DOC_SEQUENCE_VALUE is null when create the receipt using API (APPS.AR_RECEIPT_API_PUB.CREATE_CASH)
DOC_SEQUENCE_VALUE is null when create the receipt using API (APPS.AR_RECEIPT_API_PUB.CREATE_CASH). I am using the below code:
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
DECLARE
L_ERROR_DESCRIPTION VARCHAR2 (2000) := NULL;
L_MSG_INDEX_NUM NUMBER:= 1;
L_MSG_COUNT NUMBER;
L_DATA_TXT VARCHAR2(1000);
L_MSG_DATA VARCHAR2(1000);
L_RECEIPT_ID NUMBER;
L_RETURN_STATUS VARCHAR2(10);
L_ATTRIBUTE_REC APPS.AR_RECEIPT_API_PUB.ATTRIBUTE_REC_TYPE ;-- DEFAULT ar_receipt_api_pub.attribute_rec_const ;--ar_receipt_api_pub.attribute_rec_type;
L_RETURN_STATUS_2 VARCHAR2 (1);
L_MSG_COUNT_2 NUMBER;
L_MSG_DATA_2 VARCHAR2 (240);
L_MSG_INDEX_NUM2 NUMBER;