DBA Data[Home] [Help]

APPS.HR_NO_VALIDATE_PKG dependencies on HR_API

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

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

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

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

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

1408:
1409: l_age := TRUNC((p_effective_date - l_dob)/365);
1410:
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'));

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

1419: END IF;
1420: END IF;
1421:
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'));

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

1429: END IF;
1430: END IF;
1431:
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'));

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

1476:
1477: l_age := TRUNC((p_effective_date - l_dob)/365);
1478:
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'));

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

1487: END IF;
1488: END IF;
1489:
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'));

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

1497: END IF;
1498: END IF;
1499:
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'));