DBA Data[Home] [Help]

APPS.HR_PERSON dependencies on FND_PROFILE

Line 527: if fnd_profile.value('PER_SSHR_NO_EMPNUM_GENERATION') = 'Y' then

523: -- Special case for SSHR if the profile is set
524: -- as we need to make sure that the generation controls table is not
525: -- locked.
526: --
527: if fnd_profile.value('PER_SSHR_NO_EMPNUM_GENERATION') = 'Y' then
528: return;
529: end if;
530: --
531: -- -> #2660279: NEW code

Line 925: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then

921: hr_utility.set_location('hr_person.derive_full_name',1);
922: end if;
923:
924: if p_title IS NOT NULL and
925: fnd_profile.value('PER_USE_TITLE_IN_FULL_NAME') = 'Y' then
926: SELECT meaning
927: INTO l_title_meaning
928: FROM hr_lookups
929: WHERE lookup_type = 'TITLE'

Line 1127: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then

1123: -- Bug 2040730
1124: -- When Cross Business Groups is enabled, new global duplicate checking is
1125: -- carried out, so don't need to repeat check here
1126: --
1127: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1128: begin
1129: --
1130: if g_debug then
1131: hr_utility.set_location('hr_person.derive_full_name',3);

Line 1407: elsif l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland

1403: hr_utility.set_message(801,'HR_EMP_SS_EXISTS');
1404: elsif l_legislation_code = 'GB' then
1405: hr_utility.set_message(801,'HR_EMP_NI_EXISTS');
1406: -- psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING is set to NULL
1407: elsif l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
1408: null;
1409: else
1410: hr_utility.set_message(801,'HR_EMP_NAT_ID_EXISTS');
1411: end if;

Line 1414: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland

1410: hr_utility.set_message(801,'HR_EMP_NAT_ID_EXISTS');
1411: end if;
1412: /* psingla - If the legislation is Polish and profile PER_NI_UNIQUE_ERROR_WARNING
1413: is set to NULL then only null statement to be executed.*/
1414: if l_legislation_code = 'PL' and fnd_profile.value('PER_NI_UNIQUE_ERROR_WARNING') is NULL then -- For Poland
1415: null;
1416: else
1417: raise local_warning;
1418: end if;

Line 1487: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN

1483: AND length(p_national_identifier) = 9 then
1484: NULL ;
1485: else
1486: --Fix for bug2356249 start here.
1487: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1488: hr_utility.set_warning;
1489: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1490: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');
1491: hr_utility.raise_error;

Line 1489: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then

1485: else
1486: --Fix for bug2356249 start here.
1487: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1488: hr_utility.set_warning;
1489: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1490: hr_utility.set_message(801,'HR_6522_EMP_INVALID_NI_NO');
1491: hr_utility.raise_error;
1492: end if;
1493: --Fix for bug2356249 ends here.

Line 1508: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN

1504: and length(p_national_identifier) = 11 then
1505: null;
1506: else
1507: --Fix for bug2356249 start here.
1508: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1509: hr_utility.set_warning;
1510: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1511: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');
1512: hr_utility.raise_error;

Line 1510: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then

1506: else
1507: --Fix for bug2356249 start here.
1508: if nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='WARN' THEN
1509: hr_utility.set_warning;
1510: elsif nvl(fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION'),'ERROR') ='ERROR' then
1511: hr_utility.set_message(801,'HR_7056_EMP_INVALID_SS_NO');
1512: hr_utility.raise_error;
1513: end if;
1514: --Fix for bug2356249 ends here.