APPS.BIX_POP_AO_SUM_PKG dependencies on BIX_POP_AO_SUM_PKG

Line 1: PACKAGE BODY BIX_POP_AO_SUM_PKG AS

1: PACKAGE BODY BIX_POP_AO_SUM_PKG AS
2: /* $Header: bixxaosb.plb 115.4 2003/01/09 20:20:20 achanda noship $ */
3:
4: g_request_id NUMBER := FND_GLOBAL.CONC_REQUEST_ID();
5: g_program_appl_id NUMBER := FND_GLOBAL.PROG_APPL_ID();

Line 34: ' BIX_POP_AO_SUM_PKG.INSERT_LOG:' ||

30: PROCEDURE INSERT_LOG
31: AS
32: BEGIN
33: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
34: ' BIX_POP_AO_SUM_PKG.INSERT_LOG:' ||
35: 'Start inserting collection status into BIX_DM_COLLECT_LOG table');
36:
37: /* Insert status into log table */
38:

Line 90: ' BIX_POP_AO_SUM_PKG.INSERT_LOG:'||

86: );
87: COMMIT;
88:
89: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
90: ' BIX_POP_AO_SUM_PKG.INSERT_LOG:'||
91: 'Finished inserting collection status into BIX_DM_COLLECT_LOG table');
92: EXCEPTION
93: WHEN OTHERS THEN
94: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

Line 95: 'BIX_POP_AO_SUM_PKG.INSERT_LOG: ' ||

91: 'Finished inserting collection status into BIX_DM_COLLECT_LOG table');
92: EXCEPTION
93: WHEN OTHERS THEN
94: fnd_file.put_line(fnd_file.log, TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
95: 'BIX_POP_AO_SUM_PKG.INSERT_LOG: ' ||
96: ' Failed to insert rows into BIX_DM_COLLECT_LOG table: '|| sqlerrm);
97: RAISE;
98: END INSERT_LOG;
99:

Line 128: ' BIX_POP_AO_SUM_PKG.CLEAN_UP: '||

124:
125: END LOOP;
126:
127: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
128: ' BIX_POP_AO_SUM_PKG.CLEAN_UP: '||
129: ' Finished rollback from BIM_DM_AO_SUM table: ' );
130:
131: INSERT_LOG;
132:

Line 239: ' BIX_POP_AO_SUM_PKG.POPULATE: '||

235: g_collect_start_date := p_start_date_time;
236: g_collect_end_date := p_end_date_time;
237:
238: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
239: ' BIX_POP_AO_SUM_PKG.POPULATE: '||
240: ' Start Deleting rows in BIM_DM_AO_SUM table: ' );
241: LOOP
242: --dbms_output.put_line('Start deleting................');
243: DELETE bix_dm_advanced_outbound_sum

Line 259: ' BIX_POP_AO_SUM_PKG.POPULATE: '||

255: END IF;
256: END LOOP;
257:
258: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
259: ' BIX_POP_AO_SUM_PKG.POPULATE: '||
260: ' Finished Deleting rows in BIM_DM_AO_SUM table: '||
261: 'Row count: ' || g_delete_count );
262: OPEN ao_sum;
263:

Line 265: ' BIX_POP_AO_SUM_PKG.POPULATE: '||

261: 'Row count: ' || g_delete_count );
262: OPEN ao_sum;
263:
264: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
265: ' BIX_POP_AO_SUM_PKG.POPULATE: '||
266: ' Start inserting rows in BIM_DM_AO_SUM table: ' );
267:
268: LOOP
269:

Line 375: ' BIX_POP_AO_SUM_PKG.POPULATE: '||

371: EXIT WHEN ao_sum%NOTFOUND;
372:
373: END LOOP;
374: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
375: ' BIX_POP_AO_SUM_PKG.POPULATE: '||
376: ' finished inserting rows in BIM_DM_AO_SUM table: ' );
377: g_status := 'SUCCESS';
378: insert_log;
379:

Line 382: g_error_mesg := 'BIX_POP_AO_SUM_PKG.POPULATE: ERROR: '|| sqlerrm;

378: insert_log;
379:
380: EXCEPTION
381: WHEN OTHERS THEN
382: g_error_mesg := 'BIX_POP_AO_SUM_PKG.POPULATE: ERROR: '|| sqlerrm;
383: g_status := 'FAILURE';
384: clean_up;
385: END populate;
386:

Line 387: END BIX_POP_AO_SUM_PKG;

383: g_status := 'FAILURE';
384: clean_up;
385: END populate;
386:
387: END BIX_POP_AO_SUM_PKG;