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 425: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 431: wsh_debug_sv.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

507: x_msg_count => x_msg_count,
508: x_msg_data => x_msg_data);
509: --
510: IF l_debug_on THEN
511: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
512: END IF;
513:
514: wsh_util_core.api_post_call(
515: p_return_status =>x_return_status,

Line 532: WSH_DEBUG_SV.pop(l_module_name);

528: p_count => x_msg_count,
529: p_data => x_msg_data);
530: --
531: IF l_debug_on THEN
532: WSH_DEBUG_SV.pop(l_module_name);
533: END IF;
534: --
535: EXCEPTION
536: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 611: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

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

611: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
612: END IF;
613: --
614: IF l_debug_on THEN
615: wsh_debug_sv.push (l_module_name, 'Rtrim_deliveries_blank_space');
616: END IF;
617:
618: p_out_rec := p_in_rec;
619:

Line 730: WSH_DEBUG_SV.pop(l_module_name);

726: /*3667348*/
727: p_out_rec.REASON_OF_TRANSPORT := RTRIM(p_in_rec.REASON_OF_TRANSPORT);
728: p_out_rec.DESCRIPTION := RTRIM(p_in_rec.DESCRIPTION);
729: IF l_debug_on THEN
730: WSH_DEBUG_SV.pop(l_module_name);
731: END IF;
732:
733: EXCEPTION
734:

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

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

Line 741: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 803: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

799: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
800: --
801: IF l_debug_on IS NULL
802: THEN
803: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
804: END IF;
805: --
806: SAVEPOINT CREATE_UPDATE_DEL_WRAP_GRP;
807: --

Line 809: wsh_debug_sv.push(l_module_name);

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

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

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

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

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

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

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

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

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

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

839: x_msg_count => x_msg_count,
840: x_msg_data => x_msg_data);
841: --
842: IF l_debug_on THEN
843: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
844: END IF;
845: --
846: wsh_util_core.api_post_call(
847: p_return_status =>x_return_status,

Line 864: WSH_DEBUG_SV.pop(l_module_name);

860: p_count => x_msg_count,
861: p_data => x_msg_data);
862: --
863: IF l_debug_on THEN
864: WSH_DEBUG_SV.pop(l_module_name);
865: END IF;
866: --
867: EXCEPTION
868: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1022: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1018: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1019: --
1020: IF l_debug_on IS NULL
1021: THEN
1022: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1023: END IF;
1024: --
1025: SAVEPOINT DEL_DETAIL_ACTION_WRAP_GRP;
1026:

Line 1028: WSH_DEBUG_SV.push(l_module_name);

1024: --
1025: SAVEPOINT DEL_DETAIL_ACTION_WRAP_GRP;
1026:
1027: IF l_debug_on THEN
1028: WSH_DEBUG_SV.push(l_module_name);
1029: --
1030: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1031: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1032: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

1026:
1027: IF l_debug_on THEN
1028: WSH_DEBUG_SV.push(l_module_name);
1029: --
1030: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1031: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1032: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1033: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1034: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);

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

1027: IF l_debug_on THEN
1028: WSH_DEBUG_SV.push(l_module_name);
1029: --
1030: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1031: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1032: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1033: WSH_DEBUG_SV.log(l_module_name, 'Caller', p_action_prms.caller);
1034: WSH_DEBUG_SV.log(l_module_name, 'Phase', p_action_prms.phase);
1035: WSH_DEBUG_SV.log(l_module_name, 'Action Code', p_action_prms.action_code);

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

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

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

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

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

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

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

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

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

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

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

1050:
1051:
1052: IF(p_detail_id_tab.count = 0) THEN
1053: IF l_debug_on THEN
1054: wsh_debug_sv.log (l_module_name,'Input Table Count Zero');
1055: END IF;
1056: RAISE FND_API.G_EXC_ERROR;
1057: END IF;
1058:

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

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

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

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

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

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

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

1144:
1145: -- Standard check of p_commit.
1146: IF FND_API.To_Boolean( p_commit ) THEN
1147: IF l_debug_on THEN
1148: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');
1149: END IF;
1150: COMMIT WORK;
1151: END IF;
1152:

Line 1160: WSH_DEBUG_SV.pop(l_module_name);

1156: p_data => x_msg_data
1157: );
1158:
1159: IF l_debug_on THEN
1160: WSH_DEBUG_SV.pop(l_module_name);
1161: END IF;
1162: --
1163: EXCEPTION
1164: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1239: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

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

1239: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1240: END IF;
1241: --
1242: IF l_debug_on THEN
1243: wsh_debug_sv.push (l_module_name, 'Rtrim_details_blank_space');
1244: END IF;
1245:
1246: p_out_rec := p_in_rec;
1247:

Line 1336: WSH_DEBUG_SV.pop(l_module_name);

1332: p_out_rec.pickable_flag := RTRIM(p_in_rec.pickable_flag);
1333: p_out_rec.original_subinventory := RTRIM(p_in_rec.original_subinventory);
1334:
1335: IF l_debug_on THEN
1336: WSH_DEBUG_SV.pop(l_module_name);
1337: END IF;
1338:
1339: EXCEPTION
1340:

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

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

Line 1347: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 1421: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1417: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1418: --
1419: IF l_debug_on IS NULL
1420: THEN
1421: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1422: END IF;
1423: --
1424: SAVEPOINT CREATE_UPD_DEL_DET_WRAP_GRP;
1425: --

Line 1429: WSH_DEBUG_SV.push(l_module_name);

1425: --
1426: -- Debug Statements
1427: --
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.push(l_module_name);
1430: --
1431: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1432: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1433: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);

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

1427: --
1428: IF l_debug_on THEN
1429: WSH_DEBUG_SV.push(l_module_name);
1430: --
1431: WSH_DEBUG_SV.log(l_module_name,'P_API_VERSION_NUMBER',P_API_VERSION_NUMBER);
1432: WSH_DEBUG_SV.log(l_module_name,'P_INIT_MSG_LIST',P_INIT_MSG_LIST);
1433: WSH_DEBUG_SV.log(l_module_name,'P_COMMIT',P_COMMIT);
1434: END IF;
1435: --

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

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

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

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

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

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

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

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

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

1498:
1499: -- Standard check of p_commit.
1500: IF FND_API.To_Boolean( p_commit ) THEN
1501: IF l_debug_on THEN
1502: WSH_DEBUG_SV.logmsg(l_module_name, 'Commit Work');
1503: END IF;
1504: COMMIT WORK;
1505: END IF;
1506:

Line 1514: WSH_DEBUG_SV.pop(l_module_name);

1510: p_data => x_msg_data
1511: );
1512:
1513: IF l_debug_on THEN
1514: WSH_DEBUG_SV.pop(l_module_name);
1515: END IF;
1516: --
1517: EXCEPTION
1518: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

1541: );
1542:
1543: --
1544: IF l_debug_on THEN
1545: WSH_DEBUG_SV.logmsg(l_module_name,'FND_API.G_EXC_UNEXPECTED_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
1546: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
1547: END IF;
1548: --
1549: WHEN WSH_UTIL_CORE.G_EXC_WARNING THEN

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

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

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

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

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

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

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

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

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

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

Line 1641: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1637: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1638: --
1639: IF l_debug_on IS NULL
1640: THEN
1641: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1642: END IF;
1643: --
1644: IF l_debug_on THEN
1645: wsh_debug_sv.push (l_module_name);

Line 1645: wsh_debug_sv.push (l_module_name);

1641: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1642: END IF;
1643: --
1644: IF l_debug_on THEN
1645: wsh_debug_sv.push (l_module_name);
1646: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1647: END IF;
1648:
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

1642: END IF;
1643: --
1644: IF l_debug_on THEN
1645: wsh_debug_sv.push (l_module_name);
1646: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1647: END IF;
1648:
1649: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1650:

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1716: x_msg_data => x_msg_data
1717: );
1718:
1719: IF l_debug_on THEN
1720: wsh_debug_sv.log (l_module_name,'x_return_status', x_return_status);
1721: END IF;
1722:
1723: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1724: x_num_warnings =>l_num_warning,

Line 1739: WSH_DEBUG_SV.pop(l_module_name);

1735: );
1736:
1737: IF l_debug_on THEN
1738:
1739: WSH_DEBUG_SV.pop(l_module_name);
1740: END IF;
1741:
1742: EXCEPTION
1743: WHEN FND_API.G_EXC_ERROR THEN

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

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

Line 1751: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1761: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1771: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1784: WSH_DEBUG_SV.pop(l_module_name);

1780:
1781: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1782: IF l_debug_on THEN
1783: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1784: WSH_DEBUG_SV.pop(l_module_name);
1785: END IF;
1786:
1787: END Trip_Action;
1788:

Line 1847: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1843: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1844: --
1845: IF l_debug_on IS NULL
1846: THEN
1847: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1848: END IF;
1849: --
1850: IF l_debug_on THEN
1851: wsh_debug_sv.push (l_module_name);

Line 1851: wsh_debug_sv.push (l_module_name);

1847: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1848: END IF;
1849: --
1850: IF l_debug_on THEN
1851: wsh_debug_sv.push (l_module_name);
1852: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1853: END IF;
1854:
1855: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

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

1848: END IF;
1849: --
1850: IF l_debug_on THEN
1851: wsh_debug_sv.push (l_module_name);
1852: wsh_debug_sv.log (l_module_name,'phase', p_action_prms.phase);
1853: END IF;
1854:
1855: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1856:

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

1884:
1885: IF (c_attributes%NOTFOUND) THEN
1886: CLOSE c_attributes;
1887: IF l_debug_on THEN
1888: wsh_debug_sv.log (l_module_name,'WSH_BAD_ENTITY');
1889: END IF;
1890: RAISE FND_API.G_EXC_ERROR;
1891: END IF;
1892: CLOSE c_attributes;

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

1907: x_msg_data =>x_msg_data
1908: );
1909:
1910: IF l_debug_on THEN
1911: wsh_debug_sv.log (l_module_name,'l_return_status', l_return_status);
1912: END IF;
1913:
1914: wsh_util_core.api_post_call(p_return_status =>l_return_status,
1915: x_num_warnings =>l_num_warning,

Line 1930: WSH_DEBUG_SV.pop(l_module_name);

1926: , p_data => x_msg_data
1927: );
1928:
1929: IF l_debug_on THEN
1930: WSH_DEBUG_SV.pop(l_module_name);
1931: END IF;
1932:
1933: EXCEPTION
1934: WHEN FND_API.G_EXC_ERROR THEN

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

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

Line 1942: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1952: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1962: WSH_DEBUG_SV.pop(l_module_name);

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

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

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

Line 1975: WSH_DEBUG_SV.pop(l_module_name);

1971:
1972: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1973: IF l_debug_on THEN
1974: wsh_debug_sv.log (l_module_name,'Error',substr(sqlerrm,1,200));
1975: WSH_DEBUG_SV.pop(l_module_name);
1976: END IF;
1977:
1978: END Stop_Action;
1979:

Line 1995: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

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

1995: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1996: END IF;
1997: --
1998: IF l_debug_on THEN
1999: wsh_debug_sv.push (l_module_name, 'Rtrim_stops_blank_space');
2000: END IF;
2001:
2002: p_out_rec := p_in_rec;
2003:

Line 2049: WSH_DEBUG_SV.pop(l_module_name);

2045: p_out_rec.VOLUME_UOM_DESC := RTRIM(p_in_rec.VOLUME_UOM_DESC);
2046: p_out_rec.PENDING_INTERFACE_FLAG := RTRIM(p_in_rec.PENDING_INTERFACE_FLAG);
2047:
2048: IF l_debug_on THEN
2049: WSH_DEBUG_SV.pop(l_module_name);
2050: END IF;
2051:
2052: EXCEPTION
2053:

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

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

Line 2060: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 2114: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2110: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2111: --
2112: IF l_debug_on IS NULL
2113: THEN
2114: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2115: END IF;
2116: --
2117: SAVEPOINT create_update_stop_wrap_grp;
2118:

Line 2120: wsh_debug_sv.push(l_module_name);

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

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

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

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

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

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

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

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

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

Line 2165: WSH_DEBUG_SV.pop(l_module_name);

2161: p_count => x_msg_count,
2162: p_data => x_msg_data);
2163: --
2164: IF l_debug_on THEN
2165: WSH_DEBUG_SV.pop(l_module_name);
2166: END IF;
2167: --
2168: EXCEPTION
2169: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2243: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

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

2243: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2244: END IF;
2245: --
2246: IF l_debug_on THEN
2247: wsh_debug_sv.push (l_module_name, 'Rtrim_trips_blank_space');
2248: END IF;
2249:
2250: p_out_rec := p_in_rec;
2251:

Line 2299: WSH_DEBUG_SV.pop(l_module_name);

2295: p_out_rec.CARRIER_REFERENCE_NUMBER := RTRIM(p_in_rec.CARRIER_REFERENCE_NUMBER);
2296: p_out_rec.CONSIGNEE_CARRIER_AC_NO := RTRIM(p_in_rec.CONSIGNEE_CARRIER_AC_NO);
2297:
2298: IF l_debug_on THEN
2299: WSH_DEBUG_SV.pop(l_module_name);
2300: END IF;
2301:
2302: EXCEPTION
2303:

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

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

Line 2310: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 2360: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2356: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2357: --
2358: IF l_debug_on IS NULL
2359: THEN
2360: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2361: END IF;
2362: --
2363: SAVEPOINT create_update_trip_wrap_grp;
2364:

Line 2366: wsh_debug_sv.push(l_module_name);

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

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

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

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

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

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

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

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

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

Line 2409: WSH_DEBUG_SV.pop(l_module_name);

2405: p_count => x_msg_count,
2406: p_data => x_msg_data);
2407: --
2408: IF l_debug_on THEN
2409: WSH_DEBUG_SV.pop(l_module_name);
2410: END IF;
2411: --
2412: EXCEPTION
2413: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2487: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

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

2487: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2488: END IF;
2489: --
2490: IF l_debug_on THEN
2491: wsh_debug_sv.push (l_module_name, 'Rtrim_freightcost_blank_space');
2492: END IF;
2493:
2494: p_out_rec := p_in_rec;
2495:

Line 2525: WSH_DEBUG_SV.pop(l_module_name);

2521: p_out_rec.DELIVERY_NAME := RTRIM(p_in_rec.DELIVERY_NAME);
2522: p_out_rec.FREIGHT_COST_TYPE := RTRIM(p_in_rec.FREIGHT_COST_TYPE);
2523:
2524: IF l_debug_on THEN
2525: WSH_DEBUG_SV.pop(l_module_name);
2526: END IF;
2527:
2528: EXCEPTION
2529:

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

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

Line 2536: WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

Line 2573: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2569: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2570: --
2571: IF l_debug_on IS NULL
2572: THEN
2573: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2574: END IF;
2575: --
2576: SAVEPOINT Create_Update_Freight_Costs_WG;
2577:

Line 2579: wsh_debug_sv.push(l_module_name);

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

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

2576: SAVEPOINT Create_Update_Freight_Costs_WG;
2577:
2578: IF l_debug_on THEN
2579: wsh_debug_sv.push(l_module_name);
2580: wsh_debug_sv.log(l_module_name,'Caller is ', p_in_rec.caller);
2581: wsh_debug_sv.log(l_module_name,'Phase is ', p_in_rec.phase);
2582: wsh_debug_sv.log(l_module_name,'Action Code is ', p_in_rec.action_code);
2583: END IF;
2584:

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

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

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

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

Line 2621: WSH_DEBUG_SV.pop(l_module_name);

2617: p_count => x_msg_count,
2618: p_data => x_msg_data);
2619: --
2620: IF l_debug_on THEN
2621: WSH_DEBUG_SV.pop(l_module_name);
2622: END IF;
2623: --
2624: EXCEPTION
2625: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2730: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

2726: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
2727: --
2728: IF l_debug_on IS NULL
2729: THEN
2730: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2731: END IF;
2732: IF l_debug_on THEN
2733: WSH_DEBUG_SV.push(l_module_name);
2734: END IF;

Line 2733: WSH_DEBUG_SV.push(l_module_name);

2729: THEN
2730: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
2731: END IF;
2732: IF l_debug_on THEN
2733: WSH_DEBUG_SV.push(l_module_name);
2734: END IF;
2735:
2736: WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg(
2737: p_api_version_number => p_api_version_number,

Line 2748: WSH_DEBUG_SV.pop(l_module_name);

2744: x_msg_count => x_msg_count,
2745: x_msg_data => x_msg_data);
2746:
2747: IF l_debug_on THEN
2748: WSH_DEBUG_SV.pop(l_module_name);
2749: END IF;
2750:
2751:
2752: EXCEPTION

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

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

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

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