OraFAQ Forum: Forms » FRM-40404

Home » Developer & Programmer » Forms » FRM-40404 (ORACLE 10g)

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

FRM-40404 [message #524704]

Mon, 26 September 2011 04:40

swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai

Member

Dear all,

I am working on form 10g, here i am using post commond in save procedure to apply some record in database temporary.

But Frm-40404 Message raise during saving record i need post commond but i dont want to this message should popup, is there any method to avoid the message only?

Regards

Swpanil

Report message to a moderator

Re: FRM-40404 [message #524711 is a reply to message #524704]

Mon, 26 September 2011 05:09

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Try to set system message level to a higher value. Something like

declare                 --> fixed; was "decode"
  l_level number;
begin
  -- save previous level value  
  l_level := :system.message_level;

  :system.message_level := 25;
  post;

  -- restore
  :system.message_level := l_level;
end;

[EDITED by LF: put DECLARE instead of DECODE in the first line]

[Updated on: Mon, 26 September 2011 05:45]

Report message to a moderator

Re: FRM-40404 [message #524718 is a reply to message #524711]

Mon, 26 September 2011 05:30

swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai

Member

Where should i write this code please explain

Report message to a moderator

Re: FRM-40404 [message #524720 is a reply to message #524718]

Mon, 26 September 2011 05:32

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Swapnilpimple

i am using post command in save procedure

Swapnilpimple

Where should i write this code

What do you think?

Report message to a moderator

Re: FRM-40404 [message #524723 is a reply to message #524720]

Mon, 26 September 2011 05:41

swapnilpimple
Messages: 33
Registered: July 2010
Location: Mumbai

Member

Dear Sir,

decode(Is it declare?)
l_level number;
begin
-- save previous level value
l_level := :system.message_level(Should Parameter Declared by me?);

:system.message_level := 25;
post;

-- restore
:system.message_level := l_level;
end;

Report message to a moderator

Re: FRM-40404 [message #524724 is a reply to message #524723]

Mon, 26 September 2011 05:44

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

(!?!) Of course it is DECLARE, not DECODE, silly me! I apologize (I don't know what I was thinking). I'll fix it in my earlier message so that it doesn't make confusion.

:SYSTEM.MESSAGE_LEVEL is a system variable, you don't have to do anything about it. Basically, you should copy/paste this piece of code into your "save" procedure.

Report message to a moderator

Re: FRM-40404 [message #525648 is a reply to message #524724]

Tue, 04 October 2011 07:30

alexmoore
Messages: 24
Registered: October 2011

Junior Member

if the user enter a records in transaction forms.at one field of transaction
form it can't find any record in lov/*that comes from master table*/
for entering record in master table, it will open master form from
menu( transaction form is also open)

Report message to a moderator

Re: FRM-40404 [message #525649 is a reply to message #525648]

Tue, 04 October 2011 07:40

cookiemonster
Messages: 13964
Registered: September 2008
Location: Rainy Manchester

Senior Member

alexmoore wrote on Tue, 04 October 2011 13:30

if the user enter a records in transaction forms.at one field of transaction
form it can't find any record in lov/*that comes from master table*/
for entering record in master table, it will open master form from
menu( transaction form is also open)

Is that a question or a statement? And what does it have to do with this topic?

Report message to a moderator

Previous Topic:	calling internet explorer with in form
Next Topic:	ORACLE FORMS and REPORTS

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 13 08:55:16 CST 2025