DBA Data[Home] [Help]

APPS.CSP_MO_MTLTXNS_UTIL dependencies on MTL_ITEM_LOC_DEFAULTS

Line 1281: FROM mtl_item_loc_defaults

1277:
1278: IF l_restrict_locators_code = 1 THEN -- locators restricted to a predefined list.
1279: BEGIN
1280: SELECT locator_id INTO l_check_existence
1281: FROM mtl_item_loc_defaults
1282: WHERE inventory_item_id = l_inventory_item_id
1283: AND organization_id = p_organization_id
1284: AND locator_id = p_to_locator_id
1285: AND subinventory_code = p_to_subinventory_code;

Line 1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);

1291: WHEN OTHERS THEN
1292: fnd_message.set_name('CSP', 'CSP_UNEXPECTED_ERRORS');
1293: fnd_message.set_token('ERR_FIELD', 'p_to_locator_id', FALSE);
1294: fnd_message.set_token('ROUTINE', l_api_name, FALSE);
1295: fnd_message.set_token('TABLE', 'mtl_item_loc_defaults', FALSE);
1296: fnd_msg_pub.ADD;
1297: RAISE EXCP_USER_DEFINED;
1298: END;
1299: END IF;