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.

[Home] [Help]

APPS.BEN_CWB_REFRESH_PKG dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_refresh_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- --------------------------------------------------------------------------
12: -- |------------------------------< refresh >-------------------------------|
13: -- --------------------------------------------------------------------------

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

90: --
91: begin
92: --
93: if g_debug then
94: hr_utility.set_location('Entering:'|| l_proc, 10);
95: end if;
96: --
97: l_effective_date :=trunc(to_date(p_effective_date,'yyyy/mm/dd hh24:mi:ss'));
98: l_lf_evt_ocrd_dt :=trunc(to_date(p_lf_evt_ocrd_dt,'yyyy/mm/dd hh24:mi:ss'));

Line 102: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);

98: l_lf_evt_ocrd_dt :=trunc(to_date(p_lf_evt_ocrd_dt,'yyyy/mm/dd hh24:mi:ss'));
99: l_ranks_initialised := 0;
100:
101: if g_debug then
102: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
103: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
104: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
106: hr_utility.set_location('Refresh Person Info :'||

Line 103: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);

99: l_ranks_initialised := 0;
100:
101: if g_debug then
102: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
103: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
104: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
106: hr_utility.set_location('Refresh Person Info :'||
107: p_refresh_person_info_flag, 20);

Line 104: hr_utility.set_location('Eff Date :'||l_effective_date, 20);

100:
101: if g_debug then
102: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
103: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
104: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
106: hr_utility.set_location('Refresh Person Info :'||
107: p_refresh_person_info_flag, 20);
108: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);

Line 105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);

101: if g_debug then
102: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
103: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
104: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
106: hr_utility.set_location('Refresh Person Info :'||
107: p_refresh_person_info_flag, 20);
108: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
109: hr_utility.set_location('Consolidate Summary:'||

Line 106: hr_utility.set_location('Refresh Person Info :'||

102: hr_utility.set_location('Group Pl Id :'||p_group_pl_id, 20);
103: hr_utility.set_location('Lf Evt Date :'||l_lf_evt_ocrd_dt, 20);
104: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
106: hr_utility.set_location('Refresh Person Info :'||
107: p_refresh_person_info_flag, 20);
108: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
109: hr_utility.set_location('Consolidate Summary:'||
110: p_consolidate_summary_flag, 20);

Line 108: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);

104: hr_utility.set_location('Eff Date :'||l_effective_date, 20);
105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
106: hr_utility.set_location('Refresh Person Info :'||
107: p_refresh_person_info_flag, 20);
108: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
109: hr_utility.set_location('Consolidate Summary:'||
110: p_consolidate_summary_flag, 20);
111: hr_utility.set_location('Initialising Rankings:'||
112: p_init_rank, 20);

Line 109: hr_utility.set_location('Consolidate Summary:'||

105: hr_utility.set_location('Refresh Summary :'||p_refresh_summary_flag, 20);
106: hr_utility.set_location('Refresh Person Info :'||
107: p_refresh_person_info_flag, 20);
108: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
109: hr_utility.set_location('Consolidate Summary:'||
110: p_consolidate_summary_flag, 20);
111: hr_utility.set_location('Initialising Rankings:'||
112: p_init_rank, 20);
113: hr_utility.set_location('Refresh Exchange Rate:'||

Line 111: hr_utility.set_location('Initialising Rankings:'||

107: p_refresh_person_info_flag, 20);
108: hr_utility.set_location('Refresh Pl Dsgn :'||p_refresh_pl_dsgn_flag, 20);
109: hr_utility.set_location('Consolidate Summary:'||
110: p_consolidate_summary_flag, 20);
111: hr_utility.set_location('Initialising Rankings:'||
112: p_init_rank, 20);
113: hr_utility.set_location('Refresh Exchange Rate:'||
114: p_refresh_xchg, 20);
115: end if;

Line 113: hr_utility.set_location('Refresh Exchange Rate:'||

109: hr_utility.set_location('Consolidate Summary:'||
110: p_consolidate_summary_flag, 20);
111: hr_utility.set_location('Initialising Rankings:'||
112: p_init_rank, 20);
113: hr_utility.set_location('Refresh Exchange Rate:'||
114: p_refresh_xchg, 20);
115: end if;
116: --
117: --

Line 121: hr_utility.set_location(l_proc, 21);

117: --
118: if p_init_rank = 'Y' then
119: ben_batch_utils.WRITE('Initialising Rankings');
120: if g_debug then
121: hr_utility.set_location(l_proc, 21);
122: end if;
123: for l_ranking_info in c_ranking_info loop
124: hr_assignment_extra_info_api.delete_assignment_extra_info
125: (p_validate => false

Line 138: hr_utility.set_location(l_proc, 30);

134: if p_refresh_pl_dsgn_flag = 'Y' then
135: --
136: ben_batch_utils.WRITE('Refreshing Plan Design');
137: if g_debug then
138: hr_utility.set_location(l_proc, 30);
139: end if;
140: --
141: ben_cwb_pl_dsgn_pkg.refresh_pl_dsgn
142: (p_group_pl_id => p_group_pl_id

Line 149: hr_utility.set_location(l_proc, 40);

145: ,p_refresh_always => 'Y');
146: commit;
147: --
148: if g_debug then
149: hr_utility.set_location(l_proc, 40);
150: end if;
151: --
152: end if;
153: --

Line 159: hr_utility.set_location(l_proc, 21);

155: savepoint before_refresh_xchg;
156: if p_refresh_xchg = 'Y' then
157: ben_batch_utils.WRITE('Initialising Refresh');
158: if g_debug then
159: hr_utility.set_location(l_proc, 21);
160: end if;
161: ben_cwb_xchg_pkg.insert_into_ben_cwb_xchg(p_group_pl_id
162: ,l_lf_evt_ocrd_dt
163: ,l_effective_date

Line 177: hr_utility.set_location(l_proc, 50);

173: rollback to before_refresh_xchg;
174: end;
175: --
176: if g_debug then
177: hr_utility.set_location(l_proc, 50);
178: end if;
179: --
180: if p_refresh_person_info_flag = 'Y' then
181: --

Line 184: hr_utility.set_location(l_proc, 60);

180: if p_refresh_person_info_flag = 'Y' then
181: --
182: ben_batch_utils.WRITE('Refreshing Person Info');
183: if g_debug then
184: hr_utility.set_location(l_proc, 60);
185: end if;
186: --
187: ben_cwb_person_info_pkg.refresh_person_info_group_pl
188: (p_group_pl_id => p_group_pl_id

Line 195: hr_utility.set_location(l_proc, 70);

191: --
192: commit;
193: --
194: if g_debug then
195: hr_utility.set_location(l_proc, 70);
196: end if;
197: --
198: end if;
199: --

Line 201: hr_utility.set_location(l_proc, 80);

197: --
198: end if;
199: --
200: if g_debug then
201: hr_utility.set_location(l_proc, 80);
202: end if;
203: --
204: if p_refresh_summary_flag = 'Y' then
205: --

Line 208: hr_utility.set_location(l_proc, 90);

204: if p_refresh_summary_flag = 'Y' then
205: --
206: ben_batch_utils.WRITE('Refreshing Summary');
207: if g_debug then
208: hr_utility.set_location(l_proc, 90);
209: end if;
210: --
211: ben_cwb_summary_pkg.refresh_summary_group_pl
212: (p_group_pl_id => p_group_pl_id

Line 218: hr_utility.set_location(l_proc, 100);

214: --
215: commit;
216: --
217: if g_debug then
218: hr_utility.set_location(l_proc, 100);
219: end if;
220: --
221: end if;
222: --

Line 224: hr_utility.set_location(l_proc, 110);

220: --
221: end if;
222: --
223: if g_debug then
224: hr_utility.set_location(l_proc, 110);
225: end if;
226: --
227: -- if the summary is refreshed then there is no need to consolidate the
228: -- summary

Line 234: hr_utility.set_location(l_proc, 120);

230:
231: ben_batch_utils.WRITE('Consolidating Summary');
232: --
233: if g_debug then
234: hr_utility.set_location(l_proc, 120);
235: end if;
236: --
237: for rec in csr_person_ids(p_group_pl_id,l_lf_evt_ocrd_dt) loop
238: --

Line 240: hr_utility.set_location(l_proc, 130);

236: --
237: for rec in csr_person_ids(p_group_pl_id,l_lf_evt_ocrd_dt) loop
238: --
239: if g_debug then
240: hr_utility.set_location(l_proc, 130);
241: end if;
242: --
243: ben_cwb_summary_pkg.consolidate_summary_rec
244: (p_person_id => rec.person_id);

Line 249: hr_utility.set_location(l_proc, 140);

245: end loop;
246: commit;
247: --
248: if g_debug then
249: hr_utility.set_location(l_proc, 140);
250: end if;
251: --
252: end if;
253: --

Line 286: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);

282: ,p_returned_date => l_returned_date
283: );
284: -- ben_batch_utils.WRITE(rec.group_per_in_ler_id||' '||l_returned_date||' '||rec.oipl_id);
285: if g_debug then
286: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);
287: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);
288: end if;
289:
290: BEN_CWB_PERSON_RATES_API.update_person_rate(

Line 287: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);

283: );
284: -- ben_batch_utils.WRITE(rec.group_per_in_ler_id||' '||l_returned_date||' '||rec.oipl_id);
285: if g_debug then
286: hr_utility.set_location(' p_returned_date:'|| l_returned_date, 11);
287: hr_utility.set_location(' p_per_in_ler_id:'|| rec.group_per_in_ler_id, 22);
288: end if;
289:
290: BEN_CWB_PERSON_RATES_API.update_person_rate(
291: p_group_per_in_ler_id => rec.group_per_in_ler_id

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

313: --
314: end if;
315:
316: if g_debug then
317: hr_utility.set_location(' Leaving:'|| l_proc, 999);
318: end if;
319: --
320: exception
321: when others then