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_GENERATE_DPNT_COMM dependencies on HR_UTILITY

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

17: l_outputs ff_exec.outputs_t;
18: --
19: begin
20: --
21: hr_utility.set_location('Entering: '||l_proc,10);
22: hr_utility.set_location('In Parameters',10);
23: hr_utility.set_location('p_rule_id '||p_rule_id,10);
24: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
25: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 22: hr_utility.set_location('In Parameters',10);

18: --
19: begin
20: --
21: hr_utility.set_location('Entering: '||l_proc,10);
22: hr_utility.set_location('In Parameters',10);
23: hr_utility.set_location('p_rule_id '||p_rule_id,10);
24: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
25: hr_utility.set_location('p_effective_date '||p_effective_date,10);
26: --

Line 23: hr_utility.set_location('p_rule_id '||p_rule_id,10);

19: begin
20: --
21: hr_utility.set_location('Entering: '||l_proc,10);
22: hr_utility.set_location('In Parameters',10);
23: hr_utility.set_location('p_rule_id '||p_rule_id,10);
24: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
25: hr_utility.set_location('p_effective_date '||p_effective_date,10);
26: --
27: -- Steps

Line 24: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

20: --
21: hr_utility.set_location('Entering: '||l_proc,10);
22: hr_utility.set_location('In Parameters',10);
23: hr_utility.set_location('p_rule_id '||p_rule_id,10);
24: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
25: hr_utility.set_location('p_effective_date '||p_effective_date,10);
26: --
27: -- Steps
28: -- 1. If no rule exists return true

Line 25: hr_utility.set_location('p_effective_date '||p_effective_date,10);

21: hr_utility.set_location('Entering: '||l_proc,10);
22: hr_utility.set_location('In Parameters',10);
23: hr_utility.set_location('p_rule_id '||p_rule_id,10);
24: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
25: hr_utility.set_location('p_effective_date '||p_effective_date,10);
26: --
27: -- Steps
28: -- 1. If no rule exists return true
29: -- 2. If a rule exists, evaluate rule

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

33: -- Step 1.
34: --
35: if p_rule_id is null then
36: --
37: hr_utility.set_location('Leaving: '||l_proc,10);
38: return true;
39: --
40: else
41: --

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

76: end if;
77: --
78: end if;
79: --
80: hr_utility.set_location('Leaving: '||l_proc,10);
81: --
82: end rule_passes;
83: --
84: procedure check_electable_choice_popl

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

274: l_per_cm_usg_id number;
275: --
276: begin
277: --
278: hr_utility.set_location('Entering: '||l_proc,10);
279: hr_utility.set_location('In Parameters',10);
280: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

Line 279: hr_utility.set_location('In Parameters',10);

275: --
276: begin
277: --
278: hr_utility.set_location('Entering: '||l_proc,10);
279: hr_utility.set_location('In Parameters',10);
280: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

276: begin
277: --
278: hr_utility.set_location('Entering: '||l_proc,10);
279: hr_utility.set_location('In Parameters',10);
280: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

277: --
278: hr_utility.set_location('Entering: '||l_proc,10);
279: hr_utility.set_location('In Parameters',10);
280: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

Line 282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

278: hr_utility.set_location('Entering: '||l_proc,10);
279: hr_utility.set_location('In Parameters',10);
280: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

Line 283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

279: hr_utility.set_location('In Parameters',10);
280: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

280: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

281: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);

Line 286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

282: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

283: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

Line 288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

284: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

Line 289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);

285: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
293: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 290: hr_utility.set_location('p_ler_id '||p_ler_id,10);

286: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
294: --

Line 291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

287: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
294: --
295: -- Rules are as follows

Line 292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

288: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
294: --
295: -- Rules are as follows
296: -- if p_proc_cd = 'RLTD_PER' then

Line 293: hr_utility.set_location('p_effective_date '||p_effective_date,10);

289: hr_utility.set_location('p_pl_typ_id '||p_pl_typ_id,10);
290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
294: --
295: -- Rules are as follows
296: -- if p_proc_cd = 'RLTD_PER' then
297: -- create record

Line 326: hr_utility.set_location('Communication test for BNF',10);

322: elsif p_rcpent_cd = 'BNF' then
323: --
324: if p_whnvr_trgrd_flag = 'Y' then
325: --
326: hr_utility.set_location('Communication test for BNF',10);
327: open c_bnf_always;
328: --
329: fetch c_bnf_always into l_dummy;
330: if c_bnf_always%found then

Line 332: hr_utility.set_location('Communication Created for BNF',10);

328: --
329: fetch c_bnf_always into l_dummy;
330: if c_bnf_always%found then
331: --
332: hr_utility.set_location('Communication Created for BNF',10);
333: l_created := true;
334: --
335: end if;
336: --

Line 343: hr_utility.set_location('Communication usage test for BNF',10);

339: else
340: --
341: -- We must create usages for the BNF
342: --
343: hr_utility.set_location('Communication usage test for BNF',10);
344: --
345: open c_bnf_usage;
346: --
347: loop

Line 366: hr_utility.set_location('Communication usage Created for BNF',10);

362: p_effective_date)) then
363: --
364: -- create usage
365: --
366: hr_utility.set_location('Communication usage Created for BNF',10);
367: --
368: ben_generate_communications.pop_ben_per_cm_usg_f
369: (p_per_cm_id => p_per_cm_id,
370: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 396: hr_utility.set_location('Communication test for DPNT',10);

392: elsif p_rcpent_cd = 'DPNT' then
393: --
394: if p_whnvr_trgrd_flag = 'Y' then
395: --
396: hr_utility.set_location('Communication test for DPNT',10);
397: --
398: open c_dpnt_always;
399: --
400: fetch c_dpnt_always into l_dummy;

Line 403: hr_utility.set_location('Communication created for DPNT',10);

399: --
400: fetch c_dpnt_always into l_dummy;
401: if c_dpnt_always%found then
402: --
403: hr_utility.set_location('Communication created for DPNT',10);
404: l_created := true;
405: --
406: end if;
407: --

Line 414: hr_utility.set_location('Communication usage test for DPNT',10);

410: else
411: --
412: -- We must create usages for the DPNT
413: --
414: hr_utility.set_location('Communication usage test for DPNT',10);
415: --
416: open c_dpnt_usage;
417: --
418: loop

Line 437: hr_utility.set_location('Communication usage created for DPNT',10)

433: p_effective_date)) then
434: --
435: -- create usage
436: --
437: hr_utility.set_location('Communication usage created for DPNT',10)
438: ;
439: --
440: ben_generate_communications.pop_ben_per_cm_usg_f
441: (p_per_cm_id => p_per_cm_id,

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

462: end if;
463: --
464: end if;
465: --
466: hr_utility.set_location('Leaving: '||l_proc,10);
467: --
468: p_usages_created := l_created;
469: --
470: end check_electable_choice_popl;

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

760: l_per_cm_usg_id number;
761: --
762: begin
763: --
764: hr_utility.set_location('Entering: '||l_proc,10);
765: hr_utility.set_location('In Parameters',10);
766: hr_utility.set_location('p_person_id '||p_person_id,10);
767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

Line 765: hr_utility.set_location('In Parameters',10);

761: --
762: begin
763: --
764: hr_utility.set_location('Entering: '||l_proc,10);
765: hr_utility.set_location('In Parameters',10);
766: hr_utility.set_location('p_person_id '||p_person_id,10);
767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

762: begin
763: --
764: hr_utility.set_location('Entering: '||l_proc,10);
765: hr_utility.set_location('In Parameters',10);
766: hr_utility.set_location('p_person_id '||p_person_id,10);
767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

763: --
764: hr_utility.set_location('Entering: '||l_proc,10);
765: hr_utility.set_location('In Parameters',10);
766: hr_utility.set_location('p_person_id '||p_person_id,10);
767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

Line 768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

764: hr_utility.set_location('Entering: '||l_proc,10);
765: hr_utility.set_location('In Parameters',10);
766: hr_utility.set_location('p_person_id '||p_person_id,10);
767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

Line 769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

765: hr_utility.set_location('In Parameters',10);
766: hr_utility.set_location('p_person_id '||p_person_id,10);
767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

766: hr_utility.set_location('p_person_id '||p_person_id,10);
767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

767: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

768: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);
776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

Line 773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

769: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);
776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
777: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

Line 774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

770: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);
776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
777: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
778: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 775: hr_utility.set_location('p_ler_id '||p_ler_id,10);

771: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);
776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
777: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
778: hr_utility.set_location('p_effective_date '||p_effective_date,10);
779: --

Line 776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

772: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);
776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
777: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
778: hr_utility.set_location('p_effective_date '||p_effective_date,10);
779: --
780: -- Rules are as follows

Line 777: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

773: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);
776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
777: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
778: hr_utility.set_location('p_effective_date '||p_effective_date,10);
779: --
780: -- Rules are as follows
781: -- if p_proc_cd = 'RLTD_PER' then

Line 778: hr_utility.set_location('p_effective_date '||p_effective_date,10);

774: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
775: hr_utility.set_location('p_ler_id '||p_ler_id,10);
776: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
777: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
778: hr_utility.set_location('p_effective_date '||p_effective_date,10);
779: --
780: -- Rules are as follows
781: -- if p_proc_cd = 'RLTD_PER' then
782: -- create record IF USAGE EXISTS

Line 808: hr_utility.set_location('Communication usage test for RLTD_PER',10);

804: --
805: --
806: -- We must create usages for the RLTD_PER
807: --
808: hr_utility.set_location('Communication usage test for RLTD_PER',10);
809: --
810: open c_rltd_per_usage;
811: --
812: loop

Line 831: hr_utility.set_location('Communication usage created for RLTD_PER',

827: p_effective_date)) then
828: --
829: -- create usage
830: --
831: hr_utility.set_location('Communication usage created for RLTD_PER',
832: 10);
833: --
834: ben_generate_communications.pop_ben_per_cm_usg_f
835: (p_per_cm_id => p_per_cm_id,

Line 860: hr_utility.set_location('Communication test for BNF',10);

856: elsif p_rcpent_cd = 'BNF' then
857: --
858: if p_whnvr_trgrd_flag = 'Y' then
859: --
860: hr_utility.set_location('Communication test for BNF',10);
861: open c_bnf_always;
862: --
863: fetch c_bnf_always into l_dummy;
864: if c_bnf_always%found then

Line 866: hr_utility.set_location('Communication Created for BNF',10);

862: --
863: fetch c_bnf_always into l_dummy;
864: if c_bnf_always%found then
865: --
866: hr_utility.set_location('Communication Created for BNF',10);
867: l_created := true;
868: --
869: end if;
870: --

Line 877: hr_utility.set_location('Communication usage test for BNF',10);

873: else
874: --
875: -- We must create usages for the BNF
876: --
877: hr_utility.set_location('Communication usage test for BNF',10);
878: --
879: open c_bnf_usage;
880: --
881: loop

Line 900: hr_utility.set_location('Communication usage Created for BNF',10);

896: p_effective_date)) then
897: --
898: -- create usage
899: --
900: hr_utility.set_location('Communication usage Created for BNF',10);
901: --
902: ben_generate_communications.pop_ben_per_cm_usg_f
903: (p_per_cm_id => p_per_cm_id,
904: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 930: hr_utility.set_location('Communication test for DPNT',10);

926: elsif p_rcpent_cd = 'DPNT' then
927: --
928: if p_whnvr_trgrd_flag = 'Y' then
929: --
930: hr_utility.set_location('Communication test for DPNT',10);
931: --
932: open c_dpnt_always;
933: --
934: fetch c_dpnt_always into l_dummy;

Line 937: hr_utility.set_location('Communication created for DPNT',10);

933: --
934: fetch c_dpnt_always into l_dummy;
935: if c_dpnt_always%found then
936: --
937: hr_utility.set_location('Communication created for DPNT',10);
938: l_created := true;
939: --
940: end if;
941: --

Line 948: hr_utility.set_location('Communication usage test for DPNT',10);

944: else
945: --
946: -- We must create usages for the DPNT
947: --
948: hr_utility.set_location('Communication usage test for DPNT',10);
949: --
950: open c_dpnt_usage;
951: --
952: loop

Line 971: hr_utility.set_location('Communication usage created for DPNT',10);

967: p_effective_date)) then
968: --
969: -- create usage
970: --
971: hr_utility.set_location('Communication usage created for DPNT',10);
972: --
973: ben_generate_communications.pop_ben_per_cm_usg_f
974: (p_per_cm_id => p_per_cm_id,
975: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

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

995: end if;
996: --
997: end if;
998: --
999: hr_utility.set_location('Leaving: '||l_proc,10);
1000: --
1001: p_usages_created := l_created;
1002: --
1003: end check_first_time_elig_inelig;

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

1010: l_usages_created boolean := false;
1011: --
1012: begin
1013: --
1014: hr_utility.set_location('Entering: '||l_proc,10);
1015: --
1016: -- Rules are as follows
1017: --
1018: -- If rcpent_cd = 'RLTD_PER' then

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

1027: end if;
1028: --
1029: p_usages_created := l_usages_created;
1030: --
1031: hr_utility.set_location('Leaving: '||l_proc,10);
1032: --
1033: end check_automatic_enrollment;
1034: --
1035: procedure check_no_impact_on_benefits

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

1040: l_usages_created boolean := false;
1041: --
1042: begin
1043: --
1044: hr_utility.set_location('Entering: '||l_proc,10);
1045: --
1046: -- Rules are as follows
1047: --
1048: -- If rcpent_cd = 'RLTD_PER' then

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

1057: end if;
1058: --
1059: p_usages_created := l_usages_created;
1060: --
1061: hr_utility.set_location('Leaving: '||l_proc,10);
1062: --
1063: end check_no_impact_on_benefits;
1064: --
1065: procedure check_rate_change

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

1275: l_per_cm_usg_id number;
1276: --
1277: begin
1278: --
1279: hr_utility.set_location('Entering: '||l_proc,10);
1280: hr_utility.set_location('In Parameters',10);
1281: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

Line 1280: hr_utility.set_location('In Parameters',10);

1276: --
1277: begin
1278: --
1279: hr_utility.set_location('Entering: '||l_proc,10);
1280: hr_utility.set_location('In Parameters',10);
1281: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

1277: begin
1278: --
1279: hr_utility.set_location('Entering: '||l_proc,10);
1280: hr_utility.set_location('In Parameters',10);
1281: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

1278: --
1279: hr_utility.set_location('Entering: '||l_proc,10);
1280: hr_utility.set_location('In Parameters',10);
1281: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

Line 1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

1279: hr_utility.set_location('Entering: '||l_proc,10);
1280: hr_utility.set_location('In Parameters',10);
1281: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

Line 1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

1280: hr_utility.set_location('In Parameters',10);
1281: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

1281: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

1282: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

1283: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

Line 1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

1284: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

Line 1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

1285: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1293: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);

1286: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1294: --

Line 1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

1287: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1294: --
1295: -- Rules are as follows

Line 1292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

1288: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1294: --
1295: -- Rules are as follows
1296: -- if p_proc_cd = 'RLTD_PER' then

Line 1293: hr_utility.set_location('p_effective_date '||p_effective_date,10);

1289: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1290: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1291: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1292: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1293: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1294: --
1295: -- Rules are as follows
1296: -- if p_proc_cd = 'RLTD_PER' then
1297: -- create record

Line 1326: hr_utility.set_location('Communication test for BNF',10);

1322: elsif p_rcpent_cd = 'BNF' then
1323: --
1324: if p_whnvr_trgrd_flag = 'Y' then
1325: --
1326: hr_utility.set_location('Communication test for BNF',10);
1327: open c_bnf_always;
1328: --
1329: fetch c_bnf_always into l_dummy;
1330: if c_bnf_always%found then

Line 1332: hr_utility.set_location('Communication Created for BNF',10);

1328: --
1329: fetch c_bnf_always into l_dummy;
1330: if c_bnf_always%found then
1331: --
1332: hr_utility.set_location('Communication Created for BNF',10);
1333: l_created := true;
1334: --
1335: end if;
1336: --

Line 1343: hr_utility.set_location('Communication usage test for BNF',10);

1339: else
1340: --
1341: -- We must create usages for the BNF
1342: --
1343: hr_utility.set_location('Communication usage test for BNF',10);
1344: --
1345: open c_bnf_usage;
1346: --
1347: loop

Line 1366: hr_utility.set_location('Communication usage Created for BNF',10);

1362: p_effective_date)) then
1363: --
1364: -- create usage
1365: --
1366: hr_utility.set_location('Communication usage Created for BNF',10);
1367: --
1368: ben_generate_communications.pop_ben_per_cm_usg_f
1369: (p_per_cm_id => p_per_cm_id,
1370: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 1396: hr_utility.set_location('Communication test for DPNT',10);

1392: elsif p_rcpent_cd = 'DPNT' then
1393: --
1394: if p_whnvr_trgrd_flag = 'Y' then
1395: --
1396: hr_utility.set_location('Communication test for DPNT',10);
1397: --
1398: open c_dpnt_always;
1399: --
1400: fetch c_dpnt_always into l_dummy;

Line 1403: hr_utility.set_location('Communication created for DPNT',10);

1399: --
1400: fetch c_dpnt_always into l_dummy;
1401: if c_dpnt_always%found then
1402: --
1403: hr_utility.set_location('Communication created for DPNT',10);
1404: l_created := true;
1405: --
1406: end if;
1407: --

Line 1414: hr_utility.set_location('Communication usage test for DPNT',10);

1410: else
1411: --
1412: -- We must create usages for the DPNT
1413: --
1414: hr_utility.set_location('Communication usage test for DPNT',10);
1415: --
1416: open c_dpnt_usage;
1417: --
1418: loop

Line 1437: hr_utility.set_location('Communication usage created for DPNT',10);

1433: p_effective_date)) then
1434: --
1435: -- create usage
1436: --
1437: hr_utility.set_location('Communication usage created for DPNT',10);
1438: --
1439: ben_generate_communications.pop_ben_per_cm_usg_f
1440: (p_per_cm_id => p_per_cm_id,
1441: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

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

1461: end if;
1462: --
1463: end if;
1464: --
1465: hr_utility.set_location('Leaving: '||l_proc,10);
1466: --
1467: p_usages_created := l_created;
1468: --
1469: end check_rate_change;

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

1660: l_per_cm_usg_id number;
1661: --
1662: begin
1663: --
1664: hr_utility.set_location('Entering: '||l_proc,10);
1665: hr_utility.set_location('In Parameters',10);
1666: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

Line 1665: hr_utility.set_location('In Parameters',10);

1661: --
1662: begin
1663: --
1664: hr_utility.set_location('Entering: '||l_proc,10);
1665: hr_utility.set_location('In Parameters',10);
1666: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

1662: begin
1663: --
1664: hr_utility.set_location('Entering: '||l_proc,10);
1665: hr_utility.set_location('In Parameters',10);
1666: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

1663: --
1664: hr_utility.set_location('Entering: '||l_proc,10);
1665: hr_utility.set_location('In Parameters',10);
1666: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

Line 1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

1664: hr_utility.set_location('Entering: '||l_proc,10);
1665: hr_utility.set_location('In Parameters',10);
1666: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

Line 1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

1665: hr_utility.set_location('In Parameters',10);
1666: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

1666: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

1667: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

1668: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

Line 1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

1669: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1677: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

Line 1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

1670: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1677: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1678: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);

1671: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1677: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1678: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1679: --

Line 1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);

1672: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1677: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1678: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1679: --
1680: -- Rules are as follows

Line 1677: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

1673: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1677: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1678: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1679: --
1680: -- Rules are as follows
1681: -- if p_proc_cd = 'RLTD_PER' then

Line 1678: hr_utility.set_location('p_effective_date '||p_effective_date,10);

1674: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
1675: hr_utility.set_location('p_ler_id '||p_ler_id,10);
1676: hr_utility.set_location('p_whnvr_trgrd_flag '||p_whnvr_trgrd_flag,10);
1677: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
1678: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1679: --
1680: -- Rules are as follows
1681: -- if p_proc_cd = 'RLTD_PER' then
1682: -- create record

Line 1711: hr_utility.set_location('Communication test for BNF',10);

1707: elsif p_rcpent_cd = 'BNF' then
1708: --
1709: if p_whnvr_trgrd_flag = 'Y' then
1710: --
1711: hr_utility.set_location('Communication test for BNF',10);
1712: open c_bnf_always;
1713: --
1714: fetch c_bnf_always into l_dummy;
1715: if c_bnf_always%found then

Line 1717: hr_utility.set_location('Communication Created for BNF',10);

1713: --
1714: fetch c_bnf_always into l_dummy;
1715: if c_bnf_always%found then
1716: --
1717: hr_utility.set_location('Communication Created for BNF',10);
1718: l_created := true;
1719: --
1720: end if;
1721: --

Line 1728: hr_utility.set_location('Communication usage test for BNF',10);

1724: else
1725: --
1726: -- We must create usages for the BNF
1727: --
1728: hr_utility.set_location('Communication usage test for BNF',10);
1729: --
1730: open c_bnf_usage;
1731: --
1732: loop

Line 1751: hr_utility.set_location('Communication usage Created for BNF',10);

1747: p_effective_date)) then
1748: --
1749: -- create usage
1750: --
1751: hr_utility.set_location('Communication usage Created for BNF',10);
1752: --
1753: ben_generate_communications.pop_ben_per_cm_usg_f
1754: (p_per_cm_id => p_per_cm_id,
1755: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 1781: hr_utility.set_location('Communication test for DPNT',10);

1777: elsif p_rcpent_cd = 'DPNT' then
1778: --
1779: if p_whnvr_trgrd_flag = 'Y' then
1780: --
1781: hr_utility.set_location('Communication test for DPNT',10);
1782: --
1783: open c_dpnt_always;
1784: --
1785: fetch c_dpnt_always into l_dummy;

Line 1788: hr_utility.set_location('Communication created for DPNT',10);

1784: --
1785: fetch c_dpnt_always into l_dummy;
1786: if c_dpnt_always%found then
1787: --
1788: hr_utility.set_location('Communication created for DPNT',10);
1789: l_created := true;
1790: --
1791: end if;
1792: --

Line 1799: hr_utility.set_location('Communication usage test for DPNT',10);

1795: else
1796: --
1797: -- We must create usages for the DPNT
1798: --
1799: hr_utility.set_location('Communication usage test for DPNT',10);
1800: --
1801: open c_dpnt_usage;
1802: --
1803: loop

Line 1822: hr_utility.set_location('Communication usage created for DPNT',10);

1818: p_effective_date)) then
1819: --
1820: -- create usage
1821: --
1822: hr_utility.set_location('Communication usage created for DPNT',10);
1823: --
1824: ben_generate_communications.pop_ben_per_cm_usg_f
1825: (p_per_cm_id => p_per_cm_id,
1826: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

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

1846: end if;
1847: --
1848: end if;
1849: --
1850: hr_utility.set_location('Leaving: '||l_proc,10);
1851: --
1852: p_usages_created := l_created;
1853: --
1854: end check_inelig_deenroll;

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

2014: l_per_cm_usg_id number;
2015: --
2016: begin
2017: --
2018: hr_utility.set_location('Entering: '||l_proc,10);
2019: hr_utility.set_location('In Parameters',10);
2020: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

Line 2019: hr_utility.set_location('In Parameters',10);

2015: --
2016: begin
2017: --
2018: hr_utility.set_location('Entering: '||l_proc,10);
2019: hr_utility.set_location('In Parameters',10);
2020: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

2016: begin
2017: --
2018: hr_utility.set_location('Entering: '||l_proc,10);
2019: hr_utility.set_location('In Parameters',10);
2020: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

2017: --
2018: hr_utility.set_location('Entering: '||l_proc,10);
2019: hr_utility.set_location('In Parameters',10);
2020: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

Line 2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

2018: hr_utility.set_location('Entering: '||l_proc,10);
2019: hr_utility.set_location('In Parameters',10);
2020: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

2019: hr_utility.set_location('In Parameters',10);
2020: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

2020: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

2021: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

Line 2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

2022: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
2030: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

2023: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
2030: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2031: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

Line 2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);

2024: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
2030: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2031: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2032: --

Line 2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);

2025: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
2030: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2031: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2032: --
2033: -- Rules are as follows

Line 2030: hr_utility.set_location('p_effective_date '||p_effective_date,10);

2026: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
2030: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2031: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2032: --
2033: -- Rules are as follows
2034: -- if p_proc_cd = 'RLTD_PER' then

Line 2031: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

2027: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2028: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2029: hr_utility.set_location('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,10);
2030: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2031: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2032: --
2033: -- Rules are as follows
2034: -- if p_proc_cd = 'RLTD_PER' then
2035: -- create record

Line 2064: hr_utility.set_location('Communication test for BNF',10);

2060: elsif p_rcpent_cd = 'BNF' then
2061: --
2062: if p_whnvr_trgrd_flag = 'Y' then
2063: --
2064: hr_utility.set_location('Communication test for BNF',10);
2065: open c_bnf_always;
2066: --
2067: fetch c_bnf_always into l_dummy;
2068: if c_bnf_always%found then

Line 2070: hr_utility.set_location('Communication Created for BNF',10);

2066: --
2067: fetch c_bnf_always into l_dummy;
2068: if c_bnf_always%found then
2069: --
2070: hr_utility.set_location('Communication Created for BNF',10);
2071: l_created := true;
2072: --
2073: end if;
2074: --

Line 2081: hr_utility.set_location('Communication usage test for BNF',10);

2077: else
2078: --
2079: -- We must create usages for the BNF
2080: --
2081: hr_utility.set_location('Communication usage test for BNF',10);
2082: --
2083: open c_bnf_usage;
2084: --
2085: loop

Line 2104: hr_utility.set_location('Communication usage Created for BNF',10);

2100: p_effective_date)) then
2101: --
2102: -- create usage
2103: --
2104: hr_utility.set_location('Communication usage Created for BNF',10);
2105: --
2106: ben_generate_communications.pop_ben_per_cm_usg_f
2107: (p_per_cm_id => p_per_cm_id,
2108: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 2134: hr_utility.set_location('Communication test for DPNT',10);

2130: elsif p_rcpent_cd = 'DPNT' then
2131: --
2132: if p_whnvr_trgrd_flag = 'Y' then
2133: --
2134: hr_utility.set_location('Communication test for DPNT',10);
2135: --
2136: open c_dpnt_always;
2137: --
2138: fetch c_dpnt_always into l_dummy;

Line 2141: hr_utility.set_location('Communication created for DPNT',10);

2137: --
2138: fetch c_dpnt_always into l_dummy;
2139: if c_dpnt_always%found then
2140: --
2141: hr_utility.set_location('Communication created for DPNT',10);
2142: l_created := true;
2143: --
2144: end if;
2145: --

Line 2152: hr_utility.set_location('Communication usage test for DPNT',10);

2148: else
2149: --
2150: -- We must create usages for the DPNT
2151: --
2152: hr_utility.set_location('Communication usage test for DPNT',10);
2153: --
2154: open c_dpnt_usage;
2155: --
2156: loop

Line 2175: hr_utility.set_location('Communication usage created for DPNT',10)

2171: p_effective_date)) then
2172: --
2173: -- create usage
2174: --
2175: hr_utility.set_location('Communication usage created for DPNT',10)
2176: ;
2177: --
2178: ben_generate_communications.pop_ben_per_cm_usg_f
2179: (p_per_cm_id => p_per_cm_id,

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

2200: end if;
2201: --
2202: end if;
2203: --
2204: hr_utility.set_location('Leaving: '||l_proc,10);
2205: --
2206: p_usages_created := l_created;
2207: --
2208: end check_expl_dflt_enrollment;

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

2323: l_per_cm_usg_id number;
2324: --
2325: begin
2326: --
2327: hr_utility.set_location('Entering: '||l_proc,10);
2328: hr_utility.set_location('In Parameters',10);
2329: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 2328: hr_utility.set_location('In Parameters',10);

2324: --
2325: begin
2326: --
2327: hr_utility.set_location('Entering: '||l_proc,10);
2328: hr_utility.set_location('In Parameters',10);
2329: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

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

2325: begin
2326: --
2327: hr_utility.set_location('Entering: '||l_proc,10);
2328: hr_utility.set_location('In Parameters',10);
2329: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

2326: --
2327: hr_utility.set_location('Entering: '||l_proc,10);
2328: hr_utility.set_location('In Parameters',10);
2329: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

2327: hr_utility.set_location('Entering: '||l_proc,10);
2328: hr_utility.set_location('In Parameters',10);
2329: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2335: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

2328: hr_utility.set_location('In Parameters',10);
2329: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2335: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2336: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

Line 2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

2329: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2335: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2336: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2337: --

Line 2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);

2330: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2335: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2336: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2337: --
2338: -- Rules are as follows

Line 2335: hr_utility.set_location('p_effective_date '||p_effective_date,10);

2331: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2335: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2336: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2337: --
2338: -- Rules are as follows
2339: -- if p_proc_cd = 'RLTD_PER' then

Line 2336: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

2332: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2333: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2334: hr_utility.set_location('p_ler_id '||p_ler_id,10);
2335: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2336: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2337: --
2338: -- Rules are as follows
2339: -- if p_proc_cd = 'RLTD_PER' then
2340: -- create record

Line 2369: hr_utility.set_location('Communication test for BNF',10);

2365: elsif p_rcpent_cd = 'BNF' then
2366: --
2367: if p_whnvr_trgrd_flag = 'Y' then
2368: --
2369: hr_utility.set_location('Communication test for BNF',10);
2370: open c_bnf_always;
2371: --
2372: fetch c_bnf_always into l_dummy;
2373: if c_bnf_always%found then

Line 2375: hr_utility.set_location('Communication Created for BNF',10);

2371: --
2372: fetch c_bnf_always into l_dummy;
2373: if c_bnf_always%found then
2374: --
2375: hr_utility.set_location('Communication Created for BNF',10);
2376: l_created := true;
2377: --
2378: end if;
2379: --

Line 2386: hr_utility.set_location('Communication usage test for BNF',10);

2382: else
2383: --
2384: -- We must create usages for the BNF
2385: --
2386: hr_utility.set_location('Communication usage test for BNF',10);
2387: --
2388: open c_bnf_usage;
2389: --
2390: loop

Line 2409: hr_utility.set_location('Communication usage Created for BNF',10);

2405: p_effective_date)) then
2406: --
2407: -- create usage
2408: --
2409: hr_utility.set_location('Communication usage Created for BNF',10);
2410: --
2411: ben_generate_communications.pop_ben_per_cm_usg_f
2412: (p_per_cm_id => p_per_cm_id,
2413: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 2439: hr_utility.set_location('Communication test for DPNT',10);

2435: elsif p_rcpent_cd = 'DPNT' then
2436: --
2437: if p_whnvr_trgrd_flag = 'Y' then
2438: --
2439: hr_utility.set_location('Communication test for DPNT',10);
2440: --
2441: open c_dpnt_always;
2442: --
2443: fetch c_dpnt_always into l_dummy;

Line 2446: hr_utility.set_location('Communication created for DPNT',10);

2442: --
2443: fetch c_dpnt_always into l_dummy;
2444: if c_dpnt_always%found then
2445: --
2446: hr_utility.set_location('Communication created for DPNT',10);
2447: l_created := true;
2448: --
2449: end if;
2450: --

Line 2457: hr_utility.set_location('Communication usage test for DPNT',10);

2453: else
2454: --
2455: -- We must create usages for the DPNT
2456: --
2457: hr_utility.set_location('Communication usage test for DPNT',10);
2458: --
2459: open c_dpnt_usage;
2460: --
2461: loop

Line 2480: hr_utility.set_location('Communication usage created for DPNT',10)

2476: p_effective_date)) then
2477: --
2478: -- create usage
2479: --
2480: hr_utility.set_location('Communication usage created for DPNT',10)
2481: ;
2482: --
2483: ben_generate_communications.pop_ben_per_cm_usg_f
2484: (p_per_cm_id => p_per_cm_id,

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

2505: end if;
2506: --
2507: end if;
2508: --
2509: hr_utility.set_location('Leaving: '||l_proc,10);
2510: --
2511: p_usages_created := l_created;
2512: --
2513: end check_close_enrollment;

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

2693: l_per_cm_usg_id number;
2694: --
2695: begin
2696: --
2697: hr_utility.set_location('Entering: '||l_proc,10);
2698: hr_utility.set_location('In Parameters',10);
2699: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 2698: hr_utility.set_location('In Parameters',10);

2694: --
2695: begin
2696: --
2697: hr_utility.set_location('Entering: '||l_proc,10);
2698: hr_utility.set_location('In Parameters',10);
2699: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

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

2695: begin
2696: --
2697: hr_utility.set_location('Entering: '||l_proc,10);
2698: hr_utility.set_location('In Parameters',10);
2699: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);

Line 2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

2696: --
2697: hr_utility.set_location('Entering: '||l_proc,10);
2698: hr_utility.set_location('In Parameters',10);
2699: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);

Line 2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

2697: hr_utility.set_location('Entering: '||l_proc,10);
2698: hr_utility.set_location('In Parameters',10);
2699: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);

2698: hr_utility.set_location('In Parameters',10);
2699: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);

2699: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2707: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);

2700: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2707: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2708: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

Line 2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

2701: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2707: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2708: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2709: --

Line 2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

2702: hr_utility.set_location('p_actn_typ_id '||p_actn_typ_id,10);
2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2707: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2708: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2709: --
2710: -- Rules are as follows

Line 2707: hr_utility.set_location('p_effective_date '||p_effective_date,10);

2703: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2707: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2708: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2709: --
2710: -- Rules are as follows
2711: -- if p_proc_cd = 'RLTD_PER' then

Line 2708: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

2704: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2705: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2706: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2707: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2708: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2709: --
2710: -- Rules are as follows
2711: -- if p_proc_cd = 'RLTD_PER' then
2712: -- create record

Line 2741: hr_utility.set_location('Communication test for BNF',10);

2737: elsif p_rcpent_cd = 'BNF' then
2738: --
2739: if p_whnvr_trgrd_flag = 'Y' then
2740: --
2741: hr_utility.set_location('Communication test for BNF',10);
2742: open c_bnf_always;
2743: --
2744: fetch c_bnf_always into l_dummy;
2745: if c_bnf_always%found then

Line 2747: hr_utility.set_location('Communication Created for BNF',10);

2743: --
2744: fetch c_bnf_always into l_dummy;
2745: if c_bnf_always%found then
2746: --
2747: hr_utility.set_location('Communication Created for BNF',10);
2748: l_created := true;
2749: --
2750: end if;
2751: --

Line 2758: hr_utility.set_location('Communication usage test for BNF',10);

2754: else
2755: --
2756: -- We must create usages for the BNF
2757: --
2758: hr_utility.set_location('Communication usage test for BNF',10);
2759: --
2760: open c_bnf_usage;
2761: --
2762: loop

Line 2781: hr_utility.set_location('Communication usage Created for BNF',10);

2777: p_effective_date)) then
2778: --
2779: -- create usage
2780: --
2781: hr_utility.set_location('Communication usage Created for BNF',10);
2782: --
2783: ben_generate_communications.pop_ben_per_cm_usg_f
2784: (p_per_cm_id => p_per_cm_id,
2785: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 2811: hr_utility.set_location('Communication test for DPNT',10);

2807: elsif p_rcpent_cd = 'DPNT' then
2808: --
2809: if p_whnvr_trgrd_flag = 'Y' then
2810: --
2811: hr_utility.set_location('Communication test for DPNT',10);
2812: --
2813: open c_dpnt_always;
2814: --
2815: fetch c_dpnt_always into l_dummy;

Line 2818: hr_utility.set_location('Communication created for DPNT',10);

2814: --
2815: fetch c_dpnt_always into l_dummy;
2816: if c_dpnt_always%found then
2817: --
2818: hr_utility.set_location('Communication created for DPNT',10);
2819: l_created := true;
2820: --
2821: end if;
2822: --

Line 2829: hr_utility.set_location('Communication usage test for DPNT',10);

2825: else
2826: --
2827: -- We must create usages for the DPNT
2828: --
2829: hr_utility.set_location('Communication usage test for DPNT',10);
2830: --
2831: open c_dpnt_usage;
2832: --
2833: loop

Line 2852: hr_utility.set_location('Communication usage created for DPNT',10)

2848: p_effective_date)) then
2849: --
2850: -- create usage
2851: --
2852: hr_utility.set_location('Communication usage created for DPNT',10)
2853: ;
2854: --
2855: ben_generate_communications.pop_ben_per_cm_usg_f
2856: (p_per_cm_id => p_per_cm_id,

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

2877: end if;
2878: --
2879: end if;
2880: --
2881: hr_utility.set_location('Leaving: '||l_proc,10);
2882: --
2883: p_usages_created := l_created;
2884: --
2885: end check_actn_item;

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

2963: l_proc varchar2(80) := g_package || '.check_dpnt_end_enrt';
2964: --
2965: begin
2966: --
2967: hr_utility.set_location('Entering : ' || l_proc, 10);
2968: --
2969: hr_utility.set_location('In Parameters',10);
2970: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

Line 2969: hr_utility.set_location('In Parameters',10);

2965: begin
2966: --
2967: hr_utility.set_location('Entering : ' || l_proc, 10);
2968: --
2969: hr_utility.set_location('In Parameters',10);
2970: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

2966: --
2967: hr_utility.set_location('Entering : ' || l_proc, 10);
2968: --
2969: hr_utility.set_location('In Parameters',10);
2970: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

2967: hr_utility.set_location('Entering : ' || l_proc, 10);
2968: --
2969: hr_utility.set_location('In Parameters',10);
2970: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);

Line 2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

2968: --
2969: hr_utility.set_location('In Parameters',10);
2970: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);

Line 2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

2969: hr_utility.set_location('In Parameters',10);
2970: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

2970: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);

2971: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2979: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);

2972: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2979: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2980: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

Line 2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

2973: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2979: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2980: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2981: --

Line 2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

2974: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2979: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2980: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2981: --
2982: -- Rules are as follows

Line 2979: hr_utility.set_location('p_effective_date '||p_effective_date,10);

2975: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2979: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2980: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2981: --
2982: -- Rules are as follows
2983: -- if p_proc_cd = 'RLTD_PER' then

Line 2980: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

2976: hr_utility.set_location('p_pl_id '||p_pl_id,10);
2977: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
2978: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
2979: hr_utility.set_location('p_effective_date '||p_effective_date,10);
2980: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
2981: --
2982: -- Rules are as follows
2983: -- if p_proc_cd = 'RLTD_PER' then
2984: -- dont create record

Line 3010: hr_utility.set_location('Communication test for DPNT',10);

3006: elsif p_rcpent_cd = 'DPNT' then
3007: --
3008: if p_whnvr_trgrd_flag = 'Y' then
3009: --
3010: hr_utility.set_location('Communication test for DPNT',10);
3011: --
3012: open c_dpnt_always;
3013: --
3014: fetch c_dpnt_always into l_dummy;

Line 3017: hr_utility.set_location('Communication created for DPNT',10);

3013: --
3014: fetch c_dpnt_always into l_dummy;
3015: if c_dpnt_always%found then
3016: --
3017: hr_utility.set_location('Communication created for DPNT',10);
3018: l_created := true;
3019: --
3020: end if;
3021: --

Line 3028: hr_utility.set_location('Communication usage test for DPNT',10);

3024: else
3025: --
3026: -- We must create usages for the DPNT
3027: --
3028: hr_utility.set_location('Communication usage test for DPNT',10);
3029: --
3030: open c_dpnt_usage;
3031: --
3032: loop

Line 3051: hr_utility.set_location('Communication usage created for DPNT',10)

3047: p_effective_date)) then
3048: --
3049: -- create usage
3050: --
3051: hr_utility.set_location('Communication usage created for DPNT',10)
3052: ;
3053: --
3054: ben_generate_communications.pop_ben_per_cm_usg_f
3055: (p_per_cm_id => p_per_cm_id,

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

3076: end if;
3077: --
3078: end if;
3079: --
3080: hr_utility.set_location('Leaving: '||l_proc,10);
3081: --
3082: p_usages_created := l_created;
3083: --
3084: end check_dpnt_end_enrt;

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

3225: l_proc varchar2(80) := g_package || '.check_mass_mail';
3226: --
3227: begin
3228: --
3229: hr_utility.set_location('Entering : ' || l_proc, 10);
3230: --
3231: hr_utility.set_location('In Parameters',10);
3232: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

Line 3231: hr_utility.set_location('In Parameters',10);

3227: begin
3228: --
3229: hr_utility.set_location('Entering : ' || l_proc, 10);
3230: --
3231: hr_utility.set_location('In Parameters',10);
3232: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

3228: --
3229: hr_utility.set_location('Entering : ' || l_proc, 10);
3230: --
3231: hr_utility.set_location('In Parameters',10);
3232: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

3229: hr_utility.set_location('Entering : ' || l_proc, 10);
3230: --
3231: hr_utility.set_location('In Parameters',10);
3232: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);

Line 3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

3230: --
3231: hr_utility.set_location('In Parameters',10);
3232: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);

Line 3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

3231: hr_utility.set_location('In Parameters',10);
3232: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

3232: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);

3233: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3241: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);

3234: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3241: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3242: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

Line 3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

3235: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3241: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3242: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
3243: --

Line 3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

3236: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3241: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3242: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
3243: --
3244: -- Rules are as follows

Line 3241: hr_utility.set_location('p_effective_date '||p_effective_date,10);

3237: hr_utility.set_location('p_pgm_id '||p_pgm_id,10);
3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3241: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3242: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
3243: --
3244: -- Rules are as follows
3245: -- if p_proc_cd = 'RLTD_PER' then

Line 3242: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);

3238: hr_utility.set_location('p_pl_id '||p_pl_id,10);
3239: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3240: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3241: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3242: hr_utility.set_location('p_whnvr_trgrd_flag ' || p_whnvr_trgrd_flag, 10);
3243: --
3244: -- Rules are as follows
3245: -- if p_proc_cd = 'RLTD_PER' then
3246: -- create record

Line 3275: hr_utility.set_location('Communication test for BNF',10);

3271: elsif p_rcpent_cd = 'BNF' then
3272: --
3273: if p_whnvr_trgrd_flag = 'Y' then
3274: --
3275: hr_utility.set_location('Communication test for BNF',10);
3276: open c_bnf_always;
3277: --
3278: fetch c_bnf_always into l_dummy;
3279: if c_bnf_always%found then

Line 3281: hr_utility.set_location('Communication Created for BNF',10);

3277: --
3278: fetch c_bnf_always into l_dummy;
3279: if c_bnf_always%found then
3280: --
3281: hr_utility.set_location('Communication Created for BNF',10);
3282: l_created := true;
3283: --
3284: end if;
3285: --

Line 3292: hr_utility.set_location('Communication usage test for BNF',10);

3288: else
3289: --
3290: -- We must create usages for the BNF
3291: --
3292: hr_utility.set_location('Communication usage test for BNF',10);
3293: --
3294: open c_bnf_usage;
3295: --
3296: loop

Line 3315: hr_utility.set_location('Communication usage Created for BNF',10);

3311: p_effective_date)) then
3312: --
3313: -- create usage
3314: --
3315: hr_utility.set_location('Communication usage Created for BNF',10);
3316: --
3317: ben_generate_communications.pop_ben_per_cm_usg_f
3318: (p_per_cm_id => p_per_cm_id,
3319: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 3345: hr_utility.set_location('Communication test for DPNT',10);

3341: elsif p_rcpent_cd = 'DPNT' then
3342: --
3343: if p_whnvr_trgrd_flag = 'Y' then
3344: --
3345: hr_utility.set_location('Communication test for DPNT',10);
3346: --
3347: open c_dpnt_always;
3348: --
3349: fetch c_dpnt_always into l_dummy;

Line 3352: hr_utility.set_location('Communication created for DPNT',10);

3348: --
3349: fetch c_dpnt_always into l_dummy;
3350: if c_dpnt_always%found then
3351: --
3352: hr_utility.set_location('Communication created for DPNT',10);
3353: l_created := true;
3354: --
3355: end if;
3356: --

Line 3363: hr_utility.set_location('Communication usage test for DPNT',10);

3359: else
3360: --
3361: -- We must create usages for the DPNT
3362: --
3363: hr_utility.set_location('Communication usage test for DPNT',10);
3364: --
3365: open c_dpnt_usage;
3366: --
3367: loop

Line 3386: hr_utility.set_location('Communication usage created for DPNT',10)

3382: p_effective_date)) then
3383: --
3384: -- create usage
3385: --
3386: hr_utility.set_location('Communication usage created for DPNT',10)
3387: ;
3388: --
3389: ben_generate_communications.pop_ben_per_cm_usg_f
3390: (p_per_cm_id => p_per_cm_id,

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

3411: end if;
3412: --
3413: end if;
3414: --
3415: hr_utility.set_location('Leaving: '||l_proc,10);
3416: --
3417: p_usages_created := l_created;
3418: --
3419: end check_mass_mail;

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

3570: l_per_cm_usg_id number;
3571: --
3572: begin
3573: --
3574: hr_utility.set_location('Entering: '||l_proc,10);
3575: hr_utility.set_location('In Parameters',10);
3576: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

Line 3575: hr_utility.set_location('In Parameters',10);

3571: --
3572: begin
3573: --
3574: hr_utility.set_location('Entering: '||l_proc,10);
3575: hr_utility.set_location('In Parameters',10);
3576: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

3572: begin
3573: --
3574: hr_utility.set_location('Entering: '||l_proc,10);
3575: hr_utility.set_location('In Parameters',10);
3576: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

3573: --
3574: hr_utility.set_location('Entering: '||l_proc,10);
3575: hr_utility.set_location('In Parameters',10);
3576: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

Line 3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

3574: hr_utility.set_location('Entering: '||l_proc,10);
3575: hr_utility.set_location('In Parameters',10);
3576: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

3575: hr_utility.set_location('In Parameters',10);
3576: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

3576: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3584: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

3577: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3584: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3585: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

3578: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3584: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3585: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3586: --

Line 3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

3579: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3584: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3585: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3586: --
3587: -- Rules are as follows

Line 3584: hr_utility.set_location('p_ler_id '||p_ler_id,10);

3580: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3584: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3585: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3586: --
3587: -- Rules are as follows
3588: -- if p_proc_cd = 'RLTD_PER' then

Line 3585: hr_utility.set_location('p_effective_date '||p_effective_date,10);

3581: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3582: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3583: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3584: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3585: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3586: --
3587: -- Rules are as follows
3588: -- if p_proc_cd = 'RLTD_PER' then
3589: -- create record

Line 3618: hr_utility.set_location('Communication test for BNF',10);

3614: elsif p_rcpent_cd = 'BNF' then
3615: --
3616: if p_whnvr_trgrd_flag = 'Y' then
3617: --
3618: hr_utility.set_location('Communication test for BNF',10);
3619: open c_bnf_always;
3620: --
3621: fetch c_bnf_always into l_dummy;
3622: if c_bnf_always%found then

Line 3624: hr_utility.set_location('Communication Created for BNF',10);

3620: --
3621: fetch c_bnf_always into l_dummy;
3622: if c_bnf_always%found then
3623: --
3624: hr_utility.set_location('Communication Created for BNF',10);
3625: l_created := true;
3626: --
3627: end if;
3628: --

Line 3635: hr_utility.set_location('Communication usage test for BNF',10);

3631: else
3632: --
3633: -- We must create usages for the BNF
3634: --
3635: hr_utility.set_location('Communication usage test for BNF',10);
3636: --
3637: open c_bnf_usage;
3638: --
3639: loop

Line 3658: hr_utility.set_location('Communication usage Created for BNF',10);

3654: p_effective_date)) then
3655: --
3656: -- create usage
3657: --
3658: hr_utility.set_location('Communication usage Created for BNF',10);
3659: --
3660: ben_generate_communications.pop_ben_per_cm_usg_f
3661: (p_per_cm_id => p_per_cm_id,
3662: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 3688: hr_utility.set_location('Communication test for DPNT',10);

3684: elsif p_rcpent_cd = 'DPNT' then
3685: --
3686: if p_whnvr_trgrd_flag = 'Y' then
3687: --
3688: hr_utility.set_location('Communication test for DPNT',10);
3689: --
3690: open c_dpnt_always;
3691: --
3692: fetch c_dpnt_always into l_dummy;

Line 3695: hr_utility.set_location('Communication created for DPNT',10);

3691: --
3692: fetch c_dpnt_always into l_dummy;
3693: if c_dpnt_always%found then
3694: --
3695: hr_utility.set_location('Communication created for DPNT',10);
3696: l_created := true;
3697: --
3698: end if;
3699: --

Line 3706: hr_utility.set_location('Communication usage test for DPNT',10);

3702: else
3703: --
3704: -- We must create usages for the DPNT
3705: --
3706: hr_utility.set_location('Communication usage test for DPNT',10);
3707: --
3708: open c_dpnt_usage;
3709: --
3710: loop

Line 3729: hr_utility.set_location('Communication usage created for DPNT',10)

3725: p_effective_date)) then
3726: --
3727: -- create usage
3728: --
3729: hr_utility.set_location('Communication usage created for DPNT',10)
3730: ;
3731: --
3732: ben_generate_communications.pop_ben_per_cm_usg_f
3733: (p_per_cm_id => p_per_cm_id,

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

3754: end if;
3755: --
3756: end if;
3757: --
3758: hr_utility.set_location('Leaving: '||l_proc,10);
3759: --
3760: p_usages_created := l_created;
3761: --
3762: end check_enrt_rmdr;

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

3911: l_per_cm_usg_id number;
3912: --
3913: begin
3914: --
3915: hr_utility.set_location('Entering: '||l_proc,10);
3916: hr_utility.set_location('In Parameters',10);
3917: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

Line 3916: hr_utility.set_location('In Parameters',10);

3912: --
3913: begin
3914: --
3915: hr_utility.set_location('Entering: '||l_proc,10);
3916: hr_utility.set_location('In Parameters',10);
3917: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

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

3913: begin
3914: --
3915: hr_utility.set_location('Entering: '||l_proc,10);
3916: hr_utility.set_location('In Parameters',10);
3917: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

Line 3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);

3914: --
3915: hr_utility.set_location('Entering: '||l_proc,10);
3916: hr_utility.set_location('In Parameters',10);
3917: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

Line 3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);

3915: hr_utility.set_location('Entering: '||l_proc,10);
3916: hr_utility.set_location('In Parameters',10);
3917: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

Line 3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);

3916: hr_utility.set_location('In Parameters',10);
3917: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

Line 3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);

3917: hr_utility.set_location('p_per_in_ler_id '||p_per_in_ler_id,10);
3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3925: hr_utility.set_location('p_ler_id '||p_ler_id,10);

Line 3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);

3918: hr_utility.set_location('p_rcpent_person_id '||p_rcpent_person_id,10);
3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3925: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3926: hr_utility.set_location('p_effective_date '||p_effective_date,10);

Line 3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);

3919: hr_utility.set_location('p_rcpent_cd '||p_rcpent_cd,10);
3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3925: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3926: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3927: --

Line 3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);

3920: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3925: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3926: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3927: --
3928: -- Rules are as follows

Line 3925: hr_utility.set_location('p_ler_id '||p_ler_id,10);

3921: hr_utility.set_location('p_assignment_id '||p_assignment_id,10);
3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3925: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3926: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3927: --
3928: -- Rules are as follows
3929: -- if p_proc_cd = 'RLTD_PER' then

Line 3926: hr_utility.set_location('p_effective_date '||p_effective_date,10);

3922: -- hr_utility.set_location('p_enrt_perd_id '||p_enrt_perd_id,10);
3923: hr_utility.set_location('p_per_cm_id '||p_per_cm_id,10);
3924: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,10);
3925: hr_utility.set_location('p_ler_id '||p_ler_id,10);
3926: hr_utility.set_location('p_effective_date '||p_effective_date,10);
3927: --
3928: -- Rules are as follows
3929: -- if p_proc_cd = 'RLTD_PER' then
3930: -- create record

Line 3959: hr_utility.set_location('Communication test for BNF',10);

3955: elsif p_rcpent_cd = 'BNF' then
3956: --
3957: if p_whnvr_trgrd_flag = 'Y' then
3958: --
3959: hr_utility.set_location('Communication test for BNF',10);
3960: open c_bnf_always;
3961: --
3962: fetch c_bnf_always into l_dummy;
3963: if c_bnf_always%found then

Line 3965: hr_utility.set_location('Communication Created for BNF',10);

3961: --
3962: fetch c_bnf_always into l_dummy;
3963: if c_bnf_always%found then
3964: --
3965: hr_utility.set_location('Communication Created for BNF',10);
3966: l_created := true;
3967: --
3968: end if;
3969: --

Line 3976: hr_utility.set_location('Communication usage test for BNF',10);

3972: else
3973: --
3974: -- We must create usages for the BNF
3975: --
3976: hr_utility.set_location('Communication usage test for BNF',10);
3977: --
3978: open c_bnf_usage;
3979: --
3980: loop

Line 3999: hr_utility.set_location('Communication usage Created for BNF',10);

3995: p_effective_date)) then
3996: --
3997: -- create usage
3998: --
3999: hr_utility.set_location('Communication usage Created for BNF',10);
4000: --
4001: ben_generate_communications.pop_ben_per_cm_usg_f
4002: (p_per_cm_id => p_per_cm_id,
4003: p_cm_typ_usg_id => l_usage.cm_typ_usg_id,

Line 4029: hr_utility.set_location('Communication test for DPNT',10);

4025: elsif p_rcpent_cd = 'DPNT' then
4026: --
4027: if p_whnvr_trgrd_flag = 'Y' then
4028: --
4029: hr_utility.set_location('Communication test for DPNT',10);
4030: --
4031: open c_dpnt_always;
4032: --
4033: fetch c_dpnt_always into l_dummy;

Line 4036: hr_utility.set_location('Communication created for DPNT',10);

4032: --
4033: fetch c_dpnt_always into l_dummy;
4034: if c_dpnt_always%found then
4035: --
4036: hr_utility.set_location('Communication created for DPNT',10);
4037: l_created := true;
4038: --
4039: end if;
4040: --

Line 4047: hr_utility.set_location('Communication usage test for DPNT',10);

4043: else
4044: --
4045: -- We must create usages for the DPNT
4046: --
4047: hr_utility.set_location('Communication usage test for DPNT',10);
4048: --
4049: open c_dpnt_usage;
4050: --
4051: loop

Line 4070: hr_utility.set_location('Communication usage created for DPNT',10)

4066: p_effective_date)) then
4067: --
4068: -- create usage
4069: --
4070: hr_utility.set_location('Communication usage created for DPNT',10)
4071: ;
4072: --
4073: ben_generate_communications.pop_ben_per_cm_usg_f
4074: (p_per_cm_id => p_per_cm_id,

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

4095: end if;
4096: --
4097: end if;
4098: --
4099: hr_utility.set_location('Leaving: '||l_proc,10);
4100: --
4101: p_usages_created := l_created;
4102: --
4103: end check_emrg_evt;

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

4179: l_per_cm_usg_id number;
4180: --
4181: begin
4182: --
4183: hr_utility.set_location('Entering: '||l_proc,10);
4184: --
4185: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
4186: --
4187: if p_whnvr_trgrd_flag = 'N' then

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

4234: l_created := true;
4235: --
4236: end if;
4237: --
4238: hr_utility.set_location('Leaving: '||l_proc,10);
4239: --
4240: p_usages_created := l_created;
4241: --
4242: end check_hipaa_usages;

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

4530: -- plan type. If not, check for any enrollment opportunity available
4531: -- to enroll in that plan type. If there are no enrollment opportunity,
4532: -- then generate the neccessary HIPAA comm.
4533: --
4534: hr_utility.set_location('Entering: '||l_proc,10);
4535: --
4536: ben_person_object.get_object(p_person_id => p_rcpent_person_id,
4537: p_rec => l_per_rec);
4538: ben_person_object.get_object(p_person_id => p_person_id,

Line 4550: hr_utility.set_location('Before loop '||l_proc,20);

4546: return;
4547: --
4548: end if;
4549: --
4550: hr_utility.set_location('Before loop '||l_proc,20);
4551: --
4552: if p_source = 'bendsgel' then
4553: --
4554: open c_bendsgel_prev_enrt;

Line 4588: hr_utility.set_location('In loop: '||l_proc,30);

4584: end if;
4585: --
4586: end if;
4587: --
4588: hr_utility.set_location('In loop: '||l_proc,30);
4589: --
4590: -- When the participant is de-enrolled from a plan, the dependents
4591: -- also get de-enrolled. But in this case, we generate comm. for
4592: -- dpnt. only if they do not reside with the participant.

Line 4603: hr_utility.set_location('p_rsds_with_prtt: '||p_rsds_with_prtt,40);

4599: --
4600: l_epe_exists := 'N';
4601: l_crntly_enrd := 'N';
4602: l_prtt_crntly_enrd := 'N';
4603: hr_utility.set_location('p_rsds_with_prtt: '||p_rsds_with_prtt,40);
4604: --
4605: open c_crntly_enrd;
4606: fetch c_crntly_enrd into l_crntly_enrd;
4607: close c_crntly_enrd;

Line 4610: hr_utility.set_location('Not currently enrld: ',40);

4606: fetch c_crntly_enrd into l_crntly_enrd;
4607: close c_crntly_enrd;
4608: --
4609: if l_crntly_enrd = 'N' then
4610: hr_utility.set_location('Not currently enrld: ',40);
4611: --
4612: -- If dependent resides with the participant, generate a
4613: -- communication only if the participant is still enrolled.
4614: --

Line 4621: hr_utility.set_location('p_person_id: '||p_person_id,40);

4617: l_prtt_per_rec.date_of_death is null) then
4618: --
4619: -- Check if the participant is still enrolled.
4620: --
4621: hr_utility.set_location('p_person_id: '||p_person_id,40);
4622: hr_utility.set_location('p_pl_typ_id: '||l_pl_typ_id,40);
4623: open c_prtt_crntly_enrd;
4624: fetch c_prtt_crntly_enrd into l_prtt_crntly_enrd;
4625: close c_prtt_crntly_enrd;

Line 4622: hr_utility.set_location('p_pl_typ_id: '||l_pl_typ_id,40);

4618: --
4619: -- Check if the participant is still enrolled.
4620: --
4621: hr_utility.set_location('p_person_id: '||p_person_id,40);
4622: hr_utility.set_location('p_pl_typ_id: '||l_pl_typ_id,40);
4623: open c_prtt_crntly_enrd;
4624: fetch c_prtt_crntly_enrd into l_prtt_crntly_enrd;
4625: close c_prtt_crntly_enrd;
4626:

Line 4634: hr_utility.set_location('l_prtt_crntly_enrd: '||l_prtt_crntly_enrd,40);

4630: fetch c_prtt_epe into l_prtt_epe_exists;
4631: close c_prtt_epe;
4632:
4633: end if;
4634: hr_utility.set_location('l_prtt_crntly_enrd: '||l_prtt_crntly_enrd,40);
4635: -- 3585939
4636: if ( (l_prtt_crntly_enrd = 'Y' or l_prtt_epe_exists = 'Y')
4637: or
4638: l_max_enrt_cvg_thru_dt = hr_api.g_eot or

Line 4642: hr_utility.set_location('No Epe: '||l_proc,40);

4638: l_max_enrt_cvg_thru_dt = hr_api.g_eot or
4639: p_rsds_with_prtt = 'N' or
4640: l_prtt_per_rec.date_of_death is not null) then
4641: --
4642: hr_utility.set_location('No Epe: '||l_proc,40);
4643: --
4644: open c_epe;
4645: fetch c_epe into l_epe_exists;
4646: close c_epe;

Line 4650: hr_utility.set_location('No result: '||l_proc,50);

4646: close c_epe;
4647: --
4648: if l_epe_exists = 'N' then
4649: --
4650: hr_utility.set_location('No result: '||l_proc,50);
4651: --
4652: check_hipaa_usages
4653: (p_per_in_ler_id => p_per_in_ler_id,
4654: p_person_id => p_rcpent_person_id,

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

4685: end loop;
4686: --
4687: p_usages_created := l_usages_created;
4688: --
4689: hr_utility.set_location('Leaving: '||l_proc,10);
4690: --
4691: end check_hipaa_ctfn;
4692: --
4693: procedure main

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

4748: --
4749: -- Bug 6770385
4750: begin
4751: --
4752: hr_utility.set_location('Entering: '||l_proc,10);
4753: --
4754: -- hr_utility.set_location('In Parameters',10);
4755: -- hr_utility.set_location('-------------',10);
4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);

Line 4754: -- hr_utility.set_location('In Parameters',10);

4750: begin
4751: --
4752: hr_utility.set_location('Entering: '||l_proc,10);
4753: --
4754: -- hr_utility.set_location('In Parameters',10);
4755: -- hr_utility.set_location('-------------',10);
4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);
4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);

Line 4755: -- hr_utility.set_location('-------------',10);

4751: --
4752: hr_utility.set_location('Entering: '||l_proc,10);
4753: --
4754: -- hr_utility.set_location('In Parameters',10);
4755: -- hr_utility.set_location('-------------',10);
4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);
4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);

Line 4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);

4752: hr_utility.set_location('Entering: '||l_proc,10);
4753: --
4754: -- hr_utility.set_location('In Parameters',10);
4755: -- hr_utility.set_location('-------------',10);
4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);
4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);

Line 4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);

4753: --
4754: -- hr_utility.set_location('In Parameters',10);
4755: -- hr_utility.set_location('-------------',10);
4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);
4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);

Line 4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);

4754: -- hr_utility.set_location('In Parameters',10);
4755: -- hr_utility.set_location('-------------',10);
4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);
4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);

Line 4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);

4755: -- hr_utility.set_location('-------------',10);
4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);
4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);

Line 4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);

4756: -- hr_utility.set_location('p_proc_cd ='||p_proc_cd,10);
4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);

Line 4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);

4757: -- hr_utility.set_location('p_rcpent_cd ='||p_rcpent_cd,10);
4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);

Line 4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);

4758: -- hr_utility.set_location('p_person_id ='||p_person_id,10);
4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);

Line 4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);

4759: -- hr_utility.set_location('p_per_in_ler_id ='||p_per_in_ler_id,10);
4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);

Line 4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);

4760: -- hr_utility.set_location('p_business_group_id ='||p_business_group_id,10);
4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);

Line 4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);

4761: -- hr_utility.set_location('p_assignment_id ='||p_assignment_id,10);
4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);

Line 4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);

4762: -- hr_utility.set_location('p_prtt_enrt_actn_id ='||p_prtt_enrt_actn_id,10);
4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);

Line 4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);

4763: -- hr_utility.set_location('p_enrt_perd_id ='||p_enrt_perd_id,10);
4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);

Line 4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);

4764: -- hr_utility.set_location('p_enrt_mthd_cd ='||p_enrt_mthd_cd,10);
4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);

Line 4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);

4765: -- hr_utility.set_location('p_actn_typ_id ='||p_actn_typ_id,10);
4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);

Line 4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);

4766: -- hr_utility.set_location('p_per_cm_id ='||p_per_cm_id,10);
4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);

Line 4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);

4767: -- hr_utility.set_location('p_cm_trgr_id ='||p_cm_trgr_id,10);
4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);

Line 4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);

4768: -- hr_utility.set_location('p_pgm_id ='||p_pgm_id,10);
4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);

Line 4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);

4769: -- hr_utility.set_location('p_pl_id ='||p_pl_id,10);
4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);
4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);

Line 4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);

4770: -- hr_utility.set_location('p_cm_typ_id ='||p_cm_typ_id,10);
4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);
4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);
4778: -- hr_utility.set_location('p_cm_dlvry_mthd_cd ='||p_cm_dlvry_mthd_cd,10);

Line 4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);

4771: -- hr_utility.set_location('p_ler_id ='||p_ler_id,10);
4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);
4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);
4778: -- hr_utility.set_location('p_cm_dlvry_mthd_cd ='||p_cm_dlvry_mthd_cd,10);
4779: -- hr_utility.set_location('p_whnvr_trgrd_flag ='||p_whnvr_trgrd_flag,10);

Line 4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);

4772: -- hr_utility.set_location('p_date_cd ='||p_date_cd,10);
4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);
4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);
4778: -- hr_utility.set_location('p_cm_dlvry_mthd_cd ='||p_cm_dlvry_mthd_cd,10);
4779: -- hr_utility.set_location('p_whnvr_trgrd_flag ='||p_whnvr_trgrd_flag,10);
4780: -- Steps.

Line 4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);

4773: -- hr_utility.set_location('p_inspn_rqd_flag ='||p_inspn_rqd_flag,10);
4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);
4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);
4778: -- hr_utility.set_location('p_cm_dlvry_mthd_cd ='||p_cm_dlvry_mthd_cd,10);
4779: -- hr_utility.set_location('p_whnvr_trgrd_flag ='||p_whnvr_trgrd_flag,10);
4780: -- Steps.
4781: -- 1) Populate the working tables that are required.

Line 4778: -- hr_utility.set_location('p_cm_dlvry_mthd_cd ='||p_cm_dlvry_mthd_cd,10);

4774: -- hr_utility.set_location('p_formula_id ='||p_formula_id,10);
4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);
4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);
4778: -- hr_utility.set_location('p_cm_dlvry_mthd_cd ='||p_cm_dlvry_mthd_cd,10);
4779: -- hr_utility.set_location('p_whnvr_trgrd_flag ='||p_whnvr_trgrd_flag,10);
4780: -- Steps.
4781: -- 1) Populate the working tables that are required.
4782: -- 2) Loop through all contacts that are relevant

Line 4779: -- hr_utility.set_location('p_whnvr_trgrd_flag ='||p_whnvr_trgrd_flag,10);

4775: -- hr_utility.set_location('p_effective_date ='||p_effective_date,10);
4776: -- hr_utility.set_location('p_lf_evt_ocrd_dt ='||p_lf_evt_ocrd_dt,10);
4777: -- hr_utility.set_location('p_cm_dlvry_med_cd ='||p_cm_dlvry_med_cd,10);
4778: -- hr_utility.set_location('p_cm_dlvry_mthd_cd ='||p_cm_dlvry_mthd_cd,10);
4779: -- hr_utility.set_location('p_whnvr_trgrd_flag ='||p_whnvr_trgrd_flag,10);
4780: -- Steps.
4781: -- 1) Populate the working tables that are required.
4782: -- 2) Loop through all contacts that are relevant
4783: -- 3) Test against desired procedure

Line 5133: hr_utility.set_location('Rolling back transaction',10);

5129: end if;
5130: --
5131: if not l_usages_created then
5132: --
5133: hr_utility.set_location('Rolling back transaction',10);
5134: rollback to dependent_records;
5135: --
5136: else
5137: --

Line 5157: hr_utility.set_location('Creating Communication for Dependent',10);

5153: benutils.write(ben_generate_communications.g_commu_rec);
5154: ben_generate_communications.g_comm_generated := true;
5155: end if;
5156: --
5157: hr_utility.set_location('Creating Communication for Dependent',10);
5158: --
5159: end if;
5160: --
5161: end if;

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

5163: end loop;
5164: --
5165: end if;
5166: --
5167: hr_utility.set_location('Leaving: '||l_proc,10);
5168: --
5169: end main;
5170: --
5171: end ben_generate_dpnt_comm;