Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Another custom.pll question

588559Jul 19 2007 — edited Jul 19 2007
Hi all, I want to implement a custom code when the cursor is on a field in Transactions form. I want to begin with something simple. Just pop up a message says "You Have Entered The Description Value"

I have added this code in custom.pll event procedure. I have left everything else as is(default-blank).

form_name varchar2(30) := name_in('SYSTEM.CURRENT_FORM');
block_name varchar2(30) := name_in('SYSTEM.CURSOR_BLOCK');
cursor_item varchar2 (200) := name_in('SYSTEM.CURSOR_ITEM');
record_status varchar2 (200) := name_in('SYSTEM.RECORD_STATUS');
INSTRING varchar2(30) := 'You Have Entered The Description Value';

begin

IF event_name = 'WHEN–NEW–RECORD-INSTANCE' and --is this correct?
form_name='ARXTWMAI' and
block_name = 'TLIN_LINES' and
cursor_item = 'TLIN_LINES.DESCRIPTION'

THEN

FND_MESSAGE.ERASE;
FND_MESSAGE.SET_STRING('TEST');
FND_MESSAGE.SHOW;


END IF;

The form file name is AR_TWMAI.fmb while the header is ARXTWMAI. As you understand I am not getting anything, so I want your advice. It is the first time I use the custom.pll and I am not sure if the above is correct.

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 16 2007
Added on Jul 19 2007
4 comments
514 views