DBA Data[Home] [Help]

APPS.OPI_EDW_COLLECT_MBI_FACTS_F_C dependencies on APP_EXCEPTION

Line 56: APP_EXCEPTION.Raise_exception;

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;
58: edw_log.put_line(' ');
59: -- edw_log.put_line(' End of Collect Process Inventory Daily Status ');
60: edw_log.put_line(' ');

Line 70: APP_EXCEPTION.Raise_exception;

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;
72: edw_log.put_line(' ');
73: -- edw_log.put_line(' End of Collect COGS Fact');
74: edw_log.put_line(' ');

Line 84: APP_EXCEPTION.Raise_exception;

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;
86: edw_log.put_line(' ');
87: -- edw_log.put_line(' End of Collect Job Resource Fact');
88: edw_log.put_line(' ');

Line 98: APP_EXCEPTION.Raise_exception;

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;
100: edw_log.put_line(' ');
101: -- edw_log.put_line(' End of Collect Job Detail Fact');
102: edw_log.put_line(' ');

Line 112: APP_EXCEPTION.Raise_exception;

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;
114: edw_log.put_line(' ');
115: -- edw_log.put_line(' End of Collect Resource Utilization Fact');
116: