APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_LOT_NUMBERS

Line 1623: FROM MTL_LOT_NUMBERS

1619: -- Check for the existance of lot number in Inventory for the current item
1620: BEGIN
1621: SELECT 'x'
1622: INTO l_temp
1623: FROM MTL_LOT_NUMBERS
1624: WHERE inventory_item_id = p_inv_item_id
1625: AND organization_id = p_inv_org_id
1626: AND lot_number = p_lot_number;
1627: EXCEPTION

Line 1669: csi_gen_utility_pvt.put_line('Lot Number created successfully in MTL_LOT_NUMBERS..');

1665: FND_MSG_PUB.ADD;
1666: RAISE comp_error;
1667: ELSE
1668: l_return_value := TRUE;
1669: csi_gen_utility_pvt.put_line('Lot Number created successfully in MTL_LOT_NUMBERS..');
1670: END IF;
1671: END IF; -- l_temp is null
1672: --
1673: EXCEPTION