Form Personalization - AP Invoice Amount Get Error when PREPAYMENT Invoivce AMT is more than PO Amt.

Open the Form Personalization Window, Using the Following Steps...

 

Seq	Descriptions	Level	Enable
30	XX When We input the PREPAYMENT Invoice is More then PO % Amount then Not Save.	Form	YES
Condition Tab
Trigger Event	WHEN-VALIDATE-RECORD
Trigger Object	INV_SUM_FOLDER
Condition	:INV_SUM_FOLDER.INVOICE_TYPE ='Prepayment'
	AND (select ((SUM(NVL(pla.UNIT_PRICE,0) * NVL(pla.QUANTITY,0))*pha.ATTRIBUTE1)/100) PO_AMT_PERCENTAGE
	from po_headers_all pha,
	po_lines_all   pla
	where pha.SEGMENT1 = :INV_SUM_FOLDER.QUICK_PO_NUMBER
	and   pha.PO_HEADER_ID = pla.PO_HEADER_ID
	group by pha.ATTRIBUTE1)  < :INV_SUM_FOLDER.INVOICE_AMOUNT_DSP
Processing Mode	Both

 

Action Tab
Action Sequence	Type	Action Description	Language	Action Enabled
10	Message	Prepayment Invoice is More then PO % Amt Then MSG	All	YES
20	Builtin	Restrict to Save	All	YES
For SEQ 10
Message Type	Show
Message Text	='PREPAYMENT Invoice is More then PO % Amount. (PO % Amount is :'  || (select ((SUM(NVL(pla.UNIT_PRICE,0) * NVL(pla.QUANTITY,0))*pha.ATTRIBUTE1)/100) PO_AMT_PERCENTAGE
	from po_headers_all pha,
	po_lines_all   pla
	where pha.SEGMENT1 = :INV_SUM_FOLDER.QUICK_PO_NUMBER
	and   pha.PO_HEADER_ID = pla.PO_HEADER_ID
	group by pha.ATTRIBUTE1)
	||')'

For SEQ 20
Builtin Type	RAISE FORM_TRIGGER_FAILURE