APPS.BEN_EAC_BUS dependencies on HR_API

Line 54: and nvl(p_elig_age_cvg_id,hr_api.g_number)

50: p_elig_age_cvg_id => p_elig_age_cvg_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_age_cvg_id,hr_api.g_number)
55: <> ben_eac_shd.g_old_rec.elig_age_cvg_id) then
56: --
57: -- raise error as PK has changed
58: --

Line 129: and nvl(p_age_fctr_id,hr_api.g_number)

125: p_effective_date => p_effective_date,
126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_age_fctr_id,hr_api.g_number)
130: <> nvl(ben_eac_shd.g_old_rec.age_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_age_fctr_id is not null then
133: --

Line 130: <> nvl(ben_eac_shd.g_old_rec.age_fctr_id,hr_api.g_number)

126: p_object_version_number => p_object_version_number);
127: --
128: if (l_api_updating
129: and nvl(p_age_fctr_id,hr_api.g_number)
130: <> nvl(ben_eac_shd.g_old_rec.age_fctr_id,hr_api.g_number)
131: or not l_api_updating) and
132: p_age_fctr_id is not null then
133: --
134: -- check if age_fctr_id value exists in ben_age_fctr table

Line 211: and nvl(p_cvg_thru_rl,hr_api.g_number)

207: p_effective_date => p_effective_date,
208: p_object_version_number => p_object_version_number);
209: --
210: if (l_api_updating
211: and nvl(p_cvg_thru_rl,hr_api.g_number)
212: <> ben_eac_shd.g_old_rec.cvg_thru_rl
213: or not l_api_updating)
214: and p_cvg_thru_rl is not null then
215: --

Line 288: <> nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)

284: p_object_version_number => p_object_version_number);
285: --
286: if (l_api_updating
287: and p_cvg_thru_cd
288: <> nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)
289: or not l_api_updating)
290: and p_cvg_thru_cd is not null then
291: --
292: -- check if value of lookup falls within lookup type.

Line 294: if hr_api.not_exists_in_hr_lookups

290: and p_cvg_thru_cd is not null then
291: --
292: -- check if value of lookup falls within lookup type.
293: --
294: if hr_api.not_exists_in_hr_lookups
295: (p_lookup_type => 'BEN_DPNT_CVG_END',
296: p_lookup_code => p_cvg_thru_cd,
297: p_effective_date => p_effective_date) then
298: --

Line 365: and nvl(p_cvg_strt_rl,hr_api.g_number)

361: p_effective_date => p_effective_date,
362: p_object_version_number => p_object_version_number);
363: --
364: if (l_api_updating
365: and nvl(p_cvg_strt_rl,hr_api.g_number)
366: <> ben_eac_shd.g_old_rec.cvg_strt_rl
367: or not l_api_updating)
368: and p_cvg_strt_rl is not null then
369: --

Line 442: <> nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)

438: p_object_version_number => p_object_version_number);
439: --
440: if (l_api_updating
441: and p_cvg_strt_cd
442: <> nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)
443: or not l_api_updating)
444: and p_cvg_strt_cd is not null then
445: --
446: -- check if value of lookup falls within lookup type.

Line 448: if hr_api.not_exists_in_hr_lookups

444: and p_cvg_strt_cd is not null then
445: --
446: -- check if value of lookup falls within lookup type.
447: --
448: if hr_api.not_exists_in_hr_lookups
449: (p_lookup_type => 'BEN_DPNT_CVG_STRT',
450: p_lookup_code => p_cvg_strt_cd,
451: p_effective_date => p_effective_date) then
452: --

Line 515: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>

511: p_effective_date => p_effective_date,
512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
517: nvl(p_cvg_strt_rl, hr_api.g_number) <>
518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
519: or not l_api_updating) then

Line 516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or

512: p_object_version_number => p_object_version_number);
513: --
514: if (l_api_updating
515: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
517: nvl(p_cvg_strt_rl, hr_api.g_number) <>
518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
519: or not l_api_updating) then
520: --

Line 517: nvl(p_cvg_strt_rl, hr_api.g_number) <>

513: --
514: if (l_api_updating
515: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
517: nvl(p_cvg_strt_rl, hr_api.g_number) <>
518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
519: or not l_api_updating) then
520: --
521: -- check dependency of Code and Rule.

Line 518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))

514: if (l_api_updating
515: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
516: nvl(ben_eac_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
517: nvl(p_cvg_strt_rl, hr_api.g_number) <>
518: nvl(ben_eac_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
519: or not l_api_updating) then
520: --
521: -- check dependency of Code and Rule.
522: --

Line 523: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) <> 'RL' and

519: or not l_api_updating) then
520: --
521: -- check dependency of Code and Rule.
522: --
523: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) <> 'RL' and
524: p_cvg_strt_rl is not null) then
525: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
526: fnd_message.raise_error;
527: end if;

Line 529: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then

525: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
526: fnd_message.raise_error;
527: end if;
528:
529: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
530: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
531: fnd_message.raise_error;
532: end if;
533: end if;

Line 591: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>

587: p_effective_date => p_effective_date,
588: p_object_version_number => p_object_version_number);
589: --
590: if (l_api_updating
591: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_rl, hr_api.g_number) <>
594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
595: or not l_api_updating) then

Line 592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or

588: p_object_version_number => p_object_version_number);
589: --
590: if (l_api_updating
591: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_rl, hr_api.g_number) <>
594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
595: or not l_api_updating) then
596:

Line 593: nvl(p_cvg_thru_rl, hr_api.g_number) <>

589: --
590: if (l_api_updating
591: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_rl, hr_api.g_number) <>
594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
595: or not l_api_updating) then
596:
597: --

Line 594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))

590: if (l_api_updating
591: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
592: nvl(ben_eac_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
593: nvl(p_cvg_thru_rl, hr_api.g_number) <>
594: nvl(ben_eac_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
595: or not l_api_updating) then
596:
597: --
598: -- check dependency of Code and Rule.

Line 600: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) <> 'RL' and

596:
597: --
598: -- check dependency of Code and Rule.
599: --
600: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) <> 'RL' and
601: p_cvg_thru_rl is not null) then
602: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
603: fnd_message.raise_error;
604: end if;

Line 606: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then

602: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
603: fnd_message.raise_error;
604: end if;
605:
606: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
608: fnd_message.raise_error;
609: end if;
610: end if;

Line 714: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,

710: --
711: -- {End Of Comments}
712: -- ----------------------------------------------------------------------------
713: Procedure dt_update_validate
714: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
715: p_datetrack_mode in varchar2,
716: p_validation_start_date in date,
717: p_validation_end_date in date) Is
718: --

Line 728: hr_api.mandatory_arg_error

724: hr_utility.set_location('Entering:'||l_proc, 5);
725: --
726: -- Ensure that the p_datetrack_mode argument is not null
727: --
728: hr_api.mandatory_arg_error
729: (p_api_name => l_proc,
730: p_argument => 'datetrack_mode',
731: p_argument_value => p_datetrack_mode);
732: --

Line 740: hr_api.mandatory_arg_error

736: --
737: --
738: -- Ensure the arguments are not null
739: --
740: hr_api.mandatory_arg_error
741: (p_api_name => l_proc,
742: p_argument => 'validation_start_date',
743: p_argument_value => p_validation_start_date);
744: --

Line 745: hr_api.mandatory_arg_error

741: (p_api_name => l_proc,
742: p_argument => 'validation_start_date',
743: p_argument_value => p_validation_start_date);
744: --
745: hr_api.mandatory_arg_error
746: (p_api_name => l_proc,
747: p_argument => 'validation_end_date',
748: p_argument_value => p_validation_end_date);
749: --

Line 750: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and

746: (p_api_name => l_proc,
747: p_argument => 'validation_end_date',
748: p_argument_value => p_validation_end_date);
749: --
750: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
751: NOT (dt_api.check_min_max_dates
752: (p_base_table_name => 'ben_dpnt_cvg_eligy_prfl_f',
753: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
754: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,

Line 833: hr_api.mandatory_arg_error

829: hr_utility.set_location('Entering:'||l_proc, 5);
830: --
831: -- Ensure that the p_datetrack_mode argument is not null
832: --
833: hr_api.mandatory_arg_error
834: (p_api_name => l_proc,
835: p_argument => 'datetrack_mode',
836: p_argument_value => p_datetrack_mode);
837: --

Line 847: hr_api.mandatory_arg_error

843: --
844: --
845: -- Ensure the arguments are not null
846: --
847: hr_api.mandatory_arg_error
848: (p_api_name => l_proc,
849: p_argument => 'validation_start_date',
850: p_argument_value => p_validation_start_date);
851: --

Line 852: hr_api.mandatory_arg_error

848: (p_api_name => l_proc,
849: p_argument => 'validation_start_date',
850: p_argument_value => p_validation_start_date);
851: --
852: hr_api.mandatory_arg_error
853: (p_api_name => l_proc,
854: p_argument => 'validation_end_date',
855: p_argument_value => p_validation_end_date);
856: --

Line 857: hr_api.mandatory_arg_error

853: (p_api_name => l_proc,
854: p_argument => 'validation_end_date',
855: p_argument_value => p_validation_end_date);
856: --
857: hr_api.mandatory_arg_error
858: (p_api_name => l_proc,
859: p_argument => 'elig_age_cvg_id',
860: p_argument_value => p_elig_age_cvg_id);
861: --

Line 904: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

900: --
901: -- Call all supporting business operations
902: --
903: --
904: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
905: --
906:
907: chk_duplicate_rows
908: (p_elig_age_cvg_id => p_rec.elig_age_cvg_id,

Line 984: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

980: --
981: -- Call all supporting business operations
982: --
983: --
984: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
985: --
986: chk_duplicate_rows
987: (p_elig_age_cvg_id => p_rec.elig_age_cvg_id,
988: p_age_fctr_id => p_rec.age_fctr_id,

Line 1107: hr_api.mandatory_arg_error(p_api_name => l_proc,

1103: hr_utility.set_location('Entering:'|| l_proc, 10);
1104: --
1105: -- Ensure that all the mandatory parameter are not null
1106: --
1107: hr_api.mandatory_arg_error(p_api_name => l_proc,
1108: p_argument => 'elig_age_cvg_id',
1109: p_argument_value => p_elig_age_cvg_id);
1110: --
1111: open csr_leg_code;