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

Line 52: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

48: AND ppt.person_type_Id = p_person_type_id;
49: BEGIN
50:
51: /* Added for GSI Bug 5472781 */
52: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
53: v_field := NULL;
54: v_len_field := NULL;
55: g_type := NULL;
56: g_per_type := NULL;

Line 133: hr_utility.raise_error;

129: END IF;
130: IF v_len_field IS NOT NULL THEN
131: fnd_message.set_name('PER', 'HR_377418_AE_INVALID_LENGTH');
132: fnd_message.set_token('FIELD',v_len_field, translate => true );
133: hr_utility.raise_error;
134: END IF;
135:
136: --Validate not null fields
137: IF g_per_type = 'Y' THEN

Line 179: hr_utility.raise_error;

175: --END IF;
176: IF v_field IS NOT NULL THEN
177: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
178: fnd_message.set_token('NAME',v_field, translate => true );
179: hr_utility.raise_error;
180: END IF;
181:
182: DECLARE
183: CURSOR csr_get_loc_nat IS

Line 201: hr_utility.set_message(800, 'HR_377410_AE_DAT_REA_INVALID');

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;
205: END;

Line 202: hr_utility.raise_error;

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;
205: END;
206:

Line 253: hr_utility.set_message(800, 'HR_377405_AE_INVALID_MAR');

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
253: hr_utility.set_message(800, 'HR_377405_AE_INVALID_MAR');
254: hr_utility.raise_error;
255: END IF;
256: END IF;
257: END;

Line 254: hr_utility.raise_error;

250: FETCH csr_val_mar_status INTO l_valid;
251: CLOSE csr_val_mar_status;
252: IF l_valid IS NULL THEN
253: hr_utility.set_message(800, 'HR_377405_AE_INVALID_MAR');
254: hr_utility.raise_error;
255: END IF;
256: END IF;
257: END;
258:

Line 349: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

345: ,p_per_information19 => p_per_information19
346: ,p_per_information20 => p_per_information20);
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

Line 365: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');

361: ,p_lookup_code => p_per_information10
362: )
363: then
364: --
365: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
366: hr_utility.raise_error;
367: --
368: end if;
369: end if;

Line 366: hr_utility.raise_error;

362: )
363: then
364: --
365: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
366: hr_utility.raise_error;
367: --
368: end if;
369: end if;
370:

Line 385: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');

381: ,p_lookup_code => p_per_information9
382: )
383: then
384: --
385: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
386: hr_utility.raise_error;
387: --
388: end if;
389: end if;

Line 386: hr_utility.raise_error;

382: )
383: then
384: --
385: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
386: hr_utility.raise_error;
387: --
388: end if;
389: end if;
390:

Line 467: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

463: ,p_per_information19 => p_per_information19
464: ,p_per_information20 => p_per_information20);
465:
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: --

Line 484: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');

480: ,p_lookup_code => p_per_information10
481: )
482: then
483: --
484: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
485: hr_utility.raise_error;
486: --
487: end if;
488: end if;

Line 485: hr_utility.raise_error;

481: )
482: then
483: --
484: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
485: hr_utility.raise_error;
486: --
487: end if;
488: end if;
489:

Line 504: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');

500: ,p_lookup_code => p_per_information9
501: )
502: then
503: --
504: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
505: hr_utility.raise_error;
506: --
507: end if;
508: end if;

Line 505: hr_utility.raise_error;

501: )
502: then
503: --
504: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
505: hr_utility.raise_error;
506: --
507: end if;
508: end if;
509: end if;

Line 587: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

583: ,p_per_information19 => p_per_information19
584: ,p_per_information20 => p_per_information20);
585:
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: --

Line 604: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');

600: ,p_lookup_code => p_per_information10
601: )
602: then
603: --
604: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
605: hr_utility.raise_error;
606: --
607: end if;
608: end if;

Line 605: hr_utility.raise_error;

601: )
602: then
603: --
604: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
605: hr_utility.raise_error;
606: --
607: end if;
608: end if;
609:

Line 624: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');

620: ,p_lookup_code => p_per_information9
621: )
622: then
623: --
624: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
625: hr_utility.raise_error;
626: --
627: end if;
628: end if;

Line 625: hr_utility.raise_error;

621: )
622: then
623: --
624: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
625: hr_utility.raise_error;
626: --
627: end if;
628: end if;
629: end if;

Line 705: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

701: ,p_per_information19 => p_per_information19
702: ,p_per_information20 => p_per_information20);
703:
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: --

Line 722: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');

718: ,p_lookup_code => p_per_information10
719: )
720: then
721: --
722: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
723: hr_utility.raise_error;
724: --
725: end if;
726: end if;

Line 723: hr_utility.raise_error;

719: )
720: then
721: --
722: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
723: hr_utility.raise_error;
724: --
725: end if;
726: end if;
727:

Line 742: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');

738: ,p_lookup_code => p_per_information9
739: )
740: then
741: --
742: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
743: hr_utility.raise_error;
744: --
745: end if;
746: end if;

Line 743: hr_utility.raise_error;

739: )
740: then
741: --
742: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
743: hr_utility.raise_error;
744: --
745: end if;
746: end if;
747: end if;

Line 823: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

819: ,p_per_information19 => p_per_information19
820: ,p_per_information20 => p_per_information20);
821:
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: --

Line 840: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');

836: ,p_lookup_code => p_per_information10
837: )
838: then
839: --
840: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
841: hr_utility.raise_error;
842: --
843: end if;
844: end if;

Line 841: hr_utility.raise_error;

837: )
838: then
839: --
840: hr_utility.set_message(800, 'HR_377401_AE_INVALID_RELIGION');
841: hr_utility.raise_error;
842: --
843: end if;
844: end if;
845:

Line 860: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');

856: ,p_lookup_code => p_per_information9
857: )
858: then
859: --
860: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
861: hr_utility.raise_error;
862: --
863: end if;
864: end if;

Line 861: hr_utility.raise_error;

857: )
858: then
859: --
860: hr_utility.set_message(800, 'HR_377402_AE_INVALID_PREV_NAT');
861: hr_utility.raise_error;
862: --
863: end if;
864: end if;
865: end if;

Line 888: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

884: --
885: BEGIN
886:
887: /* Added for GSI Bug 5472781 */
888: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
889: --
890: l_field := NULL;
891: --
892: IF p_ctr_information_category = '' THEN

Line 904: hr_utility.set_message(800, 'HR_377414_AE_INVALID_EMP_STAT');

900: (p_effective_date => p_effective_date
901: ,p_lookup_type => 'AE_EMPLOYMENT_STATUS'
902: ,p_lookup_code => p_ctr_information1) THEN
903: --
904: hr_utility.set_message(800, 'HR_377414_AE_INVALID_EMP_STAT');
905: hr_utility.raise_error;
906: --
907: END IF;
908: --

Line 905: hr_utility.raise_error;

901: ,p_lookup_type => 'AE_EMPLOYMENT_STATUS'
902: ,p_lookup_code => p_ctr_information1) THEN
903: --
904: hr_utility.set_message(800, 'HR_377414_AE_INVALID_EMP_STAT');
905: hr_utility.raise_error;
906: --
907: END IF;
908: --
909: END IF;

Line 916: hr_utility.set_message(800, 'HR_377415_AE_EXPIRY_INVALID');

912: --
913: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
914: THEN
915: --
916: hr_utility.set_message(800, 'HR_377415_AE_EXPIRY_INVALID');
917: hr_utility.raise_error;
918: --
919: END IF;
920: --

Line 917: hr_utility.raise_error;

913: IF (fnd_date.canonical_to_date(p_ctr_information2) < p_effective_date)
914: THEN
915: --
916: hr_utility.set_message(800, 'HR_377415_AE_EXPIRY_INVALID');
917: hr_utility.raise_error;
918: --
919: END IF;
920: --
921: END IF;

Line 963: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

959: l_valid VARCHAR2(1);
960: BEGIN
961:
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

Line 973: hr_utility.set_message(800, 'HR_377403_AE_INVALID_CITY');

969: FETCH csr_validate_address INTO l_valid;
970: CLOSE csr_validate_address;
971:
972: IF l_valid IS NULL THEN
973: hr_utility.set_message(800, 'HR_377403_AE_INVALID_CITY');
974: hr_utility.raise_error;
975: END IF;
976: END IF;
977: l_valid := NULL;

Line 974: hr_utility.raise_error;

970: CLOSE csr_validate_address;
971:
972: IF l_valid IS NULL THEN
973: hr_utility.set_message(800, 'HR_377403_AE_INVALID_CITY');
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

Line 984: hr_utility.set_message(800, 'HR_377404_AE_INVALID_AREA');

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;
983: IF l_valid IS NULL THEN
984: hr_utility.set_message(800, 'HR_377404_AE_INVALID_AREA');
985: hr_utility.raise_error;
986: END IF;
987: END IF;
988: END IF;

Line 985: hr_utility.raise_error;

981: FETCH csr_validate_address INTO l_valid;
982: CLOSE csr_validate_address;
983: IF l_valid IS NULL THEN
984: hr_utility.set_message(800, 'HR_377404_AE_INVALID_AREA');
985: hr_utility.raise_error;
986: END IF;
987: END IF;
988: END IF;
989: END validate_address;

Line 1001: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

997: ,p_region_1 IN VARCHAR2) IS
998:
999: BEGIN
1000: /* Added for GSI Bug 5472781 */
1001: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1002:
1003: IF p_style = 'AE' THEN
1004: validate_address
1005: (p_effective_date => p_effective_date

Line 1031: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1027: --
1028: BEGIN
1029:
1030: /* Added for GSI Bug 5472781 */
1031: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1032: --
1033: OPEN csr_get_style(p_address_id);
1034: FETCH csr_get_style INTO l_style,l_person_id;
1035: CLOSE csr_get_style;

Line 1059: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1055:
1056: BEGIN
1057:
1058: /* Added for GSI Bug 5472781 */
1059: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1060: IF p_style = 'AE' THEN
1061: validate_address
1062: (p_effective_date => p_effective_date
1063: ,p_address_line3 => p_address_line_3

Line 1080: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1076: --
1077: BEGIN
1078:
1079: /* Added for GSI Bug 5472781 */
1080: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1081: --
1082: IF p_style = 'AE' THEN
1083: validate_address
1084: (p_effective_date => p_effective_date

Line 1106: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1102:
1103: BEGIN
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;

Line 1109: hr_utility.set_message(800, 'HR_377409_AE_SOC_SEC_REQ');

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:
1113: IF p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2 THEN

Line 1110: hr_utility.raise_error;

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:
1113: IF p_segment5 IS NOT NULL AND p_segment5 <> hr_api.g_varchar2 THEN
1114: DECLARE

Line 1131: hr_utility.set_message(800, 'HR_377408_AE_INVALID_QUAL');

1127: FETCH csr_chk_qual INTO rec_chk_qual;
1128: l_exist := rec_chk_qual.person_id;
1129: CLOSE csr_chk_qual;
1130: IF l_exist IS NULL THEN
1131: hr_utility.set_message(800, 'HR_377408_AE_INVALID_QUAL');
1132: hr_utility.raise_error;
1133: END IF;
1134: END;
1135: END IF;

Line 1132: hr_utility.raise_error;

1128: l_exist := rec_chk_qual.person_id;
1129: CLOSE csr_chk_qual;
1130: IF l_exist IS NULL THEN
1131: hr_utility.set_message(800, 'HR_377408_AE_INVALID_QUAL');
1132: hr_utility.raise_error;
1133: END IF;
1134: END;
1135: END IF;
1136: END IF;

Line 1151: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1147: l_count NUMBER;
1148: BEGIN
1149:
1150: /* Added for GSI Bug 5472781 */
1151: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1152:
1153: l_count := 0;
1154: IF p_dis_information_category = 'AE' and NVL(p_dis_information1,'N') = 'Y' THEN
1155: /*Check that Relevant to Social Security is not set to Yes for more than 1 disability in the same period*/

Line 1165: hr_utility.raise_error;

1161: AND dis_information_category = 'AE'
1162: AND dis_information1 = 'Y';
1163: IF l_count > 0 THEN
1164: fnd_message.set_name('PER', 'HR_377411_AE_INVALID_DIS_SSN');
1165: hr_utility.raise_error;
1166: END IF;
1167: END IF;
1168: END IF;
1169: END CREATE_DISABILITY_VALIDATE;

Line 1184: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1180: l_count NUMBER;
1181: BEGIN
1182:
1183: /* Added for GSI Bug 5472781 */
1184: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1185:
1186: l_count := 0;
1187: SELECT person_id
1188: INTO l_person_id

Line 1204: hr_utility.raise_error;

1200: AND dis_information_category = 'AE'
1201: AND dis_information1 = 'Y';
1202: IF l_count > 0 THEN
1203: fnd_message.set_name('PER', 'HR_377411_AE_INVALID_DIS_SSN');
1204: hr_utility.raise_error;
1205: END IF;
1206: END IF;
1207: END IF;
1208: END UPDATE_DISABILITY_VALIDATE;

Line 1223: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1219: l_count number;
1220:
1221: BEGIN
1222: /* Added for GSI Bug 5472781 */
1223: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1224:
1225: l_count := 0;
1226:
1227: IF NVL(P_PPM_INFORMATION1,'N') = 'Y' THEN

Line 1242: hr_utility.raise_error;

1238: AND PPM_INFORMATION1 = 'Y';
1239:
1240: IF l_count >= 1 THEN
1241: fnd_message.set_name('PER', 'HR_377444_AE_INVALID_EOS_FLAG');
1242: hr_utility.raise_error;
1243: END IF;
1244:
1245: END IF;
1246:

Line 1261: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1257: l_assignment_id number;
1258:
1259: BEGIN
1260: /* Added for GSI Bug 5472781 */
1261: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1262:
1263: l_count := 0;
1264:
1265: SELECT ASSIGNMENT_ID

Line 1285: hr_utility.raise_error;

1281: AND PPM_INFORMATION1 = 'Y';
1282:
1283: IF l_count > 0 THEN
1284: fnd_message.set_name('PER', 'HR_377444_AE_INVALID_EOS_FLAG');
1285: hr_utility.raise_error;
1286: END IF;
1287:
1288: END IF;
1289:

Line 1308: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1304:
1305: BEGIN
1306:
1307: /* Added for GSI Bug 5472781 */
1308: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1309:
1310: v_field := NULL;
1311: IF p_pem_information_category = 'AE' then
1312: IF p_employer_name is null then

Line 1321: hr_utility.raise_error;

1317: END IF;
1318:
1319: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
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

Line 1331: hr_utility.set_message(800, 'HR_377417_AE_INVALID_LEAV_REAS');

1327: ,p_lookup_type => 'LEAV_REAS'
1328: ,p_lookup_code => p_pem_information1
1329: )
1330: THEN
1331: hr_utility.set_message(800, 'HR_377417_AE_INVALID_LEAV_REAS');
1332: hr_utility.raise_error;
1333: END IF;
1334: END IF;
1335: END IF;

Line 1332: hr_utility.raise_error;

1328: ,p_lookup_code => p_pem_information1
1329: )
1330: THEN
1331: hr_utility.set_message(800, 'HR_377417_AE_INVALID_LEAV_REAS');
1332: hr_utility.raise_error;
1333: END IF;
1334: END IF;
1335: END IF;
1336: END IF;

Line 1367: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1363:
1364: BEGIN
1365:
1366: /* Added for GSI Bug 5472781 */
1367: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1368:
1369: v_field := NULL;
1370: l_length := 0;
1371:

Line 1383: hr_utility.raise_error;

1379: END IF;
1380:
1381: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
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:

Line 1392: hr_utility.raise_error;

1388: l_length := LENGTH(p_org_information1);
1389:
1390: IF(l_length > 12) THEN
1391: fnd_message.set_name('PER', 'HR_377407_AE_INVALID_SOC_SEC');
1392: hr_utility.raise_error;
1393: END IF;
1394: END IF;
1395:
1396: END IF;

Line 1427: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN

1423:
1424: BEGIN
1425:
1426: /* Added for GSI Bug 5472781 */
1427: IF hr_utility.chk_product_install('Oracle Human Resources', 'AE') THEN
1428:
1429: l_length := 0;
1430: l_var1 := 0;
1431: v_field := NULL;

Line 1444: hr_utility.raise_error;

1440: END IF;
1441:
1442: fnd_message.set_name('PER', 'PQH_FR_MANDATORY_MSG');
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:

Line 1453: hr_utility.raise_error;

1449: l_length := LENGTH(p_org_information1);
1450:
1451: IF(l_length > 12) THEN
1452: fnd_message.set_name('PER', 'HR_377407_AE_INVALID_SOC_SEC');
1453: hr_utility.raise_error;
1454: END IF;
1455: END IF;
1456:
1457: END IF;