DBA Data[Home] [Help]

APPS.INVPVDR4 dependencies on INVPVDR4

Line 1: PACKAGE BODY INVPVDR4 AS

1: PACKAGE BODY INVPVDR4 AS
2: /* $Header: INVPVD4B.pls 120.16.12010000.2 2008/09/26 13:14:24 pgandhik ship $ */
3:
4: FUNCTION validate_item_header4 (
5: org_id NUMBER,

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 1139: INVPUTLI.info('INVPVDR4.validate_item_header4: validate EAM attributes (EAM_ITEM_TYPE = ' || cr.EAM_ITEM_TYPE || ')');

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

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

1297: --4756500 Using l_org_id instead of org_id
1298: --Moving the validation out of the EAM_ITEM_TYPE IF BLOCK - UT Bug
1299:
1300: IF l_inv_debug_level IN(101, 102) THEN
1301: INVPUTLI.info('INVPVDR4.validate_item_header4: Validating Tracking and BOM attributes');
1302: END IF;
1303:
1304: IF ( cr.TRACKING_QUANTITY_IND = 'PS' AND
1305: (cr.BOM_ITEM_TYPE in (1,2) OR cr.BOM_ENABLED_FLAG='Y' ) )

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

1718: --End 2339789:uom units without uom code
1719: --End 2993300: New Attributes validation
1720:
1721: /*
1722: INVPUTLI.info('INVPVDR4.validate_item_header4: validate EAM attributes (EAM_ITEM_TYPE = ' || cr.EAM_ITEM_TYPE || ')');
1723:
1724: IF ( cr.XXX IS NOT NULL ) THEN
1725:
1726: BEGIN

Line 1820: err_text := substr('INVPVDR4.validate_item_header4: ' || SQLERRM , 1, 240);

1816: 'BOM_OP_VALIDATION_ERR',
1817: err_text);
1818: return (status);
1819: WHEN OTHERS THEN
1820: err_text := substr('INVPVDR4.validate_item_header4: ' || SQLERRM , 1, 240);
1821: IF l_inv_debug_level IN(101, 102) THEN
1822: INVPUTLI.info(err_text || ' (stmt=' || TO_CHAR(stmt) || ') TRANSACTION_ID : ' || TO_CHAR(trans_id));
1823: END IF;
1824: return (SQLCODE);

Line 1827: END INVPVDR4;

1823: END IF;
1824: return (SQLCODE);
1825: END validate_item_header4;
1826:
1827: END INVPVDR4;