Home » Applications » Oracle Fusion Apps & E-Business Suite » Custom.pll -- Raise Form_Trigger_Failure (Oracle Apps 11.5.10.2 Linux x86)
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
Previous Topic: Want to change the query of "Ordered item" on sales order form, But KFF is attached to tha
Next Topic: Order Management - Advance Pricing API
Goto Forum:
  


Current Time: Wed Dec 07 20:35:02 CST 2016

Total time taken to generate the page: 0.15366 seconds