DBA Data[Home] [Help]

APPS.WMS_OP_INBOUND_PVT dependencies on INV_LOC_WMS_UTILS

Line 433: inv_loc_wms_utils.revert_loc_suggested_capacity --14341640 Making the call autonomous

429: print_debug('Suggested locator capacity of the Rules suggested locaotr needs to be reverted',l_module_name,9);
430: END IF;
431:
432: IF ( p_document_rec.locator_id IS NOT NULL) THEN
433: inv_loc_wms_utils.revert_loc_suggested_capacity --14341640 Making the call autonomous
434: (
435: x_return_status => l_return_status
436: , x_msg_count => l_msg_count
437: , x_msg_data => l_msg_data

Line 652: inv_loc_wms_utils.update_loc_sugg_cap_wo_empf(

648:
649: l_progress:=60;
650:
651: IF (p_update_param_rec.sug_location_id IS NOT NULL) THEN
652: inv_loc_wms_utils.update_loc_sugg_cap_wo_empf(
653: x_return_status => l_return_status
654: , x_msg_count => l_msg_count
655: , x_msg_data => l_msg_data
656: , p_organization_id => p_document_rec.organization_id

Line 2131: print_debug('Before calling inv_loc_wms_utils.revert_loc_suggested_cap_nauto with parameters:'||l_return_status,l_module_name,4);

2127: THEN
2128: -- Need to revert the suggested capacity of the destination locator
2129: -- Do not need to do this for MO sub transfer - inventory TM handles this.
2130: IF (l_debug=1) THEN
2131: print_debug('Before calling inv_loc_wms_utils.revert_loc_suggested_cap_nauto with parameters:'||l_return_status,l_module_name,4);
2132: print_debug('p_document_rec.organization_id = '|| p_document_rec.organization_id,l_module_name,4);
2133: print_debug('p_document_rec.transfer_to_location = '|| p_document_rec.transfer_to_location,l_module_name,4);
2134: print_debug('p_document_rec.locator_i = '|| p_document_rec.locator_id,l_module_name,4);
2135: print_debug('p_document_rec.inventory_item_id = '|| p_document_rec.inventory_item_id,l_module_name,4);

Line 2142: --inv_loc_wms_utils.revert_loc_suggested_cap_nauto commented for bug 5920044.

2138: print_debug('lpn passed :'||NVL(l_new_lpn_id,Nvl(l_mmtt_data_rec.transfer_lpn_id, l_mmtt_data_rec.content_lpn_id)),l_module_name,4);
2139: END IF;
2140:
2141: IF (Nvl(p_document_rec.transfer_to_location, p_document_rec.locator_id) IS NOT NULL) THEN
2142: --inv_loc_wms_utils.revert_loc_suggested_cap_nauto commented for bug 5920044.
2143: inv_loc_wms_utils.revert_loc_suggested_capacity --bug#5920044.
2144: (
2145: x_return_status => l_return_status
2146: , x_msg_count => l_msg_count

Line 2143: inv_loc_wms_utils.revert_loc_suggested_capacity --bug#5920044.

2139: END IF;
2140:
2141: IF (Nvl(p_document_rec.transfer_to_location, p_document_rec.locator_id) IS NOT NULL) THEN
2142: --inv_loc_wms_utils.revert_loc_suggested_cap_nauto commented for bug 5920044.
2143: inv_loc_wms_utils.revert_loc_suggested_capacity --bug#5920044.
2144: (
2145: x_return_status => l_return_status
2146: , x_msg_count => l_msg_count
2147: , x_msg_data => l_msg_data

Line 2159: inv_loc_wms_utils.loc_empty_mixed_flag_auto( --bug#10621843

2155: );
2156: END IF;
2157:
2158: --Bug#9644642 Calling api to set empty_mixed flag
2159: inv_loc_wms_utils.loc_empty_mixed_flag_auto( --bug#10621843
2160: x_return_status => l_return_status
2161: , x_msg_count => l_msg_count
2162: , x_msg_data => l_msg_data
2163: , p_organization_id => p_document_rec.organization_id

Line 2361: inv_loc_wms_utils.revert_loc_suggested_capacity --14341640 Making the call autonomous

2357: print_debug('Suggested locator capacity of the Rules suggested locaotr needs to be reverted',l_module_name,4);
2358: END IF;
2359:
2360: IF (Nvl(l_mmtt_data_rec.transfer_to_location, l_mmtt_data_rec.locator_id) IS NOT NULL) THEN
2361: inv_loc_wms_utils.revert_loc_suggested_capacity --14341640 Making the call autonomous
2362: (
2363: x_return_status => l_return_status
2364: , x_msg_count => l_msg_count
2365: , x_msg_data => l_msg_data

Line 2929: inv_loc_wms_utils.revert_loc_suggested_capacity --14341640 Making the call autonomous

2925: print_debug('Suggested locator capacity of the Rules suggested locaotr needs to be reverted',l_module_name,9);
2926: END IF;
2927:
2928: IF (l_parent_mmtt_rec.locator_id IS NOT NULL) THEN
2929: inv_loc_wms_utils.revert_loc_suggested_capacity --14341640 Making the call autonomous
2930: (
2931: x_return_status => l_return_status
2932: , x_msg_count => l_msg_count
2933: , x_msg_data => l_msg_data

Line 3141: print_debug('Call inv_loc_wms_utils.revert_loc_suggested_cap_nauto to revert capactity:',l_module_name,4);

3137:
3138: IF (p_plan_orig_loc_id IS NOT NULL) THEN
3139:
3140: IF l_debug=1 THEN
3141: print_debug('Call inv_loc_wms_utils.revert_loc_suggested_cap_nauto to revert capactity:',l_module_name,4);
3142: print_debug('p_organization_id => '||p_document_rec.organization_id,l_module_name,4);
3143: print_debug('p_inventory_location_id => '||p_plan_orig_loc_id,l_module_name,4);
3144: print_debug('p_inventory_item_id => '||p_document_rec.inventory_item_id,l_module_name,4);
3145: print_debug('p_quantity => '||p_document_rec.primary_quantity,l_module_name,4);

Line 3153: print_debug('inv_loc_wms_utils.Call revert_loc_suggested_capacity',l_module_name,4);

3149: END IF;
3150:
3151: IF(p_for_manual_drop = TRUE) THEN
3152: IF l_debug=1 THEN
3153: print_debug('inv_loc_wms_utils.Call revert_loc_suggested_capacity',l_module_name,4);
3154: END IF;
3155: inv_loc_wms_utils.revert_loc_suggested_capacity
3156: (
3157: x_return_status => l_return_status

Line 3155: inv_loc_wms_utils.revert_loc_suggested_capacity

3151: IF(p_for_manual_drop = TRUE) THEN
3152: IF l_debug=1 THEN
3153: print_debug('inv_loc_wms_utils.Call revert_loc_suggested_capacity',l_module_name,4);
3154: END IF;
3155: inv_loc_wms_utils.revert_loc_suggested_capacity
3156: (
3157: x_return_status => l_return_status
3158: , x_msg_count => l_msg_count
3159: , x_msg_data => l_msg_data

Line 3169: print_debug('inv_loc_wms_utils.Call revert_loc_suggested_cap_nauto',l_module_name,4);

3165: , p_quantity => p_document_rec.primary_quantity
3166: );
3167: ELSE
3168: IF l_debug=1 THEN
3169: print_debug('inv_loc_wms_utils.Call revert_loc_suggested_cap_nauto',l_module_name,4);
3170: END IF;
3171: inv_loc_wms_utils.revert_loc_suggested_cap_nauto
3172: (
3173: x_return_status => l_return_status

Line 3171: inv_loc_wms_utils.revert_loc_suggested_cap_nauto

3167: ELSE
3168: IF l_debug=1 THEN
3169: print_debug('inv_loc_wms_utils.Call revert_loc_suggested_cap_nauto',l_module_name,4);
3170: END IF;
3171: inv_loc_wms_utils.revert_loc_suggested_cap_nauto
3172: (
3173: x_return_status => l_return_status
3174: , x_msg_count => l_msg_count
3175: , x_msg_data => l_msg_data

Line 3187: print_debug('After calling inv_loc_wms_utils.revert_loc_suggested_cap_nauto:',l_module_name,4);

3183:
3184: END IF;
3185:
3186: IF l_debug=1 THEN
3187: print_debug('After calling inv_loc_wms_utils.revert_loc_suggested_cap_nauto:',l_module_name,4);
3188: print_debug('x_return_status => '||l_return_status,l_module_name,4);
3189: print_debug('x_msg_data => '||l_msg_data,l_module_name,4);
3190: print_debug('x_msg_count => '||l_msg_count,l_module_name,4);
3191: END IF;

Line 3195: print_debug('inv_loc_wms_utils.revert_loc_suggested_cap_nauto finished with error. l_return_status = ' || l_return_status,l_module_name,4);

3191: END IF;
3192:
3193: IF l_return_status <>FND_API.g_ret_sts_success THEN
3194: IF (l_debug=1) THEN
3195: print_debug('inv_loc_wms_utils.revert_loc_suggested_cap_nauto finished with error. l_return_status = ' || l_return_status,l_module_name,4);
3196: END IF;
3197:
3198: -- Bug 5369010: do not raise exception if locator capacity API fails
3199: -- RAISE FND_API.G_EXC_ERROR;