AR_RECEIPT_API_PUB.create_cash not creating the receipt

Hi Guru's

I have developed package and built it into ADI Web Integrator to load my data into my staging table. This works perfectly. My second package is to call the data from the staging table and then to create the receipts.

This is the data I am uploading into my staging table:

I can see the data has uploaded successfully.

This is my code for the api.

CREATE OR REPLACE PACKAGE body APPS.XX_ARRECEIPTS_CREATE_PKG
IS

PROCEDURE XXCCREATEREC(errbuf out NOCOPY varchar2, retcode out NOCOPY varchar2)
IS
L_RETURN_STATUS VARCHAR2(240);
L_MSG_COUNT NUMBER;
L_MSG_DATA VARCHAR2(240);