[Home] [Help]
574: -- Special case for SSHR if the profile is set
575: -- as we need to make sure that the generation controls table is not
576: -- locked.
577: --
578: if fnd_profile.value('PER_SSHR_NO_EMPNUM_GENERATION') = 'Y' then
579: return;
580: end if;
581: --
582: -- -> #2660279: NEW code
972: hr_utility.set_location('hr_person.derive_full_name',1);
973: end if;
974:
975: if p_title IS NOT NULL and
976: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
977: SELECT meaning
978: INTO l_title_meaning
979: FROM hr_lookups
980: WHERE lookup_type = 'TITLE'
1174: -- Bug 2040730
1175: -- When Cross Business Groups is enabled, new global duplicate checking is
1176: -- carried out, so don't need to repeat check here
1177: --
1178: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1179: begin
1180: --
1181: if g_debug then
1182: hr_utility.set_location('hr_person.derive_full_name',3);
1454: hr_utility.set_message(801,'HR_EMP_SS_EXISTS');
1455: elsif l_legislation_code = 'GB' then
1456: hr_utility.set_message(801,'HR_EMP_NI_EXISTS');
1457: -- psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING is set to NULL
1458: elsif l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
1459: null;
1460: else
1461: hr_utility.set_message(801,'HR_EMP_NAT_ID_EXISTS');
1462: end if;
1461: hr_utility.set_message(801,'HR_EMP_NAT_ID_EXISTS');
1462: end if;
1463: /* psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING
1464: is set to NULL then only null statement to be executed.*/
1465: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
1466: null;
1467: else
1468: raise local_warning;
1469: end if;
1534: AND length(p_national_identifier) = 9 then
1535: NULL ;
1536: else
1537: --Fix for bug2356249 start here.
1538: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1539: hr_utility.set_warning;
1540: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1541: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');
1542: hr_utility.raise_error;
1536: else
1537: --Fix for bug2356249 start here.
1538: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1539: hr_utility.set_warning;
1540: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1541: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');
1542: hr_utility.raise_error;
1543: end if;
1544: --Fix for bug2356249 ends here.
1555: and length(p_national_identifier) = 11 then
1556: null;
1557: else
1558: --Fix for bug2356249 start here.
1559: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1560: hr_utility.set_warning;
1561: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1562: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');
1563: hr_utility.raise_error;
1557: else
1558: --Fix for bug2356249 start here.
1559: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1560: hr_utility.set_warning;
1561: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1562: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');
1563: hr_utility.raise_error;
1564: end if;
1565: --Fix for bug2356249 ends here.
2032: IF g_debug THEN
2033: hr_utility.set_location ('hr_person.fpt_check_ft_person_type',10);
2034: END IF;
2035:
2036: IF (nvl(fnd_profile.value('HR_ALLOW_FPT_UPDATES'),'N') = 'Y') THEN
2037:
2038: SELECT 'Y'
2039: INTO p_test_func
2040: FROM sys.dual