69: and lookup_code = p_lookup_code;
70: return l_lookup_meaning;
71: exception
72: when no_data_found then
73: fnd_message.set_name('PER','HR_NL_EMP_INVALID_LOOKUP');
74: fnd_message.set_token('LOOKUP',p_lookup_type);
75: fnd_message.raise_error;
76: return l_lookup_meaning;
77: end;
70: return l_lookup_meaning;
71: exception
72: when no_data_found then
73: fnd_message.set_name('PER','HR_NL_EMP_INVALID_LOOKUP');
74: fnd_message.set_token('LOOKUP',p_lookup_type);
75: fnd_message.raise_error;
76: return l_lookup_meaning;
77: end;
78:
71: exception
72: when no_data_found then
73: fnd_message.set_name('PER','HR_NL_EMP_INVALID_LOOKUP');
74: fnd_message.set_token('LOOKUP',p_lookup_type);
75: fnd_message.raise_error;
76: return l_lookup_meaning;
77: end;
78:
79: Function nl_lookup_meanings(p_lookup_type in varchar2, p_lookup_code in varchar2) return varchar2 is