Text field goes to the before field [message #606460] |
Fri, 24 January 2014 04:08 |
|
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
|
|
|
|