APPS.INV_LOC_WMS_PUB dependencies on MTL_TRANSACTIONS_INTERFACE
Line 2601: /*Check if the locator is present in MTL_TRANSACTIONS_INTERFACE
2597: WHEN NO_DATA_FOUND THEN
2598: NULL;
2599: END;
2600: 2601: /*Check if the locator is present in MTL_TRANSACTIONS_INTERFACE 2602: If the locator_id exists then error out*/
2603: BEGIN
2604: SELECT 1
2605: INTO l_chk_flag
Line 2608: FROM mtl_transactions_interface
2604: SELECT 1
2605: INTO l_chk_flag
2606: FROM DUAL
2607: WHERE EXISTS(SELECT 1 2608: FROM mtl_transactions_interface 2609: WHERE locator_id = l_inventory_location_id
2610: AND organization_id = l_organization_id);
2611:
2612: fnd_message.set_name('INV', 'INV_LOC_PENDTXN');