[Home] [Help]
409: fnd_message.raise_error;
410: else
411: close csr_get_person_details;
412: if p_user_format_choice is null or p_user_format_choice not in ('G','L') then
413: l_user_format_choice := nvl(fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT'),'L');
414: else
415: l_user_format_choice := p_user_format_choice;
416: end if;
417: --
608: -- l_format := replace(l_format,'$KN',person_rec.known_as);
609: -- l_format := replace(l_format,'$IF',substr(ltrim(person_rec.first_name),1,1));
610: -- l_format := replace(l_format,'$IM',substr(ltrim(person_rec.middle_names),1,1));
611: --
612: -- elsif fnd_profile.value('HR_INFORMAL_NAME_FORMAT') is not null then
613: --
614: -- hr_utility.set_location('Replacing tokens '||l_proc,20);
615:
616: -- l_format := fnd_profile.value('HR_INFORMAL_NAME_FORMAT');
612: -- elsif fnd_profile.value('HR_INFORMAL_NAME_FORMAT') is not null then
613: --
614: -- hr_utility.set_location('Replacing tokens '||l_proc,20);
615:
616: -- l_format := fnd_profile.value('HR_INFORMAL_NAME_FORMAT');
617: -- hr_utility.trace('profile option value : ' || l_format);
618: --
619: -- Replacing the tokens with person name components.
620: --
1246: p_local_name := l_local_name_formatted;
1247: -- ----------------------------------------------------------------------- +
1248: -- Check duplicates Cross Business Groups is not enabled
1249: -- ----------------------------------------------------------------------- +
1250: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1251: declare
1252: -- bug 3988762
1253: l_legislation_code VARCHAR2(10) := HR_API.GET_LEGISLATION_CONTEXT;
1254: begin
1678: --
1679: function get_list_name(p_global_name in varchar2
1680: ,p_local_name in varchar2) return varchar2 is
1681: begin
1682: if fnd_profile.value('HR_LOCAL_OR_GLOBAL_NAME_FORMAT') = 'G' then
1683: return p_global_name;
1684: else
1685: return p_local_name;
1686: end if;