Home » Developer & Programmer » Forms » RAISE FORM_TRIGGER_FAILURE not working using form persoanlization (Oracle Apps R12 (12.1.3))
RAISE FORM_TRIGGER_FAILURE not working using form persoanlization [message #659119] Fri, 06 January 2017 05:27
suman.g
Messages: 89
Registered: June 2009
Member
Hi Experts,

I have done below form personalization on 'Purchase Order Summary' form to restrict PO/Line/Shipment cancellation when there is receipt against the PO/Line/Shipment respectively.

Personalization is partially working, its displaying message (Action highlighted in Green) but RAISE FORM_TRIGGER_FAILURE (Action highlighted in Red)is not working.

Quick help is appreciated.

Form Personalization details (Header Level)

Seq: 1
Description: Cancel PO Header - Validation
Level: Function
Enabled: Yes

Condition
---------
Event Trigger: WHEN-VALIDATE-RECORD
Trigger Object: PO_DOCON_CONTROL
Condition: :PO_DOCON_CONTROL.ACTION='CANCEL PO' AND (select sum(quantity_received) from po_line_locations_all where po_header_id = :HEADERS_FOLDER.PO_HEADER_ID) > 0
Processing Mode: Both

Actions
-------
Seq: 1
Type: Message
Language: All
Enabled: Yes

Message Type: Error
Message Text: Receipts/Delivery exists against this PO. Please Un Receive/Deliver before cancelling the PO.


Seq: 2
Type: Builtin
Language: All
Enabled: Yes

Builtin Type: RAISE FORM_TRIGGER_FAILURE


Thanks!
Suman

[Updated on: Fri, 06 January 2017 05:28]

Report message to a moderator

Previous Topic: How to get form name in .pll
Next Topic: How to copy data .tps to oracle database
Goto Forum:
  


Current Time: Tue Jun 02 13:49:37 CDT 2020