DBA Data[Home] [Help]

APPS.PER_PER_BUS dependencies on FND_PROFILE

Line 650: if not (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y')

646: --
647: -- ER FPT
648: if (p_datetrack_mode = 'UPDATE_CHANGE_INSERT')
649: then
650: if not (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y')
651: then
652: hr_utility.set_message(801, 'HR_7724_PER_DT_MODE_SPT_CHANGE');
653: hr_utility.raise_error;
654: end if;

Line 1596: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'NONE' and fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' then

1592: -- 3807899 - Modified the 'or' condition to 'and'
1593: -- Also modified the value used to set the token 'RETURNED_VALUE' to l_valid_ni
1594: -- instead of '123-45-789'
1595: --
1596: if fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'NONE' and fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION') <> 'WARN' then
1597: -- #932657
1598: if l_valid_ni <> p_national_identifier then
1599: hr_utility.set_message(800, 'HR_52765_PER_INV_NI_FORMAT');
1600: hr_utility.set_message_token('P_N_I', p_national_identifier);

Line 1606: l_prof_val := fnd_profile.value ('PER_NI_UNIQUE_ERROR_WARNING');

1602: hr_utility.raise_error;
1603: end if;
1604: end if;
1605: -- 4069243 start
1606: l_prof_val := fnd_profile.value ('PER_NI_UNIQUE_ERROR_WARNING');
1607:
1608: hr_ni_chk_pkg.check_ni_unique
1609: (p_national_identifier => p_national_identifier
1610: ,p_person_id => p_person_id

Line 2014: and nvl(fnd_profile.value('PER_GLOBAL_EMP_NUM'),'N') = 'Y'

2010: --
2011: -- Call number generation routine.
2012: --
2013: if l_gen_method = 'A'
2014: and nvl(fnd_profile.value('PER_GLOBAL_EMP_NUM'),'N') = 'Y'
2015: and ( PER_BG_NUMBERING_METHOD_PKG.Get_PersonNumber_Formula
2016: ('EMP',p_effective_date)) is null
2017: and p_employee_number is not null
2018: and g_global_transfer_in_process then

Line 2339: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then

2335: nvl(per_per_shd.g_old_rec.npw_number, hr_api.g_varchar2) <>
2336: nvl(p_npw_number, hr_api.g_varchar2) and
2337: l_gen_method = 'A' then
2338: -- ER FPT
2339: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2340: hr_utility.set_message(800, 'HR_289657_PER_INV_CWK_UPD');
2341: hr_utility.raise_error;
2342: end if;
2343: end if;

Line 2377: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then

2373: p_npw_number is not null and
2374:
2375: p_npw_number <> nvl(per_per_shd.g_old_rec.npw_number,hr_api.g_varchar2) then
2376: -- ER FPT
2377: if not ((nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') and per_per_shd.g_old_rec.npw_number is null) then
2378: hr_utility.set_message(800,'PER_289635_CWK_NUM_NOT_NULL');
2379: hr_utility.raise_error;
2380: end if;
2381: end if;