DBA Data[Home] [Help]

APPS.WSH_PO_INTEGRATION_GRP dependencies on WSH_PO_INTEGRATION_GRP

Line 1: PACKAGE BODY WSH_PO_INTEGRATION_GRP AS

1: PACKAGE BODY WSH_PO_INTEGRATION_GRP AS
2: /* $Header: WSHPOGPB.pls 120.6 2005/08/22 11:43:13 rlanka noship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PO_INTEGRATION_GRP';
5: --

Line 4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PO_INTEGRATION_GRP';

1: PACKAGE BODY WSH_PO_INTEGRATION_GRP AS
2: /* $Header: WSHPOGPB.pls 120.6 2005/08/22 11:43:13 rlanka noship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_PO_INTEGRATION_GRP';
5: --
6:
7:
8: -- Start of comments

Line 145: WSH_UTIL_CORE.Default_Handler('WSH_PO_INTEGRATION_GRP.check_purge',l_module_name);

141: --
142: EXCEPTION
143: WHEN OTHERS THEN
144: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
145: WSH_UTIL_CORE.Default_Handler('WSH_PO_INTEGRATION_GRP.check_purge',l_module_name);
146: --
147: -- Debug Statements
148: --
149: IF l_debug_on THEN

Line 307: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.Purge',l_module_name);

303: WHEN OTHERS THEN
304: ROLLBACK TO PURGE_PVT;
305: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
306: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
307: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.Purge',l_module_name);
308:
309: --
310: -- Debug Statements
311: --

Line 393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);

389: --
390: WHEN OTHERS THEN
391: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
392: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
393: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.VENDOR_MERGE',l_module_name);
394: --
395: IF l_debug_on THEN
396: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
397: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 653: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged',l_module_name);

649: --
650: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
651: --
652: WSH_UTIL_CORE.ADD_MESSAGE(l_return_status,l_module_name);
653: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.HasDeliveryInfoChanged',l_module_name);
654: --
655: IF l_debug_on THEN
656: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
657: || ' Oracle error message is '

Line 673: -- p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type

669: -- Pre-reqs : None.
670: -- Parameters :
671: -- p_api_version_number IN NUMBER
672: -- p_init_msg_list IN VARCHAR2
673: -- p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type
674: -- p_commit IN VARCHAR2
675: -- x_return_status OUT NOCOPY VARCHAR2
676: -- x_out_rec OUT WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type
677: -- x_msg_count OUT NOCOPY NUMBER

Line 676: -- x_out_rec OUT WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type

672: -- p_init_msg_list IN VARCHAR2
673: -- p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type
674: -- p_commit IN VARCHAR2
675: -- x_return_status OUT NOCOPY VARCHAR2
676: -- x_out_rec OUT WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type
677: -- x_msg_count OUT NOCOPY NUMBER
678: -- x_msg_data OUT NOCOPY VARCHAR2
679: -- Comment :This API will be called whenever a ASN is created with a
680: -- ShipFromLocation on the IssupplierPortal Page. This API

Line 702: p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type,

698: PROCEDURE validateASNReceiptShipFrom
699: (
700: p_api_version_number IN NUMBER,
701: p_init_msg_list IN VARCHAR2,
702: p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type,
703: p_commit IN VARCHAR2,
704: x_return_status OUT NOCOPY VARCHAR2,
705: x_out_rec OUT NOCOPY WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type,
706: x_msg_count OUT NOCOPY NUMBER,

Line 705: x_out_rec OUT NOCOPY WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type,

701: p_init_msg_list IN VARCHAR2,
702: p_in_rec IN WSH_PO_INTEGRATION_GRP.validateSF_in_rec_type,
703: p_commit IN VARCHAR2,
704: x_return_status OUT NOCOPY VARCHAR2,
705: x_out_rec OUT NOCOPY WSH_PO_INTEGRATION_GRP.validateSF_out_rec_type,
706: x_msg_count OUT NOCOPY NUMBER,
707: x_msg_data OUT NOCOPY VARCHAR2
708: )
709: IS

Line 908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.validateASNReceiptShipFrom',l_module_name);

904: --
905: x_out_rec.is_valid := FALSE;
906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
907: --
908: WSH_UTIL_CORE.DEFAULT_HANDLER('WSH_PO_INTEGRATION_GRP.validateASNReceiptShipFrom',l_module_name);
909: --
910: IF l_debug_on THEN
911: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. '
912: || ' Oracle error message is '

Line 920: END WSH_PO_INTEGRATION_GRP;

916: --
917: END validateASNReceiptShipFrom;
918: --IB-Phase-2
919:
920: END WSH_PO_INTEGRATION_GRP;