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

Line 7: g_debug boolean := hr_utility.debug_enabled;

3: --
4: -- Package Variables
5: --
6: g_package varchar2(33) := ' ben_prtt_rt_val_api.';
7: g_debug boolean := hr_utility.debug_enabled;
8: g_abr_name varchar2(255);
9: --
10: -- ---------------------------------------------------------------------------
11: -- |------------------------< result_is_suspended >--------------------------|

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

40: begin
41: --
42: if g_debug then
43: l_proc := g_package||'result_is_suspended';
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: hr_utility.set_location('effective_date:'|| p_effective_date, 10);
46: end if;
47: --
48: -- open cursor and fetch result

Line 45: hr_utility.set_location('effective_date:'|| p_effective_date, 10);

41: --
42: if g_debug then
43: l_proc := g_package||'result_is_suspended';
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: hr_utility.set_location('effective_date:'|| p_effective_date, 10);
46: end if;
47: --
48: -- open cursor and fetch result
49: --

Line 64: hr_utility.set_location('Leaving:'|| l_proc, 1000);

60: end if;
61: close c_result;
62: --
63: if g_debug then
64: hr_utility.set_location('Leaving:'|| l_proc, 1000);
65: end if;
66: --
67: return(l_result);
68: end;

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

107:
108: Begin
109:
110: if g_debug then
111: hr_utility.set_location('Entering:'|| l_proc, 10);
112: end if;
113:
114: p_recurring_rt := true;
115:

Line 144: hr_utility.set_location('return date '|| p_rt_end_dt, 20);

140: end if ;
141:
142: g_abr_name := l_abr_name;
143: if g_debug then
144: hr_utility.set_location('return date '|| p_rt_end_dt, 20);
145: hr_utility.set_location('Leaving:'|| l_proc, 20);
146: end if;
147:
148: end get_non_recurring_end_dt;

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

141:
142: g_abr_name := l_abr_name;
143: if g_debug then
144: hr_utility.set_location('return date '|| p_rt_end_dt, 20);
145: hr_utility.set_location('Leaving:'|| l_proc, 20);
146: end if;
147:
148: end get_non_recurring_end_dt;
149: --

Line 179: g_debug := hr_utility.debug_enabled;

175: l_proc varchar2(72);
176:
177: begin
178:
179: g_debug := hr_utility.debug_enabled;
180: if g_debug then
181: l_proc := g_package||'chk_overlapping_dates';
182: hr_utility.set_location('Entering:'|| l_proc, 5);
183: end if;

Line 182: hr_utility.set_location('Entering:'|| l_proc, 5);

178:
179: g_debug := hr_utility.debug_enabled;
180: if g_debug then
181: l_proc := g_package||'chk_overlapping_dates';
182: hr_utility.set_location('Entering:'|| l_proc, 5);
183: end if;
184:
185: open c_overlap_rt;
186: fetch c_overlap_rt into

Line 201: hr_utility.set_location('Leaving:'|| l_proc, 10);

197: fnd_message.raise_error;
198: end if;
199:
200: if g_debug then
201: hr_utility.set_location('Leaving:'|| l_proc, 10);
202: end if;
203:
204: end chk_overlapping_dates;
205: --

Line 337: g_debug := hr_utility.debug_enabled;

333: l_pl_nip boolean;
334: --
335: begin
336: --
337: g_debug := hr_utility.debug_enabled;
338: if g_debug then
339: l_proc := g_package||'create_prtt_rt_val';
340: hr_utility.set_location('Entering:'|| l_proc, 10);
341: end if;

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

336: --
337: g_debug := hr_utility.debug_enabled;
338: if g_debug then
339: l_proc := g_package||'create_prtt_rt_val';
340: hr_utility.set_location('Entering:'|| l_proc, 10);
341: end if;
342: --
343: -- Issue a savepoint if operating in validation only mode
344: --

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

344: --
345: savepoint create_prtt_rt_val;
346: --
347: if g_debug then
348: hr_utility.set_location(l_proc, 20);
349: end if;
350:
351: l_rt_end_dt := p_rt_end_dt;
352:

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

724: --
725: end;
726: --
727: if g_debug then
728: hr_utility.set_location(l_proc, 60);
729: end if;
730: --
731: -- When in validation only mode raise the Validate_Enabled exception
732: --

Line 743: hr_utility.set_location(' Leaving:'||l_proc, 70);

739: p_prtt_rt_val_id := l_prtt_rt_val_id;
740: p_object_version_number := l_object_version_number;
741: --
742: if g_debug then
743: hr_utility.set_location(' Leaving:'||l_proc, 70);
744: end if;
745: --
746: exception
747: --

Line 762: hr_utility.set_location(' Leaving:'||l_proc, 80);

758: --
759: p_prtt_rt_val_id := null;
760: p_object_version_number := null;
761: if g_debug then
762: hr_utility.set_location(' Leaving:'||l_proc, 80);
763: end if;
764: --
765: when others then
766: --

Line 958: g_debug := hr_utility.debug_enabled;

954: l_dummy_number number;
955: --
956: begin
957: --
958: g_debug := hr_utility.debug_enabled;
959: if g_debug then
960: hr_utility.set_location('Entering:'|| l_proc, 10);
961: end if;
962: --

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

956: begin
957: --
958: g_debug := hr_utility.debug_enabled;
959: if g_debug then
960: hr_utility.set_location('Entering:'|| l_proc, 10);
961: end if;
962: --
963: -- Issue a savepoint if operating in validation only mode
964: --

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

964: --
965: savepoint update_prtt_rt_val;
966: --
967: if g_debug then
968: hr_utility.set_location(l_proc, 20);
969: end if;
970: --
971: -- Process Logic
972: --

Line 1251: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);

1247: ,p_effective_date => p_effective_date
1248: );
1249: --
1250: if g_debug then
1251: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1252: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1253: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1254: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1255: hr_utility.set_location('rate end date '||l_rt_end_dt,12);

Line 1252: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);

1248: );
1249: --
1250: if g_debug then
1251: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1252: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1253: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1254: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1255: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1256: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);

Line 1253: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);

1249: --
1250: if g_debug then
1251: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1252: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1253: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1254: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1255: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1256: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1257: end if;

Line 1254: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);

1250: if g_debug then
1251: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1252: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1253: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1254: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1255: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1256: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1257: end if;
1258: --

Line 1255: hr_utility.set_location('rate end date '||l_rt_end_dt,12);

1251: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1252: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1253: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1254: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1255: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1256: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1257: end if;
1258: --
1259: --BUG 3559005 We need to compate three values or

Line 1256: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);

1252: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1253: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1254: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1255: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1256: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1257: end if;
1258: --
1259: --BUG 3559005 We need to compate three values or
1260: --may bedependeding on the value passed to payroll code we need to

Line 1293: hr_utility.set_location('p_prtt_enrt_rslt_id'||l_old_enrt_rslt_id,15);

1289: else
1290: --
1291: -- 12583091 If result is previously unsuspended, delete element entry.
1292: --
1293: hr_utility.set_location('p_prtt_enrt_rslt_id'||l_old_enrt_rslt_id,15);
1294: hr_utility.set_location('l_old_element_entry_value_id '||l_old_element_entry_value_id,15);
1295: --
1296: if (p_rt_end_dt = hr_api.g_eot
1297: and l_old_element_entry_value_id is not null) then

Line 1294: hr_utility.set_location('l_old_element_entry_value_id '||l_old_element_entry_value_id,15);

1290: --
1291: -- 12583091 If result is previously unsuspended, delete element entry.
1292: --
1293: hr_utility.set_location('p_prtt_enrt_rslt_id'||l_old_enrt_rslt_id,15);
1294: hr_utility.set_location('l_old_element_entry_value_id '||l_old_element_entry_value_id,15);
1295: --
1296: if (p_rt_end_dt = hr_api.g_eot
1297: and l_old_element_entry_value_id is not null) then
1298: open c_pen_curr(l_old_enrt_rslt_id);

Line 1301: hr_utility.set_location('l_pen_curr.sspndd_flag '||l_pen_curr.sspndd_flag,150);

1297: and l_old_element_entry_value_id is not null) then
1298: open c_pen_curr(l_old_enrt_rslt_id);
1299: fetch c_pen_curr into l_pen_curr;
1300: close c_pen_curr;
1301: hr_utility.set_location('l_pen_curr.sspndd_flag '||l_pen_curr.sspndd_flag,150);
1302: if l_pen_curr.sspndd_flag = 'Y' then
1303: l_rslt_suspended := 'Y';
1304: end if;
1305: end if; -- end 12583091

Line 1325: hr_utility.set_location('Inside re-create',13);

1321: -- end entry one day before. Will not use rate end code here
1322: -- as the prv is not the one getting end dated
1323: --
1324: if g_debug then
1325: hr_utility.set_location('Inside re-create',13);
1326: end if;
1327:
1328: ben_element_entry.end_enrollment_element
1329: (p_business_group_id => p_business_group_id

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

1533: --
1534: end;
1535: --
1536: if g_debug then
1537: hr_utility.set_location(l_proc, 60);
1538: end if;
1539: --
1540: -- When in validation only mode raise the Validate_Enabled exception
1541: --

Line 1551: hr_utility.set_location(' Leaving:'||l_proc, 70);

1547: --
1548: p_object_version_number := l_object_version_number;
1549: --
1550: if g_debug then
1551: hr_utility.set_location(' Leaving:'||l_proc, 70);
1552: end if;
1553: --
1554: exception
1555: --

Line 1568: hr_utility.set_location(' Leaving:'||l_proc, 80);

1564: -- (Any key or derived arguments must be set to null
1565: -- when validation only mode is being used.)
1566: --
1567: if g_debug then
1568: hr_utility.set_location(' Leaving:'||l_proc, 80);
1569: end if;
1570: --
1571: when others then
1572: --

Line 1628: g_debug := hr_utility.debug_enabled;

1624: l_enrt_rt_id number;
1625:
1626: begin
1627: --
1628: g_debug := hr_utility.debug_enabled;
1629:
1630: if g_debug then
1631: l_proc := g_package||'delete_prtt_rt_val';
1632: hr_utility.set_location('Entering:'|| l_proc, 10);

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

1628: g_debug := hr_utility.debug_enabled;
1629:
1630: if g_debug then
1631: l_proc := g_package||'delete_prtt_rt_val';
1632: hr_utility.set_location('Entering:'|| l_proc, 10);
1633: end if;
1634: --
1635: -- Issue a savepoint if operating in validation only mode
1636: --

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

1636: --
1637: savepoint delete_prtt_rt_val;
1638: --
1639: if g_debug then
1640: hr_utility.set_location(l_proc, 20);
1641: end if;
1642: --
1643: -- Get the old values before any changes or calls
1644: --

Line 1663: hr_utility.set_location(l_proc, 22);

1659: fnd_message.raise_error;
1660: end if;
1661: close c_old_prv;
1662: if g_debug then
1663: hr_utility.set_location(l_proc, 22);
1664: end if;
1665:
1666: l_object_version_number := p_object_version_number;
1667: --

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

1764: --
1765: end;
1766: --
1767: if g_debug then
1768: hr_utility.set_location(l_proc, 60);
1769: end if;
1770: --
1771: -- When in validation only mode raise the Validate_Enabled exception
1772: --

Line 1778: hr_utility.set_location(' Leaving:'||l_proc, 70);

1774: raise hr_api.validate_enabled;
1775: end if;
1776: --
1777: if g_debug then
1778: hr_utility.set_location(' Leaving:'||l_proc, 70);
1779: end if;
1780: --
1781: exception
1782: --

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

1818: --
1819: begin
1820: --
1821: if g_debug then
1822: hr_utility.set_location('Entering:'|| l_proc, 10);
1823: end if;
1824: --
1825: ben_prv_shd.lck
1826: (

Line 1832: hr_utility.set_location(' Leaving:'||l_proc, 70);

1828: ,p_object_version_number => p_object_version_number
1829: );
1830: --
1831: if g_debug then
1832: hr_utility.set_location(' Leaving:'||l_proc, 70);
1833: end if;
1834: --
1835: end lck;
1836: --