1: PACKAGE BODY EGO_BULKLOAD_ENTITIES AS
2: /* $Header: EGOBKUPB.pls 120.16 2011/03/08 09:01:00 gliang ship $ */
3:
4: -------------------------------------------------------------------------
5: -- Global constants
148:
149: ----------------------------------------------------------
150: -- Print the list of conc program parameters
151: ----------------------------------------------------------
152: Write_Debug('Following are the parameters to the program EGO_BULKLOAD_ENTITIES.BulkLoadEntities ');
153: Write_Debug('************************************************************');
154: Write_Debug('RESULT_FORMAT_USAGE_ID : '||to_char(result_format_usage_id));
155: Write_Debug('USER_ID : '||to_char(user_id));
156: Write_Debug('LANGUAGE : '||language);
282: updateUploadedRowsToIntfTable (p_result_format_usage_id => result_format_usage_id);
283: ERRBUF := NVL(l_errbuf, G_RET_STS_SUCCESS);
284: RETCODE := l_retcode;
285:
286: Write_Debug('EGO_BULKLOAD_ENTITIES.BulkLoadEntities RETCODE => '|| RETCODE);
287: Write_Debug('EGO_BULKLOAD_ENTITIES.BulkLoadEntities ERRBUF => '|| ERRBUF);
288:
289: EXCEPTION
290: WHEN OTHERS THEN
283: ERRBUF := NVL(l_errbuf, G_RET_STS_SUCCESS);
284: RETCODE := l_retcode;
285:
286: Write_Debug('EGO_BULKLOAD_ENTITIES.BulkLoadEntities RETCODE => '|| RETCODE);
287: Write_Debug('EGO_BULKLOAD_ENTITIES.BulkLoadEntities ERRBUF => '|| ERRBUF);
288:
289: EXCEPTION
290: WHEN OTHERS THEN
291: FND_FILE.PUT_LINE(FND_FILE.LOG,'Others '||SQLCODE || ':'||SQLERRM);
329: l_imp_request_id NUMBER;
330: l_match_request_id NUMBER;
331:
332: BEGIN
333: Write_Debug('EGO_BULKLOAD_ENTITIES.Run_Import_Program: p_schedule_date: ' || p_schedule_date);
334: Write_Debug('EGO_BULKLOAD_ENTITIES.Run_Import_Program: formatted date - p_schedule_date: ' || to_char(p_schedule_date, 'YYYY/MM/DD HH24:MI:SS'));
335:
336:
337: l_request_id := FND_REQUEST.Submit_Request
330: l_match_request_id NUMBER;
331:
332: BEGIN
333: Write_Debug('EGO_BULKLOAD_ENTITIES.Run_Import_Program: p_schedule_date: ' || p_schedule_date);
334: Write_Debug('EGO_BULKLOAD_ENTITIES.Run_Import_Program: formatted date - p_schedule_date: ' || to_char(p_schedule_date, 'YYYY/MM/DD HH24:MI:SS'));
335:
336:
337: l_request_id := FND_REQUEST.Submit_Request
338: (