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

Line 62: l_debug_on := wsh_debug_sv.is_debug_enabled;

58: --
59: l_debug_on := wsh_debug_interface.g_debug;
60: --
61: IF l_debug_on IS NULL THEN
62: l_debug_on := wsh_debug_sv.is_debug_enabled;
63: END IF;
64: --
65: IF l_debug_on THEN
66: wsh_debug_sv.push(l_module_name);

Line 66: wsh_debug_sv.push(l_module_name);

62: l_debug_on := wsh_debug_sv.is_debug_enabled;
63: END IF;
64: --
65: IF l_debug_on THEN
66: wsh_debug_sv.push(l_module_name);
67: wsh_debug_sv.log(l_module_name, 'p_delivery_rec name',
68: p_delivery_rec.entity_name);
69: wsh_debug_sv.log(l_module_name, 'p_delivery_rec id',
70: p_delivery_rec.entity_id);

Line 67: wsh_debug_sv.log(l_module_name, 'p_delivery_rec name',

63: END IF;
64: --
65: IF l_debug_on THEN
66: wsh_debug_sv.push(l_module_name);
67: wsh_debug_sv.log(l_module_name, 'p_delivery_rec name',
68: p_delivery_rec.entity_name);
69: wsh_debug_sv.log(l_module_name, 'p_delivery_rec id',
70: p_delivery_rec.entity_id);
71: wsh_debug_sv.log(l_module_name, 'p_content_weight',

Line 69: wsh_debug_sv.log(l_module_name, 'p_delivery_rec id',

65: IF l_debug_on THEN
66: wsh_debug_sv.push(l_module_name);
67: wsh_debug_sv.log(l_module_name, 'p_delivery_rec name',
68: p_delivery_rec.entity_name);
69: wsh_debug_sv.log(l_module_name, 'p_delivery_rec id',
70: p_delivery_rec.entity_id);
71: wsh_debug_sv.log(l_module_name, 'p_content_weight',
72: p_content_weight);
73: wsh_debug_sv.log(l_module_name, 'p_weight_limit',

Line 71: wsh_debug_sv.log(l_module_name, 'p_content_weight',

67: wsh_debug_sv.log(l_module_name, 'p_delivery_rec name',
68: p_delivery_rec.entity_name);
69: wsh_debug_sv.log(l_module_name, 'p_delivery_rec id',
70: p_delivery_rec.entity_id);
71: wsh_debug_sv.log(l_module_name, 'p_content_weight',
72: p_content_weight);
73: wsh_debug_sv.log(l_module_name, 'p_weight_limit',
74: p_weight_limit);
75: wsh_debug_sv.log(l_module_name, 'p_new_delivery_name',

Line 73: wsh_debug_sv.log(l_module_name, 'p_weight_limit',

69: wsh_debug_sv.log(l_module_name, 'p_delivery_rec id',
70: p_delivery_rec.entity_id);
71: wsh_debug_sv.log(l_module_name, 'p_content_weight',
72: p_content_weight);
73: wsh_debug_sv.log(l_module_name, 'p_weight_limit',
74: p_weight_limit);
75: wsh_debug_sv.log(l_module_name, 'p_new_delivery_name',
76: p_new_delivery_name);
77: wsh_debug_sv.log(l_module_name, 'p_new_delivery_id',

Line 75: wsh_debug_sv.log(l_module_name, 'p_new_delivery_name',

71: wsh_debug_sv.log(l_module_name, 'p_content_weight',
72: p_content_weight);
73: wsh_debug_sv.log(l_module_name, 'p_weight_limit',
74: p_weight_limit);
75: wsh_debug_sv.log(l_module_name, 'p_new_delivery_name',
76: p_new_delivery_name);
77: wsh_debug_sv.log(l_module_name, 'p_new_delivery_id',
78: p_new_delivery_id);
79: wsh_debug_sv.log(l_module_name, 'p_exception_message',

Line 77: wsh_debug_sv.log(l_module_name, 'p_new_delivery_id',

73: wsh_debug_sv.log(l_module_name, 'p_weight_limit',
74: p_weight_limit);
75: wsh_debug_sv.log(l_module_name, 'p_new_delivery_name',
76: p_new_delivery_name);
77: wsh_debug_sv.log(l_module_name, 'p_new_delivery_id',
78: p_new_delivery_id);
79: wsh_debug_sv.log(l_module_name, 'p_exception_message',
80: p_exception_message);
81: wsh_debug_sv.log(l_module_name, 'p_exception_name',

Line 79: wsh_debug_sv.log(l_module_name, 'p_exception_message',

75: wsh_debug_sv.log(l_module_name, 'p_new_delivery_name',
76: p_new_delivery_name);
77: wsh_debug_sv.log(l_module_name, 'p_new_delivery_id',
78: p_new_delivery_id);
79: wsh_debug_sv.log(l_module_name, 'p_exception_message',
80: p_exception_message);
81: wsh_debug_sv.log(l_module_name, 'p_exception_name',
82: p_exception_name);
83:

Line 81: wsh_debug_sv.log(l_module_name, 'p_exception_name',

77: wsh_debug_sv.log(l_module_name, 'p_new_delivery_id',
78: p_new_delivery_id);
79: wsh_debug_sv.log(l_module_name, 'p_exception_message',
80: p_exception_message);
81: wsh_debug_sv.log(l_module_name, 'p_exception_name',
82: p_exception_name);
83:
84: END IF;
85:

Line 92: WSH_DEBUG_SV.logmsg(l_module_name, 'exception name or delivery id is NULL');

88: l_num_warn := 0;
89:
90: IF (p_exception_name IS NULL OR p_delivery_rec.entity_id IS NULL) THEN
91: IF l_debug_on THEN
92: WSH_DEBUG_SV.logmsg(l_module_name, 'exception name or delivery id is NULL');
93: END IF;
94: RAISE unexp_error;
95: END IF;
96:

Line 138: WSH_DEBUG_SV.logmsg(l_module_name, 'exception message is not provided for WSH_OTM_DEL_SPLIT_LARGE or WSH_OTM_DEL_SPLIT');

134: ELSIF (p_exception_name IN ('WSH_OTM_DEL_SPLIT_LARGE', 'WSH_OTM_DEL_SPLIT')) THEN
135: --the caller API (which is in this file since this is internal api) should provide the
136: --message for these two exceptions due to complication, this is not expected
137: IF l_debug_on THEN
138: WSH_DEBUG_SV.logmsg(l_module_name, 'exception message is not provided for WSH_OTM_DEL_SPLIT_LARGE or WSH_OTM_DEL_SPLIT');
139: END IF;
140: RAISE unexp_error;
141: END IF;
142:

Line 149: WSH_DEBUG_SV.logmsg(l_module_name, 'exception message is NULL');

145: END IF;
146:
147: IF (l_exception_message IS NULL) THEN
148: IF l_debug_on THEN
149: WSH_DEBUG_SV.logmsg(l_module_name, 'exception message is NULL');
150: END IF;
151: RAISE unexp_error;
152: END IF;
153:

Line 157: WSH_DEBUG_SV.logmsg(l_module_name,

153:
154: l_exception_id := NULL;
155:
156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,
158: 'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',
159: WSH_DEBUG_SV.C_PROC_LEVEL);
160: END IF;
161:

Line 159: WSH_DEBUG_SV.C_PROC_LEVEL);

155:
156: IF l_debug_on THEN
157: WSH_DEBUG_SV.logmsg(l_module_name,
158: 'Calling program unit WSH_XC_UTIL.LOG_EXCEPTION',
159: WSH_DEBUG_SV.C_PROC_LEVEL);
160: END IF;
161:
162: WSH_XC_UTIL.log_exception(
163: p_api_version => 1.0,

Line 177: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);

173: p_delivery_id => l_delivery_id,
174: p_message => SUBSTRB(l_exception_message,1,2000));
175:
176: IF l_debug_on THEN
177: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_XC_UTIL.log_exception: ' || l_return_status);
178: END IF;
179:
180: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
181: l_num_error := l_num_error+1;

Line 197: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);

193: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
194: END IF;
195:
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
198: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
199: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;

Line 198: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);

194: END IF;
195:
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
198: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
199: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202:

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

195:
196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
198: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
199: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202:
203: EXCEPTION

Line 200: WSH_DEBUG_SV.pop(l_module_name);

196: IF l_debug_on THEN
197: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
198: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
199: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
200: WSH_DEBUG_SV.pop(l_module_name);
201: END IF;
202:
203: EXCEPTION
204: WHEN OTHERS THEN

Line 211: WSH_DEBUG_SV.logmsg(l_module_name,

207:
208: WSH_UTIL_CORE.default_handler(
209: 'WSH_DELIVERY_SPLITTER_PKG.LOG_DEL_SPLITTER_EXCEPTION', l_module_name);
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.logmsg(l_module_name,
212: 'Unexpected error has occured. Oracle error message is '||
213: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
215: END IF;

Line 213: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

209: 'WSH_DELIVERY_SPLITTER_PKG.LOG_DEL_SPLITTER_EXCEPTION', l_module_name);
210: IF l_debug_on THEN
211: WSH_DEBUG_SV.logmsg(l_module_name,
212: 'Unexpected error has occured. Oracle error message is '||
213: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
215: END IF;
216:
217: END LOG_DEL_SPLITTER_EXCEPTION;

Line 214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

210: IF l_debug_on THEN
211: WSH_DEBUG_SV.logmsg(l_module_name,
212: 'Unexpected error has occured. Oracle error message is '||
213: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
214: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
215: END IF;
216:
217: END LOG_DEL_SPLITTER_EXCEPTION;
218:

Line 332: l_debug_on := wsh_debug_sv.is_debug_enabled;

328: --
329: l_debug_on := wsh_debug_interface.g_debug;
330: --
331: IF l_debug_on IS NULL THEN
332: l_debug_on := wsh_debug_sv.is_debug_enabled;
333: END IF;
334: --
335: IF l_debug_on THEN
336: wsh_debug_sv.push(l_module_name);

Line 336: wsh_debug_sv.push(l_module_name);

332: l_debug_on := wsh_debug_sv.is_debug_enabled;
333: END IF;
334: --
335: IF l_debug_on THEN
336: wsh_debug_sv.push(l_module_name);
337: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.COUNT:',
338: p_delivery_tab.count);
339: wsh_debug_sv.log(l_module_name, 'p_autosplit_flag',
340: p_autosplit_flag);

Line 337: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.COUNT:',

333: END IF;
334: --
335: IF l_debug_on THEN
336: wsh_debug_sv.push(l_module_name);
337: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.COUNT:',
338: p_delivery_tab.count);
339: wsh_debug_sv.log(l_module_name, 'p_autosplit_flag',
340: p_autosplit_flag);
341: END IF;

Line 339: wsh_debug_sv.log(l_module_name, 'p_autosplit_flag',

335: IF l_debug_on THEN
336: wsh_debug_sv.push(l_module_name);
337: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.COUNT:',
338: p_delivery_tab.count);
339: wsh_debug_sv.log(l_module_name, 'p_autosplit_flag',
340: p_autosplit_flag);
341: END IF;
342: --
343: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 358: WSH_DEBUG_SV.logmsg(l_module_name,'there is no delivery to split');

354: l_exception_name := NULL;
355:
356: IF (p_delivery_tab.COUNT = 0) THEN
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.logmsg(l_module_name,'there is no delivery to split');
359: WSH_DEBUG_SV.pop(l_module_name);
360: END IF;
361: RETURN;
362: END IF;

Line 359: WSH_DEBUG_SV.pop(l_module_name);

355:
356: IF (p_delivery_tab.COUNT = 0) THEN
357: IF l_debug_on THEN
358: WSH_DEBUG_SV.logmsg(l_module_name,'there is no delivery to split');
359: WSH_DEBUG_SV.pop(l_module_name);
360: END IF;
361: RETURN;
362: END IF;
363:

Line 367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);

363:
364: l_action_prms.caller := 'WSH_DELIVERY_SPLITTER';
365:
366: IF l_debug_on THEN
367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters',WSH_DEBUG_SV.C_PROC_LEVEL);
368: END IF;
369:
370: WSH_SHIPPING_PARAMS_PVT.get_global_parameters(
371: x_param_info => l_global_param_info,

Line 375: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);

371: x_param_info => l_global_param_info,
372: x_return_status => l_return_status);
373:
374: IF l_debug_on THEN
375: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get_Global_Parameters: ' || l_return_status);
376: END IF;
377:
378: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
379: l_num_warn := l_num_warn + 1;

Line 388: WSH_DEBUG_SV.pop(l_module_name);

384:
385: x_return_status := l_return_status;
386: --
387: IF l_debug_on THEN
388: WSH_DEBUG_SV.pop(l_module_name);
389: END IF;
390: RETURN;
391: END IF;
392:

Line 399: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.entity_id',

395: --looping over all the deliveries to process each one for splitting
396: WHILE i IS NOT NULL LOOP
397:
398: IF l_debug_on THEN
399: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.entity_id',
400: p_delivery_tab(i).entity_id);
401: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.entity_name',
402: p_delivery_tab(i).entity_name);
403: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.item_id',

Line 401: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.entity_name',

397:
398: IF l_debug_on THEN
399: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.entity_id',
400: p_delivery_tab(i).entity_id);
401: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.entity_name',
402: p_delivery_tab(i).entity_name);
403: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.item_id',
404: p_delivery_tab(i).item_id);
405: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.net_weight',

Line 403: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.item_id',

399: wsh_debug_sv.log(l_module_name, 'P_DELIVERY_TAB.entity_id',
400: p_delivery_tab(i).entity_id);
401: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.entity_name',
402: p_delivery_tab(i).entity_name);
403: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.item_id',
404: p_delivery_tab(i).item_id);
405: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.net_weight',
406: p_delivery_tab(i).net_weight);
407: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.gross_weight',

Line 405: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.net_weight',

401: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.entity_name',
402: p_delivery_tab(i).entity_name);
403: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.item_id',
404: p_delivery_tab(i).item_id);
405: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.net_weight',
406: p_delivery_tab(i).net_weight);
407: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.gross_weight',
408: p_delivery_tab(i).gross_weight);
409: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.organization_id',

Line 407: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.gross_weight',

403: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.item_id',
404: p_delivery_tab(i).item_id);
405: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.net_weight',
406: p_delivery_tab(i).net_weight);
407: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.gross_weight',
408: p_delivery_tab(i).gross_weight);
409: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.organization_id',
410: p_delivery_tab(i).organization_id);
411: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.weight_uom',

Line 409: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.organization_id',

405: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.net_weight',
406: p_delivery_tab(i).net_weight);
407: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.gross_weight',
408: p_delivery_tab(i).gross_weight);
409: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.organization_id',
410: p_delivery_tab(i).organization_id);
411: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.weight_uom',
412: p_delivery_tab(i).weight_uom);
413: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.quantity',

Line 411: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.weight_uom',

407: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.gross_weight',
408: p_delivery_tab(i).gross_weight);
409: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.organization_id',
410: p_delivery_tab(i).organization_id);
411: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.weight_uom',
412: p_delivery_tab(i).weight_uom);
413: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.quantity',
414: p_delivery_tab(i).quantity);
415: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.init_pickup_loc_id',

Line 413: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.quantity',

409: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.organization_id',
410: p_delivery_tab(i).organization_id);
411: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.weight_uom',
412: p_delivery_tab(i).weight_uom);
413: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.quantity',
414: p_delivery_tab(i).quantity);
415: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.init_pickup_loc_id',
416: p_delivery_tab(i).init_pickup_loc_id);
417: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.content_firm',

Line 415: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.init_pickup_loc_id',

411: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.weight_uom',
412: p_delivery_tab(i).weight_uom);
413: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.quantity',
414: p_delivery_tab(i).quantity);
415: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.init_pickup_loc_id',
416: p_delivery_tab(i).init_pickup_loc_id);
417: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.content_firm',
418: p_delivery_tab(i).content_firm);
419: END IF;

Line 417: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.content_firm',

413: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.quantity',
414: p_delivery_tab(i).quantity);
415: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.init_pickup_loc_id',
416: p_delivery_tab(i).init_pickup_loc_id);
417: wsh_debug_sv.log(l_module_name, 'p_delivery_tab.content_firm',
418: p_delivery_tab(i).content_firm);
419: END IF;
420:
421:

Line 428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);

424: --so adding this first query to bypass all the DELETE_REQUIRED deliveries
425:
426: --get delivery information
427: IF l_debug_on THEN
428: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
429: END IF;
430:
431: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,
432: x_delivery_rec => l_delivery_info,

Line 436: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);

432: x_delivery_rec => l_delivery_info,
433: x_return_status => l_return_status);
434:
435: IF l_debug_on THEN
436: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
437: END IF;
438:
439: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
440: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 444: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get delivery record');

440: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
441:
442: --reject failed delivery
443: IF l_debug_on THEN
444: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get delivery record');
445: END IF;
446:
447: l_num_error := l_num_error + 1;
448: x_rejected_del_id.EXTEND;

Line 463: wsh_debug_sv.logmsg(l_module_name, 'accepted delivery ' || p_delivery_tab(i).entity_id || ' because ignore for planning, DR or DP status');

459: l_delivery_info.tms_interface_flag = WSH_NEW_DELIVERIES_PVT.C_TMS_DELETE_IN_PROCESS ) THEN
460:
461:
462: IF l_debug_on THEN
463: wsh_debug_sv.logmsg(l_module_name, 'accepted delivery ' || p_delivery_tab(i).entity_id || ' because ignore for planning, DR or DP status');
464: END IF;
465: x_accepted_del_id.EXTEND;
466: x_accepted_del_id(x_accepted_del_id.COUNT) := p_delivery_tab(i).entity_id;
467:

Line 477: WSH_DEBUG_SV.logmsg(l_module_name,

473: SAVEPOINT delivery_record;
474:
475: --LOCK THE DELIVERY AND IT'S CONTENT
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,
478: 'Calling program unit WSH_INTERFACE_COMMON_ACTIONS.LOCK_DELIVERY_AND_DETAILS',
479: WSH_DEBUG_SV.C_PROC_LEVEL);
480: END IF;
481:

Line 479: WSH_DEBUG_SV.C_PROC_LEVEL);

475: --LOCK THE DELIVERY AND IT'S CONTENT
476: IF l_debug_on THEN
477: WSH_DEBUG_SV.logmsg(l_module_name,
478: 'Calling program unit WSH_INTERFACE_COMMON_ACTIONS.LOCK_DELIVERY_AND_DETAILS',
479: WSH_DEBUG_SV.C_PROC_LEVEL);
480: END IF;
481:
482: WSH_INTERFACE_COMMON_ACTIONS.lock_delivery_and_details(
483: p_delivery_id => p_delivery_tab(i).entity_id,

Line 487: wsh_debug_sv.log (l_module_name,

483: p_delivery_id => p_delivery_tab(i).entity_id,
484: x_return_status => l_return_status);
485:
486: IF l_debug_on THEN
487: wsh_debug_sv.log (l_module_name,
488: 'Return status from lock delivery and details',
489: l_return_status);
490: END IF;
491:

Line 496: wsh_debug_sv.logmsg(l_module_name,

492: --only locking one delivery, should have no warning status for l_return_status
493: IF (l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
494:
495: IF l_debug_on THEN
496: wsh_debug_sv.logmsg(l_module_name,
497: 'Unable to lock the delivery');
498: END IF;
499:
500: l_num_error := l_num_error+1;

Line 503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

499:
500: l_num_error := l_num_error+1;
501:
502: IF l_debug_on THEN
503: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
504: END IF;
505:
506: log_del_splitter_exception
507: (p_delivery_rec => p_delivery_tab(i),

Line 514: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

510: p_exception_name => 'WSH_OTM_DEL_LOCK_FAIL',
511: x_return_status => l_return_status);
512:
513: IF l_debug_on THEN
514: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
515: END IF;
516:
517: x_rejected_del_id.EXTEND;
518: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;

Line 525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);

521: END IF;
522:
523: --get delivery information again to ensure it's latest
524: IF l_debug_on THEN
525: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_VALIDATIONS.get_delivery_information',WSH_DEBUG_SV.C_PROC_LEVEL);
526: END IF;
527:
528: WSH_DELIVERY_VALIDATIONS.get_delivery_information(p_delivery_id => p_delivery_tab(i).entity_id,
529: x_delivery_rec => l_delivery_info,

Line 533: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);

529: x_delivery_rec => l_delivery_info,
530: x_return_status => l_return_status);
531:
532: IF l_debug_on THEN
533: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_VALIDATIONS.get_delivery_information: ' || l_return_status);
534: END IF;
535:
536: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR,
537: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN

Line 543: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get delivery record');

539: ROLLBACK TO delivery_record;
540:
541: --reject failed delivery
542: IF l_debug_on THEN
543: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get delivery record');
544: END IF;
545:
546: l_num_error := l_num_error + 1;
547: x_rejected_del_id.EXTEND;

Line 555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);

551: l_num_warn := l_num_warn + 1;
552: END IF;
553:
554: IF l_debug_on THEN
555: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_SHIPPING_PARAMS_PVT.Get',WSH_DEBUG_SV.C_PROC_LEVEL);
556: END IF;
557:
558: --get shipping parameters
559: WSH_SHIPPING_PARAMS_PVT.get(

Line 565: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);

561: x_param_info => l_parameter_info,
562: x_return_status => l_return_status);
563:
564: IF l_debug_on THEN
565: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_SHIPPING_PARAMS_PVT.Get: ' || l_return_status);
566: END IF;
567:
568: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
569: l_num_warn := l_num_warn + 1;

Line 581: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get shipping parameter info');

577: wsh_util_core.add_message(l_return_status,l_module_name);
578: l_num_error := l_num_error+1;
579:
580: IF l_debug_on THEN
581: wsh_debug_sv.logmsg(l_module_name, 'Error: cannot get shipping parameter info');
582: END IF;
583:
584: x_rejected_del_id.EXTEND;
585: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;

Line 591: wsh_debug_sv.log(l_module_name,

587: GOTO loop_end;
588: END IF;
589:
590: IF l_debug_on THEN
591: wsh_debug_sv.log(l_module_name,
592: 'Max Gross Weight',
593: l_parameter_info.max_gross_weight);
594: wsh_debug_sv.log(l_module_name,
595: 'Global UOM',

Line 594: wsh_debug_sv.log(l_module_name,

590: IF l_debug_on THEN
591: wsh_debug_sv.log(l_module_name,
592: 'Max Gross Weight',
593: l_parameter_info.max_gross_weight);
594: wsh_debug_sv.log(l_module_name,
595: 'Global UOM',
596: l_global_param_info.GU_WEIGHT_UOM);
597: wsh_debug_sv.log(l_module_name,
598: 'delivery gross weight',

Line 597: wsh_debug_sv.log(l_module_name,

593: l_parameter_info.max_gross_weight);
594: wsh_debug_sv.log(l_module_name,
595: 'Global UOM',
596: l_global_param_info.GU_WEIGHT_UOM);
597: wsh_debug_sv.log(l_module_name,
598: 'delivery gross weight',
599: p_delivery_tab(i).gross_weight);
600: END IF;
601:

Line 606: wsh_debug_sv.logmsg(l_module_name,

602: --if no limit specified in shipping parameter, accept it all
603: IF (l_parameter_info.MAX_GROSS_WEIGHT IS NULL) THEN
604:
605: IF l_debug_on THEN
606: wsh_debug_sv.logmsg(l_module_name,
607: 'Gross Weight IS NULL');
608: END IF;
609:
610: x_accepted_del_id.EXTEND;

Line 622: wsh_debug_sv.logmsg(l_module_name,

618: IF (p_delivery_tab(i).weight_uom IS NULL OR l_global_param_info.GU_WEIGHT_UOM IS NULL) THEN
619: ROLLBACK TO delivery_record;
620:
621: IF l_debug_on THEN
622: wsh_debug_sv.logmsg(l_module_name,
623: 'Weight UOM IS NULL');
624: END IF;
625:
626: IF l_debug_on THEN

Line 627: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

623: 'Weight UOM IS NULL');
624: END IF;
625:
626: IF l_debug_on THEN
627: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
628: END IF;
629:
630: log_del_splitter_exception
631: (p_delivery_rec => p_delivery_tab(i),

Line 638: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

634: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
635: x_return_status => l_return_status);
636:
637: IF l_debug_on THEN
638: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
639: END IF;
640:
641: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
642: l_num_error := l_num_error+1;

Line 682: wsh_debug_sv.log(l_module_name,

678: BULK COLLECT INTO l_line_and_container_weight,
679: l_line_and_container_id;
680:
681: IF l_debug_on THEN
682: wsh_debug_sv.log(l_module_name,
683: 'l_line_and_container_weight.count:',
684: l_line_and_container_weight.count);
685: wsh_debug_sv.log(l_module_name,
686: 'l_line_and_container_id.count:',

Line 685: wsh_debug_sv.log(l_module_name,

681: IF l_debug_on THEN
682: wsh_debug_sv.log(l_module_name,
683: 'l_line_and_container_weight.count:',
684: l_line_and_container_weight.count);
685: wsh_debug_sv.log(l_module_name,
686: 'l_line_and_container_id.count:',
687: l_line_and_container_id.count);
688: wsh_debug_sv.log(l_module_name,
689: 'wv_frozen_flag:',

Line 688: wsh_debug_sv.log(l_module_name,

684: l_line_and_container_weight.count);
685: wsh_debug_sv.log(l_module_name,
686: 'l_line_and_container_id.count:',
687: l_line_and_container_id.count);
688: wsh_debug_sv.log(l_module_name,
689: 'wv_frozen_flag:',
690: l_delivery_info.wv_frozen_flag);
691: END IF;
692:

Line 705: wsh_debug_sv.log(l_module_name, 'z', z);

701:
702: l_content_weight := l_content_weight + l_line_and_container_weight(z);
703:
704: IF l_debug_on THEN
705: wsh_debug_sv.log(l_module_name, 'z', z);
706: wsh_debug_sv.log(l_module_name, 'l_content_weight', l_content_weight);
707: END IF;
708:
709: z:= l_line_and_container_weight.NEXT(z);

Line 706: wsh_debug_sv.log(l_module_name, 'l_content_weight', l_content_weight);

702: l_content_weight := l_content_weight + l_line_and_container_weight(z);
703:
704: IF l_debug_on THEN
705: wsh_debug_sv.log(l_module_name, 'z', z);
706: wsh_debug_sv.log(l_module_name, 'l_content_weight', l_content_weight);
707: END IF;
708:
709: z:= l_line_and_container_weight.NEXT(z);
710:

Line 716: wsh_debug_sv.log(l_module_name,

712: END IF;
713: CLOSE c_get_delivery_line_and_cont;
714:
715: IF l_debug_on THEN
716: wsh_debug_sv.log(l_module_name,
717: 'Converted Max Gross Weight',
718: l_parameter_info.max_gross_weight);
719: wsh_debug_sv.log(l_module_name,
720: 'delivery content weight sum',

Line 719: wsh_debug_sv.log(l_module_name,

715: IF l_debug_on THEN
716: wsh_debug_sv.log(l_module_name,
717: 'Converted Max Gross Weight',
718: l_parameter_info.max_gross_weight);
719: wsh_debug_sv.log(l_module_name,
720: 'delivery content weight sum',
721: l_content_weight);
722: END IF;
723: END IF;

Line 741: wsh_debug_sv.logmsg(l_module_name,

737:
738: ROLLBACK TO delivery_record;
739:
740: IF l_debug_on THEN
741: wsh_debug_sv.logmsg(l_module_name,
742: 'Autosplit flag is off but delivery weight or delivery detail weight sum is over the weight limits');
743: END IF;
744:
745: IF l_debug_on THEN

Line 746: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

742: 'Autosplit flag is off but delivery weight or delivery detail weight sum is over the weight limits');
743: END IF;
744:
745: IF l_debug_on THEN
746: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
747: END IF;
748:
749: log_del_splitter_exception
750: (p_delivery_rec => p_delivery_tab(i),

Line 757: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

753: p_exception_name => 'WSH_OTM_DEL_OVERSIZED',
754: x_return_status => l_return_status);
755:
756: IF l_debug_on THEN
757: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
758: END IF;
759:
760: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
761: l_num_error := l_num_error+1;

Line 782: wsh_debug_sv.logmsg(l_module_name,

778:
779: ROLLBACK TO delivery_record;
780:
781: IF l_debug_on THEN
782: wsh_debug_sv.logmsg(l_module_name,
783: 'Content Weight sum does not equal delivery gross weight');
784: END IF;
785:
786: IF l_debug_on THEN

Line 787: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

783: 'Content Weight sum does not equal delivery gross weight');
784: END IF;
785:
786: IF l_debug_on THEN
787: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
788: END IF;
789:
790: log_del_splitter_exception
791: (p_delivery_rec => p_delivery_tab(i),

Line 798: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

794: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
795: x_return_status => l_return_status);
796:
797: IF l_debug_on THEN
798: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
799: END IF;
800:
801: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
802: l_num_error := l_num_error+1;

Line 818: wsh_debug_sv.logmsg(l_module_name,

814:
815: ROLLBACK TO delivery_record;
816:
817: IF l_debug_on THEN
818: wsh_debug_sv.logmsg(l_module_name,
819: 'Delivery is content firm');
820: END IF;
821:
822: IF l_debug_on THEN

Line 823: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

819: 'Delivery is content firm');
820: END IF;
821:
822: IF l_debug_on THEN
823: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
824: END IF;
825:
826: log_del_splitter_exception
827: (p_delivery_rec => p_delivery_tab(i),

Line 834: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

830: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
831: x_return_status => l_return_status);
832:
833: IF l_debug_on THEN
834: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
835: END IF;
836:
837: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
838: l_num_error := l_num_error+1;

Line 855: wsh_debug_sv.logmsg(l_module_name,

851:
852: ROLLBACK TO delivery_record;
853:
854: IF l_debug_on THEN
855: wsh_debug_sv.logmsg(l_module_name,
856: 'Delivery line weight greater than the gross weight limit');
857: END IF;
858:
859: IF l_debug_on THEN

Line 860: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

856: 'Delivery line weight greater than the gross weight limit');
857: END IF;
858:
859: IF l_debug_on THEN
860: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
861: END IF;
862:
863: log_del_splitter_exception
864: (p_delivery_rec => p_delivery_tab(i),

Line 871: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

867: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
868: x_return_status => l_return_status);
869:
870: IF l_debug_on THEN
871: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
872: END IF;
873:
874: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
875: l_num_error := l_num_error+1;

Line 896: wsh_debug_sv.logmsg(l_module_name,

892:
893: ROLLBACK TO delivery_record;
894:
895: IF l_debug_on THEN
896: wsh_debug_sv.logmsg(l_module_name,
897: 'Delivery is assigned to trip');
898: END IF;
899:
900: IF l_debug_on THEN

Line 901: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

897: 'Delivery is assigned to trip');
898: END IF;
899:
900: IF l_debug_on THEN
901: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
902: END IF;
903:
904: log_del_splitter_exception
905: (p_delivery_rec => p_delivery_tab(i),

Line 912: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

908: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
909: x_return_status => l_return_status);
910:
911: IF l_debug_on THEN
912: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
913: END IF;
914:
915: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
916: l_num_error := l_num_error+1;

Line 934: wsh_debug_sv.log(l_module_name, 'l_line_status count', l_line_status.COUNT);

930: FETCH c_get_delivery_line BULK COLLECT INTO l_line_status;
931: CLOSE c_get_delivery_line;
932:
933: IF l_debug_on THEN
934: wsh_debug_sv.log(l_module_name, 'l_line_status count', l_line_status.COUNT);
935: END IF;
936:
937: IF (l_line_status.COUNT > 0) THEN
938:

Line 942: wsh_debug_sv.logmsg(l_module_name,

938:
939: ROLLBACK TO delivery_record;
940:
941: IF l_debug_on THEN
942: wsh_debug_sv.logmsg(l_module_name,
943: 'Delivery line is pick released or pick confirmed.');
944: END IF;
945:
946: IF l_debug_on THEN

Line 947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

943: 'Delivery line is pick released or pick confirmed.');
944: END IF;
945:
946: IF l_debug_on THEN
947: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
948: END IF;
949:
950: log_del_splitter_exception
951: (p_delivery_rec => p_delivery_tab(i),

Line 958: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

954: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
955: x_return_status => l_return_status);
956:
957: IF l_debug_on THEN
958: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
959: END IF;
960:
961: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
962: l_num_error := l_num_error+1;

Line 1001: WSH_DEBUG_SV.logmsg(l_module_name,

997:
998: END LOOP;
999:
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name,
1002: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Unassign_multiple_details',
1003: WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005:

Line 1003: WSH_DEBUG_SV.C_PROC_LEVEL);

999:
1000: IF l_debug_on THEN
1001: WSH_DEBUG_SV.logmsg(l_module_name,
1002: 'Calling program unit WSH_DELIVERY_DETAILS_ACTIONS.Unassign_multiple_details',
1003: WSH_DEBUG_SV.C_PROC_LEVEL);
1004: END IF;
1005:
1006: WSH_DELIVERY_DETAILS_ACTIONS.unassign_multiple_details(
1007: p_rec_of_detail_ids => l_temp_ids,

Line 1014: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS: ' || l_return_status);

1010: p_action_prms => l_action_prms,
1011: x_return_status => l_return_status);
1012:
1013: IF l_debug_on THEN
1014: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_ACTIONS.UNASSIGN_MULTIPLE_DETAILS: ' || l_return_status);
1015: END IF;
1016:
1017: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1018:

Line 1025: wsh_debug_sv.logmsg(l_module_name, 'Error during unassign delivery details');

1021: l_num_error := l_num_error+1;
1022:
1023: --reject failed delivery
1024: IF l_debug_on THEN
1025: wsh_debug_sv.logmsg(l_module_name, 'Error during unassign delivery details');
1026: END IF;
1027:
1028: IF l_debug_on THEN
1029: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1029: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

1025: wsh_debug_sv.logmsg(l_module_name, 'Error during unassign delivery details');
1026: END IF;
1027:
1028: IF l_debug_on THEN
1029: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1030: END IF;
1031:
1032: log_del_splitter_exception
1033: (p_delivery_rec => p_delivery_tab(i),

Line 1040: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

1036: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
1037: x_return_status => l_return_status);
1038:
1039: IF l_debug_on THEN
1040: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1041: END IF;
1042:
1043: x_rejected_del_id.EXTEND;
1044: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;

Line 1074: WSH_DEBUG_SV.logmsg(l_module_name,

1070:
1071: l_temp_ids.DELETE;
1072:
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.logmsg(l_module_name,
1075: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1076: WSH_DEBUG_SV.C_PROC_LEVEL);
1077: END IF;
1078:

Line 1076: WSH_DEBUG_SV.C_PROC_LEVEL);

1072:
1073: IF l_debug_on THEN
1074: WSH_DEBUG_SV.logmsg(l_module_name,
1075: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1076: WSH_DEBUG_SV.C_PROC_LEVEL);
1077: END IF;
1078:
1079: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(
1080: p_api_version_number => 1.0,

Line 1092: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);

1088: p_group_by_header_flag => 'N',
1089: x_del_rows => l_temp_ids);
1090:
1091: IF l_debug_on THEN
1092: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);
1093: END IF;
1094:
1095: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1096:

Line 1102: wsh_debug_sv.logmsg(l_module_name, 'Error during autocreate delivery');

1098:
1099: l_num_error := l_num_error+1;
1100: --reject failed delivery
1101: IF l_debug_on THEN
1102: wsh_debug_sv.logmsg(l_module_name, 'Error during autocreate delivery');
1103: END IF;
1104:
1105: IF l_debug_on THEN
1106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

1102: wsh_debug_sv.logmsg(l_module_name, 'Error during autocreate delivery');
1103: END IF;
1104:
1105: IF l_debug_on THEN
1106: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1107: END IF;
1108:
1109: log_del_splitter_exception
1110: (p_delivery_rec => p_delivery_tab(i),

Line 1117: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

1113: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
1114: x_return_status => l_return_status);
1115:
1116: IF l_debug_on THEN
1117: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1118: END IF;
1119:
1120: x_rejected_del_id.EXTEND;
1121: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;

Line 1136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

1132: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery
1133:
1134: --logging tms exception for the new delivery
1135: IF l_debug_on THEN
1136: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1137: END IF;
1138:
1139: log_del_splitter_exception
1140: (p_delivery_rec => p_delivery_tab(i),

Line 1149: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

1145: p_exception_name => 'WSH_OTM_DEL_SPLIT_CHILD',
1146: x_return_status => l_return_status);
1147:
1148: IF l_debug_on THEN
1149: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1150: END IF;
1151:
1152: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1153:

Line 1156: wsh_debug_sv.logmsg(l_module_name, 'Error during log delivery exception');

1152: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1153:
1154: ROLLBACK TO delivery_record;
1155: IF l_debug_on THEN
1156: wsh_debug_sv.logmsg(l_module_name, 'Error during log delivery exception');
1157: END IF;
1158:
1159: l_num_error := l_num_error+1;
1160: x_rejected_del_id.EXTEND;

Line 1188: WSH_DEBUG_SV.logmsg(l_module_name,

1184: --line/LPN should be left under the limit.
1185: l_temp_ids.DELETE;
1186:
1187: IF l_debug_on THEN
1188: WSH_DEBUG_SV.logmsg(l_module_name,
1189: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1190: WSH_DEBUG_SV.C_PROC_LEVEL);
1191: END IF;
1192:

Line 1190: WSH_DEBUG_SV.C_PROC_LEVEL);

1186:
1187: IF l_debug_on THEN
1188: WSH_DEBUG_SV.logmsg(l_module_name,
1189: 'Calling program unit WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES',
1190: WSH_DEBUG_SV.C_PROC_LEVEL);
1191: END IF;
1192:
1193: WSH_DELIVERY_DETAILS_GRP.autocreate_deliveries(
1194: p_api_version_number => 1.0,

Line 1206: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);

1202: p_group_by_header_flag => 'N',
1203: x_del_rows => l_temp_ids);
1204:
1205: IF l_debug_on THEN
1206: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from WSH_DELIVERY_DETAILS_GRP.AUTOCREATE_DELIVERIES: ' || l_return_status);
1207: END IF;
1208:
1209: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1210:

Line 1217: wsh_debug_sv.logmsg(l_module_name, 'Error during autocreate delivery');

1213: l_num_error := l_num_error+1;
1214:
1215: --reject failed delivery
1216: IF l_debug_on THEN
1217: wsh_debug_sv.logmsg(l_module_name, 'Error during autocreate delivery');
1218: END IF;
1219:
1220: IF l_debug_on THEN
1221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 1221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

1217: wsh_debug_sv.logmsg(l_module_name, 'Error during autocreate delivery');
1218: END IF;
1219:
1220: IF l_debug_on THEN
1221: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1222: END IF;
1223:
1224: log_del_splitter_exception
1225: (p_delivery_rec => p_delivery_tab(i),

Line 1232: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

1228: p_exception_name => 'WSH_OTM_DEL_SPLIT_FAIL',
1229: x_return_status => l_return_status);
1230:
1231: IF l_debug_on THEN
1232: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1233: END IF;
1234:
1235: x_rejected_del_id.EXTEND;
1236: x_rejected_del_id(x_rejected_del_id.COUNT) := p_delivery_tab(i).entity_id;

Line 1251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

1247: l_new_delivery_name := WSH_NEW_DELIVERIES_PVT.get_name(l_temp_ids(z)); --newly created delivery
1248:
1249: --log tms exceptions for the new delivery
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1252: END IF;
1253:
1254: log_del_splitter_exception
1255: (p_delivery_rec => p_delivery_tab(i),

Line 1264: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

1260: p_exception_name => 'WSH_OTM_DEL_SPLIT_CHILD',
1261: x_return_status => l_return_status);
1262:
1263: IF l_debug_on THEN
1264: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1265: END IF;
1266:
1267: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1268:

Line 1272: wsh_debug_sv.logmsg(l_module_name, 'Error during log delivery exception');

1268:
1269: ROLLBACK TO delivery_record;
1270:
1271: IF l_debug_on THEN
1272: wsh_debug_sv.logmsg(l_module_name, 'Error during log delivery exception');
1273: END IF;
1274:
1275: l_num_error := l_num_error+1;
1276: x_rejected_del_id.EXTEND;

Line 1293: WSH_DEBUG_SV.logmsg(l_module_name,

1289:
1290: l_count := l_curr_del_split_list.COUNT;
1291:
1292: IF l_debug_on THEN
1293: WSH_DEBUG_SV.logmsg(l_module_name,
1294: l_curr_del_split_name(1) || ' is split into '
1295: || l_count || ' deliveries.');
1296:
1297: z := l_curr_del_split_list.FIRST;

Line 1301: WSH_DEBUG_SV.log(l_module_name, 'Delivery ' || z, l_curr_del_split_list(z));

1297: z := l_curr_del_split_list.FIRST;
1298:
1299: WHILE z IS NOT NULL LOOP
1300:
1301: WSH_DEBUG_SV.log(l_module_name, 'Delivery ' || z, l_curr_del_split_list(z));
1302: WSH_DEBUG_SV.log(l_module_name, 'Delivery Name ' || z, l_curr_del_split_name(z));
1303: z:= l_curr_del_split_list.NEXT(z);
1304:
1305: END LOOP;

Line 1302: WSH_DEBUG_SV.log(l_module_name, 'Delivery Name ' || z, l_curr_del_split_name(z));

1298:
1299: WHILE z IS NOT NULL LOOP
1300:
1301: WSH_DEBUG_SV.log(l_module_name, 'Delivery ' || z, l_curr_del_split_list(z));
1302: WSH_DEBUG_SV.log(l_module_name, 'Delivery Name ' || z, l_curr_del_split_name(z));
1303: z:= l_curr_del_split_list.NEXT(z);
1304:
1305: END LOOP;
1306: END IF;

Line 1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);

1326: END IF;
1327: END LOOP;
1328:
1329: IF l_debug_on THEN
1330: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit log_del_splitter_exception',WSH_DEBUG_SV.C_PROC_LEVEL);
1331: END IF;
1332:
1333: log_del_splitter_exception
1334: (p_delivery_rec => p_delivery_tab(i),

Line 1342: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);

1338: p_exception_name => l_exception_name,
1339: x_return_status => l_return_status);
1340:
1341: IF l_debug_on THEN
1342: WSH_DEBUG_SV.logmsg(l_module_name, 'return status from log_del_splitter_exception: ' || l_return_status);
1343: END IF;
1344:
1345: IF (l_return_status IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR)) THEN
1346:

Line 1351: wsh_debug_sv.logmsg(l_module_name, 'Error during log delivery exception');

1347: ROLLBACK TO delivery_record;
1348:
1349: --reject failed delivery
1350: IF l_debug_on THEN
1351: wsh_debug_sv.logmsg(l_module_name, 'Error during log delivery exception');
1352: END IF;
1353:
1354: l_num_error := l_num_error+1;
1355: x_rejected_del_id.EXTEND;

Line 1405: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);

1401: --
1402: -- Debug Statements
1403: --
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
1406: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
1407: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;

Line 1406: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);

1402: -- Debug Statements
1403: --
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
1406: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
1407: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1410: --

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

1403: --
1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
1406: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
1407: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1410: --
1411: EXCEPTION

Line 1408: WSH_DEBUG_SV.pop(l_module_name);

1404: IF l_debug_on THEN
1405: WSH_DEBUG_SV.log(l_module_name, 'l_num_error', l_num_error);
1406: WSH_DEBUG_SV.log(l_module_name, 'l_num_warn', l_num_warn);
1407: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1408: WSH_DEBUG_SV.pop(l_module_name);
1409: END IF;
1410: --
1411: EXCEPTION
1412: --

Line 1431: WSH_DEBUG_SV.logmsg(l_module_name,

1427: CLOSE c_get_delivery_line;
1428: END IF;
1429: --
1430: IF l_debug_on THEN
1431: WSH_DEBUG_SV.logmsg(l_module_name,
1432: 'FND_API.G_EXC_ERROR exception has occured ',
1433: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1435: END IF;

Line 1433: WSH_DEBUG_SV.C_EXCEP_LEVEL);

1429: --
1430: IF l_debug_on THEN
1431: WSH_DEBUG_SV.logmsg(l_module_name,
1432: 'FND_API.G_EXC_ERROR exception has occured ',
1433: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1435: END IF;
1436: --
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');

1430: IF l_debug_on THEN
1431: WSH_DEBUG_SV.logmsg(l_module_name,
1432: 'FND_API.G_EXC_ERROR exception has occured ',
1433: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1434: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1435: END IF;
1436: --
1437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1438: --

Line 1455: WSH_DEBUG_SV.logmsg(l_module_name,

1451: CLOSE c_get_delivery_line;
1452: END IF;
1453: --
1454: IF l_debug_on THEN
1455: WSH_DEBUG_SV.logmsg(l_module_name,
1456: 'Unexpected error has occured. Oracle error message is '||
1457: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1458: WSH_DEBUG_SV.pop(l_module_name,
1459: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 1457: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1453: --
1454: IF l_debug_on THEN
1455: WSH_DEBUG_SV.logmsg(l_module_name,
1456: 'Unexpected error has occured. Oracle error message is '||
1457: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1458: WSH_DEBUG_SV.pop(l_module_name,
1459: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1460: END IF;
1461: --

Line 1458: WSH_DEBUG_SV.pop(l_module_name,

1454: IF l_debug_on THEN
1455: WSH_DEBUG_SV.logmsg(l_module_name,
1456: 'Unexpected error has occured. Oracle error message is '||
1457: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1458: WSH_DEBUG_SV.pop(l_module_name,
1459: 'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1460: END IF;
1461: --
1462:

Line 1484: WSH_DEBUG_SV.logmsg(l_module_name,

1480: --
1481: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status,l_module_name);
1482: --
1483: IF l_debug_on THEN
1484: WSH_DEBUG_SV.logmsg(l_module_name,
1485: 'NO_DATA_FOUND exception has occured.',
1486: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1487: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1488: END IF;

Line 1486: WSH_DEBUG_SV.C_EXCEP_LEVEL);

1482: --
1483: IF l_debug_on THEN
1484: WSH_DEBUG_SV.logmsg(l_module_name,
1485: 'NO_DATA_FOUND exception has occured.',
1486: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1487: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1488: END IF;
1489: --
1490:

Line 1487: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');

1483: IF l_debug_on THEN
1484: WSH_DEBUG_SV.logmsg(l_module_name,
1485: 'NO_DATA_FOUND exception has occured.',
1486: WSH_DEBUG_SV.C_EXCEP_LEVEL);
1487: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
1488: END IF;
1489: --
1490:
1491: WHEN OTHERS THEN

Line 1511: WSH_DEBUG_SV.logmsg(l_module_name,

1507: --
1508: WSH_UTIL_CORE.DEFAULT_HANDLER(
1509: 'WSH_DELIVERY_SPLITTER_PKG.DELIVERY_SPLITTER', l_module_name);
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.logmsg(l_module_name,
1512: 'Unexpected error has occured. Oracle error message is '||
1513: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1515: END IF;

Line 1513: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1509: 'WSH_DELIVERY_SPLITTER_PKG.DELIVERY_SPLITTER', l_module_name);
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.logmsg(l_module_name,
1512: 'Unexpected error has occured. Oracle error message is '||
1513: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1515: END IF;
1516:
1517: END DELIVERY_SPLITTER;

Line 1514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.logmsg(l_module_name,
1512: 'Unexpected error has occured. Oracle error message is '||
1513: SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1514: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1515: END IF;
1516:
1517: END DELIVERY_SPLITTER;
1518: