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 393: g_debug boolean := hr_utility.debug_enabled;

389: */
390: --------------------------------------------------------------------------------
391: --
392: g_package varchar2(80) := 'ben_determine_activity_base_rt';
393: g_debug boolean := hr_utility.debug_enabled;
394: --
395: TYPE g_element_link_id_table IS TABLE OF pay_element_links_f.element_link_id%TYPE
396: INDEX BY BINARY_INTEGER;
397: --

Line 1264: g_debug := hr_utility.debug_enabled;

1260: end;
1261: --
1262: begin
1263: --
1264: g_debug := hr_utility.debug_enabled;
1265: hr_utility.set_location ('Entering '||l_package,10);
1266: --
1267: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1268: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));

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

1261: --
1262: begin
1263: --
1264: g_debug := hr_utility.debug_enabled;
1265: hr_utility.set_location ('Entering '||l_package,10);
1266: --
1267: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1268: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1269: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;

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

1267: l_effective_date := nvl(ben_manage_life_events.g_fonm_rt_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1268: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1269: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;
1270: --
1271: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1272: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1273: hr_utility.set_location('p_person_id '||p_person_id,20);
1274: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1275: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);

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

1268: l_cvg_eff_dt := nvl(ben_manage_life_events.g_fonm_cvg_strt_dt,nvl(p_lf_evt_ocrd_dt,p_effective_date));
1269: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;
1270: --
1271: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1272: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1273: hr_utility.set_location('p_person_id '||p_person_id,20);
1274: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1275: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1276: if p_calc_only_rt_val_flag then

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

1269: l_fonm_rt_strt_dt := ben_manage_life_events.g_fonm_rt_strt_dt;
1270: --
1271: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1272: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1273: hr_utility.set_location('p_person_id '||p_person_id,20);
1274: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1275: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1276: if p_calc_only_rt_val_flag then
1277: hr_utility.set_location(' p_calc_only_rt_val_flag',10);

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

1270: --
1271: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1272: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1273: hr_utility.set_location('p_person_id '||p_person_id,20);
1274: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1275: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1276: if p_calc_only_rt_val_flag then
1277: hr_utility.set_location(' p_calc_only_rt_val_flag',10);
1278: end if ;

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

1271: hr_utility.set_location('l_effective_date'||l_effective_date,10);
1272: hr_utility.set_location('p_acty_base_rt_id'||p_acty_base_rt_id,20);
1273: hr_utility.set_location('p_person_id '||p_person_id,20);
1274: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1275: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1276: if p_calc_only_rt_val_flag then
1277: hr_utility.set_location(' p_calc_only_rt_val_flag',10);
1278: end if ;
1279: --

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

1273: hr_utility.set_location('p_person_id '||p_person_id,20);
1274: hr_utility.set_location('p_effective_date'||p_effective_date,20);
1275: hr_utility.set_location(' p_elig_per_elctbl_chc_id'||p_elig_per_elctbl_chc_id,20);
1276: if p_calc_only_rt_val_flag then
1277: hr_utility.set_location(' p_calc_only_rt_val_flag',10);
1278: end if ;
1279: --
1280: -- Ensure relevant parameters have been populated with values
1281: --

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

1303: fnd_message.set_token('PROC','Standard Rates');
1304: fnd_message.set_token('PARAM','p_elig_per_elctbl_chc_id');
1305: fnd_message.raise_error;
1306: end if;
1307: hr_utility.set_location (' Checking Electable Choice ',20);
1308: --
1309: -- Populate electable choice information
1310: --
1311: l_coverage_value := p_bnft_amt;

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

1355: fnd_message.raise_error;
1356: end if;
1357: close c_epe;
1358: end if;
1359: hr_utility.set_location ('Dn Pop EPE'||l_package,10);
1360: --
1361: -- Get related information from either the context record or
1362: --
1363: if p_currepe_row.oipl_id is not null

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

1391: open c_pln_auto_distr (p_currepe_row.elig_per_elctbl_chc_id);
1392: fetch c_pln_auto_distr into l_pln_auto_distr_flag;
1393: close c_pln_auto_distr;
1394: end if;
1395: hr_utility.set_location('Roundng'||l_abr.rndg_cd,951);
1396: --
1397: -- get values for rules and limit checking
1398: --
1399: -- bug fix 3457483

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

1424: --
1425: CLOSE c_pl_typ;
1426:
1427: --
1428: hr_utility.set_location ('l_input_value_id' || l_input_value_id, 33);
1429:
1430: IF l_opt_typ_cd = 'ICM'
1431: THEN
1432: --

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

1439:
1440: --
1441: IF l_abr_level.pl_id IS NOT NULL
1442: THEN
1443: hr_utility.set_location ('PL LEVEL' || l_abr_level.pl_id, 32);
1444: ELSIF l_abr_level.oipl_id IS NOT NULL
1445: THEN
1446: hr_utility.set_location ('OIPL LEVEL' || l_abr_level.oipl_id, 32);
1447: END IF;

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

1442: THEN
1443: hr_utility.set_location ('PL LEVEL' || l_abr_level.pl_id, 32);
1444: ELSIF l_abr_level.oipl_id IS NOT NULL
1445: THEN
1446: hr_utility.set_location ('OIPL LEVEL' || l_abr_level.oipl_id, 32);
1447: END IF;
1448:
1449: -- To find the eligible element link for the element attached to a Rate
1450: OPEN c_elem_link (l_abr.element_type_id);

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

1455: FETCH c_elem_link
1456: INTO l_input_value_id;
1457:
1458: EXIT WHEN c_elem_link%NOTFOUND;
1459: hr_utility.set_location ('l_input_value_id' || l_input_value_id, 32);
1460: --
1461: ben_element_entry.get_link
1462: (p_assignment_id => l_assignment_id,
1463: p_element_type_id => l_abr.element_type_id,

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

1470: --
1471: IF l_element_link_id = l_input_value_id
1472: THEN
1473: --
1474: hr_utility.set_location ('l_element_link_id' || l_element_link_id,
1475: 321
1476: );
1477: l_element_link_id_table (l_element_link_id_table.COUNT + 1) :=
1478: l_element_link_id;

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

1486: IF l_abr.input_va_calc_rl IS NOT NULL
1487: THEN
1488: --
1489: l_outputs.DELETE;
1490: hr_utility.set_location ( 'l_abr.input_va_calc_rl'
1491: || l_abr.input_va_calc_rl,
1492: 13
1493: );
1494: -- getting the values returned by rule

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

1505: p_pl_typ_id => l_epe.pl_typ_id,
1506: p_acty_base_rt_id => p_acty_base_rt_id
1507: );
1508: --
1509: hr_utility.set_location ('l_count' || l_outputs.COUNT, 321);
1510: --
1511: EXCEPTION
1512: WHEN OTHERS
1513: THEN

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

1521: END;
1522: --
1523: END IF;
1524:
1525: hr_utility.set_location ( 'l_element_link_id_table.LAST'
1526: || l_element_link_id_table.LAST,
1527: 23
1528: );
1529: --

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

1530: l_counter := 0;
1531: --
1532: l_cnt_links := 0;
1533: l_cnt_inp_vals := 0;
1534: hr_utility.set_location (l_element_link_id_table.FIRST, 1121);
1535:
1536: -- putting all the default values in an element link to a table that will be used to insert values in ben_icd_chc_rates
1537: IF l_element_link_id_table.COUNT > 0
1538: THEN

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

1540: FOR i IN
1541: l_element_link_id_table.FIRST .. l_element_link_id_table.LAST
1542: --
1543: LOOP
1544: hr_utility.set_location ( 'l_element_link_id_table (i)'
1545: || l_element_link_id_table (i),
1546: 11
1547: );
1548: IF NOT l_icd_chc_rates_tab.EXISTS(1) THEN

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

1555: --
1556: END IF;
1557: --
1558: -- l_cnt_links := 1;
1559: hr_utility.set_location('l_cnt_links'||l_cnt_links,14);
1560: --
1561: -- creating row for icd pl sql table
1562: l_icd_chc_rates_tab (l_cnt_links).element_link_id :=
1563: l_element_link_id_table (i);

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

1564:
1565: --
1566: IF l_abr_level.pl_id IS NULL
1567: THEN
1568: hr_utility.set_location ('PLAN', 23);
1569: l_icd_chc_rates_tab (l_cnt_links).l_level := 'O';
1570: -- l_icd_chc_rates_tab (l_cnt_links).pl_id := NULL;
1571: -- l_icd_chc_rates_tab (l_cnt_links).oipl_id := l_epe.oipl_id;
1572: ELSIF l_abr_level.oipl_id IS NULL

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

1570: -- l_icd_chc_rates_tab (l_cnt_links).pl_id := NULL;
1571: -- l_icd_chc_rates_tab (l_cnt_links).oipl_id := l_epe.oipl_id;
1572: ELSIF l_abr_level.oipl_id IS NULL
1573: THEN
1574: hr_utility.set_location ('OIPL', 23);
1575: l_icd_chc_rates_tab (l_cnt_links).l_level := 'P';
1576: -- l_icd_chc_rates_tab (l_cnt_links).pl_id := l_epe.pl_id;
1577: -- l_icd_chc_rates_tab (l_cnt_links).oipl_id := NULL;
1578: END IF;

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

1606: --
1607: EXIT WHEN c_input_values%NOTFOUND;
1608: -- assigning default values
1609: --
1610: hr_utility.set_location ('l_cnt_inp_vals' || l_cnt_inp_vals,
1611: 21
1612: );
1613:
1614: IF l_cnt_inp_vals = 1

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

1716: --
1717: EXCEPTION
1718: WHEN OTHERS
1719: THEN
1720: hr_utility.set_location (SQLERRM, 23);
1721: END;
1722: --
1723: END LOOP;
1724: --

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

1723: END LOOP;
1724: --
1725: END IF;
1726:
1727: hr_utility.set_location ('Default values assigned ', 5);
1728: hr_utility.set_location ( l_icd_chc_rates_tab.FIRST
1729: || 'f counts'
1730: || l_icd_chc_rates_tab.LAST,
1731: 121

Line 1728: hr_utility.set_location ( l_icd_chc_rates_tab.FIRST

1724: --
1725: END IF;
1726:
1727: hr_utility.set_location ('Default values assigned ', 5);
1728: hr_utility.set_location ( l_icd_chc_rates_tab.FIRST
1729: || 'f counts'
1730: || l_icd_chc_rates_tab.LAST,
1731: 121
1732: );

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

1754: -- putting all the values returned by forumula in the table that will be used to insert values in ben_icd_chc_rates
1755: FOR l_cnt IN l_icd_chc_rates_tab.FIRST .. l_icd_chc_rates_tab.LAST
1756: -- change default values to formula returned value for every link
1757: LOOP
1758: hr_utility.set_location (' in loop ', 121);
1759:
1760: -- FOR l_cnt IN l_icd_chc_rates_tab.FIRST .. l_icd_chc_rates_tab.LAST
1761: FOR l_count IN l_outputs.FIRST .. l_outputs.LAST
1762: LOOP

Line 1774: hr_utility.set_location

1770: INTO l_ext_inpval_rec;
1771:
1772: EXIT WHEN c_ext_inpval%NOTFOUND;
1773: --
1774: hr_utility.set_location
1775: ( ' l_outputs (l_count).NAME '
1776: || l_outputs (l_count).NAME,
1777: 121
1778: );

Line 1779: hr_utility.set_location

1775: ( ' l_outputs (l_count).NAME '
1776: || l_outputs (l_count).NAME,
1777: 121
1778: );
1779: hr_utility.set_location
1780: ( ' l_ext_inpval_rec.return_var_name '
1781: || l_ext_inpval_rec.return_var_name,
1782: 121
1783: );

Line 1790: hr_utility.set_location

1786: l_ext_inpval_rec.return_var_name
1787: THEN
1788: --
1789: l_counter := l_counter + 1;
1790: hr_utility.set_location
1791: ('Before assign extra inputs cache',
1792: 11
1793: );
1794: --

Line 1795: hr_utility.set_location

1791: ('Before assign extra inputs cache',
1792: 11
1793: );
1794: --
1795: hr_utility.set_location
1796: ( 'l_ext_inpval_rec.extra_input_value_id'
1797: || l_ext_inpval_rec.extra_input_value_id,
1798: 132
1799: );

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

1797: || l_ext_inpval_rec.extra_input_value_id,
1798: 132
1799: );
1800: --
1801: hr_utility.set_location('l_cnt_links'||l_cnt_links,1231);
1802: l_input_value_id :=
1803: get_input_value_id
1804: (l_ext_inpval_rec.extra_input_value_id);
1805:

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

2001: p_business_group_id => l_epe.business_group_id,
2002: p_param1 => 'BEN_IV_PERSON_ID',
2003: p_param1_value => to_char(p_person_id)
2004: );
2005: hr_utility.set_location('l_outputs.count'||l_outputs.count,951);
2006: if (l_outputs.count >= 4) then
2007: for l_count in l_outputs.first..l_outputs.last loop
2008: begin
2009: if l_outputs(l_count).name = 'L_MN_ELCN_VAL' then

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

2027: else
2028: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
2029: fnd_message.raise_error;
2030: end if;
2031: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
2032: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
2033: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
2034: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
2035: end if;

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

2028: fnd_message.set_name('BEN','BEN_94130_MN_MX_RL_OUT_ERR');
2029: fnd_message.raise_error;
2030: end if;
2031: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
2032: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
2033: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
2034: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
2035: end if;
2036: --

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

2029: fnd_message.raise_error;
2030: end if;
2031: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
2032: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
2033: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
2034: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
2035: end if;
2036: --
2037:

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

2030: end if;
2031: --hr_utility.set_location('mn_elcn_val is '||l_abr.mn_elcn_val,951);
2032: --hr_utility.set_location('mx_elcn_val is '||l_abr.mx_elcn_val,951);
2033: --hr_utility.set_location('incrmt_elcn_val is '||l_abr.incrmt_elcn_val,951);
2034: --hr_utility.set_location('dflt_val is '||l_abr.dflt_val,951);
2035: end if;
2036: --
2037:
2038: -- end bug fix 3457483

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

2042: open c_state;
2043: fetch c_state into l_state;
2044: close c_state;
2045: */
2046: hr_utility.set_location (' Checking rate multiplier code ',40);
2047: if l_abr.rt_mlt_cd is null then
2048: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2049: fnd_message.set_token('COLUMN','rt_mlt_cd');
2050: fnd_message.set_token('PACKAGE',l_package);

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

2055: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2056: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2057: fnd_message.raise_error;
2058: end if;
2059: hr_utility.set_location (' Checking rate multiplier code others',50);
2060: if l_abr.rt_mlt_cd in ('FLFX','CL','AP','CVG','PRNT','CLANDCVG',
2061: 'APANDCVG','PRNTANDCVG') then
2062: if l_abr.val is null and l_abr.entr_val_at_enrt_flag = 'N' then
2063: --

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

2072: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2073: fnd_message.raise_error;
2074: end if;
2075: end if;
2076: hr_utility.set_location (' Checking acty base rate values ',60);
2077: --
2078: -- cwb now allows null values for min/max/incrmt so no need to validate
2079: --
2080: ben_env_object.get(p_rec => l_env);

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

2081: if (l_abr.entr_val_at_enrt_flag = 'Y' and l_abr.entr_ann_val_flag = 'N')
2082: and nvl(l_env.mode_cd,'~') <> 'W' then
2083:
2084: if l_abr.mn_elcn_val is null then
2085: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',61);
2086: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2087: fnd_message.set_token('COLUMN','mn_elcn_val');
2088: fnd_message.set_token('PACKAGE',l_package);
2089: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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

2094: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2095: fnd_message.raise_error;
2096:
2097: elsif l_abr.mx_elcn_val is null then
2098: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',62);
2099: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2100: fnd_message.set_token('COLUMN','mx_elcn_val');
2101: fnd_message.set_token('PACKAGE',l_package);
2102: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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

2106: fnd_message.set_token('PL_ID',to_char(p_pl_id));
2107: fnd_message.set_token('OIPL_ID',to_char(p_oipl_id));
2108: fnd_message.raise_error;
2109: elsif l_abr.incrmt_elcn_val is null then
2110: hr_utility.set_location (' BEN_91834_BASE_RATE_COLUMN_ERR ',63);
2111: fnd_message.set_name('BEN','BEN_91834_BASE_RATE_COLUMN_ERR');
2112: fnd_message.set_token('COLUMN','incrmt_elcn_val');
2113: fnd_message.set_token('PACKAGE',l_package);
2114: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

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

2120: fnd_message.raise_error;
2121: end if;
2122: end if;
2123:
2124: hr_utility.set_location(' checking if program or plan ',70);
2125: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),333);
2126:
2127: if l_epe.pgm_id is not null then
2128: open c_pgm

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

2121: end if;
2122: end if;
2123:
2124: hr_utility.set_location(' checking if program or plan ',70);
2125: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),333);
2126:
2127: if l_epe.pgm_id is not null then
2128: open c_pgm
2129: (c_effective_date => l_effective_date

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

2139: close c_pgm;
2140: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
2141: l_enrt_info_rt_freq_cd := l_pgm.enrt_info_rt_freq_cd;
2142: else
2143: hr_utility.set_location(' testing if plan ',80);
2144: hr_utility.set_location(' l_epe.pl_id'||l_epe.pl_id,80);
2145: open c_pln
2146: (c_effective_date => l_effective_date,
2147: c_pl_id => l_epe.pl_id

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

2140: l_acty_ref_perd_cd := l_pgm.acty_ref_perd_cd;
2141: l_enrt_info_rt_freq_cd := l_pgm.enrt_info_rt_freq_cd;
2142: else
2143: hr_utility.set_location(' testing if plan ',80);
2144: hr_utility.set_location(' l_epe.pl_id'||l_epe.pl_id,80);
2145: open c_pln
2146: (c_effective_date => l_effective_date,
2147: c_pl_id => l_epe.pl_id
2148: );

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

2160: end if;
2161: --
2162: -- Bug No 4538786
2163: --
2164: /* hr_utility.set_location('PPF changes: input epe id'||p_elig_per_elctbl_chc_id,99);
2165: hr_utility.set_location('PPF changes: element type id before changes'||l_abr.element_type_id,99); */
2166: if l_abr.rt_usg_cd = 'FLXCR' and l_enrt_info_rt_freq_cd = 'PPF' then
2167: -- hr_utility.set_location('PPF changes: fetching the element type id...',99);
2168: open get_rt_and_element(l_epe.pgm_id, l_epe.per_in_ler_id);

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

2161: --
2162: -- Bug No 4538786
2163: --
2164: /* hr_utility.set_location('PPF changes: input epe id'||p_elig_per_elctbl_chc_id,99);
2165: hr_utility.set_location('PPF changes: element type id before changes'||l_abr.element_type_id,99); */
2166: if l_abr.rt_usg_cd = 'FLXCR' and l_enrt_info_rt_freq_cd = 'PPF' then
2167: -- hr_utility.set_location('PPF changes: fetching the element type id...',99);
2168: open get_rt_and_element(l_epe.pgm_id, l_epe.per_in_ler_id);
2169: fetch get_rt_and_element into l_rt_and_element;

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

2163: --
2164: /* hr_utility.set_location('PPF changes: input epe id'||p_elig_per_elctbl_chc_id,99);
2165: hr_utility.set_location('PPF changes: element type id before changes'||l_abr.element_type_id,99); */
2166: if l_abr.rt_usg_cd = 'FLXCR' and l_enrt_info_rt_freq_cd = 'PPF' then
2167: -- hr_utility.set_location('PPF changes: fetching the element type id...',99);
2168: open get_rt_and_element(l_epe.pgm_id, l_epe.per_in_ler_id);
2169: fetch get_rt_and_element into l_rt_and_element;
2170: if get_rt_and_element%FOUND then
2171: l_abr.element_type_id := l_rt_and_element.element_type_id;

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

2171: l_abr.element_type_id := l_rt_and_element.element_type_id;
2172: end if;
2173: Close get_rt_and_element; -- Close added during bug fix 4604560
2174: end if;
2175: -- hr_utility.set_location('PPF changes: afterwards element type id'||l_abr.element_type_id,99);
2176: --
2177: -- End Bug No 4538786
2178: --
2179: -- get the dflt_enrt_cd/rule

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

2177: -- End Bug No 4538786
2178: --
2179: -- get the dflt_enrt_cd/rule
2180: --
2181: hr_utility.set_location ('BER_DDEC '||l_package,10);
2182: ben_env_object.get(p_rec => l_env);
2183: hr_utility.set_location('l_env.mode_cd' || l_env.mode_cd,13);
2184: if nvl(l_env.mode_cd,'~') <> 'D' then --cant set this code in 'D' Plans -- ICM
2185: --

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

2179: -- get the dflt_enrt_cd/rule
2180: --
2181: hr_utility.set_location ('BER_DDEC '||l_package,10);
2182: ben_env_object.get(p_rec => l_env);
2183: hr_utility.set_location('l_env.mode_cd' || l_env.mode_cd,13);
2184: if nvl(l_env.mode_cd,'~') <> 'D' then --cant set this code in 'D' Plans -- ICM
2185: --
2186: ben_enrolment_requirements.determine_dflt_enrt_cd
2187: (p_oipl_id =>l_epe.oipl_id

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

2194: ,p_dflt_enrt_rl =>l_dflt_enrt_rl
2195: ,p_business_group_id =>l_epe.business_group_id
2196: ,p_effective_date =>l_cvg_eff_dt
2197: );
2198: hr_utility.set_location ('BRRRRRP '||l_package||to_char(l_coverage_value),299);
2199: --
2200: end if;
2201: if l_abr.rt_mlt_cd in ('CVG','CLANDCVG','APANDCVG','PRNTANDCVG','SAREC') then
2202: --

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

2202: --
2203: --Bug 2192102 if the rate is of Flex credit letus get the associated enrt bnft id
2204: if l_abr.rt_usg_cd = 'FLXCR' then
2205: --
2206: hr_utility.set_location (' Before FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
2207: --
2208: open c_enb_fc ;
2209: fetch c_enb_fc into l_enrt_bnft_id ;
2210: close c_enb_fc;

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

2208: open c_enb_fc ;
2209: fetch c_enb_fc into l_enrt_bnft_id ;
2210: close c_enb_fc;
2211: --
2212: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
2213: end if;
2214: --
2215: if l_coverage_value is null then
2216: if l_enrt_bnft_id is null then

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

2258: fnd_message.raise_error;
2259: end if;
2260: p_cvg_calc_amt_mthd_id := l_cvg_calc_amt_mthd_id;
2261: end if;
2262: hr_utility.set_location ('ABR_RTMLTCD CL'||l_package,10);
2263: if l_abr.rt_mlt_cd in ('CL','CLANDCVG') then
2264: if l_abr.comp_lvl_fctr_id is null then
2265: fnd_message.set_name('BEN','BEN_92745_NO_ABR_CLF_EXISTS');
2266: fnd_message.raise_error;

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

2289: fnd_message.set_token('VARIABLE','l_compensation_value');
2290: fnd_message.raise_error;
2291: end if;
2292: end if;
2293: hr_utility.set_location ('ABR_RTMLTCD AP '||l_package,10);
2294: if l_abr.rt_mlt_cd in ('AP','APANDCVG') then
2295: p_actl_prem_id := l_abr.actl_prem_id;
2296: open c_enrt_prem(l_abr.actl_prem_id);
2297: fetch c_enrt_prem into l_actl_prem_value;

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

2295: p_actl_prem_id := l_abr.actl_prem_id;
2296: open c_enrt_prem(l_abr.actl_prem_id);
2297: fetch c_enrt_prem into l_actl_prem_value;
2298: close c_enrt_prem;
2299: hr_utility.set_location (' Dn c_enrt_prem ',120);
2300: --6314463
2301: l_force_prem_calc := 'N';
2302: open c_force_prem_calc(p_actl_prem_id);
2303: fetch c_force_prem_calc into l_force_prem_calc;

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

2308: if nvl(l_env.mode_cd,'~') <> 'D' then
2309: --
2310: if /*nvl(l_actl_prem_value,0) = 0 and */ p_calc_only_rt_val_flag
2311: or (l_force_prem_calc = 'Y' and p_called_from_ss) then
2312: hr_utility.set_location('premium re calculation ',551);
2313: ben_determine_actual_premium.g_computed_prem_val := null ;
2314: ben_determine_actual_premium.main
2315: (p_person_id => p_person_id,
2316: p_effective_date => l_cvg_eff_dt,

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

2325: p_ler_id => l_epe.ler_id,
2326: p_bnft_amt => l_coverage_value,
2327: p_business_group_id => l_epe.business_group_id );
2328:
2329: hr_utility.set_location('premium re calculation over ',551);
2330: hr_utility.set_location('Required actl_prem_id ' || l_abr.actl_prem_id,551);
2331: --
2332: -- 6330056 : Match the actl_prem_id for the evaluated
2333: -- premiums to get the correct required value.

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

2326: p_bnft_amt => l_coverage_value,
2327: p_business_group_id => l_epe.business_group_id );
2328:
2329: hr_utility.set_location('premium re calculation over ',551);
2330: hr_utility.set_location('Required actl_prem_id ' || l_abr.actl_prem_id,551);
2331: --
2332: -- 6330056 : Match the actl_prem_id for the evaluated
2333: -- premiums to get the correct required value.
2334: --

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

2336: --
2337: for idx IN ben_determine_actual_premium.g_computed_prem_tbl.FIRST..
2338: ben_determine_actual_premium.g_computed_prem_tbl.LAST loop
2339: --
2340: hr_utility.set_location('Calculated actl_prem_id ' ||
2341: ben_determine_actual_premium.g_computed_prem_tbl(idx).actl_prem_id,551);
2342: if (ben_determine_actual_premium.g_computed_prem_tbl(idx).actl_prem_id
2343: = l_abr.actl_prem_id) then
2344: --

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

2350: end loop;
2351: --
2352: end if;
2353: --
2354: hr_utility.set_location('l_actl_prem_value ' || l_actl_prem_value,100);
2355: --l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val;
2356: hr_utility.set_location('re calculation premium'||l_actl_prem_value,551);
2357: ben_determine_actual_premium.g_computed_prem_val := null;
2358: --

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

2352: end if;
2353: --
2354: hr_utility.set_location('l_actl_prem_value ' || l_actl_prem_value,100);
2355: --l_actl_prem_value := ben_determine_actual_premium.g_computed_prem_val;
2356: hr_utility.set_location('re calculation premium'||l_actl_prem_value,551);
2357: ben_determine_actual_premium.g_computed_prem_val := null;
2358: --
2359: end if;
2360:

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

2359: end if;
2360:
2361: if l_actl_prem_value is null then
2362: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2363: hr_utility.set_location (' FNDMS_RE 1 ',130);
2364: fnd_message.raise_error;
2365: end if;
2366: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2367: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);

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

2362: fnd_message.set_name('BEN','BEN_92747_ABR_APR_NULL');
2363: hr_utility.set_location (' FNDMS_RE 1 ',130);
2364: fnd_message.raise_error;
2365: end if;
2366: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2367: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);
2368: --
2369:
2370: if l_acty_ref_perd_cd = 'PWK' then

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

2363: hr_utility.set_location (' FNDMS_RE 1 ',130);
2364: fnd_message.raise_error;
2365: end if;
2366: hr_utility.set_location (' Convert prem rate (monthly) to acty_ref_perd',140);
2367: hr_utility.set_location (' l_acty_ref_perd_cd -> '||l_acty_ref_perd_cd,140);
2368: --
2369:
2370: if l_acty_ref_perd_cd = 'PWK' then
2371: l_actl_prem_value := (l_actl_prem_value * 12) / 52;

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

2393: else
2394: fnd_message.set_name('BEN','BEN_92412_UKN_ACTY_REF_PERD');
2395: fnd_message.set_token('PROC',l_package);
2396: fnd_message.set_token('VARIABLE',l_acty_ref_perd_cd);
2397: hr_utility.set_location (' FNDMS_RE 2 ',150);
2398: fnd_message.raise_error;
2399: end if;
2400: end if; --'D'
2401: end if;

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

2398: fnd_message.raise_error;
2399: end if;
2400: end if; --'D'
2401: end if;
2402: hr_utility.set_location ('ABR_RTMLTCD PRNT '||l_package,10);
2403: if l_abr.rt_mlt_cd in ('PRNT','PRNTANDCVG') then
2404: open c_abr2
2405: (c_effective_date => l_effective_date
2406: );

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

2422: fnd_message.set_token('VARIABLE','l_acty_base_rt_id');
2423: fnd_message.raise_error;
2424: end if;
2425: */
2426: hr_utility.set_location ('St BDABR_MN Sub '||l_package,10);
2427: if l_prnt_entr_val_at_enrt_flag = 'Y' then
2428: l_cal_val := null;
2429: else
2430: l_cal_val := p_cal_val;

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

2494: ,p_ordr_num => l_dummy_num
2495: ,p_iss_val => l_dummy_num
2496: );
2497: end if ;
2498: hr_utility.set_location ('Dn BDABR_MN Sub '||l_package,10);
2499: --bug :1555624 when the parent defiend as enter at enrollment then vlue
2500: -- may be returend as null or 0 this will be calcualtead in post enrollement
2501: -- process
2502: if l_prnt_rt_value is null

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

2511: end if;
2512:
2513: p_entr_val_at_enrt_flag := l_abr.entr_val_at_enrt_flag;
2514:
2515: hr_utility.set_location(' l_abr.rt_mlt_cd:'||l_abr.rt_mlt_cd,170);
2516: hr_utility.set_location(' cal val :'|| p_cal_val,170);
2517: --- bug 1480407
2518: -- when entr_val_at_enrt_flag and use_calc_acty_bs_rt_flag is true this calculation will be called
2519: -- after enrolement with the entered rate so the calulatiuon is to be done for incomming value

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

2512:
2513: p_entr_val_at_enrt_flag := l_abr.entr_val_at_enrt_flag;
2514:
2515: hr_utility.set_location(' l_abr.rt_mlt_cd:'||l_abr.rt_mlt_cd,170);
2516: hr_utility.set_location(' cal val :'|| p_cal_val,170);
2517: --- bug 1480407
2518: -- when entr_val_at_enrt_flag and use_calc_acty_bs_rt_flag is true this calculation will be called
2519: -- after enrolement with the entered rate so the calulatiuon is to be done for incomming value
2520: --- also validate the min max with the ammount entered , thi validation will be skipped in Rhi for

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

2562: End if;
2563:
2564:
2565: l_abr.val := p_cal_val;
2566: hr_utility.set_location(' incomming value ' || l_abr.val , 407);
2567: end if ;
2568:
2569: /* Bug 6015724 */
2570: l_prv_rt_strt_dt := null; -- 5748126

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

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

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

2628: l_prv_rt_strt_dt,
2629: l_prv_rt_end_dt;
2630: --
2631: if (g_debug) then
2632: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id
2633: ||':'|| l_prv_rt_strt_dt ||':'|| l_prv_rt_end_dt, 10);
2634: end if;
2635: --
2636: exit when (c_perfprv_2%notfound or l_prv_rt_strt_dt <= l_effective_date); -- 5898039: Changed from < to <=

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

2662: l_prv_rt_strt_dt,
2663: l_prv_rt_end_dt;
2664: --
2665: if (g_debug) then
2666: hr_utility.set_location(' l_prtt_rt_val_id: '|| l_prtt_rt_val_id
2667: ||':'|| l_prv_rt_strt_dt ||':'|| l_prv_rt_end_dt, 10);
2668: end if;
2669: --
2670: exit when c_prv%notfound or l_prv_rt_strt_dt <= l_effective_date; -- 5898039: Changed from < to <=

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

2671: end loop;
2672: close c_prv;
2673: --
2674: end if;
2675: hr_utility.set_location ('Cl c_prv '||l_package,10);
2676:
2677: p_prtt_rt_val_id := l_prtt_rt_val_id;
2678: /* End Bug 6015724 */
2679: --

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

2724: ,p_calculated_val => l_val);
2725:
2726: elsif l_abr.rt_mlt_cd = 'PRNT' then
2727:
2728: hr_utility.set_location(' abr value ' || l_abr.val , 407);
2729: hr_utility.set_location(' parent ' || l_prnt_rt_value , 407);
2730: benutils.rt_typ_calc
2731: (p_rt_typ_cd => l_abr.rt_typ_cd
2732: ,p_val => l_abr.val

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

2725:
2726: elsif l_abr.rt_mlt_cd = 'PRNT' then
2727:
2728: hr_utility.set_location(' abr value ' || l_abr.val , 407);
2729: hr_utility.set_location(' parent ' || l_prnt_rt_value , 407);
2730: benutils.rt_typ_calc
2731: (p_rt_typ_cd => l_abr.rt_typ_cd
2732: ,p_val => l_abr.val
2733: ,p_val_2 => l_prnt_rt_value

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

2734: ,p_calculated_val => l_val);
2735: if l_val is null then
2736: l_val := 0;
2737: end if;
2738: hr_utility.set_location(' result ' || l_val , 407);
2739: elsif l_abr.rt_mlt_cd = 'CLANDCVG' then
2740: benutils.rt_typ_calc
2741: (p_rt_typ_cd => l_abr.rt_typ_cd
2742: ,p_val => l_abr.val

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

2821: l_val := 0;
2822: end if;
2823:
2824: elsif l_abr.rt_mlt_cd = 'SAREC' then
2825: hr_utility.set_location ('BDR_ATP '||l_package||to_char(l_coverage_value),299);
2826: --ikasire -- not passing the p_complete_year_flag per bug 1650517
2827: /* Bug 6015724 */
2828: if l_rt_ovridn_flag = 'Y' and nvl(l_rt_ovridn_thru_dt, hr_api.g_eot) >= l_effective_date then
2829: --

Line 2879: hr_utility.set_location ('l_yr_strt_dt '||l_yr_strt_dt,291);

2875: );
2876: fetch c_pl_popl_yr_period_current into l_yr_strt_dt;
2877: close c_pl_popl_yr_period_current;
2878: --
2879: hr_utility.set_location ('l_yr_strt_dt '||l_yr_strt_dt,291);
2880: --
2881: open c_min_rt_strt_dt(l_epe.business_group_id);
2882: fetch c_min_rt_strt_dt into l_min_rt_strt_dt;
2883: close c_min_rt_strt_dt;

Line 2885: hr_utility.set_location ('l_min_rt_strt_dt '||l_min_rt_strt_dt,291);

2881: open c_min_rt_strt_dt(l_epe.business_group_id);
2882: fetch c_min_rt_strt_dt into l_min_rt_strt_dt;
2883: close c_min_rt_strt_dt;
2884: --
2885: hr_utility.set_location ('l_min_rt_strt_dt '||l_min_rt_strt_dt,291);
2886: --
2887: -- Calculate the rate value from the current rate start date instead
2888: -- of the plan year period start date.
2889: --

Line 2895: hr_utility.set_location ('l_complete_year_flag '||l_complete_year_flag,291);

2891: and l_prv_rt_strt_dt > l_yr_strt_dt) then
2892: l_complete_year_flag := 'N';
2893: end if;
2894: end if;
2895: hr_utility.set_location ('l_complete_year_flag '||l_complete_year_flag,291);
2896: -- end 14751721
2897: --
2898: l_val := ben_distribute_rates.annual_to_period
2899: (p_amount => p_ann_val,

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

2911: --
2912: --Bug 2149438
2913: l_val := round(l_val,4);
2914: --
2915: hr_utility.set_location ('BDR_ATP '||l_package,291);
2916: /**************************************/
2917: /* --Bug 2149438
2918: l_calc_val := ben_distribute_rates.period_to_annual
2919: (p_amount => l_val,

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

2951: end if; -- end if for if l_rt_ovridn_flag = 'Y'
2952: /* End Bug 6015724 */
2953: --
2954: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
2955: hr_utility.set_location ('BDR_ATP '||to_char(p_ann_val),222);
2956: hr_utility.set_location ('BDR_ATP '||to_char(l_cmcd_val),223);
2957: hr_utility.set_location ('BDR_ATP '||to_char(l_val),224);
2958: elsif l_abr.rt_mlt_cd = 'NSVU' then
2959: null; -- do nothing if 'no standard value used'

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

2952: /* End Bug 6015724 */
2953: --
2954: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
2955: hr_utility.set_location ('BDR_ATP '||to_char(p_ann_val),222);
2956: hr_utility.set_location ('BDR_ATP '||to_char(l_cmcd_val),223);
2957: hr_utility.set_location ('BDR_ATP '||to_char(l_val),224);
2958: elsif l_abr.rt_mlt_cd = 'NSVU' then
2959: null; -- do nothing if 'no standard value used'
2960: elsif l_abr.rt_mlt_cd = 'PRV' then

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

2953: --
2954: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
2955: hr_utility.set_location ('BDR_ATP '||to_char(p_ann_val),222);
2956: hr_utility.set_location ('BDR_ATP '||to_char(l_cmcd_val),223);
2957: hr_utility.set_location ('BDR_ATP '||to_char(l_val),224);
2958: elsif l_abr.rt_mlt_cd = 'NSVU' then
2959: null; -- do nothing if 'no standard value used'
2960: elsif l_abr.rt_mlt_cd = 'PRV' then
2961: --- for grade step progression

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

2958: elsif l_abr.rt_mlt_cd = 'NSVU' then
2959: null; -- do nothing if 'no standard value used'
2960: elsif l_abr.rt_mlt_cd = 'PRV' then
2961: --- for grade step progression
2962: hr_utility.set_location('GSP mulsti code PRV ',551) ;
2963: open c_pgr (l_abr.pay_rate_grade_rule_id , l_effective_date ) ;
2964: fetch c_pgr into l_val ;
2965: close c_pgr ;
2966: hr_utility.set_location('GSP value '|| l_val ,551) ;

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

2962: hr_utility.set_location('GSP mulsti code PRV ',551) ;
2963: open c_pgr (l_abr.pay_rate_grade_rule_id , l_effective_date ) ;
2964: fetch c_pgr into l_val ;
2965: close c_pgr ;
2966: hr_utility.set_location('GSP value '|| l_val ,551) ;
2967:
2968: else
2969: fnd_message.set_name('BEN','BEN_91342_UNKNOWN_CODE_1');
2970: fnd_message.set_token('PROC',l_package);

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

2970: fnd_message.set_token('PROC',l_package);
2971: fnd_message.set_token('CODE1',l_abr.rt_mlt_cd);
2972: fnd_message.raise_error;
2973: end if;
2974: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2975: --
2976: -- set some of the outputs
2977: --
2978: hr_utility.set_location(' set outputs ',180);

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

2974: hr_utility.set_location ('Dn ABR_RTMLTCDS '||l_package,10);
2975: --
2976: -- set some of the outputs
2977: --
2978: hr_utility.set_location(' set outputs ',180);
2979: p_tx_typ_cd := l_abr.tx_typ_cd;
2980: p_acty_typ_cd := l_abr.acty_typ_cd;
2981: p_nnmntry_uom := l_abr.nnmntry_uom;
2982: p_dsply_on_enrt_flag := l_abr.dsply_on_enrt_flag;

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

2986: p_mn_elcn_val := l_abr.mn_elcn_val;
2987: p_incrmt_elcn_val := l_abr.incrmt_elcn_val;
2988: p_ordr_num := l_abr.ordr_num;
2989:
2990: hr_utility.set_location('p_ordr_num ='||p_ordr_num,181);
2991:
2992: -- get default value from the right place depending on dflt code
2993: /*
2994: if l_dflt_enrt_cd in ('NSDCS','NNCS') then

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

3025:
3026: --bug : 1433393 Value us validated befoe calcualting the
3027: --variable rate riable rate with value us validated agains the ulitmate values of
3028: -- VAPRO
3029: hr_utility.set_location ('Lim Chk '||l_package,10);
3030: benutils.limit_checks
3031: (p_upr_lmt_val => l_abr.upr_lmt_val,
3032: p_lwr_lmt_val => l_abr.lwr_lmt_val,
3033: p_upr_lmt_calc_rl => l_abr.upr_lmt_calc_rl,

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

3065: else
3066: --Bug 2192102 if the rate is of Flex credit letus get the associated enrt bnft id
3067: if l_enrt_bnft_id is null and l_abr.rt_usg_cd = 'FLXCR' then
3068: --
3069: hr_utility.set_location (' Before FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
3070: --
3071: open c_enb_fc ;
3072: fetch c_enb_fc into l_enrt_bnft_id ;
3073: close c_enb_fc;

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

3071: open c_enb_fc ;
3072: fetch c_enb_fc into l_enrt_bnft_id ;
3073: close c_enb_fc;
3074: --
3075: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
3076: end if;
3077: --
3078: hr_utility.set_location ('BDVR_MN '||l_package,10);
3079: ben_determine_variable_rates.main

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

3074: --
3075: hr_utility.set_location (' After FLXCR l_enrt_bnft_id '||l_enrt_bnft_id, 19);
3076: end if;
3077: --
3078: hr_utility.set_location ('BDVR_MN '||l_package,10);
3079: ben_determine_variable_rates.main
3080: (p_currepe_row => p_currepe_row
3081: ,p_per_row => p_per_row
3082: ,p_asg_row => p_asg_row

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

3114: ,p_ann_mx_elcn_val => l_vr_ann_mx_elcn_val
3115: );
3116:
3117: l_vapro_entr_val_at_enrt_flag := p_entr_val_at_enrt_flag; --11065081
3118: hr_utility.set_location(' after ben_determine_variable_rates ',200);
3119: --if l_val is null then
3120: -- l_vr_trtmt_cd := 'RPLC';
3121: --end if;
3122: -- Bug 8943410:Moved this code after the variable rate is treated on std rate

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

3135: l_val := l_rounded_value;
3136: end if;*/
3137: -- End of change for Bug 8943410
3138:
3139: hr_utility.set_location('rounded value rate : ' ||to_char(l_val) ,954);
3140: hr_utility.set_location('variable rate : ' ||l_vr_val ,954);
3141: hr_utility.set_location('treatement : ' ||l_vr_trtmt_cd ,954);
3142: --
3143: -- Tilak Bug 2438506 : if the abr have null values then treat as 1 for

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

3136: end if;*/
3137: -- End of change for Bug 8943410
3138:
3139: hr_utility.set_location('rounded value rate : ' ||to_char(l_val) ,954);
3140: hr_utility.set_location('variable rate : ' ||l_vr_val ,954);
3141: hr_utility.set_location('treatement : ' ||l_vr_trtmt_cd ,954);
3142: --
3143: -- Tilak Bug 2438506 : if the abr have null values then treat as 1 for
3144: -- multiply

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

3137: -- End of change for Bug 8943410
3138:
3139: hr_utility.set_location('rounded value rate : ' ||to_char(l_val) ,954);
3140: hr_utility.set_location('variable rate : ' ||l_vr_val ,954);
3141: hr_utility.set_location('treatement : ' ||l_vr_trtmt_cd ,954);
3142: --
3143: -- Tilak Bug 2438506 : if the abr have null values then treat as 1 for
3144: -- multiply
3145: -- as 0 for add or subtract.

Line 3178: hr_utility.set_location('l_val2 : ' ||l_val ,954);

3174: l_val := l_rounded_value;
3175: end if;
3176: -- End of change for Bug 8943410
3177:
3178: hr_utility.set_location('l_val2 : ' ||l_val ,954);
3179:
3180: if l_vr_trtmt_cd is not null then
3181: --- Tilak : this code is not validating whether the enter at enrollemt is defined
3182: --- in either side ,(rate,VAPRO), this just work on the treatment code

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

3273: end if ;
3274: --
3275: l_abr.dflt_val := nvl(l_vr_dflt_elcn_val,l_abr.dflt_val);
3276: --
3277: hr_utility.set_location(' l_vr_dflt_elcn_val ' ||l_abr.dflt_val , 199);
3278:
3279: hr_utility.set_location(' mn_elcn_va ' || l_vr_mn_elcn_val , 199);
3280: p_val := l_val;
3281: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);

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

3275: l_abr.dflt_val := nvl(l_vr_dflt_elcn_val,l_abr.dflt_val);
3276: --
3277: hr_utility.set_location(' l_vr_dflt_elcn_val ' ||l_abr.dflt_val , 199);
3278:
3279: hr_utility.set_location(' mn_elcn_va ' || l_vr_mn_elcn_val , 199);
3280: p_val := l_val;
3281: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3282: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3283: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then

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

3277: hr_utility.set_location(' l_vr_dflt_elcn_val ' ||l_abr.dflt_val , 199);
3278:
3279: hr_utility.set_location(' mn_elcn_va ' || l_vr_mn_elcn_val , 199);
3280: p_val := l_val;
3281: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3282: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3283: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3284: hr_utility.set_location(' calling ultmate check rate ' ,393);
3285: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);

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

3280: p_val := l_val;
3281: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3282: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3283: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3284: hr_utility.set_location(' calling ultmate check rate ' ,393);
3285: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);
3286: hr_utility.set_location('ammount '|| p_val ,393);
3287:
3288: benutils.limit_checks

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

3281: hr_utility.set_location('valiable and rate : ' ||to_char(l_val) ,954);
3282: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3283: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3284: hr_utility.set_location(' calling ultmate check rate ' ,393);
3285: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);
3286: hr_utility.set_location('ammount '|| p_val ,393);
3287:
3288: benutils.limit_checks
3289: (p_upr_lmt_val => l_ultmt_upr_lmt,

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

3282: if l_ultmt_upr_lmt is not null or l_ultmt_lwr_lmt is not null
3283: OR l_ultmt_upr_lmt_calc_rl is not null or l_ultmt_lwr_lmt_calc_rl is not null then
3284: hr_utility.set_location(' calling ultmate check rate ' ,393);
3285: hr_utility.set_location('upper '|| l_ultmt_upr_lmt ||' Lower' || l_ultmt_lwr_lmt,393);
3286: hr_utility.set_location('ammount '|| p_val ,393);
3287:
3288: benutils.limit_checks
3289: (p_upr_lmt_val => l_ultmt_upr_lmt,
3290: p_lwr_lmt_val => l_ultmt_lwr_lmt,

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

3302: p_opt_id => l_opt.opt_id,
3303: p_ler_id => l_epe.ler_id,
3304: p_state => l_state.region_2,
3305: p_val => p_val); -- l_rounded_value);
3306: hr_utility.set_location('ammount '|| p_val ,393);
3307:
3308: end if ;
3309: --
3310: end if;

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

3371: fetch c_current_elig into l_prtn_strt_dt;
3372: close c_current_elig;
3373: --
3374: end if;
3375: hr_utility.set_location ('BDD_RACD '||l_package,10);
3376: ben_determine_date.rate_and_coverage_dates
3377: (p_cache_mode => TRUE
3378: ,p_par_ptip_id => l_epe.ptip_id
3379: ,p_par_plip_id => l_epe.plip_id

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

3409: ,p_rt_end_dt => l_dummy_date
3410: ,p_rt_end_dt_cd => l_dummy_char
3411: ,p_rt_end_dt_rl => l_dummy_num
3412: );
3413: hr_utility.set_location ('Dn BDD_RACD '||l_package,10);
3414: p_rt_strt_dt := l_rt_strt_dt;
3415: p_rt_strt_dt_cd := l_rt_strt_dt_cd;
3416: p_rt_strt_dt_rl := l_rt_strt_dt_rl;
3417: end if;

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

3458: p_cmcd_mx_elcn_val := nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val);
3459: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
3460:
3461: else
3462: hr_utility.set_location ('BDR_PTA '||l_package,10);
3463: hr_utility.set_location (' l_abr.dflt_val '||l_abr.dflt_val,22);
3464: hr_utility.set_location (' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
3465: --
3466: --Bug 2445318 We need to see whether to assign the l_abr.dflt_val to

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

3459: p_cmcd_acty_ref_perd_cd := l_enrt_info_rt_freq_cd;
3460:
3461: else
3462: hr_utility.set_location ('BDR_PTA '||l_package,10);
3463: hr_utility.set_location (' l_abr.dflt_val '||l_abr.dflt_val,22);
3464: hr_utility.set_location (' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
3465: --
3466: --Bug 2445318 We need to see whether to assign the l_abr.dflt_val to
3467: -- p_ann_dflt_val or p_dflt_val

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

3460:
3461: else
3462: hr_utility.set_location ('BDR_PTA '||l_package,10);
3463: hr_utility.set_location (' l_abr.dflt_val '||l_abr.dflt_val,22);
3464: hr_utility.set_location (' p_elig_per_elctbl_chc_id '||p_elig_per_elctbl_chc_id,22);
3465: --
3466: --Bug 2445318 We need to see whether to assign the l_abr.dflt_val to
3467: -- p_ann_dflt_val or p_dflt_val
3468: --

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

3518: end if;
3519: end if;
3520: --
3521: -- end if; -- 'D' Mode
3522: hr_utility.set_location (' p_dflt_val '||p_dflt_val,23);
3523: hr_utility.set_location (' p_ann_dflt_val '||p_ann_dflt_val,23);
3524: hr_utility.set_location (' l_ann_dflt_val '||l_ann_dflt_val,22);
3525: --GEVITY
3526: IF l_abr.rate_periodization_rl IS NOT NULL THEN

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

3519: end if;
3520: --
3521: -- end if; -- 'D' Mode
3522: hr_utility.set_location (' p_dflt_val '||p_dflt_val,23);
3523: hr_utility.set_location (' p_ann_dflt_val '||p_ann_dflt_val,23);
3524: hr_utility.set_location (' l_ann_dflt_val '||l_ann_dflt_val,22);
3525: --GEVITY
3526: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3527: --

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

3520: --
3521: -- end if; -- 'D' Mode
3522: hr_utility.set_location (' p_dflt_val '||p_dflt_val,23);
3523: hr_utility.set_location (' p_ann_dflt_val '||p_ann_dflt_val,23);
3524: hr_utility.set_location (' l_ann_dflt_val '||l_ann_dflt_val,22);
3525: --GEVITY
3526: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3527: --
3528: l_dfnd_dummy := p_val ;

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

3554: p_effective_date => l_effective_date,
3555: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
3556: p_complete_year_flag => 'Y',
3557: p_payroll_id => l_payroll_id);
3558: hr_utility.set_location ('BDR_PTA '||l_package,290);
3559: --
3560: l_calc_val := ben_distribute_rates.period_to_annual
3561: (p_amount => p_val,
3562: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,

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

3622: end if;
3623: --
3624: p_ann_mn_elcn_val := nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val);
3625: p_ann_mx_elcn_val := nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val);
3626: hr_utility.set_location ('BDR_ATP '||l_package,290);
3627: hr_utility.set_location ('Dn BDR_ATP '||l_package,290);
3628: --
3629: end if;
3630: --

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

3623: --
3624: p_ann_mn_elcn_val := nvl(l_vr_ann_mn_elcn_val,l_abr.ann_mn_elcn_val);
3625: p_ann_mx_elcn_val := nvl(l_vr_ann_mx_elcn_val,l_abr.ann_mx_elcn_val);
3626: hr_utility.set_location ('BDR_ATP '||l_package,290);
3627: hr_utility.set_location ('Dn BDR_ATP '||l_package,290);
3628: --
3629: end if;
3630: --
3631: -- bug fix 2569884 - Communicated Min and Max values are needed for self service

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

3802:
3803: -- hmani
3804:
3805: if l_abr.dflt_val is not null then
3806: hr_utility.set_location ('HMANI '||l_abr.dflt_val,290.3);
3807: --GEVITY
3808: IF l_abr.rate_periodization_rl IS NOT NULL THEN
3809: --
3810: --null;

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

3832: else
3833: l_element_type_id := null;
3834: end if;
3835: --
3836: hr_utility.set_location ('HMANI Me here'||l_cmcd_dflt_val,290.3);
3837: l_cmcd_dflt_val := ben_distribute_rates.annual_to_period
3838: (p_amount => p_ann_dflt_val,
3839: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
3840: p_acty_ref_perd_cd => l_enrt_info_rt_freq_cd,

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

3849: --7154229
3850: if(p_cmcd_val is null) then
3851: p_cmcd_val := l_cmcd_dflt_val;
3852: end if;
3853: hr_utility.set_location ('HMANI '||l_cmcd_dflt_val,290.3);
3854: END IF; --GEVITY
3855: end if;
3856:
3857: -- End of hmani

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

4015: p_lf_evt_ocrd_dt => p_lf_evt_ocrd_dt,
4016: p_complete_year_flag => 'Y',
4017: p_payroll_id => l_payroll_id,
4018: p_element_type_id => l_element_type_id);
4019: hr_utility.set_location ('HMANI '||l_cmcd_dflt_val,290.678);
4020: --
4021: END IF; --GEVITY
4022: end if;
4023:

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

4045: -- has been chosen and the l_cmcd_dflt val has been returned in the p_iss_val
4046: -- We here check that the mode is not CWB since CWB only uses iss_val
4047:
4048: ben_env_object.get(p_rec => l_env);
4049: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);
4050:
4051: if l_env.mode_cd <> 'W' and p_iss_val is null then
4052: p_iss_val := l_cmcd_dflt_val ;
4053: end if;

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

4110: --
4111: end if;
4112: -- Bug 4637525
4113: --
4114: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
4115: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
4116: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
4117: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
4118: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);

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

4111: end if;
4112: -- Bug 4637525
4113: --
4114: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
4115: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
4116: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
4117: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
4118: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
4119: --

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

4112: -- Bug 4637525
4113: --
4114: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
4115: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
4116: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
4117: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
4118: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
4119: --
4120: if nvl(l_env.mode_cd,'~') = 'W' and

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

4113: --
4114: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
4115: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
4116: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
4117: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
4118: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
4119: --
4120: if nvl(l_env.mode_cd,'~') = 'W' and
4121: l_abr.entr_val_at_enrt_flag = 'Y' and

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

4114: hr_utility.set_location('ACE l_abr.rt_mlt_cd = ' || l_abr.rt_mlt_cd , 9898);
4115: hr_utility.set_location('ACE l_env.mode_cd = ' || l_env.mode_cd , 9898);
4116: hr_utility.set_location('ACE l_abr.entr_val_at_enrt_flag = ' || l_abr.entr_val_at_enrt_flag , 9898);
4117: hr_utility.set_location('ACE l_abr.acty_typ_cd = ' || l_abr.acty_typ_cd , 9898);
4118: hr_utility.set_location('ACE l_compensation_value = ' || l_compensation_value , 9898);
4119: --
4120: if nvl(l_env.mode_cd,'~') = 'W' and
4121: l_abr.entr_val_at_enrt_flag = 'Y' and
4122: l_abr.rt_mlt_cd in ('CL' ) and

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

4130: ,p_val => p_mn_elcn_val
4131: ,p_val_2 => l_compensation_value
4132: ,p_calculated_val => l_cwb_mn_elcn_val);
4133: --
4134: hr_utility.set_location('l_cwb_mn_elcn_val is '||l_cwb_mn_elcn_val,951);
4135: --
4136: --
4137: benutils.rt_typ_calc
4138: (p_rt_typ_cd => l_abr.rt_typ_cd

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

4139: ,p_val => p_mx_elcn_val
4140: ,p_val_2 => l_compensation_value
4141: ,p_calculated_val => l_cwb_mx_elcn_val);
4142: --
4143: hr_utility.set_location('l_cwb_mx_elcn_val is '|| l_cwb_mx_elcn_val,951);
4144: --
4145: -- 5371364 : Do not Operate (i.e multiply/divide..) the Increment Value.
4146: l_cwb_incrmt_elcn_val := p_incrmt_elcn_val;
4147: /*

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

4152: ,p_calculated_val => l_cwb_incrmt_elcn_val);
4153: */
4154: --
4155:
4156: hr_utility.set_location('l_cwb_incrmt_elcn_val is '|| l_cwb_incrmt_elcn_val,951);
4157: --
4158: benutils.rt_typ_calc
4159: (p_rt_typ_cd => l_abr.rt_typ_cd
4160: ,p_val => l_vr_dflt_elcn_val

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

4160: ,p_val => l_vr_dflt_elcn_val
4161: ,p_val_2 => l_compensation_value
4162: ,p_calculated_val => l_cwb_dflt_val);
4163: --
4164: hr_utility.set_location('l_cwb_dflt_val is '|| l_cwb_dflt_val,951);
4165: --
4166: --
4167: -- Round the values. Bug 4873847.
4168: --

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

4203: p_incrmt_elcn_val := nvl(l_cwb_incrmt_elcn_val,p_incrmt_elcn_val);
4204: l_vr_dflt_elcn_val := nvl(l_cwb_dflt_val, l_vr_dflt_elcn_val );
4205: p_dflt_val := l_vr_dflt_elcn_val;
4206: --
4207: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4208: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4209: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4210: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4211: --

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

4204: l_vr_dflt_elcn_val := nvl(l_cwb_dflt_val, l_vr_dflt_elcn_val );
4205: p_dflt_val := l_vr_dflt_elcn_val;
4206: --
4207: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4208: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4209: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4210: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4211: --
4212: end if;

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

4205: p_dflt_val := l_vr_dflt_elcn_val;
4206: --
4207: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4208: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4209: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4210: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4211: --
4212: end if;
4213: --

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

4206: --
4207: hr_utility.set_location('ACE p_mn_elcn_val = ' || p_mn_elcn_val , 9898);
4208: hr_utility.set_location('ACE p_mx_elcn_val = ' || p_mx_elcn_val , 9898);
4209: hr_utility.set_location('ACE p_incrmt_elcn_val = ' || p_incrmt_elcn_val , 9898);
4210: hr_utility.set_location('ACE l_vr_dflt_elcn_val = ' || l_vr_dflt_elcn_val , 9898);
4211: --
4212: end if;
4213: --
4214: -- Bug 4637525

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

4229: p_val := l_rt_val;
4230: end if;
4231: */
4232:
4233: hr_utility.set_location ('Leaving '||l_package,999);
4234: exception
4235: --
4236: when others then
4237: --

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

4362: l_trace_on := false;
4363: end if;
4364: --
4365: if l_trace_on then
4366: hr_utility.trace_on(null,'BENACTBR');
4367: end if;
4368: --
4369: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4370: hr_utility.set_location ('Entering '||l_package,10);

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

4365: if l_trace_on then
4366: hr_utility.trace_on(null,'BENACTBR');
4367: end if;
4368: --
4369: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4370: hr_utility.set_location ('Entering '||l_package,10);
4371: --
4372: ben_env_object.init(p_business_group_id => p_business_group_id,
4373: p_effective_date => p_effective_date,

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

4366: hr_utility.trace_on(null,'BENACTBR');
4367: end if;
4368: --
4369: hr_utility.set_location('l_trace_param : '|| l_trace_param, 5);
4370: hr_utility.set_location ('Entering '||l_package,10);
4371: --
4372: ben_env_object.init(p_business_group_id => p_business_group_id,
4373: p_effective_date => p_effective_date,
4374: p_thread_id => 1,

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

4440: ,p_pp_in_yr_used_num => l_dummy_num
4441: ,p_ordr_num => l_dummy_num
4442: ,p_iss_val => l_dummy_num);
4443:
4444: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4445: hr_utility.set_location (' p_val: '||p_val,900);
4446: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4447: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4448:

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

4441: ,p_ordr_num => l_dummy_num
4442: ,p_iss_val => l_dummy_num);
4443:
4444: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4445: hr_utility.set_location (' p_val: '||p_val,900);
4446: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4447: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4448:
4449: --

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

4442: ,p_iss_val => l_dummy_num);
4443:
4444: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4445: hr_utility.set_location (' p_val: '||p_val,900);
4446: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4447: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4448:
4449: --
4450: if p_enrt_bnft_id is not null then

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

4443:
4444: hr_utility.set_location ('Output Values From ben_determine_activity_base_rt.main '||l_package,900);
4445: hr_utility.set_location (' p_val: '||p_val,900);
4446: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4447: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4448:
4449: --
4450: if p_enrt_bnft_id is not null then
4451: --

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

4516: end if;
4517: --
4518: end if;
4519:
4520: hr_utility.set_location ('Output Values: '||l_package,900);
4521: hr_utility.set_location (' p_val: '||p_val,900);
4522: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4523: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4524:

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

4517: --
4518: end if;
4519:
4520: hr_utility.set_location ('Output Values: '||l_package,900);
4521: hr_utility.set_location (' p_val: '||p_val,900);
4522: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4523: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4524:
4525: hr_utility.set_location ('Leaving '|| l_package,999);

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

4518: end if;
4519:
4520: hr_utility.set_location ('Output Values: '||l_package,900);
4521: hr_utility.set_location (' p_val: '||p_val,900);
4522: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4523: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4524:
4525: hr_utility.set_location ('Leaving '|| l_package,999);
4526: --

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

4519:
4520: hr_utility.set_location ('Output Values: '||l_package,900);
4521: hr_utility.set_location (' p_val: '||p_val,900);
4522: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4523: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4524:
4525: hr_utility.set_location ('Leaving '|| l_package,999);
4526: --
4527: if l_trace_on then

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

4521: hr_utility.set_location (' p_val: '||p_val,900);
4522: hr_utility.set_location (' p_ann_val: '||p_ann_val,900);
4523: hr_utility.set_location (' p_cmcd_val: '||p_cmcd_val,900);
4524:
4525: hr_utility.set_location ('Leaving '|| l_package,999);
4526: --
4527: if l_trace_on then
4528: hr_utility.trace_off;
4529: l_trace_param := null;

Line 4528: hr_utility.trace_off;

4524:
4525: hr_utility.set_location ('Leaving '|| l_package,999);
4526: --
4527: if l_trace_on then
4528: hr_utility.trace_off;
4529: l_trace_param := null;
4530: l_trace_on := false;
4531: end if;
4532:

Line 4542: hr_utility.trace_off;

4538: p_ann_val := null;
4539: p_cmcd_val := null;
4540: fnd_msg_pub.add;
4541: if l_trace_on then
4542: hr_utility.trace_off;
4543: l_trace_on := false;
4544: l_trace_param := null;
4545: end if;
4546: end main_w;