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_PEO_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_peo_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_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_elig_to_prte_rsn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_peo_shd.api_updating
118: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
119: p_effective_date => p_effective_date,

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

142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_ignr_prtn_ovrid_flag;
149: --
150: -- ----------------------------------------------------------------------------

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

182: l_api_updating boolean;
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_peo_shd.api_updating
189: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
190: p_effective_date => p_effective_date,

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_prtn_ovridbl_flag;
220: --
221: -- ----------------------------------------------------------------------------

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

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

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

286: end if;
287: --
288: end if;
289: --
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: end chk_vrfy_fmly_mmbr_cd;
293: --
294: -- ----------------------------------------------------------------------------

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

326: l_api_updating boolean;
327: --
328: Begin
329: --
330: hr_utility.set_location('Entering:'||l_proc, 5);
331: --
332: l_api_updating := ben_peo_shd.api_updating
333: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
334: p_effective_date => p_effective_date,

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

359: end if;
360: --
361: end if;
362: --
363: hr_utility.set_location('Leaving:'||l_proc,10);
364: --
365: end chk_elig_inelig_cd;
366: --
367: -- ----------------------------------------------------------------------------

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

399: l_api_updating boolean;
400: --
401: Begin
402: --
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: l_api_updating := ben_peo_shd.api_updating
406: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
407: p_effective_date => p_effective_date,

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

432: end if;
433: --
434: end if;
435: --
436: hr_utility.set_location('Leaving:'||l_proc,10);
437: --
438: end chk_prtn_eff_strt_dt_cd;
439: --
440: -- ----------------------------------------------------------------------------

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

475: l_api_updating boolean;
476: --
477: Begin
478: --
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: l_api_updating := ben_peo_shd.api_updating
482: (p_effective_date => p_effective_date,
483: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,

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

507: end if;
508: --
509: end if;
510: --
511: hr_utility.set_location('Leaving:'||l_proc,10);
512: --
513: end chk_vrfy_fmly_mmbr_rl;
514: --
515: -- ----------------------------------------------------------------------------

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

550: l_api_updating boolean;
551: --
552: Begin
553: --
554: hr_utility.set_location('Entering:'||l_proc, 5);
555: --
556: l_api_updating := ben_peo_shd.api_updating
557: (p_effective_date => p_effective_date,
558: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,

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

582: end if;
583: --
584: end if;
585: --
586: hr_utility.set_location('Leaving:'||l_proc,10);
587: --
588: end chk_prtn_eff_strt_dt_rl;
589: --
590: -- ----------------------------------------------------------------------------

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

622: l_api_updating boolean;
623: --
624: Begin
625: --
626: hr_utility.set_location('Entering:'||l_proc, 5);
627: --
628: l_api_updating := ben_peo_shd.api_updating
629: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
630: p_effective_date => p_effective_date,

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

655: end if;
656: --
657: end if;
658: --
659: hr_utility.set_location('Leaving:'||l_proc,10);
660: --
661: end chk_prtn_eff_end_dt_cd;
662: --
663: -- ----------------------------------------------------------------------------

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

696: l_api_updating boolean;
697: --
698: Begin
699: --
700: hr_utility.set_location('Entering:'||l_proc, 5);
701: --
702: l_api_updating := ben_peo_shd.api_updating
703: (p_effective_date => p_effective_date,
704: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,

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

728: end if;
729: --
730: end if;
731: --
732: hr_utility.set_location('Leaving:'||l_proc,10);
733: --
734: end chk_prtn_eff_end_dt_rl;
735: --
736: -- ----------------------------------------------------------------------------

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

770: l_api_updating boolean;
771: --
772: Begin
773: --
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: l_api_updating := ben_peo_shd.api_updating
777: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
778: p_effective_date => p_effective_date,

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

804: end if;
805: --
806: end if;
807: --
808: hr_utility.set_location('Leaving:'||l_proc,10);
809: --
810: end chk_wait_perd_dt_to_use_cd;
811: --
812:

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

838: p_vrfy_fmly_mmbr_cd in varchar2,
839: p_vrfy_fmly_mmbr_rl in number ) IS
840: l_proc varchar2(72) := g_package||'chk_cd_rl_combination';
841: BEGIN
842: hr_utility.set_location('Entering:'||l_proc, 5);
843: --
844: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
845: then
846: fnd_message.set_name('BEN','BEN_91730_NO_RULE');

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

854: end if;
855: --
856: --leaving Procedure.
857: --
858: hr_utility.set_location('Leaving:'||l_proc,10);
859: --
860: end chk_cd_rl_combination;
861:
862: --

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

899: l_api_updating boolean;
900: --
901: Begin
902: --
903: hr_utility.set_location('Entering:'||l_proc, 5);
904: --
905: l_api_updating := ben_peo_shd.api_updating
906: (p_effective_date => p_effective_date,
907: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,

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

931: end if;
932: --
933: end if;
934: --
935: hr_utility.set_location('Leaving:'||l_proc,10);
936: --
937: end chk_wait_perd_dt_to_use_rl;
938: --
939: -- ----------------------------------------------------------------------------

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

971: l_api_updating boolean;
972: --
973: Begin
974: --
975: hr_utility.set_location('Entering:'||l_proc, 5);
976: --
977: l_api_updating := ben_peo_shd.api_updating
978: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
979: p_effective_date => p_effective_date,

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

1002: end if;
1003: --
1004: end if;
1005: --
1006: hr_utility.set_location('Leaving:'||l_proc,10);
1007: --
1008: end chk_wait_perd_uom;
1009: --
1010: -- ----------------------------------------------------------------------------

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

1045: l_api_updating boolean;
1046: --
1047: Begin
1048: --
1049: hr_utility.set_location('Entering:'||l_proc, 5);
1050: --
1051: l_api_updating := ben_peo_shd.api_updating
1052: (p_effective_date => p_effective_date,
1053: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,

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

1077: end if;
1078: --
1079: end if;
1080: --
1081: hr_utility.set_location('Leaving:'||l_proc,10);
1082: --
1083: end chk_wait_perd_rl;
1084: --
1085: -- ----------------------------------------------------------------------------

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

1119: l_api_updating boolean;
1120: --
1121: Begin
1122: --
1123: hr_utility.set_location('Entering:'||l_proc, 5);
1124: --
1125: l_api_updating := ben_peo_shd.api_updating
1126: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1127: p_effective_date => p_effective_date,

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

1150: end if;
1151: --
1152: end if;
1153: --
1154: hr_utility.set_location('Leaving:'||l_proc,10);
1155: --
1156: end chk_mx_poe_uom;
1157: --
1158: -- ----------------------------------------------------------------------------

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

1193: l_api_updating boolean;
1194: --
1195: Begin
1196: --
1197: hr_utility.set_location('Entering:'||l_proc, 5);
1198: --
1199: l_api_updating := ben_peo_shd.api_updating
1200: (p_effective_date => p_effective_date,
1201: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,

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

1225: end if;
1226: --
1227: end if;
1228: --
1229: hr_utility.set_location('Leaving:'||l_proc,10);
1230: --
1231: end chk_mx_poe_det_dt_rl;
1232: --
1233: -- ----------------------------------------------------------------------------

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

1268: l_api_updating boolean;
1269: --
1270: Begin
1271: --
1272: hr_utility.set_location('Entering:'||l_proc, 5);
1273: --
1274: l_api_updating := ben_peo_shd.api_updating
1275: (p_effective_date => p_effective_date,
1276: p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,

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

1301: --
1302: --
1303: end if;
1304: --
1305: hr_utility.set_location('Leaving:'||l_proc,10);
1306: --
1307: end chk_mx_poe_rl;
1308: --
1309: -- ----------------------------------------------------------------------------

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

1343: l_api_updating boolean;
1344: --
1345: Begin
1346: --
1347: hr_utility.set_location('Entering:'||l_proc, 5);
1348: --
1349: l_api_updating := ben_peo_shd.api_updating
1350: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1351: 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_mx_poe_det_dt_cd;
1381: --
1382: -- ----------------------------------------------------------------------------

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

1416: l_api_updating boolean;
1417: --
1418: Begin
1419: --
1420: hr_utility.set_location('Entering:'||l_proc, 5);
1421: --
1422: l_api_updating := ben_peo_shd.api_updating
1423: (p_elig_to_prte_rsn_id => p_elig_to_prte_rsn_id,
1424: p_effective_date => p_effective_date,

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

1447: end if;
1448: --
1449: end if;
1450: --
1451: hr_utility.set_location('Leaving:'||l_proc,10);
1452: --
1453: end chk_mx_poe_apls_cd;
1454: --
1455: -- ----------------------------------------------------------------------------

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

1503: end;
1504: --
1505: Begin
1506: --
1507: hr_utility.set_location('Entering:'||l_proc, 5);
1508: --
1509: -- check that only one of the ID's is populated.
1510: --
1511: if count_them(p_id => p_pgm_id) +

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

1518: fnd_message.raise_error;
1519: --
1520: end if;
1521: --
1522: hr_utility.set_location('Leaving:'||l_proc, 5);
1523: --
1524: end chk_only_one_fk;
1525: -- ----------------------------------------------------------------------------
1526: -- |--------------------------< dt_update_validate >--------------------------|

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

1566: l_integrity_error Exception;
1567: l_table_name all_tables.table_name%TYPE;
1568: --
1569: Begin
1570: hr_utility.set_location('Entering:'||l_proc, 5);
1571: --
1572: -- Ensure that the p_datetrack_mode argument is not null
1573: --
1574: hr_api.mandatory_arg_error

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

1655: End If;
1656: --
1657: End If;
1658: --
1659: hr_utility.set_location(' Leaving:'||l_proc, 10);
1660: Exception
1661: When l_integrity_error Then
1662: --
1663: -- A referential integrity check was violated therefore

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

1662: --
1663: -- A referential integrity check was violated therefore
1664: -- we must error
1665: --
1666: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1667: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1668: hr_utility.raise_error;
1669: When Others Then
1670: --

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

1663: -- A referential integrity check was violated therefore
1664: -- we must error
1665: --
1666: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1667: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1668: hr_utility.raise_error;
1669: When Others Then
1670: --
1671: -- An unhandled or unexpected error has occurred which

Line 1668: hr_utility.raise_error;

1664: -- we must error
1665: --
1666: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1667: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1668: hr_utility.raise_error;
1669: When Others Then
1670: --
1671: -- An unhandled or unexpected error has occurred which
1672: -- we must report

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

1670: --
1671: -- An unhandled or unexpected error has occurred which
1672: -- we must report
1673: --
1674: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1675: hr_utility.set_message_token('PROCEDURE', l_proc);
1676: hr_utility.set_message_token('STEP','15');
1677: hr_utility.raise_error;
1678: End dt_update_validate;

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

1671: -- An unhandled or unexpected error has occurred which
1672: -- we must report
1673: --
1674: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1675: hr_utility.set_message_token('PROCEDURE', l_proc);
1676: hr_utility.set_message_token('STEP','15');
1677: hr_utility.raise_error;
1678: End dt_update_validate;
1679: --

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

1672: -- we must report
1673: --
1674: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1675: hr_utility.set_message_token('PROCEDURE', l_proc);
1676: hr_utility.set_message_token('STEP','15');
1677: hr_utility.raise_error;
1678: End dt_update_validate;
1679: --
1680: -- ----------------------------------------------------------------------------

Line 1677: hr_utility.raise_error;

1673: --
1674: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1675: hr_utility.set_message_token('PROCEDURE', l_proc);
1676: hr_utility.set_message_token('STEP','15');
1677: hr_utility.raise_error;
1678: End dt_update_validate;
1679: --
1680: -- ----------------------------------------------------------------------------
1681: -- |--------------------------< dt_delete_validate >--------------------------|

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

1722: l_rows_exist Exception;
1723: l_table_name all_tables.table_name%TYPE;
1724: --
1725: Begin
1726: hr_utility.set_location('Entering:'||l_proc, 5);
1727: --
1728: -- Ensure that the p_datetrack_mode argument is not null
1729: --
1730: hr_api.mandatory_arg_error

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

1759: --
1760: --
1761: End If;
1762: --
1763: hr_utility.set_location(' Leaving:'||l_proc, 10);
1764: Exception
1765: When l_rows_exist Then
1766: --
1767: -- A referential integrity check was violated therefore

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

1766: --
1767: -- A referential integrity check was violated therefore
1768: -- we must error
1769: --
1770: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1771: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1772: hr_utility.raise_error;
1773: When Others Then
1774: --

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

1767: -- A referential integrity check was violated therefore
1768: -- we must error
1769: --
1770: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1771: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1772: hr_utility.raise_error;
1773: When Others Then
1774: --
1775: -- An unhandled or unexpected error has occurred which

Line 1772: hr_utility.raise_error;

1768: -- we must error
1769: --
1770: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1771: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1772: hr_utility.raise_error;
1773: When Others Then
1774: --
1775: -- An unhandled or unexpected error has occurred which
1776: -- we must report

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

1774: --
1775: -- An unhandled or unexpected error has occurred which
1776: -- we must report
1777: --
1778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1779: hr_utility.set_message_token('PROCEDURE', l_proc);
1780: hr_utility.set_message_token('STEP','15');
1781: hr_utility.raise_error;
1782: End dt_delete_validate;

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

1775: -- An unhandled or unexpected error has occurred which
1776: -- we must report
1777: --
1778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1779: hr_utility.set_message_token('PROCEDURE', l_proc);
1780: hr_utility.set_message_token('STEP','15');
1781: hr_utility.raise_error;
1782: End dt_delete_validate;
1783: --

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

1776: -- we must report
1777: --
1778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1779: hr_utility.set_message_token('PROCEDURE', l_proc);
1780: hr_utility.set_message_token('STEP','15');
1781: hr_utility.raise_error;
1782: End dt_delete_validate;
1783: --
1784: -- ----------------------------------------------------------------------------

Line 1781: hr_utility.raise_error;

1777: --
1778: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1779: hr_utility.set_message_token('PROCEDURE', l_proc);
1780: hr_utility.set_message_token('STEP','15');
1781: hr_utility.raise_error;
1782: End dt_delete_validate;
1783: --
1784: -- ----------------------------------------------------------------------------
1785: -- |---------------------------< insert_validate >----------------------------|

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

1793: --
1794: l_proc varchar2(72) := g_package||'insert_validate';
1795: --
1796: Begin
1797: hr_utility.set_location('Entering:'||l_proc, 5);
1798: --
1799: -- Call all supporting business operations
1800: --
1801: --

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

1932: chk_cd_rl_combination
1933: (p_vrfy_fmly_mmbr_cd => p_rec.vrfy_fmly_mmbr_cd,
1934: p_vrfy_fmly_mmbr_rl => p_rec.vrfy_fmly_mmbr_rl);
1935: --
1936: hr_utility.set_location(' Leaving:'||l_proc, 10);
1937: --
1938: End insert_validate;
1939: --
1940: -- ----------------------------------------------------------------------------

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

1952: l_proc varchar2(72) := g_package||'update_validate';
1953: --
1954: Begin
1955: --
1956: hr_utility.set_location('Entering:'||l_proc, 5);
1957: --
1958: -- Call all supporting business operations
1959: --
1960: --

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

2097: chk_cd_rl_combination
2098: (p_vrfy_fmly_mmbr_cd => p_rec.vrfy_fmly_mmbr_cd,
2099: p_vrfy_fmly_mmbr_rl => p_rec.vrfy_fmly_mmbr_rl);
2100: --
2101: hr_utility.set_location(' Leaving:'||l_proc, 10);
2102: --
2103: End update_validate;
2104: --
2105: -- ----------------------------------------------------------------------------

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

2114: --
2115: l_proc varchar2(72) := g_package||'delete_validate';
2116: --
2117: Begin
2118: hr_utility.set_location('Entering:'||l_proc, 5);
2119: --
2120: -- Call all supporting business operations
2121: --
2122: dt_delete_validate

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

2124: p_validation_start_date => p_validation_start_date,
2125: p_validation_end_date => p_validation_end_date,
2126: p_elig_to_prte_rsn_id => p_rec.elig_to_prte_rsn_id);
2127: --
2128: hr_utility.set_location(' Leaving:'||l_proc, 10);
2129: --
2130: End delete_validate;
2131: --
2132: -- ---------------------------------------------------------------------------

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

2152: --
2153: begin
2154: --
2155: --
2156: hr_utility.set_location('Entering:'|| l_proc, 10);
2157: --
2158: -- Ensure that all the mandatory parameter are not null
2159: --
2160: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 2174: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

2170: close csr_leg_code;
2171: --
2172: -- The primary key is invalid therefore we must error
2173: --
2174: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2175: hr_utility.raise_error;
2176: --
2177: end if;
2178: --

Line 2175: hr_utility.raise_error;

2171: --
2172: -- The primary key is invalid therefore we must error
2173: --
2174: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2175: hr_utility.raise_error;
2176: --
2177: end if;
2178: --
2179: close csr_leg_code;

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

2177: end if;
2178: --
2179: close csr_leg_code;
2180: --
2181: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2182: --
2183: return l_legislation_code;
2184: --
2185: end return_legislation_code;