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: /* 10125436 introduced additional check if emmployee is not transferred via global deployement, if yes suppress the validation */
32: IF per_per_bus.g_global_transfer_in_process IS NULL

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

32: IF per_per_bus.g_global_transfer_in_process IS NULL
33: or per_per_bus.g_global_transfer_in_process = false THEN
34: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN
35: IF l_field IS NULL THEN
36: l_field := hr_general.decode_lookup('NO_FORM_LABELS','NI');
37: ELSE
38: l_field := l_field||', '||hr_general.decode_lookup('NO_FORM_LABELS','NI');
39: END IF;
40: END IF;

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

34: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN
35: IF l_field IS NULL THEN
36: l_field := hr_general.decode_lookup('NO_FORM_LABELS','NI');
37: ELSE
38: l_field := l_field||', '||hr_general.decode_lookup('NO_FORM_LABELS','NI');
39: END IF;
40: END IF;
41: END IF;
42:

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

41: END IF;
42:
43: --Moved mandatory check for First Name here
44: IF p_first_name IS NULL OR p_first_name = hr_api.g_varchar2 THEN
45: l_field := hr_general.decode_lookup('NO_FORM_LABELS','FIRST_NAME');
46: END IF;
47: END IF;
48:
49: /*Bug fix- 4570879 added an additional check fnd_profile.value('PER_NATIONAL_IDENTIFIER_VALIDATION')IN ('ERROR','WARN')*/

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

511: END IF;
512:
513: IF(NVL(p_org_information3,'N') = 'Y'
514: AND p_org_information4 IS NULL) THEN
515: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
516: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
517: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
518: fnd_message.RAISE_ERROR;
519: END IF;

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

519: END IF;
520:
521: IF(NVL(p_org_information3,'N') = 'Y'
522: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
523: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
524: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
525: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
526: fnd_message.RAISE_ERROR;
527: END IF;

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

995: END IF;
996:
997: IF(NVL(p_org_information3,'N') = 'Y'
998: AND p_org_information4 IS NULL) THEN
999: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_PAY_OVER_60_FIXED_PERIOD');
1000: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1001: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1002: fnd_message.RAISE_ERROR;
1003: END IF;

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

1003: END IF;
1004:
1005: IF(NVL(p_org_information3,'N') = 'Y'
1006: AND p_org_information5 IS NULL AND NVL(l_hourly_salaried.hourly_salaried,'S') = 'S') THEN
1007: l_field := hr_general.decode_lookup('NO_FORM_LABELS', 'HOL_ADJUST');
1008: fnd_message.set_name('PER', 'HR_376803_NO_MANDATORY_MSG');
1009: fnd_message.set_token('NAME', l_field, TRANSLATE => TRUE);
1010: fnd_message.RAISE_ERROR;
1011:

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

1281:
1282: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
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;

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

1282: IF (fnd_date.canonical_to_date(p_ctr_information1) < p_effective_date) THEN
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;

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

1315:
1316: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
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;

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

1316: IF (fnd_date.canonical_to_date(p_ctr_information1) < l_active_start_date) THEN
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;

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

1349: IF (fnd_date.canonical_to_date(p_inc_information1) < p_incident_date)
1350: THEN
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;

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

1350: THEN
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;

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

1361: IF (fnd_date.canonical_to_date(p_inc_information2) < p_incident_date)
1362: THEN
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;

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

1362: THEN
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;

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

1411: --GSI Bug 4584922
1412: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN
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;

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

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

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

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

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

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

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

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

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

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

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

1479: --GSI Bug 4584922
1480: IF(p_segment14 <> hr_api.g_varchar2) THEN
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;

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

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

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

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

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

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

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

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

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

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