DBA Data[Home] [Help]

APPS.WSH_DELIVERY_LEGS_GRP dependencies on WSH_DELIVERY_LEGS_GRP

Line 1: PACKAGE BODY WSH_DELIVERY_LEGS_GRP as

1: PACKAGE BODY WSH_DELIVERY_LEGS_GRP as
2: /* $Header: WSHDGGPB.pls 120.9 2007/01/05 00:48:12 anxsharm noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_GRP';

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

1: PACKAGE BODY WSH_DELIVERY_LEGS_GRP as
2: /* $Header: WSHDGGPB.pls 120.9 2007/01/05 00:48:12 anxsharm noship $ */
3:
4: --
5: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_DELIVERY_LEGS_GRP';
6: --
7:
8: -- forward declaration
9: PROCEDURE Get_Disabled_List (

Line 491: WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION(

487: l_action_out_rec.x_trip_id := x_action_out_rec.x_trip_id;
488: l_action_out_rec.x_trip_name := x_action_out_rec.x_trip_name;
489: l_action_out_rec.x_delivery_id := x_action_out_rec.x_delivery_id;
490:
491: WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION(
492: p_api_version_number => p_api_version_number,
493: p_init_msg_list => FND_API.G_FALSE,
494: p_commit => FND_API.G_FALSE,
495: p_rec_attr_tab => p_rec_attr_tab,

Line 754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');

750:
751:
752: WHEN OTHERS THEN
753: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
754: wsh_util_core.default_handler ('WSH_DELIVERY_LEGS_GRP.DELIVERY_LEG_ACTION');
755: FND_MSG_PUB.Count_And_Get (
756: p_count => x_msg_count,
757: p_data => x_msg_data,
758: p_encoded => FND_API.G_FALSE);

Line 793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,

789: PROCEDURE Update_Delivery_Leg(
790: p_api_version_number IN NUMBER,
791: p_init_msg_list IN VARCHAR2,
792: p_commit IN VARCHAR2,
793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,

Line 794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,

790: p_api_version_number IN NUMBER,
791: p_init_msg_list IN VARCHAR2,
792: p_commit IN VARCHAR2,
793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,
798: x_msg_data OUT NOCOPY VARCHAR2) IS

Line 795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,

791: p_init_msg_list IN VARCHAR2,
792: p_commit IN VARCHAR2,
793: p_delivery_leg_tab IN WSH_DELIVERY_LEGS_GRP.dlvy_leg_tab_type,
794: p_in_rec IN WSH_DELIVERY_LEGS_GRP.action_parameters_rectype,
795: x_out_rec OUT NOCOPY WSH_DELIVERY_LEGS_GRP.action_out_rec_type,
796: x_return_status OUT NOCOPY VARCHAR2,
797: x_msg_count OUT NOCOPY NUMBER,
798: x_msg_data OUT NOCOPY VARCHAR2) IS
799:

Line 941: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);

937:
938: IF c_is_final_leg%isopen THEN
939: close c_is_final_leg;
940: END IF;
941: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.Update_Delivery_Leg',l_module_name);
942: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
943: --
944: IF l_debug_on THEN
945: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1403: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.get_disabled_list',l_module_name);

1399:
1400: EXCEPTION
1401:
1402: WHEN others THEN
1403: wsh_util_core.default_handler('WSH_DELIVERY_LEGS_GRP.get_disabled_list',l_module_name);
1404: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1405: --
1406: IF c_get_leg_record%isopen THEN
1407: CLOSE c_get_leg_record;

Line 1416: END WSH_DELIVERY_LEGS_GRP;

1412: END IF;
1413:
1414: END get_disabled_list;
1415:
1416: END WSH_DELIVERY_LEGS_GRP;