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

Line 240: if p_computed_Date <= hr_api.g_sot then

236:
237: end if;
238:
239: if l_formula_type_id in (-27,-28,-29,-30,-504,-503,-66,-67) then
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );

Line 243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));

239: if l_formula_type_id in (-27,-28,-29,-30,-504,-503,-66,-67) then
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'

Line 250: ,p_parmb => fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2)

246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'
248: ,p_message_name => l_message_name1
249: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
250: ,p_parmb => fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2)
251: ,p_parmc => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
252: ,p_person_id => p_person_id
253: );
254: elsif p_computed_Date >= hr_api.g_eot then

Line 254: elsif p_computed_Date >= hr_api.g_eot then

250: ,p_parmb => fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2)
251: ,p_parmc => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
252: ,p_person_id => p_person_id
253: );
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );

Line 257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));

253: );
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'

Line 264: ,p_parmb => fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2)

260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'
262: ,p_message_name => l_message_name2
263: ,p_parma => l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
264: ,p_parmb => fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2)
265: ,p_parmc => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
266: ,p_person_id => p_person_id
267: );
268:

Line 1002: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

998: and pen.effective_end_date
999: --
1000: -- Bug 4309203 Modified the effective_end_date to enrt_cvg_thru_dt as
1001: -- effective_end_date would pick up invalid records.
1002: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;
1003: --
1004: /*
1005: cursor c_prtt_rt_val_dts is
1006: select prv.rt_strt_dt,

Line 1100: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1096: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
1097: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)
1098: --and pen.pl_typ_id = l_pl_typ_id
1099: and pen.business_group_id = l_business_group_id
1100: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1101: and not exists
1102: (select '1' from ben_prtt_enrt_rslt_f pen1
1103: where pen.prtt_enrt_rslt_id = pen1.RPLCS_SSPNDD_RSLT_ID
1104: and pen1.per_in_ler_id = c_per_in_ler_id);

Line 1118: and pen.enrt_cvg_thru_dt = hr_api.g_eot

1114: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
1115: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)
1116: --and pen.pl_typ_id = l_pl_typ_id
1117: and pen.business_group_id = l_business_group_id
1118: and pen.enrt_cvg_thru_dt = hr_api.g_eot
1119: and prv.per_in_ler_id = c_per_in_ler_id
1120: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
1121: and not exists
1122: (select '1' from ben_prtt_enrt_rslt_f pen1

Line 1546: if l_enrt_cvg_end_dt <> hr_api.g_eot then

1542:
1543: elsif p_date_cd = 'LDPPFEE' or p_date_cd = 'LDPPOAEE'
1544: then
1545: -- End of Pay Period (On or) After
1546: if l_enrt_cvg_end_dt <> hr_api.g_eot then
1547: --
1548: if g_debug then
1549: hr_utility.set_location(' Step 2 ' ,19);
1550: end if;

Line 1579: if l_enrt_cvg_end_dt <> hr_api.g_eot then

1575: l_end_date := l_enrt_cvg_end_dt ;
1576: end if ;
1577:
1578: --
1579: if l_enrt_cvg_end_dt <> hr_api.g_eot then
1580: --
1581: if l_end_date = l_enrt_cvg_end_dt then
1582: if p_date_cd = 'LDPPFEE' then
1583: -- End of Pay Period After

Line 2874: if sysdate > nvl(l_lf_evt_ocrd_dt,hr_api.g_sot) then

2870: elsif p_date_cd = 'LOR' then
2871: --
2872: -- hr_utility.set_location('Entering LOR',10);
2873: --
2874: if sysdate > nvl(l_lf_evt_ocrd_dt,hr_api.g_sot) then
2875: p_returned_date := sysdate;
2876: else
2877: p_returned_date := p_effective_date;
2878: end if;

Line 2911: if sysdate > (nvl(l_lf_evt_ocrd_dt,hr_api.g_sot) + 1) then

2907: elsif p_date_cd = 'LDAOR' then
2908: --
2909: -- hr_utility.set_location('Entering LDAOR',10);
2910: --
2911: if sysdate > (nvl(l_lf_evt_ocrd_dt,hr_api.g_sot) + 1) then
2912: p_returned_date := sysdate;
2913: else
2914: p_returned_date := p_effective_date + 1;
2915: end if;

Line 4601: if nvl(l_procg_end_dt,hr_api.g_sot) > nvl(l_enrt_end_dt,hr_api.g_sot) then

4597: end if;
4598: --
4599: close c_pil_popl;
4600: --
4601: if nvl(l_procg_end_dt,hr_api.g_sot) > nvl(l_enrt_end_dt,hr_api.g_sot) then
4602: l_enrt_end_dt := l_procg_end_dt;
4603: end if;
4604: --
4605: p_returned_date := l_enrt_end_dt;

Line 7503: and pen.enrt_cvg_thru_dt = hr_api.g_eot

7499: and nvl(pen.pgm_id,-1)=nvl(l_pgm_id,-1)
7500: and nvl(pen.oipl_id,-1)=nvl(l_oipl_id,-1)
7501: --and pen.pl_typ_id = l_pl_typ_id
7502: and pen.business_group_id = p_business_group_id
7503: and pen.enrt_cvg_thru_dt = hr_api.g_eot
7504: and prv.per_in_ler_id = c_per_in_ler_id
7505: and prv.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
7506: and not exists
7507: (select '1' from ben_prtt_enrt_rslt_f pen1