APPS.HR_SA_VALIDATE_PKG dependencies on FND_PROFILE

Line 68: IF UPPER(p_nationality) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN

64: v_field := v_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','M_FATHER_NAME');
65: END IF;
66: END IF; */ --Removed as per enhancement bug 3580573
67: --Validate grandfather is not null if nationality is saudi
68: IF UPPER(p_nationality) = FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN
69: /*IF p_per_information2 IS NULL THEN
70: IF v_field IS NULL THEN
71: v_field := hr_general.decode_lookup('SA_FORM_LABELS','M_GRANDFATHER_NAME');
72: ELSE

Line 625: if upper(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN

621: IF p_pei_information_category = 'SA_HAFIZA' and p_pei_information1 is not null THEN
622: OPEN csr_get_nationality(p_person_id);
623: FETCH csr_get_nationality into l_nationality;
624: CLOSE csr_get_nationality ;
625: if upper(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN
626: hr_utility.set_message(800, 'HR_374813_SA_INVALID_HAFIZA');
627: hr_utility.raise_error;
628: end if;
629: END IF;

Line 680: if upper(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN

676: CLOSE csr_get_pid;
677: OPEN csr_get_nationality(l_person_id);
678: FETCH csr_get_nationality into l_nationality;
679: CLOSE csr_get_nationality ;
680: if upper(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN
681: hr_utility.set_message(800, 'HR_374813_SA_HAFIZA_INVALID');
682: hr_utility.raise_error;
683: end if;
684: END IF;

Line 713: IF p_segment3 = 'Y' and UPPER(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN

709: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
710: open csr_nationality;
711: fetch csr_nationality into l_nationality;
712: close csr_nationality;
713: IF p_segment3 = 'Y' and UPPER(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN
714: hr_utility.set_message(800, 'HR_374811_SA_INVALID_ANNUITIES');
715: hr_utility.raise_error;
716: END IF;
717: END IF;