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

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

49: where a.pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id;
50: --
51: Begin
52: --
53: hr_utility.set_location('Entering:'||l_proc,5);
54: --
55: l_api_updating := ben_epe_shd.api_updating
56: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
57: p_object_version_number => p_object_version_number);

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

81: close c1;
82: --
83: end if;
84: --
85: hr_utility.set_location('Leaving:'||l_proc,10);
86: --
87: End chk_pil_elctbl_chc_popl_id;
88: */
89: --

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

128: where a.pl_typ_id = p_pl_typ_id;
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc,5);
133: --
134: l_api_updating := ben_epe_shd.api_updating
135: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
136: p_object_version_number => p_object_version_number);

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

160: close c1;
161: --
162: end if;
163: --
164: hr_utility.set_location('Leaving:'||l_proc,10);
165: --
166: End chk_pl_typ_id;
167: --
168: -- ----------------------------------------------------------------------------

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

206: where a.oipl_id = p_spcl_rt_oipl_id;
207: --
208: Begin
209: --
210: hr_utility.set_location('Entering:'||l_proc,5);
211: --
212: l_api_updating := ben_epe_shd.api_updating
213: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
214: p_object_version_number => p_object_version_number);

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

238: close c1;
239: --
240: end if;
241: --
242: hr_utility.set_location('Leaving:'||l_proc,10);
243: --
244: End chk_spcl_rt_oipl_id;
245: --
246: -- ----------------------------------------------------------------------------

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

284: where a.pl_id = p_spcl_rt_pl_id;
285: --
286: Begin
287: --
288: hr_utility.set_location('Entering:'||l_proc,5);
289: --
290: l_api_updating := ben_epe_shd.api_updating
291: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
292: p_object_version_number => p_object_version_number);

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

316: close c1;
317: --
318: end if;
319: --
320: hr_utility.set_location('Leaving:'||l_proc,10);
321: --
322: End chk_spcl_rt_pl_id;
323: --
324: -- ----------------------------------------------------------------------------

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

362: where a.plip_id = p_plip_id;
363: --
364: Begin
365: --
366: hr_utility.set_location('Entering:'||l_proc,5);
367: --
368: l_api_updating := ben_epe_shd.api_updating
369: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
370: p_object_version_number => p_object_version_number);

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

394: close c1;
395: --
396: end if;
397: --
398: hr_utility.set_location('Leaving:'||l_proc,10);
399: --
400: End chk_plip_id;
401: --
402: -- ----------------------------------------------------------------------------

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

440: where a.cmbn_ptip_id = p_cmbn_ptip_id;
441: --
442: Begin
443: --
444: hr_utility.set_location('Entering:'||l_proc,5);
445: --
446: l_api_updating := ben_epe_shd.api_updating
447: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
448: p_object_version_number => p_object_version_number);

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

472: close c1;
473: --
474: end if;
475: --
476: hr_utility.set_location('Leaving:'||l_proc,10);
477: --
478: End chk_cmbn_ptip_id;
479: --
480: -- ----------------------------------------------------------------------------

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

518: where a.cmbn_plip_id = p_cmbn_plip_id;
519: --
520: Begin
521: --
522: hr_utility.set_location('Entering:'||l_proc,5);
523: --
524: l_api_updating := ben_epe_shd.api_updating
525: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
526: p_object_version_number => p_object_version_number);

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

550: close c1;
551: --
552: end if;
553: --
554: hr_utility.set_location('Leaving:'||l_proc,10);
555: --
556: End chk_cmbn_plip_id;
557: --
558: -- ----------------------------------------------------------------------------

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

596: where a.ptip_id = p_ptip_id;
597: --
598: Begin
599: --
600: hr_utility.set_location('Entering:'||l_proc,5);
601: --
602: l_api_updating := ben_epe_shd.api_updating
603: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
604: p_object_version_number => p_object_version_number);

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

628: close c1;
629: --
630: end if;
631: --
632: hr_utility.set_location('Leaving:'||l_proc,10);
633: --
634: End chk_ptip_id;
635: --
636: -- ----------------------------------------------------------------------------

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

674: where a.cmbn_ptip_opt_id = p_cmbn_ptip_opt_id;
675: --
676: Begin
677: --
678: hr_utility.set_location('Entering:'||l_proc,5);
679: --
680: l_api_updating := ben_epe_shd.api_updating
681: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
682: p_object_version_number => p_object_version_number);

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

706: close c1;
707: --
708: end if;
709: --
710: hr_utility.set_location('Leaving:'||l_proc,10);
711: --
712: End chk_cmbn_ptip_opt_id;
713: --
714: -- ----------------------------------------------------------------------------

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

752: where a.pgm_id = p_pgm_id;
753: --
754: Begin
755: --
756: hr_utility.set_location('Entering:'||l_proc,5);
757: --
758: l_api_updating := ben_epe_shd.api_updating
759: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
760: p_object_version_number => p_object_version_number);

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

784: close c1;
785: --
786: end if;
787: --
788: hr_utility.set_location('Leaving:'||l_proc,10);
789: --
790: End chk_pgm_id;
791: --
792: -- ----------------------------------------------------------------------------

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

830: where a.oipl_id = p_oipl_id;
831: --
832: Begin
833: --
834: hr_utility.set_location('Entering:'||l_proc,5);
835: --
836: l_api_updating := ben_epe_shd.api_updating
837: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
838: p_object_version_number => p_object_version_number);

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

862: close c1;
863: --
864: end if;
865: --
866: hr_utility.set_location('Leaving:'||l_proc,10);
867: --
868: End chk_oipl_id;
869: --
870: -- ----------------------------------------------------------------------------

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

908: where a.pl_id = p_pl_id;
909: --
910: Begin
911: --
912: hr_utility.set_location('Entering:'||l_proc,5);
913: --
914: l_api_updating := ben_epe_shd.api_updating
915: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
916: p_object_version_number => p_object_version_number);

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

940: close c1;
941: --
942: end if;
943: --
944: hr_utility.set_location('Leaving:'||l_proc,10);
945: --
946: End chk_pl_id;
947: --
948: -- ----------------------------------------------------------------------------

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

986: where a.bnft_prvdr_pool_id = p_bnft_prvdr_pool_id;
987: --
988: Begin
989: --
990: hr_utility.set_location('Entering:'||l_proc,5);
991: --
992: l_api_updating := ben_epe_shd.api_updating
993: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
994: p_object_version_number => p_object_version_number);

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

1018: close c1;
1019: --
1020: end if;
1021: --
1022: hr_utility.set_location('Leaving:'||l_proc,10);
1023: --
1024: End chk_bnft_prvdr_pool_id;
1025: --
1026: -- ----------------------------------------------------------------------------

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

1065: and a.prtt_enrt_rslt_stat_cd is null;
1066: --
1067: Begin
1068: --
1069: hr_utility.set_location('Entering:'||l_proc,5);
1070: --
1071: l_api_updating := ben_epe_shd.api_updating
1072: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1073: p_object_version_number => p_object_version_number);

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

1099: close c1;
1100: --
1101: end if;
1102: --
1103: hr_utility.set_location('Leaving:'||l_proc,10);
1104: --
1105: End chk_prtt_enrt_rslt_id;
1106: --
1107: -- ----------------------------------------------------------------------------

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

1146: and a.per_in_ler_stat_cd not in ('BCKDT', 'VOIDD');
1147: --
1148: Begin
1149: --
1150: hr_utility.set_location('Entering:'||l_proc,5);
1151: --
1152: l_api_updating := ben_epe_shd.api_updating
1153: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1154: p_object_version_number => p_object_version_number);

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

1179: close c1;
1180: --
1181: end if;
1182: --
1183: hr_utility.set_location('Leaving:'||l_proc,10);
1184: --
1185: End chk_per_in_ler_id;
1186: --
1187: -- ----------------------------------------------------------------------------

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

1225: where a.pl_id = p_must_enrl_anthr_pl_id;
1226: --
1227: Begin
1228: --
1229: hr_utility.set_location('Entering:'||l_proc,5);
1230: --
1231: l_api_updating := ben_epe_shd.api_updating
1232: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1233: p_object_version_number => p_object_version_number);

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

1257: close c1;
1258: --
1259: end if;
1260: --
1261: hr_utility.set_location('Leaving:'||l_proc,10);
1262: --
1263: End chk_must_enrl_anthr_pl_id;
1264: --
1265: -- ----------------------------------------------------------------------------

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

1303: where a.elig_per_elctbl_chc_id = p_int_elig_per_elctbl_chc_id;
1304: --
1305: Begin
1306: --
1307: hr_utility.set_location('Entering:'||l_proc,5);
1308: --
1309: l_api_updating := ben_epe_shd.api_updating
1310: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1311: p_object_version_number => p_object_version_number);

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

1335: close c1;
1336: --
1337: end if;
1338: --
1339: hr_utility.set_location('Leaving:'||l_proc,10);
1340: --
1341: End chk_int_elig_per_elctbl_chc_id;
1342: --
1343: -- ----------------------------------------------------------------------------

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

1381: where a.yr_perd_id = p_yr_perd_id;
1382: --
1383: Begin
1384: --
1385: hr_utility.set_location('Entering:'||l_proc,5);
1386: --
1387: l_api_updating := ben_epe_shd.api_updating
1388: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1389: p_object_version_number => p_object_version_number);

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

1413: close c1;
1414: --
1415: end if;
1416: --
1417: hr_utility.set_location('Leaving:'||l_proc,10);
1418: --
1419: End chk_yr_perd_id;
1420: --
1421: -- -------------------------------------------------------------------------

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

1457: --
1458: Begin
1459: --
1460: /*
1461: hr_utility.set_location('Entering:'||l_proc, 5);
1462: */
1463: --
1464: l_api_updating := ben_epe_shd.api_updating
1465: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,

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

1473: --
1474: -- check if value of lookup falls within lookup type.
1475: --
1476: /*
1477: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1478: */
1479: if hr_api.not_exists_in_hr_lookups
1480: (p_lookup_type => p_lookup_type,
1481: p_lookup_code => p_cd,

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

1488: fnd_message.set_token('TYPE',p_lookup_type);
1489: fnd_message.raise_error;
1490: end if;
1491: /*
1492: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1493: */
1494: end if;
1495: /*
1496: hr_utility.set_location('Leaving:'||l_proc,10);

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

1492: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1493: */
1494: end if;
1495: /*
1496: hr_utility.set_location('Leaving:'||l_proc,10);
1497: */
1498: end chk_all_cds;
1499:
1500: --

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

1536:
1537: Begin
1538: --
1539: /*
1540: hr_utility.set_location('Entering:'||l_proc, 5);
1541: --
1542: */
1543: l_api_updating := ben_epe_shd.api_updating
1544: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,

Line 1549: hr_utility.set_location(l_proc||' updating true', 10);

1545: p_object_version_number => p_object_version_number);
1546: --
1547: /*
1548: if l_api_updating then
1549: hr_utility.set_location(l_proc||' updating true', 10);
1550: else
1551: hr_utility.set_location(l_proc||' updating false', 20);
1552: end if;
1553: hr_utility.set_location(l_proc||' pflag='||p_flag, 30);

Line 1551: hr_utility.set_location(l_proc||' updating false', 20);

1547: /*
1548: if l_api_updating then
1549: hr_utility.set_location(l_proc||' updating true', 10);
1550: else
1551: hr_utility.set_location(l_proc||' updating false', 20);
1552: end if;
1553: hr_utility.set_location(l_proc||' pflag='||p_flag, 30);
1554: */
1555: if (l_api_updating

Line 1553: hr_utility.set_location(l_proc||' pflag='||p_flag, 30);

1549: hr_utility.set_location(l_proc||' updating true', 10);
1550: else
1551: hr_utility.set_location(l_proc||' updating false', 20);
1552: end if;
1553: hr_utility.set_location(l_proc||' pflag='||p_flag, 30);
1554: */
1555: if (l_api_updating
1556: and p_flag
1557: <> nvl(p_old_flag,hr_api.g_varchar2)

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

1560: -- check if value of lookup falls within lookup type.
1561: --
1562: --
1563: /*
1564: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1565: */
1566: if hr_api.not_exists_in_hr_lookups
1567: (p_lookup_type => 'YES_NO',
1568: p_lookup_code => p_flag,

Line 1574: hr_utility.set_location(l_proc, 40);

1570: --
1571: -- raise error as does not exist as lookup
1572: --
1573: /*
1574: hr_utility.set_location(l_proc, 40);
1575: */
1576: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1577: fnd_message.set_token('FIELD', p_flag);
1578: fnd_message.set_token('TYPE','YES_NO');

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

1579: fnd_message.raise_error;
1580: --
1581: end if;
1582: /*
1583: hr_utility.set_location('Dn HRAPI_NEIHL:'||l_proc, 5);
1584: */
1585: --
1586: end if;
1587: --

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

1585: --
1586: end if;
1587: --
1588: /*
1589: hr_utility.set_location('Leaving:'||l_proc,50);
1590: --
1591: */
1592: end chk_all_flags;
1593: --

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

1644: and ff.effective_end_date;
1645: --
1646: Begin
1647: --
1648: hr_utility.set_location('Entering:'||l_proc, 5);
1649: --
1650: l_api_updating := ben_epe_shd.api_updating
1651: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1652: p_object_version_number => p_object_version_number);

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

1681: close c1;
1682: --
1683: end if;
1684: --
1685: hr_utility.set_location('Leaving:'||l_proc,10);
1686: --
1687: end chk_enrt_cvg_strt_dt_rl;
1688: --
1689: -- ----------------------------------------------------------------------------

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

1739: and ff.effective_end_date;
1740: --
1741: Begin
1742: --
1743: hr_utility.set_location('Entering:'||l_proc, 5);
1744: --
1745: l_api_updating := ben_epe_shd.api_updating
1746: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
1747: p_object_version_number => p_object_version_number);

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

1776: close c1;
1777: --
1778: end if;
1779: --
1780: hr_utility.set_location('Leaving:'||l_proc,10);
1781: --
1782: end chk_dpnt_cvg_strt_dt_rl;
1783: --
1784: -- ---------------------------------------------------------------------------

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

1822: l_proc varchar2(72) := g_package||'return_legislation_code';
1823: --
1824: begin
1825: --
1826: hr_utility.set_location('Entering:'|| l_proc, 10);
1827: --
1828: -- Ensure that all the mandatory parameter are not null
1829: --
1830: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1847: end if;
1848: --
1849: close csr_leg_code;
1850: --
1851: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1852: --
1853: return l_legislation_code;
1854: --
1855: end return_legislation_code;

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

1862: --
1863: l_proc varchar2(72) := g_package||'insert_validate';
1864: --
1865: Begin
1866: hr_utility.set_location('Entering:'||l_proc, 5);
1867: --
1868: -- Call context sensitive validate bgp cache routine
1869: --
1870: ben_batch_dt_api.batch_validate_bgp_id

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

2125: p_business_group_id => p_rec.business_group_id,
2126: p_effective_date => p_effective_date,
2127: p_object_version_number => p_rec.object_version_number);
2128: --
2129: hr_utility.set_location(' Leaving:'||l_proc, 10);
2130: End insert_validate;
2131: --
2132: -- ----------------------------------------------------------------------------
2133: -- |---------------------------< update_validate >----------------------------|

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

2137: --
2138: l_proc varchar2(72) := g_package||'update_validate';
2139: --
2140: Begin
2141: hr_utility.set_location('Entering:'||l_proc, 5);
2142: --
2143: -- Call context sensitive validate bgp cache routine
2144: --
2145: ben_batch_dt_api.batch_validate_bgp_id

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

2401: p_business_group_id => p_rec.business_group_id,
2402: p_effective_date => p_effective_date,
2403: p_object_version_number => p_rec.object_version_number);
2404: --
2405: hr_utility.set_location(' Leaving:'||l_proc, 10);
2406: End update_validate;
2407: --
2408: -- ----------------------------------------------------------------------------
2409: -- |---------------------------< delete_validate >----------------------------|

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

2413: --
2414: l_proc varchar2(72) := g_package||'delete_validate';
2415: --
2416: Begin
2417: hr_utility.set_location('Entering:'||l_proc, 5);
2418: --
2419: -- Call all supporting business operations
2420: --
2421: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

2417: hr_utility.set_location('Entering:'||l_proc, 5);
2418: --
2419: -- Call all supporting business operations
2420: --
2421: hr_utility.set_location(' Leaving:'||l_proc, 10);
2422: End delete_validate;
2423: --
2424: end ben_epe_bus;