171: WHEN no_data_found THEN /* Try the translated name. */
172: BEGIN
173: SELECT application_id
174: INTO application_id_ret
175: FROM fnd_application_tl
176: WHERE application_name = application_name_in
177: AND rownum = 1;
178: RETURN application_id_ret;
179: EXCEPTION
208: WHEN no_data_found THEN /* Try the translated name. */
209: BEGIN
210: SELECT application_short_name
211: INTO application_sn_ret
212: FROM fnd_application_tl t,
213: fnd_application b
214: WHERE t.application_name = application_name_in
215: AND rownum = 1
216: AND t.application_id = b.application_id;