EBS Customizations (MOSC)

MOSC Banner

FRM-40735: WHEN-NEW-RECORD-INSTANCE trigger raised unhandled exception ORA-06502.

edited Mar 28, 2017 5:00AM in EBS Customizations (MOSC) 5 commentsAnswered

Dear Community,

I have an CUSTOM.pll in my instance.  And I added just a very basic validation condition in the event procedure of CUSTOM.pll  -

  v_ven_name   PO_HEADERS.ATTRIBUTE5%TYPE;

  begin

    IF event_name='WHEN-NEW-RECORD-INSTANCE' THEN

     IF form_name='POXPOEPO' AND block_name='PO_HEADERS' THEN

      v_ven_name := NAME_IN(':PO_HEADERS.ATTRIBUTE5');

      IF name_in(':PO_HEADERS.ATTRIBUTE15') = 'PARTNER' THEN

       FND_MESSAGE.DEBUG('This Purchase Order is pending with '||v_ven_name);

      END IF;

     END IF;

    END IF; 

  end event;

And compiled the .pll after placing in $AU_TOP/resource.  And when I open the forms, I run into the below issue at the beginning of the form based applications -

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center