| Custom.pll -- Raise Form_Trigger_Failure [message #405998] |
Mon, 01 June 2009 08:24 |
Flash
Messages: 34
Registered: February 2008
|
Member |
|
|
Hi,
I am facing a small issue when using RAISE FORM_TRIGGER_FAILURE in custom.pll.
I am giving a custom message with "ok" "Cancel" buttons. When the user clicks on cancel, the control should remain without moving further. This is not happening. Even when we click on cancel button, even after giving RAISE FORM_TRIGGER_FAILURE, the next set of statements get executed.
I need the control to stay back at the field itself without moving forward.
The code snippet is as follows
==============================
IF v_status<>'PRODUCTION' THEN
Fnd_Message.set_string('The item status is not Production
Do you want to continue with the transaction or Stop ?
'||chr(10)||'Item Type :'||v_item||chr(10)
||'Item Status :'||v_status||chr(10)
||'Item Product Line: '||v_item_line||chr(10)
||'Planner Name :'||v_name);
IF (NOT FND_MESSAGE.WARN) THEN
Fnd_message.Debug('Pressed cancel');
Fnd_message.error;
Raise FORM_TRIGGER_FAILURE;
END IF;
END IF;
==============================
Any help on this is highly appreciated.
Thanks
Flash
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
