[Home] [Help]
1: PACKAGE BODY WSH_WMS_LPN_GRP as
2: /* $Header: WSHWLGPB.pls 120.14.12010000.2 2008/08/04 12:33:58 suppal ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_WMS_LPN_GRP';
5:
1: PACKAGE BODY WSH_WMS_LPN_GRP as
2: /* $Header: WSHWLGPB.pls 120.14.12010000.2 2008/08/04 12:33:58 suppal ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WSH_WMS_LPN_GRP';
5:
6: PROCEDURE Handle_miss_info
7: ( p_container_info_rec IN OUT NOCOPY
8: WSH_GLBL_VAR_STRCT_GRP.delivery_details_Rec_Type,
416: g_caller := NULL;
417: --g_update_to_container := 'N';
418: ROLLBACK TO create_update_WSHWLGPB;
419: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
420: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.create_update_containers');
421: FND_MSG_PUB.Count_And_Get
422: (
423: p_count => x_msg_count,
424: p_data => x_msg_data,
682: EXCEPTION
683:
684: WHEN OTHERS THEN
685: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
686: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.Handle_miss_info');
687: --
688: IF l_debug_on THEN
689: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
690: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1716: WHEN OTHERS THEN
1717: ROLLBACK TO check_purge_WSHWLGPB;
1718: --p_lpn_rec.lpn_ids.DELETE;
1719: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
1720: wsh_util_core.default_handler('WSH_WMS_LPN_GRP.check_purge');
1721: FND_MSG_PUB.Count_And_Get
1722: (
1723: p_count => x_msg_count,
1724: p_data => x_msg_data,
1953:
1954:
1955: END is_valid_consol;
1956:
1957: END WSH_WMS_LPN_GRP;