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 33: hr_utility.set_location('Entering: '||l_proc,10);

29: l_ass_rec per_all_assignments_f%rowtype;
30: --
31: begin
32: --
33: hr_utility.set_location('Entering: '||l_proc,10);
34: --
35: -- Steps
36: -- 1. If no rule exists return true
37: -- 2. If a rule exists, evaluate rule

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

41: -- Step 1.
42: --
43: if p_rule_id is null then
44: --
45: hr_utility.set_location('Leaving for rule id null : '||l_proc,10);
46: return true;
47: --
48: else
49: --

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

116: end if;
117: --
118: end if;
119: --
120: hr_utility.set_location('Leaving: '||l_proc,10);
121: --
122: end rule_passes;
123: --
124: procedure pop_ben_per_cm_f

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

267: -- end addition
268:
269: begin
270: --
271: hr_utility.set_location('Entering: '||l_proc,10);
272: --
273: -- Reset the globals for the communication.
274: --
275: g_comm_start_date := null;

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

333: FETCH c_pea INTO l_pea_esd;
334:
335: IF c_pea%FOUND
336: THEN
337: hr_utility.set_location ('PEA strt date ' || l_pea_esd, 10);
338:
339: IF l_pea_esd > g_comm_start_date
340: THEN
341: --

Line 346: hr_utility.set_location ( 'final g_comm_start_date '

342: g_comm_start_date := l_pea_esd;
343: --
344: END IF;
345:
346: hr_utility.set_location ( 'final g_comm_start_date '
347: || g_comm_start_date,
348: 10
349: );
350: CLOSE c_pea;

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

486: );
487: --
488: end if;
489: --
490: hr_utility.set_location('Leaving: '||l_proc,10);
491: --
492: end pop_ben_per_cm_f;
493: --
494: procedure pop_ben_per_cm_trgr_f(p_per_cm_id in number,

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

516: and pcr.effective_end_date;
517: --
518: begin
519: --
520: hr_utility.set_location('Entering: '||l_proc,10);
521: --
522: open c_per_cm_trgr;
523: --
524: fetch c_per_cm_trgr into p_per_cm_trgr_id;

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

570: end if;
571: --
572: close c_per_cm_trgr;
573: --
574: hr_utility.set_location('Leaving: '||l_proc,10);
575: --
576: end pop_ben_per_cm_trgr_f;
577: --
578: procedure pop_ben_per_cm_prvdd_f(p_per_cm_id in number,

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

620: l_pcd_rec c_per_cm_prvdd%rowtype;
621: --
622: begin
623: --
624: hr_utility.set_location('Entering: '||l_proc,10);
625: --
626: open c_per_cm_prvdd;
627: --
628: fetch c_per_cm_prvdd into l_pcd_rec;

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

699: else
700: close c_per_cm_prvdd;
701: end if;
702: --
703: hr_utility.set_location('Leaving: '||l_proc,10);
704: --
705: end pop_ben_per_cm_prvdd_f;
706: --
707: procedure pop_ben_per_cm_usg_f

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

730: pcu.effective_start_date and pcu.effective_end_date;
731: --
732: begin
733: --
734: hr_utility.set_location('Entering: '||l_proc,10);
735: --
736: p_usage_created := true;
737: --
738: open c1;

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

787: end if;
788: --
789: close c1;
790: --
791: hr_utility.set_location('Leaving: '||l_proc,10);
792: --
793: end pop_ben_per_cm_usg_f;
794: --
795: procedure populate_working_tables

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

810: l_new_instnc boolean := TRUE;
811: --
812: begin
813: --
814: hr_utility.set_location('Entering: '||l_proc,10);
815: --
816: pop_ben_per_cm_trgr_f
817: (p_per_cm_id => p_per_cm_id,
818: p_cm_trgr_id => p_cm_trgr_id,

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

841: g_commu_rec.per_cm_prvdd_id := l_per_cm_prvdd_id;
842: g_commu_rec.to_be_sent_dt := g_to_be_sent_dt;
843: g_commu_rec.business_group_id := p_business_group_id;
844: --
845: hr_utility.set_location('Leaving: '||l_proc,10);
846: --
847: end populate_working_tables;
848: --
849: function get_cvg_strt_dt (p_elig_per_id number,

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

1138: --
1139:
1140: begin
1141: --
1142: hr_utility.set_location('Entering: '||l_proc,10);
1143: --
1144: ben_person_object.get_object(p_person_id => p_person_id,
1145: p_rec => l_ass_rec);
1146: --

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

1155: ben_person_object.get_benass_object(p_person_id => p_person_id,
1156: p_rec => l_ass_rec);
1157: --
1158: end if;
1159: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1160: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1161: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);

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

1156: p_rec => l_ass_rec);
1157: --
1158: end if;
1159: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1160: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1161: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);

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

1157: --
1158: end if;
1159: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1160: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1161: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);

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

1158: end if;
1159: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1160: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1161: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);

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

1159: hr_utility.set_location(' flag ' || p_whnvr_trgrd_flag , 1999);
1160: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1161: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);

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

1160: hr_utility.set_location(' pl_typ_id ' || p_pl_typ_id , 1999);
1161: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);

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

1161: hr_utility.set_location(' p_asnd_lf_evt_dt ' || p_asnd_lf_evt_dt , 1999);
1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);

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

1162: hr_utility.set_location(' p_lf_evt_ocrd_dt ' || p_lf_evt_ocrd_dt , 1999);
1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);

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

1163: hr_utility.set_location(' p_effective_date ' || p_effective_date , 1999);
1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1171: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);

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

1164: hr_utility.set_location(' p_eligible_flag ' || p_eligible_flag , 1999);
1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1171: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1172: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);

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

1165: hr_utility.set_location(' p_person_id ' || p_person_id , 1999);
1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1171: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1172: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1173: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);

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

1166: hr_utility.set_location(' p_assignment_id ' || p_assignment_id , 1999);
1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1171: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1172: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1173: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1174:

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

1167: hr_utility.set_location(' p_per_cm_id ' || p_per_cm_id , 1999);
1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1171: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1172: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1173: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1174:
1175: --

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

1168: hr_utility.set_location(' p_actn_typ_id ' || p_actn_typ_id , 1999);
1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1171: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1172: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1173: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1174:
1175: --
1176: if p_whnvr_trgrd_flag = 'N' then

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

1169: hr_utility.set_location(' p_cm_typ_id ' || p_cm_typ_id , 1999);
1170: hr_utility.set_location(' comm_start_date'||ben_generate_communications.g_comm_start_date , 1999);
1171: hr_utility.set_location(' p_ler_id ' || p_ler_id , 1999);
1172: hr_utility.set_location(' p_pgm_id ' || p_pgm_id , 1999);
1173: hr_utility.set_location(' p_pl_id ' || p_pl_id , 1999);
1174:
1175: --
1176: if p_whnvr_trgrd_flag = 'N' then
1177: --

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

1201: fetch c3 into l_dummy ;
1202: if c3%found then
1203: if p_eligible_flag = 'Y' then
1204: l_f_elg_nelg := 'N' ;
1205: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5676);
1206: end if ;
1207: end if ;
1208: close c3 ;
1209: ----

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

1206: end if ;
1207: end if ;
1208: close c3 ;
1209: ----
1210: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5678);
1211:
1212: if l_f_elg_nelg = 'Y' then
1213:
1214: hr_utility.set_location('p_pgm_id = ' || p_pgm_id || ' ler_id = ' || p_ler_id, 5678);

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

1210: hr_utility.set_location('l_f_elg_nelg = ' || l_f_elg_nelg , 5678);
1211:
1212: if l_f_elg_nelg = 'Y' then
1213:
1214: hr_utility.set_location('p_pgm_id = ' || p_pgm_id || ' ler_id = ' || p_ler_id, 5678);
1215: hr_utility.set_location('p_pgm_id = ' || l_c1.pgm_id || ' pl_id = ' || l_c1.pl_id, 5678);
1216: if rule_passes
1217: (p_rule_id => l_c1.cm_usg_rl,
1218: p_person_id => p_person_id,

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

1211:
1212: if l_f_elg_nelg = 'Y' then
1213:
1214: hr_utility.set_location('p_pgm_id = ' || p_pgm_id || ' ler_id = ' || p_ler_id, 5678);
1215: hr_utility.set_location('p_pgm_id = ' || l_c1.pgm_id || ' pl_id = ' || l_c1.pl_id, 5678);
1216: if rule_passes
1217: (p_rule_id => l_c1.cm_usg_rl,
1218: p_person_id => p_person_id,
1219: p_assignment_id => p_assignment_id,

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

1269: close c2;
1270: --
1271: end if;
1272: --
1273: hr_utility.set_location('Leaving: '||l_proc,10);
1274: --
1275: p_usages_created := l_created;
1276: --
1277: end check_first_time_elig_inelig;

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

1385: l_per_cm_usg_id number;
1386: --
1387: begin
1388: --
1389: hr_utility.set_location('Entering: '||l_proc,10);
1390: --
1391: if p_whnvr_trgrd_flag = 'N' then
1392: --
1393: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

1451: close c2;
1452: --
1453: end if;
1454: --
1455: hr_utility.set_location('Leaving: '||l_proc,10);
1456: --
1457: p_usages_created := l_created;
1458: --
1459: end check_automatic_enrollment;

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

1597: l_per_cm_usg_id number;
1598: --
1599: begin
1600: --
1601: hr_utility.set_location('Entering: '||l_proc,10);
1602: --
1603: if p_whnvr_trgrd_flag = 'N' then
1604: --
1605: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

1730: close c2;
1731: --
1732: end if;
1733: --
1734: hr_utility.set_location('Leaving: '||l_proc,10);
1735: --
1736: p_usages_created := l_created;
1737: --
1738: end check_electable_choice_popl;

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

1807: l_per_cm_usg_id number;
1808: --
1809: begin
1810: --
1811: hr_utility.set_location('Entering: '||l_proc,10);
1812: --
1813: if p_whnvr_trgrd_flag = 'N' then
1814: --
1815: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

1873: close c2;
1874: --
1875: end if;
1876: --
1877: hr_utility.set_location('Leaving: '||l_proc,10);
1878: --
1879: p_usages_created := l_created;
1880: --
1881: end check_no_impact_on_benefits;

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

1992: l_per_cm_usg_id number;
1993: --
1994: begin
1995: --
1996: hr_utility.set_location('Entering: '||l_proc,10);
1997: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,10);
1998: --
1999: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2000: hr_utility.set_location('l_effective_date: '||l_effective_date,10);

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

1993: --
1994: begin
1995: --
1996: hr_utility.set_location('Entering: '||l_proc,10);
1997: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,10);
1998: --
1999: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2000: hr_utility.set_location('l_effective_date: '||l_effective_date,10);
2001: --

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

1996: hr_utility.set_location('Entering: '||l_proc,10);
1997: hr_utility.set_location('p_per_in_ler_id: '||p_per_in_ler_id,10);
1998: --
1999: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2000: hr_utility.set_location('l_effective_date: '||l_effective_date,10);
2001: --
2002: if p_whnvr_trgrd_flag = 'N' then
2003: --
2004: open c1;

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

2060: close c2;
2061: --
2062: end if;
2063: --
2064: hr_utility.set_location('Leaving: '||l_proc,10);
2065: --
2066: p_usages_created := l_created;
2067: --
2068: end check_inelig_deenroll;

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

2161: l_per_cm_usg_id number;
2162: --
2163: begin
2164: --
2165: hr_utility.set_location('Entering: '||l_proc,10);
2166:
2167: hr_utility.set_location('befo loop pl type_id ' || p_pl_typ_id,77);
2168: --
2169: if p_whnvr_trgrd_flag = 'N' then

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

2163: begin
2164: --
2165: hr_utility.set_location('Entering: '||l_proc,10);
2166:
2167: hr_utility.set_location('befo loop pl type_id ' || p_pl_typ_id,77);
2168: --
2169: if p_whnvr_trgrd_flag = 'N' then
2170: --
2171: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

2175: loop
2176: --
2177: fetch c1 into l_c1;
2178: exit when c1%notfound;
2179: hr_utility.set_location('befo loop pl type_id ' || l_c1.pl_id,77);
2180: --
2181: if rule_passes
2182: (p_rule_id => l_c1.cm_usg_rl,
2183: p_person_id => p_person_id,

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

2232: close c2;
2233: --
2234: end if;
2235: --
2236: hr_utility.set_location('Leaving: '||l_proc,10);
2237: --
2238: p_usages_created := l_created;
2239: --
2240: end check_expl_dflt_enrollment;

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

2315: l_per_cm_usg_id number;
2316: --
2317: begin
2318: --
2319: hr_utility.set_location('Entering: '||l_proc,10);
2320: --
2321: if p_whnvr_trgrd_flag = 'N' then
2322: --
2323: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

2384: close c2;
2385: --
2386: end if;
2387: --
2388: hr_utility.set_location('Leaving: '||l_proc,10);
2389: --
2390: p_usages_created := l_created;
2391: --
2392: end check_close_enrollment;

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

2448: l_per_cm_usg_id number;
2449: --
2450: begin
2451: --
2452: hr_utility.set_location('Entering: '||l_proc,10);
2453: --
2454: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2455: --
2456: if p_whnvr_trgrd_flag = 'N' then

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

2505: l_created := true;
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_actn_item;

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

2563: l_per_cm_usg_id number;
2564: --
2565: begin
2566: --
2567: hr_utility.set_location('Entering: '||l_proc,10);
2568: hr_utility.set_location('BG : '|| p_business_group_id,10);
2569: hr_utility.set_location('PL: '||p_pl_id,10);
2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);

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

2564: --
2565: begin
2566: --
2567: hr_utility.set_location('Entering: '||l_proc,10);
2568: hr_utility.set_location('BG : '|| p_business_group_id,10);
2569: hr_utility.set_location('PL: '||p_pl_id,10);
2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2572: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);

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

2565: begin
2566: --
2567: hr_utility.set_location('Entering: '||l_proc,10);
2568: hr_utility.set_location('BG : '|| p_business_group_id,10);
2569: hr_utility.set_location('PL: '||p_pl_id,10);
2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2572: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2573: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);

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

2566: --
2567: hr_utility.set_location('Entering: '||l_proc,10);
2568: hr_utility.set_location('BG : '|| p_business_group_id,10);
2569: hr_utility.set_location('PL: '||p_pl_id,10);
2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2572: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2573: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2574: hr_utility.set_location('comm type : '||p_cm_typ_id,10);

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

2567: hr_utility.set_location('Entering: '||l_proc,10);
2568: hr_utility.set_location('BG : '|| p_business_group_id,10);
2569: hr_utility.set_location('PL: '||p_pl_id,10);
2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2572: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2573: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2574: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2575:

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

2568: hr_utility.set_location('BG : '|| p_business_group_id,10);
2569: hr_utility.set_location('PL: '||p_pl_id,10);
2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2572: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2573: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2574: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2575:
2576: --

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

2569: hr_utility.set_location('PL: '||p_pl_id,10);
2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2572: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2573: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2574: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2575:
2576: --
2577: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

2570: hr_utility.set_location('ler : '||p_ler_id,10);
2571: hr_utility.set_location('pgm: '|| p_pgm_id,10);
2572: hr_utility.set_location('pl_typ: '||p_pl_typ_id,10);
2573: hr_utility.set_location('comm date : '||ben_generate_communications.g_comm_start_date,10);
2574: hr_utility.set_location('comm type : '||p_cm_typ_id,10);
2575:
2576: --
2577: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
2578: --

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

2628: l_created := true;
2629: --
2630: end if;
2631: --
2632: hr_utility.set_location('Leaving: '||l_proc,10);
2633: --
2634: p_usages_created := l_created;
2635: --
2636: end check_reimbursement;

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

2684: l_per_cm_usg_id number;
2685: --
2686: begin
2687: --
2688: hr_utility.set_location('Entering : ' || l_proc, 10);
2689: --
2690: if p_whnvr_trgrd_flag = 'N' then
2691: --
2692: -- We have to check to see if usages exist.

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

2699: --
2700: fetch c1 into l_c1;
2701: exit when c1%notfound;
2702: --
2703: hr_utility.set_location(' cursor got row ' , 110);
2704: if rule_passes
2705: (p_rule_id => l_c1.cm_usg_rl,
2706: p_person_id => p_person_id,
2707: p_assignment_id => p_assignment_id,

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: end check_dpnt_end_enrt;
2751: --
2752: procedure check_mass_mail

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

2798: l_per_cm_usg_id number;
2799: --
2800: begin
2801: --
2802: hr_utility.set_location('Entering : ' || l_proc, 10);
2803: --
2804: if p_whnvr_trgrd_flag = 'N' then
2805: --
2806: -- We have to check to see if usages exist.

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

2857: l_created := true;
2858: --
2859: end if;
2860: --
2861: hr_utility.set_location('Leaving : ' || l_proc, 10);
2862: --
2863: end check_mass_mail;
2864: --
2865: procedure check_enrt_rmdr

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

2948: l_per_cm_usg_id number;
2949: --
2950: begin
2951: --
2952: hr_utility.set_location('Entering: '||l_proc,10);
2953: --
2954: if p_whnvr_trgrd_flag = 'N' then
2955: --
2956: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

3014: close c2;
3015: --
3016: end if;
3017: --
3018: hr_utility.set_location('Leaving: '||l_proc,10);
3019: --
3020: p_usages_created := l_created;
3021: --
3022: end check_enrt_rmdr;

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

3073: l_per_cm_usg_id number;
3074: --
3075: begin
3076: --
3077: hr_utility.set_location('Entering: '||l_proc,10);
3078: --
3079: if p_whnvr_trgrd_flag = 'N' then
3080: --
3081: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

3130: l_created := true;
3131: --
3132: end if;
3133: --
3134: hr_utility.set_location('Leaving: '||l_proc,10);
3135: --
3136: p_usages_created := l_created;
3137: --
3138: end check_emrg_evt;

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

3244: l_per_cm_usg_id number;
3245: --
3246: begin
3247: --
3248: hr_utility.set_location('Entering: '||l_proc,10);
3249: --
3250: if p_whnvr_trgrd_flag = 'N' then
3251: --
3252: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);

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

3310: close c2;
3311: --
3312: end if;
3313: --
3314: hr_utility.set_location('Leaving: '||l_proc,10);
3315: --
3316: p_usages_created := l_created;
3317: --
3318: end check_rate_change;

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

3393: l_per_cm_usg_id number;
3394: --
3395: begin
3396: --
3397: hr_utility.set_location('Entering: '||l_proc,10);
3398: --
3399: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
3400: --
3401: if p_whnvr_trgrd_flag = 'N' then

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

3450: l_created := true;
3451: --
3452: end if;
3453: --
3454: hr_utility.set_location('Leaving: '||l_proc,10);
3455: --
3456: p_usages_created := l_created;
3457: --
3458: end check_hipaa_usages;

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

3634: -- plan type. If not, check for any enrollment opportunity available
3635: -- to enroll in that plan type. If there are no enrollment opportunity,
3636: -- then generate the neccessary HIPAA comm.
3637: --
3638: hr_utility.set_location('Entering: '||l_proc,10);
3639: --
3640: ben_person_object.get_object(p_person_id => p_person_id,
3641: p_rec => l_per_rec);
3642: --

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

3641: p_rec => l_per_rec);
3642: --
3643: -- If the person is dead, no comm. for the prtt.
3644: --
3645: hr_utility.set_location('per_in_ler_id '||p_per_in_ler_id,20);
3646: if l_per_rec.date_of_death is not null then
3647: --
3648: p_usages_created := false;
3649: return;

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

3657: fetch c_pcd into l_tmp ;
3658: if c_pcd%found then
3659: close c_pcd ;
3660: p_usages_created := false;
3661: hr_utility.set_location('communication exist for the same id '||l_proc,20);
3662: hr_utility.set_location(' same id '||p_per_cm_id,20);
3663: hr_utility.set_location(' same dt '||g_to_be_sent_dt,20);
3664: return;
3665: end if ;

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

3658: if c_pcd%found then
3659: close c_pcd ;
3660: p_usages_created := false;
3661: hr_utility.set_location('communication exist for the same id '||l_proc,20);
3662: hr_utility.set_location(' same id '||p_per_cm_id,20);
3663: hr_utility.set_location(' same dt '||g_to_be_sent_dt,20);
3664: return;
3665: end if ;
3666: close c_pcd ;

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

3659: close c_pcd ;
3660: p_usages_created := false;
3661: hr_utility.set_location('communication exist for the same id '||l_proc,20);
3662: hr_utility.set_location(' same id '||p_per_cm_id,20);
3663: hr_utility.set_location(' same dt '||g_to_be_sent_dt,20);
3664: return;
3665: end if ;
3666: close c_pcd ;
3667:

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

3665: end if ;
3666: close c_pcd ;
3667:
3668: --
3669: hr_utility.set_location('Before loop '||l_proc,20);
3670: --
3671: for l_prev_enrt in c_prev_enrt loop
3672: --
3673: hr_utility.set_location('In loop: '||l_proc,30);

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

3669: hr_utility.set_location('Before loop '||l_proc,20);
3670: --
3671: for l_prev_enrt in c_prev_enrt loop
3672: --
3673: hr_utility.set_location('In loop: '||l_proc,30);
3674: --
3675: l_epe_exists := 'N';
3676: l_crntly_enrd := 'N';
3677: --

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

3680: close c_crntly_enrd;
3681: --
3682: if l_crntly_enrd = 'N' then
3683: --
3684: hr_utility.set_location('No Result: '||l_proc,40);
3685: --
3686: open c_epe(l_prev_enrt.pgm_id, l_prev_enrt.pl_typ_id);
3687: fetch c_epe into l_epe_exists;
3688: close c_epe;

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

3688: close c_epe;
3689: --
3690: if l_epe_exists = 'N' then
3691: --
3692: -- hr_utility.set_location('No Choice : '||l_proc,50);
3693: --
3694: -- bwharton bug 1619271.
3695: -- When the to be sent date is null due to pl_id / oipl_id
3696: -- not available at the earlier call to determine date, try

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

3721: p_formula_id => g_p_formula_id,
3722: p_effective_date => g_p_effective_date,
3723: p_lf_evt_ocrd_dt => g_p_lf_evt_ocrd_dt,
3724: p_returned_date => g_to_be_sent_dt);
3725: hr_utility.set_location('BCW: revised g_to_be_sent_dt date : '
3726: ||g_to_be_sent_dt,1469);
3727: end if;
3728: --
3729: -- bwharton bug 1619271 end of changes above.

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

3760: end loop;
3761: --
3762: p_usages_created := l_usages_created;
3763: --
3764: hr_utility.set_location('Leaving: '||l_proc,10);
3765: --
3766: end check_hipaa_ctfn;
3767: --
3768: function usages_exist(p_proc_cd in varchar2,

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

3793: l_usages_created boolean := false;
3794: --
3795: begin
3796: --
3797: hr_utility.set_location('Entering: '||l_proc,10);
3798: --
3799: hr_utility.set_location(' program ' || p_pgm_id , 1999);
3800: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
3801: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);

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

3795: begin
3796: --
3797: hr_utility.set_location('Entering: '||l_proc,10);
3798: --
3799: hr_utility.set_location(' program ' || p_pgm_id , 1999);
3800: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
3801: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);
3802:
3803: -- The whenever triggered flag is only relevant to BENMNGLE calls due to

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

3796: --
3797: hr_utility.set_location('Entering: '||l_proc,10);
3798: --
3799: hr_utility.set_location(' program ' || p_pgm_id , 1999);
3800: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
3801: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);
3802:
3803: -- The whenever triggered flag is only relevant to BENMNGLE calls due to
3804: -- the fact that we need to know what action took place and to make sure

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

3797: hr_utility.set_location('Entering: '||l_proc,10);
3798: --
3799: hr_utility.set_location(' program ' || p_pgm_id , 1999);
3800: hr_utility.set_location(' ler_id ' || p_ler_id , 1999);
3801: hr_utility.set_location(' proc_cd '|| p_proc_cd , 1999);
3802:
3803: -- The whenever triggered flag is only relevant to BENMNGLE calls due to
3804: -- the fact that we need to know what action took place and to make sure
3805: -- that an action took place.

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

4154: raise ben_manage_life_events.g_record_error;
4155: --
4156: end if;
4157: --
4158: hr_utility.set_location('Leaving: '||l_proc,10);
4159: --
4160: return l_usages_created;
4161: --
4162: end usages_exist;

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

4302: l_pil_typ_cd ben_ler_f.typ_cd%type ;
4303: --
4304: begin
4305: --
4306: hr_utility.set_location('Entering: '||l_proc,10);
4307: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4308: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4309: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4310: --

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

4303: --
4304: begin
4305: --
4306: hr_utility.set_location('Entering: '||l_proc,10);
4307: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4308: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4309: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4310: --
4311: l_effective_date := nvl(l_lf_evt_ocrd_dt,p_effective_date);

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

4304: begin
4305: --
4306: hr_utility.set_location('Entering: '||l_proc,10);
4307: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4308: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4309: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4310: --
4311: l_effective_date := nvl(l_lf_evt_ocrd_dt,p_effective_date);
4312: --

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

4305: --
4306: hr_utility.set_location('Entering: '||l_proc,10);
4307: hr_utility.set_location(' proc cd 1' || p_proc_cd1,77);
4308: hr_utility.set_location(' proc cd 2' || p_proc_cd2,77);
4309: hr_utility.set_location(' proc cd 3' || p_proc_cd3,77);
4310: --
4311: l_effective_date := nvl(l_lf_evt_ocrd_dt,p_effective_date);
4312: --
4313: -- CWB Changes.

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

4340: --- picked for the communication , that may be age old so the fix
4341: --- getting the effective date if the ler type is unrestricred and ler is is null
4342:
4343: if p_lf_evt_ocrd_dt is null and l_per_in_ler_id is not null then
4344: hr_utility.set_location('pil befo : '||l_lf_evt_ocrd_dt,10);
4345: open c_pil (l_per_in_ler_id) ;
4346: fetch c_pil into l_pil_lf_evt_ocrd_dt, l_pil_typ_cd ;
4347: close c_pil ;
4348:

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

4347: close c_pil ;
4348:
4349:
4350: l_lf_evt_ocrd_dt := l_pil_lf_evt_ocrd_dt ;
4351: hr_utility.set_location('pil aftr : '||l_lf_evt_ocrd_dt,10);
4352:
4353:
4354: -- when the ler_id is null it is called from some process not from any event
4355: -- when the ler type is unrestricred the pil_id could be old

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

4355: -- when the ler type is unrestricred the pil_id could be old
4356: -- the date validate whther pil id is old one # 3296015
4357: if p_ler_id is null and l_pil_typ_cd = 'SCHEDDU' and l_lf_evt_ocrd_dt < p_effective_date then
4358: l_lf_evt_ocrd_dt := p_effective_date ;
4359: hr_utility.set_location('ler aftr : '||l_lf_evt_ocrd_dt,10);
4360: end if ;
4361:
4362: end if ;
4363:

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

4366: -- when the ler type is unrestricred the pil_id could be old
4367: -- the date validate whther pil id is old one # 3296015
4368: if p_ler_id is null and l_pil_typ_cd = 'SCHEDDU' and l_lf_evt_ocrd_dt < p_effective_date then
4369: l_lf_evt_ocrd_dt := p_effective_date ;
4370: hr_utility.set_location('ler aftr : '||l_lf_evt_ocrd_dt,10);
4371: end if ;
4372:
4373: --
4374: if l_ass_rec.assignment_id is null then

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

4381: end if;
4382:
4383: ----
4384: --
4385: hr_utility.set_location( 'plan and type '|| p_pl_id || ' / '||p_pl_typ_id, 77 );
4386: if p_pl_id is not null and
4387: p_pl_typ_id is null then
4388: --
4389: ben_comp_object.get_object(p_pl_id => p_pl_id,

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

4430: -- Step 3.
4431: --
4432: savepoint communications_savepoint;
4433: --
4434: hr_utility.set_location('Commu type id'||l_triggers.cm_typ_id||' ' ||l_triggers.proc_cd,10);
4435: -- Step 4.
4436: --
4437: if rule_passes
4438: (p_rule_id => l_triggers.cm_typ_trgr_rl,

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

4523: p_formula_id => l_triggers.to_be_sent_dt_rl,
4524: p_pgm_id => p_pgm_id,
4525: p_pl_id => p_pl_id,
4526: p_per_cm_id => l_per_cm_id);
4527: hr_utility.set_location('Cm type id'||l_per_cm_id,10);
4528: --
4529: --
4530: -- We have to work out the usages and this depends on the proc_cd
4531: -- If we have no usages then there is no need to populate the

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

4556: p_whnvr_trgrd_flag => l_triggers.whnvr_trgrd_flag) then
4557: --
4558: -- We have to rollback the transaction
4559: --
4560: hr_utility.set_location('rolling back' ,10);
4561: rollback to communications_savepoint;
4562: --
4563: else
4564: --

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

4561: rollback to communications_savepoint;
4562: --
4563: else
4564: --
4565: hr_utility.set_location('Cm type id'||l_per_cm_id,10);
4566: populate_working_tables
4567: (p_person_id => p_person_id,
4568: p_cm_typ_id => l_triggers.cm_typ_id,
4569: p_business_group_id => p_business_group_id,

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

4588: else
4589: --
4590: -- Generate related persons/dependents comm.
4591: --
4592: hr_utility.set_location('Entering dpnt',10);
4593: ben_generate_dpnt_comm.main
4594: (p_proc_cd => l_triggers.proc_cd,
4595: p_name => l_triggers.name,
4596: p_rcpent_cd => l_triggers.rcpent_cd,

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

4629: end loop;
4630: --
4631: close c_triggers;
4632: --
4633: hr_utility.set_location('Leaving: '||l_proc,10);
4634: --
4635: hr_utility.set_location('Displaying stats ',10);
4636: end main;
4637: --

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

4631: close c_triggers;
4632: --
4633: hr_utility.set_location('Leaving: '||l_proc,10);
4634: --
4635: hr_utility.set_location('Displaying stats ',10);
4636: end main;
4637: --
4638: end ben_generate_communications;
4639: --