APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on MTL_LOT_NUMBERS

Line 1579: FROM MTL_LOT_NUMBERS

1575: -- Check for the existance of lot number in Inventory for the current item
1576: BEGIN
1577: SELECT 'x'
1578: INTO l_temp
1579: FROM MTL_LOT_NUMBERS
1580: WHERE inventory_item_id = p_inv_item_id
1581: AND organization_id = p_inv_org_id
1582: AND lot_number = p_lot_number;
1583: EXCEPTION

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

1621: FND_MSG_PUB.ADD;
1622: RAISE comp_error;
1623: ELSE
1624: l_return_value := TRUE;
1625: csi_gen_utility_pvt.put_line('Lot Number created successfully in MTL_LOT_NUMBERS..');
1626: END IF;
1627: END IF; -- l_temp is null
1628: --
1629: EXCEPTION