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

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

29: l_proc varchar2(72) := g_package||'return_legislation_code';
30: --
31: begin
32: --
33: hr_utility.set_location('Entering: '||l_proc, 10);
34: --
35: --Ensure that all the mandatory parameters are not null
36: --
37: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

47: close csr_leg_code;
48: --
49: --The primary key is invalid therefore we must error
50: --
51: hr_utility.set_message (801, 'HR_7220_INVALID_PRIMARY_KEY');
52: fnd_message.raise_error;
53: --
54: end if;
55: --

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

54: end if;
55: --
56: close csr_leg_code;
57: --
58: hr_utility.set_location('Leaving :'||l_proc,20);
59: --
60: return l_legislation_code;
61: --
62: end return_legislation_code;

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

96: l_api_updating boolean;
97: --
98: Begin
99: --
100: hr_utility.set_location('Entering: '||l_proc,5);
101: --
102: l_api_updating := ben_pep_shd.api_updating
103: (p_effective_date => p_effective_date,
104: p_elig_per_id => p_elig_per_id,

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

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

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

179: where a.currency_code = p_rt_comp_ref_uom;
180: --
181: begin
182: --
183: hr_utility.set_location('Entering :'||l_proc,5);
184: --
185: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
186: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
187: --

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

252: close c2;
253: --
254: end if;
255: --
256: hr_utility.set_location('Leaving :'||l_proc,10);
257: --
258: end chk_comp_ref_uom;
259: --
260: -- ---------------------------------------------------------------------------

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

309: l_pgm_id ben_pgm_f.pgm_id%type;
310: --
311: begin
312: --
313: hr_utility.set_location('Entering :'||l_proc,5);
314: --
315: if p_pl_id is null and
316: p_pgm_id is null and
317: p_plip_id is null and

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

335: end if;
336: --
337: close c1;
338: --
339: hr_utility.set_location('Leaving :'||l_proc,10);
340: --
341: end chk_at_least_one_fk_set;
342: --
343: -- ---------------------------------------------------------------------------

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

376: l_api_updating boolean;
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: if (p_pl_wvd_flag = 'N' and p_wv_prtn_rsn_cd is not null) then
383: --
384: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');

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

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

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

454: l_api_updating boolean;
455: --
456: Begin
457: --
458: hr_utility.set_location('Entering:'||l_proc, 5);
459: --
460: l_api_updating := ben_pep_shd.api_updating
461: (p_elig_per_id => p_elig_per_id,
462: p_effective_date => p_effective_date,

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

509: end if;
510: --
511: end if;
512: --
513: hr_utility.set_location('Leaving:'||l_proc,10);
514: --
515: end chk_hrs_wkd_bndry_perd_cd;
516: --
517: -- ---------------------------------------------------------------------------

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

543: l_api_updating boolean;
544: --
545: Begin
546: --
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
550: --
551: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');

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

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

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

599: l_api_updating boolean;
600: --
601: Begin
602: --
603: hr_utility.set_location('Entering:'||l_proc, 5);
604: --
605: if (p_pl_wvd_flag = 'N' and p_wv_ctfn_typ_cd is not null) then
606: fnd_message.set_name('BEN','BEN_91280_ELIG_PER_PRD_FLD_WV');
607: fnd_message.raise_error;

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

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

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

677: l_api_updating boolean;
678: --
679: Begin
680: --
681: hr_utility.set_location('Entering:'||l_proc, 5);
682: --
683: /*if (p_prtn_ovridn_flag = 'N' and p_prtn_ovridn_rsn_cd is not null) or
684: (p_prtn_ovridn_flag = 'N' and p_prtn_ovridn_thru_dt is not null) then
685: fnd_message.set_name('BEN','BEN_91279_ELIG_PER_PRD_FLD_OVR');

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

713: end if;
714: --
715: end if;
716: --
717: hr_utility.set_location('Leaving:'||l_proc,10);
718: --
719: end chk_prtn_ovridn_rsn_cd;
720: --
721: -- ---------------------------------------------------------------------------

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

756: l_api_updating boolean;
757: --
758: Begin
759: --
760: hr_utility.set_location('Entering:'||l_proc, 5);
761: --
762: if (p_age_val is null and p_age_uom is not null) or
763: (p_age_uom is null and p_age_val is not null) then
764: --

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

825: end if;
826: --
827: end if;
828: --
829: hr_utility.set_location('Leaving:'||l_proc,10);
830: --
831: end chk_age_uom;
832: --
833: -- ---------------------------------------------------------------------------

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

868: l_api_updating boolean;
869: --
870: Begin
871: --
872: hr_utility.set_location('Entering:'||l_proc, 5);
873: --
874: if (p_los_val is null and p_los_uom is not null) or
875: (p_los_uom is null and p_los_val is not null) then
876: --

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

937: end if;
938: --
939: end if;
940: --
941: hr_utility.set_location('Leaving:'||l_proc,10);
942: --
943: end chk_los_uom;
944: --
945: -- ----------------------------------------------------------------------------

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

979: l_api_updating boolean;
980: --
981: begin
982: --
983: hr_utility.set_location('Entering: '||l_proc,5);
984: --
985: l_api_updating := ben_pep_shd.api_updating
986: (p_elig_per_id => p_elig_per_id,
987: p_effective_date => p_effective_date,

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

1009: end if;
1010: --
1011: end if;
1012: --
1013: hr_utility.set_location('Leaving: '||l_proc, 10);
1014: --
1015: end chk_once_r_cntug_cd;
1016: -- ----------------------------------------------------------------------------
1017: -- |------------------------------------------|

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

1050: l_api_updating boolean;
1051: --
1052: begin
1053: --
1054: hr_utility.set_location('Entering: '||l_proc,5);
1055: --
1056: l_api_updating := ben_pep_shd.api_updating
1057: (p_elig_per_id => p_elig_per_id,
1058: p_effective_date => p_effective_date,

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

1080: end if;
1081: --
1082: end if;
1083: --
1084: hr_utility.set_location('Leaving: '||l_proc, 10);
1085: --
1086: end chk_no_mx_prtn_ovrid_thru_flag;
1087: --
1088: -- ---------------------------------------------------------------------------

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

1124: --
1125: begin
1126: --
1127: /*
1128: hr_utility.set_location('Entering: '||l_proc,5);
1129: */
1130: --
1131: l_api_updating := ben_pep_shd.api_updating
1132: (p_elig_per_id => p_elig_per_id,

Line 1144: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1140: --
1141: -- check if value of lookup falls within lookup type.
1142: --
1143: /*
1144: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1145: */
1146: if hr_api.not_exists_in_hr_lookups
1147: (p_lookup_type => 'YES_NO',
1148: p_lookup_code => p_frz_comb_age_and_los_flag,

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

1156: fnd_message.raise_error;
1157: --
1158: end if;
1159: /*
1160: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1161: */
1162: --
1163: end if;
1164: --

Line 1173: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1169: --
1170: -- check if value of lookup falls within lookup type.
1171: --
1172: /*
1173: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1174: */
1175: if hr_api.not_exists_in_hr_lookups
1176: (p_lookup_type => 'YES_NO',
1177: p_lookup_code => p_rt_frz_comb_age_and_los_flag,

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

1185: fnd_message.raise_error;
1186: --
1187: end if;
1188: /*
1189: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1190: */
1191: --
1192: end if;
1193: --

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

1191: --
1192: end if;
1193: --
1194: /*
1195: hr_utility.set_location('Leaving: '||l_proc, 10);
1196: */
1197: --
1198: end chk_frz_comb_age_and_los_flag;
1199: --

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

1236: --
1237: Begin
1238: --
1239: /*
1240: hr_utility.set_location('Entering: '||l_proc,5);
1241: */
1242: --
1243: l_api_updating := ben_pep_shd.api_updating
1244: (p_elig_per_id => p_elig_per_id,

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

1267: end if;
1268: --
1269: end if;
1270: --
1271: hr_utility.set_location('Leaving: '||l_proc, 10);
1272: --
1273: end chk_dpnt_othr_pl_cvrd_rl_flag;
1274: --
1275: -- ----------------------------------------------------------------------------

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

1309: l_dummy varchar2(1);
1310: --
1311: Begin
1312: --
1313: hr_utility.set_location('Entering: '||l_proc,5);
1314: --
1315: l_api_updating := ben_pep_shd.api_updating
1316: (p_elig_per_id => p_elig_per_id,
1317: p_effective_date => p_effective_date,

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

1339: end if;
1340: --
1341: end if;
1342: --
1343: hr_utility.set_location('Leaving: '||l_proc, 10);
1344: --
1345: end chk_pl_key_ee_flag;
1346: --
1347: -- ----------------------------------------------------------------------------

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

1381: l_dummy varchar2(1);
1382: --
1383: Begin
1384: --
1385: hr_utility.set_location('Entering: '||l_proc,5);
1386: --
1387: l_api_updating := ben_pep_shd.api_updating
1388: (p_elig_per_id => p_elig_per_id,
1389: p_effective_date => p_effective_date,

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

1411: end if;
1412: --
1413: end if;
1414: --
1415: hr_utility.set_location('Leaving: '||l_proc, 10);
1416: --
1417: end chk_prtn_ovridn_flag;
1418: --
1419: -- ----------------------------------------------------------------------------

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

1453: l_dummy varchar2(1);
1454: --
1455: Begin
1456: --
1457: hr_utility.set_location('Entering: '||l_proc,5);
1458: --
1459: l_api_updating := ben_pep_shd.api_updating
1460: (p_elig_per_id => p_elig_per_id,
1461: p_effective_date => p_effective_date,

Line 1471: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1467: and p_pl_hghly_compd_flag is not null then
1468: --
1469: -- check if value of lookup falls within lookup type.
1470: --
1471: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1472: if hr_api.not_exists_in_hr_lookups
1473: (p_lookup_type => 'YES_NO',
1474: p_lookup_code => p_pl_hghly_compd_flag,
1475: p_effective_date => p_effective_date) then

Line 1485: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1481: fnd_message.set_token('TYPE','YES_NO');
1482: fnd_message.raise_error;
1483: --
1484: end if;
1485: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1486: --
1487: end if;
1488: --
1489: hr_utility.set_location('Leaving: '||l_proc, 10);

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

1485: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1486: --
1487: end if;
1488: --
1489: hr_utility.set_location('Leaving: '||l_proc, 10);
1490: --
1491: end chk_pl_hghly_compd_flag;
1492: --
1493: -- ----------------------------------------------------------------------------

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

1529: --
1530: Begin
1531: --
1532: /*
1533: hr_utility.set_location('Entering: '||l_proc,5);
1534: */
1535: --
1536: l_api_updating := ben_pep_shd.api_updating
1537: (p_elig_per_id => p_elig_per_id,

Line 1549: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1545: --
1546: -- check if value of lookup falls within lookup type.
1547: --
1548: /*
1549: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1550: */
1551: if hr_api.not_exists_in_hr_lookups
1552: (p_lookup_type => 'YES_NO',
1553: p_lookup_code => p_frz_los_flag,

Line 1565: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1561: fnd_message.raise_error;
1562: --
1563: end if;
1564: /*
1565: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1566: */
1567: --
1568: end if;
1569: --

Line 1578: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1574: --
1575: -- check if value of lookup falls within lookup type.
1576: --
1577: /*
1578: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1579: */
1580: if hr_api.not_exists_in_hr_lookups
1581: (p_lookup_type => 'YES_NO',
1582: p_lookup_code => p_rt_frz_los_flag,

Line 1594: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1590: fnd_message.raise_error;
1591: --
1592: end if;
1593: /*
1594: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1595: */
1596: --
1597: end if;
1598: --

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

1596: --
1597: end if;
1598: --
1599: /*
1600: hr_utility.set_location('Leaving: '||l_proc, 10);
1601: */
1602: --
1603: end chk_frz_los_flag;
1604: --

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

1641: --
1642: Begin
1643: --
1644: /*
1645: hr_utility.set_location('Entering: '||l_proc,5);
1646: */
1647: --
1648: l_api_updating := ben_pep_shd.api_updating
1649: (p_elig_per_id => p_elig_per_id,

Line 1661: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1657: --
1658: -- check if value of lookup falls within lookup type.
1659: --
1660: /*
1661: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1662: */
1663: if hr_api.not_exists_in_hr_lookups
1664: (p_lookup_type => 'YES_NO',
1665: p_lookup_code => p_frz_age_flag,

Line 1677: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1673: fnd_message.raise_error;
1674: --
1675: end if;
1676: /*
1677: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1678: */
1679: --
1680: end if;
1681: --

Line 1690: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1686: --
1687: -- check if value of lookup falls within lookup type.
1688: --
1689: /*
1690: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1691: */
1692: if hr_api.not_exists_in_hr_lookups
1693: (p_lookup_type => 'YES_NO',
1694: p_lookup_code => p_rt_frz_age_flag,

Line 1706: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1702: fnd_message.raise_error;
1703: --
1704: end if;
1705: /*
1706: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1707: */
1708: --
1709: end if;
1710: --

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

1708: --
1709: end if;
1710: --
1711: /*
1712: hr_utility.set_location('Leaving: '||l_proc, 10);
1713: */
1714: --
1715: end chk_frz_age_flag;
1716: --

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

1753: --
1754: Begin
1755: --
1756: /*
1757: hr_utility.set_location('Entering: '||l_proc,5);
1758: */
1759: --
1760: l_api_updating := ben_pep_shd.api_updating
1761: (p_elig_per_id => p_elig_per_id,

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

1769: --
1770: -- check if value of lookup falls within lookup type.
1771: --
1772: /*
1773: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1774: */
1775: if hr_api.not_exists_in_hr_lookups
1776: (p_lookup_type => 'YES_NO',
1777: p_lookup_code => p_frz_cmp_lvl_flag,

Line 1789: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1785: fnd_message.raise_error;
1786: --
1787: end if;
1788: /*
1789: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1790: */
1791: --
1792: end if;
1793: --

Line 1802: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1798: --
1799: -- check if value of lookup falls within lookup type.
1800: --
1801: /*
1802: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1803: */
1804: if hr_api.not_exists_in_hr_lookups
1805: (p_lookup_type => 'YES_NO',
1806: p_lookup_code => p_rt_frz_cmp_lvl_flag,

Line 1818: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1814: fnd_message.raise_error;
1815: --
1816: end if;
1817: /*
1818: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1819: */
1820: --
1821: end if;
1822: --

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

1820: --
1821: end if;
1822: --
1823: /*
1824: hr_utility.set_location('Leaving: '||l_proc, 10);
1825: */
1826: --
1827: end chk_frz_cmp_lvl_flag;
1828: --

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

1865: --
1866: Begin
1867: --
1868: /*
1869: hr_utility.set_location('Entering: '||l_proc,5);
1870: */
1871: --
1872: l_api_updating := ben_pep_shd.api_updating
1873: (p_elig_per_id => p_elig_per_id,

Line 1885: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1881: --
1882: -- check if value of lookup falls within lookup type.
1883: --
1884: /*
1885: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1886: */
1887: if hr_api.not_exists_in_hr_lookups
1888: (p_lookup_type => 'YES_NO',
1889: p_lookup_code => p_frz_pct_fl_tm_flag,

Line 1901: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1897: fnd_message.raise_error;
1898: --
1899: end if;
1900: /*
1901: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1902: */
1903: --
1904: end if;
1905: --

Line 1914: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1910: --
1911: -- check if value of lookup falls within lookup type.
1912: --
1913: /*
1914: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1915: */
1916: if hr_api.not_exists_in_hr_lookups
1917: (p_lookup_type => 'YES_NO',
1918: p_lookup_code => p_rt_frz_pct_fl_tm_flag,

Line 1930: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

1926: fnd_message.raise_error;
1927: --
1928: end if;
1929: /*
1930: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1931: */
1932: --
1933: end if;
1934: --

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

1932: --
1933: end if;
1934: --
1935: /*
1936: hr_utility.set_location('Leaving: '||l_proc, 10);
1937: */
1938: --
1939: end chk_frz_pct_fl_tm_flag;
1940: --

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

1976: l_dummy varchar2(1);
1977: --
1978: Begin
1979: --
1980: hr_utility.set_location('Entering: '||l_proc,5);
1981: --
1982: l_api_updating := ben_pep_shd.api_updating
1983: (p_elig_per_id => p_elig_per_id,
1984: p_effective_date => p_effective_date,

Line 1994: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);

1990: and p_frz_hrs_wkd_flag is not null then
1991: --
1992: -- check if value of lookup falls within lookup type.
1993: --
1994: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1995: if hr_api.not_exists_in_hr_lookups
1996: (p_lookup_type => 'YES_NO',
1997: p_lookup_code => p_frz_hrs_wkd_flag,
1998: p_effective_date => p_effective_date) then

Line 2008: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);

2004: fnd_message.set_token('TYPE','YES_NO');
2005: fnd_message.raise_error;
2006: --
2007: end if;
2008: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
2009: --
2010: end if;
2011: --
2012: if (l_api_updating and p_rt_frz_hrs_wkd_flag

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

2031: end if;
2032: --
2033: end if;
2034: --
2035: hr_utility.set_location('Leaving: '||l_proc, 10);
2036: --
2037: end chk_frz_hrs_wkd_flag;
2038: --
2039: -- ---------------------------------------------------------------------------

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

2073: l_dummy varchar2(1);
2074: --
2075: Begin
2076: --
2077: hr_utility.set_location('Entering: '||l_proc,5);
2078: --
2079: l_api_updating := ben_pep_shd.api_updating
2080: (p_elig_per_id => p_elig_per_id,
2081: p_effective_date => p_effective_date,

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

2103: end if;
2104: --
2105: end if;
2106: --
2107: hr_utility.set_location('Leaving: '||l_proc, 10);
2108: --
2109: end chk_dstr_rstcn_flag;
2110: --
2111: -- ---------------------------------------------------------------------------

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

2145: l_dummy varchar2(1);
2146: --
2147: Begin
2148: --
2149: hr_utility.set_location('Entering: '||l_proc,5);
2150: --
2151: l_api_updating := ben_pep_shd.api_updating
2152: (p_elig_per_id => p_elig_per_id,
2153: p_effective_date => p_effective_date,

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

2175: end if;
2176: --
2177: end if;
2178: --
2179: hr_utility.set_location('Leaving: '||l_proc, 10);
2180: --
2181: end chk_elig_flag;
2182: --
2183: -- ---------------------------------------------------------------------------

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

2217: l_dummy varchar2(1);
2218: --
2219: Begin
2220: --
2221: hr_utility.set_location('Entering: '||l_proc,5);
2222: --
2223: l_api_updating := ben_pep_shd.api_updating
2224: (p_elig_per_id => p_elig_per_id,
2225: p_effective_date => p_effective_date,

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

2247: end if;
2248: --
2249: end if;
2250: --
2251: hr_utility.set_location('Leaving: '||l_proc, 10);
2252: --
2253: end chk_inelg_rsn_cd;
2254: --
2255: -- ---------------------------------------------------------------------------

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

2289: l_dummy varchar2(1);
2290: --
2291: Begin
2292: --
2293: hr_utility.set_location('Entering: '||l_proc,5);
2294: --
2295: l_api_updating := ben_pep_shd.api_updating
2296: (p_elig_per_id => p_elig_per_id,
2297: p_effective_date => p_effective_date,

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

2319: end if;
2320: --
2321: end if;
2322: --
2323: hr_utility.set_location('Leaving: '||l_proc, 10);
2324: --
2325: end chk_pl_wvd_flag;
2326: --
2327: -- ----------------------------------------------------------------------------

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

2367: l_integrity_error Exception;
2368: l_table_name all_tables.table_name%TYPE;
2369: --
2370: Begin
2371: hr_utility.set_location('Entering:'||l_proc, 5);
2372: --
2373: -- Ensure that the p_datetrack_mode argument is not null
2374: --
2375: hr_api.mandatory_arg_error

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

2446: End If;
2447: --
2448: End If;
2449: --
2450: hr_utility.set_location(' Leaving:'||l_proc, 10);
2451: Exception
2452: When l_integrity_error Then
2453: --
2454: -- A referential integrity check was violated therefore

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

2513: l_rows_exist Exception;
2514: l_table_name all_tables.table_name%TYPE;
2515: --
2516: Begin
2517: hr_utility.set_location('Entering:'||l_proc, 5);
2518: --
2519: -- Ensure that the p_datetrack_mode argument is not null
2520: --
2521: hr_api.mandatory_arg_error

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

2558: End If;
2559: --
2560: End If;
2561: --
2562: hr_utility.set_location(' Leaving:'||l_proc, 10);
2563: Exception
2564: When l_rows_exist Then
2565: --
2566: -- A referential integrity check was violated therefore

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

2592: --
2593: l_proc varchar2(72) := g_package||'insert_validate';
2594: --
2595: Begin
2596: hr_utility.set_location('Entering:'||l_proc, 5);
2597: --
2598: -- Call all supporting business operations
2599: --
2600: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

2773: p_pl_wvd_flag => p_rec.pl_wvd_flag,
2774: p_effective_date => p_effective_date,
2775: p_object_version_number => p_rec.object_version_number);
2776: --
2777: hr_utility.set_location(' Leaving:'||l_proc, 10);
2778: End insert_validate;
2779: --
2780: -- ----------------------------------------------------------------------------
2781: -- |---------------------------< update_validate >----------------------------|

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

2789: --
2790: l_proc varchar2(72) := g_package||'update_validate';
2791: --
2792: Begin
2793: hr_utility.set_location('Entering:'||l_proc, 5);
2794: --
2795: -- Call all supporting business operations
2796: --
2797: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

2982: p_datetrack_mode => p_datetrack_mode,
2983: p_validation_start_date => p_validation_start_date,
2984: p_validation_end_date => p_validation_end_date);
2985: --
2986: hr_utility.set_location(' Leaving:'||l_proc, 10);
2987: End update_validate;
2988: --
2989: -- ----------------------------------------------------------------------------
2990: -- |---------------------------< delete_validate >----------------------------|

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

2998: --
2999: l_proc varchar2(72) := g_package||'delete_validate';
3000: --
3001: Begin
3002: hr_utility.set_location('Entering:'||l_proc, 5);
3003: --
3004: -- Call all supporting business operations
3005: --
3006: dt_delete_validate

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

3008: p_validation_start_date => p_validation_start_date,
3009: p_validation_end_date => p_validation_end_date,
3010: p_elig_per_id => p_rec.elig_per_id);
3011: --
3012: hr_utility.set_location(' Leaving:'||l_proc, 10);
3013: End delete_validate;
3014: --
3015: end ben_pep_bus;