209:
210: -- First check with LOOKUP_CODE
211: BEGIN
212: SELECT lookup_code INTO l_code
213: FROM fnd_lookup_values_vl
214: WHERE lookup_type = p_lookup_type
215: AND lookup_code = p_value;
216: EXCEPTION
217: WHEN NO_DATA_FOUND THEN
218: BEGIN
219: -- If the given value can't be found as LOOKUP_CODE
220: -- try with 'like MEANING%'
221: SELECT lookup_code INTO l_code
222: FROM fnd_lookup_values_vl
223: WHERE lookup_type = p_lookup_type
224: AND meaning like p_value;
225: EXCEPTION
226: WHEN NO_DATA_FOUND THEN