DBA Data[Home] [Help]

APPS.WMS_RULE_PVT dependencies on INV_LOC_WMS_UTILS

Line 4132: log_statement(l_api_name, 'calling_revert', 'Calling inv_loc_wms_utils.revert_loc_suggested_capacity');

4128: -- to update if locator_id is null
4129: IF l_line.to_locator_id IS NOT NULL THEN
4130:
4131: IF l_debug = 1 THEN
4132: log_statement(l_api_name, 'calling_revert', 'Calling inv_loc_wms_utils.revert_loc_suggested_capacity');
4133: log_statement(l_api_name, 'revert_org', 'Org: ' || p_organization_id);
4134: log_statement(l_api_name, 'revert_item', 'Item: ' || p_inventory_item_id);
4135: log_statement(l_api_name, 'revert_loc', 'Loc: ' || l_line.to_locator_id);
4136: log_statement(l_api_name, 'revert_qty', 'Qty: ' || l_line.quantity);

Line 4138: inv_loc_wms_utils.revert_loc_suggested_capacity(

4134: log_statement(l_api_name, 'revert_item', 'Item: ' || p_inventory_item_id);
4135: log_statement(l_api_name, 'revert_loc', 'Loc: ' || l_line.to_locator_id);
4136: log_statement(l_api_name, 'revert_qty', 'Qty: ' || l_line.quantity);
4137: END IF;
4138: inv_loc_wms_utils.revert_loc_suggested_capacity(
4139: x_return_status => l_return_status
4140: , x_msg_count => l_msg_count
4141: , x_msg_data => l_msg_data
4142: , p_organization_id => p_organization_id

Line 4159: log_statement(l_api_name, 'first_error', 'Error in inv_loc_wms_utils.revert_loc_suggested_capacity');

4155: x_msg_data := l_msg_data;
4156: l_no_error := FALSE;
4157:
4158: IF l_debug = 1 THEN
4159: log_statement(l_api_name, 'first_error', 'Error in inv_loc_wms_utils.revert_loc_suggested_capacity');
4160: END IF;
4161: END IF;
4162: END IF;
4163: END LOOP;

Line 10461: inv_loc_wms_utils.update_loc_suggested_capacity(

10457: --IF l_olocator_id IS NOT NULL THEN Commented bug3237702
10458: IF l_debug = 1 THEN
10459: log_statement(l_api_name, 'update_capacity', 'Updating suggested capacity');
10460: END IF;
10461: inv_loc_wms_utils.update_loc_suggested_capacity(
10462: x_return_status => x_return_status
10463: , x_msg_count => x_msg_count
10464: , x_msg_data => x_msg_data
10465: , p_organization_id => p_organization_id

Line 10738: inv_loc_wms_utils.revert_loc_suggested_capacity(

10734: IF l_capacity_updated THEN
10735: IF l_debug = 1 THEN
10736: log_statement(l_api_name, 'revert_capacity', 'Calling revert_loc_suggested_capacity');
10737: END IF;
10738: inv_loc_wms_utils.revert_loc_suggested_capacity(
10739: x_return_status => x_return_status
10740: , x_msg_count => x_msg_count
10741: , x_msg_data => x_msg_data
10742: , p_organization_id => p_organization_id

Line 10881: inv_loc_wms_utils.revert_loc_suggested_capacity(

10877:
10878: --if error occurred after capacity got updated but before
10879: -- insertion into WTT, fix the capacity for that record
10880: IF l_capacity_updated THEN
10881: inv_loc_wms_utils.revert_loc_suggested_capacity(
10882: x_return_status => l_return_status
10883: , x_msg_count => l_msg_count
10884: , x_msg_data => l_msg_data
10885: , p_organization_id => p_organization_id

Line 10924: inv_loc_wms_utils.revert_loc_suggested_capacity(

10920:
10921: --if error occurred after capacity got updated but before
10922: -- insertion into WTT, fix the capacity for that record
10923: IF l_capacity_updated THEN
10924: inv_loc_wms_utils.revert_loc_suggested_capacity(
10925: x_return_status => l_return_status
10926: , x_msg_count => l_msg_count
10927: , x_msg_data => l_msg_data
10928: , p_organization_id => p_organization_id

Line 10967: inv_loc_wms_utils.revert_loc_suggested_capacity(

10963:
10964: --if error occurred after capacity got updated but before
10965: -- insertion into WTT, fix the capacity for that record
10966: IF l_capacity_updated THEN
10967: inv_loc_wms_utils.revert_loc_suggested_capacity(
10968: x_return_status => l_return_status
10969: , x_msg_count => l_msg_count
10970: , x_msg_data => l_msg_data
10971: , p_organization_id => p_organization_id