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

Line 287: 20-mar-2003 ikasire 115.83 Bug 2847654 adding more hr_utility to isolate

283: 11-mar-2003 kmahendr 115.81 Bug#2821279 : Removed the max functions and logic
284: is based on order by clause.
285: 10-mar-2003 pbodla 115.82 Bug 2695023 CWB : If pay proposal is
286: associated with rate remove it also.
287: 20-mar-2003 ikasire 115.83 Bug 2847654 adding more hr_utility to isolate
288: an issue in the hrqa115m which is not replicable
289: 20-mar-2003 ikasire 115.84 Bug 2847654 fix removed the use of p_effective_date
290: removed the hr_utility
291: 16-Apr-2003 tjesumic 115.85 Bug # 2899702 manage_per_type_usage is called while

Line 290: removed the hr_utility

286: associated with rate remove it also.
287: 20-mar-2003 ikasire 115.83 Bug 2847654 adding more hr_utility to isolate
288: an issue in the hrqa115m which is not replicable
289: 20-mar-2003 ikasire 115.84 Bug 2847654 fix removed the use of p_effective_date
290: removed the hr_utility
291: 16-Apr-2003 tjesumic 115.85 Bug # 2899702 manage_per_type_usage is called while
292: deleting result to delete the parttn usage
293: 24-Jun-2003 tjesumic 115,86 c_futur_del_dpnt cursor is closed
294: 28-Aug-2003 tjesumic 115.87 bug # 3086161 whne the open LE reprocessed on the same day of

Line 538: hr_utility.set_location( 'Entering ben_back_out_life_event.update_epe', 1999 );

534: order by lf_evt_ocrd_dt desc ;
535:
536: l_prev_pil_id number;
537: begin
538: hr_utility.set_location( 'Entering ben_back_out_life_event.update_epe', 1999 );
539: hr_utility.set_location( 'p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 1999 );
540: hr_utility.set_location( 'p_effective_date'||p_effective_date, 1999 );
541: open c_get_pil_id(p_prtt_enrt_rslt_id);
542: fetch c_get_pil_id into l_upd_epe;

Line 539: hr_utility.set_location( 'p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 1999 );

535:
536: l_prev_pil_id number;
537: begin
538: hr_utility.set_location( 'Entering ben_back_out_life_event.update_epe', 1999 );
539: hr_utility.set_location( 'p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 1999 );
540: hr_utility.set_location( 'p_effective_date'||p_effective_date, 1999 );
541: open c_get_pil_id(p_prtt_enrt_rslt_id);
542: fetch c_get_pil_id into l_upd_epe;
543: if(c_get_pil_id%found) then

Line 540: hr_utility.set_location( 'p_effective_date'||p_effective_date, 1999 );

536: l_prev_pil_id number;
537: begin
538: hr_utility.set_location( 'Entering ben_back_out_life_event.update_epe', 1999 );
539: hr_utility.set_location( 'p_prtt_enrt_rslt_id '||p_prtt_enrt_rslt_id, 1999 );
540: hr_utility.set_location( 'p_effective_date'||p_effective_date, 1999 );
541: open c_get_pil_id(p_prtt_enrt_rslt_id);
542: fetch c_get_pil_id into l_upd_epe;
543: if(c_get_pil_id%found) then
544: hr_utility.set_location( 'epe found ', 1999 );

Line 544: hr_utility.set_location( 'epe found ', 1999 );

540: hr_utility.set_location( 'p_effective_date'||p_effective_date, 1999 );
541: open c_get_pil_id(p_prtt_enrt_rslt_id);
542: fetch c_get_pil_id into l_upd_epe;
543: if(c_get_pil_id%found) then
544: hr_utility.set_location( 'epe found ', 1999 );
545: open c_prev_pil_id;
546: fetch c_prev_pil_id into l_prev_pil_id;
547: close c_prev_pil_id;
548: hr_utility.set_location( 'l_prev_pil_id '||l_prev_pil_id, 1999 );

Line 548: hr_utility.set_location( 'l_prev_pil_id '||l_prev_pil_id, 1999 );

544: hr_utility.set_location( 'epe found ', 1999 );
545: open c_prev_pil_id;
546: fetch c_prev_pil_id into l_prev_pil_id;
547: close c_prev_pil_id;
548: hr_utility.set_location( 'l_prev_pil_id '||l_prev_pil_id, 1999 );
549: hr_utility.set_location( 'l_upd_epe.per_in_ler_id '||l_upd_epe.per_in_ler_id, 1999 );
550: hr_utility.set_location( 'l_upd_epe.prtt_enrt_rslt_id '||l_upd_epe.prtt_enrt_rslt_id, 1999 );
551: if(l_prev_pil_id <> l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is NULL) then
552: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,101);

Line 549: hr_utility.set_location( 'l_upd_epe.per_in_ler_id '||l_upd_epe.per_in_ler_id, 1999 );

545: open c_prev_pil_id;
546: fetch c_prev_pil_id into l_prev_pil_id;
547: close c_prev_pil_id;
548: hr_utility.set_location( 'l_prev_pil_id '||l_prev_pil_id, 1999 );
549: hr_utility.set_location( 'l_upd_epe.per_in_ler_id '||l_upd_epe.per_in_ler_id, 1999 );
550: hr_utility.set_location( 'l_upd_epe.prtt_enrt_rslt_id '||l_upd_epe.prtt_enrt_rslt_id, 1999 );
551: if(l_prev_pil_id <> l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is NULL) then
552: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,101);
553: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,101);

Line 550: hr_utility.set_location( 'l_upd_epe.prtt_enrt_rslt_id '||l_upd_epe.prtt_enrt_rslt_id, 1999 );

546: fetch c_prev_pil_id into l_prev_pil_id;
547: close c_prev_pil_id;
548: hr_utility.set_location( 'l_prev_pil_id '||l_prev_pil_id, 1999 );
549: hr_utility.set_location( 'l_upd_epe.per_in_ler_id '||l_upd_epe.per_in_ler_id, 1999 );
550: hr_utility.set_location( 'l_upd_epe.prtt_enrt_rslt_id '||l_upd_epe.prtt_enrt_rslt_id, 1999 );
551: if(l_prev_pil_id <> l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is NULL) then
552: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,101);
553: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,101);
554: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,101);

Line 552: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,101);

548: hr_utility.set_location( 'l_prev_pil_id '||l_prev_pil_id, 1999 );
549: hr_utility.set_location( 'l_upd_epe.per_in_ler_id '||l_upd_epe.per_in_ler_id, 1999 );
550: hr_utility.set_location( 'l_upd_epe.prtt_enrt_rslt_id '||l_upd_epe.prtt_enrt_rslt_id, 1999 );
551: if(l_prev_pil_id <> l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is NULL) then
552: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,101);
553: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,101);
554: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,101);
555:
556: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC

Line 553: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,101);

549: hr_utility.set_location( 'l_upd_epe.per_in_ler_id '||l_upd_epe.per_in_ler_id, 1999 );
550: hr_utility.set_location( 'l_upd_epe.prtt_enrt_rslt_id '||l_upd_epe.prtt_enrt_rslt_id, 1999 );
551: if(l_prev_pil_id <> l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is NULL) then
552: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,101);
553: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,101);
554: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,101);
555:
556: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC
557: (p_validate => FALSE

Line 554: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,101);

550: hr_utility.set_location( 'l_upd_epe.prtt_enrt_rslt_id '||l_upd_epe.prtt_enrt_rslt_id, 1999 );
551: if(l_prev_pil_id <> l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is NULL) then
552: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,101);
553: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,101);
554: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,101);
555:
556: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC
557: (p_validate => FALSE
558: ,p_elig_per_elctbl_chc_id => l_upd_epe.elig_per_elctbl_chc_id

Line 564: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,102);

560: ,p_object_version_number => l_upd_epe.object_version_number
561: ,p_effective_date => p_effective_date
562: );
563: elsif(l_prev_pil_id = l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is null) then
564: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,102);
565: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,102);
566: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,102);
567:
568: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC

Line 565: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,102);

561: ,p_effective_date => p_effective_date
562: );
563: elsif(l_prev_pil_id = l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is null) then
564: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,102);
565: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,102);
566: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,102);
567:
568: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC
569: (p_validate => FALSE

Line 566: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,102);

562: );
563: elsif(l_prev_pil_id = l_upd_epe.per_in_ler_id and l_upd_epe.prtt_enrt_rslt_id is null) then
564: hr_utility.set_location( 'l_pil_id '||l_upd_epe.per_in_ler_id,102);
565: hr_utility.set_location( 'l_epe_id '||l_upd_epe.elig_per_elctbl_chc_id,102);
566: hr_utility.set_location( 'l_epe_ovn '||l_upd_epe.object_version_number,102);
567:
568: ben_ELIG_PER_ELC_CHC_api.update_ELIG_PER_ELC_CHC
569: (p_validate => FALSE
570: ,p_elig_per_elctbl_chc_id => l_upd_epe.elig_per_elctbl_chc_id

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

645: l_proc varchar2(72) := g_package||'p_backout_contact_pils';
646: --
647: begin
648: --
649: hr_utility.set_location('Entering:'|| l_proc, 10);
650: hr_utility.set_location('p_bckt_stat_cd:'|| p_bckt_stat_cd, 10);
651: hr_utility.set_location('p_csd_by_ptnl_ler_for_per_id:'|| p_csd_by_ptnl_ler_for_per_id, 10);
652: --
653: -- First check any potentials of detected or unprocessed

Line 650: hr_utility.set_location('p_bckt_stat_cd:'|| p_bckt_stat_cd, 10);

646: --
647: begin
648: --
649: hr_utility.set_location('Entering:'|| l_proc, 10);
650: hr_utility.set_location('p_bckt_stat_cd:'|| p_bckt_stat_cd, 10);
651: hr_utility.set_location('p_csd_by_ptnl_ler_for_per_id:'|| p_csd_by_ptnl_ler_for_per_id, 10);
652: --
653: -- First check any potentials of detected or unprocessed
654: -- exists. then void them.

Line 651: hr_utility.set_location('p_csd_by_ptnl_ler_for_per_id:'|| p_csd_by_ptnl_ler_for_per_id, 10);

647: begin
648: --
649: hr_utility.set_location('Entering:'|| l_proc, 10);
650: hr_utility.set_location('p_bckt_stat_cd:'|| p_bckt_stat_cd, 10);
651: hr_utility.set_location('p_csd_by_ptnl_ler_for_per_id:'|| p_csd_by_ptnl_ler_for_per_id, 10);
652: --
653: -- First check any potentials of detected or unprocessed
654: -- exists. then void them.
655: --

Line 664: hr_utility.set_location(' In VOIDD loop '|| l_con_ptnls_rec.ptnl_ler_for_per_id, 10);

660: --
661: -- Give messages idicating related potentials are voided
662: -- due to back out of pil which created them.
663: --
664: hr_utility.set_location(' In VOIDD loop '|| l_con_ptnls_rec.ptnl_ler_for_per_id, 10);
665: /*Bug 8495014: Potential LE's triggered on the dependent should not be backedout to VOID'ed state
666: while backing out the LifeEvent the on the Pariticipant.
667: Commented the call to 'update_ptnl_ler_for_per_perf' */
668:

Line 750: hr_utility.set_location('Leaving:'|| l_proc, 10);

746:
747: --
748: end if;
749: --
750: hr_utility.set_location('Leaving:'|| l_proc, 10);
751: --
752: end p_backout_contact_pils;
753: --
754: -- ----------------------------------------------------------------------------

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

798: l_bckt_stat_cd hr_lookups.lookup_code%TYPE := p_bckt_stat_cd; --UTF8
799: --
800: begin
801: --
802: hr_utility.set_location('Entering:'|| l_proc, 10);
803: --
804: l_unprocd_dt := trunc(sysdate);
805: --
806: open c_ptnl;

Line 825: hr_utility.set_location('Changing status to VOIDD as a potential ' ||

821: -- A similar potential already exists, so just
822: -- void the current potential, instead of making it
823: -- into unprocessed.
824: --
825: hr_utility.set_location('Changing status to VOIDD as a potential ' ||
826: 'already exists',10);
827: l_bckt_stat_cd := 'VOIDD';
828: --
829: end if;

Line 847: hr_utility.set_location('Setting status to '||l_bckt_stat_cd,10);

843: l_mnl_dt := p_effective_date;
844: --
845: end if;
846: --
847: hr_utility.set_location('Setting status to '||l_bckt_stat_cd,10);
848: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per
849: (p_validate => false
850: ,p_ptnl_ler_for_per_id => p_per_in_ler.ptnl_ler_for_per_id
851: ,p_ptnl_ler_for_per_stat_cd => l_bckt_stat_cd

Line 862: hr_utility.set_location('Leaving:'|| l_proc, 90);

858: ,p_unprocd_dt => l_unprocd_dt
859: ,p_voidd_dt => l_voidd_dt
860: ,p_mnl_dt => l_mnl_dt);
861: --
862: hr_utility.set_location('Leaving:'|| l_proc, 90);
863: --
864: end unprocess_ptnl_ler;
865: --
866:

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

898: l_object_version_number ben_elig_per_f.object_version_number%type;
899: --End AMN bug 12732878
900: begin
901: --
902: hr_utility.set_location ('Entering '||l_proc,10);
903: --
904: FOR l_rec IN c_restore_pep(p_per_in_ler_id) LOOP
905: --
906: l_effective_date := l_rec.effective_start_date;

Line 995: hr_utility.set_location('Start Restoring elig_per_id ',48);

991: ELSE
992: NULL;
993: --Do we need to Create one ?
994: --Start AMN bug 12732878 Creating a elig_per_f record
995: hr_utility.set_location('Start Restoring elig_per_id ',48);
996: ben_Eligible_Person_perf_api.create_perf_Eligible_Person
997: (p_validate => FALSE,
998: p_elig_per_id => l_elig_per_id,
999: p_effective_start_date => l_effective_start_date,

Line 1071: --hr_utility.set_location('g_epe_map_count '||g_epe_map_count,48);

1067: g_eper_map_rec.extend;
1068: g_epe_map_count := g_eper_map_rec.last;
1069: g_eper_map_rec(g_epe_map_count).old_elig_per_id := l_rec.BKUP_TBL_ID;
1070: g_eper_map_rec(g_epe_map_count).new_elig_per_id := l_elig_per_id;
1071: --hr_utility.set_location('g_epe_map_count '||g_epe_map_count,48);
1072: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).old_elig_per_id '||g_eper_map_rec(g_epe_map_count).old_elig_per_id,48);
1073: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).new_elig_per_id '||g_eper_map_rec(g_epe_map_count).new_elig_per_id,48);
1074: --End AMN bug 12732878
1075: --

Line 1072: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).old_elig_per_id '||g_eper_map_rec(g_epe_map_count).old_elig_per_id,48);

1068: g_epe_map_count := g_eper_map_rec.last;
1069: g_eper_map_rec(g_epe_map_count).old_elig_per_id := l_rec.BKUP_TBL_ID;
1070: g_eper_map_rec(g_epe_map_count).new_elig_per_id := l_elig_per_id;
1071: --hr_utility.set_location('g_epe_map_count '||g_epe_map_count,48);
1072: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).old_elig_per_id '||g_eper_map_rec(g_epe_map_count).old_elig_per_id,48);
1073: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).new_elig_per_id '||g_eper_map_rec(g_epe_map_count).new_elig_per_id,48);
1074: --End AMN bug 12732878
1075: --
1076: END IF;

Line 1073: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).new_elig_per_id '||g_eper_map_rec(g_epe_map_count).new_elig_per_id,48);

1069: g_eper_map_rec(g_epe_map_count).old_elig_per_id := l_rec.BKUP_TBL_ID;
1070: g_eper_map_rec(g_epe_map_count).new_elig_per_id := l_elig_per_id;
1071: --hr_utility.set_location('g_epe_map_count '||g_epe_map_count,48);
1072: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).old_elig_per_id '||g_eper_map_rec(g_epe_map_count).old_elig_per_id,48);
1073: --hr_utility.set_location('g_eper_map_rec(g_epe_map_count).new_elig_per_id '||g_eper_map_rec(g_epe_map_count).new_elig_per_id,48);
1074: --End AMN bug 12732878
1075: --
1076: END IF;
1077: --

Line 1088: hr_utility.set_location ('Leaving '||l_proc,10);

1084: delete from ben_le_clsn_n_rstr elig
1085: where elig.per_in_ler_ended_id = p_per_in_ler_id
1086: and elig.BKUP_TBL_TYP_CD = 'BEN_ELIG_PER_F_CORRECT' ;
1087: --
1088: hr_utility.set_location ('Leaving '||l_proc,10);
1089: --
1090: end restore_prev_pep ;
1091: --
1092: procedure restore_cert_completion

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

1126: l_datetrack_mode varchar2(100);
1127: --
1128: begin
1129: --
1130: hr_utility.set_location ('Entering '||l_proc,10);
1131: --
1132: FOR l_rec IN c_restore_pcs(p_per_in_ler_id) LOOP
1133: --
1134: l_effective_date := l_rec.effective_start_date;

Line 1233: hr_utility.set_location ('Leaving '||l_proc,10);

1229: delete from ben_le_clsn_n_rstr pcs
1230: where pcs.per_in_ler_ended_id = p_per_in_ler_id
1231: and pcs.BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_ACTN_F_UPD' ;
1232: --
1233: hr_utility.set_location ('Leaving '||l_proc,10);
1234: --
1235: end restore_cert_completion ;
1236: --
1237: --

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

1269: l_new_elig_per_id ben_elig_per_opt_f.elig_per_opt_id%TYPE;
1270: --End AMN bug 12732878
1271: begin
1272: --
1273: hr_utility.set_location ('Entering '||l_proc,10);
1274: --
1275: FOR l_rec IN c_restore_epo(p_per_in_ler_id) LOOP
1276: --
1277: l_effective_date := l_rec.effective_start_date;

Line 1368: hr_utility.set_location('Start Restoring elig_per_opt_id '||l_elig_per_opt_id,48);

1364: NULL;
1365: --Do we need to Create one ?
1366: --AMN Start bug 12732878 Create elig_per_opt_id
1367: l_new_elig_per_id := get_new_elig_per_id(l_rec.elig_per_id);
1368: hr_utility.set_location('Start Restoring elig_per_opt_id '||l_elig_per_opt_id,48);
1369: --hr_utility.set_location('l_rec.elig_per_id '||l_rec.elig_per_id,48);
1370: --hr_utility.set_location('l_new_elig_per_id '||l_new_elig_per_id,48);
1371: ben_Eligible_Person_perf_api.create_perf_Elig_Person_Option
1372: (p_validate => FALSE,

Line 1369: --hr_utility.set_location('l_rec.elig_per_id '||l_rec.elig_per_id,48);

1365: --Do we need to Create one ?
1366: --AMN Start bug 12732878 Create elig_per_opt_id
1367: l_new_elig_per_id := get_new_elig_per_id(l_rec.elig_per_id);
1368: hr_utility.set_location('Start Restoring elig_per_opt_id '||l_elig_per_opt_id,48);
1369: --hr_utility.set_location('l_rec.elig_per_id '||l_rec.elig_per_id,48);
1370: --hr_utility.set_location('l_new_elig_per_id '||l_new_elig_per_id,48);
1371: ben_Eligible_Person_perf_api.create_perf_Elig_Person_Option
1372: (p_validate => FALSE,
1373: p_elig_per_opt_id => l_elig_per_opt_id,

Line 1370: --hr_utility.set_location('l_new_elig_per_id '||l_new_elig_per_id,48);

1366: --AMN Start bug 12732878 Create elig_per_opt_id
1367: l_new_elig_per_id := get_new_elig_per_id(l_rec.elig_per_id);
1368: hr_utility.set_location('Start Restoring elig_per_opt_id '||l_elig_per_opt_id,48);
1369: --hr_utility.set_location('l_rec.elig_per_id '||l_rec.elig_per_id,48);
1370: --hr_utility.set_location('l_new_elig_per_id '||l_new_elig_per_id,48);
1371: ben_Eligible_Person_perf_api.create_perf_Elig_Person_Option
1372: (p_validate => FALSE,
1373: p_elig_per_opt_id => l_elig_per_opt_id,
1374: p_elig_per_id => l_new_elig_per_id,

Line 1445: hr_utility.set_location ('Leaving '||l_proc,10);

1441: delete from ben_le_clsn_n_rstr elig
1442: where elig.per_in_ler_ended_id = p_per_in_ler_id
1443: and elig.BKUP_TBL_TYP_CD = 'BEN_ELIG_PER_OPT_F_CORRECT';
1444: --
1445: hr_utility.set_location ('Leaving '||l_proc,10);
1446: --
1447: END restore_prev_epo ;
1448: --
1449: -- This procedure is the main call that does the calls to back out the

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

1609:
1610: --
1611: begin
1612: --
1613: hr_utility.set_location ('Entering '||l_package,10);
1614: --
1615: -- unrestricted life event not to be backed out
1616: open c_ler_typ;
1617: fetch c_ler_typ into l_ler_typ;

Line 1704: hr_utility.set_location ('prv_per_in_ler_id' || l_prv_per_in_ler_id, 99 );

1700: open c_prev_pil_id (l_pil_stat.person_id , l_pil_stat.lf_evt_ocrd_dt) ;
1701: fetch c_prev_pil_id into l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt ;
1702: close c_prev_pil_id ;
1703:
1704: hr_utility.set_location ('prv_per_in_ler_id' || l_prv_per_in_ler_id, 99 );
1705: hr_utility.set_location ('l_lf_evt_ocrd_dt' || l_prv_lf_evt_ocrd_dt, 99 );
1706: -- First back out contact persons per in ler's
1707: -- if they are created by the per in ler which is
1708: -- # 2982606 Total of Two Plan Resulkt level backedout introduced

Line 1705: hr_utility.set_location ('l_lf_evt_ocrd_dt' || l_prv_lf_evt_ocrd_dt, 99 );

1701: fetch c_prev_pil_id into l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt ;
1702: close c_prev_pil_id ;
1703:
1704: hr_utility.set_location ('prv_per_in_ler_id' || l_prv_per_in_ler_id, 99 );
1705: hr_utility.set_location ('l_lf_evt_ocrd_dt' || l_prv_lf_evt_ocrd_dt, 99 );
1706: -- First back out contact persons per in ler's
1707: -- if they are created by the per in ler which is
1708: -- # 2982606 Total of Two Plan Resulkt level backedout introduced
1709: if p_bckdt_prtt_enrt_rslt_id is null then

Line 1751: hr_utility.set_location('Effective Date'||p_effective_date,10);

1747: p_effective_date => p_effective_date);
1748:
1749: -- (404) Until we recognize that pcp's aren't valid if their per-in-ler isn't
1750: -- we need to still delete them. Need to change views? or add per in ler id.
1751: hr_utility.set_location('Effective Date'||p_effective_date,10);
1752:
1753: delete_routine(p_routine => 'BEN_PRMRY_CARE_PRVDR_F',
1754: p_per_in_ler_id => p_per_in_ler_id,
1755: p_business_group_id => p_business_group_id,

Line 1786: hr_utility.set_location('BEN_PRTT_RT_VAL p_effective_date'||p_effective_date,1999);

1782: p_bckdt_prtt_enrt_rslt_id => p_bckdt_prtt_enrt_rslt_id,
1783: p_copy_only => p_copy_only,
1784: p_effective_date => p_effective_date);
1785:
1786: hr_utility.set_location('BEN_PRTT_RT_VAL p_effective_date'||p_effective_date,1999);
1787: -- mark rates 'backed out'
1788: delete_routine(p_routine => 'BEN_PRTT_RT_VAL',
1789: p_per_in_ler_id => p_per_in_ler_id,
1790: p_business_group_id => p_business_group_id,

Line 1919: hr_utility.set_location ('prv_per_in_ler_id' || l_prv_per_in_ler_id, 199 );

1915: fetch c_prev_pil_id into l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt ;
1916: close c_prev_pil_id ;
1917: */
1918:
1919: hr_utility.set_location ('prv_per_in_ler_id' || l_prv_per_in_ler_id, 199 );
1920: hr_utility.set_location ('l_lf_evt_ocrd_dt' || l_prv_lf_evt_ocrd_dt, 199 );
1921: --
1922: --IK START
1923: -- Get all the BEN_ELIG_PER_F_CORRECTION and BEN_ELIG_PER_OPT_F_CORRECTION

Line 1920: hr_utility.set_location ('l_lf_evt_ocrd_dt' || l_prv_lf_evt_ocrd_dt, 199 );

1916: close c_prev_pil_id ;
1917: */
1918:
1919: hr_utility.set_location ('prv_per_in_ler_id' || l_prv_per_in_ler_id, 199 );
1920: hr_utility.set_location ('l_lf_evt_ocrd_dt' || l_prv_lf_evt_ocrd_dt, 199 );
1921: --
1922: --IK START
1923: -- Get all the BEN_ELIG_PER_F_CORRECTION and BEN_ELIG_PER_OPT_F_CORRECTION
1924: -- records from BEN_LE_CLSN_N_RSTR table for the per_in_ler being backed out

Line 1970: hr_utility.set_location ('l_prv_effective_start_date' || l_prv_effective_start_date, 99 );

1966: -- Look if there is any backedout result for the future dated coverage
1967: open c_prv_rslt_lvl_bckdt(l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt );
1968: fetch c_prv_rslt_lvl_bckdt into l_prv_effective_start_date ;
1969: close c_prv_rslt_lvl_bckdt ;
1970: hr_utility.set_location ('l_prv_effective_start_date' || l_prv_effective_start_date, 99 );
1971: g_no_reopen_flag := 'Y';
1972: else
1973: open c_prv_rslt_lvl_bckdt(l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt );
1974: fetch c_prv_rslt_lvl_bckdt into l_prv_effective_start_date ;

Line 1976: hr_utility.set_location ('l_prv_effective_start_date' || l_prv_effective_start_date, 199 );

1972: else
1973: open c_prv_rslt_lvl_bckdt(l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt );
1974: fetch c_prv_rslt_lvl_bckdt into l_prv_effective_start_date ;
1975: close c_prv_rslt_lvl_bckdt ;
1976: hr_utility.set_location ('l_prv_effective_start_date' || l_prv_effective_start_date, 199 );
1977: end if;
1978: close c_chk_enrt_prev_le;
1979: /* Ended for Bug 8604243*/
1980:

Line 1981: hr_utility.set_location ('l_prv_eff dt' || l_prv_effective_start_date, 99 );

1977: end if;
1978: close c_chk_enrt_prev_le;
1979: /* Ended for Bug 8604243*/
1980:
1981: hr_utility.set_location ('l_prv_eff dt' || l_prv_effective_start_date, 99 );
1982: hr_utility.set_location ('l_prv_per_in_ler_id' || l_prv_per_in_ler_id, 99 );
1983:
1984: if l_prv_effective_start_date is not null then
1985: hr_utility.set_location ('status to started' , 99 );

Line 1982: hr_utility.set_location ('l_prv_per_in_ler_id' || l_prv_per_in_ler_id, 99 );

1978: close c_chk_enrt_prev_le;
1979: /* Ended for Bug 8604243*/
1980:
1981: hr_utility.set_location ('l_prv_eff dt' || l_prv_effective_start_date, 99 );
1982: hr_utility.set_location ('l_prv_per_in_ler_id' || l_prv_per_in_ler_id, 99 );
1983:
1984: if l_prv_effective_start_date is not null then
1985: hr_utility.set_location ('status to started' , 99 );
1986:

Line 1985: hr_utility.set_location ('status to started' , 99 );

1981: hr_utility.set_location ('l_prv_eff dt' || l_prv_effective_start_date, 99 );
1982: hr_utility.set_location ('l_prv_per_in_ler_id' || l_prv_per_in_ler_id, 99 );
1983:
1984: if l_prv_effective_start_date is not null then
1985: hr_utility.set_location ('status to started' , 99 );
1986:
1987: -- added here bug 7039025
1988: For l_prior_to_prv_rslt_lvl_bckdt in c_prior_to_prv_rslt_lvl_bckdt(l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt)
1989: loop

Line 1991: hr_utility.set_location ('prior to prev life event found in bkup table',44333);

1987: -- added here bug 7039025
1988: For l_prior_to_prv_rslt_lvl_bckdt in c_prior_to_prv_rslt_lvl_bckdt(l_prv_per_in_ler_id,l_prv_lf_evt_ocrd_dt)
1989: loop
1990: --
1991: hr_utility.set_location ('prior to prev life event found in bkup table',44333);
1992: --
1993: -- Insert a correction row before updation as if, the enrollments were corrected by the next pil.
1994: INSERT INTO ben_le_clsn_n_rstr
1995: (COMP_LVL_CD,

Line 2367: hr_utility.set_location('Inserted corrected Row', 44333);

2363: l_prior_to_prv_rslt_lvl_bckdt.VAL,
2364: l_prior_to_prv_rslt_lvl_bckdt.STD_PREM_VAL,
2365: l_prior_to_prv_rslt_lvl_bckdt.STD_PREM_UOM);
2366: --
2367: hr_utility.set_location('Inserted corrected Row', 44333);
2368: --
2369: UPDATE ben_le_clsn_n_rstr
2370: SET per_in_ler_id = l_prv_per_in_ler_id
2371: WHERE per_in_ler_id = l_prior_to_prv_rslt_lvl_bckdt.per_in_ler_id

Line 2380: hr_utility.set_location ('updated bkup table table with prev per_in_ler', 44333);

2376: AND effective_end_date = hr_api.g_eot
2377: AND enrt_cvg_strt_dt > l_prv_lf_evt_ocrd_dt
2378: AND enrt_cvg_strt_dt < effective_end_date;
2379: --
2380: hr_utility.set_location ('updated bkup table table with prev per_in_ler', 44333);
2381: --
2382:
2383: end loop;
2384:

Line 2388: hr_utility.set_location ('restoring result ' , 99 );

2384:
2385: -- added till here bug 7039025
2386:
2387:
2388: hr_utility.set_location ('restoring result ' , 99 );
2389: ben_lf_evt_clps_restore.reinstate_the_prev_enrt_rslt(
2390: p_person_id => l_pil_stat.person_id
2391: ,p_business_group_id => p_business_group_id
2392: ,p_ler_id => l_pil_stat.ler_id

Line 2404: hr_utility.set_location ('status to closed' , 99 );

2400: where per_in_ler_id = l_prv_per_in_ler_id
2401: AND business_group_id = p_business_group_id ;
2402:
2403:
2404: hr_utility.set_location ('status to closed' , 99 );
2405: end if ;
2406: --
2407: --Restore Future completed Action Items
2408: --

Line 2419: hr_utility.set_location ('Leaving '||l_package,99);

2415: -- Bug 2526994 This needs to be reset once the process is done.
2416: g_backout_flag := null ;
2417: --
2418: end if;
2419: hr_utility.set_location ('Leaving '||l_package,99);
2420: --
2421: exception
2422: when others then
2423: --

Line 2427: hr_utility.set_location('Flag g_backout_flag Reset', 9999);

2423: --
2424: -- Bug 4919951 - Reset the flag if any exception raised
2425: --
2426: g_backout_flag := null ;
2427: hr_utility.set_location('Flag g_backout_flag Reset', 9999);
2428: raise;
2429: --
2430: --
2431: end back_out_life_events;

Line 2505: hr_utility.set_location ('Entering ' || l_proc , 1230);

2501: l_prev_enrt_ctfn_prvdd_id number;
2502: --
2503: begin
2504: --
2505: hr_utility.set_location ('Entering ' || l_proc , 1230);
2506: l_per_in_ler_id := p_per_in_ler_id;
2507: --
2508: l_prev_prtt_enrt_actn_id := -1;
2509: l_prev_enrt_ctfn_prvdd_id := -1;

Line 2519: hr_utility.set_location('ACE l_prev_prtt_enrt_actn_id = ' || l_prev_prtt_enrt_actn_id, 9999);

2515: -- Un-enddate action item record
2516: --
2517: l_object_version_number := l_actn_item.object_version_number;
2518: --
2519: hr_utility.set_location('ACE l_prev_prtt_enrt_actn_id = ' || l_prev_prtt_enrt_actn_id, 9999);
2520: hr_utility.set_location('ACE l_prtt_enrt_actn_id = ' || l_prtt_enrt_actn_id, 9999);
2521: if l_prev_prtt_enrt_actn_id <> l_prtt_enrt_actn_id
2522: then
2523: --

Line 2520: hr_utility.set_location('ACE l_prtt_enrt_actn_id = ' || l_prtt_enrt_actn_id, 9999);

2516: --
2517: l_object_version_number := l_actn_item.object_version_number;
2518: --
2519: hr_utility.set_location('ACE l_prev_prtt_enrt_actn_id = ' || l_prev_prtt_enrt_actn_id, 9999);
2520: hr_utility.set_location('ACE l_prtt_enrt_actn_id = ' || l_prtt_enrt_actn_id, 9999);
2521: if l_prev_prtt_enrt_actn_id <> l_prtt_enrt_actn_id
2522: then
2523: --
2524: -- Bug 4642315 : Cursor C_ACTN_ITEM_FOR_PAST_PIL will pick up multiple datetracked

Line 2541: hr_utility.set_location('ACE l_actn_item.prtt_enrt_actn_id = ' || l_actn_item.prtt_enrt_actn_id, 8888);

2537: p_datetrack_mode => hr_api.g_future_change);
2538: --
2539: end if;
2540: --
2541: hr_utility.set_location('ACE l_actn_item.prtt_enrt_actn_id = ' || l_actn_item.prtt_enrt_actn_id, 8888);
2542: --
2543: -- Un-enddate enrollment certification record(s)
2544: --
2545: l_prev_enrt_ctfn_prvdd_id := -1;

Line 2595: hr_utility.set_location ('Leaving ' || l_proc, 1230);

2591: --
2592: end if;
2593: close c_check_prem_active;
2594: --
2595: hr_utility.set_location ('Leaving ' || l_proc, 1230);
2596: end unprocess_susp_enrt_past_pil;
2597: -- CFW
2598: --
2599: -- This function has been added as part of fix for bug 2518955

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

2608: l_msg_app VARCHAR2(50);
2609: l_proc VARCHAR2(72) := g_package||'get_msg_name';
2610:
2611: BEGIN
2612: -- hr_utility.set_location('Entering:'|| l_proc, 10);
2613:
2614: l_encoded_msg := fnd_message.get_encoded();
2615: fnd_message.parse_encoded(
2616: encoded_message => l_encoded_msg

Line 2621: -- hr_utility.set_location('Leaving:'|| l_proc, 20);

2617: ,app_short_name => l_msg_app -- OUT
2618: ,message_name => l_msg_name -- OUT
2619: );
2620:
2621: -- hr_utility.set_location('Leaving:'|| l_proc, 20);
2622:
2623: RETURN l_msg_name;
2624:
2625: END; -- get_msg_name

Line 2677: hr_utility.set_location('Entering Adj Prv rate',10);

2673: l_element_start_date date;
2674: --
2675: begin
2676: --
2677: hr_utility.set_location('Entering Adj Prv rate',10);
2678: open c_future_prv;
2679: fetch c_future_prv into l_prv;
2680: close c_future_prv;
2681: --

Line 2684: hr_utility.set_location('value Id is not null',11);

2680: close c_future_prv;
2681: --
2682: if l_prv.element_entry_value_id is not null then
2683: --
2684: hr_utility.set_location('value Id is not null',11);
2685: open c_element (l_prv.element_entry_value_id);
2686: fetch c_element into l_element;
2687: close c_element;
2688: --

Line 2689: hr_utility.set_location('effective date'||l_element.effective_start_date,10);

2685: open c_element (l_prv.element_entry_value_id);
2686: fetch c_element into l_element;
2687: close c_element;
2688: --
2689: hr_utility.set_location('effective date'||l_element.effective_start_date,10);
2690: l_element_start_date := l_element.effective_start_date;
2691: py_element_entry_api.delete_element_entry
2692: (p_validate => false
2693: ,p_datetrack_delete_mode => hr_api.g_zap

Line 2705: hr_utility.set_location ('Adjust old rate',12);

2701: --
2702: end if;
2703: -- adjust the rate
2704: l_object_version_number := p_object_version_number;
2705: hr_utility.set_location ('Adjust old rate',12);
2706: ben_prtt_rt_val_api.update_prtt_rt_val
2707: (P_PRTT_RT_VAL_ID => p_prtt_rt_val_id
2708: ,P_RT_END_DT => p_rt_END_DT
2709: ,p_person_id => p_person_id

Line 2718: hr_utility.set_location ('Recreate element ',14);

2714: --
2715:
2716: if l_prv.element_entry_value_id is not null then
2717: --
2718: hr_utility.set_location ('Recreate element ',14);
2719: ben_element_entry.create_enrollment_element
2720: (p_business_group_id => p_business_group_id
2721: ,p_prtt_rt_val_id => l_prv.prtt_rt_val_id
2722: ,p_person_id => p_person_id

Line 2739: hr_utility.set_location ('Leaving Adjust rate',15);

2735: ,p_element_entry_value_id => l_dummy_number
2736: );
2737: --
2738: end if;
2739: hr_utility.set_location ('Leaving Adjust rate',15);
2740: end;
2741: --
2742: -- Added for bug 7206471
2743: --

Line 2761: hr_utility.set_location('Entering Adj Pen Cvg',44333);

2757: --
2758: --
2759: begin
2760: --
2761: hr_utility.set_location('Entering Adj Pen Cvg',44333);
2762: --
2763: --
2764: -- adjust the coverage
2765: l_object_version_number := p_object_version_number;

Line 2766: hr_utility.set_location ('Adjust old coverage',44333);

2762: --
2763: --
2764: -- adjust the coverage
2765: l_object_version_number := p_object_version_number;
2766: hr_utility.set_location ('Adjust old coverage',44333);
2767: ben_prtt_enrt_result_api.update_prtt_enrt_result
2768: (p_validate => FALSE,
2769: p_prtt_enrt_rslt_id => p_prtt_enrt_rslt_id,
2770: p_effective_start_date => l_effective_start_date,

Line 2780: hr_utility.set_location ('Leaving Adj Pen Cvg',44333);

2776: p_multi_row_validate => FALSE,
2777: p_enrt_cvg_thru_dt => p_cvg_end_dt
2778: );
2779: --
2780: hr_utility.set_location ('Leaving Adj Pen Cvg',44333);
2781: end;
2782: -- End bug 7206471
2783:
2784: -- When Open LE processed then a LE processed before open starts

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

3966: l_effective_date_new date;
3967: --
3968: begin
3969: --
3970: hr_utility.set_location ('Entering '||l_package,10);
3971: hr_utility.set_location ('Start of '||p_routine,10);
3972: --
3973: -- check which routine we are calling
3974: --

Line 3971: hr_utility.set_location ('Start of '||p_routine,10);

3967: --
3968: begin
3969: --
3970: hr_utility.set_location ('Entering '||l_package,10);
3971: hr_utility.set_location ('Start of '||p_routine,10);
3972: --
3973: -- check which routine we are calling
3974: --
3975: if p_routine = 'BEN_ELIG_CVRD_DPNT_F' then

Line 3999: hr_utility.set_location ('with in loop '||l_pk_id,10);

3995: --
3996: -- Get the maximum of effective end date for the dependents
3997: -- with past per_in_ler 's.
3998: --
3999: hr_utility.set_location ('with in loop '||l_pk_id,10);
4000: --
4001: l_effective_date := null;
4002:
4003: open c_pdp_max_esd_of_past_pil(l_pk_id);

Line 4033: hr_utility.set_location ('backup notfound '||l_effective_date,10);

4029: fetch c_bkp_row into l_row_id;
4030: --
4031: if c_bkp_row%notfound
4032: then
4033: hr_utility.set_location ('backup notfound '||l_effective_date,10);
4034: --
4035: close c_bkp_row;
4036: --
4037: insert into BEN_LE_CLSN_N_RSTR (

Line 4247: hr_utility.set_location('Effective date is null ',121);

4243: --
4244: end if; -- l_prev_pk_id <> l_pk_id
4245: -- bud 5668052
4246: else
4247: hr_utility.set_location('Effective date is null ',121);
4248: BEN_ELIG_CVRD_DPNT_API.remove_usage(
4249: p_validate => FALSE
4250: ,p_elig_cvrd_dpnt_id => l_pk_id
4251: ,p_cvg_thru_dt => NULL

Line 4272: hr_utility.set_location ('with in future loop '||l_f_pen.prtt_enrt_rslt_id,10);

4268: ---- first cursor find all the result voided by the PIL and coverage is future dtd
4269: ---- Second cursor find the PDP record end dated for the result
4270: if nvl(p_copy_only,'N') <> 'Y' then
4271: for l_f_pen in c_futur_pen loop
4272: hr_utility.set_location ('with in future loop '||l_f_pen.prtt_enrt_rslt_id,10);
4273: open c_futur_del_dpnt (l_f_pen.prtt_enrt_rslt_id ) ;
4274: Loop
4275: fetch c_futur_del_dpnt into l_pk_id,l_object_version_number,l_effective_date ;
4276: exit when c_futur_del_dpnt%notfound;

Line 4306: hr_utility.set_location(' correcting ' || i.elig_cvrd_dpnt_id, 999 );

4302: for i in c_BEN_LE_CLSN_N_RSTR_dpnt(p_per_in_ler_id )
4303: Loop
4304: if l_prev_elig_cvrd_dpnt_id <> i.elig_cvrd_dpnt_id then
4305: l_object_version_number := i.object_version_number ;
4306: hr_utility.set_location(' correcting ' || i.elig_cvrd_dpnt_id, 999 );
4307: ben_elig_cvrd_dpnt_api.update_elig_cvrd_dpnt
4308: (p_validate => FALSE
4309: ,p_business_group_id => p_business_group_id
4310: ,p_elig_cvrd_dpnt_id => i.elig_cvrd_dpnt_id

Line 4373: --hr_utility.set_location('ben_elig_per_id '||l_pk_id,48);

4369: --
4370: fetch c_ben_elig_per_f into l_pk_id,
4371: l_object_version_number,
4372: l_effective_date_new;
4373: --hr_utility.set_location('ben_elig_per_id '||l_pk_id,48);
4374: --hr_utility.set_location('l_effective_date_new '||l_effective_date_new,48);
4375: exit when c_ben_elig_per_f%notfound;
4376: --
4377: -- Get the maximum of effective end date

Line 4374: --hr_utility.set_location('l_effective_date_new '||l_effective_date_new,48);

4370: fetch c_ben_elig_per_f into l_pk_id,
4371: l_object_version_number,
4372: l_effective_date_new;
4373: --hr_utility.set_location('ben_elig_per_id '||l_pk_id,48);
4374: --hr_utility.set_location('l_effective_date_new '||l_effective_date_new,48);
4375: exit when c_ben_elig_per_f%notfound;
4376: --
4377: -- Get the maximum of effective end date
4378: -- with past per_in_ler 's.

Line 4942: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);

4938: --
4939: elsif p_routine = 'BEN_PRTT_PREM_F' then
4940: -------------Bug 7133998
4941: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4942: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4943: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);
4944: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);
4945: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',
4946: l_prtt_prem_corr.PRTT_PREM_ID,

Line 4943: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);

4939: elsif p_routine = 'BEN_PRTT_PREM_F' then
4940: -------------Bug 7133998
4941: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4942: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4943: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);
4944: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);
4945: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',
4946: l_prtt_prem_corr.PRTT_PREM_ID,
4947: l_prtt_prem_corr.effective_start_date,

Line 4944: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);

4940: -------------Bug 7133998
4941: for l_prtt_prem_corr in c_ben_prtt_prem_f_corr loop
4942: hr_utility.set_location('l_prtt_prem_corr.PRTT_PREM_ID : '||l_prtt_prem_corr.PRTT_PREM_ID,1);
4943: hr_utility.set_location('ESD : '||l_prtt_prem_corr.effective_start_date,1);
4944: hr_utility.set_location('EED : '||l_prtt_prem_corr.effective_end_date,1);
4945: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',
4946: l_prtt_prem_corr.PRTT_PREM_ID,
4947: l_prtt_prem_corr.effective_start_date,
4948: l_prtt_prem_corr.effective_end_date) loop

Line 4949: hr_utility.set_location('ESD,in loop : '||l_prtt_prem_corr.effective_start_date,1);

4945: for l_bkp_prem_row in c_bkp_prem_row('BEN_PRTT_PREM_F_CORR',
4946: l_prtt_prem_corr.PRTT_PREM_ID,
4947: l_prtt_prem_corr.effective_start_date,
4948: l_prtt_prem_corr.effective_end_date) loop
4949: hr_utility.set_location('ESD,in loop : '||l_prtt_prem_corr.effective_start_date,1);
4950: ben_prtt_prem_api.update_prtt_prem
4951: ( p_validate => FALSE
4952: ,p_prtt_prem_id => l_prtt_prem_corr.prtt_prem_id
4953: ,p_effective_start_date => l_effective_start_date

Line 5493: hr_utility.set_location('effective date null ' ,12.12);

5489: --
5490: end if; -- l_prev_pk_id <> l_pk_id
5491: else
5492: -- -- bug 5668052
5493: hr_utility.set_location('effective date null ' ,12.12);
5494: BEN_PLAN_BENEFICIARY_API.remove_usage (
5495: p_validate => FALSE
5496: ,p_pl_bnf_id => l_pk_id
5497: ,p_effective_date => l_bnf_effective_start_date

Line 5592: hr_utility.set_location('calling date ' || p_effective_date , 293);

5588: begin
5589: loop
5590: fetch c_prc into l_prc_rec ;
5591: exit when c_prc%notfound ;
5592: hr_utility.set_location('calling date ' || p_effective_date , 293);
5593: hr_utility.set_location('calling id ' || l_prc_rec.PRTT_REIMBMT_RQST_ID , 293);
5594:
5595: BEN_prtt_reimbmt_rqst_API.delete_prtt_reimbmt_rqst
5596: (p_validate => FALSE

Line 5593: hr_utility.set_location('calling id ' || l_prc_rec.PRTT_REIMBMT_RQST_ID , 293);

5589: loop
5590: fetch c_prc into l_prc_rec ;
5591: exit when c_prc%notfound ;
5592: hr_utility.set_location('calling date ' || p_effective_date , 293);
5593: hr_utility.set_location('calling id ' || l_prc_rec.PRTT_REIMBMT_RQST_ID , 293);
5594:
5595: BEN_prtt_reimbmt_rqst_API.delete_prtt_reimbmt_rqst
5596: (p_validate => FALSE
5597: ,p_PRTT_REIMBMT_RQST_ID => l_prc_rec.PRTT_REIMBMT_RQST_ID

Line 5650: hr_utility.set_location('FOUND GHR',9909);

5646:
5647: IF (fnd_installation.get_app_info('GHR',l_status, l_industry, l_oracle_schema)) THEN
5648:
5649: if l_status = 'I' then
5650: hr_utility.set_location('FOUND GHR',9909);
5651: open c_multiple_rate;
5652: fetch c_multiple_rate into l_multiple_rate;
5653: if c_multiple_rate%found then
5654: --

Line 5655: hr_utility.set_location('Multiple rate',111);

5651: open c_multiple_rate;
5652: fetch c_multiple_rate into l_multiple_rate;
5653: if c_multiple_rate%found then
5654: --
5655: hr_utility.set_location('Multiple rate',111);
5656: insert into BEN_LE_CLSN_N_RSTR (
5657: BKUP_TBL_TYP_CD,
5658: BKUP_TBL_ID,
5659: per_in_ler_id,

Line 5722: hr_utility.set_location('l_prv_pen.effective_start_date'||l_prv_pen.effective_start_date,1999);

5718: -- may be 11-nov-99, but the rate may start on 01-jan-00.
5719: -- Passing 11-nov-99 as effective date may cause no
5720: -- element entry row found problems.
5721: --
5722: hr_utility.set_location('l_prv_pen.effective_start_date'||l_prv_pen.effective_start_date,1999);
5723: hr_utility.set_location('l_rt_strt_dt'||l_rt_strt_dt,1999);
5724: if l_prv_pen.effective_start_date < l_rt_strt_dt then
5725: l_prv_effective_date := l_rt_strt_dt;
5726: else

Line 5723: hr_utility.set_location('l_rt_strt_dt'||l_rt_strt_dt,1999);

5719: -- Passing 11-nov-99 as effective date may cause no
5720: -- element entry row found problems.
5721: --
5722: hr_utility.set_location('l_prv_pen.effective_start_date'||l_prv_pen.effective_start_date,1999);
5723: hr_utility.set_location('l_rt_strt_dt'||l_rt_strt_dt,1999);
5724: if l_prv_pen.effective_start_date < l_rt_strt_dt then
5725: l_prv_effective_date := l_rt_strt_dt;
5726: else
5727: l_prv_effective_date := l_prv_pen.effective_start_date;

Line 5835: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);

5831: --
5832: open c_prv_ovn (l_rt_adj.bkup_tbl_id);
5833: fetch c_prv_ovn into l_object_version_number;
5834: close c_prv_ovn;
5835: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);
5836: hr_utility.set_location('p_effective_date '||p_effective_date,10);
5837: hr_utility.set_location('l_rt_adj'||l_rt_adj.effective_start_date,10);
5838: hr_utility.set_location('l_object_version_number'||l_object_version_number,10);
5839: --

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

5832: open c_prv_ovn (l_rt_adj.bkup_tbl_id);
5833: fetch c_prv_ovn into l_object_version_number;
5834: close c_prv_ovn;
5835: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);
5836: hr_utility.set_location('p_effective_date '||p_effective_date,10);
5837: hr_utility.set_location('l_rt_adj'||l_rt_adj.effective_start_date,10);
5838: hr_utility.set_location('l_object_version_number'||l_object_version_number,10);
5839: --
5840: adj_prv_rate (p_person_id => l_rt_adj.person_id,

Line 5837: hr_utility.set_location('l_rt_adj'||l_rt_adj.effective_start_date,10);

5833: fetch c_prv_ovn into l_object_version_number;
5834: close c_prv_ovn;
5835: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);
5836: hr_utility.set_location('p_effective_date '||p_effective_date,10);
5837: hr_utility.set_location('l_rt_adj'||l_rt_adj.effective_start_date,10);
5838: hr_utility.set_location('l_object_version_number'||l_object_version_number,10);
5839: --
5840: adj_prv_rate (p_person_id => l_rt_adj.person_id,
5841: p_prtt_rt_val_id => l_rt_adj.bkup_tbl_id,

Line 5838: hr_utility.set_location('l_object_version_number'||l_object_version_number,10);

5834: close c_prv_ovn;
5835: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);
5836: hr_utility.set_location('p_effective_date '||p_effective_date,10);
5837: hr_utility.set_location('l_rt_adj'||l_rt_adj.effective_start_date,10);
5838: hr_utility.set_location('l_object_version_number'||l_object_version_number,10);
5839: --
5840: adj_prv_rate (p_person_id => l_rt_adj.person_id,
5841: p_prtt_rt_val_id => l_rt_adj.bkup_tbl_id,
5842: p_rt_end_dt => l_rt_adj.RT_END_DT,

Line 5865: hr_utility.set_location('prv 0 '||l_prv_bckdt.prtt_rt_val_id,10);

5861: loop
5862: fetch c_prv_of_previous_pil into l_prv_bckdt;
5863: exit when c_prv_of_previous_pil%notfound;
5864: --
5865: hr_utility.set_location('prv 0 '||l_prv_bckdt.prtt_rt_val_id,10);
5866: hr_utility.set_location('prv 1 '||l_prv_bckdt.acty_base_rt_id,10);
5867: l_prv_pen.effective_start_date := null;
5868: open c_prv_pen(l_prv_bckdt.prtt_enrt_rslt_id, l_prv_bckdt.rt_strt_dt);
5869: fetch c_prv_pen into l_prv_pen;

Line 5866: hr_utility.set_location('prv 1 '||l_prv_bckdt.acty_base_rt_id,10);

5862: fetch c_prv_of_previous_pil into l_prv_bckdt;
5863: exit when c_prv_of_previous_pil%notfound;
5864: --
5865: hr_utility.set_location('prv 0 '||l_prv_bckdt.prtt_rt_val_id,10);
5866: hr_utility.set_location('prv 1 '||l_prv_bckdt.acty_base_rt_id,10);
5867: l_prv_pen.effective_start_date := null;
5868: open c_prv_pen(l_prv_bckdt.prtt_enrt_rslt_id, l_prv_bckdt.rt_strt_dt);
5869: fetch c_prv_pen into l_prv_pen;
5870: close c_prv_pen;

Line 5910: hr_utility.set_location('l_rt_end_dt '||l_rt_end_dt,10);

5906: fetch c_get_bckdt_prv into l_bckdt_prv_rec;
5907: if c_get_bckdt_prv%found then
5908: l_rt_end_dt := l_bckdt_prv_rec.rt_end_dt;
5909: l_ended_per_in_ler_id := l_bckdt_prv_rec.per_in_ler_ended_id;
5910: hr_utility.set_location('l_rt_end_dt '||l_rt_end_dt,10);
5911: hr_utility.set_location('l_ended_per_in_ler_id '||l_ended_per_in_ler_id,10);
5912: end if;
5913: close c_get_bckdt_prv;
5914: end if;

Line 5911: hr_utility.set_location('l_ended_per_in_ler_id '||l_ended_per_in_ler_id,10);

5907: if c_get_bckdt_prv%found then
5908: l_rt_end_dt := l_bckdt_prv_rec.rt_end_dt;
5909: l_ended_per_in_ler_id := l_bckdt_prv_rec.per_in_ler_ended_id;
5910: hr_utility.set_location('l_rt_end_dt '||l_rt_end_dt,10);
5911: hr_utility.set_location('l_ended_per_in_ler_id '||l_ended_per_in_ler_id,10);
5912: end if;
5913: close c_get_bckdt_prv;
5914: end if;
5915: --

Line 5933: hr_utility.set_location('Ajdust rate end date'||l_prv_bckdt.prtt_rt_val_id,10);

5929: ,p_effective_date => l_prv_pen.effective_start_date);
5930:
5931: /* added 'if' condition for Bug 12576710. Adjust the rate from the backup table after rate is updated */
5932: if(l_prv_bckdt.adj_rec = 2 )then
5933: hr_utility.set_location('Ajdust rate end date'||l_prv_bckdt.prtt_rt_val_id,10);
5934: open c_adj_rate_curr_per_in_ler (p_per_in_ler_id,l_prv_bckdt.prtt_rt_val_id);
5935: fetch c_adj_rate_curr_per_in_ler into l_rt_adj;
5936: if(c_adj_rate_curr_per_in_ler%found) then
5937: open c_prv_ovn (l_rt_adj.bkup_tbl_id);

Line 5940: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);

5936: if(c_adj_rate_curr_per_in_ler%found) then
5937: open c_prv_ovn (l_rt_adj.bkup_tbl_id);
5938: fetch c_prv_ovn into l_object_version_number;
5939: close c_prv_ovn;
5940: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);
5941: --
5942: adj_prv_rate (p_person_id => l_rt_adj.person_id,
5943: p_prtt_rt_val_id => l_rt_adj.bkup_tbl_id,
5944: p_rt_end_dt => l_rt_adj.RT_END_DT,

Line 5973: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);

5969: --
5970: open c_prv_ovn (l_rt_adj.bkup_tbl_id);
5971: fetch c_prv_ovn into l_object_version_number;
5972: close c_prv_ovn;
5973: hr_utility.set_location('Ajdust rate end date'||l_rt_adj.bkup_tbl_id,10);
5974: --
5975: adj_prv_rate (p_person_id => l_rt_adj.person_id,
5976: p_prtt_rt_val_id => l_rt_adj.bkup_tbl_id,
5977: p_rt_end_dt => l_rt_adj.RT_END_DT,

Line 5991: hr_utility.set_location( 'backing out BEN_PRTT_ENRT_RSLT_F ' || p_per_in_ler_id , 99 );

5987: --
5988:
5989: elsif p_routine = 'BEN_PRTT_ENRT_RSLT_F' then
5990:
5991: hr_utility.set_location( 'backing out BEN_PRTT_ENRT_RSLT_F ' || p_per_in_ler_id , 99 );
5992: hr_utility.set_location( 'p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id , 99 );
5993: -- Results need to be 'un-ended' if they were ended due to this
5994: -- per-in-ler. The 'future change' date track mode handles that.
5995:

Line 5992: hr_utility.set_location( 'p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id , 99 );

5988:
5989: elsif p_routine = 'BEN_PRTT_ENRT_RSLT_F' then
5990:
5991: hr_utility.set_location( 'backing out BEN_PRTT_ENRT_RSLT_F ' || p_per_in_ler_id , 99 );
5992: hr_utility.set_location( 'p_bckdt_prtt_enrt_rslt_id ' || p_bckdt_prtt_enrt_rslt_id , 99 );
5993: -- Results need to be 'un-ended' if they were ended due to this
5994: -- per-in-ler. The 'future change' date track mode handles that.
5995:
5996: -- Results that were created due to this per-in-ler need to be marked 'backed out'.

Line 6057: hr_utility.set_location( 'Effective_date ' || l_effective_date , 99 );

6053: -- The group function "max" returns null when no records found,
6054: -- so check l_effective_date is null to find whether any
6055: -- past records were found.
6056: --
6057: hr_utility.set_location( 'Effective_date ' || l_effective_date , 99 );
6058: hr_utility.set_location( 'l_prev_pk_id ' || l_prev_pk_id , 99 );
6059: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 99 );
6060: -- changed 7176884 begin
6061: --

Line 6058: hr_utility.set_location( 'l_prev_pk_id ' || l_prev_pk_id , 99 );

6054: -- so check l_effective_date is null to find whether any
6055: -- past records were found.
6056: --
6057: hr_utility.set_location( 'Effective_date ' || l_effective_date , 99 );
6058: hr_utility.set_location( 'l_prev_pk_id ' || l_prev_pk_id , 99 );
6059: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 99 );
6060: -- changed 7176884 begin
6061: --
6062: hr_utility.set_location( 'p_per_in_ler_id ' || p_per_in_ler_id , 44333 );

Line 6059: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 99 );

6055: -- past records were found.
6056: --
6057: hr_utility.set_location( 'Effective_date ' || l_effective_date , 99 );
6058: hr_utility.set_location( 'l_prev_pk_id ' || l_prev_pk_id , 99 );
6059: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 99 );
6060: -- changed 7176884 begin
6061: --
6062: hr_utility.set_location( 'p_per_in_ler_id ' || p_per_in_ler_id , 44333 );
6063: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 44333 );

Line 6062: hr_utility.set_location( 'p_per_in_ler_id ' || p_per_in_ler_id , 44333 );

6058: hr_utility.set_location( 'l_prev_pk_id ' || l_prev_pk_id , 99 );
6059: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 99 );
6060: -- changed 7176884 begin
6061: --
6062: hr_utility.set_location( 'p_per_in_ler_id ' || p_per_in_ler_id , 44333 );
6063: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 44333 );
6064: --
6065: open c_get_enrt_mthd_cd(l_pk_id);
6066: fetch c_get_enrt_mthd_cd into l_get_enrt_mthd_cd;

Line 6063: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 44333 );

6059: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 99 );
6060: -- changed 7176884 begin
6061: --
6062: hr_utility.set_location( 'p_per_in_ler_id ' || p_per_in_ler_id , 44333 );
6063: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 44333 );
6064: --
6065: open c_get_enrt_mthd_cd(l_pk_id);
6066: fetch c_get_enrt_mthd_cd into l_get_enrt_mthd_cd;
6067: close c_get_enrt_mthd_cd;

Line 6069: hr_utility.set_location( 'l_get_enrt_mthd_cd ' || l_get_enrt_mthd_cd , 44333 );

6065: open c_get_enrt_mthd_cd(l_pk_id);
6066: fetch c_get_enrt_mthd_cd into l_get_enrt_mthd_cd;
6067: close c_get_enrt_mthd_cd;
6068: --
6069: hr_utility.set_location( 'l_get_enrt_mthd_cd ' || l_get_enrt_mthd_cd , 44333 );
6070: -- changed 7176884 end
6071:
6072: if l_effective_date is not null then
6073: --

Line 6078: hr_utility.set_location('l_prev_pk_id <> l_pk_id = ' || l_prev_pk_id || ' <> ' || l_pk_id, 999);

6074: -- Do not process the row as it is already processed(deleted).
6075: --
6076: if l_prev_pk_id <> l_pk_id then
6077:
6078: hr_utility.set_location('l_prev_pk_id <> l_pk_id = ' || l_prev_pk_id || ' <> ' || l_pk_id, 999);
6079: hr_utility.set_location( 'l_effective_date ' || l_effective_date , 99 );
6080:
6081: -- now backup all the deleted enrollment rows
6082: --

Line 6079: hr_utility.set_location( 'l_effective_date ' || l_effective_date , 99 );

6075: --
6076: if l_prev_pk_id <> l_pk_id then
6077:
6078: hr_utility.set_location('l_prev_pk_id <> l_pk_id = ' || l_prev_pk_id || ' <> ' || l_pk_id, 999);
6079: hr_utility.set_location( 'l_effective_date ' || l_effective_date , 99 );
6080:
6081: -- now backup all the deleted enrollment rows
6082: --
6083: for l_deleted_pen_rec in c_deleted_pen(l_pk_id, l_effective_date)

Line 6087: hr_utility.set_location( ' backup pil ' || l_deleted_pen_rec.PER_IN_LER_ID , 99 );

6083: for l_deleted_pen_rec in c_deleted_pen(l_pk_id, l_effective_date)
6084: loop
6085: --
6086: --
6087: hr_utility.set_location( ' backup pil ' || l_deleted_pen_rec.PER_IN_LER_ID , 99 );
6088: hr_utility.set_location( ' backup pen ' || l_deleted_pen_rec.PRTT_ENRT_RSLT_ID , 99 );
6089: open c_bkp_row('BEN_PRTT_ENRT_RSLT_F',
6090: l_deleted_pen_rec.PER_IN_LER_ID,
6091: l_deleted_pen_rec.PRTT_ENRT_RSLT_ID,

Line 6088: hr_utility.set_location( ' backup pen ' || l_deleted_pen_rec.PRTT_ENRT_RSLT_ID , 99 );

6084: loop
6085: --
6086: --
6087: hr_utility.set_location( ' backup pil ' || l_deleted_pen_rec.PER_IN_LER_ID , 99 );
6088: hr_utility.set_location( ' backup pen ' || l_deleted_pen_rec.PRTT_ENRT_RSLT_ID , 99 );
6089: open c_bkp_row('BEN_PRTT_ENRT_RSLT_F',
6090: l_deleted_pen_rec.PER_IN_LER_ID,
6091: l_deleted_pen_rec.PRTT_ENRT_RSLT_ID,
6092: l_deleted_pen_rec.object_version_number);

Line 6098: hr_utility.set_location( ' copying ' || l_deleted_pen_rec.PRTT_ENRT_RSLT_ID , 99 );

6094: --
6095: if c_bkp_row%notfound
6096: then
6097: --
6098: hr_utility.set_location( ' copying ' || l_deleted_pen_rec.PRTT_ENRT_RSLT_ID , 99 );
6099: close c_bkp_row;
6100: --
6101: insert into BEN_LE_CLSN_N_RSTR (
6102: BKUP_TBL_TYP_CD,

Line 6362: hr_utility.set_location( 'corrected result exist ' || l_dummy , 99 );

6358: open c_corr_result_exist (p_per_in_ler_id ,
6359: l_pk_id ) ;
6360: fetch c_corr_result_exist into l_dummy ;
6361: close c_corr_result_exist ;
6362: hr_utility.set_location( 'corrected result exist ' || l_dummy , 99 );
6363:
6364: if l_effective_date <> hr_api.g_eot and l_dummy is null and nvl(p_copy_only,'N') <> 'Y' then
6365: ben_prtt_enrt_result_api.delete_prtt_enrt_result
6366: (p_validate => false,

Line 6377: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 1999 );

6373: p_multi_row_validate => FALSE);
6374: end if;
6375:
6376: /* Added for Bug 8984394 */
6377: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 1999 );
6378: hr_utility.set_location( 'l_effective_end_date ' || l_effective_end_date , 1999 );
6379: if(l_effective_end_date = hr_api.g_eot) then
6380: /*Bug 9580432: Call update_epe procedure to update the epe record. Deleted the code and made a call
6381: to the procedure update_epe as the deleted code and procedure do the same thing ie update epe record

Line 6378: hr_utility.set_location( 'l_effective_end_date ' || l_effective_end_date , 1999 );

6374: end if;
6375:
6376: /* Added for Bug 8984394 */
6377: hr_utility.set_location( 'l_pk_id ' || l_pk_id , 1999 );
6378: hr_utility.set_location( 'l_effective_end_date ' || l_effective_end_date , 1999 );
6379: if(l_effective_end_date = hr_api.g_eot) then
6380: /*Bug 9580432: Call update_epe procedure to update the epe record. Deleted the code and made a call
6381: to the procedure update_epe as the deleted code and procedure do the same thing ie update epe record
6382: with the prtt_enrt_rslt_id*/

Line 6383: hr_utility.set_location(' Calling update_epe ',1999);

6379: if(l_effective_end_date = hr_api.g_eot) then
6380: /*Bug 9580432: Call update_epe procedure to update the epe record. Deleted the code and made a call
6381: to the procedure update_epe as the deleted code and procedure do the same thing ie update epe record
6382: with the prtt_enrt_rslt_id*/
6383: hr_utility.set_location(' Calling update_epe ',1999);
6384: update_epe(p_prtt_enrt_rslt_id=> l_pk_id,
6385: p_effective_date => l_effective_start_date,
6386: p_per_in_ler_id => p_per_in_ler_id) ;
6387: end if;

Line 6440: hr_utility.set_location('l_pk_id = ' || l_pk_id ,99);

6436:
6437: -- 2982606 if the update for the result level then copy the record to the
6438: -- backup table
6439: if p_bckdt_prtt_enrt_rslt_id is not null then
6440: hr_utility.set_location('l_pk_id = ' || l_pk_id ,99);
6441: hr_utility.set_location('l_pen_esd = ' || l_pen_esd ,99);
6442:
6443: -- now backup all the deleted enrollment rows
6444: --

Line 6441: hr_utility.set_location('l_pen_esd = ' || l_pen_esd ,99);

6437: -- 2982606 if the update for the result level then copy the record to the
6438: -- backup table
6439: if p_bckdt_prtt_enrt_rslt_id is not null then
6440: hr_utility.set_location('l_pk_id = ' || l_pk_id ,99);
6441: hr_utility.set_location('l_pen_esd = ' || l_pen_esd ,99);
6442:
6443: -- now backup all the deleted enrollment rows
6444: --
6445: for l_deleted_pen_rec in c_deleted_pen(l_pk_id, l_pen_esd)

Line 6459: hr_utility.set_location(' creating backup ' || l_pk_id, 999);

6455: if c_bkp_row%notfound
6456: then
6457: --
6458: close c_bkp_row;
6459: hr_utility.set_location(' creating backup ' || l_pk_id, 999);
6460: insert into BEN_LE_CLSN_N_RSTR (
6461: BKUP_TBL_TYP_CD,
6462: COMP_LVL_CD,
6463: LCR_ATTRIBUTE16,

Line 6782: hr_utility.set_location(' not found ' || l_cvg_thru_dt, 99 );

6778: open c_get_cvg_thru_dt(i.bkup_tbl_id
6779: ,i.effective_start_date);
6780: fetch c_get_cvg_thru_dt into l_cvg_thru_dt, l_prtt_enrt_rslt_stat_cd;
6781: if c_get_cvg_thru_dt%notfound then
6782: hr_utility.set_location(' not found ' || l_cvg_thru_dt, 99 );
6783: l_cvg_thru_dt := i.enrt_cvg_thru_dt;
6784: l_prtt_enrt_rslt_stat_cd := i.prtt_enrt_rslt_stat_cd;
6785: end if;
6786: close c_get_cvg_thru_dt;

Line 6788: hr_utility.set_location(' l_cvg_thru_dt ' || l_cvg_thru_dt, 99 );

6784: l_prtt_enrt_rslt_stat_cd := i.prtt_enrt_rslt_stat_cd;
6785: end if;
6786: close c_get_cvg_thru_dt;
6787: --
6788: hr_utility.set_location(' l_cvg_thru_dt ' || l_cvg_thru_dt, 99 );
6789: hr_utility.set_location(' l_prtt_enrt_rslt_stat_cd' || l_prtt_enrt_rslt_stat_cd, 99 );
6790: --
6791: -- end 8199189
6792: --

Line 6789: hr_utility.set_location(' l_prtt_enrt_rslt_stat_cd' || l_prtt_enrt_rslt_stat_cd, 99 );

6785: end if;
6786: close c_get_cvg_thru_dt;
6787: --
6788: hr_utility.set_location(' l_cvg_thru_dt ' || l_cvg_thru_dt, 99 );
6789: hr_utility.set_location(' l_prtt_enrt_rslt_stat_cd' || l_prtt_enrt_rslt_stat_cd, 99 );
6790: --
6791: -- end 8199189
6792: --
6793: hr_utility.set_location(' corrected result ' || i.bkup_tbl_id, 99 );

Line 6793: hr_utility.set_location(' corrected result ' || i.bkup_tbl_id, 99 );

6789: hr_utility.set_location(' l_prtt_enrt_rslt_stat_cd' || l_prtt_enrt_rslt_stat_cd, 99 );
6790: --
6791: -- end 8199189
6792: --
6793: hr_utility.set_location(' corrected result ' || i.bkup_tbl_id, 99 );
6794: if l_prev_bkup_tbl_id <> i.bkup_tbl_id and nvl(p_copy_only,'N') <> 'Y' then
6795:
6796: l_object_version_number := i.object_version_number ;
6797: --bug#5032364

Line 6821: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );

6817: -- Bug 7197868
6818: --
6819: if (i.effective_end_date = hr_api.g_eot
6820: and i.pen_effective_end_date <> i.effective_end_date) then
6821: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6822: --
6823: -- Bug 7197868
6824: --
6825: -- Delete future dated records.

Line 6859: hr_utility.set_location(' Calling update_epe ',1998);

6855: end if;
6856:
6857: /*Bug 9580432 :Call the procedure update_epe to update the epe record of the previous Life Event
6858: with the prtt_enrt_rslt_id of the reopened result */
6859: hr_utility.set_location(' Calling update_epe ',1998);
6860: update_epe(p_prtt_enrt_rslt_id=> i.bkup_tbl_id,
6861: p_effective_date => i.effective_start_date,
6862: p_per_in_ler_id => p_per_in_ler_id) ;
6863:

Line 6873: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );

6869: --
6870: if ((i.effective_end_date = hr_api.g_eot
6871: and i.pen_effective_end_date <> i.effective_end_date)
6872: or (l_prtt_enrt_rslt_stat_cd = 'VOIDD')) then -- 8199189
6873: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6874: hr_utility.set_location(' i.per_in_ler_id ' || i.per_in_ler_id, 999 );
6875: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );
6876: delete from ben_le_clsn_n_rstr cqb
6877: where cqb.per_in_ler_id = i.per_in_ler_id

Line 6874: hr_utility.set_location(' i.per_in_ler_id ' || i.per_in_ler_id, 999 );

6870: if ((i.effective_end_date = hr_api.g_eot
6871: and i.pen_effective_end_date <> i.effective_end_date)
6872: or (l_prtt_enrt_rslt_stat_cd = 'VOIDD')) then -- 8199189
6873: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6874: hr_utility.set_location(' i.per_in_ler_id ' || i.per_in_ler_id, 999 );
6875: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );
6876: delete from ben_le_clsn_n_rstr cqb
6877: where cqb.per_in_ler_id = i.per_in_ler_id
6878: and cqb.per_in_ler_ended_id = p_per_in_ler_id

Line 6875: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );

6871: and i.pen_effective_end_date <> i.effective_end_date)
6872: or (l_prtt_enrt_rslt_stat_cd = 'VOIDD')) then -- 8199189
6873: hr_utility.set_location(' correcting ' || i.bkup_tbl_id, 999 );
6874: hr_utility.set_location(' i.per_in_ler_id ' || i.per_in_ler_id, 999 );
6875: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );
6876: delete from ben_le_clsn_n_rstr cqb
6877: where cqb.per_in_ler_id = i.per_in_ler_id
6878: and cqb.per_in_ler_ended_id = p_per_in_ler_id
6879: and cqb.bkup_tbl_id = i.bkup_tbl_id ;

Line 6881: hr_utility.set_location(' enrt_rslt_id' || i.bkup_tbl_id, 999 );

6877: where cqb.per_in_ler_id = i.per_in_ler_id
6878: and cqb.per_in_ler_ended_id = p_per_in_ler_id
6879: and cqb.bkup_tbl_id = i.bkup_tbl_id ;
6880: else
6881: hr_utility.set_location(' enrt_rslt_id' || i.bkup_tbl_id, 999 );
6882: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );
6883: hr_utility.set_location(' i.effective_start_date ' || i.effective_start_date, 999 );
6884: --
6885: update ben_le_clsn_n_rstr cqb

Line 6882: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );

6878: and cqb.per_in_ler_ended_id = p_per_in_ler_id
6879: and cqb.bkup_tbl_id = i.bkup_tbl_id ;
6880: else
6881: hr_utility.set_location(' enrt_rslt_id' || i.bkup_tbl_id, 999 );
6882: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );
6883: hr_utility.set_location(' i.effective_start_date ' || i.effective_start_date, 999 );
6884: --
6885: update ben_le_clsn_n_rstr cqb
6886: set cqb.per_in_ler_id = p_per_in_ler_id

Line 6883: hr_utility.set_location(' i.effective_start_date ' || i.effective_start_date, 999 );

6879: and cqb.bkup_tbl_id = i.bkup_tbl_id ;
6880: else
6881: hr_utility.set_location(' enrt_rslt_id' || i.bkup_tbl_id, 999 );
6882: hr_utility.set_location(' p_per_in_ler_id ' || p_per_in_ler_id, 999 );
6883: hr_utility.set_location(' i.effective_start_date ' || i.effective_start_date, 999 );
6884: --
6885: update ben_le_clsn_n_rstr cqb
6886: set cqb.per_in_ler_id = p_per_in_ler_id
6887: , cqb.per_in_ler_ended_id = null

Line 6920: hr_utility.set_location(' delete result ' || i.bkup_tbl_id, 99 );

6916: will not be NULL), do not call delete enrollment for backup records that exists in the backup table */
6917: if(p_bckdt_prtt_enrt_rslt_id is NULL) then
6918: for i in c_BEN_LE_CLSN_N_RSTR_del(p_per_in_ler_id)
6919: Loop
6920: hr_utility.set_location(' delete result ' || i.bkup_tbl_id, 99 );
6921: if l_prev_bkup_tbl_id <> i.bkup_tbl_id then
6922:
6923: l_object_version_number := i.object_version_number ;
6924: --bug#5032364

Line 6962: hr_utility.set_location('Ajdust coverage for '||l_cvg_adj.bkup_tbl_id,44333);

6958: l_cvg_adj_effective_date := null;
6959: open c_pen_ovn (l_cvg_adj.bkup_tbl_id);
6960: fetch c_pen_ovn into l_object_version_number,l_cvg_adj_effective_date;
6961: close c_pen_ovn;
6962: hr_utility.set_location('Ajdust coverage for '||l_cvg_adj.bkup_tbl_id,44333);
6963: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);
6964: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);
6965: --
6966: --

Line 6963: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);

6959: open c_pen_ovn (l_cvg_adj.bkup_tbl_id);
6960: fetch c_pen_ovn into l_object_version_number,l_cvg_adj_effective_date;
6961: close c_pen_ovn;
6962: hr_utility.set_location('Ajdust coverage for '||l_cvg_adj.bkup_tbl_id,44333);
6963: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);
6964: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);
6965: --
6966: --
6967: /*Bug 9664943: Check l_cvg_adj_effective_date is not null before adjusting coverage*/

Line 6964: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);

6960: fetch c_pen_ovn into l_object_version_number,l_cvg_adj_effective_date;
6961: close c_pen_ovn;
6962: hr_utility.set_location('Ajdust coverage for '||l_cvg_adj.bkup_tbl_id,44333);
6963: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);
6964: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);
6965: --
6966: --
6967: /*Bug 9664943: Check l_cvg_adj_effective_date is not null before adjusting coverage*/
6968: if l_cvg_adj_effective_date is not null then

Line 6998: hr_utility.set_location('Ajdust coverage for ended per_in_ler'||l_cvg_adj.bkup_tbl_id,44333);

6994: --
6995: open c_pen_ovn (l_cvg_adj.bkup_tbl_id);
6996: fetch c_pen_ovn into l_object_version_number,l_cvg_adj_effective_date;
6997: close c_pen_ovn;
6998: hr_utility.set_location('Ajdust coverage for ended per_in_ler'||l_cvg_adj.bkup_tbl_id,44333);
6999: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);
7000: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);
7001: --
7002: --

Line 6999: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);

6995: open c_pen_ovn (l_cvg_adj.bkup_tbl_id);
6996: fetch c_pen_ovn into l_object_version_number,l_cvg_adj_effective_date;
6997: close c_pen_ovn;
6998: hr_utility.set_location('Ajdust coverage for ended per_in_ler'||l_cvg_adj.bkup_tbl_id,44333);
6999: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);
7000: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);
7001: --
7002: --
7003: adj_pen_cvg (p_person_id => l_cvg_adj.person_id,

Line 7000: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);

6996: fetch c_pen_ovn into l_object_version_number,l_cvg_adj_effective_date;
6997: close c_pen_ovn;
6998: hr_utility.set_location('Ajdust coverage for ended per_in_ler'||l_cvg_adj.bkup_tbl_id,44333);
6999: hr_utility.set_location('l_rt_adj'||l_cvg_adj_effective_date,44333);
7000: hr_utility.set_location('l_object_version_number'||l_object_version_number,44333);
7001: --
7002: --
7003: adj_pen_cvg (p_person_id => l_cvg_adj.person_id,
7004: p_prtt_enrt_rslt_id => l_cvg_adj.bkup_tbl_id,

Line 7025: hr_utility.set_location('ACE p_per_in_ler_id = ' || p_per_in_ler_id, 9999);

7021: -- Such BPL Records have been backed up in BEN_LE_CLSN_N_RSTR. See BEN_BPL_DEL.POST_DELETE
7022: -- The part of the code below (which queries cursor c_ben_bnft_prvdd_ldgr_f) takes care of rest
7023: -- of the scenarios and voiding of BPL associated with the life-event being backed out.
7024: --
7025: hr_utility.set_location('ACE p_per_in_ler_id = ' || p_per_in_ler_id, 9999);
7026: --
7027: for l_bpl_from_backup in c_bpl_from_backup
7028: loop
7029: --

Line 7030: hr_utility.set_location('ACE l_bpl_from_backup.bnft_prvdd_ldgr_id = ' || l_bpl_from_backup.BKUP_TBL_ID, 9999);

7026: --
7027: for l_bpl_from_backup in c_bpl_from_backup
7028: loop
7029: --
7030: hr_utility.set_location('ACE l_bpl_from_backup.bnft_prvdd_ldgr_id = ' || l_bpl_from_backup.BKUP_TBL_ID, 9999);
7031: --
7032: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger
7033: (
7034: p_bnft_prvdd_ldgr_id => l_bpl_from_backup.BKUP_TBL_ID,

Line 7042: hr_utility.set_location('ACE Reopened = ' || l_bpl_from_backup.BKUP_TBL_ID, 9999);

7038: p_effective_date => l_bpl_from_backup.effective_start_date,
7039: p_datetrack_mode => hr_api.g_FUTURE_CHANGE,
7040: p_business_group_id => p_business_group_id
7041: );
7042: hr_utility.set_location('ACE Reopened = ' || l_bpl_from_backup.BKUP_TBL_ID, 9999);
7043: --
7044: -- Bug 6376239 : Remove the rows from backup table once the ledger rows are restored
7045: --
7046: delete from ben_le_clsn_n_rstr cls

Line 7090: hr_utility.set_location('Deleting ledger='||to_char(l_bpl.bnft_prvdd_ldgr_id), 50);

7086: l_object_version_number := l_max_object_version_number;
7087: --
7088: if l_effective_date <> hr_api.g_eot and nvl(p_copy_only,'N') <> 'Y' then
7089: --
7090: hr_utility.set_location('Deleting ledger='||to_char(l_bpl.bnft_prvdd_ldgr_id), 50);
7091: --
7092: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
7093: p_bnft_prvdd_ldgr_id => l_bpl.bnft_prvdd_ldgr_id,
7094: p_effective_start_date => l_bpl.effective_start_date,

Line 7112: hr_utility.set_location('ledger Id'||l_bpl.bnft_prvdd_ldgr_id,11);

7108: -- added if condition to check if there is any update for the same per_in_ler
7109: if l_prev_pk_id <> l_pk_id and nvl(p_copy_only,'N') <> 'Y' then
7110: --
7111: l_bpl_effective_date := l_bpl.effective_start_date ;
7112: hr_utility.set_location('ledger Id'||l_bpl.bnft_prvdd_ldgr_id,11);
7113: hr_utility.set_location('ovn Id'||l_bpl.object_version_number,11);
7114: --
7115: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
7116: p_bnft_prvdd_ldgr_id => l_bpl.bnft_prvdd_ldgr_id,

Line 7113: hr_utility.set_location('ovn Id'||l_bpl.object_version_number,11);

7109: if l_prev_pk_id <> l_pk_id and nvl(p_copy_only,'N') <> 'Y' then
7110: --
7111: l_bpl_effective_date := l_bpl.effective_start_date ;
7112: hr_utility.set_location('ledger Id'||l_bpl.bnft_prvdd_ldgr_id,11);
7113: hr_utility.set_location('ovn Id'||l_bpl.object_version_number,11);
7114: --
7115: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger(
7116: p_bnft_prvdd_ldgr_id => l_bpl.bnft_prvdd_ldgr_id,
7117: p_effective_start_date => l_bpl.effective_start_date,

Line 7242: hr_utility.set_location ('End of '||p_routine,10);

7238: raise ben_manage_life_events.g_record_error;
7239:
7240: end if;
7241: --
7242: hr_utility.set_location ('End of '||p_routine,10);
7243: hr_utility.set_location ('Leaving '||l_package,10);
7244: --
7245: exception
7246: when others then

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

7239:
7240: end if;
7241: --
7242: hr_utility.set_location ('End of '||p_routine,10);
7243: hr_utility.set_location ('Leaving '||l_package,10);
7244: --
7245: exception
7246: when others then
7247: --