DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_CONC dependencies on HR_UTILITY

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

121: l_ebo_rec c_ebo%rowtype;
122:
123: Begin
124: --
125: hr_utility.set_location ('Entering '||l_proc,10);
126: --
127: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
128: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
129: dt_fndate.change_ses_date

Line 191: hr_utility.set_location('getting range',10);

187: -- 3) Put each row into the person cache.
188: -- 4) Process the person cache
189: -- 5) Go to number 1 again.
190: --
191: hr_utility.set_location('getting range',10);
192: --
193: Loop
194: --
195: open c_range_thread;

Line 200: hr_utility.set_location('doing range fetch',10);

196: --
197: fetch c_range_thread into l_range_id
198: ,l_start_person_action_id
199: ,l_end_person_action_id;
200: hr_utility.set_location('doing range fetch',10);
201: --
202: if c_range_thread%notfound then
203: --
204: hr_utility.set_location('range not Found',10);

Line 204: hr_utility.set_location('range not Found',10);

200: hr_utility.set_location('doing range fetch',10);
201: --
202: if c_range_thread%notfound then
203: --
204: hr_utility.set_location('range not Found',10);
205: --
206: exit;
207: --
208: end if;

Line 210: hr_utility.set_location('range Found',10);

206: exit;
207: --
208: end if;
209: --
210: hr_utility.set_location('range Found',10);
211: --
212: close c_range_thread;
213: --
214: update ben_batch_ranges ran

Line 228: hr_utility.set_location('person id'||l_person_id,10);

224: loop
225: --
226: fetch c_person_thread into l_person_id,
227: l_person_action_id;
228: hr_utility.set_location('person id'||l_person_id,10);
229: --
230: exit when c_person_thread%notfound;
231: --
232: savepoint last_place;

Line 242: hr_utility.set_location('Before open',10);

238: close c_person;
239: --
240: begin
241: --
242: hr_utility.set_location('Before open',10);
243: --
244: open c_ebo;
245: loop
246: fetch c_ebo into l_ebo_rec;

Line 280: hr_utility.set_location('Super Error exception level',10);

276: exception
277: --
278: when others then
279: --
280: hr_utility.set_location('Super Error exception level',10);
281: hr_utility.set_location(sqlerrm,10);
282: rollback to last_place;
283: benutils.rollback_cache;
284: --

Line 281: hr_utility.set_location(sqlerrm,10);

277: --
278: when others then
279: --
280: hr_utility.set_location('Super Error exception level',10);
281: hr_utility.set_location(sqlerrm,10);
282: rollback to last_place;
283: benutils.rollback_cache;
284: --
285: update ben_person_actions

Line 299: hr_utility.set_location('Error Message '||g_rec.text,10);

295: g_rec.national_identifier := l_per_rec.national_identifier;
296: g_rec.error_message_code := benutils.get_message_name;
297: g_rec.text := fnd_message.get;
298:
299: hr_utility.set_location('Error Message '||g_rec.text,10);
300: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
301: benutils.write(g_rec.text);
302: benutils.write(p_rec => g_rec);
303: --

Line 304: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);

300: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
301: benutils.write(g_rec.text);
302: benutils.write(p_rec => g_rec);
303: --
304: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
305: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
306: if g_persons_errored > g_max_errors_allowed then
307: --
308: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');

Line 305: hr_utility.set_location('Num Errors = '||g_persons_errored,10);

301: benutils.write(g_rec.text);
302: benutils.write(p_rec => g_rec);
303: --
304: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
305: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
306: if g_persons_errored > g_max_errors_allowed then
307: --
308: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
309: benutils.write(p_text => fnd_message.get);

Line 317: hr_utility.set_location('Closing c_person_thread',10);

313: end if;
314: --
315: end;
316: --
317: hr_utility.set_location('Closing c_person_thread',10);
318: --
319: end loop;
320: --
321: close c_person_thread;

Line 327: hr_utility.set_location('Rolling back transaction ',10);

323: -- Commit chunk
324: --
325: if p_validate = 'Y' then
326: --
327: hr_utility.set_location('Rolling back transaction ',10);
328: --
329: rollback;
330: --
331: end if;

Line 347: hr_utility.set_location ('Leaving '||l_proc,70);

343: ,p_num_pers_errored => g_persons_errored);
344: --
345: commit;
346: --
347: hr_utility.set_location ('Leaving '||l_proc,70);
348: --
349: Exception
350: --
351: When others then

Line 353: hr_utility.set_location('Super Error',10);

349: Exception
350: --
351: When others then
352: --
353: hr_utility.set_location('Super Error',10);
354: hr_utility.set_location(sqlerrm,10);
355: hr_utility.set_location('Super Error',10);
356: rollback;
357: benutils.rollback_cache;

Line 354: hr_utility.set_location(sqlerrm,10);

350: --
351: When others then
352: --
353: hr_utility.set_location('Super Error',10);
354: hr_utility.set_location(sqlerrm,10);
355: hr_utility.set_location('Super Error',10);
356: rollback;
357: benutils.rollback_cache;
358: --

Line 355: hr_utility.set_location('Super Error',10);

351: When others then
352: --
353: hr_utility.set_location('Super Error',10);
354: hr_utility.set_location(sqlerrm,10);
355: hr_utility.set_location('Super Error',10);
356: rollback;
357: benutils.rollback_cache;
358: --
359: g_rec.rep_typ_cd := 'FATAL';

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

409: l_retcode number;
410: --
411: Begin
412: --
413: hr_utility.set_location ('Entering '||l_proc,10);
414: --
415: -- get the parameters for a previous run and do a restart
416: --
417: open c_parameters;

Line 449: hr_utility.set_location ('Leaving '||l_proc,70);

445: ,p_legal_entity_id => l_parameters.legal_entity_id
446: ,p_person_selection_rule_id => l_parameters.person_selection_rl
447: ,p_debug_messages => l_parameters.debug_messages_flag);
448: --
449: hr_utility.set_location ('Leaving '||l_proc,70);
450: --
451: end restart;
452: --
453: -- *************************************************************************

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

556: l_commit number;
557: --
558: Begin
559: --
560: hr_utility.set_location ('Entering '||l_proc,10);
561: --
562: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
563: --
564: dt_fndate.change_ses_date

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

580: -- Do not create if a benefit action already exists, in other words
581: -- we are doing a restart.
582: --
583: If p_benefit_action_id is null then
584: hr_utility.set_location('l_effective_date '||l_effective_date,10);
585: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
586: hr_utility.set_location('p_debug_messages '||p_debug_messages,10);
587: hr_utility.set_location('p_validate '||p_validate,10);
588: hr_utility.set_location('p_person_id '||p_person_id,10);

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

581: -- we are doing a restart.
582: --
583: If p_benefit_action_id is null then
584: hr_utility.set_location('l_effective_date '||l_effective_date,10);
585: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
586: hr_utility.set_location('p_debug_messages '||p_debug_messages,10);
587: hr_utility.set_location('p_validate '||p_validate,10);
588: hr_utility.set_location('p_person_id '||p_person_id,10);
589: --

Line 586: hr_utility.set_location('p_debug_messages '||p_debug_messages,10);

582: --
583: If p_benefit_action_id is null then
584: hr_utility.set_location('l_effective_date '||l_effective_date,10);
585: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
586: hr_utility.set_location('p_debug_messages '||p_debug_messages,10);
587: hr_utility.set_location('p_validate '||p_validate,10);
588: hr_utility.set_location('p_person_id '||p_person_id,10);
589: --
590: ben_benefit_actions_api.create_perf_benefit_actions

Line 587: hr_utility.set_location('p_validate '||p_validate,10);

583: If p_benefit_action_id is null then
584: hr_utility.set_location('l_effective_date '||l_effective_date,10);
585: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
586: hr_utility.set_location('p_debug_messages '||p_debug_messages,10);
587: hr_utility.set_location('p_validate '||p_validate,10);
588: hr_utility.set_location('p_person_id '||p_person_id,10);
589: --
590: ben_benefit_actions_api.create_perf_benefit_actions
591: (p_validate_flag => p_validate

Line 588: hr_utility.set_location('p_person_id '||p_person_id,10);

584: hr_utility.set_location('l_effective_date '||l_effective_date,10);
585: hr_utility.set_location('p_business_group_id '||p_business_group_id,10);
586: hr_utility.set_location('p_debug_messages '||p_debug_messages,10);
587: hr_utility.set_location('p_validate '||p_validate,10);
588: hr_utility.set_location('p_person_id '||p_person_id,10);
589: --
590: ben_benefit_actions_api.create_perf_benefit_actions
591: (p_validate_flag => p_validate
592: ,p_benefit_action_id => l_benefit_action_id

Line 713: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);

709: End loop;
710: --
711: close c_person;
712: --
713: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
714: --
715: If l_num_row <> 0 then
716: --
717: Ben_batch_ranges_api.create_batch_ranges

Line 810: hr_utility.set_location ('Leaving '||l_proc,70);

806: ben_batch_utils.check_all_slaves_finished(p_rpt_flag => TRUE);
807: ben_batch_utils.end_process(p_benefit_action_id => l_benefit_action_id
808: ,p_person_selected => l_person_cnt
809: ,p_business_group_id => p_business_group_id);
810: hr_utility.set_location ('Leaving '||l_proc,70);
811: --
812: Exception
813: when l_no_one_to_process then
814: benutils.write(p_text => fnd_message.get);

Line 818: hr_utility.set_location('Super Error',10);

814: benutils.write(p_text => fnd_message.get);
815: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);
816: when others then
817: --
818: hr_utility.set_location('Super Error',10);
819: rollback;
820: benutils.write(p_text => fnd_message.get);
821: benutils.write(p_text => sqlerrm);
822: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);