FRM-40405 : No changes to apply error.

[Guest]

Hi,

I have problem with FRM-40405 : No changes to apply error.

Explanation of the problem:
-----------------------------
I have two forms form1,form2.
I am opening form2 from form1 and issuing a commit_form statement in
form2.It throws me the error first and then it says "transaction
completed x records saved.'.

I know that the error is from form1.but I cannot trap this by putting
an on-error trigger in form1 since it will change the default
behavior(i.e if user tries to save without any chnages it won't prompt
with any error if i suppress it).

So i want to know is there any other work around to get rid of this
problem.

Note: I am using Open form with no_session.

Thanks in advance.
Siddhardha.

[Frank van Bortel]

siddu_htc@yahoo.com wrote: Hi, I have problem with FRM-40405 : No changes to apply error. Explanation of the problem: ----------------------------- I have two forms form1,form2. I am opening form2 from form1 and issuing a commit_form statement in form2.It throws me the error first and then it says "transaction completed x records saved.'. I know that the error is from form1.but I cannot trap this by putting an on-error trigger in form1 since it will change the default behavior(i.e if user tries to save without any chnages it won't prompt with any error if i suppress it). So i want to know is there any other work around to get rid of this problem. Note: I am using Open form with no_session. Thanks in advance. Siddhardha.

You can change the level of feedback (MESSAGE_LEVEL?!?) by
setting it to 5 (from 0) or higher.
Higher values supress more (5 is informational, 10 warnings,
35 errors, iirc).
You will have to search the docco yourself, can't recall
the exact parameter name


--
Regards,
Frank van Bortel

Top-posting is one way to shut me up...

[DA Morgan]

Frank van Bortel wrote:
You can change the level of feedback (MESSAGE_LEVEL?!?) by setting it to 5 (from 0) or higher. Higher values supress more (5 is informational, 10 warnings, 35 errors, iirc). You will have to search the docco yourself, can't recall the exact parameter name

:system.message_level := <integer>;

--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Fred van Nimwegen]

"DA Morgan" <damorgan@psoug.org> schreef in bericht
news:1129928796.778592@yasure... Frank van Bortel wrote: You can change the level of feedback (MESSAGE_LEVEL?!?) by setting it to 5 (from 0) or higher. Higher values supress more (5 is informational, 10 warnings, 35 errors, iirc). You will have to search the docco yourself, can't recall the exact parameter name :system.message_level := <integer>; -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)

Setting system.message_level wil work but also skips all errors of the same
message level.
The headstart templates will give the possibility to ignore specific
messages.

[Guest]

Even i set it to ' 25 '.
I am still getting the no changes to apply from first form.

My code is like this.

The below code is in form2.

copy('25', 'SYSTEM.MESSAGE_LEVEL');
COMMIT_FORM;
copy('0','SYSTEM.MESSAGE_LEVEL');

Pls reply wwith alternatives...

Siddhardha

[DA Morgan]

siddu_htc@yahoo.com wrote: Even i set it to ' 25 '. I am still getting the no changes to apply from first form. My code is like this. The below code is in form2. copy('25', 'SYSTEM.MESSAGE_LEVEL'); COMMIT_FORM; copy('0','SYSTEM.MESSAGE_LEVEL'); Pls reply wwith alternatives... Siddhardha

Where did you get this "copy" syntax?

I gave you the correct syntax in what I posted.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)

[Guest]

in oracle apps we use that syntax..it is similar to what u have given.

Some interesting points i observed.

When i open form2 and make some changes i found the message is coming
up but suppressed by setting message level.but if i make any changes
second time it pops up with an alert box.

Please tell me how to suppress it forever

Siddhardha.

[DA Morgan]

siddu_htc@yahoo.com wrote: in oracle apps we use that syntax..it is similar to what u have given. Some interesting points i observed. When i open form2 and make some changes i found the message is coming up but suppressed by setting message level.but if i make any changes second time it pops up with an alert box. Please tell me how to suppress it forever Siddhardha.

create a user defined exception
Use Pragma ExceptionInit
Catch it with an exception handler

or

Redesign your application
--
Daniel A. Morgan
http://www.psoug.org
damorgan@x.washington.edu
(replace x with u to respond)