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

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_bpp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_bnft_prvdr_pool_id;
78: --
79: -- ----------------------------------------------------------------------------

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

122: between a.effective_start_date
123: and a.effective_end_date;
124: --
125: Begin
126: hr_utility.set_location('Entering:'||l_proc, 5);
127: --
128: l_api_updating := ben_bpp_shd.api_updating
129: (p_effective_date => p_effective_date,
130: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,

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

143: fnd_message.raise_error;
144: end if;
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc, 15);
148: End chk_name_unique;
149: --
150: -- ----------------------------------------------------------------------------
151: -- |----------------------< chk_mutual_exlsv_mn_val_flg >--------------------|

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

186: l_api_updating boolean;
187: --
188: Begin
189: --
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: l_api_updating := ben_bpp_shd.api_updating
193: (p_effective_date => p_effective_date,
194: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,

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

203: fnd_message.raise_error;
204: --
205: end if;
206: --
207: hr_utility.set_location('Leaving:'||l_proc, 10);
208: --
209: End chk_mutual_exlsv_mn_val_flg;
210: --
211: -- ----------------------------------------------------------------------------

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

247: l_api_updating boolean;
248: --
249: Begin
250: --
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: l_api_updating := ben_bpp_shd.api_updating
254: (p_effective_date => p_effective_date,
255: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,

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

264: fnd_message.raise_error;
265: --
266: end if;
267: --
268: hr_utility.set_location('Leaving:'||l_proc, 10);
269: --
270: End chk_mutual_exlsv_mx_val_flg;
271: --
272: -- ----------------------------------------------------------------------------

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

308: l_api_updating boolean;
309: --
310: Begin
311: --
312: hr_utility.set_location('Entering:'||l_proc, 5);
313: --
314: l_api_updating := ben_bpp_shd.api_updating
315: (p_effective_date => p_effective_date,
316: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,

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

325: fnd_message.raise_error;
326: --
327: end if;
328: --
329: hr_utility.set_location('Leaving:'||l_proc, 10);
330: --
331: End chk_mutual_exlsv_mn_pct_flg;
332: --
333: -- ----------------------------------------------------------------------------

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

369: l_api_updating boolean;
370: --
371: Begin
372: --
373: hr_utility.set_location('Entering:'||l_proc, 5);
374: --
375: l_api_updating := ben_bpp_shd.api_updating
376: (p_effective_date => p_effective_date,
377: p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,

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

386: fnd_message.raise_error;
387: --
388: end if;
389: --
390: hr_utility.set_location('Leaving:'||l_proc, 10);
391: --
392: End chk_mutual_exlsv_mx_pct_flg;
393: --
394: -- ----------------------------------------------------------------------------

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

431: l_api_updating boolean;
432: --
433: Begin
434: --
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: l_api_updating := ben_bpp_shd.api_updating
438: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
439: p_effective_date => p_effective_date,

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

462: end if;
463: --
464: end if;
465: --
466: hr_utility.set_location('Leaving:'||l_proc,10);
467: --
468: end chk_pct_rndg_cd_rl_dpndcy;
469: --
470: -- ----------------------------------------------------------------------------

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

507: l_api_updating boolean;
508: --
509: Begin
510: --
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: l_api_updating := ben_bpp_shd.api_updating
514: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
515: p_effective_date => p_effective_date,

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

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

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

595: and ff.effective_end_date;
596: --
597: Begin
598: --
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: l_api_updating := ben_bpp_shd.api_updating
602: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
603: p_effective_date => p_effective_date,

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

633: close c1;
634: --
635: end if;
636: --
637: hr_utility.set_location('Leaving:'||l_proc,10);
638: --
639: end chk_val_rndg_rl;
640: --
641: -- ----------------------------------------------------------------------------

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

673: l_api_updating boolean;
674: --
675: Begin
676: --
677: hr_utility.set_location('Entering:'||l_proc, 5);
678: --
679: l_api_updating := ben_bpp_shd.api_updating
680: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
681: p_effective_date => p_effective_date,

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

704: end if;
705: --
706: end if;
707: --
708: hr_utility.set_location('Leaving:'||l_proc,10);
709: --
710: end chk_val_rndg_cd;
711: --
712: -- ----------------------------------------------------------------------------

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

761: and ff.effective_end_date;
762: --
763: Begin
764: --
765: hr_utility.set_location('Entering:'||l_proc, 5);
766: --
767: l_api_updating := ben_bpp_shd.api_updating
768: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
769: p_effective_date => p_effective_date,

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

799: close c1;
800: --
801: end if;
802: --
803: hr_utility.set_location('Leaving:'||l_proc,10);
804: --
805: end chk_pct_rndg_rl;
806: --
807: -- ----------------------------------------------------------------------------

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

839: l_api_updating boolean;
840: --
841: Begin
842: --
843: hr_utility.set_location('Entering:'||l_proc, 5);
844: --
845: l_api_updating := ben_bpp_shd.api_updating
846: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
847: p_effective_date => p_effective_date,

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

870: end if;
871: --
872: end if;
873: --
874: hr_utility.set_location('Leaving:'||l_proc,10);
875: --
876: end chk_pct_rndg_cd;
877: --
878: -- ----------------------------------------------------------------------------

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

910: l_api_updating boolean;
911: --
912: Begin
913: --
914: hr_utility.set_location('Entering:'||l_proc, 5);
915: --
916: l_api_updating := ben_bpp_shd.api_updating
917: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
918: p_effective_date => p_effective_date,

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

939: end if;
940: --
941: end if;
942: --
943: hr_utility.set_location('Leaving:'||l_proc,10);
944: --
945: end chk_pgm_pool_flag;
946: --
947: -- ----------------------------------------------------------------------------

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_bpp_shd.api_updating
986: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
987: p_effective_date => p_effective_date,

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

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

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

1048: l_api_updating boolean;
1049: --
1050: Begin
1051: --
1052: hr_utility.set_location('Entering:'||l_proc, 5);
1053: --
1054: l_api_updating := ben_bpp_shd.api_updating
1055: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1056: p_effective_date => p_effective_date,

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

1077: end if;
1078: --
1079: end if;
1080: --
1081: hr_utility.set_location('Leaving:'||l_proc,10);
1082: --
1083: end chk_no_mx_dstrbl_pct_flag;
1084: --
1085: -- ----------------------------------------------------------------------------

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

1117: l_api_updating boolean;
1118: --
1119: Begin
1120: --
1121: hr_utility.set_location('Entering:'||l_proc, 5);
1122: --
1123: l_api_updating := ben_bpp_shd.api_updating
1124: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1125: p_effective_date => p_effective_date,

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

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

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

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

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

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

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

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

Line 1266: hr_utility.set_location('auto_alct_excs_flag:'||p_auto_alct_excs_flag, 5);

1262: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1263: p_effective_date => p_effective_date,
1264: p_object_version_number => p_object_version_number);
1265: --
1266: hr_utility.set_location('auto_alct_excs_flag:'||p_auto_alct_excs_flag, 5);
1267: --
1268: if (l_api_updating
1269: and p_auto_alct_excs_flag
1270: <> nvl(ben_bpp_shd.g_old_rec.auto_alct_excs_flag,hr_api.g_varchar2)

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

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

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

1335: where a.comp_lvl_fctr_id = p_comp_lvl_fctr_id;
1336: --
1337: Begin
1338: --
1339: hr_utility.set_location('Entering:'||l_proc,5);
1340: --
1341: l_api_updating := ben_bpp_shd.api_updating
1342: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1343: p_effective_date => p_effective_date,

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

1377: (p_mx_dfcit_pct_comp_num is not null and p_comp_lvl_fctr_id is null ) then
1378: fnd_message.set_name('BEN','BEN_92624_PCT_COMP_REQUIRED');
1379: fnd_message.raise_error;
1380: End if;
1381: hr_utility.set_location('Leaving:'||l_proc,10);
1382: --
1383: End chk_comp_lvl_fctr_id;
1384: --
1385: -- |----------------------< chk_alws_ngtv_crs_flag >------------------------|

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

1416: l_api_updating boolean;
1417: --
1418: Begin
1419: --
1420: hr_utility.set_location('Entering:'||l_proc, 5);
1421: --
1422: l_api_updating := ben_bpp_shd.api_updating
1423: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1424: p_effective_date => p_effective_date,

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

1445: end if;
1446: --
1447: end if;
1448: --
1449: hr_utility.set_location('Leaving:'||l_proc,10);
1450: --
1451: end chk_alws_ngtv_crs_flag;
1452:
1453:

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

1502: l_api_updating boolean;
1503: --
1504: Begin
1505: --
1506: hr_utility.set_location('Entering:'||l_proc, 5);
1507: --
1508: l_api_updating := ben_bpp_shd.api_updating
1509: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1510: p_effective_date => p_effective_date,

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

1549: end if;
1550: --
1551: end if;
1552: --
1553: hr_utility.set_location('Leaving:'||l_proc,10);
1554: --
1555: end chk_uses_net_crs_mthd_flag;
1556:
1557: --

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

1590: l_api_updating boolean;
1591: --
1592: Begin
1593: --
1594: hr_utility.set_location('Entering:'||l_proc, 5);
1595: --
1596: l_api_updating := ben_bpp_shd.api_updating
1597: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1598: p_effective_date => p_effective_date,

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

1621: end if;
1622: --
1623: end if;
1624: --
1625: hr_utility.set_location('Leaving:'||l_proc,10);
1626: --
1627: end chk_excs_trtmt_cd;
1628:
1629:

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

1663: l_api_updating boolean;
1664: --
1665: Begin
1666: --
1667: hr_utility.set_location('Entering:'||l_proc, 5);
1668: --
1669: l_api_updating := ben_bpp_shd.api_updating
1670: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1671: p_effective_date => p_effective_date,

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

1694: end if;
1695: --
1696: end if;
1697: --
1698: hr_utility.set_location('Leaving:'||l_proc,10);
1699: --
1700: end chk_dflt_excs_trtmt_cd;
1701: --
1702: -- ----------------------------------------------------------------------------

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

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

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

1791: --
1792: close c1;
1793: end if;
1794: --
1795: hr_utility.set_location('Leaving:'||l_proc,10);
1796: --
1797: end chk_dflt_excs_trtmt_rl;
1798:
1799: -- ----------------------------------------------------------------------------

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

1836: l_api_updating boolean;
1837: --
1838: Begin
1839: --
1840: hr_utility.set_location('Entering:'||l_proc, 5);
1841: --
1842: l_api_updating := ben_bpp_shd.api_updating
1843: (p_bnft_prvdr_pool_id => p_bnft_prvdr_pool_id,
1844: p_effective_date => p_effective_date,

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

1868: end if;
1869: --
1870: end if;
1871: --
1872: hr_utility.set_location('Leaving:'||l_proc,10);
1873: --
1874: end chk_excs_cd_rl_dpndcy;
1875: --
1876: --

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

1919: l_integrity_error Exception;
1920: l_table_name all_tables.table_name%TYPE;
1921: --
1922: Begin
1923: hr_utility.set_location('Entering:'||l_proc, 5);
1924: --
1925: -- Ensure that the p_datetrack_mode argument is not null
1926: --
1927: hr_api.mandatory_arg_error

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

2018: End If;
2019: --
2020: End If;
2021: --
2022: hr_utility.set_location(' Leaving:'||l_proc, 10);
2023: Exception
2024: When l_integrity_error Then
2025: --
2026: -- A referential integrity check was violated therefore

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

2084: l_rows_exist Exception;
2085: l_table_name all_tables.table_name%TYPE;
2086: --
2087: Begin
2088: hr_utility.set_location('Entering:'||l_proc, 5);
2089: --
2090: -- Ensure that the p_datetrack_mode argument is not null
2091: --
2092: hr_api.mandatory_arg_error

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

2147: End If;
2148: --
2149: End If;
2150: --
2151: hr_utility.set_location(' Leaving:'||l_proc, 10);
2152: Exception
2153: When l_rows_exist Then
2154: --
2155: -- A referential integrity check was violated therefore

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

2180: --
2181: l_proc varchar2(72) := g_package||'insert_validate';
2182: --
2183: Begin
2184: hr_utility.set_location('Entering:'||l_proc, 5);
2185: --
2186: chk_bnft_prvdr_pool_id
2187: (p_bnft_prvdr_pool_id => p_rec.bnft_prvdr_pool_id,
2188: p_effective_date => p_effective_date,

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

2363: --
2364: --
2365: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
2366: --
2367: hr_utility.set_location(' Leaving:'||l_proc, 10);
2368: End insert_validate;
2369: --
2370: -- ----------------------------------------------------------------------------
2371: -- |---------------------------< update_validate >----------------------------|

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

2379: --
2380: l_proc varchar2(72) := g_package||'update_validate';
2381: --
2382: Begin
2383: hr_utility.set_location('Entering:'||l_proc, 5);
2384: --
2385: chk_bnft_prvdr_pool_id
2386: (p_bnft_prvdr_pool_id => p_rec.bnft_prvdr_pool_id,
2387: p_effective_date => p_effective_date,

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

2578: p_datetrack_mode => p_datetrack_mode,
2579: p_validation_start_date => p_validation_start_date,
2580: p_validation_end_date => p_validation_end_date);
2581: --
2582: hr_utility.set_location(' Leaving:'||l_proc, 10);
2583: End update_validate;
2584: --
2585: -- ----------------------------------------------------------------------------
2586: -- |---------------------------< delete_validate >----------------------------|

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

2594: --
2595: l_proc varchar2(72) := g_package||'delete_validate';
2596: --
2597: Begin
2598: hr_utility.set_location('Entering:'||l_proc, 5);
2599: --
2600: -- Call all supporting business operations
2601: --
2602: dt_delete_validate

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

2604: p_validation_start_date => p_validation_start_date,
2605: p_validation_end_date => p_validation_end_date,
2606: p_bnft_prvdr_pool_id => p_rec.bnft_prvdr_pool_id);
2607: --
2608: hr_utility.set_location(' Leaving:'||l_proc, 10);
2609: End delete_validate;
2610: --
2611: -- ---------------------------------------------------------------------------
2612: -- |---------------------< return_legislation_code >-------------------------|

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

2630: l_proc varchar2(72) := g_package||'return_legislation_code';
2631: --
2632: begin
2633: --
2634: hr_utility.set_location('Entering:'|| l_proc, 10);
2635: --
2636: -- Ensure that all the mandatory parameter are not null
2637: --
2638: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2655: end if;
2656: --
2657: close csr_leg_code;
2658: --
2659: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2660: --
2661: return l_legislation_code;
2662: --
2663: end return_legislation_code;