OraFAQ Forum: Forms » Trapping Forms internal error in key

Home » Developer & Programmer » Forms » Trapping Forms internal error in key_commit trigger

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

Trapping Forms internal error in key_commit trigger [message #139649]

Thu, 29 September 2005 01:33

jaggu123
Messages: 4
Registered: September 2005

Junior Member

Hello friends,

How can i trap error(Forms internal errors comes due to property settings) in key_commmit trigger and conditionally execute the written executable code .

Code in key_commit

Begin
Proc_test ;
end;

If any error come after pressing F10(Committing the form) then program unit Proc_test should not be executed .

For example :

If error comes on committing
Frm-40207 : Must be in range 1 to 50
OR
FRM-50016 :Legal Characters are 0-9 - + E
then proc_test should not be executed.

Thanks
Jaggu

Report message to a moderator

Re: Trapping Forms internal error in key_commit trigger [message #139652 is a reply to message #139649]

Thu, 29 September 2005 01:41

karthikraj
Messages: 27
Registered: August 2005

Junior Member

Try checking Form_Success.
But this will not help in all situations, for sure.

begin
if form_success then
proc;
end if;
end;

Report message to a moderator

Re: Trapping Forms internal error in key_commit trigger [message #139682 is a reply to message #139652]

Thu, 29 September 2005 02:43

jaggu123
Messages: 4
Registered: September 2005

Junior Member

i tried using form_success but it is not working....

Report message to a moderator

Re: Trapping Forms internal error in key_commit trigger [message #139702 is a reply to message #139682]

Thu, 29 September 2005 04:29

karthikraj
Messages: 27
Registered: August 2005

Junior Member

Then, Try using like this

Enter;
If form_success then
proc;
end if;

Reply back

Report message to a moderator

Re: Trapping Forms internal error in key_commit trigger [message #139757 is a reply to message #139702]

Thu, 29 September 2005 08:27

vimald
Messages: 4
Registered: September 2005

Junior Member

Once commit is issed, you can check for system.forms_status.
If it is QUERY (commit is successful) then you can call your procedure. hope this helps.

Vimal

Report message to a moderator

Previous Topic:	gray out fields in default menu
Next Topic:	forms9i standalone - install question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 01:34:10 CDT 2024