DBA Data[Home] [Help]

APPS.HR_DK_VALIDATE_PKG dependencies on HR_API

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

37: /* 10125436 introduced additional check if emmployee is not transferred via global deployement, if yes suppress the validation */
38: IF per_per_bus.g_global_transfer_in_process IS NULL
39: or per_per_bus.g_global_transfer_in_process = false THEN
40:
41: IF p_national_identifier IS NULL OR p_national_identifier = hr_api.g_varchar2 THEN
42: IF l_field IS NULL THEN
43: l_field := hr_general.decode_lookup('DK_FORM_LABELS','CPR');
44: ELSE
45: l_field := l_field||', '||hr_general.decode_lookup('DK_FORM_LABELS','CPR');

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

46: END IF;
47: END IF;
48: END IF;
49: --Moved mandatory check for First Name here
50: IF p_first_name IS NULL OR p_first_name = hr_api.g_varchar2 THEN
51: l_field := hr_general.decode_lookup('DK_FORM_LABELS','FIRST_NAME');
52: END IF;
53: END IF;
54:

Line 485: IF p_segment6 <> hr_api.g_varchar2 THEN

481: END IF;
482:
483: ELSE
484: -- GSI Bug 4585094
485: IF p_segment6 <> hr_api.g_varchar2 THEN
486: fnd_message.set_name('PER', 'HR_377009_DK_TR_INVALID');
487: hr_utility.raise_error;
488: END IF;
489: -- GSI Bug 4585094

Line 490: IF p_segment7 <> hr_api.g_varchar2 THEN

486: fnd_message.set_name('PER', 'HR_377009_DK_TR_INVALID');
487: hr_utility.raise_error;
488: END IF;
489: -- GSI Bug 4585094
490: IF p_segment7 <> hr_api.g_varchar2 THEN
491: fnd_message.set_name('PER', 'HR_377010_DK_ND_INVALID');
492: hr_utility.raise_error;
493: END IF;
494: -- GSI Bug 4585094

Line 495: IF p_segment8 <> hr_api.g_varchar2 THEN

491: fnd_message.set_name('PER', 'HR_377010_DK_ND_INVALID');
492: hr_utility.raise_error;
493: END IF;
494: -- GSI Bug 4585094
495: IF p_segment8 <> hr_api.g_varchar2 THEN
496: fnd_message.set_name('PER', 'HR_377011_DK_TD_INVALID');
497: hr_utility.raise_error;
498: END IF;
499:

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

508: null;
509: END;
510:
511: -- Validation rule : notified date > assignment start date --
512: if p_segment7 <> hr_api.g_varchar2 -- GSI Bug 4585094
513: and l_asg_start_date is not NULL then
514: if fnd_date.canonical_to_date(p_segment7) < fnd_date.canonical_to_date(l_asg_start_date) then
515: fnd_message.set_name('PER', 'HR_377006_DK_NOTIFIED_DATE');
516: hr_utility.raise_error;

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

516: hr_utility.raise_error;
517: end if;
518: end if;
519: -- Validation rule : Termination date >= notified date --
520: if p_segment8 <> hr_api.g_varchar2 -- GSI Bug 4585094
521: and p_segment7 <> hr_api.g_varchar2 then
522: if fnd_date.canonical_to_date(p_segment8) < fnd_date.canonical_to_date(p_segment7) then
523: fnd_message.set_name('PER', 'HR_377007_DK_TERM_DATE_ERR');
524: hr_utility.raise_error;

Line 521: and p_segment7 <> hr_api.g_varchar2 then

517: end if;
518: end if;
519: -- Validation rule : Termination date >= notified date --
520: if p_segment8 <> hr_api.g_varchar2 -- GSI Bug 4585094
521: and p_segment7 <> hr_api.g_varchar2 then
522: if fnd_date.canonical_to_date(p_segment8) < fnd_date.canonical_to_date(p_segment7) then
523: fnd_message.set_name('PER', 'HR_377007_DK_TERM_DATE_ERR');
524: hr_utility.raise_error;
525: end if;

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

524: hr_utility.raise_error;
525: end if;
526: end if;
527: -- Validation rule : Adjusted seniority date < notified date --
528: if p_segment9 <> hr_api.g_varchar2 -- GSI Bug 4585094
529: and p_segment7 <> hr_api.g_varchar2 then
530: if fnd_date.canonical_to_date(p_segment9) >= fnd_date.canonical_to_date(p_segment7) then
531: fnd_message.set_name('PER', 'HR_377008_DK_ASD_ERR');
532: hr_utility.raise_error;

Line 529: and p_segment7 <> hr_api.g_varchar2 then

525: end if;
526: end if;
527: -- Validation rule : Adjusted seniority date < notified date --
528: if p_segment9 <> hr_api.g_varchar2 -- GSI Bug 4585094
529: and p_segment7 <> hr_api.g_varchar2 then
530: if fnd_date.canonical_to_date(p_segment9) >= fnd_date.canonical_to_date(p_segment7) then
531: fnd_message.set_name('PER', 'HR_377008_DK_ASD_ERR');
532: hr_utility.raise_error;
533: end if;