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

Line 256: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

252: IF (invalid_rates_exist_csr%FOUND) THEN
253: --{
254: -- there are missing rates - prepare to report them.
255: no_currency_rate_flag := 1;
256: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
257:
258: l_stmt_num := 60;
259: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
260: LOOP

Line 262: BIS_COLLECTION_UTILITIES.writemissingrate (

258: l_stmt_num := 60;
259: FOR get_missing_rates_rec IN get_missing_rates_c (l_pri_sec_curr_same)
260: LOOP
261:
262: BIS_COLLECTION_UTILITIES.writemissingrate (
263: get_missing_rates_rec.rate_type,
264: get_missing_rates_rec.func_currency_code,
265: get_missing_rates_rec.curr_code,
266: get_missing_rates_rec.transaction_date);

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

274:
275: l_stmt_num := 70; /* check no_currency_rate_flag */
276: IF (no_currency_rate_flag = 1) THEN /* missing rate found */
277: --{
278: bis_collection_utilities.put_line('ERROR: Please setup conversion rate for all missing rates reported');
279:
280: retcode := g_error;
281: --}
282: END IF;

Line 295: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_CRATES - Error at statement ('

291: || to_char(l_stmt_num)
292: || '): '
293: || substr(SQLERRM, 1,200);
294:
295: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_CRATES - Error at statement ('
296: || to_char(l_stmt_num)
297: || ')');
298:
299: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

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

295: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_CRATES - Error at statement ('
296: || to_char(l_stmt_num)
297: || ')');
298:
299: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
300: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
301:
302: retcode := g_error;
303: return g_error;

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

296: || to_char(l_stmt_num)
297: || ')');
298:
299: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
300: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
301:
302: retcode := g_error;
303: return g_error;
304:

Line 378: BIS_COLLECTION_UTILITIES.PUT_LINE('Refresh of Base Materialized View finished ...');

374: method => p_method,
375: parallelism => 0);
376:
377:
378: BIS_COLLECTION_UTILITIES.PUT_LINE('Refresh of Base Materialized View finished ...');
379:
380:
381: EXCEPTION
382: WHEN OTHERS THEN

Line 390: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_BASE_MV - Error at statement ('

386: || to_char(l_stmt_num)
387: || '): '
388: || substr(SQLERRM, 1,200);
389:
390: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_BASE_MV - Error at statement ('
391: || to_char(l_stmt_num)
392: || ')');
393:
394: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

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

390: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_BASE_MV - Error at statement ('
391: || to_char(l_stmt_num)
392: || ')');
393:
394: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
395: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
396:
397: RAISE_APPLICATION_ERROR(-20000, errbuf);
398:

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

391: || to_char(l_stmt_num)
392: || ')');
393:
394: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
395: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
396:
397: RAISE_APPLICATION_ERROR(-20000, errbuf);
398:
399: END REFRESH_BASE_MV;

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

422: BEGIN
423:
424: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MMT_STG';
425:
426: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
427:
428: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load Start Time - ' ||
429: TO_CHAR(SYSDATE, 'hh24:mi:ss'));
430:

Line 428: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load Start Time - ' ||

424: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MMT_STG';
425:
426: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
427:
428: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load Start Time - ' ||
429: TO_CHAR(SYSDATE, 'hh24:mi:ss'));
430:
431: /* Insert MMT data into staging */
432: l_stmt_num := 20;

Line 533: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load End Time - ' ||

529: l_row_count := sql%rowcount;
530:
531: commit;
532:
533: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load End Time - ' ||
534: TO_CHAR(SYSDATE, 'hh24:mi:ss'));
535: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MMT Staging Table: '|| l_row_count || ' rows inserted');
536: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
537:

Line 535: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MMT Staging Table: '|| l_row_count || ' rows inserted');

531: commit;
532:
533: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load End Time - ' ||
534: TO_CHAR(SYSDATE, 'hh24:mi:ss'));
535: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MMT Staging Table: '|| l_row_count || ' rows inserted');
536: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
537:
538: EXCEPTION
539:

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

532:
533: BIS_COLLECTION_UTILITIES.PUT_LINE('Extracting MMT Staging Load End Time - ' ||
534: TO_CHAR(SYSDATE, 'hh24:mi:ss'));
535: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MMT Staging Table: '|| l_row_count || ' rows inserted');
536: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
537:
538: EXCEPTION
539:
540: WHEN OTHERS THEN

Line 542: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

538: EXCEPTION
539:
540: WHEN OTHERS THEN
541:
542: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
543:
544: retcode := SQLCODE;
545: errbuf := SQLERRM;
546:

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

569: BEGIN
570:
571: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_ODM_INIT';
572:
573: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
574:
575: /* Insert ODM data into Staging */
576: /* mta and mmta are joined to give the transaction value and mmt gives the transaction value */
577: l_stmt_num := 20;

Line 775: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM Txn Staging Table: '|| l_row_count || ' rows inserted');

771: l_row_count := sql%rowcount;
772:
773: commit;
774:
775: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM Txn Staging Table: '|| l_row_count || ' rows inserted');
776: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
777:
778:
779: EXCEPTION

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

772:
773: commit;
774:
775: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM Txn Staging Table: '|| l_row_count || ' rows inserted');
776: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
777:
778:
779: EXCEPTION
780:

Line 783: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

779: EXCEPTION
780:
781: WHEN OTHERS THEN
782:
783: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
784:
785: retcode := SQLCODE;
786: errbuf := SQLERRM;
787:

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

810: BEGIN
811:
812: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_ODM_INCR';
813:
814: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
815:
816: /* Insert ODM data into Staging*/
817: /* mta and mmta are joined to give the transaction value and mmt gives the transaction value */
818: l_stmt_num := 20;

Line 1016: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM Txn Staging Table: '|| l_row_count || ' rows inserted');

1012: l_row_count := sql%rowcount;
1013:
1014: commit;
1015:
1016: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM Txn Staging Table: '|| l_row_count || ' rows inserted');
1017: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1018:
1019: EXCEPTION
1020:

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

1013:
1014: commit;
1015:
1016: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM Txn Staging Table: '|| l_row_count || ' rows inserted');
1017: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1018:
1019: EXCEPTION
1020:
1021: WHEN OTHERS THEN

Line 1023: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

1019: EXCEPTION
1020:
1021: WHEN OTHERS THEN
1022:
1023: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
1024:
1025: retcode := SQLCODE;
1026: errbuf := SQLERRM;
1027:

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

1062: BEGIN
1063:
1064: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_OPM_INIT';
1065:
1066: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1067:
1068: l_stmt_num := 10;
1069: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1070: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

Line 1230: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Txn Staging Table: '|| l_row_count || ' rows inserted');

1226: l_row_count := sql%rowcount;
1227:
1228: commit;
1229:
1230: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Txn Staging Table: '|| l_row_count || ' rows inserted');
1231: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1232:
1233: EXCEPTION
1234:

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

1227:
1228: commit;
1229:
1230: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Txn Staging Table: '|| l_row_count || ' rows inserted');
1231: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1232:
1233: EXCEPTION
1234:
1235: WHEN NO_DATA_FOUND THEN

Line 1237: BIS_COLLECTION_UTILITIES.PUT_LINE ('No rows in Log Table, Run Initial Load again');

1233: EXCEPTION
1234:
1235: WHEN NO_DATA_FOUND THEN
1236:
1237: BIS_COLLECTION_UTILITIES.PUT_LINE ('No rows in Log Table, Run Initial Load again');
1238: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
1239: retcode := SQLCODE;
1240: errbuf := SQLERRM;
1241:

Line 1238: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

1234:
1235: WHEN NO_DATA_FOUND THEN
1236:
1237: BIS_COLLECTION_UTILITIES.PUT_LINE ('No rows in Log Table, Run Initial Load again');
1238: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
1239: retcode := SQLCODE;
1240: errbuf := SQLERRM;
1241:
1242: WHEN OTHERS THEN

Line 1244: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

1240: errbuf := SQLERRM;
1241:
1242: WHEN OTHERS THEN
1243:
1244: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
1245:
1246: retcode := SQLCODE;
1247: errbuf := SQLERRM;
1248:

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

1283: BEGIN
1284:
1285: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_OPM_INCR';
1286:
1287: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1288:
1289: l_stmt_num := 10;
1290: OPEN OPI_DBI_RUN_LOG_CURR_CSR;
1291: FETCH OPI_DBI_RUN_LOG_CURR_CSR INTO l_from_date,l_to_date;

Line 1451: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Txn Staging Table: '|| l_row_count || ' rows inserted');

1447: l_row_count := sql%rowcount;
1448:
1449: commit;
1450:
1451: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Txn Staging Table: '|| l_row_count || ' rows inserted');
1452: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1453:
1454: EXCEPTION
1455:

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

1448:
1449: commit;
1450:
1451: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Txn Staging Table: '|| l_row_count || ' rows inserted');
1452: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1453:
1454: EXCEPTION
1455:
1456: WHEN OTHERS THEN

Line 1458: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

1454: EXCEPTION
1455:
1456: WHEN OTHERS THEN
1457:
1458: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
1459:
1460: retcode := SQLCODE;
1461: errbuf := SQLERRM;
1462:

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

1485: BEGIN
1486:
1487: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_PR12OPM_INIT';
1488:
1489: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1490:
1491: /* Inserting Pre R12 OPM MU Actuals to Jobs Transaction Staging */
1492: l_stmt_num := 10;
1493: INSERT

Line 1735: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction Pre R12 OPM to Jobs Txn Staging: '|| l_row_count || ' rows inserted');

1731: l_row_count := sql%rowcount;
1732:
1733: commit;
1734:
1735: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction Pre R12 OPM to Jobs Txn Staging: '|| l_row_count || ' rows inserted');
1736: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1737:
1738: EXCEPTION
1739:

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

1732:
1733: commit;
1734:
1735: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction Pre R12 OPM to Jobs Txn Staging: '|| l_row_count || ' rows inserted');
1736: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1737:
1738: EXCEPTION
1739:
1740: WHEN OTHERS THEN

Line 1742: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

1738: EXCEPTION
1739:
1740: WHEN OTHERS THEN
1741:
1742: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
1743:
1744: retcode := SQLCODE;
1745: errbuf := SQLERRM;
1746:

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

1769: BEGIN
1770:
1771: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_MTL_USAGE_ACT_INIT';
1772:
1773: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1774:
1775: /* Extraction of MTL Usage Actuals fact */
1776: l_stmt_num := 20;
1777: INSERT

Line 1858: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MTL USAGE ACTUALS Table: '|| l_row_count || ' rows inserted');

1854: source;
1855:
1856: l_row_count := sql%rowcount;
1857:
1858: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MTL USAGE ACTUALS Table: '|| l_row_count || ' rows inserted');
1859: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1860:
1861: EXCEPTION
1862:

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

1855:
1856: l_row_count := sql%rowcount;
1857:
1858: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MTL USAGE ACTUALS Table: '|| l_row_count || ' rows inserted');
1859: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1860:
1861: EXCEPTION
1862:
1863: WHEN OTHERS THEN

Line 1867: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

1863: WHEN OTHERS THEN
1864:
1865: rollback;
1866:
1867: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
1868:
1869: retcode := SQLCODE;
1870: errbuf := SQLERRM;
1871:

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

1894: BEGIN
1895:
1896: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_MTL_USAGE_ACT_INCR';
1897:
1898: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1899:
1900: /* Extraction of MTL Usage Actuals fact */
1901: l_stmt_num := 20;
1902: MERGE

Line 2048: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MTL USAGE ACTUALS Table: '|| l_row_count || ' rows inserted/updated');

2044: );
2045:
2046: l_row_count := sql%rowcount;
2047:
2048: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MTL USAGE ACTUALS Table: '|| l_row_count || ' rows inserted/updated');
2049: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2050:
2051:
2052: EXCEPTION

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

2045:
2046: l_row_count := sql%rowcount;
2047:
2048: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of MTL USAGE ACTUALS Table: '|| l_row_count || ' rows inserted/updated');
2049: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2050:
2051:
2052: EXCEPTION
2053:

Line 2058: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

2054: WHEN OTHERS THEN
2055:
2056: rollback;
2057:
2058: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
2059:
2060: retcode := SQLCODE;
2061: errbuf := SQLERRM;
2062:

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

2085: BEGIN
2086:
2087: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_ODM_MTL_USAGE_STD_INIT';
2088:
2089: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2090:
2091: /* ODM insert into temp table */
2092: l_stmt_num := 20;
2093: INSERT

Line 2276: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');

2272: tmp.job_type = actuals.job_type;
2273:
2274: l_row_count := sql%rowcount;
2275:
2276: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2277: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2278:
2279: EXCEPTION
2280:

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

2273:
2274: l_row_count := sql%rowcount;
2275:
2276: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2277: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2278:
2279: EXCEPTION
2280:
2281: WHEN OTHERS THEN

Line 2285: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

2281: WHEN OTHERS THEN
2282:
2283: rollback;
2284:
2285: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
2286:
2287: retcode := SQLCODE;
2288: errbuf := SQLERRM;
2289:

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

2312: BEGIN
2313:
2314: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_ODM_MTL_USAGE_STD_INCR';
2315:
2316: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2317:
2318: /* ODM insert into temp table */
2319: l_stmt_num := 20;
2320: INSERT

Line 2549: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');

2545: );
2546:
2547: l_row_count := sql%rowcount;
2548:
2549: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2550: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2551:
2552: EXCEPTION
2553:

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

2546:
2547: l_row_count := sql%rowcount;
2548:
2549: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of ODM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2550: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2551:
2552: EXCEPTION
2553:
2554: WHEN OTHERS THEN

Line 2558: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

2554: WHEN OTHERS THEN
2555:
2556: rollback;
2557:
2558: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
2559:
2560: retcode := SQLCODE;
2561: errbuf := SQLERRM;
2562:

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

2585: BEGIN
2586:
2587: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_OPM_MTL_USAGE_STD_INIT';
2588:
2589: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2590:
2591: /* OPM Standards insert into fact table */
2592: /* Actuals fact which is at transaction date level is summarised and joined with the
2593: scaled mtl table, standard value is calculated as actual-value* std_qty/actual_qty */

Line 2685: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');

2681: actuals.source;
2682:
2683: l_row_count := sql%rowcount;
2684:
2685: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2686: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2687:
2688: EXCEPTION
2689:

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

2682:
2683: l_row_count := sql%rowcount;
2684:
2685: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2686: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2687:
2688: EXCEPTION
2689:
2690: WHEN OTHERS THEN

Line 2694: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

2690: WHEN OTHERS THEN
2691:
2692: rollback;
2693:
2694: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
2695:
2696: retcode := SQLCODE;
2697: errbuf := SQLERRM;
2698:

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

2721: BEGIN
2722:
2723: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_OPM_MTL_USAGE_STD_INCR';
2724:
2725: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2726:
2727: /* OPM Standards insert into fact table */
2728: l_stmt_num := 40;
2729: MERGE

Line 2860: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');

2856: );
2857:
2858: l_row_count := sql%rowcount;
2859:
2860: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2861: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2862:
2863: EXCEPTION
2864:

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

2857:
2858: l_row_count := sql%rowcount;
2859:
2860: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM MTL USAGE Standards Table: '|| l_row_count || ' rows inserted');
2861: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2862:
2863: EXCEPTION
2864:
2865: WHEN OTHERS THEN

Line 2869: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

2865: WHEN OTHERS THEN
2866:
2867: rollback;
2868:
2869: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
2870:
2871: retcode := SQLCODE;
2872: errbuf := SQLERRM;
2873:

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

2979: BEGIN
2980:
2981: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INIT';
2982:
2983: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2984:
2985: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
2986: --{
2987: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';

Line 3111: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');

3107: commit;
3108:
3109: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;
3110:
3111: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');
3112: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3113:
3114:
3115: EXCEPTION

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

3108:
3109: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;
3110:
3111: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');
3112: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3113:
3114:
3115: EXCEPTION
3116: WHEN gmd_common_scale_error THEN

Line 3118: BIS_COLLECTION_UTILITIES.PUT_LINE('Error: gmd_common_scale.scale completed with error status at statement' || l_stmt_num);

3114:
3115: EXCEPTION
3116: WHEN gmd_common_scale_error THEN
3117: rollback;
3118: BIS_COLLECTION_UTILITIES.PUT_LINE('Error: gmd_common_scale.scale completed with error status at statement' || l_stmt_num);
3119:
3120: WHEN OTHERS THEN
3121: rollback;
3122: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

Line 3122: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

3118: BIS_COLLECTION_UTILITIES.PUT_LINE('Error: gmd_common_scale.scale completed with error status at statement' || l_stmt_num);
3119:
3120: WHEN OTHERS THEN
3121: rollback;
3122: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
3123:
3124: retcode := SQLCODE;
3125: errbuf := SQLERRM;
3126:

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

3233: BEGIN
3234:
3235: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_SCALED_MTL_INCR';
3236:
3237: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3238:
3239: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN
3240: --{
3241: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_OPM_SCALED_MTL';

Line 3364: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');

3360: commit;
3361:
3362: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;
3363:
3364: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');
3365: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3366:
3367:
3368: EXCEPTION

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

3361:
3362: select count(*) into l_row_count from OPI_DBI_OPM_SCALED_MTL;
3363:
3364: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of OPM Scaled Extraction: '|| l_row_count || ' rows inserted');
3365: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3366:
3367:
3368: EXCEPTION
3369:

Line 3372: BIS_COLLECTION_UTILITIES.PUT_LINE('Error: gmd_common_scale.scale completed with error status at statement' || l_stmt_num);

3368: EXCEPTION
3369:
3370: WHEN gmd_common_scale_error THEN
3371: rollback;
3372: BIS_COLLECTION_UTILITIES.PUT_LINE('Error: gmd_common_scale.scale completed with error status at statement' || l_stmt_num);
3373:
3374: WHEN OTHERS THEN
3375: rollback;
3376: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

Line 3376: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

3372: BIS_COLLECTION_UTILITIES.PUT_LINE('Error: gmd_common_scale.scale completed with error status at statement' || l_stmt_num);
3373:
3374: WHEN OTHERS THEN
3375: rollback;
3376: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
3377:
3378: retcode := SQLCODE;
3379: errbuf := SQLERRM;
3380:

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

3403: BEGIN
3404:
3405: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_COMP_INIT';
3406:
3407: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3408:
3409: /* Extraction of WIP Completions fact */
3410: l_stmt_num := 20;
3411: INSERT

Line 3495: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of WIP Completions Fact Table: '|| l_row_count || ' rows inserted');

3491: planned_item;
3492:
3493: l_row_count := sql%rowcount;
3494:
3495: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of WIP Completions Fact Table: '|| l_row_count || ' rows inserted');
3496: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3497:
3498: EXCEPTION
3499:

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

3492:
3493: l_row_count := sql%rowcount;
3494:
3495: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of WIP Completions Fact Table: '|| l_row_count || ' rows inserted');
3496: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3497:
3498: EXCEPTION
3499:
3500: WHEN OTHERS THEN

Line 3504: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

3500: WHEN OTHERS THEN
3501:
3502: rollback;
3503:
3504: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
3505:
3506: retcode := SQLCODE;
3507: errbuf := SQLERRM;
3508:

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

3531: BEGIN
3532:
3533: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_COMP_INCR';
3534:
3535: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3536:
3537: /* Extraction of WIP Completions fact */
3538: l_stmt_num := 20;
3539: MERGE

Line 3681: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of WIP Completions Fact Table: '|| l_row_count || ' rows inserted');

3677: );
3678:
3679: l_row_count := sql%rowcount;
3680:
3681: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of WIP Completions Fact Table: '|| l_row_count || ' rows inserted');
3682: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3683:
3684: EXCEPTION
3685:

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

3678:
3679: l_row_count := sql%rowcount;
3680:
3681: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of WIP Completions Fact Table: '|| l_row_count || ' rows inserted');
3682: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3683:
3684: EXCEPTION
3685:
3686: WHEN OTHERS THEN

Line 3690: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

3686: WHEN OTHERS THEN
3687:
3688: rollback;
3689:
3690: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
3691:
3692: retcode := SQLCODE;
3693: errbuf := SQLERRM;
3694:

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

3717: BEGIN
3718:
3719: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_SCRAP_INIT';
3720:
3721: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3722:
3723: /* Extraction of Scrap fact */
3724: l_stmt_num := 20;
3725: INSERT

Line 3800: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of Scrap Fact Table: '|| l_row_count || ' rows inserted');

3796: scrap_reason;
3797:
3798: l_row_count := sql%rowcount;
3799:
3800: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of Scrap Fact Table: '|| l_row_count || ' rows inserted');
3801: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3802:
3803: EXCEPTION
3804:

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

3797:
3798: l_row_count := sql%rowcount;
3799:
3800: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of Scrap Fact Table: '|| l_row_count || ' rows inserted');
3801: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3802:
3803: EXCEPTION
3804:
3805: WHEN OTHERS THEN

Line 3807: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

3803: EXCEPTION
3804:
3805: WHEN OTHERS THEN
3806:
3807: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
3808:
3809: retcode := SQLCODE;
3810: errbuf := SQLERRM;
3811:

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

3834: BEGIN
3835:
3836: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_WIP_SCRAP_INCR';
3837:
3838: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
3839:
3840: /* Extraction of Scrap fact */
3841: l_stmt_num := 20;
3842: MERGE

Line 3966: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of Scrap Fact Table: '|| l_row_count || ' rows inserted');

3962: );
3963:
3964: l_row_count := sql%rowcount;
3965:
3966: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of Scrap Fact Table: '|| l_row_count || ' rows inserted');
3967: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3968:
3969: EXCEPTION
3970:

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

3963:
3964: l_row_count := sql%rowcount;
3965:
3966: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished extraction of Scrap Fact Table: '|| l_row_count || ' rows inserted');
3967: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
3968:
3969: EXCEPTION
3970:
3971: WHEN OTHERS THEN

Line 3973: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

3969: EXCEPTION
3970:
3971: WHEN OTHERS THEN
3972:
3973: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
3974:
3975: retcode := SQLCODE;
3976: errbuf := SQLERRM;
3977:

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

3999: BEGIN
4000:
4001: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_TRUNC_TEMP_TBLS';
4002:
4003: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4004:
4005: /* truncate all tables */
4006: l_stmt_num := 10;
4007: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

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

4013: execute immediate 'truncate table ' || l_opi_schema || '.opi_dbi_muv_conv_rates';
4014: --}
4015: END IF;
4016:
4017: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
4018:
4019: EXCEPTION
4020:
4021: WHEN OTHERS THEN

Line 4023: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

4019: EXCEPTION
4020:
4021: WHEN OTHERS THEN
4022:
4023: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
4024:
4025: retcode := SQLCODE;
4026: errbuf := SQLERRM;
4027:

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

4049: BEGIN
4050:
4051: l_proc_name := 'OPI_DBI_JOB_TRN_STG_PKG.OPI_TRUNC_MFG_FACT_TBLS';
4052:
4053: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4054:
4055: /* truncate all tables */
4056: l_stmt_num := 10;
4057: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

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

4067: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_WIP_SCRAP_F PURGE MATERIALIZED VIEW LOG';
4068: --}
4069: END IF;
4070:
4071: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
4072:
4073: EXCEPTION
4074:
4075: WHEN OTHERS THEN

Line 4077: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));

4073: EXCEPTION
4074:
4075: WHEN OTHERS THEN
4076:
4077: BIS_COLLECTION_UTILITIES.PUT_LINE (err_mesg (SQLERRM, l_proc_name,l_stmt_num));
4078:
4079: retcode := SQLCODE;
4080: errbuf := SQLERRM;
4081:

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

4099: BEGIN
4100:
4101: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP';
4102:
4103: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4104:
4105: l_stmt_num := 10;
4106: IF(opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(1,1) = FALSE
4107: OR opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(1,2) = FALSE) THEN

Line 4109: BIS_COLLECTION_UTILITIES.put_line('Failed to store current run time bounds and new run time bounds for next run.');

4105: l_stmt_num := 10;
4106: IF(opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(1,1) = FALSE
4107: OR opi_dbi_common_mod_incr_pkg.ETL_REPORT_SUCCESS(1,2) = FALSE) THEN
4108: --{
4109: BIS_COLLECTION_UTILITIES.put_line('Failed to store current run time bounds and new run time bounds for next run.');
4110: RAISE_APPLICATION_ERROR(-20000, errbuf);
4111: --}
4112: END IF;
4113:

Line 4163: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP - Error at statement ('

4159: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP ('
4160: || to_char(l_stmt_num)
4161: || '): '
4162: || substr(SQLERRM, 1,200);
4163: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP - Error at statement ('
4164: || to_char(l_stmt_num)
4165: || ')');
4166: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4167: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

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

4162: || substr(SQLERRM, 1,200);
4163: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP - Error at statement ('
4164: || to_char(l_stmt_num)
4165: || ')');
4166: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4167: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4168: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4169:
4170: retcode := SQLCODE;

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

4163: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.OPI_JOB_TXN_WRAPUP - Error at statement ('
4164: || to_char(l_stmt_num)
4165: || ')');
4166: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4167: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4168: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4169:
4170: retcode := SQLCODE;
4171: errbuf := SQLERRM;

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

4164: || to_char(l_stmt_num)
4165: || ')');
4166: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4167: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4168: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4169:
4170: retcode := SQLCODE;
4171: errbuf := SQLERRM;
4172: RAISE_APPLICATION_ERROR(-20000, errbuf);

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

4192: BEGIN
4193:
4194: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP';
4195:
4196: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4197:
4198: /* calling setup for all fact tables */
4199: l_stmt_num := 10;
4200:

Line 4201: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DETAILS_F') = false then

4197:
4198: /* calling setup for all fact tables */
4199: l_stmt_num := 10;
4200:
4201: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DETAILS_F') = false then
4202: RAISE_APPLICATION_ERROR(-20000, errbuf);
4203: END IF;
4204:
4205: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DTL_STD_F') = false then

Line 4205: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DTL_STD_F') = false then

4201: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DETAILS_F') = false then
4202: RAISE_APPLICATION_ERROR(-20000, errbuf);
4203: END IF;
4204:
4205: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DTL_STD_F') = false then
4206: RAISE_APPLICATION_ERROR(-20000, errbuf);
4207: END IF;
4208:
4209: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_COMP_F') = false then

Line 4209: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_COMP_F') = false then

4205: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_JOB_MTL_DTL_STD_F') = false then
4206: RAISE_APPLICATION_ERROR(-20000, errbuf);
4207: END IF;
4208:
4209: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_COMP_F') = false then
4210: RAISE_APPLICATION_ERROR(-20000, errbuf);
4211: END IF;
4212:
4213: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_SCRAP_F') = false then

Line 4213: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_SCRAP_F') = false then

4209: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_COMP_F') = false then
4210: RAISE_APPLICATION_ERROR(-20000, errbuf);
4211: END IF;
4212:
4213: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_WIP_SCRAP_F') = false then
4214: RAISE_APPLICATION_ERROR(-20000, errbuf);
4215: END IF;
4216:
4217: /* calling common modules bounds check */

Line 4225: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program is running out of turn. ');

4221: IF (opi_dbi_common_mod_init_pkg.init_end_bounds_setup (1, 1) = FALSE OR
4222: opi_dbi_common_mod_init_pkg.init_end_bounds_setup (1, 2) = FALSE) THEN
4223: --{
4224:
4225: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program is running out of turn. ');
4226: BIS_COLLECTION_UTILITIES.put_line('Please submit the initial load request set for initial data collection. ');
4227:
4228: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4229: retcode := SQLCODE;

Line 4226: BIS_COLLECTION_UTILITIES.put_line('Please submit the initial load request set for initial data collection. ');

4222: opi_dbi_common_mod_init_pkg.init_end_bounds_setup (1, 2) = FALSE) THEN
4223: --{
4224:
4225: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program is running out of turn. ');
4226: BIS_COLLECTION_UTILITIES.put_line('Please submit the initial load request set for initial data collection. ');
4227:
4228: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4229: retcode := SQLCODE;
4230: errbuf := SQLERRM;

Line 4228: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

4224:
4225: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program is running out of turn. ');
4226: BIS_COLLECTION_UTILITIES.put_line('Please submit the initial load request set for initial data collection. ');
4227:
4228: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4229: retcode := SQLCODE;
4230: errbuf := SQLERRM;
4231: RAISE_APPLICATION_ERROR(-20000, errbuf);
4232: --}

Line 4241: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program is running out of turn. ');

4237: l_stmt_num := 22;
4238: IF opi_dbi_common_mod_incr_pkg.incr_end_bounds_setup (1, 1) = FALSE OR
4239: opi_dbi_common_mod_incr_pkg.incr_end_bounds_setup (1, 2) = FALSE THEN
4240: --{
4241: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program is running out of turn. ');
4242: BIS_COLLECTION_UTILITIES.put_line('Please submit the incremental load request set for incremental data collection. ');
4243:
4244: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4245: retcode := SQLCODE;

Line 4242: BIS_COLLECTION_UTILITIES.put_line('Please submit the incremental load request set for incremental data collection. ');

4238: IF opi_dbi_common_mod_incr_pkg.incr_end_bounds_setup (1, 1) = FALSE OR
4239: opi_dbi_common_mod_incr_pkg.incr_end_bounds_setup (1, 2) = FALSE THEN
4240: --{
4241: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program is running out of turn. ');
4242: BIS_COLLECTION_UTILITIES.put_line('Please submit the incremental load request set for incremental data collection. ');
4243:
4244: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4245: retcode := SQLCODE;
4246: errbuf := SQLERRM;

Line 4244: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

4240: --{
4241: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program is running out of turn. ');
4242: BIS_COLLECTION_UTILITIES.put_line('Please submit the incremental load request set for incremental data collection. ');
4243:
4244: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4245: retcode := SQLCODE;
4246: errbuf := SQLERRM;
4247: RAISE_APPLICATION_ERROR(-20000, errbuf);
4248: --}

Line 4259: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program should not be running. ');

4255: --{
4256: IF (opi_dbi_common_mod_init_pkg.run_initial_load (1, 1) = FALSE OR
4257: opi_dbi_common_mod_init_pkg.run_initial_load (1, 2) = FALSE) THEN
4258: --{
4259: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program should not be running. ');
4260: BIS_COLLECTION_UTILITIES.put_line('Try running the incremental load request set if the initial request set has already been run. ');
4261: BIS_COLLECTION_UTILITIES.put_line('If not, you will need to run the initial load request set.');
4262:
4263: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

Line 4260: BIS_COLLECTION_UTILITIES.put_line('Try running the incremental load request set if the initial request set has already been run. ');

4256: IF (opi_dbi_common_mod_init_pkg.run_initial_load (1, 1) = FALSE OR
4257: opi_dbi_common_mod_init_pkg.run_initial_load (1, 2) = FALSE) THEN
4258: --{
4259: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program should not be running. ');
4260: BIS_COLLECTION_UTILITIES.put_line('Try running the incremental load request set if the initial request set has already been run. ');
4261: BIS_COLLECTION_UTILITIES.put_line('If not, you will need to run the initial load request set.');
4262:
4263: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4264: retcode := SQLCODE;

Line 4261: BIS_COLLECTION_UTILITIES.put_line('If not, you will need to run the initial load request set.');

4257: opi_dbi_common_mod_init_pkg.run_initial_load (1, 2) = FALSE) THEN
4258: --{
4259: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program should not be running. ');
4260: BIS_COLLECTION_UTILITIES.put_line('Try running the incremental load request set if the initial request set has already been run. ');
4261: BIS_COLLECTION_UTILITIES.put_line('If not, you will need to run the initial load request set.');
4262:
4263: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4264: retcode := SQLCODE;
4265: errbuf := SQLERRM;

Line 4263: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

4259: BIS_COLLECTION_UTILITIES.put_line('Initial load concurrent program should not be running. ');
4260: BIS_COLLECTION_UTILITIES.put_line('Try running the incremental load request set if the initial request set has already been run. ');
4261: BIS_COLLECTION_UTILITIES.put_line('If not, you will need to run the initial load request set.');
4262:
4263: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4264: retcode := SQLCODE;
4265: errbuf := SQLERRM;
4266: RAISE_APPLICATION_ERROR(-20000, errbuf);
4267: --}

Line 4276: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program should not be running. ');

4272: l_stmt_num := 27;
4273: IF opi_dbi_common_mod_incr_pkg.run_incr_load (1, 1) = FALSE OR
4274: opi_dbi_common_mod_incr_pkg.run_incr_load (1, 2) = FALSE THEN
4275: --{
4276: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program should not be running. ');
4277: BIS_COLLECTION_UTILITIES.put_line('If the initial load request set has already been run successfully, please submit the incremental load request set. ');
4278: BIS_COLLECTION_UTILITIES.put_line('If not, please run the initial load request set. ');
4279:
4280: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

Line 4277: BIS_COLLECTION_UTILITIES.put_line('If the initial load request set has already been run successfully, please submit the incremental load request set. ');

4273: IF opi_dbi_common_mod_incr_pkg.run_incr_load (1, 1) = FALSE OR
4274: opi_dbi_common_mod_incr_pkg.run_incr_load (1, 2) = FALSE THEN
4275: --{
4276: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program should not be running. ');
4277: BIS_COLLECTION_UTILITIES.put_line('If the initial load request set has already been run successfully, please submit the incremental load request set. ');
4278: BIS_COLLECTION_UTILITIES.put_line('If not, please run the initial load request set. ');
4279:
4280: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4281: retcode := SQLCODE;

Line 4278: BIS_COLLECTION_UTILITIES.put_line('If not, please run the initial load request set. ');

4274: opi_dbi_common_mod_incr_pkg.run_incr_load (1, 2) = FALSE THEN
4275: --{
4276: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program should not be running. ');
4277: BIS_COLLECTION_UTILITIES.put_line('If the initial load request set has already been run successfully, please submit the incremental load request set. ');
4278: BIS_COLLECTION_UTILITIES.put_line('If not, please run the initial load request set. ');
4279:
4280: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4281: retcode := SQLCODE;
4282: errbuf := SQLERRM;

Line 4280: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);

4276: BIS_COLLECTION_UTILITIES.put_line('Incremental load concurrent program should not be running. ');
4277: BIS_COLLECTION_UTILITIES.put_line('If the initial load request set has already been run successfully, please submit the incremental load request set. ');
4278: BIS_COLLECTION_UTILITIES.put_line('If not, please run the initial load request set. ');
4279:
4280: BIS_COLLECTION_UTILITIES.put_line(SQLERRM);
4281: retcode := SQLCODE;
4282: errbuf := SQLERRM;
4283: RAISE_APPLICATION_ERROR(-20000, errbuf);
4284: --}

Line 4293: BIS_COLLECTION_UTILITIES.PUT_LINE ('The global Start date Not Set.');

4289: /* get global start date */
4290: l_stmt_num := 30;
4291: s_global_start_date := trunc (bis_common_parameters.get_global_start_date);
4292: IF (s_global_start_date IS NULL) THEN
4293: BIS_COLLECTION_UTILITIES.PUT_LINE ('The global Start date Not Set.');
4294:
4295: RAISE_APPLICATION_ERROR(-20000, errbuf);
4296: END IF;
4297:

Line 4298: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Start Date:'||s_global_start_date);

4294:
4295: RAISE_APPLICATION_ERROR(-20000, errbuf);
4296: END IF;
4297:
4298: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Start Date:'||s_global_start_date);
4299:
4300: l_stmt_num := 40;
4301: -- Global currency codes -- already checked if primary is set up
4302: g_global_currency_code := bis_common_parameters.get_currency_code;

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

4314: (g_secondary_currency_code IS NOT NULL AND
4315: g_secondary_rate_type IS NULL)
4316: ) THEN
4317: --{
4318: 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.');
4319:
4320: RAISE_APPLICATION_ERROR(-20000, errbuf);
4321: --}
4322: END IF;

Line 4329: BIS_COLLECTION_UTILITIES.PUT_LINE('R12 Migration Date: '|| s_r12_migration_date);

4325: -- get R12 upgrade date
4326: /* If Migration Sate is not setup the api will return sysdate */
4327: OPI_DBI_RPT_UTIL_PKG.get_inv_convergence_date(s_r12_migration_date);
4328:
4329: BIS_COLLECTION_UTILITIES.PUT_LINE('R12 Migration Date: '|| s_r12_migration_date);
4330:
4331: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
4332:
4333: EXCEPTION

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

4327: OPI_DBI_RPT_UTIL_PKG.get_inv_convergence_date(s_r12_migration_date);
4328:
4329: BIS_COLLECTION_UTILITIES.PUT_LINE('R12 Migration Date: '|| s_r12_migration_date);
4330:
4331: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
4332:
4333: EXCEPTION
4334:
4335: WHEN OTHERS THEN

Line 4342: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP - Error at statement ('

4338: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP ('
4339: || to_char(l_stmt_num)
4340: || '): '
4341: || substr(SQLERRM, 1,200);
4342: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP - Error at statement ('
4343: || to_char(l_stmt_num)
4344: || ')');
4345: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4346: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

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

4341: || substr(SQLERRM, 1,200);
4342: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP - Error at statement ('
4343: || to_char(l_stmt_num)
4344: || ')');
4345: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4346: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4347: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4348:
4349: retcode := SQLCODE;

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

4342: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.CHECK_OPI_JOB_TXN_SETUP - Error at statement ('
4343: || to_char(l_stmt_num)
4344: || ')');
4345: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4346: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4347: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4348:
4349: retcode := SQLCODE;
4350: errbuf := SQLERRM;

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

4343: || to_char(l_stmt_num)
4344: || ')');
4345: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4346: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4347: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4348:
4349: retcode := SQLCODE;
4350: errbuf := SQLERRM;
4351: RAISE_APPLICATION_ERROR(-20000, errbuf);

Line 4388: BIS_COLLECTION_UTILITIES.PUT_LINE('Material Details MV Refresh finished ...');

4384: 0, -- HEAP_SIZE
4385: FALSE -- ATOMIC_REFRESH
4386: );
4387:
4388: BIS_COLLECTION_UTILITIES.PUT_LINE('Material Details MV Refresh finished ...');
4389:
4390: l_stmt_num := 20;
4391: /* Scrap MV Refresh */
4392:

Line 4404: BIS_COLLECTION_UTILITIES.PUT_LINE('Scrap Refresh finished ...');

4400: l_stmt_num := 28;
4401: -- Third Level MV
4402: DBMS_MVIEW.REFRESH ('opi_scrap_sum_mv', '?');
4403:
4404: BIS_COLLECTION_UTILITIES.PUT_LINE('Scrap Refresh finished ...');
4405:
4406: l_stmt_num := 32;
4407: /* Refresh MV over WIP Completions fact for On Time production */
4408: dbms_mview.refresh('OPI_ONTIME_PROD_OO1_MV',

Line 4419: BIS_COLLECTION_UTILITIES.PUT_LINE('WIP Completions Refresh finished ...');

4415: 0, -- HEAP_SIZE
4416: FALSE -- ATOMIC_REFRESH
4417: );
4418:
4419: BIS_COLLECTION_UTILITIES.PUT_LINE('WIP Completions Refresh finished ...');
4420:
4421: EXCEPTION
4422: WHEN OTHERS THEN
4423:

Line 4430: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_MV - Error at statement ('

4426: || to_char(l_stmt_num)
4427: || '): '
4428: || substr(SQLERRM, 1,200);
4429:
4430: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_MV - Error at statement ('
4431: || to_char(l_stmt_num)
4432: || ')');
4433:
4434: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

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

4430: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.REFRESH_MV - Error at statement ('
4431: || to_char(l_stmt_num)
4432: || ')');
4433:
4434: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4435: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4436:
4437: RAISE_APPLICATION_ERROR(-20000, errbuf);
4438: /*please note that this api will commit!!*/

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

4431: || to_char(l_stmt_num)
4432: || ')');
4433:
4434: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4435: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4436:
4437: RAISE_APPLICATION_ERROR(-20000, errbuf);
4438: /*please note that this api will commit!!*/
4439:

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

4459: BEGIN
4460:
4461: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT';
4462:
4463: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4464:
4465: -- WHO column variable initialization
4466: l_stmt_num := 0;
4467: s_sysdate := SYSDATE;

Line 4486: BIS_COLLECTION_UTILITIES.PUT_LINE('Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table');

4482: GET_OPI_JOB_TXN_MMT_STG(errbuf => errbuf,retcode => retcode);
4483:
4484: --Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table
4485: l_stmt_num := 15;
4486: BIS_COLLECTION_UTILITIES.PUT_LINE('Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table');
4487: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;
4488:
4489: --Populate Jobs Txn Staging with ODM data
4490: l_stmt_num := 20;

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

4512: --Check For Missing Currency Rates
4513: l_stmt_num := 60;
4514: IF(GET_OPI_JOB_TXN_CRATES(errbuf,retcode) = -1 ) THEN
4515: --{
4516: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
4517: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
4518: RAISE_APPLICATION_ERROR(-20000, errbuf);
4519: --}
4520: END IF;

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

4513: l_stmt_num := 60;
4514: IF(GET_OPI_JOB_TXN_CRATES(errbuf,retcode) = -1 ) THEN
4515: --{
4516: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
4517: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
4518: RAISE_APPLICATION_ERROR(-20000, errbuf);
4519: --}
4520: END IF;
4521:

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

4548: OPI_JOB_TXN_WRAPUP(errbuf => errbuf,retcode => retcode);
4549:
4550: commit;
4551:
4552: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
4553:
4554: EXCEPTION
4555:
4556: WHEN OTHERS THEN

Line 4563: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT - Error at statement ('

4559: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT ('
4560: || to_char(l_stmt_num)
4561: || '): '
4562: || substr(SQLERRM, 1,200);
4563: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT - Error at statement ('
4564: || to_char(l_stmt_num)
4565: || ')');
4566: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4567: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

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

4562: || substr(SQLERRM, 1,200);
4563: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT - Error at statement ('
4564: || to_char(l_stmt_num)
4565: || ')');
4566: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4567: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4568: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4569:
4570: retcode := SQLCODE;

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

4563: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INIT - Error at statement ('
4564: || to_char(l_stmt_num)
4565: || ')');
4566: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4567: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4568: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4569:
4570: retcode := SQLCODE;
4571: errbuf := SQLERRM;

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

4564: || to_char(l_stmt_num)
4565: || ')');
4566: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4567: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4568: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4569:
4570: retcode := SQLCODE;
4571: errbuf := SQLERRM;
4572: RAISE_APPLICATION_ERROR(-20000, errbuf);

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

4592: BEGIN
4593:
4594: l_proc_name := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR';
4595:
4596: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
4597:
4598: -- WHO column variable initialization
4599: l_stmt_num := 0;
4600: s_sysdate := SYSDATE;

Line 4614: BIS_COLLECTION_UTILITIES.PUT_LINE('Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table');

4610: OPI_TRUNC_TEMP_TBLS(errbuf => errbuf,retcode => retcode);
4611:
4612: --Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table
4613: l_stmt_num := 17;
4614: BIS_COLLECTION_UTILITIES.PUT_LINE('Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table');
4615: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;
4616:
4617: --Populate Jobs Txn Staging with ODM data
4618: l_stmt_num := 20;

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

4629: --Check For Missing Currency Rates
4630: l_stmt_num := 60;
4631: IF(GET_OPI_JOB_TXN_CRATES(errbuf => errbuf,retcode => retcode) = -1 ) THEN
4632: --{
4633: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
4634: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
4635: RAISE_APPLICATION_ERROR(-20000, errbuf);
4636: --}
4637: END IF;

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

4630: l_stmt_num := 60;
4631: IF(GET_OPI_JOB_TXN_CRATES(errbuf => errbuf,retcode => retcode) = -1 ) THEN
4632: --{
4633: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
4634: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
4635: RAISE_APPLICATION_ERROR(-20000, errbuf);
4636: --}
4637: END IF;
4638:

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

4665: OPI_JOB_TXN_WRAPUP(errbuf => errbuf,retcode => retcode);
4666:
4667: commit;
4668:
4669: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
4670:
4671: EXCEPTION
4672:
4673: WHEN OTHERS THEN

Line 4680: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR - Error at statement ('

4676: l_err_msg := 'OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR ('
4677: || to_char(l_stmt_num)
4678: || '): '
4679: || substr(SQLERRM, 1,200);
4680: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR - Error at statement ('
4681: || to_char(l_stmt_num)
4682: || ')');
4683: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4684: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

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

4679: || substr(SQLERRM, 1,200);
4680: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR - Error at statement ('
4681: || to_char(l_stmt_num)
4682: || ')');
4683: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4684: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4685: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4686:
4687: retcode := SQLCODE;

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

4680: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_JOB_TXN_STG_PKG.GET_OPI_JOB_TXN_MUV_INCR - Error at statement ('
4681: || to_char(l_stmt_num)
4682: || ')');
4683: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4684: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4685: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4686:
4687: retcode := SQLCODE;
4688: errbuf := SQLERRM;

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

4681: || to_char(l_stmt_num)
4682: || ')');
4683: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
4684: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
4685: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
4686:
4687: retcode := SQLCODE;
4688: errbuf := SQLERRM;
4689: RAISE_APPLICATION_ERROR(-20000, errbuf);