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 111: l_debugOn := wsh_debug_sv.is_debug_enabled;

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

Line 115: wsh_debug_sv.push(l_moduleName);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 323: wsh_debug_sv.pop(l_moduleName);

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

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

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

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

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

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

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

Line 419: l_debugOn := wsh_debug_sv.is_debug_enabled;

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

Line 423: wsh_debug_sv.push(l_moduleName);

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

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

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

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

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

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

422: IF l_debugOn THEN
423: wsh_debug_sv.push(l_moduleName);
424: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
425: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
426: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
427: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
428: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT

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

423: wsh_debug_sv.push(l_moduleName);
424: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
425: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
426: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
427: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
428: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT
431: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);

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

424: wsh_debug_sv.log(l_moduleName, 'p_deliv_status', p_deliv_status);
425: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
426: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
427: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
428: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT
431: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
432: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);

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

425: wsh_debug_sv.log(l_moduleName, 'p_customer_id', p_customer_id);
426: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
427: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
428: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT
431: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
432: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
433: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);

Line 430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT

426: wsh_debug_sv.log(l_moduleName, 'p_pickup_start', p_pickup_start);
427: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
428: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT
431: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
432: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
433: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
434: END IF;

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

427: wsh_debug_sv.log(l_moduleName, 'p_pickup_end', p_pickup_end);
428: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT
431: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
432: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
433: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
434: END IF;
435: --

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

428: wsh_debug_sv.log(l_moduleName, 'p_dropoff_start', p_dropoff_start);
429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT
431: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
432: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
433: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
434: END IF;
435: --
436: v_select := 'SELECT wnd.DELIVERY_ID, wnd.ORGANIZATION_ID, wnd.STATUS_CODE, wnd.PLANNED_FLAG, ' ||

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

429: wsh_debug_sv.log(l_moduleName, 'p_dropoff_end', p_dropoff_end);
430: wsh_debug_sv.log(l_moduleName, 'p_client_id', p_client_id); -- Modified R12.1.1 LSP PROJECT
431: wsh_debug_sv.log(l_moduleName, 'p_ship_from_org_id', p_ship_from_org_id);
432: wsh_debug_sv.log(l_moduleName, 'p_ship_to_location', p_ship_to_location);
433: wsh_debug_sv.log(l_moduleName, 'p_ship_method_code', p_ship_method_code);
434: END IF;
435: --
436: v_select := 'SELECT wnd.DELIVERY_ID, wnd.ORGANIZATION_ID, wnd.STATUS_CODE, wnd.PLANNED_FLAG, ' ||
437: ' wnd.NAME, wnd.INITIAL_PICKUP_DATE, wnd.INITIAL_PICKUP_LOCATION_ID, ' ||

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

558: x_Query := v_select || v_from || v_where || v_OrderBy;
559: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
560: --
561: IF l_debugOn THEN
562: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
563: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
564: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
565: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
566: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);

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

559: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
560: --
561: IF l_debugOn THEN
562: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
563: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
564: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
565: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
566: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
567: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);

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

560: --
561: IF l_debugOn THEN
562: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
563: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
564: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
565: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
566: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
567: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
568: wsh_debug_sv.pop(l_moduleName);

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

561: IF l_debugOn THEN
562: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
563: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
564: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
565: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
566: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
567: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
568: wsh_debug_sv.pop(l_moduleName);
569: END IF;

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

562: wsh_debug_sv.log(l_moduleName, 'v_Select', v_Select);
563: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
564: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
565: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
566: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
567: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
568: wsh_debug_sv.pop(l_moduleName);
569: END IF;
570: --

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

563: wsh_debug_sv.log(l_moduleName, 'v_From', v_From);
564: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
565: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
566: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
567: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
568: wsh_debug_sv.pop(l_moduleName);
569: END IF;
570: --
571: EXCEPTION

Line 568: wsh_debug_sv.pop(l_moduleName);

564: wsh_debug_sv.log(l_moduleName, 'v_Where', v_Where);
565: wsh_debug_sv.log(l_moduleName, 'v_OrderBy', v_OrderBy);
566: wsh_debug_sv.log(l_moduleName, 'x_Query', x_Query);
567: wsh_debug_sv.log(l_moduleName, 'g_BindVarTab.COUNT', g_BindVarTab.COUNT);
568: wsh_debug_sv.pop(l_moduleName);
569: END IF;
570: --
571: EXCEPTION
572: --

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

577: --
578: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
579: --
580: IF l_debugOn THEN
581: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
582: wsh_debug_sv.pop(l_moduleName);
583: END IF;
584: --
585: RAISE;

Line 582: wsh_debug_sv.pop(l_moduleName);

578: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CREATE_CONSOLIDATED_TRIPS');
579: --
580: IF l_debugOn THEN
581: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM, 1, 200));
582: wsh_debug_sv.pop(l_moduleName);
583: END IF;
584: --
585: RAISE;
586: --

Line 623: l_debugOn := wsh_debug_sv.is_debug_enabled;

619: l_exists := FALSE;
620: l_separator := '-';
621: --
622: IF l_debugOn IS NULL THEN
623: l_debugOn := wsh_debug_sv.is_debug_enabled;
624: END IF;
625: --
626: IF l_debugOn THEN
627: wsh_debug_sv.push(l_moduleName);

Line 627: wsh_debug_sv.push(l_moduleName);

623: l_debugOn := wsh_debug_sv.is_debug_enabled;
624: END IF;
625: --
626: IF l_debugOn THEN
627: wsh_debug_sv.push(l_moduleName);
628: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
629: wsh_debug_sv.log(l_moduleName, 'Organization ID',
630: x_del_rec.organization_id);
631: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',

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

624: END IF;
625: --
626: IF l_debugOn THEN
627: wsh_debug_sv.push(l_moduleName);
628: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
629: wsh_debug_sv.log(l_moduleName, 'Organization ID',
630: x_del_rec.organization_id);
631: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',
632: x_del_rec.ignore_for_planning);

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

625: --
626: IF l_debugOn THEN
627: wsh_debug_sv.push(l_moduleName);
628: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
629: wsh_debug_sv.log(l_moduleName, 'Organization ID',
630: x_del_rec.organization_id);
631: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',
632: x_del_rec.ignore_for_planning);
633: END IF;

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

627: wsh_debug_sv.push(l_moduleName);
628: wsh_debug_sv.log(l_moduleName, 'Delivery ID', x_del_rec.delivery_id);
629: wsh_debug_sv.log(l_moduleName, 'Organization ID',
630: x_del_rec.organization_id);
631: wsh_debug_sv.log(l_moduleName, 'Ignore For Planning',
632: x_del_rec.ignore_for_planning);
633: END IF;
634: --
635: l_orgType := WSH_UTIL_VALIDATE.Get_Org_Type(

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

637: p_delivery_id => x_del_rec.delivery_id,
638: x_return_status => v_RetSts);
639: --
640: IF l_debugOn THEN
641: wsh_debug_sv.log(l_moduleName, 'Org Type', l_orgType);
642: END IF;
643: --
644: wsh_util_core.api_post_call(
645: p_return_status => v_RetSts,

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

672: base => g_hashBase,
673: hash_size => g_hashSize);
674: --
675: IF l_debugOn THEN
676: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
677: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
678: END IF;
679: --
680: IF x_HashTable.EXISTS(l_hashVal) THEN

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

673: hash_size => g_hashSize);
674: --
675: IF l_debugOn THEN
676: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
677: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
678: END IF;
679: --
680: IF x_HashTable.EXISTS(l_hashVal) THEN
681: --{

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

686: --
687: ELSE /* hash collision */
688: --{
689: IF l_debugOn THEN
690: wsh_debug_sv.logmsg(l_moduleName, 'Hash collision, so regenerating hash value');
691: END IF;
692: --
693: l_hashSize := g_HashSize;
694: --

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

699: base => g_hashBase,
700: hash_size => l_hashSize);
701: --
702: IF l_debugOn THEN
703: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
704: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
705: END IF;
706: --
707: IF x_HashTable.EXISTS(l_hashVal) THEN

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

700: hash_size => l_hashSize);
701: --
702: IF l_debugOn THEN
703: wsh_debug_sv.log(l_moduleName, 'l_hashStr', l_hashStr);
704: wsh_debug_sv.log(l_moduleName, 'l_hashVal', l_hashVal);
705: END IF;
706: --
707: IF x_HashTable.EXISTS(l_hashVal) THEN
708: --{

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

737: x_HashTable(l_hashVal).hashString := l_hashStr;
738: END IF;
739: --
740: IF l_debugOn THEN
741: wsh_debug_sv.log(l_moduleName, 'Delivery Hash Value', x_del_rec.hash_value);
742: wsh_debug_sv.log(l_moduleName, 'Include delivery for trip creation', x_UseDeliv);
743: wsh_debug_sv.pop(l_moduleName);
744: END IF;
745: --

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

738: END IF;
739: --
740: IF l_debugOn THEN
741: wsh_debug_sv.log(l_moduleName, 'Delivery Hash Value', x_del_rec.hash_value);
742: wsh_debug_sv.log(l_moduleName, 'Include delivery for trip creation', x_UseDeliv);
743: wsh_debug_sv.pop(l_moduleName);
744: END IF;
745: --
746: EXCEPTION

Line 743: wsh_debug_sv.pop(l_moduleName);

739: --
740: IF l_debugOn THEN
741: wsh_debug_sv.log(l_moduleName, 'Delivery Hash Value', x_del_rec.hash_value);
742: wsh_debug_sv.log(l_moduleName, 'Include delivery for trip creation', x_UseDeliv);
743: wsh_debug_sv.pop(l_moduleName);
744: END IF;
745: --
746: EXCEPTION
747: --

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

751: --
752: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CreateAssignHashValue');
753: --
754: IF l_debugOn THEN
755: wsh_debug_sv.log(l_moduleName, 'Unexpected Error', SUBSTRB(SQLERRM,1,200));
756: wsh_debug_sv.pop(l_moduleName);
757: END IF;
758: --
759: RAISE;

Line 756: wsh_debug_sv.pop(l_moduleName);

752: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.CreateAssignHashValue');
753: --
754: IF l_debugOn THEN
755: wsh_debug_sv.log(l_moduleName, 'Unexpected Error', SUBSTRB(SQLERRM,1,200));
756: wsh_debug_sv.pop(l_moduleName);
757: END IF;
758: --
759: RAISE;
760: --

Line 775: l_debugOn := wsh_debug_sv.is_debug_enabled;

771: --
772: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
773: --
774: IF l_debugOn IS NULL THEN
775: l_debugOn := wsh_debug_sv.is_debug_enabled;
776: END IF;
777: --
778: IF l_debugOn THEN
779: wsh_debug_sv.push(l_moduleName);

Line 779: wsh_debug_sv.push(l_moduleName);

775: l_debugOn := wsh_debug_sv.is_debug_enabled;
776: END IF;
777: --
778: IF l_debugOn THEN
779: wsh_debug_sv.push(l_moduleName);
780: END IF;
781: --
782: FETCH p_Deliv_ref INTO
783: x_deliv_rec.delivery_id, x_deliv_rec.organization_id,

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

793: --
794: IF p_Deliv_ref%NOTFOUND THEN
795: --
796: IF l_debugOn THEN
797: wsh_debug_sv.pop(l_moduleName || ' - FALSE');
798: END IF;
799: RETURN FALSE;
800: --
801: ELSE

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

800: --
801: ELSE
802: --
803: IF l_debugOn THEN
804: wsh_debug_sv.logmsg(l_moduleName, 'Fetching delivery ' || x_deliv_rec.delivery_id);
805: wsh_debug_sv.pop(l_moduleName || ' - TRUE');
806: END IF;
807: RETURN TRUE;
808: --

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

801: ELSE
802: --
803: IF l_debugOn THEN
804: wsh_debug_sv.logmsg(l_moduleName, 'Fetching delivery ' || x_deliv_rec.delivery_id);
805: wsh_debug_sv.pop(l_moduleName || ' - TRUE');
806: END IF;
807: RETURN TRUE;
808: --
809: END IF;

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

814: --
815: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.FetchDelivery');
816: --
817: IF l_debugOn THEN
818: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error in FetchDelivery');
819: wsh_debug_sv.pop(l_moduleName);
820: END IF;
821: --
822: RAISE;

Line 819: wsh_debug_sv.pop(l_moduleName);

815: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.FetchDelivery');
816: --
817: IF l_debugOn THEN
818: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error in FetchDelivery');
819: wsh_debug_sv.pop(l_moduleName);
820: END IF;
821: --
822: RAISE;
823: --

Line 841: l_debugOn := wsh_debug_sv.is_debug_enabled;

837: l_debugOn := WSH_DEBUG_INTERFACE.g_debug;
838: x_RetSts := WSH_UTIL_CORE.g_RET_STS_SUCCESS;
839: --
840: IF l_debugOn IS NULL THEN
841: l_debugOn := wsh_debug_sv.is_debug_enabled;
842: END IF;
843: --
844: IF l_debugOn THEN
845: wsh_debug_sv.push(l_moduleName);

Line 845: wsh_debug_sv.push(l_moduleName);

841: l_debugOn := wsh_debug_sv.is_debug_enabled;
842: END IF;
843: --
844: IF l_debugOn THEN
845: wsh_debug_sv.push(l_moduleName);
846: END IF;
847: --
848: x_DelivRec.delivery_id := p_DelivRec.delivery_id;
849: x_DelivRec.organization_id := p_DelivRec.organization_id;

Line 870: wsh_debug_sv.pop(l_moduleName);

866: x_DelivRec.shipping_control := p_DelivRec.shipping_control;
867: x_DelivRec.ignore_for_planning := p_DelivRec.ignore_for_planning;
868: --
869: IF l_debugOn THEN
870: wsh_debug_sv.pop(l_moduleName);
871: END IF;
872: --
873: EXCEPTION
874: --

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

878: --
879: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDelivRec');
880: --
881: IF l_debugOn THEN
882: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM,1,200));
883: wsh_debug_sv.pop(l_moduleName);
884: END IF;
885: --
886: RAISE;

Line 883: wsh_debug_sv.pop(l_moduleName);

879: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.BuildDelivRec');
880: --
881: IF l_debugOn THEN
882: wsh_debug_sv.log(l_moduleName, 'Unexpected error', SUBSTRB(SQLERRM,1,200));
883: wsh_debug_sv.pop(l_moduleName);
884: END IF;
885: --
886: RAISE;
887: --

Line 934: l_debugOn := wsh_debug_sv.is_debug_enabled;

930: l_num_errors := 0;
931: l_num_warnings := 0;
932: --
933: IF l_debugOn IS NULL THEN
934: l_debugOn := wsh_debug_sv.is_debug_enabled;
935: END IF;
936: --
937: IF l_debugOn THEN
938: wsh_debug_sv.push(l_moduleName);

Line 938: wsh_debug_sv.push(l_moduleName);

934: l_debugOn := wsh_debug_sv.is_debug_enabled;
935: END IF;
936: --
937: IF l_debugOn THEN
938: wsh_debug_sv.push(l_moduleName);
939: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
940: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
941: --
942: wsh_debug_sv.logmsg(l_moduleName,

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

935: END IF;
936: --
937: IF l_debugOn THEN
938: wsh_debug_sv.push(l_moduleName);
939: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
940: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
941: --
942: wsh_debug_sv.logmsg(l_moduleName,
943: '===========Complete Set of Input Deliveries===========');

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

936: --
937: IF l_debugOn THEN
938: wsh_debug_sv.push(l_moduleName);
939: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
940: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
941: --
942: wsh_debug_sv.logmsg(l_moduleName,
943: '===========Complete Set of Input Deliveries===========');
944: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;

Line 942: wsh_debug_sv.logmsg(l_moduleName,

938: wsh_debug_sv.push(l_moduleName);
939: wsh_debug_sv.log(l_moduleName, 'p_delIDTab.COUNT', p_DelivGrpRec.deliv_IDTab.COUNT);
940: wsh_debug_sv.log(l_moduleName, 'p_max_Delivs', p_DelivGrpRec.max_Delivs);
941: --
942: wsh_debug_sv.logmsg(l_moduleName,
943: '===========Complete Set of Input Deliveries===========');
944: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;
945: WHILE v_Index IS NOT NULL LOOP
946: --

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

943: '===========Complete Set of Input Deliveries===========');
944: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;
945: WHILE v_Index IS NOT NULL LOOP
946: --
947: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
948: wsh_debug_sv.log(l_moduleName, 'Delivery Id',
949: p_DelivGrpRec.deliv_IDTab(v_Index));
950: v_Index := p_DelivGrpRec.deliv_IDTab.NEXT(v_Index);
951: --

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

944: v_Index := p_DelivGrpRec.deliv_IDTab.FIRST;
945: WHILE v_Index IS NOT NULL LOOP
946: --
947: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
948: wsh_debug_sv.log(l_moduleName, 'Delivery Id',
949: p_DelivGrpRec.deliv_IDTab(v_Index));
950: v_Index := p_DelivGrpRec.deliv_IDTab.NEXT(v_Index);
951: --
952: END LOOP;

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

965: (i = p_DelivGrpRec.deliv_IDTab.COUNT) THEN
966: --{
967: IF l_debugOn THEN
968: --{
969: wsh_debug_sv.log(l_moduleName, '# of delivs. passed to AutoCreate_trip_multi',l_delivery_tab.COUNT);
970: wsh_debug_sv.logmsg(l_moduleName,
971: '========Deliveries passed to Autocreate Trip==========');
972: --
973: v_Index := l_delivery_tab.FIRST;

Line 970: wsh_debug_sv.logmsg(l_moduleName,

966: --{
967: IF l_debugOn THEN
968: --{
969: wsh_debug_sv.log(l_moduleName, '# of delivs. passed to AutoCreate_trip_multi',l_delivery_tab.COUNT);
970: wsh_debug_sv.logmsg(l_moduleName,
971: '========Deliveries passed to Autocreate Trip==========');
972: --
973: v_Index := l_delivery_tab.FIRST;
974: WHILE v_Index IS NOT NULL LOOP

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

972: --
973: v_Index := l_delivery_tab.FIRST;
974: WHILE v_Index IS NOT NULL LOOP
975: --
976: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
977: wsh_debug_sv.log(l_moduleName, 'Delivery Id', l_delivery_tab(v_Index));
978: v_Index := l_delivery_tab.NEXT(v_Index);
979: --
980: END LOOP;

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

973: v_Index := l_delivery_tab.FIRST;
974: WHILE v_Index IS NOT NULL LOOP
975: --
976: wsh_debug_sv.log(l_moduleName, 'Index', v_Index);
977: wsh_debug_sv.log(l_moduleName, 'Delivery Id', l_delivery_tab(v_Index));
978: v_Index := l_delivery_tab.NEXT(v_Index);
979: --
980: END LOOP;
981: --}

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

1002: --{
1003: x_delOutRec.result_id_tab(k):=l_trip_tab(m);
1004: --
1005: IF l_debugOn THEN
1006: wsh_debug_sv.log(l_moduleName, 'Index k', k);
1007: wsh_debug_sv.log(l_moduleName, 'Trip ID', x_delOutRec.result_id_tab(k));
1008: END IF;
1009: --
1010: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN

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

1003: x_delOutRec.result_id_tab(k):=l_trip_tab(m);
1004: --
1005: IF l_debugOn THEN
1006: wsh_debug_sv.log(l_moduleName, 'Index k', k);
1007: wsh_debug_sv.log(l_moduleName, 'Trip ID', x_delOutRec.result_id_tab(k));
1008: END IF;
1009: --
1010: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
1011: --{

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

1014: FETCH c_DeliveryCount INTO v_DelCount;
1015: CLOSE c_DeliveryCount;
1016: --
1017: IF l_debugOn THEN
1018: wsh_debug_sv.log(l_moduleName, 'v_DelCount', v_DelCount);
1019: END IF;
1020: --}
1021: ELSE
1022: v_DelCount := l_delivery_tab.COUNT;

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

1028: --}
1029: END LOOP;
1030: --
1031: IF l_debugOn THEN
1032: wsh_debug_sv.log(l_moduleName,'v_TotalDelCount', v_TotalDelCount);
1033: END IF;
1034: --
1035: j := 0;
1036: g_SuccDelivs := NVL(g_SuccDelivs,0) + v_TotalDelCount;

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

1039: v_TotalDelCount;
1040: l_delivery_tab.DELETE;
1041: --
1042: IF l_debugOn THEN
1043: wsh_debug_sv.log(l_moduleName, '# of trips until now', g_Trips);
1044: wsh_debug_sv.log(l_moduleName, '# of successful delivs until now', g_SuccDelivs);
1045: wsh_debug_sv.log(l_moduleName, '# of successful delivs in this batch', x_DelOutRec.num_success_Delivs);
1046: END IF;
1047: --}

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

1040: l_delivery_tab.DELETE;
1041: --
1042: IF l_debugOn THEN
1043: wsh_debug_sv.log(l_moduleName, '# of trips until now', g_Trips);
1044: wsh_debug_sv.log(l_moduleName, '# of successful delivs until now', g_SuccDelivs);
1045: wsh_debug_sv.log(l_moduleName, '# of successful delivs in this batch', x_DelOutRec.num_success_Delivs);
1046: END IF;
1047: --}
1048: EXCEPTION

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

1041: --
1042: IF l_debugOn THEN
1043: wsh_debug_sv.log(l_moduleName, '# of trips until now', g_Trips);
1044: wsh_debug_sv.log(l_moduleName, '# of successful delivs until now', g_SuccDelivs);
1045: wsh_debug_sv.log(l_moduleName, '# of successful delivs in this batch', x_DelOutRec.num_success_Delivs);
1046: END IF;
1047: --}
1048: EXCEPTION
1049: --{

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

1053: l_delivery_tab.DELETE;
1054: ROLLBACK TO Before_Autocreate_Trip;
1055: --
1056: IF l_debugOn THEN
1057: wsh_debug_sv.logmsg(l_moduleName, 'Expected Error for this set of deliveries');
1058: END IF;
1059: --
1060: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1061: --

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

1063: l_delivery_tab.DELETE;
1064: ROLLBACK TO Before_Autocreate_Trip;
1065: --
1066: IF l_debugOn THEN
1067: wsh_debug_sv.logmsg(l_moduleName, 'Unexpected Error for this set of deliveries');
1068: END IF;
1069: --}
1070: END;
1071: --}

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

1076: --}
1077: END LOOP;
1078: --
1079: IF l_debugOn THEN
1080: wsh_debug_Sv.log(l_moduleName, '# of calls to Autocreate Trip', v_numCalls);
1081: wsh_debug_sv.log(l_moduleName, '# errors from these calls', l_num_errors);
1082: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1083: END IF;
1084: --

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

1077: END LOOP;
1078: --
1079: IF l_debugOn THEN
1080: wsh_debug_Sv.log(l_moduleName, '# of calls to Autocreate Trip', v_numCalls);
1081: wsh_debug_sv.log(l_moduleName, '# errors from these calls', l_num_errors);
1082: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1083: END IF;
1084: --
1085: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN

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

1078: --
1079: IF l_debugOn THEN
1080: wsh_debug_Sv.log(l_moduleName, '# of calls to Autocreate Trip', v_numCalls);
1081: wsh_debug_sv.log(l_moduleName, '# errors from these calls', l_num_errors);
1082: wsh_debug_sv.log(l_moduleName, '# warnings from these calls', l_num_warnings);
1083: END IF;
1084: --
1085: IF l_num_errors > 0 AND l_num_errors = v_numCalls THEN
1086: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

1091: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1092: END IF;
1093: --
1094: IF l_debugOn THEN
1095: wsh_debug_sv.log(l_moduleName, 'x_return_status', x_return_status);
1096: wsh_debug_sv.pop(l_moduleName);
1097: END IF;
1098: --
1099: EXCEPTION

Line 1096: wsh_debug_sv.pop(l_moduleName);

1092: END IF;
1093: --
1094: IF l_debugOn THEN
1095: wsh_debug_sv.log(l_moduleName, 'x_return_status', x_return_status);
1096: wsh_debug_sv.pop(l_moduleName);
1097: END IF;
1098: --
1099: EXCEPTION
1100: --

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

1102: --
1103: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1104: --
1105: IF l_debugOn THEN
1106: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_ERROR');
1107: END IF;
1108: --
1109: RAISE;
1110: --

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

1112: --
1113: x_Return_Status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1114: --
1115: IF l_debugOn THEN
1116: wsh_debug_sv.pop(l_moduleName || ' - FND_API.G_EXC_UNEXPECTED_ERROR');
1117: END IF;
1118: --
1119: RAISE;
1120: --

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

1124: --
1125: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.GroupDelivsIntoTrips');
1126: --
1127: IF l_debugOn THEN
1128: wsh_Debug_sv.logmsg(l_moduleName, 'Unexpected error in GroupDelivsIntoTrips' || SQLERRM);
1129: wsh_debug_sv.pop(l_moduleName);
1130: END IF;
1131: --
1132: RAISE;

Line 1129: wsh_debug_sv.pop(l_moduleName);

1125: wsh_util_core.default_handler('WSH_TRIP_CONSOLIDATION.GroupDelivsIntoTrips');
1126: --
1127: IF l_debugOn THEN
1128: wsh_Debug_sv.logmsg(l_moduleName, 'Unexpected error in GroupDelivsIntoTrips' || SQLERRM);
1129: wsh_debug_sv.pop(l_moduleName);
1130: END IF;
1131: --
1132: RAISE;
1133: --