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 628: if upper(l_nationality) <> FND_PROFILE.VALUE('PER_LOCAL_NATIONALITY') THEN

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

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

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

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

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