eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_EDW_COLLECT_MBI_FACTS_F_C dependencies on EDW_LOG

Line 19: edw_log.put_line(' ');

15: BEGIN
16: Errbuf :=NULL;
17: Retcode:=0;
18:
19: edw_log.put_line(' ');
20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------

Line 20: edw_log.put_line('call EDW_COLLECTION_UTIL ');

16: Errbuf :=NULL;
17: Retcode:=0;
18:
19: edw_log.put_line(' ');
20: edw_log.put_line('call EDW_COLLECTION_UTIL ');
21: -- -------------------------------------------
22: -- call edw_collection_util.setup
23: -- -------------------------------------------
24: IF (Not EDW_COLLECTION_UTIL.setup(l_fact_name,

Line 52: edw_log.put_line(' ');

48: l_to_date := nvl(l_to_date,
49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.
51: IF l_fact_name = 'OPI_EDW_INV_DAILY_STAT_F' THEN
52: edw_log.put_line(' ');
53: -- edw_log.put_line(' Start of Collect Process Inventory Daily Status ');
54: /* OPI_EDW_OPMINV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
55: IF retcode = '2' THEN
56: APP_EXCEPTION.Raise_exception;

Line 53: -- edw_log.put_line(' Start of Collect Process Inventory Daily Status ');

49: EDW_COLLECTION_UTIL.G_local_curr_push_start_date);
50: -- End of code change for bug fix 2140267.
51: IF l_fact_name = 'OPI_EDW_INV_DAILY_STAT_F' THEN
52: edw_log.put_line(' ');
53: -- edw_log.put_line(' Start of Collect Process Inventory Daily Status ');
54: /* OPI_EDW_OPMINV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
55: IF retcode = '2' THEN
56: APP_EXCEPTION.Raise_exception;
57: END IF;

Line 58: edw_log.put_line(' ');

54: /* OPI_EDW_OPMINV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
55: IF retcode = '2' THEN
56: APP_EXCEPTION.Raise_exception;
57: END IF;
58: edw_log.put_line(' ');
59: -- edw_log.put_line(' End of Collect Process Inventory Daily Status ');
60: edw_log.put_line(' ');
61: edw_log.put_line(' Start of Collect Discrete Inventory Daily Status ');
62: OPI_EDW_INV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));

Line 59: -- edw_log.put_line(' End of Collect Process Inventory Daily Status ');

55: IF retcode = '2' THEN
56: APP_EXCEPTION.Raise_exception;
57: END IF;
58: edw_log.put_line(' ');
59: -- edw_log.put_line(' End of Collect Process Inventory Daily Status ');
60: edw_log.put_line(' ');
61: edw_log.put_line(' Start of Collect Discrete Inventory Daily Status ');
62: OPI_EDW_INV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
63: edw_log.put_line(' ');

Line 60: edw_log.put_line(' ');

56: APP_EXCEPTION.Raise_exception;
57: END IF;
58: edw_log.put_line(' ');
59: -- edw_log.put_line(' End of Collect Process Inventory Daily Status ');
60: edw_log.put_line(' ');
61: edw_log.put_line(' Start of Collect Discrete Inventory Daily Status ');
62: OPI_EDW_INV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
63: edw_log.put_line(' ');
64: edw_log.put_line(' End of Collect Discrete Inventory Daily Status ');

Line 61: edw_log.put_line(' Start of Collect Discrete Inventory Daily Status ');

57: END IF;
58: edw_log.put_line(' ');
59: -- edw_log.put_line(' End of Collect Process Inventory Daily Status ');
60: edw_log.put_line(' ');
61: edw_log.put_line(' Start of Collect Discrete Inventory Daily Status ');
62: OPI_EDW_INV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
63: edw_log.put_line(' ');
64: edw_log.put_line(' End of Collect Discrete Inventory Daily Status ');
65: ELSIF l_fact_name = 'OPI_EDW_COGS_F' THEN

Line 63: edw_log.put_line(' ');

59: -- edw_log.put_line(' End of Collect Process Inventory Daily Status ');
60: edw_log.put_line(' ');
61: edw_log.put_line(' Start of Collect Discrete Inventory Daily Status ');
62: OPI_EDW_INV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
63: edw_log.put_line(' ');
64: edw_log.put_line(' End of Collect Discrete Inventory Daily Status ');
65: ELSIF l_fact_name = 'OPI_EDW_COGS_F' THEN
66: edw_log.put_line(' ');
67: -- edw_log.put_line(' Start of Collect Process COGS Fact ');

Line 64: edw_log.put_line(' End of Collect Discrete Inventory Daily Status ');

60: edw_log.put_line(' ');
61: edw_log.put_line(' Start of Collect Discrete Inventory Daily Status ');
62: OPI_EDW_INV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
63: edw_log.put_line(' ');
64: edw_log.put_line(' End of Collect Discrete Inventory Daily Status ');
65: ELSIF l_fact_name = 'OPI_EDW_COGS_F' THEN
66: edw_log.put_line(' ');
67: -- edw_log.put_line(' Start of Collect Process COGS Fact ');
68: /* OPI_EDW_OPMCOGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */

Line 66: edw_log.put_line(' ');

62: OPI_EDW_INV_DAILY_STAT_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
63: edw_log.put_line(' ');
64: edw_log.put_line(' End of Collect Discrete Inventory Daily Status ');
65: ELSIF l_fact_name = 'OPI_EDW_COGS_F' THEN
66: edw_log.put_line(' ');
67: -- edw_log.put_line(' Start of Collect Process COGS Fact ');
68: /* OPI_EDW_OPMCOGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
69: IF retcode = '2' THEN
70: APP_EXCEPTION.Raise_exception;

Line 67: -- edw_log.put_line(' Start of Collect Process COGS Fact ');

63: edw_log.put_line(' ');
64: edw_log.put_line(' End of Collect Discrete Inventory Daily Status ');
65: ELSIF l_fact_name = 'OPI_EDW_COGS_F' THEN
66: edw_log.put_line(' ');
67: -- edw_log.put_line(' Start of Collect Process COGS Fact ');
68: /* OPI_EDW_OPMCOGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
69: IF retcode = '2' THEN
70: APP_EXCEPTION.Raise_exception;
71: END IF;

Line 72: edw_log.put_line(' ');

68: /* OPI_EDW_OPMCOGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
69: IF retcode = '2' THEN
70: APP_EXCEPTION.Raise_exception;
71: END IF;
72: edw_log.put_line(' ');
73: -- edw_log.put_line(' End of Collect COGS Fact');
74: edw_log.put_line(' ');
75: edw_log.put_line(' Start of Collect Discrete COGS Fact ');
76: OPI_EDW_COGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));

Line 73: -- edw_log.put_line(' End of Collect COGS Fact');

69: IF retcode = '2' THEN
70: APP_EXCEPTION.Raise_exception;
71: END IF;
72: edw_log.put_line(' ');
73: -- edw_log.put_line(' End of Collect COGS Fact');
74: edw_log.put_line(' ');
75: edw_log.put_line(' Start of Collect Discrete COGS Fact ');
76: OPI_EDW_COGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
77: edw_log.put_line(' ');

Line 74: edw_log.put_line(' ');

70: APP_EXCEPTION.Raise_exception;
71: END IF;
72: edw_log.put_line(' ');
73: -- edw_log.put_line(' End of Collect COGS Fact');
74: edw_log.put_line(' ');
75: edw_log.put_line(' Start of Collect Discrete COGS Fact ');
76: OPI_EDW_COGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
77: edw_log.put_line(' ');
78: edw_log.put_line(' End of Collect Discrete COGS Fact ');

Line 75: edw_log.put_line(' Start of Collect Discrete COGS Fact ');

71: END IF;
72: edw_log.put_line(' ');
73: -- edw_log.put_line(' End of Collect COGS Fact');
74: edw_log.put_line(' ');
75: edw_log.put_line(' Start of Collect Discrete COGS Fact ');
76: OPI_EDW_COGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
77: edw_log.put_line(' ');
78: edw_log.put_line(' End of Collect Discrete COGS Fact ');
79: ELSIF l_fact_name = 'OPI_EDW_JOB_RSRC_F' THEN

Line 77: edw_log.put_line(' ');

73: -- edw_log.put_line(' End of Collect COGS Fact');
74: edw_log.put_line(' ');
75: edw_log.put_line(' Start of Collect Discrete COGS Fact ');
76: OPI_EDW_COGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
77: edw_log.put_line(' ');
78: edw_log.put_line(' End of Collect Discrete COGS Fact ');
79: ELSIF l_fact_name = 'OPI_EDW_JOB_RSRC_F' THEN
80: edw_log.put_line(' ');
81: -- edw_log.put_line(' Start of Collect Process Job Resource Fact ');

Line 78: edw_log.put_line(' End of Collect Discrete COGS Fact ');

74: edw_log.put_line(' ');
75: edw_log.put_line(' Start of Collect Discrete COGS Fact ');
76: OPI_EDW_COGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
77: edw_log.put_line(' ');
78: edw_log.put_line(' End of Collect Discrete COGS Fact ');
79: ELSIF l_fact_name = 'OPI_EDW_JOB_RSRC_F' THEN
80: edw_log.put_line(' ');
81: -- edw_log.put_line(' Start of Collect Process Job Resource Fact ');
82: /* OPI_EDW_OPM_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */

Line 80: edw_log.put_line(' ');

76: OPI_EDW_COGS_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
77: edw_log.put_line(' ');
78: edw_log.put_line(' End of Collect Discrete COGS Fact ');
79: ELSIF l_fact_name = 'OPI_EDW_JOB_RSRC_F' THEN
80: edw_log.put_line(' ');
81: -- edw_log.put_line(' Start of Collect Process Job Resource Fact ');
82: /* OPI_EDW_OPM_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
83: IF retcode = '2' THEN
84: APP_EXCEPTION.Raise_exception;

Line 81: -- edw_log.put_line(' Start of Collect Process Job Resource Fact ');

77: edw_log.put_line(' ');
78: edw_log.put_line(' End of Collect Discrete COGS Fact ');
79: ELSIF l_fact_name = 'OPI_EDW_JOB_RSRC_F' THEN
80: edw_log.put_line(' ');
81: -- edw_log.put_line(' Start of Collect Process Job Resource Fact ');
82: /* OPI_EDW_OPM_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
83: IF retcode = '2' THEN
84: APP_EXCEPTION.Raise_exception;
85: END IF;

Line 86: edw_log.put_line(' ');

82: /* OPI_EDW_OPM_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
83: IF retcode = '2' THEN
84: APP_EXCEPTION.Raise_exception;
85: END IF;
86: edw_log.put_line(' ');
87: -- edw_log.put_line(' End of Collect Job Resource Fact');
88: edw_log.put_line(' ');
89: edw_log.put_line(' Start of Collect Discrete Job Resource Fact ');
90: OPI_EDW_OPI_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));

Line 87: -- edw_log.put_line(' End of Collect Job Resource Fact');

83: IF retcode = '2' THEN
84: APP_EXCEPTION.Raise_exception;
85: END IF;
86: edw_log.put_line(' ');
87: -- edw_log.put_line(' End of Collect Job Resource Fact');
88: edw_log.put_line(' ');
89: edw_log.put_line(' Start of Collect Discrete Job Resource Fact ');
90: OPI_EDW_OPI_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
91: edw_log.put_line(' ');

Line 88: edw_log.put_line(' ');

84: APP_EXCEPTION.Raise_exception;
85: END IF;
86: edw_log.put_line(' ');
87: -- edw_log.put_line(' End of Collect Job Resource Fact');
88: edw_log.put_line(' ');
89: edw_log.put_line(' Start of Collect Discrete Job Resource Fact ');
90: OPI_EDW_OPI_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
91: edw_log.put_line(' ');
92: edw_log.put_line(' End of Collect Discrete Job Resource Fact ');

Line 89: edw_log.put_line(' Start of Collect Discrete Job Resource Fact ');

85: END IF;
86: edw_log.put_line(' ');
87: -- edw_log.put_line(' End of Collect Job Resource Fact');
88: edw_log.put_line(' ');
89: edw_log.put_line(' Start of Collect Discrete Job Resource Fact ');
90: OPI_EDW_OPI_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
91: edw_log.put_line(' ');
92: edw_log.put_line(' End of Collect Discrete Job Resource Fact ');
93: ELSIF l_fact_name = 'OPI_EDW_JOB_DETAIL_F' THEN

Line 91: edw_log.put_line(' ');

87: -- edw_log.put_line(' End of Collect Job Resource Fact');
88: edw_log.put_line(' ');
89: edw_log.put_line(' Start of Collect Discrete Job Resource Fact ');
90: OPI_EDW_OPI_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
91: edw_log.put_line(' ');
92: edw_log.put_line(' End of Collect Discrete Job Resource Fact ');
93: ELSIF l_fact_name = 'OPI_EDW_JOB_DETAIL_F' THEN
94: edw_log.put_line(' ');
95: -- edw_log.put_line(' Start of Collect Process Job Detail Fact ');

Line 92: edw_log.put_line(' End of Collect Discrete Job Resource Fact ');

88: edw_log.put_line(' ');
89: edw_log.put_line(' Start of Collect Discrete Job Resource Fact ');
90: OPI_EDW_OPI_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
91: edw_log.put_line(' ');
92: edw_log.put_line(' End of Collect Discrete Job Resource Fact ');
93: ELSIF l_fact_name = 'OPI_EDW_JOB_DETAIL_F' THEN
94: edw_log.put_line(' ');
95: -- edw_log.put_line(' Start of Collect Process Job Detail Fact ');
96: /* OPI_EDW_OPM_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */

Line 94: edw_log.put_line(' ');

90: OPI_EDW_OPI_JOB_RSRC_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
91: edw_log.put_line(' ');
92: edw_log.put_line(' End of Collect Discrete Job Resource Fact ');
93: ELSIF l_fact_name = 'OPI_EDW_JOB_DETAIL_F' THEN
94: edw_log.put_line(' ');
95: -- edw_log.put_line(' Start of Collect Process Job Detail Fact ');
96: /* OPI_EDW_OPM_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
97: IF retcode = '2' THEN
98: APP_EXCEPTION.Raise_exception;

Line 95: -- edw_log.put_line(' Start of Collect Process Job Detail Fact ');

91: edw_log.put_line(' ');
92: edw_log.put_line(' End of Collect Discrete Job Resource Fact ');
93: ELSIF l_fact_name = 'OPI_EDW_JOB_DETAIL_F' THEN
94: edw_log.put_line(' ');
95: -- edw_log.put_line(' Start of Collect Process Job Detail Fact ');
96: /* OPI_EDW_OPM_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
97: IF retcode = '2' THEN
98: APP_EXCEPTION.Raise_exception;
99: END IF;

Line 100: edw_log.put_line(' ');

96: /* OPI_EDW_OPM_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
97: IF retcode = '2' THEN
98: APP_EXCEPTION.Raise_exception;
99: END IF;
100: edw_log.put_line(' ');
101: -- edw_log.put_line(' End of Collect Job Detail Fact');
102: edw_log.put_line(' ');
103: edw_log.put_line(' Start of Collect Discrete Job Detail Fact ');
104: OPI_EDW_OPI_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));

Line 101: -- edw_log.put_line(' End of Collect Job Detail Fact');

97: IF retcode = '2' THEN
98: APP_EXCEPTION.Raise_exception;
99: END IF;
100: edw_log.put_line(' ');
101: -- edw_log.put_line(' End of Collect Job Detail Fact');
102: edw_log.put_line(' ');
103: edw_log.put_line(' Start of Collect Discrete Job Detail Fact ');
104: OPI_EDW_OPI_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
105: edw_log.put_line(' ');

Line 102: edw_log.put_line(' ');

98: APP_EXCEPTION.Raise_exception;
99: END IF;
100: edw_log.put_line(' ');
101: -- edw_log.put_line(' End of Collect Job Detail Fact');
102: edw_log.put_line(' ');
103: edw_log.put_line(' Start of Collect Discrete Job Detail Fact ');
104: OPI_EDW_OPI_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
105: edw_log.put_line(' ');
106: edw_log.put_line(' End of Collect Discrete Job Detail Fact ');

Line 103: edw_log.put_line(' Start of Collect Discrete Job Detail Fact ');

99: END IF;
100: edw_log.put_line(' ');
101: -- edw_log.put_line(' End of Collect Job Detail Fact');
102: edw_log.put_line(' ');
103: edw_log.put_line(' Start of Collect Discrete Job Detail Fact ');
104: OPI_EDW_OPI_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
105: edw_log.put_line(' ');
106: edw_log.put_line(' End of Collect Discrete Job Detail Fact ');
107: ELSIF l_fact_name = 'OPI_EDW_RES_UTIL_F' THEN

Line 105: edw_log.put_line(' ');

101: -- edw_log.put_line(' End of Collect Job Detail Fact');
102: edw_log.put_line(' ');
103: edw_log.put_line(' Start of Collect Discrete Job Detail Fact ');
104: OPI_EDW_OPI_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
105: edw_log.put_line(' ');
106: edw_log.put_line(' End of Collect Discrete Job Detail Fact ');
107: ELSIF l_fact_name = 'OPI_EDW_RES_UTIL_F' THEN
108: edw_log.put_line(' ');
109: -- edw_log.put_line(' Start of Collect Process Resource Utilization Fact ');

Line 106: edw_log.put_line(' End of Collect Discrete Job Detail Fact ');

102: edw_log.put_line(' ');
103: edw_log.put_line(' Start of Collect Discrete Job Detail Fact ');
104: OPI_EDW_OPI_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
105: edw_log.put_line(' ');
106: edw_log.put_line(' End of Collect Discrete Job Detail Fact ');
107: ELSIF l_fact_name = 'OPI_EDW_RES_UTIL_F' THEN
108: edw_log.put_line(' ');
109: -- edw_log.put_line(' Start of Collect Process Resource Utilization Fact ');
110: /* OPI_EDW_OPM_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */

Line 108: edw_log.put_line(' ');

104: OPI_EDW_OPI_JOB_DETAIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
105: edw_log.put_line(' ');
106: edw_log.put_line(' End of Collect Discrete Job Detail Fact ');
107: ELSIF l_fact_name = 'OPI_EDW_RES_UTIL_F' THEN
108: edw_log.put_line(' ');
109: -- edw_log.put_line(' Start of Collect Process Resource Utilization Fact ');
110: /* OPI_EDW_OPM_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
111: IF retcode = '2' THEN
112: APP_EXCEPTION.Raise_exception;

Line 109: -- edw_log.put_line(' Start of Collect Process Resource Utilization Fact ');

105: edw_log.put_line(' ');
106: edw_log.put_line(' End of Collect Discrete Job Detail Fact ');
107: ELSIF l_fact_name = 'OPI_EDW_RES_UTIL_F' THEN
108: edw_log.put_line(' ');
109: -- edw_log.put_line(' Start of Collect Process Resource Utilization Fact ');
110: /* OPI_EDW_OPM_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
111: IF retcode = '2' THEN
112: APP_EXCEPTION.Raise_exception;
113: END IF;

Line 114: edw_log.put_line(' ');

110: /* OPI_EDW_OPM_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date =>to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') , p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS') ); */
111: IF retcode = '2' THEN
112: APP_EXCEPTION.Raise_exception;
113: END IF;
114: edw_log.put_line(' ');
115: -- edw_log.put_line(' End of Collect Resource Utilization Fact');
116:
117: edw_log.put_line(' ');
118: edw_log.put_line(' Start of Collect Discrete Resource Utilization Fact ');

Line 115: -- edw_log.put_line(' End of Collect Resource Utilization Fact');

111: IF retcode = '2' THEN
112: APP_EXCEPTION.Raise_exception;
113: END IF;
114: edw_log.put_line(' ');
115: -- edw_log.put_line(' End of Collect Resource Utilization Fact');
116:
117: edw_log.put_line(' ');
118: edw_log.put_line(' Start of Collect Discrete Resource Utilization Fact ');
119: OPI_EDW_OPI_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));

Line 117: edw_log.put_line(' ');

113: END IF;
114: edw_log.put_line(' ');
115: -- edw_log.put_line(' End of Collect Resource Utilization Fact');
116:
117: edw_log.put_line(' ');
118: edw_log.put_line(' Start of Collect Discrete Resource Utilization Fact ');
119: OPI_EDW_OPI_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
120: edw_log.put_line(' ');
121: edw_log.put_line(' End of Collect Discrete Resource Utilization Fact ');

Line 118: edw_log.put_line(' Start of Collect Discrete Resource Utilization Fact ');

114: edw_log.put_line(' ');
115: -- edw_log.put_line(' End of Collect Resource Utilization Fact');
116:
117: edw_log.put_line(' ');
118: edw_log.put_line(' Start of Collect Discrete Resource Utilization Fact ');
119: OPI_EDW_OPI_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
120: edw_log.put_line(' ');
121: edw_log.put_line(' End of Collect Discrete Resource Utilization Fact ');
122: ELSE

Line 120: edw_log.put_line(' ');

116:
117: edw_log.put_line(' ');
118: edw_log.put_line(' Start of Collect Discrete Resource Utilization Fact ');
119: OPI_EDW_OPI_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
120: edw_log.put_line(' ');
121: edw_log.put_line(' End of Collect Discrete Resource Utilization Fact ');
122: ELSE
123: edw_log.put_line(' ');
124: edw_log.put_line(' Invalid Concurrent Program registration ');

Line 121: edw_log.put_line(' End of Collect Discrete Resource Utilization Fact ');

117: edw_log.put_line(' ');
118: edw_log.put_line(' Start of Collect Discrete Resource Utilization Fact ');
119: OPI_EDW_OPI_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
120: edw_log.put_line(' ');
121: edw_log.put_line(' End of Collect Discrete Resource Utilization Fact ');
122: ELSE
123: edw_log.put_line(' ');
124: edw_log.put_line(' Invalid Concurrent Program registration ');
125: END IF;

Line 123: edw_log.put_line(' ');

119: OPI_EDW_OPI_RES_UTIL_F_C.PUSH(Errbuf => Errbuf ,Retcode => Retcode , p_from_date => to_char(l_from_date,'YYYY/MM/DD HH24:MI:SS') ,p_to_date => to_char(l_to_date,'YYYY/MM/DD HH24:MI:SS'));
120: edw_log.put_line(' ');
121: edw_log.put_line(' End of Collect Discrete Resource Utilization Fact ');
122: ELSE
123: edw_log.put_line(' ');
124: edw_log.put_line(' Invalid Concurrent Program registration ');
125: END IF;
126: END PUSH;
127: END OPI_EDW_COLLECT_MBI_FACTS_F_C;

Line 124: edw_log.put_line(' Invalid Concurrent Program registration ');

120: edw_log.put_line(' ');
121: edw_log.put_line(' End of Collect Discrete Resource Utilization Fact ');
122: ELSE
123: edw_log.put_line(' ');
124: edw_log.put_line(' Invalid Concurrent Program registration ');
125: END IF;
126: END PUSH;
127: END OPI_EDW_COLLECT_MBI_FACTS_F_C;