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_EMS_BUS dependencies on HR_API

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

50: p_elig_mrtl_stat_cvg_id => p_elig_mrtl_stat_cvg_id,
51: p_object_version_number => p_object_version_number);
52: --
53: if (l_api_updating
54: and nvl(p_elig_mrtl_stat_cvg_id,hr_api.g_number)
55: <> ben_ems_shd.g_old_rec.elig_mrtl_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_ems_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_ems_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_ems_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_ems_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_ems_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_ems_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_ems_shd.g_old_rec.mrtl_stat_cd,hr_api.g_varchar2)

428: p_object_version_number => p_object_version_number);
429: --
430: if (l_api_updating
431: and p_mrtl_stat_cd
432: <> nvl(ben_ems_shd.g_old_rec.mrtl_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 => 'MAR_STATUS',
440: p_lookup_code => p_mrtl_stat_cd,
441: p_effective_date => p_effective_date) then
442: --

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

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

Line 506: nvl(ben_ems_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or

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

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

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

Line 508: nvl(ben_ems_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))

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

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

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

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

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

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

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

Line 582: nvl(ben_ems_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or

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

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

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

Line 584: nvl(ben_ems_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))

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

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

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

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

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

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

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

Line 716: hr_api.mandatory_arg_error

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

Line 728: hr_api.mandatory_arg_error

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

Line 733: hr_api.mandatory_arg_error

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

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

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

Line 821: hr_api.mandatory_arg_error

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

Line 835: hr_api.mandatory_arg_error

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

Line 840: hr_api.mandatory_arg_error

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

Line 845: hr_api.mandatory_arg_error

841: (p_api_name => l_proc,
842: p_argument => 'validation_end_date',
843: p_argument_value => p_validation_end_date);
844: --
845: hr_api.mandatory_arg_error
846: (p_api_name => l_proc,
847: p_argument => 'elig_mrtl_stat_cvg_id',
848: p_argument_value => p_elig_mrtl_stat_cvg_id);
849: --

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

888: --
889: -- Call all supporting business operations
890: --
891: --
892: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
893: --
894: chk_duplicate_rows
895: (p_elig_mrtl_stat_cvg_id => p_rec.elig_mrtl_stat_cvg_id,
896: p_mrtl_stat_cd => p_rec.mrtl_stat_cd,

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

968: --
969: -- Call all supporting business operations
970: --
971: --
972: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
973: --
974: chk_duplicate_rows
975: (p_elig_mrtl_stat_cvg_id => p_rec.elig_mrtl_stat_cvg_id,
976: p_mrtl_stat_cd => p_rec.mrtl_stat_cd,

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

1091: hr_utility.set_location('Entering:'|| l_proc, 10);
1092: --
1093: -- Ensure that all the mandatory parameter are not null
1094: --
1095: hr_api.mandatory_arg_error(p_api_name => l_proc,
1096: p_argument => 'elig_mrtl_stat_cvg_id',
1097: p_argument_value => p_elig_mrtl_stat_cvg_id);
1098: --
1099: open csr_leg_code;