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_AE_VALIDATE_PKG dependencies on HR_API

Line 205: IF p_per_information18 <> NVL(l_local_nationality,'*') AND (p_per_information9 IS NOT NULL AND p_per_information9 <> hr_api.g_varchar2) THEN

201: FETCH csr_get_loc_nat INTO rec_get_loc_nat;
202: l_local_nationality := rec_get_loc_nat.org_information1;
203: CLOSE csr_get_loc_nat;
204: --IF p_nationality <> NVL(l_local_nationality,'*') AND p_per_information9 IS NOT NULL THEN
205: IF p_per_information18 <> NVL(l_local_nationality,'*') AND (p_per_information9 IS NOT NULL AND p_per_information9 <> hr_api.g_varchar2) THEN
206: IF (p_per_information16 IS NOT NULL AND p_per_information16 <> hr_api.g_varchar2) OR (p_per_information17 IS NOT NULL AND p_per_information17 <> hr_api.g_varchar2) THEN
207: hr_utility.set_message(800, 'HR_377410_AE_DAT_REA_INVALID');
208: hr_utility.raise_error;
209: END IF;

Line 206: IF (p_per_information16 IS NOT NULL AND p_per_information16 <> hr_api.g_varchar2) OR (p_per_information17 IS NOT NULL AND p_per_information17 <> hr_api.g_varchar2) THEN

202: l_local_nationality := rec_get_loc_nat.org_information1;
203: CLOSE csr_get_loc_nat;
204: --IF p_nationality <> NVL(l_local_nationality,'*') AND p_per_information9 IS NOT NULL THEN
205: IF p_per_information18 <> NVL(l_local_nationality,'*') AND (p_per_information9 IS NOT NULL AND p_per_information9 <> hr_api.g_varchar2) THEN
206: IF (p_per_information16 IS NOT NULL AND p_per_information16 <> hr_api.g_varchar2) OR (p_per_information17 IS NOT NULL AND p_per_information17 <> hr_api.g_varchar2) THEN
207: hr_utility.set_message(800, 'HR_377410_AE_DAT_REA_INVALID');
208: hr_utility.raise_error;
209: END IF;
210: END IF;

Line 254: IF p_marital_status IS NOT NULL AND p_marital_status <> hr_api.g_varchar2 THEN

250: OPEN csr_fetch_bg_id;
251: FETCH csr_fetch_bg_id INTO l_bg_id;
252: CLOSE csr_fetch_bg_id;
253:
254: IF p_marital_status IS NOT NULL AND p_marital_status <> hr_api.g_varchar2 THEN
255: OPEN csr_val_mar_status(l_bg_id);
256: FETCH csr_val_mar_status INTO l_valid;
257: CLOSE csr_val_mar_status;
258: IF l_valid IS NULL THEN

Line 357: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then

353: END IF;
354: /* Added for GSI Bug 5472781 */
355: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
356: if g_type IS NOT NULL THEN
357: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then
358: --
359: -- Check that the religion exists in hr_lookups for the
360: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
361: -- the effective start date of the person is between start date

Line 364: if hr_api.not_exists_in_hr_lookups

360: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
361: -- the effective start date of the person is between start date
362: -- active and end date active in hr_lookups.
363: --
364: if hr_api.not_exists_in_hr_lookups
365: (p_effective_date => p_effective_date
366: ,p_lookup_type => 'AE_RELIGION'
367: ,p_lookup_code => p_per_information10
368: )

Line 377: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then

373: --
374: end if;
375: end if;
376:
377: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then
378: --
379: -- Check that the nationality exists in hr_lookups for the
380: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
381: -- the effective start date of the person is between start date

Line 384: if hr_api.not_exists_in_hr_lookups

380: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
381: -- the effective start date of the person is between start date
382: -- active and end date active in hr_lookups.
383: --
384: if hr_api.not_exists_in_hr_lookups
385: (p_effective_date => p_effective_date
386: ,p_lookup_type => 'AE_NATIONALITY'
387: ,p_lookup_code => p_per_information9
388: )

Line 476: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then

472: /* Added for GSI Bug 5472781 */
473: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
474:
475: if g_type IS NOT NULL THEN
476: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then
477: --
478: -- Check that the religion exists in hr_lookups for the
479: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
480: -- the effective start date of the person is between start date

Line 483: if hr_api.not_exists_in_hr_lookups

479: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
480: -- the effective start date of the person is between start date
481: -- active and end date active in hr_lookups.
482: --
483: if hr_api.not_exists_in_hr_lookups
484: (p_effective_date => p_date_received
485: ,p_lookup_type => 'AE_RELIGION'
486: ,p_lookup_code => p_per_information10
487: )

Line 496: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then

492: --
493: end if;
494: end if;
495:
496: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then
497: --
498: -- Check that the nationality exists in hr_lookups for the
499: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
500: -- the effective start date of the person is between start date

Line 503: if hr_api.not_exists_in_hr_lookups

499: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
500: -- the effective start date of the person is between start date
501: -- active and end date active in hr_lookups.
502: --
503: if hr_api.not_exists_in_hr_lookups
504: (p_effective_date => p_date_received
505: ,p_lookup_type => 'AE_NATIONALITY'
506: ,p_lookup_code => p_per_information9
507: )

Line 596: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then

592: /* Added for GSI Bug 5472781 */
593: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
594:
595: if g_type IS NOT NULL THEN
596: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then
597: --
598: -- Check that the religion exists in hr_lookups for the
599: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
600: -- the effective start date of the person is between start date

Line 603: if hr_api.not_exists_in_hr_lookups

599: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
600: -- the effective start date of the person is between start date
601: -- active and end date active in hr_lookups.
602: --
603: if hr_api.not_exists_in_hr_lookups
604: (p_effective_date => p_hire_date
605: ,p_lookup_type => 'AE_RELIGION'
606: ,p_lookup_code => p_per_information10
607: )

Line 616: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then

612: --
613: end if;
614: end if;
615:
616: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then
617: --
618: -- Check that the nationality exists in hr_lookups for the
619: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
620: -- the effective start date of the person is between start date

Line 623: if hr_api.not_exists_in_hr_lookups

619: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
620: -- the effective start date of the person is between start date
621: -- active and end date active in hr_lookups.
622: --
623: if hr_api.not_exists_in_hr_lookups
624: (p_effective_date => p_hire_date
625: ,p_lookup_type => 'AE_NATIONALITY'
626: ,p_lookup_code => p_per_information9
627: )

Line 714: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then

710: /* Added for GSI Bug 5472781 */
711: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
712:
713: if g_type IS NOT NULL THEN
714: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then
715: --
716: -- Check that the religion exists in hr_lookups for the
717: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
718: -- the effective start date of the person is between start date

Line 721: if hr_api.not_exists_in_hr_lookups

717: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
718: -- the effective start date of the person is between start date
719: -- active and end date active in hr_lookups.
720: --
721: if hr_api.not_exists_in_hr_lookups
722: (p_effective_date => p_start_date
723: ,p_lookup_type => 'AE_RELIGION'
724: ,p_lookup_code => p_per_information10
725: )

Line 734: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then

730: --
731: end if;
732: end if;
733:
734: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then
735: --
736: -- Check that the nationality exists in hr_lookups for the
737: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
738: -- the effective start date of the person is between start date

Line 741: if hr_api.not_exists_in_hr_lookups

737: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
738: -- the effective start date of the person is between start date
739: -- active and end date active in hr_lookups.
740: --
741: if hr_api.not_exists_in_hr_lookups
742: (p_effective_date => p_start_date
743: ,p_lookup_type => 'AE_NATIONALITY'
744: ,p_lookup_code => p_per_information9
745: )

Line 832: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then

828: /* Added for GSI Bug 5472781 */
829: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
830:
831: if g_type IS NOT NULL THEN
832: if p_per_information_category = 'AE' and (p_per_information10 is not null AND p_per_information10 <> hr_api.g_varchar2) then
833: --
834: -- Check that the religion exists in hr_lookups for the
835: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
836: -- the effective start date of the person is between start date

Line 839: if hr_api.not_exists_in_hr_lookups

835: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
836: -- the effective start date of the person is between start date
837: -- active and end date active in hr_lookups.
838: --
839: if hr_api.not_exists_in_hr_lookups
840: (p_effective_date => p_start_date
841: ,p_lookup_type => 'AE_RELIGION'
842: ,p_lookup_code => p_per_information10
843: )

Line 852: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then

848: --
849: end if;
850: end if;
851:
852: if p_per_information_category = 'AE' and (p_per_information9 is not null AND p_per_information9 <> hr_api.g_varchar2) then
853: --
854: -- Check that the nationality exists in hr_lookups for the
855: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
856: -- the effective start date of the person is between start date

Line 859: if hr_api.not_exists_in_hr_lookups

855: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
856: -- the effective start date of the person is between start date
857: -- active and end date active in hr_lookups.
858: --
859: if hr_api.not_exists_in_hr_lookups
860: (p_effective_date => p_start_date
861: ,p_lookup_type => 'AE_NATIONALITY'
862: ,p_lookup_code => p_per_information9
863: )

Line 903: IF p_ctr_information1 IS NOT NULL AND p_ctr_information1 <> hr_api.g_varchar2 THEN

899: --
900: -- Check that the employment status exists in hr_lookups for the
901: -- lookup type 'AE_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'
902: --
903: IF p_ctr_information1 IS NOT NULL AND p_ctr_information1 <> hr_api.g_varchar2 THEN
904: --
905: IF hr_api.not_exists_in_hr_lookups
906: (p_effective_date => p_effective_date
907: ,p_lookup_type => 'AE_EMPLOYMENT_STATUS'

Line 905: IF hr_api.not_exists_in_hr_lookups

901: -- lookup type 'AE_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'
902: --
903: IF p_ctr_information1 IS NOT NULL AND p_ctr_information1 <> hr_api.g_varchar2 THEN
904: --
905: IF hr_api.not_exists_in_hr_lookups
906: (p_effective_date => p_effective_date
907: ,p_lookup_type => 'AE_EMPLOYMENT_STATUS'
908: ,p_lookup_code => p_ctr_information1) THEN
909: --

Line 917: IF p_ctr_information2 IS NOT NULL AND p_ctr_information2 <> hr_api.g_varchar2 THEN

913: END IF;
914: --
915: END IF;
916: --
917: IF p_ctr_information2 IS NOT NULL AND p_ctr_information2 <> hr_api.g_varchar2 THEN
918: --
919: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
920: THEN
921: --

Line 975: IF (p_town_or_city IS NOT NULL AND p_town_or_city <> hr_api.g_varchar2) AND (p_address_line3 IS NOT NULL AND p_address_line3 <> hr_api.g_varchar2)THEN

971: /* Added for GSI Bug 5472781 */
972: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
973:
974: l_valid := NULL;
975: IF (p_town_or_city IS NOT NULL AND p_town_or_city <> hr_api.g_varchar2) AND (p_address_line3 IS NOT NULL AND p_address_line3 <> hr_api.g_varchar2)THEN
976: OPEN csr_validate_address
977: ('AE_CITY_VALIDATION',p_town_or_city,'EMIRATE CODE',p_address_line3);
978: FETCH csr_validate_address INTO l_valid;
979: CLOSE csr_validate_address;

Line 987: IF (p_region_1 IS NOT NULL AND p_region_1 <> hr_api.g_varchar2) THEN --AND p_town_or_city IS NOT NULL THEN

983: hr_utility.raise_error;
984: END IF;
985: END IF;
986: l_valid := NULL;
987: IF (p_region_1 IS NOT NULL AND p_region_1 <> hr_api.g_varchar2) THEN --AND p_town_or_city IS NOT NULL THEN
988: OPEN csr_validate_address
989: ('AE_AREA_VALIDATION',p_region_1,'CITY CODE',p_town_or_city);
990: FETCH csr_validate_address INTO l_valid;
991: CLOSE csr_validate_address;

Line 1170: IF (p_segment2 IS NOT NULL AND p_segment2 <> hr_api.g_varchar2) AND p_segment3 IS NULL THEN

1166:
1167: /* Added for GSI Bug 5472781 */
1168: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1169:
1170: IF (p_segment2 IS NOT NULL AND p_segment2 <> hr_api.g_varchar2) AND p_segment3 IS NULL THEN
1171: hr_utility.set_message(800, 'HR_377409_AE_SOC_SEC_REQ');
1172: hr_utility.raise_error;
1173: END IF;
1174:

Line 1175: IF p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2 THEN

1171: hr_utility.set_message(800, 'HR_377409_AE_SOC_SEC_REQ');
1172: hr_utility.raise_error;
1173: END IF;
1174:
1175: IF p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2 THEN
1176: DECLARE
1177: CURSOR csr_chk_qual IS
1178: SELECT qual.person_id
1179: FROM per_qualifications qual,

Line 1359: (p_employer_name IN varchar2 default hr_api.g_varchar2

1355: END UPDATE_PAYMENT_METHOD_VALIDATE;
1356:
1357: --Procedure for validating previous_employer
1358: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1359: (p_employer_name IN varchar2 default hr_api.g_varchar2
1360: ,p_effective_date IN date default hr_api.g_date
1361: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1362: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1363: ) IS

Line 1360: ,p_effective_date IN date default hr_api.g_date

1356:
1357: --Procedure for validating previous_employer
1358: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1359: (p_employer_name IN varchar2 default hr_api.g_varchar2
1360: ,p_effective_date IN date default hr_api.g_date
1361: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1362: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1363: ) IS
1364:

Line 1361: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2

1357: --Procedure for validating previous_employer
1358: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1359: (p_employer_name IN varchar2 default hr_api.g_varchar2
1360: ,p_effective_date IN date default hr_api.g_date
1361: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1362: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1363: ) IS
1364:
1365: v_field VARCHAR2(300);

Line 1362: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2

1358: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1359: (p_employer_name IN varchar2 default hr_api.g_varchar2
1360: ,p_effective_date IN date default hr_api.g_date
1361: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1362: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1363: ) IS
1364:
1365: v_field VARCHAR2(300);
1366:

Line 1386: IF (p_pem_information1 IS NOT NULL AND p_pem_information1 <> hr_api.g_varchar2) THEN

1382: fnd_message.set_token('NAME',v_field, translate => true );
1383: hr_utility.raise_error;
1384: END IF;
1385:
1386: IF (p_pem_information1 IS NOT NULL AND p_pem_information1 <> hr_api.g_varchar2) THEN
1387: IF hr_api.not_exists_in_hr_lookups
1388: (p_effective_date => p_effective_date
1389: ,p_lookup_type => 'LEAV_REAS'
1390: ,p_lookup_code => p_pem_information1

Line 1387: IF hr_api.not_exists_in_hr_lookups

1383: hr_utility.raise_error;
1384: END IF;
1385:
1386: IF (p_pem_information1 IS NOT NULL AND p_pem_information1 <> hr_api.g_varchar2) THEN
1387: IF hr_api.not_exists_in_hr_lookups
1388: (p_effective_date => p_effective_date
1389: ,p_lookup_type => 'LEAV_REAS'
1390: ,p_lookup_code => p_pem_information1
1391: )

Line 1448: IF (p_org_information1 IS NOT NULL AND p_org_information1 <> hr_api.g_varchar2) THEN

1444: fnd_message.set_token('NAME',v_field, translate => true );
1445: hr_utility.raise_error;
1446: END IF;
1447:
1448: IF (p_org_information1 IS NOT NULL AND p_org_information1 <> hr_api.g_varchar2) THEN
1449:
1450: l_length := LENGTH(p_org_information1);
1451:
1452: IF(l_length > 12) THEN

Line 1509: IF (p_org_information1 IS NOT NULL AND p_org_information1 <> hr_api.g_varchar2) THEN

1505: fnd_message.set_token('NAME',v_field, translate => true );
1506: hr_utility.raise_error;
1507: END IF;
1508:
1509: IF (p_org_information1 IS NOT NULL AND p_org_information1 <> hr_api.g_varchar2) THEN
1510:
1511: l_length := LENGTH(p_org_information1);
1512:
1513: IF(l_length > 12) THEN