4 Replies Latest reply: Jan 17, 2014 3:37 AM by juliojgs RSS

    Firing Raise Form_trigger_failure

    1008486

      I have this code in when-validate-item of a textfield

       

      if paramter.prm_action_code='N' then

       

           pr_gen_refno;

      end if

       

      This procedure pr_gen_refno was calling a backend package function and if it returns false a form trigger failure was raised by the procedure

      And I was not able to save the form if the backend package function returned false.

       

      . But now I changed the validate-item code as

       

      declare

       

      begin

           ---A select query

           if paramter.prm_action_code='N' then

       

                pr_gen_refno;

           end if;

      exception

           WHEN OTHERS THEN

                ovpcs.pr_debug('when validate item failed');

      end;

       

      Now even if the back end package funciton returns false,I am able to save the form?

      Can somebody please explain me why its working in this way?

       

       

      But now although back end package function called by pr_gen_refno fails,I can save the form,