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

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

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

Line 124: and nvl(p_dflt_enrt_rl,hr_api.g_number)

120: p_effective_date => p_effective_date,
121: p_object_version_number => p_object_version_number);
122: --
123: if (l_api_updating
124: and nvl(p_dflt_enrt_rl,hr_api.g_number)
125: <> ben_lge_shd.g_old_rec.dflt_enrt_rl
126: or not l_api_updating)
127: and p_dflt_enrt_rl is not null then
128: --

Line 197: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)

193: p_object_version_number => p_object_version_number);
194: --
195: if (l_api_updating
196: and p_dflt_enrt_cd
197: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2)
198: or not l_api_updating)
199: and p_dflt_enrt_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.

Line 203: if hr_api.not_exists_in_hr_lookups

199: and p_dflt_enrt_cd is not null then
200: --
201: -- check if value of lookup falls within lookup type.
202: --
203: if hr_api.not_exists_in_hr_lookups
204: (p_lookup_type => 'BEN_DFLT_ENRT',
205: p_lookup_code => p_dflt_enrt_cd,
206: p_effective_date => p_effective_date) then
207: --

Line 268: <> nvl(ben_lge_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)

264: p_object_version_number => p_object_version_number);
265: --
266: if (l_api_updating
267: and p_crnt_enrt_prclds_chg_flag
268: <> nvl(ben_lge_shd.g_old_rec.crnt_enrt_prclds_chg_flag,hr_api.g_varchar2)
269: or not l_api_updating) then
270: --
271: -- check if value of lookup falls within lookup type.
272: --

Line 274: if hr_api.not_exists_in_hr_lookups

270: --
271: -- check if value of lookup falls within lookup type.
272: --
273: --
274: if hr_api.not_exists_in_hr_lookups
275: (p_lookup_type => 'YES_NO',
276: p_lookup_code => p_crnt_enrt_prclds_chg_flag,
277: p_effective_date => p_effective_date) then
278: --

Line 339: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)

335: p_effective_date => p_effective_date,
336: p_object_version_number => p_object_version_number);
337: --
338: if (l_api_updating
339: and nvl(p_auto_enrt_mthd_rl,hr_api.g_number)
340: <> ben_lge_shd.g_old_rec.auto_enrt_mthd_rl
341: or not l_api_updating)
342: and p_auto_enrt_mthd_rl is not null then
343: --

Line 412: <> nvl(ben_lge_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)

408: p_object_version_number => p_object_version_number);
409: --
410: if (l_api_updating
411: and p_enrt_mthd_cd
412: <> nvl(ben_lge_shd.g_old_rec.enrt_mthd_cd,hr_api.g_varchar2)
413: or not l_api_updating)
414: and p_enrt_mthd_cd is not null then
415: --
416: -- check if value of lookup falls within lookup type.

Line 418: if hr_api.not_exists_in_hr_lookups

414: and p_enrt_mthd_cd is not null then
415: --
416: -- check if value of lookup falls within lookup type.
417: --
418: if hr_api.not_exists_in_hr_lookups
419: (p_lookup_type => 'BEN_ENRT_MTHD',
420: p_lookup_code => p_enrt_mthd_cd,
421: p_effective_date => p_effective_date) then
422: --

Line 483: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)

479: p_object_version_number => p_object_version_number);
480: --
481: if (l_api_updating
482: and p_enrt_cd
483: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2)
484: or not l_api_updating)
485: and p_enrt_cd is not null then
486: --
487: -- check if value of lookup falls within lookup type.

Line 489: if hr_api.not_exists_in_hr_lookups

485: and p_enrt_cd is not null then
486: --
487: -- check if value of lookup falls within lookup type.
488: --
489: if hr_api.not_exists_in_hr_lookups
490: (p_lookup_type => 'BEN_ENRT',
491: p_lookup_code => p_enrt_cd,
492: p_effective_date => p_effective_date) then
493: --

Line 554: <> nvl(ben_lge_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)

550: p_object_version_number => p_object_version_number);
551: --
552: if (l_api_updating
553: and p_stl_elig_cant_chg_flag
554: <> nvl(ben_lge_shd.g_old_rec.stl_elig_cant_chg_flag,hr_api.g_varchar2)
555: or not l_api_updating) then
556: --
557: -- check if value of lookup falls within lookup type.
558: --

Line 560: if hr_api.not_exists_in_hr_lookups

556: --
557: -- check if value of lookup falls within lookup type.
558: --
559: --
560: if hr_api.not_exists_in_hr_lookups
561: (p_lookup_type => 'YES_NO',
562: p_lookup_code => p_stl_elig_cant_chg_flag,
563: p_effective_date => p_effective_date) then
564: --

Line 625: and nvl(p_enrt_rl,hr_api.g_number)

621: p_effective_date => p_effective_date,
622: p_object_version_number => p_object_version_number);
623: --
624: if (l_api_updating
625: and nvl(p_enrt_rl,hr_api.g_number)
626: <> ben_lge_shd.g_old_rec.enrt_rl
627: or not l_api_updating)
628: and p_enrt_rl is not null then
629: --

Line 706: (nvl(p_enrt_cd,hr_api.g_varchar2)

702: p_object_version_number => p_object_version_number);
703: --
704: if (l_api_updating
705: and
706: (nvl(p_enrt_cd,hr_api.g_varchar2)
707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or
708: nvl(p_enrt_rl,hr_api.g_number)
709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))
710:

Line 707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or

703: --
704: if (l_api_updating
705: and
706: (nvl(p_enrt_cd,hr_api.g_varchar2)
707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or
708: nvl(p_enrt_rl,hr_api.g_number)
709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))
710:
711: or not l_api_updating) then

Line 708: nvl(p_enrt_rl,hr_api.g_number)

704: if (l_api_updating
705: and
706: (nvl(p_enrt_cd,hr_api.g_varchar2)
707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or
708: nvl(p_enrt_rl,hr_api.g_number)
709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))
710:
711: or not l_api_updating) then
712: --

Line 709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))

705: and
706: (nvl(p_enrt_cd,hr_api.g_varchar2)
707: <> nvl(ben_lge_shd.g_old_rec.enrt_cd,hr_api.g_varchar2) or
708: nvl(p_enrt_rl,hr_api.g_number)
709: <> nvl(ben_lge_shd.g_old_rec.enrt_rl,hr_api.g_number))
710:
711: or not l_api_updating) then
712: --
713: if (p_enrt_cd = 'RL' and p_enrt_rl is null) then

Line 720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is

716: fnd_message.raise_error;
717: --
718: end if;
719: --
720: if nvl(p_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_enrt_rl is
721: not null then
722: --
723: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
724: fnd_message.raise_error;

Line 732: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)

728: end if;
729: --
730: if (l_api_updating
731: and
732: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
734: nvl(p_dflt_enrt_rl,hr_api.g_number)
735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))
736:

Line 733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or

729: --
730: if (l_api_updating
731: and
732: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
734: nvl(p_dflt_enrt_rl,hr_api.g_number)
735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))
736:
737: or not l_api_updating) then

Line 734: nvl(p_dflt_enrt_rl,hr_api.g_number)

730: if (l_api_updating
731: and
732: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
734: nvl(p_dflt_enrt_rl,hr_api.g_number)
735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))
736:
737: or not l_api_updating) then
738: --

Line 735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))

731: and
732: (nvl(p_dflt_enrt_cd,hr_api.g_varchar2)
733: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_cd,hr_api.g_varchar2) or
734: nvl(p_dflt_enrt_rl,hr_api.g_number)
735: <> nvl(ben_lge_shd.g_old_rec.dflt_enrt_rl,hr_api.g_number))
736:
737: or not l_api_updating) then
738: --
739: if (p_dflt_enrt_cd = 'RL' and p_dflt_enrt_rl is null) then

Line 746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is

742: fnd_message.raise_error;
743: --
744: end if;
745: --
746: if nvl(p_dflt_enrt_cd,hr_api.g_varchar2) <> 'RL' and p_dflt_enrt_rl is
747: not null then
748: --
749: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
750: fnd_message.raise_error;

Line 789: (p_ler_id in number default hr_api.g_number,

785: --
786: -- {End Of Comments}
787: -- ----------------------------------------------------------------------------
788: Procedure dt_update_validate
789: (p_ler_id in number default hr_api.g_number,
790: p_pgm_id in number default hr_api.g_number,
791: p_datetrack_mode in varchar2,
792: p_validation_start_date in date,
793: p_validation_end_date in date) Is

Line 790: p_pgm_id in number default hr_api.g_number,

786: -- {End Of Comments}
787: -- ----------------------------------------------------------------------------
788: Procedure dt_update_validate
789: (p_ler_id in number default hr_api.g_number,
790: p_pgm_id in number default hr_api.g_number,
791: p_datetrack_mode in varchar2,
792: p_validation_start_date in date,
793: p_validation_end_date in date) Is
794: --

Line 804: hr_api.mandatory_arg_error

800: hr_utility.set_location('Entering:'||l_proc, 5);
801: --
802: -- Ensure that the p_datetrack_mode argument is not null
803: --
804: hr_api.mandatory_arg_error
805: (p_api_name => l_proc,
806: p_argument => 'datetrack_mode',
807: p_argument_value => p_datetrack_mode);
808: --

Line 816: hr_api.mandatory_arg_error

812: --
813: --
814: -- Ensure the arguments are not null
815: --
816: hr_api.mandatory_arg_error
817: (p_api_name => l_proc,
818: p_argument => 'validation_start_date',
819: p_argument_value => p_validation_start_date);
820: --

Line 821: hr_api.mandatory_arg_error

817: (p_api_name => l_proc,
818: p_argument => 'validation_start_date',
819: p_argument_value => p_validation_start_date);
820: --
821: hr_api.mandatory_arg_error
822: (p_api_name => l_proc,
823: p_argument => 'validation_end_date',
824: p_argument_value => p_validation_end_date);
825: --

Line 826: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and

822: (p_api_name => l_proc,
823: p_argument => 'validation_end_date',
824: p_argument_value => p_validation_end_date);
825: --
826: If ((nvl(p_ler_id, hr_api.g_number) <> hr_api.g_number) and
827: NOT (dt_api.check_min_max_dates
828: (p_base_table_name => 'ben_ler_f',
829: p_base_key_column => 'ler_id',
830: p_base_key_value => p_ler_id,

Line 836: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and

832: p_to_date => p_validation_end_date))) Then
833: l_table_name := 'ben_ler_f';
834: Raise l_integrity_error;
835: End If;
836: If ((nvl(p_pgm_id, hr_api.g_number) <> hr_api.g_number) and
837: NOT (dt_api.check_min_max_dates
838: (p_base_table_name => 'ben_pgm_f',
839: p_base_key_column => 'pgm_id',
840: p_base_key_value => p_pgm_id,

Line 919: hr_api.mandatory_arg_error

915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: -- Ensure that the p_datetrack_mode argument is not null
918: --
919: hr_api.mandatory_arg_error
920: (p_api_name => l_proc,
921: p_argument => 'datetrack_mode',
922: p_argument_value => p_datetrack_mode);
923: --

Line 933: hr_api.mandatory_arg_error

929: --
930: --
931: -- Ensure the arguments are not null
932: --
933: hr_api.mandatory_arg_error
934: (p_api_name => l_proc,
935: p_argument => 'validation_start_date',
936: p_argument_value => p_validation_start_date);
937: --

Line 938: hr_api.mandatory_arg_error

934: (p_api_name => l_proc,
935: p_argument => 'validation_start_date',
936: p_argument_value => p_validation_start_date);
937: --
938: hr_api.mandatory_arg_error
939: (p_api_name => l_proc,
940: p_argument => 'validation_end_date',
941: p_argument_value => p_validation_end_date);
942: --

Line 943: hr_api.mandatory_arg_error

939: (p_api_name => l_proc,
940: p_argument => 'validation_end_date',
941: p_argument_value => p_validation_end_date);
942: --
943: hr_api.mandatory_arg_error
944: (p_api_name => l_proc,
945: p_argument => 'ler_chg_pgm_enrt_id',
946: p_argument_value => p_ler_chg_pgm_enrt_id);
947: --

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

987: --
988: -- Call all supporting business operations
989: --
990: --
991: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
992: --
993: chk_ler_chg_pgm_enrt_id
994: (p_ler_chg_pgm_enrt_id => p_rec.ler_chg_pgm_enrt_id,
995: p_effective_date => p_effective_date,

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

1075: --
1076: -- Call all supporting business operations
1077: --
1078: --
1079: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1080: --
1081: chk_ler_chg_pgm_enrt_id
1082: (p_ler_chg_pgm_enrt_id => p_rec.ler_chg_pgm_enrt_id,
1083: p_effective_date => p_effective_date,

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

1208: hr_utility.set_location('Entering:'|| l_proc, 10);
1209: --
1210: -- Ensure that all the mandatory parameter are not null
1211: --
1212: hr_api.mandatory_arg_error(p_api_name => l_proc,
1213: p_argument => 'ler_chg_pgm_enrt_id',
1214: p_argument_value => p_ler_chg_pgm_enrt_id);
1215: --
1216: open csr_leg_code;