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_LEN_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_len_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_lee_rsn_id => p_lee_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_lee_rsn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

109: l_proc varchar2(72) := g_package||'chk_inelig_and_dflts';
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'||l_proc, 5);
114: --
115: if ((p_dys_aftr_end_to_dflt_num is not null and
116: p_dys_no_enrl_not_elig_num is not null)and
117: (p_dys_no_enrl_not_elig_num < p_dys_aftr_end_to_dflt_num)) then

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

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

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

165: l_api_updating boolean;
166: --
167: Begin
168: --
169: hr_utility.set_location('Entering:'||l_proc, 5);
170: --
171: l_api_updating := ben_len_shd.api_updating
172: (p_lee_rsn_id => p_lee_rsn_id,
173: p_effective_date => p_effective_date,

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

197: end if;
198: --
199: end if;
200: --
201: hr_utility.set_location('Leaving:'||l_proc,10);
202: --
203: end chk_enrt_cvg_strt_dt_rl;
204: --
205: -- ----------------------------------------------------------------------------

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

238: l_api_updating boolean;
239: --
240: Begin
241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: l_api_updating := ben_len_shd.api_updating
245: (p_lee_rsn_id => p_lee_rsn_id,
246: p_effective_date => p_effective_date,

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

270: end if;
271: --
272: end if;
273: --
274: hr_utility.set_location('Leaving:'||l_proc,10);
275: --
276: end chk_enrt_cvg_end_dt_rl;
277: --
278: -- ----------------------------------------------------------------------------

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

311: l_api_updating boolean;
312: --
313: Begin
314: --
315: hr_utility.set_location('Entering:'||l_proc, 5);
316: --
317: l_api_updating := ben_len_shd.api_updating
318: (p_lee_rsn_id => p_lee_rsn_id,
319: p_effective_date => p_effective_date,

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

343: end if;
344: --
345: end if;
346: --
347: hr_utility.set_location('Leaving:'||l_proc,10);
348: --
349: end chk_rt_strt_dt_rl;
350: --
351: -- ----------------------------------------------------------------------------

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

383: l_api_updating boolean;
384: --
385: Begin
386: --
387: hr_utility.set_location('Entering:'||l_proc, 5);
388: --
389: l_api_updating := ben_len_shd.api_updating
390: (p_lee_rsn_id => p_lee_rsn_id,
391: p_effective_date => p_effective_date,

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

414: end if;
415: --
416: end if;
417: --
418: hr_utility.set_location('Leaving:'||l_proc,10);
419: --
420: end chk_rt_strt_dt_cd;
421: --
422:

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

456: l_api_updating boolean;
457: --
458: Begin
459: --
460: hr_utility.set_location('Entering:'||l_proc, 5);
461: --
462: l_api_updating := ben_len_shd.api_updating
463: (p_lee_rsn_id => p_lee_rsn_id,
464: p_effective_date => p_effective_date,

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

488: end if;
489: --
490: end if;
491: --
492: hr_utility.set_location('Leaving:'||l_proc,10);
493: --
494: end chk_rt_end_dt_rl;
495: --
496: -- ----------------------------------------------------------------------------

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

528: l_api_updating boolean;
529: --
530: Begin
531: --
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: l_api_updating := ben_len_shd.api_updating
535: (p_lee_rsn_id => p_lee_rsn_id,
536: p_effective_date => p_effective_date,

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

559: end if;
560: --
561: end if;
562: --
563: hr_utility.set_location('Leaving:'||l_proc,10);
564: --
565: end chk_rt_end_dt_cd;
566: --
567: -- ----------------------------------------------------------------------------

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

600: l_api_updating boolean;
601: --
602: Begin
603: --
604: hr_utility.set_location('Entering:'||l_proc, 5);
605: --
606: l_api_updating := ben_len_shd.api_updating
607: (p_lee_rsn_id => p_lee_rsn_id,
608: p_effective_date => p_effective_date,

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

632: end if;
633: --
634: end if;
635: --
636: hr_utility.set_location('Leaving:'||l_proc,10);
637: --
638: end chk_enrt_perd_end_dt_rl;
639: --
640: -- ----------------------------------------------------------------------------

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

672: l_api_updating boolean;
673: --
674: Begin
675: --
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: l_api_updating := ben_len_shd.api_updating
679: (p_lee_rsn_id => p_lee_rsn_id,
680: p_effective_date => p_effective_date,

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

703: end if;
704: --
705: end if;
706: --
707: hr_utility.set_location('Leaving:'||l_proc,10);
708: --
709: end chk_enrt_perd_end_dt_cd;
710: --
711: -- ----------------------------------------------------------------------------

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

744: l_api_updating boolean;
745: --
746: Begin
747: --
748: hr_utility.set_location('Entering:'||l_proc, 5);
749: --
750: l_api_updating := ben_len_shd.api_updating
751: (p_lee_rsn_id => p_lee_rsn_id,
752: p_effective_date => p_effective_date,

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

776: end if;
777: --
778: end if;
779: --
780: hr_utility.set_location('Leaving:'||l_proc,10);
781: --
782: end chk_enrt_perd_strt_dt_rl;
783: --
784: -- ----------------------------------------------------------------------------

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

816: l_api_updating boolean;
817: --
818: Begin
819: --
820: hr_utility.set_location('Entering:'||l_proc, 5);
821: --
822: l_api_updating := ben_len_shd.api_updating
823: (p_lee_rsn_id => p_lee_rsn_id,
824: p_effective_date => p_effective_date,

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

847: end if;
848: --
849: end if;
850: --
851: hr_utility.set_location('Leaving:'||l_proc,10);
852: --
853: end chk_enrt_perd_strt_dt_cd;
854: --
855: -- ----------------------------------------------------------------------------

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

887: l_api_updating boolean;
888: --
889: Begin
890: --
891: hr_utility.set_location('Entering:'||l_proc, 5);
892: --
893: l_api_updating := ben_len_shd.api_updating
894: (p_lee_rsn_id => p_lee_rsn_id,
895: p_effective_date => p_effective_date,

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

918: end if;
919: --
920: end if;
921: --
922: hr_utility.set_location('Leaving:'||l_proc,10);
923: --
924: end chk_enrt_cvg_strt_dt_cd;
925: --
926: --

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

959: l_api_updating boolean;
960: --
961: Begin
962: --
963: hr_utility.set_location('Entering:'||l_proc, 5);
964: --
965: l_api_updating := ben_len_shd.api_updating
966: (p_lee_rsn_id => p_lee_rsn_id,
967: p_effective_date => p_effective_date,

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

991: end if;
992: --
993: end if;
994: --
995: hr_utility.set_location('Leaving:'||l_proc,10);
996: --
997: end chk_reinstate_ovrdn_cd;
998: --
999: -- ----------------------------------------------------------------------------

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

1031: l_api_updating boolean;
1032: --
1033: Begin
1034: --
1035: hr_utility.set_location('Entering:'||l_proc, 5);
1036: --
1037: l_api_updating := ben_len_shd.api_updating
1038: (p_lee_rsn_id => p_lee_rsn_id,
1039: p_effective_date => p_effective_date,

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

1063: end if;
1064: --
1065: end if;
1066: --
1067: hr_utility.set_location('Leaving:'||l_proc,10);
1068: --
1069: end chk_reinstate_cd;
1070: -- ----------------------------------------------------------------------------
1071: -- |------< chk_enrt_cvg_end_dt_cd >------|

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

1102: l_api_updating boolean;
1103: --
1104: Begin
1105: --
1106: hr_utility.set_location('Entering:'||l_proc, 5);
1107: --
1108: l_api_updating := ben_len_shd.api_updating
1109: (p_lee_rsn_id => p_lee_rsn_id,
1110: p_effective_date => p_effective_date,

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

1133: end if;
1134: --
1135: end if;
1136: --
1137: hr_utility.set_location('Leaving:'||l_proc,10);
1138: --
1139: end chk_enrt_cvg_end_dt_cd;
1140: --
1141: -- ----------------------------------------------------------------------------

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

1173: l_api_updating boolean;
1174: --
1175: Begin
1176: --
1177: hr_utility.set_location('Entering:'||l_proc, 5);
1178: --
1179: l_api_updating := ben_len_shd.api_updating
1180: (p_lee_rsn_id => p_lee_rsn_id,
1181: p_effective_date => p_effective_date,

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

1204: end if;
1205: --
1206: end if;
1207: --
1208: hr_utility.set_location('Leaving:'||l_proc,10);
1209: --
1210: end chk_cls_enrt_dt_to_use_cd;
1211: --
1212: --

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

1241: l_proc varchar2(72) := g_package||'chk_code_rule_dpnd';
1242: --
1243: Begin
1244: --
1245: hr_utility.set_location('Entering:'||l_proc, 5);
1246: --
1247: if p_code <> 'RL' and p_rule is not null then
1248: --
1249: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

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

1255: fnd_message.raise_error;
1256: --
1257: end if;
1258: --
1259: hr_utility.set_location('Leaving:'||l_proc,10);
1260: --
1261: end chk_code_rule_dpnd;
1262:
1263:

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

1272: l_proc varchar2(72) := g_package||'chk_code_number_dpnd';
1273: --
1274: Begin
1275: --
1276: hr_utility.set_location('Entering:'||l_proc, 5);
1277:
1278: --
1279: /* Bug-4331059, Commented following check because number of days from start and end can take
1280: any value ( Including zero)

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

1318: end if ;
1319:
1320:
1321: --
1322: hr_utility.set_location('Leaving:'||l_proc,10);
1323: --
1324: end chk_code_number_dpnd;
1325: --
1326: -- CWBGLOBAL

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

1369:
1370: begin
1371:
1372:
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --hr_utility.set_location('p_ler_id:'||p_ler_id, 5.5);
1375: --hr_utility.set_location('p_lee_rsn_id:'||p_lee_rsn_id, 5.51);
1376: --hr_utility.set_location('p_popl_enrt_typ_cycl_id:'||p_popl_enrt_typ_cycl_id, 5.52);
1377:

Line 1374: --hr_utility.set_location('p_ler_id:'||p_ler_id, 5.5);

1370: begin
1371:
1372:
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --hr_utility.set_location('p_ler_id:'||p_ler_id, 5.5);
1375: --hr_utility.set_location('p_lee_rsn_id:'||p_lee_rsn_id, 5.51);
1376: --hr_utility.set_location('p_popl_enrt_typ_cycl_id:'||p_popl_enrt_typ_cycl_id, 5.52);
1377:
1378: open c_duplicate_ler;

Line 1375: --hr_utility.set_location('p_lee_rsn_id:'||p_lee_rsn_id, 5.51);

1371:
1372:
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --hr_utility.set_location('p_ler_id:'||p_ler_id, 5.5);
1375: --hr_utility.set_location('p_lee_rsn_id:'||p_lee_rsn_id, 5.51);
1376: --hr_utility.set_location('p_popl_enrt_typ_cycl_id:'||p_popl_enrt_typ_cycl_id, 5.52);
1377:
1378: open c_duplicate_ler;
1379: fetch c_duplicate_ler into l_lee_rsn_id;

Line 1376: --hr_utility.set_location('p_popl_enrt_typ_cycl_id:'||p_popl_enrt_typ_cycl_id, 5.52);

1372:
1373: hr_utility.set_location('Entering:'||l_proc, 5);
1374: --hr_utility.set_location('p_ler_id:'||p_ler_id, 5.5);
1375: --hr_utility.set_location('p_lee_rsn_id:'||p_lee_rsn_id, 5.51);
1376: --hr_utility.set_location('p_popl_enrt_typ_cycl_id:'||p_popl_enrt_typ_cycl_id, 5.52);
1377:
1378: open c_duplicate_ler;
1379: fetch c_duplicate_ler into l_lee_rsn_id;
1380: if c_duplicate_ler%FOUND then

Line 1381: -- hr_utility.set_location('dupe found:', 5.53);

1377:
1378: open c_duplicate_ler;
1379: fetch c_duplicate_ler into l_lee_rsn_id;
1380: if c_duplicate_ler%FOUND then
1381: -- hr_utility.set_location('dupe found:', 5.53);
1382: close c_duplicate_ler;
1383: fnd_message.set_name ('PAY','VALUE IS NOT UNIQUE');
1384: fnd_message.raise_error;
1385: end if;

Line 1386: --hr_utility.set_location('NOT found:', 5.54);

1382: close c_duplicate_ler;
1383: fnd_message.set_name ('PAY','VALUE IS NOT UNIQUE');
1384: fnd_message.raise_error;
1385: end if;
1386: --hr_utility.set_location('NOT found:', 5.54);
1387: close c_duplicate_ler;
1388: hr_utility.set_location('Leaving:'||l_proc, 10);
1389: end chk_cwb_ler_id ;
1390: --

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

1384: fnd_message.raise_error;
1385: end if;
1386: --hr_utility.set_location('NOT found:', 5.54);
1387: close c_duplicate_ler;
1388: hr_utility.set_location('Leaving:'||l_proc, 10);
1389: end chk_cwb_ler_id ;
1390: --
1391: --------------------------------------------------------------------------------
1392: -- |----------------------< chk_defer_flag_set_pln_plip >--------------------|

Line 1440: hr_utility.set_location('Entering:'|| l_proc, 9653);

1436: l_proc varchar2(72) := g_package||'chk_defer_flag_set_pln_plip';
1437: --
1438: begin
1439: --
1440: hr_utility.set_location('Entering:'|| l_proc, 9653);
1441: --
1442: l_api_updating := ben_len_shd.api_updating
1443: (p_effective_date => p_effective_date,
1444: p_lee_rsn_id => p_lee_rsn_id,

Line 1469: hr_utility.set_location('Leaving:'|| l_proc, 9653);

1465: end if;
1466: --
1467: end if;
1468: --
1469: hr_utility.set_location('Leaving:'|| l_proc, 9653);
1470: --
1471: end chk_defer_flag_set_pln_plip;
1472: --
1473: ---- ----------------------------------------------------------------------------

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

1503: l_proc varchar2(72) := g_package||'chk_defer_flag_lookup';
1504: --
1505: begin
1506: --
1507: hr_utility.set_location('Entering:'|| l_proc, 9653);
1508: --
1509: l_api_updating := ben_len_shd.api_updating
1510: (p_effective_date => p_effective_date,
1511: p_lee_rsn_id => p_lee_rsn_id,

Line 1533: hr_utility.set_location('Leaving:'|| l_proc, 9653);

1529: end if;
1530: --
1531: end if;
1532: --
1533: hr_utility.set_location('Leaving:'|| l_proc, 9653);
1534: --
1535: end chk_defer_flag_lookup;
1536: --
1537: --

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

1575: l_integrity_error Exception;
1576: l_table_name all_tables.table_name%TYPE;
1577: --
1578: Begin
1579: hr_utility.set_location('Entering:'||l_proc, 5);
1580: --
1581: -- Ensure that the p_datetrack_mode argument is not null
1582: --
1583: hr_api.mandatory_arg_error

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

1614: End If;
1615: --
1616: End If;
1617: --
1618: hr_utility.set_location(' Leaving:'||l_proc, 10);
1619: Exception
1620: When l_integrity_error Then
1621: --
1622: -- A referential integrity check was violated therefore

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

1621: --
1622: -- A referential integrity check was violated therefore
1623: -- we must error
1624: --
1625: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1626: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1627: hr_utility.raise_error;
1628: When Others Then
1629: --

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

1622: -- A referential integrity check was violated therefore
1623: -- we must error
1624: --
1625: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1626: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1627: hr_utility.raise_error;
1628: When Others Then
1629: --
1630: -- An unhandled or unexpected error has occurred which

Line 1627: hr_utility.raise_error;

1623: -- we must error
1624: --
1625: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
1626: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1627: hr_utility.raise_error;
1628: When Others Then
1629: --
1630: -- An unhandled or unexpected error has occurred which
1631: -- we must report

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

1629: --
1630: -- An unhandled or unexpected error has occurred which
1631: -- we must report
1632: --
1633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1634: hr_utility.set_message_token('PROCEDURE', l_proc);
1635: hr_utility.set_message_token('STEP','15');
1636: hr_utility.raise_error;
1637: End dt_update_validate;

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

1630: -- An unhandled or unexpected error has occurred which
1631: -- we must report
1632: --
1633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1634: hr_utility.set_message_token('PROCEDURE', l_proc);
1635: hr_utility.set_message_token('STEP','15');
1636: hr_utility.raise_error;
1637: End dt_update_validate;
1638: --

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

1631: -- we must report
1632: --
1633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1634: hr_utility.set_message_token('PROCEDURE', l_proc);
1635: hr_utility.set_message_token('STEP','15');
1636: hr_utility.raise_error;
1637: End dt_update_validate;
1638: --
1639: -- ----------------------------------------------------------------------------

Line 1636: hr_utility.raise_error;

1632: --
1633: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1634: hr_utility.set_message_token('PROCEDURE', l_proc);
1635: hr_utility.set_message_token('STEP','15');
1636: hr_utility.raise_error;
1637: End dt_update_validate;
1638: --
1639: -- ----------------------------------------------------------------------------
1640: -- |--------------------------< dt_delete_validate >--------------------------|

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

1681: l_rows_exist Exception;
1682: l_table_name all_tables.table_name%TYPE;
1683: --
1684: Begin
1685: hr_utility.set_location('Entering:'||l_proc, 5);
1686: --
1687: -- Ensure that the p_datetrack_mode argument is not null
1688: --
1689: hr_api.mandatory_arg_error

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

1735: End If;
1736: --
1737: End If;
1738: --
1739: hr_utility.set_location(' Leaving:'||l_proc, 10);
1740: Exception
1741: When l_rows_exist Then
1742: --
1743: -- A referential integrity check was violated therefore

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

1742: --
1743: -- A referential integrity check was violated therefore
1744: -- we must error
1745: --
1746: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1747: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1748: hr_utility.raise_error;
1749: When Others Then
1750: --

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

1743: -- A referential integrity check was violated therefore
1744: -- we must error
1745: --
1746: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1747: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1748: hr_utility.raise_error;
1749: When Others Then
1750: --
1751: -- An unhandled or unexpected error has occurred which

Line 1748: hr_utility.raise_error;

1744: -- we must error
1745: --
1746: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
1747: hr_utility.set_message_token('TABLE_NAME', l_table_name);
1748: hr_utility.raise_error;
1749: When Others Then
1750: --
1751: -- An unhandled or unexpected error has occurred which
1752: -- we must report

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

1750: --
1751: -- An unhandled or unexpected error has occurred which
1752: -- we must report
1753: --
1754: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1755: hr_utility.set_message_token('PROCEDURE', l_proc);
1756: hr_utility.set_message_token('STEP','15');
1757: hr_utility.raise_error;
1758: End dt_delete_validate;

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

1751: -- An unhandled or unexpected error has occurred which
1752: -- we must report
1753: --
1754: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1755: hr_utility.set_message_token('PROCEDURE', l_proc);
1756: hr_utility.set_message_token('STEP','15');
1757: hr_utility.raise_error;
1758: End dt_delete_validate;
1759: --

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

1752: -- we must report
1753: --
1754: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1755: hr_utility.set_message_token('PROCEDURE', l_proc);
1756: hr_utility.set_message_token('STEP','15');
1757: hr_utility.raise_error;
1758: End dt_delete_validate;
1759: --
1760: -- ----------------------------------------------------------------------------

Line 1757: hr_utility.raise_error;

1753: --
1754: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
1755: hr_utility.set_message_token('PROCEDURE', l_proc);
1756: hr_utility.set_message_token('STEP','15');
1757: hr_utility.raise_error;
1758: End dt_delete_validate;
1759: --
1760: -- ----------------------------------------------------------------------------
1761: -- |---------------------------< insert_validate >----------------------------|

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

1769: --
1770: l_proc varchar2(72) := g_package||'insert_validate';
1771: --
1772: Begin
1773: hr_utility.set_location('Entering:'||l_proc, 5);
1774: --
1775: -- Call all supporting business operations
1776: --
1777: --

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

1936: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
1937: ,p_object_version_number => p_rec.object_version_number
1938: );
1939: --
1940: hr_utility.set_location(' Leaving:'||l_proc, 10);
1941: End insert_validate;
1942: --
1943: -- ----------------------------------------------------------------------------
1944: -- |---------------------------< update_validate >----------------------------|

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

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

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

2127: ,p_defer_deenrol_flag => p_rec.defer_deenrol_flag
2128: ,p_object_version_number => p_rec.object_version_number
2129: );
2130: --
2131: hr_utility.set_location(' Leaving:'||l_proc, 10);
2132: --
2133: End update_validate;
2134: --
2135: -- ----------------------------------------------------------------------------

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

2144: --
2145: l_proc varchar2(72) := g_package||'delete_validate';
2146: --
2147: Begin
2148: hr_utility.set_location('Entering:'||l_proc, 5);
2149: --
2150: -- Call all supporting business operations
2151: --
2152: dt_delete_validate

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

2154: p_validation_start_date => p_validation_start_date,
2155: p_validation_end_date => p_validation_end_date,
2156: p_lee_rsn_id => p_rec.lee_rsn_id);
2157: --
2158: hr_utility.set_location(' Leaving:'||l_proc, 10);
2159: End delete_validate;
2160: --
2161: --
2162: -- ---------------------------------------------------------------------------

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

2181: l_proc varchar2(72) := g_package||'return_legislation_code';
2182: --
2183: begin
2184: --
2185: hr_utility.set_location('Entering:'|| l_proc, 10);
2186: --
2187: -- Ensure that all the mandatory parameter are not null
2188: --
2189: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2199: close csr_leg_code;
2200: --
2201: -- The primary key is invalid therefore we must error
2202: --
2203: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2204: hr_utility.raise_error;
2205: --
2206: end if;
2207: --

Line 2204: hr_utility.raise_error;

2200: --
2201: -- The primary key is invalid therefore we must error
2202: --
2203: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
2204: hr_utility.raise_error;
2205: --
2206: end if;
2207: --
2208: close csr_leg_code;

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

2206: end if;
2207: --
2208: close csr_leg_code;
2209: --
2210: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2211: --
2212: return l_legislation_code;
2213: --
2214: end return_legislation_code;