DBA Data[Home] [Help]

APPS.HR_DK_VALIDATE_PKG dependencies on HR_API

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

33: -- l_field := hr_general.decode_lookup('DK_FORM_LABELS','FIRST_NAME');
34: -- END IF;
35: --
36: IF l_type IS NOT NULL THEN
37: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN
38: IF l_field IS NULL THEN
39: l_field := hr_general.decode_lookup('DK_FORM_LABELS','CPR');
40: ELSE
41: l_field := l_field||', '||hr_general.decode_lookup('DK_FORM_LABELS','CPR');

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

41: l_field := l_field||', '||hr_general.decode_lookup('DK_FORM_LABELS','CPR');
42: END IF;
43: END IF;
44: --Moved mandatory check for First Name here
45: IF p_first_name IS NULL OR p_first_name = hr_api.g_varchar2 THEN
46: l_field := hr_general.decode_lookup('DK_FORM_LABELS','FIRST_NAME');
47: END IF;
48: END IF;
49:

Line 436: IF p_segment6 <> hr_api.g_varchar2 THEN

432: END IF;
433:
434: ELSE
435: -- GSI Bug 4585094
436: IF p_segment6 <> hr_api.g_varchar2 THEN
437: fnd_message.set_name('PER', 'HR_377009_DK_TR_INVALID');
438: hr_utility.raise_error;
439: END IF;
440: -- GSI Bug 4585094

Line 441: IF p_segment7 <> hr_api.g_varchar2 THEN

437: fnd_message.set_name('PER', 'HR_377009_DK_TR_INVALID');
438: hr_utility.raise_error;
439: END IF;
440: -- GSI Bug 4585094
441: IF p_segment7 <> hr_api.g_varchar2 THEN
442: fnd_message.set_name('PER', 'HR_377010_DK_ND_INVALID');
443: hr_utility.raise_error;
444: END IF;
445: -- GSI Bug 4585094

Line 446: IF p_segment8 <> hr_api.g_varchar2 THEN

442: fnd_message.set_name('PER', 'HR_377010_DK_ND_INVALID');
443: hr_utility.raise_error;
444: END IF;
445: -- GSI Bug 4585094
446: IF p_segment8 <> hr_api.g_varchar2 THEN
447: fnd_message.set_name('PER', 'HR_377011_DK_TD_INVALID');
448: hr_utility.raise_error;
449: END IF;
450:

Line 463: if p_segment7 <> hr_api.g_varchar2 -- GSI Bug 4585094

459: null;
460: END;
461:
462: -- Validation rule : notified date > assignment start date --
463: if p_segment7 <> hr_api.g_varchar2 -- GSI Bug 4585094
464: and l_asg_start_date is not NULL then
465: if fnd_date.canonical_to_date(p_segment7) < fnd_date.canonical_to_date(l_asg_start_date) then
466: fnd_message.set_name('PER', 'HR_377006_DK_NOTIFIED_DATE');
467: hr_utility.raise_error;

Line 471: if p_segment8 <> hr_api.g_varchar2 -- GSI Bug 4585094

467: hr_utility.raise_error;
468: end if;
469: end if;
470: -- Validation rule : Termination date >= notified date --
471: if p_segment8 <> hr_api.g_varchar2 -- GSI Bug 4585094
472: and p_segment7 <> hr_api.g_varchar2 then
473: if fnd_date.canonical_to_date(p_segment8) < fnd_date.canonical_to_date(p_segment7) then
474: fnd_message.set_name('PER', 'HR_377007_DK_TERM_DATE_ERR');
475: hr_utility.raise_error;

Line 472: and p_segment7 <> hr_api.g_varchar2 then

468: end if;
469: end if;
470: -- Validation rule : Termination date >= notified date --
471: if p_segment8 <> hr_api.g_varchar2 -- GSI Bug 4585094
472: and p_segment7 <> hr_api.g_varchar2 then
473: if fnd_date.canonical_to_date(p_segment8) < fnd_date.canonical_to_date(p_segment7) then
474: fnd_message.set_name('PER', 'HR_377007_DK_TERM_DATE_ERR');
475: hr_utility.raise_error;
476: end if;

Line 479: if p_segment9 <> hr_api.g_varchar2 -- GSI Bug 4585094

475: hr_utility.raise_error;
476: end if;
477: end if;
478: -- Validation rule : Adjusted seniority date < notified date --
479: if p_segment9 <> hr_api.g_varchar2 -- GSI Bug 4585094
480: and p_segment7 <> hr_api.g_varchar2 then
481: if fnd_date.canonical_to_date(p_segment9) >= fnd_date.canonical_to_date(p_segment7) then
482: fnd_message.set_name('PER', 'HR_377008_DK_ASD_ERR');
483: hr_utility.raise_error;

Line 480: and p_segment7 <> hr_api.g_varchar2 then

476: end if;
477: end if;
478: -- Validation rule : Adjusted seniority date < notified date --
479: if p_segment9 <> hr_api.g_varchar2 -- GSI Bug 4585094
480: and p_segment7 <> hr_api.g_varchar2 then
481: if fnd_date.canonical_to_date(p_segment9) >= fnd_date.canonical_to_date(p_segment7) then
482: fnd_message.set_name('PER', 'HR_377008_DK_ASD_ERR');
483: hr_utility.raise_error;
484: end if;