DBA Data[Home] [Help]

APPS.HR_NO_VALIDATE_PKG dependencies on HR_API

Line 31: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN

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
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');

Line 40: IF p_first_name IS NULL OR p_first_name = hr_api.g_varchar2 THEN

36: END IF;
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:

Line 1408: IF (p_scl_segment14 <> hr_api.g_varchar2) THEN

1404:
1405: l_age := TRUNC((p_effective_date - l_dob)/365);
1406:
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'));

Line 1419: IF(p_scl_segment12 <> hr_api.g_varchar2) THEN

1415: END IF;
1416: END IF;
1417:
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'));

Line 1429: IF(p_scl_segment13 <> hr_api.g_varchar2) THEN

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 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'));

Line 1476: IF(p_segment14 <> hr_api.g_varchar2) THEN

1472:
1473: l_age := TRUNC((p_effective_date - l_dob)/365);
1474:
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'));

Line 1487: IF(p_segment12 <> hr_api.g_varchar2) THEN

1483: END IF;
1484: END IF;
1485:
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'));

Line 1497: IF(p_segment13 <> hr_api.g_varchar2) THEN

1493: END IF;
1494: END IF;
1495:
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'));