APPS.WSH_LOCATIONS_PKG dependencies on WSH_LOCATIONS_PKG

Line 1: PACKAGE BODY WSH_LOCATIONS_PKG as

1: PACKAGE BODY WSH_LOCATIONS_PKG as
2: /* $Header: WSHLOCMB.pls 120.12.12000000.2 2007/10/09 13:15:56 arimukhe ship $ */
3: --
4: -- Package: WSH_LOCATIONS_PKG
5: --

Line 4: -- Package: WSH_LOCATIONS_PKG

1: PACKAGE BODY WSH_LOCATIONS_PKG as
2: /* $Header: WSHLOCMB.pls 120.12.12000000.2 2007/10/09 13:15:56 arimukhe ship $ */
3: --
4: -- Package: WSH_LOCATIONS_PKG
5: --
6: -- Purpose: To populate data in WSH_LOCATIONS with the data in
7: -- HZ_LOCATIONS, HR_LOCATIONS and PO_VENDOR_SITES.
8: --

Line 12: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_LOCATIONS_PKG';

8: --
9: --
10:
11: --
12: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_LOCATIONS_PKG';
13: --
14:
15: TYPE Generic_Cache_Rec_Typ IS RECORD(
16: INPUT_PARAM1 VARCHAR2(500),

Line 1812: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.insert_locations', l_module_name);

1808: -- Bug 4775798
1809: EXCEPTION
1810: WHEN OTHERS THEN
1811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1812: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.insert_locations', l_module_name);
1813: IF l_debug_on THEN
1814: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1815: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1816: ELSE

Line 1908: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.update_locations', l_module_name);

1904: -- Bug 4775798
1905: EXCEPTION
1906: WHEN OTHERS THEN
1907: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1908: WSH_UTIL_CORE.DEFAULT_HANDLER( 'WSH_LOCATIONS_PKG.update_locations', l_module_name);
1909: IF l_debug_on THEN
1910: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1911: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
1912: ELSE

Line 2477: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',

2473: IF c_convert%ISOPEN THEN
2474: CLOSE c_convert;
2475: END IF;
2476: WSH_UTIL_CORE.DEFAULT_HANDLER(
2477: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',
2478: l_module_name);
2479:
2480: IF l_debug_on THEN
2481: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2548: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',

2544:
2545: EXCEPTION
2546: WHEN OTHERS THEN
2547: WSH_UTIL_CORE.DEFAULT_HANDLER(
2548: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',
2549: l_module_name);
2550: IF l_debug_on THEN
2551: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2552: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 2560: END WSH_LOCATIONS_PKG;

2556: END convert_internal_cust_location;
2557:
2558:
2559:
2560: END WSH_LOCATIONS_PKG;