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_BPR_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_bpr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_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_pool_rlovr_rqmt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

115: l_api_updating boolean;
116: --
117: Begin
118: --
119: hr_utility.set_location('Entering:'||l_proc, 5);
120: --
121: l_api_updating := ben_bpr_shd.api_updating
122: (p_effective_date => p_effective_date,
123: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,

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

132: fnd_message.raise_error;
133: --
134: end if;
135: --
136: hr_utility.set_location('Leaving:'||l_proc, 10);
137: --
138: End chk_mutual_exlsv_mn_val_flg;
139: --
140: -- ----------------------------------------------------------------------------

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

176: l_api_updating boolean;
177: --
178: Begin
179: --
180: hr_utility.set_location('Entering:'||l_proc, 5);
181: --
182: l_api_updating := ben_bpr_shd.api_updating
183: (p_effective_date => p_effective_date,
184: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,

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

193: fnd_message.raise_error;
194: --
195: end if;
196: --
197: hr_utility.set_location('Leaving:'||l_proc, 10);
198: --
199: End chk_mutual_exlsv_mx_val_flg;
200: --
201: -- ----------------------------------------------------------------------------

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

237: l_api_updating boolean;
238: --
239: Begin
240: --
241: hr_utility.set_location('Entering:'||l_proc, 5);
242: --
243: l_api_updating := ben_bpr_shd.api_updating
244: (p_effective_date => p_effective_date,
245: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,

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

254: fnd_message.raise_error;
255: --
256: end if;
257: --
258: hr_utility.set_location('Leaving:'||l_proc, 10);
259: --
260: End chk_mutual_exlsv_mn_pct_flg;
261: --
262: -- ----------------------------------------------------------------------------

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

298: l_api_updating boolean;
299: --
300: Begin
301: --
302: hr_utility.set_location('Entering:'||l_proc, 5);
303: --
304: l_api_updating := ben_bpr_shd.api_updating
305: (p_effective_date => p_effective_date,
306: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,

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

315: fnd_message.raise_error;
316: --
317: end if;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 10);
320: --
321: End chk_mutual_exlsv_mx_pct_flg;
322: --
323: -- ----------------------------------------------------------------------------

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

360: l_api_updating boolean;
361: --
362: Begin
363: --
364: hr_utility.set_location('Entering:'||l_proc, 5);
365: --
366: l_api_updating := ben_bpr_shd.api_updating
367: (p_effective_date => p_effective_date,
368: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,

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

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

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

436: l_api_updating boolean;
437: --
438: Begin
439: --
440: hr_utility.set_location('Entering:'||l_proc, 5);
441: --
442: l_api_updating := ben_bpr_shd.api_updating
443: (p_effective_date => p_effective_date,
444: p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,

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

467: end if;
468: --
469: end if;
470: --
471: hr_utility.set_location('Leaving:'||l_proc,10);
472: --
473: end chk_val_rndg_cd_rl_dpndcy;
474: --
475: -- ----------------------------------------------------------------------------

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_bpr_shd.api_updating
514: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_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_pct_rndg_cd;
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_bpr_shd.api_updating
602: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_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_bpr_shd.api_updating
680: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_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 748: hr_utility.set_location('Entering:'||l_proc, 5);

744: l_api_updating boolean;
745: --
746: Begin
747: --
748: hr_utility.set_location('Entering:'||l_proc, 5);
749: --
750: l_api_updating := ben_bpr_shd.api_updating
751: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
752: p_effective_date => p_effective_date,

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

773: end if;
774: --
775: end if;
776: --
777: hr_utility.set_location('Leaving:'||l_proc,10);
778: --
779: end chk_no_mx_rlovr_val_dfnd_flag;
780:
781: -- ----------------------------------------------------------------------------

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

830: and ff.effective_end_date;
831: --
832: Begin
833: --
834: hr_utility.set_location('Entering:'||l_proc, 5);
835: --
836: l_api_updating := ben_bpr_shd.api_updating
837: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
838: p_effective_date => p_effective_date,

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

868: close c1;
869: --
870: end if;
871: --
872: hr_utility.set_location('Leaving:'||l_proc,10);
873: --
874: end chk_rlovr_val_rl;
875:
876: --

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

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

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

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

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

978: l_api_updating boolean;
979: --
980: Begin
981: --
982: hr_utility.set_location('Entering:'||l_proc, 5);
983: --
984: l_api_updating := ben_bpr_shd.api_updating
985: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
986: p_effective_date => p_effective_date,

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

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

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

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

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

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

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_bpr_shd.api_updating
1124: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
1125: p_effective_date => p_effective_date,

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

1124: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
1125: p_effective_date => p_effective_date,
1126: p_object_version_number => p_object_version_number);
1127: --
1128: hr_utility.set_location('p_crs_rlovr_procg_cd:'||p_crs_rlovr_procg_cd, 5);
1129: if (l_api_updating
1130: and p_crs_rlovr_procg_cd
1131: <> nvl(ben_bpr_shd.g_old_rec.crs_rlovr_procg_cd,hr_api.g_varchar2)
1132: or not l_api_updating)

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

1150: end if;
1151: --
1152: end if;
1153: --
1154: hr_utility.set_location('Leaving:'||l_proc,10);
1155: --
1156: end chk_crs_rlovr_procg_cd;
1157: --
1158: -- ----------------------------------------------------------------------------

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

1207: and ff.effective_end_date;
1208: --
1209: Begin
1210: --
1211: hr_utility.set_location('Entering:'||l_proc, 5);
1212: --
1213: l_api_updating := ben_bpr_shd.api_updating
1214: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
1215: p_effective_date => p_effective_date,

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

1245: close c1;
1246: --
1247: end if;
1248: --
1249: hr_utility.set_location('Leaving:'||l_proc,10);
1250: --
1251: end chk_pct_rndg_rl;
1252: --
1253: -- ----------------------------------------------------------------------------

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

1302: and ff.effective_end_date;
1303: --
1304: Begin
1305: --
1306: hr_utility.set_location('Entering:'||l_proc, 5);
1307: --
1308: l_api_updating := ben_bpr_shd.api_updating
1309: (p_bnft_pool_rlovr_rqmt_id => p_bnft_pool_rlovr_rqmt_id,
1310: p_effective_date => p_effective_date,

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

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

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

1373: l_dummy_var varchar2(1) ;
1374:
1375: begin
1376:
1377: hr_utility.set_location('Entering:'||l_proc, 5);
1378: open c_abp ;
1379: fetch c_abp into l_dummy_var ;
1380: if c_abp%found then
1381: hr_utility.set_location('dupes:'||l_proc, 5);

Line 1381: hr_utility.set_location('dupes:'||l_proc, 5);

1377: hr_utility.set_location('Entering:'||l_proc, 5);
1378: open c_abp ;
1379: fetch c_abp into l_dummy_var ;
1380: if c_abp%found then
1381: hr_utility.set_location('dupes:'||l_proc, 5);
1382: close c_abp ;
1383: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
1384: fnd_message.set_token('VAR1', 'Rollover Requirements');
1385: fnd_message.set_token('VAR2','Benefit Pool');

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

1386: fnd_message.raise_error;
1387: end if ;
1388: close c_abp ;
1389:
1390: hr_utility.set_location('Leaving:'||l_proc, 10);
1391:
1392: end chk_abr_dups ;
1393: --
1394: -- ----------------------------------------------------------------------------

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

1431: l_integrity_error Exception;
1432: l_table_name all_tables.table_name%TYPE;
1433: --
1434: Begin
1435: hr_utility.set_location('Entering:'||l_proc, 5);
1436: --
1437: -- Ensure that the p_datetrack_mode argument is not null
1438: --
1439: hr_api.mandatory_arg_error

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

1480: End If;
1481: --
1482: End If;
1483: --
1484: hr_utility.set_location(' Leaving:'||l_proc, 10);
1485: Exception
1486: When l_integrity_error Then
1487: --
1488: -- A referential integrity check was violated therefore

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

1546: l_rows_exist Exception;
1547: l_table_name all_tables.table_name%TYPE;
1548: --
1549: Begin
1550: hr_utility.set_location('Entering:'||l_proc, 5);
1551: --
1552: -- Ensure that the p_datetrack_mode argument is not null
1553: --
1554: hr_api.mandatory_arg_error

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

1583: --
1584: --
1585: End If;
1586: --
1587: hr_utility.set_location(' Leaving:'||l_proc, 10);
1588: Exception
1589: When l_rows_exist Then
1590: --
1591: -- A referential integrity check was violated therefore

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

1616: --
1617: l_proc varchar2(72) := g_package||'insert_validate';
1618: --
1619: Begin
1620: hr_utility.set_location('Entering:'||l_proc, 5);
1621: --
1622: -- Call all supporting business operations
1623: --
1624: --

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

1740: p_bnft_pool_rlovr_rqmt_id => p_rec.bnft_pool_rlovr_rqmt_id,
1741: p_effective_date => p_effective_date );
1742:
1743: --
1744: hr_utility.set_location(' Leaving:'||l_proc, 10);
1745: End insert_validate;
1746: --
1747: -- ----------------------------------------------------------------------------
1748: -- |---------------------------< update_validate >----------------------------|

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

1756: --
1757: l_proc varchar2(72) := g_package||'update_validate';
1758: --
1759: Begin
1760: hr_utility.set_location('Entering:'||l_proc, 5);
1761: --
1762: -- Call all supporting business operations
1763: --
1764: --

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

1890: p_bnft_pool_rlovr_rqmt_id => p_rec.bnft_pool_rlovr_rqmt_id,
1891: p_effective_date => p_effective_date );
1892:
1893: --
1894: hr_utility.set_location(' Leaving:'||l_proc, 10);
1895: End update_validate;
1896: --
1897: -- ----------------------------------------------------------------------------
1898: -- |---------------------------< delete_validate >----------------------------|

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

1906: --
1907: l_proc varchar2(72) := g_package||'delete_validate';
1908: --
1909: Begin
1910: hr_utility.set_location('Entering:'||l_proc, 5);
1911: --
1912: -- Call all supporting business operations
1913: --
1914: dt_delete_validate

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

1916: p_validation_start_date => p_validation_start_date,
1917: p_validation_end_date => p_validation_end_date,
1918: p_bnft_pool_rlovr_rqmt_id => p_rec.bnft_pool_rlovr_rqmt_id);
1919: --
1920: hr_utility.set_location(' Leaving:'||l_proc, 10);
1921: End delete_validate;
1922: --
1923: --
1924: -- ---------------------------------------------------------------------------

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

1943: l_proc varchar2(72) := g_package||'return_legislation_code';
1944: --
1945: begin
1946: --
1947: hr_utility.set_location('Entering:'|| l_proc, 10);
1948: --
1949: -- Ensure that all the mandatory parameter are not null
1950: --
1951: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1968: end if;
1969: --
1970: close csr_leg_code;
1971: --
1972: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1973: --
1974: return l_legislation_code;
1975: --
1976: end return_legislation_code;