[Home] [Help]
18:
19:
20: BEGIN
21:
22: WSH_DEBUG_SV.logmsg(p_module_name,p_text,p_level);
23:
24: END LOG;
25:
26:
158: IS
159:
160: l_api_name CONSTANT VARCHAR2(30) := 'SET_RANK_CURRENT';
161: l_api_version CONSTANT NUMBER := 1.0;
162: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
163: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
164:
165:
166: l_return_status VARCHAR2(32767);
198:
199: SAVEPOINT SET_RANK_CURRENT_PUB;
200:
201: IF l_debug_on THEN
202: WSH_DEBUG_SV.push(l_module_name);
203: END IF;
204:
205: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
206:
207:
208: IF l_debug_on
209: THEN
210: Log(l_module_name,' Calling Update Rank to update version ' ,
211: WSH_DEBUG_SV.C_PROC_LEVEL);
212: END IF;
213:
214: UPDATE_RANK(p_rank_info_rec => p_rank_info_rec,
215: x_return_status => l_return_status);
227:
228: IF l_debug_on
229: THEN
230: Log(l_module_name,' Update trip with rank id ' || p_rank_info_rec.rank_id,
231: WSH_DEBUG_SV.C_PROC_LEVEL);
232: END IF;
233:
234:
235: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
244: p_trip_in_rec.action_code :='UPDATE';
245:
246: IF l_debug_on
247: THEN
248: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ',
249: WSH_DEBUG_SV.C_PROC_LEVEL);
250: END IF;
251:
252:
245:
246: IF l_debug_on
247: THEN
248: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ',
249: WSH_DEBUG_SV.C_PROC_LEVEL);
250: END IF;
251:
252:
253: WSH_INTERFACE_GRP.Create_Update_Trip
264: );
265:
266: IF l_debug_on
267: THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
269: l_return_status,
270: WSH_DEBUG_SV.C_PROC_LEVEL);
271: END IF;
272:
266: IF l_debug_on
267: THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
269: l_return_status,
270: WSH_DEBUG_SV.C_PROC_LEVEL);
271: END IF;
272:
273: wsh_util_core.api_post_call(
274: p_return_status =>l_return_status,
289: END IF;
290:
291:
292: IF l_debug_on THEN
293: WSH_DEBUG_SV.pop(l_module_name);
294: END IF;
295:
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO SET_RANK_CURRENT_PUB;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.pop(l_module_name);
302: END IF;
303:
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK TO SET_RANK_CURRENT_PUB;
304: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
305: ROLLBACK TO SET_RANK_CURRENT_PUB;
306: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
307: IF l_debug_on THEN
308: WSH_DEBUG_SV.pop(l_module_name);
309: END IF;
310:
311: WHEN OTHERS THEN
312: ROLLBACK TO SET_RANK_CURRENT_PUB;
312: ROLLBACK TO SET_RANK_CURRENT_PUB;
313: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.SET_RANK_CURRENT');
314: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
315: IF l_debug_on THEN
316: WSH_DEBUG_SV.pop(l_module_name);
317: END IF;
318:
319: END SET_RANK_CURRENT;
320:
326: ) IS
327:
328: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RANK';
329: l_api_version CONSTANT NUMBER := 1.0;
330: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
331: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
332:
333:
334: l_tender_status VARCHAR2(30);
355:
356: BEGIN
357:
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.push(l_module_name);
360: END IF;
361:
362:
363: x_return_Status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
435: p_trip_in_rec.action_code :='UPDATE';
436:
437: IF l_debug_on
438: THEN
439: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ',
440: WSH_DEBUG_SV.C_PROC_LEVEL);
441: END IF;
442:
443:
436:
437: IF l_debug_on
438: THEN
439: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ',
440: WSH_DEBUG_SV.C_PROC_LEVEL);
441: END IF;
442:
443:
444: WSH_INTERFACE_GRP.Create_Update_Trip
455: );
456:
457: IF l_debug_on
458: THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
460: l_return_status,
461: WSH_DEBUG_SV.C_PROC_LEVEL);
462: END IF;
463:
457: IF l_debug_on
458: THEN
459: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
460: l_return_status,
461: WSH_DEBUG_SV.C_PROC_LEVEL);
462: END IF;
463:
464: wsh_util_core.api_post_call(
465: p_return_status =>l_return_status,
480:
481: IF l_debug_on
482: THEN
483: Log(l_module_name,' Return value after deleting RANK LIST ' || x_return_status,
484: WSH_DEBUG_SV.C_PROC_LEVEL);
485: END IF;
486:
487:
488: IF l_debug_on THEN
485: END IF;
486:
487:
488: IF l_debug_on THEN
489: WSH_DEBUG_SV.pop(l_module_name);
490: END IF;
491:
492:
493: EXCEPTION
495: x_return_status := FND_API.G_RET_STS_ERROR;
496: IF l_debug_on
497: THEN
498: Log(l_module_name,' Return value from DELETE_RANK_LIST ' || x_return_status,
499: WSH_DEBUG_SV.C_PROC_LEVEL);
500: END IF;
501:
502: IF l_debug_on THEN
503: WSH_DEBUG_SV.pop(l_module_name);
499: WSH_DEBUG_SV.C_PROC_LEVEL);
500: END IF;
501:
502: IF l_debug_on THEN
503: WSH_DEBUG_SV.pop(l_module_name);
504: END IF;
505: WHEN others THEN
506: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST');
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
505: WHEN others THEN
506: wsh_util_core.default_handler('FTE_CARRIER_RANK_LIST_PVT.DELETE_RANK_LIST');
507: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
508: IF l_debug_on THEN
509: WSH_DEBUG_SV.pop(l_module_name);
510: END IF;
511:
512: END DELETE_RANK_LIST;
513:
519: ) IS
520:
521: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RANK';
522: l_api_version CONSTANT NUMBER := 1.0;
523: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
524: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
525:
526:
527: CURSOR get_next_rank_id IS
537:
538: BEGIN
539:
540: IF l_debug_on THEN
541: WSH_DEBUG_SV.push(l_module_name);
542: END IF;
543:
544:
545: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
562:
563:
564: l_config := '';
565: Log(l_module_name,' Derive init sm config ' || p_derive_init_sm_config,
566: WSH_DEBUG_SV.C_PROC_LEVEL);
567:
568:
569: IF (p_derive_init_sm_config = FND_API.G_FALSE)
570: THEN
569: IF (p_derive_init_sm_config = FND_API.G_FALSE)
570: THEN
571: l_config := p_rank_info_rec.INITSMCONFIG;
572: Log(l_module_name,' l_config ' || l_config,
573: WSH_DEBUG_SV.C_PROC_LEVEL);
574:
575: ELSE
576:
577: IF (p_rank_info_rec.CARRIER_ID IS NOT NULL) THEN
589:
590: IF l_debug_on
591: THEN
592:
593: Log(l_module_name,' Creating Rank list Entry ' , WSH_DEBUG_SV.C_PROC_LEVEL);
594: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
595: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
590: IF l_debug_on
591: THEN
592:
593: Log(l_module_name,' Creating Rank list Entry ' , WSH_DEBUG_SV.C_PROC_LEVEL);
594: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
595: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
591: THEN
592:
593: Log(l_module_name,' Creating Rank list Entry ' , WSH_DEBUG_SV.C_PROC_LEVEL);
594: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
595: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
592:
593: Log(l_module_name,' Creating Rank list Entry ' , WSH_DEBUG_SV.C_PROC_LEVEL);
594: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
595: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
593: Log(l_module_name,' Creating Rank list Entry ' , WSH_DEBUG_SV.C_PROC_LEVEL);
594: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
595: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
594: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
595: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
595: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
596: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
597: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
598: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
599: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
600: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
608: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
601: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
608: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
609: Log(l_module_name,' l_config ' || l_config ,WSH_DEBUG_SV.C_PROC_LEVEL);
602: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
608: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
609: Log(l_module_name,' l_config ' || l_config ,WSH_DEBUG_SV.C_PROC_LEVEL);
610: Log(l_module_name,' p_rank_info_rec.CALL_RG_FLAG ' || p_rank_info_rec.CALL_RG_FLAG,WSH_DEBUG_SV.C_PROC_LEVEL);
603: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
608: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
609: Log(l_module_name,' l_config ' || l_config ,WSH_DEBUG_SV.C_PROC_LEVEL);
610: Log(l_module_name,' p_rank_info_rec.CALL_RG_FLAG ' || p_rank_info_rec.CALL_RG_FLAG,WSH_DEBUG_SV.C_PROC_LEVEL);
611: END IF;
604: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
608: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
609: Log(l_module_name,' l_config ' || l_config ,WSH_DEBUG_SV.C_PROC_LEVEL);
610: Log(l_module_name,' p_rank_info_rec.CALL_RG_FLAG ' || p_rank_info_rec.CALL_RG_FLAG,WSH_DEBUG_SV.C_PROC_LEVEL);
611: END IF;
612:
605: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
608: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
609: Log(l_module_name,' l_config ' || l_config ,WSH_DEBUG_SV.C_PROC_LEVEL);
610: Log(l_module_name,' p_rank_info_rec.CALL_RG_FLAG ' || p_rank_info_rec.CALL_RG_FLAG,WSH_DEBUG_SV.C_PROC_LEVEL);
611: END IF;
612:
613:
606: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
607: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
608: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
609: Log(l_module_name,' l_config ' || l_config ,WSH_DEBUG_SV.C_PROC_LEVEL);
610: Log(l_module_name,' p_rank_info_rec.CALL_RG_FLAG ' || p_rank_info_rec.CALL_RG_FLAG,WSH_DEBUG_SV.C_PROC_LEVEL);
611: END IF;
612:
613:
614: insert into FTE_CARRIER_RANK_LIST
703: decode(p_rank_info_rec.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_rank_info_rec.last_update_login)
704: );
705:
706: IF l_debug_on THEN
707: WSH_DEBUG_SV.pop(l_module_name);
708: END IF;
709:
710:
711: EXCEPTION
730: ) IS
731:
732: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RANK_LIST';
733: l_api_version CONSTANT NUMBER := 1.0;
734: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
735: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
736:
737:
738: l_return_status VARCHAR2(32767);
770:
771: SAVEPOINT CREATE_RANK_LIST_PUB;
772:
773: IF l_debug_on THEN
774: WSH_DEBUG_SV.push(l_module_name);
775: END IF;
776:
777: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
778:
779: --{
780: IF l_debug_on
781: THEN
782: Log(l_module_name,' Creating Rank List for trip ' || p_trip_id,
783: WSH_DEBUG_SV.C_PROC_LEVEL);
784: END IF;
785:
786: -- Check if rank list exists for tis trip
787:
826:
827: IF l_debug_on
828: THEN
829: Log(l_module_name,' Rank Id ' || l_rank_id,
830: WSH_DEBUG_SV.C_PROC_LEVEL);
831: Log(l_module_name,' IS CURRENT ' || p_ranklist(i).IS_CURRENT,
832: WSH_DEBUG_SV.C_PROC_LEVEL);
833: Log(l_module_name,' Return value ' || p_ranklist(i).IS_CURRENT,
834: WSH_DEBUG_SV.C_PROC_LEVEL);
828: THEN
829: Log(l_module_name,' Rank Id ' || l_rank_id,
830: WSH_DEBUG_SV.C_PROC_LEVEL);
831: Log(l_module_name,' IS CURRENT ' || p_ranklist(i).IS_CURRENT,
832: WSH_DEBUG_SV.C_PROC_LEVEL);
833: Log(l_module_name,' Return value ' || p_ranklist(i).IS_CURRENT,
834: WSH_DEBUG_SV.C_PROC_LEVEL);
835:
836: END IF;
830: WSH_DEBUG_SV.C_PROC_LEVEL);
831: Log(l_module_name,' IS CURRENT ' || p_ranklist(i).IS_CURRENT,
832: WSH_DEBUG_SV.C_PROC_LEVEL);
833: Log(l_module_name,' Return value ' || p_ranklist(i).IS_CURRENT,
834: WSH_DEBUG_SV.C_PROC_LEVEL);
835:
836: END IF;
837:
838:
853:
854: IF l_debug_on
855: THEN
856: Log(l_module_name,' Calling SET RANK CURRENT API ',
857: WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859:
860:
861: SET_RANK_CURRENT(p_rank_info_rec => p_ranklist(i),
864:
865: IF l_debug_on
866: THEN
867: Log(l_module_name,' After calling SET_RANK_CURRENT ' || l_return_status,
868: WSH_DEBUG_SV.C_PROC_LEVEL);
869: END IF;
870:
871:
872:
903:
904: END LOOP;
905:
906: IF l_debug_on THEN
907: WSH_DEBUG_SV.pop(l_module_name);
908: END IF;
909:
910: EXCEPTION
911: WHEN FND_API.G_EXC_ERROR THEN
911: WHEN FND_API.G_EXC_ERROR THEN
912: ROLLBACK TO CREATE_RANK_LIST_PUB;
913: x_return_status := FND_API.G_RET_STS_ERROR;
914: IF l_debug_on THEN
915: WSH_DEBUG_SV.pop(l_module_name);
916: END IF;
917:
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: ROLLBACK TO CREATE_RANK_LIST_PUB;
918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
919: ROLLBACK TO CREATE_RANK_LIST_PUB;
920: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
921: IF l_debug_on THEN
922: WSH_DEBUG_SV.pop(l_module_name);
923: END IF;
924:
925: WHEN OTHERS THEN
926: ROLLBACK TO CREATE_RANK_LIST_PUB;
926: ROLLBACK TO CREATE_RANK_LIST_PUB;
927: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.CREATE_RANK_LIST');
928: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
929: IF l_debug_on THEN
930: WSH_DEBUG_SV.pop(l_module_name);
931: END IF;
932:
933: END CREATE_RANK_LIST;
934:
940: ) IS
941:
942: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RANK_LIST';
943: l_api_version CONSTANT NUMBER := 1.0;
944: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
945: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
946:
947:
948: l_return_status VARCHAR2(32767);
970:
971: SAVEPOINT UPDATE_RANK_LIST_PUB;
972:
973: IF l_debug_on THEN
974: WSH_DEBUG_SV.push(l_module_name);
975: END IF;
976:
977: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
978:
979: --{
980: IF l_debug_on
981: THEN
982: Log(l_module_name,' Updating Rank List for trip ' || p_trip_id,
983: WSH_DEBUG_SV.C_PROC_LEVEL);
984: END IF;
985:
986: -- Check if rank list exists for tis trip
987:
1009:
1010: IF l_debug_on
1011: THEN
1012: Log(l_module_name,' Updating Rank id ' || p_ranklist(i).RANK_ID,
1013: WSH_DEBUG_SV.C_PROC_LEVEL);
1014: END IF;
1015:
1016:
1017: UPDATE_RANK(p_rank_info_rec => p_ranklist(i),
1033: --}
1034: END IF;
1035:
1036: IF l_debug_on THEN
1037: WSH_DEBUG_SV.pop(l_module_name);
1038: END IF;
1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: IF l_debug_on THEN
1045: WSH_DEBUG_SV.pop(l_module_name);
1046: END IF;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1050: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1051: IF l_debug_on THEN
1052: WSH_DEBUG_SV.pop(l_module_name);
1053: END IF;
1054:
1055: WHEN OTHERS THEN
1056: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1056: ROLLBACK TO UPDATE_RANK_LIST_PUB;
1057: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.UPDATE_RANK_LIST');
1058: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1059: IF l_debug_on THEN
1060: WSH_DEBUG_SV.pop(l_module_name);
1061: END IF;
1062:
1063: END UPDATE_RANK_LIST;
1064:
1072: ) IS
1073:
1074: l_api_name CONSTANT VARCHAR2(30) := 'APPEND_RANK_LIST';
1075: l_api_version CONSTANT NUMBER := 1.0;
1076: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1077: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1078:
1079:
1080: l_return_status VARCHAR2(32767);
1105: BEGIN
1106:
1107: SAVEPOINT APPEND_RANK_LIST_PUB;
1108: IF l_debug_on THEN
1109: WSH_DEBUG_SV.push(l_module_name);
1110: END IF;
1111:
1112:
1113: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1118: --{
1119: IF l_debug_on
1120: THEN
1121: Log(l_module_name,' Append Rank List for trip ' || p_trip_id,
1122: WSH_DEBUG_SV.C_PROC_LEVEL);
1123: END IF;
1124:
1125: SELECT MAX(RANK_SEQUENCE) INTO l_max_rank_seq
1126: FROM FTE_CARRIER_RANK_LIST
1136:
1137: IF l_debug_on
1138: THEN
1139: Log(l_module_name,' Found max seq ' || l_max_rank_seq,
1140: WSH_DEBUG_SV.C_PROC_LEVEL);
1141: Log(l_module_name,' Appending to Rank List ',
1142: WSH_DEBUG_SV.C_PROC_LEVEL);
1143: END IF;
1144:
1138: THEN
1139: Log(l_module_name,' Found max seq ' || l_max_rank_seq,
1140: WSH_DEBUG_SV.C_PROC_LEVEL);
1141: Log(l_module_name,' Appending to Rank List ',
1142: WSH_DEBUG_SV.C_PROC_LEVEL);
1143: END IF;
1144:
1145:
1146: idx :=1;
1159: IF l_debug_on
1160: THEN
1161: Log(l_module_name,' After calling CREATE_RANK l_return_status ' ||
1162: l_return_status,
1163: WSH_DEBUG_SV.C_PROC_LEVEL);
1164: END IF;
1165:
1166: wsh_util_core.api_post_call(
1167: p_return_status =>l_return_status,
1189:
1190: IF l_debug_on
1191: THEN
1192: Log(l_module_name,' Calling SET RANK CURRENT API ',
1193: WSH_DEBUG_SV.C_PROC_LEVEL);
1194: END IF;
1195:
1196:
1197: SET_RANK_CURRENT(p_rank_info_rec => p_ranklist(i),
1200:
1201: IF l_debug_on
1202: THEN
1203: Log(l_module_name,' After calling SET_RANK_CURRENT ' || l_return_status,
1204: WSH_DEBUG_SV.C_PROC_LEVEL);
1205: END IF;
1206:
1207:
1208:
1243: idx := idx+1;
1244:
1245: END LOOP;
1246: IF l_debug_on THEN
1247: WSH_DEBUG_SV.pop(l_module_name);
1248: END IF;
1249:
1250:
1251: EXCEPTION
1252: WHEN FND_API.G_EXC_ERROR THEN
1253: ROLLBACK TO APPEND_RANK_LIST_PUB;
1254: x_return_status := FND_API.G_RET_STS_ERROR;
1255: IF l_debug_on THEN
1256: WSH_DEBUG_SV.pop(l_module_name);
1257: END IF;
1258:
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO APPEND_RANK_LIST_PUB;
1259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1260: ROLLBACK TO APPEND_RANK_LIST_PUB;
1261: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1262: IF l_debug_on THEN
1263: WSH_DEBUG_SV.pop(l_module_name);
1264: END IF;
1265:
1266: WHEN OTHERS THEN
1267: ROLLBACK TO APPEND_RANK_LIST_PUB;
1267: ROLLBACK TO APPEND_RANK_LIST_PUB;
1268: WSH_UTIL_CORE.DEFAULT_HANDLER('FTE_CARRIER_RANK_LIST_PVT.APPEND_RANK_LIST');
1269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1270: IF l_debug_on THEN
1271: WSH_DEBUG_SV.pop(l_module_name);
1272: END IF;
1273: END APPEND_RANK_LIST;
1274:
1275:
1288:
1289:
1290: l_api_name CONSTANT VARCHAR2(30) := 'RANK_LIST_ACTION';
1291: l_api_version CONSTANT NUMBER := 1.0;
1292: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1293: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1294:
1295:
1296: l_return_status VARCHAR2(32767);
1320:
1321:
1322: SAVEPOINT RANK_LIST_ACTION_PUB;
1323: IF l_debug_on THEN
1324: WSH_DEBUG_SV.push(l_module_name);
1325: END IF;
1326:
1327: IF FND_API.to_Boolean( p_init_msg_list )
1328: THEN
1340: IF (p_action_code = S_CREATE) THEN
1341: IF l_debug_on
1342: THEN
1343: Log(l_module_name,' Creating Rank List for trip ' || p_trip_id,
1344: WSH_DEBUG_SV.C_PROC_LEVEL);
1345: END IF;
1346:
1347: CREATE_RANK_LIST(
1348: p_ranklist => p_ranklist,
1352: IF l_debug_on
1353: THEN
1354: Log(l_module_name,' l_return_status after CREATE_RANK_LIST ' ||
1355: l_return_status,
1356: WSH_DEBUG_SV.C_PROC_LEVEL);
1357: END IF;
1358:
1359:
1360: ELSIF (p_action_code = S_UPDATE) THEN
1360: ELSIF (p_action_code = S_UPDATE) THEN
1361: IF l_debug_on
1362: THEN
1363: Log(l_module_name,' Updating Rank List for trip. TBD ' || p_trip_id,
1364: WSH_DEBUG_SV.C_PROC_LEVEL);
1365: END IF;
1366:
1367: UPDATE_RANK_LIST(
1368: p_ranklist => p_ranklist,
1373: IF l_debug_on
1374: THEN
1375: Log(l_module_name,' l_return_status after UPDATE_RANK_LIST ' ||
1376: l_return_status,
1377: WSH_DEBUG_SV.C_PROC_LEVEL);
1378: END IF;
1379:
1380: ELSIF (p_action_code = S_DELETE) THEN
1381: IF l_debug_on
1380: ELSIF (p_action_code = S_DELETE) THEN
1381: IF l_debug_on
1382: THEN
1383: Log(l_module_name,' Delete Rank List for trip ' || p_trip_id,
1384: WSH_DEBUG_SV.C_PROC_LEVEL);
1385: END IF;
1386:
1387: DELETE_RANK_LIST(p_trip_id => p_trip_id,
1388: x_return_status => l_return_status);
1390: IF l_debug_on
1391: THEN
1392: Log(l_module_name,' l_return_status after DELETE_RANK_LIST ' ||
1393: l_return_status,
1394: WSH_DEBUG_SV.C_PROC_LEVEL);
1395: END IF;
1396:
1397:
1398: ELSIF (p_action_code = S_SET_CURRENT) THEN
1398: ELSIF (p_action_code = S_SET_CURRENT) THEN
1399: IF l_debug_on
1400: THEN
1401: Log(l_module_name,' Setting Current Rank ' || p_trip_id,
1402: WSH_DEBUG_SV.C_PROC_LEVEL);
1403: END IF;
1404:
1405: BEGIN
1406:
1433:
1434: IF l_debug_on
1435: THEN
1436: Log(l_module_name,' After calling UPDATE_RANK ' || l_return_status,
1437: WSH_DEBUG_SV.C_PROC_LEVEL);
1438: END IF;
1439:
1440: IF (l_return_status = 'E')
1441: THEN
1451:
1452: IF l_debug_on
1453: THEN
1454: Log(l_module_name,' Update trip with rank id ' ,
1455: WSH_DEBUG_SV.C_PROC_LEVEL);
1456: END IF;
1457:
1458: FTE_MLS_WRAPPER.INITIALIZE_TRIP_REC(x_trip_info => p_trip_info);
1459:
1467: p_trip_in_rec.action_code :='UPDATE';
1468:
1469: IF l_debug_on
1470: THEN
1471: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
1472: ' Rank list Action ',
1473: WSH_DEBUG_SV.C_PROC_LEVEL);
1474: END IF;
1475:
1469: IF l_debug_on
1470: THEN
1471: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
1472: ' Rank list Action ',
1473: WSH_DEBUG_SV.C_PROC_LEVEL);
1474: END IF;
1475:
1476:
1477: WSH_INTERFACE_GRP.Create_Update_Trip
1488: );
1489:
1490: IF l_debug_on
1491: THEN
1492: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
1493: l_return_status,
1494: WSH_DEBUG_SV.C_PROC_LEVEL);
1495: END IF;
1496:
1490: IF l_debug_on
1491: THEN
1492: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
1493: l_return_status,
1494: WSH_DEBUG_SV.C_PROC_LEVEL);
1495: END IF;
1496:
1497:
1498: ELSIF (p_action_code = S_APPEND) THEN
1498: ELSIF (p_action_code = S_APPEND) THEN
1499: IF l_debug_on
1500: THEN
1501: Log(l_module_name,' Append Rank List for trip ' || p_trip_id,
1502: WSH_DEBUG_SV.C_PROC_LEVEL);
1503: END IF;
1504:
1505: APPEND_RANK_LIST(
1506: p_ranklist => p_ranklist,
1510: IF l_debug_on
1511: THEN
1512: Log(l_module_name,' l_return_status after APPEND_RANK_LIST ' ||
1513: l_return_status,
1514: WSH_DEBUG_SV.C_PROC_LEVEL);
1515: END IF;
1516:
1517: ELSIF (p_action_code = S_REPLACE) THEN
1518: -- Request from Arindam
1519:
1520: IF l_debug_on
1521: THEN
1522: Log(l_module_name,' Replace existing rank list. Calling Delete first ' || p_trip_id,
1523: WSH_DEBUG_SV.C_PROC_LEVEL);
1524: END IF;
1525:
1526: SELECT count(*) INTO l_temp_id FROM FTE_CARRIER_RANK_LIST
1527: WHERE TRIP_ID = p_trip_id and rownum = 1;
1535: IF l_debug_on
1536: THEN
1537: Log(l_module_name,' l_return_status after DELETE_RANK_LIST ' ||
1538: l_return_status,
1539: WSH_DEBUG_SV.C_PROC_LEVEL);
1540: END IF;
1541:
1542: wsh_util_core.api_post_call(
1543: p_return_status =>l_return_status,
1562: -- now call create
1563: IF l_debug_on
1564: THEN
1565: Log(l_module_name,' Creating Rank for replace action ' || p_trip_id,
1566: WSH_DEBUG_SV.C_PROC_LEVEL);
1567: END IF;
1568:
1569: CREATE_RANK_LIST(
1570: p_ranklist => p_ranklist,
1574: IF l_debug_on
1575: THEN
1576: Log(l_module_name,' l_return_status after CREATE_RANK_LIST for replace action ' ||
1577: l_return_status,
1578: WSH_DEBUG_SV.C_PROC_LEVEL);
1579: END IF;
1580:
1581: SELECT RANK_ID INTO l_temp_id
1582: FROM WSH_TRIPS
1585: IF l_debug_on
1586: THEN
1587: Log(l_module_name,' rank id after CREATE_RANK_LIST for replace action ' ||
1588: l_temp_id,
1589: WSH_DEBUG_SV.C_PROC_LEVEL);
1590: END IF;
1591:
1592:
1593: END IF;
1626: --
1627: --
1628:
1629: IF l_debug_on THEN
1630: WSH_DEBUG_SV.pop(l_module_name);
1631: END IF;
1632:
1633:
1634:
1682:
1683:
1684: l_api_name CONSTANT VARCHAR2(30) := 'RANK_LIST_ACTION_UIWRAPPER';
1685: l_api_version CONSTANT NUMBER := 1.0;
1686: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1687: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1688:
1689:
1690: l_return_status VARCHAR2(32767);
1712:
1713:
1714: SAVEPOINT RANK_LIST_ACTION_UIWRAPPER_PUB;
1715: IF l_debug_on THEN
1716: WSH_DEBUG_SV.push(l_module_name);
1717: END IF;
1718:
1719: IF FND_API.to_Boolean( p_init_msg_list )
1720: THEN
1735: THEN
1736: IF l_debug_on
1737: THEN
1738: Log(l_module_name,' Transfering from UI list to PLSQL List ',
1739: WSH_DEBUG_SV.C_PROC_LEVEL);
1740: END IF;
1741:
1742:
1743: FOR i IN p_ranklist.FIRST..p_ranklist.LAST LOOP
1808:
1809: IF l_debug_on
1810: THEN
1811: Log(l_module_name,' Transfering from PLSQL list to UI List ',
1812: WSH_DEBUG_SV.C_PROC_LEVEL);
1813: END IF;
1814:
1815: FOR i IN l_carrier_rank_list_tbl.FIRST..l_carrier_rank_list_tbl.LAST LOOP
1816:
1863: --
1864: --
1865:
1866: IF l_debug_on THEN
1867: WSH_DEBUG_SV.pop(l_module_name);
1868: END IF;
1869:
1870:
1871:
1916:
1917:
1918: l_api_name CONSTANT VARCHAR2(30) := 'GET_RANK_DETAILS';
1919: l_api_version CONSTANT NUMBER := 1.0;
1920: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1921: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1922:
1923:
1924: l_return_status VARCHAR2(32767);
1982:
1983:
1984: SAVEPOINT GET_RANK_DETAILS_PUB;
1985: IF l_debug_on THEN
1986: WSH_DEBUG_SV.push(l_module_name);
1987: END IF;
1988:
1989:
1990: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2012: --
2013: --
2014:
2015: IF l_debug_on THEN
2016: WSH_DEBUG_SV.pop(l_module_name);
2017: END IF;
2018:
2019:
2020:
2065:
2066:
2067: l_api_name CONSTANT VARCHAR2(30) := 'GET_RANK_LIST';
2068: l_api_version CONSTANT NUMBER := 1.0;
2069: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2070: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2071:
2072:
2073: l_return_status VARCHAR2(32767);
2135:
2136:
2137: SAVEPOINT GET_RANK_LIST_PUB;
2138: IF l_debug_on THEN
2139: WSH_DEBUG_SV.push(l_module_name);
2140: END IF;
2141:
2142:
2143: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2150:
2151: IF l_debug_on
2152: THEN
2153: Log(l_module_name,' Getting rank list for trip ' || p_trip_id,
2154: WSH_DEBUG_SV.C_PROC_LEVEL);
2155: END IF;
2156:
2157: idx := 1;
2158: FOR get_rank_list_rec IN get_rank_list_c
2221:
2222: IF l_debug_on
2223: THEN
2224: Log(l_module_name,' Done getting rank list for trip ' || p_trip_id,
2225: WSH_DEBUG_SV.C_PROC_LEVEL);
2226: END IF;
2227:
2228: --
2229:
2227:
2228: --
2229:
2230: IF l_debug_on THEN
2231: WSH_DEBUG_SV.pop(l_module_name);
2232: END IF;
2233:
2234:
2235:
2280: IS
2281:
2282: l_api_name CONSTANT VARCHAR2(30) := 'REMOVE_SERVICE_APPLY_NEXT';
2283: l_api_version CONSTANT NUMBER := 1.0;
2284: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2285: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2286:
2287:
2288: l_return_status VARCHAR2(32767);
2359:
2360:
2361: SAVEPOINT REMOVE_SERVICE_APPLY_NEXT_PUB;
2362: IF l_debug_on THEN
2363: WSH_DEBUG_SV.push(l_module_name);
2364: END IF;
2365:
2366: IF FND_API.to_Boolean( p_init_msg_list )
2367: THEN
2380: l_list_exhausted := 'F';
2381: IF l_debug_on
2382: THEN
2383: Log(l_module_name,' Check current rank sequence ',
2384: WSH_DEBUG_SV.C_PROC_LEVEL);
2385: END IF;
2386:
2387: BEGIN
2388:
2406:
2407: IF l_debug_on
2408: THEN
2409: Log(l_module_name,' Current rank sequence ' || l_current_rank_sequence,
2410: WSH_DEBUG_SV.C_PROC_LEVEL);
2411: END IF;
2412:
2413:
2414: --Get the next shipmethod in the sequence based on current sequence
2418:
2419: IF l_debug_on
2420: THEN
2421: Log(l_module_name,' Executed rank query ',
2422: WSH_DEBUG_SV.C_PROC_LEVEL);
2423: END IF;
2424:
2425:
2426: IF (get_next_rank%NOTFOUND) THEN
2444:
2445: IF l_debug_on
2446: THEN
2447: Log(l_module_name,' Rank list exhausted so nothing to do ' ,
2448: WSH_DEBUG_SV.C_PROC_LEVEL);
2449: END IF;
2450: --}
2451: ELSE
2452: --{
2454: -- First cancel service
2455: IF l_debug_on
2456: THEN
2457: Log(l_module_name,' cancel service on the trip. Also get rid of rates ',
2458: WSH_DEBUG_SV.C_PROC_LEVEL);
2459: END IF;
2460:
2461:
2462: IF l_debug_on
2461:
2462: IF l_debug_on
2463: THEN
2464: Log(l_module_name,' Now update trip with next shipmethod ',
2465: WSH_DEBUG_SV.C_PROC_LEVEL);
2466: Log(l_module_name,' Carrier Id ' || l_rank_rec.CARRIER_ID,
2467: WSH_DEBUG_SV.C_PROC_LEVEL);
2468: Log(l_module_name,' Service Level ' || l_rank_rec.SERVICE_LEVEL,
2469: WSH_DEBUG_SV.C_PROC_LEVEL);
2463: THEN
2464: Log(l_module_name,' Now update trip with next shipmethod ',
2465: WSH_DEBUG_SV.C_PROC_LEVEL);
2466: Log(l_module_name,' Carrier Id ' || l_rank_rec.CARRIER_ID,
2467: WSH_DEBUG_SV.C_PROC_LEVEL);
2468: Log(l_module_name,' Service Level ' || l_rank_rec.SERVICE_LEVEL,
2469: WSH_DEBUG_SV.C_PROC_LEVEL);
2470: Log(l_module_name,' Mode Of Transport ' || l_rank_rec.MODE_OF_TRANSPORT,
2471: WSH_DEBUG_SV.C_PROC_LEVEL);
2465: WSH_DEBUG_SV.C_PROC_LEVEL);
2466: Log(l_module_name,' Carrier Id ' || l_rank_rec.CARRIER_ID,
2467: WSH_DEBUG_SV.C_PROC_LEVEL);
2468: Log(l_module_name,' Service Level ' || l_rank_rec.SERVICE_LEVEL,
2469: WSH_DEBUG_SV.C_PROC_LEVEL);
2470: Log(l_module_name,' Mode Of Transport ' || l_rank_rec.MODE_OF_TRANSPORT,
2471: WSH_DEBUG_SV.C_PROC_LEVEL);
2472: Log(l_module_name,' Lane Id ' || l_rank_rec.LANE_ID,
2473: WSH_DEBUG_SV.C_PROC_LEVEL);
2467: WSH_DEBUG_SV.C_PROC_LEVEL);
2468: Log(l_module_name,' Service Level ' || l_rank_rec.SERVICE_LEVEL,
2469: WSH_DEBUG_SV.C_PROC_LEVEL);
2470: Log(l_module_name,' Mode Of Transport ' || l_rank_rec.MODE_OF_TRANSPORT,
2471: WSH_DEBUG_SV.C_PROC_LEVEL);
2472: Log(l_module_name,' Lane Id ' || l_rank_rec.LANE_ID,
2473: WSH_DEBUG_SV.C_PROC_LEVEL);
2474: Log(l_module_name,' Freight Terms Code ' || l_rank_rec.FREIGHT_TERMS_CODE,
2475: WSH_DEBUG_SV.C_PROC_LEVEL);
2469: WSH_DEBUG_SV.C_PROC_LEVEL);
2470: Log(l_module_name,' Mode Of Transport ' || l_rank_rec.MODE_OF_TRANSPORT,
2471: WSH_DEBUG_SV.C_PROC_LEVEL);
2472: Log(l_module_name,' Lane Id ' || l_rank_rec.LANE_ID,
2473: WSH_DEBUG_SV.C_PROC_LEVEL);
2474: Log(l_module_name,' Freight Terms Code ' || l_rank_rec.FREIGHT_TERMS_CODE,
2475: WSH_DEBUG_SV.C_PROC_LEVEL);
2476: Log(l_module_name,' Consignee carrier ac no ' || l_rank_rec.CONSIGNEE_CARRIER_AC_NO,
2477: WSH_DEBUG_SV.C_PROC_LEVEL);
2471: WSH_DEBUG_SV.C_PROC_LEVEL);
2472: Log(l_module_name,' Lane Id ' || l_rank_rec.LANE_ID,
2473: WSH_DEBUG_SV.C_PROC_LEVEL);
2474: Log(l_module_name,' Freight Terms Code ' || l_rank_rec.FREIGHT_TERMS_CODE,
2475: WSH_DEBUG_SV.C_PROC_LEVEL);
2476: Log(l_module_name,' Consignee carrier ac no ' || l_rank_rec.CONSIGNEE_CARRIER_AC_NO,
2477: WSH_DEBUG_SV.C_PROC_LEVEL);
2478: END IF;
2479:
2473: WSH_DEBUG_SV.C_PROC_LEVEL);
2474: Log(l_module_name,' Freight Terms Code ' || l_rank_rec.FREIGHT_TERMS_CODE,
2475: WSH_DEBUG_SV.C_PROC_LEVEL);
2476: Log(l_module_name,' Consignee carrier ac no ' || l_rank_rec.CONSIGNEE_CARRIER_AC_NO,
2477: WSH_DEBUG_SV.C_PROC_LEVEL);
2478: END IF;
2479:
2480: -- Call shipping API to update trip information with next shipmethod
2481: /**
2492: */
2493:
2494: IF l_debug_on
2495: THEN
2496: WSH_DEBUG_SV.logmsg(l_module_name,' Calling UPDATE_SERVICE_ON_TRIP ' ||
2497: l_return_status,
2498: WSH_DEBUG_SV.C_PROC_LEVEL);
2499: END IF;
2500:
2494: IF l_debug_on
2495: THEN
2496: WSH_DEBUG_SV.logmsg(l_module_name,' Calling UPDATE_SERVICE_ON_TRIP ' ||
2497: l_return_status,
2498: WSH_DEBUG_SV.C_PROC_LEVEL);
2499: END IF;
2500:
2501:
2502: FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP(
2522: x_MSG_DATA => l_msg_data);
2523:
2524: IF l_debug_on
2525: THEN
2526: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from UPDATE_SERVICE_ON_TRIP ' ||
2527: l_return_status,
2528: WSH_DEBUG_SV.C_PROC_LEVEL);
2529: END IF;
2530:
2524: IF l_debug_on
2525: THEN
2526: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from UPDATE_SERVICE_ON_TRIP ' ||
2527: l_return_status,
2528: WSH_DEBUG_SV.C_PROC_LEVEL);
2529: END IF;
2530:
2531: wsh_util_core.api_post_call(
2532: p_return_status =>l_return_status,
2550: THEN
2551: IF l_debug_on
2552: THEN
2553: Log(l_module_name,' Price request is not null so call move ',
2554: WSH_DEBUG_SV.C_PROC_LEVEL);
2555: END IF;
2556:
2557: FTE_TRIP_RATING_GRP.Move_Records_To_Main (p_trip_id => p_trip_id,
2558: p_lane_id => l_rank_rec.LANE_ID,
2563:
2564: IF l_debug_on
2565: THEN
2566: Log(l_module_name,' After calling move rates ' || l_return_status,
2567: WSH_DEBUG_SV.C_PROC_LEVEL);
2568: END IF;
2569:
2570:
2571: wsh_util_core.api_post_call(
2576: ELSE
2577: IF l_debug_on
2578: THEN
2579: Log(l_module_name,' Price request is null so call re-price ',
2580: WSH_DEBUG_SV.C_PROC_LEVEL);
2581: END IF;
2582:
2583: FTE_MLS_WRAPPER.REPRICE_TRIP(p_api_version => 1.0,
2584: p_init_msg_list => FND_API.G_FALSE,
2589:
2590: IF l_debug_on
2591: THEN
2592: Log(l_module_name,' After calling reprice trip ' || l_return_status,
2593: WSH_DEBUG_SV.C_PROC_LEVEL);
2594: END IF;
2595:
2596:
2597: IF l_debug_on
2596:
2597: IF l_debug_on
2598: THEN
2599: Log(l_module_name,' Number of errors ' || l_number_of_errors,
2600: WSH_DEBUG_SV.C_PROC_LEVEL);
2601: Log(l_module_name,' l_msg_data ' || l_msg_data,
2602: WSH_DEBUG_SV.C_PROC_LEVEL);
2603: Log(l_module_name,' Continue even if rating failed ',
2604: WSH_DEBUG_SV.C_PROC_LEVEL);
2598: THEN
2599: Log(l_module_name,' Number of errors ' || l_number_of_errors,
2600: WSH_DEBUG_SV.C_PROC_LEVEL);
2601: Log(l_module_name,' l_msg_data ' || l_msg_data,
2602: WSH_DEBUG_SV.C_PROC_LEVEL);
2603: Log(l_module_name,' Continue even if rating failed ',
2604: WSH_DEBUG_SV.C_PROC_LEVEL);
2605:
2606: END IF;
2600: WSH_DEBUG_SV.C_PROC_LEVEL);
2601: Log(l_module_name,' l_msg_data ' || l_msg_data,
2602: WSH_DEBUG_SV.C_PROC_LEVEL);
2603: Log(l_module_name,' Continue even if rating failed ',
2604: WSH_DEBUG_SV.C_PROC_LEVEL);
2605:
2606: END IF;
2607:
2608: -- Continue even if rating failed
2633: IF l_debug_on
2634: THEN
2635: Log(l_module_name,' Before Calling Rank List Action to set current ' ||
2636: l_return_status,
2637: WSH_DEBUG_SV.C_PROC_LEVEL);
2638: END IF;
2639:
2640:
2641: RANK_LIST_ACTION(
2653: IF l_debug_on
2654: THEN
2655: Log(l_module_name,' Result FTE_CARRIER_RANK_LIST_PVT.RANK_LIST_ACTION ' ||
2656: l_return_status,
2657: WSH_DEBUG_SV.C_PROC_LEVEL);
2658: END IF;
2659:
2660: wsh_util_core.api_post_call(
2661: p_return_status =>l_return_status,
2690: --
2691: --
2692:
2693: IF l_debug_on THEN
2694: WSH_DEBUG_SV.pop(l_module_name);
2695: END IF;
2696:
2697: --}
2698: EXCEPTION
2706: p_data => x_msg_data,
2707: p_encoded => FND_API.G_FALSE
2708: );
2709: IF l_debug_on THEN
2710: WSH_DEBUG_SV.pop(l_module_name);
2711: END IF;
2712:
2713: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2714: ROLLBACK TO REMOVE_SERVICE_APPLY_NEXT_PUB;
2719: p_data => x_msg_data,
2720: p_encoded => FND_API.G_FALSE
2721: );
2722: IF l_debug_on THEN
2723: WSH_DEBUG_SV.pop(l_module_name);
2724: END IF;
2725: WHEN OTHERS THEN
2726: ROLLBACK TO REMOVE_SERVICE_APPLY_NEXT_PUB;
2727: wsh_util_core.default_handler('FTE_SS_INTERFACE.REMOVE_SERVICE_APPLY_NEXT');
2732: p_data => x_msg_data,
2733: p_encoded => FND_API.G_FALSE
2734: );
2735: IF l_debug_on THEN
2736: WSH_DEBUG_SV.pop(l_module_name);
2737: END IF;
2738:
2739: END REMOVE_SERVICE_APPLY_NEXT;
2740:
2749: IS
2750:
2751: l_api_name CONSTANT VARCHAR2(30) := 'IS_RANK_LIST_EXHAUSTED';
2752: l_api_version CONSTANT NUMBER := 1.0;
2753: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2754: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2755:
2756:
2757: l_return_status VARCHAR2(32767);
2768:
2769:
2770: SAVEPOINT IS_RANK_LIST_EXHAUSTED_PUB;
2771: IF l_debug_on THEN
2772: WSH_DEBUG_SV.push(l_module_name);
2773: END IF;
2774:
2775: IF FND_API.to_Boolean( p_init_msg_list )
2776: THEN
2809:
2810: IF l_debug_on
2811: THEN
2812: Log(l_module_name,' Remaining Services in the rank list ' || l_count,
2813: WSH_DEBUG_SV.C_PROC_LEVEL);
2814: END IF;
2815:
2816:
2817: IF (l_count = 0)
2819: x_is_exhausted := 'T';
2820: IF l_debug_on
2821: THEN
2822: Log(l_module_name,' Carrier rank list exhausted ',
2823: WSH_DEBUG_SV.C_PROC_LEVEL);
2824: END IF;
2825: ELSE
2826: IF l_debug_on
2827: THEN
2825: ELSE
2826: IF l_debug_on
2827: THEN
2828: Log(l_module_name,' Carrier rank list not exhausted ',
2829: WSH_DEBUG_SV.C_PROC_LEVEL);
2830: END IF;
2831:
2832: END IF;
2833:
2844: --
2845: --
2846:
2847: IF l_debug_on THEN
2848: WSH_DEBUG_SV.pop(l_module_name);
2849: END IF;
2850:
2851: --}
2852: EXCEPTION
2860: p_data => x_msg_data,
2861: p_encoded => FND_API.G_FALSE
2862: );
2863: IF l_debug_on THEN
2864: WSH_DEBUG_SV.pop(l_module_name);
2865: END IF;
2866:
2867: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2868: ROLLBACK TO IS_RANK_LIST_EXHAUSTED_PUB;
2873: p_data => x_msg_data,
2874: p_encoded => FND_API.G_FALSE
2875: );
2876: IF l_debug_on THEN
2877: WSH_DEBUG_SV.pop(l_module_name);
2878: END IF;
2879: WHEN OTHERS THEN
2880: ROLLBACK TO IS_RANK_LIST_EXHAUSTED_PUB;
2881: wsh_util_core.default_handler('FTE_SS_INTERFACE.REMOVE_SERVICE_APPLY_NEXT');
2886: p_data => x_msg_data,
2887: p_encoded => FND_API.G_FALSE
2888: );
2889: IF l_debug_on THEN
2890: WSH_DEBUG_SV.pop(l_module_name);
2891: END IF;
2892:
2893: END IS_RANK_LIST_EXHAUSTED;
2894:
2898:
2899:
2900: l_api_name CONSTANT VARCHAR2(30) := 'PRINT_RANK_LIST';
2901: l_api_version CONSTANT NUMBER := 1.0;
2902: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2903: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2904:
2905:
2906: l_return_status VARCHAR2(32767);
2967:
2968:
2969: SAVEPOINT PRINT_RANK_LIST_PUB;
2970: IF l_debug_on THEN
2971: WSH_DEBUG_SV.push(l_module_name);
2972: END IF;
2973:
2974:
2975: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
2979:
2980: IF l_debug_on
2981: THEN
2982: Log(l_module_name,' Getting rank list for trip ' || p_trip_id,
2983: WSH_DEBUG_SV.C_PROC_LEVEL);
2984: END IF;
2985:
2986: idx := 1;
2987: FOR p_rank_info_rec IN get_rank_list_c
2989: --{
2990:
2991: IF l_debug_on
2992: THEN
2993: Log(l_module_name,' p_rank_info_rec.RANK_ID ' || p_rank_info_rec.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2994: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
2995: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2990:
2991: IF l_debug_on
2992: THEN
2993: Log(l_module_name,' p_rank_info_rec.RANK_ID ' || p_rank_info_rec.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2994: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
2995: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2991: IF l_debug_on
2992: THEN
2993: Log(l_module_name,' p_rank_info_rec.RANK_ID ' || p_rank_info_rec.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2994: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
2995: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2992: THEN
2993: Log(l_module_name,' p_rank_info_rec.RANK_ID ' || p_rank_info_rec.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2994: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
2995: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2993: Log(l_module_name,' p_rank_info_rec.RANK_ID ' || p_rank_info_rec.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2994: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
2995: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2994: Log(l_module_name,' p_rank_info_rec.TRIP_ID ' || p_rank_info_rec.TRIP_ID ,WSH_DEBUG_SV.C_PROC_LEVEL);
2995: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2995: Log(l_module_name,' p_rank_info_rec.RANK_SEQUENCE ' || p_rank_info_rec.RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2996: Log(l_module_name,' p_rank_info_rec.CARRIER_ID ' || p_rank_info_rec.CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2997: Log(l_module_name,' p_rank_info_rec.SERVICE_LEVEL ' || p_rank_info_rec.SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2998: Log(l_module_name,' p_rank_info_rec.MODE_OF_TRANSPORT ' || p_rank_info_rec.MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
2999: Log(l_module_name,' p_rank_info_rec.LANE_ID ' || p_rank_info_rec.LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3000: Log(l_module_name,' p_rank_info_rec.SOURCE ' || p_rank_info_rec.SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3001: Log(l_module_name,' p_rank_info_rec.ESTIMATED_RATE ' || p_rank_info_rec.ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3009: Log(l_module_name,' l_config ' || p_rank_info_rec.INITSMCONFIG ,WSH_DEBUG_SV.C_PROC_LEVEL);
3002: Log(l_module_name,' p_rank_info_rec.CURRENCY_CODE ' || p_rank_info_rec.CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3009: Log(l_module_name,' l_config ' || p_rank_info_rec.INITSMCONFIG ,WSH_DEBUG_SV.C_PROC_LEVEL);
3010: Log(l_module_name,' ********************************************* ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3003: Log(l_module_name,' p_rank_info_rec.VEHICLE_ITEM_ID ' || p_rank_info_rec.VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3009: Log(l_module_name,' l_config ' || p_rank_info_rec.INITSMCONFIG ,WSH_DEBUG_SV.C_PROC_LEVEL);
3010: Log(l_module_name,' ********************************************* ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3004: Log(l_module_name,' p_rank_info_rec.VEHICLE_ORG_ID ' || p_rank_info_rec.VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3009: Log(l_module_name,' l_config ' || p_rank_info_rec.INITSMCONFIG ,WSH_DEBUG_SV.C_PROC_LEVEL);
3010: Log(l_module_name,' ********************************************* ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3012: --}
3005: Log(l_module_name,' p_rank_info_rec.ESTIMATED_TRANSIT_TIME ' || p_rank_info_rec.ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3009: Log(l_module_name,' l_config ' || p_rank_info_rec.INITSMCONFIG ,WSH_DEBUG_SV.C_PROC_LEVEL);
3010: Log(l_module_name,' ********************************************* ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3012: --}
3013: END LOOP;
3006: Log(l_module_name,' p_rank_info_rec.TRANSIT_TIME_UOM ' || p_rank_info_rec.TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
3007: Log(l_module_name,' p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO ' || p_rank_info_rec.CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
3008: Log(l_module_name,' p_rank_info_rec.FREIGHT_TERMS_CODE ' || p_rank_info_rec.FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
3009: Log(l_module_name,' l_config ' || p_rank_info_rec.INITSMCONFIG ,WSH_DEBUG_SV.C_PROC_LEVEL);
3010: Log(l_module_name,' ********************************************* ' ,WSH_DEBUG_SV.C_PROC_LEVEL);
3011: END IF;
3012: --}
3013: END LOOP;
3014:
3020:
3021: IF l_debug_on
3022: THEN
3023: Log(l_module_name,' Done getting rank list for trip ' || p_trip_id,
3024: WSH_DEBUG_SV.C_PROC_LEVEL);
3025: END IF;
3026:
3027: --
3028:
3026:
3027: --
3028:
3029: IF l_debug_on THEN
3030: WSH_DEBUG_SV.pop(l_module_name);
3031: END IF;
3032:
3033:
3034:
3065: l_temp_name VARCHAR2(100);
3066:
3067: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RANK_LIST_UIWRAPPER';
3068: l_api_version CONSTANT NUMBER := 1.0;
3069: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3070: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3071:
3072:
3073: BEGIN
3074:
3075: SAVEPOINT DELETE_RANK_LIST_UIWRAPPER_PUB;
3076:
3077: IF l_debug_on THEN
3078: WSH_DEBUG_SV.push(l_module_name);
3079: END IF;
3080:
3081:
3082: l_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3084:
3085: IF l_debug_on
3086: THEN
3087: Log(l_module_name,' Delete rank list ',
3088: WSH_DEBUG_SV.C_PROC_LEVEL);
3089: END IF;
3090:
3091:
3092: l_warning_tab := FTE_ID_TAB_TYPE();
3101:
3102: IF l_debug_on
3103: THEN
3104: Log(l_module_name,' Calling DELETE_RANK_LIST for trip ' || p_trip_id(i) ,
3105: WSH_DEBUG_SV.C_PROC_LEVEL);
3106: END IF;
3107:
3108: DELETE_RANK_LIST(p_trip_id => p_trip_id(i),
3109: x_return_status => l_return_status);
3112: IF l_debug_on
3113: THEN
3114: Log(l_module_name,' Return message after delete rank for trip ' || p_trip_id(i) || ' ' ||
3115: l_return_status,
3116: WSH_DEBUG_SV.C_PROC_LEVEL);
3117: END IF;
3118:
3119:
3120: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR)
3148:
3149: IF l_debug_on
3150: THEN
3151: Log(l_module_name,' Trip id table is empty ',
3152: WSH_DEBUG_SV.C_PROC_LEVEL);
3153: END IF;
3154:
3155: END IF;
3156:
3156:
3157: IF l_debug_on
3158: THEN
3159: Log(l_module_name,' Success count ' || l_success_tab.count,
3160: WSH_DEBUG_SV.C_PROC_LEVEL);
3161: Log(l_module_name,' Error count ' || l_error_tab.count,
3162: WSH_DEBUG_SV.C_PROC_LEVEL);
3163: Log(l_module_name,' Warning count ' || l_warning_tab.count,
3164: WSH_DEBUG_SV.C_PROC_LEVEL);
3158: THEN
3159: Log(l_module_name,' Success count ' || l_success_tab.count,
3160: WSH_DEBUG_SV.C_PROC_LEVEL);
3161: Log(l_module_name,' Error count ' || l_error_tab.count,
3162: WSH_DEBUG_SV.C_PROC_LEVEL);
3163: Log(l_module_name,' Warning count ' || l_warning_tab.count,
3164: WSH_DEBUG_SV.C_PROC_LEVEL);
3165: Log(l_module_name,' Trip count ' || p_trip_id.count,
3166: WSH_DEBUG_SV.C_PROC_LEVEL);
3160: WSH_DEBUG_SV.C_PROC_LEVEL);
3161: Log(l_module_name,' Error count ' || l_error_tab.count,
3162: WSH_DEBUG_SV.C_PROC_LEVEL);
3163: Log(l_module_name,' Warning count ' || l_warning_tab.count,
3164: WSH_DEBUG_SV.C_PROC_LEVEL);
3165: Log(l_module_name,' Trip count ' || p_trip_id.count,
3166: WSH_DEBUG_SV.C_PROC_LEVEL);
3167: END IF;
3168:
3162: WSH_DEBUG_SV.C_PROC_LEVEL);
3163: Log(l_module_name,' Warning count ' || l_warning_tab.count,
3164: WSH_DEBUG_SV.C_PROC_LEVEL);
3165: Log(l_module_name,' Trip count ' || p_trip_id.count,
3166: WSH_DEBUG_SV.C_PROC_LEVEL);
3167: END IF;
3168:
3169:
3170: IF (l_success_tab.count = p_trip_id.count)
3253: l_trip_name VARCHAR2(100);
3254:
3255: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RANK_LIST_BULK';
3256: l_api_version CONSTANT NUMBER := 1.0;
3257: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
3258: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
3259:
3260: l_temp_table carrier_rank_list_bulk_rec;
3261:
3270:
3271: SAVEPOINT CREATE_RANK_LIST_BULK_PUB;
3272:
3273: IF l_debug_on THEN
3274: WSH_DEBUG_SV.push(l_module_name);
3275: END IF;
3276:
3277:
3278: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
3281:
3282: IF l_debug_on
3283: THEN
3284: Log(l_module_name,' Loop through all the rank list table and check failure cases ',
3285: WSH_DEBUG_SV.C_PROC_LEVEL);
3286: END IF;
3287:
3288: idx := 1;
3289: FOR i IN p_ranklist.TRIP_ID.FIRST..p_ranklist.TRIP_ID.LAST
3291:
3292: IF l_debug_on
3293: THEN
3294: Log(l_module_name,' Trip Id ' || p_ranklist.TRIP_ID(i) || ' i value ' || i,
3295: WSH_DEBUG_SV.C_PROC_LEVEL);
3296: END IF;
3297:
3298:
3299: BEGIN
3309:
3310: IF l_debug_on
3311: THEN
3312: Log(l_module_name,' Rank list exist for trip ' || p_ranklist.TRIP_ID(i),
3313: WSH_DEBUG_SV.C_PROC_LEVEL);
3314: END IF;
3315:
3316: SELECT NAME INTO l_trip_name FROM WSH_TRIPS WHERE TRIP_ID = p_ranklist.TRIP_ID(i);
3317: l_trip_names := l_trip_names || ', ' || l_trip_name;
3325:
3326: IF l_debug_on
3327: THEN
3328: Log(l_module_name,' Rank Id ' || p_ranklist.RANK_ID(i) || ' i value ' || i,
3329: WSH_DEBUG_SV.C_PROC_LEVEL);
3330: END IF;
3331:
3332:
3333: l_temp_table.RANK_ID(idx) := p_ranklist.RANK_ID(i);
3370: END LOOP;
3371:
3372: IF l_debug_on
3373: THEN
3374: Log(l_module_name,' After copy ',WSH_DEBUG_SV.C_PROC_LEVEL);
3375: END IF;
3376:
3377:
3378: IF (l_temp_table.RANK_ID.COUNT > 0)
3468: );
3469:
3470: IF l_debug_on
3471: THEN
3472: Log(l_module_name,' After Insert ',WSH_DEBUG_SV.C_PROC_LEVEL);
3473: END IF;
3474:
3475:
3476:
3481: WHERE TRIP_ID = l_temp_table.TRIP_ID(i);
3482:
3483: IF l_debug_on
3484: THEN
3485: Log(l_module_name,' Rank Id ' || l_temp_table.RANK_ID(i),WSH_DEBUG_SV.C_PROC_LEVEL);
3486: END IF;
3487: END LOOP;
3488: END IF;
3489: