OraFAQ Forum: Forms » RAISE FORM_TRIGGER_FAILURE not working using form persoanlization

Home » Developer & Programmer » Forms » RAISE FORM_TRIGGER_FAILURE not working using form persoanlization (Oracle Apps R12 (12.1.3))

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 05:46:53 CST 2025