eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_TP_GRP dependencies on WSH_DEBUG_SV

Line 51: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

47: BEGIN
48: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
49: --
50: IF l_debug_on IS NULL THEN
51: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
52: END IF;
53:
54: IF l_debug_on THEN
55: WSH_DEBUG_SV.push(l_module_name);

Line 55: WSH_DEBUG_SV.push(l_module_name);

51: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
52: END IF;
53:
54: IF l_debug_on THEN
55: WSH_DEBUG_SV.push(l_module_name);
56: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id', p_trip_id);
57: END IF;
58:
59: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 56: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id', p_trip_id);

52: END IF;
53:
54: IF l_debug_on THEN
55: WSH_DEBUG_SV.push(l_module_name);
56: WSH_DEBUG_SV.log(l_module_name, 'p_trip_id', p_trip_id);
57: END IF;
58:
59: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
60:

Line 77: WSH_DEBUG_SV.log(l_module_name, 'move_id', x_int_cm_info_rec.move_id);

73: --
74: --
75:
76: IF l_debug_on THEN
77: WSH_DEBUG_SV.log(l_module_name, 'move_id', x_int_cm_info_rec.move_id);
78: WSH_DEBUG_SV.log(l_module_name, 'cm_trip_number', x_int_cm_info_rec.cm_trip_number);
79: WSH_DEBUG_SV.log(l_module_name, 'sequence_number', x_int_cm_info_rec.sequence_number);
80: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
81: WSH_DEBUG_SV.pop(l_module_name);

Line 78: WSH_DEBUG_SV.log(l_module_name, 'cm_trip_number', x_int_cm_info_rec.cm_trip_number);

74: --
75:
76: IF l_debug_on THEN
77: WSH_DEBUG_SV.log(l_module_name, 'move_id', x_int_cm_info_rec.move_id);
78: WSH_DEBUG_SV.log(l_module_name, 'cm_trip_number', x_int_cm_info_rec.cm_trip_number);
79: WSH_DEBUG_SV.log(l_module_name, 'sequence_number', x_int_cm_info_rec.sequence_number);
80: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
81: WSH_DEBUG_SV.pop(l_module_name);
82: END IF;

Line 79: WSH_DEBUG_SV.log(l_module_name, 'sequence_number', x_int_cm_info_rec.sequence_number);

75:
76: IF l_debug_on THEN
77: WSH_DEBUG_SV.log(l_module_name, 'move_id', x_int_cm_info_rec.move_id);
78: WSH_DEBUG_SV.log(l_module_name, 'cm_trip_number', x_int_cm_info_rec.cm_trip_number);
79: WSH_DEBUG_SV.log(l_module_name, 'sequence_number', x_int_cm_info_rec.sequence_number);
80: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
81: WSH_DEBUG_SV.pop(l_module_name);
82: END IF;
83:

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

76: IF l_debug_on THEN
77: WSH_DEBUG_SV.log(l_module_name, 'move_id', x_int_cm_info_rec.move_id);
78: WSH_DEBUG_SV.log(l_module_name, 'cm_trip_number', x_int_cm_info_rec.cm_trip_number);
79: WSH_DEBUG_SV.log(l_module_name, 'sequence_number', x_int_cm_info_rec.sequence_number);
80: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
81: WSH_DEBUG_SV.pop(l_module_name);
82: END IF;
83:
84: EXCEPTION

Line 81: WSH_DEBUG_SV.pop(l_module_name);

77: WSH_DEBUG_SV.log(l_module_name, 'move_id', x_int_cm_info_rec.move_id);
78: WSH_DEBUG_SV.log(l_module_name, 'cm_trip_number', x_int_cm_info_rec.cm_trip_number);
79: WSH_DEBUG_SV.log(l_module_name, 'sequence_number', x_int_cm_info_rec.sequence_number);
80: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
81: WSH_DEBUG_SV.pop(l_module_name);
82: END IF;
83:
84: EXCEPTION
85: WHEN OTHERS THEN

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

90: IF c_cm_info%ISOPEN THEN
91: CLOSE c_cm_info;
92: END IF;
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
95: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
96: END IF;
97:
98: END int_lookup_cm_info;

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

91: CLOSE c_cm_info;
92: END IF;
93: IF l_debug_on THEN
94: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
95: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
96: END IF;
97:
98: END int_lookup_cm_info;
99:

Line 211: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

207: BEGIN
208: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
209: --
210: IF l_debug_on IS NULL THEN
211: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
212: END IF;
213:
214: IF l_debug_on THEN
215: WSH_DEBUG_SV.push(l_module_name);

Line 215: WSH_DEBUG_SV.push(l_module_name);

211: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
212: END IF;
213:
214: IF l_debug_on THEN
215: WSH_DEBUG_SV.push(l_module_name);
216: WSH_DEBUG_SV.log(l_module_name, 'p_move_id', p_move_id);
217: END IF;
218:
219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 216: WSH_DEBUG_SV.log(l_module_name, 'p_move_id', p_move_id);

212: END IF;
213:
214: IF l_debug_on THEN
215: WSH_DEBUG_SV.push(l_module_name);
216: WSH_DEBUG_SV.log(l_module_name, 'p_move_id', p_move_id);
217: END IF;
218:
219: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
220: x_locked := 'N';

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

252: --
253: --
254:
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
257: WSH_DEBUG_SV.pop(l_module_name);
258: END IF;
259:
260: EXCEPTION

Line 257: WSH_DEBUG_SV.pop(l_module_name);

253: --
254:
255: IF l_debug_on THEN
256: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
257: WSH_DEBUG_SV.pop(l_module_name);
258: END IF;
259:
260: EXCEPTION
261: WHEN app_exception.application_exception or app_exception.record_lock_exception THEN

Line 268: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

264: FND_MESSAGE.SET_NAME('FTE', 'FTE_MOVE_LOCK');
265: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
266: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
267: IF l_debug_on THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
270: END IF;
271:
272: WHEN OTHERS THEN

Line 269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');

265: FND_MESSAGE.SET_TOKEN('MOVE_ID', p_move_id);
266: WSH_UTIL_CORE.ADD_MESSAGE(x_return_status);
267: IF l_debug_on THEN
268: WSH_DEBUG_SV.logmsg(l_module_name,'APP_EXCEPTION.APPLICATION_EXCEPTION exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);
269: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:APP_EXCEPTION.APPLICATION_EXCEPTION');
270: END IF;
271:
272: WHEN OTHERS THEN
273: IF c_move%ISOPEN THEN

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

286: IF c_cm_info%ISOPEN THEN
287: CLOSE c_cm_info;
288: END IF;
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
291: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
292: END IF;
293:
294: END lookup_move;

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

287: CLOSE c_cm_info;
288: END IF;
289: IF l_debug_on THEN
290: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
291: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
292: END IF;
293:
294: END lookup_move;
295:

Line 327: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

323: BEGIN
324: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
325: --
326: IF l_debug_on IS NULL THEN
327: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
328: END IF;
329:
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.push(l_module_name);

Line 331: WSH_DEBUG_SV.push(l_module_name);

327: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
328: END IF;
329:
330: IF l_debug_on THEN
331: WSH_DEBUG_SV.push(l_module_name);
332: END IF;
333:
334: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
335:

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

355: --
356: --
357:
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
360: WSH_DEBUG_SV.pop(l_module_name);
361: END IF;
362:
363: EXCEPTION

Line 360: WSH_DEBUG_SV.pop(l_module_name);

356: --
357:
358: IF l_debug_on THEN
359: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
360: WSH_DEBUG_SV.pop(l_module_name);
361: END IF;
362:
363: EXCEPTION
364: WHEN OTHERS THEN

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

369: IF c_cm_info%ISOPEN THEN
370: CLOSE c_cm_info;
371: END IF;
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
375: END IF;
376:
377: END lookup_cm_info;

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

370: CLOSE c_cm_info;
371: END IF;
372: IF l_debug_on THEN
373: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
374: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
375: END IF;
376:
377: END lookup_cm_info;
378:

Line 425: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

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

Line 429: WSH_DEBUG_SV.push(l_module_name);

425: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
426: END IF;
427:
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.push(l_module_name);
430: WSH_DEBUG_SV.log(l_module_name, 'action_code', p_action_prms.action_code);
431: WSH_DEBUG_SV.log(l_module_name, 'count of trips', p_rec_attr_tab.COUNT);
432: END IF;
433:

Line 430: WSH_DEBUG_SV.log(l_module_name, 'action_code', p_action_prms.action_code);

426: END IF;
427:
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.push(l_module_name);
430: WSH_DEBUG_SV.log(l_module_name, 'action_code', p_action_prms.action_code);
431: WSH_DEBUG_SV.log(l_module_name, 'count of trips', p_rec_attr_tab.COUNT);
432: END IF;
433:
434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;

Line 431: WSH_DEBUG_SV.log(l_module_name, 'count of trips', p_rec_attr_tab.COUNT);

427:
428: IF l_debug_on THEN
429: WSH_DEBUG_SV.push(l_module_name);
430: WSH_DEBUG_SV.log(l_module_name, 'action_code', p_action_prms.action_code);
431: WSH_DEBUG_SV.log(l_module_name, 'count of trips', p_rec_attr_tab.COUNT);
432: END IF;
433:
434: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
435:

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

450: WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
451: ROLLBACK TO before_trip_callback;
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
455: WSH_DEBUG_SV.pop(l_module_name);
456: END IF;
457: RETURN;
458: END IF;

Line 455: WSH_DEBUG_SV.pop(l_module_name);

451: ROLLBACK TO before_trip_callback;
452: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
453: IF l_debug_on THEN
454: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
455: WSH_DEBUG_SV.pop(l_module_name);
456: END IF;
457: RETURN;
458: END IF;
459:

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

524: --
525: --
526:
527: IF l_debug_on THEN
528: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
529: WSH_DEBUG_SV.pop(l_module_name);
530: END IF;
531:
532: EXCEPTION

Line 529: WSH_DEBUG_SV.pop(l_module_name);

525: --
526:
527: IF l_debug_on THEN
528: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
529: WSH_DEBUG_SV.pop(l_module_name);
530: END IF;
531:
532: EXCEPTION
533: WHEN move_error THEN

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

533: WHEN move_error THEN
534: ROLLBACK TO before_trip_callback;
535: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
538: WSH_DEBUG_SV.pop(l_module_name);
539: END IF;
540:
541: WHEN OTHERS THEN

Line 538: WSH_DEBUG_SV.pop(l_module_name);

534: ROLLBACK TO before_trip_callback;
535: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
536: IF l_debug_on THEN
537: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
538: WSH_DEBUG_SV.pop(l_module_name);
539: END IF;
540:
541: WHEN OTHERS THEN
542: ROLLBACK TO before_trip_callback;

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

544: WSH_UTIL_CORE.DEFAULT_HANDLER(
545: 'FTE_TP_GRP.trip_callback',
546: l_module_name);
547: IF l_debug_on THEN
548: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
550: END IF;
551:
552: END trip_callback;

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

545: 'FTE_TP_GRP.trip_callback',
546: l_module_name);
547: IF l_debug_on THEN
548: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
549: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
550: END IF;
551:
552: END trip_callback;
553:

Line 592: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

588: BEGIN
589: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
590: --
591: IF l_debug_on IS NULL THEN
592: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
593: END IF;
594:
595: IF l_debug_on THEN
596: WSH_DEBUG_SV.push(l_module_name);

Line 596: WSH_DEBUG_SV.push(l_module_name);

592: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
593: END IF;
594:
595: IF l_debug_on THEN
596: WSH_DEBUG_SV.push(l_module_name);
597: END IF;
598:
599: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
600:

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

606: --
607: --
608:
609: IF l_debug_on THEN
610: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
611: WSH_DEBUG_SV.pop(l_module_name);
612: END IF;
613:
614: EXCEPTION

Line 611: WSH_DEBUG_SV.pop(l_module_name);

607: --
608:
609: IF l_debug_on THEN
610: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
611: WSH_DEBUG_SV.pop(l_module_name);
612: END IF;
613:
614: EXCEPTION
615: WHEN OTHERS THEN

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

617: WSH_UTIL_CORE.DEFAULT_HANDLER(
618: 'FTE_TP_GRP.stop_callback',
619: l_module_name);
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
623: END IF;
624:
625: END stop_callback;

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

618: 'FTE_TP_GRP.stop_callback',
619: l_module_name);
620: IF l_debug_on THEN
621: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
622: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
623: END IF;
624:
625: END stop_callback;
626:

Line 731: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

727: BEGIN
728: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
729: --
730: IF l_debug_on IS NULL THEN
731: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
732: END IF;
733:
734: IF l_debug_on THEN
735: WSH_DEBUG_SV.push(l_module_name);

Line 735: WSH_DEBUG_SV.push(l_module_name);

731: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
732: END IF;
733:
734: IF l_debug_on THEN
735: WSH_DEBUG_SV.push(l_module_name);
736: END IF;
737:
738: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
739:

Line 747: WSH_DEBUG_SV.log(l_module_name,

743: l_new_index := 0;
744: FOR imove IN c_tp_interface_moves(x_group_id => x_context.group_id) LOOP --{
745:
746: IF l_debug_on THEN
747: WSH_DEBUG_SV.log(l_module_name,
748: 'imove looping: move_interface_id',
749: imove.move_interface_id);
750: END IF;
751:

Line 767: WSH_DEBUG_SV.log(l_module_name,

763: l_unmapped_trip_moves.DELETE;
764:
765:
766: IF l_debug_on THEN
767: WSH_DEBUG_SV.log(l_module_name,
768: 'x_plan_moves(l_new_index).move_id',
769: x_plan_moves(l_new_index).move_id);
770: END IF;
771:

Line 799: WSH_DEBUG_SV.pop(l_module_name);

795: x_errors_tab => x_errors_tab,
796: x_return_status => l_return_status);
797: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
798: IF l_debug_on THEN
799: WSH_DEBUG_SV.pop(l_module_name);
800: END IF;
801: RETURN;
802: ELSE
803: -- note move's current firm flag

Line 821: WSH_DEBUG_SV.log(l_module_name,

817:
818: FOR itripmove IN c_tp_interface_trip_moves(x_move_interface_id => x_plan_moves(l_new_index).move_interface_id) LOOP --[
819:
820: IF l_debug_on THEN
821: WSH_DEBUG_SV.log(l_module_name,
822: 'itripmove looping: trip_move_interface_id',
823: itripmove.trip_move_interface_id);
824: END IF;
825:

Line 856: WSH_DEBUG_SV.pop(l_module_name);

852: x_errors_tab => x_errors_tab,
853: x_return_status => l_return_status);
854: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
855: IF l_debug_on THEN
856: WSH_DEBUG_SV.pop(l_module_name);
857: END IF;
858: RETURN;
859: END IF;
860:

Line 872: WSH_DEBUG_SV.log(l_module_name,

868: x_plan_trip_moves(l_tm_index).trip_index := l_trip_index;
869: x_plan_trip_moves(l_tm_index).sequence_number := itripmove.sequence_number;
870:
871: IF l_debug_on THEN
872: WSH_DEBUG_SV.log(l_module_name,
873: 'x_plan_trip_moves(l_tm_index).trip_move_id',
874: x_plan_trip_moves(l_tm_index).trip_move_id);
875: END IF;
876: IF x_plan_moves(l_new_index).move_id IS NULL THEN

Line 889: WSH_DEBUG_SV.log(l_module_name,

885: l_map_index := NULL;
886: l_mapped := FALSE;
887:
888: IF l_debug_on THEN
889: WSH_DEBUG_SV.log(l_module_name,
890: 'l_unmapped_trip_moves.COUNT',
891: l_unmapped_trip_moves.COUNT);
892: END IF;
893:

Line 899: WSH_DEBUG_SV.log(l_module_name,

895: l_map_index := l_unmapped_trip_moves.FIRST;
896: WHILE l_map_index IS NOT NULL LOOP
897: -- this is mapped only if key attributes match.
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.log(l_module_name,
900: 'l_unmapped_trip_moves(l_map_index).trip_move_id', l_unmapped_trip_moves(l_map_index).trip_move_id);
901: WSH_DEBUG_SV.log(l_module_name,
902: 'x_plan_trip_moves(l_tm_index).trip_move_id', x_plan_trip_moves(l_tm_index).trip_move_id);
903: END IF;

Line 901: WSH_DEBUG_SV.log(l_module_name,

897: -- this is mapped only if key attributes match.
898: IF l_debug_on THEN
899: WSH_DEBUG_SV.log(l_module_name,
900: 'l_unmapped_trip_moves(l_map_index).trip_move_id', l_unmapped_trip_moves(l_map_index).trip_move_id);
901: WSH_DEBUG_SV.log(l_module_name,
902: 'x_plan_trip_moves(l_tm_index).trip_move_id', x_plan_trip_moves(l_tm_index).trip_move_id);
903: END IF;
904:
905: IF l_debug_on THEN

Line 906: WSH_DEBUG_SV.log(l_module_name,

902: 'x_plan_trip_moves(l_tm_index).trip_move_id', x_plan_trip_moves(l_tm_index).trip_move_id);
903: END IF;
904:
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.log(l_module_name,
907: 'l_unmapped_trip_moves(l_map_index).trip_id', l_unmapped_trip_moves(l_map_index).trip_id);
908: WSH_DEBUG_SV.log(l_module_name,
909: 'x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id', x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id);
910: WSH_DEBUG_SV.log(l_module_name,

Line 908: WSH_DEBUG_SV.log(l_module_name,

904:
905: IF l_debug_on THEN
906: WSH_DEBUG_SV.log(l_module_name,
907: 'l_unmapped_trip_moves(l_map_index).trip_id', l_unmapped_trip_moves(l_map_index).trip_id);
908: WSH_DEBUG_SV.log(l_module_name,
909: 'x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id', x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id);
910: WSH_DEBUG_SV.log(l_module_name,
911: 'l_unmapped_trip_moves(l_map_index).sequence_number', l_unmapped_trip_moves(l_map_index).sequence_number);
912: WSH_DEBUG_SV.log(l_module_name,

Line 910: WSH_DEBUG_SV.log(l_module_name,

906: WSH_DEBUG_SV.log(l_module_name,
907: 'l_unmapped_trip_moves(l_map_index).trip_id', l_unmapped_trip_moves(l_map_index).trip_id);
908: WSH_DEBUG_SV.log(l_module_name,
909: 'x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id', x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id);
910: WSH_DEBUG_SV.log(l_module_name,
911: 'l_unmapped_trip_moves(l_map_index).sequence_number', l_unmapped_trip_moves(l_map_index).sequence_number);
912: WSH_DEBUG_SV.log(l_module_name,
913: 'x_plan_trip_moves(l_tm_index).sequence_number', x_plan_trip_moves(l_tm_index).sequence_number);
914: END IF;

Line 912: WSH_DEBUG_SV.log(l_module_name,

908: WSH_DEBUG_SV.log(l_module_name,
909: 'x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id', x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id);
910: WSH_DEBUG_SV.log(l_module_name,
911: 'l_unmapped_trip_moves(l_map_index).sequence_number', l_unmapped_trip_moves(l_map_index).sequence_number);
912: WSH_DEBUG_SV.log(l_module_name,
913: 'x_plan_trip_moves(l_tm_index).sequence_number', x_plan_trip_moves(l_tm_index).sequence_number);
914: END IF;
915: IF (l_unmapped_trip_moves(l_map_index).trip_id
916: = x_plan_trips(x_plan_trip_moves(l_tm_index).trip_index).trip_id)

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

952: p_token_2_value => x_plan_moves(l_new_index).move_id,
953: x_errors_tab => x_errors_tab,
954: x_return_status => l_return_status);
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
957: WSH_DEBUG_SV.pop(l_module_name);
958: END IF;
959: RETURN;
960: END IF;

Line 957: WSH_DEBUG_SV.pop(l_module_name);

953: x_errors_tab => x_errors_tab,
954: x_return_status => l_return_status);
955: IF l_debug_on THEN
956: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
957: WSH_DEBUG_SV.pop(l_module_name);
958: END IF;
959: RETURN;
960: END IF;
961:

Line 981: WSH_DEBUG_SV.log(l_module_name, 'x_plan_trips.COUNT to remove unmapped moves', x_plan_trips.COUNT);

977: END LOOP; --} imove
978:
979:
980: IF l_debug_on THEN
981: WSH_DEBUG_SV.log(l_module_name, 'x_plan_trips.COUNT to remove unmapped moves', x_plan_trips.COUNT);
982: END IF;
983:
984: l_map_index := 1;
985: l_trip_index := x_plan_trips.FIRST;

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

1004: p_token_1_value => x_plan_trips(l_trip_index).tp_trip_number,
1005: x_errors_tab => x_errors_tab,
1006: x_return_status => l_return_status);
1007: IF l_debug_on THEN
1008: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1009: WSH_DEBUG_SV.pop(l_module_name);
1010: END IF;
1011: RETURN;
1012: END IF;

Line 1009: WSH_DEBUG_SV.pop(l_module_name);

1005: x_errors_tab => x_errors_tab,
1006: x_return_status => l_return_status);
1007: IF l_debug_on THEN
1008: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1009: WSH_DEBUG_SV.pop(l_module_name);
1010: END IF;
1011: RETURN;
1012: END IF;
1013:

Line 1073: WSH_DEBUG_SV.pop(l_module_name);

1069: x_errors_tab => x_errors_tab,
1070: x_return_status => l_return_status);
1071: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
1072: IF l_debug_on THEN
1073: WSH_DEBUG_SV.pop(l_module_name);
1074: END IF;
1075: RETURN;
1076: END IF;
1077:

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

1087: p_token_1_value => x_plan_trips(l_trip_index).tp_trip_number,
1088: x_errors_tab => x_errors_tab,
1089: x_return_status => l_return_status);
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1092: WSH_DEBUG_SV.pop(l_module_name);
1093: END IF;
1094: RETURN;
1095: END IF;

Line 1092: WSH_DEBUG_SV.pop(l_module_name);

1088: x_errors_tab => x_errors_tab,
1089: x_return_status => l_return_status);
1090: IF l_debug_on THEN
1091: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1092: WSH_DEBUG_SV.pop(l_module_name);
1093: END IF;
1094: RETURN;
1095: END IF;
1096:

Line 1112: WSH_DEBUG_SV.log(l_module_name, 'Trip could not be locked: ', move.trip_id);

1108: WHEN OTHERS THEN
1109: -- Do nothing, if it is locked by another process,
1110: -- Unlikely that it will need to be deleted.
1111: IF l_debug_on THEN
1112: WSH_DEBUG_SV.log(l_module_name, 'Trip could not be locked: ', move.trip_id);
1113: END IF;
1114: END;
1115:
1116: END LOOP;

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

1127: --
1128:
1129:
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1132: WSH_DEBUG_SV.pop(l_module_name);
1133: END IF;
1134:
1135: EXCEPTION

Line 1132: WSH_DEBUG_SV.pop(l_module_name);

1128:
1129:
1130: IF l_debug_on THEN
1131: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1132: WSH_DEBUG_SV.pop(l_module_name);
1133: END IF;
1134:
1135: EXCEPTION
1136: WHEN OTHERS THEN

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

1149: WSH_UTIL_CORE.DEFAULT_HANDLER(
1150: 'FTE_TP_GRP.map_moves',
1151: l_module_name);
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1155: END IF;
1156:
1157: END map_moves;

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

1150: 'FTE_TP_GRP.map_moves',
1151: l_module_name);
1152: IF l_debug_on THEN
1153: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1154: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1155: END IF;
1156:
1157: END map_moves;
1158:

Line 1205: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1201: BEGIN
1202: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1203: --
1204: IF l_debug_on IS NULL THEN
1205: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1206: END IF;
1207:
1208: IF l_debug_on THEN
1209: WSH_DEBUG_SV.push(l_module_name);

Line 1209: WSH_DEBUG_SV.push(l_module_name);

1205: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1206: END IF;
1207:
1208: IF l_debug_on THEN
1209: WSH_DEBUG_SV.push(l_module_name);
1210: END IF;
1211:
1212: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1213:

Line 1219: WSH_DEBUG_SV.log(l_module_name, 'x_obsoleted_trip_moves.COUNT', x_obsoleted_trip_moves.COUNT);

1215: --
1216: --
1217:
1218: IF l_debug_on THEN
1219: WSH_DEBUG_SV.log(l_module_name, 'x_obsoleted_trip_moves.COUNT', x_obsoleted_trip_moves.COUNT);
1220: END IF;
1221:
1222: -- first, remove obsoleted trip moves in order to avoid duplicate data.
1223: IF x_obsoleted_trip_moves.COUNT > 0 THEN

Line 1251: WSH_DEBUG_SV.pop(l_module_name);

1247: p_token_1_value => x_obsoleted_trip_moves(l_tm_index).move_id,
1248: x_errors_tab => x_errors_tab,
1249: x_return_status => l_return_status);
1250: IF l_debug_on THEN
1251: WSH_DEBUG_SV.pop(l_module_name);
1252: END IF;
1253: RETURN;
1254: END IF;
1255:

Line 1276: WSH_DEBUG_SV.pop(l_module_name);

1272: p_token_1_value => x_obsoleted_trip_moves(l_tm_index).move_id,
1273: x_errors_tab => x_errors_tab,
1274: x_return_status => l_return_status);
1275: IF l_debug_on THEN
1276: WSH_DEBUG_SV.pop(l_module_name);
1277: END IF;
1278: RETURN;
1279: END IF;
1280:

Line 1318: WSH_DEBUG_SV.pop(l_module_name);

1314: p_message_name => 'WSH_TP_F_CREATE_MOVE',
1315: x_errors_tab => x_errors_tab,
1316: x_return_status => l_return_status);
1317: IF l_debug_on THEN
1318: WSH_DEBUG_SV.pop(l_module_name);
1319: END IF;
1320: RETURN;
1321: END IF;
1322: x_plan_moves(l_m_index).move_id := l_id;

Line 1339: WSH_DEBUG_SV.pop(l_module_name);

1335: p_token_1_value => x_plan_moves(l_m_index).move_id,
1336: x_errors_tab => x_errors_tab,
1337: x_return_status => l_return_status);
1338: IF l_debug_on THEN
1339: WSH_DEBUG_SV.pop(l_module_name);
1340: END IF;
1341: RETURN;
1342: END IF;
1343: END IF;

Line 1368: WSH_DEBUG_SV.pop(l_module_name);

1364: p_message_name => 'WSH_TP_F_CREATE_TRIP_MOVE',
1365: x_errors_tab => x_errors_tab,
1366: x_return_status => l_return_status);
1367: IF l_debug_on THEN
1368: WSH_DEBUG_SV.pop(l_module_name);
1369: END IF;
1370: RETURN;
1371: END IF;
1372: x_plan_trip_moves(l_tm_index).trip_move_id := l_id;

Line 1387: WSH_DEBUG_SV.pop(l_module_name);

1383: p_message_name => 'WSH_TP_F_UPDATE_TRIP_MOVE',
1384: x_errors_tab => x_errors_tab,
1385: x_return_status => l_return_status);
1386: IF l_debug_on THEN
1387: WSH_DEBUG_SV.pop(l_module_name);
1388: END IF;
1389: RETURN;
1390: END IF;
1391: END IF;

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

1407: --
1408: --
1409:
1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1412: WSH_DEBUG_SV.pop(l_module_name);
1413: END IF;
1414:
1415: EXCEPTION

Line 1412: WSH_DEBUG_SV.pop(l_module_name);

1408: --
1409:
1410: IF l_debug_on THEN
1411: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1412: WSH_DEBUG_SV.pop(l_module_name);
1413: END IF;
1414:
1415: EXCEPTION
1416: WHEN OTHERS THEN

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

1418: WSH_UTIL_CORE.DEFAULT_HANDLER(
1419: 'FTE_TP_GRP.reconciliate_moves',
1420: l_module_name);
1421: IF l_debug_on THEN
1422: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1423: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1424: END IF;
1425:
1426: END reconciliate_moves;

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

1419: 'FTE_TP_GRP.reconciliate_moves',
1420: l_module_name);
1421: IF l_debug_on THEN
1422: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1423: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1424: END IF;
1425:
1426: END reconciliate_moves;
1427:

Line 1465: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1461: BEGIN
1462: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1463: --
1464: IF l_debug_on IS NULL THEN
1465: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1466: END IF;
1467:
1468: IF l_debug_on THEN
1469: WSH_DEBUG_SV.push(l_module_name);

Line 1469: WSH_DEBUG_SV.push(l_module_name);

1465: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1466: END IF;
1467:
1468: IF l_debug_on THEN
1469: WSH_DEBUG_SV.push(l_module_name);
1470: END IF;
1471:
1472: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1473:

Line 1511: WSH_DEBUG_SV.pop(l_module_name);

1507: p_token_1_value => x_plan_moves(l_m_index).move_id,
1508: x_errors_tab => x_errors_tab,
1509: x_return_status => l_return_status);
1510: IF l_debug_on THEN
1511: WSH_DEBUG_SV.pop(l_module_name);
1512: END IF;
1513: RETURN;
1514: END IF;
1515:

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

1523: --
1524: --
1525:
1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1528: WSH_DEBUG_SV.pop(l_module_name);
1529: END IF;
1530:
1531: EXCEPTION

Line 1528: WSH_DEBUG_SV.pop(l_module_name);

1524: --
1525:
1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1528: WSH_DEBUG_SV.pop(l_module_name);
1529: END IF;
1530:
1531: EXCEPTION
1532: WHEN OTHERS THEN

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

1534: WSH_UTIL_CORE.DEFAULT_HANDLER(
1535: 'FTE_TP_GRP.tp_firm_moves',
1536: l_module_name);
1537: IF l_debug_on THEN
1538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1540: END IF;
1541:
1542: END tp_firm_moves;

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

1535: 'FTE_TP_GRP.tp_firm_moves',
1536: l_module_name);
1537: IF l_debug_on THEN
1538: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1539: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1540: END IF;
1541:
1542: END tp_firm_moves;
1543:

Line 1573: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;

1569: BEGIN
1570: l_debug_on := WSH_DEBUG_INTERFACE.g_debug;
1571: --
1572: IF l_debug_on IS NULL THEN
1573: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1574: END IF;
1575:
1576: IF l_debug_on THEN
1577: WSH_DEBUG_SV.push(l_module_name);

Line 1577: WSH_DEBUG_SV.push(l_module_name);

1573: l_debug_on := WSH_DEBUG_SV.is_debug_enabled;
1574: END IF;
1575:
1576: IF l_debug_on THEN
1577: WSH_DEBUG_SV.push(l_module_name);
1578: END IF;
1579:
1580: x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
1581:

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

1614: --
1615: --
1616:
1617: IF l_debug_on THEN
1618: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1619: WSH_DEBUG_SV.pop(l_module_name);
1620: END IF;
1621:
1622: EXCEPTION

Line 1619: WSH_DEBUG_SV.pop(l_module_name);

1615: --
1616:
1617: IF l_debug_on THEN
1618: WSH_DEBUG_SV.log(l_module_name, 'x_return_status', x_return_status);
1619: WSH_DEBUG_SV.pop(l_module_name);
1620: END IF;
1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN

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

1625: WSH_UTIL_CORE.DEFAULT_HANDLER(
1626: 'FTE_TP_GRP.purge_interface_tables',
1627: l_module_name);
1628: IF l_debug_on THEN
1629: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1631: END IF;
1632:
1633: END purge_interface_tables;

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

1626: 'FTE_TP_GRP.purge_interface_tables',
1627: l_module_name);
1628: IF l_debug_on THEN
1629: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1630: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1631: END IF;
1632:
1633: END purge_interface_tables;
1634: