DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_ITEM_LOCATIONS

Line 937: FROM mtl_item_locations

933: END IF;
934: IF p_to_locator_id IS NOT NULL THEN
935: BEGIN
936: SELECT inventory_location_id into l_check_existence
937: FROM mtl_item_locations
938: WHERE inventory_location_id = p_to_locator_id
939: AND organization_id = organization_id
940: AND subinventory_code = p_to_subinventory_code
941: AND nvl(disable_date, sysdate+1) > sysdate;

Line 951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);

947: WHEN OTHERS THEN
948: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
949: fnd_message.set_token('ERR_FIELD', 'p_locator_id', FALSE);
950: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
951: fnd_message.set_token('TABLE', 'mtl_item_locations', FALSE);
952: fnd_msg_pub.ADD;
953: RAISE EXCP_USER_DEFINED;
954: END;
955: END IF;