APPS.CSP_RESOURCE_PUB dependencies on MTL_ITEM_LOCATIONS

Line 196: FROM mtl_item_locations

192: -- valide the p_locator_id if it is not null
193: IF p_locator_id IS NOT NULL THEN
194: BEGIN
195: SELECT inventory_location_id INTO l_check_existence
196: FROM mtl_item_locations
197: WHERE organization_id = p_organization_id
198: AND subinventory_code = p_subinventory_code
199: AND inventory_location_id = p_locator_id;
200:

Line 213: fnd_message.set_token('TABLE', 'mtl_item_locations', TRUE);

209: WHEN OTHERS THEN
210: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
211: fnd_message.set_token('ERR_FIELD', 'p_locator_id', TRUE);
212: fnd_message.set_token('ROUTINE', l_api_name, TRUE);
213: fnd_message.set_token('TABLE', 'mtl_item_locations', TRUE);
214: fnd_msg_pub.ADD;
215: --l_msg_data := 'Unexpected errors occurred while validating the Locator ID. Please contact your system administrator.';
216: RAISE EXCP_USER_DEFINED;
217: END;