DBA Data[Home] [Help]

APPS.BEN_DETERMINE_DPNT_ELIG_SS dependencies on HR_UTILITY

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

278: --
279: l_dummy varchar2(1);
280:
281: begin
282: hr_utility.set_location ('Entering '|| l_proc,10);
283: --6279654
284: if fnd_global.conc_request_id = -1 then
285: --
286: if ben_env_object.g_global_env_rec.business_group_id is null then

Line 292: hr_utility.set_location ('business_group_id '|| l_business_group_id, 8085);

288: open c_bg_id;
289: fetch c_bg_id into l_business_group_id;
290: close c_bg_id;
291:
292: hr_utility.set_location ('business_group_id '|| l_business_group_id, 8085);
293: hr_utility.set_location ('effective_date '|| p_effective_date, 8085);
294:
295: ben_env_object.init(p_business_group_id => l_business_group_id,
296: p_effective_date => p_effective_date,

Line 293: hr_utility.set_location ('effective_date '|| p_effective_date, 8085);

289: fetch c_bg_id into l_business_group_id;
290: close c_bg_id;
291:
292: hr_utility.set_location ('business_group_id '|| l_business_group_id, 8085);
293: hr_utility.set_location ('effective_date '|| p_effective_date, 8085);
294:
295: ben_env_object.init(p_business_group_id => l_business_group_id,
296: p_effective_date => p_effective_date,
297: p_thread_id => 1,

Line 637: hr_utility.set_location ('Leaving '|| l_proc,10);

633: close c_elig_dpnt;
634: --
635: end loop;
636: --
637: hr_utility.set_location ('Leaving '|| l_proc,10);
638:
639: exception
640: when others then
641: fnd_msg_pub.initialize;

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

775: l_found boolean := false;
776: --
777: begin
778: --
779: hr_utility.set_location('Entering: '||l_proc,10);
780: --
781: for l_pgm_rec in c_pgm loop
782: --
783: if l_pgm_rec.vrfy_fmly_mmbr_cd is not null or --level 1

Line 901: hr_utility.set_location('Leaving: '||l_proc,20);

897: end if;
898: end if; --level 2
899: end if; --level 1
900: end loop; --pgm end loop
901: hr_utility.set_location('Leaving: '||l_proc,20);
902: --
903: if (l_found) then
904: p_fmly_mmbr_exist := 'Y';
905: else

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

1800:
1801: l_proc varchar2(100):= g_package||'.validate_national_identifier_w';
1802: l_status varchar2(20);
1803: begin
1804: hr_utility.set_location('Entering: '||l_proc,10);
1805: hr_utility.set_location('p_birth_date: '||p_birth_date,10);
1806: hr_utility.set_location('p_effective_date: '||p_effective_date,10);
1807:
1808: hr_person_info_util_ss.validate_national_identifier(

Line 1805: hr_utility.set_location('p_birth_date: '||p_birth_date,10);

1801: l_proc varchar2(100):= g_package||'.validate_national_identifier_w';
1802: l_status varchar2(20);
1803: begin
1804: hr_utility.set_location('Entering: '||l_proc,10);
1805: hr_utility.set_location('p_birth_date: '||p_birth_date,10);
1806: hr_utility.set_location('p_effective_date: '||p_effective_date,10);
1807:
1808: hr_person_info_util_ss.validate_national_identifier(
1809: p_national_identifier => p_national_identifier

Line 1806: hr_utility.set_location('p_effective_date: '||p_effective_date,10);

1802: l_status varchar2(20);
1803: begin
1804: hr_utility.set_location('Entering: '||l_proc,10);
1805: hr_utility.set_location('p_birth_date: '||p_birth_date,10);
1806: hr_utility.set_location('p_effective_date: '||p_effective_date,10);
1807:
1808: hr_person_info_util_ss.validate_national_identifier(
1809: p_national_identifier => p_national_identifier
1810: ,p_birth_date => p_birth_date

Line 1818: hr_utility.set_location('Leaving: '||l_proc,10);

1814: ,p_legislation_code => p_legislation_code
1815: ,p_effective_date => p_effective_date
1816: ,p_warning => l_status);
1817: p_status := l_status;
1818: hr_utility.set_location('Leaving: '||l_proc,10);
1819: exception
1820: when others then
1821: p_status := l_status;
1822: hr_utility.set_location('Leaving: '||l_proc,10);

Line 1822: hr_utility.set_location('Leaving: '||l_proc,10);

1818: hr_utility.set_location('Leaving: '||l_proc,10);
1819: exception
1820: when others then
1821: p_status := l_status;
1822: hr_utility.set_location('Leaving: '||l_proc,10);
1823: end validate_national_identifier_w;
1824:
1825: --Created New Procedure to validate the Uniqueness of SSN
1826: procedure check_ni_unique_w(

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

1832: l_proc varchar2(100):= g_package||'.check_ni_unique_w';
1833: l_status varchar2(20);
1834:
1835: begin
1836: hr_utility.set_location('Entering: '||l_proc,10);
1837:
1838: hr_person_info_util_ss.check_ni_unique(p_national_identifier => p_national_identifier
1839: ,p_person_id => p_person_id
1840: ,p_business_group_id => p_business_group_id

Line 1843: hr_utility.set_location('Leaving: '||l_proc,10);

1839: ,p_person_id => p_person_id
1840: ,p_business_group_id => p_business_group_id
1841: ,p_ni_duplicate_warn_or_err => l_status);
1842: p_status := l_status;
1843: hr_utility.set_location('Leaving: '||l_proc,10);
1844: exception
1845: when others then
1846: p_status := l_status;
1847: hr_utility.set_location('Leaving: '||l_proc,10);

Line 1847: hr_utility.set_location('Leaving: '||l_proc,10);

1843: hr_utility.set_location('Leaving: '||l_proc,10);
1844: exception
1845: when others then
1846: p_status := l_status;
1847: hr_utility.set_location('Leaving: '||l_proc,10);
1848: end check_ni_unique_w;
1849: --End AMN Bug 14383515
1850: end ben_determine_dpnt_elig_ss;