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

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_elp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_eligy_prfl_id => p_eligy_prfl_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_eligy_prfl_id;
78: --
79: -- ---------------------------------------------------------------------------

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

128: --
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_elp_shd.api_updating
135: (p_effective_date => p_effective_date,
136: p_eligy_prfl_id => p_eligy_prfl_id,

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

139: if (l_api_updating
140: and p_name <> ben_elp_shd.g_old_rec.name) or
141: not l_api_updating then
142: --
143: hr_utility.set_location('Entering:'||l_proc, 10);
144: --
145: -- check if this name already exist
146: --
147: open csr_name;

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

156: end if;
157: --
158: end if;
159: --
160: hr_utility.set_location('Leaving:'||l_proc, 20);
161: --
162: End chk_name;
163: --
164: -- ----------------------------------------------------------------------------

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

196: l_api_updating boolean;
197: --
198: Begin
199: --
200: hr_utility.set_location('Entering:'||l_proc, 5);
201: --
202: l_api_updating := ben_elp_shd.api_updating
203: (p_eligy_prfl_id => p_eligy_prfl_id,
204: p_effective_date => p_effective_date,

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

225: end if;
226: --
227: end if;
228: --
229: hr_utility.set_location('Leaving:'||l_proc,10);
230: --
231: end chk_stat_cd;
232: --
233: -- ----------------------------------------------------------------------------

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

265: l_api_updating boolean;
266: --
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_elp_shd.api_updating
272: (p_eligy_prfl_id => p_eligy_prfl_id,
273: p_effective_date => p_effective_date,

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

296: end if;
297: --
298: end if;
299: --
300: hr_utility.set_location('Leaving:'||l_proc,10);
301: --
302: end chk_asmt_to_use_cd;
303: --
304: --Bug#5248048

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

327: l_return VARCHAR2(240);
328: --
329: Begin
330: --
331: hr_utility.set_location('Entering:'||l_proc, 5);
332: --
333: open c_cagr_exists;
334: fetch c_cagr_exists into l_cagr_exists;
335: --

Line 348: hr_utility.set_location('Leaving:'||l_proc, 5);

344:
345: end if;
346: close c_cagr_exists;
347: --
348: hr_utility.set_location('Leaving:'||l_proc, 5);
349:
350: end chk_cagr_exists;
351: --
352: --Bug#5248048

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

386: l_lrnr_group varchar2(1);
387: --End Enh: 13478736
388: Begin
389: --
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: --
392: open c_eoep_exists;
393: fetch c_eoep_exists into l_eoep_exists;
394: --

Line 418: hr_utility.set_location('Leaving:'||l_proc, 5);

414: fnd_message.raise_error;
415: end if;
416: close c_eoep_exists;
417: --
418: hr_utility.set_location('Leaving:'||l_proc, 5);
419:
420: end chk_eoep_exists;
421: --End Bug 5753149
422: -- ----------------------------------------------------------------------------

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

571: l_api_updating boolean;
572: --
573: Begin
574: --
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: l_api_updating := ben_elp_shd.api_updating
578: (p_eligy_prfl_id => p_eligy_prfl_id,
579: p_effective_date => p_effective_date,

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

1338: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1339: fnd_message.raise_error;
1340: --
1341: end if;
1342: hr_utility.set_location('Leaving:'||l_proc,10);
1343: --
1344: end chk_lookups;
1345: -- ----------------------------------------------------------------------------
1346: -- |--------------------------< dt_update_validate >--------------------------|

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

1380: l_integrity_error Exception;
1381: l_table_name all_tables.table_name%TYPE;
1382: --
1383: Begin
1384: hr_utility.set_location('Entering:'||l_proc, 5);
1385: --
1386: -- Ensure that the p_datetrack_mode argument is not null
1387: --
1388: hr_api.mandatory_arg_error

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

1410: --
1411: --
1412: End If;
1413: --
1414: hr_utility.set_location(' Leaving:'||l_proc, 10);
1415: Exception
1416: When l_integrity_error Then
1417: --
1418: -- A referential integrity check was violated therefore

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

1478: l_rows_exist Exception;
1479: l_table_name all_tables.table_name%TYPE;
1480: --
1481: Begin
1482: hr_utility.set_location('Entering:'||l_proc, 5);
1483: --
1484: -- Ensure that the p_datetrack_mode argument is not null
1485: --
1486: hr_api.mandatory_arg_error

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

1523: End If;
1524: --
1525: End If;
1526: --
1527: hr_utility.set_location(' Leaving:'||l_proc, 10);
1528: Exception
1529: --
1530: When l_rows_exist Then
1531: --

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

1559: --
1560: l_proc varchar2(72) := g_package||'insert_validate';
1561: --
1562: Begin
1563: hr_utility.set_location('Entering:'||l_proc, 5);
1564: --
1565: -- Call all supporting business operations
1566: --
1567: --

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

1592: p_asmt_to_use_cd => p_rec.asmt_to_use_cd,
1593: p_effective_date => p_effective_date,
1594: p_object_version_number => p_rec.object_version_number);
1595: --
1596: hr_utility.set_location(' Leaving:'||l_proc, 10);
1597: End insert_validate;
1598: --
1599: -- ----------------------------------------------------------------------------
1600: -- |---------------------------< update_validate >----------------------------|

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

1608: --
1609: l_proc varchar2(72) := g_package||'update_validate';
1610: --
1611: Begin
1612: hr_utility.set_location('Entering:'||l_proc, 5);
1613: --
1614: -- Call all supporting business operations
1615: --
1616: --

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

1648: (p_datetrack_mode => p_datetrack_mode,
1649: p_validation_start_date => p_validation_start_date,
1650: p_validation_end_date => p_validation_end_date);
1651: --
1652: hr_utility.set_location(' Leaving:'||l_proc, 10);
1653: End update_validate;
1654: --
1655: -- ----------------------------------------------------------------------------
1656: -- |---------------------------< delete_validate >----------------------------|

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

1674: --
1675: l_elp_name ben_eligy_prfl_f.name%type;
1676: --
1677: Begin
1678: hr_utility.set_location('Entering:'||l_proc, 5);
1679: --
1680: OPEN c_elp_name;
1681: --
1682: FETCH c_elp_name INTO l_elp_name;

Line 1790: -- hr_utility.set_message (801, 'PAY_52681_BHT_CHILD_EXISTS');

1786: THEN
1787: --
1788: -- Bug 4057566
1789: --
1790: -- hr_utility.set_message (801, 'PAY_52681_BHT_CHILD_EXISTS');
1791: -- hr_utility.raise_error;
1792: ben_utility.child_exists_error(p_table_name => 'BEN_ELIGY_PRFL_CRITERIA',
1793: p_parent_table_name => 'BEN_ELIGY_PRFL_F',
1794: p_parent_entity_name => l_elp_name);

Line 1791: -- hr_utility.raise_error;

1787: --
1788: -- Bug 4057566
1789: --
1790: -- hr_utility.set_message (801, 'PAY_52681_BHT_CHILD_EXISTS');
1791: -- hr_utility.raise_error;
1792: ben_utility.child_exists_error(p_table_name => 'BEN_ELIGY_PRFL_CRITERIA',
1793: p_parent_table_name => 'BEN_ELIGY_PRFL_F',
1794: p_parent_entity_name => l_elp_name);
1795: --

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

1798: END IF;
1799: --
1800: END IF;
1801: --
1802: hr_utility.set_location(' Leaving:'||l_proc, 10);
1803: End delete_validate;
1804: --
1805: --
1806: -- ---------------------------------------------------------------------------

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

1825: l_proc varchar2(72) := g_package||'return_legislation_code';
1826: --
1827: begin
1828: --
1829: hr_utility.set_location('Entering:'|| l_proc, 10);
1830: --
1831: -- Ensure that all the mandatory parameter are not null
1832: --
1833: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1850: end if;
1851: --
1852: close csr_leg_code;
1853: --
1854: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1855: --
1856: return l_legislation_code;
1857: --
1858: end return_legislation_code;