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

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

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

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

68: fnd_message.raise_error;
69: end if;
70: close c1;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 15);
73: --
74: End chk_duplicate_ordr_num;
75: --
76: -- ----------------------------------------------------------------------------

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

120: and p_validation_start_date <= effective_end_date
121: and p_validation_end_date >= effective_start_date;
122: --
123: Begin
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: open c1;
126: fetch c1 into l_dummy;
127: if c1%found then
128: fnd_message.set_name('BEN','BEN_91722_DUP_PL_TYP_ID_IN_PGM');

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

128: fnd_message.set_name('BEN','BEN_91722_DUP_PL_TYP_ID_IN_PGM');
129: fnd_message.raise_error;
130: end if;
131: close c1;
132: hr_utility.set_location('Leaving:'||l_proc, 15);
133: End chk_dup_pl_typ_id_in_pgm;
134: --
135: -- ----------------------------------------------------------------------------
136: -- |------< chk_pl_typ_waivable >------|

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

180: and plip.effective_end_date;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_ctp_shd.api_updating
187: (p_ptip_id => p_ptip_id,
188: p_effective_date => p_effective_date,

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

205: end if;
206: --
207: end if;
208: --
209: hr_utility.set_location('Leaving:'||l_proc, 15);
210: End chk_pl_typ_waivable;
211: --
212: -- ----------------------------------------------------------------------------
213: -- |------< chk_date_dpndcy >------|

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

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

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

283: end if;
284: --
285: end if;
286: --
287: hr_utility.set_location('Leaving:'||l_proc,10);
288: --
289: end chk_date_dpndcy;
290: --
291: -- ----------------------------------------------------------------------------

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

337: and business_group_id + 0 = p_business_group_id
338: and TMPRL_FCTR_APLS_RTS_FLAG = 'Y';
339: --
340: Begin
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: open c1;
344: fetch c1 into l_dummy;
345: if c1%found then

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

352: close c2;
353: end if;
354: close c1;
355: --
356: hr_utility.set_location('Leaving:'||l_proc, 15);
357: End chk_plan_typ_temporal;
358: */
359: --
360: -- ----------------------------------------------------------------------------

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_ctp_shd.api_updating
399: (p_effective_date => p_effective_date,
400: p_ptip_id => p_ptip_id,

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

421: end if;
422: --
423: end if;
424: --
425: hr_utility.set_location('Leaving:'||l_proc, 10);
426: --
427: End chk_ptip_id;
428: --
429: -- ----------------------------------------------------------------------------

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

461: l_api_updating boolean;
462: --
463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_ctp_shd.api_updating
468: (p_ptip_id => p_ptip_id,
469: p_effective_date => p_effective_date,

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

490: end if;
491: --
492: end if;
493: --
494: hr_utility.set_location('Leaving:'||l_proc,10);
495: --
496: end chk_rqd_enrt_perd_tco_cd;
497: --
498: --

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

505: l_api_updating boolean;
506: --
507: Begin
508: --
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: l_api_updating := ben_ctp_shd.api_updating
512: (p_ptip_id => p_ptip_id,
513: p_effective_date => p_effective_date,

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

539: end if;
540: --
541: end if;
542: --
543: hr_utility.set_location('Leaving:'||l_proc,10);
544: --
545: end chk_vrfy_fmly_mmbr_cd;
546: --
547: --

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

560: l_api_updating boolean;
561: --
562: Begin
563: --
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: l_api_updating := ben_ctp_shd.api_updating
567: (p_effective_date => p_effective_date,
568: p_ptip_id => p_ptip_id,

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

593: end if;
594: --
595: end if;
596: --
597: hr_utility.set_location('Leaving:'||l_proc,10);
598: --
599: end chk_vrfy_fmly_mmbr_rl;
600: --
601:

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

637: l_api_updating boolean;
638: --
639: Begin
640: --
641: hr_utility.set_location('Entering:'||l_proc, 5);
642: --
643: l_api_updating := ben_ctp_shd.api_updating
644: (p_ptip_id => p_ptip_id,
645: p_effective_date => p_effective_date,

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

666: end if;
667: --
668: end if;
669: --
670: hr_utility.set_location('Leaving:'||l_proc,10);
671: --
672: end chk_no_mn_pl_typ_overid_flag;
673: --
674: -- ----------------------------------------------------------------------------

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

706: l_api_updating boolean;
707: --
708: Begin
709: --
710: hr_utility.set_location('Entering:'||l_proc, 5);
711: --
712: l_api_updating := ben_ctp_shd.api_updating
713: (p_ptip_id => p_ptip_id,
714: p_effective_date => p_effective_date,

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

737: end if;
738: --
739: end if;
740: --
741: hr_utility.set_location('Leaving:'||l_proc,10);
742: --
743: end chk_drvbl_fctr_apls_rts_flag;
744: --
745: -- ----------------------------------------------------------------------------

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

777: l_api_updating boolean;
778: --
779: Begin
780: --
781: hr_utility.set_location('Entering:'||l_proc, 5);
782: --
783: l_api_updating := ben_ctp_shd.api_updating
784: (p_ptip_id => p_ptip_id,
785: p_effective_date => p_effective_date,

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

808: end if;
809: --
810: end if;
811: --
812: hr_utility.set_location('Leaving:'||l_proc,10);
813: --
814: end chk_drvbl_fctr_prtn_elig_flag;
815: --
816:

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

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

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

858: end if;
859: --
860: --leaving Procedure.
861: --
862: hr_utility.set_location('Leaving:'||l_proc,10);
863: --
864: end chk_cd_rl_combination;
865:
866: --

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

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

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

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

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

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

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

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

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

1043: l_api_updating boolean;
1044: --
1045: Begin
1046: --
1047: hr_utility.set_location('Entering:'||l_proc, 5);
1048: --
1049: l_api_updating := ben_ctp_shd.api_updating
1050: (p_ptip_id => p_ptip_id,
1051: p_effective_date => p_effective_date,

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

1074: end if;
1075: --
1076: end if;
1077: --
1078: hr_utility.set_location('Leaving:'||l_proc,10);
1079: --
1080: end chk_trk_inelig_per_flag;
1081: --
1082: -- ----------------------------------------------------------------------------

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

1114: l_api_updating boolean;
1115: --
1116: Begin
1117: --
1118: hr_utility.set_location('Entering:'||l_proc, 5);
1119: --
1120: l_api_updating := ben_ctp_shd.api_updating
1121: (p_ptip_id => p_ptip_id,
1122: p_effective_date => p_effective_date,

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

1145: end if;
1146: --
1147: end if;
1148: --
1149: hr_utility.set_location('Leaving:'||l_proc,10);
1150: --
1151: end chk_sbj_to_sps_lf_ins_mx_flag;
1152: --
1153: -- ----------------------------------------------------------------------------

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

1185: l_api_updating boolean;
1186: --
1187: Begin
1188: --
1189: hr_utility.set_location('Entering:'||l_proc, 5);
1190: --
1191: l_api_updating := ben_ctp_shd.api_updating
1192: (p_ptip_id => p_ptip_id,
1193: p_effective_date => p_effective_date,

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

1216: end if;
1217: --
1218: end if;
1219: --
1220: hr_utility.set_location('Leaving:'||l_proc,10);
1221: --
1222: end chk_sbj_to_dpnt_lf_ins_mx_flag;
1223: --
1224: -- ----------------------------------------------------------------------------

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

1256: l_api_updating boolean;
1257: --
1258: Begin
1259: --
1260: hr_utility.set_location('Entering:'||l_proc, 5);
1261: --
1262: l_api_updating := ben_ctp_shd.api_updating
1263: (p_ptip_id => p_ptip_id,
1264: p_effective_date => p_effective_date,

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

1287: end if;
1288: --
1289: end if;
1290: --
1291: hr_utility.set_location('Leaving:'||l_proc,10);
1292: --
1293: end chk_use_to_sum_ee_lf_ins_flag;
1294: --
1295: -- ----------------------------------------------------------------------------

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

1327: l_api_updating boolean;
1328: --
1329: Begin
1330: --
1331: hr_utility.set_location('Entering:'||l_proc, 5);
1332: --
1333: l_api_updating := ben_ctp_shd.api_updating
1334: (p_ptip_id => p_ptip_id,
1335: p_effective_date => p_effective_date,

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

1356: end if;
1357: --
1358: end if;
1359: --
1360: hr_utility.set_location('Leaving:'||l_proc,10);
1361: --
1362: end chk_drvd_fctr_dpnt_cvg_flag;
1363: --
1364: -- ----------------------------------------------------------------------------

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

1396: l_api_updating boolean;
1397: --
1398: Begin
1399: --
1400: hr_utility.set_location('Entering:'||l_proc, 5);
1401: --
1402: l_api_updating := ben_ctp_shd.api_updating
1403: (p_ptip_id => p_ptip_id,
1404: p_effective_date => p_effective_date,

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

1427: end if;
1428: --
1429: end if;
1430: --
1431: hr_utility.set_location('Leaving:'||l_proc,10);
1432: --
1433: end chk_dpnt_dob_rqd_flag;
1434: --
1435: --

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

1468: l_api_updating boolean;
1469: --
1470: Begin
1471: --
1472: hr_utility.set_location('Entering:'||l_proc, 5);
1473: --
1474: l_api_updating := ben_ctp_shd.api_updating
1475: (p_ptip_id => p_ptip_id,
1476: p_effective_date => p_effective_date,

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

1499: end if;
1500: --
1501: end if;
1502: --
1503: hr_utility.set_location('Leaving:'||l_proc,10);
1504: --
1505: end chk_dpnt_legv_id_rqd_flag;
1506: --
1507: -- ----------------------------------------------------------------------------

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

1539: l_api_updating boolean;
1540: --
1541: Begin
1542: --
1543: hr_utility.set_location('Entering:'||l_proc, 5);
1544: --
1545: l_api_updating := ben_ctp_shd.api_updating
1546: (p_ptip_id => p_ptip_id,
1547: p_effective_date => p_effective_date,

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

1568: end if;
1569: --
1570: end if;
1571: --
1572: hr_utility.set_location('Leaving:'||l_proc,10);
1573: --
1574: end chk_wvbl_flag;
1575: --
1576: -- ----------------------------------------------------------------------------

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

1608: l_api_updating boolean;
1609: --
1610: Begin
1611: --
1612: hr_utility.set_location('Entering:'||l_proc, 5);
1613: --
1614: l_api_updating := ben_ctp_shd.api_updating
1615: (p_ptip_id => p_ptip_id,
1616: p_effective_date => p_effective_date,

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

1639: end if;
1640: --
1641: end if;
1642: --
1643: hr_utility.set_location('Leaving:'||l_proc,10);
1644: --
1645: end chk_dpnt_adrs_rqd_flag;
1646: --
1647: --

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

1680: l_api_updating boolean;
1681: --
1682: Begin
1683: --
1684: hr_utility.set_location('Entering:'||l_proc, 5);
1685: --
1686: l_api_updating := ben_ctp_shd.api_updating
1687: (p_ptip_id => p_ptip_id,
1688: p_effective_date => p_effective_date,

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

1711: end if;
1712: --
1713: end if;
1714: --
1715: hr_utility.set_location('Leaving:'||l_proc,10);
1716: --
1717: end chk_dpnt_cvg_no_ctfn_rqd_flag;
1718: --
1719: -- ----------------------------------------------------------------------------

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

1751: l_api_updating boolean;
1752: --
1753: Begin
1754: --
1755: hr_utility.set_location('Entering:'||l_proc, 5);
1756: --
1757: l_api_updating := ben_ctp_shd.api_updating
1758: (p_ptip_id => p_ptip_id,
1759: p_effective_date => p_effective_date,

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

1780: end if;
1781: --
1782: end if;
1783: --
1784: hr_utility.set_location('Leaving:'||l_proc,10);
1785: --
1786: end chk_rqd_perd_enrt_nenrt_tm_uom;
1787: --
1788: -- ----------------------------------------------------------------------------

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

1820: l_api_updating boolean;
1821: --
1822: Begin
1823: --
1824: hr_utility.set_location('Entering:'||l_proc, 5);
1825: --
1826: l_api_updating := ben_ctp_shd.api_updating
1827: (p_ptip_id => p_ptip_id,
1828: p_effective_date => p_effective_date,

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

1849: end if;
1850: --
1851: end if;
1852: --
1853: hr_utility.set_location('Leaving:'||l_proc,10);
1854: --
1855: end chk_prvds_cr_flag;
1856: --
1857: -- ----------------------------------------------------------------------------

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

1889: l_api_updating boolean;
1890: --
1891: Begin
1892: --
1893: hr_utility.set_location('Entering:'||l_proc, 5);
1894: --
1895: l_api_updating := ben_ctp_shd.api_updating
1896: (p_ptip_id => p_ptip_id,
1897: p_effective_date => p_effective_date,

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

1918: end if;
1919: --
1920: end if;
1921: --
1922: hr_utility.set_location('Leaving:'||l_proc,10);
1923: --
1924: end chk_no_mx_pl_typ_ovrid_flag;
1925: --
1926: -- ----------------------------------------------------------------------------

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

1958: l_api_updating boolean;
1959: --
1960: Begin
1961: --
1962: hr_utility.set_location('Entering:'||l_proc, 5);
1963: --
1964: l_api_updating := ben_ctp_shd.api_updating
1965: (p_ptip_id => p_ptip_id,
1966: p_effective_date => p_effective_date,

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

1987: end if;
1988: --
1989: end if;
1990: --
1991: hr_utility.set_location('Leaving:'||l_proc,10);
1992: --
1993: end chk_ptip_stat_cd;
1994: --
1995: -- ----------------------------------------------------------------------------

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

2028: l_api_updating boolean;
2029: --
2030: Begin
2031: --
2032: hr_utility.set_location('Entering:'||l_proc, 5);
2033: --
2034: l_api_updating := ben_ctp_shd.api_updating
2035: (p_ptip_id => p_ptip_id,
2036: p_effective_date => p_effective_date,

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

2057: end if;
2058: --
2059: end if;
2060: --
2061: hr_utility.set_location('Leaving:'||l_proc,10);
2062: --
2063: end chk_crs_this_pl_typ_only_flag;
2064: --
2065: --

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

2102: l_api_updating boolean;
2103: --
2104: Begin
2105: --
2106: hr_utility.set_location('Entering:'||l_proc, 5);
2107: --
2108: l_api_updating := ben_ctp_shd.api_updating
2109: (p_ptip_id => p_ptip_id,
2110: p_effective_date => p_effective_date,

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

2142: fnd_message.raise_error;
2143: end if;
2144:
2145: --
2146: hr_utility.set_location('Leaving:'||l_proc,10);
2147: --
2148: end chk_dpnt_dsgn_cd;
2149: --
2150: -- ----------------------------------------------------------------------------

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

2200: and ff.effective_end_date;
2201: --
2202: Begin
2203: --
2204: hr_utility.set_location('Entering:'||l_proc, 5);
2205: --
2206: l_api_updating := ben_ctp_shd.api_updating
2207: (p_ptip_id => p_ptip_id,
2208: p_effective_date => p_effective_date,

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

2238: close c1;
2239: --
2240: end if;
2241: --
2242: hr_utility.set_location('Leaving:'||l_proc,10);
2243: --
2244: end chk_postelcn_edit_rl;
2245: --
2246: -- ----------------------------------------------------------------------------

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

2296: and ff.effective_end_date;
2297: --
2298: Begin
2299: --
2300: hr_utility.set_location('Entering:'||l_proc, 5);
2301: --
2302: l_api_updating := ben_ctp_shd.api_updating
2303: (p_ptip_id => p_ptip_id,
2304: p_effective_date => p_effective_date,

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

2334: close c1;
2335: --
2336: end if;
2337: --
2338: hr_utility.set_location('Leaving:'||l_proc,10);
2339: --
2340: end chk_rt_end_dt_rl;
2341: --
2342: --

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

2393: and ff.effective_end_date;
2394: --
2395: Begin
2396: --
2397: hr_utility.set_location('Entering:'||l_proc, 5);
2398: --
2399: l_api_updating := ben_ctp_shd.api_updating
2400: (p_ptip_id => p_ptip_id,
2401: p_effective_date => p_effective_date,

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

2431: close c1;
2432: --
2433: end if;
2434: --
2435: hr_utility.set_location('Leaving:'||l_proc,10);
2436: --
2437: end chk_rt_strt_dt_rl;
2438: --
2439: -- ----------------------------------------------------------------------------

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

2489: and ff.effective_end_date;
2490: --
2491: Begin
2492: --
2493: hr_utility.set_location('Entering:'||l_proc, 5);
2494: --
2495: l_api_updating := ben_ctp_shd.api_updating
2496: (p_ptip_id => p_ptip_id,
2497: p_effective_date => p_effective_date,

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

2527: close c1;
2528: --
2529: end if;
2530: --
2531: hr_utility.set_location('Leaving:'||l_proc,10);
2532: --
2533: end chk_enrt_cvg_end_dt_rl;
2534: --
2535: -- ----------------------------------------------------------------------------

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

2585: and ff.effective_end_date;
2586: --
2587: Begin
2588: --
2589: hr_utility.set_location('Entering:'||l_proc, 5);
2590: --
2591: l_api_updating := ben_ctp_shd.api_updating
2592: (p_ptip_id => p_ptip_id,
2593: p_effective_date => p_effective_date,

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

2623: close c1;
2624: --
2625: end if;
2626: --
2627: hr_utility.set_location('Leaving:'||l_proc,10);
2628: --
2629: end chk_enrt_cvg_strt_dt_rl;
2630: --
2631: --

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

2682: and ff.effective_end_date;
2683: --
2684: Begin
2685: --
2686: hr_utility.set_location('Entering:'||l_proc, 5);
2687: --
2688: l_api_updating := ben_ctp_shd.api_updating
2689: (p_ptip_id => p_ptip_id,
2690: p_effective_date => p_effective_date,

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

2720: close c1;
2721: --
2722: end if;
2723: --
2724: hr_utility.set_location('Leaving:'||l_proc,10);
2725: --
2726: end chk_rqd_perd_enrt_nenrt_rl;
2727: --
2728: -- ----------------------------------------------------------------------------

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

2778: and ff.effective_end_date;
2779: --
2780: Begin
2781: --
2782: hr_utility.set_location('Entering:'||l_proc, 5);
2783: --
2784: l_api_updating := ben_ctp_shd.api_updating
2785: (p_ptip_id => p_ptip_id,
2786: p_effective_date => p_effective_date,

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

2816: close c1;
2817: --
2818: end if;
2819: --
2820: hr_utility.set_location('Leaving:'||l_proc,10);
2821: --
2822: end chk_auto_enrt_mthd_rl;
2823: --
2824: -- ----------------------------------------------------------------------------

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

2874: and ff.effective_end_date;
2875: --
2876: Begin
2877: --
2878: hr_utility.set_location('Entering:'||l_proc, 5);
2879: --
2880: l_api_updating := ben_ctp_shd.api_updating
2881: (p_ptip_id => p_ptip_id,
2882: p_effective_date => p_effective_date,

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

2912: close c1;
2913: --
2914: end if;
2915: --
2916: hr_utility.set_location('Leaving:'||l_proc,10);
2917: --
2918: end chk_enrt_rl;
2919: --
2920: -- ----------------------------------------------------------------------------

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

2970: and ff.effective_end_date;
2971: --
2972: Begin
2973: --
2974: hr_utility.set_location('Entering:'||l_proc, 5);
2975: --
2976: l_api_updating := ben_ctp_shd.api_updating
2977: (p_ptip_id => p_ptip_id,
2978: p_effective_date => p_effective_date,

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

3008: close c1;
3009: --
3010: end if;
3011: --
3012: hr_utility.set_location('Leaving:'||l_proc,10);
3013: --
3014: end chk_dflt_enrt_det_rl;
3015: --
3016: -- ----------------------------------------------------------------------------

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

3048: l_api_updating boolean;
3049: --
3050: Begin
3051: --
3052: hr_utility.set_location('Entering:'||l_proc, 5);
3053: --
3054: l_api_updating := ben_ctp_shd.api_updating
3055: (p_ptip_id => p_ptip_id,
3056: p_effective_date => p_effective_date,

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

3082: --
3083: --
3084: end if;
3085: --
3086: hr_utility.set_location('Leaving:'||l_proc,10);
3087: --
3088: end chk_enrt_mthd_cd;
3089: --
3090: -- ----------------------------------------------------------------------------

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

3122: l_api_updating boolean;
3123: --
3124: Begin
3125: --
3126: hr_utility.set_location('Entering:'||l_proc, 5);
3127: --
3128: l_api_updating := ben_ctp_shd.api_updating
3129: (p_ptip_id => p_ptip_id,
3130: p_effective_date => p_effective_date,

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

3156: --
3157: --
3158: end if;
3159: --
3160: hr_utility.set_location('Leaving:'||l_proc,10);
3161: --
3162: end chk_enrt_cd;
3163: --
3164: -- ----------------------------------------------------------------------------

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

3196: l_api_updating boolean;
3197: --
3198: Begin
3199: --
3200: hr_utility.set_location('Entering:'||l_proc, 5);
3201: --
3202: l_api_updating := ben_ctp_shd.api_updating
3203: (p_ptip_id => p_ptip_id,
3204: p_effective_date => p_effective_date,

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

3230: --
3231: --
3232: end if;
3233: --
3234: hr_utility.set_location('Leaving:'||l_proc,10);
3235: --
3236: end chk_dflt_enrt_cd;
3237: --
3238: -- ----------------------------------------------------------------------------

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

3288: and ff.effective_end_date;
3289: --
3290: Begin
3291: --
3292: hr_utility.set_location('Entering:'||l_proc, 5);
3293: --
3294: l_api_updating := ben_ctp_shd.api_updating
3295: (p_ptip_id => p_ptip_id,
3296: p_effective_date => p_effective_date,

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

3326: close c1;
3327: --
3328: end if;
3329: --
3330: hr_utility.set_location('Leaving:'||l_proc,10);
3331: --
3332: end chk_dpnt_cvg_end_dt_rl;
3333: --
3334: --

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

3385: and ff.effective_end_date;
3386: --
3387: Begin
3388: --
3389: hr_utility.set_location('Entering:'||l_proc, 5);
3390: --
3391: l_api_updating := ben_ctp_shd.api_updating
3392: (p_ptip_id => p_ptip_id,
3393: p_effective_date => p_effective_date,

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

3423: close c1;
3424: --
3425: end if;
3426: --
3427: hr_utility.set_location('Leaving:'||l_proc,10);
3428: --
3429: end chk_dpnt_cvg_strt_dt_rl;
3430: --
3431: -- ----------------------------------------------------------------------------

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

3463: l_api_updating boolean;
3464: --
3465: Begin
3466: --
3467: hr_utility.set_location('Entering:'||l_proc, 5);
3468: --
3469: l_api_updating := ben_ctp_shd.api_updating
3470: (p_ptip_id => p_ptip_id,
3471: p_effective_date => p_effective_date,

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

3496: end if;
3497: --
3498: end if;
3499: --
3500: hr_utility.set_location('Leaving:'||l_proc,10);
3501: --
3502: end chk_dpnt_cvg_strt_dt_cd;
3503: --
3504: -- ----------------------------------------------------------------------------

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

3536: l_api_updating boolean;
3537: --
3538: Begin
3539: --
3540: hr_utility.set_location('Entering:'||l_proc, 5);
3541: --
3542: l_api_updating := ben_ctp_shd.api_updating
3543: (p_ptip_id => p_ptip_id,
3544: p_effective_date => p_effective_date,

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

3569: end if;
3570: --
3571: end if;
3572: --
3573: hr_utility.set_location('Leaving:'||l_proc,10);
3574: --
3575: end chk_rt_strt_dt_cd;
3576: --
3577: -- ----------------------------------------------------------------------------

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

3609: l_api_updating boolean;
3610: --
3611: Begin
3612: --
3613: hr_utility.set_location('Entering:'||l_proc, 5);
3614: --
3615: l_api_updating := ben_ctp_shd.api_updating
3616: (p_ptip_id => p_ptip_id,
3617: 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_ctp_shd.api_updating
3689: (p_ptip_id => p_ptip_id,
3690: p_effective_date => p_effective_date,

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

3715: end if;
3716: --
3717: end if;
3718: --
3719: hr_utility.set_location('Leaving:'||l_proc,10);
3720: --
3721: end chk_enrt_cvg_end_dt_cd;
3722: --
3723: -- ----------------------------------------------------------------------------

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

3755: l_api_updating boolean;
3756: --
3757: Begin
3758: --
3759: hr_utility.set_location('Entering:'||l_proc, 5);
3760: --
3761: l_api_updating := ben_ctp_shd.api_updating
3762: (p_ptip_id => p_ptip_id,
3763: p_effective_date => p_effective_date,

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

3788: end if;
3789: --
3790: end if;
3791: --
3792: hr_utility.set_location('Leaving:'||l_proc,10);
3793: --
3794: end chk_enrt_cvg_strt_dt_cd;
3795: --
3796: --

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

3829: l_api_updating boolean;
3830: --
3831: Begin
3832: --
3833: hr_utility.set_location('Entering:'||l_proc, 5);
3834: --
3835: l_api_updating := ben_ctp_shd.api_updating
3836: (p_ptip_id => p_ptip_id,
3837: p_effective_date => p_effective_date,

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

3862: end if;
3863: --
3864: end if;
3865: --
3866: hr_utility.set_location('Leaving:'||l_proc,10);
3867: --
3868: end chk_dpnt_cvg_end_dt_cd;
3869: --
3870: -- ----------------------------------------------------------------------------

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

3902: l_api_updating boolean;
3903: --
3904: Begin
3905: --
3906: hr_utility.set_location('Entering:'||l_proc, 5);
3907: --
3908: l_api_updating := ben_ctp_shd.api_updating
3909: (p_ptip_id => p_ptip_id,
3910: p_effective_date => p_effective_date,

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

3931: end if;
3932: --
3933: end if;
3934: --
3935: hr_utility.set_location('Leaving:'||l_proc,10);
3936: --
3937: end chk_coord_cvg_for_all_pls_flag;
3938: --
3939: -- ----------------------------------------------------------------------------

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

3974: l_api_updating boolean;
3975: --
3976: Begin
3977: --
3978: hr_utility.set_location('Entering:'||l_proc, 5);
3979: --
3980: l_api_updating := ben_ctp_shd.api_updating
3981: (p_ptip_id => p_ptip_id,
3982: p_effective_date => p_effective_date,

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

4001: end if;
4002: --
4003: end if;
4004: --
4005: hr_utility.set_location('Leaving:'||l_proc,10);
4006: --
4007: end chk_rqd_perd_enrt_nenrt_dpndcy;
4008: --
4009: --

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

4046: l_api_updating boolean;
4047: --
4048: Begin
4049: --
4050: hr_utility.set_location('Entering:'||l_proc, 5);
4051: --
4052: l_api_updating := ben_ctp_shd.api_updating
4053: (p_ptip_id => p_ptip_id,
4054: p_effective_date => p_effective_date,

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

4072: end if;
4073: --
4074: end if;
4075: --
4076: hr_utility.set_location('Leaving:'||l_proc,10);
4077: --
4078: end chk_max_num_ovrd_flg_dpndcy;
4079: -- ----------------------------------------------------------------------------
4080: -- |------< chk_min_num_ovrd_flg_dpndcy >------|

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

4115: l_api_updating boolean;
4116: --
4117: Begin
4118: --
4119: hr_utility.set_location('Entering:'||l_proc, 5);
4120: --
4121: l_api_updating := ben_ctp_shd.api_updating
4122: (p_ptip_id => p_ptip_id,
4123: p_effective_date => p_effective_date,

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

4141: end if;
4142: --
4143: end if;
4144: --
4145: hr_utility.set_location('Leaving:'||l_proc,10);
4146: --
4147: end chk_min_num_ovrd_flg_dpndcy;
4148: --
4149: -- ----------------------------------------------------------------------------

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

4192: and pt.effective_end_date;
4193: --
4194: Begin
4195: --
4196: hr_utility.set_location('Entering:'||l_proc, 5);
4197: --
4198: l_api_updating := ben_ctp_shd.api_updating
4199: (p_ptip_id => p_ptip_id,
4200: p_effective_date => p_effective_date,

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

4225: end if;
4226: --
4227: end if;
4228: --
4229: hr_utility.set_location('Leaving:'||l_proc,10);
4230: --
4231: end chk_mx_enrd_alwd_ovrid_num;
4232: --
4233: -- ----------------------------------------------------------------------------

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

4276: and pt.effective_end_date;
4277: --
4278: Begin
4279: --
4280: hr_utility.set_location('Entering:'||l_proc, 5);
4281: --
4282: l_api_updating := ben_ctp_shd.api_updating
4283: (p_ptip_id => p_ptip_id,
4284: p_effective_date => p_effective_date,

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

4308: close c1;
4309: end if;
4310: end if;
4311: --
4312: hr_utility.set_location('Leaving:'||l_proc,10);
4313: --
4314: end chk_mn_enrd_rqd_ovrid_num;
4315: --
4316: -- ----------------------------------------------------------------------------

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

4358: l_api_updating boolean;
4359: --
4360: Begin
4361: --
4362: hr_utility.set_location('Entering:'||l_proc, 5);
4363: --
4364: l_api_updating := ben_ctp_shd.api_updating
4365: (p_ptip_id => p_ptip_id,
4366: p_effective_date => p_effective_date,

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

4387: end if;
4388: --
4389: end if;
4390: --
4391: hr_utility.set_location('Leaving:'||l_proc,10);
4392: --
4393: end chk_min_num_ovrd_dpndcy;
4394: --
4395: -- ----------------------------------------------------------------------------

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

4431: l_api_updating boolean;
4432: --
4433: Begin
4434: --
4435: hr_utility.set_location('Entering:'||l_proc, 5);
4436: --
4437: l_api_updating := ben_ctp_shd.api_updating
4438: (p_ptip_id => p_ptip_id,
4439: p_effective_date => p_effective_date,

Line 4453: hr_utility.set_message('BEN','BEN_91247_PT_DPNT_DSGN_RQD');

4449: --
4450: if nvl(p_dpnt_dsgn_cd,'X') not in ('R','O') and
4451: (p_drvd_fctr_dpnt_cvg_flag = 'Y' ) then
4452: --
4453: hr_utility.set_message('BEN','BEN_91247_PT_DPNT_DSGN_RQD');
4454: hr_utility.raise_error;
4455: --
4456: end if;
4457: --

Line 4454: hr_utility.raise_error;

4450: if nvl(p_dpnt_dsgn_cd,'X') not in ('R','O') and
4451: (p_drvd_fctr_dpnt_cvg_flag = 'Y' ) then
4452: --
4453: hr_utility.set_message('BEN','BEN_91247_PT_DPNT_DSGN_RQD');
4454: hr_utility.raise_error;
4455: --
4456: end if;
4457: --
4458: end if;

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

4456: end if;
4457: --
4458: end if;
4459: --
4460: hr_utility.set_location('Leaving:'||l_proc,10);
4461: --
4462: end chk_dpnt_dsgn_cd_dpndcy;
4463: --
4464: --

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

4524: and pgc.effective_end_date;
4525: --
4526: Begin
4527: --
4528: hr_utility.set_location('Entering:'||l_proc, 5);
4529: --
4530: l_api_updating := ben_ctp_shd.api_updating
4531: (p_ptip_id => p_ptip_id,
4532: p_effective_date => p_effective_date,

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

4592: --
4593: --
4594: end if;
4595: --
4596: hr_utility.set_location('Leaving:'||l_proc,10);
4597: --
4598: end chk_dpnt_dsgn_cd_detail;
4599: --
4600: --

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

4648: and pgm.effective_end_date;
4649: --
4650: Begin
4651: --
4652: hr_utility.set_location('Entering:'||l_proc, 5);
4653: --
4654: l_api_updating := ben_ctp_shd.api_updating
4655: (p_ptip_id => p_ptip_id,
4656: p_effective_date => p_effective_date,

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

4685: close c1;
4686: --
4687: end if;
4688: --
4689: hr_utility.set_location('Leaving:'||l_proc,10);
4690: --
4691: end chk_dpnt_dsgn_cd_lvl_dpndcy;
4692: --
4693: -- ----------------------------------------------------------------------------

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

4733: l_integrity_error Exception;
4734: l_table_name all_tables.table_name%TYPE;
4735: --
4736: Begin
4737: hr_utility.set_location('Entering:'||l_proc, 5);
4738: --
4739: -- Ensure that the p_datetrack_mode argument is not null
4740: --
4741: hr_api.mandatory_arg_error

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

4812: End If;
4813: --
4814: End If;
4815: --
4816: hr_utility.set_location(' Leaving:'||l_proc, 10);
4817: Exception
4818: When l_integrity_error Then
4819: --
4820: -- A referential integrity check was violated therefore

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

4877: l_rows_exist Exception;
4878: l_table_name all_tables.table_name%TYPE;
4879: --
4880: Begin
4881: hr_utility.set_location('Entering:'||l_proc, 5);
4882: --
4883: -- Ensure that the p_datetrack_mode argument is not null
4884: --
4885: hr_api.mandatory_arg_error

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

4967: End If;
4968: --
4969: End If;
4970: --
4971: hr_utility.set_location(' Leaving:'||l_proc, 10);
4972: Exception
4973: When l_rows_exist Then
4974: --
4975: -- A referential integrity check was violated therefore

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

4999: --
5000: l_proc varchar2(72) := g_package||'insert_validate';
5001: --
5002: Begin
5003: hr_utility.set_location('Entering:'||l_proc, 5);
5004: --
5005: -- Call all supporting business operations
5006: --
5007: --

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

5463: ,p_validation_start_date => p_validation_start_date
5464: ,p_validation_end_date => p_validation_end_date) ;
5465:
5466: --
5467: hr_utility.set_location(' Leaving:'||l_proc, 10);
5468: End insert_validate;
5469: --
5470: -- ----------------------------------------------------------------------------
5471: -- |---------------------------< update_validate >----------------------------|

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

5479: --
5480: l_proc varchar2(72) := g_package||'update_validate';
5481: --
5482: Begin
5483: hr_utility.set_location('Entering:'||l_proc, 5);
5484: --
5485: -- Call all supporting business operations
5486: --
5487: --

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

5952: p_datetrack_mode => p_datetrack_mode,
5953: p_validation_start_date => p_validation_start_date,
5954: p_validation_end_date => p_validation_end_date);
5955: --
5956: hr_utility.set_location(' Leaving:'||l_proc, 10);
5957: End update_validate;
5958: --
5959: -- ----------------------------------------------------------------------------
5960: -- |---------------------------< delete_validate >----------------------------|

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

5968: --
5969: l_proc varchar2(72) := g_package||'delete_validate';
5970: --
5971: Begin
5972: hr_utility.set_location('Entering:'||l_proc, 5);
5973: --
5974: -- Call all supporting business operations
5975: --
5976: dt_delete_validate

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

5978: p_validation_start_date => p_validation_start_date,
5979: p_validation_end_date => p_validation_end_date,
5980: p_ptip_id => p_rec.ptip_id);
5981: --
5982: hr_utility.set_location(' Leaving:'||l_proc, 10);
5983: End delete_validate;
5984: --
5985: --
5986: -- ---------------------------------------------------------------------------

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

6006: l_proc varchar2(72) := g_package||'return_legislation_code';
6007: --
6008: begin
6009: --
6010: hr_utility.set_location('Entering:'|| l_proc, 10);
6011: --
6012: -- Ensure that all the mandatory parameter are not null
6013: --
6014: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

6032: end if;
6033: --
6034: close csr_leg_code;
6035: --
6036: hr_utility.set_location(' Leaving:'|| l_proc, 20);
6037: --
6038: return l_legislation_code;
6039:
6040: --