APPS.INVPUTLI dependencies on INVPUTLI

Line 1: PACKAGE BODY INVPUTLI AS

1: PACKAGE BODY INVPUTLI AS
2: /* $Header: INVPUL1B.pls 120.28.12020000.5 2012/10/10 23:41:22 trudave ship $ */
3: indent NUMBER := 1;
4: g_Debug_Level NUMBER := 0;
5:

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

172:
173: EXCEPTION
174:
175: WHEN OTHERS THEN
176: err_text := substr('INVPUTLI.get_dynamic_sql_str:' || SQLERRM , 1,240);
177: return(SQLCODE);
178:
179: END get_dynamic_sql_str;
180:

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

1035:
1036: EXCEPTION
1037:
1038: WHEN OTHERS THEN
1039: err_text := substr('INVPUTLI.predefault_child_master ' || SQLERRM ,1,240 );
1040: return(SQLCODE);
1041:
1042: END predefault_child_master;
1043:

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

1077: l_Primary_UOM_Code VARCHAR2(3);
1078: l_base_primary_UOM mtl_units_of_measure_tl.unit_of_measure%TYPE;
1079: BEGIN
1080:
1081: INVPUTLI.info('INVPUTLI: inside assign_master_defaults');
1082:
1083: -- Assign defaults if the interface table column value is NULL
1084:
1085: l_created_by := 1 ;

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

2029: WHEN LOGGING_ERR THEN
2030: return(dumm_status);
2031:
2032: WHEN OTHERS THEN
2033: err_text := substr('INVPUTLI.assign_master_defaults ' || SQLERRM ,1,240 );
2034: return(SQLCODE);
2035:
2036: END assign_master_defaults;
2037:

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

2721: END IF;
2722: RETURN (l_ret_status);
2723: EXCEPTION
2724: WHEN NULL_DESC_ERR THEN
2725: err_text := 'INVPUTLI.assign_item_defaults: Description cannot be null in MSII';
2726: return(1403);
2727: -- ToDo: make sure the following NO_DATA_FOUND happens only in a relevant sql statement
2728: WHEN NO_DATA_FOUND THEN
2729: err_text := 'INVPUTLI.assign_item_defaults: Invalid PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE';

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

2725: err_text := 'INVPUTLI.assign_item_defaults: Description cannot be null in MSII';
2726: return(1403);
2727: -- ToDo: make sure the following NO_DATA_FOUND happens only in a relevant sql statement
2728: WHEN NO_DATA_FOUND THEN
2729: err_text := 'INVPUTLI.assign_item_defaults: Invalid PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE';
2730: return(SQLCODE);
2731: WHEN OTHERS THEN
2732: err_text := substr('INVPUTLI.assign_item_defaults ' || SQLERRM , 1, 240);
2733: return(SQLCODE);

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

2728: WHEN NO_DATA_FOUND THEN
2729: err_text := 'INVPUTLI.assign_item_defaults: Invalid PRIMARY_UNIT_OF_MEASURE or PRIMARY_UOM_CODE';
2730: return(SQLCODE);
2731: WHEN OTHERS THEN
2732: err_text := substr('INVPUTLI.assign_item_defaults ' || SQLERRM , 1, 240);
2733: return(SQLCODE);
2734: END assign_item_defaults;
2735:
2736: /*Bug: 4667452 */

Line 2775: END INVPUTLI;

2771: NULL;
2772: END;
2773:
2774:
2775: END INVPUTLI;