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.

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 134: hr_utility.raise_error;

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

Line 145: hr_utility.raise_error;

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

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

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

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

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

Line 225: hr_utility.raise_error;

221: )
222: then
223: --
224: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
225: hr_utility.raise_error;
226: --
227: end if;
228: end if;
229: end if;

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

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

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

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

Line 299: hr_utility.raise_error;

295: )
296: then
297: --
298: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
299: hr_utility.raise_error;
300: --
301: end if;
302: end if;
303: end if;

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

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

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

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

Line 374: hr_utility.raise_error;

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

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

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

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

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

Line 452: hr_utility.raise_error;

448: )
449: then
450: --
451: hr_utility.set_message(800, 'HR_374803_SA_INVALID_RELIGION');
452: hr_utility.raise_error;
453: --
454: end if;
455: end if;
456: end if;

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

465: ) IS
466: BEGIN
467:
468: /* Added for GSI Bug 5472781 */
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');

Line 475: hr_utility.raise_error;

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

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

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

Line 523: hr_utility.raise_error;

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

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

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

Line 537: hr_utility.raise_error;

533: )
534: THEN
535: --
536: hr_utility.set_message(800, 'HR_374804_SA_INVALID_EMP_STAT');
537: hr_utility.raise_error;
538: --
539: END IF;
540: END IF;
541: END IF;

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

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

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

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

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

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

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

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

Line 630: hr_utility.raise_error;

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;
633: END IF;
634: END create_person_eit_validate;

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

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

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

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

Line 685: hr_utility.raise_error;

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;
688: END IF;
689: END update_person_eit_validate;

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

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

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

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

Line 718: hr_utility.raise_error;

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;
721: END assignment_annuities_validate;
722: END hr_sa_validate_pkg;