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.WSH_TRIP_CONSOLIDATION dependencies on WSH_DEBUG_SV

Line 21: l_debugOn := wsh_debug_sv.is_debug_enabled;

17: --
18: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
19: --
20: IF l_debugOn IS NULL THEN
21: l_debugOn := wsh_debug_sv.is_debug_enabled;
22: END IF;
23: --
24: IF l_debugOn THEN
25: wsh_debug_sv.push(l_moduleName);

Line 25: wsh_debug_sv.push(l_moduleName);

21: l_debugOn := wsh_debug_sv.is_debug_enabled;
22: END IF;
23: --
24: IF l_debugOn THEN
25: wsh_debug_sv.push(l_moduleName);
26: wsh_debug_sv.log(l_moduleName, 'p_IndexTab.COUNT', p_IndexTab.COUNT);
27: wsh_debug_sv.log(l_moduleName, 'p_DeliveryTab.COUNT', p_DeliveryTab.COUNT);
28: END IF;
29: --

Line 26: wsh_debug_sv.log(l_moduleName, 'p_IndexTab.COUNT', p_IndexTab.COUNT);

22: END IF;
23: --
24: IF l_debugOn THEN
25: wsh_debug_sv.push(l_moduleName);
26: wsh_debug_sv.log(l_moduleName, 'p_IndexTab.COUNT', p_IndexTab.COUNT);
27: wsh_debug_sv.log(l_moduleName, 'p_DeliveryTab.COUNT', p_DeliveryTab.COUNT);
28: END IF;
29: --
30: FOR j IN p_IndexTab.FIRST..p_IndexTab.LAST LOOP

Line 27: wsh_debug_sv.log(l_moduleName, 'p_DeliveryTab.COUNT', p_DeliveryTab.COUNT);

23: --
24: IF l_debugOn THEN
25: wsh_debug_sv.push(l_moduleName);
26: wsh_debug_sv.log(l_moduleName, 'p_IndexTab.COUNT', p_IndexTab.COUNT);
27: wsh_debug_sv.log(l_moduleName, 'p_DeliveryTab.COUNT', p_DeliveryTab.COUNT);
28: END IF;
29: --
30: FOR j IN p_IndexTab.FIRST..p_IndexTab.LAST LOOP
31: --

Line 33: wsh_debug_sv.log(l_moduleName, 'Index', p_IndexTab(j));

29: --
30: FOR j IN p_IndexTab.FIRST..p_IndexTab.LAST LOOP
31: --
32: IF l_debugOn THEN
33: wsh_debug_sv.log(l_moduleName, 'Index', p_IndexTab(j));
34: wsh_Debug_sv.log(l_moduleName, 'Delivery at this Index',
35: p_deliveryTab(p_IndexTab(j)).delivery_id);
36: END IF;
37: --

Line 34: wsh_Debug_sv.log(l_moduleName, 'Delivery at this Index',

30: FOR j IN p_IndexTab.FIRST..p_IndexTab.LAST LOOP
31: --
32: IF l_debugOn THEN
33: wsh_debug_sv.log(l_moduleName, 'Index', p_IndexTab(j));
34: wsh_Debug_sv.log(l_moduleName, 'Delivery at this Index',
35: p_deliveryTab(p_IndexTab(j)).delivery_id);
36: END IF;
37: --
38: x_DeliveryTab(x_DeliveryTab.COUNT+1) := p_DeliveryTab(p_IndexTab(j));

Line 43: wsh_debug_sv.log(l_moduleName, 'x_DeliveryTab.COUNT', x_DeliveryTab.COUNT);

39: --
40: END LOOP;
41: --
42: IF l_debugOn THEN
43: wsh_debug_sv.log(l_moduleName, 'x_DeliveryTab.COUNT', x_DeliveryTab.COUNT);
44: wsh_debug_sv.pop(l_moduleName);
45: END IF;
46: --
47: EXCEPTION

Line 44: wsh_debug_sv.pop(l_moduleName);

40: END LOOP;
41: --
42: IF l_debugOn THEN
43: wsh_debug_sv.log(l_moduleName, 'x_DeliveryTab.COUNT', x_DeliveryTab.COUNT);
44: wsh_debug_sv.pop(l_moduleName);
45: END IF;
46: --
47: EXCEPTION
48: --

Line 54: wsh_debug_sv.log(l_moduleName, 'Unexpected error',

50: --
51: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDeliveryTable');
52: --
53: IF l_debugOn THEN
54: wsh_debug_sv.log(l_moduleName, 'Unexpected error',
55: SUBSTRB(SQLERRM, 1, 200));
56: wsh_debug_sv.pop(l_moduleName);
57: END IF;
58: --

Line 56: wsh_debug_sv.pop(l_moduleName);

52: --
53: IF l_debugOn THEN
54: wsh_debug_sv.log(l_moduleName, 'Unexpected error',
55: SUBSTRB(SQLERRM, 1, 200));
56: wsh_debug_sv.pop(l_moduleName);
57: END IF;
58: --
59: RAISE;
60: --

Line 110: l_debugOn := wsh_debug_sv.is_debug_enabled;

106: --
107: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
108: --
109: IF l_debugOn IS NULL THEN
110: l_debugOn := wsh_debug_sv.is_debug_enabled;
111: END IF;
112: --
113: IF l_debugOn THEN
114: wsh_debug_sv.push(l_moduleName);

Line 114: wsh_debug_sv.push(l_moduleName);

110: l_debugOn := wsh_debug_sv.is_debug_enabled;
111: END IF;
112: --
113: IF l_debugOn THEN
114: wsh_debug_sv.push(l_moduleName);
115: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_from', p_grp_ship_from);
116: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_method', p_grp_ship_method);
117: wsh_debug_sv.log(l_moduleName, 'p_max_num_deliveries', p_max_num_deliveries);
118: END IF;

Line 115: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_from', p_grp_ship_from);

111: END IF;
112: --
113: IF l_debugOn THEN
114: wsh_debug_sv.push(l_moduleName);
115: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_from', p_grp_ship_from);
116: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_method', p_grp_ship_method);
117: wsh_debug_sv.log(l_moduleName, 'p_max_num_deliveries', p_max_num_deliveries);
118: END IF;
119: --

Line 116: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_method', p_grp_ship_method);

112: --
113: IF l_debugOn THEN
114: wsh_debug_sv.push(l_moduleName);
115: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_from', p_grp_ship_from);
116: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_method', p_grp_ship_method);
117: wsh_debug_sv.log(l_moduleName, 'p_max_num_deliveries', p_max_num_deliveries);
118: END IF;
119: --
120: BuildQuery(

Line 117: wsh_debug_sv.log(l_moduleName, 'p_max_num_deliveries', p_max_num_deliveries);

113: IF l_debugOn THEN
114: wsh_debug_sv.push(l_moduleName);
115: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_from', p_grp_ship_from);
116: wsh_debug_sv.log(l_moduleName, 'p_grp_ship_method', p_grp_ship_method);
117: wsh_debug_sv.log(l_moduleName, 'p_max_num_deliveries', p_max_num_deliveries);
118: END IF;
119: --
120: BuildQuery(
121: p_deliv_status => p_deliv_status,

Line 134: wsh_debug_sv.logmsg(l_moduleName, 'After build query');

130: x_Query => v_Query,
131: x_return_status => v_RetSts);
132: --
133: IF l_debugOn THEN
134: wsh_debug_sv.logmsg(l_moduleName, 'After build query');
135: END IF;
136: --
137: wsh_util_core.api_post_call(
138: p_return_status => v_RetSts,

Line 169: wsh_debug_sv.log(l_moduleName, 'Total number of deliveries selected', v_DelivTab.COUNT);

165: --}
166: END LOOP;
167: --
168: IF l_debugOn THEN
169: wsh_debug_sv.log(l_moduleName, 'Total number of deliveries selected', v_DelivTab.COUNT);
170: wsh_debug_sv.log(l_moduleName, 'Total number of unique hash values', v_HashTab.COUNT);
171: END IF;
172: --
173: i := v_HashTab.FIRST;

Line 170: wsh_debug_sv.log(l_moduleName, 'Total number of unique hash values', v_HashTab.COUNT);

166: END LOOP;
167: --
168: IF l_debugOn THEN
169: wsh_debug_sv.log(l_moduleName, 'Total number of deliveries selected', v_DelivTab.COUNT);
170: wsh_debug_sv.log(l_moduleName, 'Total number of unique hash values', v_HashTab.COUNT);
171: END IF;
172: --
173: i := v_HashTab.FIRST;
174: WHILE i IS NOT NULL LOOP

Line 177: wsh_debug_sv.logmsg(l_moduleName, '=========================================================');

173: i := v_HashTab.FIRST;
174: WHILE i IS NOT NULL LOOP
175: --{
176: IF l_debugOn THEN
177: wsh_debug_sv.logmsg(l_moduleName, '=========================================================');
178: wsh_debug_sv.log(l_moduleName, 'v_HashTab(' || i || ').hashString', v_HashTab(i).hashString);
179: END IF;
180: --
181: l_DelTab.DELETE;

Line 178: wsh_debug_sv.log(l_moduleName, 'v_HashTab(' || i || ').hashString', v_HashTab(i).hashString);

174: WHILE i IS NOT NULL LOOP
175: --{
176: IF l_debugOn THEN
177: wsh_debug_sv.logmsg(l_moduleName, '=========================================================');
178: wsh_debug_sv.log(l_moduleName, 'v_HashTab(' || i || ').hashString', v_HashTab(i).hashString);
179: END IF;
180: --
181: l_DelTab.DELETE;
182: --

Line 201: wsh_debug_sv.log(l_moduleName, 'number of deliveries in this batch', l_DelTab.COUNT);

197: --}
198: END LOOP;
199: --
200: IF l_debugOn THEN
201: wsh_debug_sv.log(l_moduleName, 'number of deliveries in this batch', l_DelTab.COUNT);
202: END IF;
203: --
204: IF l_DelTab.COUNT > 0 THEN
205: --{

Line 235: wsh_debug_sv.logmsg(l_moduleName, 'Delivery_Action - warning');

231: --
232: IF v_RetSts = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
233: --{
234: IF l_debugOn THEN
235: wsh_debug_sv.logmsg(l_moduleName, 'Delivery_Action - warning');
236: wsh_debug_sv.log(l_moduleName, 'l_deliv_out_rec.valid_ids_tab.COUNT',
237: l_deliv_out_rec.valid_ids_tab.COUNT);
238: END IF;
239: --

Line 236: wsh_debug_sv.log(l_moduleName, 'l_deliv_out_rec.valid_ids_tab.COUNT',

232: IF v_RetSts = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
233: --{
234: IF l_debugOn THEN
235: wsh_debug_sv.logmsg(l_moduleName, 'Delivery_Action - warning');
236: wsh_debug_sv.log(l_moduleName, 'l_deliv_out_rec.valid_ids_tab.COUNT',
237: l_deliv_out_rec.valid_ids_tab.COUNT);
238: END IF;
239: --
240: IF l_deliv_out_rec.valid_ids_tab.COUNT > 0 AND

Line 250: wsh_debug_sv.log(l_moduleName, 'l_deliveryTab.COUNT',

246: x_DeliveryTab => l_DeliveryTab);
247: l_action_prms.phase := 2;
248: --
249: IF l_debugOn THEN
250: wsh_debug_sv.log(l_moduleName, 'l_deliveryTab.COUNT',
251: l_deliveryTab.COUNT);
252: wsh_debug_sv.logmsg(l_moduleName, 'Second call to Delivery_Action');
253: --
254: END IF;

Line 252: wsh_debug_sv.logmsg(l_moduleName, 'Second call to Delivery_Action');

248: --
249: IF l_debugOn THEN
250: wsh_debug_sv.log(l_moduleName, 'l_deliveryTab.COUNT',
251: l_deliveryTab.COUNT);
252: wsh_debug_sv.logmsg(l_moduleName, 'Second call to Delivery_Action');
253: --
254: END IF;
255: --
256: WSH_DELIVERIES_GRP.Delivery_Action

Line 295: wsh_debug_sv.logmsg(l_moduleName, 'No deliveries selected for this hashValue');

291: --}
292: ELSE
293: --
294: IF l_debugOn THEN
295: wsh_debug_sv.logmsg(l_moduleName, 'No deliveries selected for this hashValue');
296: END IF;
297: --
298: END IF;
299: --

Line 317: wsh_Debug_sv.log(l_moduleName, 'Total deliveries', NVL(x_TotDeliveries, 0));

313: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
314: END IF;
315: --
316: IF l_debugOn THEN
317: wsh_Debug_sv.log(l_moduleName, 'Total deliveries', NVL(x_TotDeliveries, 0));
318: wsh_debug_Sv.log(l_moduleName, 'number of Successful deliveries', NVL(x_SuccessDeliv, 0));
319: wsh_debug_sv.log(l_moduleName, 'number of Trips', NVL(x_Trips, 0));
320: wsh_debug_sv.log(l_moduleName, 'Return Status', x_return_status);
321: wsh_debug_sv.pop(l_moduleName);

Line 318: wsh_debug_Sv.log(l_moduleName, 'number of Successful deliveries', NVL(x_SuccessDeliv, 0));

314: END IF;
315: --
316: IF l_debugOn THEN
317: wsh_Debug_sv.log(l_moduleName, 'Total deliveries', NVL(x_TotDeliveries, 0));
318: wsh_debug_Sv.log(l_moduleName, 'number of Successful deliveries', NVL(x_SuccessDeliv, 0));
319: wsh_debug_sv.log(l_moduleName, 'number of Trips', NVL(x_Trips, 0));
320: wsh_debug_sv.log(l_moduleName, 'Return Status', x_return_status);
321: wsh_debug_sv.pop(l_moduleName);
322: END IF;

Line 319: wsh_debug_sv.log(l_moduleName, 'number of Trips', NVL(x_Trips, 0));

315: --
316: IF l_debugOn THEN
317: wsh_Debug_sv.log(l_moduleName, 'Total deliveries', NVL(x_TotDeliveries, 0));
318: wsh_debug_Sv.log(l_moduleName, 'number of Successful deliveries', NVL(x_SuccessDeliv, 0));
319: wsh_debug_sv.log(l_moduleName, 'number of Trips', NVL(x_Trips, 0));
320: wsh_debug_sv.log(l_moduleName, 'Return Status', x_return_status);
321: wsh_debug_sv.pop(l_moduleName);
322: END IF;
323: --

Line 320: wsh_debug_sv.log(l_moduleName, 'Return Status', x_return_status);

316: IF l_debugOn THEN
317: wsh_Debug_sv.log(l_moduleName, 'Total deliveries', NVL(x_TotDeliveries, 0));
318: wsh_debug_Sv.log(l_moduleName, 'number of Successful deliveries', NVL(x_SuccessDeliv, 0));
319: wsh_debug_sv.log(l_moduleName, 'number of Trips', NVL(x_Trips, 0));
320: wsh_debug_sv.log(l_moduleName, 'Return Status', x_return_status);
321: wsh_debug_sv.pop(l_moduleName);
322: END IF;
323: --
324: EXCEPTION

Line 321: wsh_debug_sv.pop(l_moduleName);

317: wsh_Debug_sv.log(l_moduleName, 'Total deliveries', NVL(x_TotDeliveries, 0));
318: wsh_debug_Sv.log(l_moduleName, 'number of Successful deliveries', NVL(x_SuccessDeliv, 0));
319: wsh_debug_sv.log(l_moduleName, 'number of Trips', NVL(x_Trips, 0));
320: wsh_debug_sv.log(l_moduleName, 'Return Status', x_return_status);
321: wsh_debug_sv.pop(l_moduleName);
322: END IF;
323: --
324: EXCEPTION
325: --

Line 341: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');

337: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
338: END IF;
339: --
340: IF l_debugOn THEN
341: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');
342: END IF;
343: --
344: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
345: --

Line 359: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXP_ERROR');

355: x_return_status := WSH_UTIL_CORE.g_RET_STS_WARNING;
356: END IF;
357: --
358: IF l_debugOn THEN
359: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXP_ERROR');
360: END IF;
361: --
362: WHEN OTHERS THEN
363: --

Line 379: wsh_debug_sv.pop(l_moduleName || ' - Unknown error - ' || SQLERRM);

375: --
376: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
377: --
378: IF l_debugOn THEN
379: wsh_debug_sv.pop(l_moduleName || ' - Unknown error - ' || SQLERRM);
380: END IF;
381: --
382: RAISE;
383: --

Line 416: l_debugOn := wsh_debug_sv.is_debug_enabled;

412: --
413: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
414: --
415: IF l_debugOn IS NULL THEN
416: l_debugOn := wsh_debug_sv.is_debug_enabled;
417: END IF;
418: --
419: IF l_debugOn THEN
420: wsh_debug_sv.push(l_moduleName);

Line 420: wsh_debug_sv.push(l_moduleName);

416: l_debugOn := wsh_debug_sv.is_debug_enabled;
417: END IF;
418: --
419: IF l_debugOn THEN
420: wsh_debug_sv.push(l_moduleName);
421: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);

Line 421: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);

417: END IF;
418: --
419: IF l_debugOn THEN
420: wsh_debug_sv.push(l_moduleName);
421: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);

Line 422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);

418: --
419: IF l_debugOn THEN
420: wsh_debug_sv.push(l_moduleName);
421: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);

Line 423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);

419: IF l_debugOn THEN
420: wsh_debug_sv.push(l_moduleName);
421: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);

Line 424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);

420: wsh_debug_sv.push(l_moduleName);
421: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
428: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);

Line 425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);

421: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
428: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
429: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);

Line 426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);

422: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
428: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
429: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
430: END IF;

Line 427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);

423: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
428: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
429: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
430: END IF;
431: --

Line 428: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);

424: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
428: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
429: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
430: END IF;
431: --
432: v_select := 'SELECT wnd.DELIVERY_ID, wnd.ORGANIZATION_ID, wnd.STATUS_CODE, wnd.PLANNED_FLAG, ' ||

Line 429: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);

425: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
426: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
427: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
428: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
429: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
430: END IF;
431: --
432: v_select := 'SELECT wnd.DELIVERY_ID, wnd.ORGANIZATION_ID, wnd.STATUS_CODE, wnd.PLANNED_FLAG, ' ||
433: ' wnd.NAME, wnd.INITIAL_PICKUP_DATE, wnd.INITIAL_PICKUP_LOCATION_ID, ' ||

Line 542: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);

538: x_Query := v_select || v_from || v_where || v_OrderBy;
539: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
540: --
541: IF l_debugOn THEN
542: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);

Line 543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);

539: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
540: --
541: IF l_debugOn THEN
542: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
547: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);

Line 544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);

540: --
541: IF l_debugOn THEN
542: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
547: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
548: wsh_debug_sv.pop(l_moduleName);

Line 545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);

541: IF l_debugOn THEN
542: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
547: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
548: wsh_debug_sv.pop(l_moduleName);
549: END IF;

Line 546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);

542: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
547: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
548: wsh_debug_sv.pop(l_moduleName);
549: END IF;
550: --

Line 547: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);

543: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
547: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
548: wsh_debug_sv.pop(l_moduleName);
549: END IF;
550: --
551: EXCEPTION

Line 548: wsh_debug_sv.pop(l_moduleName);

544: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
545: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
546: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
547: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
548: wsh_debug_sv.pop(l_moduleName);
549: END IF;
550: --
551: EXCEPTION
552: --

Line 561: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));

557: --
558: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
559: --
560: IF l_debugOn THEN
561: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
562: wsh_debug_sv.pop(l_moduleName);
563: END IF;
564: --
565: RAISE;

Line 562: wsh_debug_sv.pop(l_moduleName);

558: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
559: --
560: IF l_debugOn THEN
561: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
562: wsh_debug_sv.pop(l_moduleName);
563: END IF;
564: --
565: RAISE;
566: --

Line 603: l_debugOn := wsh_debug_sv.is_debug_enabled;

599: l_exists := FALSE;
600: l_separator := '-';
601: --
602: IF l_debugOn IS NULL THEN
603: l_debugOn := wsh_debug_sv.is_debug_enabled;
604: END IF;
605: --
606: IF l_debugOn THEN
607: wsh_debug_sv.push(l_moduleName);

Line 607: wsh_debug_sv.push(l_moduleName);

603: l_debugOn := wsh_debug_sv.is_debug_enabled;
604: END IF;
605: --
606: IF l_debugOn THEN
607: wsh_debug_sv.push(l_moduleName);
608: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
609: wsh_debug_sv.log(l_moduleName, 'Organization ID',
610: x_del_rec.organization_id);
611: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',

Line 608: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);

604: END IF;
605: --
606: IF l_debugOn THEN
607: wsh_debug_sv.push(l_moduleName);
608: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
609: wsh_debug_sv.log(l_moduleName, 'Organization ID',
610: x_del_rec.organization_id);
611: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',
612: x_del_rec.ignore_for_planning);

Line 609: wsh_debug_sv.log(l_moduleName, 'Organization ID',

605: --
606: IF l_debugOn THEN
607: wsh_debug_sv.push(l_moduleName);
608: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
609: wsh_debug_sv.log(l_moduleName, 'Organization ID',
610: x_del_rec.organization_id);
611: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',
612: x_del_rec.ignore_for_planning);
613: END IF;

Line 611: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',

607: wsh_debug_sv.push(l_moduleName);
608: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
609: wsh_debug_sv.log(l_moduleName, 'Organization ID',
610: x_del_rec.organization_id);
611: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',
612: x_del_rec.ignore_for_planning);
613: END IF;
614: --
615: l_orgType := WSH_UTIL_VALIDATE.Get_Org_Type(

Line 621: wsh_debug_sv.log(l_moduleName, 'Org Type', l_orgType);

617: p_delivery_id => x_del_rec.delivery_id,
618: x_return_status => v_RetSts);
619: --
620: IF l_debugOn THEN
621: wsh_debug_sv.log(l_moduleName, 'Org Type', l_orgType);
622: END IF;
623: --
624: wsh_util_core.api_post_call(
625: p_return_status => v_RetSts,

Line 656: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);

652: base => g_hashBase,
653: hash_size => g_hashSize);
654: --
655: IF l_debugOn THEN
656: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
657: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
658: END IF;
659: --
660: IF x_HashTable.EXISTS(l_hashVal) THEN

Line 657: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);

653: hash_size => g_hashSize);
654: --
655: IF l_debugOn THEN
656: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
657: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
658: END IF;
659: --
660: IF x_HashTable.EXISTS(l_hashVal) THEN
661: --{

Line 670: wsh_debug_sv.logmsg(l_moduleName, 'Hash collision, so regenerating hash value');

666: --
667: ELSE /* hash collision */
668: --{
669: IF l_debugOn THEN
670: wsh_debug_sv.logmsg(l_moduleName, 'Hash collision, so regenerating hash value');
671: END IF;
672: --
673: l_hashSize := g_HashSize;
674: --

Line 683: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);

679: base => g_hashBase,
680: hash_size => l_hashSize);
681: --
682: IF l_debugOn THEN
683: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
684: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
685: END IF;
686: --
687: IF x_HashTable.EXISTS(l_hashVal) THEN

Line 684: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);

680: hash_size => l_hashSize);
681: --
682: IF l_debugOn THEN
683: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
684: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
685: END IF;
686: --
687: IF x_HashTable.EXISTS(l_hashVal) THEN
688: --{

Line 721: wsh_debug_sv.log(l_moduleName, 'Delivery Hash Value', x_del_rec.hash_value);

717: x_HashTable(l_hashVal).hashString := l_hashStr;
718: END IF;
719: --
720: IF l_debugOn THEN
721: wsh_debug_sv.log(l_moduleName, 'Delivery Hash Value', x_del_rec.hash_value);
722: wsh_debug_sv.log(l_moduleName, 'Include delivery for trip creation', x_UseDeliv);
723: wsh_debug_sv.pop(l_moduleName);
724: END IF;
725: --

Line 722: wsh_debug_sv.log(l_moduleName, 'Include delivery for trip creation', x_UseDeliv);

718: END IF;
719: --
720: IF l_debugOn THEN
721: wsh_debug_sv.log(l_moduleName, 'Delivery Hash Value', x_del_rec.hash_value);
722: wsh_debug_sv.log(l_moduleName, 'Include delivery for trip creation', x_UseDeliv);
723: wsh_debug_sv.pop(l_moduleName);
724: END IF;
725: --
726: EXCEPTION

Line 723: wsh_debug_sv.pop(l_moduleName);

719: --
720: IF l_debugOn THEN
721: wsh_debug_sv.log(l_moduleName, 'Delivery Hash Value', x_del_rec.hash_value);
722: wsh_debug_sv.log(l_moduleName, 'Include delivery for trip creation', x_UseDeliv);
723: wsh_debug_sv.pop(l_moduleName);
724: END IF;
725: --
726: EXCEPTION
727: --

Line 735: wsh_debug_sv.log(l_moduleName, 'Unexpected Error', SUBSTRB(SQLERRM,1,200));

731: --
732: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CreateAssignHashValue');
733: --
734: IF l_debugOn THEN
735: wsh_debug_sv.log(l_moduleName, 'Unexpected Error', SUBSTRB(SQLERRM,1,200));
736: wsh_debug_sv.pop(l_moduleName);
737: END IF;
738: --
739: RAISE;

Line 736: wsh_debug_sv.pop(l_moduleName);

732: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CreateAssignHashValue');
733: --
734: IF l_debugOn THEN
735: wsh_debug_sv.log(l_moduleName, 'Unexpected Error', SUBSTRB(SQLERRM,1,200));
736: wsh_debug_sv.pop(l_moduleName);
737: END IF;
738: --
739: RAISE;
740: --

Line 755: l_debugOn := wsh_debug_sv.is_debug_enabled;

751: --
752: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
753: --
754: IF l_debugOn IS NULL THEN
755: l_debugOn := wsh_debug_sv.is_debug_enabled;
756: END IF;
757: --
758: IF l_debugOn THEN
759: wsh_debug_sv.push(l_moduleName);

Line 759: wsh_debug_sv.push(l_moduleName);

755: l_debugOn := wsh_debug_sv.is_debug_enabled;
756: END IF;
757: --
758: IF l_debugOn THEN
759: wsh_debug_sv.push(l_moduleName);
760: END IF;
761: --
762: FETCH p_Deliv_ref INTO
763: x_deliv_rec.delivery_id, x_deliv_rec.organization_id,

Line 777: wsh_debug_sv.pop(l_moduleName || ' - FALSE');

773: --
774: IF p_Deliv_ref%NOTFOUND THEN
775: --
776: IF l_debugOn THEN
777: wsh_debug_sv.pop(l_moduleName || ' - FALSE');
778: END IF;
779: RETURN FALSE;
780: --
781: ELSE

Line 784: wsh_debug_sv.logmsg(l_moduleName, 'Fetching delivery ' || x_deliv_rec.delivery_id);

780: --
781: ELSE
782: --
783: IF l_debugOn THEN
784: wsh_debug_sv.logmsg(l_moduleName, 'Fetching delivery ' || x_deliv_rec.delivery_id);
785: wsh_debug_sv.pop(l_moduleName || ' - TRUE');
786: END IF;
787: RETURN TRUE;
788: --

Line 785: wsh_debug_sv.pop(l_moduleName || ' - TRUE');

781: ELSE
782: --
783: IF l_debugOn THEN
784: wsh_debug_sv.logmsg(l_moduleName, 'Fetching delivery ' || x_deliv_rec.delivery_id);
785: wsh_debug_sv.pop(l_moduleName || ' - TRUE');
786: END IF;
787: RETURN TRUE;
788: --
789: END IF;

Line 798: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error in FetchDelivery');

794: --
795: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.FetchDelivery');
796: --
797: IF l_debugOn THEN
798: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error in FetchDelivery');
799: wsh_debug_sv.pop(l_moduleName);
800: END IF;
801: --
802: RAISE;

Line 799: wsh_debug_sv.pop(l_moduleName);

795: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.FetchDelivery');
796: --
797: IF l_debugOn THEN
798: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error in FetchDelivery');
799: wsh_debug_sv.pop(l_moduleName);
800: END IF;
801: --
802: RAISE;
803: --

Line 821: l_debugOn := wsh_debug_sv.is_debug_enabled;

817: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
818: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
819: --
820: IF l_debugOn IS NULL THEN
821: l_debugOn := wsh_debug_sv.is_debug_enabled;
822: END IF;
823: --
824: IF l_debugOn THEN
825: wsh_debug_sv.push(l_moduleName);

Line 825: wsh_debug_sv.push(l_moduleName);

821: l_debugOn := wsh_debug_sv.is_debug_enabled;
822: END IF;
823: --
824: IF l_debugOn THEN
825: wsh_debug_sv.push(l_moduleName);
826: END IF;
827: --
828: x_DelivRec.delivery_id := p_DelivRec.delivery_id;
829: x_DelivRec.organization_id := p_DelivRec.organization_id;

Line 850: wsh_debug_sv.pop(l_moduleName);

846: x_DelivRec.shipping_control := p_DelivRec.shipping_control;
847: x_DelivRec.ignore_for_planning := p_DelivRec.ignore_for_planning;
848: --
849: IF l_debugOn THEN
850: wsh_debug_sv.pop(l_moduleName);
851: END IF;
852: --
853: EXCEPTION
854: --

Line 862: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM,1,200));

858: --
859: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDelivRec');
860: --
861: IF l_debugOn THEN
862: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM,1,200));
863: wsh_debug_sv.pop(l_moduleName);
864: END IF;
865: --
866: RAISE;

Line 863: wsh_debug_sv.pop(l_moduleName);

859: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDelivRec');
860: --
861: IF l_debugOn THEN
862: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM,1,200));
863: wsh_debug_sv.pop(l_moduleName);
864: END IF;
865: --
866: RAISE;
867: --

Line 914: l_debugOn := wsh_debug_sv.is_debug_enabled;

910: l_num_errors := 0;
911: l_num_warnings := 0;
912: --
913: IF l_debugOn IS NULL THEN
914: l_debugOn := wsh_debug_sv.is_debug_enabled;
915: END IF;
916: --
917: IF l_debugOn THEN
918: wsh_debug_sv.push(l_moduleName);

Line 918: wsh_debug_sv.push(l_moduleName);

914: l_debugOn := wsh_debug_sv.is_debug_enabled;
915: END IF;
916: --
917: IF l_debugOn THEN
918: wsh_debug_sv.push(l_moduleName);
919: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
920: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
921: --
922: wsh_debug_sv.logmsg(l_moduleName,

Line 919: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);

915: END IF;
916: --
917: IF l_debugOn THEN
918: wsh_debug_sv.push(l_moduleName);
919: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
920: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
921: --
922: wsh_debug_sv.logmsg(l_moduleName,
923: '===========Complete Set of Input Deliveries===========');

Line 920: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);

916: --
917: IF l_debugOn THEN
918: wsh_debug_sv.push(l_moduleName);
919: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
920: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
921: --
922: wsh_debug_sv.logmsg(l_moduleName,
923: '===========Complete Set of Input Deliveries===========');
924: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;

Line 922: wsh_debug_sv.logmsg(l_moduleName,

918: wsh_debug_sv.push(l_moduleName);
919: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
920: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
921: --
922: wsh_debug_sv.logmsg(l_moduleName,
923: '===========Complete Set of Input Deliveries===========');
924: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;
925: WHILE v_Index IS NOT NULL LOOP
926: --

Line 927: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);

923: '===========Complete Set of Input Deliveries===========');
924: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;
925: WHILE v_Index IS NOT NULL LOOP
926: --
927: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
928: wsh_debug_sv.log(l_moduleName, 'Delivery Id',
929: p_DelivGrpRec.deliv_IDTab(v_Index));
930: v_Index := p_DelivGrpRec.deliv_IDTab.NEXT(v_Index);
931: --

Line 928: wsh_debug_sv.log(l_moduleName, 'Delivery Id',

924: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;
925: WHILE v_Index IS NOT NULL LOOP
926: --
927: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
928: wsh_debug_sv.log(l_moduleName, 'Delivery Id',
929: p_DelivGrpRec.deliv_IDTab(v_Index));
930: v_Index := p_DelivGrpRec.deliv_IDTab.NEXT(v_Index);
931: --
932: END LOOP;

Line 949: wsh_debug_sv.log(l_moduleName, '# of delivs. passed to AutoCreate_trip_multi',l_delivery_tab.COUNT);

945: (i = p_DelivGrpRec.deliv_IDTab.COUNT) THEN
946: --{
947: IF l_debugOn THEN
948: --{
949: wsh_debug_sv.log(l_moduleName, '# of delivs. passed to AutoCreate_trip_multi',l_delivery_tab.COUNT);
950: wsh_debug_sv.logmsg(l_moduleName,
951: '========Deliveries passed to Autocreate Trip==========');
952: --
953: v_Index := l_delivery_tab.FIRST;

Line 950: wsh_debug_sv.logmsg(l_moduleName,

946: --{
947: IF l_debugOn THEN
948: --{
949: wsh_debug_sv.log(l_moduleName, '# of delivs. passed to AutoCreate_trip_multi',l_delivery_tab.COUNT);
950: wsh_debug_sv.logmsg(l_moduleName,
951: '========Deliveries passed to Autocreate Trip==========');
952: --
953: v_Index := l_delivery_tab.FIRST;
954: WHILE v_Index IS NOT NULL LOOP

Line 956: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);

952: --
953: v_Index := l_delivery_tab.FIRST;
954: WHILE v_Index IS NOT NULL LOOP
955: --
956: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
957: wsh_debug_sv.log(l_moduleName, 'Delivery Id', l_delivery_tab(v_Index));
958: v_Index := l_delivery_tab.NEXT(v_Index);
959: --
960: END LOOP;

Line 957: wsh_debug_sv.log(l_moduleName, 'Delivery Id', l_delivery_tab(v_Index));

953: v_Index := l_delivery_tab.FIRST;
954: WHILE v_Index IS NOT NULL LOOP
955: --
956: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
957: wsh_debug_sv.log(l_moduleName, 'Delivery Id', l_delivery_tab(v_Index));
958: v_Index := l_delivery_tab.NEXT(v_Index);
959: --
960: END LOOP;
961: --}

Line 986: wsh_debug_sv.log(l_moduleName, 'Index k', k);

982: --{
983: x_delOutRec.result_id_tab(k):=l_trip_tab(m);
984: --
985: IF l_debugOn THEN
986: wsh_debug_sv.log(l_moduleName, 'Index k', k);
987: wsh_debug_sv.log(l_moduleName, 'Trip ID', x_delOutRec.result_id_tab(k));
988: END IF;
989: --
990: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

Line 987: wsh_debug_sv.log(l_moduleName, 'Trip ID', x_delOutRec.result_id_tab(k));

983: x_delOutRec.result_id_tab(k):=l_trip_tab(m);
984: --
985: IF l_debugOn THEN
986: wsh_debug_sv.log(l_moduleName, 'Index k', k);
987: wsh_debug_sv.log(l_moduleName, 'Trip ID', x_delOutRec.result_id_tab(k));
988: END IF;
989: --
990: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
991: --{

Line 998: wsh_debug_sv.log(l_moduleName, 'v_DelCount', v_DelCount);

994: FETCH c_DeliveryCount INTO v_DelCount;
995: CLOSE c_DeliveryCount;
996: --
997: IF l_debugOn THEN
998: wsh_debug_sv.log(l_moduleName, 'v_DelCount', v_DelCount);
999: END IF;
1000: --}
1001: ELSE
1002: v_DelCount := l_delivery_tab.COUNT;

Line 1012: wsh_debug_sv.log(l_moduleName,'v_TotalDelCount', v_TotalDelCount);

1008: --}
1009: END LOOP;
1010: --
1011: IF l_debugOn THEN
1012: wsh_debug_sv.log(l_moduleName,'v_TotalDelCount', v_TotalDelCount);
1013: END IF;
1014: --
1015: j := 0;
1016: g_SuccDelivs := NVL(g_SuccDelivs,0) + v_TotalDelCount;

Line 1023: wsh_debug_sv.log(l_moduleName, '# of trips until now', g_Trips);

1019: v_TotalDelCount;
1020: l_delivery_tab.DELETE;
1021: --
1022: IF l_debugOn THEN
1023: wsh_debug_sv.log(l_moduleName, '# of trips until now', g_Trips);
1024: wsh_debug_sv.log(l_moduleName, '# of successful delivs until now', g_SuccDelivs);
1025: wsh_debug_sv.log(l_moduleName, '# of successful delivs in this batch', x_DelOutRec.num_success_Delivs);
1026: END IF;
1027: --}

Line 1024: wsh_debug_sv.log(l_moduleName, '# of successful delivs until now', g_SuccDelivs);

1020: l_delivery_tab.DELETE;
1021: --
1022: IF l_debugOn THEN
1023: wsh_debug_sv.log(l_moduleName, '# of trips until now', g_Trips);
1024: wsh_debug_sv.log(l_moduleName, '# of successful delivs until now', g_SuccDelivs);
1025: wsh_debug_sv.log(l_moduleName, '# of successful delivs in this batch', x_DelOutRec.num_success_Delivs);
1026: END IF;
1027: --}
1028: EXCEPTION

Line 1025: wsh_debug_sv.log(l_moduleName, '# of successful delivs in this batch', x_DelOutRec.num_success_Delivs);

1021: --
1022: IF l_debugOn THEN
1023: wsh_debug_sv.log(l_moduleName, '# of trips until now', g_Trips);
1024: wsh_debug_sv.log(l_moduleName, '# of successful delivs until now', g_SuccDelivs);
1025: wsh_debug_sv.log(l_moduleName, '# of successful delivs in this batch', x_DelOutRec.num_success_Delivs);
1026: END IF;
1027: --}
1028: EXCEPTION
1029: --{

Line 1037: wsh_debug_sv.logmsg(l_moduleName, 'Expected Error for this set of deliveries');

1033: l_delivery_tab.DELETE;
1034: ROLLBACK TO Before_Autocreate_Trip;
1035: --
1036: IF l_debugOn THEN
1037: wsh_debug_sv.logmsg(l_moduleName, 'Expected Error for this set of deliveries');
1038: END IF;
1039: --
1040: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1041: --

Line 1047: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error for this set of deliveries');

1043: l_delivery_tab.DELETE;
1044: ROLLBACK TO Before_Autocreate_Trip;
1045: --
1046: IF l_debugOn THEN
1047: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error for this set of deliveries');
1048: END IF;
1049: --}
1050: END;
1051: --}

Line 1060: wsh_debug_Sv.log(l_moduleName, '# of calls to Autocreate Trip', v_numCalls);

1056: --}
1057: END LOOP;
1058: --
1059: IF l_debugOn THEN
1060: wsh_debug_Sv.log(l_moduleName, '# of calls to Autocreate Trip', v_numCalls);
1061: wsh_debug_sv.log(l_moduleName, '# errors from these calls', l_num_errors);
1062: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1063: END IF;
1064: --

Line 1061: wsh_debug_sv.log(l_moduleName, '# errors from these calls', l_num_errors);

1057: END LOOP;
1058: --
1059: IF l_debugOn THEN
1060: wsh_debug_Sv.log(l_moduleName, '# of calls to Autocreate Trip', v_numCalls);
1061: wsh_debug_sv.log(l_moduleName, '# errors from these calls', l_num_errors);
1062: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1063: END IF;
1064: --
1065: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN

Line 1062: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);

1058: --
1059: IF l_debugOn THEN
1060: wsh_debug_Sv.log(l_moduleName, '# of calls to Autocreate Trip', v_numCalls);
1061: wsh_debug_sv.log(l_moduleName, '# errors from these calls', l_num_errors);
1062: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1063: END IF;
1064: --
1065: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN
1066: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 1075: wsh_debug_sv.log(l_moduleName, 'x_return_status', x_return_status);

1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1072: END IF;
1073: --
1074: IF l_debugOn THEN
1075: wsh_debug_sv.log(l_moduleName, 'x_return_status', x_return_status);
1076: wsh_debug_sv.pop(l_moduleName);
1077: END IF;
1078: --
1079: EXCEPTION

Line 1076: wsh_debug_sv.pop(l_moduleName);

1072: END IF;
1073: --
1074: IF l_debugOn THEN
1075: wsh_debug_sv.log(l_moduleName, 'x_return_status', x_return_status);
1076: wsh_debug_sv.pop(l_moduleName);
1077: END IF;
1078: --
1079: EXCEPTION
1080: --

Line 1086: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');

1082: --
1083: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1084: --
1085: IF l_debugOn THEN
1086: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');
1087: END IF;
1088: --
1089: RAISE;
1090: --

Line 1096: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXPECTED_ERROR');

1092: --
1093: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1094: --
1095: IF l_debugOn THEN
1096: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXPECTED_ERROR');
1097: END IF;
1098: --
1099: RAISE;
1100: --

Line 1108: wsh_Debug_sv.logmsg(l_moduleName, 'Unexpected error in GroupDelivsIntoTrips' || SQLERRM);

1104: --
1105: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.GroupDelivsIntoTrips');
1106: --
1107: IF l_debugOn THEN
1108: wsh_Debug_sv.logmsg(l_moduleName, 'Unexpected error in GroupDelivsIntoTrips' || SQLERRM);
1109: wsh_debug_sv.pop(l_moduleName);
1110: END IF;
1111: --
1112: RAISE;

Line 1109: wsh_debug_sv.pop(l_moduleName);

1105: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.GroupDelivsIntoTrips');
1106: --
1107: IF l_debugOn THEN
1108: wsh_Debug_sv.logmsg(l_moduleName, 'Unexpected error in GroupDelivsIntoTrips' || SQLERRM);
1109: wsh_debug_sv.pop(l_moduleName);
1110: END IF;
1111: --
1112: RAISE;
1113: --