[Home] [Help]
18:
19: G_DATE_MISMATCH EXCEPTION;
20:
21: /*===================================================================================================+
22: | INSERT_LOG procedure inserts collection concurrent program status into BIX_DM_COLLECT_LOG table |
23: | It inserts a row with the following details : |
24: | |
25: | COLLECT_STATUS column equals to FAILED if the program failed otherwise SUCCESS |
26: | COLLECT_EXCEP_MESG as error message if the program failed otherwise NULL |
44: AS
45: BEGIN
46: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
47: ' BIX_DM_EMAIL_SUMMARY_PKG.INSERT_LOG:' ||
48: 'Start inserting collection status into BIX_DM_COLLECT_LOG table');
49:
50: /* Insert status into log table */
51:
52: INSERT INTO BIX_DM_COLLECT_LOG
48: 'Start inserting collection status into BIX_DM_COLLECT_LOG table');
49:
50: /* Insert status into log table */
51:
52: INSERT INTO BIX_DM_COLLECT_LOG
53: (
54: COLLECT_ID,
55: COLLECT_CONCUR_ID,
56: OBJECT_NAME,
72: PROGRAM_UPDATE_DATE
73: )
74: VALUES
75: (
76: BIX_DM_COLLECT_LOG_S.NEXTVAL,
77: NULL,
78: g_proc_name,
79: 'PL SQL PACKAGE',
80: g_program_start_date,
96: COMMIT;
97:
98: write_log(TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
99: ' BIX_DM_EMAIL_SUMMARY_PKG.INSERT_LOG:'||
100: 'Finished inserting collection status into BIX_DM_COLLECT_LOG table');
101: EXCEPTION
102: WHEN OTHERS THEN
103: write_log( TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
104: 'BIX_DM_EMAIL_SUMMARY_PKG.INSERT_LOG: ' ||
101: EXCEPTION
102: WHEN OTHERS THEN
103: write_log( TO_CHAR(SYSDATE,'DD-MON-YYYY HH24:MI:SS')||
104: 'BIX_DM_EMAIL_SUMMARY_PKG.INSERT_LOG: ' ||
105: 'Failed to insert rows into BIX_DM_COLLECT_LOG table: '||sqlerrm);
106: RAISE;
107: END INSERT_LOG;
108:
109: /*===================================================================================================+
107: END INSERT_LOG;
108:
109: /*===================================================================================================+
110: | CLEAN_UP procedure writes error message into FND log file,Rollback the data written into Email |
111: | summary tables and also calls INSERT_LOG procedure to log error messge in BIX_DM_COLLECT_LOG table |
112: +===================================================================================================*/
113:
114: PROCEDURE clean_up IS
115: l_delete_count NUMBER := 0;
1483: | 3. COLLECT_OPEN_MEASURES : Collects Open measures |
1484: | 4. COLLECT_GROUP_SUMMARY : summarizes all the agent information to group |
1485: | 5. COLLECT_AGENT_SUMMARY : summarizes all the agent inforation to all the dimension other |
1486: | than resource and update the email table itself |
1487: | 5. INSERT_LOG : Insert the status into BIX_DM_COLLECT_LOG table. |
1488: ==============================================================================================+*/
1489:
1490: PROCEDURE COLLECT_EMAILS_SUMMARY(p_start_date IN VARCHAR2, p_end_date IN VARCHAR2)
1491: AS
1603: except agent and update in email summary table */
1604:
1605: collect_agent_summary;
1606:
1607: /* Insert the status into BIX_DM_COLLECT_LOG table */
1608:
1609: g_status := 'SUCCESS';
1610: insert_log;
1611: ELSE
1634: | 3. COLLECT_OPEN_MEASURES : Collects Open measures |
1635: | 4. COLLECT_GROUP_SUMMARY : summarizes all the agent information to group |
1636: | 5. COLLECT_AGENT_SUMMARY : summarizes all the agent inforation to all the dimension other |
1637: | than resource and update the email table itself |
1638: | 5. INSERT_LOG : Insert the status into BIX_DM_COLLECT_LOG table. |
1639: ==============================================================================================+*/
1640:
1641:
1642: PROCEDURE COLLECT_EMAILS_SUMMARY(errbuf out nocopy varchar2,
1759: except agent and update in email summary table */
1760:
1761: collect_agent_summary;
1762:
1763: /* Insert the status into BIX_DM_COLLECT_LOG table */
1764:
1765: g_status := 'SUCCESS';
1766: insert_log;
1767: retcode := NULL;