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 FND_DATE

Line 242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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 );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning

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 249: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)

245: benutils.write(p_text=>fnd_message.get);
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: );

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 256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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 );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning

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 263: ,p_parma => l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)

259: benutils.write(p_text=>fnd_message.get);
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: );

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 272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

268:
269: elsif l_formula_type_id in (-29,-66,-67) then
270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning

Line 274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'
278: ,p_message_name => l_message_name3

Line 279: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)

275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'
278: ,p_message_name => l_message_name3
279: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
280: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
281: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
282: ,p_person_id => p_person_id
283: );

Line 281: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)

277: (p_application_short_name => 'BEN'
278: ,p_message_name => l_message_name3
279: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
280: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
281: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
282: ,p_person_id => p_person_id
283: );
284: end if;
285:

Line 291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

287:
288: elsif l_formula_type_id in (-27,-28) then
289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
294:
295: g_dep_rec.text := fnd_message.get;

Line 293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';
297: g_dep_rec.error_message_code :='BEN_93964_ENRO_DT_LT_LE_OCD_DT';

Line 308: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)

304: benutils.write(p_rec=>g_dep_rec);
305: ben_warnings.load_warning
306: (p_application_short_name => 'BEN'
307: ,p_message_name => l_message_name3
308: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
309: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
310: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
311: ,p_person_id => p_person_id
312: );

Line 310: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)

306: (p_application_short_name => 'BEN'
307: ,p_message_name => l_message_name3
308: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
309: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
310: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
311: ,p_person_id => p_person_id
312: );
313: end if;
314:

Line 321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

317: --Bug 5076010
318: elsif l_formula_type_id = -30 then
319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
324:
325: benutils.write(p_text=>fnd_message.get);

Line 323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
327: (p_application_short_name => 'BEN'

Line 329: ,p_parma => substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)

325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
327: (p_application_short_name => 'BEN'
328: ,p_message_name => l_message_name3
329: ,p_parma => substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
330: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
331: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
332: ,p_person_id => p_person_id
333: );

Line 331: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)

327: (p_application_short_name => 'BEN'
328: ,p_message_name => l_message_name3
329: ,p_parma => substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
330: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
331: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
332: ,p_person_id => p_person_id
333: );
334: end if;
335: --Bug 5076010

Line 343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

339: fetch c_mode into l_dummy;
340: if c_mode%found then
341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
346:
347: benutils.write(p_text=>fnd_message.get);

Line 345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
349: (p_application_short_name => 'BEN'

Line 351: ,p_parma => l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)

347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
349: (p_application_short_name => 'BEN'
350: ,p_message_name => l_message_name3
351: ,p_parma => l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
352: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
353: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
354: ,p_person_id => p_person_id);
355: end if;

Line 353: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)

349: (p_application_short_name => 'BEN'
350: ,p_message_name => l_message_name3
351: ,p_parma => l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2)
352: ,p_parmb => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
353: ,p_parmc => fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2)
354: ,p_person_id => p_person_id);
355: end if;
356: end if;
357: --

Line 5631: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))

5627: ,p_param1 => p_param1
5628: ,p_param1_value => p_param1_value
5629: -- FONM
5630: ,p_param2 => 'BEN_IV_RT_STRT_DT'
5631: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))
5632: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
5633: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))
5634: ,p_param4 => 'BEN_IV_PERSON_ID' -- Bug 5331889
5635: ,p_param4_value => to_char(p_person_id)

Line 5633: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))

5629: -- FONM
5630: ,p_param2 => 'BEN_IV_RT_STRT_DT'
5631: ,p_param2_value => fnd_date.date_to_canonical(nvl(p_fonm_rt_strt_dt,ben_manage_life_events.g_fonm_rt_strt_dt))
5632: ,p_param3 => 'BEN_IV_CVG_STRT_DT'
5633: ,p_param3_value => fnd_date.date_to_canonical(nvl(p_fonm_cvg_strt_dt,ben_manage_life_events.g_fonm_cvg_strt_dt))
5634: ,p_param4 => 'BEN_IV_PERSON_ID' -- Bug 5331889
5635: ,p_param4_value => to_char(p_person_id)
5636: ,p_jurisdiction_code => l_jurisdiction_code);
5637: --

Line 5639: p_returned_date := fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);

5635: ,p_param4_value => to_char(p_person_id)
5636: ,p_jurisdiction_code => l_jurisdiction_code);
5637: --
5638:
5639: p_returned_date := fnd_date.canonical_to_date(l_outputs(l_outputs.first).value);
5640:
5641: if g_debug then
5642: hr_utility.set_location ('p_returned_date='||p_returned_date,1689);
5643: end if;