128: END IF; -- To Fix Bug 4438655
129: END IF; -- To fix for bug 9109692
130: END IF;
131: IF v_field IS NOT NULL THEN
132: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
133: fnd_message.set_token('NAME',v_field, translate => true );
134: hr_utility.raise_error;
135: END IF;
136: --Validate the gender/title combination.
129: END IF; -- To fix for bug 9109692
130: END IF;
131: IF v_field IS NOT NULL THEN
132: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
133: fnd_message.set_token('NAME',v_field, translate => true );
134: hr_utility.raise_error;
135: END IF;
136: --Validate the gender/title combination.
137: IF p_sex IS NOT NULL THEN
140: OR
141: (p_sex = 'F'
142: AND UPPER(p_title) IN ('HH','PRINCE','MR.')) THEN
143: -- Error: Values for Sex and Title are inconsistent.
144: fnd_message.set_name('PAY', 'HR_6527_PERSON_SEX_AND_TITLE');
145: hr_utility.raise_error;
146: END IF;
147: END IF;
148: --Validate that the Hijrah Birth Date is a valid hijrah date
469: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
470:
471: if p_pem_information_category = 'SA' then
472: if p_employer_name is null then
473: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
474: fnd_message.set_token('NAME',p_employer_name, translate => true );
475: hr_utility.raise_error;
476: end if;
477: end if;
470:
471: if p_pem_information_category = 'SA' then
472: if p_employer_name is null then
473: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
474: fnd_message.set_token('NAME',p_employer_name, translate => true );
475: hr_utility.raise_error;
476: end if;
477: end if;
478: END IF;
517: l_field := l_field||', '||hr_general.decode_lookup('SA_FORM_LABELS','PROFESSION');
518: END IF;
519: END IF;
520: IF l_field IS NOT NULL THEN
521: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
522: fnd_message.set_token('NAME',l_field, translate => true );
523: hr_utility.raise_error;
524: END IF;
525: -- Check that the employment status exists in hr_lookups for the
518: END IF;
519: END IF;
520: IF l_field IS NOT NULL THEN
521: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
522: fnd_message.set_token('NAME',l_field, translate => true );
523: hr_utility.raise_error;
524: END IF;
525: -- Check that the employment status exists in hr_lookups for the
526: -- lookup type 'SA_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'