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.14 2011/03/30 02:52:12 brana 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.14 2011/03/30 02:52:12 brana 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 2480: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',

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

Line 2551: 'WSH_LOCATIONS_PKG.convert_internal_cust_location',

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

Line 2563: END WSH_LOCATIONS_PKG;

2559: END convert_internal_cust_location;
2560:
2561:
2562:
2563: END WSH_LOCATIONS_PKG;