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_DBI_WMS_RTP_F_C dependencies on BIS_COLLECTION_UTILITIES

Line 65: l_go_ahead := bis_collection_utilities.setup('OPIDBIRTP');

61:
62: DBMS_APPLICATION_INFO.SET_MODULE(module_name => 'OPI DBI RTP COLLECT', action_name => 'start');
63: l_dop := bis_common_parameters.get_degree_of_parallelism;
64: -- default DOP to profile in EDW_PARALLEL_SRC if 2nd param is not passed
65: l_go_ahead := bis_collection_utilities.setup('OPIDBIRTP');
66: if (g_init) then
67: execute immediate 'alter session set hash_area_size=104857600';
68: execute immediate 'alter session set sort_area_size=104857600';
69: end if;

Line 74: bis_collection_utilities.g_debug := FALSE;

70: IF (NOT l_go_ahead) THEN
71: errbuf := fnd_message.get;
72: RAISE_APPLICATION_ERROR (-20000, 'Error in SETUP: ' || errbuf);
73: END IF;
74: bis_collection_utilities.g_debug := FALSE;
75:
76: IF(g_init) THEN
77: l_start_date := To_char(bis_common_parameters.get_global_start_date
78: , 'YYYY/MM/DD HH24:MI:SS');

Line 81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');

77: l_start_date := To_char(bis_common_parameters.get_global_start_date
78: , 'YYYY/MM/DD HH24:MI:SS');
79: d_start_date := bis_common_parameters.get_global_start_date;
80: ELSE
81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
82: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
83: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004;
84: END IF;
85:

Line 83: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004;

79: d_start_date := bis_common_parameters.get_global_start_date;
80: ELSE
81: l_start_date := To_char(fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004,'YYYY/MM/DD HH24:MI:SS');
82: /* note that if there is not a success record in the log, we should get global start date as l_start_date */
83: d_start_date := fnd_date.displaydt_to_date(bis_collection_utilities.get_last_refresh_period('OPIDBIRTP')) - 0.004;
84: END IF;
85:
86: l_end_date := To_char(Sysdate, 'YYYY/MM/DD HH24:MI:SS');
87: d_end_date := Sysdate;

Line 89: bis_collection_utilities.log( 'The collection range is from '||

85:
86: l_end_date := To_char(Sysdate, 'YYYY/MM/DD HH24:MI:SS');
87: d_end_date := Sysdate;
88:
89: bis_collection_utilities.log( 'The collection range is from '||
90: l_start_date ||' to '|| l_end_date, 0);
91:
92: l_glob_date := To_char(bis_common_parameters.get_global_start_date, 'YYYY/MM/DD HH24:MI:SS');
93: d_glob_date := bis_common_parameters.get_global_start_date;

Line 97: bis_collection_utilities.log('Error getting app info '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

93: d_glob_date := bis_common_parameters.get_global_start_date;
94:
95: DBMS_APPLICATION_INFO.SET_ACTION('rates');
96: if (not(fnd_installation.get_app_info('OPI', l_status, l_industry, l_opi_schema))) then
97: bis_collection_utilities.log('Error getting app info '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
98: RAISE_APPLICATION_ERROR (-20000, 'Error in GET_APP_INFO: ' || errbuf);
99: end if;
100: l_stmt := 'TRUNCATE TABLE ' || l_opi_schema || '.OPI_DBI_WMS_UOM_RATES';
101: execute immediate l_stmt;

Line 217: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

213: COMMIT;
214: DBMS_APPLICATION_INFO.SET_ACTION('stats');
215: fnd_stats.gather_table_stats(OWNNAME => l_opi_schema, TABNAME => 'OPI_DBI_WMS_UOM_RATES');
216:
217: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
218: -- bis_collection_utilities.log('Identified '||
219:
220: l_start_time := sysdate;
221: l_login := fnd_global.login_id;

Line 218: -- bis_collection_utilities.log('Identified '||

214: DBMS_APPLICATION_INFO.SET_ACTION('stats');
215: fnd_stats.gather_table_stats(OWNNAME => l_opi_schema, TABNAME => 'OPI_DBI_WMS_UOM_RATES');
216:
217: bis_collection_utilities.log('Populate base table: '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
218: -- bis_collection_utilities.log('Identified '||
219:
220: l_start_time := sysdate;
221: l_login := fnd_global.login_id;
222: l_user := fnd_global.user_id;

Line 227: bis_collection_utilities.log('Initial Load - populate base fact. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

223: DBMS_APPLICATION_INFO.SET_ACTION('collect');
224:
225: IF (g_init) THEN
226:
227: bis_collection_utilities.log('Initial Load - populate base fact. '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
228: INSERT /*+ APPEND PARALLEL(t) */ INTO opi_dbi_wms_rtp_f t (
229: task_id,
230: transaction_id,
231: organization_id,

Line 432: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

428: COMMIT;
429:
430: END IF;
431:
432: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
433: bis_collection_utilities.wrapup(TRUE, l_count, 'OPI DBI WMS RTP COLLECTION SUCEEDED', To_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
434: g_init := false;
435: DBMS_APPLICATION_INFO.set_module(NULL, NULL);
436: EXCEPTION

Line 433: bis_collection_utilities.wrapup(TRUE, l_count, 'OPI DBI WMS RTP COLLECTION SUCEEDED', To_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));

429:
430: END IF;
431:
432: bis_collection_utilities.log('Collection complete '|| 'Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
433: bis_collection_utilities.wrapup(TRUE, l_count, 'OPI DBI WMS RTP COLLECTION SUCEEDED', To_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
434: g_init := false;
435: DBMS_APPLICATION_INFO.set_module(NULL, NULL);
436: EXCEPTION
437: WHEN OTHERS THEN

Line 441: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);

437: WHEN OTHERS THEN
438: DBMS_APPLICATION_INFO.SET_ACTION('error');
439: errbuf:=sqlerrm;
440: retcode:=sqlcode;
441: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
442: -- dbms_output.put_line(l_start_date || l_end_date);
443: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode,
444: To_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
445:

Line 443: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode,

439: errbuf:=sqlerrm;
440: retcode:=sqlcode;
441: bis_collection_utilities.log('Collection failed with '||errbuf||':'||retcode||' Sysdate=' ||To_char(Sysdate, 'DD/MM/YYYY HH24:MI:SS'), 0);
442: -- dbms_output.put_line(l_start_date || l_end_date);
443: bis_collection_utilities.wrapup(FALSE, l_count, errbuf||':'||retcode,
444: To_date(l_start_date, '''YYYY/MM/DD HH24:MI:SS'''), To_date(l_end_date, '''YYYY/MM/DD HH24:MI:SS'''));
445:
446:
447: RAISE;