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

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

245: g_secondary_rate_type IS NOT NULL)
246: OR (g_secondary_currency_code IS NOT NULL AND
247: g_secondary_rate_type IS NULL) ) THEN
248:
249: 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.');
250:
251: RAISE_APPLICATION_ERROR(-20000, errbuf);
252:
253: END IF;

Line 369: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;

365: IF (invalid_rates_exist_csr%FOUND) THEN
366:
367: -- there are missing rates - prepare to report them.
368: no_currency_rate_flag := 1;
369: BIS_COLLECTION_UTILITIES.writeMissingRateHeader;
370:
371: l_stmt_num := 60;
372: FOR get_missing_rates_rec IN get_missing_rates_c
373: (l_pri_sec_curr_same,

Line 381: BIS_COLLECTION_UTILITIES.writemissingrate (

377: g_secondary_rate_type,
378: g_sysdate)
379: LOOP
380:
381: BIS_COLLECTION_UTILITIES.writemissingrate (
382: get_missing_rates_rec.rate_type,
383: get_missing_rates_rec.func_currency_code,
384: get_missing_rates_rec.curr_code,
385: get_missing_rates_rec.transaction_date);

Line 394: BIS_COLLECTION_UTILITIES.put_line('Please setup conversion rate for all missing rates reported');

390: CLOSE invalid_rates_exist_csr;
391:
392: l_stmt_num := 70; /* check no_currency_rate_flag */
393: IF (no_currency_rate_flag = 1) THEN /* missing rate found */
394: BIS_COLLECTION_UTILITIES.put_line('Please setup conversion rate for all missing rates reported');
395: retcode := g_error; -- there are missing rates to report
396: END IF;
397:
398: return retcode;

Line 409: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_MTL_VARIANCE_PKG.GET_CONVERSION_RATE - Error at statement ('

405: || to_char(l_stmt_num)
406: || '): '
407: || substr(SQLERRM, 1,200);
408:
409: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_MTL_VARIANCE_PKG.GET_CONVERSION_RATE - Error at statement ('
410: || to_char(l_stmt_num)
411: || ')');
412:
413: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));

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

409: BIS_COLLECTION_UTILITIES.put_line('OPI_DBI_MTL_VARIANCE_PKG.GET_CONVERSION_RATE - Error at statement ('
410: || to_char(l_stmt_num)
411: || ')');
412:
413: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
414: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
415:
416: return g_error;
417:

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

410: || to_char(l_stmt_num)
411: || ')');
412:
413: BIS_COLLECTION_UTILITIES.put_line('Error Number: ' || to_char(i_err_num));
414: BIS_COLLECTION_UTILITIES.put_line('Error Message: ' || i_err_msg);
415:
416: return g_error;
417:
418: END get_conversion_rate;

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

515: BEGIN
516:
517: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_MFG_CST_VAR_PRER12_INIT';
518:
519: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
520:
521: l_stmt_num := 10;
522: --Inserting Pre R12 OPM data
523: INSERT /*+ append parallel(OPI_DBI_MFG_CST_VAR_F) */

Line 715: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished Pre R12 OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count || ' rows inserted');

711: sec_conversion_rate;
712:
713: l_row_count := sql%rowcount;
714:
715: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished Pre R12 OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count || ' rows inserted');
716: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
717:
718: END GET_MFG_CST_VAR_PRER12_INIT;
719:

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

712:
713: l_row_count := sql%rowcount;
714:
715: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished Pre R12 OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count || ' rows inserted');
716: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
717:
718: END GET_MFG_CST_VAR_PRER12_INIT;
719:
720: /*

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

737: l_proc_name VARCHAR2(255);
738: BEGIN
739:
740: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_MFG_CST_VAR_INIT';
741: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
742:
743: -- WHO column variable initialization
744: g_sysdate := SYSDATE;
745: g_user_id := nvl(fnd_global.user_id, -1);

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

765: execute immediate 'alter session enable parallel dml';
766:
767: /* Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table */
768: l_stmt_num := 17;
769: BIS_COLLECTION_UTILITIES.PUT_LINE('Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table');
770: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;
771:
772: /* Insert OPI Manufacturing Cost Variances */
773: l_stmt_num := 20;

Line 1000: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI and OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count || ' rows inserted');

996:
997:
998: l_row_count := sql%rowcount;
999: g_row_count := g_row_count + l_row_count;
1000: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI and OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count || ' rows inserted');
1001:
1002: commit;
1003:
1004: IF(g_r12_migration_date > g_global_start_date) THEN

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

1016: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';
1017: --}
1018: END IF;
1019:
1020: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1021:
1022: END GET_MFG_CST_VAR_INIT;
1023:
1024: /*

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

1041: l_proc_name VARCHAR2(255);
1042: BEGIN
1043:
1044: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_MFG_CST_VAR_INCR';
1045: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1046:
1047: -- WHO column variable initialization
1048: g_sysdate := SYSDATE;
1049: g_user_id := nvl(fnd_global.user_id, -1);

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

1058: CHECK_OPI_MFG_CST_VAR_SETUP(errbuf,retcode);
1059:
1060: /* Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table */
1061: l_stmt_num := 15;
1062: BIS_COLLECTION_UTILITIES.PUT_LINE('Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table');
1063: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;
1064:
1065: /* Insert OPI Manufacturing Cost Variances */
1066: l_stmt_num := 20;

Line 1479: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI Manufacturing Cost Variance load into Fact Table: '|| l_row_count1 || ' rows inserted');

1475: g_row_count := g_row_count + l_row_count1 + l_row_count2;
1476:
1477: commit;
1478:
1479: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI Manufacturing Cost Variance load into Fact Table: '|| l_row_count1 || ' rows inserted');
1480: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count2 || ' rows inserted');
1481:
1482: /* Truncating Jobs Staging Table */
1483: l_stmt_num := 30;

Line 1480: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count2 || ' rows inserted');

1476:
1477: commit;
1478:
1479: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI Manufacturing Cost Variance load into Fact Table: '|| l_row_count1 || ' rows inserted');
1480: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPM Manufacturing Cost Variance load into Fact Table: '|| l_row_count2 || ' rows inserted');
1481:
1482: /* Truncating Jobs Staging Table */
1483: l_stmt_num := 30;
1484: IF fnd_installation.get_app_info( 'OPI', l_status, l_industry, l_opi_schema) THEN

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

1486: execute immediate 'truncate table ' || l_opi_schema || '.OPI_DBI_JOBS_STG';
1487: --}
1488: END IF;
1489:
1490: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1491:
1492: END GET_MFG_CST_VAR_INCR;
1493:
1494: /*

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

1514: BEGIN
1515:
1516: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR';
1517:
1518: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
1519:
1520: -- WHO column variable initialization
1521: g_sysdate := SYSDATE;
1522: g_user_id := nvl(fnd_global.user_id, -1);

Line 1535: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_CURR_UNREC_VAR_F' ) = false then

1531: l_list(3) := 'BIS_PRIMARY_RATE_TYPE';
1532:
1533: IF (bis_common_parameters.check_global_parameters(l_list)) THEN
1534:
1535: IF BIS_COLLECTION_UTILITIES.SETUP( 'OPI_DBI_CURR_UNREC_VAR_F' ) = false then
1536: RAISE_APPLICATION_ERROR(-20000, errbuf);
1537: End if;
1538:
1539: /* Truncate Current Unrecognized Variances Fact Table */

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

1544: END IF;
1545:
1546: l_stmt_num := 20;
1547: IF (Get_Conversion_Rate (errbuf, retcode) = -1) THEN
1548: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
1549: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
1550: retcode := g_error;
1551: return;
1552: END IF;

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

1545:
1546: l_stmt_num := 20;
1547: IF (Get_Conversion_Rate (errbuf, retcode) = -1) THEN
1548: BIS_COLLECTION_UTILITIES.put_line('Missing currency rate.');
1549: BIS_COLLECTION_UTILITIES.put_line('Please run this concurrent program again after fixing the missing currency rates.');
1550: retcode := g_error;
1551: return;
1552: END IF;
1553:

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

1552: END IF;
1553:
1554: /* Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table */
1555: l_stmt_num := 25;
1556: BIS_COLLECTION_UTILITIES.PUT_LINE('Calling to populate temp table for mutli ledger/valuation_cost_type in gtv table');
1557: OPI_DBI_BOUNDS_PKG.load_opm_org_ledger_data;
1558:
1559:
1560: /* Insert OPI Current Unrecognized Variances */

Line 1870: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI and OPM Current Unrecognized Variance into Fact Table: '|| l_row_count || ' rows inserted');

1866: l_row_count := sql%rowcount;
1867:
1868: commit;
1869:
1870: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI and OPM Current Unrecognized Variance into Fact Table: '|| l_row_count || ' rows inserted');
1871:
1872: BIS_COLLECTION_UTILITIES.WRAPUP(
1873: p_status => TRUE,
1874: p_count => l_row_count,

Line 1872: BIS_COLLECTION_UTILITIES.WRAPUP(

1868: commit;
1869:
1870: BIS_COLLECTION_UTILITIES.PUT_LINE('Finished OPI and OPM Current Unrecognized Variance into Fact Table: '|| l_row_count || ' rows inserted');
1871:
1872: BIS_COLLECTION_UTILITIES.WRAPUP(
1873: p_status => TRUE,
1874: p_count => l_row_count,
1875: p_message => 'Successfully loaded Current Unrecognized Variance table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
1876: );

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

1874: p_count => l_row_count,
1875: p_message => 'Successfully loaded Current Unrecognized Variance table at ' || TO_CHAR(SYSDATE, 'DD-MON-YYYY HH24:MI:SS')
1876: );
1877:
1878: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1879:
1880: ELSE
1881: retcode := g_error;
1882: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');

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

1878: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1879:
1880: ELSE
1881: retcode := g_error;
1882: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1883: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_PRIMARY_CURRENCY_CODE is setup.');
1884: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1885:
1886: END IF;

Line 1883: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_PRIMARY_CURRENCY_CODE is setup.');

1879:
1880: ELSE
1881: retcode := g_error;
1882: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1883: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_PRIMARY_CURRENCY_CODE is setup.');
1884: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1885:
1886: END IF;
1887:

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

1880: ELSE
1881: retcode := g_error;
1882: BIS_COLLECTION_UTILITIES.PUT_LINE('Global Parameters are not setup.');
1883: BIS_COLLECTION_UTILITIES.PUT_LINE('Please check that the profile option BIS_PRIMARY_CURRENCY_CODE is setup.');
1884: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
1885:
1886: END IF;
1887:
1888:

Line 1898: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR - Error at statement ('

1894: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR ('
1895: || to_char(l_stmt_num)
1896: || '): '
1897: || substr(SQLERRM, 1,200);
1898: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR - Error at statement ('
1899: || to_char(l_stmt_num)
1900: || ')');
1901: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1902: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

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

1897: || substr(SQLERRM, 1,200);
1898: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR - Error at statement ('
1899: || to_char(l_stmt_num)
1900: || ')');
1901: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1902: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1903: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1904:
1905: retcode := SQLCODE;

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

1898: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR - Error at statement ('
1899: || to_char(l_stmt_num)
1900: || ')');
1901: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1902: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1903: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1904:
1905: retcode := SQLCODE;
1906: errbuf := SQLERRM;

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

1899: || to_char(l_stmt_num)
1900: || ')');
1901: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1902: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1903: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
1904:
1905: retcode := SQLCODE;
1906: errbuf := SQLERRM;
1907: RAISE_APPLICATION_ERROR(-20000, errbuf);

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

1923: method => p_method,
1924: parallelism => 0);
1925:
1926:
1927: BIS_COLLECTION_UTILITIES.PUT_LINE('Refresh of Base Materialized View finished ...');
1928:
1929:
1930: EXCEPTION
1931: WHEN OTHERS THEN

Line 1939: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.Refresh_Base_MV - Error at statement ('

1935: || to_char(l_stmt_num)
1936: || '): '
1937: || substr(SQLERRM, 1,200);
1938:
1939: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.Refresh_Base_MV - Error at statement ('
1940: || to_char(l_stmt_num)
1941: || ')');
1942:
1943: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

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

1939: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.Refresh_Base_MV - Error at statement ('
1940: || to_char(l_stmt_num)
1941: || ')');
1942:
1943: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1944: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1945:
1946: RAISE_APPLICATION_ERROR(-20000, errbuf);
1947:

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

1940: || to_char(l_stmt_num)
1941: || ')');
1942:
1943: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
1944: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
1945:
1946: RAISE_APPLICATION_ERROR(-20000, errbuf);
1947:
1948: END Refresh_Base_MV;

Line 1971: BIS_COLLECTION_UTILITIES.PUT_LINE('Material Details MV Refresh finished ...');*/

1967: 0, -- HEAP_SIZE
1968: FALSE -- ATOMIC_REFRESH
1969: );
1970:
1971: BIS_COLLECTION_UTILITIES.PUT_LINE('Material Details MV Refresh finished ...');*/
1972:
1973: l_stmt_num := 20;
1974: /* MFG Cost Variance MV Refresh */
1975:

Line 1987: BIS_COLLECTION_UTILITIES.PUT_LINE('Manufacturing Cost Variance Refresh finished ...');

1983: 0, -- HEAP_SIZE
1984: FALSE -- ATOMIC_REFRESH
1985: );
1986:
1987: BIS_COLLECTION_UTILITIES.PUT_LINE('Manufacturing Cost Variance Refresh finished ...');
1988:
1989: EXCEPTION
1990: WHEN OTHERS THEN
1991:

Line 1998: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.REFRESH_MV - Error at statement ('

1994: || to_char(l_stmt_num)
1995: || '): '
1996: || substr(SQLERRM, 1,200);
1997:
1998: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.REFRESH_MV - Error at statement ('
1999: || to_char(l_stmt_num)
2000: || ')');
2001:
2002: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));

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

1998: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.REFRESH_MV - Error at statement ('
1999: || to_char(l_stmt_num)
2000: || ')');
2001:
2002: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
2003: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
2004:
2005: RAISE_APPLICATION_ERROR(-20000, errbuf);
2006: /*please note that this api will commit!!*/

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

1999: || to_char(l_stmt_num)
2000: || ')');
2001:
2002: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
2003: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
2004:
2005: RAISE_APPLICATION_ERROR(-20000, errbuf);
2006: /*please note that this api will commit!!*/
2007:

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

2025: BEGIN
2026:
2027: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP';
2028:
2029: BIS_COLLECTION_UTILITIES.PUT_LINE('Entering Procedure '|| l_proc_name);
2030:
2031: /* calling setup for all fact tables */
2032: l_stmt_num := 10;
2033:

Line 2034: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_MFG_CST_VAR_F') = false then

2030:
2031: /* calling setup for all fact tables */
2032: l_stmt_num := 10;
2033:
2034: IF BIS_COLLECTION_UTILITIES.SETUP('OPI_DBI_MFG_CST_VAR_F') = false then
2035: RAISE_APPLICATION_ERROR(-20000, errbuf);
2036: END IF;
2037:
2038: /* get global start date */

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

2038: /* get global start date */
2039: l_stmt_num := 20;
2040: g_global_start_date := trunc (bis_common_parameters.get_global_start_date);
2041: IF (g_global_start_date IS NULL) THEN
2042: BIS_COLLECTION_UTILITIES.PUT_LINE ('The global Start date Not Set.');
2043:
2044: RAISE_APPLICATION_ERROR(-20000, errbuf);
2045: END IF;
2046:

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

2060: OR
2061: (g_secondary_currency_code IS NOT NULL AND
2062: g_secondary_rate_type IS NULL)
2063: ) THEN
2064: 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.');
2065:
2066: RAISE_APPLICATION_ERROR(-20000, errbuf);
2067:
2068: END IF;

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

2070: l_stmt_num := 40;
2071: -- get R12 upgrade date
2072: OPI_DBI_RPT_UTIL_PKG.get_inv_convergence_date(g_r12_migration_date);
2073:
2074: BIS_COLLECTION_UTILITIES.PUT_LINE('Exiting Procedure '|| l_proc_name);
2075:
2076: EXCEPTION
2077:
2078: WHEN OTHERS THEN

Line 2085: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP - Error at statement ('

2081: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP ('
2082: || to_char(l_stmt_num)
2083: || '): '
2084: || substr(SQLERRM, 1,200);
2085: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP - Error at statement ('
2086: || to_char(l_stmt_num)
2087: || ')');
2088: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
2089: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);

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

2084: || substr(SQLERRM, 1,200);
2085: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP - Error at statement ('
2086: || to_char(l_stmt_num)
2087: || ')');
2088: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
2089: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
2090: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
2091:
2092: retcode := SQLCODE;

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

2085: BIS_COLLECTION_UTILITIES.PUT_LINE('OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP - Error at statement ('
2086: || to_char(l_stmt_num)
2087: || ')');
2088: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
2089: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
2090: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
2091:
2092: retcode := SQLCODE;
2093: errbuf := SQLERRM;

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

2086: || to_char(l_stmt_num)
2087: || ')');
2088: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Number: ' || to_char(l_err_num));
2089: BIS_COLLECTION_UTILITIES.PUT_LINE('Error Message: ' || l_err_msg);
2090: BIS_COLLECTION_UTILITIES.WRAPUP( FALSE, l_row_count, 'EXCEPTION '|| l_err_num||' : '||l_err_msg );
2091:
2092: retcode := SQLCODE;
2093: errbuf := SQLERRM;
2094: RAISE_APPLICATION_ERROR(-20000, errbuf);