DBA Data[Home] [Help]

APPS.INVPVDR4 dependencies on INVPUTLI

Line 85: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452

81: LOGGING_ERR EXCEPTION;
82: VALIDATE_ERR EXCEPTION;
83: temp_proc_flag NUMBER;
84: proc_enab_org VARCHAR2(1);
85: l_inv_debug_level NUMBER := INVPUTLI.get_debug_level; --Bug: 4667452
86:
87: BEGIN
88:
89: IF l_inv_debug_level IN(101, 102) THEN

Line 90: INVPUTLI.info('INVPVDR4.validate_item_header4: begin');

86:
87: BEGIN
88:
89: IF l_inv_debug_level IN(101, 102) THEN
90: INVPUTLI.info('INVPVDR4.validate_item_header4: begin');
91: END IF;
92: -- Validate the records
93:
94: FOR cr IN cc LOOP

Line 102: --INVPUTLI.info('INVPVDR4: Validating second set of lookups');

98: l_item_id := cr.inventory_item_id; -- Bug 4705184
99: temp_proc_flag := cr.process_flag; -- Bug 4705184
100:
101: -- Validate second set of fields with lookup values @@
102: --INVPUTLI.info('INVPVDR4: Validating second set of lookups');
103: -- validate lookup
104: IF (cr.bom_item_type <> 1 AND
105: cr.bom_item_type <> 2 AND
106: cr.bom_item_type <> 3 AND

Line 1142: INVPUTLI.info('INVPVDR4.validate_item_header4: validate EAM attributes (EAM_ITEM_TYPE = ' || cr.EAM_ITEM_TYPE || ')');

1138: --Validate INDIVISIBLE_FLAG
1139: -- Do not raise error
1140: -- Validate EAM Asset Item attributes
1141: IF l_inv_debug_level IN(101, 102) THEN
1142: INVPUTLI.info('INVPVDR4.validate_item_header4: validate EAM attributes (EAM_ITEM_TYPE = ' || cr.EAM_ITEM_TYPE || ')');
1143: END IF;
1144:
1145: IF ( cr.EAM_ITEM_TYPE IS NOT NULL ) THEN
1146: BEGIN

Line 1307: INVPUTLI.info('INVPVDR4.validate_item_header4: Validating Tracking and BOM attributes');

1303: --4756500 Using l_org_id instead of org_id
1304: --Moving the validation out of the EAM_ITEM_TYPE IF BLOCK - UT Bug
1305:
1306: IF l_inv_debug_level IN(101, 102) THEN
1307: INVPUTLI.info('INVPVDR4.validate_item_header4: Validating Tracking and BOM attributes');
1308: END IF;
1309:
1310: /*Comment the code to fix bug7477872
1311: IF ( cr.TRACKING_QUANTITY_IND = 'PS' AND

Line 1729: INVPUTLI.info('INVPVDR4.validate_item_header4: validate EAM attributes (EAM_ITEM_TYPE = ' || cr.EAM_ITEM_TYPE || ')');

1725: --End 2339789:uom units without uom code
1726: --End 2993300: New Attributes validation
1727:
1728: /*
1729: INVPUTLI.info('INVPVDR4.validate_item_header4: validate EAM attributes (EAM_ITEM_TYPE = ' || cr.EAM_ITEM_TYPE || ')');
1730:
1731: IF ( cr.XXX IS NOT NULL ) THEN
1732:
1733: BEGIN

Line 1830: INVPUTLI.info(err_text || ' (stmt=' || TO_CHAR(stmt) || ') TRANSACTION_ID : ' || TO_CHAR(trans_id));

1826: return (status);
1827: WHEN OTHERS THEN
1828: err_text := substr('INVPVDR4.validate_item_header4: ' || SQLERRM , 1, 240);
1829: IF l_inv_debug_level IN(101, 102) THEN
1830: INVPUTLI.info(err_text || ' (stmt=' || TO_CHAR(stmt) || ') TRANSACTION_ID : ' || TO_CHAR(trans_id));
1831: END IF;
1832: return (SQLCODE);
1833: END validate_item_header4;
1834: