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 901: hr_utility.set_location ('Entering '||l_package,10);

897:
898:
899: BEGIN
900: --
901: hr_utility.set_location ('Entering '||l_package,10);
902: hr_utility.set_location ('ler date '||l_effective_date,10);
903: --
904: -- Edit to ensure that the input p_effective_date has a value
905: --

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

898:
899: BEGIN
900: --
901: hr_utility.set_location ('Entering '||l_package,10);
902: hr_utility.set_location ('ler date '||l_effective_date,10);
903: --
904: -- Edit to ensure that the input p_effective_date has a value
905: --
906: If p_effective_date is null then

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

920: fnd_message.raise_error;
921: --
922: end if;
923: --
924: hr_utility.set_location (l_package,20);
925: --
926: -- Get the active per in ler id.
927: --
928: open c_pil;

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

930: close c_pil;
931: --
932: -- Get all electbale choices for the per in ler.
933: --
934: hr_utility.set_location ('Before loop '||l_package,25);
935: --
936: open c_epe(l_pil.per_in_ler_id);
937: --
938: loop

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

936: open c_epe(l_pil.per_in_ler_id);
937: --
938: loop
939: --
940: hr_utility.set_location ('In loop '||l_package,30);
941: --
942: fetch c_epe into l_epe;
943: exit when c_epe%notfound;
944: hr_utility.set_location('Found an epe', 32);

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

940: hr_utility.set_location ('In loop '||l_package,30);
941: --
942: fetch c_epe into l_epe;
943: exit when c_epe%notfound;
944: hr_utility.set_location('Found an epe', 32);
945: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
946: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
947: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
948: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

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

941: --
942: fetch c_epe into l_epe;
943: exit when c_epe%notfound;
944: hr_utility.set_location('Found an epe', 32);
945: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
946: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
947: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
948: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
949: --

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

942: fetch c_epe into l_epe;
943: exit when c_epe%notfound;
944: hr_utility.set_location('Found an epe', 32);
945: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
946: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
947: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
948: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
949: --
950: -- Initialize the variables.

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

943: exit when c_epe%notfound;
944: hr_utility.set_location('Found an epe', 32);
945: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
946: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
947: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
948: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
949: --
950: -- Initialize the variables.
951: --

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

944: hr_utility.set_location('Found an epe', 32);
945: hr_utility.set_location('pl_id='||l_epe.pl_id,1963);
946: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1963);
947: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1963);
948: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
949: --
950: -- Initialize the variables.
951: --
952: l_pen_found := false;

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

966: if l_epe.enrt_perd_strt_dt is not null then
967: l_effective_date := l_epe.enrt_perd_strt_dt ;
968: end if ;
969: --
970: hr_utility.set_location('Max l_effective_date '||l_effective_date,123);
971: --
972: -- Look for rate, benefit, premium changes only if the choice is
973: -- not electable (electable flag is off).
974: --

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

971: --
972: -- Look for rate, benefit, premium changes only if the choice is
973: -- not electable (electable flag is off).
974: --
975: hr_utility.set_location('elctbl_flag='||l_epe.elctbl_flag,1963);
976: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
977: --
978: hr_utility.set_location ('An epe is not electable'||
979: to_char(l_epe.elig_per_elctbl_chc_id),35);

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

974: --
975: hr_utility.set_location('elctbl_flag='||l_epe.elctbl_flag,1963);
976: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
977: --
978: hr_utility.set_location ('An epe is not electable'||
979: to_char(l_epe.elig_per_elctbl_chc_id),35);
980: --
981: open c_pen;
982: fetch c_pen into l_pen;

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

983: --
984: if c_pen%found then
985: --
986: l_pen_found := true;
987: hr_utility.set_location('pen found',1963);
988: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
989: --
990: else
991: hr_utility.set_location('pen not found',1963);

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

984: if c_pen%found then
985: --
986: l_pen_found := true;
987: hr_utility.set_location('pen found',1963);
988: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
989: --
990: else
991: hr_utility.set_location('pen not found',1963);
992: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

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

987: hr_utility.set_location('pen found',1963);
988: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
989: --
990: else
991: hr_utility.set_location('pen not found',1963);
992: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
993: end if;
994: --
995: close c_pen;

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

988: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
989: --
990: else
991: hr_utility.set_location('pen not found',1963);
992: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
993: end if;
994: --
995: close c_pen;
996: --

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

997: if l_pen_found then
998: --
999: -- Check for benefit amount changes.
1000: --
1001: hr_utility.set_location (l_package,40);
1002: --
1003: open c_enb;
1004: fetch c_enb into l_enb;
1005: --

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

1004: fetch c_enb into l_enb;
1005: --
1006: if c_enb%found then
1007: --
1008: hr_utility.set_location('c_enb found enrt_bnft_id = ' || l_enb.enrt_bnft_id, 1999);
1009: hr_utility.set_location('c_enb found prtt_enrt_rslt_id = ' || l_enb.prtt_enrt_rslt_id, 1999);
1010: l_enb_found := true;
1011: --
1012: open c_pl(l_epe.pl_id,nvl(l_epe.fonm_cvg_strt_dt,p_effective_date));

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

1005: --
1006: if c_enb%found then
1007: --
1008: hr_utility.set_location('c_enb found enrt_bnft_id = ' || l_enb.enrt_bnft_id, 1999);
1009: hr_utility.set_location('c_enb found prtt_enrt_rslt_id = ' || l_enb.prtt_enrt_rslt_id, 1999);
1010: l_enb_found := true;
1011: --
1012: open c_pl(l_epe.pl_id,nvl(l_epe.fonm_cvg_strt_dt,p_effective_date));
1013: fetch c_pl into l_pl;

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

1020: --
1021: -- Reset bnft id to null, if bnft record does not exist.
1022: --
1023: -- Bug 4895872 - Nullify all member variables of L_ENB
1024: hr_utility.set_location('c_enb not found', 1999);
1025: l_enb.enrt_bnft_id := null;
1026: l_enb.val := null;
1027: l_enb.prtt_enrt_rslt_id := null;
1028: l_enb.entr_val_at_enrt_flag := NULL;

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

1047: ben_manage_life_events.g_fonm_cvg_strt_dt :=
1048: l_epe.fonm_cvg_strt_dt;
1049: end if;
1050:
1051: hr_utility.set_location('Old Amount '||l_pen.bnft_amt,10);
1052: hr_utility.set_location('New Amount '||l_enb.val,10);
1053: --
1054: -- Case B added for bug 4715688
1055: -- Case C added for bug 4723828

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

1048: l_epe.fonm_cvg_strt_dt;
1049: end if;
1050:
1051: hr_utility.set_location('Old Amount '||l_pen.bnft_amt,10);
1052: hr_utility.set_location('New Amount '||l_enb.val,10);
1053: --
1054: -- Case B added for bug 4715688
1055: -- Case C added for bug 4723828
1056: -- Case : Same as Annualized Elected Activity Rate (SAAEAR) added for bug 5126800 - For this case

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

1094: l_imp_changed := true;
1095: end if;
1096: close c_pl;
1097:
1098: hr_utility.set_location (l_package,45);
1099:
1100: ben_election_information.election_information
1101: (p_elig_per_elctbl_chc_id => l_epe.elig_per_elctbl_chc_id,
1102: p_prtt_enrt_rslt_id => l_pen.prtt_enrt_rslt_id,

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

1159: --
1160: --Start Bug 5768795
1161: if((not pgm_id_table.exists(l_pen.pgm_id)) and l_pen.pgm_id is not null)then
1162: pgm_id_table(l_pen.pgm_id):=l_pen.pgm_id;
1163: hr_utility.set_location('pgm_id_table(l_pen.pgm_id) ' ||pgm_id_table(l_pen.pgm_id),10);
1164: end if;
1165: --End Bug 5768795
1166: --
1167: end if;

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

1167: end if;
1168: --
1169: -- Look for rate changes.
1170: --
1171: hr_utility.set_location ('Before Rates ',50);
1172: --
1173: for l_ecr in c_ecr(l_epe.elig_per_elctbl_chc_id,
1174: l_enb.enrt_bnft_id) loop
1175:

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

1174: l_enb.enrt_bnft_id) loop
1175:
1176: l_rt_end_dt_non_rec := null; -- Bug 7566569
1177: --
1178: hr_utility.set_location ('In rates loop ',55);
1179: --
1180: if l_ecr.rt_strt_dt_cd is null then
1181: l_rt_strt_dt := l_ecr.rt_strt_dt;
1182: end if;

Line 1223: hr_utility.set_location ('profile BEN_CREATE_NON_REC_ENTRIES '||l_chk_non_rec_entry,50);

1219: -- while running RPV. If the profile is set to 'N' and if it is a non-recurring element, then
1220: -- do not recreated it while running RPV
1221:
1222: l_chk_non_rec_entry := fnd_profile.value('BEN_CREATE_NON_REC_ENTRIES');
1223: hr_utility.set_location ('profile BEN_CREATE_NON_REC_ENTRIES '||l_chk_non_rec_entry,50);
1224: --
1225: -- Bug 7566569 : Check whether the element / rate is a non-recurring one. If it is non-recurring,
1226: -- we should not re-create it while running Recalculate Participant Values program
1227: --

Line 1238: hr_utility.set_location ('Rate is either recurring or non-rec with profile option as Yes ',50);

1234: ,p_effective_date => l_effective_date
1235: );
1236:
1237: if (nvl(l_chk_non_rec_entry,'Y') = 'Y' or (nvl(l_chk_non_rec_entry,'Y')='N' and l_recurring_rt)) then
1238: hr_utility.set_location ('Rate is either recurring or non-rec with profile option as Yes ',50);
1239: open c_prv(l_ecr.acty_base_rt_id,l_rt_strt_dt);
1240: fetch c_prv into l_prv;
1241: --
1242: if c_prv%found then

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

1258: --
1259: -- Fix for WWBUG 1298556
1260: -- Check if activity changed.
1261: --
1262: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1263: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1264: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1265: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1266: -- Bug 2551834 If the ecr.val is null it fails

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

1259: -- Fix for WWBUG 1298556
1260: -- Check if activity changed.
1261: --
1262: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1263: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1264: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1265: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1266: -- Bug 2551834 If the ecr.val is null it fails
1267: -- Bug#2959410 - don't look for changes if the rate is enter value

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

1260: -- Check if activity changed.
1261: --
1262: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1263: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1264: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1265: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1266: -- Bug 2551834 If the ecr.val is null it fails
1267: -- Bug#2959410 - don't look for changes if the rate is enter value
1268: -- at enrollment as the val will always be null

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

1261: --
1262: hr_utility.set_location('OLD RT'||l_prv.rt_val,10);
1263: hr_utility.set_location('NEW RT'||l_ecr.val,10);
1264: hr_utility.set_location('OLD ACT'||l_prv.acty_typ_cd,10);
1265: hr_utility.set_location('NEW ACT'||l_ecr.acty_typ_cd,10);
1266: -- Bug 2551834 If the ecr.val is null it fails
1267: -- Bug#2959410 - don't look for changes if the rate is enter value
1268: -- at enrollment as the val will always be null
1269: l_entr_val_at_enrt_flag := l_ecr.entr_val_at_enrt_flag;

Line 1282: hr_utility.set_location('ann RT'||l_prv.ann_rt_val,10);

1278: --
1279: -- if the amt changed, no need to determine if the element
1280: -- info changed
1281: --
1282: hr_utility.set_location('ann RT'||l_prv.ann_rt_val,10);
1283: hr_utility.set_location('ecr ann RT'||l_ecr.ann_val,10);
1284: hr_utility.set_location('cmcd RT'||l_prv.cmcd_rt_val,10);
1285: hr_utility.set_location('ecr cmcd RT'||l_ecr.cmcd_val,10);
1286: if l_prv_found and

Line 1283: hr_utility.set_location('ecr ann RT'||l_ecr.ann_val,10);

1279: -- if the amt changed, no need to determine if the element
1280: -- info changed
1281: --
1282: hr_utility.set_location('ann RT'||l_prv.ann_rt_val,10);
1283: hr_utility.set_location('ecr ann RT'||l_ecr.ann_val,10);
1284: hr_utility.set_location('cmcd RT'||l_prv.cmcd_rt_val,10);
1285: hr_utility.set_location('ecr cmcd RT'||l_ecr.cmcd_val,10);
1286: if l_prv_found and
1287: ((nvl(l_prv.rt_val,0) = nvl(l_ecr.val,0) and

Line 1284: hr_utility.set_location('cmcd RT'||l_prv.cmcd_rt_val,10);

1280: -- info changed
1281: --
1282: hr_utility.set_location('ann RT'||l_prv.ann_rt_val,10);
1283: hr_utility.set_location('ecr ann RT'||l_ecr.ann_val,10);
1284: hr_utility.set_location('cmcd RT'||l_prv.cmcd_rt_val,10);
1285: hr_utility.set_location('ecr cmcd RT'||l_ecr.cmcd_val,10);
1286: if l_prv_found and
1287: ((nvl(l_prv.rt_val,0) = nvl(l_ecr.val,0) and
1288: nvl(l_prv.ann_rt_val,0) = nvl(l_ecr.ann_val,0)) OR /* bug 7414466 */

Line 1285: hr_utility.set_location('ecr cmcd RT'||l_ecr.cmcd_val,10);

1281: --
1282: hr_utility.set_location('ann RT'||l_prv.ann_rt_val,10);
1283: hr_utility.set_location('ecr ann RT'||l_ecr.ann_val,10);
1284: hr_utility.set_location('cmcd RT'||l_prv.cmcd_rt_val,10);
1285: hr_utility.set_location('ecr cmcd RT'||l_ecr.cmcd_val,10);
1286: if l_prv_found and
1287: ((nvl(l_prv.rt_val,0) = nvl(l_ecr.val,0) and
1288: nvl(l_prv.ann_rt_val,0) = nvl(l_ecr.ann_val,0)) OR /* bug 7414466 */
1289: --

Line 1294: hr_utility.set_location('l_prv_found '||l_prv.prtt_rt_val_id,10);

1290: -- bug 9143356
1291: --
1292: -- nvl(l_prv.cmcd_rt_val,0) = nvl(l_ecr.cmcd_val,0)) OR /* bug 7414466 */
1293: l_prv.rt_ovridn_flag = 'Y') then
1294: hr_utility.set_location('l_prv_found '||l_prv.prtt_rt_val_id,10);
1295: --
1296: if l_rt_strt_dt is null then
1297: --
1298: -- derive new rt strt dt

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

1357: fetch c_element_info into l_element_info;
1358: close c_element_info;
1359: end if;
1360:
1361: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1362: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1363: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1364: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1365: --

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

1358: close c_element_info;
1359: end if;
1360:
1361: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1362: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1363: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1364: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1365: --
1366: -- get current element info

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

1359: end if;
1360:
1361: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1362: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1363: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1364: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1365: --
1366: -- get current element info
1367: --

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

1360:
1361: hr_utility.set_location('elt :'||l_element_info.element_type_id,10);
1362: hr_utility.set_location('inp :'||l_element_info.input_value_id,10);
1363: hr_utility.set_location('ee end:'||l_element_info.effective_end_date,10);
1364: hr_utility.set_location('rt strt :'||l_rt_strt_dt,10);
1365: --
1366: -- get current element info
1367: --
1368: open c_abr(l_ecr.acty_base_rt_id,l_rt_strt_dt);

Line 1424: hr_utility.set_location( 'l_pen.oipl_id '||l_pen.oipl_id, 20);

1420:
1421: -- Bug 8623254
1422: l_get_opt_id := null;
1423:
1424: hr_utility.set_location( 'l_pen.oipl_id '||l_pen.oipl_id, 20);
1425: if l_pen.oipl_id is not null then
1426: open c_get_opt_id;
1427: fetch c_get_opt_id into l_get_opt_id;
1428: close c_get_opt_id;

Line 1430: hr_utility.set_location( 'l_get_opt_id.opt_id '||l_get_opt_id.opt_id, 20);

1426: open c_get_opt_id;
1427: fetch c_get_opt_id into l_get_opt_id;
1428: close c_get_opt_id;
1429: end if;
1430: hr_utility.set_location( 'l_get_opt_id.opt_id '||l_get_opt_id.opt_id, 20);
1431:
1432: -- Bug 8623254
1433:
1434: l_ext_inpval_tab.delete;

Line 1495: hr_utility.set_location('l_current_yr_start_date '|| l_yr_start_date,22);

1491: --
1492: open c_yr_perd(l_epe.yr_perd_id);
1493: fetch c_yr_perd into l_yr_start_date, l_yr_end_date;
1494: close c_yr_perd;
1495: hr_utility.set_location('l_current_yr_start_date '|| l_yr_start_date,22);
1496: hr_utility.set_location('l_current_yr_end_date '|| l_yr_end_date,22);
1497: --
1498: l_no_of_periods := ben_distribute_rates.get_periods_between
1499: ( p_acty_ref_perd_cd => 'PP',

Line 1496: hr_utility.set_location('l_current_yr_end_date '|| l_yr_end_date,22);

1492: open c_yr_perd(l_epe.yr_perd_id);
1493: fetch c_yr_perd into l_yr_start_date, l_yr_end_date;
1494: close c_yr_perd;
1495: hr_utility.set_location('l_current_yr_start_date '|| l_yr_start_date,22);
1496: hr_utility.set_location('l_current_yr_end_date '|| l_yr_end_date,22);
1497: --
1498: l_no_of_periods := ben_distribute_rates.get_periods_between
1499: ( p_acty_ref_perd_cd => 'PP',
1500: p_start_date => l_yr_start_date,

Line 1506: hr_utility.set_location('l_no_of_periods '|| l_no_of_periods,22);

1502: p_payroll_id => l_element_info.payroll_id,
1503: p_business_group_id => p_business_group_id,
1504: p_effective_date => p_effective_date
1505: );
1506: hr_utility.set_location('l_no_of_periods '|| l_no_of_periods,22);
1507: --
1508: -- Get the number of periods in the prior year.
1509: --
1510: open c_pl_popl_yr_period_prev(l_pen.pl_id,l_yr_start_date-1);--AMN Bug 14077548

Line 1523: hr_utility.set_location('l_prev_no_of_periods '|| l_prev_no_of_periods,22);

1519: p_business_group_id => p_business_group_id,
1520: p_effective_date => p_effective_date
1521: );
1522:
1523: hr_utility.set_location('l_prev_no_of_periods '|| l_prev_no_of_periods,22);
1524: --
1525: l_element_changed := l_prev_no_of_periods <> l_no_of_periods;
1526: end if; -- pay periods element changed -- 12417510
1527: end if;

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

1562: nvl(l_prv.tx_typ_cd,'-1') <> nvl(l_ecr.tx_typ_cd,'-1') or
1563: l_element_changed or
1564: l_bnft_changed then
1565: --
1566: hr_utility.set_location ('Calling rate_info ',60);
1567: hr_utility.set_location('rate change',13);
1568: --
1569: l_flex_call := true;
1570: ben_election_information.election_rate_information

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

1563: l_element_changed or
1564: l_bnft_changed then
1565: --
1566: hr_utility.set_location ('Calling rate_info ',60);
1567: hr_utility.set_location('rate change',13);
1568: --
1569: l_flex_call := true;
1570: ben_election_information.election_rate_information
1571: (p_enrt_mthd_cd => l_pen.enrt_mthd_cd

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

1597: end if; -- l_recurring_rt -- Bug 7566569
1598: --
1599: end loop;
1600:
1601: hr_utility.set_location ('Before imputed and premium process ',65);
1602:
1603: if l_bnft_changed then
1604: -- if benefit amount changed, check to see if imputed
1605: -- income should also change.

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

1680: l_prtt_enrt_rslt_id_shell ) ;
1681: fetch c_bpl into l_prvdd_val ;
1682: close c_bpl ;
1683: --if there is amount change call the updating
1684: hr_utility.set_location( 'prvdd val ' || l_prvdd_val , 1001);
1685: hr_utility.set_location( 'changed val ' || i.val , 1001);
1686: hr_utility.set_location('Result id'||l_prtt_enrt_rslt_id_shell,1002);
1687:
1688:

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

1681: fetch c_bpl into l_prvdd_val ;
1682: close c_bpl ;
1683: --if there is amount change call the updating
1684: hr_utility.set_location( 'prvdd val ' || l_prvdd_val , 1001);
1685: hr_utility.set_location( 'changed val ' || i.val , 1001);
1686: hr_utility.set_location('Result id'||l_prtt_enrt_rslt_id_shell,1002);
1687:
1688:
1689: if l_prvdd_val is not null and l_prvdd_val <> i.val then

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

1682: close c_bpl ;
1683: --if there is amount change call the updating
1684: hr_utility.set_location( 'prvdd val ' || l_prvdd_val , 1001);
1685: hr_utility.set_location( 'changed val ' || i.val , 1001);
1686: hr_utility.set_location('Result id'||l_prtt_enrt_rslt_id_shell,1002);
1687:
1688:
1689: if l_prvdd_val is not null and l_prvdd_val <> i.val then
1690: ben_provider_pools.create_credit_ledger_entry

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

1748: -- If the benefit amount has changed, the premium would
1749: -- already have changed by the election_information call.
1750: for l_epr in c_epr(l_epe.elig_per_elctbl_chc_id,
1751: l_enb.enrt_bnft_id) loop
1752: hr_utility.set_location ('In Prem. loop ',70);
1753: --
1754: -- derive new rt strt dt
1755: --
1756: if l_rt_strt_dt is null then

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

1855: -- eof FONM
1856: );
1857: --
1858: if l_ppe.std_prem_val <> l_epr.val then
1859: hr_utility.set_location ('Updating prem. ',75);
1860: /* Start of Changes for WWBUG: 1646442 */
1861: --
1862: --Find the valid datetrack modes.
1863: --

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

1917: end if; -- elctbl_flag = 'N'
1918: --
1919: end loop; -- c_epe
1920: --
1921: hr_utility.set_location ('Out of epe loop '||l_package,85);
1922: --
1923: close c_epe;
1924: --
1925: --gevity fix

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

1929: open c_epe3(l_pil.per_in_ler_id);
1930: --
1931: loop
1932: --
1933: hr_utility.set_location ('In loop '||l_package,321);
1934: --
1935: fetch c_epe3 into l_epe;
1936: exit when c_epe3%notfound;
1937: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

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

1933: hr_utility.set_location ('In loop '||l_package,321);
1934: --
1935: fetch c_epe3 into l_epe;
1936: exit when c_epe3%notfound;
1937: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1938: l_pen_found := false;
1939: l_enrt_cvg_strt_dt := null;
1940: l_rt_strt_dt := null;
1941:

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

1940: l_rt_strt_dt := null;
1941:
1942: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
1943: --
1944: hr_utility.set_location ('An epe is not electable'||
1945: to_char(l_epe.elig_per_elctbl_chc_id),33);
1946: --
1947: open c_pen;
1948: fetch c_pen into l_pen;

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

1949: --
1950: if c_pen%found then
1951: --
1952: l_pen_found := true;
1953: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1954: --
1955: else
1956: hr_utility.set_location('pen not found',1963);
1957: end if;

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

1952: l_pen_found := true;
1953: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
1954: --
1955: else
1956: hr_utility.set_location('pen not found',1963);
1957: end if;
1958: --
1959: close c_pen;
1960: --

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

2042:
2043: --Start Bug 5768795
2044: if((not pgm_id_table.exists(l_pen.pgm_id)) and l_pen.pgm_id is not null)then
2045: pgm_id_table(l_pen.pgm_id):=l_pen.pgm_id;
2046: hr_utility.set_location('pgm_id_table(l_pen.pgm_id) ' ||pgm_id_table(l_pen.pgm_id),20);
2047: end if;
2048: --End Bug 5768795
2049:
2050:

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

2124: --
2125: end loop; -- c_epe3
2126: close c_epe3;
2127: -- canon fix
2128: hr_utility.set_location ('Before c_epe2 loop '||l_package,86);
2129: --
2130: l_pen_found := false;
2131: --
2132: open c_epe2(l_pil.per_in_ler_id);

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

2132: open c_epe2(l_pil.per_in_ler_id);
2133: --
2134: loop
2135: --
2136: hr_utility.set_location ('In loop '||l_package,31);
2137: --
2138: fetch c_epe2 into l_epe;
2139: exit when c_epe2%notfound;
2140: hr_utility.set_location('Found an epe', 32);

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

2136: hr_utility.set_location ('In loop '||l_package,31);
2137: --
2138: fetch c_epe2 into l_epe;
2139: exit when c_epe2%notfound;
2140: hr_utility.set_location('Found an epe', 32);
2141: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
2142: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
2143: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
2144: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);

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

2137: --
2138: fetch c_epe2 into l_epe;
2139: exit when c_epe2%notfound;
2140: hr_utility.set_location('Found an epe', 32);
2141: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
2142: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
2143: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
2144: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2145: l_pen_found := false;

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

2138: fetch c_epe2 into l_epe;
2139: exit when c_epe2%notfound;
2140: hr_utility.set_location('Found an epe', 32);
2141: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
2142: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
2143: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
2144: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2145: l_pen_found := false;
2146: l_enb_found := false;

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

2139: exit when c_epe2%notfound;
2140: hr_utility.set_location('Found an epe', 32);
2141: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
2142: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
2143: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
2144: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2145: l_pen_found := false;
2146: l_enb_found := false;
2147: l_prv_found := false;

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

2140: hr_utility.set_location('Found an epe', 32);
2141: hr_utility.set_location('pl_id='||l_epe.pl_id,1964);
2142: hr_utility.set_location('GP oipl_id='||l_epe.oipl_id,1964);
2143: hr_utility.set_location('epe_id='||l_epe.elig_per_elctbl_chc_id,1964);
2144: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2145: l_pen_found := false;
2146: l_enb_found := false;
2147: l_prv_found := false;
2148: l_enrt_cvg_strt_dt := null;

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

2148: l_enrt_cvg_strt_dt := null;
2149: l_rt_strt_dt := null;
2150: if l_epe.elctbl_flag = 'N' or p_mode = 'R' then
2151: --
2152: hr_utility.set_location ('An epe is not electable'||
2153: to_char(l_epe.elig_per_elctbl_chc_id),33);
2154: --
2155: open c_pen;
2156: fetch c_pen into l_pen;

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

2157: --
2158: if c_pen%found then
2159: --
2160: l_pen_found := true;
2161: hr_utility.set_location('pen found',1964);
2162: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2163: --
2164: else
2165: hr_utility.set_location('pen not found',1963);

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

2158: if c_pen%found then
2159: --
2160: l_pen_found := true;
2161: hr_utility.set_location('pen found',1964);
2162: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2163: --
2164: else
2165: hr_utility.set_location('pen not found',1963);
2166: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);

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

2161: hr_utility.set_location('pen found',1964);
2162: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2163: --
2164: else
2165: hr_utility.set_location('pen not found',1963);
2166: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
2167: end if;
2168: --
2169: close c_pen;

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

2162: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1964);
2163: --
2164: else
2165: hr_utility.set_location('pen not found',1963);
2166: hr_utility.set_location('pen_id='||l_epe.prtt_enrt_rslt_id,1963);
2167: end if;
2168: --
2169: close c_pen;
2170: --

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

2169: close c_pen;
2170: --
2171: if l_pen_found then
2172: --
2173: hr_utility.set_location (l_package,40);
2174: --
2175: if ben_manage_life_events.fonm = 'Y' then
2176: ben_manage_life_events.g_fonm_cvg_strt_dt :=
2177: l_epe.fonm_cvg_strt_dt;

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

2351: ,p_validate => false);
2352: --
2353: end if;
2354: --
2355: hr_utility.set_location ('Leaving '||l_package,10);
2356: --
2357: end main;
2358: --
2359: procedure prv_delete(p_prtt_rt_val_id in number ,

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

2691: if c_prvdd_val%notfound then
2692: exit;
2693: end if;
2694: --
2695: hr_utility.set_location ('Provided Val'||l_prvdd_val.prvdd_val,10);
2696: hr_utility.set_location ('Acty base Rt'||l_prvdd_val.acty_base_rt_id,11);
2697: open c_new_cr_val (p_acty_base_rt_id =>l_prvdd_val.acty_base_rt_id,
2698: p_bnft_prvdr_pool_id =>l_prvdd_val.bnft_prvdr_pool_id);
2699: loop

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

2692: exit;
2693: end if;
2694: --
2695: hr_utility.set_location ('Provided Val'||l_prvdd_val.prvdd_val,10);
2696: hr_utility.set_location ('Acty base Rt'||l_prvdd_val.acty_base_rt_id,11);
2697: open c_new_cr_val (p_acty_base_rt_id =>l_prvdd_val.acty_base_rt_id,
2698: p_bnft_prvdr_pool_id =>l_prvdd_val.bnft_prvdr_pool_id);
2699: loop
2700: fetch c_new_cr_val into l_new_cr_val;