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 OPI_DBI_MTL_VARIANCE_PKG

Line 1: Package Body OPI_DBI_MTL_VARIANCE_PKG AS

1: Package Body OPI_DBI_MTL_VARIANCE_PKG AS
2: /*$Header: OPIDMUVETLB.pls 120.24 2006/09/21 00:38:11 asparama noship $ */
3:
4: -- DBI GSD
5: g_global_start_date DATE;

Line 404: i_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.GET_CONVERSION_RATE ('

400: EXCEPTION
401: WHEN OTHERS THEN
402: rollback;
403: i_err_num := SQLCODE;
404: i_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.GET_CONVERSION_RATE ('
405: || to_char(l_stmt_num)
406: || '): '
407: || substr(SQLERRM, 1,200);
408:

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 517: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_MFG_CST_VAR_PRER12_INIT';

513: l_err_msg VARCHAR2(255);
514: l_proc_name VARCHAR2(255);
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;

Line 740: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_MFG_CST_VAR_INIT';

736: l_opi_schema VARCHAR2(30);
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;

Line 1044: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_MFG_CST_VAR_INCR';

1040: l_opi_schema VARCHAR2(30);
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;

Line 1516: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR';

1512: l_proc_name VARCHAR2(255);
1513:
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

Line 1894: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.GET_CURR_UNREC_VAR ('

1890: WHEN OTHERS THEN
1891: rollback;
1892:
1893: l_err_num := SQLCODE;
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 ('

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 1934: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.Refresh_Base_MV ('

1930: EXCEPTION
1931: WHEN OTHERS THEN
1932:
1933: l_err_num := SQLCODE;
1934: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.Refresh_Base_MV ('
1935: || to_char(l_stmt_num)
1936: || '): '
1937: || substr(SQLERRM, 1,200);
1938:

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 1993: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.REFRESH_MV ('

1989: EXCEPTION
1990: WHEN OTHERS THEN
1991:
1992: l_err_num := SQLCODE;
1993: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.REFRESH_MV ('
1994: || to_char(l_stmt_num)
1995: || '): '
1996: || substr(SQLERRM, 1,200);
1997:

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 2027: l_proc_name := 'OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP';

2023: l_err_msg VARCHAR2(255);
2024: l_proc_name VARCHAR2(255);
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 */

Line 2081: l_err_msg := 'OPI_DBI_MTL_VARIANCE_PKG.CHECK_OPI_MFG_CST_VAR_SETUP ('

2077:
2078: WHEN OTHERS THEN
2079: rollback;
2080: l_err_num := SQLCODE;
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 ('

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 2098: END OPI_DBI_MTL_VARIANCE_PKG;

2094: RAISE_APPLICATION_ERROR(-20000, errbuf);
2095:
2096: END CHECK_OPI_MFG_CST_VAR_SETUP;
2097:
2098: END OPI_DBI_MTL_VARIANCE_PKG;