DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_PVT dependencies on WSH_DELIVERY_LEGS_PVT

Line 1: PACKAGE BODY WSH_DELIVERY_LEGS_PVT as

1: PACKAGE BODY WSH_DELIVERY_LEGS_PVT as
2: /* $Header: WSHDGTHB.pls 120.2 2007/01/05 01:03:45 jishen noship $ */
3:
4: --
5: -- Procedure: Create_Delivery_Leg

Line 14: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_PVT';

10: -- validations are provided.
11: --
12:
13: --
14: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_PVT';
15: --
16: PROCEDURE Create_Delivery_Leg (
17: p_delivery_leg_info IN Delivery_Leg_Rec_Type,
18: x_rowid OUT NOCOPY VARCHAR2,

Line 259: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.CREATE_DELIVERY_LEG',l_module_name);

255: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:MARK_REPRICE_ERROR');
256: END IF;
257: --
258: WHEN WSH_CREATE_FC_ERROR THEN
259: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.CREATE_DELIVERY_LEG',l_module_name);
260: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
261: --
262: IF l_debug_on THEN
263: WSH_DEBUG_SV.logmsg(l_module_name,'WSH_CREATE_FC_ERROR exception has occured.',WSH_DEBUG_SV.C_EXCEP_LEVEL);

Line 268: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.CREATE_DELIVERY_LEG',l_module_name);

264: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:WSH_CREATE_FC_ERROR');
265: END IF;
266: --
267: WHEN others THEN
268: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.CREATE_DELIVERY_LEG',l_module_name);
269: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
270: --
271: IF l_debug_on THEN
272: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 434: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.UPDATE_DELIVERY_LEG',l_module_name);

430: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:NO_DATA_FOUND');
431: END IF;
432: --
433: WHEN others THEN
434: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.UPDATE_DELIVERY_LEG',l_module_name);
435: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
436: --
437: IF l_debug_on THEN
438: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1125: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',l_module_name);

1121:
1122: -- J-IB-NPARIKH-}
1123:
1124: WHEN others THEN
1125: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.DELETE_DELIVERY_LEG',l_module_name);
1126: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1127: --
1128: IF l_debug_on THEN
1129: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1551: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.POPULATE_RECORD',l_module_name);

1547: END IF;
1548: --
1549: EXCEPTION
1550: WHEN others THEN
1551: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_PVT.POPULATE_RECORD',l_module_name);
1552: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1553: --
1554: IF l_debug_on THEN
1555: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1933: END WSH_DELIVERY_LEGS_PVT;

1929:
1930: END Lock_Dlvy_Leg_No_Compare;
1931:
1932:
1933: END WSH_DELIVERY_LEGS_PVT;
1934: