APPS.INVPUTLI dependencies on INVPUTLI

Line 1: PACKAGE BODY INVPUTLI AS

1: PACKAGE BODY INVPUTLI AS
2: /* $Header: INVPUL1B.pls 120.25.12010000.2 2008/11/25 02:26:05 akbharga ship $ */
3: indent NUMBER := 1;
4: g_Debug_Level NUMBER := 0;
5:

Line 171: err_text := substr('INVPUTLI.get_dynamic_sql_str:' || SQLERRM , 1,240);

167:
168: EXCEPTION
169:
170: WHEN OTHERS THEN
171: err_text := substr('INVPUTLI.get_dynamic_sql_str:' || SQLERRM , 1,240);
172: return(SQLCODE);
173:
174: END get_dynamic_sql_str;
175:

Line 1032: err_text := substr('INVPUTLI.assign_master_defaults ' || SQLERRM ,1,240 );

1028:
1029: EXCEPTION
1030:
1031: WHEN OTHERS THEN
1032: err_text := substr('INVPUTLI.assign_master_defaults ' || SQLERRM ,1,240 );
1033: return(SQLCODE);
1034:
1035: END predefault_child_master;
1036:

Line 1074: INVPUTLI.info('INVPUTLI: inside assign_master_defaults');

1070: l_Primary_UOM_Code VARCHAR2(3);
1071: l_base_primary_UOM mtl_units_of_measure_tl.unit_of_measure%TYPE;
1072: BEGIN
1073:
1074: INVPUTLI.info('INVPUTLI: inside assign_master_defaults');
1075:
1076: -- Assign defaults if the interface table column value is NULL
1077:
1078: l_created_by := 1 ;

Line 1958: err_text := substr('INVPUTLI.assign_master_defaults ' || SQLERRM ,1,240 );

1954: WHEN LOGGING_ERR THEN
1955: return(dumm_status);
1956:
1957: WHEN OTHERS THEN
1958: err_text := substr('INVPUTLI.assign_master_defaults ' || SQLERRM ,1,240 );
1959: return(SQLCODE);
1960:
1961: END assign_master_defaults;
1962:

Line 2636: err_text := 'INVPUTLI.assign_item_defaults: Description cannot be null in MSII';

2632: END IF;
2633: RETURN (l_ret_status);
2634: EXCEPTION
2635: WHEN NULL_DESC_ERR THEN
2636: err_text := 'INVPUTLI.assign_item_defaults: Description cannot be null in MSII';
2637: return(1403);
2638: -- ToDo: make sure the following NO_DATA_FOUND happens only in a relevant sql statement
2639: WHEN NO_DATA_FOUND THEN
2640: err_text := 'INVPUTLI.assign_item_defaults: Invalid PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE';

Line 2640: err_text := 'INVPUTLI.assign_item_defaults: Invalid PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE';

2636: err_text := 'INVPUTLI.assign_item_defaults: Description cannot be null in MSII';
2637: return(1403);
2638: -- ToDo: make sure the following NO_DATA_FOUND happens only in a relevant sql statement
2639: WHEN NO_DATA_FOUND THEN
2640: err_text := 'INVPUTLI.assign_item_defaults: Invalid PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE';
2641: return(SQLCODE);
2642: WHEN OTHERS THEN
2643: err_text := substr('INVPUTLI.assign_item_defaults ' || SQLERRM , 1, 240);
2644: return(SQLCODE);

Line 2643: err_text := substr('INVPUTLI.assign_item_defaults ' || SQLERRM , 1, 240);

2639: WHEN NO_DATA_FOUND THEN
2640: err_text := 'INVPUTLI.assign_item_defaults: Invalid PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE';
2641: return(SQLCODE);
2642: WHEN OTHERS THEN
2643: err_text := substr('INVPUTLI.assign_item_defaults ' || SQLERRM , 1, 240);
2644: return(SQLCODE);
2645: END assign_item_defaults;
2646:
2647: /*Bug: 4667452 */

Line 2663: END INVPUTLI;

2659: BEGIN
2660:
2661: g_Debug_Level := FND_PROFILE.Value('INV_DEBUG_LEVEL');
2662:
2663: END INVPUTLI;