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

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

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

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

72: end if;
73: --
74: end if;
75: --
76: hr_utility.set_location('Leaving:'||l_proc, 10);
77: --
78: End chk_oipl_id;
79: -- ----------------------------------------------------------------------------
80: -- |----------------------------< chk_dflt_flag >-----------------------------|

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_cop_shd.api_updating
118: (p_oipl_id => p_oipl_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_dflt_flag;
149: -- ----------------------------------------------------------------------------
150: -- |----------------------------< chk_mndtry_flag >---------------------------|

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

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

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

212: end if;
213: --
214: end if;
215: --
216: hr_utility.set_location('Leaving:'||l_proc,10);
217: --
218: end chk_mndtry_flag;
219: -- ----------------------------------------------------------------------------
220: -- |----------------------------< chk_elig_apls_flag >------------------------|

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

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

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

282: end if;
283: --
284: end if;
285: --
286: hr_utility.set_location('Leaving:'||l_proc,10);
287: --
288: end chk_elig_apls_flag;
289: -- ----------------------------------------------------------------------------
290: -- |----------------------------< chk_trk_inelig_per_flag >-------------------|

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

321: l_api_updating boolean;
322: --
323: Begin
324: --
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: l_api_updating := ben_cop_shd.api_updating
328: (p_oipl_id => p_oipl_id,
329: p_effective_date => p_effective_date,

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

352: end if;
353: --
354: end if;
355: --
356: hr_utility.set_location('Leaving:'||l_proc,10);
357: --
358: end chk_trk_inelig_per_flag;
359: -- ----------------------------------------------------------------------------
360: -- |---------------------------< chk_drvbl_fctr_prtn_elig_flag >--------------|

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

392: l_api_updating boolean;
393: --
394: Begin
395: --
396: hr_utility.set_location('Entering:'||l_proc, 5);
397: --
398: l_api_updating := ben_cop_shd.api_updating
399: (p_oipl_id => p_oipl_id,
400: p_effective_date => p_effective_date,

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

423: end if;
424: --
425: end if;
426: --
427: hr_utility.set_location('Leaving:'||l_proc,10);
428: --
429: end chk_drvbl_fctr_prtn_elig_flag;
430: -- ----------------------------------------------------------------------------
431: -- |----------------------------< chk_prtn_elig_ovrid_alwd_flag >-------------|

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

463: l_api_updating boolean;
464: --
465: Begin
466: --
467: hr_utility.set_location('Entering:'||l_proc, 5);
468: --
469: l_api_updating := ben_cop_shd.api_updating
470: (p_oipl_id => p_oipl_id,
471: p_effective_date => p_effective_date,

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

494: end if;
495: --
496: end if;
497: --
498: hr_utility.set_location('Leaving:'||l_proc,10);
499: --
500: end chk_prtn_elig_ovrid_alwd_flag;
501: -- ----------------------------------------------------------------------------
502: -- |---------------------------< chk_drvbl_fctr_apls_rts_flag >---------------|

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

534: l_api_updating boolean;
535: --
536: Begin
537: --
538: hr_utility.set_location('Entering:'||l_proc, 5);
539: --
540: l_api_updating := ben_cop_shd.api_updating
541: (p_oipl_id => p_oipl_id,
542: p_effective_date => p_effective_date,

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

565: end if;
566: --
567: end if;
568: --
569: hr_utility.set_location('Leaving:'||l_proc,10);
570: --
571: end chk_drvbl_fctr_apls_rts_flag;
572: -- ----------------------------------------------------------------------------
573: -- |-----------------------< chk_oipl_stat_cd >-------------------------------|

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

604: l_api_updating boolean;
605: --
606: Begin
607: --
608: hr_utility.set_location('Entering:'||l_proc, 5);
609: --
610: l_api_updating := ben_cop_shd.api_updating
611: (p_oipl_id => p_oipl_id,
612: p_effective_date => p_effective_date,

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

635: end if;
636: --
637: end if;
638: --
639: hr_utility.set_location('Leaving:'||l_proc,10);
640: --
641: end chk_oipl_stat_cd;
642: -- ----------------------------------------------------------------------------
643: -- |-----------------------< chk_pcp_dsgn_cd >-------------------------------|

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

674: l_api_updating boolean;
675: --
676: Begin
677: --
678: hr_utility.set_location('Entering:'||l_proc, 5);
679: --
680: l_api_updating := ben_cop_shd.api_updating
681: (p_oipl_id => p_oipl_id,
682: p_effective_date => p_effective_date,

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

705: end if;
706: --
707: end if;
708: --
709: hr_utility.set_location('Leaving:'||l_proc,10);
710: --
711: end chk_pcp_dsgn_cd;
712: --
713: -- -------------------------------------------------------------------------------

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

745: l_api_updating boolean;
746: --
747: Begin
748: --
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: l_api_updating := ben_cop_shd.api_updating
752: (p_oipl_id => p_oipl_id,
753: 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_pcp_dpnt_dsgn_cd;
783: -- ----------------------------------------------------------------------------
784: -- |-----------------------< chk_auto_enrt_flag >-----------------------------|

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

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

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

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

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

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

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

917: end if;
918: --
919: end if;
920: --
921: hr_utility.set_location('Leaving:'||l_proc,10);
922: --
923: end chk_vrfy_fmly_mmbr_cd;
924: -- ---------------------------------------------------------------------
925: -- |------------------< chk_enrt_cd >-------------------------------|

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

956: l_api_updating boolean;
957: --
958: Begin
959: --
960: hr_utility.set_location('Entering:'||l_proc, 5);
961: --
962: l_api_updating := ben_cop_shd.api_updating
963: (p_oipl_id => p_oipl_id,
964: p_effective_date => p_effective_date,

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

987: end if;
988: --
989: end if;
990: --
991: hr_utility.set_location('Leaving:'||l_proc,10);
992: --
993: end chk_enrt_cd;
994: -- ----------------------------------------------------------------------------
995: -- |-----------------------< chk_dflt_enrt_cd >-------------------------------|

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

1026: l_api_updating boolean;
1027: --
1028: Begin
1029: --
1030: hr_utility.set_location('Entering:'||l_proc, 5);
1031: --
1032: l_api_updating := ben_cop_shd.api_updating
1033: (p_oipl_id => p_oipl_id,
1034: p_effective_date => p_effective_date,

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

1057: end if;
1058: --
1059: end if;
1060: --
1061: hr_utility.set_location('Leaving:'||l_proc,10);
1062: --
1063: end chk_dflt_enrt_cd;
1064: -- ----------------------------------------------------------------------------
1065: -- |--------------------------< chk_auto_enrt_mthd_rl >-----------------------|

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

1097: l_api_updating boolean;
1098: --
1099: Begin
1100: --
1101: hr_utility.set_location('Entering:'||l_proc, 5);
1102: --
1103: l_api_updating := ben_cop_shd.api_updating
1104: (p_oipl_id => p_oipl_id,
1105: p_effective_date => p_effective_date,

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

1129: end if;
1130: --
1131: end if;
1132: --
1133: hr_utility.set_location('Leaving:'||l_proc,10);
1134: --
1135: end chk_auto_enrt_mthd_rl;
1136: --
1137: -- ----------------------------------------------------------------------------

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

1171: --
1172: --
1173: Begin
1174: --
1175: hr_utility.set_location('Entering:'||l_proc, 5);
1176: --
1177: l_api_updating := ben_cop_shd.api_updating
1178: (p_oipl_id => p_oipl_id,
1179: p_effective_date => p_effective_date,

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

1203: end if;
1204: --
1205: end if;
1206: --
1207: hr_utility.set_location('Leaving:'||l_proc,10);
1208: --
1209: end chk_dflt_enrt_det_rl;
1210: -- ----------------------------------------------------------------------------
1211: -- |--------------------------< chk_mndtry_rl >-------------------------------|

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

1243: l_api_updating boolean;
1244: --
1245: Begin
1246: --
1247: hr_utility.set_location('Entering:'||l_proc, 5);
1248: --
1249: l_api_updating := ben_cop_shd.api_updating
1250: (p_oipl_id => p_oipl_id,
1251: p_effective_date => p_effective_date,

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

1275: end if;
1276: --
1277: end if;
1278: --
1279: hr_utility.set_location('Leaving:'||l_proc,10);
1280: --
1281: end chk_mndtry_rl;
1282: -- ----------------------------------------------------------------------------
1283: -- |-------------------< chk_rqd_perd_enrt_nenrt_rl >-------------------------|

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

1315: l_api_updating boolean;
1316: --
1317: Begin
1318: --
1319: hr_utility.set_location('Entering:'||l_proc, 5);
1320: --
1321: l_api_updating := ben_cop_shd.api_updating
1322: (p_oipl_id => p_oipl_id,
1323: p_effective_date => p_effective_date,

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

1347: end if;
1348: --
1349: end if;
1350: --
1351: hr_utility.set_location('Leaving:'||l_proc,10);
1352: --
1353: end chk_rqd_perd_enrt_nenrt_rl;
1354: -- ----------------------------------------------------------------------------
1355: -- |------------------------< chk_postelcn_edit_rl >--------------------------|

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

1387: l_api_updating boolean;
1388: --
1389: Begin
1390: --
1391: hr_utility.set_location('Entering:'||l_proc, 5);
1392: --
1393: l_api_updating := ben_cop_shd.api_updating
1394: (p_oipl_id => p_oipl_id,
1395: p_effective_date => p_effective_date,

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

1419: end if;
1420: --
1421: end if;
1422: --
1423: hr_utility.set_location('Leaving:'||l_proc,10);
1424: --
1425: end chk_postelcn_edit_rl;
1426: -- ----------------------------------------------------------------------------
1427: -- |--------------------------< chk_vrfy_fmly_mmbr_rl >-----------------------|

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

1459: l_api_updating boolean;
1460: --
1461: Begin
1462: --
1463: hr_utility.set_location('Entering:'||l_proc, 5);
1464: --
1465: l_api_updating := ben_cop_shd.api_updating
1466: (p_oipl_id => p_oipl_id,
1467: p_effective_date => p_effective_date,

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

1491: end if;
1492: --
1493: end if;
1494: --
1495: hr_utility.set_location('Leaving:'||l_proc,10);
1496: --
1497: end chk_vrfy_fmly_mmbr_rl;
1498: --
1499: -- ----------------------------------------------------------------------------

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

1532: l_api_updating boolean;
1533: --
1534: Begin
1535: --
1536: hr_utility.set_location('Entering:'||l_proc, 5);
1537: --
1538: l_api_updating := ben_cop_shd.api_updating
1539: (p_oipl_id => p_oipl_id,
1540: p_effective_date => p_effective_date,

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

1564: end if;
1565: --
1566: end if;
1567: --
1568: hr_utility.set_location('Leaving:'||l_proc,10);
1569: --
1570: end chk_enrt_rl;
1571: -- ----------------------------------------------------------------------------
1572: -- |--------------------------< chk_cd_rl_combination >-------------------------------|

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

1599: p_dflt_enrt_cd in varchar2,
1600: p_dflt_enrt_det_rl in number ) IS
1601: l_proc varchar2(72) := g_package||'chk_cd_rl_combination';
1602: BEGIN
1603: hr_utility.set_location('Entering:'||l_proc, 5);
1604: --
1605: if (p_dflt_enrt_cd <> 'RL' and p_dflt_enrt_det_rl is not null)
1606: then
1607: fnd_message.set_name('BEN','BEN_91730_NO_RULE');

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

1614: end if;
1615: --
1616: -- Leaving Procedure.
1617: --
1618: hr_utility.set_location('Leaving:'||l_proc,10);
1619: END;
1620: --
1621: -- ----------------------------------------------------------------------------
1622: -- |-----------------------< chk_auto_enrt_and_mthd >--------------------------|

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

1665: and pl.business_group_id + 0 = p_business_group_id;
1666: --
1667: Begin
1668: --
1669: hr_utility.set_location('Entering:'||l_proc, 5);
1670: --
1671: if p_auto_enrt_flag = 'Y' then
1672: open c1;
1673: --

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

1687: close c1;
1688: end if;
1689: --
1690: --
1691: hr_utility.set_location('Leaving:'||l_proc, 10);
1692: --
1693: End chk_auto_enrt_and_mthd;
1694: --
1695: -- ----------------------------------------------------------------------------

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

1724: l_proc varchar2(72) := g_package||'chk_auto_enrt_and_flags';
1725: --
1726: Begin
1727: --
1728: hr_utility.set_location('Entering:'||l_proc, 5);
1729: --
1730: if p_auto_enrt_flag = 'Y' and
1731: (p_mndtry_flag = 'Y' or p_dflt_flag = 'Y') then
1732: --

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

1739: --
1740: end if;
1741: --
1742: --
1743: hr_utility.set_location('Leaving:'||l_proc, 10);
1744: --
1745: End chk_auto_enrt_and_flags;
1746: --
1747: -- ----------------------------------------------------------------------------

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

1794: and a.business_group_id = p_business_group_id;
1795: --
1796: Begin
1797: --
1798: hr_utility.set_location('Entering:'||l_proc, 5);
1799: --
1800: l_api_updating := ben_cop_shd.api_updating
1801: (p_effective_date => p_effective_date,
1802: p_oipl_id => p_oipl_id,

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

1822: close c1;
1823: --
1824: end if;
1825: --
1826: hr_utility.set_location('Leaving:'||l_proc, 10);
1827: --
1828: End chk_plan_pcp_before_oipl;
1829: --
1830: -- ----------------------------------------------------------------------------

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

1876: and a.effective_end_date;
1877: --
1878: Begin
1879: --
1880: hr_utility.set_location('Entering:'||l_proc, 5);
1881: --
1882: l_api_updating := ben_cop_shd.api_updating
1883: (p_effective_date => p_effective_date,
1884: p_oipl_id => p_oipl_id,

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

1906: close c1;
1907: --
1908: end if;
1909: --
1910: hr_utility.set_location('Leaving:'||l_proc, 10);
1911: --
1912: End chk_plan_oipl_mutexcl;
1913: --
1914: -- ----------------------------------------------------------------------------

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

1978: -- End of CAGR band aid.
1979: --
1980: Begin
1981: --
1982: hr_utility.set_location('Entering:'||l_proc,5);
1983: --
1984: l_api_updating := ben_cop_shd.api_updating
1985: (p_oipl_id => p_oipl_id,
1986: p_effective_date => p_effective_date,

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

2008: close c1;
2009: --
2010: end if;
2011: --
2012: hr_utility.set_location('Leaving:'||l_proc,10);
2013: --
2014: End chk_opt_id;
2015: --
2016: --

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

2065: and p_validation_end_date >= effective_start_date;
2066: --
2067: Begin
2068: --
2069: hr_utility.set_location('Entering:'||l_proc,5);
2070: --
2071: l_api_updating := ben_cop_shd.api_updating
2072: (p_oipl_id => p_oipl_id,
2073: p_effective_date => p_effective_date,

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

2095: close c1;
2096: --
2097: end if;
2098: --
2099: hr_utility.set_location('Leaving:'||l_proc,10);
2100: --
2101: End chk_ordr_num_unq_in_plan;
2102: --
2103: -- ----------------------------------------------------------------------------

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

2144: l_integrity_error Exception;
2145: l_table_name all_tables.table_name%TYPE;
2146: --
2147: Begin
2148: hr_utility.set_location('Entering:'||l_proc, 5);
2149: --
2150: -- Ensure that the p_datetrack_mode argument is not null
2151: --
2152: hr_api.mandatory_arg_error

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

2233: End If;
2234: --
2235: End If;
2236: --
2237: hr_utility.set_location(' Leaving:'||l_proc, 10);
2238: Exception
2239: When l_integrity_error Then
2240: --
2241: -- A referential integrity check was violated therefore

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

2240: --
2241: -- A referential integrity check was violated therefore
2242: -- we must error
2243: --
2244: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
2245: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2246: hr_utility.raise_error;
2247: When Others Then
2248: --

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

2241: -- A referential integrity check was violated therefore
2242: -- we must error
2243: --
2244: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
2245: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2246: hr_utility.raise_error;
2247: When Others Then
2248: --
2249: -- An unhandled or unexpected error has occurred which

Line 2246: hr_utility.raise_error;

2242: -- we must error
2243: --
2244: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
2245: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2246: hr_utility.raise_error;
2247: When Others Then
2248: --
2249: -- An unhandled or unexpected error has occurred which
2250: -- we must report

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

2248: --
2249: -- An unhandled or unexpected error has occurred which
2250: -- we must report
2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_update_validate;

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

2249: -- An unhandled or unexpected error has occurred which
2250: -- we must report
2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_update_validate;
2257: --

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

2250: -- we must report
2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_update_validate;
2257: --
2258: -- ----------------------------------------------------------------------------

Line 2255: hr_utility.raise_error;

2251: --
2252: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2253: hr_utility.set_message_token('PROCEDURE', l_proc);
2254: hr_utility.set_message_token('STEP','15');
2255: hr_utility.raise_error;
2256: End dt_update_validate;
2257: --
2258: -- ----------------------------------------------------------------------------
2259: -- |--------------------------< dt_delete_validate >--------------------------|

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

2312: from ben_elig_per_elctbl_chc epe
2313: where epe.oipl_id = p_oipl_id;
2314: --
2315: Begin
2316: hr_utility.set_location('Entering:'||l_proc, 5);
2317: --
2318: -- Ensure that the p_datetrack_mode argument is not null
2319: --
2320: hr_api.mandatory_arg_error

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

2436: End If;
2437: --
2438: End If;
2439: --
2440: hr_utility.set_location(' Leaving:'||l_proc, 10);
2441: Exception
2442: When l_rows_exist Then
2443: --
2444: -- A referential integrity check was violated therefore

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

2443: --
2444: -- A referential integrity check was violated therefore
2445: -- we must error
2446: --
2447: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
2448: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2449: hr_utility.raise_error;
2450: When Others Then
2451: Raise;

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

2444: -- A referential integrity check was violated therefore
2445: -- we must error
2446: --
2447: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
2448: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2449: hr_utility.raise_error;
2450: When Others Then
2451: Raise;
2452: --

Line 2449: hr_utility.raise_error;

2445: -- we must error
2446: --
2447: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
2448: hr_utility.set_message_token('TABLE_NAME', l_table_name);
2449: hr_utility.raise_error;
2450: When Others Then
2451: Raise;
2452: --
2453: -- An unhandled or unexpected error has occurred which

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

2452: --
2453: -- An unhandled or unexpected error has occurred which
2454: -- we must report
2455: --
2456: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2457: hr_utility.set_message_token('PROCEDURE', l_proc);
2458: hr_utility.set_message_token('STEP','15');
2459: hr_utility.raise_error;
2460: End dt_delete_validate;

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

2453: -- An unhandled or unexpected error has occurred which
2454: -- we must report
2455: --
2456: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2457: hr_utility.set_message_token('PROCEDURE', l_proc);
2458: hr_utility.set_message_token('STEP','15');
2459: hr_utility.raise_error;
2460: End dt_delete_validate;
2461: --

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

2454: -- we must report
2455: --
2456: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2457: hr_utility.set_message_token('PROCEDURE', l_proc);
2458: hr_utility.set_message_token('STEP','15');
2459: hr_utility.raise_error;
2460: End dt_delete_validate;
2461: --
2462: -- ----------------------------------------------------------------------------

Line 2459: hr_utility.raise_error;

2455: --
2456: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
2457: hr_utility.set_message_token('PROCEDURE', l_proc);
2458: hr_utility.set_message_token('STEP','15');
2459: hr_utility.raise_error;
2460: End dt_delete_validate;
2461: --
2462: -- ----------------------------------------------------------------------------
2463: -- |---------------------------< insert_validate >----------------------------|

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

2471: --
2472: l_proc varchar2(72) := g_package||'insert_validate';
2473: --
2474: Begin
2475: hr_utility.set_location('Entering:'||l_proc, 5);
2476: --
2477: -- Call all supporting business operations
2478: --
2479: --

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

2646: p_effective_date => p_effective_date,
2647: p_business_group_id => p_rec.business_group_id,
2648: p_object_version_number => p_rec.object_version_number);
2649: --
2650: hr_utility.set_location(' Leaving:'||l_proc, 10);
2651: End insert_validate;
2652: --
2653: -- ----------------------------------------------------------------------------
2654: -- |---------------------------< update_validate >----------------------------|

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

2662: --
2663: l_proc varchar2(72) := g_package||'update_validate';
2664: --
2665: Begin
2666: hr_utility.set_location('Entering:'||l_proc, 5);
2667: --
2668: -- Call all supporting business operations
2669: --
2670: --

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

2880: p_datetrack_mode => p_datetrack_mode,
2881: p_validation_start_date => p_validation_start_date,
2882: p_validation_end_date => p_validation_end_date);
2883: --
2884: hr_utility.set_location(' Leaving:'||l_proc, 10);
2885: End update_validate;
2886: --
2887: -- ----------------------------------------------------------------------------
2888: -- |---------------------------< delete_validate >----------------------------|

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

2898: --
2899:
2900: --
2901: Begin
2902: hr_utility.set_location('Entering:'||l_proc, 5);
2903:
2904: --
2905: -- Call all supporting business operations
2906: --

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

2909: p_validation_start_date => p_validation_start_date,
2910: p_validation_end_date => p_validation_end_date,
2911: p_oipl_id => p_rec.oipl_id);
2912: --
2913: hr_utility.set_location(' Leaving:'||l_proc, 10);
2914: --
2915: End delete_validate;
2916: --
2917: -- ---------------------------------------------------------------------------

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

2936: l_proc varchar2(72) := g_package||'return_legislation_code';
2937: --
2938: begin
2939: --
2940: hr_utility.set_location('Entering:'|| l_proc, 10);
2941: --
2942: -- Ensure that all the mandatory parameter are not null
2943: --
2944: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2961: end if;
2962: --
2963: close csr_leg_code;
2964: --
2965: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2966: --
2967: return l_legislation_code;
2968:
2969: --