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

Line 434: hr_utility.set_location(' l_ben_vapro_rul_cond ' || l_ben_vapro_rul_cond, 757 );

430: if l_inst_count > 0 then
431: --- get the profile setup it can be either AND or OR # 2508757
432: l_ben_vapro_rul_cond := fnd_profile.value('BEN_VAPRO_RL_COND');
433:
434: hr_utility.set_location(' l_ben_vapro_rul_cond ' || l_ben_vapro_rul_cond, 757 );
435: --
436: for i in l_inst_set.first..l_inst_set.last loop
437: --
438: hr_utility.set_location(' p_vrbl_rt_prfl_id ' || p_vrbl_rt_prfl_id, 757 );

Line 438: hr_utility.set_location(' p_vrbl_rt_prfl_id ' || p_vrbl_rt_prfl_id, 757 );

434: hr_utility.set_location(' l_ben_vapro_rul_cond ' || l_ben_vapro_rul_cond, 757 );
435: --
436: for i in l_inst_set.first..l_inst_set.last loop
437: --
438: hr_utility.set_location(' p_vrbl_rt_prfl_id ' || p_vrbl_rt_prfl_id, 757 );
439: l_outputs := benutils.formula
440: (p_formula_id => l_inst_set(i).formula_id
441: ,p_effective_date => nvl(p_lf_evt_ocrd_dt
442: ,p_effective_date)

Line 465: hr_utility.set_location(' result ' || l_outputs(l_outputs.first).value, 758 );

461: );
462: -- if the profile is AND and one of the rule fails #2508757
463: if nvl(l_ben_vapro_rul_cond,'A') = 'A' then
464:
465: hr_utility.set_location(' result ' || l_outputs(l_outputs.first).value, 758 );
466: if l_outputs(l_outputs.first).value <> 'Y' then
467: raise g_criteria_failed;
468: End if ;
469: Else

Line 471: hr_utility.set_location(' result ' || l_outputs(l_outputs.first).value, 759 );

467: raise g_criteria_failed;
468: End if ;
469: Else
470: -- if the profile is OR and one of the rule pass then exit
471: hr_utility.set_location(' result ' || l_outputs(l_outputs.first).value, 759 );
472: if l_outputs(l_outputs.first).value = 'Y' then
473: --
474: exit;
475: --

Line 482: hr_utility.set_location(' error on OR and N ', 757 );

478: --
479: end loop;
480: -- if the profile is OR and exit with value 'N' raise the error
481: if nvl(l_ben_vapro_rul_cond,'A') = 'O' and l_outputs(l_outputs.first).value <> 'Y' then
482: hr_utility.set_location(' error on OR and N ', 757 );
483: raise g_criteria_failed;
484: end if ;
485: --
486: end if;

Line 603: hr_utility.set_location(' l_inst_set(i).gndr_cd '||l_inst_set(i).gndr_cd , 12);

599: l_rows_found := true;
600: --
601: for i in l_inst_set.first..l_inst_set.last loop
602: --
603: hr_utility.set_location(' l_inst_set(i).gndr_cd '||l_inst_set(i).gndr_cd , 12);
604: hr_utility.set_location(' l_inst_set(i).excld_flag '|| l_inst_set(i).excld_flag ,12);
605: --
606: l_ok := l_inst_set(i).gndr_cd = p_sex;
607: --

Line 604: hr_utility.set_location(' l_inst_set(i).excld_flag '|| l_inst_set(i).excld_flag ,12);

600: --
601: for i in l_inst_set.first..l_inst_set.last loop
602: --
603: hr_utility.set_location(' l_inst_set(i).gndr_cd '||l_inst_set(i).gndr_cd , 12);
604: hr_utility.set_location(' l_inst_set(i).excld_flag '|| l_inst_set(i).excld_flag ,12);
605: --
606: l_ok := l_inst_set(i).gndr_cd = p_sex;
607: --
608: if l_ok is null or p_sex is null then

Line 1194: hr_utility.set_location ('Entering check_pct_fltm',01);

1190: l_rows_found boolean := false;
1191: l_mx_pct_val number ;
1192: --
1193: begin
1194: hr_utility.set_location ('Entering check_pct_fltm',01);
1195: hr_utility.set_location ('opt' || p_opt_id ,01);
1196: hr_utility.set_location ('plip'|| p_plip_id ,01);
1197: hr_utility.set_location ('pl' || p_pl_id ,01);
1198: hr_utility.set_location ('pgm' || p_pgm_id ,01);

Line 1195: hr_utility.set_location ('opt' || p_opt_id ,01);

1191: l_mx_pct_val number ;
1192: --
1193: begin
1194: hr_utility.set_location ('Entering check_pct_fltm',01);
1195: hr_utility.set_location ('opt' || p_opt_id ,01);
1196: hr_utility.set_location ('plip'|| p_plip_id ,01);
1197: hr_utility.set_location ('pl' || p_pl_id ,01);
1198: hr_utility.set_location ('pgm' || p_pgm_id ,01);
1199: --

Line 1196: hr_utility.set_location ('plip'|| p_plip_id ,01);

1192: --
1193: begin
1194: hr_utility.set_location ('Entering check_pct_fltm',01);
1195: hr_utility.set_location ('opt' || p_opt_id ,01);
1196: hr_utility.set_location ('plip'|| p_plip_id ,01);
1197: hr_utility.set_location ('pl' || p_pl_id ,01);
1198: hr_utility.set_location ('pgm' || p_pgm_id ,01);
1199: --
1200:

Line 1197: hr_utility.set_location ('pl' || p_pl_id ,01);

1193: begin
1194: hr_utility.set_location ('Entering check_pct_fltm',01);
1195: hr_utility.set_location ('opt' || p_opt_id ,01);
1196: hr_utility.set_location ('plip'|| p_plip_id ,01);
1197: hr_utility.set_location ('pl' || p_pl_id ,01);
1198: hr_utility.set_location ('pgm' || p_pgm_id ,01);
1199: --
1200:
1201: if p_opt_id is not null then

Line 1198: hr_utility.set_location ('pgm' || p_pgm_id ,01);

1194: hr_utility.set_location ('Entering check_pct_fltm',01);
1195: hr_utility.set_location ('opt' || p_opt_id ,01);
1196: hr_utility.set_location ('plip'|| p_plip_id ,01);
1197: hr_utility.set_location ('pl' || p_pl_id ,01);
1198: hr_utility.set_location ('pgm' || p_pgm_id ,01);
1199: --
1200:
1201: if p_opt_id is not null then
1202: -- Look for oiplip first. oiplip elig_per_opt rows hang off plip elig_per

Line 1207: hr_utility.set_location ('oiplip '||to_char(l_rt_pct_fl_tm_val),01);

1203: -- records.
1204: if p_plip_id is not null then
1205: open c_pct_ft_plip;
1206: fetch c_pct_ft_plip into l_rt_pct_fl_tm_val;
1207: hr_utility.set_location ('oiplip '||to_char(l_rt_pct_fl_tm_val),01);
1208: close c_pct_ft_plip;
1209: end if;
1210:
1211: -- If there is no oiplip, check for oipl

Line 1215: hr_utility.set_location ('oipl '||to_char(l_rt_pct_fl_tm_val),01);

1211: -- If there is no oiplip, check for oipl
1212: if l_rt_pct_fl_tm_val is null then
1213: open c_pct_ft_opt;
1214: fetch c_pct_ft_opt into l_rt_pct_fl_tm_val;
1215: hr_utility.set_location ('oipl '||to_char(l_rt_pct_fl_tm_val),01);
1216: close c_pct_ft_opt;
1217: end if;
1218: else
1219: -- just look for pl elig per record.

Line 1222: hr_utility.set_location ('pl '||to_char(l_rt_pct_fl_tm_val),01);

1218: else
1219: -- just look for pl elig per record.
1220: open c_pct_ft;
1221: fetch c_pct_ft into l_rt_pct_fl_tm_val;
1222: hr_utility.set_location ('pl '||to_char(l_rt_pct_fl_tm_val),01);
1223: close c_pct_ft;
1224: end if;
1225:
1226: -- Get the rate profile data from the cache.

Line 1260: hr_utility.set_location('if' , 610) ;

1256: l_mx_pct_val := l_inst_set(i).mx_pct_val + 1 ;
1257: --
1258: end if;
1259: --
1260: hr_utility.set_location('if' , 610) ;
1261: --
1262: l_ok := ((l_rt_pct_fl_tm_val >=
1263: l_inst_set(i).mn_pct_val
1264: and l_rt_pct_fl_tm_val < l_mx_pct_val )

Line 1273: hr_utility.set_location('success ' ,610);

1269: (l_rt_pct_fl_tm_val >= l_inst_set(i).mn_pct_val and
1270: l_inst_set(i).no_mx_pct_val_flag = 'Y'));
1271:
1272: if l_ok Then
1273: hr_utility.set_location('success ' ,610);
1274: end if ;
1275: --
1276: if l_ok is null or l_rt_pct_fl_tm_val is null then
1277: --

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

1335: l_include_flag varchar2(80);
1336: --
1337: begin
1338: --
1339: hr_utility.set_location('Entering: '||l_proc, 10);
1340: --
1341: -- Getting eligibility profile compensation level by eligibility profile
1342: --
1343: ben_rt_asnt_cache.get_rt_asnt_cache

Line 1351: hr_utility.set_location('Int COunt'||l_inst_count,11);

1347: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
1348: ,p_inst_set => l_inst_dets
1349: ,p_inst_count => l_inst_count);
1350: --
1351: hr_utility.set_location('Int COunt'||l_inst_count,11);
1352: if l_inst_count > 0 then
1353: --
1354: ben_person_object.get_object(p_person_id => p_person_id,
1355: p_rec => l_ass_rec);

Line 1362: hr_utility.set_location('COunt'||l_count,11);

1358: --
1359: -- Error if someone hasn't built the formula as this will
1360: -- cause an error. In this case kill the run.
1361: --
1362: hr_utility.set_location('COunt'||l_count,11);
1363: if l_inst_dets(l_count).formula_id is null then
1364: --
1365: fnd_message.set_name('BEN','BEN_92460_ASS_SET_FORMULA');
1366: fnd_message.set_token('PROC',l_proc);

Line 1372: hr_utility.set_location('Bef Formula',11);

1368: fnd_message.raise_error;
1369: --
1370: end if;
1371: --
1372: hr_utility.set_location('Bef Formula',11);
1373: l_outputs := benutils.formula
1374: (p_formula_id => l_inst_dets(l_count).formula_id,
1375: p_assignment_id => l_ass_rec.assignment_id,
1376: p_effective_date => nvl(p_lf_evt_ocrd_dt, p_effective_date), -- FONM

Line 1386: hr_utility.set_location('Incl Flag ',11);

1382: begin
1383: --
1384: if l_outputs(l_outputs.first).name = 'INCLUDE_FLAG' then
1385: --
1386: hr_utility.set_location('Incl Flag ',11);
1387: l_include_flag := l_outputs(l_outputs.first).value;
1388: --
1389: else
1390: --

Line 1416: hr_utility.set_location('Include Flag '||l_include_flag,10);

1412: fnd_message.raise_error;
1413: --
1414: end;
1415: --
1416: hr_utility.set_location('Include Flag '||l_include_flag,10);
1417: --
1418: l_ok := nvl((l_include_flag = 'Y'),FALSE);
1419: --if l_ok is null then
1420: -- l_ok:=false;

Line 1453: hr_utility.set_location('Criteria Failed: '||l_proc,20);

1449: if l_rows_found and
1450: not l_ok then
1451: --
1452: fnd_message.set_name('BEN','BEN_92459_ASS_SET_PRFL_FAIL');
1453: hr_utility.set_location('Criteria Failed: '||l_proc,20);
1454: raise g_criteria_failed;
1455: --
1456: end if;
1457: --

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

1454: raise g_criteria_failed;
1455: --
1456: end if;
1457: --
1458: hr_utility.set_location('Leaving :'||l_proc,20);
1459: --
1460: end check_asnt_set;
1461: -- --------------------------------------------------------------------
1462: -- Hours worked in a period check.

Line 1537: hr_utility.set_location ('Entering check_hrs_wkd',01);

1533: l_rows_found boolean := false;
1534: l_mx_hrs_num number ;
1535:
1536: begin
1537: hr_utility.set_location ('Entering check_hrs_wkd',01);
1538: if p_opt_id is not null then
1539: -- Look for oiplip first. oiplip elig_per_opt rows hang off plip elig_per
1540: -- records.
1541: if p_plip_id is not null then

Line 1544: hr_utility.set_location ('oiplip '||to_char(l_rt_hrs_wkd_val),01);

1540: -- records.
1541: if p_plip_id is not null then
1542: open c_hrs_wkd_plip;
1543: fetch c_hrs_wkd_plip into l_rt_hrs_wkd_val;
1544: hr_utility.set_location ('oiplip '||to_char(l_rt_hrs_wkd_val),01);
1545: close c_hrs_wkd_plip;
1546: end if;
1547:
1548: -- If there is no oiplip, check for oipl

Line 1552: hr_utility.set_location ('oipl '||to_char(l_rt_hrs_wkd_val),01);

1548: -- If there is no oiplip, check for oipl
1549: if l_rt_hrs_wkd_val is null then
1550: open c_hrs_wkd_opt;
1551: fetch c_hrs_wkd_opt into l_rt_hrs_wkd_val;
1552: hr_utility.set_location ('oipl '||to_char(l_rt_hrs_wkd_val),01);
1553: close c_hrs_wkd_opt;
1554: end if;
1555: else
1556: -- just look for pl elig per record.

Line 1559: hr_utility.set_location ('pl '||to_char(l_rt_hrs_wkd_val),01);

1555: else
1556: -- just look for pl elig per record.
1557: open c_hrs_wkd;
1558: fetch c_hrs_wkd into l_rt_hrs_wkd_val;
1559: hr_utility.set_location ('pl '||to_char(l_rt_hrs_wkd_val),01);
1560: close c_hrs_wkd;
1561: end if;
1562:
1563:

Line 1582: hr_utility.set_location ('hrx criteria'||l_rt_hrs_wkd_val || ' min:'||

1578: --
1579: l_rows_found := true;
1580: --
1581: for i in l_inst_set.first..l_inst_set.last loop
1582: hr_utility.set_location ('hrx criteria'||l_rt_hrs_wkd_val || ' min:'||
1583: to_char(l_inst_set(i).mn_hrs_num)||' mx:'||to_char(l_inst_set(i).mx_hrs_num),610.2);
1584: --
1585: -- Bug 2101937 fixes
1586: l_mx_hrs_num := l_inst_set(i).mx_hrs_num ;

Line 1865: hr_utility.set_location ('c_get_absence_type found',88);

1861: fetch c_get_absence_type into l_dummy;
1862: --
1863: if c_get_absence_type%found then
1864: --
1865: hr_utility.set_location ('c_get_absence_type found',88);
1866: --
1867: if l_inst_set(i).excld_flag = 'N' then
1868: --
1869: l_ok:=true;

Line 1883: hr_utility.set_location ('c_get_absence_type not found',88);

1879: end if;
1880: --
1881: else
1882: --
1883: hr_utility.set_location ('c_get_absence_type not found',88);
1884: --
1885: if l_inst_set(i).excld_flag = 'N' then
1886: --
1887: l_rows_found:=true;

Line 2012: hr_utility.set_location('p_vrbl_rt_prfl_id -> '||p_vrbl_rt_prfl_id,11);

2008: begin
2009: --
2010: -- Get the data from the cache.
2011: --
2012: hr_utility.set_location('p_vrbl_rt_prfl_id -> '||p_vrbl_rt_prfl_id,11);
2013:
2014: ben_rt_prfl_cache.get_rt_prfl_cache
2015: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2016: ,p_effective_date => p_effective_date

Line 2034: hr_utility.set_location(l_inst_set(i).person_type_id,10);

2030: l_rows_found := true;
2031: --
2032: for l_count in p_person_type.first..p_person_type.last loop
2033: --
2034: hr_utility.set_location(l_inst_set(i).person_type_id,10);
2035: --
2036: -- To support user creatd person type use person_type_id instead of per_typ_cd
2037: --
2038: /*l_ok := l_inst_set(i).per_typ_cd =

Line 2139: hr_utility.set_location('entering chck_zip_code', 10);

2135: --
2136: BEGIN
2137: --
2138: -- Get the data from the cache.
2139: hr_utility.set_location('entering chck_zip_code', 10);
2140: --
2141: -- FONM
2142: if ben_manage_life_events.fonm = 'Y' then
2143: --

Line 2164: hr_utility.set_location('person zip '||p_postal_code ,2219.3);

2160: LOOP
2161: FETCH get_zip_ranges INTO l_from_value,l_to_value;
2162: EXIT WHEN get_zip_ranges%NOTFOUND;
2163: --
2164: hr_utility.set_location('person zip '||p_postal_code ,2219.3);
2165: hr_utility.set_location('from zip '||l_from_value ,2219.3);
2166: hr_utility.set_location('to zip '||l_to_value ,2219.3);
2167: --
2168: l_rows_found := TRUE;

Line 2165: hr_utility.set_location('from zip '||l_from_value ,2219.3);

2161: FETCH get_zip_ranges INTO l_from_value,l_to_value;
2162: EXIT WHEN get_zip_ranges%NOTFOUND;
2163: --
2164: hr_utility.set_location('person zip '||p_postal_code ,2219.3);
2165: hr_utility.set_location('from zip '||l_from_value ,2219.3);
2166: hr_utility.set_location('to zip '||l_to_value ,2219.3);
2167: --
2168: l_rows_found := TRUE;
2169: EXIT;

Line 2166: hr_utility.set_location('to zip '||l_to_value ,2219.3);

2162: EXIT WHEN get_zip_ranges%NOTFOUND;
2163: --
2164: hr_utility.set_location('person zip '||p_postal_code ,2219.3);
2165: hr_utility.set_location('from zip '||l_from_value ,2219.3);
2166: hr_utility.set_location('to zip '||l_to_value ,2219.3);
2167: --
2168: l_rows_found := TRUE;
2169: EXIT;
2170: --

Line 2205: hr_utility.set_location('leaving chck_zip_code', 10);

2201: RAISE ben_evaluate_rate_profiles.g_profile_failed;
2202: --
2203: end if;
2204: --
2205: hr_utility.set_location('leaving chck_zip_code', 10);
2206: --
2207: END check_zip_code_rng;
2208: --
2209: -- --------------------------------------------------------

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

2987: --
2988: end if;
2989:
2990:
2991: --hr_utility.set_location(l_proc||' Entering ',10);
2992: if p_elig_per_elctbl_chc_id is not null then
2993: --
2994: open c_age_param;
2995: --

Line 3018: --hr_utility.set_location(l_proc||' Dn GRP Cac ',10);

3014: ,p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt
3015: ,p_business_group_id => p_business_group_id
3016: ,p_inst_set => l_inst_set
3017: ,p_inst_count => l_inst_count);
3018: --hr_utility.set_location(l_proc||' Dn GRP Cac ',10);
3019: --
3020: if l_inst_count > 0 then
3021: --
3022: -- plan in program is overriden, capture the data from cache by passing plip_id

Line 3047: hr_utility.set_location('Plan not in Program',10);

3043: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
3044: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
3045: l_per_age := l_epo_row.rt_age_val;
3046: else
3047: hr_utility.set_location('Plan not in Program',10);
3048: l_prtn_ovridn_flag := p_currepe_row.prtn_ovridn_flag;
3049: l_prtn_ovridn_thru_dt := p_currepe_row.prtn_ovridn_thru_dt;
3050: l_per_age := p_currepe_row.rt_age_val;
3051: end if;

Line 3104: hr_utility.set_location(' age ' || l_per_age , 610.2);

3100: ,p_perform_rounding_flg => TRUE
3101: ,p_value => l_per_age
3102: ,p_change_date => l_dummy_date);
3103: --
3104: hr_utility.set_location(' age ' || l_per_age , 610.2);
3105: hr_utility.set_location(' mn age ' || l_inst_set(i).mn_age_num , 610.2);
3106: --
3107: l_mx_age_num := l_inst_set(i).mx_age_num ;
3108: --

Line 3105: hr_utility.set_location(' mn age ' || l_inst_set(i).mn_age_num , 610.2);

3101: ,p_value => l_per_age
3102: ,p_change_date => l_dummy_date);
3103: --
3104: hr_utility.set_location(' age ' || l_per_age , 610.2);
3105: hr_utility.set_location(' mn age ' || l_inst_set(i).mn_age_num , 610.2);
3106: --
3107: l_mx_age_num := l_inst_set(i).mx_age_num ;
3108: --
3109: if ( l_inst_set(i).mx_age_num <> trunc(l_inst_set(i).mx_age_num) OR

Line 3120: hr_utility.set_location(' l_mx_age_num '||l_mx_age_num , 610.10);

3116: l_mx_age_num := l_inst_set(i).mx_age_num + 1 ;
3117: --
3118: end if;
3119: --
3120: hr_utility.set_location(' l_mx_age_num '||l_mx_age_num , 610.10);
3121: --
3122: l_ok := (l_per_age >= l_inst_set(i).mn_age_num and
3123: l_per_age < l_mx_age_num )
3124: or

Line 3133: --hr_utility.set_location(' Step 1' ,99);

3129: l_per_age >= l_inst_set(i).mn_age_num);
3130: --
3131: if l_ok is null or l_per_age is null then
3132: --
3133: --hr_utility.set_location(' Step 1' ,99);
3134: l_ok := false;
3135: --
3136: end if;
3137: --

Line 3140: --hr_utility.set_location(' Step 2' ,99);

3136: end if;
3137: --
3138: if l_ok and l_inst_set(i).excld_flag = 'N' then
3139: --
3140: --hr_utility.set_location(' Step 2' ,99);
3141: exit;
3142: --
3143: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
3144: --

Line 3145: --hr_utility.set_location(' Step 3' ,99);

3141: exit;
3142: --
3143: elsif l_ok and l_inst_set(i).excld_flag = 'Y' then
3144: --
3145: --hr_utility.set_location(' Step 3' ,99);
3146: -- raise ben_evaluate_rate_profiles.g_profile_failed;
3147: l_ok := false;
3148: exit ;
3149: --

Line 3157: --hr_utility.set_location(' Step 4' ,99);

3153: -- exit ;
3154: --
3155: elsif l_inst_set(i).excld_flag = 'N' then
3156: --
3157: --hr_utility.set_location(' Step 4' ,99);
3158: l_rows_found := true;
3159: --
3160: end if;
3161: --

Line 3168: --hr_utility.set_location(' Step 5 ' ,99);

3164: end if;
3165: --
3166: if l_rows_found and not l_ok then
3167: --
3168: --hr_utility.set_location(' Step 5 ' ,99);
3169: raise ben_evaluate_rate_profiles.g_profile_failed;
3170: --
3171: end if;
3172: --

Line 3293: hr_utility.set_location( ' compen ' || l_compensation_value , 610.2) ;

3289: ,p_fonm_cvg_strt_dt => ben_manage_life_events.g_fonm_cvg_strt_dt
3290: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3291: ,p_value => l_compensation_value);
3292:
3293: hr_utility.set_location( ' compen ' || l_compensation_value , 610.2) ;
3294: hr_utility.set_location( ' mn compen ' || l_inst_set(i).mn_comp_val , 610.2) ;
3295: --
3296: -- Bug 2101937 fixes
3297: l_mx_comp_val := l_inst_set(i).mx_comp_val ;

Line 3294: hr_utility.set_location( ' mn compen ' || l_inst_set(i).mn_comp_val , 610.2) ;

3290: ,p_fonm_rt_strt_dt => ben_manage_life_events.g_fonm_rt_strt_dt
3291: ,p_value => l_compensation_value);
3292:
3293: hr_utility.set_location( ' compen ' || l_compensation_value , 610.2) ;
3294: hr_utility.set_location( ' mn compen ' || l_inst_set(i).mn_comp_val , 610.2) ;
3295: --
3296: -- Bug 2101937 fixes
3297: l_mx_comp_val := l_inst_set(i).mx_comp_val ;
3298: --

Line 3310: hr_utility.set_location('if' , 610) ;

3306: l_mx_comp_val := l_inst_set(i).mx_comp_val + 1 ;
3307: --
3308: end if;
3309: --
3310: hr_utility.set_location('if' , 610) ;
3311: --
3312: l_ok := (nvl(l_compensation_value,-1) >= l_inst_set(i).mn_comp_val and
3313: nvl(l_compensation_value,9999999) < l_mx_comp_val )
3314: or

Line 3446: hr_utility.set_location('p_vrbl_rt_prfl_id rate level '||p_vrbl_rt_prfl_id,10);

3442: end if;
3443: --
3444: -- Get the data from the cache.
3445: --
3446: hr_utility.set_location('p_vrbl_rt_prfl_id rate level '||p_vrbl_rt_prfl_id,10);
3447: --
3448: ben_rt_prfl_cache.get_rt_prfl_cache
3449: (p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
3450: ,p_effective_date => p_effective_date

Line 3456: hr_utility.set_location('l_per_los rate level '||l_per_los,10);

3452: ,p_business_group_id => p_business_group_id
3453: ,p_inst_set => l_inst_set
3454: ,p_inst_count => l_inst_count);
3455: --
3456: hr_utility.set_location('l_per_los rate level '||l_per_los,10);
3457: hr_utility.set_location('l_inst_count '||l_inst_count,10);
3458: --
3459: if l_inst_count > 0 then
3460: --

Line 3457: hr_utility.set_location('l_inst_count '||l_inst_count,10);

3453: ,p_inst_set => l_inst_set
3454: ,p_inst_count => l_inst_count);
3455: --
3456: hr_utility.set_location('l_per_los rate level '||l_per_los,10);
3457: hr_utility.set_location('l_inst_count '||l_inst_count,10);
3458: --
3459: if l_inst_count > 0 then
3460: --
3461: -- plan in program is overriden, capture the data from cache by passing plip_id

Line 3486: hr_utility.set_location('Plan not in Program',10);

3482: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
3483: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
3484: l_per_los := l_epo_row.rt_los_val;
3485: else
3486: hr_utility.set_location('Plan not in Program',10);
3487: l_prtn_ovridn_flag := p_currepe_row.prtn_ovridn_flag;
3488: l_prtn_ovridn_thru_dt := p_currepe_row.prtn_ovridn_thru_dt;
3489: l_per_los := p_currepe_row.rt_los_val;
3490: end if;

Line 3524: hr_utility.set_location( ' los ' || l_per_los , 610.2);

3520: ,p_perform_rounding_flg => TRUE
3521: ,p_value => l_per_los
3522: ,p_start_date => l_dummy_date);
3523: --
3524: hr_utility.set_location( ' los ' || l_per_los , 610.2);
3525: -- Bug 2101937 fixes
3526: l_mx_los_num := l_inst_set(i).mx_los_num ;
3527: --
3528: if ( l_inst_set(i).mx_los_num <> trunc(l_inst_set(i).mx_los_num) OR

Line 3701: hr_utility.set_location('Plan not in Program',10);

3697: l_prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;
3698: l_prtn_ovridn_thru_dt := l_epo_row.prtn_ovridn_thru_dt;
3699: l_cmbn_age_n_los_val := l_epo_row.rt_cmbn_age_n_los_val;
3700: else
3701: hr_utility.set_location('Plan not in Program',10);
3702: l_prtn_ovridn_flag := p_currepe_row.prtn_ovridn_flag;
3703: l_prtn_ovridn_thru_dt := p_currepe_row.prtn_ovridn_thru_dt;
3704: l_cmbn_age_n_los_val := p_currepe_row.rt_cmbn_age_n_los_val;
3705: end if;

Line 3918: hr_utility.set_location ('l_inst_count:'||l_inst_count,10);

3914: ,p_business_group_id => p_business_group_id
3915: ,p_inst_set => l_inst_set
3916: ,p_inst_count => l_inst_count);
3917: --
3918: hr_utility.set_location ('l_inst_count:'||l_inst_count,10);
3919: if l_inst_count > 0 then
3920: --
3921: -- Data found. Loop through to see if excld flag is on or off.
3922: --

Line 3931: hr_utility.set_location ('did not find quald bnf:',10);

3927: --
3928: open c_get_quald_bnf;
3929: fetch c_get_quald_bnf into l_cqb_rec;
3930: if c_get_quald_bnf%notfound then
3931: hr_utility.set_location ('did not find quald bnf:',10);
3932: close c_get_quald_bnf;
3933: --
3934: -- Bug 1566944 Check for new terminations with qualifying event
3935: -- New a termination life event is processes, system can't find

Line 3943: hr_utility.set_location ('not a new qualifying termination event:',10);

3939: --
3940: open c_ler;
3941: fetch c_ler into l_ler_rec ;
3942: if c_ler%notfound then
3943: hr_utility.set_location ('not a new qualifying termination event:',10);
3944: close c_ler;
3945: raise ben_evaluate_rate_profiles.g_profile_failed;
3946: else
3947: close c_ler;

Line 3969: hr_utility.set_location ('l_strt_dt '||l_strt_dt, 199);

3965: else
3966: l_strt_dt := hr_api.g_sot;
3967: end if;
3968: --
3969: hr_utility.set_location ('l_strt_dt '||l_strt_dt, 199);
3970: -- Calculate the end date.
3971: --
3972: if l_inst_set(i).no_mx_poe_flag = 'N' then
3973: l_end_dt := benutils.derive_date

Line 3984: hr_utility.set_location ('l_end_dt '||l_end_dt , 199);

3980: else
3981: l_end_dt := hr_api.g_eot;
3982: end if;
3983: --
3984: hr_utility.set_location ('l_end_dt '||l_end_dt , 199);
3985: --
3986: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between
3987: l_strt_dt and l_end_dt then
3988: raise ben_evaluate_rate_profiles.g_profile_failed;

Line 4024: hr_utility.set_location ('l_strt_dt '||l_strt_dt, 200);

4020: ,p_min => null
4021: ,p_max => l_mn_poe_num
4022: ,p_value => null
4023: ));
4024: hr_utility.set_location ('l_strt_dt '||l_strt_dt, 200);
4025: else
4026: l_strt_dt := hr_api.g_sot;
4027: end if;
4028: --

Line 4093: hr_utility.set_location ('disability rate applies 60 :',10);

4089: if c_get_dsblity_evt%notfound then
4090: close c_get_dsblity_evt;
4091: --
4092: else
4093: hr_utility.set_location ('disability rate applies 60 :',10);
4094: close c_get_dsblity_evt;
4095: l_dsbld := true;
4096: exit;
4097: end if;

Line 4099: hr_utility.set_location ('disability rate applies tom :',10);

4095: l_dsbld := true;
4096: exit;
4097: end if;
4098: else
4099: hr_utility.set_location ('disability rate applies tom :',10);
4100: l_dsbld := true;
4101: exit;
4102: end if;
4103: end if;

Line 4118: hr_utility.set_location ('event not found',10);

4114: ,l_cqb_rec.cbr_elig_perd_end_dt
4115: );
4116: fetch c_get_arra_evt into l_exists;
4117: if c_get_arra_evt%notfound then
4118: hr_utility.set_location ('event not found',10);
4119: close c_get_arra_evt;
4120: raise ben_evaluate_rate_profiles.g_profile_failed;
4121: else
4122: hr_utility.set_location ('event found',10);

Line 4122: hr_utility.set_location ('event found',10);

4118: hr_utility.set_location ('event not found',10);
4119: close c_get_arra_evt;
4120: raise ben_evaluate_rate_profiles.g_profile_failed;
4121: else
4122: hr_utility.set_location ('event found',10);
4123: close c_get_arra_evt;
4124: l_end_dt := l_end_dt - 1;
4125: hr_utility.set_location ('l_end_dt '||l_end_dt,10);
4126: end if;

Line 4125: hr_utility.set_location ('l_end_dt '||l_end_dt,10);

4121: else
4122: hr_utility.set_location ('event found',10);
4123: close c_get_arra_evt;
4124: l_end_dt := l_end_dt - 1;
4125: hr_utility.set_location ('l_end_dt '||l_end_dt,10);
4126: end if;
4127: end if;
4128: --
4129: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between

Line 4131: hr_utility.set_location ('l_strt_dt'||l_strt_dt,10);

4127: end if;
4128: --
4129: if nvl(p_lf_evt_ocrd_dt, p_effective_date) not between
4130: l_strt_dt and l_end_dt then
4131: hr_utility.set_location ('l_strt_dt'||l_strt_dt,10);
4132: raise ben_evaluate_rate_profiles.g_profile_failed;
4133: end if;
4134: hr_utility.set_location ('p_lf_evt_ocrd_dt'||p_lf_evt_ocrd_dt,10);
4135: end if; -- qualified beneficiary

Line 4134: hr_utility.set_location ('p_lf_evt_ocrd_dt'||p_lf_evt_ocrd_dt,10);

4130: l_strt_dt and l_end_dt then
4131: hr_utility.set_location ('l_strt_dt'||l_strt_dt,10);
4132: raise ben_evaluate_rate_profiles.g_profile_failed;
4133: end if;
4134: hr_utility.set_location ('p_lf_evt_ocrd_dt'||p_lf_evt_ocrd_dt,10);
4135: end if; -- qualified beneficiary
4136: --
4137: <>
4138: null;

Line 4163: hr_utility.set_location ('check_ttl_prtt:'||to_char(p_ttl_prtt),10);

4159: l_inst_count number;
4160: l_profile_match varchar2(1);
4161: --
4162: begin
4163: hr_utility.set_location ('check_ttl_prtt:'||to_char(p_ttl_prtt),10);
4164:
4165: --
4166: -- Get the data from the cache.
4167: --

Line 4193: hr_utility.set_location ('p_ttl:'||to_char(p_ttl_prtt)||

4189: --
4190: -- Data found. Loop through to see we match the total number of prtts.
4191: --
4192: for i in l_inst_set.first..l_inst_set.last loop
4193: hr_utility.set_location ('p_ttl:'||to_char(p_ttl_prtt)||
4194: ' min:'||to_char(l_inst_set(i).mn_prtt_num)||' max:'||
4195: to_char(l_inst_set(i).mx_prtt_num),33);
4196:
4197: if p_ttl_prtt between nvl(l_inst_set(i).mn_prtt_num,0)

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

4225: l_rows_found boolean := false;
4226: --
4227: begin
4228: --
4229: hr_utility.set_location('Entering : '||l_proc,10);
4230: --
4231: -- Get the data from the cache.
4232: --
4233: ben_rt_prfl_cache.get_rt_prfl_cache

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

4305: l_rec per_all_people_f%rowtype;
4306: --
4307: begin
4308: --
4309: hr_utility.set_location('Entering : '||l_proc,10);
4310: --
4311: -- Get the data from the cache.
4312: --
4313: ben_rt_prfl_cache.get_rt_prfl_cache

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

4359: l_rec per_periods_of_service%rowtype;
4360: --
4361: begin
4362: --
4363: hr_utility.set_location('Entering : '||l_proc,10);
4364: --
4365: -- Get the data from the cache.
4366: --
4367: ben_rt_prfl_cache.get_rt_prfl_cache

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

4452: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT');
4453:
4454: begin
4455: --
4456: hr_utility.set_location('Entering : '||l_proc,10);
4457: --
4458: -- Get the data from the cache.
4459: --
4460: ben_rt_prfl_cache.get_rt_prfl_cache

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

4543: and pdp.effective_end_date = hr_api.g_eot;
4544:
4545: begin
4546: --
4547: hr_utility.set_location('Entering : '||l_proc,10);
4548: --
4549: -- Get the data from the cache.
4550: --
4551: ben_rt_prfl_cache.get_rt_prfl_cache

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

4657: and pdp.cvg_thru_dt
4658: and pdp.effective_end_date = hr_api.g_eot;
4659: begin
4660: --
4661: hr_utility.set_location('Entering : '||l_proc,10);
4662: --
4663: -- Get the data from the cache.
4664: --
4665: ben_rt_prfl_cache.get_rt_prfl_cache

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

4783: and reg.effective_end_date;
4784:
4785: begin
4786: --
4787: hr_utility.set_location('Entering : '||l_proc,10);
4788: --
4789: -- Get the data from the cache.
4790: --
4791: ben_rt_prfl_cache.get_rt_prfl_cache

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

4906:
4907:
4908: begin
4909: --
4910: hr_utility.set_location('Entering : '||l_proc,10);
4911: --
4912: -- Get the data from the cache.
4913: --
4914: ben_rt_prfl_cache.get_rt_prfl_cache

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

5015:
5016:
5017: begin
5018: --
5019: hr_utility.set_location('Entering : '||l_proc,10);
5020: --
5021: -- Get the data from the cache.
5022: --
5023: ben_rt_prfl_cache.get_rt_prfl_cache

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

5202: ) ;
5203: --
5204: begin
5205: --
5206: hr_utility.set_location('Entering: '||l_proc, 10);
5207: --
5208: -- Getting variable profile compensation level by variable profile
5209: --
5210: ben_rt_prfl_cache.get_rt_prfl_cache

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

5316: raise g_criteria_failed;
5317: --
5318: end if;
5319: --
5320: hr_utility.set_location('Leaving :'||l_proc,20);
5321: --
5322: end check_othr_ptip ;
5323:
5324: --

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

5344: l_dummy varchar2(1);
5345: --
5346: begin
5347: --
5348: hr_utility.set_location('Entering: '||l_proc, 10);
5349:
5350: --
5351: ben_rt_prfl_cache.get_rt_prfl_cache
5352: (p_effective_date => nvl(p_lf_evt_ocrd_dt,p_effective_date),

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

5429: raise g_criteria_failed;
5430: --
5431: end if;
5432: --
5433: hr_utility.set_location('Leaving :'||l_proc,20);
5434: --
5435: end check_enrld_anthr_pl;
5436: --
5437: -- --------------------------------------------------------------------------

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

5468: and pen.prtt_enrt_rslt_stat_cd is null;
5469: --
5470: begin
5471: --
5472: hr_utility.set_location('Entering: '||l_proc, 10);
5473: --
5474: -- Getting variable rate profile compensation level by variable profile
5475: --
5476: ben_rt_prfl_cache.get_rt_prfl_cache

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

5556: raise g_criteria_failed;
5557: --
5558: end if;
5559: --
5560: hr_utility.set_location('Leaving :'||l_proc,20);
5561: --
5562: end check_enrld_anthr_oipl;
5563:
5564:

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

5609:
5610: --
5611: begin
5612: --
5613: hr_utility.set_location('Entering: '||l_proc, 10);
5614: --
5615: -- Getting variable rate profile compensation level
5616: --
5617: ben_rt_prfl_cache.get_rt_prfl_cache

Line 5638: hr_utility.set_location('Getting profiles',10);

5634: -- then no problem.
5635: -- 5) If person eligible for any of the plans and exclude flag = 'N'
5636: -- then fail criteria.
5637: --
5638: hr_utility.set_location('Getting profiles',10);
5639: <>
5640: for i in l_inst_set.first..l_inst_set.last loop
5641: --
5642: l_rows_found := true;

Line 5644: hr_utility.set_location('Getting results',10);

5640: for i in l_inst_set.first..l_inst_set.last loop
5641: --
5642: l_rows_found := true;
5643: --
5644: hr_utility.set_location('Getting results',10);
5645: <>
5646: for l_count in nvl(ben_manage_life_events.g_cache_person_prtn.first,0)..
5647: nvl(ben_manage_life_events.g_cache_person_prtn.last,-1) loop
5648: if ben_manage_life_events.

Line 5666: hr_utility.set_location('Getting cobra plans',10);

5662: -- If only check plans that are subject to COBRA.
5663: --
5664: l_continue := true;
5665: --
5666: hr_utility.set_location('Getting cobra plans',10);
5667: --
5668: if l_inst_set(i).only_pls_subj_cobra_flag = 'Y' then
5669: --
5670: open c1(ben_manage_life_events.g_cache_person_prtn(l_count).pl_id);

Line 5676: hr_utility.set_location('Cobra plans not found',10);

5672: fetch c1 into l_dummy;
5673: --
5674: if c1%notfound then
5675: --
5676: hr_utility.set_location('Cobra plans not found',10);
5677: l_continue := false;
5678: --
5679: end if;
5680: --

Line 5687: hr_utility.set_location('Cobra plans found',10);

5683: end if;
5684: --
5685: if l_continue then
5686: --
5687: hr_utility.set_location('Cobra plans found',10);
5688: --
5689: if (l_date_to_use
5690: between ben_manage_life_events.
5691: g_cache_person_prtn(l_count).enrt_cvg_strt_dt

Line 5699: hr_utility.set_location('Exclude flags = N Cobra plans found',10);

5695: l_found_ptip := true;
5696: --
5697: if l_inst_set(i).excld_flag = 'N' then
5698: --
5699: hr_utility.set_location('Exclude flags = N Cobra plans found',10);
5700: l_ok := true;
5701: exit prfl;
5702: --
5703: end if;

Line 5707: hr_utility.set_location('Exclude flags = Y Cobra plans found',10);

5703: end if;
5704: --
5705: if l_inst_set(i).excld_flag = 'Y' then
5706: --
5707: hr_utility.set_location('Exclude flags = Y Cobra plans found',10);
5708: l_ok := false;
5709: exit prfl;
5710: --
5711: end if;

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

5736: raise g_criteria_failed;
5737: --
5738: end if;
5739: --
5740: hr_utility.set_location('Leaving :'||l_proc,20);
5741: --
5742: end check_enrld_anthr_ptip;
5743:
5744:

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

5782: and pen.prtt_enrt_rslt_stat_cd is null;
5783: --
5784: begin
5785: --
5786: hr_utility.set_location('Entering: '||l_proc, 10);
5787: --
5788: -- Getting variable profile compensation level by variable profile
5789: --
5790: ben_rt_prfl_cache.get_rt_prfl_cache

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

5854: raise g_criteria_failed;
5855: --
5856: end if;
5857: --
5858: hr_utility.set_location('Leaving :'||l_proc,20);
5859: --
5860: end check_enrld_anthr_plip;
5861:
5862:

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

5886: l_dummy varchar2(1);
5887: --
5888: begin
5889: --
5890: hr_utility.set_location('Entering: '||l_proc, 10);
5891: hr_utility.set_location('prfl_id: '||p_vrbl_rt_prfl_id, 10);
5892: --
5893: -- Getting variable profile compensation level
5894: --

Line 5891: hr_utility.set_location('prfl_id: '||p_vrbl_rt_prfl_id, 10);

5887: --
5888: begin
5889: --
5890: hr_utility.set_location('Entering: '||l_proc, 10);
5891: hr_utility.set_location('prfl_id: '||p_vrbl_rt_prfl_id, 10);
5892: --
5893: -- Getting variable profile compensation level
5894: --
5895: ben_rt_prfl_cache.get_rt_prfl_cache

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

5976: raise g_criteria_failed;
5977: --
5978: end if;
5979: --
5980: hr_utility.set_location('Leaving :'||l_proc,20);
5981: --
5982: end check_enrld_anthr_pgm;
5983:
5984: --

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

6061: between epo.effective_start_date and epo.effective_end_date;
6062: --
6063: begin
6064: --
6065: hr_utility.set_location('Entering: '||l_proc, 10);
6066: --
6067: -- Getting variable profile compensation level by variable profile
6068: --
6069: ben_rt_prfl_cache.get_rt_prfl_cache

Line 6079: hr_utility.set_location('l_inst_count: '||l_inst_count, 10);

6075: p_inst_count => l_inst_count);
6076:
6077:
6078: --
6079: hr_utility.set_location('l_inst_count: '||l_inst_count, 10);
6080: --
6081: if l_inst_count > 0 then
6082: --
6083: -- Operation

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

6145: raise g_criteria_failed;
6146: --
6147: end if;
6148: --
6149: hr_utility.set_location('Leaving :'||l_proc,20);
6150: --
6151: end check_dpnt_othr_ptip;
6152:
6153:

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

6171:
6172:
6173: begin
6174: --
6175: hr_utility.set_location('Entering : '||l_proc,10);
6176: --
6177: -- Get the data from the cache.
6178: --
6179: ben_rt_prfl_cache.get_rt_prfl_cache

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

6228:
6229:
6230: begin
6231: --
6232: hr_utility.set_location('Entering : '||l_proc,10);
6233: --
6234: -- Get the data from the cache.
6235: --
6236: ben_rt_prfl_cache.get_rt_prfl_cache

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

6313: and pce.business_group_id = p_business_group_id ;
6314:
6315: begin
6316: --
6317: hr_utility.set_location('Entering : '||l_proc,10);
6318: --
6319: -- Get the data from the cache.
6320: --
6321: ben_rt_prfl_cache.get_rt_prfl_cache

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

6407: and pqt.business_group_id = p_business_group_id ;
6408:
6409: begin
6410: --
6411: hr_utility.set_location('Entering : '||l_proc,10);
6412: --
6413: -- Get the data from the cache.
6414: --
6415: ben_rt_prfl_cache.get_rt_prfl_cache

Line 6491: hr_utility.set_location ('check_ttl_cvg:'||to_char(p_ttl_cvg),10);

6487: l_inst_count number;
6488: l_profile_match varchar2(1);
6489: --
6490: begin
6491: hr_utility.set_location ('check_ttl_cvg:'||to_char(p_ttl_cvg),10);
6492:
6493: --
6494: -- Get the data from the cache.
6495: --

Line 6521: hr_utility.set_location ('min:'||to_char(l_inst_set(i).mn_cvg_vol_amt)||

6517: --
6518: -- Data found. Loop through to see we match the total amount of cvg.
6519: --
6520: for i in l_inst_set.first..l_inst_set.last loop
6521: hr_utility.set_location ('min:'||to_char(l_inst_set(i).mn_cvg_vol_amt)||
6522: ' max:'||to_char(l_inst_set(i).mx_cvg_vol_amt),14);
6523: if p_ttl_cvg between nvl(l_inst_set(i).mn_cvg_vol_amt,0)
6524: and nvl(l_inst_set(i).mx_cvg_vol_amt,999999999999999) then
6525: -- we match one of the ranges, exit with success.

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

6644: END;
6645: --
6646: begin
6647: --
6648: hr_utility.set_location('Entering : '||l_proc,10);
6649: --
6650: -- Get the data from the cache.
6651: --
6652: ben_rt_prfl_cache.get_rt_prfl_cache

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

6819: --
6820:
6821: begin
6822: --
6823: hr_utility.set_location('Entering : '||l_proc,10);
6824: --
6825: -- Get the data from the cache.
6826: --
6827: ben_rt_prfl_cache.get_rt_prfl_cache

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

7031: l_package varchar2(80) := g_package||'.load_globals';
7032: l_insert_record varchar2(1);
7033: l_ctr number;
7034: begin
7035: -- hr_utility.set_location ('Entering '||l_package,10);
7036:
7037: if p_all_prfls then
7038: -- load the 'all prfls' globals. These globals use the actl_prem_vrbl_rt.ordr_num
7039: -- as it's index, because the second time we loop thru them, we need them in

Line 7052: hr_utility.set_location ('added to profile:'||

7048: if g_all_prfls(l_ctr).vrbl_rt_prfl_id = p_vrbl_rt_prfl_id then
7049: g_all_prfls(l_ctr).match_cnt := g_all_prfls(l_ctr).match_cnt+1;
7050: g_all_prfls(l_ctr).match_cvg := g_all_prfls(l_ctr).match_cvg+p_bnft_amt;
7051: l_insert_record := 'N';
7052: hr_utility.set_location ('added to profile:'||
7053: to_char(p_vrbl_rt_prfl_id)||
7054: ' new num:'||to_char(g_all_prfls(l_ctr).match_cnt)||
7055: ' new cvg:'||to_char(g_all_prfls(l_ctr).match_cvg),16);
7056:

Line 7074: hr_utility.set_location ('added new profile '||

7070: g_all_prfls(p_ordr_num).vrbl_rt_prfl_id :=
7071: p_vrbl_rt_prfl_id;
7072: g_all_prfls(p_ordr_num).match_cnt := 1;
7073: g_all_prfls(p_ordr_num).match_cvg := p_bnft_amt;
7074: hr_utility.set_location ('added new profile '||
7075: to_char(p_vrbl_rt_prfl_id)||
7076: ' cvg:'||to_char(p_bnft_amt)||
7077: ' p_ordr_num:'||to_char(p_ordr_num),18);
7078:

Line 7152: hr_utility.set_location ('added to profile:'||

7148: if g_use_prfls(y).vrbl_rt_prfl_id = p_vrbl_rt_prfl_id then
7149: g_use_prfls(y).match_cnt := g_use_prfls(y).match_cnt+1;
7150: g_use_prfls(y).match_cvg := g_use_prfls(y).match_cvg+p_bnft_amt;
7151: l_insert_record := 'N';
7152: hr_utility.set_location ('added to profile:'||
7153: to_char(p_vrbl_rt_prfl_id)||
7154: ' new num:'||to_char(g_use_prfls(y).match_cnt)||
7155: ' new cvg:'||to_char(g_use_prfls(y).match_cvg),26);
7156: exit;

Line 7168: hr_utility.set_location ('added new profile '||

7164: g_use_prfls(g_num_of_prfls_used).vrbl_rt_prfl_id :=
7165: p_vrbl_rt_prfl_id;
7166: g_use_prfls(g_num_of_prfls_used).match_cnt := 1;
7167: g_use_prfls(g_num_of_prfls_used).match_cvg := p_bnft_amt;
7168: hr_utility.set_location ('added new profile '||
7169: to_char(p_vrbl_rt_prfl_id)||
7170: ' cvg:'||to_char(p_bnft_amt),28);
7171: end if;
7172: end if;

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

7169: to_char(p_vrbl_rt_prfl_id)||
7170: ' cvg:'||to_char(p_bnft_amt),28);
7171: end if;
7172: end if;
7173: -- hr_utility.set_location ('Leaving '||l_package,99);
7174: end load_globals;
7175: --
7176: --
7177: -- ---------------------------------------------------------------------------

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

7270: --
7271: --
7272: begin
7273: --
7274: hr_utility.set_location ('Entering '||l_package,10);
7275: hr_utility.set_location( 'elig per elect id ' || p_elig_per_elctbl_chc_id, 610.3);
7276: --Bug 5077452
7277: if fnd_global.conc_request_id = -1 then
7278: --

Line 7275: hr_utility.set_location( 'elig per elect id ' || p_elig_per_elctbl_chc_id, 610.3);

7271: --
7272: begin
7273: --
7274: hr_utility.set_location ('Entering '||l_package,10);
7275: hr_utility.set_location( 'elig per elect id ' || p_elig_per_elctbl_chc_id, 610.3);
7276: --Bug 5077452
7277: if fnd_global.conc_request_id = -1 then
7278: --
7279: ben_env_object.init(p_business_group_id => p_business_group_id,

Line 7300: hr_utility.set_location('p_all_prfls -> true',11);

7296: --
7297: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
7298: --
7299: if p_all_prfls then
7300: hr_utility.set_location('p_all_prfls -> true',11);
7301: else hr_utility.set_location('p_all_prfls -> false',11); end if;
7302: if p_use_globals then
7303: hr_utility.set_location('p_use_globals -> true',11);
7304: else hr_utility.set_location('p_use_globals -> false',11); end if;

Line 7301: else hr_utility.set_location('p_all_prfls -> false',11); end if;

7297: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date);
7298: --
7299: if p_all_prfls then
7300: hr_utility.set_location('p_all_prfls -> true',11);
7301: else hr_utility.set_location('p_all_prfls -> false',11); end if;
7302: if p_use_globals then
7303: hr_utility.set_location('p_use_globals -> true',11);
7304: else hr_utility.set_location('p_use_globals -> false',11); end if;
7305:

Line 7303: hr_utility.set_location('p_use_globals -> true',11);

7299: if p_all_prfls then
7300: hr_utility.set_location('p_all_prfls -> true',11);
7301: else hr_utility.set_location('p_all_prfls -> false',11); end if;
7302: if p_use_globals then
7303: hr_utility.set_location('p_use_globals -> true',11);
7304: else hr_utility.set_location('p_use_globals -> false',11); end if;
7305:
7306: if p_person_id is NULL then
7307: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');

Line 7304: else hr_utility.set_location('p_use_globals -> false',11); end if;

7300: hr_utility.set_location('p_all_prfls -> true',11);
7301: else hr_utility.set_location('p_all_prfls -> false',11); end if;
7302: if p_use_globals then
7303: hr_utility.set_location('p_use_globals -> true',11);
7304: else hr_utility.set_location('p_use_globals -> false',11); end if;
7305:
7306: if p_person_id is NULL then
7307: fnd_message.set_name('BEN','BEN_91521_BERP_PERSON_ID');
7308: fnd_message.set_token('PACKAGE',l_package);

Line 7393: hr_utility.set_location('clearing cache' || nvl(l_fonm_cvg_strt_dt,l_effective_date) ,10);

7389: -- fonm check the date of the person cache
7390: if not nvl(l_fonm_cvg_strt_dt,l_effective_date)
7391: between l_per_rec.effective_start_date and l_per_rec.effective_end_date then
7392:
7393: hr_utility.set_location('clearing cache' || nvl(l_fonm_cvg_strt_dt,l_effective_date) ,10);
7394: hr_utility.set_location('cache start ' || l_per_rec.effective_start_date ,10);
7395: hr_utility.set_location('cache end ' || l_per_rec.effective_end_date ,10);
7396:
7397: ben_use_cvg_rt_date.fonm_clear_down_cache;

Line 7394: hr_utility.set_location('cache start ' || l_per_rec.effective_start_date ,10);

7390: if not nvl(l_fonm_cvg_strt_dt,l_effective_date)
7391: between l_per_rec.effective_start_date and l_per_rec.effective_end_date then
7392:
7393: hr_utility.set_location('clearing cache' || nvl(l_fonm_cvg_strt_dt,l_effective_date) ,10);
7394: hr_utility.set_location('cache start ' || l_per_rec.effective_start_date ,10);
7395: hr_utility.set_location('cache end ' || l_per_rec.effective_end_date ,10);
7396:
7397: ben_use_cvg_rt_date.fonm_clear_down_cache;
7398: --

Line 7395: hr_utility.set_location('cache end ' || l_per_rec.effective_end_date ,10);

7391: between l_per_rec.effective_start_date and l_per_rec.effective_end_date then
7392:
7393: hr_utility.set_location('clearing cache' || nvl(l_fonm_cvg_strt_dt,l_effective_date) ,10);
7394: hr_utility.set_location('cache start ' || l_per_rec.effective_start_date ,10);
7395: hr_utility.set_location('cache end ' || l_per_rec.effective_end_date ,10);
7396:
7397: ben_use_cvg_rt_date.fonm_clear_down_cache;
7398: --
7399: ben_person_object.get_object(p_person_id => p_person_id,

Line 7402: hr_utility.set_location('nw cache start ' || l_per_rec.effective_start_date ,10);

7398: --
7399: ben_person_object.get_object(p_person_id => p_person_id,
7400: p_rec => l_per_rec);
7401:
7402: hr_utility.set_location('nw cache start ' || l_per_rec.effective_start_date ,10);
7403: hr_utility.set_location('nw cache end ' || l_per_rec.effective_end_date ,10);
7404: end if ;
7405:
7406:

Line 7403: hr_utility.set_location('nw cache end ' || l_per_rec.effective_end_date ,10);

7399: ben_person_object.get_object(p_person_id => p_person_id,
7400: p_rec => l_per_rec);
7401:
7402: hr_utility.set_location('nw cache start ' || l_per_rec.effective_start_date ,10);
7403: hr_utility.set_location('nw cache end ' || l_per_rec.effective_end_date ,10);
7404: end if ;
7405:
7406:
7407:

Line 7512: hr_utility.set_location( ' else if ',610);

7508: --
7509: if p_currepe_row.elig_per_elctbl_chc_id is not null
7510: then
7511: --
7512: hr_utility.set_location( ' else if ',610);
7513: hr_utility.set_location( ' PLIP ID '|| p_currepe_row.plip_id ,610);
7514: l_epe.pgm_id := p_currepe_row.pgm_id;
7515: l_epe.pl_id := p_currepe_row.pl_id;
7516: l_epe.pl_typ_id := p_currepe_row.pl_typ_id;

Line 7513: hr_utility.set_location( ' PLIP ID '|| p_currepe_row.plip_id ,610);

7509: if p_currepe_row.elig_per_elctbl_chc_id is not null
7510: then
7511: --
7512: hr_utility.set_location( ' else if ',610);
7513: hr_utility.set_location( ' PLIP ID '|| p_currepe_row.plip_id ,610);
7514: l_epe.pgm_id := p_currepe_row.pgm_id;
7515: l_epe.pl_id := p_currepe_row.pl_id;
7516: l_epe.pl_typ_id := p_currepe_row.pl_typ_id;
7517: l_epe.oipl_id := p_currepe_row.oipl_id;

Line 7525: hr_utility.set_location( ' in cursor ',610) ;

7521: l_epe.plip_id := p_currepe_row.plip_id;
7522: l_epe.business_group_id := p_currepe_row.business_group_id;
7523: --
7524: else
7525: hr_utility.set_location( ' in cursor ',610) ;
7526: open c_epe;
7527: fetch c_epe into l_epe;
7528: close c_epe;
7529: end if;

Line 7531: hr_utility.set_location(' oipl id ' || l_epe.oipl_id , 610.3);

7527: fetch c_epe into l_epe;
7528: close c_epe;
7529: end if;
7530: --
7531: hr_utility.set_location(' oipl id ' || l_epe.oipl_id , 610.3);
7532: hr_utility.set_location( ' PLIP ID '|| l_epe.plip_id ,610);
7533: if l_epe.oipl_id is not null then
7534: ben_comp_object.get_object(p_oipl_id => l_epe.oipl_id
7535: ,p_rec => l_oipl_rec);

Line 7532: hr_utility.set_location( ' PLIP ID '|| l_epe.plip_id ,610);

7528: close c_epe;
7529: end if;
7530: --
7531: hr_utility.set_location(' oipl id ' || l_epe.oipl_id , 610.3);
7532: hr_utility.set_location( ' PLIP ID '|| l_epe.plip_id ,610);
7533: if l_epe.oipl_id is not null then
7534: ben_comp_object.get_object(p_oipl_id => l_epe.oipl_id
7535: ,p_rec => l_oipl_rec);
7536: end if;

Line 7554: hr_utility.set_location ('Prof loop '||l_package,10);

7550: ,p_inst_set => l_inst_set
7551: );
7552: end if;
7553:
7554: hr_utility.set_location ('Prof loop '||l_package,10);
7555: for i in 1..l_inst_set.count
7556: loop
7557: --
7558: begin

Line 7654: hr_utility.set_location('l_profile.vrbl_rt_prfl_id -> '||l_profile.vrbl_rt_prfl_id,11);

7650: --
7651: ben_person_object.get_object(p_person_id => p_person_id, -- FONM 9999
7652: p_rec => l_typ_rec);
7653: --
7654: hr_utility.set_location('l_profile.vrbl_rt_prfl_id -> '||l_profile.vrbl_rt_prfl_id,11);
7655: hr_utility.set_location('l_profile.rt_per_typ_flag -> '||l_profile.rt_per_typ_flag,11);
7656: --
7657: if l_profile.rt_elig_prfl_flag = 'Y' then
7658: hr_utility.set_location('elig_for_profiles',10);

Line 7655: hr_utility.set_location('l_profile.rt_per_typ_flag -> '||l_profile.rt_per_typ_flag,11);

7651: ben_person_object.get_object(p_person_id => p_person_id, -- FONM 9999
7652: p_rec => l_typ_rec);
7653: --
7654: hr_utility.set_location('l_profile.vrbl_rt_prfl_id -> '||l_profile.vrbl_rt_prfl_id,11);
7655: hr_utility.set_location('l_profile.rt_per_typ_flag -> '||l_profile.rt_per_typ_flag,11);
7656: --
7657: if l_profile.rt_elig_prfl_flag = 'Y' then
7658: hr_utility.set_location('elig_for_profiles',10);
7659:

Line 7658: hr_utility.set_location('elig_for_profiles',10);

7654: hr_utility.set_location('l_profile.vrbl_rt_prfl_id -> '||l_profile.vrbl_rt_prfl_id,11);
7655: hr_utility.set_location('l_profile.rt_per_typ_flag -> '||l_profile.rt_per_typ_flag,11);
7656: --
7657: if l_profile.rt_elig_prfl_flag = 'Y' then
7658: hr_utility.set_location('elig_for_profiles',10);
7659:
7660: l_eligible :=
7661: ben_evaluate_elig_profiles.eligible
7662: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id

Line 7695: hr_utility.set_location ('Dn elig_for_profiles '||l_package,10);

7691: raise g_profile_failed;
7692: --
7693: end if;
7694: end if;
7695: hr_utility.set_location ('Dn elig_for_profiles '||l_package,10);
7696:
7697: if l_profile.rt_per_typ_flag = 'Y' then
7698: hr_utility.set_location('check_per_typ',10);
7699: check_per_typ

Line 7698: hr_utility.set_location('check_per_typ',10);

7694: end if;
7695: hr_utility.set_location ('Dn elig_for_profiles '||l_package,10);
7696:
7697: if l_profile.rt_per_typ_flag = 'Y' then
7698: hr_utility.set_location('check_per_typ',10);
7699: check_per_typ
7700: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7701: p_person_id => p_person_id,
7702: p_business_group_id => p_business_group_id,

Line 7707: hr_utility.set_location ('Dn check_per_typ '||l_package,10);

7703: p_effective_date => p_effective_date,
7704: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
7705: p_person_type => l_typ_rec);
7706: end if;
7707: hr_utility.set_location ('Dn check_per_typ '||l_package,10);
7708: --
7709: -- Now we check these profiles using the required assignment type
7710: --
7711: l_loop_count := 1;

Line 7836: hr_utility.set_location ('l_asg_rec'|| l_asg_rec.assignment_id,534511234);

7832: --
7833: end if;
7834: --
7835: -- Bug 6399423
7836: hr_utility.set_location ('l_asg_rec'|| l_asg_rec.assignment_id,534511234);
7837: --
7838: if (l_profile.asmt_to_use_cd <> 'ANY' and
7839: l_asg_rec.assignment_id is null) then
7840: --

Line 7845: hr_utility.set_location ('ASG Profs '||l_package,10);

7841: raise ben_evaluate_rate_profiles.g_profile_failed;
7842: end if;
7843: --
7844: -- Bug 6399423
7845: hr_utility.set_location ('ASG Profs '||l_package,10);
7846: for l_count in 1..l_loop_count loop
7847: --
7848: begin
7849: --

Line 7861: hr_utility.set_location('check_ee_stat',10);

7857: --
7858: -- Employee Status
7859: --
7860: if l_profile.rt_ee_stat_flag = 'Y' then
7861: hr_utility.set_location('check_ee_stat',10);
7862: check_ee_stat
7863: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7864: p_person_id => p_person_id,
7865: p_business_group_id => p_business_group_id,

Line 7874: hr_utility.set_location('check_people_group',10);

7870: --
7871: -- People Group
7872: --
7873: if l_profile.rt_ppl_grp_flag = 'Y' then
7874: hr_utility.set_location('check_people_group',10);
7875: check_people_group
7876: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7877: p_business_group_id => p_business_group_id,
7878: p_effective_date => p_effective_date,

Line 7886: hr_utility.set_location('check_hourly_salary',10);

7882: --
7883: -- Hourly/Salary Code
7884: --
7885: if l_profile.rt_hrly_slrd_flag = 'Y' then
7886: hr_utility.set_location('check_hourly_salary',10);
7887: check_hourly_salary
7888: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7889: p_business_group_id => p_business_group_id,
7890: p_effective_date => p_effective_date,

Line 7898: hr_utility.set_location('check_brgng_unit',10);

7894: --
7895: -- Bargaining Unit
7896: --
7897: if l_profile.rt_brgng_unit_flag = 'Y' then
7898: hr_utility.set_location('check_brgng_unit',10);
7899: check_brgng_unit
7900: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7901: p_business_group_id => p_business_group_id,
7902: p_effective_date => p_effective_date,

Line 7910: hr_utility.set_location('check_lbr_union',10);

7906: --
7907: -- Labor Union
7908: --
7909: if l_profile.rt_lbr_mmbr_flag = 'Y' then
7910: hr_utility.set_location('check_lbr_union',10);
7911: check_lbr_union
7912: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7913: p_person_id => p_person_id,
7914: p_business_group_id => p_business_group_id,

Line 7923: hr_utility.set_location('check_fl_tm_pt',10);

7919: --
7920: -- Full Time / Part Time
7921: --
7922: if l_profile.rt_fl_tm_pt_tm_flag = 'Y' then
7923: hr_utility.set_location('check_fl_tm_pt',10);
7924: check_fl_tm_pt
7925: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7926: p_person_id => p_person_id,
7927: p_business_group_id => p_business_group_id,

Line 7936: hr_utility.set_location('check_wk_location',10);

7932: --
7933: -- Work Location
7934: --
7935: if l_profile.rt_wk_loc_flag = 'Y' then
7936: hr_utility.set_location('check_wk_location',10);
7937: check_wk_location
7938: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7939: p_person_id => p_person_id,
7940: p_business_group_id => p_business_group_id,

Line 7949: hr_utility.set_location('check_org_unit',10);

7945: --
7946: -- Organization
7947: --
7948: if l_profile.rt_org_unit_flag = 'Y' then
7949: hr_utility.set_location('check_org_unit',10);
7950: check_org_unit
7951: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7952: p_person_id => p_person_id,
7953: p_business_group_id => p_business_group_id,

Line 7962: hr_utility.set_location('check_loa_rsn',10);

7958: --
7959: -- LOA
7960: --
7961: if l_profile.rt_loa_rsn_flag = 'Y' then
7962: hr_utility.set_location('check_loa_rsn',10);
7963: check_loa_rsn
7964: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7965: p_person_id => p_person_id,
7966: p_business_group_id => p_business_group_id,

Line 7974: hr_utility.set_location('check_sched_hrs',10);

7970: --
7971: -- Scheduled Hours
7972: --
7973: if l_profile.rt_schedd_hrs_flag = 'Y' then
7974: hr_utility.set_location('check_sched_hrs',10);
7975: check_sched_hrs
7976: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
7977: p_person_id => p_person_id,
7978: p_business_group_id => p_business_group_id,

Line 7998: hr_utility.set_location('check_py_bss',10);

7994: --
7995: -- Pay Basis
7996: --
7997: if l_profile.rt_py_bss_flag = 'Y' then
7998: hr_utility.set_location('check_py_bss',10);
7999: check_py_bss
8000: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8001: p_person_id => p_person_id,
8002: p_business_group_id => p_business_group_id,

Line 8011: hr_utility.set_location('check_grade',10);

8007: --
8008: -- Grade
8009: --
8010: if l_profile.rt_grd_flag = 'Y' then
8011: hr_utility.set_location('check_grade',10);
8012: check_grade
8013: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8014: p_person_id => p_person_id,
8015: p_business_group_id => p_business_group_id,

Line 8024: hr_utility.set_location('check_lgl_enty',10);

8020: --
8021: -- Legal Entity
8022: --
8023: if l_profile.rt_lgl_enty_flag = 'Y' then
8024: hr_utility.set_location('check_lgl_enty',10);
8025: open c_gre(l_asg_rec.soft_coding_keyflex_id);
8026: --
8027: fetch c_gre into l_gre_id;
8028: --

Line 8043: hr_utility.set_location('check_pyrl',10);

8039: --
8040: -- Payroll
8041: --
8042: if l_profile.rt_pyrl_flag = 'Y' then
8043: hr_utility.set_location('check_pyrl',10);
8044: check_pyrl
8045: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8046: p_person_id => p_person_id,
8047: p_business_group_id => p_business_group_id,

Line 8057: hr_utility.set_location('check_job',10);

8053: --
8054: -- Job
8055: --
8056: if l_profile.rt_job_flag = 'Y' then
8057: hr_utility.set_location('check_job',10);
8058: check_job
8059: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8060: p_business_group_id => p_business_group_id,
8061: p_effective_date => p_effective_date,

Line 8070: hr_utility.set_location('check_pstn',10);

8066: --
8067: -- Postion
8068: --
8069: if l_profile.rt_pstn_flag = 'Y' then
8070: hr_utility.set_location('check_pstn',10);
8071: check_pstn
8072: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8073: p_business_group_id => p_business_group_id,
8074: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,

Line 8083: hr_utility.set_location('check_qua_in_gr',10);

8079: --
8080: -- Quartile in Grade
8081: --
8082: if l_profile.rt_qua_in_gr_flag = 'Y' then
8083: hr_utility.set_location('check_qua_in_gr',10);
8084: check_qua_in_gr(p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8085: p_business_group_id => p_business_group_id,
8086: p_person_id => p_person_id,
8087: p_grade_id => l_asg_rec.grade_id,

Line 8098: hr_utility.set_location('check_perf_rtng',10);

8094: --
8095: -- Performance Rating
8096: --
8097: if l_profile.rt_perf_rtng_flag = 'Y' then
8098: hr_utility.set_location('check_perf_rtng',10);
8099: check_perf_rtng(p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8100: p_business_group_id => p_business_group_id,
8101: p_assignment_id => l_asg_rec.assignment_id,
8102: p_person_id => p_person_id,

Line 8111: hr_utility.set_location('check_rules',10);

8107: --
8108: -- Rules
8109: --
8110: if l_profile.rt_prfl_rl_flag = 'Y' then
8111: hr_utility.set_location('check_rules',10);
8112: check_rules
8113: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8114: p_business_group_id => p_business_group_id,
8115: p_effective_date => p_effective_date,

Line 8160: hr_utility.set_location ('Person Profs '||l_package,10);

8156: --
8157: --
8158: -- PCT Fulltime
8159: --
8160: hr_utility.set_location ('Person Profs '||l_package,10);
8161: if l_profile.rt_pct_fl_tm_flag = 'Y' then
8162: hr_utility.set_location('check_pct_fltm',10);
8163: check_pct_fltm
8164: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,

Line 8162: hr_utility.set_location('check_pct_fltm',10);

8158: -- PCT Fulltime
8159: --
8160: hr_utility.set_location ('Person Profs '||l_package,10);
8161: if l_profile.rt_pct_fl_tm_flag = 'Y' then
8162: hr_utility.set_location('check_pct_fltm',10);
8163: check_pct_fltm
8164: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8165: p_person_id => p_person_id,
8166: p_business_group_id => p_business_group_id,

Line 8182: hr_utility.set_location('check_benefits_group',10);

8178: --
8179: -- Benefits Group
8180: --
8181: if l_profile.rt_benfts_grp_flag = 'Y' then
8182: hr_utility.set_location('check_benefits_group',10);
8183: check_benefits_grp
8184: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8185: p_person_id => p_person_id,
8186: p_business_group_id => p_business_group_id,

Line 8194: hr_utility.set_location ('DF Profs '||l_package,10);

8190: end if;
8191: --
8192: -- Age
8193: --
8194: hr_utility.set_location ('DF Profs '||l_package,10);
8195: if l_profile.rt_age_flag = 'Y' then
8196: hr_utility.set_location('check_age',10);
8197: check_age
8198: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id

Line 8196: hr_utility.set_location('check_age',10);

8192: -- Age
8193: --
8194: hr_utility.set_location ('DF Profs '||l_package,10);
8195: if l_profile.rt_age_flag = 'Y' then
8196: hr_utility.set_location('check_age',10);
8197: check_age
8198: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id
8199: ,p_per_dob => l_per_rec.date_of_birth
8200: ,p_person_id => p_person_id

Line 8217: hr_utility.set_location ('Tobacco '||l_package,10);

8213: end if;
8214: --
8215: -- Tobacco
8216: --
8217: hr_utility.set_location ('Tobacco '||l_package,10);
8218: if l_profile.rt_tbco_use_flag = 'Y' then
8219: hr_utility.set_location('check_tobacco',10);
8220: check_tobacco
8221: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,

Line 8219: hr_utility.set_location('check_tobacco',10);

8215: -- Tobacco
8216: --
8217: hr_utility.set_location ('Tobacco '||l_package,10);
8218: if l_profile.rt_tbco_use_flag = 'Y' then
8219: hr_utility.set_location('check_tobacco',10);
8220: check_tobacco
8221: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8222: p_business_group_id => p_business_group_id,
8223: p_effective_date => p_effective_date,

Line 8231: hr_utility.set_location ('LOS Prof '||l_package,10);

8227: end if;
8228: --
8229: -- LOS
8230: --
8231: hr_utility.set_location ('LOS Prof '||l_package,10);
8232: if l_profile.rt_los_flag = 'Y' then
8233: hr_utility.set_location('check_los',10);
8234: check_los
8235: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,

Line 8233: hr_utility.set_location('check_los',10);

8229: -- LOS
8230: --
8231: hr_utility.set_location ('LOS Prof '||l_package,10);
8232: if l_profile.rt_los_flag = 'Y' then
8233: hr_utility.set_location('check_los',10);
8234: check_los
8235: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8236: p_person_id => p_person_id,
8237: p_business_group_id => p_business_group_id,

Line 8251: hr_utility.set_location('Assn Set Flag',10);

8247: end if;
8248: --
8249: -- Assignment set
8250: if l_profile.rt_asnt_set_flag = 'Y' then
8251: hr_utility.set_location('Assn Set Flag',10);
8252: check_asnt_set
8253: (p_VRBL_RT_PRFL_ID => l_profile.vrbl_rt_prfl_id,
8254: p_business_group_id => p_business_group_id,
8255: p_person_id => p_person_id,

Line 8262: hr_utility.set_location('check_hrs_wkd',10);

8258: end if;
8259: -- Hours worked
8260: --
8261: if l_profile.rt_hrs_wkd_flag = 'Y' then
8262: hr_utility.set_location('check_hrs_wkd',10);
8263: check_hrs_wkd
8264: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8265: p_person_id => p_person_id,
8266: p_business_group_id => p_business_group_id,

Line 8282: hr_utility.set_location('check_zip_code_rng',10);

8278: --
8279: -- Postal Code
8280: --
8281: if l_profile.rt_pstl_cd_flag = 'Y' then
8282: hr_utility.set_location('check_zip_code_rng',10);
8283: check_zip_code_rng
8284: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8285: p_person_id => p_person_id,
8286: p_business_group_id => p_business_group_id,

Line 8295: hr_utility.set_location('check_service_area',10);

8291: --
8292: -- Service Area
8293: --
8294: if l_profile.rt_svc_area_flag = 'Y' then
8295: hr_utility.set_location('check_service_area',10);
8296: check_service_area
8297: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8298: p_person_id => p_person_id,
8299: p_business_group_id => p_business_group_id,

Line 8307: hr_utility.set_location ('DF profs '||l_package,10);

8303: end if;
8304: --
8305: -- Comp Level
8306: --
8307: hr_utility.set_location ('DF profs '||l_package,10);
8308: if l_profile.rt_comp_lvl_flag = 'Y' then
8309: hr_utility.set_location('check_comp_level',10);
8310: check_comp_level
8311: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,

Line 8309: hr_utility.set_location('check_comp_level',10);

8305: -- Comp Level
8306: --
8307: hr_utility.set_location ('DF profs '||l_package,10);
8308: if l_profile.rt_comp_lvl_flag = 'Y' then
8309: hr_utility.set_location('check_comp_level',10);
8310: check_comp_level
8311: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8312: p_person_id => p_person_id,
8313: p_business_group_id => p_business_group_id,

Line 8326: hr_utility.set_location('check_age_los',10);

8322: --
8323: -- Combine Age and LOS
8324: --
8325: if l_profile.rt_cmbn_age_los_flag = 'Y' then
8326: hr_utility.set_location('check_age_los',10);
8327: check_age_los
8328: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8329: p_person_id => p_person_id,
8330: p_business_group_id => p_business_group_id,

Line 8344: hr_utility.set_location('check_gender',10);

8340: --
8341: -- Gender
8342: --
8343: if l_profile.rt_gndr_flag = 'Y' then
8344: hr_utility.set_location('check_gender',10);
8345: check_gender
8346: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8347: p_business_group_id => p_business_group_id,
8348: p_effective_date => p_effective_date,

Line 8356: hr_utility.set_location ('COBRA profs '||l_package,10);

8352: --
8353: -- Check period of enrollment. This is
8354: -- currently only for COBRA.
8355: --
8356: hr_utility.set_location ('COBRA profs '||l_package,10);
8357: if l_profile.rt_poe_flag = 'Y' then
8358: hr_utility.set_location('check_period_of_enrollment',10);
8359: check_period_of_enrollment
8360: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,

Line 8358: hr_utility.set_location('check_period_of_enrollment',10);

8354: -- currently only for COBRA.
8355: --
8356: hr_utility.set_location ('COBRA profs '||l_package,10);
8357: if l_profile.rt_poe_flag = 'Y' then
8358: hr_utility.set_location('check_period_of_enrollment',10);
8359: check_period_of_enrollment
8360: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8361: p_business_group_id => p_business_group_id,
8362: p_effective_date => p_effective_date,

Line 8373: hr_utility.set_location('check_dsbld_cd' || l_per_rec.registered_disabled_flag,10);

8369: --
8370: -- Disabled
8371: --
8372: if l_profile.rt_dsbld_flag = 'Y' then
8373: hr_utility.set_location('check_dsbld_cd' || l_per_rec.registered_disabled_flag,10);
8374: check_dsbld_cd
8375: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8376: p_business_group_id => p_business_group_id,
8377: p_effective_date => p_effective_date,

Line 8386: hr_utility.set_location('check_optd_mdcr',10);

8382: --
8383: -- Opted for Medicare
8384: --
8385: if l_profile.rt_optd_mdcr_flag = 'Y' then
8386: hr_utility.set_location('check_optd_mdcr',10);
8387: check_optd_mdcr
8388: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8389: p_business_group_id => p_business_group_id,
8390: p_effective_date => p_effective_date,

Line 8399: hr_utility.set_location('check_lvg_rsn',10);

8395: --
8396: -- Leaving Reason
8397: --
8398: if l_profile.rt_lvg_rsn_flag = 'Y' then
8399: hr_utility.set_location('check_lvg_rsn',10);
8400: check_lvg_rsn
8401: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8402: p_business_group_id => p_business_group_id,
8403: p_effective_date => p_effective_date,

Line 8412: hr_utility.set_location('check_cbr_quald_bnf',10);

8408: --
8409: -- Cobra Qualified Beneficiary
8410: --
8411: if l_profile.rt_cbr_quald_bnf_flag = 'Y' then
8412: hr_utility.set_location('check_cbr_quald_bnf',10);
8413: check_cbr_quald_bnf
8414: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8415: p_business_group_id => p_business_group_id,
8416: p_effective_date => p_effective_date,

Line 8425: hr_utility.set_location('check_comptncy',10);

8421: --
8422: -- Competency
8423: --
8424: if l_profile.rt_comptncy_flag = 'Y' then
8425: hr_utility.set_location('check_comptncy',10);
8426: check_comptncy
8427: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8428: p_business_group_id => p_business_group_id,
8429: p_person_id => p_person_id ,

Line 8438: hr_utility.set_location('check_qual_titl',10);

8434: --
8435: -- Qualification title
8436: --
8437: if l_profile.rt_qual_titl_flag = 'Y' then
8438: hr_utility.set_location('check_qual_titl',10);
8439: check_qual_titl
8440: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8441: p_business_group_id => p_business_group_id,
8442: p_person_id => p_person_id ,

Line 8451: hr_utility.set_location('check_dpnt_cvrd_othr_pl',10);

8447: --
8448: -- Dependent Covered Other Plan
8449: --
8450: if l_profile.rt_dpnt_cvrd_pl_flag = 'Y' then
8451: hr_utility.set_location('check_dpnt_cvrd_othr_pl',10);
8452: check_dpnt_cvrd_othr_pl
8453: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8454: p_business_group_id => p_business_group_id,
8455: p_effective_date => p_effective_date,

Line 8465: hr_utility.set_location('check_dpnt_cvrd_othr_plip',10);

8461: --
8462: -- Dependent Covered Other Plan in Program
8463: --
8464: if l_profile.rt_dpnt_cvrd_plip_flag = 'Y' then
8465: hr_utility.set_location('check_dpnt_cvrd_othr_plip',10);
8466: check_dpnt_cvrd_othr_plip
8467: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8468: p_business_group_id => p_business_group_id,
8469: p_effective_date => p_effective_date,

Line 8478: hr_utility.set_location('check_dpnt_cvrd_othr_ptip',10);

8474: --
8475: -- Dependent Covered Other Plan Type in Program
8476: --
8477: if l_profile.rt_dpnt_cvrd_ptip_flag = 'Y' then
8478: hr_utility.set_location('check_dpnt_cvrd_othr_ptip',10);
8479: check_dpnt_cvrd_othr_ptip
8480: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8481: p_business_group_id => p_business_group_id,
8482: p_effective_date => p_effective_date,

Line 8492: hr_utility.set_location('check_dpnt_cvrd_othr_pgm',10);

8488: --
8489: -- Dependent Covered Other Program
8490: --
8491: if l_profile.rt_dpnt_cvrd_pgm_flag = 'Y' then
8492: hr_utility.set_location('check_dpnt_cvrd_othr_pgm',10);
8493: check_dpnt_cvrd_othr_pgm
8494: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8495: p_business_group_id => p_business_group_id,
8496: p_effective_date => p_effective_date,

Line 8507: hr_utility.set_location('check_prtt_anthr_pl',10);

8503: --
8504: -- Eligible for Another Plan
8505: --
8506: if l_profile.rt_prtt_anthr_pl_flag = 'Y' then
8507: hr_utility.set_location('check_prtt_anthr_pl',10);
8508: check_prtt_anthr_pl
8509: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8510: p_business_group_id => p_business_group_id,
8511: -- FONM : as lf_evt_ocrd_dt is not used, it's fine to overload the

Line 8526: hr_utility.set_location('check_othr_ptip',10);

8522: --
8523: -- Eligible for Another Plan Type in Program
8524: --
8525: if l_profile.rt_othr_ptip_flag = 'Y' then
8526: hr_utility.set_location('check_othr_ptip',10);
8527: check_othr_ptip
8528: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8529: p_business_group_id => p_business_group_id,
8530: -- FONM : do not overload as the lf_evt_ocrd_dt takes precedence over eff dt.

Line 8541: hr_utility.set_location('check_enrld_anthr_pl',10);

8537: --
8538: -- Enrolled in Another Plan
8539: --
8540: if l_profile.rt_enrld_pl_flag = 'Y' then
8541: hr_utility.set_location('check_enrld_anthr_pl',10);
8542: check_enrld_anthr_pl
8543: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8544: p_business_group_id => p_business_group_id,
8545: -- FONM : do not overload eff date as determine_date is called.

Line 8557: hr_utility.set_location('check_enrld_anthr_oipl',10);

8553: --
8554: -- Enrolled in Another Option In Plan
8555: --
8556: if l_profile.rt_enrld_oipl_flag = 'Y' then
8557: hr_utility.set_location('check_enrld_anthr_oipl',10);
8558: check_enrld_anthr_oipl
8559: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8560: p_business_group_id => p_business_group_id,
8561: -- FONM : do not overload eff date as determine_date is called.

Line 8573: hr_utility.set_location('check_enrld_anthr_plip',10);

8569: --
8570: -- Enrolled in Another Plan in Program
8571: --
8572: if l_profile.rt_enrld_plip_flag = 'Y' then
8573: hr_utility.set_location('check_enrld_anthr_plip',10);
8574: check_enrld_anthr_plip
8575: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8576: p_business_group_id => p_business_group_id,
8577: -- FONM : do not overload eff date as determine_date is called.

Line 8588: hr_utility.set_location('check_enrld_anthr_ptip',10);

8584: --
8585: -- Enrolled in Another Plan Type in Program
8586: --
8587: if l_profile.rt_enrld_ptip_flag = 'Y' then
8588: hr_utility.set_location('check_enrld_anthr_ptip',10);
8589: check_enrld_anthr_ptip
8590: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8591: p_business_group_id => p_business_group_id,
8592: -- FONM : do not overload eff date as determine_date is called.

Line 8601: hr_utility.set_location('check_enrld_anthr_pgm',10);

8597: --
8598: -- Enrolled in Another Program
8599: --
8600: if l_profile.rt_enrld_pgm_flag = 'Y' then
8601: hr_utility.set_location('check_enrld_anthr_pgm',10);
8602: check_enrld_anthr_pgm
8603: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8604: p_business_group_id => p_business_group_id,
8605: p_pgm_id => p_pgm_id ,

Line 8616: hr_utility.set_location('check_dpnt_othr_ptip',10);

8612: --
8613: -- Dependent Other Plan Type in Program
8614: --
8615: if l_profile.rt_dpnt_othr_ptip_flag = 'Y' then
8616: hr_utility.set_location('check_dpnt_othr_ptip',10);
8617: check_dpnt_othr_ptip
8618: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8619: p_business_group_id => p_business_group_id,
8620: -- FONM : as lf_evt_ocrd_dt is used, do not overload the

Line 8632: hr_utility.set_location('check_no_othr_cvg',10);

8628: --
8629: -- No Other Coverage
8630: --
8631: if l_profile.rt_no_othr_cvg_flag = 'Y' then
8632: hr_utility.set_location('check_no_othr_cvg',10);
8633: check_no_othr_cvg
8634: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8635: p_business_group_id => p_business_group_id,
8636: p_person_id => p_person_id,

Line 8655: hr_utility.set_location ('Total profs '||l_package,10);

8651: -- of people participating in the comp object.
8652: --
8653: -- Total Number of Participants
8654: --
8655: hr_utility.set_location ('Total profs '||l_package,10);
8656: if l_profile.rt_ttl_prtt_flag = 'Y' then
8657: hr_utility.set_location('check_ttl_prtt',10);
8658: check_ttl_prtt
8659: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,

Line 8657: hr_utility.set_location('check_ttl_prtt',10);

8653: -- Total Number of Participants
8654: --
8655: hr_utility.set_location ('Total profs '||l_package,10);
8656: if l_profile.rt_ttl_prtt_flag = 'Y' then
8657: hr_utility.set_location('check_ttl_prtt',10);
8658: check_ttl_prtt
8659: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8660: p_business_group_id => p_business_group_id,
8661: p_effective_date => p_effective_date,

Line 8669: hr_utility.set_location('check_ttl_cvg',10);

8665: --
8666: -- Total Amount of Coverage
8667: --
8668: if l_profile.rt_ttl_cvg_vol_flag = 'Y' then
8669: hr_utility.set_location('check_ttl_cvg',10);
8670: check_ttl_cvg
8671: (p_vrbl_rt_prfl_id => l_profile.vrbl_rt_prfl_id,
8672: p_business_group_id => p_business_group_id,
8673: p_effective_date => p_effective_date,

Line 8688: hr_utility.set_location ('Load globals '||l_package,10);

8684: --
8685: l_vrbl_rt_prfl_id := l_profile.vrbl_rt_prfl_id;
8686: l_matched_vrbl_prfl := 'Y';
8687: --
8688: hr_utility.set_location ('Load globals '||l_package,10);
8689: if p_all_prfls then
8690: --
8691: hr_utility.set_location ('p_all_prfls on ',20);
8692: --

Line 8691: hr_utility.set_location ('p_all_prfls on ',20);

8687: --
8688: hr_utility.set_location ('Load globals '||l_package,10);
8689: if p_all_prfls then
8690: --
8691: hr_utility.set_location ('p_all_prfls on ',20);
8692: --
8693: -- first time thru procedure where we are keeping track of all
8694: -- the profiles a person matches, without running the ttl-cvg
8695: -- and ttl-prtt's profiles.

Line 8769: hr_utility.set_location ('p_use_globals on ',21);

8765: else
8766: -- Bug 1211317: changed to use new parm.
8767: if p_use_prfls then
8768: --
8769: hr_utility.set_location ('p_use_globals on ',21);
8770: --
8771: -- our second time thru this procedure where we are
8772: -- determining which profile a person matches with
8773: -- ttl_cvg and ttl_prtt taken into account. Keep track

Line 8856: hr_utility.set_location ('g_profile_failed '||l_package,10);

8852: --
8853: -- If profile failed one of the criteria,
8854: -- go onto next profile.
8855: --
8856: hr_utility.set_location ('g_profile_failed '||l_package,10);
8857: NULL;
8858: --
8859: -- begin bug # 2436338
8860: when g_criteria_failed then

Line 8865: hr_utility.set_location ('g_profile_failed '||l_package,10);

8861: --
8862: -- If profile failed one of the criteria,
8863: -- go onto next profile.
8864: --
8865: hr_utility.set_location ('g_profile_failed '||l_package,10);
8866: NULL;
8867: --
8868: -- end bug # 2436338
8869: end;

Line 8872: hr_utility.set_location ('Dn Prof loop '||l_package,10);

8868: -- end bug # 2436338
8869: end;
8870: --
8871: end loop;
8872: hr_utility.set_location ('Dn Prof loop '||l_package,10);
8873: --
8874: if l_matched_vrbl_prfl = 'N' then
8875: --
8876: if p_all_prfls or p_use_globals then

Line 8886: hr_utility.set_location ('did not match profile :'||

8882: --
8883: g_no_match_cnt := g_no_match_cnt + 1;
8884: g_no_match_cvg := g_no_match_cvg + p_bnft_amt;
8885: --
8886: hr_utility.set_location ('did not match profile :'||
8887: to_char(p_person_id)||' cnt:'||
8888: to_char(g_no_match_cnt),88);
8889: --
8890: end if;

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

8892: end if;
8893: --
8894: p_vrbl_rt_prfl_id := l_vrbl_rt_prfl_id;
8895: --
8896: hr_utility.set_location ('Leaving '||l_package,99);
8897: --
8898: end main;
8899: --
8900: end ben_evaluate_rate_profiles;