DBA Data[Home] [Help]

APPS.HR_PERSON_NAME dependencies on HR_UTILITY

Line 579: -- hr_utility.set_location('Entering '||l_proc,10);

575: -- l_format varchar2(400);
576: --
577: --begin
578: --
579: -- hr_utility.set_location('Entering '||l_proc,10);
580: --
581: --open c1;
582: -- fetch c1 into person_rec;
583: --

Line 598: -- hr_utility.set_location('Replacing tokens '||l_proc,20);

594: -- if p_format is not null then --format specified
595: --
596: -- l_format := p_format;
597: --
598: -- hr_utility.set_location('Replacing tokens '||l_proc,20);
599: -- Replacing the tokens with person name components.
600: --
601: -- l_format := replace(l_format,'$FI',person_rec.first_name);
602: -- l_format := replace(l_format,'$MI',person_rec.middle_names);

Line 614: -- hr_utility.set_location('Replacing tokens '||l_proc,20);

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');
617: -- hr_utility.trace('profile option value : ' || l_format);
618: --

Line 617: -- hr_utility.trace('profile option value : ' || l_format);

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: --
621: -- l_format := replace(l_format,'$FI',person_rec.first_name);

Line 635: -- hr_utility.set_location('No format specified Full_Name '||l_proc,40);

631:
632: -- else -- format not specified.
633: --
634: --
635: -- hr_utility.set_location('No format specified Full_Name '||l_proc,40);
636: -- in this case returning full_name.
637: --
638: -- l_format := person_rec.full_name;
639: --

Line 644: -- hr_utility.set_location('Leaving '||l_proc,50);

640: --
641: -- end if;
642: --
643: --
644: -- hr_utility.set_location('Leaving '||l_proc,50);
645: --
646: -- return l_format;
647: --
648: --

Line 652: -- hr_utility.set_location('Leaving '||l_proc,60);

648: --
649: -- end if;
650: --
651: -- close c1;
652: -- hr_utility.set_location('Leaving '||l_proc,60);
653: --
654: --end get_person_name; --function
655: --
656: -- ----------------------------------------------------------------------------

Line 689: if ( hr_utility.chk_product_install('Oracle Human Resources',p_legislation_code)

685: l_package_name := null;
686: l_procedure_name := null;
687: --
688: -- if hr_general.g_data_migrator_mode <> 'Y' then -- Fix For Bug # 13029361
689: if ( hr_utility.chk_product_install('Oracle Human Resources',p_legislation_code)
690: or (p_legislation_code = 'JP')) then
691: --
692: l_package_name := 'HR_'||p_legislation_code||'_UTILITY';
693: if p_format_name = g_FULL_NAME then

Line 1308: hr_utility.set_message(801,'HR_PERSON_DUPLICATE');

1304: )
1305: )
1306: );
1307: --
1308: hr_utility.set_message(801,'HR_PERSON_DUPLICATE');
1309:
1310: raise local_warning;
1311:
1312: --

Line 1321: hr_utility.set_warning;

1317: end if;
1318: --
1319: exception
1320: when local_warning then
1321: hr_utility.set_warning;
1322: p_duplicate_flag:='Y';
1323: --
1324: end derive_person_names;
1325: --