Upload process error while running Automatically Submit Import which does validations after the last

Solution Provided in https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=1pl82mt02_9&_afrLoop=508476655749141 has already been applied but it did not fix the issue.

procedure VALIDATE_RECORDS (p_record_id IN NUMBER)

as

exception;

NUMBER;

NUMBER;

-- pragma autonomous_transaction;

begin

-- xxvs_debug_proc (p_record_id);

SELECT receipt_amount

INTO   l_rec_amount

FROM XXEGY_AR_CASH_RECEIPTS

WHERE record_id = p_record_id

AND rownum=1;

--     xxvs_debug_proc ('TEST2');

SELECT sum(amount_applied)

INTO l_amount_applied

FROM XXEGY_AR_CASH_RECEIPTS

WHERE  record_id = p_record_id;

--    xxvs_debug_proc ('TEST3');