DBA Data[Home] [Help]

APPS.HR_NO_VALIDATE_PKG dependencies on HR_GENERAL

Line 28: -- l_field := hr_general.decode_lookup('NO_FORM_LABELS','FIRST_NAME');

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

Line 33: l_field := hr_general.decode_lookup('NO_FORM_LABELS','NI');

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;

Line 35: l_field := l_field||', '||hr_general.decode_lookup('NO_FORM_LABELS','NI');

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

Line 41: l_field := hr_general.decode_lookup('NO_FORM_LABELS','FIRST_NAME');

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')*/

Line 511: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');

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;

Line 519: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');

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;

Line 995: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');

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;

Line 1003: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');

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:

Line 1281: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));

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;

Line 1282: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));

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;

Line 1315: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','CED'));

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;

Line 1316: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ASD'));

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;

Line 1349: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_SSO'));

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;

Line 1350: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));

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;

Line 1361: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','DATE_REPORTED_TO_LIA'));

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;

Line 1362: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','ID'));

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;

Line 1411: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));

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;

Line 1412: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));

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;

Line 1422: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));

1418: --GSI Bug 4584922
1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
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;

Line 1423: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));

1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN
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:

Line 1432: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));

1428: --GSI Bug 4584922
1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
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;

Line 1433: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));

1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN
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;

Line 1479: fnd_message.set_token('AGE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RA'));

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;

Line 1480: fnd_message.set_token('AGE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','AA'));

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;

Line 1490: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RD'));

1486: --GSI Bug 4584922
1487: IF(p_segment12 <> hr_api.g_varchar2) THEN
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;

Line 1491: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));

1487: IF(p_segment12 <> hr_api.g_varchar2) THEN
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:

Line 1500: fnd_message.set_token('DATE1',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','RIS'));

1496: --GSI Bug 4584922
1497: IF(p_segment13 <> hr_api.g_varchar2) THEN
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;

Line 1501: fnd_message.set_token('DATE2',hr_general.decode_fnd_comm_lookup('NO_FORM_LABELS','HD'));

1497: IF(p_segment13 <> hr_api.g_varchar2) THEN
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;