APPS.BEN_DET_IMPUTED_INCOME dependencies on HR_UTILITY

Line 61: hr_utility.set_location(' Entering: '||l_proc , 11);

57: l_proc varchar2(72) := g_package||'delete_past_imp';
58:
59: BEGIN
60:
61: hr_utility.set_location(' Entering: '||l_proc , 11);
62:
63: -- get the imputed income plan
64: open c_imp_inc_plan(p_imptd_incm_calc_cd, p_business_group_id, p_effective_date);
65: fetch c_imp_inc_plan into l_pl_id;

Line 69: hr_utility.set_location (' l_pl_id '||l_pl_id, 2);

65: fetch c_imp_inc_plan into l_pl_id;
66: close c_imp_inc_plan;
67:
68: -- Now, we need to pick up the PRVs starting before the above earliest coverage start date of plan subject to imp inc
69: hr_utility.set_location (' l_pl_id '||l_pl_id, 2);
70: hr_utility.set_location (' p_per_in_ler_id '||p_per_in_ler_id, 2);
71:
72: open c_del_imp_inc_rt (p_per_in_ler_id);
73: fetch c_del_imp_inc_rt bulk collect into l_imp_inc_rt_tab;

Line 70: hr_utility.set_location (' p_per_in_ler_id '||p_per_in_ler_id, 2);

66: close c_imp_inc_plan;
67:
68: -- Now, we need to pick up the PRVs starting before the above earliest coverage start date of plan subject to imp inc
69: hr_utility.set_location (' l_pl_id '||l_pl_id, 2);
70: hr_utility.set_location (' p_per_in_ler_id '||p_per_in_ler_id, 2);
71:
72: open c_del_imp_inc_rt (p_per_in_ler_id);
73: fetch c_del_imp_inc_rt bulk collect into l_imp_inc_rt_tab;
74: close c_del_imp_inc_rt;

Line 76: hr_utility.set_location('l_imp_inc_rt_tab.count: '||l_imp_inc_rt_tab.count,6080);

72: open c_del_imp_inc_rt (p_per_in_ler_id);
73: fetch c_del_imp_inc_rt bulk collect into l_imp_inc_rt_tab;
74: close c_del_imp_inc_rt;
75:
76: hr_utility.set_location('l_imp_inc_rt_tab.count: '||l_imp_inc_rt_tab.count,6080);
77:
78: if l_imp_inc_rt_tab.count > 0 then
79: for r in l_imp_inc_rt_tab.first..l_imp_inc_rt_tab.last
80: loop

Line 81: hr_utility.set_location (' delete past rate prv', 2);

77:
78: if l_imp_inc_rt_tab.count > 0 then
79: for r in l_imp_inc_rt_tab.first..l_imp_inc_rt_tab.last
80: loop
81: hr_utility.set_location (' delete past rate prv', 2);
82: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);
83:
84: -- Nullify the prv_id on enrt_rt
85: update ben_enrt_rt set prtt_rt_val_id = NULL

Line 82: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);

78: if l_imp_inc_rt_tab.count > 0 then
79: for r in l_imp_inc_rt_tab.first..l_imp_inc_rt_tab.last
80: loop
81: hr_utility.set_location (' delete past rate prv', 2);
82: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);
83:
84: -- Nullify the prv_id on enrt_rt
85: update ben_enrt_rt set prtt_rt_val_id = NULL
86: where prtt_rt_val_id = nvl(l_imp_inc_rt_tab(r).prtt_rt_val_id,-1);

Line 88: hr_utility.set_location (' l_imp_inc_rt_tab(r).rt_strt_dt '||l_imp_inc_rt_tab(r).rt_strt_dt, 2);

84: -- Nullify the prv_id on enrt_rt
85: update ben_enrt_rt set prtt_rt_val_id = NULL
86: where prtt_rt_val_id = nvl(l_imp_inc_rt_tab(r).prtt_rt_val_id,-1);
87:
88: hr_utility.set_location (' l_imp_inc_rt_tab(r).rt_strt_dt '||l_imp_inc_rt_tab(r).rt_strt_dt, 2);
89: -- delete the rate
90: ben_prtt_rt_val_api.delete_prtt_rt_val
91: (p_validate => false
92: ,p_prtt_rt_val_id => l_imp_inc_rt_tab(r).prtt_rt_val_id

Line 100: hr_utility.set_location(' Leaving: '||l_proc , 20);

96: ,p_object_version_number => l_imp_inc_rt_tab(r).object_version_number
97: ,p_effective_date => l_imp_inc_rt_tab(r).rt_strt_dt);
98: end loop;
99: end if;
100: hr_utility.set_location(' Leaving: '||l_proc , 20);
101: END delete_past_imp;
102: --
103: /* 8716870: procedure delete_imp_inc is addded to delete the future rate and enrollment for imputed shell plan */
104:

Line 227: hr_utility.set_location('Entering '||l_proc,6054);

223: l_corr_pen_rec c_corr_result_exist%rowtype;
224: --
225: begin
226:
227: hr_utility.set_location('Entering '||l_proc,6054);
228: hr_utility.set_location('p_effective_date: '||p_effective_date,6062);
229: hr_utility.set_location('p_imptd_incm_calc_cd: '||p_imptd_incm_calc_cd,6063);
230: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,6064);
231:

Line 228: hr_utility.set_location('p_effective_date: '||p_effective_date,6062);

224: --
225: begin
226:
227: hr_utility.set_location('Entering '||l_proc,6054);
228: hr_utility.set_location('p_effective_date: '||p_effective_date,6062);
229: hr_utility.set_location('p_imptd_incm_calc_cd: '||p_imptd_incm_calc_cd,6063);
230: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,6064);
231:
232:

Line 229: hr_utility.set_location('p_imptd_incm_calc_cd: '||p_imptd_incm_calc_cd,6063);

225: begin
226:
227: hr_utility.set_location('Entering '||l_proc,6054);
228: hr_utility.set_location('p_effective_date: '||p_effective_date,6062);
229: hr_utility.set_location('p_imptd_incm_calc_cd: '||p_imptd_incm_calc_cd,6063);
230: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,6064);
231:
232:
233: -- get the imputed income plan

Line 230: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,6064);

226:
227: hr_utility.set_location('Entering '||l_proc,6054);
228: hr_utility.set_location('p_effective_date: '||p_effective_date,6062);
229: hr_utility.set_location('p_imptd_incm_calc_cd: '||p_imptd_incm_calc_cd,6063);
230: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,6064);
231:
232:
233: -- get the imputed income plan
234: open c_imp_inc_plan(p_imptd_incm_calc_cd, p_business_group_id, p_effective_date);

Line 239: hr_utility.set_location (' l_pl_id '||l_pl_id, 2);

235: fetch c_imp_inc_plan into l_pl_id;
236: close c_imp_inc_plan;
237:
238: --delete rates first
239: hr_utility.set_location (' l_pl_id '||l_pl_id, 2);
240:
241: open c_del_imp_inc_rt (p_per_in_ler_id);
242: fetch c_del_imp_inc_rt bulk collect into l_imp_inc_rt_tab;
243: close c_del_imp_inc_rt;

Line 245: hr_utility.set_location('l_imp_inc_rt_tab.count: '||l_imp_inc_rt_tab.count,6080);

241: open c_del_imp_inc_rt (p_per_in_ler_id);
242: fetch c_del_imp_inc_rt bulk collect into l_imp_inc_rt_tab;
243: close c_del_imp_inc_rt;
244:
245: hr_utility.set_location('l_imp_inc_rt_tab.count: '||l_imp_inc_rt_tab.count,6080);
246:
247: if l_imp_inc_rt_tab.count > 0 then
248: for r in l_imp_inc_rt_tab.first..l_imp_inc_rt_tab.last
249: loop

Line 250: hr_utility.set_location (' delete future rate prv', 2);

246:
247: if l_imp_inc_rt_tab.count > 0 then
248: for r in l_imp_inc_rt_tab.first..l_imp_inc_rt_tab.last
249: loop
250: hr_utility.set_location (' delete future rate prv', 2);
251: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);
252:
253: -- Nullify the prv_id on enrt_rt
254: update ben_enrt_rt set prtt_rt_val_id = NULL

Line 251: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);

247: if l_imp_inc_rt_tab.count > 0 then
248: for r in l_imp_inc_rt_tab.first..l_imp_inc_rt_tab.last
249: loop
250: hr_utility.set_location (' delete future rate prv', 2);
251: hr_utility.set_location (' l_imp_inc_rt_tab(r).prtt_rt_val_id '||l_imp_inc_rt_tab(r).prtt_rt_val_id, 2);
252:
253: -- Nullify the prv_id on enrt_rt
254: update ben_enrt_rt set prtt_rt_val_id = NULL
255: where prtt_rt_val_id = nvl(l_imp_inc_rt_tab(r).prtt_rt_val_id,-1);

Line 257: hr_utility.set_location (' l_imp_inc_rt_tab(r).rt_strt_dt '||l_imp_inc_rt_tab(r).rt_strt_dt, 2);

253: -- Nullify the prv_id on enrt_rt
254: update ben_enrt_rt set prtt_rt_val_id = NULL
255: where prtt_rt_val_id = nvl(l_imp_inc_rt_tab(r).prtt_rt_val_id,-1);
256:
257: hr_utility.set_location (' l_imp_inc_rt_tab(r).rt_strt_dt '||l_imp_inc_rt_tab(r).rt_strt_dt, 2);
258: -- delete the rate
259: ben_prtt_rt_val_api.delete_prtt_rt_val
260: (p_validate => false
261: ,p_prtt_rt_val_id => l_imp_inc_rt_tab(r).prtt_rt_val_id

Line 276: hr_utility.set_location('l_imp_inc_enrt_tab.count: '||l_imp_inc_enrt_tab.count,6080);

272: open c_del_imp_inc_enrt (p_per_in_ler_id);
273: fetch c_del_imp_inc_enrt bulk collect into l_imp_inc_enrt_tab;
274: close c_del_imp_inc_enrt;
275:
276: hr_utility.set_location('l_imp_inc_enrt_tab.count: '||l_imp_inc_enrt_tab.count,6080);
277:
278: if l_imp_inc_enrt_tab.count > 0 then
279: for r in l_imp_inc_enrt_tab.first..l_imp_inc_enrt_tab.last
280: loop

Line 285: hr_utility.set_location (' delete imputed enrollment', 2);

281: --
282: --Need to see if the imputed income enrollments existed 1 day prior, since we need the
283: --previous record in order to delete future records.
284: --
285: hr_utility.set_location (' delete imputed enrollment', 2);
286: hr_utility.set_location (' l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id '||l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id, 3);
287: hr_utility.set_location (' l_imp_inc_enrt_tab(r).effective_start_date '||l_imp_inc_enrt_tab(r).effective_start_date, 3);
288:
289: open c_del_imp_inc_enrt_prior(p_prtt_enrt_rslt_id => l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id,

Line 286: hr_utility.set_location (' l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id '||l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id, 3);

282: --Need to see if the imputed income enrollments existed 1 day prior, since we need the
283: --previous record in order to delete future records.
284: --
285: hr_utility.set_location (' delete imputed enrollment', 2);
286: hr_utility.set_location (' l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id '||l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id, 3);
287: hr_utility.set_location (' l_imp_inc_enrt_tab(r).effective_start_date '||l_imp_inc_enrt_tab(r).effective_start_date, 3);
288:
289: open c_del_imp_inc_enrt_prior(p_prtt_enrt_rslt_id => l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id,
290: p_effective_date => l_imp_inc_enrt_tab(r).effective_start_date - 1);

Line 287: hr_utility.set_location (' l_imp_inc_enrt_tab(r).effective_start_date '||l_imp_inc_enrt_tab(r).effective_start_date, 3);

283: --previous record in order to delete future records.
284: --
285: hr_utility.set_location (' delete imputed enrollment', 2);
286: hr_utility.set_location (' l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id '||l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id, 3);
287: hr_utility.set_location (' l_imp_inc_enrt_tab(r).effective_start_date '||l_imp_inc_enrt_tab(r).effective_start_date, 3);
288:
289: open c_del_imp_inc_enrt_prior(p_prtt_enrt_rslt_id => l_imp_inc_enrt_tab(r).prtt_enrt_rslt_id,
290: p_effective_date => l_imp_inc_enrt_tab(r).effective_start_date - 1);
291: fetch c_del_imp_inc_enrt_prior bulk collect into l_imp_inc_enrt_tab_prior;

Line 295: hr_utility.set_location('l_imp_inc_enrt_tab.count '||l_imp_inc_enrt_tab.count,6685);

291: fetch c_del_imp_inc_enrt_prior bulk collect into l_imp_inc_enrt_tab_prior;
292: close c_del_imp_inc_enrt_prior;
293:
294:
295: hr_utility.set_location('l_imp_inc_enrt_tab.count '||l_imp_inc_enrt_tab.count,6685);
296:
297:
298: if l_imp_inc_enrt_tab_prior.count > 0 then
299: --

Line 300: hr_utility.set_location('Prior enrollment exists: ',6685);

296:
297:
298: if l_imp_inc_enrt_tab_prior.count > 0 then
299: --
300: hr_utility.set_location('Prior enrollment exists: ',6685);
301: l_zap := null;
302: l_delete := null;
303: l_future_change := null;
304: l_delete_next_change := null;

Line 325: hr_utility.set_location (' l_mode '||l_mode, 5);

321: --
322: l_mode := hr_api.g_delete_next_change;
323:
324: end if;
325: hr_utility.set_location (' l_mode '||l_mode, 5);
326: l_delrec := l_imp_inc_enrt_tab_prior(l_imp_inc_enrt_tab_prior.first);
327: l_imp_inc_enrt_tab_prior.delete;
328:
329: else

Line 330: hr_utility.set_location('Else - no prior imputed enrollment exists ',6685);

326: l_delrec := l_imp_inc_enrt_tab_prior(l_imp_inc_enrt_tab_prior.first);
327: l_imp_inc_enrt_tab_prior.delete;
328:
329: else
330: hr_utility.set_location('Else - no prior imputed enrollment exists ',6685);
331: l_delrec := l_imp_inc_enrt_tab(r);
332: l_mode := hr_api.g_zap;
333: end if;
334: --

Line 337: hr_utility.set_location('----------------------------------------------------------',6690);

333: end if;
334: --
335:
336:
337: hr_utility.set_location('----------------------------------------------------------',6690);
338: hr_utility.set_location('l_mode: '||l_mode,5363);
339: hr_utility.set_location('l_delrec.prtt_enrt_rslt_id: '||l_delrec.prtt_enrt_rslt_id,5363);
340: hr_utility.set_location('l_delrec.effective_start_date: '||l_delrec.effective_start_date,5363);
341: hr_utility.set_location('l_delrec.effective_end_date: '||l_delrec.effective_end_date,5363);

Line 338: hr_utility.set_location('l_mode: '||l_mode,5363);

334: --
335:
336:
337: hr_utility.set_location('----------------------------------------------------------',6690);
338: hr_utility.set_location('l_mode: '||l_mode,5363);
339: hr_utility.set_location('l_delrec.prtt_enrt_rslt_id: '||l_delrec.prtt_enrt_rslt_id,5363);
340: hr_utility.set_location('l_delrec.effective_start_date: '||l_delrec.effective_start_date,5363);
341: hr_utility.set_location('l_delrec.effective_end_date: '||l_delrec.effective_end_date,5363);
342:

Line 339: hr_utility.set_location('l_delrec.prtt_enrt_rslt_id: '||l_delrec.prtt_enrt_rslt_id,5363);

335:
336:
337: hr_utility.set_location('----------------------------------------------------------',6690);
338: hr_utility.set_location('l_mode: '||l_mode,5363);
339: hr_utility.set_location('l_delrec.prtt_enrt_rslt_id: '||l_delrec.prtt_enrt_rslt_id,5363);
340: hr_utility.set_location('l_delrec.effective_start_date: '||l_delrec.effective_start_date,5363);
341: hr_utility.set_location('l_delrec.effective_end_date: '||l_delrec.effective_end_date,5363);
342:
343:

Line 340: hr_utility.set_location('l_delrec.effective_start_date: '||l_delrec.effective_start_date,5363);

336:
337: hr_utility.set_location('----------------------------------------------------------',6690);
338: hr_utility.set_location('l_mode: '||l_mode,5363);
339: hr_utility.set_location('l_delrec.prtt_enrt_rslt_id: '||l_delrec.prtt_enrt_rslt_id,5363);
340: hr_utility.set_location('l_delrec.effective_start_date: '||l_delrec.effective_start_date,5363);
341: hr_utility.set_location('l_delrec.effective_end_date: '||l_delrec.effective_end_date,5363);
342:
343:
344: --

Line 341: hr_utility.set_location('l_delrec.effective_end_date: '||l_delrec.effective_end_date,5363);

337: hr_utility.set_location('----------------------------------------------------------',6690);
338: hr_utility.set_location('l_mode: '||l_mode,5363);
339: hr_utility.set_location('l_delrec.prtt_enrt_rslt_id: '||l_delrec.prtt_enrt_rslt_id,5363);
340: hr_utility.set_location('l_delrec.effective_start_date: '||l_delrec.effective_start_date,5363);
341: hr_utility.set_location('l_delrec.effective_end_date: '||l_delrec.effective_end_date,5363);
342:
343:
344: --
345: l_object_version_number := l_delrec.object_version_number;

Line 355: hr_utility.set_location(' corr pen rec exists, no zap, upd prev pil_id on pen',6695);

351: fetch c_corr_result_exist into l_corr_pen_rec;
352:
353: if c_corr_result_exist%found then
354:
355: hr_utility.set_location(' corr pen rec exists, no zap, upd prev pil_id on pen',6695);
356:
357: -- as corr rec exists, upd the ler_id, pil_id of corr rec on the rslt
358: update ben_prtt_enrt_rslt_f
359: set ler_id = l_corr_pen_rec.ler_id,

Line 381: hr_utility.set_location (' ZAP l_delrec.prtt_enrt_rslt_id '||l_delrec.prtt_enrt_rslt_id, 5);

377: close c_corr_result_exist;
378: else
379: close c_corr_result_exist;
380: -- no corr rec exists, so ZAP the result
381: hr_utility.set_location (' ZAP l_delrec.prtt_enrt_rslt_id '||l_delrec.prtt_enrt_rslt_id, 5);
382: ben_prtt_enrt_result_api.delete_prtt_enrt_result
383: (p_validate => false,
384: p_prtt_enrt_rslt_id => l_delrec.prtt_enrt_rslt_id,
385: p_effective_start_date => l_effective_start_date,

Line 394: hr_utility.set_location('Deleting enrollment: '||l_delrec.prtt_enrt_rslt_id,6695);

390: p_multi_row_validate => FALSE);
391: end if;
392:
393: else
394: hr_utility.set_location('Deleting enrollment: '||l_delrec.prtt_enrt_rslt_id,6695);
395:
396: ben_prtt_enrt_result_api.delete_prtt_enrt_result
397: (p_validate => false,
398: p_prtt_enrt_rslt_id => l_delrec.prtt_enrt_rslt_id,

Line 411: hr_utility.set_location('Leaving '||l_proc,6054);

407: l_delrec := null;
408: end loop;
409: end if;
410:
411: hr_utility.set_location('Leaving '||l_proc,6054);
412:
413: end delete_imp_inc;
414:
415:

Line 891: hr_utility.set_location(' Entering: '||l_proc , 10);

887: /* 8716870: Imputed Income Enhancement */
888:
889: begin
890: --
891: hr_utility.set_location(' Entering: '||l_proc , 10);
892: --
893: open c_pil;
894: --
895: fetch c_pil into l_pil_rec;

Line 900: hr_utility.set_location (' l_max_le_eff_date '||l_max_le_eff_date , 8.0);

896: --
897: close c_pil;
898: --
899: l_max_le_eff_date := greatest(l_pil_rec.lf_evt_ocrd_dt ,p_imp_cvg_strt_dt); -- Bug 9436910
900: hr_utility.set_location (' l_max_le_eff_date '||l_max_le_eff_date , 8.0);
901: --
902: l_eff_dt:= NULL;
903: l_cvg_strt_dt := NULL;
904: open c_pil_epe_imp_inc;

Line 939: hr_utility.set_location (' p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt, 2);

935: close c_pil_epe_imp_inc;
936: end if;
937:
938: -- 8716870
939: hr_utility.set_location (' p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt, 2);
940: hr_utility.set_location (' l_cvg_strt_dt '||l_cvg_strt_dt, 2);
941:
942: if p_imp_cvg_strt_dt is not null and p_imp_cvg_strt_dt > l_cvg_strt_dt then
943: hr_utility.set_location (' re-setting l_cvg_strt_dt ', 2);

Line 940: hr_utility.set_location (' l_cvg_strt_dt '||l_cvg_strt_dt, 2);

936: end if;
937:
938: -- 8716870
939: hr_utility.set_location (' p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt, 2);
940: hr_utility.set_location (' l_cvg_strt_dt '||l_cvg_strt_dt, 2);
941:
942: if p_imp_cvg_strt_dt is not null and p_imp_cvg_strt_dt > l_cvg_strt_dt then
943: hr_utility.set_location (' re-setting l_cvg_strt_dt ', 2);
944: l_cvg_strt_dt := p_imp_cvg_strt_dt;

Line 943: hr_utility.set_location (' re-setting l_cvg_strt_dt ', 2);

939: hr_utility.set_location (' p_imp_cvg_strt_dt '||p_imp_cvg_strt_dt, 2);
940: hr_utility.set_location (' l_cvg_strt_dt '||l_cvg_strt_dt, 2);
941:
942: if p_imp_cvg_strt_dt is not null and p_imp_cvg_strt_dt > l_cvg_strt_dt then
943: hr_utility.set_location (' re-setting l_cvg_strt_dt ', 2);
944: l_cvg_strt_dt := p_imp_cvg_strt_dt;
945: l_rt_strt_dt := p_imp_cvg_strt_dt;
946: end if;
947:

Line 953: hr_utility.set_location (' calling delete_imp_inc with effective date as l_rt_strt_dt ', 2);

949: ben_manage_life_events.g_fonm_cvg_strt_dt := l_cvg_strt_dt;
950: ben_manage_life_events.g_fonm_rt_strt_dt := l_rt_strt_dt;
951:
952: -- 8716870
953: hr_utility.set_location (' calling delete_imp_inc with effective date as l_rt_strt_dt ', 2);
954: delete_imp_inc(p_person_id => p_person_id,
955: p_per_in_ler_id => p_per_in_ler_id,
956: p_business_group_id => p_business_group_id,
957: p_effective_date => nvl(l_rt_strt_dt,l_cvg_strt_dt),

Line 976: hr_utility.set_location (' l_hgh_cmp_amt '||l_hgh_cmp_amt ,8.1);

972: open c_ben_amt(p_highly_comp => 'Y', p_cvg_strt_dt => l_cvg_strt_dt);
973: fetch c_ben_amt into l_hgh_cmp_amt;
974: close c_ben_amt;
975:
976: hr_utility.set_location (' l_hgh_cmp_amt '||l_hgh_cmp_amt ,8.1);
977: --
978: open c_ben_amt(p_highly_comp => 'N',p_cvg_strt_dt => l_cvg_strt_dt);
979: fetch c_ben_amt into l_nor_cmp_amt;
980: close c_ben_amt;

Line 982: hr_utility.set_location (' l_nor_cmp_amt '||l_nor_cmp_amt , 8.2);

978: open c_ben_amt(p_highly_comp => 'N',p_cvg_strt_dt => l_cvg_strt_dt);
979: fetch c_ben_amt into l_nor_cmp_amt;
980: close c_ben_amt;
981:
982: hr_utility.set_location (' l_nor_cmp_amt '||l_nor_cmp_amt , 8.2);
983: --
984: if p_subj_to_imptd_incm_typ_cd = 'PRTT' then
985: --
986: l_std_imp_inc_ded := 50000;

Line 1023: hr_utility.set_location('l_tot_sub_to_imp_inc: '||l_tot_sub_to_imp_inc, 10);

1019: end if;
1020: --
1021: l_tot_sub_to_imp_inc := l_tot_ben_amt + nvl(l_hgh_cmp_amt,0);
1022: --
1023: hr_utility.set_location('l_tot_sub_to_imp_inc: '||l_tot_sub_to_imp_inc, 10);
1024:
1025: -- if the profile set to 'Y' and eployee contributed pre-tax , deduct the contribution
1026: --- post tax calcualtion 2897063
1027:

Line 1029: hr_utility.set_location('Profile:'||l_prflvalue, 99 );

1025: -- if the profile set to 'Y' and eployee contributed pre-tax , deduct the contribution
1026: --- post tax calcualtion 2897063
1027:
1028: l_prflvalue := fnd_profile.value('BEN_IMPTD_INCM_POST_TAX');
1029: hr_utility.set_location('Profile:'||l_prflvalue, 99 );
1030: if l_prflvalue = 'Y' then
1031: open c_post_tax_contrib(hr_api.g_eot) ;
1032: Loop
1033: fetch c_post_tax_contrib into l_post_tax_rec ;

Line 1041: hr_utility.set_location('pdv amount : '||l_post_tax_rec.rt_val , 10);

1037: l_post_tax_amount := l_post_tax_amount + nvl(l_post_tax_rec.rt_val,0) ;
1038: else
1039: l_post_tax_err_found := 'Y' ;
1040: end if ;
1041: hr_utility.set_location('pdv amount : '||l_post_tax_rec.rt_val , 10);
1042: end loop ;
1043: close c_post_tax_contrib ;
1044: hr_utility.set_location('post tax : '||l_post_tax_amount || ' found ' || l_post_tax_err_found , 10);
1045:

Line 1044: hr_utility.set_location('post tax : '||l_post_tax_amount || ' found ' || l_post_tax_err_found , 10);

1040: end if ;
1041: hr_utility.set_location('pdv amount : '||l_post_tax_rec.rt_val , 10);
1042: end loop ;
1043: close c_post_tax_contrib ;
1044: hr_utility.set_location('post tax : '||l_post_tax_amount || ' found ' || l_post_tax_err_found , 10);
1045:
1046: if l_post_tax_err_found = 'Y' then
1047:
1048: if fnd_global.conc_request_id in ( 0,-1) then

Line 1103: hr_utility.set_location( ' Prtt_enrt_rslt_id '||l_enrt_rslt_rec.Prtt_enrt_rslt_id , 8.5);

1099: --
1100: open c_enrt_rslt(l_plan_rec.pl_id);
1101: --
1102: fetch c_enrt_rslt into l_enrt_rslt_rec;
1103: hr_utility.set_location( ' Prtt_enrt_rslt_id '||l_enrt_rslt_rec.Prtt_enrt_rslt_id , 8.5);
1104: --
1105: close c_enrt_rslt;
1106: if p_no_choice_flag or l_enrt_rslt_rec.pl_id is not null then
1107: --

Line 1128: hr_utility.set_location( ' l_choice_exists_flag ' , 8.6);

1124: --
1125: else
1126: --
1127: l_choice_exists_flag := true;
1128: hr_utility.set_location( ' l_choice_exists_flag ' , 8.6);
1129: --
1130: if l_plan_rec.pl_cd = 'MSTBPGM' then
1131: loop
1132: --

Line 1161: hr_utility.set_location( ' l_result_exists_flag ' , 8.7);

1157: --
1158: if l_enrt_rslt_rec.pl_id is not null then
1159: --
1160: l_result_exists_flag := TRUE;
1161: hr_utility.set_location( ' l_result_exists_flag ' , 8.7);
1162: --
1163: else
1164: --
1165: open c_enrt_rslt(l_plan_rec.pl_id);

Line 1171: hr_utility.set_location( ' l_result_exists_flag ' ,8.8);

1167: fetch c_enrt_rslt into l_enrt_rslt_rec;
1168: if c_enrt_rslt%found then
1169: --
1170: l_result_exists_flag := TRUE;
1171: hr_utility.set_location( ' l_result_exists_flag ' ,8.8);
1172: --
1173: end if;
1174: --
1175: close c_enrt_rslt;

Line 1223: hr_utility.set_location('l_eff_date_for_enrt :'||l_eff_date_for_enrt,1234);

1219: l_eff_date_for_enrt := p_effective_date;
1220: end if;
1221: end if;
1222:
1223: hr_utility.set_location('l_eff_date_for_enrt :'||l_eff_date_for_enrt,1234);
1224: hr_utility.set_location('p_effective_date :'||p_effective_date,1234);
1225: /* 8716870 ends */
1226:
1227:

Line 1224: hr_utility.set_location('p_effective_date :'||p_effective_date,1234);

1220: end if;
1221: end if;
1222:
1223: hr_utility.set_location('l_eff_date_for_enrt :'||l_eff_date_for_enrt,1234);
1224: hr_utility.set_location('p_effective_date :'||p_effective_date,1234);
1225: /* 8716870 ends */
1226:
1227:
1228: --

Line 1260: hr_utility.set_location( ' pl id ' || l_plan_rec.pl_id, 99 ) ;

1256: end if;
1257: --
1258: close c_ecr_prv;
1259: -- Start of Bug fix 3027365
1260: hr_utility.set_location( ' pl id ' || l_plan_rec.pl_id, 99 ) ;
1261: open c_chk_rate_avlbl(l_plan_rec.pl_id);
1262: fetch c_chk_rate_avlbl into l_acty_base_rt_id;
1263:
1264: if c_chk_rate_avlbl%found then

Line 1368: hr_utility.set_location('factor before : '||rate_val_list(l_count) , 10);

1364: ,p_iss_val => l_iss_val);
1365: --
1366: -- Imputed income will always be rate * total subject to imputed income
1367: --
1368: hr_utility.set_location('factor before : '||rate_val_list(l_count) , 10);
1369: rate_val_list(l_count) := rate_val_list(l_count)*l_tot_sub_to_imp_inc;
1370: rate_id_list(l_count) := l_ecr_prv_rec.enrt_rt_id;
1371:
1372: hr_utility.set_location('factor after : '||rate_val_list(l_count) , 10);

Line 1372: hr_utility.set_location('factor after : '||rate_val_list(l_count) , 10);

1368: hr_utility.set_location('factor before : '||rate_val_list(l_count) , 10);
1369: rate_val_list(l_count) := rate_val_list(l_count)*l_tot_sub_to_imp_inc;
1370: rate_id_list(l_count) := l_ecr_prv_rec.enrt_rt_id;
1371:
1372: hr_utility.set_location('factor after : '||rate_val_list(l_count) , 10);
1373: --- Post tax contribution deducted here 2897063
1374: if l_post_tax_amount > 0 then
1375: if l_post_tax_amount > rate_val_list(l_count) then
1376: rate_val_list(l_count) := 0 ;

Line 1382: hr_utility.set_location('post deduction : '||rate_val_list(l_count) , 10);

1378: rate_val_list(l_count) := rate_val_list(l_count) - l_post_tax_amount ;
1379: end if ;
1380: end if ;
1381: --
1382: hr_utility.set_location('post deduction : '||rate_val_list(l_count) , 10);
1383:
1384: if l_result_exists_flag then
1385: --
1386: if l_choice_exists_flag then

Line 1435: hr_utility.set_location( ' Case 1 l_result_exists_flag l_choice_exists_flag ' , 9.0);

1431: --
1432: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1433: fnd_message.set_token('PROC','ben_election_information -update');
1434: -- do update Bug 1295277
1435: hr_utility.set_location( ' Case 1 l_result_exists_flag l_choice_exists_flag ' , 9.0);
1436: ben_election_information.election_information
1437: (p_validate => FALSE
1438: ,p_elig_per_elctbl_chc_id => l_elctbl_chc_rec.elig_per_elctbl_chc_id
1439: ,p_prtt_enrt_rslt_id => l_enrt_rslt_rec.prtt_enrt_rslt_id

Line 1492: hr_utility.set_location('Effective Date '||p_effective_date , 1399);

1488: --
1489: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1490: fnd_message.set_token('PROC','ben_election_information-insert');
1491: -- do insert.
1492: hr_utility.set_location('Effective Date '||p_effective_date , 1399);
1493: hr_utility.set_location('p_enrt_mthd_cd ' ||p_enrt_mthd_cd , 1399 ) ;
1494:
1495: hr_utility.set_location('Befor plan_id'||to_char(l_elctbl_chc_rec.pl_id) , 1399);
1496: hr_utility.set_location('Conc Req Id '||fnd_global.conc_request_id , 1399);

Line 1493: hr_utility.set_location('p_enrt_mthd_cd ' ||p_enrt_mthd_cd , 1399 ) ;

1489: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
1490: fnd_message.set_token('PROC','ben_election_information-insert');
1491: -- do insert.
1492: hr_utility.set_location('Effective Date '||p_effective_date , 1399);
1493: hr_utility.set_location('p_enrt_mthd_cd ' ||p_enrt_mthd_cd , 1399 ) ;
1494:
1495: hr_utility.set_location('Befor plan_id'||to_char(l_elctbl_chc_rec.pl_id) , 1399);
1496: hr_utility.set_location('Conc Req Id '||fnd_global.conc_request_id , 1399);
1497: hr_utility.set_location('lf date'|| l_pil_rec.lf_evt_ocrd_dt,1399);

Line 1495: hr_utility.set_location('Befor plan_id'||to_char(l_elctbl_chc_rec.pl_id) , 1399);

1491: -- do insert.
1492: hr_utility.set_location('Effective Date '||p_effective_date , 1399);
1493: hr_utility.set_location('p_enrt_mthd_cd ' ||p_enrt_mthd_cd , 1399 ) ;
1494:
1495: hr_utility.set_location('Befor plan_id'||to_char(l_elctbl_chc_rec.pl_id) , 1399);
1496: hr_utility.set_location('Conc Req Id '||fnd_global.conc_request_id , 1399);
1497: hr_utility.set_location('lf date'|| l_pil_rec.lf_evt_ocrd_dt,1399);
1498: hr_utility.set_location('p_enrt_mthd_cd '||p_enrt_mthd_cd , 1399 );
1499: -- Bug 1561138 When automatic enrollment is run for an imputted income

Line 1496: hr_utility.set_location('Conc Req Id '||fnd_global.conc_request_id , 1399);

1492: hr_utility.set_location('Effective Date '||p_effective_date , 1399);
1493: hr_utility.set_location('p_enrt_mthd_cd ' ||p_enrt_mthd_cd , 1399 ) ;
1494:
1495: hr_utility.set_location('Befor plan_id'||to_char(l_elctbl_chc_rec.pl_id) , 1399);
1496: hr_utility.set_location('Conc Req Id '||fnd_global.conc_request_id , 1399);
1497: hr_utility.set_location('lf date'|| l_pil_rec.lf_evt_ocrd_dt,1399);
1498: hr_utility.set_location('p_enrt_mthd_cd '||p_enrt_mthd_cd , 1399 );
1499: -- Bug 1561138 When automatic enrollment is run for an imputted income
1500: -- plan take the effective date as the minimum of

Line 1497: hr_utility.set_location('lf date'|| l_pil_rec.lf_evt_ocrd_dt,1399);

1493: hr_utility.set_location('p_enrt_mthd_cd ' ||p_enrt_mthd_cd , 1399 ) ;
1494:
1495: hr_utility.set_location('Befor plan_id'||to_char(l_elctbl_chc_rec.pl_id) , 1399);
1496: hr_utility.set_location('Conc Req Id '||fnd_global.conc_request_id , 1399);
1497: hr_utility.set_location('lf date'|| l_pil_rec.lf_evt_ocrd_dt,1399);
1498: hr_utility.set_location('p_enrt_mthd_cd '||p_enrt_mthd_cd , 1399 );
1499: -- Bug 1561138 When automatic enrollment is run for an imputted income
1500: -- plan take the effective date as the minimum of
1501: -- life event occured date and effective date passed.

Line 1498: hr_utility.set_location('p_enrt_mthd_cd '||p_enrt_mthd_cd , 1399 );

1494:
1495: hr_utility.set_location('Befor plan_id'||to_char(l_elctbl_chc_rec.pl_id) , 1399);
1496: hr_utility.set_location('Conc Req Id '||fnd_global.conc_request_id , 1399);
1497: hr_utility.set_location('lf date'|| l_pil_rec.lf_evt_ocrd_dt,1399);
1498: hr_utility.set_location('p_enrt_mthd_cd '||p_enrt_mthd_cd , 1399 );
1499: -- Bug 1561138 When automatic enrollment is run for an imputted income
1500: -- plan take the effective date as the minimum of
1501: -- life event occured date and effective date passed.
1502: -- This is done only in case of batch process from a

Line 1510: hr_utility.set_location('Automatic enrollmant case' , 1399);

1506: if p_enrt_mthd_cd = 'A'
1507: AND fnd_global.conc_request_id <> -1
1508: then
1509: --
1510: hr_utility.set_location('Automatic enrollmant case' , 1399);
1511: if p_effective_date > l_pil_rec.lf_evt_ocrd_dt
1512: then
1513: l_effective_date := l_pil_rec.lf_evt_ocrd_dt ;
1514: hr_utility.set_location('Automatic enrollment eff date altered', 1399);

Line 1514: hr_utility.set_location('Automatic enrollment eff date altered', 1399);

1510: hr_utility.set_location('Automatic enrollmant case' , 1399);
1511: if p_effective_date > l_pil_rec.lf_evt_ocrd_dt
1512: then
1513: l_effective_date := l_pil_rec.lf_evt_ocrd_dt ;
1514: hr_utility.set_location('Automatic enrollment eff date altered', 1399);
1515: hr_utility.set_location('Date passed is :'||l_effective_date, 1399) ;
1516: end if;
1517: --
1518: end if;

Line 1515: hr_utility.set_location('Date passed is :'||l_effective_date, 1399) ;

1511: if p_effective_date > l_pil_rec.lf_evt_ocrd_dt
1512: then
1513: l_effective_date := l_pil_rec.lf_evt_ocrd_dt ;
1514: hr_utility.set_location('Automatic enrollment eff date altered', 1399);
1515: hr_utility.set_location('Date passed is :'||l_effective_date, 1399) ;
1516: end if;
1517: --
1518: end if;
1519:

Line 1576: hr_utility.set_location( ' Case 3 ' , 9.2);

1572: end if;
1573: --
1574: else
1575: --
1576: hr_utility.set_location( ' Case 3 ' , 9.2);
1577: open c_imp_inc_plan2(l_cvg_strt_dt); -- 8716870
1578: --
1579: fetch c_imp_inc_plan2 into l_enrt_rslt_rec;
1580: if c_imp_inc_plan2%found then

Line 1590: hr_utility.set_location('l_eff_date_for_enrt :'||l_eff_date_for_enrt,1234);

1586: else
1587: l_eff_date_for_enrt := p_effective_date;
1588: end if;
1589:
1590: hr_utility.set_location('l_eff_date_for_enrt :'||l_eff_date_for_enrt,1234);
1591: hr_utility.set_location('p_effective_date :'||p_effective_date,1234);
1592:
1593: /* 8716870 */
1594: ben_prtt_enrt_result_api.delete_enrollment

Line 1591: hr_utility.set_location('p_effective_date :'||p_effective_date,1234);

1587: l_eff_date_for_enrt := p_effective_date;
1588: end if;
1589:
1590: hr_utility.set_location('l_eff_date_for_enrt :'||l_eff_date_for_enrt,1234);
1591: hr_utility.set_location('p_effective_date :'||p_effective_date,1234);
1592:
1593: /* 8716870 */
1594: ben_prtt_enrt_result_api.delete_enrollment
1595: (p_prtt_enrt_rslt_id => l_enrt_rslt_rec.prtt_enrt_rslt_id,

Line 1621: hr_utility.set_location('l_eff_date_for_enrt:'||l_eff_date_for_enrt,1234);

1617: --env objects. This date is not required for any other modules so we query to see if this value was written and
1618: --if so we will overwrite it with the original effective date.
1619: ben_env_object.get(p_rec => p_global_env_rec);
1620:
1621: hr_utility.set_location('l_eff_date_for_enrt:'||l_eff_date_for_enrt,1234);
1622: hr_utility.set_location('p_effective_date:'||p_effective_date,1234);
1623: hr_utility.set_location('p_global_env_rec.effective_date:'||p_global_env_rec.effective_date,1234);
1624:
1625:

Line 1622: hr_utility.set_location('p_effective_date:'||p_effective_date,1234);

1618: --if so we will overwrite it with the original effective date.
1619: ben_env_object.get(p_rec => p_global_env_rec);
1620:
1621: hr_utility.set_location('l_eff_date_for_enrt:'||l_eff_date_for_enrt,1234);
1622: hr_utility.set_location('p_effective_date:'||p_effective_date,1234);
1623: hr_utility.set_location('p_global_env_rec.effective_date:'||p_global_env_rec.effective_date,1234);
1624:
1625:
1626: if (p_global_env_rec.effective_date = l_eff_date_for_enrt) then

Line 1623: hr_utility.set_location('p_global_env_rec.effective_date:'||p_global_env_rec.effective_date,1234);

1619: ben_env_object.get(p_rec => p_global_env_rec);
1620:
1621: hr_utility.set_location('l_eff_date_for_enrt:'||l_eff_date_for_enrt,1234);
1622: hr_utility.set_location('p_effective_date:'||p_effective_date,1234);
1623: hr_utility.set_location('p_global_env_rec.effective_date:'||p_global_env_rec.effective_date,1234);
1624:
1625:
1626: if (p_global_env_rec.effective_date = l_eff_date_for_enrt) then
1627: ben_env_object.init

Line 1641: hr_utility.set_location('Leaving: '||l_proc , 10);

1637: end if;
1638: end if;
1639: /* 8716870 ends */
1640:
1641: hr_utility.set_location('Leaving: '||l_proc , 10);
1642: --
1643: end p_comp_imp_inc_internal;
1644: --
1645:

Line 1823: hr_utility.set_location(' Entering ' || l_proc , 11);

1819:
1820: l_proc varchar2(72) := g_package||'redo_imp_inc';
1821:
1822: begin
1823: hr_utility.set_location(' Entering ' || l_proc , 11);
1824: hr_utility.set_location(' p_per_in_ler_id '||p_per_in_ler_id, 10);
1825: hr_utility.set_location(' p_person_id '||p_person_id, 10);
1826:
1827: open c_ler_type ;

Line 1824: hr_utility.set_location(' p_per_in_ler_id '||p_per_in_ler_id, 10);

1820: l_proc varchar2(72) := g_package||'redo_imp_inc';
1821:
1822: begin
1823: hr_utility.set_location(' Entering ' || l_proc , 11);
1824: hr_utility.set_location(' p_per_in_ler_id '||p_per_in_ler_id, 10);
1825: hr_utility.set_location(' p_person_id '||p_person_id, 10);
1826:
1827: open c_ler_type ;
1828: fetch c_ler_type into l_ler_type ;

Line 1825: hr_utility.set_location(' p_person_id '||p_person_id, 10);

1821:
1822: begin
1823: hr_utility.set_location(' Entering ' || l_proc , 11);
1824: hr_utility.set_location(' p_per_in_ler_id '||p_per_in_ler_id, 10);
1825: hr_utility.set_location(' p_person_id '||p_person_id, 10);
1826:
1827: open c_ler_type ;
1828: fetch c_ler_type into l_ler_type ;
1829: close c_ler_type;

Line 1831: hr_utility.set_location('l_ler_type.typ_cd '||l_ler_type.typ_cd, 11);

1827: open c_ler_type ;
1828: fetch c_ler_type into l_ler_type ;
1829: close c_ler_type;
1830:
1831: hr_utility.set_location('l_ler_type.typ_cd '||l_ler_type.typ_cd, 11);
1832:
1833: -- Bug 10014628 : bypass delete_past_imp call for unrestricted life events, because for unrestricted life event,
1834: -- the per_in_ler_id will be same for all unrestricted runs. So, the enrollment will always be end dated, and we need
1835: -- the past prv record.

Line 1850: hr_utility.set_location('l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);

1846: l_found_prtt := TRUE;
1847: end if;
1848: close c_erlst_cvg_strt;
1849:
1850: hr_utility.set_location('l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);
1851: hr_utility.set_location('l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);
1852:
1853: if l_found_prtt then
1854: delete_past_imp(p_person_id => p_person_id,

Line 1851: hr_utility.set_location('l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);

1847: end if;
1848: close c_erlst_cvg_strt;
1849:
1850: hr_utility.set_location('l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);
1851: hr_utility.set_location('l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);
1852:
1853: if l_found_prtt then
1854: delete_past_imp(p_person_id => p_person_id,
1855: p_per_in_ler_id => p_per_in_ler_id,

Line 1871: hr_utility.set_location('dpnt l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);

1867: l_found_dpnt := TRUE;
1868: end if;
1869: close c_erlst_cvg_strt;
1870:
1871: hr_utility.set_location('dpnt l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);
1872: hr_utility.set_location('dpnt l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);
1873:
1874: if l_found_dpnt then
1875: delete_past_imp(p_person_id => p_person_id,

Line 1872: hr_utility.set_location('dpnt l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);

1868: end if;
1869: close c_erlst_cvg_strt;
1870:
1871: hr_utility.set_location('dpnt l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);
1872: hr_utility.set_location('dpnt l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);
1873:
1874: if l_found_dpnt then
1875: delete_past_imp(p_person_id => p_person_id,
1876: p_per_in_ler_id => p_per_in_ler_id,

Line 1892: hr_utility.set_location('sps l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);

1888: l_found_sps := TRUE;
1889: end if;
1890: close c_erlst_cvg_strt;
1891:
1892: hr_utility.set_location('sps l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);
1893: hr_utility.set_location('sps l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);
1894:
1895: if l_found_sps then
1896: delete_past_imp(p_person_id => p_person_id,

Line 1893: hr_utility.set_location('sps l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);

1889: end if;
1890: close c_erlst_cvg_strt;
1891:
1892: hr_utility.set_location('sps l_erlst_cvg_strt.enrt_cvg_strt_dt '||l_erlst_cvg_strt.enrt_cvg_strt_dt, 20);
1893: hr_utility.set_location('sps l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd '||l_erlst_cvg_strt.subj_to_imptd_incm_typ_cd, 20);
1894:
1895: if l_found_sps then
1896: delete_past_imp(p_person_id => p_person_id,
1897: p_per_in_ler_id => p_per_in_ler_id,

Line 1916: hr_utility.set_location('l_imp_cvg_strt_dt '||l_imp_cvg_strt_dt, 10);

1912: l_imp_cvg_strt_dt := l_enrt_subj_to_imp.enrt_cvg_strt_dt ;
1913:
1914: l_effective_date := p_effective_date; -- Bug 9436910
1915:
1916: hr_utility.set_location('l_imp_cvg_strt_dt '||l_imp_cvg_strt_dt, 10);
1917: hr_utility.set_location('l_effective_date '||l_effective_date, 10);
1918: hr_utility.set_location('l_enrt_subj_to_imp.prtt_enrt_rslt_id '||l_enrt_subj_to_imp.prtt_enrt_rslt_id, 10);
1919:
1920: if l_enrt_subj_to_imp.subj_to_imptd_incm_typ_cd ='PRTT' then

Line 1917: hr_utility.set_location('l_effective_date '||l_effective_date, 10);

1913:
1914: l_effective_date := p_effective_date; -- Bug 9436910
1915:
1916: hr_utility.set_location('l_imp_cvg_strt_dt '||l_imp_cvg_strt_dt, 10);
1917: hr_utility.set_location('l_effective_date '||l_effective_date, 10);
1918: hr_utility.set_location('l_enrt_subj_to_imp.prtt_enrt_rslt_id '||l_enrt_subj_to_imp.prtt_enrt_rslt_id, 10);
1919:
1920: if l_enrt_subj_to_imp.subj_to_imptd_incm_typ_cd ='PRTT' then
1921: hr_utility.set_location('recalc imputed income PRTT ', 1635);

Line 1918: hr_utility.set_location('l_enrt_subj_to_imp.prtt_enrt_rslt_id '||l_enrt_subj_to_imp.prtt_enrt_rslt_id, 10);

1914: l_effective_date := p_effective_date; -- Bug 9436910
1915:
1916: hr_utility.set_location('l_imp_cvg_strt_dt '||l_imp_cvg_strt_dt, 10);
1917: hr_utility.set_location('l_effective_date '||l_effective_date, 10);
1918: hr_utility.set_location('l_enrt_subj_to_imp.prtt_enrt_rslt_id '||l_enrt_subj_to_imp.prtt_enrt_rslt_id, 10);
1919:
1920: if l_enrt_subj_to_imp.subj_to_imptd_incm_typ_cd ='PRTT' then
1921: hr_utility.set_location('recalc imputed income PRTT ', 1635);
1922:

Line 1921: hr_utility.set_location('recalc imputed income PRTT ', 1635);

1917: hr_utility.set_location('l_effective_date '||l_effective_date, 10);
1918: hr_utility.set_location('l_enrt_subj_to_imp.prtt_enrt_rslt_id '||l_enrt_subj_to_imp.prtt_enrt_rslt_id, 10);
1919:
1920: if l_enrt_subj_to_imp.subj_to_imptd_incm_typ_cd ='PRTT' then
1921: hr_utility.set_location('recalc imputed income PRTT ', 1635);
1922:
1923: p_comp_imp_inc_internal
1924: (p_person_id => p_person_id
1925: ,p_enrt_mthd_cd => p_enrt_mthd_cd

Line 1938: hr_utility.set_location('recalc imputed income sps', 1675);

1934: );
1935:
1936: elsif l_enrt_subj_to_imp.subj_to_imptd_incm_typ_cd ='SPS' then
1937:
1938: hr_utility.set_location('recalc imputed income sps', 1675);
1939:
1940: p_comp_imp_inc_internal
1941: (p_person_id => p_person_id
1942: ,p_enrt_mthd_cd => p_enrt_mthd_cd

Line 1955: hr_utility.set_location('recalc imputed income dpnt', 1690);

1951: );
1952:
1953: elsif l_enrt_subj_to_imp.subj_to_imptd_incm_typ_cd ='DPNT' then
1954:
1955: hr_utility.set_location('recalc imputed income dpnt', 1690);
1956:
1957: p_comp_imp_inc_internal
1958: (p_person_id => p_person_id
1959: ,p_enrt_mthd_cd => p_enrt_mthd_cd

Line 1972: hr_utility.set_location(' Leaving ' || l_proc , 11);

1968: );
1969: end if;
1970: end loop;
1971:
1972: hr_utility.set_location(' Leaving ' || l_proc , 11);
1973: close c_enrt_subj_to_imp;
1974:
1975: -- Bug 9981379: if c_enrt_subj_to_imp not found, which means that there are no enrollments subjected to
1976: -- imputed income currently, then check if you there is you are still enrolled in the imputed shell plan.

Line 1988: hr_utility.set_location('PRTT c_enrt_subj_to_imp_2 is not found ', 200);

1984: open c_enrt_subj_to_imp_2('PRTT');
1985: fetch c_enrt_subj_to_imp_2 into l_enrt_subj_to_imp_2;
1986: if c_enrt_subj_to_imp_2%notfound then
1987: -- check if the person is enrolled in the imputed shell plan.
1988: hr_utility.set_location('PRTT c_enrt_subj_to_imp_2 is not found ', 200);
1989: open c_imp_shell_enrt('PRTT');
1990: fetch c_imp_shell_enrt into l_imp_shell_enrt;
1991: if c_imp_shell_enrt%found then
1992:

Line 1993: hr_utility.set_location('PRTT l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);

1989: open c_imp_shell_enrt('PRTT');
1990: fetch c_imp_shell_enrt into l_imp_shell_enrt;
1991: if c_imp_shell_enrt%found then
1992:
1993: hr_utility.set_location('PRTT l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);
1994: hr_utility.set_location('kalpesh p_per_in_ler_id '||p_per_in_ler_id, 200);
1995:
1996: ben_prtt_enrt_result_api.delete_enrollment
1997: (p_prtt_enrt_rslt_id => l_imp_shell_enrt.prtt_enrt_rslt_id,

Line 1994: hr_utility.set_location('kalpesh p_per_in_ler_id '||p_per_in_ler_id, 200);

1990: fetch c_imp_shell_enrt into l_imp_shell_enrt;
1991: if c_imp_shell_enrt%found then
1992:
1993: hr_utility.set_location('PRTT l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);
1994: hr_utility.set_location('kalpesh p_per_in_ler_id '||p_per_in_ler_id, 200);
1995:
1996: ben_prtt_enrt_result_api.delete_enrollment
1997: (p_prtt_enrt_rslt_id => l_imp_shell_enrt.prtt_enrt_rslt_id,
1998: p_per_in_ler_id => p_per_in_ler_id,

Line 2017: hr_utility.set_location('SPS c_enrt_subj_to_imp_2 is not found ', 200);

2013: open c_enrt_subj_to_imp_2('SPS');
2014: fetch c_enrt_subj_to_imp_2 into l_enrt_subj_to_imp_2;
2015: if c_enrt_subj_to_imp_2%notfound then
2016: -- check if the person is enrolled in the imputed shell plan.
2017: hr_utility.set_location('SPS c_enrt_subj_to_imp_2 is not found ', 200);
2018: open c_imp_shell_enrt('SPS');
2019: fetch c_imp_shell_enrt into l_imp_shell_enrt;
2020: if c_imp_shell_enrt%found then
2021: hr_utility.set_location('SPS l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);

Line 2021: hr_utility.set_location('SPS l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);

2017: hr_utility.set_location('SPS c_enrt_subj_to_imp_2 is not found ', 200);
2018: open c_imp_shell_enrt('SPS');
2019: fetch c_imp_shell_enrt into l_imp_shell_enrt;
2020: if c_imp_shell_enrt%found then
2021: hr_utility.set_location('SPS l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);
2022: hr_utility.set_location('kalpesh p_per_in_ler_id '||p_per_in_ler_id, 200);
2023:
2024: ben_prtt_enrt_result_api.delete_enrollment
2025: (p_prtt_enrt_rslt_id => l_imp_shell_enrt.prtt_enrt_rslt_id,

Line 2022: hr_utility.set_location('kalpesh p_per_in_ler_id '||p_per_in_ler_id, 200);

2018: open c_imp_shell_enrt('SPS');
2019: fetch c_imp_shell_enrt into l_imp_shell_enrt;
2020: if c_imp_shell_enrt%found then
2021: hr_utility.set_location('SPS l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);
2022: hr_utility.set_location('kalpesh p_per_in_ler_id '||p_per_in_ler_id, 200);
2023:
2024: ben_prtt_enrt_result_api.delete_enrollment
2025: (p_prtt_enrt_rslt_id => l_imp_shell_enrt.prtt_enrt_rslt_id,
2026: p_per_in_ler_id => p_per_in_ler_id,

Line 2046: hr_utility.set_location('DPNT c_enrt_subj_to_imp_2 is not found ', 200);

2042: open c_enrt_subj_to_imp_2('DPNT');
2043: fetch c_enrt_subj_to_imp_2 into l_enrt_subj_to_imp_2;
2044: if c_enrt_subj_to_imp_2%notfound then
2045: -- check if the person is enrolled in the imputed shell plan.
2046: hr_utility.set_location('DPNT c_enrt_subj_to_imp_2 is not found ', 200);
2047: open c_imp_shell_enrt('DPNT');
2048: fetch c_imp_shell_enrt into l_imp_shell_enrt;
2049: if c_imp_shell_enrt%found then
2050: hr_utility.set_location('DPNT l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);

Line 2050: hr_utility.set_location('DPNT l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);

2046: hr_utility.set_location('DPNT c_enrt_subj_to_imp_2 is not found ', 200);
2047: open c_imp_shell_enrt('DPNT');
2048: fetch c_imp_shell_enrt into l_imp_shell_enrt;
2049: if c_imp_shell_enrt%found then
2050: hr_utility.set_location('DPNT l_imp_shell_enrt.prtt_enrt_rslt_id '||l_imp_shell_enrt.prtt_enrt_rslt_id, 200);
2051:
2052: ben_prtt_enrt_result_api.delete_enrollment
2053: (p_prtt_enrt_rslt_id => l_imp_shell_enrt.prtt_enrt_rslt_id,
2054: p_per_in_ler_id => p_per_in_ler_id,

Line 2181: hr_utility.set_location(' Entering ' || l_proc , 11);

2177: --
2178: begin
2179: --
2180: --
2181: hr_utility.set_location(' Entering ' || l_proc , 11);
2182: hr_utility.set_location(' Calculate participant imputed income ', 10);
2183:
2184: if p_ctrlm_fido_call then
2185: --

Line 2182: hr_utility.set_location(' Calculate participant imputed income ', 10);

2178: begin
2179: --
2180: --
2181: hr_utility.set_location(' Entering ' || l_proc , 11);
2182: hr_utility.set_location(' Calculate participant imputed income ', 10);
2183:
2184: if p_ctrlm_fido_call then
2185: --
2186: dt_fndate.get_dates(

Line 2256: hr_utility.set_location(' Calculate spouse imputed income ', 10);

2252: ,p_validate => p_validate
2253: ,p_no_choice_flag => p_no_choice_flag
2254: );
2255:
2256: hr_utility.set_location(' Calculate spouse imputed income ', 10);
2257:
2258: p_comp_imp_inc_internal
2259: (p_person_id => p_person_id
2260: ,p_enrt_mthd_cd => p_enrt_mthd_cd

Line 2270: hr_utility.set_location(' Calculate dependent imputed income ', 10);

2266: ,p_validate => p_validate
2267: ,p_no_choice_flag => p_no_choice_flag
2268: );
2269:
2270: hr_utility.set_location(' Calculate dependent imputed income ', 10);
2271:
2272: p_comp_imp_inc_internal
2273: (p_person_id => p_person_id
2274: ,p_enrt_mthd_cd => p_enrt_mthd_cd

Line 2305: hr_utility.set_location(' Leaving ' || l_proc , 10);

2301: p_commit => l_commit);
2302: --
2303: end if;
2304: --
2305: hr_utility.set_location(' Leaving ' || l_proc , 10);
2306:
2307: end p_comp_imputed_income;
2308: --
2309: END ben_det_imputed_income;