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

Line 376: g_debug boolean := hr_utility.debug_enabled;

372: */
373: --------------------------------------------------------------------------------
374: --
375: g_package varchar2(80) := 'ben_determine_activity_base_rt';
376: g_debug boolean := hr_utility.debug_enabled;
377: --
378: TYPE g_element_link_id_table IS TABLE OF pay_element_links_f.element_link_id%TYPE
379: INDEX BY BINARY_INTEGER;
380: --

Line 1204: g_debug := hr_utility.debug_enabled;

1200: end;
1201: --
1202: begin
1203: --
1204: g_debug := hr_utility.debug_enabled;
1205: hr_utility.set_location ('Entering '||l_package,10);
1206: --
1207: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1208: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));

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

1201: --
1202: begin
1203: --
1204: g_debug := hr_utility.debug_enabled;
1205: hr_utility.set_location ('Entering '||l_package,10);
1206: --
1207: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1208: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1209: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;

Line 1211: hr_utility.set_location('l_effective_date'||l_effective_date,10);

1207: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1208: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1209: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;
1210: --
1211: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1212: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1213: hr_utility.set_location('p_person_id '||p_person_id,20);
1214: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1215: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);

Line 1212: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);

1208: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1209: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;
1210: --
1211: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1212: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1213: hr_utility.set_location('p_person_id '||p_person_id,20);
1214: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1215: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1216: if p_calc_only_rt_val_flag then

Line 1213: hr_utility.set_location('p_person_id '||p_person_id,20);

1209: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;
1210: --
1211: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1212: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1213: hr_utility.set_location('p_person_id '||p_person_id,20);
1214: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1215: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1216: if p_calc_only_rt_val_flag then
1217: hr_utility.set_location(' p_calc_only_rt_val_flag',10);

Line 1214: hr_utility.set_location('p_effective_date'||p_effective_date,20);

1210: --
1211: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1212: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1213: hr_utility.set_location('p_person_id '||p_person_id,20);
1214: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1215: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1216: if p_calc_only_rt_val_flag then
1217: hr_utility.set_location(' p_calc_only_rt_val_flag',10);
1218: end if ;

Line 1215: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);

1211: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1212: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1213: hr_utility.set_location('p_person_id '||p_person_id,20);
1214: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1215: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1216: if p_calc_only_rt_val_flag then
1217: hr_utility.set_location(' p_calc_only_rt_val_flag',10);
1218: end if ;
1219: --

Line 1217: hr_utility.set_location(' p_calc_only_rt_val_flag',10);

1213: hr_utility.set_location('p_person_id '||p_person_id,20);
1214: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1215: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1216: if p_calc_only_rt_val_flag then
1217: hr_utility.set_location(' p_calc_only_rt_val_flag',10);
1218: end if ;
1219: --
1220: -- Ensure relevant parameters have been populated with values
1221: --

Line 1247: hr_utility.set_location (' Checking Electable Choice ',20);

1243: fnd_message.set_token('PROC','Standard Rates');
1244: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1245: fnd_message.raise_error;
1246: end if;
1247: hr_utility.set_location (' Checking Electable Choice ',20);
1248: --
1249: -- Populate electable choice information
1250: --
1251: l_coverage_value := p_bnft_amt;

Line 1299: hr_utility.set_location ('Dn Pop EPE'||l_package,10);

1295: fnd_message.raise_error;
1296: end if;
1297: close c_epe;
1298: end if;
1299: hr_utility.set_location ('Dn Pop EPE'||l_package,10);
1300: --
1301: -- Get related information from either the context record or
1302: --
1303: if p_currepe_row.oipl_id is not null

Line 1335: hr_utility.set_location('Roundng'||l_abr.rndg_cd,951);

1331: open c_pln_auto_distr (p_currepe_row.elig_per_elctbl_chc_id);
1332: fetch c_pln_auto_distr into l_pln_auto_distr_flag;
1333: close c_pln_auto_distr;
1334: end if;
1335: hr_utility.set_location('Roundng'||l_abr.rndg_cd,951);
1336: --
1337: -- get values for rules and limit checking
1338: --
1339: -- bug fix 3457483

Line 1368: hr_utility.set_location ('l_input_value_id' || l_input_value_id, 33);

1364: --
1365: CLOSE c_pl_typ;
1366:
1367: --
1368: hr_utility.set_location ('l_input_value_id' || l_input_value_id, 33);
1369:
1370: IF l_opt_typ_cd = 'ICM'
1371: THEN
1372: --

Line 1383: hr_utility.set_location ('PL LEVEL' || l_abr_level.pl_id, 32);

1379:
1380: --
1381: IF l_abr_level.pl_id IS NOT NULL
1382: THEN
1383: hr_utility.set_location ('PL LEVEL' || l_abr_level.pl_id, 32);
1384: ELSIF l_abr_level.oipl_id IS NOT NULL
1385: THEN
1386: hr_utility.set_location ('OIPL LEVEL' || l_abr_level.oipl_id, 32);
1387: END IF;

Line 1386: hr_utility.set_location ('OIPL LEVEL' || l_abr_level.oipl_id, 32);

1382: THEN
1383: hr_utility.set_location ('PL LEVEL' || l_abr_level.pl_id, 32);
1384: ELSIF l_abr_level.oipl_id IS NOT NULL
1385: THEN
1386: hr_utility.set_location ('OIPL LEVEL' || l_abr_level.oipl_id, 32);
1387: END IF;
1388:
1389: -- To find the eligible element link for the element attached to a Rate
1390: OPEN c_elem_link (l_abr.element_type_id);

Line 1399: hr_utility.set_location ('l_input_value_id' || l_input_value_id, 32);

1395: FETCH c_elem_link
1396: INTO l_input_value_id;
1397:
1398: EXIT WHEN c_elem_link%NOTFOUND;
1399: hr_utility.set_location ('l_input_value_id' || l_input_value_id, 32);
1400: --
1401: ben_element_entry.get_link
1402: (p_assignment_id => l_assignment_id,
1403: p_element_type_id => l_abr.element_type_id,

Line 1414: hr_utility.set_location ('l_element_link_id' || l_element_link_id,

1410: --
1411: IF l_element_link_id = l_input_value_id
1412: THEN
1413: --
1414: hr_utility.set_location ('l_element_link_id' || l_element_link_id,
1415: 321
1416: );
1417: l_element_link_id_table (l_element_link_id_table.COUNT + 1) :=
1418: l_element_link_id;

Line 1430: hr_utility.set_location ( 'l_abr.input_va_calc_rl'

1426: IF l_abr.input_va_calc_rl IS NOT NULL
1427: THEN
1428: --
1429: l_outputs.DELETE;
1430: hr_utility.set_location ( 'l_abr.input_va_calc_rl'
1431: || l_abr.input_va_calc_rl,
1432: 13
1433: );
1434: -- getting the values returned by rule

Line 1449: hr_utility.set_location ('l_count' || l_outputs.COUNT, 321);

1445: p_pl_typ_id => l_epe.pl_typ_id,
1446: p_acty_base_rt_id => p_acty_base_rt_id
1447: );
1448: --
1449: hr_utility.set_location ('l_count' || l_outputs.COUNT, 321);
1450: --
1451: EXCEPTION
1452: WHEN OTHERS
1453: THEN

Line 1465: hr_utility.set_location ( 'l_element_link_id_table.LAST'

1461: END;
1462: --
1463: END IF;
1464:
1465: hr_utility.set_location ( 'l_element_link_id_table.LAST'
1466: || l_element_link_id_table.LAST,
1467: 23
1468: );
1469: --

Line 1474: hr_utility.set_location (l_element_link_id_table.FIRST, 1121);

1470: l_counter := 0;
1471: --
1472: l_cnt_links := 0;
1473: l_cnt_inp_vals := 0;
1474: hr_utility.set_location (l_element_link_id_table.FIRST, 1121);
1475:
1476: -- putting all the default values in an element link to a table that will be used to insert values in ben_icd_chc_rates
1477: IF l_element_link_id_table.COUNT > 0
1478: THEN

Line 1484: hr_utility.set_location ( 'l_element_link_id_table (i)'

1480: FOR i IN
1481: l_element_link_id_table.FIRST .. l_element_link_id_table.LAST
1482: --
1483: LOOP
1484: hr_utility.set_location ( 'l_element_link_id_table (i)'
1485: || l_element_link_id_table (i),
1486: 11
1487: );
1488: IF NOT l_icd_chc_rates_tab.EXISTS(1) THEN

Line 1499: hr_utility.set_location('l_cnt_links'||l_cnt_links,14);

1495: --
1496: END IF;
1497: --
1498: -- l_cnt_links := 1;
1499: hr_utility.set_location('l_cnt_links'||l_cnt_links,14);
1500: --
1501: -- creating row for icd pl sql table
1502: l_icd_chc_rates_tab (l_cnt_links).element_link_id :=
1503: l_element_link_id_table (i);

Line 1508: hr_utility.set_location ('PLAN', 23);

1504:
1505: --
1506: IF l_abr_level.pl_id IS NULL
1507: THEN
1508: hr_utility.set_location ('PLAN', 23);
1509: l_icd_chc_rates_tab (l_cnt_links).l_level := 'O';
1510: -- l_icd_chc_rates_tab (l_cnt_links).pl_id := NULL;
1511: -- l_icd_chc_rates_tab (l_cnt_links).oipl_id := l_epe.oipl_id;
1512: ELSIF l_abr_level.oipl_id IS NULL

Line 1514: hr_utility.set_location ('OIPL', 23);

1510: -- l_icd_chc_rates_tab (l_cnt_links).pl_id := NULL;
1511: -- l_icd_chc_rates_tab (l_cnt_links).oipl_id := l_epe.oipl_id;
1512: ELSIF l_abr_level.oipl_id IS NULL
1513: THEN
1514: hr_utility.set_location ('OIPL', 23);
1515: l_icd_chc_rates_tab (l_cnt_links).l_level := 'P';
1516: -- l_icd_chc_rates_tab (l_cnt_links).pl_id := l_epe.pl_id;
1517: -- l_icd_chc_rates_tab (l_cnt_links).oipl_id := NULL;
1518: END IF;

Line 1550: hr_utility.set_location ('l_cnt_inp_vals' || l_cnt_inp_vals,

1546: --
1547: EXIT WHEN c_input_values%NOTFOUND;
1548: -- assigning default values
1549: --
1550: hr_utility.set_location ('l_cnt_inp_vals' || l_cnt_inp_vals,
1551: 21
1552: );
1553:
1554: IF l_cnt_inp_vals = 1

Line 1660: hr_utility.set_location (SQLERRM, 23);

1656: --
1657: EXCEPTION
1658: WHEN OTHERS
1659: THEN
1660: hr_utility.set_location (SQLERRM, 23);
1661: END;
1662: --
1663: END LOOP;
1664: --

Line 1667: hr_utility.set_location ('Default values assigned ', 5);

1663: END LOOP;
1664: --
1665: END IF;
1666:
1667: hr_utility.set_location ('Default values assigned ', 5);
1668: hr_utility.set_location ( l_icd_chc_rates_tab.FIRST
1669: || 'f counts'
1670: || l_icd_chc_rates_tab.LAST,
1671: 121

Line 1668: hr_utility.set_location ( l_icd_chc_rates_tab.FIRST

1664: --
1665: END IF;
1666:
1667: hr_utility.set_location ('Default values assigned ', 5);
1668: hr_utility.set_location ( l_icd_chc_rates_tab.FIRST
1669: || 'f counts'
1670: || l_icd_chc_rates_tab.LAST,
1671: 121
1672: );

Line 1698: hr_utility.set_location (' in loop ', 121);

1694: -- putting all the values returned by forumula in the table that will be used to insert values in ben_icd_chc_rates
1695: FOR l_cnt IN l_icd_chc_rates_tab.FIRST .. l_icd_chc_rates_tab.LAST
1696: -- change default values to formula returned value for every link
1697: LOOP
1698: hr_utility.set_location (' in loop ', 121);
1699:
1700: -- FOR l_cnt IN l_icd_chc_rates_tab.FIRST .. l_icd_chc_rates_tab.LAST
1701: FOR l_count IN l_outputs.FIRST .. l_outputs.LAST
1702: LOOP

Line 1714: hr_utility.set_location

1710: INTO l_ext_inpval_rec;
1711:
1712: EXIT WHEN c_ext_inpval%NOTFOUND;
1713: --
1714: hr_utility.set_location
1715: ( ' l_outputs (l_count).NAME '
1716: || l_outputs (l_count).NAME,
1717: 121
1718: );

Line 1719: hr_utility.set_location

1715: ( ' l_outputs (l_count).NAME '
1716: || l_outputs (l_count).NAME,
1717: 121
1718: );
1719: hr_utility.set_location
1720: ( ' l_ext_inpval_rec.return_var_name '
1721: || l_ext_inpval_rec.return_var_name,
1722: 121
1723: );

Line 1730: hr_utility.set_location

1726: l_ext_inpval_rec.return_var_name
1727: THEN
1728: --
1729: l_counter := l_counter + 1;
1730: hr_utility.set_location
1731: ('Before assign extra inputs cache',
1732: 11
1733: );
1734: --

Line 1735: hr_utility.set_location

1731: ('Before assign extra inputs cache',
1732: 11
1733: );
1734: --
1735: hr_utility.set_location
1736: ( 'l_ext_inpval_rec.extra_input_value_id'
1737: || l_ext_inpval_rec.extra_input_value_id,
1738: 132
1739: );

Line 1741: hr_utility.set_location('l_cnt_links'||l_cnt_links,1231);

1737: || l_ext_inpval_rec.extra_input_value_id,
1738: 132
1739: );
1740: --
1741: hr_utility.set_location('l_cnt_links'||l_cnt_links,1231);
1742: l_input_value_id :=
1743: get_input_value_id
1744: (l_ext_inpval_rec.extra_input_value_id);
1745:

Line 1945: hr_utility.set_location('l_outputs.count'||l_outputs.count,951);

1941: p_business_group_id => l_epe.business_group_id,
1942: p_param1 => 'BEN_IV_PERSON_ID',
1943: p_param1_value => to_char(p_person_id)
1944: );
1945: hr_utility.set_location('l_outputs.count'||l_outputs.count,951);
1946: if (l_outputs.count >= 4) then
1947: for l_count in l_outputs.first..l_outputs.last loop
1948: begin
1949: if l_outputs(l_count).name = 'L_MN_ELCN_VAL' then

Line 1971: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);

1967: else
1968: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
1969: fnd_message.raise_error;
1970: end if;
1971: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
1972: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
1973: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
1974: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
1975: end if;

Line 1972: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);

1968: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
1969: fnd_message.raise_error;
1970: end if;
1971: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
1972: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
1973: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
1974: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
1975: end if;
1976: --

Line 1973: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);

1969: fnd_message.raise_error;
1970: end if;
1971: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
1972: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
1973: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
1974: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
1975: end if;
1976: --
1977:

Line 1974: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);

1970: end if;
1971: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
1972: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
1973: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
1974: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
1975: end if;
1976: --
1977:
1978: -- end bug fix 3457483

Line 1986: hr_utility.set_location (' Checking rate multiplier code ',40);

1982: open c_state;
1983: fetch c_state into l_state;
1984: close c_state;
1985: */
1986: hr_utility.set_location (' Checking rate multiplier code ',40);
1987: if l_abr.rt_mlt_cd is null then
1988: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
1989: fnd_message.set_token('COLUMN','rt_mlt_cd');
1990: fnd_message.set_token('PACKAGE',l_package);

Line 1999: hr_utility.set_location (' Checking rate multiplier code others',50);

1995: fnd_message.set_token('PL_ID',to_char(p_pl_id));
1996: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
1997: fnd_message.raise_error;
1998: end if;
1999: hr_utility.set_location (' Checking rate multiplier code others',50);
2000: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',
2001: 'APANDCVG','PRNTANDCVG') then
2002: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2003: --

Line 2016: hr_utility.set_location (' Checking acty base rate values ',60);

2012: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2013: fnd_message.raise_error;
2014: end if;
2015: end if;
2016: hr_utility.set_location (' Checking acty base rate values ',60);
2017: --
2018: -- cwb now allows null values for min/max/incrmt so no need to validate
2019: --
2020: ben_env_object.get(p_rec => l_env);

Line 2025: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);

2021: if (l_abr.entr_val_at_enrt_flag = 'Y' and l_abr.entr_ann_val_flag = 'N')
2022: and nvl(l_env.mode_cd,'~') <> 'W' then
2023:
2024: if l_abr.mn_elcn_val is null then
2025: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2026: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2027: fnd_message.set_token('COLUMN','mn_elcn_val');
2028: fnd_message.set_token('PACKAGE',l_package);
2029: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);

2034: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2035: fnd_message.raise_error;
2036:
2037: elsif l_abr.mx_elcn_val is null then
2038: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2039: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2040: fnd_message.set_token('COLUMN','mx_elcn_val');
2041: fnd_message.set_token('PACKAGE',l_package);
2042: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);

2046: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2047: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2048: fnd_message.raise_error;
2049: elsif l_abr.incrmt_elcn_val is null then
2050: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2051: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2052: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2053: fnd_message.set_token('PACKAGE',l_package);
2054: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 2064: hr_utility.set_location(' checking if program or plan ',70);

2060: fnd_message.raise_error;
2061: end if;
2062: end if;
2063:
2064: hr_utility.set_location(' checking if program or plan ',70);
2065: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),333);
2066:
2067: if l_epe.pgm_id is not null then
2068: open c_pgm

Line 2065: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),333);

2061: end if;
2062: end if;
2063:
2064: hr_utility.set_location(' checking if program or plan ',70);
2065: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),333);
2066:
2067: if l_epe.pgm_id is not null then
2068: open c_pgm
2069: (c_effective_date => l_effective_date

Line 2083: hr_utility.set_location(' testing if plan ',80);

2079: close c_pgm;
2080: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
2081: l_enrt_info_rt_freq_cd := l_pgm.enrt_info_rt_freq_cd;
2082: else
2083: hr_utility.set_location(' testing if plan ',80);
2084: hr_utility.set_location(' l_epe.pl_id'||l_epe.pl_id,80);
2085: open c_pln
2086: (c_effective_date => l_effective_date,
2087: c_pl_id => l_epe.pl_id

Line 2084: hr_utility.set_location(' l_epe.pl_id'||l_epe.pl_id,80);

2080: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
2081: l_enrt_info_rt_freq_cd := l_pgm.enrt_info_rt_freq_cd;
2082: else
2083: hr_utility.set_location(' testing if plan ',80);
2084: hr_utility.set_location(' l_epe.pl_id'||l_epe.pl_id,80);
2085: open c_pln
2086: (c_effective_date => l_effective_date,
2087: c_pl_id => l_epe.pl_id
2088: );

Line 2104: /* hr_utility.set_location('PPF changes: input epe id'||p_elig_per_elctbl_chc_id,99);

2100: end if;
2101: --
2102: -- Bug No 4538786
2103: --
2104: /* hr_utility.set_location('PPF changes: input epe id'||p_elig_per_elctbl_chc_id,99);
2105: hr_utility.set_location('PPF changes: element type id before changes'||l_abr.element_type_id,99); */
2106: if l_abr.rt_usg_cd = 'FLXCR' and l_enrt_info_rt_freq_cd = 'PPF' then
2107: -- hr_utility.set_location('PPF changes: fetching the element type id...',99);
2108: open get_rt_and_element(l_epe.pgm_id, l_epe.per_in_ler_id);

Line 2105: hr_utility.set_location('PPF changes: element type id before changes'||l_abr.element_type_id,99); */

2101: --
2102: -- Bug No 4538786
2103: --
2104: /* hr_utility.set_location('PPF changes: input epe id'||p_elig_per_elctbl_chc_id,99);
2105: hr_utility.set_location('PPF changes: element type id before changes'||l_abr.element_type_id,99); */
2106: if l_abr.rt_usg_cd = 'FLXCR' and l_enrt_info_rt_freq_cd = 'PPF' then
2107: -- hr_utility.set_location('PPF changes: fetching the element type id...',99);
2108: open get_rt_and_element(l_epe.pgm_id, l_epe.per_in_ler_id);
2109: fetch get_rt_and_element into l_rt_and_element;

Line 2107: -- hr_utility.set_location('PPF changes: fetching the element type id...',99);

2103: --
2104: /* hr_utility.set_location('PPF changes: input epe id'||p_elig_per_elctbl_chc_id,99);
2105: hr_utility.set_location('PPF changes: element type id before changes'||l_abr.element_type_id,99); */
2106: if l_abr.rt_usg_cd = 'FLXCR' and l_enrt_info_rt_freq_cd = 'PPF' then
2107: -- hr_utility.set_location('PPF changes: fetching the element type id...',99);
2108: open get_rt_and_element(l_epe.pgm_id, l_epe.per_in_ler_id);
2109: fetch get_rt_and_element into l_rt_and_element;
2110: if get_rt_and_element%FOUND then
2111: l_abr.element_type_id := l_rt_and_element.element_type_id;

Line 2115: -- hr_utility.set_location('PPF changes: afterwards element type id'||l_abr.element_type_id,99);

2111: l_abr.element_type_id := l_rt_and_element.element_type_id;
2112: end if;
2113: Close get_rt_and_element; -- Close added during bug fix 4604560
2114: end if;
2115: -- hr_utility.set_location('PPF changes: afterwards element type id'||l_abr.element_type_id,99);
2116: --
2117: -- End Bug No 4538786
2118: --
2119: -- get the dflt_enrt_cd/rule

Line 2121: hr_utility.set_location ('BER_DDEC '||l_package,10);

2117: -- End Bug No 4538786
2118: --
2119: -- get the dflt_enrt_cd/rule
2120: --
2121: hr_utility.set_location ('BER_DDEC '||l_package,10);
2122: ben_env_object.get(p_rec => l_env);
2123: hr_utility.set_location('l_env.mode_cd' || l_env.mode_cd,13);
2124: if nvl(l_env.mode_cd,'~') <> 'D' then --cant set this code in 'D' Plans -- ICM
2125: --

Line 2123: hr_utility.set_location('l_env.mode_cd' || l_env.mode_cd,13);

2119: -- get the dflt_enrt_cd/rule
2120: --
2121: hr_utility.set_location ('BER_DDEC '||l_package,10);
2122: ben_env_object.get(p_rec => l_env);
2123: hr_utility.set_location('l_env.mode_cd' || l_env.mode_cd,13);
2124: if nvl(l_env.mode_cd,'~') <> 'D' then --cant set this code in 'D' Plans -- ICM
2125: --
2126: ben_enrolment_requirements.determine_dflt_enrt_cd
2127: (p_oipl_id =>l_epe.oipl_id

Line 2138: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),299);

2134: ,p_dflt_enrt_rl =>l_dflt_enrt_rl
2135: ,p_business_group_id =>l_epe.business_group_id
2136: ,p_effective_date =>l_cvg_eff_dt
2137: );
2138: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),299);
2139: --
2140: end if;
2141: if l_abr.rt_mlt_cd in ('CVG','CLANDCVG','APANDCVG','PRNTANDCVG','SAREC') then
2142: --

Line 2146: hr_utility.set_location (' Before FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);

2142: --
2143: --Bug 2192102 if the rate is of Flex credit letus get the associated enrt bnft id
2144: if l_abr.rt_usg_cd = 'FLXCR' then
2145: --
2146: hr_utility.set_location (' Before FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
2147: --
2148: open c_enb_fc ;
2149: fetch c_enb_fc into l_enrt_bnft_id ;
2150: close c_enb_fc;

Line 2152: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);

2148: open c_enb_fc ;
2149: fetch c_enb_fc into l_enrt_bnft_id ;
2150: close c_enb_fc;
2151: --
2152: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
2153: end if;
2154: --
2155: if l_coverage_value is null then
2156: if l_enrt_bnft_id is null then

Line 2202: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);

2198: fnd_message.raise_error;
2199: end if;
2200: p_cvg_calc_amt_mthd_id := l_cvg_calc_amt_mthd_id;
2201: end if;
2202: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);
2203: if l_abr.rt_mlt_cd in ('CL','CLANDCVG') then
2204: if l_abr.comp_lvl_fctr_id is null then
2205: fnd_message.set_name('BEN','BEN_92745_NO_ABR_CLF_EXISTS');
2206: fnd_message.raise_error;

Line 2233: hr_utility.set_location ('ABR_RTMLTCD AP '||l_package,10);

2229: fnd_message.set_token('VARIABLE','l_compensation_value');
2230: fnd_message.raise_error;
2231: end if;
2232: end if;
2233: hr_utility.set_location ('ABR_RTMLTCD AP '||l_package,10);
2234: if l_abr.rt_mlt_cd in ('AP','APANDCVG') then
2235: p_actl_prem_id := l_abr.actl_prem_id;
2236: open c_enrt_prem(l_abr.actl_prem_id);
2237: fetch c_enrt_prem into l_actl_prem_value;

Line 2239: hr_utility.set_location (' Dn c_enrt_prem ',120);

2235: p_actl_prem_id := l_abr.actl_prem_id;
2236: open c_enrt_prem(l_abr.actl_prem_id);
2237: fetch c_enrt_prem into l_actl_prem_value;
2238: close c_enrt_prem;
2239: hr_utility.set_location (' Dn c_enrt_prem ',120);
2240: --6314463
2241: l_force_prem_calc := 'N';
2242: open c_force_prem_calc(p_actl_prem_id);
2243: fetch c_force_prem_calc into l_force_prem_calc;

Line 2252: hr_utility.set_location('premium re calculation ',551);

2248: if nvl(l_env.mode_cd,'~') <> 'D' then
2249: --
2250: if /*nvl(l_actl_prem_value,0) = 0 and */ p_calc_only_rt_val_flag
2251: or (l_force_prem_calc = 'Y' and p_called_from_ss) then
2252: hr_utility.set_location('premium re calculation ',551);
2253: ben_determine_actual_premium.g_computed_prem_val := null ;
2254: ben_determine_actual_premium.main
2255: (p_person_id => p_person_id,
2256: p_effective_date => l_cvg_eff_dt,

Line 2269: hr_utility.set_location('premium re calculation over ',551);

2265: p_ler_id => l_epe.ler_id,
2266: p_bnft_amt => l_coverage_value,
2267: p_business_group_id => l_epe.business_group_id );
2268:
2269: hr_utility.set_location('premium re calculation over ',551);
2270: hr_utility.set_location('Required actl_prem_id ' || l_abr.actl_prem_id,551);
2271: --
2272: -- 6330056 : Match the actl_prem_id for the evaluated
2273: -- premiums to get the correct required value.

Line 2270: hr_utility.set_location('Required actl_prem_id ' || l_abr.actl_prem_id,551);

2266: p_bnft_amt => l_coverage_value,
2267: p_business_group_id => l_epe.business_group_id );
2268:
2269: hr_utility.set_location('premium re calculation over ',551);
2270: hr_utility.set_location('Required actl_prem_id ' || l_abr.actl_prem_id,551);
2271: --
2272: -- 6330056 : Match the actl_prem_id for the evaluated
2273: -- premiums to get the correct required value.
2274: --

Line 2280: hr_utility.set_location('Calculated actl_prem_id ' ||

2276: --
2277: for idx IN ben_determine_actual_premium.g_computed_prem_tbl.FIRST..
2278: ben_determine_actual_premium.g_computed_prem_tbl.LAST loop
2279: --
2280: hr_utility.set_location('Calculated actl_prem_id ' ||
2281: ben_determine_actual_premium.g_computed_prem_tbl(idx).actl_prem_id,551);
2282: if (ben_determine_actual_premium.g_computed_prem_tbl(idx).actl_prem_id
2283: = l_abr.actl_prem_id) then
2284: --

Line 2294: hr_utility.set_location('l_actl_prem_value ' || l_actl_prem_value,100);

2290: end loop;
2291: --
2292: end if;
2293: --
2294: hr_utility.set_location('l_actl_prem_value ' || l_actl_prem_value,100);
2295: --l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val;
2296: hr_utility.set_location('re calculation premium'||l_actl_prem_value,551);
2297: ben_determine_actual_premium.g_computed_prem_val := null;
2298: --

Line 2296: hr_utility.set_location('re calculation premium'||l_actl_prem_value,551);

2292: end if;
2293: --
2294: hr_utility.set_location('l_actl_prem_value ' || l_actl_prem_value,100);
2295: --l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val;
2296: hr_utility.set_location('re calculation premium'||l_actl_prem_value,551);
2297: ben_determine_actual_premium.g_computed_prem_val := null;
2298: --
2299: end if;
2300:

Line 2303: hr_utility.set_location (' FNDMS_RE 1 ',130);

2299: end if;
2300:
2301: if l_actl_prem_value is null then
2302: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2303: hr_utility.set_location (' FNDMS_RE 1 ',130);
2304: fnd_message.raise_error;
2305: end if;
2306: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2307: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);

Line 2306: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);

2302: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2303: hr_utility.set_location (' FNDMS_RE 1 ',130);
2304: fnd_message.raise_error;
2305: end if;
2306: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2307: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);
2308: --
2309:
2310: if l_acty_ref_perd_cd = 'PWK' then

Line 2307: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);

2303: hr_utility.set_location (' FNDMS_RE 1 ',130);
2304: fnd_message.raise_error;
2305: end if;
2306: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2307: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);
2308: --
2309:
2310: if l_acty_ref_perd_cd = 'PWK' then
2311: l_actl_prem_value := (l_actl_prem_value * 12) / 52;

Line 2337: hr_utility.set_location (' FNDMS_RE 2 ',150);

2333: else
2334: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2335: fnd_message.set_token('PROC',l_package);
2336: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2337: hr_utility.set_location (' FNDMS_RE 2 ',150);
2338: fnd_message.raise_error;
2339: end if;
2340: end if; --'D'
2341: end if;

Line 2342: hr_utility.set_location ('ABR_RTMLTCD PRNT '||l_package,10);

2338: fnd_message.raise_error;
2339: end if;
2340: end if; --'D'
2341: end if;
2342: hr_utility.set_location ('ABR_RTMLTCD PRNT '||l_package,10);
2343: if l_abr.rt_mlt_cd in ('PRNT','PRNTANDCVG') then
2344: open c_abr2
2345: (c_effective_date => l_effective_date
2346: );

Line 2366: hr_utility.set_location ('St BDABR_MN Sub '||l_package,10);

2362: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2363: fnd_message.raise_error;
2364: end if;
2365: */
2366: hr_utility.set_location ('St BDABR_MN Sub '||l_package,10);
2367: if l_prnt_entr_val_at_enrt_flag = 'Y' then
2368: l_cal_val := null;
2369: else
2370: l_cal_val := p_cal_val;

Line 2438: hr_utility.set_location ('Dn BDABR_MN Sub '||l_package,10);

2434: ,p_ordr_num => l_dummy_num
2435: ,p_iss_val => l_dummy_num
2436: );
2437: end if ;
2438: hr_utility.set_location ('Dn BDABR_MN Sub '||l_package,10);
2439: --bug :1555624 when the parent defiend as enter at enrollment then vlue
2440: -- may be returend as null or 0 this will be calcualtead in post enrollement
2441: -- process
2442: if l_prnt_rt_value is null

Line 2455: hr_utility.set_location(' l_abr.rt_mlt_cd:'||l_abr.rt_mlt_cd,170);

2451: end if;
2452:
2453: p_entr_val_at_enrt_flag := l_abr.entr_val_at_enrt_flag;
2454:
2455: hr_utility.set_location(' l_abr.rt_mlt_cd:'||l_abr.rt_mlt_cd,170);
2456: hr_utility.set_location(' cal val :'|| p_cal_val,170);
2457: --- bug 1480407
2458: -- when entr_val_at_enrt_flag and use_calc_acty_bs_rt_flag is true this calculation will be called
2459: -- after enrolement with the entered rate so the calulatiuon is to be done for incomming value

Line 2456: hr_utility.set_location(' cal val :'|| p_cal_val,170);

2452:
2453: p_entr_val_at_enrt_flag := l_abr.entr_val_at_enrt_flag;
2454:
2455: hr_utility.set_location(' l_abr.rt_mlt_cd:'||l_abr.rt_mlt_cd,170);
2456: hr_utility.set_location(' cal val :'|| p_cal_val,170);
2457: --- bug 1480407
2458: -- when entr_val_at_enrt_flag and use_calc_acty_bs_rt_flag is true this calculation will be called
2459: -- after enrolement with the entered rate so the calulatiuon is to be done for incomming value
2460: --- also validate the min max with the ammount entered , thi validation will be skipped in Rhi for

Line 2506: hr_utility.set_location(' incomming value ' || l_abr.val , 407);

2502: End if;
2503:
2504:
2505: l_abr.val := p_cal_val;
2506: hr_utility.set_location(' incomming value ' || l_abr.val , 407);
2507: end if ;
2508:
2509: /* Bug 6015724 */
2510: l_prv_rt_strt_dt := null; -- 5748126

Line 2548: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id

2544: l_prv_rt_strt_dt,
2545: l_prv_rt_end_dt;
2546: --
2547: if (g_debug) then
2548: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id
2549: ||':'|| l_prv_rt_strt_dt ||':'|| l_prv_rt_end_dt, 10);
2550: end if;
2551: --
2552: exit when (c_perfprv%notfound or l_prv_rt_strt_dt <= l_effective_date); -- 5898039: Changed from < to <=

Line 2572: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id

2568: l_prv_rt_strt_dt,
2569: l_prv_rt_end_dt;
2570: --
2571: if (g_debug) then
2572: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id
2573: ||':'|| l_prv_rt_strt_dt ||':'|| l_prv_rt_end_dt, 10);
2574: end if;
2575: --
2576: exit when (c_perfprv_2%notfound or l_prv_rt_strt_dt <= l_effective_date); -- 5898039: Changed from < to <=

Line 2606: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id

2602: l_prv_rt_strt_dt,
2603: l_prv_rt_end_dt;
2604: --
2605: if (g_debug) then
2606: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id
2607: ||':'|| l_prv_rt_strt_dt ||':'|| l_prv_rt_end_dt, 10);
2608: end if;
2609: --
2610: exit when c_prv%notfound or l_prv_rt_strt_dt <= l_effective_date; -- 5898039: Changed from < to <=

Line 2615: hr_utility.set_location ('Cl c_prv '||l_package,10);

2611: end loop;
2612: close c_prv;
2613: --
2614: end if;
2615: hr_utility.set_location ('Cl c_prv '||l_package,10);
2616:
2617: p_prtt_rt_val_id := l_prtt_rt_val_id;
2618: /* End Bug 6015724 */
2619: --

Line 2668: hr_utility.set_location(' abr value ' || l_abr.val , 407);

2664: ,p_calculated_val => l_val);
2665:
2666: elsif l_abr.rt_mlt_cd = 'PRNT' then
2667:
2668: hr_utility.set_location(' abr value ' || l_abr.val , 407);
2669: hr_utility.set_location(' parent ' || l_prnt_rt_value , 407);
2670: benutils.rt_typ_calc
2671: (p_rt_typ_cd => l_abr.rt_typ_cd
2672: ,p_val => l_abr.val

Line 2669: hr_utility.set_location(' parent ' || l_prnt_rt_value , 407);

2665:
2666: elsif l_abr.rt_mlt_cd = 'PRNT' then
2667:
2668: hr_utility.set_location(' abr value ' || l_abr.val , 407);
2669: hr_utility.set_location(' parent ' || l_prnt_rt_value , 407);
2670: benutils.rt_typ_calc
2671: (p_rt_typ_cd => l_abr.rt_typ_cd
2672: ,p_val => l_abr.val
2673: ,p_val_2 => l_prnt_rt_value

Line 2678: hr_utility.set_location(' result ' || l_val , 407);

2674: ,p_calculated_val => l_val);
2675: if l_val is null then
2676: l_val := 0;
2677: end if;
2678: hr_utility.set_location(' result ' || l_val , 407);
2679: elsif l_abr.rt_mlt_cd = 'CLANDCVG' then
2680: benutils.rt_typ_calc
2681: (p_rt_typ_cd => l_abr.rt_typ_cd
2682: ,p_val => l_abr.val

Line 2765: hr_utility.set_location ('BDR_ATP '||l_package||to_char(l_coverage_value),299);

2761: l_val := 0;
2762: end if;
2763:
2764: elsif l_abr.rt_mlt_cd = 'SAREC' then
2765: hr_utility.set_location ('BDR_ATP '||l_package||to_char(l_coverage_value),299);
2766: --ikasire -- not passing the p_complete_year_flag per bug 1650517
2767: /* Bug 6015724 */
2768: if l_rt_ovridn_flag = 'Y' and nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then
2769: --

Line 2820: hr_utility.set_location ('BDR_ATP '||l_package,291);

2816: --
2817: --Bug 2149438
2818: l_val := round(l_val,4);
2819: --
2820: hr_utility.set_location ('BDR_ATP '||l_package,291);
2821: /**************************************/
2822: /* --Bug 2149438
2823: l_calc_val := ben_distribute_rates.period_to_annual
2824: (p_amount => l_val,

Line 2860: hr_utility.set_location ('BDR_ATP '||to_char(p_ann_val),222);

2856: end if; -- end if for if l_rt_ovridn_flag = 'Y'
2857: /* End Bug 6015724 */
2858: --
2859: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
2860: hr_utility.set_location ('BDR_ATP '||to_char(p_ann_val),222);
2861: hr_utility.set_location ('BDR_ATP '||to_char(l_cmcd_val),223);
2862: hr_utility.set_location ('BDR_ATP '||to_char(l_val),224);
2863: elsif l_abr.rt_mlt_cd = 'NSVU' then
2864: null; -- do nothing if 'no standard value used'

Line 2861: hr_utility.set_location ('BDR_ATP '||to_char(l_cmcd_val),223);

2857: /* End Bug 6015724 */
2858: --
2859: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
2860: hr_utility.set_location ('BDR_ATP '||to_char(p_ann_val),222);
2861: hr_utility.set_location ('BDR_ATP '||to_char(l_cmcd_val),223);
2862: hr_utility.set_location ('BDR_ATP '||to_char(l_val),224);
2863: elsif l_abr.rt_mlt_cd = 'NSVU' then
2864: null; -- do nothing if 'no standard value used'
2865: elsif l_abr.rt_mlt_cd = 'PRV' then

Line 2862: hr_utility.set_location ('BDR_ATP '||to_char(l_val),224);

2858: --
2859: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
2860: hr_utility.set_location ('BDR_ATP '||to_char(p_ann_val),222);
2861: hr_utility.set_location ('BDR_ATP '||to_char(l_cmcd_val),223);
2862: hr_utility.set_location ('BDR_ATP '||to_char(l_val),224);
2863: elsif l_abr.rt_mlt_cd = 'NSVU' then
2864: null; -- do nothing if 'no standard value used'
2865: elsif l_abr.rt_mlt_cd = 'PRV' then
2866: --- for grade step progression

Line 2867: hr_utility.set_location('GSP mulsti code PRV ',551) ;

2863: elsif l_abr.rt_mlt_cd = 'NSVU' then
2864: null; -- do nothing if 'no standard value used'
2865: elsif l_abr.rt_mlt_cd = 'PRV' then
2866: --- for grade step progression
2867: hr_utility.set_location('GSP mulsti code PRV ',551) ;
2868: open c_pgr (l_abr.pay_rate_grade_rule_id , l_effective_date ) ;
2869: fetch c_pgr into l_val ;
2870: close c_pgr ;
2871: hr_utility.set_location('GSP value '|| l_val ,551) ;

Line 2871: hr_utility.set_location('GSP value '|| l_val ,551) ;

2867: hr_utility.set_location('GSP mulsti code PRV ',551) ;
2868: open c_pgr (l_abr.pay_rate_grade_rule_id , l_effective_date ) ;
2869: fetch c_pgr into l_val ;
2870: close c_pgr ;
2871: hr_utility.set_location('GSP value '|| l_val ,551) ;
2872:
2873: else
2874: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2875: fnd_message.set_token('PROC',l_package);

Line 2879: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);

2875: fnd_message.set_token('PROC',l_package);
2876: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2877: fnd_message.raise_error;
2878: end if;
2879: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2880: --
2881: -- set some of the outputs
2882: --
2883: hr_utility.set_location(' set outputs ',180);

Line 2883: hr_utility.set_location(' set outputs ',180);

2879: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2880: --
2881: -- set some of the outputs
2882: --
2883: hr_utility.set_location(' set outputs ',180);
2884: p_tx_typ_cd := l_abr.tx_typ_cd;
2885: p_acty_typ_cd := l_abr.acty_typ_cd;
2886: p_nnmntry_uom := l_abr.nnmntry_uom;
2887: p_dsply_on_enrt_flag := l_abr.dsply_on_enrt_flag;

Line 2895: hr_utility.set_location('p_ordr_num ='||p_ordr_num,181);

2891: p_mn_elcn_val := l_abr.mn_elcn_val;
2892: p_incrmt_elcn_val := l_abr.incrmt_elcn_val;
2893: p_ordr_num := l_abr.ordr_num;
2894:
2895: hr_utility.set_location('p_ordr_num ='||p_ordr_num,181);
2896:
2897: -- get default value from the right place depending on dflt code
2898: /*
2899: if l_dflt_enrt_cd in ('NSDCS','NNCS') then

Line 2934: hr_utility.set_location ('Lim Chk '||l_package,10);

2930:
2931: --bug : 1433393 Value us validated befoe calcualting the
2932: --variable rate riable rate with value us validated agains the ulitmate values of
2933: -- VAPRO
2934: hr_utility.set_location ('Lim Chk '||l_package,10);
2935: benutils.limit_checks
2936: (p_upr_lmt_val => l_abr.upr_lmt_val,
2937: p_lwr_lmt_val => l_abr.lwr_lmt_val,
2938: p_upr_lmt_calc_rl => l_abr.upr_lmt_calc_rl,

Line 2974: hr_utility.set_location (' Before FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);

2970: else
2971: --Bug 2192102 if the rate is of Flex credit letus get the associated enrt bnft id
2972: if l_enrt_bnft_id is null and l_abr.rt_usg_cd = 'FLXCR' then
2973: --
2974: hr_utility.set_location (' Before FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
2975: --
2976: open c_enb_fc ;
2977: fetch c_enb_fc into l_enrt_bnft_id ;
2978: close c_enb_fc;

Line 2980: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);

2976: open c_enb_fc ;
2977: fetch c_enb_fc into l_enrt_bnft_id ;
2978: close c_enb_fc;
2979: --
2980: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
2981: end if;
2982: --
2983: hr_utility.set_location ('BDVR_MN '||l_package,10);
2984: ben_determine_variable_rates.main

Line 2983: hr_utility.set_location ('BDVR_MN '||l_package,10);

2979: --
2980: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
2981: end if;
2982: --
2983: hr_utility.set_location ('BDVR_MN '||l_package,10);
2984: ben_determine_variable_rates.main
2985: (p_currepe_row => p_currepe_row
2986: ,p_per_row => p_per_row
2987: ,p_asg_row => p_asg_row

Line 3021: hr_utility.set_location(' after ben_determine_variable_rates ',200);

3017: ,p_ann_mn_elcn_val => l_vr_ann_mn_elcn_val
3018: ,p_ann_mx_elcn_val => l_vr_ann_mx_elcn_val
3019: );
3020:
3021: hr_utility.set_location(' after ben_determine_variable_rates ',200);
3022: --if l_val is null then
3023: -- l_vr_trtmt_cd := 'RPLC';
3024: --end if;
3025: if (l_abr.rndg_cd is not null or

Line 3039: hr_utility.set_location('rounded value rate : ' ||to_char(l_val) ,954);

3035: p_effective_date => l_effective_date);
3036: l_val := l_rounded_value;
3037: end if;
3038:
3039: hr_utility.set_location('rounded value rate : ' ||to_char(l_val) ,954);
3040: hr_utility.set_location('variable rate : ' ||l_vr_val ,954);
3041: hr_utility.set_location('treatement : ' ||l_vr_trtmt_cd ,954);
3042: --
3043: -- Tilak Bug 2438506 : if the abr have null values then treat as 1 for

Line 3040: hr_utility.set_location('variable rate : ' ||l_vr_val ,954);

3036: l_val := l_rounded_value;
3037: end if;
3038:
3039: hr_utility.set_location('rounded value rate : ' ||to_char(l_val) ,954);
3040: hr_utility.set_location('variable rate : ' ||l_vr_val ,954);
3041: hr_utility.set_location('treatement : ' ||l_vr_trtmt_cd ,954);
3042: --
3043: -- Tilak Bug 2438506 : if the abr have null values then treat as 1 for
3044: -- multiply

Line 3041: hr_utility.set_location('treatement : ' ||l_vr_trtmt_cd ,954);

3037: end if;
3038:
3039: hr_utility.set_location('rounded value rate : ' ||to_char(l_val) ,954);
3040: hr_utility.set_location('variable rate : ' ||l_vr_val ,954);
3041: hr_utility.set_location('treatement : ' ||l_vr_trtmt_cd ,954);
3042: --
3043: -- Tilak Bug 2438506 : if the abr have null values then treat as 1 for
3044: -- multiply
3045: -- as 0 for add or subtract.

Line 3158: hr_utility.set_location(' l_vr_dflt_elcn_val ' ||l_abr.dflt_val , 199);

3154: end if ;
3155: --
3156: l_abr.dflt_val := nvl(l_vr_dflt_elcn_val,l_abr.dflt_val);
3157: --
3158: hr_utility.set_location(' l_vr_dflt_elcn_val ' ||l_abr.dflt_val , 199);
3159:
3160: hr_utility.set_location(' mn_elcn_va ' || l_vr_mn_elcn_val , 199);
3161: p_val := l_val;
3162: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);

Line 3160: hr_utility.set_location(' mn_elcn_va ' || l_vr_mn_elcn_val , 199);

3156: l_abr.dflt_val := nvl(l_vr_dflt_elcn_val,l_abr.dflt_val);
3157: --
3158: hr_utility.set_location(' l_vr_dflt_elcn_val ' ||l_abr.dflt_val , 199);
3159:
3160: hr_utility.set_location(' mn_elcn_va ' || l_vr_mn_elcn_val , 199);
3161: p_val := l_val;
3162: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3163: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3164: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then

Line 3162: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);

3158: hr_utility.set_location(' l_vr_dflt_elcn_val ' ||l_abr.dflt_val , 199);
3159:
3160: hr_utility.set_location(' mn_elcn_va ' || l_vr_mn_elcn_val , 199);
3161: p_val := l_val;
3162: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3163: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3164: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3165: hr_utility.set_location(' calling ultmate check rate ' ,393);
3166: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);

Line 3165: hr_utility.set_location(' calling ultmate check rate ' ,393);

3161: p_val := l_val;
3162: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3163: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3164: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3165: hr_utility.set_location(' calling ultmate check rate ' ,393);
3166: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);
3167: hr_utility.set_location('ammount '|| p_val ,393);
3168:
3169: benutils.limit_checks

Line 3166: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);

3162: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3163: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3164: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3165: hr_utility.set_location(' calling ultmate check rate ' ,393);
3166: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);
3167: hr_utility.set_location('ammount '|| p_val ,393);
3168:
3169: benutils.limit_checks
3170: (p_upr_lmt_val => l_ultmt_upr_lmt,

Line 3167: hr_utility.set_location('ammount '|| p_val ,393);

3163: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3164: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3165: hr_utility.set_location(' calling ultmate check rate ' ,393);
3166: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);
3167: hr_utility.set_location('ammount '|| p_val ,393);
3168:
3169: benutils.limit_checks
3170: (p_upr_lmt_val => l_ultmt_upr_lmt,
3171: p_lwr_lmt_val => l_ultmt_lwr_lmt,

Line 3187: hr_utility.set_location('ammount '|| p_val ,393);

3183: p_opt_id => l_opt.opt_id,
3184: p_ler_id => l_epe.ler_id,
3185: p_state => l_state.region_2,
3186: p_val => p_val); -- l_rounded_value);
3187: hr_utility.set_location('ammount '|| p_val ,393);
3188:
3189: end if ;
3190: --
3191: end if;

Line 3255: hr_utility.set_location ('BDD_RACD '||l_package,10);

3251: fetch c_current_elig into l_prtn_strt_dt;
3252: close c_current_elig;
3253: --
3254: end if;
3255: hr_utility.set_location ('BDD_RACD '||l_package,10);
3256: ben_determine_date.rate_and_coverage_dates
3257: (p_cache_mode => TRUE
3258: ,p_par_ptip_id => l_epe.ptip_id
3259: ,p_par_plip_id => l_epe.plip_id

Line 3293: hr_utility.set_location ('Dn BDD_RACD '||l_package,10);

3289: ,p_rt_end_dt => l_dummy_date
3290: ,p_rt_end_dt_cd => l_dummy_char
3291: ,p_rt_end_dt_rl => l_dummy_num
3292: );
3293: hr_utility.set_location ('Dn BDD_RACD '||l_package,10);
3294: p_rt_strt_dt := l_rt_strt_dt;
3295: p_rt_strt_dt_cd := l_rt_strt_dt_cd;
3296: p_rt_strt_dt_rl := l_rt_strt_dt_rl;
3297: end if;

Line 3342: hr_utility.set_location ('BDR_PTA '||l_package,10);

3338: p_cmcd_mx_elcn_val := nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val);
3339: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
3340:
3341: else
3342: hr_utility.set_location ('BDR_PTA '||l_package,10);
3343: hr_utility.set_location (' l_abr.dflt_val '||l_abr.dflt_val,22);
3344: hr_utility.set_location (' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
3345: --
3346: --Bug 2445318 We need to see whether to assign the l_abr.dflt_val to

Line 3343: hr_utility.set_location (' l_abr.dflt_val '||l_abr.dflt_val,22);

3339: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
3340:
3341: else
3342: hr_utility.set_location ('BDR_PTA '||l_package,10);
3343: hr_utility.set_location (' l_abr.dflt_val '||l_abr.dflt_val,22);
3344: hr_utility.set_location (' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
3345: --
3346: --Bug 2445318 We need to see whether to assign the l_abr.dflt_val to
3347: -- p_ann_dflt_val or p_dflt_val

Line 3344: hr_utility.set_location (' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);

3340:
3341: else
3342: hr_utility.set_location ('BDR_PTA '||l_package,10);
3343: hr_utility.set_location (' l_abr.dflt_val '||l_abr.dflt_val,22);
3344: hr_utility.set_location (' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
3345: --
3346: --Bug 2445318 We need to see whether to assign the l_abr.dflt_val to
3347: -- p_ann_dflt_val or p_dflt_val
3348: --

Line 3402: hr_utility.set_location (' p_dflt_val '||p_dflt_val,23);

3398: end if;
3399: end if;
3400: --
3401: -- end if; -- 'D' Mode
3402: hr_utility.set_location (' p_dflt_val '||p_dflt_val,23);
3403: hr_utility.set_location (' p_ann_dflt_val '||p_ann_dflt_val,23);
3404: hr_utility.set_location (' l_ann_dflt_val '||l_ann_dflt_val,22);
3405: --GEVITY
3406: IF l_abr.rate_periodization_rl IS NOT NULL THEN

Line 3403: hr_utility.set_location (' p_ann_dflt_val '||p_ann_dflt_val,23);

3399: end if;
3400: --
3401: -- end if; -- 'D' Mode
3402: hr_utility.set_location (' p_dflt_val '||p_dflt_val,23);
3403: hr_utility.set_location (' p_ann_dflt_val '||p_ann_dflt_val,23);
3404: hr_utility.set_location (' l_ann_dflt_val '||l_ann_dflt_val,22);
3405: --GEVITY
3406: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3407: --

Line 3404: hr_utility.set_location (' l_ann_dflt_val '||l_ann_dflt_val,22);

3400: --
3401: -- end if; -- 'D' Mode
3402: hr_utility.set_location (' p_dflt_val '||p_dflt_val,23);
3403: hr_utility.set_location (' p_ann_dflt_val '||p_ann_dflt_val,23);
3404: hr_utility.set_location (' l_ann_dflt_val '||l_ann_dflt_val,22);
3405: --GEVITY
3406: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3407: --
3408: l_dfnd_dummy := p_val ;

Line 3438: hr_utility.set_location ('BDR_PTA '||l_package,290);

3434: p_effective_date => l_effective_date,
3435: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
3436: p_complete_year_flag => 'Y',
3437: p_payroll_id => l_payroll_id);
3438: hr_utility.set_location ('BDR_PTA '||l_package,290);
3439: --
3440: l_calc_val := ben_distribute_rates.period_to_annual
3441: (p_amount => p_val,
3442: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,

Line 3506: hr_utility.set_location ('BDR_ATP '||l_package,290);

3502: end if;
3503: --
3504: p_ann_mn_elcn_val := nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val);
3505: p_ann_mx_elcn_val := nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val);
3506: hr_utility.set_location ('BDR_ATP '||l_package,290);
3507: hr_utility.set_location ('Dn BDR_ATP '||l_package,290);
3508: --
3509: end if;
3510: --

Line 3507: hr_utility.set_location ('Dn BDR_ATP '||l_package,290);

3503: --
3504: p_ann_mn_elcn_val := nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val);
3505: p_ann_mx_elcn_val := nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val);
3506: hr_utility.set_location ('BDR_ATP '||l_package,290);
3507: hr_utility.set_location ('Dn BDR_ATP '||l_package,290);
3508: --
3509: end if;
3510: --
3511: -- bug fix 2569884 - Communicated Min and Max values are needed for self service

Line 3608: hr_utility.set_location ('HMANI '||l_abr.dflt_val,290.3);

3604:
3605: -- hmani
3606:
3607: if l_abr.dflt_val is not null then
3608: hr_utility.set_location ('HMANI '||l_abr.dflt_val,290.3);
3609: --GEVITY
3610: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3611: --
3612: --null;

Line 3638: hr_utility.set_location ('HMANI Me here'||l_cmcd_dflt_val,290.3);

3634: else
3635: l_element_type_id := null;
3636: end if;
3637: --
3638: hr_utility.set_location ('HMANI Me here'||l_cmcd_dflt_val,290.3);
3639: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period
3640: (p_amount => p_ann_dflt_val,
3641: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3642: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,

Line 3654: hr_utility.set_location ('HMANI '||l_cmcd_dflt_val,290.3);

3650: --7154229
3651: if(p_cmcd_val is null) then
3652: p_cmcd_val := l_cmcd_dflt_val;
3653: end if;
3654: hr_utility.set_location ('HMANI '||l_cmcd_dflt_val,290.3);
3655: END IF; --GEVITY
3656: end if;
3657:
3658: -- End of hmani

Line 3820: hr_utility.set_location ('HMANI '||l_cmcd_dflt_val,290.678);

3816: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
3817: p_complete_year_flag => 'Y',
3818: p_payroll_id => l_payroll_id,
3819: p_element_type_id => l_element_type_id);
3820: hr_utility.set_location ('HMANI '||l_cmcd_dflt_val,290.678);
3821: --
3822: END IF; --GEVITY
3823: end if;
3824:

Line 3850: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);

3846: -- has been chosen and the l_cmcd_dflt val has been returned in the p_iss_val
3847: -- We here check that the mode is not CWB since CWB only uses iss_val
3848:
3849: ben_env_object.get(p_rec => l_env);
3850: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);
3851:
3852: if l_env.mode_cd <> 'W' and p_iss_val is null then
3853: p_iss_val := l_cmcd_dflt_val ;
3854: end if;

Line 3915: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);

3911: --
3912: end if;
3913: -- Bug 4637525
3914: --
3915: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
3916: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
3917: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
3918: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
3919: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);

Line 3916: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);

3912: end if;
3913: -- Bug 4637525
3914: --
3915: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
3916: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
3917: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
3918: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
3919: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
3920: --

Line 3917: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);

3913: -- Bug 4637525
3914: --
3915: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
3916: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
3917: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
3918: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
3919: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
3920: --
3921: if nvl(l_env.mode_cd,'~') = 'W' and

Line 3918: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);

3914: --
3915: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
3916: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
3917: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
3918: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
3919: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
3920: --
3921: if nvl(l_env.mode_cd,'~') = 'W' and
3922: l_abr.entr_val_at_enrt_flag = 'Y' and

Line 3919: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);

3915: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
3916: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
3917: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
3918: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
3919: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
3920: --
3921: if nvl(l_env.mode_cd,'~') = 'W' and
3922: l_abr.entr_val_at_enrt_flag = 'Y' and
3923: l_abr.rt_mlt_cd in ('CL' ) and

Line 3935: hr_utility.set_location('l_cwb_mn_elcn_val is '||l_cwb_mn_elcn_val,951);

3931: ,p_val => p_mn_elcn_val
3932: ,p_val_2 => l_compensation_value
3933: ,p_calculated_val => l_cwb_mn_elcn_val);
3934: --
3935: hr_utility.set_location('l_cwb_mn_elcn_val is '||l_cwb_mn_elcn_val,951);
3936: --
3937: --
3938: benutils.rt_typ_calc
3939: (p_rt_typ_cd => l_abr.rt_typ_cd

Line 3944: hr_utility.set_location('l_cwb_mx_elcn_val is '|| l_cwb_mx_elcn_val,951);

3940: ,p_val => p_mx_elcn_val
3941: ,p_val_2 => l_compensation_value
3942: ,p_calculated_val => l_cwb_mx_elcn_val);
3943: --
3944: hr_utility.set_location('l_cwb_mx_elcn_val is '|| l_cwb_mx_elcn_val,951);
3945: --
3946: -- 5371364 : Do not Operate (i.e multiply/divide..) the Increment Value.
3947: l_cwb_incrmt_elcn_val := p_incrmt_elcn_val;
3948: /*

Line 3957: hr_utility.set_location('l_cwb_incrmt_elcn_val is '|| l_cwb_incrmt_elcn_val,951);

3953: ,p_calculated_val => l_cwb_incrmt_elcn_val);
3954: */
3955: --
3956:
3957: hr_utility.set_location('l_cwb_incrmt_elcn_val is '|| l_cwb_incrmt_elcn_val,951);
3958: --
3959: benutils.rt_typ_calc
3960: (p_rt_typ_cd => l_abr.rt_typ_cd
3961: ,p_val => l_vr_dflt_elcn_val

Line 3965: hr_utility.set_location('l_cwb_dflt_val is '|| l_cwb_dflt_val,951);

3961: ,p_val => l_vr_dflt_elcn_val
3962: ,p_val_2 => l_compensation_value
3963: ,p_calculated_val => l_cwb_dflt_val);
3964: --
3965: hr_utility.set_location('l_cwb_dflt_val is '|| l_cwb_dflt_val,951);
3966: --
3967: --
3968: -- Round the values. Bug 4873847.
3969: --

Line 4008: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);

4004: p_incrmt_elcn_val := nvl(l_cwb_incrmt_elcn_val,p_incrmt_elcn_val);
4005: l_vr_dflt_elcn_val := nvl(l_cwb_dflt_val, l_vr_dflt_elcn_val );
4006: p_dflt_val := l_vr_dflt_elcn_val;
4007: --
4008: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4009: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4010: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4011: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4012: --

Line 4009: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);

4005: l_vr_dflt_elcn_val := nvl(l_cwb_dflt_val, l_vr_dflt_elcn_val );
4006: p_dflt_val := l_vr_dflt_elcn_val;
4007: --
4008: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4009: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4010: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4011: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4012: --
4013: end if;

Line 4010: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);

4006: p_dflt_val := l_vr_dflt_elcn_val;
4007: --
4008: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4009: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4010: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4011: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4012: --
4013: end if;
4014: --

Line 4011: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);

4007: --
4008: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4009: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4010: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4011: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4012: --
4013: end if;
4014: --
4015: -- Bug 4637525

Line 4034: hr_utility.set_location ('Leaving '||l_package,999);

4030: p_val := l_rt_val;
4031: end if;
4032: */
4033:
4034: hr_utility.set_location ('Leaving '||l_package,999);
4035: exception
4036: --
4037: when others then
4038: --

Line 4167: hr_utility.trace_on(null,'BENACTBR');

4163: l_trace_on := false;
4164: end if;
4165: --
4166: if l_trace_on then
4167: hr_utility.trace_on(null,'BENACTBR');
4168: end if;
4169: --
4170: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4171: hr_utility.set_location ('Entering '||l_package,10);

Line 4170: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);

4166: if l_trace_on then
4167: hr_utility.trace_on(null,'BENACTBR');
4168: end if;
4169: --
4170: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4171: hr_utility.set_location ('Entering '||l_package,10);
4172: --
4173: ben_env_object.init(p_business_group_id => p_business_group_id,
4174: p_effective_date => p_effective_date,

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

4167: hr_utility.trace_on(null,'BENACTBR');
4168: end if;
4169: --
4170: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4171: hr_utility.set_location ('Entering '||l_package,10);
4172: --
4173: ben_env_object.init(p_business_group_id => p_business_group_id,
4174: p_effective_date => p_effective_date,
4175: p_thread_id => 1,

Line 4245: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);

4241: ,p_pp_in_yr_used_num => l_dummy_num
4242: ,p_ordr_num => l_dummy_num
4243: ,p_iss_val => l_dummy_num);
4244:
4245: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4246: hr_utility.set_location (' p_val: '||p_val,900);
4247: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4248: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4249:

Line 4246: hr_utility.set_location (' p_val: '||p_val,900);

4242: ,p_ordr_num => l_dummy_num
4243: ,p_iss_val => l_dummy_num);
4244:
4245: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4246: hr_utility.set_location (' p_val: '||p_val,900);
4247: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4248: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4249:
4250: --

Line 4247: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);

4243: ,p_iss_val => l_dummy_num);
4244:
4245: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4246: hr_utility.set_location (' p_val: '||p_val,900);
4247: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4248: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4249:
4250: --
4251: if p_enrt_bnft_id is not null then

Line 4248: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);

4244:
4245: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4246: hr_utility.set_location (' p_val: '||p_val,900);
4247: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4248: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4249:
4250: --
4251: if p_enrt_bnft_id is not null then
4252: --

Line 4321: hr_utility.set_location ('Output Values: '||l_package,900);

4317: end if;
4318: --
4319: end if;
4320:
4321: hr_utility.set_location ('Output Values: '||l_package,900);
4322: hr_utility.set_location (' p_val: '||p_val,900);
4323: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4324: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4325:

Line 4322: hr_utility.set_location (' p_val: '||p_val,900);

4318: --
4319: end if;
4320:
4321: hr_utility.set_location ('Output Values: '||l_package,900);
4322: hr_utility.set_location (' p_val: '||p_val,900);
4323: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4324: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4325:
4326: hr_utility.set_location ('Leaving '|| l_package,999);

Line 4323: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);

4319: end if;
4320:
4321: hr_utility.set_location ('Output Values: '||l_package,900);
4322: hr_utility.set_location (' p_val: '||p_val,900);
4323: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4324: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4325:
4326: hr_utility.set_location ('Leaving '|| l_package,999);
4327: --

Line 4324: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);

4320:
4321: hr_utility.set_location ('Output Values: '||l_package,900);
4322: hr_utility.set_location (' p_val: '||p_val,900);
4323: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4324: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4325:
4326: hr_utility.set_location ('Leaving '|| l_package,999);
4327: --
4328: if l_trace_on then

Line 4326: hr_utility.set_location ('Leaving '|| l_package,999);

4322: hr_utility.set_location (' p_val: '||p_val,900);
4323: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4324: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4325:
4326: hr_utility.set_location ('Leaving '|| l_package,999);
4327: --
4328: if l_trace_on then
4329: hr_utility.trace_off;
4330: l_trace_param := null;

Line 4329: hr_utility.trace_off;

4325:
4326: hr_utility.set_location ('Leaving '|| l_package,999);
4327: --
4328: if l_trace_on then
4329: hr_utility.trace_off;
4330: l_trace_param := null;
4331: l_trace_on := false;
4332: end if;
4333:

Line 4343: hr_utility.trace_off;

4339: p_ann_val := null;
4340: p_cmcd_val := null;
4341: fnd_msg_pub.add;
4342: if l_trace_on then
4343: hr_utility.trace_off;
4344: l_trace_on := false;
4345: l_trace_param := null;
4346: end if;
4347: end main_w;