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.

[Home] [Help]

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: end if;
46: --
47: -- open cursor and fetch result
48: --

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

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

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

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

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

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

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

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

Line 178: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

Line 336: g_debug := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

Line 942: g_debug := hr_utility.debug_enabled;

938: l_dummy_number number;
939: --
940: begin
941: --
942: g_debug := hr_utility.debug_enabled;
943: if g_debug then
944: hr_utility.set_location('Entering:'|| l_proc, 10);
945: end if;
946: --

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

940: begin
941: --
942: g_debug := hr_utility.debug_enabled;
943: if g_debug then
944: hr_utility.set_location('Entering:'|| l_proc, 10);
945: end if;
946: --
947: -- Issue a savepoint if operating in validation only mode
948: --

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

948: --
949: savepoint update_prtt_rt_val;
950: --
951: if g_debug then
952: hr_utility.set_location(l_proc, 20);
953: end if;
954: --
955: -- Process Logic
956: --

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

1231: ,p_effective_date => p_effective_date
1232: );
1233: --
1234: if g_debug then
1235: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1236: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1237: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1238: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1239: hr_utility.set_location('rate end date '||l_rt_end_dt,12);

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

1232: );
1233: --
1234: if g_debug then
1235: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1236: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1237: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1238: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1239: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1240: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);

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

1233: --
1234: if g_debug then
1235: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1236: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1237: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1238: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1239: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1240: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1241: end if;

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

1234: if g_debug then
1235: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1236: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1237: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1238: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1239: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1240: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1241: end if;
1242: --

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

1235: hr_utility.set_location('old entry value'||l_old_element_entry_value_id,11);
1236: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1237: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1238: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1239: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1240: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1241: end if;
1242: --
1243: --BUG 3559005 We need to compate three values or

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

1236: hr_utility.set_location('prtt rt val id '||p_prtt_rt_val_id,11);
1237: hr_utility.set_location('rate start date '||l_rt_strt_dt,11);
1238: hr_utility.set_location('old rt strt date '||l_old_rt_strt_dt,12);
1239: hr_utility.set_location('rate end date '||l_rt_end_dt,12);
1240: hr_utility.set_location('old rt end date '||l_old_rt_end_dt,12);
1241: end if;
1242: --
1243: --BUG 3559005 We need to compate three values or
1244: --may bedependeding on the value passed to payroll code we need to

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

1270: -- end entry one day before. Will not use rate end code here
1271: -- as the prv is not the one getting end dated
1272: --
1273: if g_debug then
1274: hr_utility.set_location('Inside re-create',13);
1275: end if;
1276:
1277: ben_element_entry.end_enrollment_element
1278: (p_business_group_id => p_business_group_id

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

1482: --
1483: end;
1484: --
1485: if g_debug then
1486: hr_utility.set_location(l_proc, 60);
1487: end if;
1488: --
1489: -- When in validation only mode raise the Validate_Enabled exception
1490: --

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

1496: --
1497: p_object_version_number := l_object_version_number;
1498: --
1499: if g_debug then
1500: hr_utility.set_location(' Leaving:'||l_proc, 70);
1501: end if;
1502: --
1503: exception
1504: --

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

1513: -- (Any key or derived arguments must be set to null
1514: -- when validation only mode is being used.)
1515: --
1516: if g_debug then
1517: hr_utility.set_location(' Leaving:'||l_proc, 80);
1518: end if;
1519: --
1520: when others then
1521: --

Line 1577: g_debug := hr_utility.debug_enabled;

1573: l_enrt_rt_id number;
1574:
1575: begin
1576: --
1577: g_debug := hr_utility.debug_enabled;
1578:
1579: if g_debug then
1580: l_proc := g_package||'delete_prtt_rt_val';
1581: hr_utility.set_location('Entering:'|| l_proc, 10);

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

1577: g_debug := hr_utility.debug_enabled;
1578:
1579: if g_debug then
1580: l_proc := g_package||'delete_prtt_rt_val';
1581: hr_utility.set_location('Entering:'|| l_proc, 10);
1582: end if;
1583: --
1584: -- Issue a savepoint if operating in validation only mode
1585: --

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

1585: --
1586: savepoint delete_prtt_rt_val;
1587: --
1588: if g_debug then
1589: hr_utility.set_location(l_proc, 20);
1590: end if;
1591: --
1592: -- Get the old values before any changes or calls
1593: --

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

1608: fnd_message.raise_error;
1609: end if;
1610: close c_old_prv;
1611: if g_debug then
1612: hr_utility.set_location(l_proc, 22);
1613: end if;
1614:
1615: l_object_version_number := p_object_version_number;
1616: --

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

1713: --
1714: end;
1715: --
1716: if g_debug then
1717: hr_utility.set_location(l_proc, 60);
1718: end if;
1719: --
1720: -- When in validation only mode raise the Validate_Enabled exception
1721: --

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

1723: raise hr_api.validate_enabled;
1724: end if;
1725: --
1726: if g_debug then
1727: hr_utility.set_location(' Leaving:'||l_proc, 70);
1728: end if;
1729: --
1730: exception
1731: --

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

1767: --
1768: begin
1769: --
1770: if g_debug then
1771: hr_utility.set_location('Entering:'|| l_proc, 10);
1772: end if;
1773: --
1774: ben_prv_shd.lck
1775: (

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

1777: ,p_object_version_number => p_object_version_number
1778: );
1779: --
1780: if g_debug then
1781: hr_utility.set_location(' Leaving:'||l_proc, 70);
1782: end if;
1783: --
1784: end lck;
1785: --