DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_GEN dependencies on WMS_GLOBALS

Line 8236: l_lpn_controlled_flag := wms_globals.g_non_lpn_controlled_sub;

8232: , l_operation_plan_id
8233: FROM mtl_material_transactions_temp mmtt
8234: WHERE mmtt.transaction_temp_id = p_temp_id;
8235:
8236: l_lpn_controlled_flag := wms_globals.g_non_lpn_controlled_sub;
8237:
8238: IF l_xfr_sub IS NOT NULL THEN
8239: SELECT lpn_controlled_flag
8240: INTO l_lpn_controlled_flag

Line 8247: AND l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN

8243: AND secondary_inventory_name = l_xfr_sub;
8244: END IF;
8245:
8246: IF l_xfr_sub IS NOT NULL
8247: AND l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN
8248: IF (l_debug = 1) THEN
8249: mydebug('validate_pick_to_lpn: Transfer Sub is LPN Controlled');
8250: END IF;
8251:

Line 8307: AND msi.lpn_controlled_flag = wms_globals.g_lpn_controlled_sub

8303: WHERE mmtt.transaction_temp_id <> p_temp_id
8304: AND mmtt.transfer_lpn_id = pick_to_lpn_rec.lpn_id
8305: AND msi.organization_id = p_organization_id
8306: AND msi.secondary_inventory_name = mmtt.transfer_subinventory
8307: AND msi.lpn_controlled_flag = wms_globals.g_lpn_controlled_sub
8308: );
8309: EXCEPTION
8310: WHEN NO_DATA_FOUND THEN
8311: l_count := 0;

Line 14228: IF l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN

14224: WHERE mmtt.transaction_temp_id = p_temp_id
14225: AND mmtt.organization_id = msi.organization_id
14226: AND msi.secondary_inventory_name = p_confirmed_drop_sub;
14227:
14228: IF l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN
14229: IF (l_mmtt_mo_type = 5) THEN
14230: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
14231: fnd_msg_pub.ADD;
14232: RAISE fnd_api.g_exc_error;