APPS.OPI_DBI_WMS_RTP_F_C dependencies on DBMS_APPLICATION_INFO

Line 62: DBMS_APPLICATION_INFO.SET_MODULE(module_name => 'OPI DBI RTP COLLECT', action_name => 'start');

58: BEGIN
59: Errbuf :=NULL;
60: Retcode:=0;
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

Line 95: DBMS_APPLICATION_INFO.SET_ACTION('rates');

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;
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;

Line 214: DBMS_APPLICATION_INFO.SET_ACTION('stats');

210: raise_application_error (-20000, 'error in rates table collection: ' || errbuf);
211: end if;
212:
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 '||

Line 223: DBMS_APPLICATION_INFO.SET_ACTION('collect');

219:
220: l_start_time := sysdate;
221: l_login := fnd_global.login_id;
222: l_user := fnd_global.user_id;
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);

Line 435: DBMS_APPLICATION_INFO.set_module(NULL, NULL);

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
438: DBMS_APPLICATION_INFO.SET_ACTION('error');
439: errbuf:=sqlerrm;

Line 438: DBMS_APPLICATION_INFO.SET_ACTION('error');

434: g_init := false;
435: DBMS_APPLICATION_INFO.set_module(NULL, NULL);
436: EXCEPTION
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);