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

Line 312: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

308: IF (invalid_rates_exist_csr%FOUND) THEN
309:
310: -- there are missing rates - prepare to report them.
311: no_currency_rate_flag := 1;
312: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
313:
314: l_stmt_num := 60;
315: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
316: LOOP

Line 318: BIS_COLLECTION_UTILITIES.writemissingrate (

314: l_stmt_num := 60;
315: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
316: LOOP
317:
318: BIS_COLLECTION_UTILITIES.writemissingrate (
319: get_missing_rates_rec.rate_type,
320: get_missing_rates_rec.func_currency_code,
321: get_missing_rates_rec.curr_code,
322: get_missing_rates_rec.completion_date);

Line 332: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');

328:
329:
330: l_stmt_num := 70; /* check no_currency_rate_flag */
331: IF (no_currency_rate_flag = 1) THEN /* missing rate found */
332: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');
333:
334: retcode := g_error;
335: END IF;
336:

Line 348: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOBS_PKG.GET_CONVERSION_RATE - Error at statement ('

344: || to_char(l_stmt_num)
345: || '): '
346: || substr(SQLERRM, 1,200);
347:
348: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOBS_PKG.GET_CONVERSION_RATE - Error at statement ('
349: || to_char(l_stmt_num)
350: || ')');
351:
352: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

Line 352: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

348: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOBS_PKG.GET_CONVERSION_RATE - Error at statement ('
349: || to_char(l_stmt_num)
350: || ')');
351:
352: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
353: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
354:
355: retcode := g_error;
356: return g_error;

Line 353: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);

349: || to_char(l_stmt_num)
350: || ')');
351:
352: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
353: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
354:
355: retcode := g_error;
356: return g_error;
357:

Line 624: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);

620:
621: BEGIN
622:
623: l_proc_name := 'OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD';
624: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
625:
626: l_stmt_num := 2;
627: --Calling Common Module Log
628: opi_dbi_common_mod_init_pkg.run_common_module_init(errbuf,l_ret_code);

Line 646: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = FALSE THEN

642: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';
643:
644: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
645:
646: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = FALSE THEN
647: RAISE_APPLICATION_ERROR(-20000, errbuf);
648: END IF;
649:
650: l_stmt_num := 8;

Line 690: 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.');

686: g_secondary_rate_type IS NOT NULL)
687: OR (g_secondary_currency_code IS NOT NULL AND
688: g_secondary_rate_type IS NULL) ) THEN
689:
690: 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.');
691:
692: RAISE_APPLICATION_ERROR(-20000, errbuf);
693:
694: END IF;

Line 700: -- BIS_COLLECTION_UTILITIES.put_line(

696: --l_stmt_num := 14;
697: -- Store current sysdate as the Last Collection Date.
698: -- This one for OPI, and a later one for OPM
699: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN
700: -- BIS_COLLECTION_UTILITIES.put_line(
701: -- 'Failed to store current sysdate as the Last Collection Date.');
702: -- RAISE_APPLICATION_ERROR(-20000, errbuf);
703: --END IF;
704:

Line 884: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI Jobs Extraction into Staging Table: '|| l_row_count || ' rows inserted');

880:
881: l_row_count := sql%rowcount;
882: commit;
883:
884: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI Jobs Extraction into Staging Table: '|| l_row_count || ' rows inserted');
885:
886: -- Store current sysdate as the Last Collection Date.
887: -- This one for OPM, and an earlier one for OPI
888: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN

Line 889: -- BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');

885:
886: -- Store current sysdate as the Last Collection Date.
887: -- This one for OPM, and an earlier one for OPI
888: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN
889: -- BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');
890: -- RAISE_APPLICATION_ERROR(-20000, errbuf);
891: --END IF;
892:
893: /********* OPM Insert *********************************/

Line 990: BIS_COLLECTION_UTILITIES.PUT_LINE(

986:
987: l_row_count := sql%rowcount;
988: commit;
989:
990: BIS_COLLECTION_UTILITIES.PUT_LINE(
991: 'Finished OPM Jobs Extraction into Staging Table: '||
992: l_row_count || ' rows inserted');
993:
994: l_stmt_num := 20;

Line 996: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');

992: l_row_count || ' rows inserted');
993:
994: l_stmt_num := 20;
995: IF (Get_Conversion_Rate (errbuf, retcode) = -1) THEN
996: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
997: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
998: retcode := g_error;
999: return;
1000: END IF;

Line 997: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');

993:
994: l_stmt_num := 20;
995: IF (Get_Conversion_Rate (errbuf, retcode) = -1) THEN
996: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
997: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
998: retcode := g_error;
999: return;
1000: END IF;
1001:

Line 1006: BIS_COLLECTION_UTILITIES.PUT_LINE(

1002: l_stmt_num := 30;
1003: /* Once Conversion Rates process finishes successfully,
1004: Merge Conversion Rates and Jobs Staging table into Jobs Fact */
1005: l_row_count := Insert_into_Jobs_Fact;
1006: BIS_COLLECTION_UTILITIES.PUT_LINE(
1007: 'Finished Jobs Extraction into Fact Table: '||
1008: l_row_count || ' rows inserted');
1009:
1010:

Line 1015: BIS_COLLECTION_UTILITIES.put_line(

1011: l_stmt_num := 35;
1012: --Store current sysdate as the Last Collection Date.
1013: --This one for OPI, and a later one for OPM
1014: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN
1015: BIS_COLLECTION_UTILITIES.put_line(
1016: 'Failed to store current sysdate as the Last Collection Date.');
1017: RAISE_APPLICATION_ERROR(-20000, errbuf);
1018: END IF;
1019:

Line 1024: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');

1020: l_stmt_num := 40;
1021: -- Store current sysdate as the Last Collection Date.
1022: -- This one for OPM, and an earlier one for OPI
1023: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN
1024: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');
1025: RAISE_APPLICATION_ERROR(-20000, errbuf);
1026: END IF;
1027:
1028: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1028: BIS_COLLECTION_UTILITIES.WRAPUP(

1024: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');
1025: RAISE_APPLICATION_ERROR(-20000, errbuf);
1026: END IF;
1027:
1028: BIS_COLLECTION_UTILITIES.WRAPUP(
1029: p_status => TRUE,
1030: p_count => l_row_count,
1031: p_message => 'Successfully loaded Jobs master table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
1032: );

Line 1034: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);

1030: p_count => l_row_count,
1031: p_message => 'Successfully loaded Jobs master table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
1032: );
1033:
1034: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1035:
1036: ELSE
1037: retcode := g_error;
1038: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

Line 1038: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

1034: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1035:
1036: ELSE
1037: retcode := g_error;
1038: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1039: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_PRIMARY_RATE_TYPE and BIS_GLOBAL_START_DATE are setup.');
1040: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1041:
1042: END IF;

Line 1039: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_PRIMARY_RATE_TYPE and BIS_GLOBAL_START_DATE are setup.');

1035:
1036: ELSE
1037: retcode := g_error;
1038: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1039: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_PRIMARY_RATE_TYPE and BIS_GLOBAL_START_DATE are setup.');
1040: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1041:
1042: END IF;
1043:

Line 1040: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);

1036: ELSE
1037: retcode := g_error;
1038: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1039: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE, BIS_PRIMARY_RATE_TYPE and BIS_GLOBAL_START_DATE are setup.');
1040: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1041:
1042: END IF;
1043:
1044: EXCEPTION

Line 1054: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD - Error at statement ('

1050: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD ('
1051: || to_char(l_stmt_num)
1052: || '): '
1053: || substr(SQLERRM, 1,200);
1054: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD - Error at statement ('
1055: || to_char(l_stmt_num)
1056: || ')');
1057: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1058: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1057: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

1053: || substr(SQLERRM, 1,200);
1054: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD - Error at statement ('
1055: || to_char(l_stmt_num)
1056: || ')');
1057: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1058: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1059: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,
1060: l_row_count,
1061: 'EXCEPTION '|| l_err_num||' : '||l_err_msg

Line 1058: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

1054: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INITIAL_LOAD - Error at statement ('
1055: || to_char(l_stmt_num)
1056: || ')');
1057: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1058: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1059: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,
1060: l_row_count,
1061: 'EXCEPTION '|| l_err_num||' : '||l_err_msg
1062: );

Line 1059: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,

1055: || to_char(l_stmt_num)
1056: || ')');
1057: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1058: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1059: BIS_COLLECTION_UTILITIES.WRAPUP(FALSE,
1060: l_row_count,
1061: 'EXCEPTION '|| l_err_num||' : '||l_err_msg
1062: );
1063: retcode := SQLCODE;

Line 1273: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI Jobs Extraction into Staging Table: '|| l_row_count || ' rows inserted');

1269:
1270: l_row_count := sql%rowcount;
1271: commit;
1272:
1273: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI Jobs Extraction into Staging Table: '|| l_row_count || ' rows inserted');
1274:
1275:
1276: EXCEPTION
1277: WHEN OTHERS THEN

Line 1285: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD - Error at statement ('

1281: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD ('
1282: || to_char(l_stmt_num)
1283: || '): '
1284: || substr(SQLERRM, 1,200);
1285: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD - Error at statement ('
1286: || to_char(l_stmt_num)
1287: || ')');
1288: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1289: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1288: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

1284: || substr(SQLERRM, 1,200);
1285: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD - Error at statement ('
1286: || to_char(l_stmt_num)
1287: || ')');
1288: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1289: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1290: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1291:
1292: retcode := SQLCODE;

Line 1289: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

1285: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPI_JOBS_INCR_LOAD - Error at statement ('
1286: || to_char(l_stmt_num)
1287: || ')');
1288: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1289: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1290: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1291:
1292: retcode := SQLCODE;
1293: errbuf := SQLERRM;

Line 1290: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );

1286: || to_char(l_stmt_num)
1287: || ')');
1288: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1289: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1290: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1291:
1292: retcode := SQLCODE;
1293: errbuf := SQLERRM;
1294:

Line 1432: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPM Jobs Extraction into Staging Table: '|| l_row_count || ' rows inserted');

1428:
1429: l_row_count := sql%rowcount;
1430: commit;
1431:
1432: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPM Jobs Extraction into Staging Table: '|| l_row_count || ' rows inserted');
1433:
1434: EXCEPTION
1435: WHEN OTHERS THEN
1436: rollback;

Line 1443: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD - Error at statement ('

1439: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD ('
1440: || to_char(l_stmt_num)
1441: || '): '
1442: || substr(SQLERRM, 1,200);
1443: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD - Error at statement ('
1444: || to_char(l_stmt_num)
1445: || ')');
1446: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1446: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

1442: || substr(SQLERRM, 1,200);
1443: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD - Error at statement ('
1444: || to_char(l_stmt_num)
1445: || ')');
1446: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1448: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1449:
1450: retcode := SQLCODE;

Line 1447: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

1443: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_OPM_JOBS_INCR_LOAD - Error at statement ('
1444: || to_char(l_stmt_num)
1445: || ')');
1446: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1448: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1449:
1450: retcode := SQLCODE;
1451: errbuf := SQLERRM;

Line 1448: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );

1444: || to_char(l_stmt_num)
1445: || ')');
1446: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1447: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1448: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1449:
1450: retcode := SQLCODE;
1451: errbuf := SQLERRM;
1452:

Line 1473: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);

1469: l_list dbms_sql.varchar2_table;
1470: BEGIN
1471:
1472: l_proc_name := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD';
1473: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1474:
1475: l_stmt_num := 2;
1476: --Calling Common Module Log
1477: opi_dbi_common_mod_incr_pkg.run_common_module_incr(errbuf,l_ret_code);

Line 1491: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = false then

1487: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';
1488:
1489: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
1490:
1491: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_JOBS_F' ) = false then
1492: RAISE_APPLICATION_ERROR(-20000, errbuf);
1493: END IF;
1494:
1495: l_stmt_num := 10;

Line 1515: 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.');

1511: g_secondary_rate_type IS NOT NULL)
1512: OR (g_secondary_currency_code IS NOT NULL AND
1513: g_secondary_rate_type IS NULL) ) THEN
1514:
1515: 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.');
1516:
1517: RAISE_APPLICATION_ERROR(-20000, errbuf);
1518:
1519: END IF;

Line 1527: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');

1523: SELECT LAST_COLLECTION_DATE INTO g_last_collection_date FROM OPI_DBI_RUN_LOG_CURR
1524: WHERE ETL_ID = 4 AND SOURCE = 1;
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN
1527: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');
1528: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
1529: retcode := SQLCODE;
1530: errbuf := SQLERRM;
1531: return;

Line 1528: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

1524: WHERE ETL_ID = 4 AND SOURCE = 1;
1525: EXCEPTION
1526: WHEN NO_DATA_FOUND THEN
1527: BIS_COLLECTION_UTILITIES.put_line('Last collection date is not available. Cannot proceed.');
1528: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
1529: retcode := SQLCODE;
1530: errbuf := SQLERRM;
1531: return;
1532: END;

Line 1538: -- BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');

1534: --l_stmt_num := 30;
1535: -- Store current sysdate as the Last Collection Date.
1536: -- This one for OPI, and a later one for OPM
1537: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN
1538: -- BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');
1539: -- RAISE_APPLICATION_ERROR(-20000, errbuf);
1540: --END IF;
1541:
1542: l_stmt_num := 35;

Line 1562: BIS_COLLECTION_UTILITIES.put_line('Process Manufacturing Last collection date is not available. Cannot proceed.');

1558: SELECT LAST_COLLECTION_DATE INTO g_opm_last_collection_date FROM OPI_DBI_RUN_LOG_CURR
1559: WHERE ETL_ID = 4 AND SOURCE = 2;
1560: EXCEPTION
1561: WHEN NO_DATA_FOUND THEN
1562: BIS_COLLECTION_UTILITIES.put_line('Process Manufacturing Last collection date is not available. Cannot proceed.');
1563: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
1564: retcode := SQLCODE;
1565: errbuf := SQLERRM;
1566: return;

Line 1563: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

1559: WHERE ETL_ID = 4 AND SOURCE = 2;
1560: EXCEPTION
1561: WHEN NO_DATA_FOUND THEN
1562: BIS_COLLECTION_UTILITIES.put_line('Process Manufacturing Last collection date is not available. Cannot proceed.');
1563: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
1564: retcode := SQLCODE;
1565: errbuf := SQLERRM;
1566: return;
1567: END;

Line 1573: -- BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');

1569: --l_stmt_num := 47;
1570: -- Store current sysdate as the Last Collection Date.
1571: -- This one for OPM, and an earlier one for OPI
1572: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN
1573: -- BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');
1574: -- RAISE_APPLICATION_ERROR(-20000, errbuf);
1575: --END IF;
1576:
1577: GET_OPM_JOBS_INCR_LOAD(errbuf, retcode);

Line 1582: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');

1578:
1579:
1580: l_stmt_num := 50;
1581: IF (Get_Conversion_Rate (errbuf, retcode) = -1) THEN
1582: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
1583: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
1584: retcode := g_error;
1585: return;
1586: END IF;

Line 1583: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');

1579:
1580: l_stmt_num := 50;
1581: IF (Get_Conversion_Rate (errbuf, retcode) = -1) THEN
1582: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
1583: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
1584: retcode := g_error;
1585: return;
1586: END IF;
1587:

Line 1593: BIS_COLLECTION_UTILITIES.PUT_LINE(

1589: l_stmt_num := 60;
1590: /* Once Conversion Rates process finishes successfully,
1591: Merge Conversion Rates and Jobs Staging table into Jobs Fact */
1592: l_row_count := Merge_into_Jobs_Fact;
1593: BIS_COLLECTION_UTILITIES.PUT_LINE(
1594: 'Finished Jobs Extraction into Fact Table: '||
1595: l_row_count || ' rows inserted/updated');
1596:
1597: l_stmt_num := 65;

Line 1601: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');

1597: l_stmt_num := 65;
1598: -- Store current sysdate as the Last Collection Date.
1599: -- This one for OPI, and a later one for OPM
1600: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN
1601: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Last Collection Date.');
1602: RAISE_APPLICATION_ERROR(-20000, errbuf);
1603: END IF;
1604:
1605: l_stmt_num := 70;

Line 1609: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');

1605: l_stmt_num := 70;
1606: -- Store current sysdate as the Last Collection Date.
1607: -- This one for OPM, and an earlier one for OPI
1608: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN
1609: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');
1610: RAISE_APPLICATION_ERROR(-20000, errbuf);
1611: END IF;
1612:
1613: BIS_COLLECTION_UTILITIES.WRAPUP(

Line 1613: BIS_COLLECTION_UTILITIES.WRAPUP(

1609: BIS_COLLECTION_UTILITIES.put_line('Failed to store current sysdate as the Process Manufacturing Last Collection Date.');
1610: RAISE_APPLICATION_ERROR(-20000, errbuf);
1611: END IF;
1612:
1613: BIS_COLLECTION_UTILITIES.WRAPUP(
1614: p_status => TRUE,
1615: p_count => l_row_count,
1616: p_message => 'Successfully loaded Jobs master table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
1617: );

Line 1619: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);

1615: p_count => l_row_count,
1616: p_message => 'Successfully loaded Jobs master table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
1617: );
1618:
1619: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1620:
1621: ELSE
1622: retcode := g_error;
1623: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

Line 1623: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

1619: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1620:
1621: ELSE
1622: retcode := g_error;
1623: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1624: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
1625: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1626:
1627: END IF;

Line 1624: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');

1620:
1621: ELSE
1622: retcode := g_error;
1623: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1624: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
1625: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1626:
1627: END IF;
1628:

Line 1625: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);

1621: ELSE
1622: retcode := g_error;
1623: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1624: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile options: BIS_PRIMARY_CURRENCY_CODE and BIS_GLOBAL_START_DATE are setup.');
1625: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1626:
1627: END IF;
1628:
1629: EXCEPTION

Line 1638: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD - Error at statement ('

1634: l_err_msg := 'OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD ('
1635: || to_char(l_stmt_num)
1636: || '): '
1637: || substr(SQLERRM, 1,200);
1638: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD - Error at statement ('
1639: || to_char(l_stmt_num)
1640: || ')');
1641: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

Line 1641: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

1637: || substr(SQLERRM, 1,200);
1638: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD - Error at statement ('
1639: || to_char(l_stmt_num)
1640: || ')');
1641: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1643: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1644:
1645: retcode := SQLCODE;

Line 1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

1638: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.GET_JOBS_INCR_LOAD - Error at statement ('
1639: || to_char(l_stmt_num)
1640: || ')');
1641: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1643: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1644:
1645: retcode := SQLCODE;
1646: errbuf := SQLERRM;

Line 1643: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );

1639: || to_char(l_stmt_num)
1640: || ')');
1641: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1642: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1643: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1644:
1645: retcode := SQLCODE;
1646: errbuf := SQLERRM;
1647: RAISE_APPLICATION_ERROR(-20000, errbuf);

Line 1753: BIS_COLLECTION_UTILITIES.PUT_LINE('MV over Jobs Fact Refresh finished ...');

1749: 0, -- HEAP_SIZE
1750: FALSE -- ATOMIC_REFRESH
1751: );
1752:
1753: BIS_COLLECTION_UTILITIES.PUT_LINE('MV over Jobs Fact Refresh finished ...');
1754:
1755: EXCEPTION
1756: WHEN OTHERS THEN
1757:

Line 1764: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.REFRESH_MV - Error at statement ('

1760: || to_char(l_stmt_num)
1761: || '): '
1762: || substr(SQLERRM, 1,200);
1763:
1764: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.REFRESH_MV - Error at statement ('
1765: || to_char(l_stmt_num)
1766: || ')');
1767:
1768: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

Line 1768: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

1764: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOBS_PKG.REFRESH_MV - Error at statement ('
1765: || to_char(l_stmt_num)
1766: || ')');
1767:
1768: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1769: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1770:
1771: RAISE_APPLICATION_ERROR(-20000, errbuf);
1772: /*please note that this api will commit!!*/

Line 1769: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

1765: || to_char(l_stmt_num)
1766: || ')');
1767:
1768: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1769: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1770:
1771: RAISE_APPLICATION_ERROR(-20000, errbuf);
1772: /*please note that this api will commit!!*/
1773: