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

Line 163: BIS_COLLECTION_UTILITIES.PUT_LINE

159: -- if uncosted transactions were found, return a warning.
160: l_stmt_id := 70;
161: IF (l_bounds_warning) THEN
162:
163: BIS_COLLECTION_UTILITIES.PUT_LINE
164: ('Common Module Initial Load terminated with warnings.');
165: retcode := s_WARNING;
166: errbuf := 'Common Module Initial Load Found Uncosted Transactions. ';
167:

Line 170: BIS_COLLECTION_UTILITIES.PUT_LINE

166: errbuf := 'Common Module Initial Load Found Uncosted Transactions. ';
167:
168: ELSE
169: -- terminate successfully
170: BIS_COLLECTION_UTILITIES.PUT_LINE
171: ('Common Module Initial Load terminated successfully.');
172: retcode := s_SUCCESS;
173: errbuf := '';
174: END IF;

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

177:
178: WHEN schema_info_not_found THEN
179: rollback;
180:
181: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
182: l_proc_name || ' ' ||
183: '#' || l_stmt_id ||
184: ': ' || SQLERRM);
185:

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

191:
192: WHEN global_setup_missing THEN
193: rollback;
194:
195: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
196: l_proc_name || ' ' ||
197: '#' || l_stmt_id ||
198: ': ' || SQLERRM);
199:

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

205:
206: WHEN stage_failure THEN
207: rollback;
208:
209: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
210: l_proc_name || ' ' ||
211: '#' || l_stmt_id ||
212: ': ' || SQLERRM);
213: retcode := s_ERROR;

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

218:
219: WHEN OTHERS THEN
220: rollback;
221:
222: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
223: l_proc_name || ' ' ||
224: '#' || l_stmt_id ||
225: ': ' || SQLERRM);
226:

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

304:
305: WHEN OTHERS THEN
306: rollback;
307:
308: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
309: l_proc_name || ' ' ||
310: '#' || l_stmt_id ||
311: ': ' || SQLERRM);
312:

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

743:
744: WHEN OTHERS THEN
745: rollback;
746:
747: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
748: l_proc_name || ' ' ||
749: '#' || l_stmt_id ||
750: ': ' || SQLERRM);
751:

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

838: EXCEPTION
839:
840:
841: WHEN run_common_mod_init THEN
842: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
843: l_proc_name || ' ' ||
844: '#' || l_stmt_id ||
845: ': ' || 'Run time bounds have not been set up. Please run the initial load request set.');
846:

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

850:
851: WHEN OTHERS THEN
852: rollback;
853:
854: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
855: l_proc_name || ' ' ||
856: '#' || l_stmt_id ||
857: ': ' || SQLERRM);
858:

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

940:
941: EXCEPTION
942:
943: WHEN txn_id_bounds_missing THEN
944: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' || l_proc_name || ' ' ||
945: '#' || l_stmt_id || ': ' ||
946: 'Found missing transaction_id bounds for ETL ' ||
947: p_etl_id || ' source ' || p_source || '.');
948: l_bounds_valid := false;

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

950:
951: WHEN OTHERS THEN
952: rollback;
953:
954: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
955: l_proc_name || ' ' ||
956: '#' || l_stmt_id ||
957: ': ' || SQLERRM);
958:

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

1056:
1057: EXCEPTION
1058:
1059: WHEN collect_date_bounds_missing THEN
1060: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1061: l_proc_name || ' ' ||
1062: '#' || l_stmt_id || ': ' ||
1063: 'Found missing dates for ETL ' ||
1064: p_etl_id || ' source ' ||

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

1069:
1070: WHEN OTHERS THEN
1071: rollback;
1072:
1073: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1074: l_proc_name || ' ' ||
1075: '#' || l_stmt_id ||
1076: ': ' || SQLERRM);
1077:

Line 1122: BIS_COLLECTION_UTILITIES.PUT_LINE ('The initial load of this concurrent program cannot be run independently. Please run the initial load request set if it has not already been run successfully.');

1118: IF (l_num_non_init_rows IS NULL) THEN
1119: l_run_init := true;
1120: ELSE
1121: l_run_init := false;
1122: BIS_COLLECTION_UTILITIES.PUT_LINE ('The initial load of this concurrent program cannot be run independently. Please run the initial load request set if it has not already been run successfully.');
1123: BIS_COLLECTION_UTILITIES.PUT_LINE (' Alternatively, run the incremental load request set if the initial load request set has already run.');
1124:
1125: END IF;
1126:

Line 1123: BIS_COLLECTION_UTILITIES.PUT_LINE (' Alternatively, run the incremental load request set if the initial load request set has already run.');

1119: l_run_init := true;
1120: ELSE
1121: l_run_init := false;
1122: BIS_COLLECTION_UTILITIES.PUT_LINE ('The initial load of this concurrent program cannot be run independently. Please run the initial load request set if it has not already been run successfully.');
1123: BIS_COLLECTION_UTILITIES.PUT_LINE (' Alternatively, run the incremental load request set if the initial load request set has already run.');
1124:
1125: END IF;
1126:
1127: l_stmt_id := 30;

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

1131:
1132: WHEN OTHERS THEN
1133: rollback;
1134:
1135: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1136: l_proc_name || ' ' ||
1137: '#' || l_stmt_id ||
1138: ': ' || SQLERRM);
1139:

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

1178:
1179: WHEN OTHERS THEN
1180: rollback;
1181:
1182: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1183: l_proc_name || ' ' ||
1184: '#' || l_stmt_id ||
1185: ': ' || SQLERRM);
1186:

Line 1274: BIS_COLLECTION_UTILITIES.PUT_LINE (

1270:
1271: -- print the header
1272: l_stmt_id := 10;
1273:
1274: BIS_COLLECTION_UTILITIES.PUT_LINE (
1275: RPAD ('Organization Code', 20) ||
1276: RPAD ('Txn Id Stopped Before', 25) ||
1277: RPAD ('Data Collected Until', 25) ||
1278: RPAD ('Reason Stopped', 20));

Line 1281: BIS_COLLECTION_UTILITIES.PUT_LINE (

1277: RPAD ('Data Collected Until', 25) ||
1278: RPAD ('Reason Stopped', 20));
1279:
1280:
1281: BIS_COLLECTION_UTILITIES.PUT_LINE (
1282: RPAD ('-----------------', 20) ||
1283: RPAD ('---------------------', 25) ||
1284: RPAD ('--------------------', 25) ||
1285: RPAD ('--------------', 20));

Line 1293: BIS_COLLECTION_UTILITIES.PUT_LINE (

1289: l_stmt_id := 20;
1290: FOR opi_org_bounds_rec IN opi_org_bounds_csr
1291: LOOP
1292:
1293: BIS_COLLECTION_UTILITIES.PUT_LINE (
1294: RPAD (opi_org_bounds_rec.organization_code, 20) ||
1295: RPAD (opi_org_bounds_rec.next_start_txn_id, 25) ||
1296: RPAD (opi_org_bounds_rec.data_until, 25) ||
1297: RPAD (opi_org_bounds_rec.stop_reason, 20));

Line 1304: BIS_COLLECTION_UTILITIES.PUT_LINE (LPAD ('', 90, '-'));

1300:
1301:
1302: -- print table end
1303: l_stmt_id := 30;
1304: BIS_COLLECTION_UTILITIES.PUT_LINE (LPAD ('', 90, '-'));
1305:
1306: RETURN;
1307:
1308: EXCEPTION

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

1309:
1310: WHEN OTHERS THEN
1311: rollback;
1312:
1313: BIS_COLLECTION_UTILITIES.PUT_LINE (s_pkg_name || '.' ||
1314: l_proc_name || ' ' ||
1315: 'Error when printing org bounds.');
1316:
1317: RAISE; -- propagate exception to wrapper