APPS.WSH_INTERFACE_GRP dependencies on WSH_DEBUG_SV

Line 27: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

23: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
24: --
25: IF l_debug_on IS NULL
26: THEN
27: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
28: END IF;
29: --
30: IF l_debug_on THEN
31: wsh_debug_sv.push (l_module_name, 'Rtrim_deliveries_action');

Line 31: wsh_debug_sv.push (l_module_name, 'Rtrim_deliveries_action');

27: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
28: END IF;
29: --
30: IF l_debug_on THEN
31: wsh_debug_sv.push (l_module_name, 'Rtrim_deliveries_action');
32: END IF;
33:
34: p_out_rec := p_in_rec;
35:

Line 61: WSH_DEBUG_SV.pop(l_module_name);

57: p_out_rec.reason_of_transport := RTRIM(p_in_rec.reason_of_transport);
58: p_out_rec.description := RTRIM(p_in_rec.description);
59:
60: IF l_debug_on THEN
61: WSH_DEBUG_SV.pop(l_module_name);
62: END IF;
63:
64: EXCEPTION
65:

Line 70: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||

66: WHEN OTHERS THEN
67: wsh_util_core.default_handler (
68: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_action', l_module_name);
69: IF l_debug_on THEN
70: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
71: ' Oracle error message is '|| SQLERRM,
72: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
73: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
74: END IF;

Line 72: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

68: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_action', l_module_name);
69: IF l_debug_on THEN
70: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
71: ' Oracle error message is '|| SQLERRM,
72: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
73: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
74: END IF;
75: RAISE;
76:

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

69: IF l_debug_on THEN
70: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
71: ' Oracle error message is '|| SQLERRM,
72: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
73: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
74: END IF;
75: RAISE;
76:
77: END Rtrim_deliveries_action;

Line 187: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

183: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
184: --
185: IF l_debug_on IS NULL
186: THEN
187: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
188: END IF;
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.push(l_module_name);
191: END IF;

Line 190: WSH_DEBUG_SV.push(l_module_name);

186: THEN
187: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
188: END IF;
189: IF l_debug_on THEN
190: WSH_DEBUG_SV.push(l_module_name);
191: END IF;
192:
193: x_return_status := wsh_util_core.g_ret_sts_success;
194:

Line 218: WSH_DEBUG_SV.logmsg(l_module_name,'No Valid Rule found');

214: fnd_message.set_name('WSH','WSH_ACTIVE_SC_RULE');
215: CLOSE get_sc_rule;
216: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
217: IF l_debug_on THEN
218: WSH_DEBUG_SV.logmsg(l_module_name,'No Valid Rule found');
219: WSH_DEBUG_SV.pop(l_module_name);
220: END IF;
221: return;
222: ELSE

Line 219: WSH_DEBUG_SV.pop(l_module_name);

215: CLOSE get_sc_rule;
216: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
217: IF l_debug_on THEN
218: WSH_DEBUG_SV.logmsg(l_module_name,'No Valid Rule found');
219: WSH_DEBUG_SV.pop(l_module_name);
220: END IF;
221: return;
222: ELSE
223: CLOSE get_sc_rule;

Line 227: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule',l_sc_rule);

223: CLOSE get_sc_rule;
224: END IF;
225:
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule',l_sc_rule);
228: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule id',l_sc_rule_id);
229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);
230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);

Line 228: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule id',l_sc_rule_id);

224: END IF;
225:
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule',l_sc_rule);
228: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule id',l_sc_rule_id);
229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);
230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);

Line 229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);

225:
226: IF l_debug_on THEN
227: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule',l_sc_rule);
228: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule id',l_sc_rule_id);
229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);
230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);

Line 230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);

226: IF l_debug_on THEN
227: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule',l_sc_rule);
228: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule id',l_sc_rule_id);
229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);
230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);

Line 231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);

227: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule',l_sc_rule);
228: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule id',l_sc_rule_id);
229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);
230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);

Line 232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);

228: WSH_DEBUG_SV.log(l_module_name,'Ship Confirm Rule id',l_sc_rule_id);
229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);
230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);
236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);

Line 233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);

229: WSH_DEBUG_SV.log(l_module_name,'In transit',l_ac_intransit_flag);
230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);
236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);
237: WSH_DEBUG_SV.log(l_module_name,'Stage Del flag',l_stage_del_flag);

Line 234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);

230: WSH_DEBUG_SV.log(l_module_name,'Close',l_ac_close_flag);
231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);
236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);
237: WSH_DEBUG_SV.log(l_module_name,'Stage Del flag',l_stage_del_flag);
238: WSH_DEBUG_SV.log(l_module_name,'Action flag',l_action_flag);

Line 235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);

231: WSH_DEBUG_SV.log(l_module_name,'BOL flag',l_ac_bol_flag);
232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);
236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);
237: WSH_DEBUG_SV.log(l_module_name,'Stage Del flag',l_stage_del_flag);
238: WSH_DEBUG_SV.log(l_module_name,'Action flag',l_action_flag);
239: END IF;

Line 236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);

232: WSH_DEBUG_SV.log(l_module_name,'Defer Interface flag',l_ac_defer_interface_flag);
233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);
236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);
237: WSH_DEBUG_SV.log(l_module_name,'Stage Del flag',l_stage_del_flag);
238: WSH_DEBUG_SV.log(l_module_name,'Action flag',l_action_flag);
239: END IF;
240:

Line 237: WSH_DEBUG_SV.log(l_module_name,'Stage Del flag',l_stage_del_flag);

233: WSH_DEBUG_SV.log(l_module_name,'SC report set',l_report_set_id);
234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);
236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);
237: WSH_DEBUG_SV.log(l_module_name,'Stage Del flag',l_stage_del_flag);
238: WSH_DEBUG_SV.log(l_module_name,'Action flag',l_action_flag);
239: END IF;
240:
241: x_out_params.intransit_flag := l_ac_intransit_flag;

Line 238: WSH_DEBUG_SV.log(l_module_name,'Action flag',l_action_flag);

234: WSH_DEBUG_SV.log(l_module_name,'SC ship method',l_ship_method_code);
235: WSH_DEBUG_SV.log(l_module_name,'SC ship method default flag',l_ship_method_default_flag);
236: WSH_DEBUG_SV.log(l_module_name,'Effective end date',l_effective_end_date);
237: WSH_DEBUG_SV.log(l_module_name,'Stage Del flag',l_stage_del_flag);
238: WSH_DEBUG_SV.log(l_module_name,'Action flag',l_action_flag);
239: END IF;
240:
241: x_out_params.intransit_flag := l_ac_intransit_flag;
242: x_out_params.close_trip_flag := l_ac_close_flag;

Line 301: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Methods are different');

297: IF NVL(l_temp_ship_method_code,' ') <> NVL(l_dist_ship_method_code,' ') THEN
298: -- Ship Methods are different for Deliveries,
299: -- so Null Ship Method is returned
300: IF l_debug_on THEN
301: WSH_DEBUG_SV.logmsg(l_module_name,'Ship Methods are different');
302: END IF;
303: l_dist_ship_method_code := NULL;
304: l_ship_method_code := NULL;
305: EXIT;

Line 327: WSH_DEBUG_SV.log(l_module_name, 'x_out_params.ship_method_code', x_out_params.ship_method_code);

323: END IF;
324: x_out_params.ship_method_code := l_ship_method_code;
325:
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.log(l_module_name, 'x_out_params.ship_method_code', x_out_params.ship_method_code);
328: WSH_DEBUG_SV.pop(l_module_name);
329: END IF;
330:
331: EXCEPTION

Line 328: WSH_DEBUG_SV.pop(l_module_name);

324: x_out_params.ship_method_code := l_ship_method_code;
325:
326: IF l_debug_on THEN
327: WSH_DEBUG_SV.log(l_module_name, 'x_out_params.ship_method_code', x_out_params.ship_method_code);
328: WSH_DEBUG_SV.pop(l_module_name);
329: END IF;
330:
331: EXCEPTION
332:

Line 338: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

334: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.derive_sc_rule_details',l_module_name);
335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
336: --
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
339: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
340: END IF;
341:
342: END derive_sc_rule_details;

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

335: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
336: --
337: IF l_debug_on THEN
338: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
339: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
340: END IF;
341:
342: END derive_sc_rule_details;
343:

Line 423: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

419: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
420: --
421: IF l_debug_on IS NULL
422: THEN
423: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
424: END IF;
425: --
426: SAVEPOINT DELIVERY_ACTION_WRAPPER_GRP;
427: --

Line 429: wsh_debug_sv.push(l_module_name);

425: --
426: SAVEPOINT DELIVERY_ACTION_WRAPPER_GRP;
427: --
428: IF l_debug_on THEN
429: wsh_debug_sv.push(l_module_name);
430: wsh_debug_sv.log(l_module_name,'Caller is ', p_action_prms.caller);
431: wsh_debug_sv.log(l_module_name,'Phase is ', p_action_prms.phase);
432: wsh_debug_sv.log(l_module_name,'Action Code is ', p_action_prms.phase);
433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);

Line 430: wsh_debug_sv.log(l_module_name,'Caller is ', p_action_prms.caller);

426: SAVEPOINT DELIVERY_ACTION_WRAPPER_GRP;
427: --
428: IF l_debug_on THEN
429: wsh_debug_sv.push(l_module_name);
430: wsh_debug_sv.log(l_module_name,'Caller is ', p_action_prms.caller);
431: wsh_debug_sv.log(l_module_name,'Phase is ', p_action_prms.phase);
432: wsh_debug_sv.log(l_module_name,'Action Code is ', p_action_prms.phase);
433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);
434: END IF;

Line 431: wsh_debug_sv.log(l_module_name,'Phase is ', p_action_prms.phase);

427: --
428: IF l_debug_on THEN
429: wsh_debug_sv.push(l_module_name);
430: wsh_debug_sv.log(l_module_name,'Caller is ', p_action_prms.caller);
431: wsh_debug_sv.log(l_module_name,'Phase is ', p_action_prms.phase);
432: wsh_debug_sv.log(l_module_name,'Action Code is ', p_action_prms.phase);
433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);
434: END IF;
435: --

Line 432: wsh_debug_sv.log(l_module_name,'Action Code is ', p_action_prms.phase);

428: IF l_debug_on THEN
429: wsh_debug_sv.push(l_module_name);
430: wsh_debug_sv.log(l_module_name,'Caller is ', p_action_prms.caller);
431: wsh_debug_sv.log(l_module_name,'Phase is ', p_action_prms.phase);
432: wsh_debug_sv.log(l_module_name,'Action Code is ', p_action_prms.phase);
433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);
434: END IF;
435: --
436: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);

429: wsh_debug_sv.push(l_module_name);
430: wsh_debug_sv.log(l_module_name,'Caller is ', p_action_prms.caller);
431: wsh_debug_sv.log(l_module_name,'Phase is ', p_action_prms.phase);
432: wsh_debug_sv.log(l_module_name,'Action Code is ', p_action_prms.phase);
433: wsh_debug_sv.log(l_module_name,'Total Number of Delivery Records', p_delivery_id_tab.COUNT);
434: END IF;
435: --
436: IF FND_API.to_Boolean( p_init_msg_list ) THEN
437: FND_MSG_PUB.initialize;

Line 451: wsh_debug_sv.log (l_module_name,'After deriving SC Rule details', x_return_status);

447: p_delivery_id_tab => p_delivery_id_tab,
448: x_out_params => l_action_prms,
449: x_return_status => x_return_status);
450: IF l_debug_on THEN
451: wsh_debug_sv.log (l_module_name,'After deriving SC Rule details', x_return_status);
452: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
453: END IF;
454:
455: wsh_util_core.api_post_call(

Line 452: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);

448: x_out_params => l_action_prms,
449: x_return_status => x_return_status);
450: IF l_debug_on THEN
451: wsh_debug_sv.log (l_module_name,'After deriving SC Rule details', x_return_status);
452: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
453: END IF;
454:
455: wsh_util_core.api_post_call(
456: p_return_status =>x_return_status,

Line 507: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);

503: x_msg_count => x_msg_count,
504: x_msg_data => x_msg_data);
505: --
506: IF l_debug_on THEN
507: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
508: END IF;
509:
510: wsh_util_core.api_post_call(
511: p_return_status =>x_return_status,

Line 528: WSH_DEBUG_SV.pop(l_module_name);

524: p_count => x_msg_count,
525: p_data => x_msg_data);
526: --
527: IF l_debug_on THEN
528: WSH_DEBUG_SV.pop(l_module_name);
529: END IF;
530: --
531: EXCEPTION
532: WHEN FND_API.G_EXC_ERROR THEN

Line 543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

539: p_encoded => FND_API.G_FALSE
540: );
541: --
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
545: END IF;
546: --
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

540: );
541: --
542: IF l_debug_on THEN
543: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
544: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
545: END IF;
546: --
547: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
548: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;

Line 558: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

554: p_encoded => FND_API.G_FALSE
555: );
556: --
557: IF l_debug_on THEN
558: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
560: END IF;
561: --
562: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

555: );
556: --
557: IF l_debug_on THEN
558: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
559: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
560: END IF;
561: --
562: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
563: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 572: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

568: p_encoded => FND_API.G_FALSE
569: );
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
574: END IF;
575: --
576: WHEN OTHERS THEN

Line 573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

569: );
570: --
571: IF l_debug_on THEN
572: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
574: END IF;
575: --
576: WHEN OTHERS THEN
577: ROLLBACK TO DELIVERY_ACTION_WRAPPER_GRP;

Line 588: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

584: p_encoded => FND_API.G_FALSE
585: );
586: --
587: IF l_debug_on THEN
588: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
589: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
590: END IF;
591: --
592: END Delivery_Action;

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

585: );
586: --
587: IF l_debug_on THEN
588: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
589: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
590: END IF;
591: --
592: END Delivery_Action;
593:

Line 607: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

603: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
604: --
605: IF l_debug_on IS NULL
606: THEN
607: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
608: END IF;
609: --
610: IF l_debug_on THEN
611: wsh_debug_sv.push (l_module_name, 'Rtrim_deliveries_blank_space');

Line 611: wsh_debug_sv.push (l_module_name, 'Rtrim_deliveries_blank_space');

607: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
608: END IF;
609: --
610: IF l_debug_on THEN
611: wsh_debug_sv.push (l_module_name, 'Rtrim_deliveries_blank_space');
612: END IF;
613:
614: p_out_rec := p_in_rec;
615:

Line 726: WSH_DEBUG_SV.pop(l_module_name);

722: /*3667348*/
723: p_out_rec.REASON_OF_TRANSPORT := RTRIM(p_in_rec.REASON_OF_TRANSPORT);
724: p_out_rec.DESCRIPTION := RTRIM(p_in_rec.DESCRIPTION);
725: IF l_debug_on THEN
726: WSH_DEBUG_SV.pop(l_module_name);
727: END IF;
728:
729: EXCEPTION
730:

Line 735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||

731: WHEN OTHERS THEN
732: wsh_util_core.default_handler (
733: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_blank_space', l_module_name);
734: IF l_debug_on THEN
735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
736: ' Oracle error message is '|| SQLERRM,
737: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
738: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
739: END IF;

Line 737: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

733: 'WSH_TRIP_STOPS_GRP.Rtrim_deliveries_blank_space', l_module_name);
734: IF l_debug_on THEN
735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
736: ' Oracle error message is '|| SQLERRM,
737: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
738: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
739: END IF;
740: RAISE;
741:

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

734: IF l_debug_on THEN
735: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
736: ' Oracle error message is '|| SQLERRM,
737: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
738: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
739: END IF;
740: RAISE;
741:
742: END Rtrim_deliveries_blank_space;

Line 799: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

795: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
796: --
797: IF l_debug_on IS NULL
798: THEN
799: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
800: END IF;
801: --
802: SAVEPOINT CREATE_UPDATE_DEL_WRAP_GRP;
803: --

Line 805: wsh_debug_sv.push(l_module_name);

801: --
802: SAVEPOINT CREATE_UPDATE_DEL_WRAP_GRP;
803: --
804: IF l_debug_on THEN
805: wsh_debug_sv.push(l_module_name);
806: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
807: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
808: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.phase);
809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);

Line 806: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);

802: SAVEPOINT CREATE_UPDATE_DEL_WRAP_GRP;
803: --
804: IF l_debug_on THEN
805: wsh_debug_sv.push(l_module_name);
806: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
807: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
808: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.phase);
809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
810: END IF;

Line 807: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);

803: --
804: IF l_debug_on THEN
805: wsh_debug_sv.push(l_module_name);
806: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
807: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
808: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.phase);
809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
810: END IF;
811: --

Line 808: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.phase);

804: IF l_debug_on THEN
805: wsh_debug_sv.push(l_module_name);
806: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
807: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
808: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.phase);
809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
810: END IF;
811: --
812: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);

805: wsh_debug_sv.push(l_module_name);
806: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
807: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
808: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.phase);
809: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
810: END IF;
811: --
812: IF FND_API.to_Boolean( p_init_msg_list ) THEN
813: FND_MSG_PUB.initialize;

Line 839: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);

835: x_msg_count => x_msg_count,
836: x_msg_data => x_msg_data);
837: --
838: IF l_debug_on THEN
839: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
840: END IF;
841: --
842: wsh_util_core.api_post_call(
843: p_return_status =>x_return_status,

Line 860: WSH_DEBUG_SV.pop(l_module_name);

856: p_count => x_msg_count,
857: p_data => x_msg_data);
858: --
859: IF l_debug_on THEN
860: WSH_DEBUG_SV.pop(l_module_name);
861: END IF;
862: --
863: EXCEPTION
864: WHEN FND_API.G_EXC_ERROR THEN

Line 875: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

871: p_encoded => FND_API.G_FALSE
872: );
873: --
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
876: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
877: END IF;
878: --
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

872: );
873: --
874: IF l_debug_on THEN
875: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
876: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
877: END IF;
878: --
879: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
880: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;

Line 890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

886: p_encoded => FND_API.G_FALSE
887: );
888: --
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
892: END IF;
893: --
894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

887: );
888: --
889: IF l_debug_on THEN
890: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
891: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
892: END IF;
893: --
894: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
895: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 904: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

900: p_encoded => FND_API.G_FALSE
901: );
902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
905: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
906: END IF;
907: --
908: WHEN OTHERS THEN

Line 905: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

901: );
902: --
903: IF l_debug_on THEN
904: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
905: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
906: END IF;
907: --
908: WHEN OTHERS THEN
909: ROLLBACK TO CREATE_UPDATE_DEL_WRAP_GRP;

Line 920: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

916: p_encoded => FND_API.G_FALSE
917: );
918: --
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
922: END IF;
923: --
924:

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

917: );
918: --
919: IF l_debug_on THEN
920: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
921: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
922: END IF;
923: --
924:
925: END Create_Update_Delivery;

Line 1018: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1014: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1015: --
1016: IF l_debug_on IS NULL
1017: THEN
1018: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1019: END IF;
1020: --
1021: SAVEPOINT DEL_DETAIL_ACTION_WRAP_GRP;
1022:

Line 1024: WSH_DEBUG_SV.push(l_module_name);

1020: --
1021: SAVEPOINT DEL_DETAIL_ACTION_WRAP_GRP;
1022:
1023: IF l_debug_on THEN
1024: WSH_DEBUG_SV.push(l_module_name);
1025: --
1026: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 1026: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

1022:
1023: IF l_debug_on THEN
1024: WSH_DEBUG_SV.push(l_module_name);
1025: --
1026: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);

Line 1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

1023: IF l_debug_on THEN
1024: WSH_DEBUG_SV.push(l_module_name);
1025: --
1026: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);
1031: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);

Line 1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

1024: WSH_DEBUG_SV.push(l_module_name);
1025: --
1026: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);
1031: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);
1032: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);

Line 1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);

1025: --
1026: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);
1031: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);
1032: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);
1033: END IF;

Line 1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);

1026: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);
1031: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);
1032: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);
1033: END IF;
1034: --

Line 1031: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);

1027: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);
1031: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);
1032: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);
1033: END IF;
1034: --
1035:

Line 1032: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);

1028: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1029: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1030: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);
1031: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);
1032: WSH_DEBUG_SV.log(l_module_name, 'Input Table count', p_detail_id_tab.count);
1033: END IF;
1034: --
1035:
1036: IF FND_API.to_Boolean( p_init_msg_list )

Line 1050: wsh_debug_sv.log (l_module_name,'Input Table Count Zero');

1046:
1047:
1048: IF(p_detail_id_tab.count = 0) THEN
1049: IF l_debug_on THEN
1050: wsh_debug_sv.log (l_module_name,'Input Table Count Zero');
1051: END IF;
1052: RAISE FND_API.G_EXC_ERROR;
1053: END IF;
1054:

Line 1086: wsh_debug_sv.log (l_module_name,'Invalid Delivery Detail');

1082: l_rec_attr_tab(l_index).move_order_line_id; -- R12, X-dock
1083:
1084: IF det_cur%NOTFOUND THEN
1085: IF l_debug_on THEN
1086: wsh_debug_sv.log (l_module_name,'Invalid Delivery Detail');
1087: END IF;
1088: CLOSE det_cur;
1089: RAISE FND_API.G_EXC_ERROR;
1090: END IF;

Line 1108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);

1104: l_action_prms.delivery_flag := RTRIM(p_action_prms.delivery_flag);
1105: -- Call the Core Group API
1106:
1107: IF l_debug_on THEN
1108: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIERY_DETAILS_GRP.DELIVERY_DETAIL_ACTION',WSH_DEBUG_SV.C_PROC_LEVEL);
1109: END IF;
1110:
1111: wsh_delivery_details_grp.Delivery_Detail_Action(
1112: p_api_version_number => p_api_version_number,

Line 1126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1122: );
1123:
1124: --
1125: IF l_debug_on THEN
1126: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1127: END IF;
1128:
1129: wsh_util_core.api_post_call(
1130: p_return_status => l_return_status,

Line 1144: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');

1140:
1141: -- Standard check of p_commit.
1142: IF FND_API.To_Boolean( p_commit ) THEN
1143: IF l_debug_on THEN
1144: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');
1145: END IF;
1146: COMMIT WORK;
1147: END IF;
1148:

Line 1156: WSH_DEBUG_SV.pop(l_module_name);

1152: p_data => x_msg_data
1153: );
1154:
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.pop(l_module_name);
1157: END IF;
1158: --
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN

Line 1171: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1167: p_encoded => FND_API.G_FALSE
1168: );
1169: --
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1173: END IF;
1174: --
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1168: );
1169: --
1170: IF l_debug_on THEN
1171: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1172: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1173: END IF;
1174: --
1175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1176: ROLLBACK TO DEL_DETAIL_ACTION_WRAP_GRP;

Line 1186: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1182: p_encoded => FND_API.G_FALSE
1183: );
1184: --
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1188: END IF;
1189: --
1190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1183: );
1184: --
1185: IF l_debug_on THEN
1186: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1187: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1188: END IF;
1189: --
1190: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1191: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1200: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1196: p_encoded => FND_API.G_FALSE
1197: );
1198: --
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1202: END IF;
1203: --
1204: WHEN OTHERS THEN

Line 1201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

1197: );
1198: --
1199: IF l_debug_on THEN
1200: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1201: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1202: END IF;
1203: --
1204: WHEN OTHERS THEN
1205: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Delivery_Detail_Action');

Line 1216: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1212: p_encoded => FND_API.G_FALSE
1213: );
1214: --
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1218: END IF;
1219: --
1220: --

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

1213: );
1214: --
1215: IF l_debug_on THEN
1216: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1217: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1218: END IF;
1219: --
1220: --
1221: END Delivery_Detail_Action;

Line 1235: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1231: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1232: --
1233: IF l_debug_on IS NULL
1234: THEN
1235: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1236: END IF;
1237: --
1238: IF l_debug_on THEN
1239: wsh_debug_sv.push (l_module_name, 'Rtrim_details_blank_space');

Line 1239: wsh_debug_sv.push (l_module_name, 'Rtrim_details_blank_space');

1235: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1236: END IF;
1237: --
1238: IF l_debug_on THEN
1239: wsh_debug_sv.push (l_module_name, 'Rtrim_details_blank_space');
1240: END IF;
1241:
1242: p_out_rec := p_in_rec;
1243:

Line 1332: WSH_DEBUG_SV.pop(l_module_name);

1328: p_out_rec.pickable_flag := RTRIM(p_in_rec.pickable_flag);
1329: p_out_rec.original_subinventory := RTRIM(p_in_rec.original_subinventory);
1330:
1331: IF l_debug_on THEN
1332: WSH_DEBUG_SV.pop(l_module_name);
1333: END IF;
1334:
1335: EXCEPTION
1336:

Line 1341: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||

1337: WHEN OTHERS THEN
1338: wsh_util_core.default_handler (
1339: 'WSH_TRIP_STOPS_GRP.Rtrim_details_blank_space', l_module_name);
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
1342: ' Oracle error message is '|| SQLERRM,
1343: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1345: END IF;

Line 1343: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1339: 'WSH_TRIP_STOPS_GRP.Rtrim_details_blank_space', l_module_name);
1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
1342: ' Oracle error message is '|| SQLERRM,
1343: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1345: END IF;
1346: RAISE;
1347:

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

1340: IF l_debug_on THEN
1341: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
1342: ' Oracle error message is '|| SQLERRM,
1343: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1344: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1345: END IF;
1346: RAISE;
1347:
1348: END Rtrim_details_blank_space;

Line 1417: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1413: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1414: --
1415: IF l_debug_on IS NULL
1416: THEN
1417: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1418: END IF;
1419: --
1420: SAVEPOINT CREATE_UPD_DEL_DET_WRAP_GRP;
1421: --

Line 1425: WSH_DEBUG_SV.push(l_module_name);

1421: --
1422: -- Debug Statements
1423: --
1424: IF l_debug_on THEN
1425: WSH_DEBUG_SV.push(l_module_name);
1426: --
1427: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1428: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1429: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

Line 1427: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);

1423: --
1424: IF l_debug_on THEN
1425: WSH_DEBUG_SV.push(l_module_name);
1426: --
1427: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1428: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1429: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1430: END IF;
1431: --

Line 1428: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);

1424: IF l_debug_on THEN
1425: WSH_DEBUG_SV.push(l_module_name);
1426: --
1427: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1428: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1429: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1430: END IF;
1431: --
1432: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1429: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

1425: WSH_DEBUG_SV.push(l_module_name);
1426: --
1427: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1428: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1429: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1430: END IF;
1431: --
1432: -- Initialize message list if p_init_msg_list is set to TRUE.
1433: IF FND_API.to_Boolean( p_init_msg_list )

Line 1457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

1453:
1454: -- Call Core Group API
1455:
1456: IF l_debug_on THEN
1457: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_GRP.CREATE_UPDATE_DELIVERY_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
1458: END IF;
1459: --
1460: l_index := p_detail_info_tab.FIRST;
1461: WHILE l_index IS NOT NULL LOOP

Line 1481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);

1477: );
1478:
1479: --
1480: IF l_debug_on THEN
1481: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_UTIL_CORE.API_POST_CALL',WSH_DEBUG_SV.C_PROC_LEVEL);
1482: END IF;
1483: --
1484: wsh_util_core.api_post_call(
1485: p_return_status => l_return_status,

Line 1498: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');

1494:
1495: -- Standard check of p_commit.
1496: IF FND_API.To_Boolean( p_commit ) THEN
1497: IF l_debug_on THEN
1498: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');
1499: END IF;
1500: COMMIT WORK;
1501: END IF;
1502:

Line 1510: WSH_DEBUG_SV.pop(l_module_name);

1506: p_data => x_msg_data
1507: );
1508:
1509: IF l_debug_on THEN
1510: WSH_DEBUG_SV.pop(l_module_name);
1511: END IF;
1512: --
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN

Line 1525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1521: p_encoded => FND_API.G_FALSE
1522: );
1523: --
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1527: END IF;
1528: --
1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

1522: );
1523: --
1524: IF l_debug_on THEN
1525: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1526: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
1527: END IF;
1528: --
1529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1530: ROLLBACK TO CREATE_UPD_DEL_DET_WRAP_GRP;

Line 1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1537: );
1538:
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1543: END IF;
1544: --
1545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

1538:
1539: --
1540: IF l_debug_on THEN
1541: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1542: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1543: END IF;
1544: --
1545: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1546: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

1551: p_encoded => FND_API.G_FALSE
1552: );
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1557: END IF;
1558: --
1559: WHEN OTHERS THEN

Line 1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

1552: );
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1556: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
1557: END IF;
1558: --
1559: WHEN OTHERS THEN
1560: WSH_UTIL_CORE.default_handler('WSH_INTERFACE_GRP.Create_Update_Delivery_Detail');

Line 1572: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

1568: );
1569: --
1570:
1571: IF l_debug_on THEN
1572: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1574: END IF;
1575: --
1576: END Create_Update_Delivery_Detail;

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

1569: --
1570:
1571: IF l_debug_on THEN
1572: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1573: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1574: END IF;
1575: --
1576: END Create_Update_Delivery_Detail;
1577:

Line 1637: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1633: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1634: --
1635: IF l_debug_on IS NULL
1636: THEN
1637: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1638: END IF;
1639: --
1640: IF l_debug_on THEN
1641: wsh_debug_sv.push (l_module_name);

Line 1641: wsh_debug_sv.push (l_module_name);

1637: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1638: END IF;
1639: --
1640: IF l_debug_on THEN
1641: wsh_debug_sv.push (l_module_name);
1642: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1643: END IF;
1644:
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1642: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);

1638: END IF;
1639: --
1640: IF l_debug_on THEN
1641: wsh_debug_sv.push (l_module_name);
1642: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1643: END IF;
1644:
1645: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1646:

Line 1674: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');

1670: CLOSE c_attributes;
1671: --fnd_message.set_name('WSH','WSH_BAD_ENTITY');
1672: --fnd_message.set_token('ID',p_entity_id_tab(l_index));
1673: IF l_debug_on THEN
1674: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');
1675: END IF;
1676: RAISE FND_API.G_EXC_ERROR;
1677: END IF;
1678: l_rec_attr_tab(l_index).status_code := l_status_code;

Line 1688: wsh_debug_sv.log (l_module_name,'Trip id', l_trip_id);

1684: l_rec_attr_tab(l_index).ignore_for_planning := l_ignore_for_planning;--OTM R12, glog proj
1685:
1686: -- OTM R12, glog proj, add debug messages
1687: IF l_debug_on THEN
1688: wsh_debug_sv.log (l_module_name,'Trip id', l_trip_id);
1689: wsh_debug_sv.log (l_module_name,'Status Code', l_status_code);
1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);
1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);
1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);

Line 1689: wsh_debug_sv.log (l_module_name,'Status Code', l_status_code);

1685:
1686: -- OTM R12, glog proj, add debug messages
1687: IF l_debug_on THEN
1688: wsh_debug_sv.log (l_module_name,'Trip id', l_trip_id);
1689: wsh_debug_sv.log (l_module_name,'Status Code', l_status_code);
1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);
1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);
1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);
1693: wsh_debug_sv.log (l_module_name,'Shipment Type Flag', l_shipments_type_flag);

Line 1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);

1686: -- OTM R12, glog proj, add debug messages
1687: IF l_debug_on THEN
1688: wsh_debug_sv.log (l_module_name,'Trip id', l_trip_id);
1689: wsh_debug_sv.log (l_module_name,'Status Code', l_status_code);
1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);
1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);
1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);
1693: wsh_debug_sv.log (l_module_name,'Shipment Type Flag', l_shipments_type_flag);
1694: wsh_debug_sv.log (l_module_name,'Ignore for Planning', l_ignore_for_planning);

Line 1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);

1687: IF l_debug_on THEN
1688: wsh_debug_sv.log (l_module_name,'Trip id', l_trip_id);
1689: wsh_debug_sv.log (l_module_name,'Status Code', l_status_code);
1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);
1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);
1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);
1693: wsh_debug_sv.log (l_module_name,'Shipment Type Flag', l_shipments_type_flag);
1694: wsh_debug_sv.log (l_module_name,'Ignore for Planning', l_ignore_for_planning);
1695: END IF;

Line 1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);

1688: wsh_debug_sv.log (l_module_name,'Trip id', l_trip_id);
1689: wsh_debug_sv.log (l_module_name,'Status Code', l_status_code);
1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);
1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);
1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);
1693: wsh_debug_sv.log (l_module_name,'Shipment Type Flag', l_shipments_type_flag);
1694: wsh_debug_sv.log (l_module_name,'Ignore for Planning', l_ignore_for_planning);
1695: END IF;
1696:

Line 1693: wsh_debug_sv.log (l_module_name,'Shipment Type Flag', l_shipments_type_flag);

1689: wsh_debug_sv.log (l_module_name,'Status Code', l_status_code);
1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);
1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);
1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);
1693: wsh_debug_sv.log (l_module_name,'Shipment Type Flag', l_shipments_type_flag);
1694: wsh_debug_sv.log (l_module_name,'Ignore for Planning', l_ignore_for_planning);
1695: END IF;
1696:
1697: CLOSE c_attributes;

Line 1694: wsh_debug_sv.log (l_module_name,'Ignore for Planning', l_ignore_for_planning);

1690: wsh_debug_sv.log (l_module_name,'Planned Flag', l_planned_flag);
1691: wsh_debug_sv.log (l_module_name,'Lane id', l_lane_id);
1692: wsh_debug_sv.log (l_module_name,'Load Tender Status', l_load_tender_status);
1693: wsh_debug_sv.log (l_module_name,'Shipment Type Flag', l_shipments_type_flag);
1694: wsh_debug_sv.log (l_module_name,'Ignore for Planning', l_ignore_for_planning);
1695: END IF;
1696:
1697: CLOSE c_attributes;
1698:

Line 1716: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);

1712: x_msg_data => x_msg_data
1713: );
1714:
1715: IF l_debug_on THEN
1716: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
1717: END IF;
1718:
1719: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1720: x_num_warnings =>l_num_warning,

Line 1735: WSH_DEBUG_SV.pop(l_module_name);

1731: );
1732:
1733: IF l_debug_on THEN
1734:
1735: WSH_DEBUG_SV.pop(l_module_name);
1736: END IF;
1737:
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN

Line 1746: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');

1742: ( p_count => x_msg_count
1743: , p_data => x_msg_data
1744: );
1745: IF l_debug_on THEN
1746: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1747: WSH_DEBUG_SV.pop(l_module_name);
1748: END IF;
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1747: WSH_DEBUG_SV.pop(l_module_name);

1743: , p_data => x_msg_data
1744: );
1745: IF l_debug_on THEN
1746: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1747: WSH_DEBUG_SV.pop(l_module_name);
1748: END IF;
1749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1750: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1751: FND_MSG_PUB.Count_And_Get

Line 1756: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');

1752: ( p_count => x_msg_count
1753: , p_data => x_msg_data
1754: );
1755: IF l_debug_on THEN
1756: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1757: WSH_DEBUG_SV.pop(l_module_name);
1758: END IF;
1759: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1760: FND_MSG_PUB.Count_And_Get

Line 1757: WSH_DEBUG_SV.pop(l_module_name);

1753: , p_data => x_msg_data
1754: );
1755: IF l_debug_on THEN
1756: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1757: WSH_DEBUG_SV.pop(l_module_name);
1758: END IF;
1759: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1760: FND_MSG_PUB.Count_And_Get
1761: ( p_count => x_msg_count

Line 1766: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');

1762: , p_data => x_msg_data
1763: );
1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1765: IF l_debug_on THEN
1766: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1767: WSH_DEBUG_SV.pop(l_module_name);
1768: END IF;
1769: WHEN OTHERS THEN
1770: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',

Line 1767: WSH_DEBUG_SV.pop(l_module_name);

1763: );
1764: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1765: IF l_debug_on THEN
1766: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1767: WSH_DEBUG_SV.pop(l_module_name);
1768: END IF;
1769: WHEN OTHERS THEN
1770: wsh_util_core.default_handler('WSH_TRIPS_GRP.TRIP_ACTION',
1771: l_module_name);

Line 1779: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));

1775: );
1776:
1777: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1778: IF l_debug_on THEN
1779: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1780: WSH_DEBUG_SV.pop(l_module_name);
1781: END IF;
1782:
1783: END Trip_Action;

Line 1780: WSH_DEBUG_SV.pop(l_module_name);

1776:
1777: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1778: IF l_debug_on THEN
1779: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1780: WSH_DEBUG_SV.pop(l_module_name);
1781: END IF;
1782:
1783: END Trip_Action;
1784:

Line 1843: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1839: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1840: --
1841: IF l_debug_on IS NULL
1842: THEN
1843: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1844: END IF;
1845: --
1846: IF l_debug_on THEN
1847: wsh_debug_sv.push (l_module_name);

Line 1847: wsh_debug_sv.push (l_module_name);

1843: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1844: END IF;
1845: --
1846: IF l_debug_on THEN
1847: wsh_debug_sv.push (l_module_name);
1848: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1849: END IF;
1850:
1851: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 1848: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);

1844: END IF;
1845: --
1846: IF l_debug_on THEN
1847: wsh_debug_sv.push (l_module_name);
1848: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1849: END IF;
1850:
1851: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1852:

Line 1884: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');

1880:
1881: IF (c_attributes%NOTFOUND) THEN
1882: CLOSE c_attributes;
1883: IF l_debug_on THEN
1884: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');
1885: END IF;
1886: RAISE FND_API.G_EXC_ERROR;
1887: END IF;
1888: CLOSE c_attributes;

Line 1907: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);

1903: x_msg_data =>x_msg_data
1904: );
1905:
1906: IF l_debug_on THEN
1907: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);
1908: END IF;
1909:
1910: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1911: x_num_warnings =>l_num_warning,

Line 1926: WSH_DEBUG_SV.pop(l_module_name);

1922: , p_data => x_msg_data
1923: );
1924:
1925: IF l_debug_on THEN
1926: WSH_DEBUG_SV.pop(l_module_name);
1927: END IF;
1928:
1929: EXCEPTION
1930: WHEN FND_API.G_EXC_ERROR THEN

Line 1937: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');

1933: ( p_count => x_msg_count
1934: , p_data => x_msg_data
1935: );
1936: IF l_debug_on THEN
1937: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1938: WSH_DEBUG_SV.pop(l_module_name);
1939: END IF;
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 1938: WSH_DEBUG_SV.pop(l_module_name);

1934: , p_data => x_msg_data
1935: );
1936: IF l_debug_on THEN
1937: wsh_debug_sv.log (l_module_name,'G_EXC_ERROR');
1938: WSH_DEBUG_SV.pop(l_module_name);
1939: END IF;
1940: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1941: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1942: FND_MSG_PUB.Count_And_Get

Line 1947: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');

1943: ( p_count => x_msg_count
1944: , p_data => x_msg_data
1945: );
1946: IF l_debug_on THEN
1947: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1951: FND_MSG_PUB.Count_And_Get

Line 1948: WSH_DEBUG_SV.pop(l_module_name);

1944: , p_data => x_msg_data
1945: );
1946: IF l_debug_on THEN
1947: wsh_debug_sv.log (l_module_name,'G_EXC_UNEXPECTED_ERROR');
1948: WSH_DEBUG_SV.pop(l_module_name);
1949: END IF;
1950: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
1951: FND_MSG_PUB.Count_And_Get
1952: ( p_count => x_msg_count

Line 1957: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');

1953: , p_data => x_msg_data
1954: );
1955: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1956: IF l_debug_on THEN
1957: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1958: WSH_DEBUG_SV.pop(l_module_name);
1959: END IF;
1960: WHEN OTHERS THEN
1961: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',

Line 1958: WSH_DEBUG_SV.pop(l_module_name);

1954: );
1955: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
1956: IF l_debug_on THEN
1957: wsh_debug_sv.log (l_module_name,'G_EXC_WARNING');
1958: WSH_DEBUG_SV.pop(l_module_name);
1959: END IF;
1960: WHEN OTHERS THEN
1961: wsh_util_core.default_handler('WSH_TRIP_STOPS_GRP.STOP_ACTION',
1962: l_module_name);

Line 1970: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));

1966: );
1967:
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN
1970: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1971: WSH_DEBUG_SV.pop(l_module_name);
1972: END IF;
1973:
1974: END Stop_Action;

Line 1971: WSH_DEBUG_SV.pop(l_module_name);

1967:
1968: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1969: IF l_debug_on THEN
1970: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1971: WSH_DEBUG_SV.pop(l_module_name);
1972: END IF;
1973:
1974: END Stop_Action;
1975:

Line 1991: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1987: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1988: --
1989: IF l_debug_on IS NULL
1990: THEN
1991: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1992: END IF;
1993: --
1994: IF l_debug_on THEN
1995: wsh_debug_sv.push (l_module_name, 'Rtrim_stops_blank_space');

Line 1995: wsh_debug_sv.push (l_module_name, 'Rtrim_stops_blank_space');

1991: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1992: END IF;
1993: --
1994: IF l_debug_on THEN
1995: wsh_debug_sv.push (l_module_name, 'Rtrim_stops_blank_space');
1996: END IF;
1997:
1998: p_out_rec := p_in_rec;
1999:

Line 2045: WSH_DEBUG_SV.pop(l_module_name);

2041: p_out_rec.VOLUME_UOM_DESC := RTRIM(p_in_rec.VOLUME_UOM_DESC);
2042: p_out_rec.PENDING_INTERFACE_FLAG := RTRIM(p_in_rec.PENDING_INTERFACE_FLAG);
2043:
2044: IF l_debug_on THEN
2045: WSH_DEBUG_SV.pop(l_module_name);
2046: END IF;
2047:
2048: EXCEPTION
2049:

Line 2054: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||

2050: WHEN OTHERS THEN
2051: wsh_util_core.default_handler (
2052: 'WSH_TRIP_STOPS_GRP.Rtrim_stops_blank_space', l_module_name);
2053: IF l_debug_on THEN
2054: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2055: ' Oracle error message is '|| SQLERRM,
2056: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2058: END IF;

Line 2056: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2052: 'WSH_TRIP_STOPS_GRP.Rtrim_stops_blank_space', l_module_name);
2053: IF l_debug_on THEN
2054: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2055: ' Oracle error message is '|| SQLERRM,
2056: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2058: END IF;
2059: RAISE;
2060:

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

2053: IF l_debug_on THEN
2054: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2055: ' Oracle error message is '|| SQLERRM,
2056: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2057: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2058: END IF;
2059: RAISE;
2060:
2061: END Rtrim_stops_blank_space;

Line 2110: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2106: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2107: --
2108: IF l_debug_on IS NULL
2109: THEN
2110: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2111: END IF;
2112: --
2113: SAVEPOINT create_update_stop_wrap_grp;
2114:

Line 2116: wsh_debug_sv.push(l_module_name);

2112: --
2113: SAVEPOINT create_update_stop_wrap_grp;
2114:
2115: IF l_debug_on THEN
2116: wsh_debug_sv.push(l_module_name);
2117: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2118: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2119: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2120: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);

Line 2117: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);

2113: SAVEPOINT create_update_stop_wrap_grp;
2114:
2115: IF l_debug_on THEN
2116: wsh_debug_sv.push(l_module_name);
2117: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2118: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2119: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2120: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
2121: END IF;

Line 2118: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);

2114:
2115: IF l_debug_on THEN
2116: wsh_debug_sv.push(l_module_name);
2117: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2118: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2119: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2120: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
2121: END IF;
2122:

Line 2119: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);

2115: IF l_debug_on THEN
2116: wsh_debug_sv.push(l_module_name);
2117: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2118: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2119: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2120: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
2121: END IF;
2122:
2123: l_in_rec := p_in_rec;

Line 2120: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);

2116: wsh_debug_sv.push(l_module_name);
2117: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2118: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2119: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2120: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_rec_attr_tab.COUNT);
2121: END IF;
2122:
2123: l_in_rec := p_in_rec;
2124: l_in_rec.caller := RTRIM(p_in_rec.caller);

Line 2161: WSH_DEBUG_SV.pop(l_module_name);

2157: p_count => x_msg_count,
2158: p_data => x_msg_data);
2159: --
2160: IF l_debug_on THEN
2161: WSH_DEBUG_SV.pop(l_module_name);
2162: END IF;
2163: --
2164: EXCEPTION
2165: WHEN FND_API.G_EXC_ERROR THEN

Line 2176: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2172: p_encoded => FND_API.G_FALSE
2173: );
2174: --
2175: IF l_debug_on THEN
2176: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2177: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2178: END IF;
2179: --
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2173: );
2174: --
2175: IF l_debug_on THEN
2176: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2177: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2178: END IF;
2179: --
2180: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181: ROLLBACK TO create_update_stop_wrap_grp;

Line 2191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2187: p_encoded => FND_API.G_FALSE
2188: );
2189: --
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2193: END IF;
2194: --
2195: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2188: );
2189: --
2190: IF l_debug_on THEN
2191: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2192: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2193: END IF;
2194: --
2195: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2196: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2201: p_encoded => FND_API.G_FALSE
2202: );
2203: --
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2207: END IF;
2208: WHEN OTHERS THEN
2209: ROLLBACK TO create_update_stop_wrap_grp;

Line 2206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2202: );
2203: --
2204: IF l_debug_on THEN
2205: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2206: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2207: END IF;
2208: WHEN OTHERS THEN
2209: ROLLBACK TO create_update_stop_wrap_grp;
2210: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2216: p_encoded => FND_API.G_FALSE
2217: );
2218: --
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2222: END IF;
2223: --
2224: END Create_Update_Stop;

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

2217: );
2218: --
2219: IF l_debug_on THEN
2220: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2221: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2222: END IF;
2223: --
2224: END Create_Update_Stop;
2225:

Line 2239: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2235: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2236: --
2237: IF l_debug_on IS NULL
2238: THEN
2239: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2240: END IF;
2241: --
2242: IF l_debug_on THEN
2243: wsh_debug_sv.push (l_module_name, 'Rtrim_trips_blank_space');

Line 2243: wsh_debug_sv.push (l_module_name, 'Rtrim_trips_blank_space');

2239: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2240: END IF;
2241: --
2242: IF l_debug_on THEN
2243: wsh_debug_sv.push (l_module_name, 'Rtrim_trips_blank_space');
2244: END IF;
2245:
2246: p_out_rec := p_in_rec;
2247:

Line 2295: WSH_DEBUG_SV.pop(l_module_name);

2291: p_out_rec.CARRIER_REFERENCE_NUMBER := RTRIM(p_in_rec.CARRIER_REFERENCE_NUMBER);
2292: p_out_rec.CONSIGNEE_CARRIER_AC_NO := RTRIM(p_in_rec.CONSIGNEE_CARRIER_AC_NO);
2293:
2294: IF l_debug_on THEN
2295: WSH_DEBUG_SV.pop(l_module_name);
2296: END IF;
2297:
2298: EXCEPTION
2299:

Line 2304: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||

2300: WHEN OTHERS THEN
2301: wsh_util_core.default_handler (
2302: 'WSH_TRIP_STOPS_GRP.Rtrim_trips_blank_space', l_module_name);
2303: IF l_debug_on THEN
2304: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2305: ' Oracle error message is '|| SQLERRM,
2306: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2308: END IF;

Line 2306: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2302: 'WSH_TRIP_STOPS_GRP.Rtrim_trips_blank_space', l_module_name);
2303: IF l_debug_on THEN
2304: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2305: ' Oracle error message is '|| SQLERRM,
2306: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2308: END IF;
2309: RAISE;
2310:

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

2303: IF l_debug_on THEN
2304: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2305: ' Oracle error message is '|| SQLERRM,
2306: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2307: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2308: END IF;
2309: RAISE;
2310:
2311: END Rtrim_trips_blank_space;

Line 2356: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2352: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2353: --
2354: IF l_debug_on IS NULL
2355: THEN
2356: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2357: END IF;
2358: --
2359: SAVEPOINT create_update_trip_wrap_grp;
2360:

Line 2362: wsh_debug_sv.push(l_module_name);

2358: --
2359: SAVEPOINT create_update_trip_wrap_grp;
2360:
2361: IF l_debug_on THEN
2362: wsh_debug_sv.push(l_module_name);
2363: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2364: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2365: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2366: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_trip_info_tab.COUNT);

Line 2363: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);

2359: SAVEPOINT create_update_trip_wrap_grp;
2360:
2361: IF l_debug_on THEN
2362: wsh_debug_sv.push(l_module_name);
2363: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2364: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2365: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2366: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_trip_info_tab.COUNT);
2367: END IF;

Line 2364: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);

2360:
2361: IF l_debug_on THEN
2362: wsh_debug_sv.push(l_module_name);
2363: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2364: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2365: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2366: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_trip_info_tab.COUNT);
2367: END IF;
2368:

Line 2365: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);

2361: IF l_debug_on THEN
2362: wsh_debug_sv.push(l_module_name);
2363: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2364: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2365: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2366: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_trip_info_tab.COUNT);
2367: END IF;
2368:
2369: l_in_rec := p_in_rec;

Line 2366: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_trip_info_tab.COUNT);

2362: wsh_debug_sv.push(l_module_name);
2363: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2364: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2365: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2366: wsh_debug_sv.log(l_module_name,'Number of Records is ', p_trip_info_tab.COUNT);
2367: END IF;
2368:
2369: l_in_rec := p_in_rec;
2370: l_in_rec.caller := RTRIM(p_in_rec.caller);

Line 2405: WSH_DEBUG_SV.pop(l_module_name);

2401: p_count => x_msg_count,
2402: p_data => x_msg_data);
2403: --
2404: IF l_debug_on THEN
2405: WSH_DEBUG_SV.pop(l_module_name);
2406: END IF;
2407: --
2408: EXCEPTION
2409: WHEN FND_API.G_EXC_ERROR THEN

Line 2420: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2416: p_encoded => FND_API.G_FALSE
2417: );
2418: --
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2422: END IF;
2423: --
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2417: );
2418: --
2419: IF l_debug_on THEN
2420: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2421: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2422: END IF;
2423: --
2424: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2425: ROLLBACK TO create_update_trip_wrap_grp;

Line 2435: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2431: p_encoded => FND_API.G_FALSE
2432: );
2433: --
2434: IF l_debug_on THEN
2435: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2437: END IF;
2438: --
2439: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 2436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2432: );
2433: --
2434: IF l_debug_on THEN
2435: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2436: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2437: END IF;
2438: --
2439: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2440: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2449: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2445: p_encoded => FND_API.G_FALSE
2446: );
2447: --
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2451: END IF;
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_update_trip_wrap_grp;

Line 2450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2446: );
2447: --
2448: IF l_debug_on THEN
2449: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2450: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2451: END IF;
2452: WHEN OTHERS THEN
2453: ROLLBACK TO create_update_trip_wrap_grp;
2454: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2460: p_encoded => FND_API.G_FALSE
2461: );
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2466: END IF;
2467: --
2468: END Create_Update_Trip;

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

2461: );
2462: --
2463: IF l_debug_on THEN
2464: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2465: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2466: END IF;
2467: --
2468: END Create_Update_Trip;
2469:

Line 2483: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2479: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2480: --
2481: IF l_debug_on IS NULL
2482: THEN
2483: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2484: END IF;
2485: --
2486: IF l_debug_on THEN
2487: wsh_debug_sv.push (l_module_name, 'Rtrim_freightcost_blank_space');

Line 2487: wsh_debug_sv.push (l_module_name, 'Rtrim_freightcost_blank_space');

2483: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2484: END IF;
2485: --
2486: IF l_debug_on THEN
2487: wsh_debug_sv.push (l_module_name, 'Rtrim_freightcost_blank_space');
2488: END IF;
2489:
2490: p_out_rec := p_in_rec;
2491:

Line 2521: WSH_DEBUG_SV.pop(l_module_name);

2517: p_out_rec.DELIVERY_NAME := RTRIM(p_in_rec.DELIVERY_NAME);
2518: p_out_rec.FREIGHT_COST_TYPE := RTRIM(p_in_rec.FREIGHT_COST_TYPE);
2519:
2520: IF l_debug_on THEN
2521: WSH_DEBUG_SV.pop(l_module_name);
2522: END IF;
2523:
2524: EXCEPTION
2525:

Line 2530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||

2526: WHEN OTHERS THEN
2527: wsh_util_core.default_handler (
2528: 'WSH_TRIP_STOPS_GRP.Rtrim_freightcost_blank_space', l_module_name);
2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2531: ' Oracle error message is '|| SQLERRM,
2532: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2534: END IF;

Line 2532: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2528: 'WSH_TRIP_STOPS_GRP.Rtrim_freightcost_blank_space', l_module_name);
2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2531: ' Oracle error message is '|| SQLERRM,
2532: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2534: END IF;
2535: RAISE;
2536:

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

2529: IF l_debug_on THEN
2530: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured.'||
2531: ' Oracle error message is '|| SQLERRM,
2532: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2533: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2534: END IF;
2535: RAISE;
2536:
2537: END Rtrim_freightcost_blank_space;

Line 2569: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2565: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2566: --
2567: IF l_debug_on IS NULL
2568: THEN
2569: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2570: END IF;
2571: --
2572: SAVEPOINT Create_Update_Freight_Costs_WG;
2573:

Line 2575: wsh_debug_sv.push(l_module_name);

2571: --
2572: SAVEPOINT Create_Update_Freight_Costs_WG;
2573:
2574: IF l_debug_on THEN
2575: wsh_debug_sv.push(l_module_name);
2576: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2577: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2578: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2579: END IF;

Line 2576: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);

2572: SAVEPOINT Create_Update_Freight_Costs_WG;
2573:
2574: IF l_debug_on THEN
2575: wsh_debug_sv.push(l_module_name);
2576: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2577: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2578: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2579: END IF;
2580:

Line 2577: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);

2573:
2574: IF l_debug_on THEN
2575: wsh_debug_sv.push(l_module_name);
2576: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2577: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2578: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2579: END IF;
2580:
2581: l_in_rec := p_in_rec;

Line 2578: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);

2574: IF l_debug_on THEN
2575: wsh_debug_sv.push(l_module_name);
2576: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2577: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2578: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2579: END IF;
2580:
2581: l_in_rec := p_in_rec;
2582: l_in_rec.caller := RTRIM(p_in_rec.caller);

Line 2617: WSH_DEBUG_SV.pop(l_module_name);

2613: p_count => x_msg_count,
2614: p_data => x_msg_data);
2615: --
2616: IF l_debug_on THEN
2617: WSH_DEBUG_SV.pop(l_module_name);
2618: END IF;
2619: --
2620: EXCEPTION
2621: WHEN FND_API.G_EXC_ERROR THEN

Line 2632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2628: p_encoded => FND_API.G_FALSE
2629: );
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2634: END IF;
2635: --
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

2629: );
2630: --
2631: IF l_debug_on THEN
2632: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_ERROR exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2633: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_ERROR');
2634: END IF;
2635: --
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637: ROLLBACK TO Create_Update_Freight_Costs_WG;

Line 2647: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2643: p_encoded => FND_API.G_FALSE
2644: );
2645: --
2646: IF l_debug_on THEN
2647: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2648: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2649: END IF;
2650: --
2651: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

Line 2648: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

2644: );
2645: --
2646: IF l_debug_on THEN
2647: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2648: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
2649: END IF;
2650: --
2651: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN
2652: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 2661: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);

2657: p_encoded => FND_API.G_FALSE
2658: );
2659: --
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2663: END IF;
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Create_Update_Freight_Costs_WG;

Line 2662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');

2658: );
2659: --
2660: IF l_debug_on THEN
2661: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2662: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2663: END IF;
2664: WHEN OTHERS THEN
2665: ROLLBACK TO Create_Update_Freight_Costs_WG;
2666: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;

Line 2676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2672: p_encoded => FND_API.G_FALSE
2673: );
2674: --
2675: IF l_debug_on THEN
2676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2678: END IF;
2679: --
2680: END Create_Update_Freight_costs;

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

2673: );
2674: --
2675: IF l_debug_on THEN
2676: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2677: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2678: END IF;
2679: --
2680: END Create_Update_Freight_costs;
2681: -- heali

Line 2726: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2722: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2723: --
2724: IF l_debug_on IS NULL
2725: THEN
2726: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2727: END IF;
2728: IF l_debug_on THEN
2729: WSH_DEBUG_SV.push(l_module_name);
2730: END IF;

Line 2729: WSH_DEBUG_SV.push(l_module_name);

2725: THEN
2726: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2727: END IF;
2728: IF l_debug_on THEN
2729: WSH_DEBUG_SV.push(l_module_name);
2730: END IF;
2731:
2732: WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg(
2733: p_api_version_number => p_api_version_number,

Line 2744: WSH_DEBUG_SV.pop(l_module_name);

2740: x_msg_count => x_msg_count,
2741: x_msg_data => x_msg_data);
2742:
2743: IF l_debug_on THEN
2744: WSH_DEBUG_SV.pop(l_module_name);
2745: END IF;
2746:
2747:
2748: EXCEPTION

Line 2755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

2751: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2756: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2757: END IF;
2758:
2759: END Update_Delivery_Leg;

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

2752: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2753: --
2754: IF l_debug_on THEN
2755: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2756: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2757: END IF;
2758:
2759: END Update_Delivery_Leg;
2760: