eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_SS_INTERFACE dependencies on WSH_DEBUG_SV

Line 95: WSH_DEBUG_SV.logmsg(p_module_name,p_text,p_level);

91:
92:
93: BEGIN
94:
95: WSH_DEBUG_SV.logmsg(p_module_name,p_text,p_level);
96: --dbms_output.put_line(p_module_name || ' ' || p_text);
97:
98: END LOG;
99:

Line 110: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

106: IS
107:
108: l_api_name CONSTANT VARCHAR2(30) := 'DERIVE_INITIAL_SHIPMETHOD';
109: l_api_version CONSTANT NUMBER := 1.0;
110: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
111: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
112:
113:
114: BEGIN

Line 117: WSH_DEBUG_SV.push(l_module_name);

113:
114: BEGIN
115:
116: IF l_debug_on THEN
117: WSH_DEBUG_SV.push(l_module_name);
118: END IF;
119:
120:
121: x_carrier_id := p_rank_list_rec.carrier_id;

Line 130: WSH_DEBUG_SV.C_PROC_LEVEL);

126: THEN
127: LOG(l_module_name,
128: ' InitSMConfig value ' || p_rank_list_rec.INITSMCONFIG || ' , ' ||
129: length(p_rank_list_rec.INITSMCONFIG),
130: WSH_DEBUG_SV.C_PROC_LEVEL);
131: END IF;
132:
133:
134: IF (length(p_rank_list_rec.INITSMCONFIG) = 1)

Line 144: WSH_DEBUG_SV.C_PROC_LEVEL);

140: THEN
141: LOG(l_module_name,
142: ' Pass in carrier as search option ' ||
143: p_rank_list_rec.carrier_id,
144: WSH_DEBUG_SV.C_PROC_LEVEL);
145: END IF;
146: x_service_level := null;
147: x_mode_of_transport := null;
148:

Line 157: WSH_DEBUG_SV.C_PROC_LEVEL);

153: THEN
154: LOG(l_module_name,
155: ' Pass in Service level as search option ' ||
156: p_rank_list_rec.service_level,
157: WSH_DEBUG_SV.C_PROC_LEVEL);
158: END IF;
159: x_carrier_id := null;
160: x_mode_of_transport := null;
161: -- Just service level is part of partial shipmethod

Line 170: WSH_DEBUG_SV.C_PROC_LEVEL);

166: THEN
167: LOG(l_module_name,
168: ' Pass in Mode as search option ' ||
169: p_rank_list_rec.mode_of_transport,
170: WSH_DEBUG_SV.C_PROC_LEVEL);
171: END IF;
172: x_carrier_id := null;
173: x_service_level := null;
174: --}

Line 189: WSH_DEBUG_SV.C_PROC_LEVEL);

185: LOG(l_module_name,
186: ' Carrier and Service level ' ||
187: p_rank_list_rec.carrier_id || ' ' ||
188: p_rank_list_rec.service_level,
189: WSH_DEBUG_SV.C_PROC_LEVEL);
190: END IF;
191: x_mode_of_transport := null;
192:
193: ELSIF (p_rank_list_rec.INITSMCONFIG = 'CM')

Line 201: WSH_DEBUG_SV.C_PROC_LEVEL);

197: LOG(l_module_name,
198: ' Carrier and Mode ' ||
199: p_rank_list_rec.carrier_id || ' ' ||
200: p_rank_list_rec.mode_of_transport,
201: WSH_DEBUG_SV.C_PROC_LEVEL);
202: END IF;
203: x_service_level := null;
204:
205: ELSIF (p_rank_list_rec.INITSMCONFIG = 'SM')

Line 213: WSH_DEBUG_SV.C_PROC_LEVEL);

209: LOG(l_module_name,
210: ' Service level and Mode ' ||
211: p_rank_list_rec.service_level|| ' ' ||
212: p_rank_list_rec.mode_of_Transport,
213: WSH_DEBUG_SV.C_PROC_LEVEL);
214: END IF;
215: x_carrier_id := null;
216: END IF;
217: --}

Line 223: WSH_DEBUG_SV.C_PROC_LEVEL);

219: IF l_debug_on
220: THEN
221: LOG(l_module_name,
222: ' Pass in null for all values ',
223: WSH_DEBUG_SV.C_PROC_LEVEL);
224: END IF;
225:
226:
227: x_carrier_id := NULL;

Line 234: WSH_DEBUG_SV.pop(l_module_name);

230:
231: END IF;
232:
233: IF l_debug_on THEN
234: WSH_DEBUG_SV.pop(l_module_name);
235: END IF;
236: EXCEPTION
237:
238: WHEN OTHERS THEN

Line 240: WSH_DEBUG_SV.pop(l_module_name);

236: EXCEPTION
237:
238: WHEN OTHERS THEN
239: IF l_debug_on THEN
240: WSH_DEBUG_SV.pop(l_module_name);
241: END IF;
242: END DERIVE_INITIAL_SHIPMETHOD;
243:
244:

Line 265: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

261: --{ Local variables
262:
263: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SEARCH_CRITERIA_WF';
264: l_api_version CONSTANT NUMBER := 1.0;
265: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
266: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
267:
268:
269: l_return_status VARCHAR2(32767);

Line 299: WSH_DEBUG_SV.push(l_module_name);

295:
296:
297: SAVEPOINT CREATE_SEARCH_CRITERIA_WF_PUB;
298: IF l_debug_on THEN
299: WSH_DEBUG_SV.push(l_module_name);
300: END IF;
301:
302: IF FND_API.to_Boolean( p_init_msg_list )
303: THEN

Line 329: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);

325:
326: IF l_debug_on
327: THEN
328: LOG(l_module_name,' Carrier Rank list count ' ||
329: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);
330: LOG(l_module_name,' Append list flag = ' ||
331: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
332: WSH_DEBUG_SV.C_PROC_LEVEL);
333: LOG(l_module_name,' Rule Id = ' ||

Line 332: WSH_DEBUG_SV.C_PROC_LEVEL);

328: LOG(l_module_name,' Carrier Rank list count ' ||
329: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);
330: LOG(l_module_name,' Append list flag = ' ||
331: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
332: WSH_DEBUG_SV.C_PROC_LEVEL);
333: LOG(l_module_name,' Rule Id = ' ||
334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
335: LOG(l_module_name,' Existing Rank Id = ' ||
336: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

330: LOG(l_module_name,' Append list flag = ' ||
331: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
332: WSH_DEBUG_SV.C_PROC_LEVEL);
333: LOG(l_module_name,' Rule Id = ' ||
334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
335: LOG(l_module_name,' Existing Rank Id = ' ||
336: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
337: END IF;
338:

Line 336: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

332: WSH_DEBUG_SV.C_PROC_LEVEL);
333: LOG(l_module_name,' Rule Id = ' ||
334: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
335: LOG(l_module_name,' Existing Rank Id = ' ||
336: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
337: END IF;
338:
339: IF (l_tbl_count = 0)
340: THEN

Line 349: WSH_DEBUG_SV.C_PROC_LEVEL);

345: THEN
346: LOG(l_module_name,' This is possible when there is nothing in rank list ' ||
347: 'and user is doing search serivces from UI. Just add ' ||
348: ' UI level info and search ',
349: WSH_DEBUG_SV.C_PROC_LEVEL);
350: END IF;
351:
352: --}
353: ELSIF (l_tbl_count = 1)

Line 362: WSH_DEBUG_SV.C_PROC_LEVEL);

358: IF l_debug_on
359: THEN
360: LOG(l_module_name,' Found entry. Source = ' ||
361: l_rank_list_rec.source,
362: WSH_DEBUG_SV.C_PROC_LEVEL);
363: LOG(l_module_name,' InitSMConfig = ' ||
364: l_rank_list_rec.INITSMCONFIG,
365: WSH_DEBUG_SV.C_PROC_LEVEL);
366: LOG(l_module_name,' Lane Id = ' ||

Line 365: WSH_DEBUG_SV.C_PROC_LEVEL);

361: l_rank_list_rec.source,
362: WSH_DEBUG_SV.C_PROC_LEVEL);
363: LOG(l_module_name,' InitSMConfig = ' ||
364: l_rank_list_rec.INITSMCONFIG,
365: WSH_DEBUG_SV.C_PROC_LEVEL);
366: LOG(l_module_name,' Lane Id = ' ||
367: l_rank_list_rec.LANE_ID,
368: WSH_DEBUG_SV.C_PROC_LEVEL);
369: END IF;

Line 368: WSH_DEBUG_SV.C_PROC_LEVEL);

364: l_rank_list_rec.INITSMCONFIG,
365: WSH_DEBUG_SV.C_PROC_LEVEL);
366: LOG(l_module_name,' Lane Id = ' ||
367: l_rank_list_rec.LANE_ID,
368: WSH_DEBUG_SV.C_PROC_LEVEL);
369: END IF;
370:
371:
372: X_RANK_EXIST_TAB(1) := l_rank_list_rec;

Line 389: ' Initial Shipmethod is full ',WSH_DEBUG_SV.C_PROC_LEVEL);

385: --{
386: IF l_debug_on
387: THEN
388: LOG(l_module_name,
389: ' Initial Shipmethod is full ',WSH_DEBUG_SV.C_PROC_LEVEL);
390: END IF;
391:
392: -- 1 Full SM / 1 Full SM with Service Case
393: -- Check append list flag

Line 402: WSH_DEBUG_SV.C_PROC_LEVEL);

398: THEN
399: LOG(l_module_name,
400: ' Calling Routing Guide Rule _id ' ||
401: P_FTE_SS_ATTR_REC.RULE_ID,
402: WSH_DEBUG_SV.C_PROC_LEVEL);
403: END IF;
404:
405: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,
406: x_routing_results => l_routing_results,

Line 424: WSH_DEBUG_SV.C_PROC_LEVEL);

420: IF l_debug_on
421: THEN
422: LOG(l_module_name,
423: ' Build X_SS_RATE_SORT_TAB for search ',
424: WSH_DEBUG_SV.C_PROC_LEVEL);
425: END IF;
426:
427: IF (l_routing_results.COUNT > 0)
428: THEN

Line 449: WSH_DEBUG_SV.C_PROC_LEVEL);

445: IF l_debug_on
446: THEN
447: LOG(l_module_name,
448: ' Append flag is N return back ',
449: WSH_DEBUG_SV.C_PROC_LEVEL);
450: END IF;
451: --}
452: END IF;
453: --}

Line 468: WSH_DEBUG_SV.C_PROC_LEVEL);

464: IF l_debug_on
465: THEN
466: LOG(l_module_name,
467: ' Initial configuration is Partial SM. ',
468: WSH_DEBUG_SV.C_PROC_LEVEL);
469: LOG(l_module_name,
470: ' Derive SM information ',
471: WSH_DEBUG_SV.C_PROC_LEVEL);
472: END IF;

Line 471: WSH_DEBUG_SV.C_PROC_LEVEL);

467: ' Initial configuration is Partial SM. ',
468: WSH_DEBUG_SV.C_PROC_LEVEL);
469: LOG(l_module_name,
470: ' Derive SM information ',
471: WSH_DEBUG_SV.C_PROC_LEVEL);
472: END IF;
473:
474: DERIVE_INITIAL_SHIPMETHOD(
475: p_rank_list_rec => l_rank_list_rec,

Line 484: WSH_DEBUG_SV.C_PROC_LEVEL);

480: IF l_debug_on
481: THEN
482: LOG(l_module_name,
483: ' Pass in these parameters for search. ',
484: WSH_DEBUG_SV.C_PROC_LEVEL);
485: LOG(l_module_name,
486: ' Carrier _id ' || l_carrier_id,WSH_DEBUG_SV.C_PROC_LEVEL);
487: LOG(l_module_name,
488: ' Service level ' || l_service_level,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 486: ' Carrier _id ' || l_carrier_id,WSH_DEBUG_SV.C_PROC_LEVEL);

482: LOG(l_module_name,
483: ' Pass in these parameters for search. ',
484: WSH_DEBUG_SV.C_PROC_LEVEL);
485: LOG(l_module_name,
486: ' Carrier _id ' || l_carrier_id,WSH_DEBUG_SV.C_PROC_LEVEL);
487: LOG(l_module_name,
488: ' Service level ' || l_service_level,WSH_DEBUG_SV.C_PROC_LEVEL);
489: LOG(l_module_name,
490: ' Mode ' || l_mode_of_transport,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 488: ' Service level ' || l_service_level,WSH_DEBUG_SV.C_PROC_LEVEL);

484: WSH_DEBUG_SV.C_PROC_LEVEL);
485: LOG(l_module_name,
486: ' Carrier _id ' || l_carrier_id,WSH_DEBUG_SV.C_PROC_LEVEL);
487: LOG(l_module_name,
488: ' Service level ' || l_service_level,WSH_DEBUG_SV.C_PROC_LEVEL);
489: LOG(l_module_name,
490: ' Mode ' || l_mode_of_transport,WSH_DEBUG_SV.C_PROC_LEVEL);
491: END IF;
492:

Line 490: ' Mode ' || l_mode_of_transport,WSH_DEBUG_SV.C_PROC_LEVEL);

486: ' Carrier _id ' || l_carrier_id,WSH_DEBUG_SV.C_PROC_LEVEL);
487: LOG(l_module_name,
488: ' Service level ' || l_service_level,WSH_DEBUG_SV.C_PROC_LEVEL);
489: LOG(l_module_name,
490: ' Mode ' || l_mode_of_transport,WSH_DEBUG_SV.C_PROC_LEVEL);
491: END IF;
492:
493: l_new_rank_list_rec.CARRIER_ID := l_carrier_id;
494: l_new_rank_list_rec.SERVICE_LEVEL := l_mode_of_transport;

Line 513: WSH_DEBUG_SV.C_PROC_LEVEL);

509: IF l_debug_on
510: THEN
511: LOG(l_module_name,
512: ' Search using LCSS So just calling rate, sort search for open search',
513: WSH_DEBUG_SV.C_PROC_LEVEL);
514: END IF;
515:
516: l_new_rank_list_rec.SOURCE := 'LCSS';
517: l_new_rank_list_rec.INITSMCONFIG := l_rank_list_rec.INITSMCONFIG;

Line 532: WSH_DEBUG_SV.C_PROC_LEVEL);

528: IF l_debug_on
529: THEN
530: LOG(l_module_name,
531: ' We have a entry from TP So call Routing Guide to get Routing guide results',
532: WSH_DEBUG_SV.C_PROC_LEVEL);
533: LOG(l_module_name,
534: ' We Do not have Rule id so we have to call main Routing guide API ',
535: WSH_DEBUG_SV.C_PROC_LEVEL);
536: END IF;

Line 535: WSH_DEBUG_SV.C_PROC_LEVEL);

531: ' We have a entry from TP So call Routing Guide to get Routing guide results',
532: WSH_DEBUG_SV.C_PROC_LEVEL);
533: LOG(l_module_name,
534: ' We Do not have Rule id so we have to call main Routing guide API ',
535: WSH_DEBUG_SV.C_PROC_LEVEL);
536: END IF;
537:
538: -- Routing guide may enter these values into Rank list table directly
539: -- that i still need to resolve

Line 585: WSH_DEBUG_SV.pop(l_module_name);

581: --
582: --
583:
584: IF l_debug_on THEN
585: WSH_DEBUG_SV.pop(l_module_name);
586: END IF;
587:
588: --}
589: EXCEPTION

Line 601: WSH_DEBUG_SV.pop(l_module_name);

597: p_data => x_msg_data,
598: p_encoded => FND_API.G_FALSE
599: );
600: IF l_debug_on THEN
601: WSH_DEBUG_SV.pop(l_module_name);
602: END IF;
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;

Line 614: WSH_DEBUG_SV.pop(l_module_name);

610: p_data => x_msg_data,
611: p_encoded => FND_API.G_FALSE
612: );
613: IF l_debug_on THEN
614: WSH_DEBUG_SV.pop(l_module_name);
615: END IF;
616: WHEN OTHERS THEN
617: ROLLBACK TO CREATE_SEARCH_CRITERIA_WF_PUB;
618: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_WF');

Line 627: WSH_DEBUG_SV.pop(l_module_name);

623: p_data => x_msg_data,
624: p_encoded => FND_API.G_FALSE
625: );
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.pop(l_module_name);
628: END IF;
629:
630: --}
631:

Line 657: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

653: --{ Local variables
654:
655: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SEARCH_CRITERIA_UI';
656: l_api_version CONSTANT NUMBER := 1.0;
657: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
658: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
659:
660:
661: l_return_status VARCHAR2(32767);

Line 706: WSH_DEBUG_SV.push(l_module_name);

702:
703:
704: SAVEPOINT CREATE_SEARCH_CRITERIA_UI_PUB;
705: IF l_debug_on THEN
706: WSH_DEBUG_SV.push(l_module_name);
707: END IF;
708:
709: IF FND_API.to_Boolean( p_init_msg_list )
710: THEN

Line 736: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);

732:
733: IF l_debug_on
734: THEN
735: LOG(l_module_name,' Carrier Rank list count ' ||
736: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);
737: LOG(l_module_name,' Append list flag = ' ||
738: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
739: WSH_DEBUG_SV.C_PROC_LEVEL);
740: LOG(l_module_name,' Rule Id = ' ||

Line 739: WSH_DEBUG_SV.C_PROC_LEVEL);

735: LOG(l_module_name,' Carrier Rank list count ' ||
736: l_tbl_count,WSH_DEBUG_SV.C_PROC_LEVEL);
737: LOG(l_module_name,' Append list flag = ' ||
738: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
739: WSH_DEBUG_SV.C_PROC_LEVEL);
740: LOG(l_module_name,' Rule Id = ' ||
741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
742: LOG(l_module_name,' Existing Rank Id = ' ||
743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

737: LOG(l_module_name,' Append list flag = ' ||
738: P_FTE_SS_ATTR_REC.APPEND_LIST_FLAG,
739: WSH_DEBUG_SV.C_PROC_LEVEL);
740: LOG(l_module_name,' Rule Id = ' ||
741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
742: LOG(l_module_name,' Existing Rank Id = ' ||
743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,

Line 743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

739: WSH_DEBUG_SV.C_PROC_LEVEL);
740: LOG(l_module_name,' Rule Id = ' ||
741: P_FTE_SS_ATTR_REC.RULE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
742: LOG(l_module_name,' Existing Rank Id = ' ||
743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,

Line 746: WSH_DEBUG_SV.C_PROC_LEVEL);

742: LOG(l_module_name,' Existing Rank Id = ' ||
743: P_FTE_SS_ATTR_REC.RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
748: WSH_DEBUG_SV.C_PROC_LEVEL);
749: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
750: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 748: WSH_DEBUG_SV.C_PROC_LEVEL);

744:
745: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
748: WSH_DEBUG_SV.C_PROC_LEVEL);
749: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
750: WSH_DEBUG_SV.C_PROC_LEVEL);
751:
752:

Line 750: WSH_DEBUG_SV.C_PROC_LEVEL);

746: WSH_DEBUG_SV.C_PROC_LEVEL);
747: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
748: WSH_DEBUG_SV.C_PROC_LEVEL);
749: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
750: WSH_DEBUG_SV.C_PROC_LEVEL);
751:
752:
753: END IF;
754:

Line 762: ' In this case just add user pref to search criteira ', WSH_DEBUG_SV.C_PROC_LEVEL);

758: IF l_debug_on
759: THEN
760: LOG(l_module_name,' This is possible when there is nothing in rank list ' ||
761: ' and user does search services from UI ' ||
762: ' In this case just add user pref to search criteira ', WSH_DEBUG_SV.C_PROC_LEVEL);
763: END IF;
764:
765: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;
766: l_new_rank_list_rec.SERVICE_LEVEL := P_FTE_SS_ATTR_REC.SERVICE_LEVEL;

Line 787: WSH_DEBUG_SV.C_PROC_LEVEL);

783:
784: IF l_debug_on
785: THEN
786: LOG(l_module_name,' Found entry. Source = ' || l_rank_list_rec.source,
787: WSH_DEBUG_SV.C_PROC_LEVEL);
788: LOG(l_module_name,' InitSMConfig = ' ||l_rank_list_rec.INITSMCONFIG,
789: WSH_DEBUG_SV.C_PROC_LEVEL);
790: LOG(l_module_name,' Lane Id = ' || l_rank_list_rec.LANE_ID,
791: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 789: WSH_DEBUG_SV.C_PROC_LEVEL);

785: THEN
786: LOG(l_module_name,' Found entry. Source = ' || l_rank_list_rec.source,
787: WSH_DEBUG_SV.C_PROC_LEVEL);
788: LOG(l_module_name,' InitSMConfig = ' ||l_rank_list_rec.INITSMCONFIG,
789: WSH_DEBUG_SV.C_PROC_LEVEL);
790: LOG(l_module_name,' Lane Id = ' || l_rank_list_rec.LANE_ID,
791: WSH_DEBUG_SV.C_PROC_LEVEL);
792:
793: LOG(l_module_name,' l_rank_list_rec.CARRIER_ID ' || l_rank_list_rec.CARRIER_ID ,

Line 791: WSH_DEBUG_SV.C_PROC_LEVEL);

787: WSH_DEBUG_SV.C_PROC_LEVEL);
788: LOG(l_module_name,' InitSMConfig = ' ||l_rank_list_rec.INITSMCONFIG,
789: WSH_DEBUG_SV.C_PROC_LEVEL);
790: LOG(l_module_name,' Lane Id = ' || l_rank_list_rec.LANE_ID,
791: WSH_DEBUG_SV.C_PROC_LEVEL);
792:
793: LOG(l_module_name,' l_rank_list_rec.CARRIER_ID ' || l_rank_list_rec.CARRIER_ID ,
794: WSH_DEBUG_SV.C_PROC_LEVEL);
795: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,

Line 794: WSH_DEBUG_SV.C_PROC_LEVEL);

790: LOG(l_module_name,' Lane Id = ' || l_rank_list_rec.LANE_ID,
791: WSH_DEBUG_SV.C_PROC_LEVEL);
792:
793: LOG(l_module_name,' l_rank_list_rec.CARRIER_ID ' || l_rank_list_rec.CARRIER_ID ,
794: WSH_DEBUG_SV.C_PROC_LEVEL);
795: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
796: WSH_DEBUG_SV.C_PROC_LEVEL);
797: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
798: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 796: WSH_DEBUG_SV.C_PROC_LEVEL);

792:
793: LOG(l_module_name,' l_rank_list_rec.CARRIER_ID ' || l_rank_list_rec.CARRIER_ID ,
794: WSH_DEBUG_SV.C_PROC_LEVEL);
795: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
796: WSH_DEBUG_SV.C_PROC_LEVEL);
797: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
798: WSH_DEBUG_SV.C_PROC_LEVEL);
799:
800: END IF;

Line 798: WSH_DEBUG_SV.C_PROC_LEVEL);

794: WSH_DEBUG_SV.C_PROC_LEVEL);
795: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
796: WSH_DEBUG_SV.C_PROC_LEVEL);
797: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
798: WSH_DEBUG_SV.C_PROC_LEVEL);
799:
800: END IF;
801:
802:

Line 817: ' Initial Shipmethod is full ',WSH_DEBUG_SV.C_PROC_LEVEL);

813: --{
814: IF l_debug_on
815: THEN
816: LOG(l_module_name,
817: ' Initial Shipmethod is full ',WSH_DEBUG_SV.C_PROC_LEVEL);
818: END IF;
819:
820: IF (l_rank_list_rec.LANE_ID IS NOT NULL)
821: THEN

Line 836: WSH_DEBUG_SV.C_PROC_LEVEL);

832: THEN
833: LOG(l_module_name,
834: ' Calling Routing Guide Rule _id ' ||
835: P_FTE_SS_ATTR_REC.RULE_ID,
836: WSH_DEBUG_SV.C_PROC_LEVEL);
837: END IF;
838:
839: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,
840: x_routing_results => l_routing_results,

Line 857: WSH_DEBUG_SV.C_PROC_LEVEL);

853:
854: IF l_debug_on
855: THEN
856: LOG(l_module_name,' Build X_SS_RATE_SORT_TAB for search ',
857: WSH_DEBUG_SV.C_PROC_LEVEL);
858: END IF;
859:
860: IF (l_routing_results.COUNT > 0)
861: THEN

Line 882: LOG(l_module_name, ' Append flag is N Do not call RG ', WSH_DEBUG_SV.C_PROC_LEVEL);

878: ELSE
879: --{
880: IF l_debug_on
881: THEN
882: LOG(l_module_name, ' Append flag is N Do not call RG ', WSH_DEBUG_SV.C_PROC_LEVEL);
883: END IF;
884:
885:
886: IF (l_rank_list_rec.LANE_ID IS NOT NULL)

Line 909: ' Initial Shipmethod is Partial or only 1 Full shipmethod ',WSH_DEBUG_SV.C_PROC_LEVEL);

905:
906: IF l_debug_on
907: THEN
908: LOG(l_module_name,
909: ' Initial Shipmethod is Partial or only 1 Full shipmethod ',WSH_DEBUG_SV.C_PROC_LEVEL);
910: LOG(l_module_name,
911: ' l_rank_list_rec.INITSMCONFIG ' || l_rank_list_rec.INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);
912:
913: END IF;

Line 911: ' l_rank_list_rec.INITSMCONFIG ' || l_rank_list_rec.INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);

907: THEN
908: LOG(l_module_name,
909: ' Initial Shipmethod is Partial or only 1 Full shipmethod ',WSH_DEBUG_SV.C_PROC_LEVEL);
910: LOG(l_module_name,
911: ' l_rank_list_rec.INITSMCONFIG ' || l_rank_list_rec.INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);
912:
913: END IF;
914:
915:

Line 968: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||

964: p_trip_in_rec.action_code :='UPDATE';
965:
966: IF l_debug_on
967: THEN
968: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
969: ' Updating rank id to null in UIWrapper ' ,
970: WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972:

Line 970: WSH_DEBUG_SV.C_PROC_LEVEL);

966: IF l_debug_on
967: THEN
968: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
969: ' Updating rank id to null in UIWrapper ' ,
970: WSH_DEBUG_SV.C_PROC_LEVEL);
971: END IF;
972:
973:
974: WSH_INTERFACE_GRP.Create_Update_Trip

Line 989: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||

985: );
986:
987: IF l_debug_on
988: THEN
989: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
990: l_return_status,
991: WSH_DEBUG_SV.C_PROC_LEVEL);
992: END IF;
993:

Line 991: WSH_DEBUG_SV.C_PROC_LEVEL);

987: IF l_debug_on
988: THEN
989: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
990: l_return_status,
991: WSH_DEBUG_SV.C_PROC_LEVEL);
992: END IF;
993:
994: wsh_util_core.api_post_call(
995: p_return_status =>l_return_status,

Line 1025: ' TP Initial Shipmethod is full ',WSH_DEBUG_SV.C_PROC_LEVEL);

1021: -- Call routing guide if Append flag is set to Y.
1022: IF l_debug_on
1023: THEN
1024: LOG(l_module_name,
1025: ' TP Initial Shipmethod is full ',WSH_DEBUG_SV.C_PROC_LEVEL);
1026: END IF;
1027:
1028: X_RANK_EXIST_TAB(1) := l_rank_list_rec;
1029:

Line 1040: WSH_DEBUG_SV.C_PROC_LEVEL);

1036: THEN
1037: LOG(l_module_name,
1038: ' Calling Routing Guide Rule _id ' ||
1039: P_FTE_SS_ATTR_REC.RULE_ID,
1040: WSH_DEBUG_SV.C_PROC_LEVEL);
1041: END IF;
1042:
1043: GET_RANKED_RESULTS(p_rule_id => P_FTE_SS_ATTR_REC.RULE_ID,
1044: x_routing_results => l_routing_results,

Line 1059: WSH_DEBUG_SV.C_PROC_LEVEL);

1055:
1056: IF l_debug_on
1057: THEN
1058: LOG(l_module_name,' Build X_SS_RATE_SORT_TAB for search ',
1059: WSH_DEBUG_SV.C_PROC_LEVEL);
1060: END IF;
1061:
1062: IF (l_routing_results.COUNT > 0)
1063: THEN

Line 1084: LOG(l_module_name, ' Append flag is N Do not call RG ', WSH_DEBUG_SV.C_PROC_LEVEL);

1080: ELSE
1081: --{
1082: IF l_debug_on
1083: THEN
1084: LOG(l_module_name, ' Append flag is N Do not call RG ', WSH_DEBUG_SV.C_PROC_LEVEL);
1085: END IF;
1086:
1087:
1088: X_SAVE_RANK_LIST := FND_API.G_FALSE;

Line 1100: WSH_DEBUG_SV.C_PROC_LEVEL);

1096: IF l_debug_on
1097: THEN
1098: LOG(l_module_name,
1099: ' Rank list created manually add 1 entry to existing services list ',
1100: WSH_DEBUG_SV.C_PROC_LEVEL);
1101: END IF;
1102:
1103: IF (l_rank_list_rec.LANE_ID IS NOT NULL)
1104: THEN

Line 1124: WSH_DEBUG_SV.C_PROC_LEVEL);

1120: IF l_debug_on
1121: THEN
1122: LOG(l_module_name,
1123: ' Search using LCSS So just calling rate, sort search for open search',
1124: WSH_DEBUG_SV.C_PROC_LEVEL);
1125: END IF;
1126:
1127: IF (l_rank_list_rec.LANE_ID IS NOT NULL)
1128: THEN

Line 1152: WSH_DEBUG_SV.C_PROC_LEVEL);

1148: -- one in rank list. If different then we have to search based on that
1149: IF l_debug_on
1150: THEN
1151: LOG(l_module_name,' Checking If UI level is different than the rank list entry ',
1152: WSH_DEBUG_SV.C_PROC_LEVEL);
1153: LOG(l_module_name,' l_rank_list_rec.CARRIER_ID ' || l_rank_list_rec.CARRIER_ID ,
1154: WSH_DEBUG_SV.C_PROC_LEVEL);
1155: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
1156: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1154: WSH_DEBUG_SV.C_PROC_LEVEL);

1150: THEN
1151: LOG(l_module_name,' Checking If UI level is different than the rank list entry ',
1152: WSH_DEBUG_SV.C_PROC_LEVEL);
1153: LOG(l_module_name,' l_rank_list_rec.CARRIER_ID ' || l_rank_list_rec.CARRIER_ID ,
1154: WSH_DEBUG_SV.C_PROC_LEVEL);
1155: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
1156: WSH_DEBUG_SV.C_PROC_LEVEL);
1157: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
1158: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1156: WSH_DEBUG_SV.C_PROC_LEVEL);

1152: WSH_DEBUG_SV.C_PROC_LEVEL);
1153: LOG(l_module_name,' l_rank_list_rec.CARRIER_ID ' || l_rank_list_rec.CARRIER_ID ,
1154: WSH_DEBUG_SV.C_PROC_LEVEL);
1155: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
1156: WSH_DEBUG_SV.C_PROC_LEVEL);
1157: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
1158: WSH_DEBUG_SV.C_PROC_LEVEL);
1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
1160: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1158: WSH_DEBUG_SV.C_PROC_LEVEL);

1154: WSH_DEBUG_SV.C_PROC_LEVEL);
1155: LOG(l_module_name,' l_rank_list_rec.SERVICE_LEVEL ' || l_rank_list_rec.SERVICE_LEVEL,
1156: WSH_DEBUG_SV.C_PROC_LEVEL);
1157: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
1158: WSH_DEBUG_SV.C_PROC_LEVEL);
1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
1160: WSH_DEBUG_SV.C_PROC_LEVEL);
1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
1162: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1160: WSH_DEBUG_SV.C_PROC_LEVEL);

1156: WSH_DEBUG_SV.C_PROC_LEVEL);
1157: LOG(l_module_name,' l_rank_list_rec.MODE_OF_TRANSPORT ' || l_rank_list_rec.MODE_OF_TRANSPORT,
1158: WSH_DEBUG_SV.C_PROC_LEVEL);
1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
1160: WSH_DEBUG_SV.C_PROC_LEVEL);
1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
1162: WSH_DEBUG_SV.C_PROC_LEVEL);
1163: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
1164: WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1162: WSH_DEBUG_SV.C_PROC_LEVEL);

1158: WSH_DEBUG_SV.C_PROC_LEVEL);
1159: LOG(l_module_name,' P_FTE_SS_ATTR_REC.CARRIER_ID ' || P_FTE_SS_ATTR_REC.CARRIER_ID ,
1160: WSH_DEBUG_SV.C_PROC_LEVEL);
1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
1162: WSH_DEBUG_SV.C_PROC_LEVEL);
1163: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
1164: WSH_DEBUG_SV.C_PROC_LEVEL);
1165:
1166: END IF;

Line 1164: WSH_DEBUG_SV.C_PROC_LEVEL);

1160: WSH_DEBUG_SV.C_PROC_LEVEL);
1161: LOG(l_module_name,' P_FTE_SS_ATTR_REC.SERVICE_LEVEL ' || P_FTE_SS_ATTR_REC.SERVICE_LEVEL,
1162: WSH_DEBUG_SV.C_PROC_LEVEL);
1163: LOG(l_module_name,' P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT ' || P_FTE_SS_ATTR_REC.MODE_OF_TRANSPORT,
1164: WSH_DEBUG_SV.C_PROC_LEVEL);
1165:
1166: END IF;
1167:
1168:

Line 1178: LOG(l_module_name,' Not Different ',WSH_DEBUG_SV.C_PROC_LEVEL);

1174:
1175:
1176: IF l_debug_on
1177: THEN
1178: LOG(l_module_name,' Not Different ',WSH_DEBUG_SV.C_PROC_LEVEL);
1179: END IF;
1180: --}
1181: ELSE
1182: --{

Line 1186: LOG(l_module_name,' Different ',WSH_DEBUG_SV.C_PROC_LEVEL);

1182: --{
1183:
1184: IF l_debug_on
1185: THEN
1186: LOG(l_module_name,' Different ',WSH_DEBUG_SV.C_PROC_LEVEL);
1187: END IF;
1188:
1189:
1190: l_new_rank_list_rec.CARRIER_ID := P_FTE_SS_ATTR_REC.CARRIER_ID;

Line 1228: WSH_DEBUG_SV.logmsg(l_module_name,' X_LIST_CREATE_TYPE ' ||

1224: -- SM
1225:
1226: IF l_debug_on
1227: THEN
1228: WSH_DEBUG_SV.logmsg(l_module_name,' X_LIST_CREATE_TYPE ' ||
1229: X_LIST_CREATE_TYPE,WSH_DEBUG_SV.C_PROC_LEVEL);
1230: END IF;
1231:
1232: IF (X_LIST_CREATE_TYPE = 'SYSTEM')

Line 1229: X_LIST_CREATE_TYPE,WSH_DEBUG_SV.C_PROC_LEVEL);

1225:
1226: IF l_debug_on
1227: THEN
1228: WSH_DEBUG_SV.logmsg(l_module_name,' X_LIST_CREATE_TYPE ' ||
1229: X_LIST_CREATE_TYPE,WSH_DEBUG_SV.C_PROC_LEVEL);
1230: END IF;
1231:
1232: IF (X_LIST_CREATE_TYPE = 'SYSTEM')
1233: THEN

Line 1236: WSH_DEBUG_SV.logmsg(l_module_name,' X_LIST_CREATE_TYPE ' ||

1232: IF (X_LIST_CREATE_TYPE = 'SYSTEM')
1233: THEN
1234: IF l_debug_on
1235: THEN
1236: WSH_DEBUG_SV.logmsg(l_module_name,' X_LIST_CREATE_TYPE ' ||
1237: 'SYSTEM' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1238: END IF;
1239: ELSE
1240: X_LIST_CREATE_TYPE := 'USER';

Line 1237: 'SYSTEM' ,WSH_DEBUG_SV.C_PROC_LEVEL);

1233: THEN
1234: IF l_debug_on
1235: THEN
1236: WSH_DEBUG_SV.logmsg(l_module_name,' X_LIST_CREATE_TYPE ' ||
1237: 'SYSTEM' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1238: END IF;
1239: ELSE
1240: X_LIST_CREATE_TYPE := 'USER';
1241: END IF;

Line 1266: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||

1262: p_trip_in_rec.action_code :='UPDATE';
1263:
1264: IF l_debug_on
1265: THEN
1266: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
1267: ' Setting rank id to null in UIWrapper ',
1268: WSH_DEBUG_SV.C_PROC_LEVEL);
1269: END IF;
1270:

Line 1268: WSH_DEBUG_SV.C_PROC_LEVEL);

1264: IF l_debug_on
1265: THEN
1266: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
1267: ' Setting rank id to null in UIWrapper ',
1268: WSH_DEBUG_SV.C_PROC_LEVEL);
1269: END IF;
1270:
1271:
1272: WSH_INTERFACE_GRP.Create_Update_Trip

Line 1287: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||

1283: );
1284:
1285: IF l_debug_on
1286: THEN
1287: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
1288: l_return_status,
1289: WSH_DEBUG_SV.C_PROC_LEVEL);
1290: END IF;
1291:

Line 1289: WSH_DEBUG_SV.C_PROC_LEVEL);

1285: IF l_debug_on
1286: THEN
1287: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
1288: l_return_status,
1289: WSH_DEBUG_SV.C_PROC_LEVEL);
1290: END IF;
1291:
1292: wsh_util_core.api_post_call(
1293: p_return_status =>l_return_status,

Line 1332: LOG(l_module_name,' Shipmethod did not modify ',WSH_DEBUG_SV.C_PROC_LEVEL);

1328: THEN
1329: --{
1330: IF l_debug_on
1331: THEN
1332: LOG(l_module_name,' Shipmethod did not modify ',WSH_DEBUG_SV.C_PROC_LEVEL);
1333: END IF;
1334:
1335: l_sm_modified := 'N';
1336: END IF;

Line 1374: WSH_DEBUG_SV.C_PROC_LEVEL);

1370: IF l_debug_on
1371: THEN
1372: LOG(l_module_name,
1373: ' save rank list Value ' || X_SAVE_RANK_LIST,
1374: WSH_DEBUG_SV.C_PROC_LEVEL);
1375: END IF;
1376:
1377:
1378: -- Standard call to get message count and if count is 1,get message info.

Line 1392: WSH_DEBUG_SV.pop(l_module_name);

1388: --
1389: --
1390:
1391: IF l_debug_on THEN
1392: WSH_DEBUG_SV.pop(l_module_name);
1393: END IF;
1394:
1395: --}
1396: EXCEPTION

Line 1408: WSH_DEBUG_SV.pop(l_module_name);

1404: p_data => x_msg_data,
1405: p_encoded => FND_API.G_FALSE
1406: );
1407: IF l_debug_on THEN
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1410:
1411: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1412: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;

Line 1421: WSH_DEBUG_SV.pop(l_module_name);

1417: p_data => x_msg_data,
1418: p_encoded => FND_API.G_FALSE
1419: );
1420: IF l_debug_on THEN
1421: WSH_DEBUG_SV.pop(l_module_name);
1422: END IF;
1423: WHEN OTHERS THEN
1424: ROLLBACK TO CREATE_SEARCH_CRITERIA_UI_PUB;
1425: wsh_util_core.default_handler('FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_UI');

Line 1434: WSH_DEBUG_SV.pop(l_module_name);

1430: p_data => x_msg_data,
1431: p_encoded => FND_API.G_FALSE
1432: );
1433: IF l_debug_on THEN
1434: WSH_DEBUG_SV.pop(l_module_name);
1435: END IF;
1436:
1437: --}
1438:

Line 1466: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

1462:
1463:
1464: l_api_name CONSTANT VARCHAR2(30) := 'SEARCH_SERVICES';
1465: l_api_version CONSTANT NUMBER := 1.0;
1466: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
1467: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
1468:
1469:
1470: l_return_status VARCHAR2(1);

Line 1508: WSH_DEBUG_SV.push(l_module_name);

1504:
1505:
1506: SAVEPOINT SEARCH_SERVICES_PUB;
1507: IF l_debug_on THEN
1508: WSH_DEBUG_SV.push(l_module_name);
1509: END IF;
1510:
1511: IF FND_API.to_Boolean( p_init_msg_list )
1512: THEN

Line 1527: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);

1523:
1524: IF l_debug_on
1525: THEN
1526: LOG(l_module_name,' P_caller ' ||
1527: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
1528: LOG(l_module_name,' Append list flag ' ||
1529: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
1530: END IF;
1531:

Line 1529: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);

1525: THEN
1526: LOG(l_module_name,' P_caller ' ||
1527: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
1528: LOG(l_module_name,' Append list flag ' ||
1529: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
1530: END IF;
1531:
1532: IF (p_caller = S_CALLER_WF)
1533: THEN

Line 1544: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);

1540: --{
1541: IF l_debug_on
1542: THEN
1543: LOG(l_module_name,' Return back because we cannot expand ' ||
1544: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
1545: END IF;
1546:
1547: return;
1548: --}

Line 1555: WSH_DEBUG_SV.C_PROC_LEVEL);

1551:
1552: IF l_debug_on
1553: THEN
1554: LOG(l_module_name,' Call FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_WF ',
1555: WSH_DEBUG_SV.C_PROC_LEVEL);
1556: END IF;
1557:
1558: CREATE_SEARCH_CRITERIA_WF(
1559: P_API_VERSION_NUMBER => 1.0,

Line 1575: WSH_DEBUG_SV.C_PROC_LEVEL);

1571: IF l_debug_on
1572: THEN
1573: LOG(l_module_name,' Result FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_WF ' ||
1574: l_return_status,
1575: WSH_DEBUG_SV.C_PROC_LEVEL);
1576: END IF;
1577:
1578: wsh_util_core.api_post_call(
1579: p_return_status =>l_return_status,

Line 1588: WSH_DEBUG_SV.C_PROC_LEVEL);

1584: IF l_debug_on
1585: THEN
1586: LOG(l_module_name,' copy existing service in the rank list to out tab X_SS_RATE_SORT TAB ' ||
1587: l_existing_service_tbl.COUNT,
1588: WSH_DEBUG_SV.C_PROC_LEVEL);
1589: END IF;
1590: --}
1591: ELSIF (p_caller = S_CALLER_UI) THEN
1592: --{

Line 1596: WSH_DEBUG_SV.C_PROC_LEVEL);

1592: --{
1593: IF l_debug_on
1594: THEN
1595: LOG(l_module_name,' Call FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_UI ',
1596: WSH_DEBUG_SV.C_PROC_LEVEL);
1597: END IF;
1598:
1599: CREATE_SEARCH_CRITERIA_UI(
1600: P_API_VERSION_NUMBER => 1.0,

Line 1617: WSH_DEBUG_SV.C_PROC_LEVEL);

1613: IF l_debug_on
1614: THEN
1615: LOG(l_module_name,' Result FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_UI ' ||
1616: l_return_status,
1617: WSH_DEBUG_SV.C_PROC_LEVEL);
1618: LOG(l_module_name,' List Create Type ' || x_list_create_type,
1619: WSH_DEBUG_SV.C_PROC_LEVEL);
1620:
1621: END IF;

Line 1619: WSH_DEBUG_SV.C_PROC_LEVEL);

1615: LOG(l_module_name,' Result FTE_SS_INTERFACE.CREATE_SEARCH_CRITERIA_UI ' ||
1616: l_return_status,
1617: WSH_DEBUG_SV.C_PROC_LEVEL);
1618: LOG(l_module_name,' List Create Type ' || x_list_create_type,
1619: WSH_DEBUG_SV.C_PROC_LEVEL);
1620:
1621: END IF;
1622:
1623: wsh_util_core.api_post_call(

Line 1635: LOG(l_module_name,' Printing the SEARCH CRITERIA ', WSH_DEBUG_SV.C_PROC_LEVEL);

1631:
1632:
1633: IF l_debug_on
1634: THEN
1635: LOG(l_module_name,' Printing the SEARCH CRITERIA ', WSH_DEBUG_SV.C_PROC_LEVEL);
1636: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1637:
1638: IF (l_search_criteria_tbl.COUNT > 0)
1639: THEN

Line 1636: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);

1632:
1633: IF l_debug_on
1634: THEN
1635: LOG(l_module_name,' Printing the SEARCH CRITERIA ', WSH_DEBUG_SV.C_PROC_LEVEL);
1636: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1637:
1638: IF (l_search_criteria_tbl.COUNT > 0)
1639: THEN
1640: --{

Line 1646: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);

1642: FOR i IN l_search_criteria_tbl.FIRST..l_search_criteria_tbl.LAST
1643: LOOP
1644: --{
1645:
1646: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1647: Log(l_module_name,' l_search_criteria_tbl.RANK_ID ' || l_search_criteria_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1647: Log(l_module_name,' l_search_criteria_tbl.RANK_ID ' || l_search_criteria_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

1643: LOOP
1644: --{
1645:
1646: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1647: Log(l_module_name,' l_search_criteria_tbl.RANK_ID ' || l_search_criteria_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);

1644: --{
1645:
1646: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1647: Log(l_module_name,' l_search_criteria_tbl.RANK_ID ' || l_search_criteria_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

1645:
1646: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1647: Log(l_module_name,' l_search_criteria_tbl.RANK_ID ' || l_search_criteria_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);

1646: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1647: Log(l_module_name,' l_search_criteria_tbl.RANK_ID ' || l_search_criteria_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1654: Log(l_module_name,' l_search_criteria_tbl.INITSMCONFIG ' || l_search_criteria_tbl(i).INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);

1647: Log(l_module_name,' l_search_criteria_tbl.RANK_ID ' || l_search_criteria_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1654: Log(l_module_name,' l_search_criteria_tbl.INITSMCONFIG ' || l_search_criteria_tbl(i).INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);
1655: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);

1648: LOG(l_module_name,' l_search_criteria_tbl.RANK_SEQUENCE ' || l_search_criteria_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1654: Log(l_module_name,' l_search_criteria_tbl.INITSMCONFIG ' || l_search_criteria_tbl(i).INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);
1655: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1656:

Line 1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);

1649: LOG(l_module_name,' l_search_criteria_tbl.CARRIER_ID ' || l_search_criteria_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1654: Log(l_module_name,' l_search_criteria_tbl.INITSMCONFIG ' || l_search_criteria_tbl(i).INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);
1655: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1656:
1657: --}

Line 1654: Log(l_module_name,' l_search_criteria_tbl.INITSMCONFIG ' || l_search_criteria_tbl(i).INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);

1650: Log(l_module_name,' l_search_criteria_tbl.SERVICE_LEVEL ' || l_search_criteria_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1654: Log(l_module_name,' l_search_criteria_tbl.INITSMCONFIG ' || l_search_criteria_tbl(i).INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);
1655: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1656:
1657: --}
1658: END LOOP;

Line 1655: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);

1651: Log(l_module_name,' l_search_criteria_tbl.MODE_OF_TRANSPORT ' || l_search_criteria_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1652: Log(l_module_name,' l_search_criteria_tbl.SOURCE ' || l_search_criteria_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1653: Log(l_module_name,' l_search_criteria_tbl.SORT ' || l_search_criteria_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1654: Log(l_module_name,' l_search_criteria_tbl.INITSMCONFIG ' || l_search_criteria_tbl(i).INITSMCONFIG,WSH_DEBUG_SV.C_PROC_LEVEL);
1655: LOG(l_module_name,' &&&&&&&&&&&&&&&&&&&&&&&& ', WSH_DEBUG_SV.C_PROC_LEVEL);
1656:
1657: --}
1658: END LOOP;
1659: --}

Line 1661: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);

1657: --}
1658: END LOOP;
1659: --}
1660: END IF;
1661: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1662: LOG(l_module_name,' End Printing the search criteria ', WSH_DEBUG_SV.C_PROC_LEVEL);
1663:
1664: END IF;
1665:

Line 1662: LOG(l_module_name,' End Printing the search criteria ', WSH_DEBUG_SV.C_PROC_LEVEL);

1658: END LOOP;
1659: --}
1660: END IF;
1661: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1662: LOG(l_module_name,' End Printing the search criteria ', WSH_DEBUG_SV.C_PROC_LEVEL);
1663:
1664: END IF;
1665:
1666:

Line 1679: WSH_DEBUG_SV.C_PROC_LEVEL);

1675: --{
1676: IF l_debug_on
1677: THEN
1678: LOG(l_module_name,' Calling RATE_SORT_WRAPPER ',
1679: WSH_DEBUG_SV.C_PROC_LEVEL);
1680: END IF;
1681:
1682: RATE_SORT_WRAPPER(p_ss_rate_sort_tbl => l_search_criteria_tbl,
1683: x_ss_rate_sort_tbl => l_search_results_tbl);

Line 1692: WSH_DEBUG_SV.C_PROC_LEVEL);

1688:
1689: IF l_debug_on
1690: THEN
1691: LOG(l_module_name,' Calling FTE_TRIP_RATING_GRP.Search_Rate_Sort ',
1692: WSH_DEBUG_SV.C_PROC_LEVEL);
1693: END IF;
1694:
1695:
1696: FTE_TRIP_RATING_GRP.Search_Rate_Sort(

Line 1715: WSH_DEBUG_SV.C_PROC_LEVEL);

1711: IF l_debug_on
1712: THEN
1713: LOG(l_module_name,' Return message after calling Search Rate sort ' ||
1714: l_return_status,
1715: WSH_DEBUG_SV.C_PROC_LEVEL);
1716: END IF;
1717:
1718:
1719: wsh_util_core.api_post_call(

Line 1730: WSH_DEBUG_SV.C_PROC_LEVEL);

1726: IF l_debug_on
1727: THEN
1728: LOG(l_module_name,' Existing Service count l_existing_service_tbl.COUNT ' ||
1729: l_existing_service_tbl.COUNT,
1730: WSH_DEBUG_SV.C_PROC_LEVEL);
1731: LOG(l_module_name,' Search Service result count l_search_results_tbl.COUNT ' ||
1732: l_search_results_tbl.COUNT,
1733: WSH_DEBUG_SV.C_PROC_LEVEL);
1734: LOG(l_module_name,' Rating request id ' || x_rating_request_id,

Line 1733: WSH_DEBUG_SV.C_PROC_LEVEL);

1729: l_existing_service_tbl.COUNT,
1730: WSH_DEBUG_SV.C_PROC_LEVEL);
1731: LOG(l_module_name,' Search Service result count l_search_results_tbl.COUNT ' ||
1732: l_search_results_tbl.COUNT,
1733: WSH_DEBUG_SV.C_PROC_LEVEL);
1734: LOG(l_module_name,' Rating request id ' || x_rating_request_id,
1735: WSH_DEBUG_SV.C_PROC_LEVEL);
1736: END IF;
1737:

Line 1735: WSH_DEBUG_SV.C_PROC_LEVEL);

1731: LOG(l_module_name,' Search Service result count l_search_results_tbl.COUNT ' ||
1732: l_search_results_tbl.COUNT,
1733: WSH_DEBUG_SV.C_PROC_LEVEL);
1734: LOG(l_module_name,' Rating request id ' || x_rating_request_id,
1735: WSH_DEBUG_SV.C_PROC_LEVEL);
1736: END IF;
1737:
1738:
1739:

Line 1747: WSH_DEBUG_SV.C_PROC_LEVEL);

1743: IF l_debug_on
1744: THEN
1745: LOG(l_module_name,' search result count is 0 ' ||
1746: l_return_status,
1747: WSH_DEBUG_SV.C_PROC_LEVEL);
1748: END IF;
1749: -- we cannot do anything
1750: --}
1751: ELSIF (x_rating_request_id IS NOT NULL)

Line 1764: WSH_DEBUG_SV.C_PROC_LEVEL);

1760:
1761: IF l_debug_on
1762: THEN
1763: LOG(l_module_name,' Eliminating Duplicates ',
1764: WSH_DEBUG_SV.C_PROC_LEVEL);
1765:
1766: END IF;
1767:
1768: -- remove the existing services from l_search_results tbl

Line 1777: l_existing_service_tbl(j).LANE_ID , WSH_DEBUG_SV.C_PROC_LEVEL);

1773: LOOP
1774: --{
1775: LOG(l_module_name,' Compare Lane Id. l_search_results_tbl ' ||
1776: l_search_results_tbl(i).LANE_ID || ' with l_existing_service_tbl ' ||
1777: l_existing_service_tbl(j).LANE_ID , WSH_DEBUG_SV.C_PROC_LEVEL);
1778:
1779: LOG(l_module_name,' Compare VEHICLE. l_search_results_tbl ' ||
1780: l_search_results_tbl(i).VEHICLE_ITEM_ID || ' with l_existing_service_tbl ' ||
1781: l_existing_service_tbl(j).VEHICLE_ITEM_ID, WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1781: l_existing_service_tbl(j).VEHICLE_ITEM_ID, WSH_DEBUG_SV.C_PROC_LEVEL);

1777: l_existing_service_tbl(j).LANE_ID , WSH_DEBUG_SV.C_PROC_LEVEL);
1778:
1779: LOG(l_module_name,' Compare VEHICLE. l_search_results_tbl ' ||
1780: l_search_results_tbl(i).VEHICLE_ITEM_ID || ' with l_existing_service_tbl ' ||
1781: l_existing_service_tbl(j).VEHICLE_ITEM_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1782:
1783:
1784: IF (l_search_results_tbl(i).LANE_ID <> -99)
1785: THEN

Line 1800: ' Remove this service. Do not send it to Rank list ' || l_search_results_tbl(i).LANE_ID, WSH_DEBUG_SV.C_PROC_LEVEL);

1796: -- Check if vehicle is same. if yes
1797: IF l_debug_on
1798: THEN
1799: LOG(l_module_name,
1800: ' Remove this service. Do not send it to Rank list ' || l_search_results_tbl(i).LANE_ID, WSH_DEBUG_SV.C_PROC_LEVEL);
1801:
1802: END IF;
1803:
1804: l_search_results_tbl(i).LANE_ID := -99;

Line 1811: ' because that is the latest rate ' , WSH_DEBUG_SV.C_PROC_LEVEL);

1807: IF l_debug_on
1808: THEN
1809: LOG(l_module_name,
1810: ' But copy the rate information from search restuls to the existins ' ||
1811: ' because that is the latest rate ' , WSH_DEBUG_SV.C_PROC_LEVEL);
1812: END IF;
1813:
1814: l_existing_service_tbl(j).ESTIMATED_RATE :=
1815: l_search_results_tbl(i).ESTIMATED_RATE;

Line 1847: WSH_DEBUG_SV.C_PROC_LEVEL);

1843:
1844: IF l_debug_on
1845: THEN
1846: LOG(l_module_name,' Save everything. Except Manual. ' ,
1847: WSH_DEBUG_SV.C_PROC_LEVEL);
1848: END IF;
1849:
1850:
1851: l_rank_list_action := FTE_CARRIER_RANK_LIST_PVT.S_CREATE;

Line 1869: LOG(l_module_name,' Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);

1865: X_SS_RATE_SORT_TAB(X_SS_RATE_SORT_TAB.COUNT+1) := l_existing_service_tbl(i);
1866:
1867: IF l_debug_on
1868: THEN
1869: LOG(l_module_name,' Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);
1870: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1871:
1872:
1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1870: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);

1866:
1867: IF l_debug_on
1868: THEN
1869: LOG(l_module_name,' Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);
1870: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1871:
1872:
1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

1869: LOG(l_module_name,' Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);
1870: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1871:
1872:
1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);

1870: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1871:
1872:
1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

1871:
1872:
1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);

1872:
1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);

1873: Log(l_module_name,' l_existing_service_tbl.RANK_ID ' || l_existing_service_tbl(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1881:

Line 1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

1874: Log(l_module_name,' l_existing_service_tbl.RANK_SEQUENCE ' || l_existing_service_tbl(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1881:
1882: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);

1875: Log(l_module_name,' l_existing_service_tbl.CARRIER_ID ' || l_existing_service_tbl(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1881:
1882: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1883: LOG(l_module_name,' End Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);

1876: Log(l_module_name,' l_existing_service_tbl.SERVICE_LEVEL ' || l_existing_service_tbl(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
1877: Log(l_module_name,' l_existing_service_tbl.MODE_OF_TRANSPORT ' || l_existing_service_tbl(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1881:
1882: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1883: LOG(l_module_name,' End Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);
1884:

Line 1882: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);

1878: Log(l_module_name,' l_existing_service_tbl.LANE_ID ' || l_existing_service_tbl(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1881:
1882: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1883: LOG(l_module_name,' End Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);
1884:
1885: END IF;
1886:

Line 1883: LOG(l_module_name,' End Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);

1879: Log(l_module_name,' l_existing_service_tbl.SOURCE ' || l_existing_service_tbl(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
1880: Log(l_module_name,' l_existing_service_tbl.SORT ' || l_existing_service_tbl(i).SORT,WSH_DEBUG_SV.C_PROC_LEVEL);
1881:
1882: LOG(l_module_name,' ********************************************** ', WSH_DEBUG_SV.C_PROC_LEVEL);
1883: LOG(l_module_name,' End Printing existing service ', WSH_DEBUG_SV.C_PROC_LEVEL);
1884:
1885: END IF;
1886:
1887: --}

Line 2012: WSH_DEBUG_SV.C_PROC_LEVEL);

2008:
2009: IF l_debug_on
2010: THEN
2011: LOG(l_module_name,' l_existing_service_tbl.count = 0 ' ,
2012: WSH_DEBUG_SV.C_PROC_LEVEL);
2013: END IF;
2014:
2015:
2016: FOR i IN l_rank_list_in_param_tbl.FIRST..l_rank_list_in_param_tbl.LAST

Line 2031: WSH_DEBUG_SV.C_PROC_LEVEL);

2027: --{
2028: IF l_debug_on
2029: THEN
2030: LOG(l_module_name,' l_existing_service_tbl.count is not 0 ' ,
2031: WSH_DEBUG_SV.C_PROC_LEVEL);
2032: END IF;
2033:
2034: FOR i IN l_rank_list_in_param_tbl.FIRST..l_rank_list_in_param_tbl.LAST
2035: LOOP

Line 2066: WSH_DEBUG_SV.C_PROC_LEVEL);

2062: --{
2063: IF l_debug_on
2064: THEN
2065: LOG(l_module_name,' Rating request id is null so do not do anything. ' ,
2066: WSH_DEBUG_SV.C_PROC_LEVEL);
2067: END IF;
2068:
2069: --}
2070: END IF;

Line 2104: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||

2100: p_trip_in_rec.action_code :='UPDATE';
2101:
2102: IF l_debug_on
2103: THEN
2104: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
2105: ' Updating append flag to N ',
2106: WSH_DEBUG_SV.C_PROC_LEVEL);
2107: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
2108: ' Trip Id ' || p_trip_info.TRIP_ID,

Line 2106: WSH_DEBUG_SV.C_PROC_LEVEL);

2102: IF l_debug_on
2103: THEN
2104: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
2105: ' Updating append flag to N ',
2106: WSH_DEBUG_SV.C_PROC_LEVEL);
2107: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
2108: ' Trip Id ' || p_trip_info.TRIP_ID,
2109: WSH_DEBUG_SV.C_PROC_LEVEL);
2110: END IF;

Line 2107: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||

2103: THEN
2104: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
2105: ' Updating append flag to N ',
2106: WSH_DEBUG_SV.C_PROC_LEVEL);
2107: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
2108: ' Trip Id ' || p_trip_info.TRIP_ID,
2109: WSH_DEBUG_SV.C_PROC_LEVEL);
2110: END IF;
2111:

Line 2109: WSH_DEBUG_SV.C_PROC_LEVEL);

2105: ' Updating append flag to N ',
2106: WSH_DEBUG_SV.C_PROC_LEVEL);
2107: WSH_DEBUG_SV.logmsg(l_module_name,' Before calling CREATE_UPDATE_TRIP ' ||
2108: ' Trip Id ' || p_trip_info.TRIP_ID,
2109: WSH_DEBUG_SV.C_PROC_LEVEL);
2110: END IF;
2111:
2112:
2113: WSH_INTERFACE_GRP.Create_Update_Trip

Line 2128: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||

2124: );
2125:
2126: IF l_debug_on
2127: THEN
2128: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
2129: l_return_status,
2130: WSH_DEBUG_SV.C_PROC_LEVEL);
2131: END IF;
2132:

Line 2130: WSH_DEBUG_SV.C_PROC_LEVEL);

2126: IF l_debug_on
2127: THEN
2128: WSH_DEBUG_SV.logmsg(l_module_name,' REturn value from Create update trip ' ||
2129: l_return_status,
2130: WSH_DEBUG_SV.C_PROC_LEVEL);
2131: END IF;
2132:
2133: wsh_util_core.api_post_call(
2134: p_return_status =>l_return_status,

Line 2154: Log(l_module_name,' PRINTING ALL SERVICES ********** ',WSH_DEBUG_SV.C_PROC_LEVEL);

2150: END IF;
2151:
2152: IF l_debug_on
2153: THEN
2154: Log(l_module_name,' PRINTING ALL SERVICES ********** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2155: END IF;
2156:
2157: -- Printing all the services
2158: IF (X_SS_RATE_SORT_TAB.COUNT > 0)

Line 2167: Log(l_module_name,' ******************** ',WSH_DEBUG_SV.C_PROC_LEVEL);

2163: LOOP
2164: --{
2165: IF l_debug_on
2166: THEN
2167: Log(l_module_name,' ******************** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2168:
2169: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_ID ' || X_SS_RATE_SORT_TAB(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2169: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_ID ' || X_SS_RATE_SORT_TAB(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

2165: IF l_debug_on
2166: THEN
2167: Log(l_module_name,' ******************** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2168:
2169: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_ID ' || X_SS_RATE_SORT_TAB(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);

2166: THEN
2167: Log(l_module_name,' ******************** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2168:
2169: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_ID ' || X_SS_RATE_SORT_TAB(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

2167: Log(l_module_name,' ******************** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2168:
2169: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_ID ' || X_SS_RATE_SORT_TAB(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);

2168:
2169: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_ID ' || X_SS_RATE_SORT_TAB(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);

2169: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_ID ' || X_SS_RATE_SORT_TAB(i).RANK_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

2170: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE ' || X_SS_RATE_SORT_TAB(i).RANK_SEQUENCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);

2171: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CARRIER_ID ' || X_SS_RATE_SORT_TAB(i).CARRIER_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);

2172: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL ' || X_SS_RATE_SORT_TAB(i).SERVICE_LEVEL,WSH_DEBUG_SV.C_PROC_LEVEL);
2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);

2173: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT ' || X_SS_RATE_SORT_TAB(i).MODE_OF_TRANSPORT,WSH_DEBUG_SV.C_PROC_LEVEL);
2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

2174: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).LANE_ID ' || X_SS_RATE_SORT_TAB(i).LANE_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
2182: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO ' || X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);

2175: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).SOURCE ' || X_SS_RATE_SORT_TAB(i).SOURCE,WSH_DEBUG_SV.C_PROC_LEVEL);
2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
2182: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO ' || X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
2183: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE ' || X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);

2176: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_RATE,WSH_DEBUG_SV.C_PROC_LEVEL);
2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
2182: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO ' || X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
2183: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE ' || X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2184: END IF;

Line 2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);

2177: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CURRENCY_CODE ' || X_SS_RATE_SORT_TAB(i).CURRENCY_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
2182: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO ' || X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
2183: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE ' || X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2184: END IF;
2185:

Line 2182: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO ' || X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);

2178: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ITEM_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
2182: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO ' || X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
2183: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE ' || X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2184: END IF;
2185:
2186: --}

Line 2183: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE ' || X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);

2179: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID ' || X_SS_RATE_SORT_TAB(i).VEHICLE_ORG_ID,WSH_DEBUG_SV.C_PROC_LEVEL);
2180: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME ' || X_SS_RATE_SORT_TAB(i).ESTIMATED_TRANSIT_TIME,WSH_DEBUG_SV.C_PROC_LEVEL);
2181: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM ' || X_SS_RATE_SORT_TAB(i).TRANSIT_TIME_UOM,WSH_DEBUG_SV.C_PROC_LEVEL);
2182: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO ' || X_SS_RATE_SORT_TAB(i).CONSIGNEE_CARRIER_AC_NO,WSH_DEBUG_SV.C_PROC_LEVEL);
2183: Log(l_module_name,' X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE ' || X_SS_RATE_SORT_TAB(i).FREIGHT_TERMS_CODE,WSH_DEBUG_SV.C_PROC_LEVEL);
2184: END IF;
2185:
2186: --}
2187: END LOOP;

Line 2192: Log(l_module_name,' END PRINTING ALL SERVICES ********** ',WSH_DEBUG_SV.C_PROC_LEVEL);

2188: END IF;
2189:
2190: IF l_debug_on
2191: THEN
2192: Log(l_module_name,' END PRINTING ALL SERVICES ********** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2193: LOG(l_module_name,' X_LIST_CREATE_TYPE value ' || X_LIST_CREATE_TYPE,
2194: WSH_DEBUG_SV.C_PROC_LEVEL);
2195: END IF;
2196:

Line 2194: WSH_DEBUG_SV.C_PROC_LEVEL);

2190: IF l_debug_on
2191: THEN
2192: Log(l_module_name,' END PRINTING ALL SERVICES ********** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2193: LOG(l_module_name,' X_LIST_CREATE_TYPE value ' || X_LIST_CREATE_TYPE,
2194: WSH_DEBUG_SV.C_PROC_LEVEL);
2195: END IF;
2196:
2197:
2198: -- Standard call to get message count and if count is 1,get message info.

Line 2211: WSH_DEBUG_SV.pop(l_module_name);

2207: --
2208: --
2209:
2210: IF l_debug_on THEN
2211: WSH_DEBUG_SV.pop(l_module_name);
2212: END IF;
2213:
2214: --}
2215: EXCEPTION

Line 2227: WSH_DEBUG_SV.pop(l_module_name);

2223: p_data => x_msg_data,
2224: p_encoded => FND_API.G_FALSE
2225: );
2226: IF l_debug_on THEN
2227: WSH_DEBUG_SV.pop(l_module_name);
2228: END IF;
2229:
2230: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2231: ROLLBACK TO SEARCH_SERVICES_PUB;

Line 2240: WSH_DEBUG_SV.pop(l_module_name);

2236: p_data => x_msg_data,
2237: p_encoded => FND_API.G_FALSE
2238: );
2239: IF l_debug_on THEN
2240: WSH_DEBUG_SV.pop(l_module_name);
2241: END IF;
2242: WHEN OTHERS THEN
2243: ROLLBACK TO SEARCH_SERVICES_PUB;
2244: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES');

Line 2253: WSH_DEBUG_SV.pop(l_module_name);

2249: p_data => x_msg_data,
2250: p_encoded => FND_API.G_FALSE
2251: );
2252: IF l_debug_on THEN
2253: WSH_DEBUG_SV.pop(l_module_name);
2254: END IF;
2255:
2256:
2257: --}

Line 2282: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2278:
2279:
2280: l_api_name CONSTANT VARCHAR2(30) := 'SEARCH_SERVICES_UIWRAPPER';
2281: l_api_version CONSTANT NUMBER := 1.0;
2282: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2283: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2284:
2285:
2286: l_return_status VARCHAR2(1);

Line 2305: WSH_DEBUG_SV.push(l_module_name);

2301:
2302:
2303: SAVEPOINT SEARCH_SERVICES_UIWRAPPER_PUB;
2304: IF l_debug_on THEN
2305: WSH_DEBUG_SV.push(l_module_name);
2306: END IF;
2307:
2308: IF FND_API.to_Boolean( p_init_msg_list )
2309: THEN

Line 2324: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);

2320:
2321: IF l_debug_on
2322: THEN
2323: LOG(l_module_name,' P_caller ' ||
2324: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
2325: LOG(l_module_name,' Append list flag ' ||
2326: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2327: LOG(l_module_name,' Calling FTE_SS_INTERFACE.SEARCH_SERVICES ' ||
2328: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 2326: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);

2322: THEN
2323: LOG(l_module_name,' P_caller ' ||
2324: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
2325: LOG(l_module_name,' Append list flag ' ||
2326: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2327: LOG(l_module_name,' Calling FTE_SS_INTERFACE.SEARCH_SERVICES ' ||
2328: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2329:
2330: END IF;

Line 2328: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);

2324: p_caller,WSH_DEBUG_SV.C_PROC_LEVEL);
2325: LOG(l_module_name,' Append list flag ' ||
2326: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2327: LOG(l_module_name,' Calling FTE_SS_INTERFACE.SEARCH_SERVICES ' ||
2328: P_FTE_SS_ATTR_REC.append_list_flag,WSH_DEBUG_SV.C_PROC_LEVEL);
2329:
2330: END IF;
2331:
2332:

Line 2373: WSH_DEBUG_SV.C_PROC_LEVEL);

2369: IF l_debug_on
2370: THEN
2371:
2372: LOG(l_module_name,' List Create Type ' || x_list_create_type,
2373: WSH_DEBUG_SV.C_PROC_LEVEL);
2374:
2375: Log(l_module_name,' Looping through all results to return back values to UI ',WSH_DEBUG_SV.C_PROC_LEVEL);
2376:
2377: END IF;

Line 2375: Log(l_module_name,' Looping through all results to return back values to UI ',WSH_DEBUG_SV.C_PROC_LEVEL);

2371:
2372: LOG(l_module_name,' List Create Type ' || x_list_create_type,
2373: WSH_DEBUG_SV.C_PROC_LEVEL);
2374:
2375: Log(l_module_name,' Looping through all results to return back values to UI ',WSH_DEBUG_SV.C_PROC_LEVEL);
2376:
2377: END IF;
2378:
2379: -- Printing all the services

Line 2421: Log(l_module_name,' END PRINTING ALL SERVICES ********** ',WSH_DEBUG_SV.C_PROC_LEVEL);

2417: END IF;
2418:
2419: IF l_debug_on
2420: THEN
2421: Log(l_module_name,' END PRINTING ALL SERVICES ********** ',WSH_DEBUG_SV.C_PROC_LEVEL);
2422: END IF;
2423:
2424:
2425: -- Standard call to get message count and if count is 1,get message info.

Line 2438: WSH_DEBUG_SV.pop(l_module_name);

2434: --
2435: --
2436:
2437: IF l_debug_on THEN
2438: WSH_DEBUG_SV.pop(l_module_name);
2439: END IF;
2440:
2441: --}
2442: EXCEPTION

Line 2454: WSH_DEBUG_SV.pop(l_module_name);

2450: p_data => x_msg_data,
2451: p_encoded => FND_API.G_FALSE
2452: );
2453: IF l_debug_on THEN
2454: WSH_DEBUG_SV.pop(l_module_name);
2455: END IF;
2456:
2457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2458: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;

Line 2467: WSH_DEBUG_SV.pop(l_module_name);

2463: p_data => x_msg_data,
2464: p_encoded => FND_API.G_FALSE
2465: );
2466: IF l_debug_on THEN
2467: WSH_DEBUG_SV.pop(l_module_name);
2468: END IF;
2469: WHEN OTHERS THEN
2470: ROLLBACK TO SEARCH_SERVICES_UIWRAPPER_PUB;
2471: wsh_util_core.default_handler('FTE_SS_INTERFACE.SEARCH_SERVICES_UIWRAPPER');

Line 2480: WSH_DEBUG_SV.pop(l_module_name);

2476: p_data => x_msg_data,
2477: p_encoded => FND_API.G_FALSE
2478: );
2479: IF l_debug_on THEN
2480: WSH_DEBUG_SV.pop(l_module_name);
2481: END IF;
2482:
2483:
2484: --}

Line 2512: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2508:
2509:
2510: l_api_name CONSTANT VARCHAR2(30) := 'GET_RANKED_RESULTS_WRAPPER';
2511: l_api_version CONSTANT NUMBER := 1.0;
2512: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2513: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.' || G_PKG_NAME || '.' || l_api_name;
2514:
2515:
2516: l_return_status VARCHAR2(32767);

Line 2535: WSH_DEBUG_SV.push(l_module_name);

2531:
2532:
2533: SAVEPOINT GET_RANKED_RESULTS_WRAPPER_PUB;
2534: IF l_debug_on THEN
2535: WSH_DEBUG_SV.push(l_module_name);
2536: END IF;
2537:
2538: IF FND_API.to_Boolean( p_init_msg_list )
2539: THEN

Line 2553: LOG(l_module_name,' Calling Routing guide with rule id ',WSH_DEBUG_SV.C_PROC_LEVEL);

2549:
2550:
2551: IF l_debug_on
2552: THEN
2553: LOG(l_module_name,' Calling Routing guide with rule id ',WSH_DEBUG_SV.C_PROC_LEVEL);
2554: END IF;
2555:
2556: x_routing_guide := FTE_SS_RATE_SORT_TAB_TYPE();
2557:

Line 2566: WSH_DEBUG_SV.C_PROC_LEVEL);

2562: */
2563: IF l_debug_on
2564: THEN
2565: LOG(l_module_name,' return status from GET_RANKED_RESULTS ' || l_return_status,
2566: WSH_DEBUG_SV.C_PROC_LEVEL);
2567: END IF;
2568:
2569: wsh_util_core.api_post_call(
2570: p_return_status =>l_return_status,

Line 2660: WSH_DEBUG_SV.pop(l_module_name);

2656: --
2657: --
2658:
2659: IF l_debug_on THEN
2660: WSH_DEBUG_SV.pop(l_module_name);
2661: END IF;
2662:
2663: --}
2664: EXCEPTION

Line 2676: WSH_DEBUG_SV.pop(l_module_name);

2672: p_data => x_msg_data,
2673: p_encoded => FND_API.G_FALSE
2674: );
2675: IF l_debug_on THEN
2676: WSH_DEBUG_SV.pop(l_module_name);
2677: END IF;
2678:
2679: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2680: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;

Line 2689: WSH_DEBUG_SV.pop(l_module_name);

2685: p_data => x_msg_data,
2686: p_encoded => FND_API.G_FALSE
2687: );
2688: IF l_debug_on THEN
2689: WSH_DEBUG_SV.pop(l_module_name);
2690: END IF;
2691: WHEN OTHERS THEN
2692: ROLLBACK TO GET_RANKED_RESULTS_WRAPPER_PUB;
2693: wsh_util_core.default_handler('FTE_SS_INTERFACE.GET_RANKED_RESULTS_WRAPPER');

Line 2702: WSH_DEBUG_SV.pop(l_module_name);

2698: p_data => x_msg_data,
2699: p_encoded => FND_API.G_FALSE
2700: );
2701: IF l_debug_on THEN
2702: WSH_DEBUG_SV.pop(l_module_name);
2703: END IF;
2704:
2705:
2706: --}

Line 2762: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;

2758: l_ss_rate_sort_rec FTE_SS_RATE_SORT_REC;
2759: l_action_out_rec FTE_ACTION_OUT_REC;
2760: l_trip_action_param FTE_TRIP_ACTION_PARAM_REC;
2761:
2762: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
2763: l_module_name CONSTANT VARCHAR2(100) := 'fte.plsql.'|| G_PKG_NAME ||'.'||'ASSIGN_SERVICE_TENDER';
2764:
2765: BEGIN
2766:

Line 2777: wsh_debug_sv.push(l_module_name);

2773: FND_MSG_PUB.initialize;
2774: END IF;
2775: --
2776: IF l_debug_on THEN
2777: wsh_debug_sv.push(l_module_name);
2778: END IF;
2779: --
2780: --
2781: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 2795: WSH_DEBUG_SV.logmsg(l_module_name, 'TripId:LegId:DeliveryId:'

2791: l_delivery_id := p_ss_attr_rec.delivery_id;
2792: l_list_action := p_list_action;
2793:
2794: IF l_debug_on THEN
2795: WSH_DEBUG_SV.logmsg(l_module_name, 'TripId:LegId:DeliveryId:'
2796: ||l_trip_id||':'||l_delivery_leg_id||':'||l_delivery_id);
2797: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:List Action:'
2798: ||p_service_action||':'||p_list_action);
2799: END IF;

Line 2797: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:List Action:'

2793:
2794: IF l_debug_on THEN
2795: WSH_DEBUG_SV.logmsg(l_module_name, 'TripId:LegId:DeliveryId:'
2796: ||l_trip_id||':'||l_delivery_leg_id||':'||l_delivery_id);
2797: WSH_DEBUG_SV.logmsg(l_module_name, 'Service Action:List Action:'
2798: ||p_service_action||':'||p_list_action);
2799: END IF;
2800:
2801: -- Step 1: Check if old service exists on trip

Line 2808: WSH_DEBUG_SV.logmsg(l_module_name, 'Deleting Main Records for:'||l_trip_id);

2804: IF ( p_service_action = 'UPDATE' AND l_trip_id IS NOT NULL
2805: AND l_delivery_leg_id IS NULL ) THEN
2806:
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name, 'Deleting Main Records for:'||l_trip_id);
2809: END IF;
2810:
2811: FTE_TRIP_RATING_GRP.DELETE_MAIN_RECORDS(
2812: p_trip_id => l_trip_id,

Line 2829: WSH_DEBUG_SV.logmsg(l_module_name, 'List Action:'||p_list_action);

2825: -- If LaneId is null, change l_list_action = 'SET_CURRENT'.
2826:
2827: /* R12 Hiding Project
2828: IF l_debug_on THEN
2829: WSH_DEBUG_SV.logmsg(l_module_name, 'List Action:'||p_list_action);
2830: WSH_DEBUG_SV.logmsg(l_module_name, ' Service List Size:'||p_ss_rate_sort_tab.count);
2831: END IF;
2832:
2833: IF ( l_list_action = 'APPEND' ) THEN

Line 2830: WSH_DEBUG_SV.logmsg(l_module_name, ' Service List Size:'||p_ss_rate_sort_tab.count);

2826:
2827: /* R12 Hiding Project
2828: IF l_debug_on THEN
2829: WSH_DEBUG_SV.logmsg(l_module_name, 'List Action:'||p_list_action);
2830: WSH_DEBUG_SV.logmsg(l_module_name, ' Service List Size:'||p_ss_rate_sort_tab.count);
2831: END IF;
2832:
2833: IF ( l_list_action = 'APPEND' ) THEN
2834: l_ss_rate_sort_rec := p_ss_rate_sort_tab(1);

Line 2837: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Rank Id:'||l_ss_rate_sort_rec.rank_id);

2833: IF ( l_list_action = 'APPEND' ) THEN
2834: l_ss_rate_sort_rec := p_ss_rate_sort_tab(1);
2835:
2836: IF l_debug_on THEN
2837: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Rank Id:'||l_ss_rate_sort_rec.rank_id);
2838: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Lane Id:'||l_ss_rate_sort_rec.lane_id);
2839: END IF;
2840:
2841: IF (l_ss_rate_sort_rec.rank_id IS NOT NULL AND l_ss_rate_sort_rec.lane_id IS NULL) THEN

Line 2838: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Lane Id:'||l_ss_rate_sort_rec.lane_id);

2834: l_ss_rate_sort_rec := p_ss_rate_sort_tab(1);
2835:
2836: IF l_debug_on THEN
2837: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Rank Id:'||l_ss_rate_sort_rec.rank_id);
2838: WSH_DEBUG_SV.logmsg(l_module_name, 'Append Check Lane Id:'||l_ss_rate_sort_rec.lane_id);
2839: END IF;
2840:
2841: IF (l_ss_rate_sort_rec.rank_id IS NOT NULL AND l_ss_rate_sort_rec.lane_id IS NULL) THEN
2842: -- l_ss_rate_sort_rec.schedule_id IS NULL AND

Line 2847: WSH_DEBUG_SV.logmsg(l_module_name, 'Only rank id populated:'||l_rank_id);

2843: l_rank_id := l_ss_rate_sort_rec.rank_id;
2844: l_list_action := 'SET_CURRENT';
2845:
2846: IF l_debug_on THEN
2847: WSH_DEBUG_SV.logmsg(l_module_name, 'Only rank id populated:'||l_rank_id);
2848: END IF;
2849: END IF;
2850: END IF;
2851:

Line 2853: WSH_DEBUG_SV.logmsg(l_module_name, ' New List Action:'||l_list_action);

2849: END IF;
2850: END IF;
2851:
2852: IF l_debug_on THEN
2853: WSH_DEBUG_SV.logmsg(l_module_name, ' New List Action:'||l_list_action);
2854: END IF;
2855:
2856: -- Step 3: Create, Append or SetCurrent Ranked List depending on list action_code
2857: -- Values will be CREATE OR APPEND. Modify APPEND to be either APPEND or SET_CURRENT

Line 2899: WSH_DEBUG_SV.logmsg(l_module_name, 'New Rank Id:'||l_rank_id);

2895:
2896: END IF;
2897:
2898: IF l_debug_on THEN
2899: WSH_DEBUG_SV.logmsg(l_module_name, 'New Rank Id:'||l_rank_id);
2900: END IF;
2901: */
2902:
2903: -- Step 4: Update Trip

Line 2916: WSH_DEBUG_SV.logmsg(l_module_name, 'After unmark reprice status:'||l_return_status);

2912: p_segment_id => l_trip_id,
2913: x_return_status => l_return_status);
2914:
2915: IF l_debug_on THEN
2916: WSH_DEBUG_SV.logmsg(l_module_name, 'After unmark reprice status:'||l_return_status);
2917: END IF;
2918: END IF;
2919:
2920: IF (l_delivery_id IS NULL ) THEN -- Coming from TWB

Line 2992: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP');

2988: */
2989: END IF;
2990:
2991: IF l_debug_on THEN
2992: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP');
2993: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
2994: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
2995: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
2996: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);

Line 2993: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);

2989: END IF;
2990:
2991: IF l_debug_on THEN
2992: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP');
2993: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
2994: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
2995: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
2996: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
2997: END IF;

Line 2994: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);

2990:
2991: IF l_debug_on THEN
2992: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP');
2993: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
2994: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
2995: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
2996: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
2997: END IF;
2998:

Line 2995: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);

2991: IF l_debug_on THEN
2992: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP');
2993: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
2994: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
2995: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
2996: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
2997: END IF;
2998:
2999: -- Step 5: Move FC Rates

Line 2996: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);

2992: WSH_DEBUG_SV.logmsg(l_module_name, 'API:FTE_MLS_WRAPPER.UPDATE_SERVICE_ON_TRIP');
2993: WSH_DEBUG_SV.logmsg(l_module_name, 'l_return_status:'||l_return_status);
2994: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_warnings:'||l_number_of_warnings);
2995: WSH_DEBUG_SV.logmsg(l_module_name, 'l_number_of_errors:'||l_number_of_errors);
2996: WSH_DEBUG_SV.logmsg(l_module_name, 'l_msg_data:'||l_msg_data);
2997: END IF;
2998:
2999: -- Step 5: Move FC Rates
3000: -- If delivery_id is null, this call is coming from TripWB.

Line 3003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Move FC TEMP Request Id:'||p_request_id);

2999: -- Step 5: Move FC Rates
3000: -- If delivery_id is null, this call is coming from TripWB.
3001:
3002: IF l_debug_on THEN
3003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Move FC TEMP Request Id:'||p_request_id);
3004: WSH_DEBUG_SV.logmsg(l_module_name,' If Delivery Id is NULL, from TWB:'||l_delivery_id);
3005: END IF;
3006:
3007: IF ( p_request_id IS NOT NULL ) THEN

Line 3004: WSH_DEBUG_SV.logmsg(l_module_name,' If Delivery Id is NULL, from TWB:'||l_delivery_id);

3000: -- If delivery_id is null, this call is coming from TripWB.
3001:
3002: IF l_debug_on THEN
3003: WSH_DEBUG_SV.logmsg(l_module_name,'Calling Move FC TEMP Request Id:'||p_request_id);
3004: WSH_DEBUG_SV.logmsg(l_module_name,' If Delivery Id is NULL, from TWB:'||l_delivery_id);
3005: END IF;
3006:
3007: IF ( p_request_id IS NOT NULL ) THEN
3008:

Line 3042: WSH_DEBUG_SV.logmsg(l_module_name,'Pre Raising Tender Event CarrierContactId:'

3038:
3039: END IF;
3040:
3041: IF l_debug_on THEN
3042: WSH_DEBUG_SV.logmsg(l_module_name,'Pre Raising Tender Event CarrierContactId:'
3043: ||p_tender_attr_rec.car_contact_id);
3044: END IF;
3045:
3046: -- Step 6: Raise Tender event

Line 3051: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Tender Event CarrierContactId:'

3047: IF ( p_tender_attr_rec IS NOT NULL AND
3048: p_tender_attr_rec.car_contact_id IS NOT NULL) THEN
3049:
3050: IF l_debug_on THEN
3051: WSH_DEBUG_SV.logmsg(l_module_name,'Raising Tender Event CarrierContactId:'
3052: ||p_tender_attr_rec.car_contact_id);
3053: END IF;
3054:
3055: -- Create Trip Actions Tab

Line 3097: WSH_DEBUG_SV.POP(l_module_name);

3093: p_encoded => FND_API.G_FALSE
3094: );
3095:
3096: IF l_debug_on THEN
3097: WSH_DEBUG_SV.POP(l_module_name);
3098: END IF;
3099:
3100: EXCEPTION
3101: WHEN FND_API.G_EXC_ERROR THEN