APPS.OPI_DBI_INV_VALUE_OPM_INIT_PKG dependencies on OPI_DBI_INV_VALUE_OPM_INIT_PKG

Line 1: Package Body OPI_DBI_INV_VALUE_OPM_INIT_PKG AS

1: Package Body OPI_DBI_INV_VALUE_OPM_INIT_PKG AS
2: /*$Header: OPIDIPIB.pls 120.1 2005/08/02 01:45:18 achandak noship $ */
3:
4: g_user_id NUMBER := nvl(fnd_global.user_id, -1);
5: g_login_id NUMBER := nvl(fnd_global.login_id, -1);

Line 77: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Clean_OPM_Tables (Error at statement '

73: END IF;
74:
75: EXCEPTION
76: WHEN OTHERS THEN
77: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Clean_OPM_Tables (Error at statement '
78: || to_char(l_stmt_num)
79: || '): '
80: || substr(SQLERRM, 1,200);
81:

Line 259: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance ('

255: EXCEPTION
256: WHEN OTHERS THEN
257:
258: l_err_num := SQLCODE;
259: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance ('
260: || to_char(l_stmt_num) || '): ' || substr(SQLERRM, 1,200);
261:
262: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance '
263: || '- Error at statement (' || to_char(l_stmt_num) || ')');

Line 262: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance '

258: l_err_num := SQLCODE;
259: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance ('
260: || to_char(l_stmt_num) || '): ' || substr(SQLERRM, 1,200);
261:
262: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Onhand_Balance '
263: || '- Error at statement (' || to_char(l_stmt_num) || ')');
264: bis_collection_utilities.put_line('Error Number: ' || to_char(l_err_num));
265: bis_collection_utilities.put_line('Error Message: ' || l_err_msg);
266:

Line 887: bis_collection_utilities.put_line('Error encounted in OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Inception_Inv_Balance');

883:
884: EXCEPTION
885: WHEN OTHERS THEN
886:
887: bis_collection_utilities.put_line('Error encounted in OPI_DBI_INV_VALUE_OPM_INIT_PKG.Get_OPM_Inception_Inv_Balance');
888: bis_collection_utilities.put_line('Error Message: ' || SQLERRM);
889:
890: RAISE_APPLICATION_ERROR(-20000, errbuf);
891: /*please note that this api will commit!!*/

Line 930: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Run_OPM_First_ETL ('

926: EXCEPTION
927: WHEN OTHERS THEN
928: retcode := 1;
929: l_err_num := SQLCODE;
930: l_err_msg := 'OPI_DBI_INV_VALUE_OPM_INIT_PKG.Run_OPM_First_ETL ('
931: || to_char(l_stmt_num)
932: || '): '
933: || substr(SQLERRM, 1,200);
934:

Line 935: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Run_OPM_First_ETL '

931: || to_char(l_stmt_num)
932: || '): '
933: || substr(SQLERRM, 1,200);
934:
935: bis_collection_utilities.put_line('OPI_DBI_INV_VALUE_OPM_INIT_PKG.Run_OPM_First_ETL '
936: || '- Error at statement ('
937: || to_char(l_stmt_num)
938: || ')');
939:

Line 955: End OPI_DBI_INV_VALUE_OPM_INIT_PKG ;

951: industry => g_opi_industry,
952: oracle_schema => g_opi_schema
953: );
954:
955: End OPI_DBI_INV_VALUE_OPM_INIT_PKG ;