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

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

36: l_ass_rec per_all_assignments_f%rowtype;
37: --
38: begin
39: --
40: hr_utility.set_location('Entering: '||l_proc,10);
41: --
42: -- Steps
43: -- 1. If no rule exists return true
44: -- 2. If a rule exists, evaluate rule

Line 52: hr_utility.set_location('Leaving for rule id null : '||l_proc,10);

48: -- Step 1.
49: --
50: if p_rule_id is null then
51: --
52: hr_utility.set_location('Leaving for rule id null : '||l_proc,10);
53: return true;
54: --
55: else
56: --

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

123: end if;
124: --
125: end if;
126: --
127: hr_utility.set_location('Leaving: '||l_proc,10);
128: --
129: end rule_passes;
130: --
131: procedure pop_ben_per_cm_f

Line 310: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,1001);

306: p_result out nocopy varchar2) is
307: l_found boolean;
308: begin
309: l_found := false;
310: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,1001);
311: if g_ct_eval_tab.count is not NULL and g_ct_eval_tab.count > 0 then
312: for i in g_ct_eval_tab.first..g_ct_eval_tab.last loop
313: hr_utility.set_location('inside for ',1001);
314: if(g_ct_eval_tab(i).CM_TYP_ID = p_cm_typ_id) then

Line 313: hr_utility.set_location('inside for ',1001);

309: l_found := false;
310: hr_utility.set_location('p_cm_typ_id '||p_cm_typ_id,1001);
311: if g_ct_eval_tab.count is not NULL and g_ct_eval_tab.count > 0 then
312: for i in g_ct_eval_tab.first..g_ct_eval_tab.last loop
313: hr_utility.set_location('inside for ',1001);
314: if(g_ct_eval_tab(i).CM_TYP_ID = p_cm_typ_id) then
315: l_found := true;
316: p_eval := 'Y';
317: p_result := g_ct_eval_tab(i).EVAL_RESULT;

Line 330: hr_utility.set_location('Error: '||SQLCODE,1001);

326: return;
327: end if;
328: exception
329: when others then
330: hr_utility.set_location('Error: '||SQLCODE,1001);
331: p_eval := 'N';
332: p_result := 'N';
333: end is_eval;
334:

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

341: end add_ctp_elig;
342:
343: begin
344: --
345: hr_utility.set_location('Entering: '||l_proc,10);
346: --
347: -- Reset the globals for the communication.
348: --
349: g_comm_start_date := null;

Line 411: hr_utility.set_location ('PEA strt date ' || l_pea_esd, 10);

407: FETCH c_pea INTO l_pea_esd;
408:
409: IF c_pea%FOUND
410: THEN
411: hr_utility.set_location ('PEA strt date ' || l_pea_esd, 10);
412:
413: IF l_pea_esd > g_comm_start_date
414: THEN
415: --

Line 420: hr_utility.set_location ( 'final g_comm_start_date '

416: g_comm_start_date := l_pea_esd;
417: --
418: END IF;
419:
420: hr_utility.set_location ( 'final g_comm_start_date '
421: || g_comm_start_date,
422: 10
423: );
424: CLOSE c_pea;

Line 435: hr_utility.set_location ('p_lf_evt_ocrd_dt 1'||p_lf_evt_ocrd_dt,101);

431: --
432: -- Check if the PIL ID is set. If so then fire c_pil_per_cm
433: -- rather than c_per_cm
434: --
435: hr_utility.set_location ('p_lf_evt_ocrd_dt 1'||p_lf_evt_ocrd_dt,101);
436: hr_utility.set_location ('p_effective_date 1'||p_effective_date,101);
437: hr_utility.set_location ('Condition'||ben_generate_communications.g_comm_start_date,101);
438: if p_per_in_ler_id is not null then
439: --

Line 436: hr_utility.set_location ('p_effective_date 1'||p_effective_date,101);

432: -- Check if the PIL ID is set. If so then fire c_pil_per_cm
433: -- rather than c_per_cm
434: --
435: hr_utility.set_location ('p_lf_evt_ocrd_dt 1'||p_lf_evt_ocrd_dt,101);
436: hr_utility.set_location ('p_effective_date 1'||p_effective_date,101);
437: hr_utility.set_location ('Condition'||ben_generate_communications.g_comm_start_date,101);
438: if p_per_in_ler_id is not null then
439: --
440: hr_utility.set_location ('Condition 1',101);

Line 437: hr_utility.set_location ('Condition'||ben_generate_communications.g_comm_start_date,101);

433: -- rather than c_per_cm
434: --
435: hr_utility.set_location ('p_lf_evt_ocrd_dt 1'||p_lf_evt_ocrd_dt,101);
436: hr_utility.set_location ('p_effective_date 1'||p_effective_date,101);
437: hr_utility.set_location ('Condition'||ben_generate_communications.g_comm_start_date,101);
438: if p_per_in_ler_id is not null then
439: --
440: hr_utility.set_location ('Condition 1',101);
441: open c_pil_per_cm

Line 440: hr_utility.set_location ('Condition 1',101);

436: hr_utility.set_location ('p_effective_date 1'||p_effective_date,101);
437: hr_utility.set_location ('Condition'||ben_generate_communications.g_comm_start_date,101);
438: if p_per_in_ler_id is not null then
439: --
440: hr_utility.set_location ('Condition 1',101);
441: open c_pil_per_cm
442: (c_ler_id => p_ler_id
443: ,c_pna_id => p_prtt_enrt_actn_id
444: ,c_per_id => p_person_id

Line 464: hr_utility.set_location ('Condition 2',101);

460: --
461: elsif p_person_id is not null
462: then
463: --
464: hr_utility.set_location ('Condition 2',101);
465: open c_perid_per_cm
466: (c_ler_id => p_ler_id
467: ,c_pna_id => p_prtt_enrt_actn_id
468: ,c_per_id => p_person_id

Line 486: hr_utility.set_location ('Condition 3',101);

482: close c_perid_per_cm;
483: --
484: else
485: --
486: hr_utility.set_location ('Condition 3',101);
487: open c_per_cm
488: (c_ler_id => p_ler_id
489: ,c_pna_id => p_prtt_enrt_actn_id
490: ,c_per_id => p_person_id

Line 527: hr_utility.set_location( 'cm_typ_id '||p_cm_typ_id,1001);

523: l_result := 'N';
524: l_continue_eval := 'N' ;
525: l_found_elig := false;
526:
527: hr_utility.set_location( 'cm_typ_id '||p_cm_typ_id,1001);
528: if(l_dummy_val = 'N' ) then
529: l_continue_eval := 'Y';
530: else
531: is_eval(p_cm_typ_id,

Line 535: hr_utility.set_location( 'l_eval '||l_eval,1001);

531: is_eval(p_cm_typ_id,
532: l_eval,
533: l_result);
534: end if;
535: hr_utility.set_location( 'l_eval '||l_eval,1001);
536: hr_utility.set_location( 'l_result '||l_result,1001);
537:
538: if(l_eval = 'Y' and l_result = 'N') then
539: l_continue_eval := 'N' ;

Line 536: hr_utility.set_location( 'l_result '||l_result,1001);

532: l_eval,
533: l_result);
534: end if;
535: hr_utility.set_location( 'l_eval '||l_eval,1001);
536: hr_utility.set_location( 'l_result '||l_result,1001);
537:
538: if(l_eval = 'Y' and l_result = 'N') then
539: l_continue_eval := 'N' ;
540: elsif(l_eval = 'Y' and l_result = 'Y') then

Line 555: hr_utility.set_location( 'l_triggers.cm_typ_id Elig'||p_cm_typ_id,1001);

551: ,p_col_value => p_cm_typ_id
552: ,p_elig_flag => l_elig_flag1);
553:
554: if(l_elig_flag1 = 'Y') then
555: hr_utility.set_location( 'l_triggers.cm_typ_id Elig'||p_cm_typ_id,1001);
556: l_continue_eval := 'Y' ;
557: add_ctp_elig(p_cm_typ_id,'Y');
558: else
559: hr_utility.set_location( 'l_triggers.cm_typ_id Not Elig'||p_cm_typ_id,1001);

Line 559: hr_utility.set_location( 'l_triggers.cm_typ_id Not Elig'||p_cm_typ_id,1001);

555: hr_utility.set_location( 'l_triggers.cm_typ_id Elig'||p_cm_typ_id,1001);
556: l_continue_eval := 'Y' ;
557: add_ctp_elig(p_cm_typ_id,'Y');
558: else
559: hr_utility.set_location( 'l_triggers.cm_typ_id Not Elig'||p_cm_typ_id,1001);
560: l_continue_eval := 'N' ;
561: add_ctp_elig(p_cm_typ_id,'N');
562: end if;
563: end if;

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

622: end if;
623: --
624: end if;
625: --
626: hr_utility.set_location('Leaving: '||l_proc,10);
627: --
628: end pop_ben_per_cm_f;
629: --
630: procedure pop_ben_per_cm_trgr_f(p_per_cm_id in number,

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

652: and pcr.effective_end_date;
653: --
654: begin
655: --
656: hr_utility.set_location('Entering: '||l_proc,10);
657: --
658: open c_per_cm_trgr;
659: --
660: fetch c_per_cm_trgr into p_per_cm_trgr_id;

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

706: end if;
707: --
708: close c_per_cm_trgr;
709: --
710: hr_utility.set_location('Leaving: '||l_proc,10);
711: --
712: end pop_ben_per_cm_trgr_f;
713: --
714: procedure pop_ben_per_cm_prvdd_f(p_per_cm_id in number,

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

756: l_pcd_rec c_per_cm_prvdd%rowtype;
757: --
758: begin
759: --
760: hr_utility.set_location('Entering: '||l_proc,10);
761: --
762: open c_per_cm_prvdd;
763: --
764: fetch c_per_cm_prvdd into l_pcd_rec;

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

835: else
836: close c_per_cm_prvdd;
837: end if;
838: --
839: hr_utility.set_location('Leaving: '||l_proc,10);
840: --
841: end pop_ben_per_cm_prvdd_f;
842: --
843: procedure pop_ben_per_cm_usg_f

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

866: pcu.effective_start_date and pcu.effective_end_date;
867: --
868: begin
869: --
870: hr_utility.set_location('Entering: '||l_proc,10);
871: --
872: p_usage_created := true;
873: --
874: open c1;

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

923: end if;
924: --
925: close c1;
926: --
927: hr_utility.set_location('Leaving: '||l_proc,10);
928: --
929: end pop_ben_per_cm_usg_f;
930: --
931: procedure populate_working_tables

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

946: l_new_instnc boolean := TRUE;
947: --
948: begin
949: --
950: hr_utility.set_location('Entering: '||l_proc,10);
951: --
952: pop_ben_per_cm_trgr_f
953: (p_per_cm_id => p_per_cm_id,
954: p_cm_trgr_id => p_cm_trgr_id,

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

977: g_commu_rec.per_cm_prvdd_id := l_per_cm_prvdd_id;
978: g_commu_rec.to_be_sent_dt := g_to_be_sent_dt;
979: g_commu_rec.business_group_id := p_business_group_id;
980: --
981: hr_utility.set_location('Leaving: '||l_proc,10);
982: --
983: end populate_working_tables;
984: --
985: function get_cvg_strt_dt (p_elig_per_id number,

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

1360: --
1361:
1362: begin
1363: --
1364: hr_utility.set_location('Entering: '||l_proc,10);
1365: --
1366: ben_person_object.get_object(p_person_id => p_person_id,
1367: p_rec => l_ass_rec);
1368: --

Line 1375: hr_utility.set_location('Coomu per_in_ler_id : '||l_per_in_ler_id,10);

1371: --
1372: open c_get_per_in_ler(p_lf_evt_ocrd_dt);
1373: fetch c_get_per_in_ler into l_per_in_ler_id;
1374: close c_get_per_in_ler;
1375: hr_utility.set_location('Coomu per_in_ler_id : '||l_per_in_ler_id,10);
1376: hr_utility.set_location('Coomu le occrd dt : '||p_lf_evt_ocrd_dt,10);
1377:
1378: l_effective_date_1 := least(p_effective_date,nvl(p_lf_evt_ocrd_dt,p_effective_date))-1 ;
1379: if l_ass_rec.assignment_id is null then

Line 1376: hr_utility.set_location('Coomu le occrd dt : '||p_lf_evt_ocrd_dt,10);

1372: open c_get_per_in_ler(p_lf_evt_ocrd_dt);
1373: fetch c_get_per_in_ler into l_per_in_ler_id;
1374: close c_get_per_in_ler;
1375: hr_utility.set_location('Coomu per_in_ler_id : '||l_per_in_ler_id,10);
1376: hr_utility.set_location('Coomu le occrd dt : '||p_lf_evt_ocrd_dt,10);
1377:
1378: l_effective_date_1 := least(p_effective_date,nvl(p_lf_evt_ocrd_dt,p_effective_date))-1 ;
1379: if l_ass_rec.assignment_id is null then
1380: --

Line 1387: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);

1383: ben_person_object.get_benass_object(p_person_id => p_person_id,
1384: p_rec => l_ass_rec);
1385: --
1386: end if;
1387: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1388: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);

Line 1388: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);

1384: p_rec => l_ass_rec);
1385: --
1386: end if;
1387: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1388: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);

Line 1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);

1385: --
1386: end if;
1387: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1388: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);

Line 1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);

1386: end if;
1387: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1388: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);

Line 1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);

1387: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1388: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);

Line 1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);

1388: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);

Line 1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);

1389: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);

Line 1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);

1390: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);

Line 1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);

1391: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);

Line 1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);

1392: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1400: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);

Line 1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);

1393: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1400: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1401: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);

Line 1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);

1394: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1400: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1401: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1402:

Line 1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);

1395: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1400: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1401: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1402:
1403: --

Line 1400: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);

1396: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1400: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1401: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1402:
1403: --
1404: if p_whnvr_trgrd_flag = 'N' then

Line 1401: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);

1397: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1398: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1399: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1400: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1401: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1402:
1403: --
1404: if p_whnvr_trgrd_flag = 'N' then
1405: --

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

1408: -- Reset the based on fonm mode.
1409: --
1410: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
1411: --
1412: hr_utility.set_location('Coomu l_effective_date : '||l_effective_date,10);
1413:
1414: open c_prev_pil(l_per_in_ler_id);
1415: fetch c_prev_pil into l_prev_pil_id;
1416: close c_prev_pil;

Line 1425: hr_utility.set_location('Coomu cvg_date : '||l_c1.cvg_dt,10);

1421: --
1422: fetch c1 into l_c1;
1423: exit when c1%notfound;
1424: --
1425: hr_utility.set_location('Coomu cvg_date : '||l_c1.cvg_dt,10);
1426: hr_utility.set_location('Coomu cvg_date : '||l_c1.per_in_ler_id,10);
1427: hr_utility.set_location('Coomu cvg_date : '||l_c1.elig_per_id,10);
1428: hr_utility.set_location('Coomu cvg_date : '||l_c1.ler_id,10);
1429: hr_utility.set_location('Coomu cvg_date : '||l_c1.pl_typ_id,10);

Line 1426: hr_utility.set_location('Coomu cvg_date : '||l_c1.per_in_ler_id,10);

1422: fetch c1 into l_c1;
1423: exit when c1%notfound;
1424: --
1425: hr_utility.set_location('Coomu cvg_date : '||l_c1.cvg_dt,10);
1426: hr_utility.set_location('Coomu cvg_date : '||l_c1.per_in_ler_id,10);
1427: hr_utility.set_location('Coomu cvg_date : '||l_c1.elig_per_id,10);
1428: hr_utility.set_location('Coomu cvg_date : '||l_c1.ler_id,10);
1429: hr_utility.set_location('Coomu cvg_date : '||l_c1.pl_typ_id,10);
1430: -- make sure he is eligible /noneligible as dpnt for the same object

Line 1427: hr_utility.set_location('Coomu cvg_date : '||l_c1.elig_per_id,10);

1423: exit when c1%notfound;
1424: --
1425: hr_utility.set_location('Coomu cvg_date : '||l_c1.cvg_dt,10);
1426: hr_utility.set_location('Coomu cvg_date : '||l_c1.per_in_ler_id,10);
1427: hr_utility.set_location('Coomu cvg_date : '||l_c1.elig_per_id,10);
1428: hr_utility.set_location('Coomu cvg_date : '||l_c1.ler_id,10);
1429: hr_utility.set_location('Coomu cvg_date : '||l_c1.pl_typ_id,10);
1430: -- make sure he is eligible /noneligible as dpnt for the same object
1431: -- # 2754970

Line 1428: hr_utility.set_location('Coomu cvg_date : '||l_c1.ler_id,10);

1424: --
1425: hr_utility.set_location('Coomu cvg_date : '||l_c1.cvg_dt,10);
1426: hr_utility.set_location('Coomu cvg_date : '||l_c1.per_in_ler_id,10);
1427: hr_utility.set_location('Coomu cvg_date : '||l_c1.elig_per_id,10);
1428: hr_utility.set_location('Coomu cvg_date : '||l_c1.ler_id,10);
1429: hr_utility.set_location('Coomu cvg_date : '||l_c1.pl_typ_id,10);
1430: -- make sure he is eligible /noneligible as dpnt for the same object
1431: -- # 2754970
1432: l_f_elg_nelg := 'Y';

Line 1429: hr_utility.set_location('Coomu cvg_date : '||l_c1.pl_typ_id,10);

1425: hr_utility.set_location('Coomu cvg_date : '||l_c1.cvg_dt,10);
1426: hr_utility.set_location('Coomu cvg_date : '||l_c1.per_in_ler_id,10);
1427: hr_utility.set_location('Coomu cvg_date : '||l_c1.elig_per_id,10);
1428: hr_utility.set_location('Coomu cvg_date : '||l_c1.ler_id,10);
1429: hr_utility.set_location('Coomu cvg_date : '||l_c1.pl_typ_id,10);
1430: -- make sure he is eligible /noneligible as dpnt for the same object
1431: -- # 2754970
1432: l_f_elg_nelg := 'Y';
1433:

Line 1444: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5676);

1440: fetch c3 into l_dummy ;
1441: if c3%found then
1442: if p_eligible_flag = 'Y' then
1443: l_f_elg_nelg := 'N' ;
1444: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5676);
1445: end if ;
1446: end if ;
1447: close c3 ;
1448: ----

Line 1449: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5678);

1445: end if ;
1446: end if ;
1447: close c3 ;
1448: ----
1449: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5678);
1450:
1451: if l_f_elg_nelg = 'Y' then
1452:
1453: hr_utility.set_location('p_pgm_id = ' || p_pgm_id || ' ler_id = ' || p_ler_id, 5678);

Line 1453: hr_utility.set_location('p_pgm_id = ' || p_pgm_id || ' ler_id = ' || p_ler_id, 5678);

1449: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5678);
1450:
1451: if l_f_elg_nelg = 'Y' then
1452:
1453: hr_utility.set_location('p_pgm_id = ' || p_pgm_id || ' ler_id = ' || p_ler_id, 5678);
1454: hr_utility.set_location('p_pgm_id = ' || l_c1.pgm_id || ' pl_id = ' || l_c1.pl_id, 5678);
1455: if rule_passes
1456: (p_rule_id => l_c1.cm_usg_rl,
1457: p_person_id => p_person_id,

Line 1454: hr_utility.set_location('p_pgm_id = ' || l_c1.pgm_id || ' pl_id = ' || l_c1.pl_id, 5678);

1450:
1451: if l_f_elg_nelg = 'Y' then
1452:
1453: hr_utility.set_location('p_pgm_id = ' || p_pgm_id || ' ler_id = ' || p_ler_id, 5678);
1454: hr_utility.set_location('p_pgm_id = ' || l_c1.pgm_id || ' pl_id = ' || l_c1.pl_id, 5678);
1455: if rule_passes
1456: (p_rule_id => l_c1.cm_usg_rl,
1457: p_person_id => p_person_id,
1458: p_assignment_id => p_assignment_id,

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

1508: close c2;
1509: --
1510: end if;
1511: --
1512: hr_utility.set_location('Leaving: '||l_proc,10);
1513: --
1514: p_usages_created := l_created;
1515: --
1516: end check_first_time_elig_inelig;

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

1624: l_per_cm_usg_id number;
1625: --
1626: begin
1627: --
1628: hr_utility.set_location('Entering: '||l_proc,10);
1629: --
1630: if p_whnvr_trgrd_flag = 'N' then
1631: --
1632: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

1690: close c2;
1691: --
1692: end if;
1693: --
1694: hr_utility.set_location('Leaving: '||l_proc,10);
1695: --
1696: p_usages_created := l_created;
1697: --
1698: end check_automatic_enrollment;

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

1836: l_per_cm_usg_id number;
1837: --
1838: begin
1839: --
1840: hr_utility.set_location('Entering: '||l_proc,10);
1841: --
1842: if p_whnvr_trgrd_flag = 'N' then
1843: --
1844: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

1969: close c2;
1970: --
1971: end if;
1972: --
1973: hr_utility.set_location('Leaving: '||l_proc,10);
1974: --
1975: p_usages_created := l_created;
1976: --
1977: end check_electable_choice_popl;

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

2046: l_per_cm_usg_id number;
2047: --
2048: begin
2049: --
2050: hr_utility.set_location('Entering: '||l_proc,10);
2051: --
2052: if p_whnvr_trgrd_flag = 'N' then
2053: --
2054: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

2112: close c2;
2113: --
2114: end if;
2115: --
2116: hr_utility.set_location('Leaving: '||l_proc,10);
2117: --
2118: p_usages_created := l_created;
2119: --
2120: end check_no_impact_on_benefits;

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

2231: l_per_cm_usg_id number;
2232: --
2233: begin
2234: --
2235: hr_utility.set_location('Entering: '||l_proc,10);
2236: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,10);
2237: --
2238: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2239: hr_utility.set_location('l_effective_date: '||l_effective_date,10);

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

2232: --
2233: begin
2234: --
2235: hr_utility.set_location('Entering: '||l_proc,10);
2236: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,10);
2237: --
2238: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2239: hr_utility.set_location('l_effective_date: '||l_effective_date,10);
2240: --

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

2235: hr_utility.set_location('Entering: '||l_proc,10);
2236: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,10);
2237: --
2238: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2239: hr_utility.set_location('l_effective_date: '||l_effective_date,10);
2240: --
2241: if p_whnvr_trgrd_flag = 'N' then
2242: --
2243: open c1;

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

2299: close c2;
2300: --
2301: end if;
2302: --
2303: hr_utility.set_location('Leaving: '||l_proc,10);
2304: --
2305: p_usages_created := l_created;
2306: --
2307: end check_inelig_deenroll;

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

2400: l_per_cm_usg_id number;
2401: --
2402: begin
2403: --
2404: hr_utility.set_location('Entering: '||l_proc,10);
2405:
2406: hr_utility.set_location('befo loop pl type_id ' || p_pl_typ_id,77);
2407: --
2408: if p_whnvr_trgrd_flag = 'N' then

Line 2406: hr_utility.set_location('befo loop pl type_id ' || p_pl_typ_id,77);

2402: begin
2403: --
2404: hr_utility.set_location('Entering: '||l_proc,10);
2405:
2406: hr_utility.set_location('befo loop pl type_id ' || p_pl_typ_id,77);
2407: --
2408: if p_whnvr_trgrd_flag = 'N' then
2409: --
2410: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

Line 2418: hr_utility.set_location('befo loop pl type_id ' || l_c1.pl_id,77);

2414: loop
2415: --
2416: fetch c1 into l_c1;
2417: exit when c1%notfound;
2418: hr_utility.set_location('befo loop pl type_id ' || l_c1.pl_id,77);
2419: --
2420: if rule_passes
2421: (p_rule_id => l_c1.cm_usg_rl,
2422: p_person_id => p_person_id,

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

2471: close c2;
2472: --
2473: end if;
2474: --
2475: hr_utility.set_location('Leaving: '||l_proc,10);
2476: --
2477: p_usages_created := l_created;
2478: --
2479: end check_expl_dflt_enrollment;

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

2554: l_per_cm_usg_id number;
2555: --
2556: begin
2557: --
2558: hr_utility.set_location('Entering: '||l_proc,10);
2559: --
2560: if p_whnvr_trgrd_flag = 'N' then
2561: --
2562: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

2623: close c2;
2624: --
2625: end if;
2626: --
2627: hr_utility.set_location('Leaving: '||l_proc,10);
2628: --
2629: p_usages_created := l_created;
2630: --
2631: end check_close_enrollment;

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

2687: l_per_cm_usg_id number;
2688: --
2689: begin
2690: --
2691: hr_utility.set_location('Entering: '||l_proc,10);
2692: --
2693: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2694: --
2695: if p_whnvr_trgrd_flag = 'N' then

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

2744: l_created := true;
2745: --
2746: end if;
2747: --
2748: hr_utility.set_location('Leaving: '||l_proc,10);
2749: --
2750: p_usages_created := l_created;
2751: --
2752: end check_actn_item;

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

2802: l_per_cm_usg_id number;
2803: --
2804: begin
2805: --
2806: hr_utility.set_location('Entering: '||l_proc,10);
2807: hr_utility.set_location('BG : '|| p_business_group_id,10);
2808: hr_utility.set_location('PL: '||p_pl_id,10);
2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);

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

2803: --
2804: begin
2805: --
2806: hr_utility.set_location('Entering: '||l_proc,10);
2807: hr_utility.set_location('BG : '|| p_business_group_id,10);
2808: hr_utility.set_location('PL: '||p_pl_id,10);
2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2811: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);

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

2804: begin
2805: --
2806: hr_utility.set_location('Entering: '||l_proc,10);
2807: hr_utility.set_location('BG : '|| p_business_group_id,10);
2808: hr_utility.set_location('PL: '||p_pl_id,10);
2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2811: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2812: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);

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

2805: --
2806: hr_utility.set_location('Entering: '||l_proc,10);
2807: hr_utility.set_location('BG : '|| p_business_group_id,10);
2808: hr_utility.set_location('PL: '||p_pl_id,10);
2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2811: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2812: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2813: hr_utility.set_location('comm type : '||p_cm_typ_id,10);

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

2806: hr_utility.set_location('Entering: '||l_proc,10);
2807: hr_utility.set_location('BG : '|| p_business_group_id,10);
2808: hr_utility.set_location('PL: '||p_pl_id,10);
2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2811: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2812: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2813: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2814:

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

2807: hr_utility.set_location('BG : '|| p_business_group_id,10);
2808: hr_utility.set_location('PL: '||p_pl_id,10);
2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2811: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2812: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2813: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2814:
2815: --

Line 2812: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);

2808: hr_utility.set_location('PL: '||p_pl_id,10);
2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2811: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2812: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2813: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2814:
2815: --
2816: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

Line 2813: hr_utility.set_location('comm type : '||p_cm_typ_id,10);

2809: hr_utility.set_location('ler : '||p_ler_id,10);
2810: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2811: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2812: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2813: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2814:
2815: --
2816: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2817: --

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

2867: l_created := true;
2868: --
2869: end if;
2870: --
2871: hr_utility.set_location('Leaving: '||l_proc,10);
2872: --
2873: p_usages_created := l_created;
2874: --
2875: end check_reimbursement;

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

2923: l_per_cm_usg_id number;
2924: --
2925: begin
2926: --
2927: hr_utility.set_location('Entering : ' || l_proc, 10);
2928: --
2929: if p_whnvr_trgrd_flag = 'N' then
2930: --
2931: -- We have to check to see if usages exist.

Line 2942: hr_utility.set_location(' cursor got row ' , 110);

2938: --
2939: fetch c1 into l_c1;
2940: exit when c1%notfound;
2941: --
2942: hr_utility.set_location(' cursor got row ' , 110);
2943: if rule_passes
2944: (p_rule_id => l_c1.cm_usg_rl,
2945: p_person_id => p_person_id,
2946: p_assignment_id => p_assignment_id,

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

2983: l_created := true;
2984: --
2985: end if;
2986: --
2987: hr_utility.set_location('Leaving : ' || l_proc, 10);
2988: --
2989: end check_dpnt_end_enrt;
2990: --
2991: procedure check_mass_mail

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

3037: l_per_cm_usg_id number;
3038: --
3039: begin
3040: --
3041: hr_utility.set_location('Entering : ' || l_proc, 10);
3042: --
3043: if p_whnvr_trgrd_flag = 'N' then
3044: --
3045: -- We have to check to see if usages exist.

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

3096: l_created := true;
3097: --
3098: end if;
3099: --
3100: hr_utility.set_location('Leaving : ' || l_proc, 10);
3101: --
3102: end check_mass_mail;
3103: --
3104: procedure check_enrt_rmdr

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

3187: l_per_cm_usg_id number;
3188: --
3189: begin
3190: --
3191: hr_utility.set_location('Entering: '||l_proc,10);
3192: --
3193: if p_whnvr_trgrd_flag = 'N' then
3194: --
3195: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

3253: close c2;
3254: --
3255: end if;
3256: --
3257: hr_utility.set_location('Leaving: '||l_proc,10);
3258: --
3259: p_usages_created := l_created;
3260: --
3261: end check_enrt_rmdr;

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

3312: l_per_cm_usg_id number;
3313: --
3314: begin
3315: --
3316: hr_utility.set_location('Entering: '||l_proc,10);
3317: --
3318: if p_whnvr_trgrd_flag = 'N' then
3319: --
3320: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

3369: l_created := true;
3370: --
3371: end if;
3372: --
3373: hr_utility.set_location('Leaving: '||l_proc,10);
3374: --
3375: p_usages_created := l_created;
3376: --
3377: end check_emrg_evt;

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

3483: l_per_cm_usg_id number;
3484: --
3485: begin
3486: --
3487: hr_utility.set_location('Entering: '||l_proc,10);
3488: --
3489: if p_whnvr_trgrd_flag = 'N' then
3490: --
3491: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

3549: close c2;
3550: --
3551: end if;
3552: --
3553: hr_utility.set_location('Leaving: '||l_proc,10);
3554: --
3555: p_usages_created := l_created;
3556: --
3557: end check_rate_change;

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

3632: l_per_cm_usg_id number;
3633: --
3634: begin
3635: --
3636: hr_utility.set_location('Entering: '||l_proc,10);
3637: --
3638: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
3639: --
3640: if p_whnvr_trgrd_flag = 'N' then

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

3689: l_created := true;
3690: --
3691: end if;
3692: --
3693: hr_utility.set_location('Leaving: '||l_proc,10);
3694: --
3695: p_usages_created := l_created;
3696: --
3697: end check_hipaa_usages;

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

3910: -- plan type. If not, check for any enrollment opportunity available
3911: -- to enroll in that plan type. If there are no enrollment opportunity,
3912: -- then generate the neccessary HIPAA comm.
3913: --
3914: hr_utility.set_location('Entering: '||l_proc,10);
3915: --
3916: ben_person_object.get_object(p_person_id => p_person_id,
3917: p_rec => l_per_rec);
3918: --

Line 3921: hr_utility.set_location('per_in_ler_id '||p_per_in_ler_id,20);

3917: p_rec => l_per_rec);
3918: --
3919: -- If the person is dead, no comm. for the prtt.
3920: --
3921: hr_utility.set_location('per_in_ler_id '||p_per_in_ler_id,20);
3922: if l_per_rec.date_of_death is not null then
3923: --
3924: p_usages_created := false;
3925: return;

Line 3937: hr_utility.set_location('communication exist for the same id '||l_proc,20);

3933: fetch c_pcd into l_tmp ;
3934: if c_pcd%found then
3935: close c_pcd ;
3936: p_usages_created := false;
3937: hr_utility.set_location('communication exist for the same id '||l_proc,20);
3938: hr_utility.set_location(' same id '||p_per_cm_id,20);
3939: hr_utility.set_location(' same dt '||g_to_be_sent_dt,20);
3940: return;
3941: end if ;

Line 3938: hr_utility.set_location(' same id '||p_per_cm_id,20);

3934: if c_pcd%found then
3935: close c_pcd ;
3936: p_usages_created := false;
3937: hr_utility.set_location('communication exist for the same id '||l_proc,20);
3938: hr_utility.set_location(' same id '||p_per_cm_id,20);
3939: hr_utility.set_location(' same dt '||g_to_be_sent_dt,20);
3940: return;
3941: end if ;
3942: close c_pcd ;

Line 3939: hr_utility.set_location(' same dt '||g_to_be_sent_dt,20);

3935: close c_pcd ;
3936: p_usages_created := false;
3937: hr_utility.set_location('communication exist for the same id '||l_proc,20);
3938: hr_utility.set_location(' same id '||p_per_cm_id,20);
3939: hr_utility.set_location(' same dt '||g_to_be_sent_dt,20);
3940: return;
3941: end if ;
3942: close c_pcd ;
3943:

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

3941: end if ;
3942: close c_pcd ;
3943:
3944: --
3945: hr_utility.set_location('Before loop '||l_proc,20);
3946: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
3947: --
3948: for l_prev_enrt in c_prev_enrt loop
3949: --

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

3946: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
3947: --
3948: for l_prev_enrt in c_prev_enrt loop
3949: --
3950: hr_utility.set_location('In loop: '||l_proc,30);
3951: --
3952: l_epe_exists := 'N';
3953: l_crntly_enrd := 'N';
3954: --

Line 3986: hr_utility.set_location('No Result: '||l_proc,40);

3982: --HIPAA Enh
3983: --
3984: if l_crntly_enrd = 'N' then
3985: --
3986: hr_utility.set_location('No Result: '||l_proc,40);
3987: --
3988: open c_epe(l_prev_enrt.pgm_id, l_prev_enrt.pl_typ_id);
3989: fetch c_epe into l_epe_exists;
3990: close c_epe;

Line 4021: -- hr_utility.set_location('No Choice : '||l_proc,50);

4017:
4018: --
4019: if l_epe_exists = 'N' then
4020: --
4021: -- hr_utility.set_location('No Choice : '||l_proc,50);
4022: --
4023: -- bwharton bug 1619271.
4024: -- When the to be sent date is null due to pl_id / oipl_id
4025: -- not available at the earlier call to determine date, try

Line 4054: hr_utility.set_location('BCW: revised g_to_be_sent_dt date : '

4050: p_formula_id => g_p_formula_id,
4051: p_effective_date => g_p_effective_date,
4052: p_lf_evt_ocrd_dt => g_p_lf_evt_ocrd_dt,
4053: p_returned_date => g_to_be_sent_dt);
4054: hr_utility.set_location('BCW: revised g_to_be_sent_dt date : '
4055: ||g_to_be_sent_dt,1469);
4056: end if;
4057: --
4058: -- bwharton bug 1619271 end of changes above.

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

4089: end loop;
4090: --
4091: p_usages_created := l_usages_created;
4092: --
4093: hr_utility.set_location('Leaving: '||l_proc,10);
4094: --
4095: end check_hipaa_ctfn;
4096: --
4097: function usages_exist(p_proc_cd in varchar2,

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

4122: l_usages_created boolean := false;
4123: --
4124: begin
4125: --
4126: hr_utility.set_location('Entering: '||l_proc,10);
4127: --
4128: hr_utility.set_location(' program ' || p_pgm_id , 1999);
4129: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
4130: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);

Line 4128: hr_utility.set_location(' program ' || p_pgm_id , 1999);

4124: begin
4125: --
4126: hr_utility.set_location('Entering: '||l_proc,10);
4127: --
4128: hr_utility.set_location(' program ' || p_pgm_id , 1999);
4129: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
4130: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);
4131:
4132: -- The whenever triggered flag is only relevant to BENMNGLE calls due to

Line 4129: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);

4125: --
4126: hr_utility.set_location('Entering: '||l_proc,10);
4127: --
4128: hr_utility.set_location(' program ' || p_pgm_id , 1999);
4129: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
4130: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);
4131:
4132: -- The whenever triggered flag is only relevant to BENMNGLE calls due to
4133: -- the fact that we need to know what action took place and to make sure

Line 4130: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);

4126: hr_utility.set_location('Entering: '||l_proc,10);
4127: --
4128: hr_utility.set_location(' program ' || p_pgm_id , 1999);
4129: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
4130: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);
4131:
4132: -- The whenever triggered flag is only relevant to BENMNGLE calls due to
4133: -- the fact that we need to know what action took place and to make sure
4134: -- that an action took place.

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

4483: raise ben_manage_life_events.g_record_error;
4484: --
4485: end if;
4486: --
4487: hr_utility.set_location('Leaving: '||l_proc,10);
4488: --
4489: return l_usages_created;
4490: --
4491: end usages_exist;

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

4632: l_pil_typ_cd ben_ler_f.typ_cd%type ;
4633: --
4634: begin
4635: --
4636: hr_utility.set_location('Entering: '||l_proc,10);
4637: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4638: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4639: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4640: --

Line 4637: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);

4633: --
4634: begin
4635: --
4636: hr_utility.set_location('Entering: '||l_proc,10);
4637: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4638: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4639: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4640: --
4641: l_effective_date := nvl(l_lf_evt_ocrd_dt,p_effective_date);

Line 4638: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);

4634: begin
4635: --
4636: hr_utility.set_location('Entering: '||l_proc,10);
4637: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4638: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4639: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4640: --
4641: l_effective_date := nvl(l_lf_evt_ocrd_dt,p_effective_date);
4642: --

Line 4639: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);

4635: --
4636: hr_utility.set_location('Entering: '||l_proc,10);
4637: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4638: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4639: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4640: --
4641: l_effective_date := nvl(l_lf_evt_ocrd_dt,p_effective_date);
4642: --
4643: -- CWB Changes.

Line 4678: hr_utility.set_location('pil befo : '||l_lf_evt_ocrd_dt,10);

4674: --- picked for the communication , that may be age old so the fix
4675: --- getting the effective date if the ler type is unrestricred and ler is is null
4676:
4677: if p_lf_evt_ocrd_dt is null and l_per_in_ler_id is not null then
4678: hr_utility.set_location('pil befo : '||l_lf_evt_ocrd_dt,10);
4679: open c_pil (l_per_in_ler_id) ;
4680: fetch c_pil into l_pil_lf_evt_ocrd_dt, l_pil_typ_cd ;
4681: close c_pil ;
4682:

Line 4685: hr_utility.set_location('pil aftr : '||l_lf_evt_ocrd_dt,10);

4681: close c_pil ;
4682:
4683:
4684: l_lf_evt_ocrd_dt := l_pil_lf_evt_ocrd_dt ;
4685: hr_utility.set_location('pil aftr : '||l_lf_evt_ocrd_dt,10);
4686:
4687:
4688: -- when the ler_id is null it is called from some process not from any event
4689: -- when the ler type is unrestricred the pil_id could be old

Line 4693: hr_utility.set_location('ler aftr : '||l_lf_evt_ocrd_dt,10);

4689: -- when the ler type is unrestricred the pil_id could be old
4690: -- the date validate whther pil id is old one # 3296015
4691: if p_ler_id is null and l_pil_typ_cd = 'SCHEDDU' and l_lf_evt_ocrd_dt < p_effective_date then
4692: l_lf_evt_ocrd_dt := p_effective_date ;
4693: hr_utility.set_location('ler aftr : '||l_lf_evt_ocrd_dt,10);
4694: end if ;
4695:
4696: end if ;
4697:

Line 4704: hr_utility.set_location('ler aftr : '||l_lf_evt_ocrd_dt,10);

4700: -- when the ler type is unrestricred the pil_id could be old
4701: -- the date validate whther pil id is old one # 3296015
4702: if p_ler_id is null and l_pil_typ_cd = 'SCHEDDU' and l_lf_evt_ocrd_dt < p_effective_date then
4703: l_lf_evt_ocrd_dt := p_effective_date ;
4704: hr_utility.set_location('ler aftr : '||l_lf_evt_ocrd_dt,10);
4705: end if ;
4706:
4707: --
4708: if l_ass_rec.assignment_id is null then

Line 4719: hr_utility.set_location( 'plan and type '|| p_pl_id || ' / '||p_pl_typ_id, 77 );

4715: end if;
4716:
4717: ----
4718: --
4719: hr_utility.set_location( 'plan and type '|| p_pl_id || ' / '||p_pl_typ_id, 77 );
4720: if p_pl_id is not null and
4721: p_pl_typ_id is null then
4722: --
4723: ben_comp_object.get_object(p_pl_id => p_pl_id,

Line 4771: hr_utility.set_location('Commu type id'||l_triggers.cm_typ_id||' ' ||l_triggers.proc_cd,10);

4767: -- Step 3.
4768: --
4769: savepoint communications_savepoint;
4770: --
4771: hr_utility.set_location('Commu type id'||l_triggers.cm_typ_id||' ' ||l_triggers.proc_cd,10);
4772: -- Step 4.
4773: --
4774: if rule_passes
4775: (p_rule_id => l_triggers.cm_typ_trgr_rl,

Line 4864: hr_utility.set_location('Cm type id'||l_per_cm_id,10);

4860: p_formula_id => l_triggers.to_be_sent_dt_rl,
4861: p_pgm_id => p_pgm_id,
4862: p_pl_id => p_pl_id,
4863: p_per_cm_id => l_per_cm_id);
4864: hr_utility.set_location('Cm type id'||l_per_cm_id,10);
4865: --
4866: --
4867: -- We have to work out the usages and this depends on the proc_cd
4868: -- If we have no usages then there is no need to populate the

Line 4898: hr_utility.set_location('rolling back' ,10);

4894: p_whnvr_trgrd_flag => l_triggers.whnvr_trgrd_flag) then
4895: --
4896: -- We have to rollback the transaction
4897: --
4898: hr_utility.set_location('rolling back' ,10);
4899: rollback to communications_savepoint;
4900: --
4901: else
4902: --

Line 4903: hr_utility.set_location('Cm type id'||l_per_cm_id,10);

4899: rollback to communications_savepoint;
4900: --
4901: else
4902: --
4903: hr_utility.set_location('Cm type id'||l_per_cm_id,10);
4904: populate_working_tables
4905: (p_person_id => p_person_id,
4906: p_cm_typ_id => l_triggers.cm_typ_id,
4907: p_business_group_id => p_business_group_id,

Line 4931: hr_utility.set_location('Entering dpnt',10);

4927: else
4928: --
4929: -- Generate related persons/dependents comm.
4930: --
4931: hr_utility.set_location('Entering dpnt',10);
4932: ben_generate_dpnt_comm.main
4933: (p_proc_cd => l_triggers.proc_cd,
4934: p_name => l_triggers.name,
4935: p_rcpent_cd => l_triggers.rcpent_cd,

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

4968: end loop;
4969: --
4970: close c_triggers;
4971: --
4972: hr_utility.set_location('Leaving: '||l_proc,10);
4973: --
4974: hr_utility.set_location('Displaying stats ',10);
4975: end main;
4976: --

Line 4974: hr_utility.set_location('Displaying stats ',10);

4970: close c_triggers;
4971: --
4972: hr_utility.set_location('Leaving: '||l_proc,10);
4973: --
4974: hr_utility.set_location('Displaying stats ',10);
4975: end main;
4976: --
4977: end ben_generate_communications;
4978: --