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

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_person_info_pkg.'; --Global package name
9: g_debug boolean := hr_utility.debug_enabled;
10: g_fte_factor VARCHAR2(240) := fnd_profile.VALUE('BEN_CWB_FTE_FACTOR');
11: g_salary_survey_id number := null; --Change to right value when implementing.
12: --
13: cursor c_sal_info(v_assignment_id number,

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

85:
86: begin
87: --
88: if g_debug then
89: hr_utility.set_location('Entering:'|| l_proc, 10);
90: end if;
91: --
92: open c_sal_info(p_assignment_id, p_effective_date);
93: fetch c_sal_info into l_sal_info;

Line 97: hr_utility.set_location(l_proc, 99);

93: fetch c_sal_info into l_sal_info;
94: close c_sal_info;
95: --
96: if g_debug then
97: hr_utility.set_location(l_proc, 99);
98: end if;
99: --
100: return l_sal_info;
101: end get_salary_info;

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

114: --
115: begin
116: --
117: if g_debug then
118: hr_utility.set_location('Entering:'|| l_proc, 10);
119: end if;
120: --
121: open c_survey_info(p_job_id, p_effective_date);
122: fetch c_survey_info into l_survey_info;

Line 126: hr_utility.set_location(l_proc, 99);

122: fetch c_survey_info into l_survey_info;
123: close c_survey_info;
124: --
125: if g_debug then
126: hr_utility.set_location(l_proc, 99);
127: end if;
128: --
129: return l_survey_info;
130: end get_survey_info;

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

145: --
146: begin
147: --
148: if g_debug then
149: hr_utility.set_location('Entering:'|| l_proc, 10);
150: end if;
151: --
152: select trunc(sum(months_between(
153: decode(asgjob.effective_end_date,

Line 165: hr_utility.set_location(l_proc, 99);

161: and asgjob.effective_start_date <= p_asg_effective_start_date
162: and asgjob.assignment_type in ('C','E'); -- bug 13061653
163: --
164: if g_debug then
165: hr_utility.set_location(l_proc, 99);
166: end if;
167: --
168: return l_years_in_job;
169: end;

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

184: --
185: begin
186: --
187: if g_debug then
188: hr_utility.set_location('Entering:'|| l_proc, 10);
189: end if;
190: --
191: select trunc(sum(months_between(
192: decode(asgpos.effective_end_date,

Line 203: hr_utility.set_location(l_proc, 99);

199: and asgpos.position_id = p_position_id
200: and asgpos.effective_start_date <= p_asg_effective_start_date;
201: --
202: if g_debug then
203: hr_utility.set_location(l_proc, 99);
204: end if;
205: --
206: return l_years_in_position;
207: end;

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

222: --
223: begin
224: --
225: if g_debug then
226: hr_utility.set_location('Entering:'|| l_proc, 10);
227: end if;
228: --
229: select trunc(sum(months_between(
230: decode(asggrd.effective_end_date,

Line 242: hr_utility.set_location(l_proc, 99);

238: and asggrd.effective_start_date <= p_asg_effective_start_date
239: and asggrd.assignment_type <> 'A'; --9060804
240: --
241: if g_debug then
242: hr_utility.set_location(l_proc, 99);
243: end if;
244: --
245: return l_years_in_grade;
246: end; -- get_years_in_grade

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

259: --
260: begin
261: --
262: if g_debug then
263: hr_utility.set_location('Entering:'|| l_proc, 10);
264: end if;
265: --
266: select fnd_number.canonical_to_number(minimum) into l_grd_min_val
267: from pay_grade_rules_f grdrule

Line 274: hr_utility.set_location(l_proc, 99);

270: and p_effective_date between grdrule.effective_start_date
271: and grdrule.effective_end_date;
272: --
273: if g_debug then
274: hr_utility.set_location(l_proc, 99);
275: end if;
276: --
277: return l_grd_min_val;
278: end; -- get_grd_min_val

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

292: --
293: begin
294: --
295: if g_debug then
296: hr_utility.set_location('Entering:'|| l_proc, 10);
297: end if;
298: --
299: select fnd_number.canonical_to_number(maximum) into l_grd_max_val
300: from pay_grade_rules_f grdrule

Line 307: hr_utility.set_location(l_proc, 99);

303: and p_effective_date between grdrule.effective_start_date
304: and grdrule.effective_end_date;
305: --
306: if g_debug then
307: hr_utility.set_location(l_proc, 99);
308: end if;
309: --
310: return l_grd_max_val;
311: end; -- get_grd_max_val

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

325: --
326: begin
327: --
328: if g_debug then
329: hr_utility.set_location('Entering:'|| l_proc, 10);
330: end if;
331: --
332: select fnd_number.canonical_to_number(mid_value) into l_grd_mid_point
333: from pay_grade_rules_f grdrule

Line 340: hr_utility.set_location(l_proc, 99);

336: and p_effective_date between grdrule.effective_start_date
337: and grdrule.effective_end_date;
338: --
339: if g_debug then
340: hr_utility.set_location(l_proc, 99);
341: end if;
342: --
343: return l_grd_mid_point;
344: end; -- get_grd_mid_point

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

790: 'refresh_person_info';
791: ben_manage_cwb_life_events.g_error_log_rec.step_number := 211;
792: --
793: if g_debug then
794: hr_utility.set_location('Entering:'|| l_proc, 10);
795: end if;
796: --
797: -- get the performance_rating_type from pl_dsgn. This value is same
798: -- for all plans and oipls in a group plan.

Line 837: hr_utility.set_location(l_proc, 20);

833: l_from_benmngle := 'N';
834: end if;
835: --
836: if g_debug then
837: hr_utility.set_location(l_proc, 20);
838: end if;
839: --vkodedal get the salary suvey id from EIT setup
840:
841: open c_survey_id(l_group_pl_id);

Line 846: hr_utility.set_location('c_survey_id:'|| g_salary_survey_id, 15);

842: fetch c_survey_id into g_salary_survey_id;
843: close c_survey_id;
844: --
845: if g_debug then
846: hr_utility.set_location('c_survey_id:'|| g_salary_survey_id, 15);
847: end if;
848: --
849: --ER:8369634
850: --Bug fix 9760967

Line 855: hr_utility.set_location('show_appraisals_n_days:'|| l_appraisal_n_days, 15);

851: for l_grp_plan_extra_info in csr_grp_plan_extra_info(l_group_pl_id,l_lf_evt_ocrd_dt) loop
852: l_appraisal_n_days := to_number(l_grp_plan_extra_info.show_appraisals_n_days);
853: end loop;
854: if g_debug then
855: hr_utility.set_location('show_appraisals_n_days:'|| l_appraisal_n_days, 15);
856: end if;
857:
858: -- Open the cursor and update the details in ben_cwb_person_info
859: -- It always should return only one row, but using the for to avoid

Line 1104: hr_utility.set_location(l_proc, 30);

1100: ,appraisal_id = perinfo_rec.appraisal_id
1101: where group_per_in_ler_id = perinfo_rec.group_per_in_ler_id;
1102: --
1103: if g_debug then
1104: hr_utility.set_location(l_proc, 30);
1105: end if;
1106: --
1107: else
1108: -- The record does not exist. So insert the new record

Line 1463: hr_utility.set_location(l_proc, 40);

1459: ,perinfo_rec.appraisal_id
1460: );
1461: --
1462: if g_debug then
1463: hr_utility.set_location(l_proc, 40);
1464: end if;
1465: --
1466: -- ************ audit changes ****************** --
1467: ben_cwb_audit_api.create_per_record

Line 1493: hr_utility.set_location(l_proc, 50);

1489: if p_called_from_benmngle and not(l_rec_modified) and
1490: l_cpi_effective_date is null then
1491: --
1492: if g_debug then
1493: hr_utility.set_location(l_proc, 50);
1494: end if;
1495: --
1496: if l_assignment_id is not null then
1497: insert into ben_cwb_person_info

Line 1521: hr_utility.set_location(l_proc, 60);

1517: ben_cwb_audit_api.create_per_record
1518: (p_per_in_ler_id => p_group_per_in_ler_id);
1519: -- ********************************************* --
1520: if g_debug then
1521: hr_utility.set_location(l_proc, 60);
1522: end if;
1523: --
1524: end if;
1525: --

Line 1529: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1525: --
1526: end if;
1527: --
1528: if g_debug then
1529: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1530: end if;
1531: --
1532: end; -- of refresh_person_info
1533: --

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

1551: --
1552: begin
1553: --
1554: if g_debug then
1555: hr_utility.set_location('Entering:'|| l_proc, 10);
1556: end if;
1557: --
1558: -- for each record in csr_pil
1559: for pil in csr_pil loop

Line 1562: hr_utility.set_location(l_proc, 20);

1558: -- for each record in csr_pil
1559: for pil in csr_pil loop
1560: --
1561: if g_debug then
1562: hr_utility.set_location(l_proc, 20);
1563: end if;
1564: --
1565: refresh_person_info(p_group_per_in_ler_id => pil.per_in_ler_id
1566: ,p_effective_date => p_effective_date);

Line 1577: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1573: --
1574: end loop;
1575: --
1576: if g_debug then
1577: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1578: end if;
1579: --
1580: end;
1581: --

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

1596: --
1597: begin
1598: --
1599: if g_debug then
1600: hr_utility.set_location('Entering:'|| l_proc, 10);
1601: end if;
1602: --
1603: if p_salary is not null then
1604: if p_salary < p_min then

Line 1620: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1616: end if;
1617: end if;
1618: --
1619: if g_debug then
1620: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1621: end if;
1622: --
1623: return l_return_value;
1624: --

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

1642: --
1643: begin
1644: --
1645: if g_debug then
1646: hr_utility.set_location('Entering:'|| l_proc, 10);
1647: end if;
1648: --
1649: if p_salary is not null and l_step is not null then
1650: if p_salary < p_min then

Line 1668: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1664: end if;
1665: end if;
1666: --
1667: if g_debug then
1668: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1669: end if;
1670: --
1671: return l_return_value;
1672: --

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

1690: --
1691: begin
1692: --
1693: if g_debug then
1694: hr_utility.set_location('Entering:'|| l_proc, 10);
1695: end if;
1696: --
1697: if p_salary is not null and l_step is not null then
1698: if p_salary < p_min then

Line 1726: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1722: end if;
1723: end if;
1724: --
1725: if g_debug then
1726: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1727: end if;
1728: --
1729: return l_return_value;
1730: --

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

1751: --
1752: begin
1753: --
1754: if g_debug then
1755: hr_utility.set_location('Entering:'|| l_proc, 10);
1756: end if;
1757: --
1758: if l_range = 0 then
1759: return l_return_val;

Line 1765: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1761: --
1762: l_return_val := round((l_min_to_sal / l_range * 100),1);
1763: --
1764: if g_debug then
1765: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1766: end if;
1767: --
1768: return l_return_val;
1769: --

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

1782: --
1783: begin
1784: --
1785: if g_debug then
1786: hr_utility.set_location('Entering:'|| l_proc, 10);
1787: end if;
1788: --
1789: if p_salary is null or p_mid is null or p_mid <= 0 then
1790: return null;

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

1811: --
1812: begin
1813: --
1814: if g_debug then
1815: hr_utility.set_location('Entering:'|| l_proc, 10);
1816: end if;
1817: --
1818: select pl.effective_date into l_effective_date
1819: from ben_cwb_pl_dsgn pl

Line 1837: hr_utility.set_location(l_proc, 30);

1833: l_effective_date := null;
1834: end if;
1835: --
1836: if g_debug then
1837: hr_utility.set_location(l_proc, 30);
1838: end if;
1839: --
1840: -- call refresh_person_info
1841: refresh_person_info(p_group_per_in_ler_id => p_group_per_in_ler_id

Line 1845: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1841: refresh_person_info(p_group_per_in_ler_id => p_group_per_in_ler_id
1842: ,p_effective_date => l_effective_date);
1843: --
1844: if g_debug then
1845: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1846: end if;
1847: --
1848: end;
1849: --

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

1872: --
1873: begin
1874: --
1875: if g_debug then
1876: hr_utility.set_location('Entering:'|| l_proc, 10);
1877: end if;
1878: --
1879: open csr_currency;
1880: fetch csr_currency into l_currency;

Line 1884: hr_utility.set_location(' Leaving:'|| l_proc, 99);

1880: fetch csr_currency into l_currency;
1881: close csr_currency;
1882: --
1883: if g_debug then
1884: hr_utility.set_location(' Leaving:'|| l_proc, 99);
1885: end if;
1886: --
1887: return l_currency;
1888: end;