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

Line 455: hr_utility.set_location('Entering:'||l_proc, 5);

451:
452: -- Bug 9888746
453: begin
454: --
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: --Bug 14740884
458: open c_prev_pil(p_per_in_ler_id);
459: fetch c_prev_pil into l_prev_pil_id;

Line 467: hr_utility.set_location('l_old_prtt_enrt_rslt_id '||l_old_prtt_enrt_rslt_id, 5);

463:
464: -- Bug 9888746
465: l_old_prtt_enrt_rslt_id := p_old_prtt_enrt_rslt_id;
466:
467: hr_utility.set_location('l_old_prtt_enrt_rslt_id '||l_old_prtt_enrt_rslt_id, 5);
468:
469: if l_old_prtt_enrt_rslt_id is null then
470:
471: open c_check_old_pen;

Line 477: hr_utility.set_location('After c_check_old_pen l_old_prtt_enrt_rslt_id '||l_old_prtt_enrt_rslt_id, 12);

473: close c_check_old_pen;
474:
475: end if;
476:
477: hr_utility.set_location('After c_check_old_pen l_old_prtt_enrt_rslt_id '||l_old_prtt_enrt_rslt_id, 12);
478:
479: -- Bug 9888746
480:
481: -- If participant is returning to his prior coverage that is

Line 490: hr_utility.set_location('Restore existing cvg', 10);

486: -- inheritance logic should still apply).
487: --
488: if p_return_to_exist_cvg_flag = 'Y' and
489: p_process_dpnt then
490: hr_utility.set_location('Restore existing cvg', 10);
491:
492: FOR dpnt in exist_dpnt_c LOOP
493: --
494: if dpnt.elig_per_elctbl_chc_id = p_new_elig_per_elctbl_chc_id then

Line 565: hr_utility.set_location('No inheritance possible:' || l_proc, 15);

561: p_old_pl_typ_id <> p_new_pl_typ_id then
562: --
563: -- no inheritance
564: --
565: hr_utility.set_location('No inheritance possible:' || l_proc, 15);
566: --
567: l_inherit := FALSE;
568: --
569: else

Line 583: hr_utility.set_location('grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );

579: --
580: if total_rqmt_c%notfound then
581: Exit ;
582: End if ;
583: hr_utility.set_location('grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
584: hr_utility.set_location('l_ttl_max_num '|| l_ttl_max_num, 99 );
585: --
586: --
587: l_ttl_rqmt_exist := TRUE;

Line 584: hr_utility.set_location('l_ttl_max_num '|| l_ttl_max_num, 99 );

580: if total_rqmt_c%notfound then
581: Exit ;
582: End if ;
583: hr_utility.set_location('grp_rlshp_cd ' || l_grp_rlshp_cd, 99 );
584: hr_utility.set_location('l_ttl_max_num '|| l_ttl_max_num, 99 );
585: --
586: --
587: l_ttl_rqmt_exist := TRUE;
588: --

Line 592: hr_utility.set_location(' total eligible ' || l_num_cov_dpnt_elig_new, 99 );

588: --
589: open c_tot_elig_dpnt (l_dsgn_rqmt_id,l_grp_rlshp_cd) ;
590: fetch c_tot_elig_dpnt into l_num_cov_dpnt_elig_new ;
591: close c_tot_elig_dpnt ;
592: hr_utility.set_location(' total eligible ' || l_num_cov_dpnt_elig_new, 99 );
593:
594: if l_ttl_no_max_flag = 'N' and
595: l_num_cov_dpnt_elig_new > l_ttl_max_num then
596: --

Line 597: hr_utility.set_location('No inheritance, total max exceeded : ',99 );

593:
594: if l_ttl_no_max_flag = 'N' and
595: l_num_cov_dpnt_elig_new > l_ttl_max_num then
596: --
597: hr_utility.set_location('No inheritance, total max exceeded : ',99 );
598: --
599: -- no inheritance
600: --
601: l_inherit := FALSE;

Line 604: hr_utility.set_location(' inherit false ', 99 );

600: --
601: l_inherit := FALSE;
602: exit ;
603: --
604: hr_utility.set_location(' inherit false ', 99 );
605: end if;
606: --
607: end loop; -- if a total requirement is found.
608: --

Line 615: hr_utility.set_location('Get cvg start dt'||l_proc, 26);

611: end if;
612: --
613: if l_inherit then
614:
615: hr_utility.set_location('Get cvg start dt'||l_proc, 26);
616: --
617: -- Calculate Dependents Coverage Start Date
618: -- dbms_output.put_line('Calculating cvg strt dt');
619: --

Line 648: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);

644: l_cvg_strt_dt := p_enrt_cvg_strt_dt;
645: --
646: end if;
647: --
648: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);
649:
650: -- Loop thru dependents previously covered by the result:
651: --
652: hr_utility.set_location('Loop thru old dependents:'||l_proc, 30);

Line 652: hr_utility.set_location('Loop thru old dependents:'||l_proc, 30);

648: hr_utility.set_location('Cvg start dt ='||to_char(l_cvg_strt_dt), 25);
649:
650: -- Loop thru dependents previously covered by the result:
651: --
652: hr_utility.set_location('Loop thru old dependents:'||l_proc, 30);
653: -- dbms_output.put_line('Start loop for old dpnts');
654: --
655: FOR copy_dpnt_rec in copy_dpnt_c LOOP
656: --

Line 657: hr_utility.set_location('Inherit dependent, rlshp max OK:'||l_proc, 45);

653: -- dbms_output.put_line('Start loop for old dpnts');
654: --
655: FOR copy_dpnt_rec in copy_dpnt_c LOOP
656: --
657: hr_utility.set_location('Inherit dependent, rlshp max OK:'||l_proc, 45);
658: --
659: hook_dpnt
660: (p_validate => FALSE
661: ,p_elig_dpnt_id => copy_dpnt_rec.new_dpnt

Line 685: hr_utility.set_location('Plans the same, copy bnfs', 55);

681: -- no plan change:
682: --
683: If p_old_pl_id = p_new_pl_id then
684: --
685: hr_utility.set_location('Plans the same, copy bnfs', 55);
686: --
687: /* Bug: 3812994: If the new Option is Waive (or Plan is waived..),
688: then we do not copy the beneficiaries to the new result.
689: */

Line 693: hr_utility.set_location('Waive Opt/Plan. Need not carry bnf ', 60);

689: */
690: OPEN c_waive_pl_opt;
691: FETCH c_waive_pl_opt INTO l_waive_pl_opt;
692: IF c_waive_pl_opt%FOUND THEN
693: hr_utility.set_location('Waive Opt/Plan. Need not carry bnf ', 60);
694: hr_utility.set_location('Exiting'||l_proc, 99);
695: return;
696: END IF;
697: -- End 3812994 changes.

Line 694: hr_utility.set_location('Exiting'||l_proc, 99);

690: OPEN c_waive_pl_opt;
691: FETCH c_waive_pl_opt INTO l_waive_pl_opt;
692: IF c_waive_pl_opt%FOUND THEN
693: hr_utility.set_location('Waive Opt/Plan. Need not carry bnf ', 60);
694: hr_utility.set_location('Exiting'||l_proc, 99);
695: return;
696: END IF;
697: -- End 3812994 changes.
698: --

Line 764: hr_utility.set_location('Exiting'||l_proc, 99);

760: end if; -- if p_process_bnf
761: --
762: end if;
763: --
764: hr_utility.set_location('Exiting'||l_proc, 99);
765:
766: --
767:
768: --

Line 916: hr_utility.set_location('Entering'||l_proc, 5);

912: --
913:
914: begin
915: --
916: hr_utility.set_location('Entering'||l_proc, 5);
917: --
918: --
919: -- update cvrd_flag, rslt_id, etc. ...
920: --

Line 921: hr_utility.set_location('Update dpnt info'||l_proc, 20);

917: --
918: --
919: -- update cvrd_flag, rslt_id, etc. ...
920: --
921: hr_utility.set_location('Update dpnt info'||l_proc, 20);
922: if p_multi_row_actn then
923: hr_utility.set_location('LAMC manage multi row', 20);
924: else hr_utility.set_location('LAMC manage NOT multi row', 20);
925: end if;

Line 923: hr_utility.set_location('LAMC manage multi row', 20);

919: -- update cvrd_flag, rslt_id, etc. ...
920: --
921: hr_utility.set_location('Update dpnt info'||l_proc, 20);
922: if p_multi_row_actn then
923: hr_utility.set_location('LAMC manage multi row', 20);
924: else hr_utility.set_location('LAMC manage NOT multi row', 20);
925: end if;
926:
927: ben_ELIG_DPNT_api.process_dependent(

Line 924: else hr_utility.set_location('LAMC manage NOT multi row', 20);

920: --
921: hr_utility.set_location('Update dpnt info'||l_proc, 20);
922: if p_multi_row_actn then
923: hr_utility.set_location('LAMC manage multi row', 20);
924: else hr_utility.set_location('LAMC manage NOT multi row', 20);
925: end if;
926:
927: ben_ELIG_DPNT_api.process_dependent(
928: p_elig_dpnt_id => p_elig_dpnt_id,

Line 944: hr_utility.set_location('10297977 p_old_prtt_enrt_rslt_id' || p_old_prtt_enrt_rslt_id ,1114);

940: -- dbms_output.put_line('Dpnt Info Done');
941: --
942: --Bug# 5572910
943: --
944: hr_utility.set_location('10297977 p_old_prtt_enrt_rslt_id' || p_old_prtt_enrt_rslt_id ,1114);
945: hr_utility.set_location('10297977 p_prtt_enrt_rslt_id' || p_prtt_enrt_rslt_id ,1114);
946:
947: if (p_old_prtt_enrt_rslt_id = p_prtt_enrt_rslt_id) then --10297977
948:

Line 945: hr_utility.set_location('10297977 p_prtt_enrt_rslt_id' || p_prtt_enrt_rslt_id ,1114);

941: --
942: --Bug# 5572910
943: --
944: hr_utility.set_location('10297977 p_old_prtt_enrt_rslt_id' || p_old_prtt_enrt_rslt_id ,1114);
945: hr_utility.set_location('10297977 p_prtt_enrt_rslt_id' || p_prtt_enrt_rslt_id ,1114);
946:
947: if (p_old_prtt_enrt_rslt_id = p_prtt_enrt_rslt_id) then --10297977
948:
949: open c_dpnt_pea;

Line 953: hr_utility.set_location('l_dpnt_pea.prtt_enrt_actn_id'||l_dpnt_pea.prtt_enrt_actn_id,1114);

949: open c_dpnt_pea;
950: --
951: fetch c_dpnt_pea into l_dpnt_pea;
952: --
953: hr_utility.set_location('l_dpnt_pea.prtt_enrt_actn_id'||l_dpnt_pea.prtt_enrt_actn_id,1114);
954: --
955: if c_dpnt_pea%found then
956: l_ccp_update_flag := 'N'; --6613891
957: hr_utility.set_location('In c_dpnt_pea. l_ccp_update_flag = '|| l_ccp_update_flag,8085);

Line 957: hr_utility.set_location('In c_dpnt_pea. l_ccp_update_flag = '|| l_ccp_update_flag,8085);

953: hr_utility.set_location('l_dpnt_pea.prtt_enrt_actn_id'||l_dpnt_pea.prtt_enrt_actn_id,1114);
954: --
955: if c_dpnt_pea%found then
956: l_ccp_update_flag := 'N'; --6613891
957: hr_utility.set_location('In c_dpnt_pea. l_ccp_update_flag = '|| l_ccp_update_flag,8085);
958: --
959: open c_ccp(l_dpnt_pea.prtt_enrt_actn_id);
960: loop
961: fetch c_ccp into l_ccp_rec;

Line 965: hr_utility.set_location('l_elig_cvrd_dpnt_id'||l_elig_cvrd_dpnt_id,1114);

961: fetch c_ccp into l_ccp_rec;
962: exit when c_ccp%notfound;
963: l_ccp_update_flag := 'Y'; --6613891
964: --
965: hr_utility.set_location('l_elig_cvrd_dpnt_id'||l_elig_cvrd_dpnt_id,1114);
966: --
967: -- Bug 6793512
968: --
969: dt_api.find_dt_upd_modes

Line 987: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);

983: else
984: l_datetrack_mode := hr_api.g_correction;
985: end if;
986: --
987: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);
988: -- Bug 6793512
989: ben_CVRD_DPNT_CTFN_PRVDD_api.update_CVRD_DPNT_CTFN_PRVDD
990: (
991: p_validate => FALSE

Line 1007: hr_utility.set_location('l_ccp_update_flag = ' || l_ccp_update_flag,8085);

1003: --
1004: close c_ccp;
1005:
1006: --6613891
1007: hr_utility.set_location('l_ccp_update_flag = ' || l_ccp_update_flag,8085);
1008: --
1009:
1010: if l_ccp_update_flag = 'Y' then
1011: --

Line 1032: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);

1028: else
1029: l_datetrack_mode := hr_api.g_correction;
1030: end if;
1031: --
1032: hr_utility.set_location('rtagarra '||l_datetrack_mode,9653);
1033: --
1034: -- Bug 6793512
1035: ben_PRTT_ENRT_ACTN_api.update_PRTT_ENRT_ACTN
1036: (

Line 1184: hr_utility.set_location('Exiting'||l_proc, 25);

1180: close dsgn_lvl_c;
1181: --
1182: end if;
1183: --
1184: hr_utility.set_location('Exiting'||l_proc, 25);
1185: --
1186: End hook_dpnt;
1187: --
1188: end ben_mng_dpnt_bnf;