eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_REGIONS_SEARCH_PKG dependencies on WSH_REGIONS_SEARCH_PKG

Line 1: PACKAGE BODY WSH_REGIONS_SEARCH_PKG AS

1: PACKAGE BODY WSH_REGIONS_SEARCH_PKG AS
2: /* $Header: WSHRESEB.pls 120.12.12010000.2 2008/08/29 13:21:51 selsubra ship $ */
3:
4: --
5: -- Package

Line 6: -- WSH_REGIONS_SEARCH_PKG

2: /* $Header: WSHRESEB.pls 120.12.12010000.2 2008/08/29 13:21:51 selsubra ship $ */
3:
4: --
5: -- Package
6: -- WSH_REGIONS_SEARCH_PKG
7: --
8: -- Purpose
9: --
10:

Line 56: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_REGIONS_SEARCH_PKG';

52: -- Purpose: call another Get_Region_Info with p_search_flag ='N'
53: --
54: --
55: --
56: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_REGIONS_SEARCH_PKG';
57: --
58:
59: --
60: -- PROCEDURE : get_key

Line 136: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_key');

132: END IF;
133: x_return_status := l_return_status;
134: EXCEPTION
135: WHEN others THEN
136: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_key');
137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
138: --
139: IF l_debug_on THEN
140: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);

1523: --
1524: -- Debug Statements
1525: --
1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1528: END IF;
1529: --
1530: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (
1531: p_country => loc.territory_short_name,

Line 1530: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (

1526: IF l_debug_on THEN
1527: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1528: END IF;
1529: --
1530: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (
1531: p_country => loc.territory_short_name,
1532: p_country_code => loc.territory_code,
1533: p_state => loc.state,
1534: p_city => loc.city,

Line 1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');

1705: WSH_DEBUG_SV.pop(l_module_name);
1706: END IF;
1707: EXCEPTION
1708: WHEN others THEN
1709: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');
1710: --
1711: IF l_debug_on THEN
1712: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1713: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 1769: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(

1765: IF l_debug_on THEN
1766: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING PROCESS_ALL_LOCATIONS API with location_type=BOTH' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1767: END IF;
1768:
1769: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(
1770: p_dummy1 => NULL,
1771: p_dummy2 => NULL,
1772: p_mode => p_mode,
1773: p_insert_flag => p_insert_flag,

Line 1786: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');

1782: END IF;
1783:
1784: EXCEPTION
1785: WHEN others THEN
1786: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
1787: --
1788: IF l_debug_on THEN
1789: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1790: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2092: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');

2088: END IF;
2089:
2090: EXCEPTION
2091: WHEN others THEN
2092: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2093: --
2094: IF l_debug_on THEN
2095: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2096: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2151: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.refresh_cache');

2147: --
2148:
2149: EXCEPTION
2150: WHEN others THEN
2151: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.refresh_cache');
2152: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2153: --
2154: IF l_debug_on THEN
2155: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2699: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');

2695: --
2696: --Bug 4775798
2697: EXCEPTION
2698: WHEN OTHERS THEN
2699: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2703: ELSE

Line 2704: WSH_UTIL_CORE.printmsg('Unexpected error has occured in WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');

2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2702: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2703: ELSE
2704: WSH_UTIL_CORE.printmsg('Unexpected error has occured in WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2705: WSH_UTIL_CORE.printmsg(SQLERRM);
2706: END IF;
2707: END Get_All_Region_Matches;
2708:

Line 2817: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');

2813: WHEN others THEN
2814: IF c_get_all_region_id%ISOPEN THEN
2815: CLOSE c_get_all_region_id;
2816: END IF;
2817: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');
2818: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2819: --
2820: IF l_debug_on THEN
2821: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 2931: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');

2927: WHEN others THEN
2928: IF c_get_zone_for_region%ISOPEN THEN
2929: CLOSE c_get_zone_for_region;
2930: END IF;
2931: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');
2932: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2933: --
2934: IF l_debug_on THEN
2935: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3204: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols');

3200: END IF;
3201: IF c_get_zone_for_region%ISOPEN THEN
3202: CLOSE c_get_zone_for_region;
3203: END IF;
3204: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols');
3205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3206: --
3207: IF l_debug_on THEN
3208: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3231: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)

3227: p_region_type IN NUMBER,
3228: p_search_flag IN VARCHAR2,
3229: p_lang_code IN VARCHAR2,
3230: x_return_status OUT NOCOPY VARCHAR2,
3231: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)
3232: IS
3233:
3234: CURSOR C1 IS
3235: SELECT REGION_ID

Line 3358: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)

3354: p_region_type IN NUMBER,
3355: p_search_flag IN VARCHAR2,
3356: p_lang_code IN VARCHAR2,
3357: x_return_status OUT NOCOPY VARCHAR2,
3358: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)
3359: IS
3360:
3361: CURSOR C1 IS
3362: SELECT REGION_ID

Line 3601: END WSH_REGIONS_SEARCH_PKG;

3597:
3598: END;
3599:
3600:
3601: END WSH_REGIONS_SEARCH_PKG;