Re: FRM-40405 : No changes to apply error.

siddu_htc_at_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_at_x.washington.edu
(replace x with u to respond)