OraFAQ Forum: Forms » To display error message, when an invalid value is entered on a field; Saving records ;

Home » Developer & Programmer » Forms » To display error message, when an invalid value is entered on a field; Saving records ;

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

To display error message, when an invalid value is entered on a field; Saving records ; [message #529154]

Fri, 28 October 2011 18:59

newuser01
Messages: 4
Registered: October 2011
Location: east coast

Junior Member

My when-validate-item trigger as below:

IF :data_block.FINAL_FLAG NOT IN ( 'Y', 'N') THEN
message('ERROR: Final Flag must be Y or N. ');
display_error;
raise form_trigger_failure;
END IF;

Currently, the error message displays on the status bar. User's often do not notice that.

1. I want the message to be diplayed on a popup window.

2. When a value is changed in the screen by the user, I want to display message confirmation in a popup window that the record has been saved.

Thanks to all of you in advance.

[Updated on: Fri, 28 October 2011 19:07]

Report message to a moderator