eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EMC_BUS dependencies on HR_API

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

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

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

128: p_effective_date => p_effective_date,
129: p_object_version_number => p_object_version_number);
130: --
131: if (l_api_updating
132: and nvl(p_cvg_thru_rl,hr_api.g_number)
133: <> ben_emc_shd.g_old_rec.cvg_thru_rl
134: or not l_api_updating)
135: and p_cvg_thru_rl is not null then
136: --

Line 209: <> nvl(ben_emc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)

205: p_object_version_number => p_object_version_number);
206: --
207: if (l_api_updating
208: and p_cvg_thru_cd
209: <> nvl(ben_emc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)
210: or not l_api_updating)
211: and p_cvg_thru_cd is not null then
212: --
213: -- check if value of lookup falls within lookup type.

Line 215: if hr_api.not_exists_in_hr_lookups

211: and p_cvg_thru_cd is not null then
212: --
213: -- check if value of lookup falls within lookup type.
214: --
215: if hr_api.not_exists_in_hr_lookups
216: (p_lookup_type => 'BEN_DPNT_CVG_END',
217: p_lookup_code => p_cvg_thru_cd,
218: p_effective_date => p_effective_date) then
219: --

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

282: p_effective_date => p_effective_date,
283: p_object_version_number => p_object_version_number);
284: --
285: if (l_api_updating
286: and nvl(p_cvg_strt_rl,hr_api.g_number)
287: <> ben_emc_shd.g_old_rec.cvg_strt_rl
288: or not l_api_updating)
289: and p_cvg_strt_rl is not null then
290: --

Line 363: <> nvl(ben_emc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)

359: p_object_version_number => p_object_version_number);
360: --
361: if (l_api_updating
362: and p_cvg_strt_cd
363: <> nvl(ben_emc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)
364: or not l_api_updating)
365: and p_cvg_strt_cd is not null then
366: --
367: -- check if value of lookup falls within lookup type.

Line 369: if hr_api.not_exists_in_hr_lookups

365: and p_cvg_strt_cd is not null then
366: --
367: -- check if value of lookup falls within lookup type.
368: --
369: if hr_api.not_exists_in_hr_lookups
370: (p_lookup_type => 'BEN_DPNT_CVG_STRT',
371: p_lookup_code => p_cvg_strt_cd,
372: p_effective_date => p_effective_date) then
373: --

Line 432: <> nvl(ben_emc_shd.g_old_rec.mltry_stat_cd,hr_api.g_varchar2)

428: p_object_version_number => p_object_version_number);
429: --
430: if (l_api_updating
431: and p_mltry_stat_cd
432: <> nvl(ben_emc_shd.g_old_rec.mltry_stat_cd,hr_api.g_varchar2)
433: or not l_api_updating) then
434: --
435: -- check if value of lookup falls within lookup type.
436: --

Line 438: if hr_api.not_exists_in_hr_lookups

434: --
435: -- check if value of lookup falls within lookup type.
436: --
437: --
438: if hr_api.not_exists_in_hr_lookups
439: (p_lookup_type => 'YES_NO',
440: p_lookup_code => p_mltry_stat_cd,
441: p_effective_date => p_effective_date) then
442: --

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

502: p_effective_date => p_effective_date,
503: p_object_version_number => p_object_version_number);
504: --
505: if (l_api_updating
506: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
507: nvl(ben_emc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
508: nvl(p_cvg_strt_rl, hr_api.g_number) <>
509: nvl(ben_emc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
510: or not l_api_updating) then

Line 507: nvl(ben_emc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or

503: p_object_version_number => p_object_version_number);
504: --
505: if (l_api_updating
506: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
507: nvl(ben_emc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
508: nvl(p_cvg_strt_rl, hr_api.g_number) <>
509: nvl(ben_emc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
510: or not l_api_updating) then
511: --

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

504: --
505: if (l_api_updating
506: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
507: nvl(ben_emc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
508: nvl(p_cvg_strt_rl, hr_api.g_number) <>
509: nvl(ben_emc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
510: or not l_api_updating) then
511: --
512: -- check dependency of Code and Rule.

Line 509: nvl(ben_emc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))

505: if (l_api_updating
506: and (nvl(p_cvg_strt_cd, hr_api.g_varchar2) <>
507: nvl(ben_emc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or
508: nvl(p_cvg_strt_rl, hr_api.g_number) <>
509: nvl(ben_emc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))
510: or not l_api_updating) then
511: --
512: -- check dependency of Code and Rule.
513: --

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

510: or not l_api_updating) then
511: --
512: -- check dependency of Code and Rule.
513: --
514: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) <> 'RL' and
515: p_cvg_strt_rl is not null) then
516: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
517: fnd_message.raise_error;
518: end if;

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

516: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
517: fnd_message.raise_error;
518: end if;
519:
520: if ( nvl(p_cvg_strt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_rl is null) then
521: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
522: fnd_message.raise_error;
523: end if;
524: end if;

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

578: p_effective_date => p_effective_date,
579: p_object_version_number => p_object_version_number);
580: --
581: if (l_api_updating
582: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
583: nvl(ben_emc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
584: nvl(p_cvg_thru_rl, hr_api.g_number) <>
585: nvl(ben_emc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
586: or not l_api_updating) then

Line 583: nvl(ben_emc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or

579: p_object_version_number => p_object_version_number);
580: --
581: if (l_api_updating
582: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
583: nvl(ben_emc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
584: nvl(p_cvg_thru_rl, hr_api.g_number) <>
585: nvl(ben_emc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
586: or not l_api_updating) then
587:

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

580: --
581: if (l_api_updating
582: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
583: nvl(ben_emc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
584: nvl(p_cvg_thru_rl, hr_api.g_number) <>
585: nvl(ben_emc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
586: or not l_api_updating) then
587:
588: --

Line 585: nvl(ben_emc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))

581: if (l_api_updating
582: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
583: nvl(ben_emc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
584: nvl(p_cvg_thru_rl, hr_api.g_number) <>
585: nvl(ben_emc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
586: or not l_api_updating) then
587:
588: --
589: -- check dependency of Code and Rule.

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

587:
588: --
589: -- check dependency of Code and Rule.
590: --
591: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) <> 'RL' and
592: p_cvg_thru_rl is not null) then
593: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
594: fnd_message.raise_error;
595: end if;

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

593: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
594: fnd_message.raise_error;
595: end if;
596:
597: if ( nvl(p_cvg_thru_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_rl is null) then
598: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
599: fnd_message.raise_error;
600: end if;
601: end if;

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

701: --
702: -- {End Of Comments}
703: -- ----------------------------------------------------------------------------
704: Procedure dt_update_validate
705: (p_dpnt_cvg_eligy_prfl_id in number default hr_api.g_number,
706: p_datetrack_mode in varchar2,
707: p_validation_start_date in date,
708: p_validation_end_date in date) Is
709: --

Line 719: hr_api.mandatory_arg_error

715: hr_utility.set_location('Entering:'||l_proc, 5);
716: --
717: -- Ensure that the p_datetrack_mode argument is not null
718: --
719: hr_api.mandatory_arg_error
720: (p_api_name => l_proc,
721: p_argument => 'datetrack_mode',
722: p_argument_value => p_datetrack_mode);
723: --

Line 731: hr_api.mandatory_arg_error

727: --
728: --
729: -- Ensure the arguments are not null
730: --
731: hr_api.mandatory_arg_error
732: (p_api_name => l_proc,
733: p_argument => 'validation_start_date',
734: p_argument_value => p_validation_start_date);
735: --

Line 736: hr_api.mandatory_arg_error

732: (p_api_name => l_proc,
733: p_argument => 'validation_start_date',
734: p_argument_value => p_validation_start_date);
735: --
736: hr_api.mandatory_arg_error
737: (p_api_name => l_proc,
738: p_argument => 'validation_end_date',
739: p_argument_value => p_validation_end_date);
740: --

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

737: (p_api_name => l_proc,
738: p_argument => 'validation_end_date',
739: p_argument_value => p_validation_end_date);
740: --
741: If ((nvl(p_dpnt_cvg_eligy_prfl_id, hr_api.g_number) <> hr_api.g_number) and
742: NOT (dt_api.check_min_max_dates
743: (p_base_table_name => 'ben_dpnt_cvg_eligy_prfl_f',
744: p_base_key_column => 'dpnt_cvg_eligy_prfl_id',
745: p_base_key_value => p_dpnt_cvg_eligy_prfl_id,

Line 824: hr_api.mandatory_arg_error

820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: -- Ensure that the p_datetrack_mode argument is not null
823: --
824: hr_api.mandatory_arg_error
825: (p_api_name => l_proc,
826: p_argument => 'datetrack_mode',
827: p_argument_value => p_datetrack_mode);
828: --

Line 838: hr_api.mandatory_arg_error

834: --
835: --
836: -- Ensure the arguments are not null
837: --
838: hr_api.mandatory_arg_error
839: (p_api_name => l_proc,
840: p_argument => 'validation_start_date',
841: p_argument_value => p_validation_start_date);
842: --

Line 843: hr_api.mandatory_arg_error

839: (p_api_name => l_proc,
840: p_argument => 'validation_start_date',
841: p_argument_value => p_validation_start_date);
842: --
843: hr_api.mandatory_arg_error
844: (p_api_name => l_proc,
845: p_argument => 'validation_end_date',
846: p_argument_value => p_validation_end_date);
847: --

Line 848: hr_api.mandatory_arg_error

844: (p_api_name => l_proc,
845: p_argument => 'validation_end_date',
846: p_argument_value => p_validation_end_date);
847: --
848: hr_api.mandatory_arg_error
849: (p_api_name => l_proc,
850: p_argument => 'elig_mltry_stat_cvg_id',
851: p_argument_value => p_elig_mltry_stat_cvg_id);
852: --

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

891: --
892: -- Call all supporting business operations
893: --
894: --
895: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
896: --
897: chk_duplicate_rows
898: (p_elig_mltry_stat_cvg_id => p_rec.elig_mltry_stat_cvg_id,
899: p_mltry_stat_cd => p_rec.mltry_stat_cd,

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

971: --
972: -- Call all supporting business operations
973: --
974: --
975: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
976: --
977: chk_elig_mltry_stat_cvg_id
978: (p_elig_mltry_stat_cvg_id => p_rec.elig_mltry_stat_cvg_id,
979: p_effective_date => p_effective_date,

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

1087: hr_utility.set_location('Entering:'|| l_proc, 10);
1088: --
1089: -- Ensure that all the mandatory parameter are not null
1090: --
1091: hr_api.mandatory_arg_error(p_api_name => l_proc,
1092: p_argument => 'elig_mltry_stat_cvg_id',
1093: p_argument_value => p_elig_mltry_stat_cvg_id);
1094: --
1095: open csr_leg_code;