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 14491: IF l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN

14487: WHERE mmtt.transaction_temp_id = p_temp_id
14488: AND mmtt.organization_id = msi.organization_id
14489: AND msi.secondary_inventory_name = p_confirmed_drop_sub;
14490:
14491: IF l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN
14492: IF (l_mmtt_mo_type = 5) THEN
14493: /*Bug#9659710 for GME batches, the validation should not be there as it allows the move order transfer
14494: to a LPN controlled subinventory and allowd the material consumption from the same later */
14495: OPEN get_wip_entity_type;

Line 14628: IF l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN

14624: AND msi.secondary_inventory_name = p_confirmed_drop_sub;
14625:
14626: x_lpn_controlled_flag:=l_lpn_controlled_flag;
14627:
14628: IF l_lpn_controlled_flag = wms_globals.g_lpn_controlled_sub THEN
14629: IF (l_mmtt_mo_type = 5) THEN
14630: fnd_message.set_name('WMS', 'WMS_CONT_INVALID_SUB');
14631: fnd_msg_pub.ADD;
14632: RAISE fnd_api.g_exc_error;