24:
25:
26: --Validate not null fields
27: --IF p_first_name IS NULL THEN
28: -- l_field := hr_general.decode_lookup('NO_FORM_LABELS','FIRST_NAME');
29: --END IF;
30: IF l_type IS NOT NULL THEN
31: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN
32: IF l_field IS NULL THEN
29: --END IF;
30: IF l_type IS NOT NULL THEN
31: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN
32: IF l_field IS NULL THEN
33: l_field := hr_general.decode_lookup('NO_FORM_LABELS','NI');
34: ELSE
35: l_field := l_field||', '||hr_general.decode_lookup('NO_FORM_LABELS','NI');
36: END IF;
37: END IF;
31: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN
32: IF l_field IS NULL THEN
33: l_field := hr_general.decode_lookup('NO_FORM_LABELS','NI');
34: ELSE
35: l_field := l_field||', '||hr_general.decode_lookup('NO_FORM_LABELS','NI');
36: END IF;
37: END IF;
38:
39: --Moved mandatory check for First Name here
37: END IF;
38:
39: --Moved mandatory check for First Name here
40: IF p_first_name IS NULL OR p_first_name = hr_api.g_varchar2 THEN
41: l_field := hr_general.decode_lookup('NO_FORM_LABELS','FIRST_NAME');
42: END IF;
43: END IF;
44:
45: /*Bug fix- 4570879 added an additional check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN')*/
507: END IF;
508:
509: IF(NVL(p_org_information3,'N') = 'Y'
510: AND p_org_information4 IS NULL) THEN
511: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
512: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
513: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
514: fnd_message.RAISE_ERROR;
515: END IF;
515: END IF;
516:
517: IF(NVL(p_org_information3,'N') = 'Y'
518: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
519: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
520: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
521: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
522: fnd_message.RAISE_ERROR;
523: END IF;
991: END IF;
992:
993: IF(NVL(p_org_information3,'N') = 'Y'
994: AND p_org_information4 IS NULL) THEN
995: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
996: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
997: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
998: fnd_message.RAISE_ERROR;
999: END IF;
999: END IF;
1000:
1001: IF(NVL(p_org_information3,'N') = 'Y'
1002: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1003: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1004: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1005: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1006: fnd_message.RAISE_ERROR;
1007:
1277:
1278: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
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;
1278: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
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;
1311:
1312: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
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;
1312: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
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;
1345: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1346: THEN
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;
1346: THEN
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;
1357: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)
1358: THEN
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;
1358: THEN
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;
1407: --GSI Bug 4584922
1408: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
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;
1408: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
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;
1418: --GSI Bug 4584922
1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1420: IF( p_scl_segment12
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;
1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
1420: IF( p_scl_segment12
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
1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1430: IF( p_scl_segment13
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;
1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
1430: IF( p_scl_segment13
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;
1475: --GSI Bug 4584922
1476: IF(p_segment14 <> hr_api.g_varchar2) THEN
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;
1476: IF(p_segment14 <> hr_api.g_varchar2) THEN
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;
1486: --GSI Bug 4584922
1487: IF(p_segment12 <> hr_api.g_varchar2) THEN
1488: IF( p_segment12
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;
1487: IF(p_segment12 <> hr_api.g_varchar2) THEN
1488: IF( p_segment12
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
1497: IF(p_segment13 <> hr_api.g_varchar2) THEN
1498: IF( p_segment13
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;
1497: IF(p_segment13 <> hr_api.g_varchar2) THEN
1498: IF( p_segment13
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;