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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: ---
4: -- Package Variables
5: --
6: g_package varchar2(300) := 'ben_reopen_ended_results.';
7: g_debug boolean := hr_utility.debug_enabled;
8: --
9: -- bug 6127624 added
10: FUNCTION check_prev_eligible (
11: p_person_id IN NUMBER,

Line 94: hr_utility.set_location ('Entering ' || l_proc, 121);

90: := g_package || 'check_prev_eligible';
91: BEGIN
92: IF g_debug
93: THEN
94: hr_utility.set_location ('Entering ' || l_proc, 121);
95: hr_utility.set_location ('p_person_id ' || p_person_id, 121);
96: hr_utility.set_location ('p_pgm_id ' || p_pgm_id, 121);
97: hr_utility.set_location ('p_pl_id ' || p_pl_id, 121);
98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);

Line 95: hr_utility.set_location ('p_person_id ' || p_person_id, 121);

91: BEGIN
92: IF g_debug
93: THEN
94: hr_utility.set_location ('Entering ' || l_proc, 121);
95: hr_utility.set_location ('p_person_id ' || p_person_id, 121);
96: hr_utility.set_location ('p_pgm_id ' || p_pgm_id, 121);
97: hr_utility.set_location ('p_pl_id ' || p_pl_id, 121);
98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);
99: hr_utility.set_location ('p_business_group_id ' || p_business_group_id,

Line 96: hr_utility.set_location ('p_pgm_id ' || p_pgm_id, 121);

92: IF g_debug
93: THEN
94: hr_utility.set_location ('Entering ' || l_proc, 121);
95: hr_utility.set_location ('p_person_id ' || p_person_id, 121);
96: hr_utility.set_location ('p_pgm_id ' || p_pgm_id, 121);
97: hr_utility.set_location ('p_pl_id ' || p_pl_id, 121);
98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);
99: hr_utility.set_location ('p_business_group_id ' || p_business_group_id,
100: 121

Line 97: hr_utility.set_location ('p_pl_id ' || p_pl_id, 121);

93: THEN
94: hr_utility.set_location ('Entering ' || l_proc, 121);
95: hr_utility.set_location ('p_person_id ' || p_person_id, 121);
96: hr_utility.set_location ('p_pgm_id ' || p_pgm_id, 121);
97: hr_utility.set_location ('p_pl_id ' || p_pl_id, 121);
98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);
99: hr_utility.set_location ('p_business_group_id ' || p_business_group_id,
100: 121
101: );

Line 98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);

94: hr_utility.set_location ('Entering ' || l_proc, 121);
95: hr_utility.set_location ('p_person_id ' || p_person_id, 121);
96: hr_utility.set_location ('p_pgm_id ' || p_pgm_id, 121);
97: hr_utility.set_location ('p_pl_id ' || p_pl_id, 121);
98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);
99: hr_utility.set_location ('p_business_group_id ' || p_business_group_id,
100: 121
101: );
102: hr_utility.set_location ( 'p_effective_date '

Line 99: hr_utility.set_location ('p_business_group_id ' || p_business_group_id,

95: hr_utility.set_location ('p_person_id ' || p_person_id, 121);
96: hr_utility.set_location ('p_pgm_id ' || p_pgm_id, 121);
97: hr_utility.set_location ('p_pl_id ' || p_pl_id, 121);
98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);
99: hr_utility.set_location ('p_business_group_id ' || p_business_group_id,
100: 121
101: );
102: hr_utility.set_location ( 'p_effective_date '
103: || TO_CHAR (p_effective_date, 'YYYY/MM/DD'),

Line 102: hr_utility.set_location ( 'p_effective_date '

98: hr_utility.set_location ('p_oipl_id ' || p_oipl_id, 121);
99: hr_utility.set_location ('p_business_group_id ' || p_business_group_id,
100: 121
101: );
102: hr_utility.set_location ( 'p_effective_date '
103: || TO_CHAR (p_effective_date, 'YYYY/MM/DD'),
104: 121
105: );
106: hr_utility.set_location ('p_per_in_ler_id ' || p_per_in_ler_id, 121);

Line 106: hr_utility.set_location ('p_per_in_ler_id ' || p_per_in_ler_id, 121);

102: hr_utility.set_location ( 'p_effective_date '
103: || TO_CHAR (p_effective_date, 'YYYY/MM/DD'),
104: 121
105: );
106: hr_utility.set_location ('p_per_in_ler_id ' || p_per_in_ler_id, 121);
107: END IF;
108:
109: IF p_oipl_id IS NOT NULL
110: THEN

Line 134: hr_utility.set_location ('oipl elig ', 121);

130: IF rec_prev_opt_elig_check.elig_flag = 'Y'
131: THEN
132: IF g_debug
133: THEN
134: hr_utility.set_location ('oipl elig ', 121);
135: END IF;
136:
137: l_return := TRUE;
138: END IF;

Line 156: hr_utility.set_location ('pl elig', 121);

152: IF rec_prev_opt_elig_check.elig_flag = 'Y'
153: THEN
154: IF g_debug
155: THEN
156: hr_utility.set_location ('pl elig', 121);
157: END IF;
158:
159: l_return := TRUE;
160: END IF;

Line 163: hr_utility.set_location ('Leaving ' || l_proc, 121);

159: l_return := TRUE;
160: END IF;
161: END IF;
162:
163: hr_utility.set_location ('Leaving ' || l_proc, 121);
164: RETURN l_return;
165: EXCEPTION
166: WHEN OTHERS
167: THEN

Line 168: hr_utility.set_location (SQLERRM, -121);

164: RETURN l_return;
165: EXCEPTION
166: WHEN OTHERS
167: THEN
168: hr_utility.set_location (SQLERRM, -121);
169: hr_utility.set_location ('Leaving ' || l_proc, -121);
170: RAISE;
171: END check_prev_eligible;
172:

Line 169: hr_utility.set_location ('Leaving ' || l_proc, -121);

165: EXCEPTION
166: WHEN OTHERS
167: THEN
168: hr_utility.set_location (SQLERRM, -121);
169: hr_utility.set_location ('Leaving ' || l_proc, -121);
170: RAISE;
171: END check_prev_eligible;
172:
173:

Line 496: hr_utility.set_location ('Entering '||g_package, 10);

492: l_cvg_adjust varchar2(1); -- bug 7206471
493:
494: begin
495: --
496: hr_utility.set_location ('Entering '||g_package, 10);
497: -- bug 6127624
498: OPEN csr_electable_epes;
499:
500: FETCH csr_electable_epes

Line 507: hr_utility.set_location ('Electable choices found ', 121);

503: IF csr_electable_epes%FOUND
504: THEN
505: IF g_debug
506: THEN
507: hr_utility.set_location ('Electable choices found ', 121);
508: END IF;
509: open c_ended_result (p_per_in_ler_id,p_business_group_id);
510: loop
511: fetch c_ended_result into l_ended_result;

Line 527: hr_utility.set_location ( 'Eligible for pen_id '|| l_ended_result.prtt_enrt_rslt_id,121);

523: )
524: THEN
525: IF g_debug
526: THEN
527: hr_utility.set_location ( 'Eligible for pen_id '|| l_ended_result.prtt_enrt_rslt_id,121);
528: END IF;
529:
530: insert into BEN_LE_CLSN_N_RSTR (
531: BKUP_TBL_TYP_CD,

Line 862: hr_utility.set_location('DDD 33 Backingout l_future_results.prtt_enrt_rslt_id'||l_future_results.prtt_enrt_rslt_id,999);

858: l_future_results.PLIP_ORDR_NUM,
859: l_future_results.PTIP_ORDR_NUM,
860: l_future_results.OIPL_ORDR_NUM
861: );
862: hr_utility.set_location('DDD 33 Backingout l_future_results.prtt_enrt_rslt_id'||l_future_results.prtt_enrt_rslt_id,999);
863:
864: ben_back_out_life_event.back_out_life_events
865: (p_per_in_ler_id => l_future_results.per_in_ler_id,
866: p_business_group_id => p_business_group_id,

Line 903: hr_utility.set_location ('Leaving'||g_package, 20);

899: --
900: end if; -- check_prev_eligible
901: end loop;
902: close c_ended_result;
903: hr_utility.set_location ('Leaving'||g_package, 20);
904: -- Reopen ended result in other ineligible program and deenroll
905: open c_pl_typ (p_per_in_ler_id);
906: loop
907: fetch c_pl_typ into l_pgm_id, l_pl_typ_id;

Line 927: hr_utility.set_location('Update prtt rt val'||l_ended_prv.prtt_rt_val_id,100);

923: p_prtt_enrt_rslt_id => l_ended_prv.prtt_enrt_rslt_id);
924: fetch c_prv into l_prv;
925: if c_prv%found then
926: --
927: hr_utility.set_location('Update prtt rt val'||l_ended_prv.prtt_rt_val_id,100);
928: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
929:
930: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
931: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);

Line 930: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);

926: --
927: hr_utility.set_location('Update prtt rt val'||l_ended_prv.prtt_rt_val_id,100);
928: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
929:
930: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
931: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
932: hr_utility.set_location('Rate should be ended with lesser date ',121);
933:
934: ben_prtt_rt_val_api.update_prtt_rt_val

Line 931: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);

927: hr_utility.set_location('Update prtt rt val'||l_ended_prv.prtt_rt_val_id,100);
928: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
929:
930: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
931: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
932: hr_utility.set_location('Rate should be ended with lesser date ',121);
933:
934: ben_prtt_rt_val_api.update_prtt_rt_val
935: (P_VALIDATE => FALSE

Line 932: hr_utility.set_location('Rate should be ended with lesser date ',121);

928: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
929:
930: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
931: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
932: hr_utility.set_location('Rate should be ended with lesser date ',121);
933:
934: ben_prtt_rt_val_api.update_prtt_rt_val
935: (P_VALIDATE => FALSE
936: ,P_PRTT_RT_VAL_ID => l_ended_prv.prtt_rt_val_id

Line 945: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);

941: ,P_OBJECT_VERSION_NUMBER => l_ended_prv.object_version_number
942: ,P_EFFECTIVE_DATE => p_effective_date
943: );
944: else
945: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
946: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
947: hr_utility.set_location('Rate is ended with a lesser date already ',121);
948: end if;
949: -- end 5947036

Line 946: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);

942: ,P_EFFECTIVE_DATE => p_effective_date
943: );
944: else
945: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
946: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
947: hr_utility.set_location('Rate is ended with a lesser date already ',121);
948: end if;
949: -- end 5947036
950: end if;

Line 947: hr_utility.set_location('Rate is ended with a lesser date already ',121);

943: );
944: else
945: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
946: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
947: hr_utility.set_location('Rate is ended with a lesser date already ',121);
948: end if;
949: -- end 5947036
950: end if;
951: close c_prv;

Line 968: hr_utility.set_location ('ENdedn result 2',100);

964: if c_ended_result2%notfound then
965: exit;
966: end if;
967: --
968: hr_utility.set_location ('ENdedn result 2',100);
969: hr_utility.set_location ('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,100);
970: hr_utility.set_location ('p_pl_typ_id '||l_pl_typ_id,100);
971: hr_utility.set_location ('p_pgm_id '||l_pgm_id,100);
972: hr_utility.set_location ('l_ended_results2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,100);

Line 969: hr_utility.set_location ('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,100);

965: exit;
966: end if;
967: --
968: hr_utility.set_location ('ENdedn result 2',100);
969: hr_utility.set_location ('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,100);
970: hr_utility.set_location ('p_pl_typ_id '||l_pl_typ_id,100);
971: hr_utility.set_location ('p_pgm_id '||l_pgm_id,100);
972: hr_utility.set_location ('l_ended_results2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,100);
973: insert into BEN_LE_CLSN_N_RSTR (

Line 970: hr_utility.set_location ('p_pl_typ_id '||l_pl_typ_id,100);

966: end if;
967: --
968: hr_utility.set_location ('ENdedn result 2',100);
969: hr_utility.set_location ('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,100);
970: hr_utility.set_location ('p_pl_typ_id '||l_pl_typ_id,100);
971: hr_utility.set_location ('p_pgm_id '||l_pgm_id,100);
972: hr_utility.set_location ('l_ended_results2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,100);
973: insert into BEN_LE_CLSN_N_RSTR (
974: BKUP_TBL_TYP_CD,

Line 971: hr_utility.set_location ('p_pgm_id '||l_pgm_id,100);

967: --
968: hr_utility.set_location ('ENdedn result 2',100);
969: hr_utility.set_location ('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,100);
970: hr_utility.set_location ('p_pl_typ_id '||l_pl_typ_id,100);
971: hr_utility.set_location ('p_pgm_id '||l_pgm_id,100);
972: hr_utility.set_location ('l_ended_results2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,100);
973: insert into BEN_LE_CLSN_N_RSTR (
974: BKUP_TBL_TYP_CD,
975: COMP_LVL_CD,

Line 972: hr_utility.set_location ('l_ended_results2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,100);

968: hr_utility.set_location ('ENdedn result 2',100);
969: hr_utility.set_location ('p_lf_evt_ocrd_dt '||p_lf_evt_ocrd_dt,100);
970: hr_utility.set_location ('p_pl_typ_id '||l_pl_typ_id,100);
971: hr_utility.set_location ('p_pgm_id '||l_pgm_id,100);
972: hr_utility.set_location ('l_ended_results2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,100);
973: insert into BEN_LE_CLSN_N_RSTR (
974: BKUP_TBL_TYP_CD,
975: COMP_LVL_CD,
976: LCR_ATTRIBUTE16,

Line 1137: hr_utility.set_location ('l_ended_result2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,101);

1133: );
1134: --
1135: -- Back up the prtt rt val -- 8896851
1136: --
1137: hr_utility.set_location ('l_ended_result2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,101);
1138: hr_utility.set_location ('l_ended_result2.per_in_ler_id '||l_ended_result2.per_in_ler_id,101);
1139: for l_prv_rec in c_get_prv(l_ended_result2.prtt_enrt_rslt_id
1140: ,l_ended_result2.per_in_ler_id) loop
1141: hr_utility.set_location ('l_prv_rec.prtt_rt_val_id'||l_prv_rec.prtt_rt_val_id,102);

Line 1138: hr_utility.set_location ('l_ended_result2.per_in_ler_id '||l_ended_result2.per_in_ler_id,101);

1134: --
1135: -- Back up the prtt rt val -- 8896851
1136: --
1137: hr_utility.set_location ('l_ended_result2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,101);
1138: hr_utility.set_location ('l_ended_result2.per_in_ler_id '||l_ended_result2.per_in_ler_id,101);
1139: for l_prv_rec in c_get_prv(l_ended_result2.prtt_enrt_rslt_id
1140: ,l_ended_result2.per_in_ler_id) loop
1141: hr_utility.set_location ('l_prv_rec.prtt_rt_val_id'||l_prv_rec.prtt_rt_val_id,102);
1142: hr_utility.set_location ('l_prv_rec.ended_per_in_ler_id'||l_prv_rec.ended_per_in_ler_id,102);

Line 1141: hr_utility.set_location ('l_prv_rec.prtt_rt_val_id'||l_prv_rec.prtt_rt_val_id,102);

1137: hr_utility.set_location ('l_ended_result2.prtt_enrt_rslt_id '||l_ended_result2.prtt_enrt_rslt_id,101);
1138: hr_utility.set_location ('l_ended_result2.per_in_ler_id '||l_ended_result2.per_in_ler_id,101);
1139: for l_prv_rec in c_get_prv(l_ended_result2.prtt_enrt_rslt_id
1140: ,l_ended_result2.per_in_ler_id) loop
1141: hr_utility.set_location ('l_prv_rec.prtt_rt_val_id'||l_prv_rec.prtt_rt_val_id,102);
1142: hr_utility.set_location ('l_prv_rec.ended_per_in_ler_id'||l_prv_rec.ended_per_in_ler_id,102);
1143: hr_utility.set_location ('p_per_in_ler_id'||p_per_in_ler_id,102);
1144: insert into BEN_LE_CLSN_N_RSTR (
1145: BKUP_TBL_TYP_CD,

Line 1142: hr_utility.set_location ('l_prv_rec.ended_per_in_ler_id'||l_prv_rec.ended_per_in_ler_id,102);

1138: hr_utility.set_location ('l_ended_result2.per_in_ler_id '||l_ended_result2.per_in_ler_id,101);
1139: for l_prv_rec in c_get_prv(l_ended_result2.prtt_enrt_rslt_id
1140: ,l_ended_result2.per_in_ler_id) loop
1141: hr_utility.set_location ('l_prv_rec.prtt_rt_val_id'||l_prv_rec.prtt_rt_val_id,102);
1142: hr_utility.set_location ('l_prv_rec.ended_per_in_ler_id'||l_prv_rec.ended_per_in_ler_id,102);
1143: hr_utility.set_location ('p_per_in_ler_id'||p_per_in_ler_id,102);
1144: insert into BEN_LE_CLSN_N_RSTR (
1145: BKUP_TBL_TYP_CD,
1146: RT_END_DT,

Line 1143: hr_utility.set_location ('p_per_in_ler_id'||p_per_in_ler_id,102);

1139: for l_prv_rec in c_get_prv(l_ended_result2.prtt_enrt_rslt_id
1140: ,l_ended_result2.per_in_ler_id) loop
1141: hr_utility.set_location ('l_prv_rec.prtt_rt_val_id'||l_prv_rec.prtt_rt_val_id,102);
1142: hr_utility.set_location ('l_prv_rec.ended_per_in_ler_id'||l_prv_rec.ended_per_in_ler_id,102);
1143: hr_utility.set_location ('p_per_in_ler_id'||p_per_in_ler_id,102);
1144: insert into BEN_LE_CLSN_N_RSTR (
1145: BKUP_TBL_TYP_CD,
1146: RT_END_DT,
1147: PER_IN_LER_ID,

Line 1165: hr_utility.set_location ('enrt_cvg_thru_dt '||l_ended_result2.enrt_cvg_thru_dt,101);

1161: --
1162: -- end 8896851
1163: --
1164: /* bug # 8968118 */
1165: hr_utility.set_location ('enrt_cvg_thru_dt '||l_ended_result2.enrt_cvg_thru_dt,101);
1166: hr_utility.set_location ('p_pgm_id '||l_ended_result2.pgm_id, 101);
1167: for l_future_results2 in c_future_results2 (p_person_id
1168: ,l_ended_result2.enrt_cvg_thru_dt
1169: ,l_ended_result2.pl_typ_id

Line 1166: hr_utility.set_location ('p_pgm_id '||l_ended_result2.pgm_id, 101);

1162: -- end 8896851
1163: --
1164: /* bug # 8968118 */
1165: hr_utility.set_location ('enrt_cvg_thru_dt '||l_ended_result2.enrt_cvg_thru_dt,101);
1166: hr_utility.set_location ('p_pgm_id '||l_ended_result2.pgm_id, 101);
1167: for l_future_results2 in c_future_results2 (p_person_id
1168: ,l_ended_result2.enrt_cvg_thru_dt
1169: ,l_ended_result2.pl_typ_id
1170: ,l_ended_result2.business_group_id

Line 1334: hr_utility.set_location('DDD 44 Backing out l_future_results2.prtt_enrt_rslt_id'||l_future_results2.prtt_enrt_rslt_id,999);

1330: l_future_results2.PLIP_ORDR_NUM,
1331: l_future_results2.PTIP_ORDR_NUM,
1332: l_future_results2.OIPL_ORDR_NUM
1333: );
1334: hr_utility.set_location('DDD 44 Backing out l_future_results2.prtt_enrt_rslt_id'||l_future_results2.prtt_enrt_rslt_id,999);
1335:
1336: ben_back_out_life_event.back_out_life_events
1337: (p_per_in_ler_id => l_future_results2.per_in_ler_id
1338: ,p_business_group_id => p_business_group_id

Line 1378: hr_utility.set_location ('Delete enrollment ',101);

1374: open c_pen(l_ended_result2.prtt_enrt_rslt_id);
1375: fetch c_pen into l_pen;
1376: close c_pen;
1377: --
1378: hr_utility.set_location ('Delete enrollment ',101);
1379: if l_pen.effective_start_date is not null then
1380: ben_prtt_enrt_result_api.delete_enrollment
1381: (p_validate => false ,
1382: p_prtt_enrt_rslt_id => l_ended_result2.prtt_enrt_rslt_id,

Line 1425: hr_utility.set_location('Adjusting rate '||l_epe.rt_strt_dt,111);

1421: -- Get all results that were de-enrolled for the event.
1422: --
1423: for l_pen in c_get_enrt_rslts(l_epe.rt_strt_dt
1424: ,l_epe.ptip_id ) loop
1425: hr_utility.set_location('Adjusting rate '||l_epe.rt_strt_dt,111);
1426: --
1427: open c_prtt_rt_val_adj(p_per_in_ler_id,l_pen.prtt_rt_val_id);
1428: fetch c_prtt_rt_val_adj into l_exists;
1429: if c_prtt_rt_val_adj%notfound then

Line 1478: hr_utility.set_location('l_cvg_adjust '||l_cvg_adjust,44333);

1474: if c_get_pgm_extra_info_cvg%found then
1475: --
1476: if l_cvg_adjust = 'Y' then
1477: --
1478: hr_utility.set_location('l_cvg_adjust '||l_cvg_adjust,44333);
1479: --
1480: -- Get cvg end dt
1481: --
1482: for l_get_elctbl_chc_for_cvg in c_get_elctbl_chc_for_cvg loop

Line 1488: hr_utility.set_location('Adjusting Coverage for '||l_get_elctbl_chc_for_cvg.enrt_cvg_strt_dt,44333);

1484: -- Get all results that were de-enrolled for the event.
1485: --
1486: for l_get_enrt_rslts_for_pen in c_get_enrt_rslts_for_pen(l_get_elctbl_chc_for_cvg.enrt_cvg_strt_dt
1487: ,l_get_elctbl_chc_for_cvg.ptip_id ) loop
1488: hr_utility.set_location('Adjusting Coverage for '||l_get_elctbl_chc_for_cvg.enrt_cvg_strt_dt,44333);
1489: --
1490: open c_prtt_enrt_rslt_adj(p_per_in_ler_id,l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id);
1491: fetch c_prtt_enrt_rslt_adj into l_exists;
1492: if c_prtt_enrt_rslt_adj%notfound then

Line 1539: hr_utility.set_location ('Leaving '||g_package, 10);

1535: --
1536: -- bug 6127624
1537: end if; -- end if csr_electable_epe
1538: close csr_electable_epes;
1539: hr_utility.set_location ('Leaving '||g_package, 10);
1540: end;
1541: --
1542: end ben_reopen_ended_results;