DBA Data[Home] [Help]

APPS.WSH_DELIVERIES_GRP dependencies on WSH_DELIVERIES_GRP

Line 1: PACKAGE BODY WSH_DELIVERIES_GRP as

1: PACKAGE BODY WSH_DELIVERIES_GRP as
2: /* $Header: WSHDEGPB.pls 120.23 2007/11/16 06:30:16 sankarun noship $ */
3:
4: --===================
5: -- CONSTANTS

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERIES_GRP';

3:
4: --===================
5: -- CONSTANTS
6: --===================
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_DELIVERIES_GRP';
8: -- add your constants here if any
9:
10: -- Forward declaration
11: PROCEDURE Lock_Related_Entities(

Line 2657: wsh_deliveries_grp.delivery_action(

2653: l_action_prms.action_code := 'GENERATE-PACK-SLIP';
2654: l_rec_attr_tab.delete;
2655: l_rec_attr_tab(1) := p_rec_attr_tab(i);
2656:
2657: wsh_deliveries_grp.delivery_action(
2658: p_api_version_number => p_api_version_number,
2659: p_init_msg_list => FND_API.G_FALSE,
2660: p_commit => FND_API.G_FALSE,
2661: p_action_prms => l_action_prms,

Line 3428: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.DELIVERY_ACTION');

3424: END IF;
3425: -- K LPN CONV. rv
3426: --
3427: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3428: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.DELIVERY_ACTION');
3429:
3430: --
3431: -- Start code for Bugfix 4070732
3432: --

Line 4361: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.VALIDATE_DELIVERY');

4357: --
4358: WHEN OTHERS THEN
4359: ROLLBACK TO VALIDATE_DELIVERY_GRP;
4360: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
4361: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.VALIDATE_DELIVERY');
4362: --
4363: IF l_debug_on THEN
4364: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
4365: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 5390: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.CREATE_UPDATE_DELIVERY');

5386: --
5387: WHEN OTHERS THEN
5388: ROLLBACK TO CREATE_UPDATE_DELIVERY_GRP;
5389: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
5390: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.CREATE_UPDATE_DELIVERY');
5391: --
5392: -- Start code for Bugfix 4070732
5393: --
5394: IF upper(WSH_UTIL_CORE.G_START_OF_SESSION_API) = upper(l_api_session_name) THEN

Line 5885: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.Validate_Delivery',l_module_name);

5881: END IF;
5882: --
5883: EXCEPTION
5884: WHEN others THEN
5885: wsh_util_core.default_handler('WSH_DELIVERIES_GRP.Validate_Delivery',l_module_name);
5886: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
5887: --
5888: IF l_debug_on THEN
5889: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 6060: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_GRP.map_grp_pvt',l_module_name);

6056: WSH_DEBUG_SV.pop(l_module_name);
6057: END IF;
6058: EXCEPTION
6059: WHEN OTHERS THEN
6060: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_DELIVERIES_GRP.map_grp_pvt',l_module_name);
6061: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
6062: --
6063: IF l_debug_on THEN
6064: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 6368: l_action_prms wsh_deliveries_grp.action_parameters_rectype;

6364: --
6365: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_ACTION';
6366: --
6367: --
6368: l_action_prms wsh_deliveries_grp.action_parameters_rectype;
6369: l_del_action_out_rec wsh_deliveries_grp.Delivery_Action_Out_Rec_Type;
6370: l_delivery_id_tab wsh_util_core.id_tab_type;
6371: --
6372: l_delivery_id NUMBER := p_delivery_id;

Line 6369: l_del_action_out_rec wsh_deliveries_grp.Delivery_Action_Out_Rec_Type;

6365: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'DELIVERY_ACTION';
6366: --
6367: --
6368: l_action_prms wsh_deliveries_grp.action_parameters_rectype;
6369: l_del_action_out_rec wsh_deliveries_grp.Delivery_Action_Out_Rec_Type;
6370: l_delivery_id_tab wsh_util_core.id_tab_type;
6371: --
6372: l_delivery_id NUMBER := p_delivery_id;
6373: --

Line 6776: WSH_UTIL_CORE.default_handler('WSH_DELIVERIES_GRP.Lock_Related_Entities');

6772: END IF;
6773: --
6774: WHEN OTHERS THEN
6775: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
6776: WSH_UTIL_CORE.default_handler('WSH_DELIVERIES_GRP.Lock_Related_Entities');
6777: IF l_debug_on THEN
6778: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6779: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');
6780: END IF;

Line 6935: END WSH_DELIVERIES_GRP;

6931:
6932:
6933:
6934:
6935: END WSH_DELIVERIES_GRP;