APPS.OPI_DBI_JOBS_PKG dependencies on OPI_DBI_COMMON_MOD_INCR_PKG

Line 699: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN

695:
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;

Line 888: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN

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
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:

Line 1014: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN

1010:
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;

Line 1023: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN

1019:
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:

Line 1477: opi_dbi_common_mod_incr_pkg.run_common_module_incr(errbuf,l_ret_code);

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);
1478: retcode := to_char(l_ret_code);
1479:
1480: -- session parameters
1481: g_sysdate := SYSDATE;

Line 1537: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN

1533:
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:

Line 1572: --IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN

1568:
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:

Line 1600: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,1) = FALSE) THEN

1596:
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:

Line 1608: IF (opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(4,2) = FALSE) THEN

1604:
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: