Hello everyone,
I have created a persistant custom field called APPROBATION_USER_ID_STEP_1 in the PaymentPlan entity, and i want to modify its value in my custom event, so i have used the CF_Modify__ method that belongs to the custom field package PAYMENT_PLAN_CFP, but the custom field is not updated.
Could you please provide me some help ? This is my code :
DECLARE ATTR_ VARCHAR2(4000);
STMT_ VARCHAR2(4000);
SQL_MSG_ VARCHAR2(4000);
BEGIN
STMT_ := q'[
DECLARE
objid_ VARCHAR2(4000);
objv_ VARCHAR2(4000);
info_ VARCHAR2(4000);
onHoldReason_ VARCHAR2(4000);
onHoldReasonId_ VARCHAR2(4000);
managerProject_ VARCHAR2(4000);
PROJ_ID VARCHAR(1000);
PROJ_MNG VARCHAR(1000);
INV_COMP VARCHAR2(1000);
invoiceid_ NUMBER(20);
site_ VARCHAR2(20);
installementid_ NUMBER;
ATTR_ VARCHAR2(4000);
attr_cf_ VARCHAR2(4000);
ERROR_MSG VARCHAR2(4000);
BEGIN
SELECT INVOICE_ID, COMPANY,INSTALLMENT_ID, OBJID as objid
INTO invoiceid_,site_,installementid_, objid_
FROM PAYMENT_PLAN_AUTH_QRY_CFV
WHERE INVOICE_ID = &NEW:INVOICE_ID AND COMPANY = '&NEW:COMPANY' AND INSTALLMENT_ID = &NEW:INSTALLMENT_ID;
CLIENT_SYS.CLEAR_ATTR(ATTR_);
CLIENT_SYS.ADD_TO_ATTR('ON_HOLD_REASON', onHoldReason_ , ATTR_);
CLIENT_SYS.ADD_TO_ATTR('ON_HOLD', 'True' , ATTR_);
PAYMENT_PLAN_API.Modify__(info_, objid_, objv_, ATTR_, 'DO');
-- UPDATE THE CUSTOM FIELD :
CLIENT_SYS.CLEAR_ATTR(ATTR_);
CLIENT_SYS.CLEAR_ATTR(attr_cf_);
CLIENT_SYS.ADD_TO_ATTR('CF$_APPROBATION_USER_ID_STEP_1', onHoldReason_ , attr_cf_);
PAYMENT_PLAN_CFP.CF_Modify__(info_, objid_, attr_cf_, ATTR_, 'DO');
END;]';
SQL_MSG_ := MESSAGE_SYS.CONSTRUCT('UPDATECOLINE');
MESSAGE_SYS.ADD_ATTRIBUTE(SQL_MSG_, 'SQL', STMT_);
CLIENT_SYS.CLEAR_ATTR(ATTR_);
CLIENT_SYS.ADD_TO_ATTR('SQL_DATA_', SQL_MSG_, ATTR_);
CLIENT_SYS.ADD_TO_ATTR('MSG_', '', ATTR_);
TRANSACTION_SYS.DEFERRED_CALL('Fnd_Event_Action_API.Action_Executeonlinesql','PARAMETER',
ATTR_,LANGUAGE_SYS.TRANSLATE_CONSTANT(
'Event',
'Authorize Invoice for payment',
NULL,
NULL
)
);
END;