206:
207: BEGIN
208: SELECT location_id,location_id
209: INTO addresscode,location
210: FROM po_user_preferences
211: WHERE functional_area = p_functional_area
212: AND address_type= l_addressType
213: AND FND_USER_ID = fnd_global.user_id;
214: EXCEPTION
227:
228: BEGIN
229: SELECT contact_id
230: INTO contact
231: FROM po_user_preferences
232: WHERE functional_area = p_functional_area
233: AND address_type= l_addressType
234: AND FND_USER_ID = fnd_global.user_id;
235: EXCEPTION