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));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
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));

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));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
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)

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)
250: ,p_parmb => fnd_date.date_to_displaydate(hr_api.g_sot)
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)
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));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
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));

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));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
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)

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)
264: ,p_parmb => fnd_date.date_to_displaydate(hr_api.g_eot)
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 1000: and pen.enrt_cvg_thru_dt = hr_api.g_eot ;

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

Line 1481: if l_enrt_cvg_end_dt <> hr_api.g_eot then

1477:
1478: elsif p_date_cd = 'LDPPFEE' or p_date_cd = 'LDPPOAEE'
1479: then
1480: -- End of Pay Period (On or) After
1481: if l_enrt_cvg_end_dt <> hr_api.g_eot then
1482: --
1483: if g_debug then
1484: hr_utility.set_location(' Step 2 ' ,19);
1485: end if;

Line 1514: if l_enrt_cvg_end_dt <> hr_api.g_eot then

1510: l_end_date := l_enrt_cvg_end_dt ;
1511: end if ;
1512:
1513: --
1514: if l_enrt_cvg_end_dt <> hr_api.g_eot then
1515: --
1516: if l_end_date = l_enrt_cvg_end_dt then
1517: if p_date_cd = 'LDPPFEE' then
1518: -- End of Pay Period After

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

2772: elsif p_date_cd = 'LOR' then
2773: --
2774: -- hr_utility.set_location('Entering LOR',10);
2775: --
2776: if sysdate > nvl(l_lf_evt_ocrd_dt,hr_api.g_sot) then
2777: p_returned_date := sysdate;
2778: else
2779: p_returned_date := p_effective_date;
2780: end if;

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

2809: elsif p_date_cd = 'LDAOR' then
2810: --
2811: -- hr_utility.set_location('Entering LDAOR',10);
2812: --
2813: if sysdate > (nvl(l_lf_evt_ocrd_dt,hr_api.g_sot) + 1) then
2814: p_returned_date := sysdate;
2815: else
2816: p_returned_date := p_effective_date + 1;
2817: end if;

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

4499: end if;
4500: --
4501: close c_pil_popl;
4502: --
4503: if nvl(l_procg_end_dt,hr_api.g_sot) > nvl(l_enrt_end_dt,hr_api.g_sot) then
4504: l_enrt_end_dt := l_procg_end_dt;
4505: end if;
4506: --
4507: p_returned_date := l_enrt_end_dt;