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.

[Home] [Help]

APPS.BEN_CPP_BUS dependencies on HR_UTILITY

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

54: and p_validation_end_date >= effective_start_date;
55:
56: --
57: Begin
58: hr_utility.set_location('Entering:'||l_proc, 5);
59: --
60: open c1;
61: fetch c1 into l_dummy;
62: if c1%found then

Line 68: hr_utility.set_location('Leaving:'||l_proc, 15);

64: fnd_message.raise_error;
65: end if;
66: close c1;
67: --
68: hr_utility.set_location('Leaving:'||l_proc, 15);
69: End chk_duplicate_ordr_num;
70: --
71: -- ----------------------------------------------------------------------------
72: -- |--------------------< chk_duplicate_pl_id_in_pgm>------------------------|

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

116: and p_validation_start_date <= effective_end_date
117: and p_validation_end_date >= effective_start_date;
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: hr_utility.set_location('p_validation_start_date:'||p_validation_start_date, 5);
122: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 5);
123: open c1;
124: fetch c1 into l_dummy;

Line 121: hr_utility.set_location('p_validation_start_date:'||p_validation_start_date, 5);

117: and p_validation_end_date >= effective_start_date;
118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: hr_utility.set_location('p_validation_start_date:'||p_validation_start_date, 5);
122: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 5);
123: open c1;
124: fetch c1 into l_dummy;
125: if c1%found then

Line 122: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 5);

118: --
119: Begin
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: hr_utility.set_location('p_validation_start_date:'||p_validation_start_date, 5);
122: hr_utility.set_location('p_validation_end_date:'||p_validation_end_date, 5);
123: open c1;
124: fetch c1 into l_dummy;
125: if c1%found then
126: fnd_message.set_name('BEN','BEN_91721_DUP_PL_ID_IN_PGM');

Line 130: hr_utility.set_location('Leaving:'||l_proc, 15);

126: fnd_message.set_name('BEN','BEN_91721_DUP_PL_ID_IN_PGM');
127: fnd_message.raise_error;
128: end if;
129: close c1;
130: hr_utility.set_location('Leaving:'||l_proc, 15);
131: End chk_duplicate_pl_id_in_pgm;
132: --
133: -- ----------------------------------------------------------------------------
134: -- |------< chk_plan_allowed_in_pgm >------|

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

167: and effective_end_date
168: and business_group_id = p_business_group_id;
169: --
170: Begin
171: hr_utility.set_location('Entering:'||l_proc, 5);
172: open c1;
173: fetch c1 into l_pl_cd;
174: close c1;
175: if l_pl_cd = 'MYNTBPGM' then

Line 179: hr_utility.set_location('Leaving:'||l_proc, 15);

175: if l_pl_cd = 'MYNTBPGM' then
176: fnd_message.set_name('BEN','BEN_91787_PL_ALWD_IN_PGM');
177: fnd_message.raise_error;
178: end if;
179: hr_utility.set_location('Leaving:'||l_proc, 15);
180: End chk_plan_allowed_in_pgm;
181: --
182:
183: -- --------------------------------chk_cd_rl_combination >-------------------------------|

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

208: p_vrfy_fmly_mmbr_cd in varchar2,
209: p_vrfy_fmly_mmbr_rl in number ) IS
210: l_proc varchar2(72) := g_package||'chk_cd_rl_combination';
211: BEGIN
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: if ( p_vrfy_fmly_mmbr_cd <> 'RL' and p_vrfy_fmly_mmbr_rl is not null)
215: then
216: fnd_message.set_name('BEN','BEN_91730_NO_RULE');

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

224: end if;
225: --
226: --leaving Procedure.
227: --
228: hr_utility.set_location('Leaving:'||l_proc,10);
229: --
230: end chk_cd_rl_combination;
231:
232: ---

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

265: l_api_updating boolean;
266: --
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_cpp_shd.api_updating
272: (p_effective_date => p_effective_date,
273: p_plip_id => p_plip_id,

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

294: end if;
295: --
296: end if;
297: --
298: hr_utility.set_location('Leaving:'||l_proc, 10);
299: --
300: End chk_plip_id;
301: --
302: -- ----------------------------------------------------------------------------

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

352: and ff.effective_end_date;
353: --
354: Begin
355: --
356: hr_utility.set_location('Entering:'||l_proc, 5);
357: --
358: l_api_updating := ben_cpp_shd.api_updating
359: (p_plip_id => p_plip_id,
360: p_effective_date => p_effective_date,

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

390: close c1;
391: --
392: end if;
393: --
394: hr_utility.set_location('Leaving:'||l_proc,10);
395: --
396: end chk_dflt_enrt_det_rl;
397: --
398: -- ----------------------------------------------------------------------------

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

448: and ff.effective_end_date;
449: --
450: Begin
451: --
452: hr_utility.set_location('Entering:'||l_proc, 5);
453: --
454: l_api_updating := ben_cpp_shd.api_updating
455: (p_plip_id => p_plip_id,
456: p_effective_date => p_effective_date,

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

484: close c1;
485: --
486: end if;
487: --
488: hr_utility.set_location('Leaving:'||l_proc,10);
489: --
490: end chk_auto_enrt_mthd_rl;
491: --
492:

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

500: l_api_updating boolean;
501: --
502: Begin
503: --
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: l_api_updating := ben_cpp_shd.api_updating
507: (p_plip_id => p_plip_id,
508: p_effective_date => p_effective_date,

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

533: end if;
534: --
535: end if;
536: --
537: hr_utility.set_location('Leaving:'||l_proc,10);
538: --
539: end chk_vrfy_fmly_mmbr_cd;
540:
541: -------------------------

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

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

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

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

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

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

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: end chk_vrfy_fmly_mmbr_rl;
641: --
642: --
643:

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

696: and ff.effective_end_date;
697: --
698: Begin
699: --
700: hr_utility.set_location('Entering:'||l_proc, 5);
701: --
702: l_api_updating := ben_cpp_shd.api_updating
703: (p_plip_id => p_plip_id,
704: p_effective_date => p_effective_date,

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

732: close c1;
733: --
734: end if;
735: --
736: hr_utility.set_location('Leaving:'||l_proc,10);
737: --
738: end chk_enrt_rl;
739: --
740: -- ----------------------------------------------------------------------------

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

790: and ff.effective_end_date;
791: --
792: Begin
793: --
794: hr_utility.set_location('Entering:'||l_proc, 5);
795: --
796: l_api_updating := ben_cpp_shd.api_updating
797: (p_plip_id => p_plip_id,
798: p_effective_date => p_effective_date,

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

828: close c1;
829: --
830: end if;
831: --
832: hr_utility.set_location('Leaving:'||l_proc,10);
833: --
834: end chk_dflt_to_asn_pndg_ctfn_rl;
835: --
836: -- ----------------------------------------------------------------------------

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

886: and ff.effective_end_date;
887: --
888: Begin
889: --
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: l_api_updating := ben_cpp_shd.api_updating
893: (p_plip_id => p_plip_id,
894: p_effective_date => p_effective_date,

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

924: close c1;
925: --
926: end if;
927: --
928: hr_utility.set_location('Leaving:'||l_proc,10);
929: --
930: end chk_mn_cvg_rl;
931: --
932: -- ----------------------------------------------------------------------------

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

982: and ff.effective_end_date;
983: --
984: Begin
985: --
986: hr_utility.set_location('Entering:'||l_proc, 5);
987: --
988: l_api_updating := ben_cpp_shd.api_updating
989: (p_plip_id => p_plip_id,
990: p_effective_date => p_effective_date,

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

1020: close c1;
1021: --
1022: end if;
1023: --
1024: hr_utility.set_location('Leaving:'||l_proc,10);
1025: --
1026: end chk_mx_cvg_rl;
1027: --
1028: -- ----------------------------------------------------------------------------

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

1078: and ff.effective_end_date;
1079: --
1080: Begin
1081: --
1082: hr_utility.set_location('Entering:'||l_proc, 5);
1083: --
1084: l_api_updating := ben_cpp_shd.api_updating
1085: (p_plip_id => p_plip_id,
1086: p_effective_date => p_effective_date,

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

1116: close c1;
1117: --
1118: end if;
1119: --
1120: hr_utility.set_location('Leaving:'||l_proc,10);
1121: --
1122: end chk_prort_prtl_yr_cvg_rstrn_rl;
1123: --
1124: -- ----------------------------------------------------------------------------

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

1156: l_api_updating boolean;
1157: --
1158: Begin
1159: --
1160: hr_utility.set_location('Entering:'||l_proc, 5);
1161: --
1162: l_api_updating := ben_cpp_shd.api_updating
1163: (p_plip_id => p_plip_id,
1164: p_effective_date => p_effective_date,

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

1185: end if;
1186: --
1187: end if;
1188: --
1189: hr_utility.set_location('Leaving:'||l_proc,10);
1190: --
1191: end chk_dflt_enrt_cd;
1192: --
1193: -- ----------------------------------------------------------------------------

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

1225: l_api_updating boolean;
1226: --
1227: Begin
1228: --
1229: hr_utility.set_location('Entering:'||l_proc, 5);
1230: --
1231: l_api_updating := ben_cpp_shd.api_updating
1232: (p_plip_id => p_plip_id,
1233: p_effective_date => p_effective_date,

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

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

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

1296: l_api_updating boolean;
1297: --
1298: Begin
1299: --
1300: hr_utility.set_location('Entering:'||l_proc, 5);
1301: --
1302: l_api_updating := ben_cpp_shd.api_updating
1303: (p_plip_id => p_plip_id,
1304: p_effective_date => p_effective_date,

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

1327: end if;
1328: --
1329: end if;
1330: --
1331: hr_utility.set_location('Leaving:'||l_proc,10);
1332: --
1333: end chk_unsspnd_enrt_cd;
1334: --
1335: -- ----------------------------------------------------------------------------

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

1367: l_api_updating boolean;
1368: --
1369: Begin
1370: --
1371: hr_utility.set_location('Entering:'||l_proc, 5);
1372: --
1373: l_api_updating := ben_cpp_shd.api_updating
1374: (p_plip_id => p_plip_id,
1375: p_effective_date => p_effective_date,

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

1398: end if;
1399: --
1400: end if;
1401: --
1402: hr_utility.set_location('Leaving:'||l_proc,10);
1403: --
1404: end chk_prort_prtl_yr_cvg_rstrn_cd;
1405: --
1406: -- ----------------------------------------------------------------------------

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

1438: l_api_updating boolean;
1439: --
1440: Begin
1441: --
1442: hr_utility.set_location('Entering:'||l_proc, 5);
1443: --
1444: l_api_updating := ben_cpp_shd.api_updating
1445: (p_plip_id => p_plip_id,
1446: p_effective_date => p_effective_date,

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

1469: end if;
1470: --
1471: end if;
1472: --
1473: hr_utility.set_location('Leaving:'||l_proc,10);
1474: --
1475: end chk_cvg_incr_r_decr_only_cd;
1476: --
1477: -- ----------------------------------------------------------------------------

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

1509: l_api_updating boolean;
1510: --
1511: Begin
1512: --
1513: hr_utility.set_location('Entering:'||l_proc, 5);
1514: --
1515: l_api_updating := ben_cpp_shd.api_updating
1516: (p_plip_id => p_plip_id,
1517: p_effective_date => p_effective_date,

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

1540: end if;
1541: --
1542: end if;
1543: --
1544: hr_utility.set_location('Leaving:'||l_proc,10);
1545: --
1546: end chk_bnft_or_option_rstrctn_cd;
1547: --
1548: -- ----------------------------------------------------------------------------

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

1580: l_api_updating boolean;
1581: --
1582: Begin
1583: --
1584: hr_utility.set_location('Entering:'||l_proc, 5);
1585: --
1586: l_api_updating := ben_cpp_shd.api_updating
1587: (p_plip_id => p_plip_id,
1588: p_effective_date => p_effective_date,

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

1609: end if;
1610: --
1611: end if;
1612: --
1613: hr_utility.set_location('Leaving:'||l_proc,10);
1614: --
1615: end chk_enrt_mthd_cd;
1616: --
1617: -- ----------------------------------------------------------------------------

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

1649: l_api_updating boolean;
1650: --
1651: Begin
1652: --
1653: hr_utility.set_location('Entering:'||l_proc, 5);
1654: --
1655: l_api_updating := ben_cpp_shd.api_updating
1656: (p_plip_id => p_plip_id,
1657: p_effective_date => p_effective_date,

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

1678: end if;
1679: --
1680: end if;
1681: --
1682: hr_utility.set_location('Leaving:'||l_proc,10);
1683: --
1684: end chk_enrt_cd;
1685: --
1686: -- ----------------------------------------------------------------------------

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

1718: l_api_updating boolean;
1719: --
1720: Begin
1721: --
1722: hr_utility.set_location('Entering:'||l_proc, 5);
1723: --
1724: l_api_updating := ben_cpp_shd.api_updating
1725: (p_plip_id => p_plip_id,
1726: p_effective_date => p_effective_date,

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

1747: end if;
1748: --
1749: end if;
1750: --
1751: hr_utility.set_location('Leaving:'||l_proc,10);
1752: --
1753: end chk_plip_stat_cd;
1754: --
1755: -- ----------------------------------------------------------------------------

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

1787: l_api_updating boolean;
1788: --
1789: Begin
1790: --
1791: hr_utility.set_location('Entering:'||l_proc, 5);
1792: --
1793: l_api_updating := ben_cpp_shd.api_updating
1794: (p_plip_id => p_plip_id,
1795: p_effective_date => p_effective_date,

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

1816: end if;
1817: --
1818: end if;
1819: --
1820: hr_utility.set_location('Leaving:'||l_proc,10);
1821: --
1822: end chk_dflt_flag;
1823: --
1824: -- ----------------------------------------------------------------------------

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

1856: l_api_updating boolean;
1857: --
1858: Begin
1859: --
1860: hr_utility.set_location('Entering:'||l_proc, 5);
1861: --
1862: l_api_updating := ben_cpp_shd.api_updating
1863: (p_plip_id => p_plip_id,
1864: p_effective_date => p_effective_date,

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

1885: end if;
1886: --
1887: end if;
1888: --
1889: hr_utility.set_location('Leaving:'||l_proc,10);
1890: --
1891: end chk_alws_unrstrctd_enrt_flag;
1892: --
1893: -- ----------------------------------------------------------------------------

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

1925: l_api_updating boolean;
1926: --
1927: Begin
1928: --
1929: hr_utility.set_location('Entering:'||l_proc, 5);
1930: --
1931: l_api_updating := ben_cpp_shd.api_updating
1932: (p_plip_id => p_plip_id,
1933: p_effective_date => p_effective_date,

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

1956: end if;
1957: --
1958: end if;
1959: --
1960: hr_utility.set_location('Leaving:'||l_proc,10);
1961: --
1962: end chk_no_mn_cvg_amt_apls_flag;
1963: --
1964: -- ----------------------------------------------------------------------------

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

1996: l_api_updating boolean;
1997: --
1998: Begin
1999: --
2000: hr_utility.set_location('Entering:'||l_proc, 5);
2001: --
2002: l_api_updating := ben_cpp_shd.api_updating
2003: (p_plip_id => p_plip_id,
2004: p_effective_date => p_effective_date,

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

2027: end if;
2028: --
2029: end if;
2030: --
2031: hr_utility.set_location('Leaving:'||l_proc,10);
2032: --
2033: end chk_no_mn_cvg_incr_apls_flag;
2034: --
2035: -- ----------------------------------------------------------------------------

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

2067: l_api_updating boolean;
2068: --
2069: Begin
2070: --
2071: hr_utility.set_location('Entering:'||l_proc, 5);
2072: --
2073: l_api_updating := ben_cpp_shd.api_updating
2074: (p_plip_id => p_plip_id,
2075: p_effective_date => p_effective_date,

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

2098: end if;
2099: --
2100: end if;
2101: --
2102: hr_utility.set_location('Leaving:'||l_proc,10);
2103: --
2104: end chk_no_mx_cvg_amt_apls_flag;
2105: --
2106: -- ----------------------------------------------------------------------------

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

2138: l_api_updating boolean;
2139: --
2140: Begin
2141: --
2142: hr_utility.set_location('Entering:'||l_proc, 5);
2143: --
2144: l_api_updating := ben_cpp_shd.api_updating
2145: (p_plip_id => p_plip_id,
2146: p_effective_date => p_effective_date,

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

2169: end if;
2170: --
2171: end if;
2172: --
2173: hr_utility.set_location('Leaving:'||l_proc,10);
2174: --
2175: end chk_no_mx_cvg_incr_apls_flag;
2176: --
2177: -- ----------------------------------------------------------------------------

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

2209: l_proc varchar2(72) := g_package||'chk_all_no_amount_flags';
2210: --
2211: Begin
2212: --
2213: hr_utility.set_location('Entering:'||l_proc, 5);
2214: --
2215: -- check if it is a valid combination
2216: --
2217: if ((p_no_mn_cvg_amt_apls_flag='Y' and p_mn_cvg_amt>0) or

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

2235: fnd_message.raise_error;
2236: --
2237: end if;
2238: --
2239: hr_utility.set_location('Leaving:'||l_proc,10);
2240: --
2241: end chk_all_no_amount_flags;
2242: --
2243: -- ----------------------------------------------------------------------------

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

2273: l_proc varchar2(72) := g_package||'chk_mn_val_mn_flag_mn_rule';
2274: --
2275: Begin
2276: --
2277: hr_utility.set_location('Entering:'||l_proc, 5);
2278: --
2279: if p_mn_cvg_amt is not null and (p_no_mn_cvg_amt_apls_flag = 'Y' or
2280: p_mn_cvg_rl is not null) then
2281: --

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

2295: fnd_message.raise_error;
2296: --
2297: end if;
2298: --
2299: hr_utility.set_location('Leaving:'||l_proc,10);
2300: --
2301: end chk_mn_val_mn_flag_mn_rule;
2302: --
2303: -- ----------------------------------------------------------------------------

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

2333: l_proc varchar2(72) := g_package||'chk_mx_val_mx_flag_mx_rule';
2334: --
2335: Begin
2336: --
2337: hr_utility.set_location('Entering:'||l_proc, 5);
2338: --
2339: if p_mx_cvg_alwd_amt is not null and (p_no_mx_cvg_amt_apls_flag = 'Y' or
2340: p_mx_cvg_rl is not null) then
2341: --

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

2355: fnd_message.raise_error;
2356: --
2357: end if;
2358: --
2359: hr_utility.set_location('Leaving:'||l_proc,10);
2360: --
2361: end chk_mx_val_mx_flag_mx_rule;
2362: --
2363: -- ----------------------------------------------------------------------------

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

2410: and pgm.effective_end_date;
2411: --
2412: Begin
2413: --
2414: hr_utility.set_location('Entering:'||l_proc, 5);
2415: --
2416: l_api_updating := ben_cpp_shd.api_updating
2417: (p_plip_id => p_plip_id,
2418: p_effective_date => p_effective_date,

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

2443: end if;
2444: --
2445: end if;
2446: --
2447: hr_utility.set_location('Leaving:'||l_proc,10);
2448: --
2449: end chk_dflt_enrt_cd_dpndcy;
2450: --
2451: -- ----------------------------------------------------------------------------

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

2502: and pgm.effective_end_date;
2503: --
2504: Begin
2505: --
2506: hr_utility.set_location('Entering:'||l_proc, 5);
2507: --
2508: l_api_updating := ben_cpp_shd.api_updating
2509: (p_plip_id => p_plip_id,
2510: p_effective_date => p_effective_date,

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

2542: close c1;
2543: --
2544: end if;
2545: --
2546: hr_utility.set_location('Leaving:'||l_proc,10);
2547: --
2548: end chk_dflt_dpndcy;
2549: --
2550: -- ----------------------------------------------------------------------------

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

2584: l_api_updating boolean;
2585: --
2586: Begin
2587: --
2588: hr_utility.set_location('Entering:'||l_proc, 5);
2589: --
2590: l_api_updating := ben_cpp_shd.api_updating
2591: (p_plip_id => p_plip_id,
2592: p_effective_date => p_effective_date,

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

2611: end if;
2612: --
2613: end if;
2614: --
2615: hr_utility.set_location('Leaving:'||l_proc,10);
2616: --
2617: end chk_dflt_flag_dependency;
2618: --
2619: -- ----------------------------------------------------------------------------

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

2655: l_api_updating boolean;
2656: --
2657: Begin
2658: --
2659: hr_utility.set_location('Entering:'||l_proc, 5);
2660: --
2661: l_api_updating := ben_cpp_shd.api_updating
2662: (p_plip_id => p_plip_id,
2663: p_effective_date => p_effective_date,

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

2686: end if;
2687: --
2688: end if;
2689: --
2690: hr_utility.set_location('Leaving:'||l_proc,10);
2691: --
2692: end chk_dflt_enrt_mthd_dpndcy;
2693: --
2694: -- ----------------------------------------------------------------------------

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

2752: and plip.effective_end_date;
2753: --
2754: Begin
2755: --
2756: hr_utility.set_location('Entering:'||l_proc, 5);
2757: --
2758: open pl_is_imputed;
2759: fetch pl_is_imputed into l_imptd_incm_cd;
2760: close pl_is_imputed;

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

2775: --
2776: end if;
2777: end if;
2778: --
2779: hr_utility.set_location('Leaving:'||l_proc,10);
2780: --
2781: end chk_invk_imptd_incm_per_pgm;
2782: --
2783: --

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

2849: and plip.effective_end_date;
2850: --
2851: Begin
2852: --
2853: hr_utility.set_location('Entering:'||l_proc, 5);
2854: --
2855: open c_flex_pgm;
2856: fetch c_flex_pgm into l_pgm_typ_cd;
2857: close c_flex_pgm;

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

2887: --
2888: end if;
2889: end if;
2890: --
2891: hr_utility.set_location('Leaving:'||l_proc,10);
2892: --
2893: end chk_invk_flx_crpl_per_pgm;
2894: --
2895: -- ----------------------------------------------------------------------------

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

2944: and ff.effective_end_date;
2945: --
2946: Begin
2947: --
2948: hr_utility.set_location('Entering:'||l_proc, 5);
2949: --
2950: l_api_updating := ben_cpp_shd.api_updating
2951: (p_plip_id => p_plip_id,
2952: p_effective_date => p_effective_date,

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

2980: close c1;
2981: --
2982: end if;
2983: --
2984: hr_utility.set_location('Leaving:'||l_proc,10);
2985: --
2986: end chk_enrt_cvg_strt_dt_rl;
2987: --
2988: -- ----------------------------------------------------------------------------

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

3037: and ff.effective_end_date;
3038: --
3039: Begin
3040: --
3041: hr_utility.set_location('Entering:'||l_proc, 5);
3042: --
3043: l_api_updating := ben_cpp_shd.api_updating
3044: (p_plip_id => p_plip_id,
3045: p_effective_date => p_effective_date,

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

3073: close c1;
3074: --
3075: end if;
3076: --
3077: hr_utility.set_location('Leaving:'||l_proc,10);
3078: --
3079: end chk_enrt_cvg_end_dt_rl;
3080: --
3081: -- ----------------------------------------------------------------------------

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

3113: l_api_updating boolean;
3114: --
3115: Begin
3116: --
3117: hr_utility.set_location('Entering:'||l_proc, 5);
3118: --
3119: l_api_updating := ben_cpp_shd.api_updating
3120: (p_plip_id => p_plip_id,
3121: p_effective_date => p_effective_date,

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

3144: end if;
3145: --
3146: end if;
3147: --
3148: hr_utility.set_location('Leaving:'||l_proc,10);
3149: --
3150: end chk_enrt_cvg_strt_dt_cd;
3151: --
3152: -- ----------------------------------------------------------------------------

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

3184: l_api_updating boolean;
3185: --
3186: Begin
3187: --
3188: hr_utility.set_location('Entering:'||l_proc, 5);
3189: --
3190: l_api_updating := ben_cpp_shd.api_updating
3191: (p_plip_id => p_plip_id,
3192: p_effective_date => p_effective_date,

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

3215: end if;
3216: --
3217: end if;
3218: --
3219: hr_utility.set_location('Leaving:'||l_proc,10);
3220: --
3221: end chk_enrt_cvg_end_dt_cd;
3222: --
3223: -- ----------------------------------------------------------------------------

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

3272: and ff.effective_end_date;
3273: --
3274: Begin
3275: --
3276: hr_utility.set_location('Entering:'||l_proc, 5);
3277: --
3278: l_api_updating := ben_cpp_shd.api_updating
3279: (p_plip_id => p_plip_id,
3280: p_effective_date => p_effective_date,

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

3310: close c1;
3311: --
3312: end if;
3313: --
3314: hr_utility.set_location('Leaving:'||l_proc,10);
3315: --
3316: end chk_rt_strt_dt_rl;
3317: --
3318: -- ----------------------------------------------------------------------------

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

3350: l_api_updating boolean;
3351: --
3352: Begin
3353: --
3354: hr_utility.set_location('Entering:'||l_proc, 5);
3355: --
3356: l_api_updating := ben_cpp_shd.api_updating
3357: (p_plip_id => p_plip_id,
3358: p_effective_date => p_effective_date,

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

3381: end if;
3382: --
3383: end if;
3384: --
3385: hr_utility.set_location('Leaving:'||l_proc,10);
3386: --
3387: end chk_rt_strt_dt_cd;
3388: --
3389: -- ----------------------------------------------------------------------------

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

3438: and ff.effective_end_date;
3439: --
3440: Begin
3441: --
3442: hr_utility.set_location('Entering:'||l_proc, 5);
3443: --
3444: l_api_updating := ben_cpp_shd.api_updating
3445: (p_plip_id => p_plip_id,
3446: p_effective_date => p_effective_date,

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

3476: close c1;
3477: --
3478: end if;
3479: --
3480: hr_utility.set_location('Leaving:'||l_proc,10);
3481: --
3482: end chk_rt_end_dt_rl;
3483: --
3484: -- ----------------------------------------------------------------------------

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

3533: and ff.effective_end_date;
3534: --
3535: Begin
3536: --
3537: hr_utility.set_location('Entering:'||l_proc, 5);
3538: --
3539: l_api_updating := ben_cpp_shd.api_updating
3540: (p_plip_id => p_plip_id,
3541: p_effective_date => p_effective_date,

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

3571: close c1;
3572: --
3573: end if;
3574: --
3575: hr_utility.set_location('Leaving:'||l_proc,10);
3576: --
3577: end chk_postelcn_edit_rl;
3578: --
3579: -- ----------------------------------------------------------------------------

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

3611: l_api_updating boolean;
3612: --
3613: Begin
3614: --
3615: hr_utility.set_location('Entering:'||l_proc, 5);
3616: --
3617: l_api_updating := ben_cpp_shd.api_updating
3618: (p_plip_id => p_plip_id,
3619: p_effective_date => p_effective_date,

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

3642: end if;
3643: --
3644: end if;
3645: --
3646: hr_utility.set_location('Leaving:'||l_proc,10);
3647: --
3648: end chk_rt_end_dt_cd;
3649: --
3650: -- ----------------------------------------------------------------------------

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

3682: l_api_updating boolean;
3683: --
3684: Begin
3685: --
3686: hr_utility.set_location('Entering:'||l_proc, 5);
3687: --
3688: l_api_updating := ben_cpp_shd.api_updating
3689: (p_plip_id => p_plip_id,
3690: p_effective_date => p_effective_date,

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

3713: end if;
3714: --
3715: end if;
3716: --
3717: hr_utility.set_location('Leaving:'||l_proc,10);
3718: --
3719: end chk_drvbl_fctr_apls_rts_flag;
3720: --
3721: -- ----------------------------------------------------------------------------

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

3752: l_api_updating boolean;
3753: --
3754: Begin
3755: --
3756: hr_utility.set_location('Entering:'||l_proc, 5);
3757: --
3758: l_api_updating := ben_cpp_shd.api_updating
3759: (p_plip_id => p_plip_id,
3760: p_effective_date => p_effective_date,

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

3783: end if;
3784: --
3785: end if;
3786: --
3787: hr_utility.set_location('Leaving:'||l_proc,10);
3788: --
3789: end chk_drvbl_fctr_prtn_elig_flag;
3790: --
3791: -- ----------------------------------------------------------------------------

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

3823: l_api_updating boolean;
3824: --
3825: Begin
3826: --
3827: hr_utility.set_location('Entering:'||l_proc, 5);
3828: --
3829: l_api_updating := ben_cpp_shd.api_updating
3830: (p_plip_id => p_plip_id,
3831: p_effective_date => p_effective_date,

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

3854: end if;
3855: --
3856: end if;
3857: --
3858: hr_utility.set_location('Leaving:'||l_proc,10);
3859: --
3860: end chk_elig_apls_flag;
3861: --
3862: -- ----------------------------------------------------------------------------

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

3895: l_api_updating boolean;
3896: --
3897: Begin
3898: --
3899: hr_utility.set_location('Entering:'||l_proc, 5);
3900: --
3901: l_api_updating := ben_cpp_shd.api_updating
3902: (p_plip_id => p_plip_id,
3903: p_effective_date => p_effective_date,

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

3926: end if;
3927: --
3928: end if;
3929: --
3930: hr_utility.set_location('Leaving:'||l_proc,10);
3931: --
3932: end chk_prtn_elig_ovrid_alwd_flag;
3933: --
3934: -- ----------------------------------------------------------------------------

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

3967: l_api_updating boolean;
3968: --
3969: Begin
3970: --
3971: hr_utility.set_location('Entering:'||l_proc, 5);
3972: --
3973: l_api_updating := ben_cpp_shd.api_updating
3974: (p_plip_id => p_plip_id,
3975: p_effective_date => p_effective_date,

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

3998: end if;
3999: --
4000: end if;
4001: --
4002: hr_utility.set_location('Leaving:'||l_proc,10);
4003: --
4004: end chk_trk_inelig_per_flag;
4005: --
4006: -- ----------------------------------------------------------------------------

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

4051: and p_effective_date between cvg.effective_start_date and cvg.effective_end_date;
4052: --
4053: Begin
4054: --
4055: hr_utility.set_location('Entering:'||l_proc, 5);
4056: --
4057: l_api_updating := ben_cpp_shd.api_updating
4058: (p_effective_date => p_effective_date,
4059: p_plip_id => p_plip_id,

Line 4068: hr_utility.set_location(l_proc, 15);

4064: <> nvl(ben_cpp_shd.g_old_rec.dflt_to_asn_pndg_ctfn_cd, '***')
4065: or not l_api_updating)
4066: and p_dflt_to_asn_pndg_ctfn_cd is not null then
4067: --
4068: hr_utility.set_location(l_proc, 15);
4069: --
4070: if (instr(p_dflt_to_asn_pndg_ctfn_cd,'NL'))>0 then
4071: --
4072: hr_utility.set_location(l_proc, 25);

Line 4072: hr_utility.set_location(l_proc, 25);

4068: hr_utility.set_location(l_proc, 15);
4069: --
4070: if (instr(p_dflt_to_asn_pndg_ctfn_cd,'NL'))>0 then
4071: --
4072: hr_utility.set_location(l_proc, 25);
4073: --
4074: open c1;
4075: fetch c1 into l_dummy;
4076: if c1%found then

Line 4079: hr_utility.set_location(l_proc, 35);

4075: fetch c1 into l_dummy;
4076: if c1%found then
4077: --
4078: close c1;
4079: hr_utility.set_location(l_proc, 35);
4080: fnd_message.set_name('BEN', 'BEN_93113_CD_CANNOT_NEXTLOWER');
4081: fnd_message.raise_error;
4082: --
4083: else

Line 4093: hr_utility.set_location('Leaving:'||l_proc, 50);

4089: end if; -- End of instr end if
4090: --
4091: end if;
4092: --
4093: hr_utility.set_location('Leaving:'||l_proc, 50);
4094: --
4095: End chk_interim_cd_cvg_calc_mthd;
4096:
4097: -- ----------------------------------------------------------------------------

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

4167:
4168:
4169:
4170: Begin
4171: hr_utility.set_location('Entering:'||l_proc, 5);
4172:
4173: open c2;
4174: fetch c2 into l_pgm_id,l_pl_id;
4175: close c2;

Line 4191: hr_utility.set_location('Leaving:'||l_proc, 15);

4187: fnd_message.raise_error;
4188:
4189: end if;
4190: close c1;
4191: hr_utility.set_location('Leaving:'||l_proc, 15);
4192: End chk_plan_delete_in_pgm;
4193: --
4194: -- ----------------------------------------------------------------------------
4195: -- |--------------------------< dt_update_validate >--------------------------|

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

4232: l_integrity_error Exception;
4233: l_table_name all_tables.table_name%TYPE;
4234: --
4235: Begin
4236: hr_utility.set_location('Entering:'||l_proc, 5);
4237: --
4238: -- Ensure that the p_datetrack_mode argument is not null
4239: --
4240: hr_api.mandatory_arg_error

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

4291: End If;
4292: --
4293: End If;
4294: --
4295: hr_utility.set_location(' Leaving:'||l_proc, 10);
4296: Exception
4297: When l_integrity_error Then
4298: --
4299: -- A referential integrity check was violated therefore

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

4356: l_rows_exist Exception;
4357: l_table_name all_tables.table_name%TYPE;
4358: --
4359: Begin
4360: hr_utility.set_location('Entering:'||l_proc, 5);
4361: --
4362: -- Ensure that the p_datetrack_mode argument is not null
4363: --
4364: hr_api.mandatory_arg_error

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

4410: End If;
4411: --
4412: End If;
4413: --
4414: hr_utility.set_location(' Leaving:'||l_proc, 10);
4415: Exception
4416: When l_rows_exist Then
4417: --
4418: -- A referential integrity check was violated therefore

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

4442: --
4443: l_proc varchar2(72) := g_package||'insert_validate';
4444: --
4445: Begin
4446: hr_utility.set_location('Entering:'||l_proc, 5);
4447: --
4448: -- Call all supporting business operations
4449: --
4450: --

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

4806: p_trk_inelig_per_flag => p_rec.trk_inelig_per_flag,
4807: p_effective_date => p_effective_date,
4808: p_object_version_number => p_rec.object_version_number);
4809: --
4810: hr_utility.set_location(' Leaving:'||l_proc, 10);
4811: End insert_validate;
4812: --
4813: -- ----------------------------------------------------------------------------
4814: -- |---------------------------< update_validate >----------------------------|

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

4822: --
4823: l_proc varchar2(72) := g_package||'update_validate';
4824: --
4825: Begin
4826: hr_utility.set_location('Entering:'||l_proc, 5);
4827: --
4828: -- Call all supporting business operations
4829: --
4830: --

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

5199: p_datetrack_mode => p_datetrack_mode,
5200: p_validation_start_date => p_validation_start_date,
5201: p_validation_end_date => p_validation_end_date);
5202: --
5203: hr_utility.set_location(' Leaving:'||l_proc, 10);
5204: End update_validate;
5205: --
5206: -- ----------------------------------------------------------------------------
5207: -- |---------------------------< delete_validate >----------------------------|

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

5215: --
5216: l_proc varchar2(72) := g_package||'delete_validate';
5217: --
5218: Begin
5219: hr_utility.set_location('Entering:'||l_proc, 5);
5220: --
5221: -- Call all supporting business operations
5222: --
5223: dt_delete_validate

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

5234: );
5235:
5236:
5237: --
5238: hr_utility.set_location(' Leaving:'||l_proc, 10);
5239: End delete_validate;
5240: --
5241: --
5242: -- ---------------------------------------------------------------------------

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

5261: l_proc varchar2(72) := g_package||'return_legislation_code';
5262: --
5263: begin
5264: --
5265: hr_utility.set_location('Entering:'|| l_proc, 10);
5266: --
5267: -- Ensure that all the mandatory parameter are not null
5268: --
5269: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

5286: end if;
5287: --
5288: close csr_leg_code;
5289: --
5290: hr_utility.set_location(' Leaving:'|| l_proc, 20);
5291: --
5292: return l_legislation_code;
5293:
5294: --