205: BEGIN
206: --
207: IF (p_number IS NOT NULL) THEN
208:
209: l_mask_size := Fnd_Profile.value_wnps('HR_MASK_CHARACTERS');
210:
211: IF (ABS(l_mask_size) > LENGTH(p_number)) THEN
212: l_mask_size := LENGTH(p_number);
213: END IF;
279: l_dummy varchar2(1);
280: BEGIN
281: --
282: hr_utility.set_location('11',10);
283: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
284: return l_duplicate_found;
285: end if;
286: -- Get the session date
287: SELECT se.effective_date
392: l_dummy varchar2(1);
393: BEGIN
394: --
395: hr_utility.set_location('1',10);
396: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
397: return l_duplicate_found;
398: end if;
399: -- Get the session date
400: SELECT se.effective_date
1154: --
1155: -- If the profile restricts by assignment-based supervisor hierarchies,
1156: -- return true.
1157: --
1158: IF NVL(fnd_profile.value('HR_SUPERVISOR_HIERARCHY_USAGE'), 'P') = 'A' THEN
1159: RETURN 'TRUE';
1160: ELSE
1161: RETURN 'FALSE';
1162: END IF;
1396: begin
1397:
1398: hr_utility.set_location('1',10);
1399:
1400: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1401: hr_utility.set_location('2',10);
1402: return l_duplicate_found;
1403: else
1404: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1400: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1401: hr_utility.set_location('2',10);
1402: return l_duplicate_found;
1403: else
1404: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1405: hr_utility.set_location('3',10);
1406: -- Get the session date
1407: SELECT se.effective_date
1408: INTO l_session_date
1569:
1570:
1571: hr_utility.set_location('SSHR',10);
1572:
1573: if fnd_profile.value('HR_CROSS_BUSINESS_GROUP') = 'N' then
1574: hr_utility.set_location('SSHR',10.1);
1575: --fix for bug 5923547 starts here.
1576: hr_person_name.derive_person_names
1577: (p_format_name => null
1710: l_duplicate_found := FALSE;
1711: end if;
1712: --fix for bug 5923547 ends here.
1713: else
1714: if nvl(fnd_profile.value('HR_DUPLICATE_PERSON_CHECK'),'Y') = 'Y' then --fix for bug 5930576
1715: hr_utility.set_location('SSHR',20);
1716:
1717:
1718: -- Query to detect duplicate person
1860: is
1861:
1862: begin
1863:
1864: hr_utility.set_location('Before: FND PROFILE CALL', 13163);
1865:
1866: fnd_profile.put(NAME,VAL);
1867:
1868: hr_utility.set_location('After: FND PROFILE CALL', 13163);
1862: begin
1863:
1864: hr_utility.set_location('Before: FND PROFILE CALL', 13163);
1865:
1866: fnd_profile.put(NAME,VAL);
1867:
1868: hr_utility.set_location('After: FND PROFILE CALL', 13163);
1869:
1870: end SERVER_SIDE_PROFILE_PUT;
1864: hr_utility.set_location('Before: FND PROFILE CALL', 13163);
1865:
1866: fnd_profile.put(NAME,VAL);
1867:
1868: hr_utility.set_location('After: FND PROFILE CALL', 13163);
1869:
1870: end SERVER_SIDE_PROFILE_PUT;
1871:
1872: