Home » Developer & Programmer » Forms » Text field goes to the before field
Text field goes to the before field [message #606460] Fri, 24 January 2014 04:08 Go to next message
mist598
Messages: 1195
Registered: February 2013
Location: Hyderabad
Senior Member
Hi all,

I have problem with trigger, i have script like below

DECLARE 
    vcount NUMBER; 
BEGIN 
    SELECT Count(*) 
    INTO   vcount 
    FROM   epm_jj_expedisi 
    WHERE  org_id = :GLOBAL.org_id 
    AND no_invoice_expedisi = :EPM_JJ_EXPEDISI.no_invoice_expedisi; 

    IF Nvl(vcount, 0) <> 0 THEN 
      fnd_message.Debug('NOMOR INVOICE SUDAH TERPAKAI !!'); 

      :EPM_JJ_EXPEDISI.no_invoice_expedisi := ''; 

      RAISE form_trigger_failure; 

      Go_item('EPM_JJ_EXPEDISI.NO_INVOICE_EXPEDISI'); 
    END IF; 
EXCEPTION 
    WHEN OTHERS THEN 
      NULL; 
END; 


when i run this form, why the cursor can't go back to 'invoice_expedisi', and always go to the next field 'jml'.

Thank You
Re: Text field goes to the before field [message #606467 is a reply to message #606460] Fri, 24 January 2014 05:44 Go to previous message
Littlefoot
Messages: 21808
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Because RAISE stops form execution, and none of the statements that follow it are ever executed.
Previous Topic: Run Time Error
Next Topic: update records- trigger
Goto Forum:
  


Current Time: Fri Apr 26 02:30:41 CDT 2024