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_FTE_CONSTRAINT_FRAMEWORK dependencies on WSH_REGIONS_SEARCH_PKG

Line 2742: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

2738:
2739: l_comp_class_id := g_comp_class_tab(l_hash_value).compatibility_class_id;
2740:
2741:
2742: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
2743: p_location_id => p_location_id,
2744: p_use_cache => TRUE,
2745: p_lang_code => USERENV('LANG'),
2746: x_region_tab => l_region_tab,

Line 2814: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

2810: END IF;
2811: END IF;
2812:
2813: -- l_object1_id currently holds the region id
2814: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
2815: p_region_id => l_region_id,
2816: x_zone_tab => l_zone_tab,
2817: x_return_status => l_return_status);
2818:

Line 3156: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

3152: END IF;
3153:
3154: l_reg_comp_class_id := g_comp_class_tab(l_hash_value).COMPATIBILITY_CLASS_ID;
3155:
3156: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
3157: p_location_id => p_location_id,
3158: p_use_cache => TRUE,
3159: p_lang_code => USERENV('LANG'),
3160: x_region_tab => l_region_tab,

Line 3295: WSH_DEBUG_SV.logmsg(l_module_name,' Calling WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches ');

3291:
3292: IF NOT(l_constraint_found) THEN
3293:
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.logmsg(l_module_name,' Calling WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches ');
3296: END IF;
3297: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
3298: p_region_id => l_region_id,
3299: x_zone_tab => l_zone_tab,

Line 3297: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

3293:
3294: IF l_debug_on THEN
3295: WSH_DEBUG_SV.logmsg(l_module_name,' Calling WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches ');
3296: END IF;
3297: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
3298: p_region_id => l_region_id,
3299: x_zone_tab => l_zone_tab,
3300: x_return_status => l_return_status);
3301:

Line 17877: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

17873: IF l_debug_on THEN
17874: WSH_DEBUG_SV.logmsg(l_module_name,'g_region_mustuse_location.COUNT : '|| g_region_mustuse_location.COUNT);
17875: END IF;
17876:
17877: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
17878: p_location_id => l_ship_to_location_id,
17879: p_use_cache => TRUE,
17880: p_lang_code => USERENV('LANG'),
17881: x_region_tab => l_region_tab,

Line 17910: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

17906:
17907: IF (l_ship_to_location_id < g_cache_max_size AND l_deconsol_location IS NOT NULL) THEN
17908: g_location_mustuse_location(l_ship_to_location_id) := l_deconsol_location;
17909: ELSIF l_deconsol_location IS NULL THEN
17910: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
17911: p_region_id => l_region_id,
17912: x_zone_tab => l_zone_tab,
17913: x_return_status => l_return_status);
17914:

Line 18073: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(

18069: IF l_debug_on THEN
18070: WSH_DEBUG_SV.logmsg(l_module_name,'g_region_mustuse_location.COUNT : '|| g_region_mustuse_location.COUNT);
18071: END IF;
18072:
18073: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches(
18074: p_location_id => l_ship_from_location_id,
18075: p_use_cache => TRUE,
18076: p_lang_code => USERENV('LANG'),
18077: x_region_tab => l_region_tab,

Line 18106: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

18102:
18103: IF (l_ship_to_location_id < g_cache_max_size AND l_deconsol_location IS NOT NULL) THEN
18104: g_location_mustuse_location(l_ship_from_location_id) := l_deconsol_location;
18105: ELSIF l_deconsol_location IS NULL THEN
18106: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
18107: p_region_id => l_region_id,
18108: x_zone_tab => l_zone_tab,
18109: x_return_status => l_return_status);
18110:

Line 18262: l_region_tab WSH_REGIONS_SEARCH_PKG.region_deconsol_Tab_Type;

18258: l_rule_deconsol_location NUMBER;
18259: l_debug_on CONSTANT BOOLEAN := WSH_DEBUG_SV.is_debug_enabled;
18260: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'VALIDATE_CONSTRAINT_DECONSOL';
18261: rec_cnt NUMBER;
18262: l_region_tab WSH_REGIONS_SEARCH_PKG.region_deconsol_Tab_Type;
18263: l_success VARCHAR2(1) := 'S';
18264: l_failure VARCHAR2(1) := 'F';
18265: l_zone_index NUMBER := 0;
18266: l_msg_count NUMBER := 0;

Line 18579: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols

18575: IF l_debug_on THEN
18576: WSH_DEBUG_SV.logmsg(l_module_name,'p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID: '||p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID);
18577: END IF;
18578:
18579: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols
18580: ( p_location_id => p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID,
18581: p_use_cache => TRUE,
18582: p_lang_code => USERENV('LANG'),
18583: p_zone_flag => TRUE,

Line 18669: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols

18665: -- }
18666: ELSE -- if
18667: --{
18668:
18669: WSH_REGIONS_SEARCH_PKG.get_all_region_deconsols
18670: ( p_location_id => p_delivery_info(rec_cnt).ULTIMATE_DROPOFF_LOCATION_ID,
18671: p_use_cache => TRUE,
18672: p_lang_code => USERENV('LANG'),
18673: p_zone_flag => TRUE,