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.15.12020000.2 2012/07/04 10:39:02 suppal ship $ */
3:
4: --
5: -- Package

Line 6: -- WSH_REGIONS_SEARCH_PKG

2: /* $Header: WSHRESEB.pls 120.15.12020000.2 2012/07/04 10:39:02 suppal 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 1797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);

1793: --
1794: -- Debug Statements
1795: --
1796: IF l_debug_on THEN
1797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1798: END IF;
1799: --
1800: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (
1801: p_country => loc.territory_short_name,

Line 1800: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (

1796: IF l_debug_on THEN
1797: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_REGIONS_SEARCH_PKG.MATCH_LOCATION_REGION',WSH_DEBUG_SV.C_PROC_LEVEL);
1798: END IF;
1799: --
1800: l_region_id := Wsh_Regions_Search_Pkg.Match_Location_Region (
1801: p_country => loc.territory_short_name,
1802: p_country_code => loc.territory_code,
1803: p_state => loc.state,
1804: p_city => loc.city,

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

1975: WSH_DEBUG_SV.pop(l_module_name);
1976: END IF;
1977: EXCEPTION
1978: WHEN others THEN
1979: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_Child_Requests_Status');
1980: --
1981: IF l_debug_on THEN
1982: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
1983: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

Line 2039: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(

2035: IF l_debug_on THEN
2036: WSH_DEBUG_SV.logmsg(l_module_name, 'CALLING PROCESS_ALL_LOCATIONS API with location_type=BOTH' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2037: END IF;
2038:
2039: WSH_REGIONS_SEARCH_PKG.Process_All_Locations(
2040: p_dummy1 => NULL,
2041: p_dummy2 => NULL,
2042: p_mode => p_mode,
2043: p_insert_flag => p_insert_flag,

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

2052: END IF;
2053:
2054: EXCEPTION
2055: WHEN others THEN
2056: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2057: --
2058: IF l_debug_on THEN
2059: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2060: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

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

2358: END IF;
2359:
2360: EXCEPTION
2361: WHEN others THEN
2362: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Process_All_Locations');
2363: --
2364: IF l_debug_on THEN
2365: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2366: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:FND_API.G_EXC_UNEXPECTED_ERROR');

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

2417: --
2418:
2419: EXCEPTION
2420: WHEN others THEN
2421: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.refresh_cache');
2422: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2423: --
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

2966: --
2967: --Bug 4775798
2968: EXCEPTION
2969: WHEN OTHERS THEN
2970: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2971: IF l_debug_on THEN
2972: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2973: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2974: ELSE

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

2971: IF l_debug_on THEN
2972: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
2973: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
2974: ELSE
2975: WSH_UTIL_CORE.printmsg('Unexpected error has occured in WSH_REGIONS_SEARCH_PKG.Get_All_Region_Matches');
2976: WSH_UTIL_CORE.printmsg(SQLERRM);
2977: END IF;
2978: END Get_All_Region_Matches;
2979:

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

3084: WHEN others THEN
3085: IF c_get_all_region_id%ISOPEN THEN
3086: CLOSE c_get_all_region_id;
3087: END IF;
3088: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');
3089: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3090: --
3091: IF l_debug_on THEN
3092: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

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

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

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

3471: END IF;
3472: IF c_get_zone_for_region%ISOPEN THEN
3473: CLOSE c_get_zone_for_region;
3474: END IF;
3475: WSH_UTIL_CORE.default_handler('WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols');
3476: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
3477: --
3478: IF l_debug_on THEN
3479: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3502: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)

3498: p_region_type IN NUMBER,
3499: p_search_flag IN VARCHAR2,
3500: p_lang_code IN VARCHAR2,
3501: x_return_status OUT NOCOPY VARCHAR2,
3502: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)
3503: IS
3504:
3505: CURSOR C1 IS
3506: SELECT REGION_ID

Line 3629: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)

3625: p_region_type IN NUMBER,
3626: p_search_flag IN VARCHAR2,
3627: p_lang_code IN VARCHAR2,
3628: x_return_status OUT NOCOPY VARCHAR2,
3629: x_region_info OUT NOCOPY WSH_REGIONS_SEARCH_PKG.region_rec)
3630: IS
3631:
3632: CURSOR C1 IS
3633: SELECT REGION_ID

Line 3872: END WSH_REGIONS_SEARCH_PKG;

3868:
3869: END;
3870:
3871:
3872: END WSH_REGIONS_SEARCH_PKG;