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

Line 30: bis_collection_utilities.put_line('Initializing Tables:');

26: l_stmt_num := 10;
27: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema)
28: THEN
29:
30: bis_collection_utilities.put_line('Initializing Tables:');
31:
32: l_stmt_num := 10;
33: /* Truncating Staging Tables */
34: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_STG ';

Line 35: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_STG');

31:
32: l_stmt_num := 10;
33: /* Truncating Staging Tables */
34: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_STG ';
35: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_STG');
36:
37: l_stmt_num := 20;
38: /* Truncating Base Table */
39: DELETE FROM OPI_DBI_INV_VALUE_F WHERE source = 2;

Line 40: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_F');

36:
37: l_stmt_num := 20;
38: /* Truncating Base Table */
39: DELETE FROM OPI_DBI_INV_VALUE_F WHERE source = 2;
40: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_F');
41:
42: l_stmt_num := 30;
43: /* Truncating Log Table */
44: DELETE FROM OPI_DBI_INV_VALUE_LOG log

Line 46: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_LOG');

42: l_stmt_num := 30;
43: /* Truncating Log Table */
44: DELETE FROM OPI_DBI_INV_VALUE_LOG log
45: WHERE type IN ('GSL','OID');
46: bis_collection_utilities.put_line('... OPI_DBI_INV_VALUE_LOG');
47:
48: l_stmt_num := 40;
49: /* Truncating Conversion Rates Table */
50: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_CONVERSION_RATES ';

Line 51: bis_collection_utilities.put_line('... OPI_DBI_OPM_CONVERSION_RATES');

47:
48: l_stmt_num := 40;
49: /* Truncating Conversion Rates Table */
50: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_CONVERSION_RATES ';
51: bis_collection_utilities.put_line('... OPI_DBI_OPM_CONVERSION_RATES');
52:
53: l_stmt_num := 50;
54: /* Truncating OPM Inception Qtys */
55: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INCEPTION_QTY ';

Line 56: bis_collection_utilities.put_line('... OPI_DBI_OPM_INCEPTION_QTY');

52:
53: l_stmt_num := 50;
54: /* Truncating OPM Inception Qtys */
55: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INCEPTION_QTY ';
56: bis_collection_utilities.put_line('... OPI_DBI_OPM_INCEPTION_QTY');
57:
58: l_stmt_num := 60;
59: /* Truncating OPM Current Permanent Subledger Rows */
60: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_LED_CURRENT ';

Line 61: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_LED_CURRENT');

57:
58: l_stmt_num := 60;
59: /* Truncating OPM Current Permanent Subledger Rows */
60: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_LED_CURRENT ';
61: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_LED_CURRENT');
62:
63: l_stmt_num := 70;
64: /* Truncating OPM Current Test Subldger Rows */
65: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_TST_CURRENT ';

Line 66: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_TST_CURRENT');

62:
63: l_stmt_num := 70;
64: /* Truncating OPM Current Test Subldger Rows */
65: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_TST_CURRENT ';
66: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_TST_CURRENT');
67:
68: l_stmt_num := 80;
69: /* Truncating OPM Prior Test Subledger Rows */
70: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_TST_PRIOR ';

Line 71: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_TST_PRIOR');

67:
68: l_stmt_num := 80;
69: /* Truncating OPM Prior Test Subledger Rows */
70: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_INV_TST_PRIOR ';
71: bis_collection_utilities.put_line('... OPI_DBI_OPM_INV_TST_PRIOR');
72:
73: END IF;
74:
75: EXCEPTION

Line 82: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);

78: || to_char(l_stmt_num)
79: || '): '
80: || substr(SQLERRM, 1,200);
81:
82: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);
83:
84: RAISE;
85:
86: END Clean_OPM_Tables;

Line 145: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' company inception date rows created.');

141: WHERE
142: c.orgn_code = led.co_code
143: GROUP BY c.organization_id;
144:
145: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' company inception date rows created.');
146:
147: fnd_stats.gather_table_stats(
148: ownname => g_opi_schema,
149: tabname => 'OPI_DBI_INV_VALUE_LOG',

Line 161: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' l_min_inception_date values determined.');

157: SELECT MIN(transaction_date) INTO l_min_inception_date
158: FROM opi_dbi_inv_value_log
159: WHERE type = 'OID';
160:
161: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' l_min_inception_date values determined.');
162:
163: IF g_global_start_date > l_min_inception_date
164: THEN
165: bis_collection_utilities.put_line('Warning: The Global Start Date (' || TO_CHAR(g_global_start_date) ||

Line 165: bis_collection_utilities.put_line('Warning: The Global Start Date (' || TO_CHAR(g_global_start_date) ||

161: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' l_min_inception_date values determined.');
162:
163: IF g_global_start_date > l_min_inception_date
164: THEN
165: bis_collection_utilities.put_line('Warning: The Global Start Date (' || TO_CHAR(g_global_start_date) ||
166: ') is later than the earliest available transaction');
167: bis_collection_utilities.put_line('This means that you are not going to extract all ' ||
168: 'of the historic data that exists in your database.');
169: bis_collection_utilities.put_line('This affects the following OPM companies:');

Line 167: bis_collection_utilities.put_line('This means that you are not going to extract all ' ||

163: IF g_global_start_date > l_min_inception_date
164: THEN
165: bis_collection_utilities.put_line('Warning: The Global Start Date (' || TO_CHAR(g_global_start_date) ||
166: ') is later than the earliest available transaction');
167: bis_collection_utilities.put_line('This means that you are not going to extract all ' ||
168: 'of the historic data that exists in your database.');
169: bis_collection_utilities.put_line('This affects the following OPM companies:');
170: bis_collection_utilities.put_line(
171: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));

Line 169: bis_collection_utilities.put_line('This affects the following OPM companies:');

165: bis_collection_utilities.put_line('Warning: The Global Start Date (' || TO_CHAR(g_global_start_date) ||
166: ') is later than the earliest available transaction');
167: bis_collection_utilities.put_line('This means that you are not going to extract all ' ||
168: 'of the historic data that exists in your database.');
169: bis_collection_utilities.put_line('This affects the following OPM companies:');
170: bis_collection_utilities.put_line(
171: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));
172: bis_collection_utilities.put_line(
173: RPAD('Company',10) || ' ' || RPAD('Earliest Date', 15) || ' ' || 'Days Truncated');

Line 170: bis_collection_utilities.put_line(

166: ') is later than the earliest available transaction');
167: bis_collection_utilities.put_line('This means that you are not going to extract all ' ||
168: 'of the historic data that exists in your database.');
169: bis_collection_utilities.put_line('This affects the following OPM companies:');
170: bis_collection_utilities.put_line(
171: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));
172: bis_collection_utilities.put_line(
173: RPAD('Company',10) || ' ' || RPAD('Earliest Date', 15) || ' ' || 'Days Truncated');
174: bis_collection_utilities.put_line(

Line 172: bis_collection_utilities.put_line(

168: 'of the historic data that exists in your database.');
169: bis_collection_utilities.put_line('This affects the following OPM companies:');
170: bis_collection_utilities.put_line(
171: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));
172: bis_collection_utilities.put_line(
173: RPAD('Company',10) || ' ' || RPAD('Earliest Date', 15) || ' ' || 'Days Truncated');
174: bis_collection_utilities.put_line(
175: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));
176:

Line 174: bis_collection_utilities.put_line(

170: bis_collection_utilities.put_line(
171: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));
172: bis_collection_utilities.put_line(
173: RPAD('Company',10) || ' ' || RPAD('Earliest Date', 15) || ' ' || 'Days Truncated');
174: bis_collection_utilities.put_line(
175: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));
176:
177: FOR id IN inception_date_cursor
178: LOOP

Line 179: bis_collection_utilities.put_line(RPAD(id.co_code,11) ||

175: RPAD('-',10,'-') || ' ' || RPAD('-',15,'-') || ' ' || RPAD('-',15,'-'));
176:
177: FOR id IN inception_date_cursor
178: LOOP
179: bis_collection_utilities.put_line(RPAD(id.co_code,11) ||
180: RPAD(TO_CHAR(id.inception_date),16) ||
181: TO_CHAR(ROUND(g_global_start_date - id.inception_date))
182: );
183: END LOOP;

Line 190: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' inception dates shortened.');

186: SET transaction_date = g_global_start_date
187: WHERE type = 'OID'
188: AND g_global_start_date > transaction_date;
189:
190: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' inception dates shortened.');
191:
192: END IF;
193:
194: COMMIT;

Line 199: bis_collection_utilities.put_line ('Get_OPM_Inception_Date: '|| sqlerrm);

195:
196: EXCEPTION
197: WHEN OTHERS
198: THEN
199: bis_collection_utilities.put_line ('Get_OPM_Inception_Date: '|| sqlerrm);
200: RAISE;
201:
202: END Get_OPM_Inception_Date;
203:

Line 253: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Onhand Inception Quantity rows extracted.');

249: ) onh
250: GROUP BY item_id, whse_code
251: HAVING SUM(onhand_qty) <> 0;
252:
253: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Onhand Inception Quantity rows extracted.');
254:
255: EXCEPTION
256: WHEN OTHERS THEN
257:

Line 262: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance '

258: l_err_num := SQLCODE;
259: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance ('
260: || to_char(l_stmt_num) || '): ' || substr(SQLERRM, 1,200);
261:
262: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance '
263: || '- Error at statement (' || to_char(l_stmt_num) || ')');
264: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));
265: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);
266:

Line 264: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));

260: || to_char(l_stmt_num) || '): ' || substr(SQLERRM, 1,200);
261:
262: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance '
263: || '- Error at statement (' || to_char(l_stmt_num) || ')');
264: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));
265: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);
266:
267: RAISE_APPLICATION_ERROR(-20000, errbuf);
268:

Line 265: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);

261:
262: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance '
263: || '- Error at statement (' || to_char(l_stmt_num) || ')');
264: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));
265: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);
266:
267: RAISE_APPLICATION_ERROR(-20000, errbuf);
268:
269: END Get_OPM_Onhand_Balance;

Line 293: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' cost parameter rows inserted.');

289: AND c.orgn_code = o.co_code
290: AND id.type = 'OID'
291: AND id.organization_id = c.organization_id;
292:
293: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' cost parameter rows inserted.');
294:
295: opi_pmi_cost.get_cost;
296:
297: EXCEPTION

Line 300: bis_collection_utilities.put_line ('Cost_Inception_Quantities: '|| sqlerrm);

296:
297: EXCEPTION
298: WHEN OTHERS
299: THEN
300: bis_collection_utilities.put_line ('Cost_Inception_Quantities: '|| sqlerrm);
301: RAISE;
302:
303: END Cost_Inception_Quantities;
304:

Line 363: bis_collection_utilities.put_line(TO_CHAR(l_row_count) || ' Onhand and Intransit Inception Balances Costed.');

359: msi.primary_uom_code
360: ;
361:
362: l_row_count := sql%rowcount;
363: bis_collection_utilities.put_line(TO_CHAR(l_row_count) || ' Onhand and Intransit Inception Balances Costed.');
364:
365: -- SETUP/WRAPUP: take out wrapup api call, put log message here.
366: bis_collection_utilities.put_line('FINISHED Onhand Inception Balances SUCCESSFULLY');
367:

Line 366: bis_collection_utilities.put_line('FINISHED Onhand Inception Balances SUCCESSFULLY');

362: l_row_count := sql%rowcount;
363: bis_collection_utilities.put_line(TO_CHAR(l_row_count) || ' Onhand and Intransit Inception Balances Costed.');
364:
365: -- SETUP/WRAPUP: take out wrapup api call, put log message here.
366: bis_collection_utilities.put_line('FINISHED Onhand Inception Balances SUCCESSFULLY');
367:
368: COMMIT;
369:
370: EXCEPTION

Line 373: bis_collection_utilities.put_line ('Create_Inception_Balances: '|| sqlerrm);

369:
370: EXCEPTION
371: WHEN OTHERS
372: THEN
373: bis_collection_utilities.put_line ('Create_Inception_Balances: '|| sqlerrm);
374: RAISE;
375:
376: END Create_Inception_Balances;
377:

Line 697: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Intransit Inception Quantity rows extracted.');

693: ) tot_intransit
694: ) inception_intransit
695: GROUP BY whse, item;
696:
697: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' Intransit Inception Quantity rows extracted.');
698:
699: EXCEPTION
700:
701: WHEN OTHERS

Line 703: bis_collection_utilities.put_line (proc_name || sqlerrm);

699: EXCEPTION
700:
701: WHEN OTHERS
702: THEN
703: bis_collection_utilities.put_line (proc_name || sqlerrm);
704:
705: END Get_OPM_Intransit_Balance;
706:
707:

Line 794: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' WIP Inception Balances calculated.');

790: AND c.orgn_code = o.co_code
791: AND log.organization_id = c.organization_id
792: AND log.type= 'OID';
793:
794: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' WIP Inception Balances calculated.');
795:
796: COMMIT;
797:
798: EXCEPTION

Line 801: bis_collection_utilities.put_line ('Get_OPM_WIP_Balance: '|| sqlerrm);

797:
798: EXCEPTION
799: WHEN OTHERS
800: THEN
801: bis_collection_utilities.put_line ('Get_OPM_WIP_Balance: '|| sqlerrm);
802: RAISE;
803:
804: END Get_OPM_WIP_Balance;
805:

Line 837: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' high water mark log rows inserted.');

833: g_user_id,
834: g_login_id
835: );
836:
837: bis_collection_utilities.put_line(TO_CHAR(sql%rowcount) || ' high water mark log rows inserted.');
838:
839: fnd_stats.gather_table_stats(
840: ownname => g_opi_schema,
841: tabname => 'OPI_DBI_INV_VALUE_LOG',

Line 849: bis_collection_utilities.put_line ('Initialize_High_Water_Mark: '|| sqlerrm);

845:
846: EXCEPTION
847: WHEN OTHERS
848: THEN
849: bis_collection_utilities.put_line ('Initialize_High_Water_Mark: '|| sqlerrm);
850: RAISE;
851:
852: END Initialize_High_Water_Mark;
853:

Line 887: bis_collection_utilities.put_line('Error encounted in OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Inception_Inv_Balance');

883:
884: EXCEPTION
885: WHEN OTHERS THEN
886:
887: bis_collection_utilities.put_line('Error encounted in OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Inception_Inv_Balance');
888: bis_collection_utilities.put_line('Error Message: ' || SQLERRM);
889:
890: RAISE_APPLICATION_ERROR(-20000, errbuf);
891: /*please note that this api will commit!!*/

Line 888: bis_collection_utilities.put_line('Error Message: ' || SQLERRM);

884: EXCEPTION
885: WHEN OTHERS THEN
886:
887: bis_collection_utilities.put_line('Error encounted in OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Inception_Inv_Balance');
888: bis_collection_utilities.put_line('Error Message: ' || SQLERRM);
889:
890: RAISE_APPLICATION_ERROR(-20000, errbuf);
891: /*please note that this api will commit!!*/
892:

Line 911: bis_collection_utilities.put_line('< Starting Inception Balance Extraction >');

907:
908: IF (bis_common_parameters.check_global_parameters(l_list))
909: THEN
910: l_stmt_num := 10;
911: bis_collection_utilities.put_line('< Starting Inception Balance Extraction >');
912: --Get_OPM_Inception_Inv_Balance(errbuf, retcode);
913: bis_collection_utilities.put_line('');
914:
915: l_stmt_num := 20;

Line 913: bis_collection_utilities.put_line('');

909: THEN
910: l_stmt_num := 10;
911: bis_collection_utilities.put_line('< Starting Inception Balance Extraction >');
912: --Get_OPM_Inception_Inv_Balance(errbuf, retcode);
913: bis_collection_utilities.put_line('');
914:
915: l_stmt_num := 20;
916: bis_collection_utilities.put_line('< Starting Daily Activity Extraction >');
917: opi_dbi_inv_value_opm_incr_pkg.Extract_OPM_Daily_Activity(errbuf, retcode, g_inception_date);

Line 916: bis_collection_utilities.put_line('< Starting Daily Activity Extraction >');

912: --Get_OPM_Inception_Inv_Balance(errbuf, retcode);
913: bis_collection_utilities.put_line('');
914:
915: l_stmt_num := 20;
916: bis_collection_utilities.put_line('< Starting Daily Activity Extraction >');
917: opi_dbi_inv_value_opm_incr_pkg.Extract_OPM_Daily_Activity(errbuf, retcode, g_inception_date);
918: bis_collection_utilities.put_line(' 919: ELSE
920: retcode := 1;

Line 918: bis_collection_utilities.put_line('

914:
915: l_stmt_num := 20;
916: bis_collection_utilities.put_line('< Starting Daily Activity Extraction >');
917: opi_dbi_inv_value_opm_incr_pkg.Extract_OPM_Daily_Activity(errbuf, retcode, g_inception_date);
918: bis_collection_utilities.put_line(' 919: ELSE
920: retcode := 1;
921: bis_collection_utilities.put_line('Global Parameters are not setup.');
922: bis_collection_utilities.put_line('Please check that the profile options: ' ||

Line 921: bis_collection_utilities.put_line('Global Parameters are not setup.');

917: opi_dbi_inv_value_opm_incr_pkg.Extract_OPM_Daily_Activity(errbuf, retcode, g_inception_date);
918: bis_collection_utilities.put_line(' 919: ELSE
920: retcode := 1;
921: bis_collection_utilities.put_line('Global Parameters are not setup.');
922: bis_collection_utilities.put_line('Please check that the profile options: ' ||
923: 'BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
924: END IF;
925:

Line 922: bis_collection_utilities.put_line('Please check that the profile options: ' ||

918: bis_collection_utilities.put_line(' 919: ELSE
920: retcode := 1;
921: bis_collection_utilities.put_line('Global Parameters are not setup.');
922: bis_collection_utilities.put_line('Please check that the profile options: ' ||
923: 'BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
924: END IF;
925:
926: EXCEPTION

Line 935: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Run_OPM_First_ETL '

931: || to_char(l_stmt_num)
932: || '): '
933: || substr(SQLERRM, 1,200);
934:
935: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Run_OPM_First_ETL '
936: || '- Error at statement ('
937: || to_char(l_stmt_num)
938: || ')');
939:

Line 940: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));

936: || '- Error at statement ('
937: || to_char(l_stmt_num)
938: || ')');
939:
940: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));
941: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);
942:
943: END Run_OPM_First_ETL;
944:

Line 941: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);

937: || to_char(l_stmt_num)
938: || ')');
939:
940: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));
941: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);
942:
943: END Run_OPM_First_ETL;
944:
945: