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

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

296: and ppf.effective_end_date;
297:
298: Begin
299: --
300: hr_utility.set_location ('Entering '||l_proc,10);
301: --
302: fnd_message.set_name('BEN','BEN_91333_CALLING_PROC');
303: fnd_message.set_token('PROC','dt_fndate.change_ses_date');
304: dt_fndate.change_ses_date

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

365: -- 3) Put each row into the person cache.
366: -- 4) Process the person cache
367: -- 5) Go to number 1 again.
368: --
369: hr_utility.set_location('getting range',10);
370: --
371: Loop
372: --
373: open c_range_thread;

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

374: --
375: fetch c_range_thread into l_range_id
376: ,l_start_person_action_id
377: ,l_end_person_action_id;
378: hr_utility.set_location('doing range fetch',10);
379: --
380: if c_range_thread%notfound then
381: --
382: hr_utility.set_location('range not Found',10);

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

378: hr_utility.set_location('doing range fetch',10);
379: --
380: if c_range_thread%notfound then
381: --
382: hr_utility.set_location('range not Found',10);
383: --
384: exit;
385: --
386: end if;

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

384: exit;
385: --
386: end if;
387: --
388: hr_utility.set_location('range Found',10);
389: --
390: close c_range_thread;
391: --
392: update ben_batch_ranges ran

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

402: loop
403: --
404: fetch c_person_thread into l_person_id,
405: l_person_action_id;
406: hr_utility.set_location('person id'||l_person_id,10);
407: --
408: exit when c_person_thread%notfound;
409: --
410: savepoint last_place;

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

437:
438: --
439: begin
440: --
441: hr_utility.set_location('Before open',10);
442: --open c_ler_thread;
443: --
444: /* Bug 15829093: Replaced open-fetch-close with Cursor FOR..Loop for the
445: cursor c_ler_thread*/

Line 447: hr_utility.set_location('fetching record',10);

443: --
444: /* Bug 15829093: Replaced open-fetch-close with Cursor FOR..Loop for the
445: cursor c_ler_thread*/
446: for l_ler_thread in c_ler_thread Loop
447: hr_utility.set_location('fetching record',10);
448: hr_utility.set_location('fetching record '||l_ler_thread.per_in_ler_id,10);
449: hr_utility.set_location('fetching record '||l_ler_thread.typ_cd,10);
450: --
451: -- fetch c_ler_thread into l_ler_thread;

Line 448: hr_utility.set_location('fetching record '||l_ler_thread.per_in_ler_id,10);

444: /* Bug 15829093: Replaced open-fetch-close with Cursor FOR..Loop for the
445: cursor c_ler_thread*/
446: for l_ler_thread in c_ler_thread Loop
447: hr_utility.set_location('fetching record',10);
448: hr_utility.set_location('fetching record '||l_ler_thread.per_in_ler_id,10);
449: hr_utility.set_location('fetching record '||l_ler_thread.typ_cd,10);
450: --
451: -- fetch c_ler_thread into l_ler_thread;
452: --exit when c_ler_thread%notfound;

Line 449: hr_utility.set_location('fetching record '||l_ler_thread.typ_cd,10);

445: cursor c_ler_thread*/
446: for l_ler_thread in c_ler_thread Loop
447: hr_utility.set_location('fetching record',10);
448: hr_utility.set_location('fetching record '||l_ler_thread.per_in_ler_id,10);
449: hr_utility.set_location('fetching record '||l_ler_thread.typ_cd,10);
450: --
451: -- fetch c_ler_thread into l_ler_thread;
452: --exit when c_ler_thread%notfound;
453: fnd_file.put_line(fnd_file.log,'per_in_ler_id '||l_ler_thread.per_in_ler_id);

Line 531: hr_utility.set_location('before rollback',10);

527: /*Bug 9818852: When Back-out Life Events Process is run in Rollback mode, because of the
528: commit statement(after update statement), backed out results of successfully processed employees are committed.
529: When Back-out Life Events Process is run Rollback mode, only ben_person_actions table update should be commited.
530: For a employee for whom the results are successfully backed out, results should be rolled back */
531: hr_utility.set_location('before rollback',10);
532: if p_validate = 'Y' then
533: rollback to last_place;
534: end if;
535: hr_utility.set_location('after rollback',10);

Line 535: hr_utility.set_location('after rollback',10);

531: hr_utility.set_location('before rollback',10);
532: if p_validate = 'Y' then
533: rollback to last_place;
534: end if;
535: hr_utility.set_location('after rollback',10);
536:
537: g_rec.ler_id := l_ler_thread.ler_id;
538: hr_utility.set_location('Assign ler_id',10);
539: g_rec.rep_typ_cd := 'LFBO';

Line 538: hr_utility.set_location('Assign ler_id',10);

534: end if;
535: hr_utility.set_location('after rollback',10);
536:
537: g_rec.ler_id := l_ler_thread.ler_id;
538: hr_utility.set_location('Assign ler_id',10);
539: g_rec.rep_typ_cd := 'LFBO';
540: g_rec.person_id := l_person_id;
541: --
542: -- This is to assign the global variable which contains information about

Line 546: hr_utility.set_location('Assign global values 1',10);

542: -- This is to assign the global variable which contains information about
543: -- the closed or in process life events with or without election,
544: -- that were backed out.
545: --
546: hr_utility.set_location('Assign global values 1',10);
547: g_rec.text := l_ler_thread.per_in_ler_stat_cd ||
548: ben_back_out_life_event.g_enrt_made_flag;
549: --
550: -- This is to assign the per_in_ler_id in the record to extract the

Line 552: hr_utility.set_location('Assign global values 2',10);

548: ben_back_out_life_event.g_enrt_made_flag;
549: --
550: -- This is to assign the per_in_ler_id in the record to extract the
551: -- the electable choices later.
552: hr_utility.set_location('Assign global values 2',10);
553: g_rec.temporal_ler_id := l_ler_thread.per_in_ler_id;
554:
555: benutils.write(p_rec => g_rec);
556: --

Line 563: hr_utility.set_location('before update',10);

559: --close c_ler_thread;
560: --
561: -- If we get here it was successful.
562: --
563: hr_utility.set_location('before update',10);
564: update ben_person_actions
565: set action_status_cd = 'P'
566: where person_id = l_person_id
567: and benefit_action_id = p_benefit_action_id;

Line 568: hr_utility.set_location('after update',10);

564: update ben_person_actions
565: set action_status_cd = 'P'
566: where person_id = l_person_id
567: and benefit_action_id = p_benefit_action_id;
568: hr_utility.set_location('after update',10);
569: --
570: benutils.write(l_per_rec.full_name||' processed successfully');
571: g_persons_processed := g_persons_processed + 1;
572: --

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

573: exception
574: --
575: when others then
576: --
577: hr_utility.set_location('Super Error exception level',10);
578: hr_utility.set_location(sqlerrm,10);
579:
580: if c_latest_ler%isopen then
581:

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

574: --
575: when others then
576: --
577: hr_utility.set_location('Super Error exception level',10);
578: hr_utility.set_location(sqlerrm,10);
579:
580: if c_latest_ler%isopen then
581:
582: close c_latest_ler;

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

614: g_rec.text := fnd_message.get;
615:
616: -- Bug 2376330 end
617: --
618: hr_utility.set_location('Error Message '||g_rec.text,10);
619: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
620: benutils.write(g_rec.text);
621: benutils.write(p_rec => g_rec);
622: --

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

619: benutils.write(l_per_rec.full_name||' processed unsuccessfully');
620: benutils.write(g_rec.text);
621: benutils.write(p_rec => g_rec);
622: --
623: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
624: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
625: if g_persons_errored > g_max_errors_allowed then
626: --
627: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');

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

620: benutils.write(g_rec.text);
621: benutils.write(p_rec => g_rec);
622: --
623: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
624: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
625: if g_persons_errored > g_max_errors_allowed then
626: --
627: fnd_message.set_name('BEN','BEN_92431_BENBOCON_ERROR_LIMIT');
628: benutils.write(p_text => fnd_message.get);

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

632: end if;
633: --
634: end;
635: --
636: hr_utility.set_location('Closing c_person_thread',10);
637: --
638: end loop;
639: --
640: close c_person_thread;

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

642: -- Commit chunk
643: --
644: if p_validate = 'Y' then
645: --
646: hr_utility.set_location('Rolling back transaction ',10);
647: --
648: rollback;
649: --
650: end if;

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

662: ,p_num_pers_errored => g_persons_errored);
663: --
664: commit;
665: --
666: hr_utility.set_location ('Leaving '||l_proc,70);
667: --
668: Exception
669: --
670: When others then

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

668: Exception
669: --
670: When others then
671: --
672: hr_utility.set_location('Super Error',10);
673: hr_utility.set_location(sqlerrm,10);
674: hr_utility.set_location('Super Error',10);
675: rollback;
676: benutils.rollback_cache;

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

669: --
670: When others then
671: --
672: hr_utility.set_location('Super Error',10);
673: hr_utility.set_location(sqlerrm,10);
674: hr_utility.set_location('Super Error',10);
675: rollback;
676: benutils.rollback_cache;
677: --

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

670: When others then
671: --
672: hr_utility.set_location('Super Error',10);
673: hr_utility.set_location(sqlerrm,10);
674: hr_utility.set_location('Super Error',10);
675: rollback;
676: benutils.rollback_cache;
677: --
678: g_rec.ler_id := nvl(p_life_event_id,l_ler_thread.ler_id);

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

732: l_retcode number;
733: --
734: Begin
735: --
736: hr_utility.set_location ('Entering '||l_proc,10);
737: --
738: -- get the parameters for a previous run and do a restart
739: --
740: open c_parameters;

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

769: ,p_legal_entity_id => l_parameters.legal_entity_id
770: ,p_person_selection_rule_id => l_parameters.person_selection_rl
771: ,p_debug_messages => l_parameters.debug_messages_flag);
772: --
773: hr_utility.set_location ('Leaving '||l_proc,70);
774: --
775: end restart;
776: --
777: -- *************************************************************************

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

943: l_person_ok varchar2(1) := 'Y';
944: l_err_message varchar2(2000);
945: Begin
946: --
947: hr_utility.set_location ('Entering '||l_proc,10);
948: --
949: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
950: l_from_ocrd_date:=trunc(fnd_date.canonical_to_date(p_from_ocrd_date));
951: l_to_ocrd_date:=trunc(fnd_date.canonical_to_date(p_to_ocrd_date));

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

1107: End loop;
1108: --
1109: close c_person;
1110: --
1111: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
1112: --
1113: If l_num_row <> 0 then
1114: --
1115: Ben_batch_ranges_api.create_batch_ranges

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

1244: description => null,
1245: sub_request => false,
1246: argument1 => fnd_global.conc_request_id);
1247: --
1248: hr_utility.set_location ('Leaving '||l_proc,70);
1249: --
1250: hr_utility.trace_off;
1251: Exception
1252: --Bug 2253040

Line 1250: hr_utility.trace_off;

1246: argument1 => fnd_global.conc_request_id);
1247: --
1248: hr_utility.set_location ('Leaving '||l_proc,70);
1249: --
1250: hr_utility.trace_off;
1251: Exception
1252: --Bug 2253040
1253: when l_no_one_to_process then
1254: benutils.write(p_text => fnd_message.get);

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

1256: --Bug 2253040
1257:
1258: when others then
1259: --
1260: hr_utility.set_location('Super Error',10);
1261: rollback;
1262: benutils.write(p_text => fnd_message.get);
1263: benutils.write(p_text => sqlerrm);
1264: benutils.write_table_and_file(p_table => TRUE, p_file => TRUE);