2707: if ( numeric_characters is not null ) then
2708: begin
2709: select lookup_code
2710: into dummy_val
2711: from fnd_lookup_values_vl
2712: where lookup_type = 'ICX_NUMERIC_CHARACTERS' and
2713: lookup_code = numeric_characters;
2714: exception
2715: when no_data_found then
4443: begin
4444:
4445: select count(*)
4446: into l_lookup_cnt
4447: from fnd_lookup_values_vl
4448: where lookup_type = 'ICX_NUMERIC_CHARACTERS'
4449: and lookup_code = num_char;
4450:
4451: if ( l_lookup_cnt > 0 ) then