63: SAVEPOINT ASSIGN_SERVICE_TENDER_PUB;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: --
67: IF FND_API.to_Boolean( p_init_msg_list )
68: THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71: --
161: IF ( l_list_action IS NOT NULL AND l_trip_id IS NOT NULL) THEN
162: IF ( p_list_action = 'SET_CURRENT' ) THEN
163: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
164: p_API_VERSION_NUMBER => 1.0,
165: p_INIT_MSG_LIST => FND_API.G_TRUE,
166: p_ACTION_CODE => l_list_action,
167: p_RANKLIST => p_ss_rate_sort_tab,
168: p_RANK_ID => l_rank_id,
169: p_TRIP_ID => l_trip_id,
172: x_MSG_DATA => l_msg_data);
173: ELSE
174: FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION_UIWRAPPER(
175: p_API_VERSION_NUMBER => 1.0,
176: p_INIT_MSG_LIST => FND_API.G_TRUE,
177: p_ACTION_CODE => l_list_action,
178: p_RANKLIST => p_ss_rate_sort_tab,
179: p_RANK_ID => l_rank_id,
180: p_TRIP_ID => l_trip_id,
211: l_veh_org_id := p_ss_attr_rec.vehicle_org_id;
212:
213: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
214: p_API_VERSION_NUMBER => 1.0,
215: p_INIT_MSG_LIST => FND_API.G_TRUE,
216: p_COMMIT => FND_API.G_FALSE,
217: p_CALLER => 'FTE',
218: p_SERVICE_ACTION => p_service_action,
219: p_DELIVERY_ID => l_delivery_id,
212:
213: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
214: p_API_VERSION_NUMBER => 1.0,
215: p_INIT_MSG_LIST => FND_API.G_TRUE,
216: p_COMMIT => FND_API.G_FALSE,
217: p_CALLER => 'FTE',
218: p_SERVICE_ACTION => p_service_action,
219: p_DELIVERY_ID => l_delivery_id,
220: p_DELIVERY_LEG_ID => l_delivery_leg_id,
225: p_SERVICE_LEVEL => l_service_level,
226: p_MODE_OF_TRANSPORT => l_mode,
227: p_VEHICLE_ITEM_ID => l_veh_item_id,
228: p_VEHICLE_ORG_ID => l_veh_org_id,
229: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
230: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
231: x_RETURN_STATUS => l_return_status,
232: x_MSG_COUNT => l_msg_count,
233: x_MSG_DATA => l_msg_data);
226: p_MODE_OF_TRANSPORT => l_mode,
227: p_VEHICLE_ITEM_ID => l_veh_item_id,
228: p_VEHICLE_ORG_ID => l_veh_org_id,
229: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
230: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
231: x_RETURN_STATUS => l_return_status,
232: x_MSG_COUNT => l_msg_count,
233: x_MSG_DATA => l_msg_data);
234:
234:
235: ELSE -- Coming from DWB/MI
236: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
237: p_API_VERSION_NUMBER => 1.0,
238: p_INIT_MSG_LIST => FND_API.G_TRUE,
239: p_COMMIT => FND_API.G_FALSE,
240: p_CALLER => 'FTE',
241: p_SERVICE_ACTION => p_service_action,
242: p_DELIVERY_ID => l_delivery_id,
235: ELSE -- Coming from DWB/MI
236: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
237: p_API_VERSION_NUMBER => 1.0,
238: p_INIT_MSG_LIST => FND_API.G_TRUE,
239: p_COMMIT => FND_API.G_FALSE,
240: p_CALLER => 'FTE',
241: p_SERVICE_ACTION => p_service_action,
242: p_DELIVERY_ID => l_delivery_id,
243: p_DELIVERY_LEG_ID => l_delivery_leg_id,
241: p_SERVICE_ACTION => p_service_action,
242: p_DELIVERY_ID => l_delivery_id,
243: p_DELIVERY_LEG_ID => l_delivery_leg_id,
244: p_TRIP_ID => l_trip_id,
245: p_LANE_ID => FND_API.G_MISS_NUM,
246: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
247: p_CARRIER_ID => FND_API.G_MISS_NUM,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
242: p_DELIVERY_ID => l_delivery_id,
243: p_DELIVERY_LEG_ID => l_delivery_leg_id,
244: p_TRIP_ID => l_trip_id,
245: p_LANE_ID => FND_API.G_MISS_NUM,
246: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
247: p_CARRIER_ID => FND_API.G_MISS_NUM,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
243: p_DELIVERY_LEG_ID => l_delivery_leg_id,
244: p_TRIP_ID => l_trip_id,
245: p_LANE_ID => FND_API.G_MISS_NUM,
246: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
247: p_CARRIER_ID => FND_API.G_MISS_NUM,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
251: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
244: p_TRIP_ID => l_trip_id,
245: p_LANE_ID => FND_API.G_MISS_NUM,
246: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
247: p_CARRIER_ID => FND_API.G_MISS_NUM,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
251: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
252: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
245: p_LANE_ID => FND_API.G_MISS_NUM,
246: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
247: p_CARRIER_ID => FND_API.G_MISS_NUM,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
251: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
252: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
253: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
246: p_SCHEDULE_ID => FND_API.G_MISS_NUM,
247: p_CARRIER_ID => FND_API.G_MISS_NUM,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
251: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
252: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
253: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
254: x_RETURN_STATUS => l_return_status,
247: p_CARRIER_ID => FND_API.G_MISS_NUM,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
251: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
252: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
253: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
254: x_RETURN_STATUS => l_return_status,
255: x_MSG_COUNT => l_msg_count,
248: p_SERVICE_LEVEL => FND_API.G_MISS_CHAR,
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
251: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
252: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
253: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
254: x_RETURN_STATUS => l_return_status,
255: x_MSG_COUNT => l_msg_count,
256: x_MSG_DATA => l_msg_data);
249: p_MODE_OF_TRANSPORT => FND_API.G_MISS_CHAR,
250: p_VEHICLE_ITEM_ID => FND_API.G_MISS_NUM,
251: p_VEHICLE_ORG_ID => FND_API.G_MISS_NUM,
252: p_CONSIGNEE_CARRIER_AC_NO => FND_API.G_MISS_CHAR,
253: p_FREIGHT_TERMS_CODE => FND_API.G_MISS_CHAR,
254: x_RETURN_STATUS => l_return_status,
255: x_MSG_COUNT => l_msg_count,
256: x_MSG_DATA => l_msg_data);
257: END IF;
278: /*
279: ELSE -- Coming from DWB/MI
280:
281: FTE_FREIGHT_PRICING.MOVE_FC_TEMP_TO_MAIN(
282: p_init_msg_list => FND_API.G_FALSE,
283: p_request_id => p_request_id,
284: p_trip_id => l_trip_id,
285: p_lane_id => l_lane_id,
286: p_schedule_id => l_schedule_id,
319: null,null);
320:
321: FTE_MLS_WRAPPER.TRIP_ACTION(
322: p_api_version_number => 1.0,
323: p_init_msg_list => FND_API.G_TRUE,
324: p_action_prms => l_trip_action_param,
325: p_trip_info_rec => p_tender_attr_rec,
326: x_action_out_rec => l_action_out_rec,
327: x_return_status => l_return_status,
340: WSH_DEBUG_SV.POP(l_module_name);
341: END IF;
342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get
348: (
342:
343: EXCEPTION
344: WHEN FND_API.G_EXC_ERROR THEN
345: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
346: x_return_status := FND_API.G_RET_STS_ERROR;
347: FND_MSG_PUB.Count_And_Get
348: (
349: p_count => x_msg_count,
350: p_data => x_msg_data,
347: FND_MSG_PUB.Count_And_Get
348: (
349: p_count => x_msg_count,
350: p_data => x_msg_data,
351: p_encoded => FND_API.G_FALSE
352: );
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
349: p_count => x_msg_count,
350: p_data => x_msg_data,
351: p_encoded => FND_API.G_FALSE
352: );
353: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
354: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
355: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
356: FND_MSG_PUB.Count_And_Get
357: (
356: FND_MSG_PUB.Count_And_Get
357: (
358: p_count => x_msg_count,
359: p_data => x_msg_data,
360: p_encoded => FND_API.G_FALSE
361: );
362: WHEN OTHERS THEN
363: ROLLBACK TO ASSIGN_SERVICE_TENDER_PUB;
364: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
365: FND_MSG_PUB.Count_And_Get
366: (
367: p_count => x_msg_count,
368: p_data => x_msg_data,
369: p_encoded => FND_API.G_FALSE
370: );
371: END ASSIGN_SERVICE_TENDER;
372: --
373: PROCEDURE SEARCH_SERVICES
397:
398:
399: -- Initialize message list if p_init_msg_list is set to TRUE.
400: --
401: --IF FND_API.to_Boolean( p_init_msg_list )
402: --THEN
403: FND_MSG_PUB.initialize;
404: --END IF;
405: --
449: x_PRICING_REQUEST_ID := 21;
450:
451: --
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: ROLLBACK TO SEARCH_SERVICES_PUB;
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.Count_And_Get
457: (
451: --
452: EXCEPTION
453: WHEN FND_API.G_EXC_ERROR THEN
454: ROLLBACK TO SEARCH_SERVICES_PUB;
455: x_return_status := FND_API.G_RET_STS_ERROR;
456: FND_MSG_PUB.Count_And_Get
457: (
458: p_count => x_msg_count,
459: p_data => x_msg_data,
456: FND_MSG_PUB.Count_And_Get
457: (
458: p_count => x_msg_count,
459: p_data => x_msg_data,
460: p_encoded => FND_API.G_FALSE
461: );
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: ROLLBACK TO SEARCH_SERVICES_PUB;
464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
458: p_count => x_msg_count,
459: p_data => x_msg_data,
460: p_encoded => FND_API.G_FALSE
461: );
462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
463: ROLLBACK TO SEARCH_SERVICES_PUB;
464: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
465: FND_MSG_PUB.Count_And_Get
466: (
465: FND_MSG_PUB.Count_And_Get
466: (
467: p_count => x_msg_count,
468: p_data => x_msg_data,
469: p_encoded => FND_API.G_FALSE
470: );
471: WHEN OTHERS THEN
472: ROLLBACK TO SEARCH_SERVICES_PUB;
473: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
474: FND_MSG_PUB.Count_And_Get
475: (
476: p_count => x_msg_count,
477: p_data => x_msg_data,
478: p_encoded => FND_API.G_FALSE
479: );
480: END SEARCH_SERVICES;
481: --
482: END FTE_MLS_TEST_NT;