13:
14: -- update batch summary table and detail table
15: -- set statu as complete with error
16:
17: update hz_imp_batch_summary
18: set IMPORT_STATUS = 'COMPL_ERROR_LIMIT'
19: where BATCH_ID = P_BATCH_ID;
20:
21: UPDATE hz_imp_batch_details
44:
45: -- update batch summary table and detail table
46: -- set statu as action required
47:
48: update hz_imp_batch_summary
49: set IMPORT_STATUS = 'ACTION_REQUIRED'
50: where BATCH_ID = P_BATCH_ID;
51:
52: UPDATE hz_imp_batch_details
637:
638: errbuf := FND_MESSAGE.get;
639: retcode := 2;
640:
641: UPDATE hz_imp_batch_summary
642: SET import_status = 'ERROR'
643: WHERE batch_id = P_BATCH_ID;
644:
645: UPDATE hz_imp_batch_details