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

Line 33: g_debug boolean := hr_utility.debug_enabled;

29: g_persons_passed number(9) := 0;
30: g_persons_errored number(9) := 0;
31: g_max_errors_allowed number(9) := 200;
32: g_rec ben_type.g_report_rec;
33: g_debug boolean := hr_utility.debug_enabled;
34: --
35: --
36: procedure check_business_rules
37: (p_business_group_id in number,

Line 52: hr_utility.set_location ('Entering '||l_package,10);

48: --
49: begin
50: --
51: if g_debug then
52: hr_utility.set_location ('Entering '||l_package,10);
53: end if;
54: --
55: -- This procedure checks validity of parameters that have been passed to the
56: -- BENMNGLE process.

Line 108: hr_utility.set_location ('Leaving '||l_package,10);

104: --
105: End If;
106: --
107: if g_debug then
108: hr_utility.set_location ('Leaving '||l_package,10);
109: end if;
110: --
111: exception
112: --

Line 115: hr_utility.set_location('Error || sqlerrm',10);

111: exception
112: --
113: when others then
114: --
115: hr_utility.set_location('Error || sqlerrm',10);
116: ben_batch_utils.write('Error is : '||benutils.get_message_name||' - '||fnd_message.get);
117: fnd_message.raise_error;
118: --
119: end check_business_rules;

Line 137: hr_utility.set_location ('Entering '||l_package,10);

133: begin
134: --
135: if g_debug then
136: l_package := g_package||'.print_parameters';
137: hr_utility.set_location ('Entering '||l_package,10);
138: end if;
139: --
140: open c_parameter;
141: --

Line 285: hr_utility.set_location ('Leaving '||l_package,10);

281: l_parm.debug_messages_flag);
282:
283: --
284: if g_debug then
285: hr_utility.set_location ('Leaving '||l_package,10);
286: end if;
287: --
288: end print_parameters;
289: --

Line 397: g_debug := hr_utility.debug_enabled;

393: l_commit number;
394: --
395: Begin
396: --
397: g_debug := hr_utility.debug_enabled;
398: if g_debug then
399: hr_utility.set_location ('Entering '||l_proc,10);
400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);
401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);

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

395: Begin
396: --
397: g_debug := hr_utility.debug_enabled;
398: if g_debug then
399: hr_utility.set_location ('Entering '||l_proc,10);
400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);
401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);
402: hr_utility.set_location ('p_thread_id is :'||p_thread_id,10);
403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);

Line 400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);

396: --
397: g_debug := hr_utility.debug_enabled;
398: if g_debug then
399: hr_utility.set_location ('Entering '||l_proc,10);
400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);
401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);
402: hr_utility.set_location ('p_thread_id is :'||p_thread_id,10);
403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);
404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);

Line 401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);

397: g_debug := hr_utility.debug_enabled;
398: if g_debug then
399: hr_utility.set_location ('Entering '||l_proc,10);
400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);
401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);
402: hr_utility.set_location ('p_thread_id is :'||p_thread_id,10);
403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);
404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);
405: end if;

Line 402: hr_utility.set_location ('p_thread_id is :'||p_thread_id,10);

398: if g_debug then
399: hr_utility.set_location ('Entering '||l_proc,10);
400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);
401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);
402: hr_utility.set_location ('p_thread_id is :'||p_thread_id,10);
403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);
404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);
405: end if;
406: --

Line 403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);

399: hr_utility.set_location ('Entering '||l_proc,10);
400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);
401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);
402: hr_utility.set_location ('p_thread_id is :'||p_thread_id,10);
403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);
404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);
405: end if;
406: --
407: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));

Line 404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);

400: hr_utility.set_location ('p_benefit_action_id is :'||p_benefit_action_id,10);
401: hr_utility.set_location ('p_effective_date is :'||p_effective_date,10);
402: hr_utility.set_location ('p_thread_id is :'||p_thread_id,10);
403: hr_utility.set_location ('p_pgm_id is :'||p_pgm_id,10);
404: hr_utility.set_location ('p_pl_id is :'||p_pl_id,10);
405: end if;
406: --
407: l_effective_date:=trunc(fnd_date.canonical_to_date(p_effective_date));
408: l_lf_evt_ocrd_dt:=trunc(fnd_date.canonical_to_date(p_lf_evt_ocrd_dt));

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

467: -- 3) Put each row into the person cache.
468: -- 4) Process the person cache
469: -- 5) Go to number 1 again.
470: --
471: hr_utility.set_location('getting range',10);
472: --
473: Loop
474: --
475: open c_range_thread;

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

476: --
477: fetch c_range_thread into l_range_id
478: ,l_start_person_action_id
479: ,l_end_person_action_id;
480: hr_utility.set_location('doing range fetch',10);
481: --
482: if c_range_thread%notfound then
483: --
484: hr_utility.set_location('range not Found',10);

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

480: hr_utility.set_location('doing range fetch',10);
481: --
482: if c_range_thread%notfound then
483: --
484: hr_utility.set_location('range not Found',10);
485: --
486: exit;
487: --
488: end if;

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

486: exit;
487: --
488: end if;
489: --
490: hr_utility.set_location('range Found',10);
491: --
492: close c_range_thread;
493: --
494: update ben_batch_ranges ran

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

504: loop
505: --
506: fetch c_person_thread into l_person_id,
507: l_person_action_id;
508: hr_utility.set_location('person id'||l_person_id,10);
509: --
510: exit when c_person_thread%notfound;
511: --
512: savepoint last_place;

Line 522: hr_utility.set_location('per_in_ler_id '||l_pel.per_in_ler_id,10);

518: loop
519: fetch c_pel into l_pel;
520: exit when c_pel%NOTFOUND;
521: --
522: hr_utility.set_location('per_in_ler_id '||l_pel.per_in_ler_id,10);
523: hr_utility.set_location('typ_cd '||l_pel.typ_cd,10);
524: if (p_no_of_days is not null) then
525: hr_utility.set_location('In IF part...',10);
526: hr_utility.set_location('Adding no of days to all dates...',10);

Line 523: hr_utility.set_location('typ_cd '||l_pel.typ_cd,10);

519: fetch c_pel into l_pel;
520: exit when c_pel%NOTFOUND;
521: --
522: hr_utility.set_location('per_in_ler_id '||l_pel.per_in_ler_id,10);
523: hr_utility.set_location('typ_cd '||l_pel.typ_cd,10);
524: if (p_no_of_days is not null) then
525: hr_utility.set_location('In IF part...',10);
526: hr_utility.set_location('Adding no of days to all dates...',10);
527: l_new_enrt_perd_end_dt := l_pel.enrt_perd_end_dt + p_no_of_days;

Line 525: hr_utility.set_location('In IF part...',10);

521: --
522: hr_utility.set_location('per_in_ler_id '||l_pel.per_in_ler_id,10);
523: hr_utility.set_location('typ_cd '||l_pel.typ_cd,10);
524: if (p_no_of_days is not null) then
525: hr_utility.set_location('In IF part...',10);
526: hr_utility.set_location('Adding no of days to all dates...',10);
527: l_new_enrt_perd_end_dt := l_pel.enrt_perd_end_dt + p_no_of_days;
528: l_new_procg_end_dt := l_pel.procg_end_dt + p_no_of_days;
529: l_new_dflt_enrt_dt := l_pel.dflt_enrt_dt + p_no_of_days;

Line 526: hr_utility.set_location('Adding no of days to all dates...',10);

522: hr_utility.set_location('per_in_ler_id '||l_pel.per_in_ler_id,10);
523: hr_utility.set_location('typ_cd '||l_pel.typ_cd,10);
524: if (p_no_of_days is not null) then
525: hr_utility.set_location('In IF part...',10);
526: hr_utility.set_location('Adding no of days to all dates...',10);
527: l_new_enrt_perd_end_dt := l_pel.enrt_perd_end_dt + p_no_of_days;
528: l_new_procg_end_dt := l_pel.procg_end_dt + p_no_of_days;
529: l_new_dflt_enrt_dt := l_pel.dflt_enrt_dt + p_no_of_days;
530: else

Line 531: hr_utility.set_location('In ELSE part...',10);

527: l_new_enrt_perd_end_dt := l_pel.enrt_perd_end_dt + p_no_of_days;
528: l_new_procg_end_dt := l_pel.procg_end_dt + p_no_of_days;
529: l_new_dflt_enrt_dt := l_pel.dflt_enrt_dt + p_no_of_days;
530: else
531: hr_utility.set_location('In ELSE part...',10);
532: l_new_enrt_perd_end_dt := l_pel.enrt_perd_end_dt;
533: l_new_procg_end_dt := l_pel.procg_end_dt;
534: l_new_dflt_enrt_dt := l_pel.dflt_enrt_dt;
535: --

Line 537: hr_utility.set_location('Replacing enrt end date...',10);

533: l_new_procg_end_dt := l_pel.procg_end_dt;
534: l_new_dflt_enrt_dt := l_pel.dflt_enrt_dt;
535: --
536: if p_new_enrt_perd_end_dt is not null then
537: hr_utility.set_location('Replacing enrt end date...',10);
538: l_new_enrt_perd_end_dt := trunc(fnd_date.canonical_to_date(p_new_enrt_perd_end_dt));
539: end if;
540: if p_new_procg_end_dt is not null then
541: hr_utility.set_location('Replacing procg end date...',10);

Line 541: hr_utility.set_location('Replacing procg end date...',10);

537: hr_utility.set_location('Replacing enrt end date...',10);
538: l_new_enrt_perd_end_dt := trunc(fnd_date.canonical_to_date(p_new_enrt_perd_end_dt));
539: end if;
540: if p_new_procg_end_dt is not null then
541: hr_utility.set_location('Replacing procg end date...',10);
542: l_new_procg_end_dt := trunc(fnd_date.canonical_to_date(p_new_procg_end_dt));
543: end if;
544: if p_new_dflt_enrt_dt is not null then
545: hr_utility.set_location('Replacing dflt enrt date...',10);

Line 545: hr_utility.set_location('Replacing dflt enrt date...',10);

541: hr_utility.set_location('Replacing procg end date...',10);
542: l_new_procg_end_dt := trunc(fnd_date.canonical_to_date(p_new_procg_end_dt));
543: end if;
544: if p_new_dflt_enrt_dt is not null then
545: hr_utility.set_location('Replacing dflt enrt date...',10);
546: l_new_dflt_enrt_dt := trunc(fnd_date.canonical_to_date(p_new_dflt_enrt_dt));
547: end if;
548: --
549: end if;

Line 552: hr_utility.set_location('New ...enrt_perd_end_dt'||l_new_enrt_perd_end_dt,10);

548: --
549: end if;
550: --
551: if g_debug then
552: hr_utility.set_location('New ...enrt_perd_end_dt'||l_new_enrt_perd_end_dt,10);
553: hr_utility.set_location('New ...procg_end_dt'||l_new_procg_end_dt,10);
554: hr_utility.set_location('New ...dflt_enrt_dt'||l_new_dflt_enrt_dt,10);
555: end if;
556: /* Now updating the POPL record */

Line 553: hr_utility.set_location('New ...procg_end_dt'||l_new_procg_end_dt,10);

549: end if;
550: --
551: if g_debug then
552: hr_utility.set_location('New ...enrt_perd_end_dt'||l_new_enrt_perd_end_dt,10);
553: hr_utility.set_location('New ...procg_end_dt'||l_new_procg_end_dt,10);
554: hr_utility.set_location('New ...dflt_enrt_dt'||l_new_dflt_enrt_dt,10);
555: end if;
556: /* Now updating the POPL record */
557: hr_utility.set_location('Updating POPL record : '||l_pel.pil_elctbl_chc_popl_id,10);

Line 554: hr_utility.set_location('New ...dflt_enrt_dt'||l_new_dflt_enrt_dt,10);

550: --
551: if g_debug then
552: hr_utility.set_location('New ...enrt_perd_end_dt'||l_new_enrt_perd_end_dt,10);
553: hr_utility.set_location('New ...procg_end_dt'||l_new_procg_end_dt,10);
554: hr_utility.set_location('New ...dflt_enrt_dt'||l_new_dflt_enrt_dt,10);
555: end if;
556: /* Now updating the POPL record */
557: hr_utility.set_location('Updating POPL record : '||l_pel.pil_elctbl_chc_popl_id,10);
558: BEN_pil_elctbl_chc_popl_API.update_pil_elctbl_chc_popl

Line 557: hr_utility.set_location('Updating POPL record : '||l_pel.pil_elctbl_chc_popl_id,10);

553: hr_utility.set_location('New ...procg_end_dt'||l_new_procg_end_dt,10);
554: hr_utility.set_location('New ...dflt_enrt_dt'||l_new_dflt_enrt_dt,10);
555: end if;
556: /* Now updating the POPL record */
557: hr_utility.set_location('Updating POPL record : '||l_pel.pil_elctbl_chc_popl_id,10);
558: BEN_pil_elctbl_chc_popl_API.update_pil_elctbl_chc_popl
559: (p_validate => FALSE
560: ,p_PIL_ELCTBL_CHC_POPL_ID => l_pel.pil_elctbl_chc_popl_id
561: ,p_DFLT_ENRT_DT => l_new_dflt_enrt_dt

Line 567: hr_utility.set_location('Updation done'||l_pel.pil_elctbl_chc_popl_id,10);

563: ,p_PROCG_END_DT => l_new_procg_end_dt
564: ,p_OBJECT_VERSION_NUMBER => l_pel.object_version_number
565: ,p_effective_date => l_effective_date
566: );
567: hr_utility.set_location('Updation done'||l_pel.pil_elctbl_chc_popl_id,10);
568: --
569: if p_audit_log_flag = 'Y' then
570: ben_batch_utils.write('| '||rpad(l_pel.full_name,30)||'| '||'SUCCESS | '||
571: rpad(l_pel.pil_elctbl_chc_popl_id,10)||'| '||

Line 585: hr_utility.set_location('No POPL record found for '||l_pel.full_name ||' for the given set of conditions.',10);

581: if l_popl_cnt = 0 then
582: if p_audit_log_flag = 'Y' then
583: ben_batch_utils.write('| '||rpad(l_pel.full_name,30)||'| '||'UNSUCCESSFUL | No record found for the given set of conditions.');
584: end if;
585: hr_utility.set_location('No POPL record found for '||l_pel.full_name ||' for the given set of conditions.',10);
586: end if;
587: l_popl_cnt := 0;
588: --
589: -- If we get here it was successful.

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

598: exception
599: --
600: when others then
601: --
602: hr_utility.set_location('Super Error exception level',10);
603: hr_utility.set_location(sqlerrm,10);
604: --
605: if c_pel%isopen then
606:

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

599: --
600: when others then
601: --
602: hr_utility.set_location('Super Error exception level',10);
603: hr_utility.set_location(sqlerrm,10);
604: --
605: if c_pel%isopen then
606:
607: close c_pel;

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

619: commit;
620: --
621: g_persons_errored := g_persons_errored + 1;
622: --
623: hr_utility.set_location('Error Message '||g_rec.text,10);
624: if p_audit_log_flag = 'Y' then
625: -- changed bug: 5611643
626: /*
627: ben_batch_utils.write('| '||rpad(l_pel.full_name,18)||'| '||'UNSUCCESSFUL | Error is - '||

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

657: END;
658:
659: end if;
660: --
661: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
662: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
663: -- if g_persons_errored > g_max_errors_allowed then
664: if g_persons_errored >= g_max_errors_allowed then
665: --

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

658:
659: end if;
660: --
661: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
662: hr_utility.set_location('Num Errors = '||g_persons_errored,10);
663: -- if g_persons_errored > g_max_errors_allowed then
664: if g_persons_errored >= g_max_errors_allowed then
665: --
666: fnd_message.set_name('BEN','BEN_94642_BENMNOEW_ERROR_LIMIT');

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

673: end;
674: --
675: end loop;
676: --
677: hr_utility.set_location('Closing c_person_thread',10);
678: --
679: close c_person_thread;
680: --
681: -- Commit chunk

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

681: -- Commit chunk
682: --
683: if p_validate = 'Y' then
684: --
685: hr_utility.set_location('Rolling back transaction ',10);
686: --
687: rollback;
688: --
689: end if;

Line 691: hr_utility.set_location('Commiting transaction ',10);

687: rollback;
688: --
689: end if;
690: --
691: hr_utility.set_location('Commiting transaction ',10);
692: --
693: commit;
694: --
695: end loop;

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

701: ,p_num_pers_errored => g_persons_errored);
702: --
703: commit;
704: --
705: hr_utility.set_location ('Leaving '||l_proc,70);
706: --
707: Exception
708: --
709: When others then

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

707: Exception
708: --
709: When others then
710: --
711: hr_utility.set_location('Super Error',10);
712: hr_utility.set_location(sqlerrm,10);
713: hr_utility.set_location('Super Error',10);
714: rollback;
715: benutils.rollback_cache;

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

708: --
709: When others then
710: --
711: hr_utility.set_location('Super Error',10);
712: hr_utility.set_location(sqlerrm,10);
713: hr_utility.set_location('Super Error',10);
714: rollback;
715: benutils.rollback_cache;
716: --

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

709: When others then
710: --
711: hr_utility.set_location('Super Error',10);
712: hr_utility.set_location(sqlerrm,10);
713: hr_utility.set_location('Super Error',10);
714: rollback;
715: benutils.rollback_cache;
716: --
717: g_rec.ler_id := p_ler_id;

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

779: l_retcode number;
780: --
781: Begin
782: --
783: hr_utility.set_location ('Entering '||l_proc,10);
784: --
785: -- get the parameters for a previous run and do a restart
786: --
787: open c_parameters;

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

817: ,p_person_selection_rule_id => l_parameters.person_selection_rl
818: ,p_debug_messages => l_parameters.debug_messages_flag);
819: */
820: --
821: hr_utility.set_location ('Leaving '||l_proc,70);
822: --
823: end restart;
824: --
825: -- *************************************************************************

Line 993: g_debug := hr_utility.debug_enabled;

989: l_person_ok varchar2(1) := 'Y';
990: l_err_message varchar2(2000);
991: Begin
992: --
993: g_debug := hr_utility.debug_enabled;
994: if g_debug then
995: hr_utility.set_location ('Entering '||l_proc,10);
996: hr_utility.set_location ('p_validate : '||p_validate,5);
997: end if;

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

991: Begin
992: --
993: g_debug := hr_utility.debug_enabled;
994: if g_debug then
995: hr_utility.set_location ('Entering '||l_proc,10);
996: hr_utility.set_location ('p_validate : '||p_validate,5);
997: end if;
998: --
999: -- Check that business rules that apply to this conc request are being adhered to.

Line 996: hr_utility.set_location ('p_validate : '||p_validate,5);

992: --
993: g_debug := hr_utility.debug_enabled;
994: if g_debug then
995: hr_utility.set_location ('Entering '||l_proc,10);
996: hr_utility.set_location ('p_validate : '||p_validate,5);
997: end if;
998: --
999: -- Check that business rules that apply to this conc request are being adhered to.
1000: --

Line 1034: hr_utility.set_location (l_proc||' Done get pm ',30);

1030: ,p_threads => l_threads
1031: ,p_chunk_size => l_chunk_size
1032: ,p_max_errors => g_max_errors_allowed);
1033: if g_debug then
1034: hr_utility.set_location (l_proc||' Done get pm ',30);
1035: hr_utility.set_location('Num Threads = '||l_threads,10);
1036: hr_utility.set_location('Chunk Size = '||l_chunk_size,10);
1037: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1038: end if;

Line 1035: hr_utility.set_location('Num Threads = '||l_threads,10);

1031: ,p_chunk_size => l_chunk_size
1032: ,p_max_errors => g_max_errors_allowed);
1033: if g_debug then
1034: hr_utility.set_location (l_proc||' Done get pm ',30);
1035: hr_utility.set_location('Num Threads = '||l_threads,10);
1036: hr_utility.set_location('Chunk Size = '||l_chunk_size,10);
1037: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1038: end if;
1039: --

Line 1036: hr_utility.set_location('Chunk Size = '||l_chunk_size,10);

1032: ,p_max_errors => g_max_errors_allowed);
1033: if g_debug then
1034: hr_utility.set_location (l_proc||' Done get pm ',30);
1035: hr_utility.set_location('Num Threads = '||l_threads,10);
1036: hr_utility.set_location('Chunk Size = '||l_chunk_size,10);
1037: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1038: end if;
1039: --
1040: --

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

1033: if g_debug then
1034: hr_utility.set_location (l_proc||' Done get pm ',30);
1035: hr_utility.set_location('Num Threads = '||l_threads,10);
1036: hr_utility.set_location('Chunk Size = '||l_chunk_size,10);
1037: hr_utility.set_location('Max Errors = '||g_max_errors_allowed,10);
1038: end if;
1039: --
1040: --
1041: -- Create benefit actions parameters in the benefit action table.

Line 1048: hr_utility.set_location (l_proc||' Create BFT ',30);

1044: --
1045: if p_benefit_action_id is null then
1046: --
1047: if g_debug then
1048: hr_utility.set_location (l_proc||' Create BFT ',30);
1049: end if;
1050: --
1051: ben_benefit_actions_api.create_benefit_actions
1052: (p_validate => false

Line 1091: hr_utility.set_location (' l_benefit_action_id : '||l_benefit_action_id,20);

1087: --
1088: benutils.g_benefit_action_id := l_benefit_action_id;
1089: --
1090: if g_debug then
1091: hr_utility.set_location (' l_benefit_action_id : '||l_benefit_action_id,20);
1092: hr_utility.set_location (l_proc||' Dn Create BFT ',20);
1093: end if;
1094: --
1095: -- Delete/clear ranges from ben_batch_ranges table

Line 1092: hr_utility.set_location (l_proc||' Dn Create BFT ',20);

1088: benutils.g_benefit_action_id := l_benefit_action_id;
1089: --
1090: if g_debug then
1091: hr_utility.set_location (' l_benefit_action_id : '||l_benefit_action_id,20);
1092: hr_utility.set_location (l_proc||' Dn Create BFT ',20);
1093: end if;
1094: --
1095: -- Delete/clear ranges from ben_batch_ranges table
1096: --

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

1183: End loop;
1184: --
1185: close c_person;
1186: --
1187: hr_utility.set_location('l_num_row='||to_char(l_num_row),18);
1188: --
1189: If l_num_row <> 0 then
1190: --
1191: Ben_batch_ranges_api.create_batch_ranges

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

1285: --
1286: -- need to write summary contents here
1287: --
1288: --
1289: hr_utility.set_location ('Leaving '||l_proc,70);
1290: --
1291: Exception
1292: --
1293: when l_no_one_to_process then

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

1294: ben_batch_utils.write(p_text => fnd_message.get);
1295: --
1296: when others then
1297: --
1298: hr_utility.set_location('Super Error',10);
1299: rollback;
1300: ben_batch_utils.write(p_text => fnd_message.get);
1301: ben_batch_utils.write(p_text => sqlerrm);
1302: --