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

Line 256: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

252:
253: -- opi data was not found successfully
254: l_opi_success := false;
255:
256: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
257: l_proc_name || ' ' ||
258: '#' || l_stmt_id ||
259: ': ' || SQLERRM);
260: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

Line 260: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

256: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
257: l_proc_name || ' ' ||
258: '#' || l_stmt_id ||
259: ': ' || SQLERRM);
260: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
261: l_proc_name || ' ' ||
262: '#' || l_stmt_id || ': ' ||
263: 'Unable to collect OPI WIP completions data in initial load into staging table.');
264:

Line 288: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

284:
285: -- opm data was not found successfully
286: l_opm_success := false;
287:
288: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
289: l_proc_name || ' ' ||
290: '#' || l_stmt_id ||
291: ': ' || SQLERRM);
292: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

Line 292: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

288: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
289: l_proc_name || ' ' ||
290: '#' || l_stmt_id ||
291: ': ' || SQLERRM);
292: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
293: l_proc_name || ' ' ||
294: '#' || l_stmt_id || ': ' ||
295: 'Unable to collect OPM WIP completions data in initial load into staging table.');
296:

Line 334: BIS_COLLECTION_UTILITIES.PUT_LINE

330: EXECUTE IMMEDIATE ('TRUNCATE TABLE ' || s_opi_schema || '.' ||
331: 'OPI_DBI_WIP_COMP_STG');
332:
333: l_stmt_id := 130;
334: BIS_COLLECTION_UTILITIES.PUT_LINE
335: ('WIP Completions Initial load terminated successfully.');
336: retcode := s_SUCCESS;
337: errbuf := '';
338: return;

Line 345: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

341:
342: WHEN schema_info_not_found THEN
343: rollback;
344:
345: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
346: l_proc_name || ' ' ||
347: '#' || l_stmt_id ||
348: ': ' || SQLERRM);
349:

Line 359: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

355:
356: WHEN global_setup_missing THEN
357: rollback;
358:
359: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
360: l_proc_name || ' ' ||
361: '#' || l_stmt_id ||
362: ': ' || SQLERRM);
363:

Line 373: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

369:
370: WHEN data_extraction_failed THEN
371: rollback;
372:
373: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
374: l_proc_name || ' ' ||
375: '#' || l_stmt_id ||
376: ': ' || SQLERRM);
377:

Line 387: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

383:
384: WHEN OTHERS THEN
385: rollback;
386:
387: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
388: l_proc_name || ' ' ||
389: '#' || l_stmt_id ||
390: ': ' || SQLERRM);
391:

Line 609: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

605:
606: WHEN could_not_log_success THEN
607: rollback;
608:
609: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
610: l_proc_name || ' ' ||
611: '#' || l_stmt_id || ': ' ||
612: 'WIP Completion ETLs Initial load OPI data extraction success could not be logged into log table. Aborting.');
613:

Line 623: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

619:
620:
621: WHEN cannot_run_initial_load THEN
622: rollback;
623: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
624: l_proc_name || ' ' ||
625: '#' || l_stmt_id || ': ' ||
626: 'WIP Completion initial load concurrent program should not be running. Try running the incremental load request set if the initial request set has already been run.');
627: BIS_COLLECTION_UTILITIES.PUT_LINE ('If not, you will need to run the initial load request set.');

Line 627: BIS_COLLECTION_UTILITIES.PUT_LINE ('If not, you will need to run the initial load request set.');

623: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
624: l_proc_name || ' ' ||
625: '#' || l_stmt_id || ': ' ||
626: 'WIP Completion initial load concurrent program should not be running. Try running the incremental load request set if the initial request set has already been run.');
627: BIS_COLLECTION_UTILITIES.PUT_LINE ('If not, you will need to run the initial load request set.');
628:
629: retcode := s_ERROR;
630: errbuf := s_pkg_name || '.' || l_proc_name || ' ' || '#' ||
631: l_stmt_id || ': ' ||

Line 637: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

633: RAISE; -- propagate exception to wrapper.
634:
635: WHEN run_common_module THEN
636: rollback;
637: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
638: l_proc_name || ' ' ||
639: '#' || l_stmt_id || ': ' ||
640: 'WIP Completion initial load concurrent program is running out of turn. Please submit the initial load request set for initial data collection.');
641:

Line 652: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

648:
649: WHEN OTHERS THEN
650: rollback;
651:
652: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
653: l_proc_name || ' ' ||
654: '#' || l_stmt_id ||
655: ': ' || SQLERRM);
656:

Line 762: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

758:
759: WHEN OTHERS THEN
760: rollback;
761:
762: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
763: l_proc_name || ' ' ||
764: '#' || l_stmt_id ||
765: ': ' || SQLERRM);
766:

Line 1073: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

1069: IF (invalid_rates_exist_csr%FOUND) THEN
1070:
1071: -- there are missing rates - prepare to report them.
1072: l_all_rates_found := false;
1073: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
1074:
1075: l_stmt_id := 60;
1076: FOR get_missing_rates_rec IN get_missing_rates_c
1077: (l_pri_sec_curr_same,

Line 1084: BIS_COLLECTION_UTILITIES.writemissingrate (

1080: l_secondary_currency_code,
1081: l_secondary_rate_type)
1082: LOOP
1083:
1084: BIS_COLLECTION_UTILITIES.writemissingrate (
1085: get_missing_rates_rec.rate_type,
1086: get_missing_rates_rec.func_currency_code,
1087: get_missing_rates_rec.curr_code,
1088: get_missing_rates_rec.transaction_date);

Line 1111: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

1107:
1108: WHEN global_curr_code_not_found THEN
1109: rollback;
1110:
1111: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1112: l_proc_name || ' ' ||
1113: '#' || l_stmt_id || ': ' ||
1114: 'WIP Completion ETLs global currency code not found.');
1115:

Line 1125: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

1121:
1122: WHEN global_rate_type_not_found THEN
1123: rollback;
1124:
1125: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1126: l_proc_name || ' ' ||
1127: '#' || l_stmt_id || ': ' ||
1128: 'WIP Completions ETL Initial load global rate type not found.');
1129:

Line 1139: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

1135:
1136: WHEN missing_conversion_rates THEN
1137: rollback;
1138:
1139: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1140: l_proc_name || ' ' ||
1141: '#' || l_stmt_id || ': ' ||
1142: 'WIP Completion ETLs Initial Load found missing currency rates.');
1143:

Line 1154: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

1150:
1151: WHEN OTHERS THEN
1152: rollback;
1153:
1154: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1155: l_proc_name || ' ' ||
1156: '#' || l_stmt_id ||
1157: ': ' || SQLERRM);
1158:

Line 1209: BIS_COLLECTION_UTILITIES.PUT_LINE (

1205: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';
1206: l_setup_good := bis_common_parameters.check_global_parameters(l_list);
1207:
1208: IF (NOT (l_setup_good)) THEN
1209: BIS_COLLECTION_UTILITIES.PUT_LINE (
1210: 'Global setup is not correct. Please setup up the global start date, primary currency code and primary rate type.');
1211: END IF;
1212:
1213: -- check the secondary currency setup

Line 1225: BIS_COLLECTION_UTILITIES.PUT_LINE ('The global secondary currency code setup is incorrect. The secondary currency code cannot be null when the secondary rate type is defined and vice versa.');

1221: l_secondary_rate_type IS NOT NULL)
1222: OR (l_secondary_currency_code IS NOT NULL AND
1223: l_secondary_rate_type IS NULL) ) THEN
1224:
1225: BIS_COLLECTION_UTILITIES.PUT_LINE ('The global secondary currency code setup is incorrect. The secondary currency code cannot be null when the secondary rate type is defined and vice versa.');
1226:
1227: l_setup_good := FALSE;
1228:
1229: END IF;

Line 1239: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||

1235:
1236: WHEN OTHERS THEN
1237: rollback;
1238:
1239: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1240: l_proc_name || ' ' ||
1241: '#' || l_stmt_id ||
1242: ': ' || SQLERRM);
1243: