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