Hz_Cust_Account_Site_V2pub.update_cust_site_use - Error updating Primary SalesRep ID
I get the following error when I use the same object version number that is for the site_use_id:
API Message: 1.The following SQL error occurred:
ORA-01403: no data found.
When I use object version number + 1 for the site_use_id, I get the error:
API Message: 1.The following SQL error occurred:
ORA-01403: no data found.
I am on R12.1.3. Running this as a concurrent program.
Code is given below:
============
PROCEDURE update_salesrep(P_RETCODE OUT NUMBER,
P_ERRBUFF OUT VARCHAR2
) AS
p_order_header_rec OE_Order_PUB.Header_Val_Rec_Type;
v_cust_site_use_rec Hz_Cust_Account_Site_V2pub.CUST_SITE_USE_REC_TYPE;
1