2323: -- joabraha :Added an exception around this select so that the exception when the item is is not Lot Cotrolled is caught
2324: -- and the API can proceed executing.
2325: Begin
2326: SELECT lot_control_code INTO l_lot_control_code
2327: FROM MTL_SYSTEM_ITEMS_B
2328: WHERE organization_id = p_organization_id
2329: AND inventory_item_id = p_inventory_item_id;
2330:
2331: Exception