APPS.OE_ITORD_UTIL dependencies on WSH_REGIONS_SEARCH_PKG

Line 72: --bug7294798 using WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches to get all matching region_ids

68: End;
69:
70: --------------------------------------------------------------------------------------
71: --Function get_region_id will return the region_id for the passed ship_to_org_id
72: --bug7294798 using WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches to get all matching region_ids
73: --Get all the matching region_id for the current location_id and comma seperate it.This
74: -- comma seperated list of region_ids is used in validation routines and OE_ITEMS_ORD_MV to support rules based on regions
75: --------------------------------------------------------------------------------------
76: Function get_region_ids ( p_ship_to_org_id IN NUMBER)

Line 97: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches

93: END IF;
94:
95: l_location_id := OE_ITORD_UTIL.Get_Shipto_Location_Id(p_ship_to_org_id);
96:
97: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches
98: ( p_location_id => l_location_id,
99: p_use_cache => TRUE,
100: p_lang_code => USERENV('LANG'),
101: x_region_tab => l_region_id_tbl,

Line 106: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');

102: x_return_status => l_return_status );
103:
104: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
105: IF l_debug_level > 0 then
106: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches');
107: END IF;
108:
109: RETURN NULL;
110: END IF;

Line 116: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(

112: -- if there are any regions returned then check following for zone
113: IF l_region_id_tbl.count >0 THEN
114: FOR i IN l_region_id_tbl.FIRST..l_region_id_tbl.LAST LOOP
115:
116: WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches(
117: p_region_id => l_region_id_tbl(i),
118: x_zone_tab => Region_Loc_zone_tab,
119: x_return_status => l_return_status);
120:

Line 123: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');

119: x_return_status => l_return_status);
120:
121: IF l_return_status <> FND_API.G_RET_STS_SUCCESS then
122: IF l_debug_level > 0 then
123: oe_debug_pub.add('Unexpected error in WSH_REGIONS_SEARCH_PKG.Get_All_Zone_Matches');
124: END IF;
125:
126: RETURN NULL;
127: END IF;