APPS.BIX_POP_AO_SUM_PKG dependencies on FND_FILE

Line 33: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

29:
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 */

Line 89: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

85: SYSDATE
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

Line 94: 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')||
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;

Line 107: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||g_error_mesg);

103: +===================================================================================================*/
104:
105: PROCEDURE clean_up IS
106: BEGIN
107: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||g_error_mesg);
108: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
109: 'Start rolling back from BIX_DM_ADVANCED_OUTBOUND_SUMtable ');
110:
111: /* Delete from AO summary table */

Line 108: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

104:
105: PROCEDURE clean_up IS
106: BEGIN
107: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||g_error_mesg);
108: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
109: 'Start rolling back from BIX_DM_ADVANCED_OUTBOUND_SUMtable ');
110:
111: /* Delete from AO summary table */
112:

Line 127: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

123: END IF;
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;

Line 135: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

131: INSERT_LOG;
132:
133: EXCEPTION
134: WHEN OTHERS THEN
135: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
136: 'CLEAN_UP: ERROR: '|| SQLERRM);
137: RAISE;
138: END CLEAN_UP;
139:

Line 238: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

234:
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................');

Line 258: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

254: COMMIT;
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;

Line 264: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

260: ' Finished Deleting rows in BIM_DM_AO_SUM table: '||
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

Line 374: fnd_file.put_line(fnd_file.log,TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||

370:
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;