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

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

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

60: BEGIN
61: --
62: -- Added for GSI Bug 5472781
63: --
64: IF hr_utility.chk_product_install('Oracle Human Resources', 'NO') THEN
65: --
66: validate
67: (p_person_type_id => p_person_type_id
68: ,p_first_name => p_first_name

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

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

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

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

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

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

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

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

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

444: --
445: IF p_org_info_type_code = 'NO_EOY_REPORTING_RULE_OVERRIDE' THEN
446: --
447: IF to_number(p_org_information2) < to_number(p_org_information1) THEN
448: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
449: hr_utility.raise_error;
450: END IF;
451: --
452: OPEN csr_repoting_span;

Line 449: hr_utility.raise_error;

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

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

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

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

927: --
928: IF p_org_info_type_code = 'NO_EOY_REPORTING_RULE_OVERRIDE' THEN
929: --
930: IF to_number(p_org_information2) < to_number(p_org_information1) THEN
931: hr_utility.set_message(801,'PAY_376896_NO_YEAR_RESTRICT');
932: hr_utility.raise_error;
933: END IF;
934: --
935: OPEN csr_repoting_span(l_organization_id);

Line 932: hr_utility.raise_error;

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

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

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

Line 1121: hr_utility.raise_error;

1117:
1118:
1119: if p_qua_information1 <> l_nus2000_code then
1120: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1121: hr_utility.raise_error;
1122: end if;
1123:
1124:
1125:

Line 1136: hr_utility.raise_error;

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

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

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

Line 1181: hr_utility.raise_error;

1177: CLOSE c_information1;
1178:
1179: if p_qua_information1 <> l_nus2000_code then
1180: fnd_message.set_name('PER', 'HR_376822_NO_NUS2000_MISMATCH');
1181: hr_utility.raise_error;
1182: end if;
1183:
1184:
1185:

Line 1203: hr_utility.raise_error;

1199: and pq.qua_information2='Y';
1200:
1201: IF l_count > 0 then
1202: fnd_message.set_name('PER', 'HR_376812_NO_HIGHEST_LEVEL');
1203: hr_utility.raise_error;
1204: END IF;
1205:
1206: END IF;
1207: END IF;

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

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

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

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

Line 1283: hr_utility.raise_error;

1279: --
1280: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1281: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1282: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1283: hr_utility.raise_error;
1284: --
1285: END IF;
1286: END IF;
1287: END IF;

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

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

Line 1317: hr_utility.raise_error;

1313: --
1314: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1315: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));
1316: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));
1317: hr_utility.raise_error;
1318: --
1319: END IF;
1320: END IF;
1321: END IF;

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

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

Line 1351: hr_utility.raise_error;

1347: --
1348: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1349: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));
1350: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1351: hr_utility.raise_error;
1352: --
1353: END IF;
1354: END IF;
1355:

Line 1363: hr_utility.raise_error;

1359: --
1360: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1361: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));
1362: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));
1363: hr_utility.raise_error;
1364: --
1365: END IF;
1366: END IF;
1367: END IF;

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

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

Line 1413: hr_utility.raise_error;

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

Line 1424: hr_utility.raise_error;

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

Line 1434: hr_utility.raise_error;

1430: IF( p_scl_segment13 1431: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1432: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1433: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1434: hr_utility.raise_error;
1435: END IF;
1436: END IF;
1437: END IF;
1438: END create_asg_validate;

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

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

Line 1481: hr_utility.raise_error;

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

Line 1492: hr_utility.raise_error;

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

Line 1502: hr_utility.raise_error;

1498: IF( p_segment13 1499: fnd_message.set_name('PER','HR_376820_NO_DATE_EARLY');
1500: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));
1501: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));
1502: hr_utility.raise_error;
1503: END IF;
1504: END IF;
1505: END IF;
1506: END update_asg_validate;

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

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

Line 1603: hr_utility.raise_error;

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

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

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

Line 1613: hr_utility.raise_error;

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

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

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

Line 1621: hr_utility.raise_error;

1617: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8
1618: OR p_eei_information4 = p_eei_information10 OR p_eei_information4 = p_eei_information12
1619: OR p_eei_information4 = p_eei_information14 OR p_eei_information4 = p_eei_information16) THEN
1620: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1621: hr_utility.raise_error;
1622: END IF;
1623: --
1624: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1625: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14

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

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

Line 1628: hr_utility.raise_error;

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

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

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

Line 1634: hr_utility.raise_error;

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

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

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

Line 1640: hr_utility.raise_error;

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

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

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

Line 1645: hr_utility.raise_error;

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

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

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

Line 1650: hr_utility.raise_error;

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

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

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

Line 1660: hr_utility.raise_error;

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

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

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

Line 1681: hr_utility.raise_error;

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

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

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

Line 1686: hr_utility.raise_error;

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

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

1688: END IF;
1689:
1690: IF( rec_get_ele_code.eei_information2 IS NULL ) THEN
1691: IF( p_eei_information2 IS NULL) THEN
1692: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1693: hr_utility.raise_error;
1694: ELSIF( p_eei_information2 IS NOT NULL AND p_eei_information1 = rec_get_ele_code.eei_information1) THEN
1695: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1696: hr_utility.raise_error;

Line 1693: hr_utility.raise_error;

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

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

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

Line 1696: hr_utility.raise_error;

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

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

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

Line 1821: hr_utility.raise_error;

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

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

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

Line 1835: hr_utility.raise_error;

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

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

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

Line 1843: hr_utility.raise_error;

1839: IF (p_eei_information4 = p_eei_information6 OR p_eei_information4 = p_eei_information8
1840: OR p_eei_information4 = p_eei_information10 OR p_eei_information4 = p_eei_information12
1841: OR p_eei_information4 = p_eei_information14 OR p_eei_information4 = p_eei_information16) THEN
1842: hr_utility.set_message(801,'PAY_376894_NO_DUP_INPUT_VALUE');
1843: hr_utility.raise_error;
1844: END IF;
1845: --
1846: IF (p_eei_information6 = p_eei_information8 OR p_eei_information6 = p_eei_information10
1847: OR p_eei_information6 = p_eei_information12 OR p_eei_information6 = p_eei_information14

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

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

Line 1850: hr_utility.raise_error;

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

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

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

Line 1856: hr_utility.raise_error;

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

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

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

Line 1862: hr_utility.raise_error;

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

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

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

Line 1867: hr_utility.raise_error;

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

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

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

Line 1872: hr_utility.raise_error;

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

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

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

Line 1882: hr_utility.raise_error;

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

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

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

Line 1911: hr_utility.raise_error;

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

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

1912: END IF;
1913:
1914:
1915: IF ( csr_get_ele_code_le_glob%FOUND AND rec_get_ele_code_le_glob.eei_information2 IS NULL) THEN
1916: hr_utility.set_message(801,'PAY_376883_NO_ELE_CODE_LE_GLOB');
1917: hr_utility.raise_error;
1918: END IF;
1919:
1920: CLOSE csr_get_ele_code_le_glob;

Line 1917: hr_utility.raise_error;

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