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 94: WSH_REGIONS_SEARCH_PKG.Get_All_RegionId_Matches

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

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

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