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

Line 228: BIS_COLLECTION_UTILITIES.PUT_LINE

224: -- if uncosted transactions were found, return a warning.
225: l_stmt_id := 80;
226: IF (l_bounds_warning) THEN
227:
228: BIS_COLLECTION_UTILITIES.PUT_LINE
229: ('Common Module Incremental Load terminated with warnings.');
230: retcode := s_WARNING;
231: errbuf := 'Common Module Incremental Load Found Uncosted Transactions.';
232: ELSE

Line 234: BIS_COLLECTION_UTILITIES.PUT_LINE

230: retcode := s_WARNING;
231: errbuf := 'Common Module Incremental Load Found Uncosted Transactions.';
232: ELSE
233: -- terminate successfully
234: BIS_COLLECTION_UTILITIES.PUT_LINE
235: ('Common Module Incremental Load terminated successfully.');
236: retcode := s_SUCCESS;
237: errbuf := '';
238: END IF;

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

241:
242: WHEN run_common_mod_init THEN
243: rollback;
244:
245: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
246: l_proc_name || ' ' ||
247: '#' || l_stmt_id ||
248: ': ' ||
249: 'Manufacturing Page common module Initial load has not been run. Please run the initial load (Initial Load - Update Job Details Base Summary) first.');

Line 261: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' || l_proc_name || ' ' ||

257:
258: WHEN schema_info_not_found THEN
259: rollback;
260:
261: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' || l_proc_name || ' ' ||
262: '#' || l_stmt_id || ': ' || SQLERRM);
263:
264: retcode := s_ERROR;
265: errbuf := s_pkg_name || '.' || l_proc_name || ' ' || '#' ||

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

269:
270: WHEN global_setup_missing THEN
271: rollback;
272:
273: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
274: l_proc_name || ' ' ||
275: '#' || l_stmt_id ||
276: ': ' || SQLERRM);
277:

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

283:
284: WHEN stage_failure THEN
285: rollback;
286:
287: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
288: l_proc_name || ' ' ||
289: '#' || l_stmt_id ||
290: ': ' || SQLERRM);
291: retcode := s_ERROR;

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

297:
298: WHEN OTHERS THEN
299: rollback;
300:
301: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
302: l_proc_name || ' ' ||
303: '#' || l_stmt_id ||
304: ': ' || SQLERRM);
305:

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

360:
361: WHEN OTHERS THEN
362: rollback;
363:
364: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
365: l_proc_name || ' ' ||
366: '#' || l_stmt_id ||
367: ': ' || SQLERRM);
368:

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

700:
701: WHEN global_start_date_null THEN
702: rollback;
703:
704: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
705: l_proc_name || ' ' ||
706: '#' || l_stmt_id ||
707: ': ' ||
708: 'Global Start date was null');

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

716:
717: WHEN OTHERS THEN
718: rollback;
719:
720: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
721: l_proc_name || ' ' ||
722: '#' || l_stmt_id ||
723: ': ' || SQLERRM);
724:

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

821:
822: WHEN OTHERS THEN
823: rollback;
824:
825: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
826: l_proc_name || ' ' ||
827: '#' || l_stmt_id ||
828: ': ' || SQLERRM);
829:

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

826: l_proc_name || ' ' ||
827: '#' || l_stmt_id ||
828: ': ' || SQLERRM);
829:
830: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
831: l_proc_name || ' ' ||
832: '#' || l_stmt_id || ': ' ||
833: 'Failed to log successful collection for ETL #' ||
834: p_etl_id || ' source #' ||

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

954:
955: WHEN OTHERS THEN
956: rollback;
957:
958: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
959: l_proc_name || ' ' ||
960: '#' || l_stmt_id ||
961: ': ' || SQLERRM);
962:

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

959: l_proc_name || ' ' ||
960: '#' || l_stmt_id ||
961: ': ' || SQLERRM);
962:
963: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
964: l_proc_name || ' ' ||
965: '#' || l_stmt_id || ': ' ||
966: 'Failed to log transaction id success for ETL #' ||
967: p_etl_id || ' source #' ||

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

1083:
1084: WHEN OTHERS THEN
1085: rollback;
1086:
1087: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1088: l_proc_name || ' ' ||
1089: '#' || l_stmt_id ||
1090: ': ' || SQLERRM);
1091:

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

1088: l_proc_name || ' ' ||
1089: '#' || l_stmt_id ||
1090: ': ' || SQLERRM);
1091:
1092: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1093: l_proc_name || ' ' ||
1094: '#' || l_stmt_id || ': ' ||
1095: 'Failed to log collection date success for ETL #' ||
1096: p_etl_id || ' source #' ||

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

1172:
1173: EXCEPTION
1174:
1175: WHEN run_common_mod_init THEN
1176: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1177: l_proc_name || ' ' ||
1178: '#' || l_stmt_id ||
1179: ': ' || 'The initial load request set has not been run yet. Please run the initial load request set before running the incremental load request set.');
1180:

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

1184:
1185: WHEN OTHERS THEN
1186: rollback;
1187:
1188: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1189: l_proc_name || ' ' ||
1190: '#' || l_stmt_id ||
1191: ': ' || SQLERRM);
1192:

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

1271:
1272: EXCEPTION
1273:
1274: WHEN txn_id_bounds_missing THEN
1275: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1276: l_proc_name || ' ' ||
1277: '#' || l_stmt_id || ': ' ||
1278: 'Found missing transaction_id bounds for ETL ' ||
1279: p_etl_id || ' source ' ||

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

1283:
1284: WHEN OTHERS THEN
1285: rollback;
1286:
1287: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1288: l_proc_name || ' ' ||
1289: '#' || l_stmt_id ||
1290: ': ' || SQLERRM);
1291:

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

1387:
1388: EXCEPTION
1389:
1390: WHEN collect_date_bounds_missing THEN
1391: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1392: l_proc_name || ' ' ||
1393: '#' || l_stmt_id || ': ' ||
1394: 'Found null last_collection_date for ETL ' ||
1395: p_etl_id || ' source ' ||

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

1400:
1401: WHEN OTHERS THEN
1402: rollback;
1403:
1404: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1405: l_proc_name || ' ' ||
1406: '#' || l_stmt_id ||
1407: ': ' || SQLERRM);
1408:

Line 1453: BIS_COLLECTION_UTILITIES.PUT_LINE ('The incremental request set cannot be run because ' || l_num_non_incr_rows || ' rows in the runtime bounds log indicate that the initial load has not been run.');

1449: IF (l_num_non_incr_rows IS NULL) THEN
1450: l_run_incr := true;
1451: ELSE
1452: l_run_incr := false;
1453: BIS_COLLECTION_UTILITIES.PUT_LINE ('The incremental request set cannot be run because ' || l_num_non_incr_rows || ' rows in the runtime bounds log indicate that the initial load has not been run.');
1454: BIS_COLLECTION_UTILITIES.PUT_LINE (' Please run the initial load request set before running the incremental load request set.');
1455:
1456: END IF;
1457:

Line 1454: BIS_COLLECTION_UTILITIES.PUT_LINE (' Please run the initial load request set before running the incremental load request set.');

1450: l_run_incr := true;
1451: ELSE
1452: l_run_incr := false;
1453: BIS_COLLECTION_UTILITIES.PUT_LINE ('The incremental request set cannot be run because ' || l_num_non_incr_rows || ' rows in the runtime bounds log indicate that the initial load has not been run.');
1454: BIS_COLLECTION_UTILITIES.PUT_LINE (' Please run the initial load request set before running the incremental load request set.');
1455:
1456: END IF;
1457:
1458: l_stmt_id := 30;

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

1462:
1463: WHEN OTHERS THEN
1464: rollback;
1465:
1466: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1467: l_proc_name || ' ' ||
1468: '#' || l_stmt_id ||
1469: ': ' || SQLERRM);
1470: