|RAISE FORM_TRIGGER_FAILURE not working using form persoanlization [message #659119]
||Fri, 06 January 2017 05:27
Registered: June 2009
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)
Description: Cancel PO Header - Validation
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
Message Type: Error
Message Text: Receipts/Delivery exists against this PO. Please Un Receive/Deliver before cancelling the PO.
Builtin Type: RAISE FORM_TRIGGER_FAILURE
[Updated on: Fri, 06 January 2017 05:28]
Report message to a moderator