DBA Data[Home] [Help]

APPS.WSH_TRIP_STOPS_PVT dependencies on WSH_TRIP_STOPS_PVT

Line 1: PACKAGE BODY WSH_TRIP_STOPS_PVT AS

1: PACKAGE BODY WSH_TRIP_STOPS_PVT AS
2: /* $Header: WSHSTTHB.pls 120.3.12010000.2 2008/08/21 06:04:26 sankarun ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_PVT';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_PVT';

1: PACKAGE BODY WSH_TRIP_STOPS_PVT AS
2: /* $Header: WSHSTTHB.pls 120.3.12010000.2 2008/08/21 06:04:26 sankarun ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIP_STOPS_PVT';
6: --
7: PROCEDURE Create_Trip_Stop(
8: p_trip_stop_info IN trip_stop_rec_type,
9: x_rowid OUT NOCOPY VARCHAR2,

Line 371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);

367: SUBSTRB(WSH_UTIL_CORE.get_location_description(p_trip_stop_info.stop_location_id,'NEW UI CODE'), 1, 60));
368: wsh_util_core.add_message(x_return_status,l_module_name);
369:
370: WHEN others THEN
371: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.CREATE_TRIP_STOP',l_module_name);
372: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
373:
374: --
375: -- Debug Statements

Line 539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

535: --
536: -- Debug Statements
537: --
538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
540: END IF;
541: --
542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));
543: wsh_util_core.add_message(x_return_status,l_module_name);

Line 542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));

538: IF l_debug_on THEN
539: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_TRIP_STOPS_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
540: END IF;
541: --
542: FND_MESSAGE.SET_TOKEN('STOP_NAME',wsh_trip_stops_pvt.get_name(l_stop_id, p_caller));
543: wsh_util_core.add_message(x_return_status,l_module_name);
544: --
545: -- Debug Statements
546: --

Line 704: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',l_module_name);

700: WHEN others THEN
701: IF c_get_trip_status%ISOPEN THEN
702: CLOSE c_get_trip_status;
703: END IF;
704: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.DELETE_TRIP_STOP',l_module_name);
705: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
706:
707: --
708: -- Debug Statements

Line 976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);

972: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
973: END IF;
974: --
975: WHEN others THEN
976: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TRIP_STOP',l_module_name);
977: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
978:
979: --
980: -- Debug Statements

Line 1468: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.POPULATE_RECORD',l_module_name);

1464: END IF;
1465: --
1466: EXCEPTION
1467: WHEN others THEN
1468: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.POPULATE_RECORD',l_module_name);
1469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1470:
1471: --
1472: -- Debug Statements

Line 1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);

1599:
1600: EXCEPTION
1601:
1602: WHEN others THEN
1603: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.GET_NAME',l_module_name);
1604: --
1605: IF l_debug_on THEN
1606: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1607: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);

2205: RAISE;
2206:
2207: WHEN OTHERS THEN
2208: --
2209: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare',l_module_name);
2210: --
2211: IF l_debug_on THEN
2212: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2213: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);

2351: WHEN OTHERS THEN
2352: --
2353: x_return_status := wsh_util_core.g_ret_sts_unexp_error;
2354: --
2355: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.LOCK_TRIP_STOP_WRAPPER',l_module_name);
2356: --
2357: IF l_debug_on THEN
2358: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2359: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2531: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);

2527: END IF;
2528:
2529: WHEN others THEN
2530: ROLLBACK TO update_tms_interface;
2531: wsh_util_core.default_handler('WSH_TRIP_STOPS_PVT.UPDATE_TMS_INTERFACE_FLAG',l_module_name);
2532: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2533:
2534: --
2535: -- Debug Statements

Line 2544: END WSH_TRIP_STOPS_PVT;

2540: END IF;
2541: --
2542: END UPDATE_TMS_INTERFACE_FLAG;
2543:
2544: END WSH_TRIP_STOPS_PVT;