OraFAQ Forum: Forms » How to Display messages error message in status bar

Home » Developer & Programmer » Forms » How to Display messages error message in status bar

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

How to Display messages error message in status bar [message #287428]

Wed, 12 December 2007 04:01

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

Report message to a moderator

Re: How to Display messages error message in status bar [message #287431 is a reply to message #287428]

Wed, 12 December 2007 04:18

azamkhan
Messages: 557
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

Report message to a moderator

Re: How to Display messages error message in status bar [message #287444 is a reply to message #287431]

Wed, 12 December 2007 04:37

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

Report message to a moderator

Re: How to Display messages error message in status bar [message #287446 is a reply to message #287444]

Wed, 12 December 2007 04:42

azamkhan
Messages: 557
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.

Report message to a moderator

Re: How to Display messages error message in status bar [message #287449 is a reply to message #287446]

Wed, 12 December 2007 04:53

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

Report message to a moderator

Re: How to Display messages error message in status bar [message #287452 is a reply to message #287449]

Wed, 12 December 2007 04:58

azamkhan
Messages: 557
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

Report message to a moderator

Re: How to Display messages error message in status bar [message #287457 is a reply to message #287449]

Wed, 12 December 2007 05:09

Littlefoot
Messages: 21823
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).

Report message to a moderator

Re: How to Display messages error message in status bar [message #287461 is a reply to message #287457]

Wed, 12 December 2007 05:25

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.

Report message to a moderator

Previous Topic:	Message problem
Next Topic:	get old value when update on form

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 03:46:57 CST 2025