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

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

29: l_proc varchar2(72) := g_package||'return_legislation_code';
30: --
31: begin
32: --
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Ensure that all the mandatory parameter are not null
36: --
37: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

54: end if;
55: --
56: close csr_leg_code;
57: --
58: hr_utility.set_location(' Leaving:'|| l_proc, 20);
59: --
60: return l_legislation_code;
61: --
62: end return_legislation_code;

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

96: l_api_updating boolean;
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering:'||l_proc, 5);
101: --
102: l_api_updating := ben_clp_shd.api_updating
103: (p_effective_date => p_effective_date,
104: p_clpse_lf_evt_id => p_clpse_lf_evt_id,

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

125: end if;
126: --
127: end if;
128: --
129: hr_utility.set_location('Leaving:'||l_proc, 10);
130: --
131: End chk_clpse_lf_evt_id;
132: --
133: -- ----------------------------------------------------------------------------

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

183: or (p_validation_start_date>clp.effective_end_date)));
184:
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_clp_shd.api_updating
190: (p_effective_date => p_effective_date,
191: p_clpse_lf_evt_id => p_clpse_lf_evt_id,

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

212: close c1;
213: --
214: end if;
215: --
216: hr_utility.set_location('Leaving:'||l_proc, 10);
217: --
218: End chk_seq;
219: -- ----------------------------------------------------------------------------
220: -- |------------------------< chk_ler1_id >-----------------------------------|

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

252: l_api_updating boolean;
253: --
254: Begin
255: --
256: hr_utility.set_location('Entering:'||l_proc, 5);
257: --
258: l_api_updating := ben_clp_shd.api_updating
259: (p_effective_date => p_effective_date,
260: p_clpse_lf_evt_id => p_clpse_lf_evt_id,

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

266: fnd_message.raise_error;
267: --
268: end if;
269: --
270: hr_utility.set_location('Leaving:'||l_proc, 10);
271: --
272: End chk_ler1_id;
273: -- ----------------------------------------------------------------------------
274: -- |------------------------< chk_eval_ler_id >-------------------------------|

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

306: l_api_updating boolean;
307: --
308: Begin
309: --
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: if p_eval_ler_id is null then
313: --
314: fnd_message.set_name('BEN','BEN_92126_EVAL_LER_ID');

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

315: fnd_message.raise_error;
316: --
317: end if;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 10);
320: --
321: End chk_eval_ler_id;
322: -- ----------------------------------------------------------------------------
323: -- |------------------------< chk_tlrnc_dys_num >-----------------------------|

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

355: l_api_updating boolean;
356: --
357: Begin
358: --
359: hr_utility.set_location('Entering:'||l_proc, 5);
360: --
361: if nvl(p_tlrnc_dys_num,0) < 0 then
362: --
363: fnd_message.set_name('BEN','BEN_92127_TLRNC_DYS_NUM');

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

364: fnd_message.raise_error;
365: --
366: end if;
367: --
368: hr_utility.set_location('Leaving:'||l_proc, 10);
369: --
370: End chk_tlrnc_dys_num;
371: -- ----------------------------------------------------------------------------
372: -- |----------------------------< chk_ler_bool_seq >--------------------------|

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

442: l_error boolean := false;
443: --
444: Begin
445: --
446: hr_utility.set_location('Entering:'||l_proc, 5);
447: --
448: l_api_updating := ben_clp_shd.api_updating
449: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
450: p_effective_date => p_effective_date,

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

600: end if;
601: --
602: end if;
603: --
604: hr_utility.set_location('Entering:'||l_proc, 5);
605: --
606: end chk_ler_bool_seq;
607: -- ----------------------------------------------------------------------------
608: -- |----------------------------< chk_bool_cd >-------------------------------|

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

655: l_api_updating boolean;
656: --
657: Begin
658: --
659: hr_utility.set_location('Entering:'||l_proc, 5);
660: --
661: l_api_updating := ben_clp_shd.api_updating
662: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
663: p_effective_date => p_effective_date,

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

878: end if;
879: --
880: end if;
881: --
882: hr_utility.set_location('Leaving:'||l_proc,10);
883: --
884: end chk_bool_cd;
885: --
886: -- ----------------------------------------------------------------------------

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

920: l_api_updating boolean;
921: --
922: Begin
923: --
924: hr_utility.set_location('Entering:'||l_proc, 5);
925: --
926: l_api_updating := ben_clp_shd.api_updating
927: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
928: p_effective_date => p_effective_date,

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

952: end if;
953: --
954: end if;
955: --
956: hr_utility.set_location('Leaving:'||l_proc,10);
957: --
958: end chk_eval_rl;
959: -- ----------------------------------------------------------------------------
960: -- |-------------------------< chk_eval_ler_det_rl >--------------------------|

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

993: l_api_updating boolean;
994: --
995: Begin
996: --
997: hr_utility.set_location('Entering:'||l_proc, 5);
998: --
999: l_api_updating := ben_clp_shd.api_updating
1000: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
1001: p_effective_date => p_effective_date,

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

1025: end if;
1026: --
1027: end if;
1028: --
1029: hr_utility.set_location('Leaving:'||l_proc,10);
1030: --
1031: end chk_eval_ler_det_rl;
1032: --
1033: -- ----------------------------------------------------------------------------

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

1075: l_found boolean := false;
1076: --
1077: Begin
1078: --
1079: hr_utility.set_location('Entering:'||l_proc, 5);
1080: --
1081: if p_bool1_cd is null and
1082: (p_bool2_cd is not null or
1083: p_bool3_cd is not null or

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

1157: fnd_message.raise_error;
1158: --
1159: end if;
1160: --
1161: hr_utility.set_location('Entering:'||l_proc, 5);
1162: --
1163: end chk_consecutive_bool_cd;
1164: -- ----------------------------------------------------------------------------
1165: -- |---------------------< chk_consecutive_ler_id >---------------------------|

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

1208: l_found boolean := false;
1209: --
1210: Begin
1211: --
1212: hr_utility.set_location('Entering:'||l_proc, 5);
1213: --
1214: if p_ler1_id is null and
1215: (p_ler2_id is not null or
1216: p_ler3_id is not null or

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

1303: fnd_message.raise_error;
1304: --
1305: end if;
1306: --
1307: hr_utility.set_location('Entering:'||l_proc, 5);
1308: --
1309: end chk_consecutive_ler_id;
1310: -- ----------------------------------------------------------------------------
1311: -- |----------------------------< chk_eval_cd >-------------------------------|

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

1344: l_dummy varchar2(1);
1345: --
1346: Begin
1347: --
1348: hr_utility.set_location('Entering:'||l_proc, 5);
1349: --
1350: l_api_updating := ben_clp_shd.api_updating
1351: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
1352: p_effective_date => p_effective_date,

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

1374: end if;
1375: --
1376: end if;
1377: --
1378: hr_utility.set_location('Leaving:'||l_proc,10);
1379: --
1380: end chk_eval_cd;
1381: -- ----------------------------------------------------------------------------
1382: -- |------------------------< chk_eval_ler_det_cd >---------------------------|

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

1415: l_dummy varchar2(1);
1416: --
1417: Begin
1418: --
1419: hr_utility.set_location('Entering:'||l_proc, 5);
1420: --
1421: l_api_updating := ben_clp_shd.api_updating
1422: (p_clpse_lf_evt_id => p_clpse_lf_evt_id,
1423: p_effective_date => p_effective_date,

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

1445: end if;
1446: --
1447: end if;
1448: --
1449: hr_utility.set_location('Leaving:'||l_proc,10);
1450: --
1451: end chk_eval_ler_det_cd;
1452: -- ----------------------------------------------------------------------------
1453: -- |--------------------------< dt_update_validate >--------------------------|

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

1498: l_integrity_error Exception;
1499: l_table_name all_tables.table_name%TYPE;
1500: --
1501: Begin
1502: hr_utility.set_location('Entering:'||l_proc, 5);
1503: --
1504: -- Ensure that the p_datetrack_mode argument is not null
1505: --
1506: hr_api.mandatory_arg_error

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

1637: End If;
1638: --
1639: End If;
1640: --
1641: hr_utility.set_location(' Leaving:'||l_proc, 10);
1642: Exception
1643: When l_integrity_error Then
1644: --
1645: -- A referential integrity check was violated therefore

Line 1648: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

1644: --
1645: -- A referential integrity check was violated therefore
1646: -- we must error
1647: --
1648: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1649: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1650: hr_utility.raise_error;
1651: When Others Then
1652: --

Line 1649: hr_utility.set_message_token('TABLE_NAME', l_table_name);

1645: -- A referential integrity check was violated therefore
1646: -- we must error
1647: --
1648: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1649: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1650: hr_utility.raise_error;
1651: When Others Then
1652: --
1653: -- An unhandled or unexpected error has occurred which

Line 1650: hr_utility.raise_error;

1646: -- we must error
1647: --
1648: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1649: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1650: hr_utility.raise_error;
1651: When Others Then
1652: --
1653: -- An unhandled or unexpected error has occurred which
1654: -- we must report

Line 1656: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1652: --
1653: -- An unhandled or unexpected error has occurred which
1654: -- we must report
1655: --
1656: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1657: hr_utility.set_message_token('PROCEDURE', l_proc);
1658: hr_utility.set_message_token('STEP','15');
1659: hr_utility.raise_error;
1660: End dt_update_validate;

Line 1657: hr_utility.set_message_token('PROCEDURE', l_proc);

1653: -- An unhandled or unexpected error has occurred which
1654: -- we must report
1655: --
1656: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1657: hr_utility.set_message_token('PROCEDURE', l_proc);
1658: hr_utility.set_message_token('STEP','15');
1659: hr_utility.raise_error;
1660: End dt_update_validate;
1661: --

Line 1658: hr_utility.set_message_token('STEP','15');

1654: -- we must report
1655: --
1656: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1657: hr_utility.set_message_token('PROCEDURE', l_proc);
1658: hr_utility.set_message_token('STEP','15');
1659: hr_utility.raise_error;
1660: End dt_update_validate;
1661: --
1662: -- ----------------------------------------------------------------------------

Line 1659: hr_utility.raise_error;

1655: --
1656: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1657: hr_utility.set_message_token('PROCEDURE', l_proc);
1658: hr_utility.set_message_token('STEP','15');
1659: hr_utility.raise_error;
1660: End dt_update_validate;
1661: --
1662: -- ----------------------------------------------------------------------------
1663: -- |--------------------------< dt_delete_validate >--------------------------|

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

1704: l_rows_exist Exception;
1705: l_table_name all_tables.table_name%TYPE;
1706: --
1707: Begin
1708: hr_utility.set_location('Entering:'||l_proc, 5);
1709: --
1710: -- Ensure that the p_datetrack_mode argument is not null
1711: --
1712: hr_api.mandatory_arg_error

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

1741: --
1742: --
1743: End If;
1744: --
1745: hr_utility.set_location(' Leaving:'||l_proc, 10);
1746: Exception
1747: When l_rows_exist Then
1748: --
1749: -- A referential integrity check was violated therefore

Line 1752: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');

1748: --
1749: -- A referential integrity check was violated therefore
1750: -- we must error
1751: --
1752: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1753: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1754: hr_utility.raise_error;
1755: When Others Then
1756: --

Line 1753: hr_utility.set_message_token('TABLE_NAME', l_table_name);

1749: -- A referential integrity check was violated therefore
1750: -- we must error
1751: --
1752: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1753: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1754: hr_utility.raise_error;
1755: When Others Then
1756: --
1757: -- An unhandled or unexpected error has occurred which

Line 1754: hr_utility.raise_error;

1750: -- we must error
1751: --
1752: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1753: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1754: hr_utility.raise_error;
1755: When Others Then
1756: --
1757: -- An unhandled or unexpected error has occurred which
1758: -- we must report

Line 1760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

1756: --
1757: -- An unhandled or unexpected error has occurred which
1758: -- we must report
1759: --
1760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE', l_proc);
1762: hr_utility.set_message_token('STEP','15');
1763: hr_utility.raise_error;
1764: End dt_delete_validate;

Line 1761: hr_utility.set_message_token('PROCEDURE', l_proc);

1757: -- An unhandled or unexpected error has occurred which
1758: -- we must report
1759: --
1760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE', l_proc);
1762: hr_utility.set_message_token('STEP','15');
1763: hr_utility.raise_error;
1764: End dt_delete_validate;
1765: --

Line 1762: hr_utility.set_message_token('STEP','15');

1758: -- we must report
1759: --
1760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE', l_proc);
1762: hr_utility.set_message_token('STEP','15');
1763: hr_utility.raise_error;
1764: End dt_delete_validate;
1765: --
1766: -- ----------------------------------------------------------------------------

Line 1763: hr_utility.raise_error;

1759: --
1760: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1761: hr_utility.set_message_token('PROCEDURE', l_proc);
1762: hr_utility.set_message_token('STEP','15');
1763: hr_utility.raise_error;
1764: End dt_delete_validate;
1765: --
1766: -- ----------------------------------------------------------------------------
1767: -- |---------------------------< insert_validate >----------------------------|

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

1775: --
1776: l_proc varchar2(72) := g_package||'insert_validate';
1777: --
1778: Begin
1779: hr_utility.set_location('Entering:'||l_proc, 5);
1780: --
1781: -- Call all supporting business operations
1782: --
1783: --

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

1902: p_ler10_id => p_rec.ler10_id,
1903: p_effective_date => p_effective_date,
1904: p_object_version_number => p_rec.object_version_number);
1905: --
1906: hr_utility.set_location(' Leaving:'||l_proc, 10);
1907: End insert_validate;
1908: --
1909: -- ----------------------------------------------------------------------------
1910: -- |---------------------------< update_validate >----------------------------|

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

1918: --
1919: l_proc varchar2(72) := g_package||'update_validate';
1920: --
1921: Begin
1922: hr_utility.set_location('Entering:'||l_proc, 5);
1923: --
1924: -- Call all supporting business operations
1925: --
1926: --

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

2063: p_datetrack_mode => p_datetrack_mode,
2064: p_validation_start_date => p_validation_start_date,
2065: p_validation_end_date => p_validation_end_date);
2066: --
2067: hr_utility.set_location(' Leaving:'||l_proc, 10);
2068: End update_validate;
2069: --
2070: -- ----------------------------------------------------------------------------
2071: -- |---------------------------< delete_validate >----------------------------|

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

2079: --
2080: l_proc varchar2(72) := g_package||'delete_validate';
2081: --
2082: Begin
2083: hr_utility.set_location('Entering:'||l_proc, 5);
2084: --
2085: -- Call all supporting business operations
2086: --
2087: dt_delete_validate

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

2089: p_validation_start_date => p_validation_start_date,
2090: p_validation_end_date => p_validation_end_date,
2091: p_clpse_lf_evt_id => p_rec.clpse_lf_evt_id);
2092: --
2093: hr_utility.set_location(' Leaving:'||l_proc, 10);
2094: End delete_validate;
2095: --
2096: end ben_clp_bus;