[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
p_action_code => FTE_CARRIER_RANK_LIST_PVT.S_DELETE,
p_ranklist => l_temp_rank_tbl,
p_trip_id => P_FTE_SS_ATTR_REC.trip_id,
p_rank_id => null);
-- and update trip rank id to null. User is going to pick on again.
-- calling shipping API
FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
-- Update trip information
p_trip_info.RANK_ID := NULL;
p_trip_in_rec.action_code :='UPDATE';
WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
' Updating rank id to null in UIWrapper ' ,
WSH_DEBUG_SV.C_PROC_LEVEL);
WSH_INTERFACE_GRP.Create_Update_Trip
(
p_api_version_number =>p_api_version_number,
p_init_msg_list =>FND_API.G_FALSE,
p_commit =>FND_API.G_FALSE,
x_return_status =>l_return_status,
x_msg_count =>l_msg_count,
x_msg_data =>l_msg_data,
p_trip_info_tab =>p_trip_info_tab,
p_in_rec =>p_trip_in_rec,
x_out_tab =>x_out_tab
);
WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
l_return_status,
WSH_DEBUG_SV.C_PROC_LEVEL);
-- delete this from rank list table.
DELETE FTE_CARRIER_RANK_LIST
WHERE RANK_ID = l_rank_list_tbl(i).RANK_ID;
-- Update trip information
p_trip_info.RANK_ID := NULL;
p_trip_in_rec.action_code :='UPDATE';
WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
' Setting rank id to null in UIWrapper ',
WSH_DEBUG_SV.C_PROC_LEVEL);
WSH_INTERFACE_GRP.Create_Update_Trip
(
p_api_version_number =>p_api_version_number,
p_init_msg_list =>FND_API.G_FALSE,
p_commit =>FND_API.G_FALSE,
x_return_status =>l_return_status,
x_msg_count =>l_msg_count,
x_msg_data =>l_msg_data,
p_trip_info_tab =>p_trip_info_tab,
p_in_rec =>p_trip_in_rec,
x_out_tab =>x_out_tab
);
WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
l_return_status,
WSH_DEBUG_SV.C_PROC_LEVEL);
-- If trip is is null, in DWB case, we should not update the trip
-- because there is no trip. UI call is going to set append flag to N
-- later : HBHAGAVA
IF (P_FTE_SS_ATTR_REC.TRIP_ID IS NOT NULL)
THEN
FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
-- Update trip information
p_trip_info.APPEND_FLAG := 'N';
p_trip_in_rec.action_code :='UPDATE';
WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
' Updating append flag to N ',
WSH_DEBUG_SV.C_PROC_LEVEL);
WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
' Trip Id ' || p_trip_info.TRIP_ID,
WSH_DEBUG_SV.C_PROC_LEVEL);
WSH_INTERFACE_GRP.Create_Update_Trip
(
p_api_version_number =>p_api_version_number,
p_init_msg_list =>FND_API.G_FALSE,
p_commit =>FND_API.G_FALSE,
x_return_status =>l_return_status,
x_msg_count =>l_msg_count,
x_msg_data =>l_msg_data,
p_trip_info_tab =>p_trip_info_tab,
p_in_rec =>p_trip_in_rec,
x_out_tab =>x_out_tab
);
WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
l_return_status,
WSH_DEBUG_SV.C_PROC_LEVEL);
-- Update trip append flag to N
-- looping through
IF l_debug_on
THEN
LOG(l_module_name,' List Create Type ' || x_list_create_type,
WSH_DEBUG_SV.C_PROC_LEVEL);
-- Update trip append flag to N
-- Standard call to get message count and if count is 1,get message info.
--
FND_MSG_PUB.Count_And_Get
(
p_count => x_msg_count,
p_data => x_msg_data,
p_encoded => FND_API.G_FALSE
);
-- If p_service_action indicates service is currently assigned, delete old rates
-- and raise appropriate business event
IF ( p_service_action = 'UPDATE' AND l_trip_id IS NOT NULL
AND l_delivery_leg_id IS NULL ) THEN
IF l_debug_on THEN
WSH_DEBUG_SV.logmsg(l_module_name, 'Deleting Main Records for:'||l_trip_id);
FTE_TRIP_RATING_GRP.DELETE_MAIN_RECORDS(
p_trip_id => l_trip_id,
x_return_status => l_return_status);
-- CREATE: Manual condition, set IS_CURRENT for selected service
-- SET_CURRENT: Only pass user entry as current. Version is increased. Do no
-- pass service tab, only rankId
-- APPEND: Pass in one record service tab (entry has no rankId or sequence)
-- Entry appended to existing list with next ranked seq. Set IS_CURRENT on record.
-- OUT param is the new rankId to be stored on the trip
IF ( l_list_action IS NOT NULL AND l_trip_id IS NOT NULL) THEN
IF ( p_list_action = 'SET_CURRENT' ) THEN
FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
p_API_VERSION_NUMBER => 1.0,
p_INIT_MSG_LIST => FND_API.G_TRUE,
p_ACTION_CODE => l_list_action,
p_RANKLIST => p_ss_rate_sort_tab,
p_RANK_ID => l_rank_id,
p_TRIP_ID => l_trip_id,
x_RETURN_STATUS => l_return_status,
x_MSG_COUNT => l_msg_count,
x_MSG_DATA => l_msg_data);
-- Step 4: Update Trip
-- If delivery_id is null, this call is coming from TripWB. Update Trip with
-- current service from FTE_SS_ATTR_REC and rank id.
-- Else this call is coming from DWB or MI. Update Trip with Rank Id only.
-- Step 4a: Set reprice flag to N
IF l_trip_id IS NOT NULL THEN
FTE_FREIGHT_PRICING.unmark_reprice_required(
p_segment_id => l_trip_id,
x_return_status => l_return_status);
FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
p_API_VERSION_NUMBER => 1.0,
p_INIT_MSG_LIST => FND_API.G_TRUE,
p_COMMIT => FND_API.G_FALSE,
p_CALLER => 'FTE',
p_SERVICE_ACTION => p_service_action,
p_DELIVERY_ID => l_delivery_id,
p_DELIVERY_LEG_ID => l_delivery_leg_id,
p_TRIP_ID => l_trip_id,
p_LANE_ID => l_lane_id,
p_SCHEDULE_ID => null, -- Need to change to real schedule
p_CARRIER_ID => l_carrier_id,
p_SERVICE_LEVEL => l_service_level,
p_MODE_OF_TRANSPORT => l_mode,
p_VEHICLE_ITEM_ID => l_veh_item_id,
p_VEHICLE_ORG_ID => l_veh_org_id,
p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
x_RETURN_STATUS => l_return_status,
x_MSG_COUNT => l_msg_count,
x_MSG_DATA => l_msg_data);
FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
p_API_VERSION_NUMBER => 1.0,
p_INIT_MSG_LIST => FND_API.G_TRUE,
p_COMMIT => FND_API.G_FALSE,
p_CALLER => 'FTE',
p_SERVICE_ACTION => p_service_action,
p_DELIVERY_ID => l_delivery_id,
p_DELIVERY_LEG_ID => l_delivery_leg_id,
p_TRIP_ID => l_trip_id,
p_LANE_ID => FND_API.G_MISS_NUM,
p_SCHEDULE_ID => FND_API.G_MISS_NUM,
p_CARRIER_ID => FND_API.G_MISS_NUM,
p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
x_RETURN_STATUS => l_return_status,
x_MSG_COUNT => l_msg_count,
x_MSG_DATA => l_msg_data);
WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP');