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

Line 53: hr_utility.raise_error;

49: /*Bug fix- 4570879 added an additional check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN')*/
50: IF l_field IS NOT NULL AND fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN') THEN
51: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
52: fnd_message.set_token('NAME',l_field, translate => true );
53: hr_utility.raise_error;
54: END IF;
55:
56: END;
57:

Line 68: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

64: BEGIN
65: --
66: -- Added for GSI Bug 5472781
67: --
68: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
69: --
70: validate
71: (p_person_type_id => p_person_type_id
72: ,p_first_name => p_first_name

Line 90: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

86: BEGIN
87: --
88: -- Added for GSI Bug 5472781
89: --
90: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
91: --
92: per_per_bus.chk_person_type
93: (p_person_type_id => l_person_type_id
94: ,p_business_group_id => p_business_group_id

Line 117: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

113: BEGIN
114: --
115: -- Added for GSI Bug 5472781
116: --
117: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
118: --
119: per_per_bus.chk_person_type
120: (p_person_type_id => l_person_type_id
121: ,p_business_group_id => p_business_group_id

Line 144: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

140: BEGIN
141: --
142: -- Added for GSI Bug 5472781
143: --
144: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
145: --
146: per_per_bus.chk_person_type
147: (p_person_type_id => l_person_type_id
148: ,p_business_group_id => p_business_group_id

Line 329: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

325: BEGIN
326: --
327: -- Added for GSI Bug 5472781
328: --
329: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
330: --
331: /* Performance Bug fix 4892110 - Start */
332: begin
333: SELECT effective_date INTO s_effective_date FROM fnd_sessions

Line 452: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');

448: --
449: IF p_org_info_type_code = 'NO_EOY_REPORTING_RULE_OVERRIDE' THEN
450: --
451: IF to_number(p_org_information2) < to_number(p_org_information1) THEN
452: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
453: hr_utility.raise_error;
454: END IF;
455: --
456: OPEN csr_repoting_span;

Line 453: hr_utility.raise_error;

449: IF p_org_info_type_code = 'NO_EOY_REPORTING_RULE_OVERRIDE' THEN
450: --
451: IF to_number(p_org_information2) < to_number(p_org_information1) THEN
452: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
453: hr_utility.raise_error;
454: END IF;
455: --
456: OPEN csr_repoting_span;
457: FETCH csr_repoting_span INTO l_overlap_status;

Line 801: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

797: BEGIN
798: --
799: -- Added for GSI Bug 5472781
800: --
801: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
802: --
803: /* Performance Bug fix 4892110 - Start */
804: begin
805: SELECT effective_date INTO s_effective_date FROM fnd_sessions

Line 935: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');

931: --
932: IF p_org_info_type_code = 'NO_EOY_REPORTING_RULE_OVERRIDE' THEN
933: --
934: IF to_number(p_org_information2) < to_number(p_org_information1) THEN
935: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
936: hr_utility.raise_error;
937: END IF;
938: --
939: OPEN csr_repoting_span(l_organization_id);

Line 936: hr_utility.raise_error;

932: IF p_org_info_type_code = 'NO_EOY_REPORTING_RULE_OVERRIDE' THEN
933: --
934: IF to_number(p_org_information2) < to_number(p_org_information1) THEN
935: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
936: hr_utility.raise_error;
937: END IF;
938: --
939: OPEN csr_repoting_span(l_organization_id);
940: FETCH csr_repoting_span INTO l_overlap_status;

Line 1115: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1111: BEGIN
1112: --
1113: -- Added for GSI Bug 5472781
1114: --
1115: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1116: --
1117:
1118: select information1 into l_nus2000_code
1119: from per_qualification_types

Line 1125: hr_utility.raise_error;

1121:
1122:
1123: if p_qua_information1 <> l_nus2000_code then
1124: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1125: hr_utility.raise_error;
1126: end if;
1127:
1128:
1129:

Line 1140: hr_utility.raise_error;

1136: and pq.qua_information_category='NO'
1137: and pq.qua_information2='Y';
1138: IF l_count > 0 then
1139: fnd_message.set_name('PER', 'HR_376812_NO_HIGHEST_LEVEL');
1140: hr_utility.raise_error;
1141: END IF;
1142: END IF ;
1143: END IF;
1144: END qual_insert_validate;

Line 1177: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1173: BEGIN
1174: --
1175: -- Added for GSI Bug 5472781
1176: --
1177: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1178: --
1179: OPEN c_information1;
1180: FETCH c_information1 INTO l_nus2000_code ;
1181: CLOSE c_information1;

Line 1185: hr_utility.raise_error;

1181: CLOSE c_information1;
1182:
1183: if p_qua_information1 <> l_nus2000_code then
1184: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1185: hr_utility.raise_error;
1186: end if;
1187:
1188:
1189:

Line 1207: hr_utility.raise_error;

1203: and pq.qua_information2='Y';
1204:
1205: IF l_count > 0 then
1206: fnd_message.set_name('PER', 'HR_376812_NO_HIGHEST_LEVEL');
1207: hr_utility.raise_error;
1208: END IF;
1209:
1210: END IF;
1211: END IF;

Line 1240: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1236: BEGIN
1237: --
1238: -- Added for GSI Bug 5472781
1239: --
1240: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1241: --
1242: open getbgid;
1243: fetch getbgid into l_business_group_id;
1244: close getbgid;

Line 1277: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1273: BEGIN
1274: --
1275: -- Added for GSI Bug 5472781
1276: --
1277: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1278: --
1279: IF p_status = 'A-ACTIVE' THEN
1280: IF (p_ctr_information1 IS NOT NULL AND p_ctr_information_category ='NO') THEN
1281:

Line 1287: hr_utility.raise_error;

1283: --
1284: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1285: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1286: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1287: hr_utility.raise_error;
1288: --
1289: END IF;
1290: END IF;
1291: END IF;

Line 1309: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1305: BEGIN
1306: --
1307: -- Added for GSI Bug 5472781
1308: --
1309: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1310: --
1311: IF p_status = 'A-ACTIVE' THEN
1312: IF (p_ctr_information1 IS NOT NULL AND p_ctr_information_category ='NO') THEN
1313:

Line 1321: hr_utility.raise_error;

1317: --
1318: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1319: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1320: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1321: hr_utility.raise_error;
1322: --
1323: END IF;
1324: END IF;
1325: END IF;

Line 1346: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1342: BEGIN
1343: --
1344: -- Added for GSI Bug 5472781
1345: --
1346: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1347: --
1348: IF (p_inc_information1 IS NOT NULL AND p_inc_information_category ='NO' )THEN
1349: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1350: THEN

Line 1355: hr_utility.raise_error;

1351: --
1352: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1353: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1354: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1355: hr_utility.raise_error;
1356: --
1357: END IF;
1358: END IF;
1359:

Line 1367: hr_utility.raise_error;

1363: --
1364: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1365: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1366: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1367: hr_utility.raise_error;
1368: --
1369: END IF;
1370: END IF;
1371: END IF;

Line 1403: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1399: BEGIN
1400: --
1401: -- Added for GSI Bug 5472781
1402: --
1403: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1404: --
1405: open get_person_details(p_person_id);
1406: fetch get_person_details into l_dob,l_start_date;
1407: close get_person_details;

Line 1417: hr_utility.raise_error;

1413: IF(l_age > p_scl_segment14 ) THEN
1414: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1415: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1416: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1417: hr_utility.raise_error;
1418:
1419: END IF;
1420: END IF;
1421:

Line 1428: hr_utility.raise_error;

1424: IF( p_scl_segment12 1425: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1426: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1427: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1428: hr_utility.raise_error;
1429: END IF;
1430: END IF;
1431:
1432: --GSI Bug 4584922

Line 1438: hr_utility.raise_error;

1434: IF( p_scl_segment13 1435: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1436: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1437: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1438: hr_utility.raise_error;
1439: END IF;
1440: END IF;
1441: END IF;
1442: END create_asg_validate;

Line 1471: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN

1467: BEGIN
1468: --
1469: -- Added for GSI Bug 5472781
1470: --
1471: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
1472: --
1473: open get_person_details(p_assignment_id);
1474: fetch get_person_details into l_dob,l_start_date;
1475: close get_person_details;

Line 1485: hr_utility.raise_error;

1481: IF(l_age > p_segment14 ) THEN
1482: fnd_message.set_name('PER','HR_376821_NO_AGE_LESS');
1483: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));
1484: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));
1485: hr_utility.raise_error;
1486:
1487: END IF;
1488: END IF;
1489:

Line 1496: hr_utility.raise_error;

1492: IF( p_segment12 1493: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1494: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));
1495: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1496: hr_utility.raise_error;
1497: END IF;
1498: END IF;
1499:
1500: --GSI Bug 4584922

Line 1506: hr_utility.raise_error;

1502: IF( p_segment13 1503: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1504: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1505: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1506: hr_utility.raise_error;
1507: END IF;
1508: END IF;
1509: END IF;
1510: END update_asg_validate;

Line 1606: hr_utility.set_message(800,'PAY_376896_NO_YEAR_RESTRICT');

1602: --
1603: IF p_eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING' THEN
1604: -- Validation to ensure Year of Reporting(EOY) is different then what we already have in Extra Element Info DDF
1605: IF p_eei_information2 IS NOT NULL AND to_number(p_eei_information2) < to_number(p_eei_information1) THEN
1606: hr_utility.set_message(800,'PAY_376896_NO_YEAR_RESTRICT');
1607: hr_utility.raise_error;
1608: END IF;
1609: --
1610: OPEN csr_chk_element_eit_year;

Line 1607: hr_utility.raise_error;

1603: IF p_eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING' THEN
1604: -- Validation to ensure Year of Reporting(EOY) is different then what we already have in Extra Element Info DDF
1605: IF p_eei_information2 IS NOT NULL AND to_number(p_eei_information2) < to_number(p_eei_information1) THEN
1606: hr_utility.set_message(800,'PAY_376896_NO_YEAR_RESTRICT');
1607: hr_utility.raise_error;
1608: END IF;
1609: --
1610: OPEN csr_chk_element_eit_year;
1611: FETCH csr_chk_element_eit_year INTO l_year_status, l_overlap_code;

Line 1615: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');

1611: FETCH csr_chk_element_eit_year INTO l_year_status, l_overlap_code;
1612: CLOSE csr_chk_element_eit_year;
1613: --
1614: IF (l_year_status = 'Y') THEN
1615: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1616: fnd_message.set_token('REP_CODE',l_overlap_code); --p_eei_information3);
1617: hr_utility.raise_error;
1618: END IF;
1619: --

Line 1617: hr_utility.raise_error;

1613: --
1614: IF (l_year_status = 'Y') THEN
1615: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1616: fnd_message.set_token('REP_CODE',l_overlap_code); --p_eei_information3);
1617: hr_utility.raise_error;
1618: END IF;
1619: --
1620: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1621: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8

Line 1624: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1620: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1621: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8
1622: OR p_eei_information4 = p_eei_information10 OR p_eei_information4 = p_eei_information12
1623: OR p_eei_information4 = p_eei_information14 OR p_eei_information4 = p_eei_information16) THEN
1624: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1625: hr_utility.raise_error;
1626: END IF;
1627: --
1628: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10

Line 1625: hr_utility.raise_error;

1621: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8
1622: OR p_eei_information4 = p_eei_information10 OR p_eei_information4 = p_eei_information12
1623: OR p_eei_information4 = p_eei_information14 OR p_eei_information4 = p_eei_information16) THEN
1624: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1625: hr_utility.raise_error;
1626: END IF;
1627: --
1628: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1629: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14

Line 1631: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1627: --
1628: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1629: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14
1630: OR p_eei_information6 = p_eei_information16) THEN
1631: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1632: hr_utility.raise_error;
1633: END IF;
1634: --
1635: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12

Line 1632: hr_utility.raise_error;

1628: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1629: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14
1630: OR p_eei_information6 = p_eei_information16) THEN
1631: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1632: hr_utility.raise_error;
1633: END IF;
1634: --
1635: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12
1636: OR p_eei_information8 = p_eei_information14 OR p_eei_information8 = p_eei_information16) THEN

Line 1637: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1633: END IF;
1634: --
1635: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12
1636: OR p_eei_information8 = p_eei_information14 OR p_eei_information8 = p_eei_information16) THEN
1637: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1638: hr_utility.raise_error;
1639: END IF;
1640: --
1641: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14

Line 1638: hr_utility.raise_error;

1634: --
1635: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12
1636: OR p_eei_information8 = p_eei_information14 OR p_eei_information8 = p_eei_information16) THEN
1637: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1638: hr_utility.raise_error;
1639: END IF;
1640: --
1641: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14
1642: OR p_eei_information10 = p_eei_information16) THEN

Line 1643: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1639: END IF;
1640: --
1641: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14
1642: OR p_eei_information10 = p_eei_information16) THEN
1643: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1644: hr_utility.raise_error;
1645: END IF;
1646: --
1647: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN

Line 1644: hr_utility.raise_error;

1640: --
1641: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14
1642: OR p_eei_information10 = p_eei_information16) THEN
1643: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1644: hr_utility.raise_error;
1645: END IF;
1646: --
1647: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN
1648: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

Line 1648: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1644: hr_utility.raise_error;
1645: END IF;
1646: --
1647: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN
1648: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1649: hr_utility.raise_error;
1650: END IF;
1651: --
1652: IF (p_eei_information14 = p_eei_information16) THEN

Line 1649: hr_utility.raise_error;

1645: END IF;
1646: --
1647: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN
1648: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1649: hr_utility.raise_error;
1650: END IF;
1651: --
1652: IF (p_eei_information14 = p_eei_information16) THEN
1653: hr_utility.set_message(810,'PAY_376894_NO_DUP_INPUT_VALUE');

Line 1653: hr_utility.set_message(810,'PAY_376894_NO_DUP_INPUT_VALUE');

1649: hr_utility.raise_error;
1650: END IF;
1651: --
1652: IF (p_eei_information14 = p_eei_information16) THEN
1653: hr_utility.set_message(810,'PAY_376894_NO_DUP_INPUT_VALUE');
1654: hr_utility.raise_error;
1655: END IF;
1656: -- Validation to check if input value is specified without a mapping column in Extra Element Info DDF
1657: IF (p_eei_information5 IS NULL and p_eei_information6 IS NOT NULL)

Line 1654: hr_utility.raise_error;

1650: END IF;
1651: --
1652: IF (p_eei_information14 = p_eei_information16) THEN
1653: hr_utility.set_message(810,'PAY_376894_NO_DUP_INPUT_VALUE');
1654: hr_utility.raise_error;
1655: END IF;
1656: -- Validation to check if input value is specified without a mapping column in Extra Element Info DDF
1657: IF (p_eei_information5 IS NULL and p_eei_information6 IS NOT NULL)
1658: OR (p_eei_information7 IS NULL and p_eei_information8 IS NOT NULL)

Line 1663: hr_utility.set_message(801,'PAY_376895_NO_COL_MAP_MISSING');

1659: OR (p_eei_information9 IS NULL and p_eei_information10 IS NOT NULL)
1660: OR (p_eei_information11 IS NULL and p_eei_information12 IS NOT NULL)
1661: OR (p_eei_information13 IS NULL and p_eei_information14 IS NOT NULL)
1662: OR (p_eei_information15 IS NULL and p_eei_information16 IS NOT NULL) THEN
1663: hr_utility.set_message(801,'PAY_376895_NO_COL_MAP_MISSING');
1664: hr_utility.raise_error;
1665: END IF;
1666: --
1667: END IF;

Line 1664: hr_utility.raise_error;

1660: OR (p_eei_information11 IS NULL and p_eei_information12 IS NOT NULL)
1661: OR (p_eei_information13 IS NULL and p_eei_information14 IS NOT NULL)
1662: OR (p_eei_information15 IS NULL and p_eei_information16 IS NOT NULL) THEN
1663: hr_utility.set_message(801,'PAY_376895_NO_COL_MAP_MISSING');
1664: hr_utility.raise_error;
1665: END IF;
1666: --
1667: END IF;
1668: --

Line 1682: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');

1678: FETCH csr_get_le_details INTO rec_get_le_details;
1679: CLOSE csr_get_le_details;
1680:
1681: IF( p_eei_information2 = rec_get_ele_code.eei_information2) THEN
1682: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1683: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1684: fnd_message.set_token('LE',rec_get_le_details.name);
1685: hr_utility.raise_error;
1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN

Line 1685: hr_utility.raise_error;

1681: IF( p_eei_information2 = rec_get_ele_code.eei_information2) THEN
1682: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1683: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1684: fnd_message.set_token('LE',rec_get_le_details.name);
1685: hr_utility.raise_error;
1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1688: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1689: fnd_message.set_token('LE',rec_get_le_details.name);

Line 1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');

1683: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1684: fnd_message.set_token('LE',rec_get_le_details.name);
1685: hr_utility.raise_error;
1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1688: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1689: fnd_message.set_token('LE',rec_get_le_details.name);
1690: hr_utility.raise_error;
1691: END IF;

Line 1690: hr_utility.raise_error;

1686: ELSIF( p_eei_information2 IS NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1687: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1688: --fnd_message.set_token('LE',rec_get_ele_code.eei_information2);
1689: fnd_message.set_token('LE',rec_get_le_details.name);
1690: hr_utility.raise_error;
1691: END IF;
1692: END IF;
1693:
1694: IF( rec_get_ele_code.eei_information2 IS NULL ) THEN

Line 1696: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');

1692: END IF;
1693:
1694: IF( rec_get_ele_code.eei_information2 IS NULL ) THEN
1695: IF( p_eei_information2 IS NULL) THEN
1696: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1697: hr_utility.raise_error;
1698: ELSIF( p_eei_information2 IS NOT NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1699: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1700: hr_utility.raise_error;

Line 1697: hr_utility.raise_error;

1693:
1694: IF( rec_get_ele_code.eei_information2 IS NULL ) THEN
1695: IF( p_eei_information2 IS NULL) THEN
1696: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1697: hr_utility.raise_error;
1698: ELSIF( p_eei_information2 IS NOT NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1699: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1700: hr_utility.raise_error;
1701: END IF;

Line 1699: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');

1695: IF( p_eei_information2 IS NULL) THEN
1696: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1697: hr_utility.raise_error;
1698: ELSIF( p_eei_information2 IS NOT NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1699: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1700: hr_utility.raise_error;
1701: END IF;
1702: END IF;
1703:

Line 1700: hr_utility.raise_error;

1696: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1697: hr_utility.raise_error;
1698: ELSIF( p_eei_information2 IS NOT NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1699: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1700: hr_utility.raise_error;
1701: END IF;
1702: END IF;
1703:
1704: END LOOP;

Line 1824: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');

1820: --
1821: IF p_eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING' THEN
1822: -- Validation to ensure Year of Reporting(EOY) is different then what we already have in Extra Element Info DDF
1823: IF to_number(p_eei_information2) < to_number(p_eei_information1) THEN
1824: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
1825: hr_utility.raise_error;
1826: END IF;
1827: --
1828: OPEN csr_get_element_type;

Line 1825: hr_utility.raise_error;

1821: IF p_eei_information_category = 'NO_EOY_REPORTING_CODE_MAPPING' THEN
1822: -- Validation to ensure Year of Reporting(EOY) is different then what we already have in Extra Element Info DDF
1823: IF to_number(p_eei_information2) < to_number(p_eei_information1) THEN
1824: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
1825: hr_utility.raise_error;
1826: END IF;
1827: --
1828: OPEN csr_get_element_type;
1829: FETCH csr_get_element_type INTO rec_get_element_type;

Line 1837: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');

1833: FETCH csr_chk_element_eit_year INTO l_year_status, l_overlap_code;
1834: CLOSE csr_chk_element_eit_year;
1835: --
1836: IF (l_year_status = 'Y') THEN
1837: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1838: fnd_message.set_token('REP_CODE', l_overlap_code); --p_eei_information3);
1839: hr_utility.raise_error;
1840: END IF;
1841: --

Line 1839: hr_utility.raise_error;

1835: --
1836: IF (l_year_status = 'Y') THEN
1837: hr_utility.set_message(801,'PAY_376893_NO_YEAR_EXISTS');
1838: fnd_message.set_token('REP_CODE', l_overlap_code); --p_eei_information3);
1839: hr_utility.raise_error;
1840: END IF;
1841: --
1842: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1843: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8

Line 1846: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1842: -- Validation to check if single input value is mapped to more than one column in Extra Element Info DDF
1843: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8
1844: OR p_eei_information4 = p_eei_information10 OR p_eei_information4 = p_eei_information12
1845: OR p_eei_information4 = p_eei_information14 OR p_eei_information4 = p_eei_information16) THEN
1846: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1847: hr_utility.raise_error;
1848: END IF;
1849: --
1850: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10

Line 1847: hr_utility.raise_error;

1843: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8
1844: OR p_eei_information4 = p_eei_information10 OR p_eei_information4 = p_eei_information12
1845: OR p_eei_information4 = p_eei_information14 OR p_eei_information4 = p_eei_information16) THEN
1846: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1847: hr_utility.raise_error;
1848: END IF;
1849: --
1850: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1851: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14

Line 1853: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1849: --
1850: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1851: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14
1852: OR p_eei_information6 = p_eei_information16) THEN
1853: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1854: hr_utility.raise_error;
1855: END IF;
1856: --
1857: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12

Line 1854: hr_utility.raise_error;

1850: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1851: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14
1852: OR p_eei_information6 = p_eei_information16) THEN
1853: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1854: hr_utility.raise_error;
1855: END IF;
1856: --
1857: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12
1858: OR p_eei_information8 = p_eei_information14 OR p_eei_information8 = p_eei_information16) THEN

Line 1859: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1855: END IF;
1856: --
1857: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12
1858: OR p_eei_information8 = p_eei_information14 OR p_eei_information8 = p_eei_information16) THEN
1859: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1860: hr_utility.raise_error;
1861: END IF;
1862: --
1863: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14

Line 1860: hr_utility.raise_error;

1856: --
1857: IF (p_eei_information8 = p_eei_information10 OR p_eei_information8 = p_eei_information12
1858: OR p_eei_information8 = p_eei_information14 OR p_eei_information8 = p_eei_information16) THEN
1859: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1860: hr_utility.raise_error;
1861: END IF;
1862: --
1863: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14
1864: OR p_eei_information10 = p_eei_information16) THEN

Line 1865: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1861: END IF;
1862: --
1863: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14
1864: OR p_eei_information10 = p_eei_information16) THEN
1865: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1866: hr_utility.raise_error;
1867: END IF;
1868: --
1869: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN

Line 1866: hr_utility.raise_error;

1862: --
1863: IF (p_eei_information10 = p_eei_information12 OR p_eei_information10 = p_eei_information14
1864: OR p_eei_information10 = p_eei_information16) THEN
1865: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1866: hr_utility.raise_error;
1867: END IF;
1868: --
1869: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN
1870: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

Line 1870: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1866: hr_utility.raise_error;
1867: END IF;
1868: --
1869: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN
1870: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1871: hr_utility.raise_error;
1872: END IF;
1873: --
1874: IF (p_eei_information14 = p_eei_information16) THEN

Line 1871: hr_utility.raise_error;

1867: END IF;
1868: --
1869: IF (p_eei_information12 = p_eei_information14 OR p_eei_information12 = p_eei_information16) THEN
1870: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1871: hr_utility.raise_error;
1872: END IF;
1873: --
1874: IF (p_eei_information14 = p_eei_information16) THEN
1875: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

Line 1875: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');

1871: hr_utility.raise_error;
1872: END IF;
1873: --
1874: IF (p_eei_information14 = p_eei_information16) THEN
1875: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1876: hr_utility.raise_error;
1877: END IF;
1878: -- Validation to check if input value is specified without a mapping column in Extra Element Info DDF
1879: IF (p_eei_information5 IS NULL and p_eei_information6 IS NOT NULL)

Line 1876: hr_utility.raise_error;

1872: END IF;
1873: --
1874: IF (p_eei_information14 = p_eei_information16) THEN
1875: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1876: hr_utility.raise_error;
1877: END IF;
1878: -- Validation to check if input value is specified without a mapping column in Extra Element Info DDF
1879: IF (p_eei_information5 IS NULL and p_eei_information6 IS NOT NULL)
1880: OR (p_eei_information7 IS NULL and p_eei_information8 IS NOT NULL)

Line 1885: hr_utility.set_message(801,'PAY_376895_NO_COL_MAP_MISSING');

1881: OR (p_eei_information9 IS NULL and p_eei_information10 IS NOT NULL)
1882: OR (p_eei_information11 IS NULL and p_eei_information12 IS NOT NULL)
1883: OR (p_eei_information13 IS NULL and p_eei_information14 IS NOT NULL)
1884: OR (p_eei_information15 IS NULL and p_eei_information16 IS NOT NULL) THEN
1885: hr_utility.set_message(801,'PAY_376895_NO_COL_MAP_MISSING');
1886: hr_utility.raise_error;
1887: END IF;
1888: --
1889: END IF;

Line 1886: hr_utility.raise_error;

1882: OR (p_eei_information11 IS NULL and p_eei_information12 IS NOT NULL)
1883: OR (p_eei_information13 IS NULL and p_eei_information14 IS NOT NULL)
1884: OR (p_eei_information15 IS NULL and p_eei_information16 IS NOT NULL) THEN
1885: hr_utility.set_message(801,'PAY_376895_NO_COL_MAP_MISSING');
1886: hr_utility.raise_error;
1887: END IF;
1888: --
1889: END IF;
1890: --

Line 1912: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');

1908: OPEN csr_get_le_details(to_number(rec_get_ele_code_le_glob.eei_information2));
1909: FETCH csr_get_le_details INTO rec_get_le_details;
1910: CLOSE csr_get_le_details;
1911:
1912: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1913: --fnd_message.set_token('LE',rec_get_ele_code_le_glob.eei_information2);
1914: fnd_message.set_token('LE',rec_get_le_details.name);
1915: hr_utility.raise_error;
1916: END IF;

Line 1915: hr_utility.raise_error;

1911:
1912: hr_utility.set_message(801,'PAY_376882_NO_ELE_CODE_LE');
1913: --fnd_message.set_token('LE',rec_get_ele_code_le_glob.eei_information2);
1914: fnd_message.set_token('LE',rec_get_le_details.name);
1915: hr_utility.raise_error;
1916: END IF;
1917:
1918:
1919: IF ( csr_get_ele_code_le_glob%FOUND AND rec_get_ele_code_le_glob.eei_information2 IS NULL) THEN

Line 1920: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');

1916: END IF;
1917:
1918:
1919: IF ( csr_get_ele_code_le_glob%FOUND AND rec_get_ele_code_le_glob.eei_information2 IS NULL) THEN
1920: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1921: hr_utility.raise_error;
1922: END IF;
1923:
1924: CLOSE csr_get_ele_code_le_glob;

Line 1921: hr_utility.raise_error;

1917:
1918:
1919: IF ( csr_get_ele_code_le_glob%FOUND AND rec_get_ele_code_le_glob.eei_information2 IS NULL) THEN
1920: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1921: hr_utility.raise_error;
1922: END IF;
1923:
1924: CLOSE csr_get_ele_code_le_glob;
1925: