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

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

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

Line 124: <> nvl(ben_edc_shd.g_old_rec.dsbld_cd,hr_api.g_varchar2)

120: p_object_version_number => p_object_version_number);
121: --
122: if (l_api_updating
123: and p_dsbld_cd
124: <> nvl(ben_edc_shd.g_old_rec.dsbld_cd,hr_api.g_varchar2)
125: or not l_api_updating) then
126: --
127: -- check if value of lookup falls within lookup type.
128: --

Line 130: if hr_api.not_exists_in_hr_lookups

126: --
127: -- check if value of lookup falls within lookup type.
128: --
129: --
130: if hr_api.not_exists_in_hr_lookups
131: (p_lookup_type => 'REGISTERED_DISABLED',
132: p_lookup_code => p_dsbld_cd,
133: p_effective_date => p_effective_date) then
134: --

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

197: p_effective_date => p_effective_date,
198: p_object_version_number => p_object_version_number);
199: --
200: if (l_api_updating
201: and nvl(p_cvg_thru_rl,hr_api.g_number)
202: <> ben_edc_shd.g_old_rec.cvg_thru_rl
203: or not l_api_updating)
204: and p_cvg_thru_rl is not null then
205: --

Line 278: <> nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)

274: p_object_version_number => p_object_version_number);
275: --
276: if (l_api_updating
277: and p_cvg_thru_cd
278: <> nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2)
279: or not l_api_updating)
280: and p_cvg_thru_cd is not null then
281: --
282: -- check if value of lookup falls within lookup type.

Line 284: if hr_api.not_exists_in_hr_lookups

280: and p_cvg_thru_cd is not null then
281: --
282: -- check if value of lookup falls within lookup type.
283: --
284: if hr_api.not_exists_in_hr_lookups
285: (p_lookup_type => 'BEN_DPNT_CVG_END',
286: p_lookup_code => p_cvg_thru_cd,
287: p_effective_date => p_effective_date) then
288: --

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

351: p_effective_date => p_effective_date,
352: p_object_version_number => p_object_version_number);
353: --
354: if (l_api_updating
355: and nvl(p_cvg_strt_rl,hr_api.g_number)
356: <> ben_edc_shd.g_old_rec.cvg_strt_rl
357: or not l_api_updating)
358: and p_cvg_strt_rl is not null then
359: --

Line 432: <> nvl(ben_edc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2)

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

Line 438: if hr_api.not_exists_in_hr_lookups

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

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

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

Line 508: nvl(ben_edc_shd.g_old_rec.cvg_strt_cd,hr_api.g_varchar2) or

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

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

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

Line 510: nvl(ben_edc_shd.g_old_rec.cvg_strt_rl,hr_api.g_number))

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

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

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

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

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

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

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

Line 587: nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or

583: --
584:
585: if (l_api_updating
586: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
587: nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
588: nvl(p_cvg_thru_rl, hr_api.g_number) <>
589: nvl(ben_edc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
590: or not l_api_updating) then
591:

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

584:
585: if (l_api_updating
586: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
587: nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
588: nvl(p_cvg_thru_rl, hr_api.g_number) <>
589: nvl(ben_edc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
590: or not l_api_updating) then
591:
592: --

Line 589: nvl(ben_edc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))

585: if (l_api_updating
586: and (nvl(p_cvg_thru_cd, hr_api.g_varchar2) <>
587: nvl(ben_edc_shd.g_old_rec.cvg_thru_cd,hr_api.g_varchar2) or
588: nvl(p_cvg_thru_rl, hr_api.g_number) <>
589: nvl(ben_edc_shd.g_old_rec.cvg_thru_rl,hr_api.g_number))
590: or not l_api_updating) then
591:
592: --
593: -- check dependency of Code and Rule.

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

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

Line 601: 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_67890_field_CWOR');
598: fnd_message.raise_error;
599: end if;
600:
601: 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_12345_field_CWOR');
603: fnd_message.raise_error;
604: end if;
605: end if;

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

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

Line 722: hr_api.mandatory_arg_error

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

Line 734: hr_api.mandatory_arg_error

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

Line 739: hr_api.mandatory_arg_error

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

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

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

Line 827: hr_api.mandatory_arg_error

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

Line 841: hr_api.mandatory_arg_error

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

Line 846: hr_api.mandatory_arg_error

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

Line 851: hr_api.mandatory_arg_error

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

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

894: --
895: -- Call all supporting business operations
896: --
897: --
898: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
899: --
900: chk_duplicate_rows
901: (p_elig_dsbld_stat_cvg_id => p_rec.elig_dsbld_stat_cvg_id,
902: p_dsbld_cd => p_rec.dsbld_cd,

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

974: --
975: -- Call all supporting business operations
976: --
977: --
978: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
979: --
980: chk_duplicate_rows
981: (p_elig_dsbld_stat_cvg_id => p_rec.elig_dsbld_stat_cvg_id,
982: p_dsbld_cd => p_rec.dsbld_cd,

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

1097: hr_utility.set_location('Entering:'|| l_proc, 10);
1098: --
1099: -- Ensure that all the mandatory parameter are not null
1100: --
1101: hr_api.mandatory_arg_error(p_api_name => l_proc,
1102: p_argument => 'elig_dsbld_stat_cvg_id',
1103: p_argument_value => p_elig_dsbld_stat_cvg_id);
1104: --
1105: open csr_leg_code;