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

Line 51: and nvl(p_pil_elctbl_chc_popl_id,hr_api.g_number)

47: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
48: p_object_version_number => p_object_version_number);
49: --
50: if (l_api_updating
51: and nvl(p_pil_elctbl_chc_popl_id,hr_api.g_number)
52: <> ben_pel_shd.g_old_rec.pil_elctbl_chc_popl_id) then
53: --
54: -- raise error as PK has changed
55: --

Line 124: <> nvl(ben_pel_shd.g_old_rec.uom,hr_api.g_varchar2)

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

Line 200: and nvl(p_per_in_ler_id,hr_api.g_number)

196: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
197: p_object_version_number => p_object_version_number);
198: --
199: if (l_api_updating
200: and nvl(p_per_in_ler_id,hr_api.g_number)
201: <> nvl(ben_pel_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
202: or not l_api_updating) then
203: --
204: -- check if per_in_ler_id value exists in ben_per_in_ler table

Line 201: <> nvl(ben_pel_shd.g_old_rec.per_in_ler_id,hr_api.g_number)

197: p_object_version_number => p_object_version_number);
198: --
199: if (l_api_updating
200: and nvl(p_per_in_ler_id,hr_api.g_number)
201: <> nvl(ben_pel_shd.g_old_rec.per_in_ler_id,hr_api.g_number)
202: or not l_api_updating) then
203: --
204: -- check if per_in_ler_id value exists in ben_per_in_ler table
205: --

Line 280: and nvl(p_lee_rsn_id,hr_api.g_number)

276: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and nvl(p_lee_rsn_id,hr_api.g_number)
281: <> nvl(ben_pel_shd.g_old_rec.lee_rsn_id,hr_api.g_number)
282: or not l_api_updating) then
283: --
284: -- check if lee_rsn_id value exists in ben_lee_rsn_f table

Line 281: <> nvl(ben_pel_shd.g_old_rec.lee_rsn_id,hr_api.g_number)

277: p_object_version_number => p_object_version_number);
278: --
279: if (l_api_updating
280: and nvl(p_lee_rsn_id,hr_api.g_number)
281: <> nvl(ben_pel_shd.g_old_rec.lee_rsn_id,hr_api.g_number)
282: or not l_api_updating) then
283: --
284: -- check if lee_rsn_id value exists in ben_lee_rsn_f table
285: --

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

351: (p_pil_elctbl_chc_popl_id => p_pil_elctbl_chc_popl_id,
352: p_object_version_number => p_object_version_number);
353: --
354: if ((l_api_updating
355: and nvl(p_enrt_perd_id,hr_api.g_number)
356: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_id,hr_api.g_number)) --Bug 4068639
357: or not l_api_updating) and
358: p_enrt_perd_id is not null then
359: --

Line 356: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_id,hr_api.g_number)) --Bug 4068639

352: p_object_version_number => p_object_version_number);
353: --
354: if ((l_api_updating
355: and nvl(p_enrt_perd_id,hr_api.g_number)
356: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_id,hr_api.g_number)) --Bug 4068639
357: or not l_api_updating) and
358: p_enrt_perd_id is not null then
359: --
360: -- check if enrt_perd_id value exists in ben_enrt_perd table

Line 428: <> nvl(ben_pel_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)

424: p_object_version_number => p_object_version_number);
425: --
426: if (l_api_updating
427: and p_enrt_typ_cycl_cd
428: <> nvl(ben_pel_shd.g_old_rec.enrt_typ_cycl_cd,hr_api.g_varchar2)
429: or not l_api_updating)
430: and p_enrt_typ_cycl_cd is not null then
431: --
432: -- check if value of lookup falls within lookup type.

Line 434: if hr_api.not_exists_in_hr_lookups

430: and p_enrt_typ_cycl_cd is not null then
431: --
432: -- check if value of lookup falls within lookup type.
433: --
434: if hr_api.not_exists_in_hr_lookups
435: (p_lookup_type => 'BEN_ENRT_TYP_CYCL',
436: p_lookup_code => p_enrt_typ_cycl_cd,
437: p_effective_date => p_effective_date) then
438: --

Line 498: <> nvl(ben_pel_shd.g_old_rec.ws_stat_cd,hr_api.g_varchar2)

494: p_object_version_number => p_object_version_number);
495: --
496: if (l_api_updating
497: and p_ws_stat_cd
498: <> nvl(ben_pel_shd.g_old_rec.ws_stat_cd,hr_api.g_varchar2)
499: or not l_api_updating)
500: and p_ws_stat_cd is not null then
501: --
502: -- check if value of lookup falls within lookup type.

Line 504: if hr_api.not_exists_in_hr_lookups

500: and p_ws_stat_cd is not null then
501: --
502: -- check if value of lookup falls within lookup type.
503: --
504: if hr_api.not_exists_in_hr_lookups
505: (p_lookup_type => 'BEN_WS_STAT',
506: p_lookup_code => p_ws_stat_cd,
507: p_effective_date => p_effective_date) then
508: --

Line 568: <> nvl(ben_pel_shd.g_old_rec.ws_acc_cd,hr_api.g_varchar2)

564: p_object_version_number => p_object_version_number);
565: --
566: if (l_api_updating
567: and p_ws_acc_cd
568: <> nvl(ben_pel_shd.g_old_rec.ws_acc_cd,hr_api.g_varchar2)
569: or not l_api_updating)
570: and p_ws_acc_cd is not null then
571: --
572: -- check if value of lookup falls within lookup type.

Line 574: if hr_api.not_exists_in_hr_lookups

570: and p_ws_acc_cd is not null then
571: --
572: -- check if value of lookup falls within lookup type.
573: --
574: if hr_api.not_exists_in_hr_lookups
575: (p_lookup_type => 'BEN_WS_ACC',
576: p_lookup_code => p_ws_acc_cd,
577: p_effective_date => p_effective_date) then
578: --

Line 638: <> nvl(ben_pel_shd.g_old_rec.bdgt_stat_cd,hr_api.g_varchar2)

634: p_object_version_number => p_object_version_number);
635: --
636: if (l_api_updating
637: and p_bdgt_stat_cd
638: <> nvl(ben_pel_shd.g_old_rec.bdgt_stat_cd,hr_api.g_varchar2)
639: or not l_api_updating)
640: and p_bdgt_stat_cd is not null then
641: --
642: -- check if value of lookup falls within lookup type.

Line 644: if hr_api.not_exists_in_hr_lookups

640: and p_bdgt_stat_cd is not null then
641: --
642: -- check if value of lookup falls within lookup type.
643: --
644: if hr_api.not_exists_in_hr_lookups
645: (p_lookup_type => 'BEN_BDGT_STAT',
646: p_lookup_code => p_bdgt_stat_cd,
647: p_effective_date => p_effective_date) then
648: --

Line 708: <> nvl(ben_pel_shd.g_old_rec.pop_cd,hr_api.g_varchar2)

704: p_object_version_number => p_object_version_number);
705: --
706: if (l_api_updating
707: and p_pop_cd
708: <> nvl(ben_pel_shd.g_old_rec.pop_cd,hr_api.g_varchar2)
709: or not l_api_updating)
710: and p_pop_cd is not null then
711: --
712: -- check if value of lookup falls within lookup type.

Line 714: if hr_api.not_exists_in_hr_lookups

710: and p_pop_cd is not null then
711: --
712: -- check if value of lookup falls within lookup type.
713: --
714: if hr_api.not_exists_in_hr_lookups
715: (p_lookup_type => 'BEN_POP',
716: p_lookup_code => p_pop_cd,
717: p_effective_date => p_effective_date) then
718: --

Line 778: <> nvl(ben_pel_shd.g_old_rec.bdgt_acc_cd,hr_api.g_varchar2)

774: p_object_version_number => p_object_version_number);
775: --
776: if (l_api_updating
777: and p_bdgt_acc_cd
778: <> nvl(ben_pel_shd.g_old_rec.bdgt_acc_cd,hr_api.g_varchar2)
779: or not l_api_updating)
780: and p_bdgt_acc_cd is not null then
781: --
782: -- check if value of lookup falls within lookup type.

Line 784: if hr_api.not_exists_in_hr_lookups

780: and p_bdgt_acc_cd is not null then
781: --
782: -- check if value of lookup falls within lookup type.
783: --
784: if hr_api.not_exists_in_hr_lookups
785: (p_lookup_type => 'BEN_BDGT_ACC',
786: p_lookup_code => p_bdgt_acc_cd,
787: p_effective_date => p_effective_date) then
788: --

Line 848: <> nvl(ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)

844: p_object_version_number => p_object_version_number);
845: --
846: if (l_api_updating
847: and p_cls_enrt_dt_to_use_cd
848: <> nvl(ben_pel_shd.g_old_rec.cls_enrt_dt_to_use_cd,hr_api.g_varchar2)
849: or not l_api_updating)
850: and p_cls_enrt_dt_to_use_cd is not null then
851: --
852: -- check if value of lookup falls within lookup type.

Line 854: if hr_api.not_exists_in_hr_lookups

850: and p_cls_enrt_dt_to_use_cd is not null then
851: --
852: -- check if value of lookup falls within lookup type.
853: --
854: if hr_api.not_exists_in_hr_lookups
855: (p_lookup_type => 'BEN_CLS_ENRT_DT_TO_USE',
856: p_lookup_code => p_cls_enrt_dt_to_use_cd,
857: p_effective_date => p_effective_date) then
858: --

Line 918: <> nvl(ben_pel_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)

914: p_object_version_number => p_object_version_number);
915: --
916: if (l_api_updating
917: and p_acty_ref_perd_cd
918: <> nvl(ben_pel_shd.g_old_rec.acty_ref_perd_cd,hr_api.g_varchar2)
919: or not l_api_updating)
920: and p_acty_ref_perd_cd is not null then
921: --
922: -- check if value of lookup falls within lookup type.

Line 924: if hr_api.not_exists_in_hr_lookups

920: and p_acty_ref_perd_cd is not null then
921: --
922: -- check if value of lookup falls within lookup type.
923: --
924: if hr_api.not_exists_in_hr_lookups
925: (p_lookup_type => 'BEN_ACTY_REF_PERD',
926: p_lookup_code => p_acty_ref_perd_cd,
927: p_effective_date => p_effective_date) then
928: --

Line 988: <> nvl(ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd,hr_api.g_varchar2)

984: p_object_version_number => p_object_version_number);
985: --
986: if (l_api_updating
987: and p_pil_elctbl_popl_stat_cd
988: <> nvl(ben_pel_shd.g_old_rec.pil_elctbl_popl_stat_cd,hr_api.g_varchar2)
989: or not l_api_updating)
990: and p_pil_elctbl_popl_stat_cd is not null then
991: --
992: -- check if value of lookup falls within lookup type.

Line 994: if hr_api.not_exists_in_hr_lookups

990: and p_pil_elctbl_popl_stat_cd is not null then
991: --
992: -- check if value of lookup falls within lookup type.
993: --
994: if hr_api.not_exists_in_hr_lookups
995: (p_lookup_type => 'BEN_PER_IN_LER_STAT',
996: p_lookup_code => p_pil_elctbl_popl_stat_cd,
997: p_effective_date => p_effective_date) then
998: --

Line 1033: <> nvl(ben_pel_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)

1029: p_object_version_number => p_object_version_number);
1030: --
1031: if (l_api_updating
1032: and p_reinstate_cd
1033: <> nvl(ben_pel_shd.g_old_rec.reinstate_cd,hr_api.g_varchar2)
1034: or not l_api_updating)
1035: and p_reinstate_cd is not null then
1036: --
1037: -- check if value of lookup falls within lookup type.

Line 1039: if hr_api.not_exists_in_hr_lookups

1035: and p_reinstate_cd is not null then
1036: --
1037: -- check if value of lookup falls within lookup type.
1038: --
1039: if hr_api.not_exists_in_hr_lookups
1040: (p_lookup_type => 'BEN_REINSTATE',
1041: p_lookup_code => p_reinstate_cd,
1042: p_effective_date => p_effective_date) then
1043: --

Line 1078: <> nvl(ben_pel_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)

1074: p_object_version_number => p_object_version_number);
1075: --
1076: if (l_api_updating
1077: and p_reinstate_ovrdn_cd
1078: <> nvl(ben_pel_shd.g_old_rec.reinstate_ovrdn_cd,hr_api.g_varchar2)
1079: or not l_api_updating)
1080: and p_reinstate_ovrdn_cd is not null then
1081: --
1082: -- check if value of lookup falls within lookup type.

Line 1084: if hr_api.not_exists_in_hr_lookups

1080: and p_reinstate_ovrdn_cd is not null then
1081: --
1082: -- check if value of lookup falls within lookup type.
1083: --
1084: if hr_api.not_exists_in_hr_lookups
1085: (p_lookup_type => 'BEN_REINSTATE_OVRDN',
1086: p_lookup_code => p_reinstate_ovrdn_cd,
1087: p_effective_date => p_effective_date) then
1088: --

Line 1183: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_end_dt,hr_api.g_date)) then

1179: --
1180: -- hr_utility.set_location('Me here :'||l_proc, 8);
1181: if (l_api_updating
1182: and p_enrt_perd_end_dt
1183: <> nvl(ben_pel_shd.g_old_rec.enrt_perd_end_dt,hr_api.g_date)) then
1184: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1185: /*
1186: if (trunc(p_enrt_perd_end_dt) < trunc(l_system_date)) then
1187: fnd_message.set_name('BEN','BEN_92298_ENRT_PEREND_LT_SYSD');

Line 1202: <> nvl(ben_pel_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date)) then

1198: -- hr_utility.set_location('Me here :'||l_proc, 10);
1199: --
1200: if (l_api_updating
1201: and p_dflt_enrt_dt
1202: <> nvl(ben_pel_shd.g_old_rec.dflt_enrt_dt,hr_api.g_date)) then
1203: If p_pil_elctbl_popl_stat_cd = 'STRTD' then
1204: If p_dflt_asnd_dt is not null then
1205: fnd_message.set_name('BEN','BEN_92295_DFLT_ENRT_W_ASND');
1206: fnd_message.raise_error;

Line 1292: <> nvl(ben_pel_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then

1288:
1289: hr_utility.set_location(' Entering:'||l_proc, 10);
1290:
1291: if (p_ws_mgr_id
1292: <> nvl(ben_pel_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then
1293:
1294: open c1;
1295: fetch c1 into l_person1,l_person2;
1296: if c1%found then

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

1326: /*
1327: --
1328: -- Call all supporting business operations
1329: --
1330: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1331: */
1332: --
1333: chk_pil_elctbl_chc_popl_id
1334: (p_pil_elctbl_chc_popl_id => p_rec.pil_elctbl_chc_popl_id,

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

1447: /*
1448: --
1449: -- Call all supporting business operations
1450: --
1451: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1452: */
1453: --
1454: chk_pil_elctbl_chc_popl_id
1455: (p_pil_elctbl_chc_popl_id => p_rec.pil_elctbl_chc_popl_id,

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

1610: hr_utility.set_location('Entering:'|| l_proc, 10);
1611: --
1612: -- Ensure that all the mandatory parameter are not null
1613: --
1614: hr_api.mandatory_arg_error(p_api_name => l_proc,
1615: p_argument => 'pil_elctbl_chc_popl_id',
1616: p_argument_value => p_pil_elctbl_chc_popl_id);
1617: --
1618: open csr_leg_code;