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

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

811: --Bug 6133258
812: --
813: BEGIN
814: --
815: hr_utility.set_location ('Entering '||l_package,10);
816: hr_utility.set_location ('ler date '||l_effective_date,10);
817: --
818: -- Edit to ensure that the input p_effective_date has a value
819: --

Line 816: hr_utility.set_location ('ler date '||l_effective_date,10);

812: --
813: BEGIN
814: --
815: hr_utility.set_location ('Entering '||l_package,10);
816: hr_utility.set_location ('ler date '||l_effective_date,10);
817: --
818: -- Edit to ensure that the input p_effective_date has a value
819: --
820: If p_effective_date is null then

Line 838: hr_utility.set_location (l_package,20);

834: fnd_message.raise_error;
835: --
836: end if;
837: --
838: hr_utility.set_location (l_package,20);
839: --
840: -- Get the active per in ler id.
841: --
842: open c_pil;

Line 848: hr_utility.set_location ('Before loop '||l_package,25);

844: close c_pil;
845: --
846: -- Get all electbale choices for the per in ler.
847: --
848: hr_utility.set_location ('Before loop '||l_package,25);
849: --
850: open c_epe(l_pil.per_in_ler_id);
851: --
852: loop

Line 854: hr_utility.set_location ('In loop '||l_package,30);

850: open c_epe(l_pil.per_in_ler_id);
851: --
852: loop
853: --
854: hr_utility.set_location ('In loop '||l_package,30);
855: --
856: fetch c_epe into l_epe;
857: exit when c_epe%notfound;
858: hr_utility.set_location('Found an epe', 32);

Line 858: hr_utility.set_location('Found an epe', 32);

854: hr_utility.set_location ('In loop '||l_package,30);
855: --
856: fetch c_epe into l_epe;
857: exit when c_epe%notfound;
858: hr_utility.set_location('Found an epe', 32);
859: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
860: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
861: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
862: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

Line 859: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);

855: --
856: fetch c_epe into l_epe;
857: exit when c_epe%notfound;
858: hr_utility.set_location('Found an epe', 32);
859: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
860: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
861: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
862: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
863: --

Line 860: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);

856: fetch c_epe into l_epe;
857: exit when c_epe%notfound;
858: hr_utility.set_location('Found an epe', 32);
859: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
860: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
861: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
862: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
863: --
864: -- Initialize the variables.

Line 861: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);

857: exit when c_epe%notfound;
858: hr_utility.set_location('Found an epe', 32);
859: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
860: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
861: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
862: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
863: --
864: -- Initialize the variables.
865: --

Line 862: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

858: hr_utility.set_location('Found an epe', 32);
859: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
860: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
861: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
862: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
863: --
864: -- Initialize the variables.
865: --
866: l_pen_found := false;

Line 884: hr_utility.set_location('Max l_effective_date '||l_effective_date,123);

880: if l_epe.enrt_perd_strt_dt is not null then
881: l_effective_date := l_epe.enrt_perd_strt_dt ;
882: end if ;
883: --
884: hr_utility.set_location('Max l_effective_date '||l_effective_date,123);
885: --
886: -- Look for rate, benefit, premium changes only if the choice is
887: -- not electable (electable flag is off).
888: --

Line 889: hr_utility.set_location('elctbl_flag='||l_epe.elctbl_flag,1963);

885: --
886: -- Look for rate, benefit, premium changes only if the choice is
887: -- not electable (electable flag is off).
888: --
889: hr_utility.set_location('elctbl_flag='||l_epe.elctbl_flag,1963);
890: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
891: --
892: hr_utility.set_location ('An epe is not electable'||
893: to_char(l_epe.elig_per_elctbl_chc_id),35);

Line 892: hr_utility.set_location ('An epe is not electable'||

888: --
889: hr_utility.set_location('elctbl_flag='||l_epe.elctbl_flag,1963);
890: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
891: --
892: hr_utility.set_location ('An epe is not electable'||
893: to_char(l_epe.elig_per_elctbl_chc_id),35);
894: --
895: open c_pen;
896: fetch c_pen into l_pen;

Line 901: hr_utility.set_location('pen found',1963);

897: --
898: if c_pen%found then
899: --
900: l_pen_found := true;
901: hr_utility.set_location('pen found',1963);
902: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
903: --
904: else
905: hr_utility.set_location('pen not found',1963);

Line 902: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

898: if c_pen%found then
899: --
900: l_pen_found := true;
901: hr_utility.set_location('pen found',1963);
902: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
903: --
904: else
905: hr_utility.set_location('pen not found',1963);
906: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

Line 905: hr_utility.set_location('pen not found',1963);

901: hr_utility.set_location('pen found',1963);
902: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
903: --
904: else
905: hr_utility.set_location('pen not found',1963);
906: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
907: end if;
908: --
909: close c_pen;

Line 906: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

902: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
903: --
904: else
905: hr_utility.set_location('pen not found',1963);
906: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
907: end if;
908: --
909: close c_pen;
910: --

Line 915: hr_utility.set_location (l_package,40);

911: if l_pen_found then
912: --
913: -- Check for benefit amount changes.
914: --
915: hr_utility.set_location (l_package,40);
916: --
917: open c_enb;
918: fetch c_enb into l_enb;
919: --

Line 922: hr_utility.set_location('c_enb found enrt_bnft_id = ' || l_enb.enrt_bnft_id, 1999);

918: fetch c_enb into l_enb;
919: --
920: if c_enb%found then
921: --
922: hr_utility.set_location('c_enb found enrt_bnft_id = ' || l_enb.enrt_bnft_id, 1999);
923: hr_utility.set_location('c_enb found prtt_enrt_rslt_id = ' || l_enb.prtt_enrt_rslt_id, 1999);
924: l_enb_found := true;
925: --
926: open c_pl(l_epe.pl_id,nvl(l_epe.fonm_cvg_strt_dt,p_effective_date));

Line 923: hr_utility.set_location('c_enb found prtt_enrt_rslt_id = ' || l_enb.prtt_enrt_rslt_id, 1999);

919: --
920: if c_enb%found then
921: --
922: hr_utility.set_location('c_enb found enrt_bnft_id = ' || l_enb.enrt_bnft_id, 1999);
923: hr_utility.set_location('c_enb found prtt_enrt_rslt_id = ' || l_enb.prtt_enrt_rslt_id, 1999);
924: l_enb_found := true;
925: --
926: open c_pl(l_epe.pl_id,nvl(l_epe.fonm_cvg_strt_dt,p_effective_date));
927: fetch c_pl into l_pl;

Line 938: hr_utility.set_location('c_enb not found', 1999);

934: --
935: -- Reset bnft id to null, if bnft record does not exist.
936: --
937: -- Bug 4895872 - Nullify all member variables of L_ENB
938: hr_utility.set_location('c_enb not found', 1999);
939: l_enb.enrt_bnft_id := null;
940: l_enb.val := null;
941: l_enb.prtt_enrt_rslt_id := null;
942: l_enb.entr_val_at_enrt_flag := NULL;

Line 965: hr_utility.set_location('Old Amount '||l_pen.bnft_amt,10);

961: ben_manage_life_events.g_fonm_cvg_strt_dt :=
962: l_epe.fonm_cvg_strt_dt;
963: end if;
964:
965: hr_utility.set_location('Old Amount '||l_pen.bnft_amt,10);
966: hr_utility.set_location('New Amount '||l_enb.val,10);
967: --
968: -- Case B added for bug 4715688
969: -- Case C added for bug 4723828

Line 966: hr_utility.set_location('New Amount '||l_enb.val,10);

962: l_epe.fonm_cvg_strt_dt;
963: end if;
964:
965: hr_utility.set_location('Old Amount '||l_pen.bnft_amt,10);
966: hr_utility.set_location('New Amount '||l_enb.val,10);
967: --
968: -- Case B added for bug 4715688
969: -- Case C added for bug 4723828
970: -- Case : Same as Annualized Elected Activity Rate (SAAEAR) added for bug 5126800 - For this case

Line 1012: hr_utility.set_location (l_package,45);

1008: l_imp_changed := true;
1009: end if;
1010: close c_pl;
1011:
1012: hr_utility.set_location (l_package,45);
1013:
1014: ben_election_information.election_information
1015: (p_elig_per_elctbl_chc_id => l_epe.elig_per_elctbl_chc_id,
1016: p_prtt_enrt_rslt_id => l_pen.prtt_enrt_rslt_id,

Line 1077: hr_utility.set_location('pgm_id_table(l_pen.pgm_id) ' ||pgm_id_table(l_pen.pgm_id),10);

1073: --
1074: --Start Bug 5768795
1075: if((not pgm_id_table.exists(l_pen.pgm_id)) and l_pen.pgm_id is not null)then
1076: pgm_id_table(l_pen.pgm_id):=l_pen.pgm_id;
1077: hr_utility.set_location('pgm_id_table(l_pen.pgm_id) ' ||pgm_id_table(l_pen.pgm_id),10);
1078: end if;
1079: --End Bug 5768795
1080: --
1081: end if;

Line 1085: hr_utility.set_location ('Before Rates ',50);

1081: end if;
1082: --
1083: -- Look for rate changes.
1084: --
1085: hr_utility.set_location ('Before Rates ',50);
1086: --
1087: for l_ecr in c_ecr(l_epe.elig_per_elctbl_chc_id,
1088: l_enb.enrt_bnft_id) loop
1089: --

Line 1090: hr_utility.set_location ('In rates loop ',55);

1086: --
1087: for l_ecr in c_ecr(l_epe.elig_per_elctbl_chc_id,
1088: l_enb.enrt_bnft_id) loop
1089: --
1090: hr_utility.set_location ('In rates loop ',55);
1091: --
1092: if l_ecr.rt_strt_dt_cd is null then
1093: l_rt_strt_dt := l_ecr.rt_strt_dt;
1094: end if;

Line 1153: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);

1149: --
1150: -- Fix for WWBUG 1298556
1151: -- Check if activity changed.
1152: --
1153: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1154: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1155: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1156: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1157: -- Bug 2551834 If the ecr.val is null it fails

Line 1154: hr_utility.set_location('NEW RT'||l_ecr.val,10);

1150: -- Fix for WWBUG 1298556
1151: -- Check if activity changed.
1152: --
1153: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1154: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1155: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1156: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1157: -- Bug 2551834 If the ecr.val is null it fails
1158: -- Bug#2959410 - don't look for changes if the rate is enter value

Line 1155: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);

1151: -- Check if activity changed.
1152: --
1153: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1154: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1155: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1156: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1157: -- Bug 2551834 If the ecr.val is null it fails
1158: -- Bug#2959410 - don't look for changes if the rate is enter value
1159: -- at enrollment as the val will always be null

Line 1156: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);

1152: --
1153: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1154: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1155: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1156: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1157: -- Bug 2551834 If the ecr.val is null it fails
1158: -- Bug#2959410 - don't look for changes if the rate is enter value
1159: -- at enrollment as the val will always be null
1160: l_entr_val_at_enrt_flag := l_ecr.entr_val_at_enrt_flag;

Line 1235: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);

1231: fetch c_element_info into l_element_info;
1232: close c_element_info;
1233: end if;
1234:
1235: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1236: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1237: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1238: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1239: --

Line 1236: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);

1232: close c_element_info;
1233: end if;
1234:
1235: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1236: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1237: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1238: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1239: --
1240: -- get current element info

Line 1237: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);

1233: end if;
1234:
1235: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1236: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1237: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1238: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1239: --
1240: -- get current element info
1241: --

Line 1238: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);

1234:
1235: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1236: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1237: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1238: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1239: --
1240: -- get current element info
1241: --
1242: open c_abr(l_ecr.acty_base_rt_id,l_rt_strt_dt);

Line 1385: hr_utility.set_location ('Calling rate_info ',60);

1381: nvl(l_prv.tx_typ_cd,'-1') <> nvl(l_ecr.tx_typ_cd,'-1') or
1382: l_element_changed or
1383: l_bnft_changed then
1384: --
1385: hr_utility.set_location ('Calling rate_info ',60);
1386: hr_utility.set_location('rate change',13);
1387: --
1388: l_flex_call := true;
1389: ben_election_information.election_rate_information

Line 1386: hr_utility.set_location('rate change',13);

1382: l_element_changed or
1383: l_bnft_changed then
1384: --
1385: hr_utility.set_location ('Calling rate_info ',60);
1386: hr_utility.set_location('rate change',13);
1387: --
1388: l_flex_call := true;
1389: ben_election_information.election_rate_information
1390: (p_enrt_mthd_cd => l_pen.enrt_mthd_cd

Line 1418: hr_utility.set_location ('Before imputed and premium process ',65);

1414: end if; --Override if
1415: --
1416: end loop;
1417:
1418: hr_utility.set_location ('Before imputed and premium process ',65);
1419:
1420: if l_bnft_changed then
1421: -- if benefit amount changed, check to see if imputed
1422: -- income should also change.

Line 1501: hr_utility.set_location( 'prvdd val ' || l_prvdd_val , 1001);

1497: l_prtt_enrt_rslt_id_shell ) ;
1498: fetch c_bpl into l_prvdd_val ;
1499: close c_bpl ;
1500: --if there is amount change call the updating
1501: hr_utility.set_location( 'prvdd val ' || l_prvdd_val , 1001);
1502: hr_utility.set_location( 'changed val ' || i.val , 1001);
1503: hr_utility.set_location('Result id'||l_prtt_enrt_rslt_id_shell,1002);
1504:
1505:

Line 1502: hr_utility.set_location( 'changed val ' || i.val , 1001);

1498: fetch c_bpl into l_prvdd_val ;
1499: close c_bpl ;
1500: --if there is amount change call the updating
1501: hr_utility.set_location( 'prvdd val ' || l_prvdd_val , 1001);
1502: hr_utility.set_location( 'changed val ' || i.val , 1001);
1503: hr_utility.set_location('Result id'||l_prtt_enrt_rslt_id_shell,1002);
1504:
1505:
1506: if l_prvdd_val is not null and l_prvdd_val <> i.val then

Line 1503: hr_utility.set_location('Result id'||l_prtt_enrt_rslt_id_shell,1002);

1499: close c_bpl ;
1500: --if there is amount change call the updating
1501: hr_utility.set_location( 'prvdd val ' || l_prvdd_val , 1001);
1502: hr_utility.set_location( 'changed val ' || i.val , 1001);
1503: hr_utility.set_location('Result id'||l_prtt_enrt_rslt_id_shell,1002);
1504:
1505:
1506: if l_prvdd_val is not null and l_prvdd_val <> i.val then
1507: ben_provider_pools.create_credit_ledger_entry

Line 1569: hr_utility.set_location ('In Prem. loop ',70);

1565: -- If the benefit amount has changed, the premium would
1566: -- already have changed by the election_information call.
1567: for l_epr in c_epr(l_epe.elig_per_elctbl_chc_id,
1568: l_enb.enrt_bnft_id) loop
1569: hr_utility.set_location ('In Prem. loop ',70);
1570: --
1571: -- derive new rt strt dt
1572: --
1573: if l_rt_strt_dt is null then

Line 1676: hr_utility.set_location ('Updating prem. ',75);

1672: -- eof FONM
1673: );
1674: --
1675: if l_ppe.std_prem_val <> l_epr.val then
1676: hr_utility.set_location ('Updating prem. ',75);
1677: /* Start of Changes for WWBUG: 1646442 */
1678: --
1679: --Find the valid datetrack modes.
1680: --

Line 1738: hr_utility.set_location ('Out of epe loop '||l_package,85);

1734: end if; -- elctbl_flag = 'N'
1735: --
1736: end loop; -- c_epe
1737: --
1738: hr_utility.set_location ('Out of epe loop '||l_package,85);
1739: --
1740: close c_epe;
1741: --
1742: --gevity fix

Line 1750: hr_utility.set_location ('In loop '||l_package,321);

1746: open c_epe3(l_pil.per_in_ler_id);
1747: --
1748: loop
1749: --
1750: hr_utility.set_location ('In loop '||l_package,321);
1751: --
1752: fetch c_epe3 into l_epe;
1753: exit when c_epe3%notfound;
1754: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

Line 1754: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

1750: hr_utility.set_location ('In loop '||l_package,321);
1751: --
1752: fetch c_epe3 into l_epe;
1753: exit when c_epe3%notfound;
1754: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1755: l_pen_found := false;
1756: l_enrt_cvg_strt_dt := null;
1757: l_rt_strt_dt := null;
1758:

Line 1761: hr_utility.set_location ('An epe is not electable'||

1757: l_rt_strt_dt := null;
1758:
1759: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
1760: --
1761: hr_utility.set_location ('An epe is not electable'||
1762: to_char(l_epe.elig_per_elctbl_chc_id),33);
1763: --
1764: open c_pen;
1765: fetch c_pen into l_pen;

Line 1770: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

1766: --
1767: if c_pen%found then
1768: --
1769: l_pen_found := true;
1770: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1771: --
1772: else
1773: hr_utility.set_location('pen not found',1963);
1774: end if;

Line 1773: hr_utility.set_location('pen not found',1963);

1769: l_pen_found := true;
1770: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1771: --
1772: else
1773: hr_utility.set_location('pen not found',1963);
1774: end if;
1775: --
1776: close c_pen;
1777: --

Line 1863: hr_utility.set_location('pgm_id_table(l_pen.pgm_id) ' ||pgm_id_table(l_pen.pgm_id),20);

1859:
1860: --Start Bug 5768795
1861: if((not pgm_id_table.exists(l_pen.pgm_id)) and l_pen.pgm_id is not null)then
1862: pgm_id_table(l_pen.pgm_id):=l_pen.pgm_id;
1863: hr_utility.set_location('pgm_id_table(l_pen.pgm_id) ' ||pgm_id_table(l_pen.pgm_id),20);
1864: end if;
1865: --End Bug 5768795
1866:
1867:

Line 1945: hr_utility.set_location ('Before c_epe2 loop '||l_package,86);

1941: --
1942: end loop; -- c_epe3
1943: close c_epe3;
1944: -- canon fix
1945: hr_utility.set_location ('Before c_epe2 loop '||l_package,86);
1946: --
1947: l_pen_found := false;
1948: --
1949: open c_epe2(l_pil.per_in_ler_id);

Line 1953: hr_utility.set_location ('In loop '||l_package,31);

1949: open c_epe2(l_pil.per_in_ler_id);
1950: --
1951: loop
1952: --
1953: hr_utility.set_location ('In loop '||l_package,31);
1954: --
1955: fetch c_epe2 into l_epe;
1956: exit when c_epe2%notfound;
1957: hr_utility.set_location('Found an epe', 32);

Line 1957: hr_utility.set_location('Found an epe', 32);

1953: hr_utility.set_location ('In loop '||l_package,31);
1954: --
1955: fetch c_epe2 into l_epe;
1956: exit when c_epe2%notfound;
1957: hr_utility.set_location('Found an epe', 32);
1958: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
1959: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
1960: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
1961: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

Line 1958: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);

1954: --
1955: fetch c_epe2 into l_epe;
1956: exit when c_epe2%notfound;
1957: hr_utility.set_location('Found an epe', 32);
1958: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
1959: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
1960: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
1961: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1962: l_pen_found := false;

Line 1959: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);

1955: fetch c_epe2 into l_epe;
1956: exit when c_epe2%notfound;
1957: hr_utility.set_location('Found an epe', 32);
1958: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
1959: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
1960: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
1961: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1962: l_pen_found := false;
1963: l_enb_found := false;

Line 1960: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);

1956: exit when c_epe2%notfound;
1957: hr_utility.set_location('Found an epe', 32);
1958: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
1959: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
1960: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
1961: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1962: l_pen_found := false;
1963: l_enb_found := false;
1964: l_prv_found := false;

Line 1961: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

1957: hr_utility.set_location('Found an epe', 32);
1958: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
1959: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
1960: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
1961: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1962: l_pen_found := false;
1963: l_enb_found := false;
1964: l_prv_found := false;
1965: l_enrt_cvg_strt_dt := null;

Line 1969: hr_utility.set_location ('An epe is not electable'||

1965: l_enrt_cvg_strt_dt := null;
1966: l_rt_strt_dt := null;
1967: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
1968: --
1969: hr_utility.set_location ('An epe is not electable'||
1970: to_char(l_epe.elig_per_elctbl_chc_id),33);
1971: --
1972: open c_pen;
1973: fetch c_pen into l_pen;

Line 1978: hr_utility.set_location('pen found',1964);

1974: --
1975: if c_pen%found then
1976: --
1977: l_pen_found := true;
1978: hr_utility.set_location('pen found',1964);
1979: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1980: --
1981: else
1982: hr_utility.set_location('pen not found',1963);

Line 1979: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

1975: if c_pen%found then
1976: --
1977: l_pen_found := true;
1978: hr_utility.set_location('pen found',1964);
1979: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1980: --
1981: else
1982: hr_utility.set_location('pen not found',1963);
1983: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

Line 1982: hr_utility.set_location('pen not found',1963);

1978: hr_utility.set_location('pen found',1964);
1979: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1980: --
1981: else
1982: hr_utility.set_location('pen not found',1963);
1983: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
1984: end if;
1985: --
1986: close c_pen;

Line 1983: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

1979: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1980: --
1981: else
1982: hr_utility.set_location('pen not found',1963);
1983: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
1984: end if;
1985: --
1986: close c_pen;
1987: --

Line 1990: hr_utility.set_location (l_package,40);

1986: close c_pen;
1987: --
1988: if l_pen_found then
1989: --
1990: hr_utility.set_location (l_package,40);
1991: --
1992: if ben_manage_life_events.fonm = 'Y' then
1993: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1994: l_epe.fonm_cvg_strt_dt;

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

2168: ,p_validate => false);
2169: --
2170: end if;
2171: --
2172: hr_utility.set_location ('Leaving '||l_package,10);
2173: --
2174: end main;
2175: --
2176: procedure prv_delete(p_prtt_rt_val_id in number ,

Line 2512: hr_utility.set_location ('Provided Val'||l_prvdd_val.prvdd_val,10);

2508: if c_prvdd_val%notfound then
2509: exit;
2510: end if;
2511: --
2512: hr_utility.set_location ('Provided Val'||l_prvdd_val.prvdd_val,10);
2513: hr_utility.set_location ('Acty base Rt'||l_prvdd_val.acty_base_rt_id,11);
2514: open c_new_cr_val (p_acty_base_rt_id =>l_prvdd_val.acty_base_rt_id,
2515: p_bnft_prvdr_pool_id =>l_prvdd_val.bnft_prvdr_pool_id);
2516: loop

Line 2513: hr_utility.set_location ('Acty base Rt'||l_prvdd_val.acty_base_rt_id,11);

2509: exit;
2510: end if;
2511: --
2512: hr_utility.set_location ('Provided Val'||l_prvdd_val.prvdd_val,10);
2513: hr_utility.set_location ('Acty base Rt'||l_prvdd_val.acty_base_rt_id,11);
2514: open c_new_cr_val (p_acty_base_rt_id =>l_prvdd_val.acty_base_rt_id,
2515: p_bnft_prvdr_pool_id =>l_prvdd_val.bnft_prvdr_pool_id);
2516: loop
2517: fetch c_new_cr_val into l_new_cr_val;