APPS.WSH_TRIPS_PVT dependencies on WSH_TRIPS_PVT

Line 1: PACKAGE BODY WSH_TRIPS_PVT AS

1: PACKAGE BODY WSH_TRIPS_PVT AS
2: /* $Header: WSHTRTHB.pls 120.3 2007/01/05 00:26:34 anxsharm ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIPS_PVT';

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

1: PACKAGE BODY WSH_TRIPS_PVT AS
2: /* $Header: WSHTRTHB.pls 120.3 2007/01/05 00:26:34 anxsharm ship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_TRIPS_PVT';
6: --
7: PROCEDURE Create_Trip(
8: p_trip_info IN trip_rec_type,
9: x_rowid OUT NOCOPY varchar2,

Line 410: wsh_util_core.default_handler('WSH_TRIPS_PVT.CREATE_TRIP');

406: END IF;
407: IF check_trip_ids%ISOPEN THEN
408: CLOSE check_trip_ids;
409: END IF;
410: wsh_util_core.default_handler('WSH_TRIPS_PVT.CREATE_TRIP');
411: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
412: --
413: -- Debug Statements
414: --

Line 685: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));

681: IF c_get_trip_status%ISOPEN THEN
682: CLOSE c_get_trip_status;
683: END IF;
684: FND_MESSAGE.SET_NAME('WSH','WSH_TRIP_DELETE_ERROR');
685: FND_MESSAGE.SET_TOKEN('TRIP_NAME',wsh_trips_pvt.get_name(p_trip_id));
686: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
687: wsh_util_core.add_message(x_return_status);
688: --
689: -- Debug Statements

Line 701: wsh_util_core.default_handler('WSH_TRIPS_PVT.DELETE_TRIP');

697: -- OTM R12, glog proj
698: IF c_get_trip_status%ISOPEN THEN
699: CLOSE c_get_trip_status;
700: END IF;
701: wsh_util_core.default_handler('WSH_TRIPS_PVT.DELETE_TRIP');
702: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
703: --
704: -- Debug Statements
705: --

Line 956: wsh_util_core.default_handler('WSH_TRIPS_PVT.UPDATE_TRIP');

952: --
953:
954:
955: WHEN others THEN
956: wsh_util_core.default_handler('WSH_TRIPS_PVT.UPDATE_TRIP');
957: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
958:
959: --
960: -- Debug Statements

Line 1524: wsh_util_core.default_handler('WSH_TRIPS_PVT.POPULATE_RECORD');

1520: END IF;
1521: --
1522: EXCEPTION
1523: WHEN others THEN
1524: wsh_util_core.default_handler('WSH_TRIPS_PVT.POPULATE_RECORD');
1525: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1526:
1527: --
1528: -- Debug Statements

Line 1609: wsh_util_core.default_handler('WSH_TRIPS_PVT.GET_NAME');

1605:
1606: EXCEPTION
1607:
1608: WHEN others THEN
1609: wsh_util_core.default_handler('WSH_TRIPS_PVT.GET_NAME');
1610: --
1611: -- Debug Statements
1612: --
1613: IF l_debug_on THEN

Line 1828: wsh_util_core.default_handler('WSH_TRIPS_PVT.lock_trip_no_compare',l_module_name);

1824: RAISE;
1825:
1826: WHEN OTHERS THEN
1827: --
1828: wsh_util_core.default_handler('WSH_TRIPS_PVT.lock_trip_no_compare',l_module_name);
1829: --
1830: IF l_debug_on THEN
1831: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1832: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 1838: END WSH_TRIPS_PVT;

1834: --
1835: RAISE;
1836: END lock_trip_no_compare;
1837:
1838: END WSH_TRIPS_PVT;