DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on WSH_DELIVERY_LEGS_ACTIONS

Line 1: PACKAGE BODY WSH_DELIVERY_LEGS_ACTIONS as

1: PACKAGE BODY WSH_DELIVERY_LEGS_ACTIONS as
2: /* $Header: WSHDGACB.pls 120.13 2008/03/18 11:53:24 jnpinto noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_ACTIONS';

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

1: PACKAGE BODY WSH_DELIVERY_LEGS_ACTIONS as
2: /* $Header: WSHDGACB.pls 120.13 2008/03/18 11:53:24 jnpinto noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_ACTIONS';
6: --
7: g_wms_installed WSH_UTIL_CORE.Column_Tab_Type;
8:
9: CURSOR C_IS_FIRST_LEG(p_trip_id in number, p_delivery_id in number, p_pickup_loc_id in number) is

Line 2816: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES');

2812: END IF;
2813: IF c_next_seq_exists%ISOPEN THEN
2814: close c_next_seq_exists;
2815: END IF;
2816: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_ACTIONS.ASSIGN_DELIVERIES');
2817: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2818:
2819: IF l_debug_on THEN
2820: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3523: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES');

3519: WHEN others THEN
3520: iF c_is_first_leg%isopen THEN
3521: close c_is_first_leg;
3522: END IF;
3523: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_ACTIONS.UNASSIGN_DELIVERIES');
3524: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3525: IF l_debug_on THEN
3526: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
3527: END IF;

Line 4009: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');

4005: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:DELIVERY_LEG_LOCKED');
4006: END IF;
4007: --
4008: WHEN others THEN
4009: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_ACTIONS.Mark_Reprice_Required');
4010: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4011:
4012: --
4013: -- Debug Statements

Line 4378: END WSH_DELIVERY_LEGS_ACTIONS;

4374: END Check_Rate_Trip_Contents;
4375:
4376:
4377:
4378: END WSH_DELIVERY_LEGS_ACTIONS;