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

APPS.WSH_TRIP_STOPS_ACTIONS dependencies on WSH_TRIP_STOPS_ACTIONS

Line 1: PACKAGE BODY WSH_TRIP_STOPS_ACTIONS as

1: PACKAGE BODY WSH_TRIP_STOPS_ACTIONS as
2: /* $Header: WSHSTACB.pls 120.4 2007/05/08 12:12:22 mvudugul noship $ */
3:
4:
5: --

Line 6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_ACTIONS';

2: /* $Header: WSHSTACB.pls 120.4 2007/05/08 12:12:22 mvudugul noship $ */
3:
4:
5: --
6: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_ACTIONS';
7: --
8:
9:
10: --OTM R12 Org-Specific. Declare of local procedure.

Line 280: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CONFIRM_STOP');

276: END IF;
277:
278: EXCEPTION
279: WHEN others THEN
280: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CONFIRM_STOP');
281: rollback to sp_confirm_stop;
282: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
283: IF l_debug_on THEN
284: WSH_DEBUG_SV.log(l_module_name,'Unexpected Error has Occured.Oracle error message is'||SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 488: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CHECK_UPDATE');

484: END IF;
485: --
486: EXCEPTION
487: WHEN others THEN
488: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CHECK_UPDATE');
489: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
490:
491: --
492: -- Debug Statements

Line 642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.SETCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);

638: END IF;
639: --
640: --
641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.SETCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
643: END IF;
644: --
645: WSH_TRIP_STOPS_ACTIONS.setClose
646: (

Line 645: WSH_TRIP_STOPS_ACTIONS.setClose

641: IF l_debug_on THEN
642: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.SETCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
643: END IF;
644: --
645: WSH_TRIP_STOPS_ACTIONS.setClose
646: (
647: p_in_rec => l_in_rec,
648: p_in_rec1 => l_out_rec,
649: p_defer_interface_flag => p_defer_interface_flag,

Line 1133: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CHANGE_STATUS');

1129: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:INVALID_STOP');
1130: END IF;
1131: --
1132: WHEN others THEN
1133: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CHANGE_STATUS');
1134: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1135:
1136:
1137: --

Line 1240: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CALC_STOP_WEIGHT_VOLUME');

1236: END IF;
1237: --
1238: EXCEPTION
1239: WHEN others THEN
1240: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.CALC_STOP_WEIGHT_VOLUME');
1241: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1242:
1243: --
1244: -- Debug Statements

Line 1387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.setClose',WSH_DEBUG_SV.C_PROC_LEVEL);

1383: l_in_rec.put_messages := TRUE;
1384: --
1385: --
1386: IF l_debug_on THEN
1387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.setClose',WSH_DEBUG_SV.C_PROC_LEVEL);
1388: END IF;
1389: --
1390: WSH_TRIP_STOPS_ACTIONS.setClose
1391: (

Line 1390: WSH_TRIP_STOPS_ACTIONS.setClose

1386: IF l_debug_on THEN
1387: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.setClose',WSH_DEBUG_SV.C_PROC_LEVEL);
1388: END IF;
1389: --
1390: WSH_TRIP_STOPS_ACTIONS.setClose
1391: (
1392: p_in_rec => l_in_rec,
1393: p_in_rec1 => l_out_rec,
1394: p_defer_interface_flag => 'Y',

Line 1419: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.setOpen',WSH_DEBUG_SV.C_PROC_LEVEL);

1415: l_in_rec.put_messages := TRUE;
1416: --
1417: --
1418: IF l_debug_on THEN
1419: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.setOpen',WSH_DEBUG_SV.C_PROC_LEVEL);
1420: END IF;
1421: --
1422: WSH_TRIP_STOPS_ACTIONS.setOpen
1423: (

Line 1422: WSH_TRIP_STOPS_ACTIONS.setOpen

1418: IF l_debug_on THEN
1419: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.setOpen',WSH_DEBUG_SV.C_PROC_LEVEL);
1420: END IF;
1421: --
1422: WSH_TRIP_STOPS_ACTIONS.setOpen
1423: (
1424: p_in_rec => l_in_rec,
1425: p_in_rec1 => l_out_rec,
1426: x_return_status => l_return_status

Line 1489: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.autoCloseOpen', l_module_name);

1485: --
1486: WHEN OTHERS THEN
1487:
1488: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1489: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.autoCloseOpen', l_module_name);
1490: IF l_debug_on THEN
1491: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1492: END IF;
1493: --

Line 2298: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.setClose',l_module_name);

2294: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2295: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2296: END IF;
2297: WHEN others THEN
2298: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.setClose',l_module_name);
2299: --
2300: --ROLLBACK TO close_stop_begin_sp;
2301: --
2302: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 2575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);

2571: l_stop_in_rec.actual_date := p_in_rec.actual_date;
2572: --
2573: --
2574: IF l_debug_on THEN
2575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2576: END IF;
2577: --
2578: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2579: (

Line 2578: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen

2574: IF l_debug_on THEN
2575: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2576: END IF;
2577: --
2578: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2579: (
2580: p_in_rec => l_stop_in_rec,
2581: p_reopenStop => TRUE,
2582: x_stop_processed => l_stop_opened,

Line 2798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);

2794: l_stop_in_rec.actual_date := p_in_rec.actual_date;
2795: --
2796: --
2797: IF l_debug_on THEN
2798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2799: END IF;
2800: --
2801: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2802: (

Line 2801: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen

2797: IF l_debug_on THEN
2798: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2799: END IF;
2800: --
2801: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2802: (
2803: p_in_rec => l_stop_in_rec,
2804: p_reopenStop => TRUE,
2805: x_stop_processed => l_stop_opened,

Line 2832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);

2828: l_stop_in_rec.actual_date := p_in_rec.actual_date;
2829: --
2830: --
2831: IF l_debug_on THEN
2832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2833: END IF;
2834: --
2835: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2836: (

Line 2835: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen

2831: IF l_debug_on THEN
2832: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_ACTIONS.autoCLOSE',WSH_DEBUG_SV.C_PROC_LEVEL);
2833: END IF;
2834: --
2835: WSH_TRIP_STOPS_ACTIONS.autoCloseOpen
2836: (
2837: p_in_rec => l_stop_in_rec,
2838: p_reopenStop => TRUE,
2839: x_stop_processed => l_stop_opened,

Line 2930: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.setOpen',l_module_name);

2926: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_UTIL_CORE.G_EXC_WARNING exception has occured ',WSH_DEBUG_SV.C_EXCEP_LEVEL);
2927: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_UTIL_CORE.G_EXC_WARNING');
2928: END IF;
2929: WHEN others THEN
2930: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.setOpen',l_module_name);
2931: --
2932: --ROLLBACK TO open_stop_begin_sp;
2933: --
2934: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;

Line 3147: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.reset_stop_sequence_numbers',l_module_name);

3143: END IF;
3144:
3145: WHEN OTHERS THEN
3146:
3147: wsh_util_core.default_handler('WSH_TRIP_STOPS_ACTIONS.reset_stop_sequence_numbers',l_module_name);
3148: IF get_all_open_stops%ISOPEN THEN
3149: close get_all_open_stops;
3150: END IF;
3151: ROLLBACK TO begin_reset_stop_seq;

Line 3345: wsh_util_core.default_handler('wsh_trip_stops_actions.last_pickup_stop_closed',

3341: IF check_eligible_for_asr_csr%ISOPEN THEN
3342: CLOSE check_eligible_for_asr_csr;
3343: END IF;
3344:
3345: wsh_util_core.default_handler('wsh_trip_stops_actions.last_pickup_stop_closed',
3346: l_module_name);
3347: --
3348: IF l_debug_on THEN
3349: WSH_DEBUG_SV.log(l_module_name,

Line 3357: END WSH_TRIP_STOPS_ACTIONS;

3353: END IF;
3354:
3355: END LAST_PICKUP_STOP_CLOSED;
3356:
3357: END WSH_TRIP_STOPS_ACTIONS;