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_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 379: hr_utility.set_location('Entering:'||l_proc, 5);

375: l_return VARCHAR2(240);
376: --
377: Begin
378: --
379: hr_utility.set_location('Entering:'||l_proc, 5);
380: --
381: open c_eoep_exists;
382: fetch c_eoep_exists into l_eoep_exists;
383: --

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

389: fnd_message.raise_error;
390: end if;
391: close c_eoep_exists;
392: --
393: hr_utility.set_location('Leaving:'||l_proc, 5);
394:
395: end chk_eoep_exists;
396: --End Bug 5753149
397: -- ----------------------------------------------------------------------------

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

546: l_api_updating boolean;
547: --
548: Begin
549: --
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: l_api_updating := ben_elp_shd.api_updating
553: (p_eligy_prfl_id => p_eligy_prfl_id,
554: p_effective_date => p_effective_date,

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

1313: fnd_message.set_token('FIELD','p_elig_crit_values_flag');
1314: fnd_message.raise_error;
1315: --
1316: end if;
1317: hr_utility.set_location('Leaving:'||l_proc,10);
1318: --
1319: end chk_lookups;
1320: -- ----------------------------------------------------------------------------
1321: -- |--------------------------< dt_update_validate >--------------------------|

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

1355: l_integrity_error Exception;
1356: l_table_name all_tables.table_name%TYPE;
1357: --
1358: Begin
1359: hr_utility.set_location('Entering:'||l_proc, 5);
1360: --
1361: -- Ensure that the p_datetrack_mode argument is not null
1362: --
1363: hr_api.mandatory_arg_error

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

1385: --
1386: --
1387: End If;
1388: --
1389: hr_utility.set_location(' Leaving:'||l_proc, 10);
1390: Exception
1391: When l_integrity_error Then
1392: --
1393: -- A referential integrity check was violated therefore

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

1453: l_rows_exist Exception;
1454: l_table_name all_tables.table_name%TYPE;
1455: --
1456: Begin
1457: hr_utility.set_location('Entering:'||l_proc, 5);
1458: --
1459: -- Ensure that the p_datetrack_mode argument is not null
1460: --
1461: hr_api.mandatory_arg_error

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

1498: End If;
1499: --
1500: End If;
1501: --
1502: hr_utility.set_location(' Leaving:'||l_proc, 10);
1503: Exception
1504: --
1505: When l_rows_exist Then
1506: --

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

1534: --
1535: l_proc varchar2(72) := g_package||'insert_validate';
1536: --
1537: Begin
1538: hr_utility.set_location('Entering:'||l_proc, 5);
1539: --
1540: -- Call all supporting business operations
1541: --
1542: --

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

1567: p_asmt_to_use_cd => p_rec.asmt_to_use_cd,
1568: p_effective_date => p_effective_date,
1569: p_object_version_number => p_rec.object_version_number);
1570: --
1571: hr_utility.set_location(' Leaving:'||l_proc, 10);
1572: End insert_validate;
1573: --
1574: -- ----------------------------------------------------------------------------
1575: -- |---------------------------< update_validate >----------------------------|

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

1583: --
1584: l_proc varchar2(72) := g_package||'update_validate';
1585: --
1586: Begin
1587: hr_utility.set_location('Entering:'||l_proc, 5);
1588: --
1589: -- Call all supporting business operations
1590: --
1591: --

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

1623: (p_datetrack_mode => p_datetrack_mode,
1624: p_validation_start_date => p_validation_start_date,
1625: p_validation_end_date => p_validation_end_date);
1626: --
1627: hr_utility.set_location(' Leaving:'||l_proc, 10);
1628: End update_validate;
1629: --
1630: -- ----------------------------------------------------------------------------
1631: -- |---------------------------< delete_validate >----------------------------|

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

1649: --
1650: l_elp_name ben_eligy_prfl_f.name%type;
1651: --
1652: Begin
1653: hr_utility.set_location('Entering:'||l_proc, 5);
1654: --
1655: OPEN c_elp_name;
1656: --
1657: FETCH c_elp_name INTO l_elp_name;

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

1761: THEN
1762: --
1763: -- Bug 4057566
1764: --
1765: -- hr_utility.set_message (801, 'PAY_52681_BHT_CHILD_EXISTS');
1766: -- hr_utility.raise_error;
1767: ben_utility.child_exists_error(p_table_name => 'BEN_ELIGY_PRFL_CRITERIA',
1768: p_parent_table_name => 'BEN_ELIGY_PRFL_F',
1769: p_parent_entity_name => l_elp_name);

Line 1766: -- hr_utility.raise_error;

1762: --
1763: -- Bug 4057566
1764: --
1765: -- hr_utility.set_message (801, 'PAY_52681_BHT_CHILD_EXISTS');
1766: -- hr_utility.raise_error;
1767: ben_utility.child_exists_error(p_table_name => 'BEN_ELIGY_PRFL_CRITERIA',
1768: p_parent_table_name => 'BEN_ELIGY_PRFL_F',
1769: p_parent_entity_name => l_elp_name);
1770: --

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

1773: END IF;
1774: --
1775: END IF;
1776: --
1777: hr_utility.set_location(' Leaving:'||l_proc, 10);
1778: End delete_validate;
1779: --
1780: --
1781: -- ---------------------------------------------------------------------------

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

1800: l_proc varchar2(72) := g_package||'return_legislation_code';
1801: --
1802: begin
1803: --
1804: hr_utility.set_location('Entering:'|| l_proc, 10);
1805: --
1806: -- Ensure that all the mandatory parameter are not null
1807: --
1808: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1825: end if;
1826: --
1827: close csr_leg_code;
1828: --
1829: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1830: --
1831: return l_legislation_code;
1832: --
1833: end return_legislation_code;