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 199: IF p_per_information18 <> NVL(l_local_nationality,'*') AND (p_per_information9 IS NOT NULL AND p_per_information9 <> hr_api.g_varchar2) THEN

195: FETCH csr_get_loc_nat INTO rec_get_loc_nat;
196: l_local_nationality := rec_get_loc_nat.org_information1;
197: CLOSE csr_get_loc_nat;
198: --IF p_nationality <> NVL(l_local_nationality,'*') AND p_per_information9 IS NOT NULL THEN
199: IF p_per_information18 <> NVL(l_local_nationality,'*') AND (p_per_information9 IS NOT NULL AND p_per_information9 <> hr_api.g_varchar2) THEN
200: 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
201: hr_utility.set_message(800, 'HR_377410_AE_DAT_REA_INVALID');
202: hr_utility.raise_error;
203: END IF;

Line 200: 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

196: l_local_nationality := rec_get_loc_nat.org_information1;
197: CLOSE csr_get_loc_nat;
198: --IF p_nationality <> NVL(l_local_nationality,'*') AND p_per_information9 IS NOT NULL THEN
199: IF p_per_information18 <> NVL(l_local_nationality,'*') AND (p_per_information9 IS NOT NULL AND p_per_information9 <> hr_api.g_varchar2) THEN
200: 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
201: hr_utility.set_message(800, 'HR_377410_AE_DAT_REA_INVALID');
202: hr_utility.raise_error;
203: END IF;
204: END IF;

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

244: OPEN csr_fetch_bg_id;
245: FETCH csr_fetch_bg_id INTO l_bg_id;
246: CLOSE csr_fetch_bg_id;
247:
248: IF p_marital_status IS NOT NULL AND p_marital_status <> hr_api.g_varchar2 THEN
249: OPEN csr_val_mar_status(l_bg_id);
250: FETCH csr_val_mar_status INTO l_valid;
251: CLOSE csr_val_mar_status;
252: IF l_valid IS NULL THEN

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

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

Line 358: if hr_api.not_exists_in_hr_lookups

354: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
355: -- the effective start date of the person is between start date
356: -- active and end date active in hr_lookups.
357: --
358: if hr_api.not_exists_in_hr_lookups
359: (p_effective_date => p_effective_date
360: ,p_lookup_type => 'AE_RELIGION'
361: ,p_lookup_code => p_per_information10
362: )

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

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

Line 378: if hr_api.not_exists_in_hr_lookups

374: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
375: -- the effective start date of the person is between start date
376: -- active and end date active in hr_lookups.
377: --
378: if hr_api.not_exists_in_hr_lookups
379: (p_effective_date => p_effective_date
380: ,p_lookup_type => 'AE_NATIONALITY'
381: ,p_lookup_code => p_per_information9
382: )

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

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

Line 477: if hr_api.not_exists_in_hr_lookups

473: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
474: -- the effective start date of the person is between start date
475: -- active and end date active in hr_lookups.
476: --
477: if hr_api.not_exists_in_hr_lookups
478: (p_effective_date => p_date_received
479: ,p_lookup_type => 'AE_RELIGION'
480: ,p_lookup_code => p_per_information10
481: )

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

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

Line 497: if hr_api.not_exists_in_hr_lookups

493: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
494: -- the effective start date of the person is between start date
495: -- active and end date active in hr_lookups.
496: --
497: if hr_api.not_exists_in_hr_lookups
498: (p_effective_date => p_date_received
499: ,p_lookup_type => 'AE_NATIONALITY'
500: ,p_lookup_code => p_per_information9
501: )

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

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

Line 597: if hr_api.not_exists_in_hr_lookups

593: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
594: -- the effective start date of the person is between start date
595: -- active and end date active in hr_lookups.
596: --
597: if hr_api.not_exists_in_hr_lookups
598: (p_effective_date => p_hire_date
599: ,p_lookup_type => 'AE_RELIGION'
600: ,p_lookup_code => p_per_information10
601: )

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

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

Line 617: if hr_api.not_exists_in_hr_lookups

613: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
614: -- the effective start date of the person is between start date
615: -- active and end date active in hr_lookups.
616: --
617: if hr_api.not_exists_in_hr_lookups
618: (p_effective_date => p_hire_date
619: ,p_lookup_type => 'AE_NATIONALITY'
620: ,p_lookup_code => p_per_information9
621: )

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

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

Line 715: if hr_api.not_exists_in_hr_lookups

711: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
712: -- the effective start date of the person is between start date
713: -- active and end date active in hr_lookups.
714: --
715: if hr_api.not_exists_in_hr_lookups
716: (p_effective_date => p_start_date
717: ,p_lookup_type => 'AE_RELIGION'
718: ,p_lookup_code => p_per_information10
719: )

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

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

Line 735: if hr_api.not_exists_in_hr_lookups

731: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
732: -- the effective start date of the person is between start date
733: -- active and end date active in hr_lookups.
734: --
735: if hr_api.not_exists_in_hr_lookups
736: (p_effective_date => p_start_date
737: ,p_lookup_type => 'AE_NATIONALITY'
738: ,p_lookup_code => p_per_information9
739: )

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

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

Line 833: if hr_api.not_exists_in_hr_lookups

829: -- lookup type 'AE_RELIGION' with an enabled flag set to 'Y' and that
830: -- the effective start date of the person is between start date
831: -- active and end date active in hr_lookups.
832: --
833: if hr_api.not_exists_in_hr_lookups
834: (p_effective_date => p_start_date
835: ,p_lookup_type => 'AE_RELIGION'
836: ,p_lookup_code => p_per_information10
837: )

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

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

Line 853: if hr_api.not_exists_in_hr_lookups

849: -- lookup type 'AE_NATIONALITY' with an enabled flag set to 'Y' and that
850: -- the effective start date of the person is between start date
851: -- active and end date active in hr_lookups.
852: --
853: if hr_api.not_exists_in_hr_lookups
854: (p_effective_date => p_start_date
855: ,p_lookup_type => 'AE_NATIONALITY'
856: ,p_lookup_code => p_per_information9
857: )

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

893: --
894: -- Check that the employment status exists in hr_lookups for the
895: -- lookup type 'AE_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'
896: --
897: IF p_ctr_information1 IS NOT NULL AND p_ctr_information1 <> hr_api.g_varchar2 THEN
898: --
899: IF hr_api.not_exists_in_hr_lookups
900: (p_effective_date => p_effective_date
901: ,p_lookup_type => 'AE_EMPLOYMENT_STATUS'

Line 899: IF hr_api.not_exists_in_hr_lookups

895: -- lookup type 'AE_EMPLOYMENT_STATUS' with an enabled flag set to 'Y'
896: --
897: IF p_ctr_information1 IS NOT NULL AND p_ctr_information1 <> hr_api.g_varchar2 THEN
898: --
899: IF hr_api.not_exists_in_hr_lookups
900: (p_effective_date => p_effective_date
901: ,p_lookup_type => 'AE_EMPLOYMENT_STATUS'
902: ,p_lookup_code => p_ctr_information1) THEN
903: --

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

907: END IF;
908: --
909: END IF;
910: --
911: IF p_ctr_information2 IS NOT NULL AND p_ctr_information2 <> hr_api.g_varchar2 THEN
912: --
913: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
914: THEN
915: --

Line 966: 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

962: /* Added for GSI Bug 5472781 */
963: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
964:
965: l_valid := NULL;
966: 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
967: OPEN csr_validate_address
968: ('AE_CITY_VALIDATION',p_town_or_city,'EMIRATE CODE',p_address_line3);
969: FETCH csr_validate_address INTO l_valid;
970: CLOSE csr_validate_address;

Line 978: 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

974: hr_utility.raise_error;
975: END IF;
976: END IF;
977: l_valid := NULL;
978: 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
979: OPEN csr_validate_address
980: ('AE_AREA_VALIDATION',p_region_1,'CITY CODE',p_town_or_city);
981: FETCH csr_validate_address INTO l_valid;
982: CLOSE csr_validate_address;

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

1104:
1105: /* Added for GSI Bug 5472781 */
1106: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1107:
1108: IF (p_segment2 IS NOT NULL AND p_segment2 <> hr_api.g_varchar2) AND p_segment3 IS NULL THEN
1109: hr_utility.set_message(800, 'HR_377409_AE_SOC_SEC_REQ');
1110: hr_utility.raise_error;
1111: END IF;
1112:

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

1109: hr_utility.set_message(800, 'HR_377409_AE_SOC_SEC_REQ');
1110: hr_utility.raise_error;
1111: END IF;
1112:
1113: IF p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2 THEN
1114: DECLARE
1115: CURSOR csr_chk_qual IS
1116: SELECT qual.person_id
1117: FROM per_qualifications qual,

Line 1297: (p_employer_name IN varchar2 default hr_api.g_varchar2

1293: END UPDATE_PAYMENT_METHOD_VALIDATE;
1294:
1295: --Procedure for validating previous_employer
1296: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1297: (p_employer_name IN varchar2 default hr_api.g_varchar2
1298: ,p_effective_date IN date default hr_api.g_date
1299: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1300: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1301: ) IS

Line 1298: ,p_effective_date IN date default hr_api.g_date

1294:
1295: --Procedure for validating previous_employer
1296: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1297: (p_employer_name IN varchar2 default hr_api.g_varchar2
1298: ,p_effective_date IN date default hr_api.g_date
1299: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1300: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1301: ) IS
1302:

Line 1299: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2

1295: --Procedure for validating previous_employer
1296: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1297: (p_employer_name IN varchar2 default hr_api.g_varchar2
1298: ,p_effective_date IN date default hr_api.g_date
1299: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1300: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1301: ) IS
1302:
1303: v_field VARCHAR2(300);

Line 1300: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2

1296: PROCEDURE PREVIOUS_EMPLOYER_VALIDATE
1297: (p_employer_name IN varchar2 default hr_api.g_varchar2
1298: ,p_effective_date IN date default hr_api.g_date
1299: ,p_pem_information_category IN varchar2 default hr_api.g_varchar2
1300: ,p_pem_information1 IN varchar2 default hr_api.g_varchar2
1301: ) IS
1302:
1303: v_field VARCHAR2(300);
1304:

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

1320: fnd_message.set_token('NAME',v_field, translate => true );
1321: hr_utility.raise_error;
1322: END IF;
1323:
1324: IF (p_pem_information1 IS NOT NULL AND p_pem_information1 <> hr_api.g_varchar2) THEN
1325: IF hr_api.not_exists_in_hr_lookups
1326: (p_effective_date => p_effective_date
1327: ,p_lookup_type => 'LEAV_REAS'
1328: ,p_lookup_code => p_pem_information1

Line 1325: IF hr_api.not_exists_in_hr_lookups

1321: hr_utility.raise_error;
1322: END IF;
1323:
1324: IF (p_pem_information1 IS NOT NULL AND p_pem_information1 <> hr_api.g_varchar2) THEN
1325: IF hr_api.not_exists_in_hr_lookups
1326: (p_effective_date => p_effective_date
1327: ,p_lookup_type => 'LEAV_REAS'
1328: ,p_lookup_code => p_pem_information1
1329: )

Line 1386: IF (p_org_information1 IS NOT NULL AND p_org_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_org_information1 IS NOT NULL AND p_org_information1 <> hr_api.g_varchar2) THEN
1387:
1388: l_length := LENGTH(p_org_information1);
1389:
1390: IF(l_length > 12) THEN

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

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