APPS.BIX_POP_AO_SUM_PKG dependencies on BIX_DM_COLLECT_LOG

Line 19: | INSERT_LOG procedure inserts collection concurrent program status into BIX_DM_COLLECT_LOG table |

15: g_delete_count NUMBER := 0;
16: g_insert_count NUMBER := 0;
17:
18: /*===================================================================================================+
19: | INSERT_LOG procedure inserts collection concurrent program status into BIX_DM_COLLECT_LOG table |
20: | It inserts a row with the following details : |
21: | |
22: | COLLECT_STATUS column equals to FAILURE if the program failed otherwise SUCCESS |
23: | COLLECT_EXCEP_MESG as error message if the program failed otherwise NULL |

Line 35: 'Start inserting collection status into BIX_DM_COLLECT_LOG table');

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:
39: INSERT INTO BIX_DM_COLLECT_LOG

Line 39: INSERT INTO BIX_DM_COLLECT_LOG

35: 'Start inserting collection status into BIX_DM_COLLECT_LOG table');
36:
37: /* Insert status into log table */
38:
39: INSERT INTO BIX_DM_COLLECT_LOG
40: (
41: COLLECT_ID,
42: COLLECT_CONCUR_ID,
43: OBJECT_NAME,

Line 65: BIX_DM_COLLECT_LOG_S.NEXTVAL,

61: PROGRAM_UPDATE_DATE
62: )
63: VALUES
64: (
65: BIX_DM_COLLECT_LOG_S.NEXTVAL,
66: NULL,
67: 'BIX_DM_ADVANCED_OUTBOUND_SUM',
68: 'TABLE',
69: g_program_start_date,

Line 91: 'Finished inserting collection status into BIX_DM_COLLECT_LOG table');

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')||
95: 'BIX_POP_AO_SUM_PKG.INSERT_LOG: ' ||

Line 96: ' Failed to insert rows into BIX_DM_COLLECT_LOG table: '|| sqlerrm);

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:
100: /*===================================================================================================+

Line 102: | summary tables and also calls INSERT_LOG procedure to log error messge in BIX_DM_COLLECT_LOG table |

98: END INSERT_LOG;
99:
100: /*===================================================================================================+
101: | CLEAN_UP procedure writes error message into FND log file,Rollback the data written into AO |
102: | summary tables and also calls INSERT_LOG procedure to log error messge in BIX_DM_COLLECT_LOG table |
103: +===================================================================================================*/
104:
105: PROCEDURE clean_up IS
106: BEGIN