42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pgm_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pgm_id => p_pgm_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_pgm_id;
78: --
79: -- ----------------------------------------------------------------------------
128: and ff.effective_end_date;
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_pgm_shd.api_updating
135: (p_pgm_id => p_pgm_id,
136: p_effective_date => p_effective_date,
164: close c1;
165: --
166: end if;
167: --
168: hr_utility.set_location('Leaving:'||l_proc,10);
169: --
170: end chk_auto_enrt_mthd_rl;
171: --
172:
198: p_vrfy_fmly_mmbr_cd in varchar2,
199: p_vrfy_fmly_mmbr_rl in number ) IS
200: l_proc varchar2(72) := g_package||'chk_cd_rl_combination';
201: BEGIN
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
205: then
206: fnd_message.set_name('BEN','BEN_91730_NO_RULE');
214: end if;
215: --
216: --leaving Procedure.
217: --
218: hr_utility.set_location('Leaving:'||l_proc,10);
219: --
220: end chk_cd_rl_combination;
221:
222: ---
273: and ff.effective_end_date;
274: --
275: Begin
276: --
277: hr_utility.set_location('Entering:'||l_proc, 5);
278: --
279: l_api_updating := ben_pgm_shd.api_updating
280: (p_pgm_id => p_pgm_id,
281: p_effective_date => p_effective_date,
309: close c1;
310: --
311: end if;
312: --
313: hr_utility.set_location('Leaving:'||l_proc,10);
314: --
315: end chk_enrt_rl;
316: --
317: -- ----------------------------------------------------------------------------
366: and ff.effective_end_date;
367: --
368: Begin
369: --
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: l_api_updating := ben_pgm_shd.api_updating
373: (p_pgm_id => p_pgm_id,
374: p_effective_date => p_effective_date,
402: close c1;
403: --
404: end if;
405: --
406: hr_utility.set_location('Leaving:'||l_proc,10);
407: --
408: end chk_enrt_cvg_strt_dt_rl;
409: --
410: -- ----------------------------------------------------------------------------
459: and ff.effective_end_date;
460: --
461: Begin
462: --
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: l_api_updating := ben_pgm_shd.api_updating
466: (p_pgm_id => p_pgm_id,
467: p_effective_date => p_effective_date,
495: close c1;
496: --
497: end if;
498: --
499: hr_utility.set_location('Leaving:'||l_proc,10);
500: --
501: end chk_enrt_cvg_end_dt_rl;
502: --
503:
511: l_api_updating boolean;
512: --
513: Begin
514: --
515: hr_utility.set_location('Entering:'||l_proc, 5);
516: --
517: l_api_updating := ben_pgm_shd.api_updating
518: (p_pgm_id => p_pgm_id,
519: p_effective_date => p_effective_date,
545:
546: --
547: end if;
548: --
549: hr_utility.set_location('Leaving:'||l_proc,10);
550: --
551: end chk_vrfy_fmly_mmbr_cd;
552:
553: -------------------------
566: l_api_updating boolean;
567: --
568: Begin
569: --
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: l_api_updating := ben_pgm_shd.api_updating
573: (p_effective_date => p_effective_date,
574: p_pgm_id => p_pgm_id,
599: end if;
600: --
601: end if;
602: --
603: hr_utility.set_location('Leaving:'||l_proc,10);
604: end chk_vrfy_fmly_mmbr_rl;
605: --
606:
607:
659: and ff.effective_end_date;
660: --
661: Begin
662: --
663: hr_utility.set_location('Entering:'||l_proc, 5);
664: --
665: l_api_updating := ben_pgm_shd.api_updating
666: (p_pgm_id => p_pgm_id,
667: p_effective_date => p_effective_date,
695: close c1;
696: --
697: end if;
698: --
699: hr_utility.set_location('Leaving:'||l_proc,10);
700: --
701: end chk_dpnt_cvg_strt_dt_rl;
702: --
703: -- ----------------------------------------------------------------------------
751: and ff.effective_end_date;
752: --
753: Begin
754: --
755: hr_utility.set_location('Entering:'||l_proc, 5);
756: --
757: l_api_updating := ben_pgm_shd.api_updating
758: (p_pgm_id => p_pgm_id,
759: p_effective_date => p_effective_date,
789: close c1;
790: --
791: end if;
792: --
793: hr_utility.set_location('Leaving:'||l_proc,10);
794: --
795: end chk_rt_end_dt_rl;
796: --
797: -- ----------------------------------------------------------------------------
845: and ff.effective_end_date;
846: --
847: Begin
848: --
849: hr_utility.set_location('Entering:'||l_proc, 5);
850: --
851: l_api_updating := ben_pgm_shd.api_updating
852: (p_pgm_id => p_pgm_id,
853: p_effective_date => p_effective_date,
883: close c1;
884: --
885: end if;
886: --
887: hr_utility.set_location('Leaving:'||l_proc,10);
888: --
889: end chk_rt_strt_dt_rl;
890: --
891: -- ----------------------------------------------------------------------------
940: and ff.effective_end_date;
941: --
942: Begin
943: --
944: hr_utility.set_location('Entering:'||l_proc, 5);
945: --
946: l_api_updating := ben_pgm_shd.api_updating
947: (p_pgm_id => p_pgm_id,
948: p_effective_date => p_effective_date,
976: close c1;
977: --
978: end if;
979: --
980: hr_utility.set_location('Leaving:'||l_proc,10);
981: --
982: end chk_dpnt_cvg_end_dt_rl;
983: --
984: /*
1032: and ff.effective_end_date;
1033: --
1034: Begin
1035: --
1036: hr_utility.set_location('Entering:'||l_proc, 5);
1037: --
1038: l_api_updating := ben_pgm_shd.api_updating
1039: (p_pgm_id => p_pgm_id,
1040: p_effective_date => p_effective_date,
1068: close c1;
1069: --
1070: end if;
1071: --
1072: hr_utility.set_location('Leaving:'||l_proc,10);
1073: --
1074: end chk_prtn_end_dt_rl;
1075: --
1076: --
1126: and ff.effective_end_date;
1127: --
1128: Begin
1129: --
1130: hr_utility.set_location('Entering:'||l_proc, 5);
1131: --
1132: l_api_updating := ben_pgm_shd.api_updating
1133: (p_pgm_id => p_pgm_id,
1134: p_effective_date => p_effective_date,
1162: close c1;
1163: --
1164: end if;
1165: --
1166: hr_utility.set_location('Leaving:'||l_proc,10);
1167: --
1168: end chk_prtn_strt_dt_rl;
1169: --
1170: */
1205: l_dummy varchar2(1);
1206: --
1207: Begin
1208: --
1209: hr_utility.set_location('Entering:'||l_proc, 5);
1210: --
1211: l_api_updating := ben_pgm_shd.api_updating
1212: (p_pgm_id => p_pgm_id,
1213: p_effective_date => p_effective_date,
1234: end if;
1235: --
1236: end if;
1237: --
1238: hr_utility.set_location('Leaving:'||l_proc,10);
1239: --
1240: end chk_dpnt_adrs_rqd_flag;
1241: --
1242: /*
1276: l_dummy varchar2(1);
1277: --
1278: Begin
1279: --
1280: hr_utility.set_location('Entering:'||l_proc, 5);
1281: --
1282: l_api_updating := ben_pgm_shd.api_updating
1283: (p_pgm_id => p_pgm_id,
1284: p_effective_date => p_effective_date,
1305: end if;
1306: --
1307: end if;
1308: --
1309: hr_utility.set_location('Leaving:'||l_proc,10);
1310: --
1311: end chk_elig_apls_to_all_pls_flag;
1312: --
1313: */
1347: l_dummy varchar2(1);
1348: --
1349: Begin
1350: --
1351: hr_utility.set_location('Entering:'||l_proc, 5);
1352: --
1353: l_api_updating := ben_pgm_shd.api_updating
1354: (p_pgm_id => p_pgm_id,
1355: p_effective_date => p_effective_date,
1376: end if;
1377: --
1378: end if;
1379: --
1380: hr_utility.set_location('Leaving:'||l_proc,10);
1381: --
1382: end chk_dpnt_dob_rqd_flag;
1383: --
1384: -- ----------------------------------------------------------------------------
1417: l_dummy varchar2(1);
1418: --
1419: Begin
1420: --
1421: hr_utility.set_location('Entering:'||l_proc, 5);
1422: --
1423: l_api_updating := ben_pgm_shd.api_updating
1424: (p_pgm_id => p_pgm_id,
1425: p_effective_date => p_effective_date,
1446: end if;
1447: --
1448: end if;
1449: --
1450: hr_utility.set_location('Leaving:'||l_proc,10);
1451: --
1452: end chk_pgm_prvd_no_auto_enrt_flag;
1453: --
1454: -- ----------------------------------------------------------------------------
1487: l_dummy varchar2(1);
1488: --
1489: Begin
1490: --
1491: hr_utility.set_location('Entering:'||l_proc, 5);
1492: --
1493: l_api_updating := ben_pgm_shd.api_updating
1494: (p_pgm_id => p_pgm_id,
1495: p_effective_date => p_effective_date,
1516: end if;
1517: --
1518: end if;
1519: --
1520: hr_utility.set_location('Leaving:'||l_proc,10);
1521: --
1522: end chk_pgm_prvd_no_dflt_enrt_flag;
1523: --
1524: -- ----------------------------------------------------------------------------
1557: l_dummy varchar2(1);
1558: --
1559: Begin
1560: --
1561: hr_utility.set_location('Entering:'||l_proc, 5);
1562: --
1563: l_api_updating := ben_pgm_shd.api_updating
1564: (p_pgm_id => p_pgm_id,
1565: p_effective_date => p_effective_date,
1586: end if;
1587: --
1588: end if;
1589: --
1590: hr_utility.set_location('Leaving:'||l_proc,10);
1591: --
1592: end chk_dpnt_legv_id_rqd_flag;
1593: --
1594: -- ----------------------------------------------------------------------------
1627: l_dummy varchar2(1);
1628: --
1629: Begin
1630: --
1631: hr_utility.set_location('Entering:'||l_proc, 5);
1632: --
1633: l_api_updating := ben_pgm_shd.api_updating
1634: (p_pgm_id => p_pgm_id,
1635: p_effective_date => p_effective_date,
1656: end if;
1657: --
1658: end if;
1659: --
1660: hr_utility.set_location('Leaving:'||l_proc,10);
1661: --
1662: end chk_elig_apls_flag;
1663: --
1664: -- ----------------------------------------------------------------------------
1697: l_dummy varchar2(1);
1698: --
1699: Begin
1700: --
1701: hr_utility.set_location('Entering:'||l_proc, 5);
1702: --
1703: l_api_updating := ben_pgm_shd.api_updating
1704: (p_pgm_id => p_pgm_id,
1705: p_effective_date => p_effective_date,
1726: end if;
1727: --
1728: end if;
1729: --
1730: hr_utility.set_location('Leaving:'||l_proc,10);
1731: --
1732: end chk_uses_all_asmts_for_rts_fla;
1733: --
1734: -- ----------------------------------------------------------------------------
1767: l_dummy varchar2(1);
1768: --
1769: Begin
1770: --
1771: hr_utility.set_location('Entering:'||l_proc, 5);
1772: --
1773: l_api_updating := ben_pgm_shd.api_updating
1774: (p_pgm_id => p_pgm_id,
1775: p_effective_date => p_effective_date,
1796: end if;
1797: --
1798: end if;
1799: --
1800: hr_utility.set_location('Leaving:'||l_proc,10);
1801: --
1802: end chk_prtn_elig_ovrid_alwd_flag;
1803:
1804: --
1839: l_dummy varchar2(1);
1840: --
1841: Begin
1842: --
1843: hr_utility.set_location('Entering:'||l_proc, 5);
1844: --
1845: l_api_updating := ben_pgm_shd.api_updating
1846: (p_pgm_id => p_pgm_id,
1847: p_effective_date => p_effective_date,
1868: end if;
1869: --
1870: end if;
1871: --
1872: hr_utility.set_location('Leaving:'||l_proc,10);
1873: --
1874: end chk_tmprl_fctr_apls_rts_flag;
1875: */
1876: --
1910: l_dummy varchar2(1);
1911: --
1912: Begin
1913: --
1914: hr_utility.set_location('Entering:'||l_proc, 5);
1915: --
1916: l_api_updating := ben_pgm_shd.api_updating
1917: (p_pgm_id => p_pgm_id,
1918: p_effective_date => p_effective_date,
1939: end if;
1940: --
1941: end if;
1942: --
1943: hr_utility.set_location('Leaving:'||l_proc,10);
1944: --
1945: end chk_pgm_use_all_asnt_elig_flag;
1946:
1947: --
1981: l_dummy varchar2(1);
1982: --
1983: Begin
1984: --
1985: hr_utility.set_location('Entering:'||l_proc, 5);
1986: --
1987: l_api_updating := ben_pgm_shd.api_updating
1988: (p_pgm_id => p_pgm_id,
1989: p_effective_date => p_effective_date,
2010: end if;
2011: --
2012: end if;
2013: --
2014: hr_utility.set_location('Leaving:'||l_proc,10);
2015: --
2016: end chk_coord_cvg_for_all_pls_flg;
2017:
2018: --
2052: l_dummy varchar2(1);
2053: --
2054: Begin
2055: --
2056: hr_utility.set_location('Entering:'||l_proc, 5);
2057: --
2058: l_api_updating := ben_pgm_shd.api_updating
2059: (p_pgm_id => p_pgm_id,
2060: p_effective_date => p_effective_date,
2081: end if;
2082: --
2083: end if;
2084: --
2085: hr_utility.set_location('Leaving:'||l_proc,10);
2086: --
2087: end chk_drvbl_fctr_dpnt_elig_flag;
2088:
2089: --
2124: l_dummy varchar2(1);
2125: --
2126: Begin
2127: --
2128: hr_utility.set_location('Entering:'||l_proc, 5);
2129: --
2130: l_api_updating := ben_pgm_shd.api_updating
2131: (p_pgm_id => p_pgm_id,
2132: p_effective_date => p_effective_date,
2153: end if;
2154: --
2155: end if;
2156: --
2157: hr_utility.set_location('Leaving:'||l_proc,10);
2158: --
2159: end chk_mt_one_dpnt_cvg_elig_flag;
2160: */
2161: --
2195: l_dummy varchar2(1);
2196: --
2197: Begin
2198: --
2199: hr_utility.set_location('Entering:'||l_proc, 5);
2200: --
2201: l_api_updating := ben_pgm_shd.api_updating
2202: (p_pgm_id => p_pgm_id,
2203: p_effective_date => p_effective_date,
2224: end if;
2225: --
2226: end if;
2227: --
2228: hr_utility.set_location('Leaving:'||l_proc,10);
2229: --
2230: end chk_drvbl_fctr_prtn_elig_flag;
2231:
2232: --
2268: l_dummy varchar2(1);
2269: --
2270: Begin
2271: --
2272: hr_utility.set_location('Entering:'||l_proc, 5);
2273: --
2274: l_api_updating := ben_pgm_shd.api_updating
2275: (p_pgm_id => p_pgm_id,
2276: p_effective_date => p_effective_date,
2297: end if;
2298: --
2299: end if;
2300: --
2301: hr_utility.set_location('Leaving:'||l_proc,10);
2302: --
2303: end chk_alws_unrstrctd_enrt_flag;
2304:
2305: -- ----------------------------------------------------------------------------
2338: l_dummy varchar2(1);
2339: --
2340: Begin
2341: --
2342: hr_utility.set_location('Entering:'||l_proc, 5);
2343: --
2344: l_api_updating := ben_pgm_shd.api_updating
2345: (p_pgm_id => p_pgm_id,
2346: p_effective_date => p_effective_date,
2367: end if;
2368: --
2369: end if;
2370: --
2371: hr_utility.set_location('Leaving:'||l_proc,10);
2372: --
2373: end chk_drvbl_fctr_apls_rts_flag;
2374:
2375: --
2410: l_dummy varchar2(1);
2411: --
2412: Begin
2413: --
2414: hr_utility.set_location('Entering:'||l_proc, 5);
2415: --
2416: l_api_updating := ben_pgm_shd.api_updating
2417: (p_pgm_id => p_pgm_id,
2418: p_effective_date => p_effective_date,
2439: end if;
2440: --
2441: end if;
2442: --
2443: hr_utility.set_location('Leaving:'||l_proc,10);
2444: --
2445: end chk_tmprl_fctr_dpnt_elig_flag;
2446:
2447: --
2481: l_dummy varchar2(1);
2482: --
2483: Begin
2484: --
2485: hr_utility.set_location('Entering:'||l_proc, 5);
2486: --
2487: l_api_updating := ben_pgm_shd.api_updating
2488: (p_pgm_id => p_pgm_id,
2489: p_effective_date => p_effective_date,
2510: end if;
2511: --
2512: end if;
2513: --
2514: hr_utility.set_location('Leaving:'||l_proc,10);
2515: --
2516: end chk_tmprl_fctr_prtn_elig_flag;
2517: */
2518: --
2552: l_dummy varchar2(1);
2553: --
2554: Begin
2555: --
2556: hr_utility.set_location('Entering:'||l_proc, 5);
2557: --
2558: l_api_updating := ben_pgm_shd.api_updating
2559: (p_pgm_id => p_pgm_id,
2560: p_effective_date => p_effective_date,
2581: end if;
2582: --
2583: end if;
2584: --
2585: hr_utility.set_location('Leaving:'||l_proc,10);
2586: --
2587: end chk_dpnt_dsgn_no_ctfn_rqd_flag;
2588:
2589: --
2623: l_dummy varchar2(1);
2624: --
2625: Begin
2626: --
2627: hr_utility.set_location('Entering:'||l_proc, 5);
2628: --
2629: l_api_updating := ben_pgm_shd.api_updating
2630: (p_pgm_id => p_pgm_id,
2631: p_effective_date => p_effective_date,
2652: end if;
2653: --
2654: end if;
2655: --
2656: hr_utility.set_location('Leaving:'||l_proc,10);
2657: --
2658: end chk_trk_inelig_per_flag;
2659:
2660: -- ----------------------------------------------------------------------------
2698: and end_date_active
2699: and enabled_flag = 'Y';
2700: --
2701: Begin
2702: hr_utility.set_location('Entering:'||l_proc, 5);
2703: if p_pgm_stat_cd is null then
2704: open c1;
2705: fetch c1 into l_pgm_stat;
2706: if c1%notfound then
2710: fnd_message.set_name('BEN','BEN_91350_PGM_STATUS_RQD');
2711: fnd_message.raise_error;
2712: end if;
2713: close c1;
2714: hr_utility.set_location('Leaving:'||l_proc, 10);
2715: return l_pgm_stat;
2716: else
2717: hr_utility.set_location('Leaving:'||l_proc, 15);
2718: return p_pgm_stat_cd;
2713: close c1;
2714: hr_utility.set_location('Leaving:'||l_proc, 10);
2715: return l_pgm_stat;
2716: else
2717: hr_utility.set_location('Leaving:'||l_proc, 15);
2718: return p_pgm_stat_cd;
2719: end if;
2720: End chk_pgm_stat_cd_not_null;
2721: --
2758: and name = p_name
2759: and business_group_id = p_business_group_id;
2760: --
2761: Begin
2762: hr_utility.set_location('Entering:'||l_proc, 5);
2763: --
2764: open c1;
2765: fetch c1 into l_dummy;
2766: if c1%found then
2768: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
2769: fnd_message.raise_error;
2770: end if;
2771: --
2772: hr_utility.set_location('Leaving:'||l_proc, 15);
2773: End chk_name_unique;
2774: --
2775: /*
2776: -- ----------------------------------------------------------------------------
2831: and rl.effective_end_date;
2832: --
2833: Begin
2834: --
2835: hr_utility.set_location('Entering:'||l_proc, 5);
2836: --
2837: if p_elig_apls_flag = 'Y' then
2838: --
2839: -- check to see if there is a profile set up...if so return
2841: open c1;
2842: fetch c1 into l_dummy;
2843: if c1%found then
2844: close c1;
2845: hr_utility.set_location('Leaving:'||l_proc, 9);
2846: return;
2847: end if;
2848: close c1;
2849: --
2852: open c2;
2853: fetch c2 into l_dummy;
2854: if c2%found then
2855: close c2;
2856: hr_utility.set_location('Leaving:'||l_proc, 10);
2857: return;
2858: end if;
2859: close c2;
2860: --
2863: fnd_message.set_name('BEN','BEN_91351_PGM_ELIG_APLS');
2864: fnd_message.raise_error;
2865: end if;
2866: --
2867: hr_utility.set_location('Leaving:'||l_proc, 15);
2868: --
2869: End chk_eligibility_defined;
2870: --
2871: */
2905: l_api_updating boolean;
2906: --
2907: Begin
2908: --
2909: hr_utility.set_location('Entering:'||l_proc, 5);
2910:
2911: --
2912: l_api_updating := ben_pgm_shd.api_updating
2913: (p_pgm_id => p_pgm_id,
2936: end if;
2937: --
2938: end if;
2939: --
2940: hr_utility.set_location('Leaving:'||l_proc,10);
2941: --
2942: end chk_enrt_mthd_cd;
2943: --
2944: -- ----------------------------------------------------------------------------
2977: l_api_updating boolean;
2978: --
2979: Begin
2980: --
2981: hr_utility.set_location('Entering:'||l_proc, 5);
2982:
2983: --
2984: l_api_updating := ben_pgm_shd.api_updating
2985: (p_pgm_id => p_pgm_id,
3010: end if;
3011: --
3012: end if;
3013: --
3014: hr_utility.set_location('Leaving:'||l_proc,10);
3015: --
3016: end chk_poe_lvl_cd;
3017: --
3018: -- ----------------------------------------------------------------------------
3050: l_api_updating boolean;
3051: --
3052: Begin
3053: --
3054: hr_utility.set_location('Entering:'||l_proc, 5);
3055:
3056: --
3057: l_api_updating := ben_pgm_shd.api_updating
3058: (p_pgm_id => p_pgm_id,
3081: end if;
3082: --
3083: end if;
3084: --
3085: hr_utility.set_location('Leaving:'||l_proc,10);
3086: --
3087: end chk_enrt_cd;
3088: --
3089: -- ----------------------------------------------------------------------------
3121: l_api_updating boolean;
3122: --
3123: Begin
3124: --
3125: hr_utility.set_location('Entering:'||l_proc, 5);
3126:
3127: --
3128: l_api_updating := ben_pgm_shd.api_updating
3129: (p_pgm_id => p_pgm_id,
3151: end if;
3152: --
3153: end if;
3154: --
3155: hr_utility.set_location('Leaving:'||l_proc,10);
3156: --
3157: end chk_pgm_stat_cd;
3158: --
3159: -- ----------------------------------------------------------------------------
3191: l_api_updating boolean;
3192: --
3193: Begin
3194: --
3195: hr_utility.set_location('Entering:'||l_proc, 5);
3196: --
3197: l_api_updating := ben_pgm_shd.api_updating
3198: (p_pgm_id => p_pgm_id,
3199: p_effective_date => p_effective_date,
3222: end if;
3223: --
3224: end if;
3225: --
3226: hr_utility.set_location('Leaving:'||l_proc,10);
3227: --
3228: end chk_dpnt_dsgn_lvl_cd;
3229: --
3230: -- ----------------------------------------------------------------------------
3262: l_api_updating boolean;
3263: --
3264: Begin
3265: --
3266: hr_utility.set_location('Entering:'||l_proc, 5);
3267: --
3268: l_api_updating := ben_pgm_shd.api_updating
3269: (p_pgm_id => p_pgm_id,
3270: p_effective_date => p_effective_date,
3290: end if;
3291: --
3292: end if;
3293: --
3294: hr_utility.set_location('Leaving:'||l_proc,10);
3295: --
3296: end chk_pgm_typ_cd;
3297: --
3298: -- ----------------------------------------------------------------------------
3338: l_api_updating boolean;
3339: --
3340: Begin
3341: --
3342: hr_utility.set_location('Entering:'||l_proc, 5);
3343: --
3344: l_api_updating := ben_pgm_shd.api_updating
3345: (p_pgm_id => p_pgm_id,
3346: p_effective_date => p_effective_date,
3389: --fnd_message.raise_error;
3390: end if;
3391: --
3392:
3393: hr_utility.set_location('Leaving:'||l_proc,10);
3394: --
3395: end chk_dpnt_dsgn_cd;
3396: --
3397: -- ----------------------------------------------------------------------------
3429: l_api_updating boolean;
3430: --
3431: Begin
3432: --
3433: hr_utility.set_location('Entering:'||l_proc, 5);
3434: --
3435: l_api_updating := ben_pgm_shd.api_updating
3436: (p_pgm_id => p_pgm_id,
3437: p_effective_date => p_effective_date,
3460: end if;
3461: --
3462: end if;
3463: --
3464: hr_utility.set_location('Leaving:'||l_proc,10);
3465: --
3466: end chk_pgm_grp_cd;
3467: --
3468: -- ----------------------------------------------------------------------------
3500: l_api_updating boolean;
3501: --
3502: Begin
3503: --
3504: hr_utility.set_location('Entering:'||l_proc, 5);
3505: --
3506: l_api_updating := ben_pgm_shd.api_updating
3507: (p_pgm_id => p_pgm_id,
3508: p_effective_date => p_effective_date,
3531: end if;
3532: --
3533: end if;
3534: --
3535: hr_utility.set_location('Leaving:'||l_proc,10);
3536: --
3537: end chk_acty_ref_perd_cd;
3538: --
3539: -- ----------------------------------------------------------------------------
3571: l_api_updating boolean;
3572: --
3573: Begin
3574: --
3575: hr_utility.set_location('Entering:'||l_proc, 5);
3576: --
3577: l_api_updating := ben_pgm_shd.api_updating
3578: (p_pgm_id => p_pgm_id,
3579: p_effective_date => p_effective_date,
3602: end if;
3603: --
3604: end if;
3605: --
3606: hr_utility.set_location('Leaving:'||l_proc,10);
3607: --
3608: end chk_enrt_cvg_strt_dt_cd;
3609: --
3610: -- ----------------------------------------------------------------------------
3642: l_api_updating boolean;
3643: --
3644: Begin
3645: --
3646: hr_utility.set_location('Entering:'||l_proc, 5);
3647: --
3648: l_api_updating := ben_pgm_shd.api_updating
3649: (p_pgm_id => p_pgm_id,
3650: p_effective_date => p_effective_date,
3673: end if;
3674: --
3675: end if;
3676: --
3677: hr_utility.set_location('Leaving:'||l_proc,10);
3678: --
3679: end chk_enrt_cvg_end_dt_cd;
3680: /*
3681: --
3714: l_api_updating boolean;
3715: --
3716: Begin
3717: --
3718: hr_utility.set_location('Entering:'||l_proc, 5);
3719: --
3720: l_api_updating := ben_pgm_shd.api_updating
3721: (p_pgm_id => p_pgm_id,
3722: p_effective_date => p_effective_date,
3745: end if;
3746: --
3747: end if;
3748: --
3749: hr_utility.set_location('Leaving:'||l_proc,10);
3750: --
3751: end chk_prtn_strt_dt_cd;
3752: --
3753: -- ----------------------------------------------------------------------------
3785: l_api_updating boolean;
3786: --
3787: Begin
3788: --
3789: hr_utility.set_location('Entering:'||l_proc, 5);
3790: --
3791: l_api_updating := ben_pgm_shd.api_updating
3792: (p_pgm_id => p_pgm_id,
3793: p_effective_date => p_effective_date,
3816: end if;
3817: --
3818: end if;
3819: --
3820: hr_utility.set_location('Leaving:'||l_proc,10);
3821: --
3822: end chk_prtn_end_dt_cd;
3823: */
3824: --
3863: l_dummy varchar2(30);
3864: --
3865: Begin
3866: --
3867: hr_utility.set_location('Entering:'||l_proc, 5);
3868: --
3869:
3870: l_api_updating := ben_pgm_shd.api_updating
3871: (p_pgm_id => p_pgm_id,
3892: close c1;
3893: --
3894: end if;
3895: --
3896: hr_utility.set_location('Leaving:'||l_proc,10);
3897: --
3898: end chk_pgm_uom;
3899: --
3900: -- ----------------------------------------------------------------------------
3951: and ff.effective_end_date;
3952: --
3953: Begin
3954: --
3955: hr_utility.set_location('Entering:'||l_proc, 5);
3956: --
3957: l_api_updating := ben_pgm_shd.api_updating
3958: (p_pgm_id => p_pgm_id,
3959: p_effective_date => p_effective_date,
4061: l_api_updating boolean;
4062: --
4063: Begin
4064: --
4065: hr_utility.set_location('Entering:'||l_proc, 5);
4066: --
4067: l_api_updating := ben_pgm_shd.api_updating
4068: (p_pgm_id => p_pgm_id,
4069: p_effective_date => p_effective_date,
4179: --
4180: end if;
4181:
4182: --
4183: hr_utility.set_location('Leaving:'||l_proc,10);
4184: --
4185: end chk_lookup_codes;
4186: --
4187: --
4220: l_api_updating boolean;
4221: --
4222: Begin
4223: --
4224: hr_utility.set_location('Entering:'||l_proc, 5);
4225: --
4226: l_api_updating := ben_pgm_shd.api_updating
4227: (p_pgm_id => p_pgm_id,
4228: p_effective_date => p_effective_date,
4251: end if;
4252: --
4253: end if;
4254: --
4255: hr_utility.set_location('Leaving:'||l_proc,10);
4256: --
4257: end chk_enrt_info_rt_freq_cd;
4258: --
4259: -- ----------------------------------------------------------------------------
4291: l_api_updating boolean;
4292: --
4293: Begin
4294: --
4295: hr_utility.set_location('Entering:'||l_proc, 5);
4296: --
4297: l_api_updating := ben_pgm_shd.api_updating
4298: (p_pgm_id => p_pgm_id,
4299: p_effective_date => p_effective_date,
4322: end if;
4323: --
4324: end if;
4325: --
4326: hr_utility.set_location('Leaving:'||l_proc,10);
4327: --
4328: end chk_dpnt_cvg_strt_dt_cd;
4329: --
4330: -- ----------------------------------------------------------------------------
4362: l_api_updating boolean;
4363: --
4364: Begin
4365: --
4366: hr_utility.set_location('Entering:'||l_proc, 5);
4367: --
4368: l_api_updating := ben_pgm_shd.api_updating
4369: (p_pgm_id => p_pgm_id,
4370: p_effective_date => p_effective_date,
4393: end if;
4394: --
4395: end if;
4396: --
4397: hr_utility.set_location('Leaving:'||l_proc,10);
4398: --
4399: end chk_dpnt_cvg_end_dt_cd;
4400: --
4401: -- ----------------------------------------------------------------------------
4438: l_api_updating boolean;
4439: --
4440: Begin
4441: --
4442: hr_utility.set_location('Entering:'||l_proc, 5);
4443: --
4444: l_api_updating := ben_pgm_shd.api_updating
4445: (p_pgm_id => p_pgm_id,
4446: p_effective_date => p_effective_date,
4469: end if;
4470: --
4471: end if;
4472: --
4473: hr_utility.set_location('Leaving:'||l_proc,10);
4474: --
4475: end chk_enrl_strt_dt_dpndcy;
4476: --
4477: -- ----------------------------------------------------------------------------
4514: l_api_updating boolean;
4515: --
4516: Begin
4517: --
4518: hr_utility.set_location('Entering:'||l_proc, 5);
4519: --
4520: l_api_updating := ben_pgm_shd.api_updating
4521: (p_pgm_id => p_pgm_id,
4522: p_effective_date => p_effective_date,
4546: end if;
4547: --
4548: end if;
4549: --
4550: hr_utility.set_location('Leaving:'||l_proc,10);
4551: --
4552: end chk_enrl_end_dt_dpndcy;
4553: --
4554: -- ----------------------------------------------------------------------------
4590: l_api_updating boolean;
4591: --
4592: Begin
4593: --
4594: hr_utility.set_location('Entering:'||l_proc, 5);
4595: --
4596: l_api_updating := ben_pgm_shd.api_updating
4597: (p_pgm_id => p_pgm_id,
4598: p_effective_date => p_effective_date,
4621: end if;
4622: --
4623: end if;
4624: --
4625: hr_utility.set_location('Leaving:'||l_proc,10);
4626: --
4627: end chk_dpnt_cvg_strt_dt_dpndcy;
4628: --
4629: -- ----------------------------------------------------------------------------
4665: l_api_updating boolean;
4666: --
4667: Begin
4668: --
4669: hr_utility.set_location('Entering:'||l_proc, 5);
4670: --
4671: l_api_updating := ben_pgm_shd.api_updating
4672: (p_pgm_id => p_pgm_id,
4673: p_effective_date => p_effective_date,
4696: end if;
4697: --
4698: end if;
4699: --
4700: hr_utility.set_location('Leaving:'||l_proc,10);
4701: --
4702: end chk_dpnt_cvg_end_dt_dpndcy;
4703: --
4704: -- ----------------------------------------------------------------------------
4757: l_api_updating boolean;
4758: --
4759: Begin
4760: --
4761: hr_utility.set_location('Entering:'||l_proc, 5);
4762: --
4763: l_api_updating := ben_pgm_shd.api_updating
4764: (p_pgm_id => p_pgm_id,
4765: p_effective_date => p_effective_date,
4806: end if;
4807: --
4808: end if;
4809: --
4810: hr_utility.set_location('Leaving:'||l_proc,10);
4811: --
4812: end chk_dpnt_dsgn_cd_dpndcy;
4813: --
4814: /*
4862: and cpp.effective_end_date;
4863: --
4864: Begin
4865: --
4866: hr_utility.set_location('Entering:'||l_proc, 5);
4867: --
4868: l_api_updating := ben_pgm_shd.api_updating
4869: (p_pgm_id => p_pgm_id,
4870: p_effective_date => p_effective_date,
4893: close c1;
4894: --
4895: end if;
4896: --
4897: hr_utility.set_location('Leaving:'||l_proc,10);
4898: --
4899: end chk_pgm_prvds_no_auto_dpndcy;
4900: --
4901: -- ----------------------------------------------------------------------------
4950: and cpp.effective_end_date;
4951: --
4952: Begin
4953: --
4954: hr_utility.set_location('Entering:'||l_proc, 5);
4955: --
4956: l_api_updating := ben_pgm_shd.api_updating
4957: (p_pgm_id => p_pgm_id,
4958: p_effective_date => p_effective_date,
4982: close c1;
4983: --
4984: end if;
4985: --
4986: hr_utility.set_location('Leaving:'||l_proc,10);
4987: --
4988: end chk_pgm_prvds_no_dflt_dpndcy;
4989: --
4990: */
5042: and len.dys_aftr_end_to_dflt_num is not null;
5043: --
5044: Begin
5045: --
5046: hr_utility.set_location('Entering:'||l_proc, 5);
5047: --
5048: l_api_updating := ben_pgm_shd.api_updating
5049: (p_pgm_id => p_pgm_id,
5050: p_effective_date => p_effective_date,
5073: close c1;
5074: --
5075: end if;
5076: --
5077: hr_utility.set_location('Leaving:'||l_proc,10);
5078: --
5079: end chk_pgm_prvds_no_dflt_dpndcy2;
5080: --
5081: -- ----------------------------------------------------------------------------
5136: l_api_updating boolean;
5137: --
5138: Begin
5139: --
5140: hr_utility.set_location('Entering:'||l_proc, 5);
5141: --
5142: l_api_updating := ben_pgm_shd.api_updating
5143: (p_pgm_id => p_pgm_id,
5144: p_effective_date => p_effective_date,
5193: end if;
5194: --
5195: end if;
5196: --
5197: hr_utility.set_location('Leaving:'||l_proc,10);
5198: --
5199: end chk_dpnt_dsgn_lvl_cd_dpndcy;
5200: --
5201: -- ----------------------------------------------------------------------------
5260: and pgc.effective_end_date;
5261: --
5262: Begin
5263: --
5264: hr_utility.set_location('Entering:'||l_proc, 5);
5265: --
5266: l_api_updating := ben_pgm_shd.api_updating
5267: (p_pgm_id => p_pgm_id,
5268: p_effective_date => p_effective_date,
5331: --
5332: --
5333: end if;
5334: --
5335: hr_utility.set_location('Leaving:'||l_proc,10);
5336: --
5337: end chk_dpnt_dsgn_cd_detail;
5338: --
5339: -- ----------------------------------------------------------------------------
5398: and pgc.effective_end_date;
5399: --
5400: Begin
5401: --
5402: hr_utility.set_location('Entering:'||l_proc, 5);
5403: --
5404: l_api_updating := ben_pgm_shd.api_updating
5405: (p_pgm_id => p_pgm_id,
5406: p_effective_date => p_effective_date,
5465: --
5466: --
5467: end if;
5468: --
5469: hr_utility.set_location('Leaving:'||l_proc,10);
5470: --
5471: end chk_dpnt_dsgn_lvl_cd_dpndcy2;
5472: --
5473: /*
5523: and ctp.effective_end_date;
5524: --
5525: Begin
5526: --
5527: hr_utility.set_location('Entering:'||l_proc, 5);
5528: --
5529: l_api_updating := ben_pgm_shd.api_updating
5530: (p_pgm_id => p_pgm_id,
5531: p_effective_date => p_effective_date,
5553: end if;
5554: --
5555: end if;
5556: --
5557: hr_utility.set_location('Leaving:'||l_proc,10);
5558: --
5559: end chk_dpnt_dsgn_lvl_cd_dpndcy3;
5560: --
5561: */
5636: and pyd.effective_end_date;
5637: --
5638: Begin
5639: --
5640: hr_utility.set_location('Entering:'||l_proc, 5);
5641: --
5642: l_api_updating := ben_pgm_shd.api_updating
5643: (p_pgm_id => p_pgm_id,
5644: p_effective_date => p_effective_date,
5700: --
5701: --
5702: end if;
5703: --
5704: hr_utility.set_location('Leaving:'||l_proc,10);
5705: --
5706: end chk_dpnt_dsgn_lvl_cd_dpndcy4;
5707: --
5708: -- ----------------------------------------------------------------------------
5743: l_api_updating boolean;
5744: --
5745: Begin
5746: --
5747: hr_utility.set_location('Entering:'||l_proc, 5);
5748:
5749: --
5750: l_api_updating := ben_pgm_shd.api_updating
5751: (p_pgm_id => p_pgm_id,
5776: end if;
5777: --
5778: end if;
5779: --
5780: hr_utility.set_location('Leaving:'||l_proc,10);
5781: --
5782: end chk_enrt_cd_gsp;
5783: --
5784:
5824: l_integrity_error Exception;
5825: l_table_name all_tables.table_name%TYPE;
5826: --
5827: Begin
5828: hr_utility.set_location('Entering:'||l_proc, 5);
5829: --
5830: -- Ensure that the p_datetrack_mode argument is not null
5831: --
5832: hr_api.mandatory_arg_error
5916: */
5917: --
5918: End If;
5919: --
5920: hr_utility.set_location(' Leaving:'||l_proc, 10);
5921: Exception
5922: When l_integrity_error Then
5923: --
5924: -- A referential integrity check was violated therefore
5988: from ben_popl_yr_perd t
5989: where t.pl_id = p_pgm_id ;
5990: --
5991: Begin
5992: hr_utility.set_location('Entering:'||l_proc, 5);
5993: --
5994: -- Ensure that the p_datetrack_mode argument is not null
5995: --
5996: hr_api.mandatory_arg_error
6157: l_table_name := 'ben_elig_cbr_quald_bnf_f';
6158: Raise l_rows_exist;
6159: End If;
6160: /*
6161: hr_utility.set_location('!!!!! 18', 5);
6162: If (dt_api.rows_exist
6163: (p_base_table_name => 'ben_elig_per_elctbl_chc',
6164: p_base_key_column => 'pgm_id',
6165: p_base_key_value => p_pgm_id,
6167: p_to_date => p_validation_end_date)) Then
6168: l_table_name := 'ben_elig_per_elctbl_chc';
6169: Raise l_rows_exist;
6170: End If;
6171: hr_utility.set_location('!!!!! 19', 5);
6172:
6173: If (dt_api.rows_exist -- Uncommented, Bug 4339842
6174: (p_base_table_name => 'ben_popl_yr_perd',
6175: p_base_key_column => 'pgm_id',
6191: close c_yr_perd_exists;
6192: --
6193: End If;
6194: --
6195: hr_utility.set_location(' Leaving:'||l_proc, 10);
6196: Exception
6197: When l_rows_exist Then
6198: --
6199: -- A referential integrity check was violated therefore
6223: --
6224: l_proc varchar2(72) := g_package||'insert_validate';
6225: --
6226: Begin
6227: hr_utility.set_location('Entering:'||l_proc, 5);
6228: --
6229: chk_pgm_id
6230: (p_pgm_id => p_rec.pgm_id,
6231: p_effective_date => p_effective_date,
6715: if p_rec.business_group_id is not null and p_rec.legislation_code is null then
6716: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
6717: end if;
6718: --
6719: hr_utility.set_location(' Leaving:'||l_proc, 10);
6720: End insert_validate;
6721: --
6722: -- ----------------------------------------------------------------------------
6723: -- |---------------------------< update_validate >----------------------------|
6731: --
6732: l_proc varchar2(72) := g_package||'update_validate';
6733: --
6734: Begin
6735: hr_utility.set_location('Entering:'||l_proc, 5);
6736: --
6737: -- Call all supporting business operations
6738: --
6739: --
7229: p_object_version_number => p_rec.object_version_number);
7230: --
7231: -- Call user defined business rules
7232: --
7233: hr_utility.set_location(' Leaving:'||l_proc, 10);
7234: End update_validate;
7235: --
7236: -- ----------------------------------------------------------------------------
7237: -- |---------------------------< delete_validate >----------------------------|
7245: --
7246: l_proc varchar2(72) := g_package||'delete_validate';
7247: --
7248: Begin
7249: hr_utility.set_location('Entering:'||l_proc, 5);
7250: --
7251: -- Call all supporting business operations
7252: --
7253: dt_delete_validate
7255: p_validation_start_date => p_validation_start_date,
7256: p_validation_end_date => p_validation_end_date,
7257: p_pgm_id => p_rec.pgm_id);
7258: --
7259: hr_utility.set_location(' Leaving:'||l_proc, 10);
7260: End delete_validate;
7261: --
7262: --
7263: -- ---------------------------------------------------------------------------
7283:
7284: --
7285: begin
7286: --
7287: hr_utility.set_location('Entering:'|| l_proc, 10);
7288: --
7289: -- Ensure that all the mandatory parameter are not null
7290: --
7291: hr_api.mandatory_arg_error(p_api_name => l_proc,
7309: end if;
7310: --
7311: close csr_leg_code;
7312: --
7313: hr_utility.set_location(' Leaving:'|| l_proc, 20);
7314: --
7315: return l_legislation_code;
7316: --
7317: end return_legislation_code;