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_LANE_SEARCH dependencies on WSH_DEBUG_SV

Line 60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

56: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
57: --
58: IF l_debug_on IS NULL
59: THEN
60: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
61: END IF;
62: --
63: --
64: -- Debug Statements

Line 67: WSH_DEBUG_SV.push(l_module_name);

63: --
64: -- Debug Statements
65: --
66: IF l_debug_on THEN
67: WSH_DEBUG_SV.push(l_module_name);
68: --
69: WSH_DEBUG_SV.log(l_module_name,'P_LOC_ID',P_LOC_ID);
70: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

Line 69: WSH_DEBUG_SV.log(l_module_name,'P_LOC_ID',P_LOC_ID);

65: --
66: IF l_debug_on THEN
67: WSH_DEBUG_SV.push(l_module_name);
68: --
69: WSH_DEBUG_SV.log(l_module_name,'P_LOC_ID',P_LOC_ID);
70: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
72: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
73: WSH_DEBUG_SV.log(l_module_name,'P_ZIP',P_ZIP);

Line 70: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);

66: IF l_debug_on THEN
67: WSH_DEBUG_SV.push(l_module_name);
68: --
69: WSH_DEBUG_SV.log(l_module_name,'P_LOC_ID',P_LOC_ID);
70: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
72: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
73: WSH_DEBUG_SV.log(l_module_name,'P_ZIP',P_ZIP);
74: END IF;

Line 71: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);

67: WSH_DEBUG_SV.push(l_module_name);
68: --
69: WSH_DEBUG_SV.log(l_module_name,'P_LOC_ID',P_LOC_ID);
70: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
72: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
73: WSH_DEBUG_SV.log(l_module_name,'P_ZIP',P_ZIP);
74: END IF;
75: --

Line 72: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);

68: --
69: WSH_DEBUG_SV.log(l_module_name,'P_LOC_ID',P_LOC_ID);
70: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
72: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
73: WSH_DEBUG_SV.log(l_module_name,'P_ZIP',P_ZIP);
74: END IF;
75: --
76:

Line 73: WSH_DEBUG_SV.log(l_module_name,'P_ZIP',P_ZIP);

69: WSH_DEBUG_SV.log(l_module_name,'P_LOC_ID',P_LOC_ID);
70: WSH_DEBUG_SV.log(l_module_name,'P_COUNTRY',P_COUNTRY);
71: WSH_DEBUG_SV.log(l_module_name,'P_STATE',P_STATE);
72: WSH_DEBUG_SV.log(l_module_name,'P_CITY',P_CITY);
73: WSH_DEBUG_SV.log(l_module_name,'P_ZIP',P_ZIP);
74: END IF;
75: --
76:
77: IF (p_loc_id is null AND p_country is null AND

Line 85: WSH_DEBUG_SV.logmsg(l_module_name,'no region information passed in',WSH_DEBUG_SV.C_PROC_LEVEL);

81: --
82: -- Debug Statements
83: --
84: IF l_debug_on THEN
85: WSH_DEBUG_SV.logmsg(l_module_name,'no region information passed in',WSH_DEBUG_SV.C_PROC_LEVEL);
86: END IF;
87:
88: l_region_and_type.region_id := NULL;
89: l_region_and_type.region_type := NULL;

Line 120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);

116: --
117: -- Debug Statements
118: --
119: IF l_debug_on THEN
120: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);
121: END IF;
122: --
123: BEGIN
124: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,

Line 144: WSH_DEBUG_SV.logmsg(l_module_name,'No Region Found for ' || l_country || ', ' || l_state || ', ' || l_city);

140:
141: EXCEPTION
142: WHEN NO_DATA_FOUND THEN
143: IF l_debug_on THEN
144: WSH_DEBUG_SV.logmsg(l_module_name,'No Region Found for ' || l_country || ', ' || l_state || ', ' || l_city);
145: END IF;
146: END;
147:
148: -- using city field as a state if region obtained is a country

Line 162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);

158: --
159: -- Debug Statements
160: --
161: IF l_debug_on THEN
162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.GET_ALL_REGION_MATCHES',WSH_DEBUG_SV.C_PROC_LEVEL);
163: END IF;
164: --
165: BEGIN
166: WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches(p_country => l_country,

Line 186: WSH_DEBUG_SV.logmsg(l_module_name,'No Region Found for ' || l_country || ', ' || l_state || ', ' || l_city);

182:
183: EXCEPTION
184: WHEN NO_DATA_FOUND THEN
185: IF l_debug_on THEN
186: WSH_DEBUG_SV.logmsg(l_module_name,'No Region Found for ' || l_country || ', ' || l_state || ', ' || l_city);
187: END IF;
188: END;
189: END IF;
190:

Line 228: WSH_DEBUG_SV.pop(l_module_name);

224: --
225: -- Debug Statements
226: --
227: IF l_debug_on THEN
228: WSH_DEBUG_SV.pop(l_module_name);
229: END IF;
230: END Set_Up_Regions;
231:
232:

Line 286: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

282: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
283: --
284: IF l_debug_on IS NULL
285: THEN
286: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
287: END IF;
288:
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.push(l_module_name);

Line 290: WSH_DEBUG_SV.push(l_module_name);

286: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
287: END IF;
288:
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.push(l_module_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_vehicle_id',p_vehicle_id);
292: WSH_DEBUG_SV.log(l_module_name, 'p_origin_id', p_origin_id);
293: WSH_DEBUG_SV.log(l_module_name, 'p_destination_id', p_dest_id);
294: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id', p_carrier_id);

Line 291: WSH_DEBUG_SV.log(l_module_name,'p_vehicle_id',p_vehicle_id);

287: END IF;
288:
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.push(l_module_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_vehicle_id',p_vehicle_id);
292: WSH_DEBUG_SV.log(l_module_name, 'p_origin_id', p_origin_id);
293: WSH_DEBUG_SV.log(l_module_name, 'p_destination_id', p_dest_id);
294: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id', p_carrier_id);
295: END IF;

Line 292: WSH_DEBUG_SV.log(l_module_name, 'p_origin_id', p_origin_id);

288:
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.push(l_module_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_vehicle_id',p_vehicle_id);
292: WSH_DEBUG_SV.log(l_module_name, 'p_origin_id', p_origin_id);
293: WSH_DEBUG_SV.log(l_module_name, 'p_destination_id', p_dest_id);
294: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id', p_carrier_id);
295: END IF;
296:

Line 293: WSH_DEBUG_SV.log(l_module_name, 'p_destination_id', p_dest_id);

289: IF l_debug_on THEN
290: WSH_DEBUG_SV.push(l_module_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_vehicle_id',p_vehicle_id);
292: WSH_DEBUG_SV.log(l_module_name, 'p_origin_id', p_origin_id);
293: WSH_DEBUG_SV.log(l_module_name, 'p_destination_id', p_dest_id);
294: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id', p_carrier_id);
295: END IF;
296:
297: open c_vehicle_available;

Line 294: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id', p_carrier_id);

290: WSH_DEBUG_SV.push(l_module_name);
291: WSH_DEBUG_SV.log(l_module_name,'p_vehicle_id',p_vehicle_id);
292: WSH_DEBUG_SV.log(l_module_name, 'p_origin_id', p_origin_id);
293: WSH_DEBUG_SV.log(l_module_name, 'p_destination_id', p_dest_id);
294: WSH_DEBUG_SV.log(l_module_name, 'p_carrier_id', p_carrier_id);
295: END IF;
296:
297: open c_vehicle_available;
298: fetch c_vehicle_available into l_id;

Line 315: WSH_DEBUG_SV.pop(l_module_name);

311: --
312: -- Debug Statements
313: --
314: IF l_debug_on THEN
315: WSH_DEBUG_SV.pop(l_module_name);
316: END IF;
317:
318: return l_available;
319:

Line 351: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

347: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
348: --
349: IF l_debug_on IS NULL
350: THEN
351: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
352: END IF;
353: --
354: --
355: -- Debug Statements

Line 358: WSH_DEBUG_SV.push(l_module_name);

354: --
355: -- Debug Statements
356: --
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.push(l_module_name);
359: --
360: WSH_DEBUG_SV.log(l_module_name,'P_CURSOR_ID',P_CURSOR_ID);
361: END IF;
362: --

Line 360: WSH_DEBUG_SV.log(l_module_name,'P_CURSOR_ID',P_CURSOR_ID);

356: --
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.push(l_module_name);
359: --
360: WSH_DEBUG_SV.log(l_module_name,'P_CURSOR_ID',P_CURSOR_ID);
361: END IF;
362: --
363: IF (p_bindvars.COUNT > 0) THEN
364:

Line 371: WSH_DEBUG_SV.logmsg(l_module_name,'bind var ' || p_bindvars(l_counter).bindvarindex || ' = ' || p_bindvars(l_counter).bindvar,WSH_DEBUG_SV.C_PROC_LEVEL);

367: --
368: -- Debug Statements
369: --
370: IF l_debug_on THEN
371: WSH_DEBUG_SV.logmsg(l_module_name,'bind var ' || p_bindvars(l_counter).bindvarindex || ' = ' || p_bindvars(l_counter).bindvar,WSH_DEBUG_SV.C_PROC_LEVEL);
372: END IF;
373:
374: IF (p_bindvars(l_counter).bindtype = 'NUMBER') THEN
375: dbms_sql.BIND_VARIABLE(p_cursor_id, ':' || p_bindvars(l_counter).bindvarindex, to_number(p_bindvars(l_counter).bindvar));

Line 392: WSH_DEBUG_SV.pop(l_module_name);

388: --
389: -- Debug Statements
390: --
391: IF l_debug_on THEN
392: WSH_DEBUG_SV.pop(l_module_name);
393: END IF;
394: --
395: END Bind_Vars;
396:

Line 439: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

435: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
436: --
437: IF l_debug_on IS NULL
438: THEN
439: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
440: END IF;
441: --
442: --
443: -- Debug Statements

Line 446: WSH_DEBUG_SV.push(l_module_name);

442: --
443: -- Debug Statements
444: --
445: IF l_debug_on THEN
446: WSH_DEBUG_SV.push(l_module_name);
447: --
448: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_LOC_ID',P_SHIP_FROM_LOC_ID);
449: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_SITE_ID',P_SHIP_TO_SITE_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',P_CARRIER_ID);

Line 448: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_LOC_ID',P_SHIP_FROM_LOC_ID);

444: --
445: IF l_debug_on THEN
446: WSH_DEBUG_SV.push(l_module_name);
447: --
448: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_LOC_ID',P_SHIP_FROM_LOC_ID);
449: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_SITE_ID',P_SHIP_TO_SITE_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',P_CARRIER_ID);
451: WSH_DEBUG_SV.log(l_module_name,'P_SERVICE_CODE',P_SERVICE_CODE);
452: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);

Line 449: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_SITE_ID',P_SHIP_TO_SITE_ID);

445: IF l_debug_on THEN
446: WSH_DEBUG_SV.push(l_module_name);
447: --
448: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_LOC_ID',P_SHIP_FROM_LOC_ID);
449: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_SITE_ID',P_SHIP_TO_SITE_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',P_CARRIER_ID);
451: WSH_DEBUG_SV.log(l_module_name,'P_SERVICE_CODE',P_SERVICE_CODE);
452: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);
453: END IF;

Line 450: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',P_CARRIER_ID);

446: WSH_DEBUG_SV.push(l_module_name);
447: --
448: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_LOC_ID',P_SHIP_FROM_LOC_ID);
449: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_SITE_ID',P_SHIP_TO_SITE_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',P_CARRIER_ID);
451: WSH_DEBUG_SV.log(l_module_name,'P_SERVICE_CODE',P_SERVICE_CODE);
452: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);
453: END IF;
454: --

Line 451: WSH_DEBUG_SV.log(l_module_name,'P_SERVICE_CODE',P_SERVICE_CODE);

447: --
448: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_LOC_ID',P_SHIP_FROM_LOC_ID);
449: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_SITE_ID',P_SHIP_TO_SITE_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',P_CARRIER_ID);
451: WSH_DEBUG_SV.log(l_module_name,'P_SERVICE_CODE',P_SERVICE_CODE);
452: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);
453: END IF;
454: --
455:

Line 452: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);

448: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_FROM_LOC_ID',P_SHIP_FROM_LOC_ID);
449: WSH_DEBUG_SV.log(l_module_name,'P_SHIP_TO_SITE_ID',P_SHIP_TO_SITE_ID);
450: WSH_DEBUG_SV.log(l_module_name,'P_CARRIER_ID',P_CARRIER_ID);
451: WSH_DEBUG_SV.log(l_module_name,'P_SERVICE_CODE',P_SERVICE_CODE);
452: WSH_DEBUG_SV.log(l_module_name,'P_MODE_CODE',P_MODE_CODE);
453: END IF;
454: --
455:
456: x_return_status := WSH_UTIL_CORE.g_ret_sts_success;

Line 470: WSH_DEBUG_SV.log(l_module_name,'Transit Time: ', x_transit_time);

466: x_transit_time=>x_transit_time,
467: x_return_status=>x_return_status);
468:
469: IF l_debug_on THEN
470: WSH_DEBUG_SV.log(l_module_name,'Transit Time: ', x_transit_time);
471: WSH_DEBUG_SV.log(l_module_name,'x_return_status', x_return_status);
472: END IF;
473: --
474: -- Debug Statements

Line 471: WSH_DEBUG_SV.log(l_module_name,'x_return_status', x_return_status);

467: x_return_status=>x_return_status);
468:
469: IF l_debug_on THEN
470: WSH_DEBUG_SV.log(l_module_name,'Transit Time: ', x_transit_time);
471: WSH_DEBUG_SV.log(l_module_name,'x_return_status', x_return_status);
472: END IF;
473: --
474: -- Debug Statements
475: --

Line 477: WSH_DEBUG_SV.pop(l_module_name);

473: --
474: -- Debug Statements
475: --
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.pop(l_module_name);
478: END IF;
479: --
480:
481: END Get_Transit_Time;

Line 529: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

525: --
526: x_return_message := WSH_UTIL_CORE.g_ret_sts_success;
527: IF l_debug_on IS NULL
528: THEN
529: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
530: END IF;
531: --
532: --
533: -- Debug Statements

Line 536: WSH_DEBUG_SV.push(l_module_name);

532: --
533: -- Debug Statements
534: --
535: IF l_debug_on THEN
536: WSH_DEBUG_SV.push(l_module_name);
537: --
538: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.COUNT',p_search_criteria.COUNT);
539: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);
540: END IF;

Line 538: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.COUNT',p_search_criteria.COUNT);

534: --
535: IF l_debug_on THEN
536: WSH_DEBUG_SV.push(l_module_name);
537: --
538: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.COUNT',p_search_criteria.COUNT);
539: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);
540: END IF;
541: --
542: x_lane_results:= fte_lane_tab();

Line 539: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);

535: IF l_debug_on THEN
536: WSH_DEBUG_SV.push(l_module_name);
537: --
538: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.COUNT',p_search_criteria.COUNT);
539: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);
540: END IF;
541: --
542: x_lane_results:= fte_lane_tab();
543: x_schedule_results := fte_schedule_tab();

Line 596: WSH_DEBUG_SV.log(l_module_name,'x_lane_results.COUNT',x_count);

592: i := p_search_criteria.NEXT(i);
593: END LOOP;
594: --
595: IF l_debug_on THEN
596: WSH_DEBUG_SV.log(l_module_name,'x_lane_results.COUNT',x_count);
597: WSH_DEBUG_SV.pop(l_module_name);
598: END IF;
599: --
600: EXCEPTION

Line 597: WSH_DEBUG_SV.pop(l_module_name);

593: END LOOP;
594: --
595: IF l_debug_on THEN
596: WSH_DEBUG_SV.log(l_module_name,'x_lane_results.COUNT',x_count);
597: WSH_DEBUG_SV.pop(l_module_name);
598: END IF;
599: --
600: EXCEPTION
601: WHEN OTHERS THEN

Line 605: WSH_DEBUG_SV.pop(l_module_name);

601: WHEN OTHERS THEN
602: x_return_message := g_message || 'Unexpected Error in Search_Lanes Package: ' || sqlerrm;
603: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
604: IF l_debug_on THEN
605: WSH_DEBUG_SV.pop(l_module_name);
606: END IF;
607:
608: END Search_Lanes;
609:

Line 792: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

788: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
789: --
790: IF l_debug_on IS NULL
791: THEN
792: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
793: END IF;
794: --
795: --
796: -- Debug Statements

Line 799: WSH_DEBUG_SV.push(l_module_name);

795: --
796: -- Debug Statements
797: --
798: IF l_debug_on THEN
799: WSH_DEBUG_SV.push(l_module_name);
800: --
801: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_TYPE',P_SEARCH_TYPE);
802: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
803: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);

Line 801: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_TYPE',P_SEARCH_TYPE);

797: --
798: IF l_debug_on THEN
799: WSH_DEBUG_SV.push(l_module_name);
800: --
801: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_TYPE',P_SEARCH_TYPE);
802: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
803: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);
804: END IF;
805: --

Line 802: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);

798: IF l_debug_on THEN
799: WSH_DEBUG_SV.push(l_module_name);
800: --
801: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_TYPE',P_SEARCH_TYPE);
802: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
803: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);
804: END IF;
805: --
806:

Line 803: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);

799: WSH_DEBUG_SV.push(l_module_name);
800: --
801: WSH_DEBUG_SV.log(l_module_name,'P_SEARCH_TYPE',P_SEARCH_TYPE);
802: WSH_DEBUG_SV.log(l_module_name,'P_SOURCE_TYPE',P_SOURCE_TYPE);
803: WSH_DEBUG_SV.log(l_module_name,'P_NUM_RESULTS',P_NUM_RESULTS);
804: END IF;
805: --
806:
807: -- get origin and parents set up

Line 830: WSH_DEBUG_SV.log(l_module_name,'Number of base origins', l_origins.count);

826: x_parent_regions => l_parent_dests);
827:
828:
829: IF l_debug_on THEN
830: WSH_DEBUG_SV.log(l_module_name,'Number of base origins', l_origins.count);
831: WSH_DEBUG_SV.log(l_module_name,'Number of base destinations',l_destinations.count);
832: WSH_DEBUG_SV.log(l_module_name,'Number of parent origins', l_parent_origins.count);
833: WSH_DEBUG_SV.log(l_module_name,'Number of parent dests',l_parent_dests.count);
834: END IF;

Line 831: WSH_DEBUG_SV.log(l_module_name,'Number of base destinations',l_destinations.count);

827:
828:
829: IF l_debug_on THEN
830: WSH_DEBUG_SV.log(l_module_name,'Number of base origins', l_origins.count);
831: WSH_DEBUG_SV.log(l_module_name,'Number of base destinations',l_destinations.count);
832: WSH_DEBUG_SV.log(l_module_name,'Number of parent origins', l_parent_origins.count);
833: WSH_DEBUG_SV.log(l_module_name,'Number of parent dests',l_parent_dests.count);
834: END IF;
835:

Line 832: WSH_DEBUG_SV.log(l_module_name,'Number of parent origins', l_parent_origins.count);

828:
829: IF l_debug_on THEN
830: WSH_DEBUG_SV.log(l_module_name,'Number of base origins', l_origins.count);
831: WSH_DEBUG_SV.log(l_module_name,'Number of base destinations',l_destinations.count);
832: WSH_DEBUG_SV.log(l_module_name,'Number of parent origins', l_parent_origins.count);
833: WSH_DEBUG_SV.log(l_module_name,'Number of parent dests',l_parent_dests.count);
834: END IF;
835:
836: --g_message := g_message || 'Number of base origins' || l_origins.count;

Line 833: WSH_DEBUG_SV.log(l_module_name,'Number of parent dests',l_parent_dests.count);

829: IF l_debug_on THEN
830: WSH_DEBUG_SV.log(l_module_name,'Number of base origins', l_origins.count);
831: WSH_DEBUG_SV.log(l_module_name,'Number of base destinations',l_destinations.count);
832: WSH_DEBUG_SV.log(l_module_name,'Number of parent origins', l_parent_origins.count);
833: WSH_DEBUG_SV.log(l_module_name,'Number of parent dests',l_parent_dests.count);
834: END IF;
835:
836: --g_message := g_message || 'Number of base origins' || l_origins.count;
837: --g_message := g_message || 'Number of base destinations' || l_destinations.count;

Line 851: WSH_DEBUG_SV.pop(l_module_name);

847:
848: x_return_message := x_return_message || 'No regions found for search criteria';
849:
850: IF l_debug_on THEN
851: WSH_DEBUG_SV.pop(l_module_name);
852: END IF;
853: --
854: RETURN;
855: END IF;

Line 942: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.relax_flag', p_search_criteria.relax_flag);

938: 'mm-dd-yyyy hh24:mi');
939: END IF;
940:
941: IF l_debug_on THEN
942: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.relax_flag', p_search_criteria.relax_flag);
943: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.origin_zip', p_search_criteria.origin_zip);
944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);
945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);

Line 943: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.origin_zip', p_search_criteria.origin_zip);

939: END IF;
940:
941: IF l_debug_on THEN
942: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.relax_flag', p_search_criteria.relax_flag);
943: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.origin_zip', p_search_criteria.origin_zip);
944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);
945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);

Line 944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);

940:
941: IF l_debug_on THEN
942: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.relax_flag', p_search_criteria.relax_flag);
943: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.origin_zip', p_search_criteria.origin_zip);
944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);
945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);

Line 945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);

941: IF l_debug_on THEN
942: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.relax_flag', p_search_criteria.relax_flag);
943: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.origin_zip', p_search_criteria.origin_zip);
944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);
945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);

Line 946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);

942: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.relax_flag', p_search_criteria.relax_flag);
943: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.origin_zip', p_search_criteria.origin_zip);
944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);
945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);

Line 947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);

943: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.origin_zip', p_search_criteria.origin_zip);
944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);
945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);

Line 948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);

944: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.destination_zip', p_search_criteria.destination_zip);
945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);

Line 949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);

945: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.mode_of_transport', p_search_criteria.mode_of_transport);
946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);

Line 950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);

946: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_number', p_search_criteria.lane_number);
947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);

Line 951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);

947: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_id', p_search_criteria.carrier_id);
948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);

Line 952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);

948: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.carrier_name', p_search_criteria.carrier_name);
949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);

Line 953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);

949: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity_catg_id', p_search_criteria.commodity_catg_id);
950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);

Line 954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);

950: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.commodity', p_search_criteria.commodity);
951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);

Line 955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);

951: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service_code', p_search_criteria.service_code);
952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);

Line 956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);

952: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.service', p_search_criteria.service);
953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');

Line 957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);

953: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment_code', p_search_criteria.equipment_code);
954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');
961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);

Line 958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);

954: --WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.equipment', p_search_criteria.equipment);
955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');
961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);
962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);

Line 959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);

955: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.schedule_only_flag', p_search_criteria.schedule_only_flag);
956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');
961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);
962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);
963: -- glami added for effective date

Line 960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');

956: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_from', p_search_criteria.dep_date_from);
957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');
961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);
962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);
963: -- glami added for effective date
964: WSH_DEBUG_SV.log(l_module_name,'Effective Date ', l_search_criteria.effective_date);

Line 961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);

957: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.dep_date_to', p_search_criteria.dep_date_to);
958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');
961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);
962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);
963: -- glami added for effective date
964: WSH_DEBUG_SV.log(l_module_name,'Effective Date ', l_search_criteria.effective_date);
965: WSH_DEBUG_SV.log(l_module_name,'Effective Date Type ', l_search_criteria.effective_date_type);

Line 962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);

958: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
959: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.arr_date_to', p_search_criteria.arr_date_to);
960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');
961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);
962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);
963: -- glami added for effective date
964: WSH_DEBUG_SV.log(l_module_name,'Effective Date ', l_search_criteria.effective_date);
965: WSH_DEBUG_SV.log(l_module_name,'Effective Date Type ', l_search_criteria.effective_date_type);
966: WSH_DEBUG_SV.log(l_module_name,'Tariff Name ', l_search_criteria.tariff_name);

Line 964: WSH_DEBUG_SV.log(l_module_name,'Effective Date ', l_search_criteria.effective_date);

960: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.lane_ids_string', substr(p_search_criteria.lane_ids_string, 0, 15) || '...');
961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);
962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);
963: -- glami added for effective date
964: WSH_DEBUG_SV.log(l_module_name,'Effective Date ', l_search_criteria.effective_date);
965: WSH_DEBUG_SV.log(l_module_name,'Effective Date Type ', l_search_criteria.effective_date_type);
966: WSH_DEBUG_SV.log(l_module_name,'Tariff Name ', l_search_criteria.tariff_name);
967: END IF;
968:

Line 965: WSH_DEBUG_SV.log(l_module_name,'Effective Date Type ', l_search_criteria.effective_date_type);

961: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.vehicle_id', p_search_criteria.vehicle_id);
962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);
963: -- glami added for effective date
964: WSH_DEBUG_SV.log(l_module_name,'Effective Date ', l_search_criteria.effective_date);
965: WSH_DEBUG_SV.log(l_module_name,'Effective Date Type ', l_search_criteria.effective_date_type);
966: WSH_DEBUG_SV.log(l_module_name,'Tariff Name ', l_search_criteria.tariff_name);
967: END IF;
968:
969: -- [11/11] Add query type for Lane Group and Commitment -> 'T'

Line 966: WSH_DEBUG_SV.log(l_module_name,'Tariff Name ', l_search_criteria.tariff_name);

962: WSH_DEBUG_SV.log(l_module_name,'New Vehicle ID ', l_search_criteria.vehicle_id);
963: -- glami added for effective date
964: WSH_DEBUG_SV.log(l_module_name,'Effective Date ', l_search_criteria.effective_date);
965: WSH_DEBUG_SV.log(l_module_name,'Effective Date Type ', l_search_criteria.effective_date_type);
966: WSH_DEBUG_SV.log(l_module_name,'Tariff Name ', l_search_criteria.tariff_name);
967: END IF;
968:
969: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
970: l_source_type := p_source_type;

Line 979: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_LANE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);

975: --
976: -- Debug Statements
977: --
978: IF l_debug_on THEN
979: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_LANE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);
980: END IF;
981: --
982: FTE_LANE_SEARCH_QUERY_GEN.Create_Lane_Query(p_search_criteria => l_search_criteria,
983: p_origins => l_origins,

Line 1001: WSH_DEBUG_SV.logmsg(l_module_name,'query:' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);

997: --
998: -- Debug Statements
999: --
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name,'query:' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);
1002: END IF;
1003:
1004: l_cursor_id := dbms_sql.OPEN_CURSOR;
1005: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);

Line 1137: WSH_DEBUG_SV.logmsg(l_module_name,'Seeking Transit Time');

1133: v_lane_service_id(n + l_offset) is not null AND
1134: NOT l_result_service_ids.EXISTS(v_lane_service_id(n + l_offset)))) THEN
1135:
1136: IF l_debug_on THEN
1137: WSH_DEBUG_SV.logmsg(l_module_name,'Seeking Transit Time');
1138: END IF;
1139:
1140: l_transit_time := null; -- v_transit_time(n + l_offset); -- this is what's on the lane
1141: l_transit_time_uom := 'DAY';

Line 1147: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_type:'||p_source_type );

1143: -- obtain transit time from ATP if transit time on lane is null
1144: -- convert transit time on lane to DAYS if necessary
1145:
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_type:'||p_source_type );
1148: WSH_DEBUG_SV.logmsg(l_module_name,'p_search_criteria.pickupstop_location_id :'||p_search_criteria.pickupstop_location_id );
1149: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.ship_to_site_id :'|| p_search_criteria.ship_to_site_id );
1150: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.dropoffstop_location_id:'|| p_search_criteria.dropoffstop_location_id );
1151: END IF;

Line 1148: WSH_DEBUG_SV.logmsg(l_module_name,'p_search_criteria.pickupstop_location_id :'||p_search_criteria.pickupstop_location_id );

1144: -- convert transit time on lane to DAYS if necessary
1145:
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_type:'||p_source_type );
1148: WSH_DEBUG_SV.logmsg(l_module_name,'p_search_criteria.pickupstop_location_id :'||p_search_criteria.pickupstop_location_id );
1149: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.ship_to_site_id :'|| p_search_criteria.ship_to_site_id );
1150: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.dropoffstop_location_id:'|| p_search_criteria.dropoffstop_location_id );
1151: END IF;
1152:

Line 1149: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.ship_to_site_id :'|| p_search_criteria.ship_to_site_id );

1145:
1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_type:'||p_source_type );
1148: WSH_DEBUG_SV.logmsg(l_module_name,'p_search_criteria.pickupstop_location_id :'||p_search_criteria.pickupstop_location_id );
1149: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.ship_to_site_id :'|| p_search_criteria.ship_to_site_id );
1150: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.dropoffstop_location_id:'|| p_search_criteria.dropoffstop_location_id );
1151: END IF;
1152:
1153: IF (p_source_type = 'R' AND

Line 1150: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.dropoffstop_location_id:'|| p_search_criteria.dropoffstop_location_id );

1146: IF l_debug_on THEN
1147: WSH_DEBUG_SV.logmsg(l_module_name,'p_source_type:'||p_source_type );
1148: WSH_DEBUG_SV.logmsg(l_module_name,'p_search_criteria.pickupstop_location_id :'||p_search_criteria.pickupstop_location_id );
1149: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.ship_to_site_id :'|| p_search_criteria.ship_to_site_id );
1150: WSH_DEBUG_SV.logmsg(l_module_name,' p_search_criteria.dropoffstop_location_id:'|| p_search_criteria.dropoffstop_location_id );
1151: END IF;
1152:
1153: IF (p_source_type = 'R' AND
1154: p_search_criteria.pickupstop_location_id is not null AND

Line 1159: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for OM:' );

1155: p_search_criteria.ship_to_site_id is not null) THEN
1156:
1157:
1158: IF l_debug_on THEN
1159: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for OM:' );
1160: END IF;
1161: Get_Transit_Time(p_ship_from_loc_id => p_search_criteria.pickupstop_location_id,
1162: p_ship_to_site_id => p_search_criteria.ship_to_site_id,
1163: p_carrier_id => v_carrier_id(n + l_offset),

Line 1174: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for Trips / deliveries' );

1170:
1171: ELSE IF (p_source_type = 'R' AND p_search_criteria.pickupstop_location_id is not null ) THEN
1172:
1173: IF l_debug_on THEN
1174: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for Trips / deliveries' );
1175: END IF;
1176: Get_Transit_Time(p_ship_from_loc_id => p_search_criteria.pickupstop_location_id,
1177: p_ship_to_site_id => p_search_criteria.dropoffstop_location_id,
1178: p_carrier_id => v_carrier_id(n + l_offset),

Line 1286: WSH_DEBUG_SV.logmsg(l_module_name,

1282:
1283: -- [08/30] Add check for Vehicle_id
1284: -- only if the Lane has TL as Mode of Transport
1285: IF (l_search_criteria.vehicle_id is not null AND v_mode_code(n + l_offset) ='TRUCK') THEN
1286: WSH_DEBUG_SV.logmsg(l_module_name,
1287: 'Check Vehicle Availability for Lane ' || v_lane_number(n + l_offset));
1288:
1289: IF( Is_Vehicle_Available(p_vehicle_id => l_search_criteria.vehicle_id,
1290: p_carrier_id => v_carrier_id(n + l_offset),

Line 1310: WSH_DEBUG_SV.logmsg(l_module_name, x_return_message);

1306: END IF;
1307: ELSE
1308: l_vehicles_discarded := l_vehicles_discarded || v_lane_id(n+l_offset) || ', ';
1309:
1310: WSH_DEBUG_SV.logmsg(l_module_name, x_return_message);
1311: WSH_DEBUG_SV.logmsg(l_module_name, 'Vehicle unavailable for lane ' || v_lane_number(n+l_offset));
1312:
1313: END IF;
1314: ELSE

Line 1311: WSH_DEBUG_SV.logmsg(l_module_name, 'Vehicle unavailable for lane ' || v_lane_number(n+l_offset));

1307: ELSE
1308: l_vehicles_discarded := l_vehicles_discarded || v_lane_id(n+l_offset) || ', ';
1309:
1310: WSH_DEBUG_SV.logmsg(l_module_name, x_return_message);
1311: WSH_DEBUG_SV.logmsg(l_module_name, 'Vehicle unavailable for lane ' || v_lane_number(n+l_offset));
1312:
1313: END IF;
1314: ELSE
1315: --g_message := g_message || ' Not TL or vehicle null ' || v_lane_id(n + l_offset);

Line 1323: WSH_DEBUG_SV.logmsg(l_module_name,'Point 1.1',WSH_DEBUG_SV.C_PROC_LEVEL);

1319: l_result_lane_ids(v_lane_id(n + l_offset)) := v_lane_id(n + l_offset);
1320:
1321: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1322: IF (p_source_type <>'T' and v_lane_service_id(n + l_offset) is not null ) THEN
1323: WSH_DEBUG_SV.logmsg(l_module_name,'Point 1.1',WSH_DEBUG_SV.C_PROC_LEVEL);
1324: l_result_service_ids(v_lane_service_id(n + l_offset)) := v_lane_service_id(n + l_offset);
1325: END IF;
1326:
1327: END IF;

Line 1362: WSH_DEBUG_SV.logmsg(l_module_name,'query2:' || l_query2,WSH_DEBUG_SV.C_PROC_LEVEL);

1358: --
1359: -- Debug Statements
1360: --
1361: IF l_debug_on THEN
1362: WSH_DEBUG_SV.logmsg(l_module_name,'query2:' || l_query2,WSH_DEBUG_SV.C_PROC_LEVEL);
1363: END IF;
1364:
1365: dbms_sql.PARSE(l_cursor_id, l_query2, DBMS_SQL.V7);
1366:

Line 1369: WSH_DEBUG_SV.logmsg(l_module_name,'Query^^^^^^^^ :'||l_query2 );

1365: dbms_sql.PARSE(l_cursor_id, l_query2, DBMS_SQL.V7);
1366:
1367: Bind_Vars(l_cursor_id, l_bindvars2);
1368: Bind_Vars(l_cursor_id, l_bindvars3);
1369: WSH_DEBUG_SV.logmsg(l_module_name,'Query^^^^^^^^ :'||l_query2 );
1370: -- [11/11] Add query type for Lane Group and Commitment -> 'T'
1371: if (p_source_type ='T') THEN
1372:
1373: dbms_sql.DEFINE_ARRAY(l_cursor_id, 1, v_party_name, p_num_results, 1);

Line 1508: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for OM:' );

1504: p_search_criteria.pickupstop_location_id is not null AND
1505: p_search_criteria.ship_to_site_id is not null) THEN
1506:
1507: IF l_debug_on THEN
1508: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for OM:' );
1509: END IF;
1510:
1511: Get_Transit_Time(p_ship_from_loc_id => p_search_criteria.pickupstop_location_id,
1512: p_ship_to_site_id => p_search_criteria.ship_to_site_id,

Line 1524: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for Trips / deliveries' );

1520:
1521: ELSE IF (p_source_type = 'R' AND p_search_criteria.pickupstop_location_id is not null ) THEN
1522:
1523: IF l_debug_on THEN
1524: WSH_DEBUG_SV.logmsg(l_module_name,'Get_Transit_Time for Trips / deliveries' );
1525: END IF;
1526:
1527: Get_Transit_Time(p_ship_from_loc_id => p_search_criteria.pickupstop_location_id,
1528: p_ship_to_site_id => p_search_criteria.dropoffstop_location_id,

Line 1629: WSH_DEBUG_SV.logmsg(l_module_name,

1625: end if;
1626:
1627: IF (l_search_criteria.vehicle_id is not null AND v_mode_code(n + l_offset) ='TRUCK') THEN
1628:
1629: WSH_DEBUG_SV.logmsg(l_module_name,
1630: 'Check Vehicle Availability for Lane ' || v_lane_number(n + l_offset));
1631:
1632: IF( Is_Vehicle_Available(p_vehicle_id => l_search_criteria.vehicle_id,
1633: p_carrier_id => v_carrier_id(n + l_offset),

Line 1653: WSH_DEBUG_SV.logmsg(l_module_name, 'Vehicle unavailable for lane ' || v_lane_number(n+l_offset));

1649: END IF;
1650: ELSE
1651: l_vehicles_discarded := l_vehicles_discarded || v_lane_id(n+l_offset) || ',';
1652:
1653: WSH_DEBUG_SV.logmsg(l_module_name, 'Vehicle unavailable for lane ' || v_lane_number(n+l_offset));
1654: WSH_DEBUG_SV.logmsg(l_module_name, x_return_message);
1655: END IF;
1656:
1657: ELSE

Line 1654: WSH_DEBUG_SV.logmsg(l_module_name, x_return_message);

1650: ELSE
1651: l_vehicles_discarded := l_vehicles_discarded || v_lane_id(n+l_offset) || ',';
1652:
1653: WSH_DEBUG_SV.logmsg(l_module_name, 'Vehicle unavailable for lane ' || v_lane_number(n+l_offset));
1654: WSH_DEBUG_SV.logmsg(l_module_name, x_return_message);
1655: END IF;
1656:
1657: ELSE
1658: --g_message := g_message || '; Not a TL ' || v_lane_id(n + l_offset);

Line 1693: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_SCHEDULE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);

1689: --
1690: -- Debug Statements
1691: --
1692: IF l_debug_on THEN
1693: WSH_DEBUG_SV.logmsg(l_module_name,'Calling FTE_LANE_SEARCH_QUERY_GEN.CREATE_SCHEDULE_QUERY',WSH_DEBUG_SV.C_PROC_LEVEL);
1694: END IF;
1695: --
1696: FTE_LANE_SEARCH_QUERY_GEN.Create_Schedule_Query(p_search_criteria => l_search_criteria,
1697: p_origins => l_origins,

Line 1710: WSH_DEBUG_SV.logmsg(l_module_name,'schedule query: ' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);

1706: --
1707: -- Debug Statements
1708: --
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'schedule query: ' || l_query1,WSH_DEBUG_SV.C_PROC_LEVEL);
1711: END IF;
1712:
1713: l_cursor_id := dbms_sql.OPEN_CURSOR;
1714: dbms_sql.PARSE(l_cursor_id, l_query1, DBMS_SQL.V7);

Line 1846: WSH_DEBUG_SV.logmsg(l_module_name,'lanes obtained = ' || l_lanes_tab.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);

1842: --
1843: -- Debug Statements
1844: --
1845: IF (l_debug_on AND p_search_type = 'L') THEN
1846: WSH_DEBUG_SV.logmsg(l_module_name,'lanes obtained = ' || l_lanes_tab.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
1847: WSH_DEBUG_SV.logmsg(l_module_name,'lane ids returned: ',WSH_DEBUG_SV.C_PROC_LEVEL);
1848:
1849: IF (l_lanes_tab.count > 0) THEN
1850: FOR k IN l_lanes_tab.FIRST..l_lanes_tab.LAST LOOP

Line 1847: WSH_DEBUG_SV.logmsg(l_module_name,'lane ids returned: ',WSH_DEBUG_SV.C_PROC_LEVEL);

1843: -- Debug Statements
1844: --
1845: IF (l_debug_on AND p_search_type = 'L') THEN
1846: WSH_DEBUG_SV.logmsg(l_module_name,'lanes obtained = ' || l_lanes_tab.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
1847: WSH_DEBUG_SV.logmsg(l_module_name,'lane ids returned: ',WSH_DEBUG_SV.C_PROC_LEVEL);
1848:
1849: IF (l_lanes_tab.count > 0) THEN
1850: FOR k IN l_lanes_tab.FIRST..l_lanes_tab.LAST LOOP
1851: WSH_DEBUG_SV.logmsg(l_module_name,l_lanes_tab(k).lane_id,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1851: WSH_DEBUG_SV.logmsg(l_module_name,l_lanes_tab(k).lane_id,WSH_DEBUG_SV.C_PROC_LEVEL);

1847: WSH_DEBUG_SV.logmsg(l_module_name,'lane ids returned: ',WSH_DEBUG_SV.C_PROC_LEVEL);
1848:
1849: IF (l_lanes_tab.count > 0) THEN
1850: FOR k IN l_lanes_tab.FIRST..l_lanes_tab.LAST LOOP
1851: WSH_DEBUG_SV.logmsg(l_module_name,l_lanes_tab(k).lane_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1852: WSH_DEBUG_SV.logmsg(l_module_name,l_lanes_tab(k).tariff_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1853: END LOOP;
1854: END IF;
1855: END IF;

Line 1852: WSH_DEBUG_SV.logmsg(l_module_name,l_lanes_tab(k).tariff_name,WSH_DEBUG_SV.C_PROC_LEVEL);

1848:
1849: IF (l_lanes_tab.count > 0) THEN
1850: FOR k IN l_lanes_tab.FIRST..l_lanes_tab.LAST LOOP
1851: WSH_DEBUG_SV.logmsg(l_module_name,l_lanes_tab(k).lane_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1852: WSH_DEBUG_SV.logmsg(l_module_name,l_lanes_tab(k).tariff_name,WSH_DEBUG_SV.C_PROC_LEVEL);
1853: END LOOP;
1854: END IF;
1855: END IF;
1856:

Line 1873: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery Leg Lane Search. Performing constraints checking',WSH_DEBUG_SV.C_PROC_LEVEL);

1869: --
1870: -- Debug Statements
1871: --
1872: IF l_debug_on THEN
1873: WSH_DEBUG_SV.logmsg(l_module_name,'Delivery Leg Lane Search. Performing constraints checking',WSH_DEBUG_SV.C_PROC_LEVEL);
1874: END IF;
1875: --
1876:
1877: -- setup delivery record for constraints check

Line 1921: WSH_DEBUG_SV.logmsg(l_module_name,'After calling WSH_FTE_COMP_CONSTRAINT_ENGINE.validate_constraint_dleg. Messages:',WSH_DEBUG_SV.C_PROC_LEVEL);

1917: --
1918: -- Debug Statements
1919: --
1920: IF l_debug_on THEN
1921: WSH_DEBUG_SV.logmsg(l_module_name,'After calling WSH_FTE_COMP_CONSTRAINT_ENGINE.validate_constraint_dleg. Messages:',WSH_DEBUG_SV.C_PROC_LEVEL);
1922: IF (l_msg_count > 1) THEN
1923: FOR m IN 1..l_msg_count LOOP
1924: l_msg_data := FND_MSG_PUB.GET(m, 'T');
1925: WSH_DEBUG_SV.logmsg(l_module_name,l_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1925: WSH_DEBUG_SV.logmsg(l_module_name,l_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);

1921: WSH_DEBUG_SV.logmsg(l_module_name,'After calling WSH_FTE_COMP_CONSTRAINT_ENGINE.validate_constraint_dleg. Messages:',WSH_DEBUG_SV.C_PROC_LEVEL);
1922: IF (l_msg_count > 1) THEN
1923: FOR m IN 1..l_msg_count LOOP
1924: l_msg_data := FND_MSG_PUB.GET(m, 'T');
1925: WSH_DEBUG_SV.logmsg(l_module_name,l_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
1926: END LOOP;
1927: ELSE
1928: WSH_DEBUG_SV.logmsg(l_module_name,l_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
1929: END IF;

Line 1928: WSH_DEBUG_SV.logmsg(l_module_name,l_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);

1924: l_msg_data := FND_MSG_PUB.GET(m, 'T');
1925: WSH_DEBUG_SV.logmsg(l_module_name,l_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
1926: END LOOP;
1927: ELSE
1928: WSH_DEBUG_SV.logmsg(l_module_name,l_msg_data,WSH_DEBUG_SV.C_PROC_LEVEL);
1929: END IF;
1930:
1931: END IF;
1932: --

Line 1938: WSH_DEBUG_SV.logmsg(l_module_name,'validate result = ' || l_validate_result,WSH_DEBUG_SV.C_PROC_LEVEL);

1934: --
1935: -- Debug Statements
1936: --
1937: IF l_debug_on THEN
1938: WSH_DEBUG_SV.logmsg(l_module_name,'validate result = ' || l_validate_result,WSH_DEBUG_SV.C_PROC_LEVEL);
1939: WSH_DEBUG_SV.logmsg(l_module_name,'lane ids returned by constraints ' || l_success_lanes.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
1940: END IF;
1941:
1942: -- loop thru l_lanes_tab and for each lane_id, check to see if in l_success_lanes

Line 1939: WSH_DEBUG_SV.logmsg(l_module_name,'lane ids returned by constraints ' || l_success_lanes.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);

1935: -- Debug Statements
1936: --
1937: IF l_debug_on THEN
1938: WSH_DEBUG_SV.logmsg(l_module_name,'validate result = ' || l_validate_result,WSH_DEBUG_SV.C_PROC_LEVEL);
1939: WSH_DEBUG_SV.logmsg(l_module_name,'lane ids returned by constraints ' || l_success_lanes.COUNT,WSH_DEBUG_SV.C_PROC_LEVEL);
1940: END IF;
1941:
1942: -- loop thru l_lanes_tab and for each lane_id, check to see if in l_success_lanes
1943: -- if not in there, then delete from l_lanes_tab

Line 1964: WSH_DEBUG_SV.logmsg(l_module_name,'removing lane ' || l_lanes_tab(k).lane_id,WSH_DEBUG_SV.C_PROC_LEVEL);

1960: --
1961: -- Debug Statements
1962: --
1963: IF l_debug_on THEN
1964: WSH_DEBUG_SV.logmsg(l_module_name,'removing lane ' || l_lanes_tab(k).lane_id,WSH_DEBUG_SV.C_PROC_LEVEL);
1965: END IF;
1966:
1967: l_lanes_tab.DELETE(k);
1968:

Line 1980: WSH_DEBUG_SV.logmsg(l_module_name,'Supplier manages freight. Skipping constraints checking.', WSH_DEBUG_SV.C_PROC_LEVEL);

1976: --
1977: -- Debug Statements
1978: --
1979: IF l_debug_on THEN
1980: WSH_DEBUG_SV.logmsg(l_module_name,'Supplier manages freight. Skipping constraints checking.', WSH_DEBUG_SV.C_PROC_LEVEL);
1981: END IF;
1982: --
1983:
1984: END IF; -- end if <> supplier managing freight

Line 2002: WSH_DEBUG_SV.pop(l_module_name);

1998: --
1999: -- Debug Statements
2000: --
2001: IF l_debug_on THEN
2002: WSH_DEBUG_SV.pop(l_module_name);
2003: END IF;
2004: --
2005: EXCEPTION
2006: WHEN OTHERS THEN

Line 2060: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2056: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2057: --
2058: IF l_debug_on IS NULL
2059: THEN
2060: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2061: END IF;
2062: --
2063: --
2064: -- Debug Statements

Line 2067: WSH_DEBUG_SV.push(l_module_name);

2063: --
2064: -- Debug Statements
2065: --
2066: IF l_debug_on THEN
2067: WSH_DEBUG_SV.push(l_module_name);
2068: --
2069: END IF;
2070: --
2071:

Line 2077: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.tariff_name', p_search_criteria.tariff_name);

2073:
2074: -- get carrier name
2075: l_carrier_name := p_search_criteria.carrier_name;
2076: l_tariff_name := p_search_criteria.tariff_name;
2077: WSH_DEBUG_SV.log(l_module_name,'p_search_criteria.tariff_name', p_search_criteria.tariff_name);
2078: -- get origin and parents set up
2079: l_origin_zip := p_search_criteria.origin_zip;
2080: Set_Up_Regions(p_search_criteria.origin_loc_id,
2081: p_search_criteria.origin_country,

Line 2121: WSH_DEBUG_SV.logmsg(l_module_name,'rate chart query:' || l_query,WSH_DEBUG_SV.C_PROC_LEVEL);

2117: --
2118: -- Debug Statements
2119: --
2120: IF l_debug_on THEN
2121: WSH_DEBUG_SV.logmsg(l_module_name,'rate chart query:' || l_query,WSH_DEBUG_SV.C_PROC_LEVEL);
2122: END IF;
2123:
2124:
2125: l_cursor_id := dbms_sql.OPEN_CURSOR;

Line 2159: WSH_DEBUG_SV.pop(l_module_name);

2155: --
2156: -- Debug Statements
2157: --
2158: IF l_debug_on THEN
2159: WSH_DEBUG_SV.pop(l_module_name);
2160: END IF;
2161: --
2162: END Get_Rate_Chart_Ids;
2163: