Home » Developer & Programmer » Forms » How to Display messages error message in status bar
How to Display messages error message in status bar [message #287428] Wed, 12 December 2007 04:01 Go to next message
amjathkhan.subhankhan
Messages: 9
Registered: December 2007
Location: chennai
Junior Member

In my custom form when user enters enter the character data in the text item field which is of Number data type, i want the message to be displayed in the status bar (as like in standards forms).

i use standard form TEMPLATE.fmb and modified.

I searched in the forum & found one solution. in ON-ERROR trigger i written APP_STANDARD.EVENT('ON-ERROR'); at form level.

still i could not able to show the error message in status bar. Please help to fix the issue

Thanks,
amjadkhans
Re: How to Display messages error message in status bar [message #287431 is a reply to message #287428] Wed, 12 December 2007 04:18 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear just place "MESSAGE('you message')" command in ON-Error and ON-Message once and this is show your message in status bar.

But remember is "MESSAGE('')" command used twice, I mean like this

MESSAGE ('Hello World...1');
MESSAGE ('Hello World...2');

Then one message will be showed in status bar and the second message will be showed as alert.

Regards,
Azam Khan
Re: How to Display messages error message in status bar [message #287444 is a reply to message #287431] Wed, 12 December 2007 04:37 Go to previous messageGo to next message
amjathkhan.subhankhan
Messages: 9
Registered: December 2007
Location: chennai
Junior Member
i tried with the statement in both ON-ERROR and ON-MESSAGE trigger
MESSGE('Test messgae');
MESSGE('Test messgae');

but its not showing the message in both the status bar and alert

Re: How to Display messages error message in status bar [message #287446 is a reply to message #287444] Wed, 12 December 2007 04:42 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
You cann't trap an error or a message by simply typing MESSAGE('') command.

Please check the ON-Error and ON-Message help in developer.
Re: How to Display messages error message in status bar [message #287449 is a reply to message #287446] Wed, 12 December 2007 04:53 Go to previous messageGo to next message
amjathkhan.subhankhan
Messages: 9
Registered: December 2007
Location: chennai
Junior Member
i tried like this in ON-ERROR and ON-MESSAGE triggers
DECLARE
errnum NUMBER := ERROR_CODE;
errtxt VARCHAR2(80) := ERROR_TEXT;
errtyp VARCHAR2(3) := ERROR_TYPE;
errortext varchar2(80);

BEGIN
Message(errtyp||'-'||TO_CHAR(errnum)||': '||errtxt);
Message(errtyp||'-'||TO_CHAR(errnum)||': '||errtxt);
RAISE Form_Trigger_Failure;
end;

still it does not show the message in status bar. i also tried with fnd_message.hint
Re: How to Display messages error message in status bar [message #287452 is a reply to message #287449] Wed, 12 December 2007 04:58 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Dear most of the errors or messages generated by Oracle forms are trapped like this. I have also done this.

Azam Khan
Re: How to Display messages error message in status bar [message #287457 is a reply to message #287449] Wed, 12 December 2007 05:09 Go to previous messageGo to next message
Littlefoot
Messages: 20896
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

i tried like this in ON-ERROR and ON-MESSAGE triggers

OK, but was there a reason for Forms to raise and error and, consequentially, fire ON-ERROR or ON-MESSAGE trigger. If "nothing happened", there's no chance for you to see any message.

The easiest way to test it is to put the MESSAGE statement into the WHEN-NEW-FORM-INSTANCE trigger. It will always fire (i.e. you won't have to wait for (or cause) an error).
Re: How to Display messages error message in status bar [message #287461 is a reply to message #287457] Wed, 12 December 2007 05:25 Go to previous message
amjathkhan.subhankhan
Messages: 9
Registered: December 2007
Location: chennai
Junior Member
Yes it was called in WHEN-NEW-FORM-INSTANCE trigger. Thanks for your help to fix this issue.
Previous Topic: Message problem
Next Topic: get old value when update on form
Goto Forum:
  


Current Time: Tue Dec 06 02:55:44 CST 2016

Total time taken to generate the page: 0.08329 seconds