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

454: l_cvg_adjust varchar2(1); -- bug 7206471
455:
456: begin
457: --
458: hr_utility.set_location ('Entering '||g_package, 10);
459: -- bug 6127624
460: OPEN csr_electable_epes;
461:
462: FETCH csr_electable_epes

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

465: IF csr_electable_epes%FOUND
466: THEN
467: IF g_debug
468: THEN
469: hr_utility.set_location ('Electable choices found ', 121);
470: END IF;
471: open c_ended_result (p_per_in_ler_id,p_business_group_id);
472: loop
473: fetch c_ended_result into l_ended_result;

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

485: )
486: THEN
487: IF g_debug
488: THEN
489: hr_utility.set_location ( 'Eligible for pen_id '|| l_ended_result.prtt_enrt_rslt_id,121);
490: END IF;
491:
492: insert into BEN_LE_CLSN_N_RSTR (
493: BKUP_TBL_TYP_CD,

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

820: l_future_results.PLIP_ORDR_NUM,
821: l_future_results.PTIP_ORDR_NUM,
822: l_future_results.OIPL_ORDR_NUM
823: );
824: hr_utility.set_location('DDD 33 Backingout l_future_results.prtt_enrt_rslt_id'||l_future_results.prtt_enrt_rslt_id,999);
825:
826: ben_back_out_life_event.back_out_life_events
827: (p_per_in_ler_id => l_future_results.per_in_ler_id,
828: p_business_group_id => p_business_group_id,

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

861: --
862: end if; -- check_prev_eligible
863: end loop;
864: close c_ended_result;
865: hr_utility.set_location ('Leaving'||g_package, 20);
866: -- Reopen ended result in other ineligible program and deenroll
867: open c_pl_typ (p_per_in_ler_id);
868: loop
869: fetch c_pl_typ into l_pgm_id, l_pl_typ_id;

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

885: p_prtt_enrt_rslt_id => l_ended_prv.prtt_enrt_rslt_id);
886: fetch c_prv into l_prv;
887: if c_prv%found then
888: --
889: hr_utility.set_location('Update prtt rt val'||l_ended_prv.prtt_rt_val_id,100);
890: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
891:
892: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
893: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);

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

888: --
889: hr_utility.set_location('Update prtt rt val'||l_ended_prv.prtt_rt_val_id,100);
890: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
891:
892: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
893: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
894: hr_utility.set_location('Rate should be ended with lesser date ',121);
895:
896: ben_prtt_rt_val_api.update_prtt_rt_val

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

889: hr_utility.set_location('Update prtt rt val'||l_ended_prv.prtt_rt_val_id,100);
890: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
891:
892: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
893: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
894: hr_utility.set_location('Rate should be ended with lesser date ',121);
895:
896: ben_prtt_rt_val_api.update_prtt_rt_val
897: (P_VALIDATE => FALSE

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

890: if l_prv.rt_end_dt < l_ended_prv.rt_end_dt then -- 5947036
891:
892: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
893: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
894: hr_utility.set_location('Rate should be ended with lesser date ',121);
895:
896: ben_prtt_rt_val_api.update_prtt_rt_val
897: (P_VALIDATE => FALSE
898: ,P_PRTT_RT_VAL_ID => l_ended_prv.prtt_rt_val_id

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

903: ,P_OBJECT_VERSION_NUMBER => l_ended_prv.object_version_number
904: ,P_EFFECTIVE_DATE => p_effective_date
905: );
906: else
907: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
908: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
909: hr_utility.set_location('Rate is ended with a lesser date already ',121);
910: end if;
911: -- end 5947036

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

904: ,P_EFFECTIVE_DATE => p_effective_date
905: );
906: else
907: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
908: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
909: hr_utility.set_location('Rate is ended with a lesser date already ',121);
910: end if;
911: -- end 5947036
912: end if;

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

905: );
906: else
907: hr_utility.set_location('l_prv.rt_end_dt ' || l_prv.rt_end_dt ,121);
908: hr_utility.set_location('l_ended_prv.rt_end_dt ' || l_ended_prv.rt_end_dt ,121);
909: hr_utility.set_location('Rate is ended with a lesser date already ',121);
910: end if;
911: -- end 5947036
912: end if;
913: close c_prv;

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

926: if c_ended_result2%notfound then
927: exit;
928: end if;
929: --
930: hr_utility.set_location ('ENdedn result 2',100);
931: insert into BEN_LE_CLSN_N_RSTR (
932: BKUP_TBL_TYP_CD,
933: COMP_LVL_CD,
934: LCR_ATTRIBUTE16,

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

1100: open c_pen(l_ended_result2.prtt_enrt_rslt_id);
1101: fetch c_pen into l_pen;
1102: close c_pen;
1103: --
1104: hr_utility.set_location ('Delete enrollment ',101);
1105: if l_pen.effective_start_date is not null then
1106: ben_prtt_enrt_result_api.delete_enrollment
1107: (p_validate => false ,
1108: p_prtt_enrt_rslt_id => l_ended_result2.prtt_enrt_rslt_id,

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

1147: -- Get all results that were de-enrolled for the event.
1148: --
1149: for l_pen in c_get_enrt_rslts(l_epe.rt_strt_dt
1150: ,l_epe.ptip_id ) loop
1151: hr_utility.set_location('Adjusting rate '||l_epe.rt_strt_dt,111);
1152: --
1153: open c_prtt_rt_val_adj(p_per_in_ler_id,l_pen.prtt_rt_val_id);
1154: fetch c_prtt_rt_val_adj into l_exists;
1155: if c_prtt_rt_val_adj%notfound then

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

1200: if c_get_pgm_extra_info_cvg%found then
1201: --
1202: if l_cvg_adjust = 'Y' then
1203: --
1204: hr_utility.set_location('l_cvg_adjust '||l_cvg_adjust,44333);
1205: --
1206: -- Get cvg end dt
1207: --
1208: for l_get_elctbl_chc_for_cvg in c_get_elctbl_chc_for_cvg loop

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

1210: -- Get all results that were de-enrolled for the event.
1211: --
1212: for l_get_enrt_rslts_for_pen in c_get_enrt_rslts_for_pen(l_get_elctbl_chc_for_cvg.enrt_cvg_strt_dt
1213: ,l_get_elctbl_chc_for_cvg.ptip_id ) loop
1214: hr_utility.set_location('Adjusting Coverage for '||l_get_elctbl_chc_for_cvg.enrt_cvg_strt_dt,44333);
1215: --
1216: open c_prtt_enrt_rslt_adj(p_per_in_ler_id,l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id);
1217: fetch c_prtt_enrt_rslt_adj into l_exists;
1218: if c_prtt_enrt_rslt_adj%notfound then

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

1261: --
1262: -- bug 6127624
1263: end if; -- end if csr_electable_epe
1264: close csr_electable_epes;
1265: hr_utility.set_location ('Leaving '||g_package, 10);
1266: end;
1267: --
1268: end ben_reopen_ended_results;