673: OPEN C1;
674: FETCH C1 INTO l_container_id, l_delivery_id;
675: CLOSE C1;
676:
677: l_user_id := FND_GLOBAL.user_id;
678: l_login_id := FND_GLOBAL.login_id;
679:
680: OPEN get_pref_grade(p_delivery_detail_id);
681: FETCH get_pref_grade INTO l_oeline_pref_grade,
674: FETCH C1 INTO l_container_id, l_delivery_id;
675: CLOSE C1;
676:
677: l_user_id := FND_GLOBAL.user_id;
678: l_login_id := FND_GLOBAL.login_id;
679:
680: OPEN get_pref_grade(p_delivery_detail_id);
681: FETCH get_pref_grade INTO l_oeline_pref_grade,
682: l_organization_id, l_line_direction; -- LPN CONV. rv
3711:
3712: -- deliveryMerge
3713: l_adjust_planned_del_tab.delete;
3714:
3715: l_user_id := FND_GLOBAL.user_id;
3716: l_login_id := FND_GLOBAL.login_id;
3717:
3718: --
3719: -- Debug Statements
3712: -- deliveryMerge
3713: l_adjust_planned_del_tab.delete;
3714:
3715: l_user_id := FND_GLOBAL.user_id;
3716: l_login_id := FND_GLOBAL.login_id;
3717:
3718: --
3719: -- Debug Statements
3720: --
4450: -- Setting Backorder Flag as TRUE so that request ends with Warning
4451: WSH_PICK_LIST.G_BACKORDERED := TRUE;
4452: --BUG#:1549665 hwahdani log exception if running from conc. request
4453: -- and action is backorder
4454: l_request_id := fnd_global.conc_request_id;
4455: -- 1729516
4456: IF ( l_request_id <> -1 OR
4457: p_changed_attributes(l_Counter).cycle_count_quantity = FND_API.G_MISS_NUM OR
4458: WSH_PICK_LIST.G_BATCH_ID IS NOT NULL ) THEN
4735: x_exception_id => l_dummy_exception_id ,
4736: p_logged_at_location_id => l_exception_location_id,
4737: p_exception_location_id => l_exception_location_id,
4738: p_logging_entity => 'SHIPPER',
4739: p_logging_entity_id => FND_GLOBAL.USER_ID,
4740: p_exception_name => 'WSH_PICK_BACKORDER',
4741: p_message => l_msg ,
4742: p_error_message => l_exception_error_message,
4743: p_request_id => l_request_id,
4796: x_exception_id => l_dummy_exception_id ,
4797: p_logged_at_location_id => l_exception_location_id,
4798: p_exception_location_id => l_exception_location_id,
4799: p_logging_entity => 'SHIPPER',
4800: p_logging_entity_id => FND_GLOBAL.USER_ID,
4801: p_exception_name => 'WSH_PICK_BACKORDER',
4802: p_message => l_msg ,
4803: p_error_message => l_exception_error_message,
4804: p_inventory_item_id => old_delivery_detail_rec.inventory_item_id,--Bug:1646466
4864: x_exception_id => l_dummy_exception_id ,
4865: p_logged_at_location_id => l_exception_location_id,
4866: p_exception_location_id => l_exception_location_id,
4867: p_logging_entity => 'SHIPPER',
4868: p_logging_entity_id => FND_GLOBAL.USER_ID,
4869: p_exception_name => 'WSH_PICK_BACKORDER',
4870: p_message => l_msg ,
4871: p_error_message => l_exception_error_message,
4872: p_inventory_item_id => old_delivery_detail_rec.inventory_item_id,--Bug:1646466
5184: x_exception_id => l_dummy_exception_id ,
5185: p_logged_at_location_id => l_exception_location_id,
5186: p_exception_location_id => l_exception_location_id,
5187: p_logging_entity => 'SHIPPER',
5188: p_logging_entity_id => FND_GLOBAL.USER_ID,
5189: p_exception_name => 'WSH_INVALID_PACKING',
5190: p_message => l_msg,
5191: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id,
5192: p_subinventory => p_changed_attributes(l_Counter).transfer_lpn_id,