eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.HR_SA_VALIDATE_PKG dependencies on HR_UTILITY

Line 39: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

35: l_emp_type varchar2(10);
36: BEGIN
37:
38: /* Added for GSI Bug 5472781 */
39: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
40:
41: l_emp_type:= NULL;
42: g_type := NULL;
43: IF p_per_information_category = 'SA' THEN

Line 131: hr_utility.raise_error;

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
135: IF (p_sex = 'M'

Line 142: hr_utility.raise_error;

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
146: IF p_per_information8 is not null THEN

Line 204: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

200: ,p_per_information9 => p_per_information9
201: ,p_per_information10 => p_per_information10);
202:
203: /* Added for GSI Bug 5472781 */
204: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
205:
206: if g_type IS NOT NULL THEN
207: if p_per_information_category = 'SA' and p_per_information7 is not null then
208: --

Line 221: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');

217: ,p_lookup_code => p_per_information7
218: )
219: then
220: --
221: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
222: hr_utility.raise_error;
223: --
224: end if;
225: end if;

Line 222: hr_utility.raise_error;

218: )
219: then
220: --
221: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
222: hr_utility.raise_error;
223: --
224: end if;
225: end if;
226: end if;

Line 278: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

274: ,p_per_information9 => p_per_information9
275: ,p_per_information10 => p_per_information10);
276:
277: /* Added for GSI Bug 5472781 */
278: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
279:
280: if g_type IS NOT NULL THEN
281: if p_per_information_category = 'SA' and p_per_information7 is not null then
282: --

Line 295: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');

291: ,p_lookup_code => p_per_information7
292: )
293: then
294: --
295: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
296: hr_utility.raise_error;
297: --
298: end if;
299: end if;

Line 296: hr_utility.raise_error;

292: )
293: then
294: --
295: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
296: hr_utility.raise_error;
297: --
298: end if;
299: end if;
300: end if;

Line 353: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

349: ,p_per_information9 => p_per_information9
350: ,p_per_information10 => p_per_information10);
351:
352: /* Added for GSI Bug 5472781 */
353: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
354:
355: if g_type IS NOT NULL THEN
356: if p_per_information_category = 'SA' and p_per_information7 is not null then
357: --

Line 370: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');

366: ,p_lookup_code => p_per_information7
367: )
368: then
369: --
370: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
371: hr_utility.raise_error;
372: --
373: end if;
374: end if;

Line 371: hr_utility.raise_error;

367: )
368: then
369: --
370: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
371: hr_utility.raise_error;
372: --
373: end if;
374: end if;
375: --Validate that the Hijrah Hire Date is a valid hijrah date

Line 431: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

427: ,p_per_information9 => p_per_information9
428: ,p_per_information10 => p_per_information10);
429:
430: /* Added for GSI Bug 5472781 */
431: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
432:
433: if g_type IS NOT NULL THEN
434: if p_per_information_category = 'SA' and p_per_information7 is not null then
435: --

Line 448: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');

444: ,p_lookup_code => p_per_information7
445: )
446: then
447: --
448: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
449: hr_utility.raise_error;
450: --
451: end if;
452: end if;

Line 449: hr_utility.raise_error;

445: )
446: then
447: --
448: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
449: hr_utility.raise_error;
450: --
451: end if;
452: end if;
453: end if;

Line 466: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

462: ) IS
463: BEGIN
464:
465: /* Added for GSI Bug 5472781 */
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');

Line 472: hr_utility.raise_error;

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;
476: END previous_employer_validate;

Line 495: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

491: l_field VARCHAR2(300) := NULL;
492: BEGIN
493:
494: /* Added for GSI Bug 5472781 */
495: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
496:
497: IF p_ctr_information_category = 'SA' THEN
498: IF p_type = 'SPECIFIED_PERIOD' THEN
499: IF p_duration IS NULL THEN

Line 520: hr_utility.raise_error;

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'
524: --

Line 533: hr_utility.set_message(800, 'HR_374804_SA_INVALID_EMP_STAT');

529: ,p_lookup_code => p_ctr_information1
530: )
531: THEN
532: --
533: hr_utility.set_message(800, 'HR_374804_SA_INVALID_EMP_STAT');
534: hr_utility.raise_error;
535: --
536: END IF;
537: END IF;

Line 534: hr_utility.raise_error;

530: )
531: THEN
532: --
533: hr_utility.set_message(800, 'HR_374804_SA_INVALID_EMP_STAT');
534: hr_utility.raise_error;
535: --
536: END IF;
537: END IF;
538: END IF;

Line 550: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

546: l_hijrah_date varchar2(10);
547: l_valid_date varchar2(10);
548: BEGIN
549: /* Added for GSI Bug 5472781 */
550: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
551: IF p_pds_information_category = 'SA' THEN
552: l_hijrah_date := p_pds_information1;
553: hr_sa_hijrah_functions.validate_date(l_hijrah_date,l_valid_date);
554: END IF;

Line 575: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

571: l_valid_date1 varchar2(10);
572: l_valid_date2 varchar2(10);
573: BEGIN
574: /* Added for GSI Bug 5472781 */
575: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
576: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
577: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
578: END IF;
579: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information4 is not null THEN

Line 613: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

609: And fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date;
610: BEGIN
611:
612: /* Added for GSI Bug 5472781 */
613: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
614:
615: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
616: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
617: END IF;

Line 626: hr_utility.set_message(800, 'HR_374813_SA_INVALID_HAFIZA');

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;
630: END IF;

Line 627: hr_utility.raise_error;

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;
630: END IF;
631: END create_person_eit_validate;

Line 665: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

661: And fnd.effective_date between ppf.effective_start_date and ppf.effective_end_date;
662: BEGIN
663:
664: /* Added for GSI Bug 5472781 */
665: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
666:
667: IF p_pei_information_category = 'SA_IQAMA' and p_pei_information3 is not null THEN
668: hr_sa_hijrah_functions.validate_date(p_pei_information3,l_valid_date1);
669: END IF;

Line 681: hr_utility.set_message(800, 'HR_374813_SA_HAFIZA_INVALID');

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;
685: END IF;

Line 682: hr_utility.raise_error;

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;
685: END IF;
686: END update_person_eit_validate;

Line 703: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN

699: AND p_effective_date BETWEEN effective_start_date AND effective_end_date;
700: BEGIN
701:
702: /* Added for GSI Bug 5472781 */
703: IF hr_utility.chk_product_install('Oracle Human Resources', 'SA') THEN
704:
705: SELECT person_id
706: INTO l_person_id
707: FROM per_all_assignments_f

Line 714: hr_utility.set_message(800, 'HR_374811_SA_INVALID_ANNUITIES');

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;
718: END assignment_annuities_validate;

Line 715: hr_utility.raise_error;

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;
718: END assignment_annuities_validate;
719: END hr_sa_validate_pkg;