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_APR_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_apr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_actl_prem_id => p_actl_prem_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_actl_prem_id;
78: --
79: -- ----------------------------------------------------------------------------

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

150: and org.business_group_id = p_business_group_id;
151: --
152: Begin
153: --
154: hr_utility.set_location('Entering:'||l_proc,5);
155: --
156: l_api_updating := ben_apr_shd.api_updating
157: (p_actl_prem_id => p_actl_prem_id,
158: p_effective_date => p_effective_date,

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: End chk_organization_id;
220:
221: --

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

271: and ff.effective_end_date;
272: --
273: Begin
274: --
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: --
277: l_api_updating := ben_apr_shd.api_updating
278: (p_actl_prem_id => p_actl_prem_id,
279: p_effective_date => p_effective_date,

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

309: close c1;
310: --
311: end if;
312: --
313: hr_utility.set_location('Leaving:'||l_proc,10);
314: --
315: end chk_rndg_rl;
316: --
317: -- ----------------------------------------------------------------------------

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

366: and ff.effective_end_date;
367: --
368: Begin
369: --
370: hr_utility.set_location('Entering:'||l_proc, 5);
371: --
372: l_api_updating := ben_apr_shd.api_updating
373: (p_actl_prem_id => p_actl_prem_id,
374: p_effective_date => p_effective_date,

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

404: close c1;
405: --
406: end if;
407: --
408: hr_utility.set_location('Leaving:'||l_proc,10);
409: --
410: end chk_val_calc_rl;
411: --
412: -- ----------------------------------------------------------------------------

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

461: and ff.effective_end_date;
462: --
463: Begin
464: --
465: hr_utility.set_location('Entering:'||l_proc, 5);
466: --
467: l_api_updating := ben_apr_shd.api_updating
468: (p_actl_prem_id => p_actl_prem_id,
469: p_effective_date => p_effective_date,

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

499: close c1;
500: --
501: end if;
502: --
503: hr_utility.set_location('Leaving:'||l_proc,10);
504: --
505: end chk_vrbl_rt_add_on_calc_rl;
506: --
507: -- ----------------------------------------------------------------------------

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

539: l_api_updating boolean;
540: --
541: Begin
542: --
543: hr_utility.set_location('Entering:'||l_proc, 5);
544: --
545: l_api_updating := ben_apr_shd.api_updating
546: (p_actl_prem_id => p_actl_prem_id,
547: p_effective_date => p_effective_date,

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

568: end if;
569: --
570: end if;
571: --
572: hr_utility.set_location('Leaving:'||l_proc,10);
573: --
574: end chk_rndg_cd;
575: --
576: -- ----------------------------------------------------------------------------

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

608: l_api_updating boolean;
609: --
610: Begin
611: --
612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: l_api_updating := ben_apr_shd.api_updating
615: (p_actl_prem_id => p_actl_prem_id,
616: p_effective_date => p_effective_date,

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

637: end if;
638: --
639: end if;
640: --
641: hr_utility.set_location('Leaving:'||l_proc,10);
642: --
643: end chk_prdct_cd;
644: --
645: -- ----------------------------------------------------------------------------

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: l_api_updating := ben_apr_shd.api_updating
684: (p_actl_prem_id => p_actl_prem_id,
685: p_effective_date => p_effective_date,

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

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

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

752: l_api_updating boolean;
753: --
754: Begin
755: --
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: --
758: l_api_updating := ben_apr_shd.api_updating
759: (p_actl_prem_id => p_actl_prem_id,
760: p_effective_date => p_effective_date,

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

781: end if;
782: --
783: end if;
784: --
785: hr_utility.set_location('Leaving:'||l_proc,10);
786: --
787: end chk_prtl_mo_det_mthd_cd;
788: --
789: -- ----------------------------------------------------------------------------

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

821: l_api_updating boolean;
822: --
823: Begin
824: --
825: hr_utility.set_location('Entering:'||l_proc, 5);
826: --
827: l_api_updating := ben_apr_shd.api_updating
828: (p_actl_prem_id => p_actl_prem_id,
829: p_effective_date => p_effective_date,

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

851: end if;
852: --
853: end if;
854: --
855: hr_utility.set_location('Leaving:'||l_proc,10);
856: --
857: end chk_rt_typ_cd;
858: --
859: -- ----------------------------------------------------------------------------

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

891: l_api_updating boolean;
892: --
893: Begin
894: --
895: hr_utility.set_location('Entering:'||l_proc, 5);
896: --
897: l_api_updating := ben_apr_shd.api_updating
898: (p_actl_prem_id => p_actl_prem_id,
899: p_effective_date => p_effective_date,

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

921: end if;
922: --
923: end if;
924: --
925: hr_utility.set_location('Leaving:'||l_proc,10);
926: --
927: end chk_bnft_rt_typ_cd;
928: --
929: -- ----------------------------------------------------------------------------

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

961: l_api_updating boolean;
962: --
963: Begin
964: --
965: hr_utility.set_location('Entering:'||l_proc, 5);
966: --
967: l_api_updating := ben_apr_shd.api_updating
968: (p_actl_prem_id => p_actl_prem_id,
969: p_effective_date => p_effective_date,

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

991: end if;
992: --
993: end if;
994: --
995: hr_utility.set_location('Leaving:'||l_proc,10);
996: --
997: end chk_acty_ref_perd_cd;
998: --
999: --

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

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

Line 1064: hr_utility.set_location('name is :'||p_name, 10);

1060: if (l_api_updating
1061: and p_name <> ben_apr_shd.g_old_rec.name) or
1062: not l_api_updating then
1063: --
1064: hr_utility.set_location('name is :'||p_name, 10);
1065: --
1066: -- check if this name already exist
1067: --
1068: open csr_name;

Line 1075: hr_utility.set_location('before message'||p_name,10);

1071: close csr_name;
1072: --
1073: -- raise error as UK1 is violated
1074: --
1075: hr_utility.set_location('before message'||p_name,10);
1076: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
1077: fnd_message.raise_error;
1078: --
1079: end if;

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

1079: end if;
1080: --
1081: end if;
1082: --
1083: hr_utility.set_location('Leaving:'||l_proc, 20);
1084: --
1085: End chk_name;
1086: --
1087: -- ----------------------------------------------------------------------------

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

1124: -- l_api_updating boolean;
1125: --
1126: --Begin
1127: --
1128: -- hr_utility.set_location('Entering:'||l_proc, 5);
1129: --
1130: -- l_api_updating := ben_apr_shd.api_updating
1131: -- (p_actl_prem_id => p_actl_prem_id,
1132: -- p_effective_date => p_effective_date,

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

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

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

1184: l_proc varchar2(72) := g_package||'chk_code_rule_num';
1185: --
1186: Begin
1187: --
1188: hr_utility.set_location('Entering:'||l_proc, 5);
1189: --
1190: if p_code <> 'RL' and p_rule is not null then
1191: --
1192: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');

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

1210: fnd_message.raise_error;
1211: --
1212: end if;
1213: --
1214: hr_utility.set_location('Leaving:'||l_proc,10);
1215: --
1216: end chk_code_rule_num;
1217: --
1218: -- ----------------------------------------------------------------------------

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

1257: l_proc varchar2(72) := g_package||'chk_asgnmt_cd_lvl_mlt_pyr' ;
1258: --
1259: Begin
1260: --
1261: hr_utility.set_location('Entering:'||l_proc, 5);
1262: --
1263: if (p_prem_asnmt_cd = 'ENRT' and p_prem_asnmt_lvl_cd <> 'PRTT')
1264: then
1265: fnd_message.set_name('BEN', 'BEN_92272_ASGN_ENRT_LVL_NPRTT');

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

1295: end if;
1296: --
1297: -- Leaving Procedure.
1298: --
1299: hr_utility.set_location('Leaving:'||l_proc,10);
1300: --
1301: end chk_asgnmt_cd_lvl_mlt_pyr;
1302: --
1303: -- ----------------------------------------------------------------------------

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

1338: l_proc varchar2(72) := g_package||'chk_lwr_lmt_rl_val';
1339: --
1340: Begin
1341: --
1342: hr_utility.set_location('Entering:'||l_proc, 5);
1343: --
1344: if (p_upr_lmt_calc_rl is not null and p_upr_lmt_val is not null)
1345: then
1346: fnd_message.set_name('BEN', 'BEN_92277_UPR_LMT_RL_VAL');

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

1354: end if;
1355: --
1356: -- Leaving Procedure.
1357: --
1358: hr_utility.set_location('Leaving:'||l_proc,10);
1359: --
1360: end chk_lwr_lmt_rl_val;
1361: --
1362: -- ----------------------------------------------------------------------------

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

1389: l_proc varchar2(72) := g_package||'chk_lwr_lmt_upr_lmt';
1390: --
1391: Begin
1392: --
1393: hr_utility.set_location('Entering:'||l_proc, 5);
1394: --
1395: -- check the values
1396: -- note: Don't want an error if either one is null
1397: --

Line 1408: hr_utility.set_location('Leaving:'||l_proc, 5);

1404: fnd_message.raise_error;
1405: --
1406: end if;
1407: --
1408: hr_utility.set_location('Leaving:'||l_proc, 5);
1409: --
1410: end chk_lwr_lmt_upr_lmt;
1411: -- ----------------------------------------------------------------------------
1412: -- |------------------------< chk_asg_vrbl_prfl_mlt_tmt >---------------------|

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

1460: and apv.effective_end_date;
1461: --
1462: Begin
1463: --
1464: hr_utility.set_location('Entering:'||l_proc, 5);
1465: --
1466: if p_prem_asnmt_cd is not null then
1467: --
1468: -- Check if vrbl_rt_prfl is assigned to premium and do checks.

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

1504: close c1;
1505: --
1506: end if;
1507: --
1508: hr_utility.set_location('Leaving:'||l_proc, 10);
1509: --
1510: End chk_asg_vrbl_prfl_mlt_tmt;
1511: -- ----------------------------------------------------------------------------
1512: -- |----------------------------< chk_lookups >-------------------------------|

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

1552: l_dummy varchar2(30);
1553: --
1554: Begin
1555: --
1556: hr_utility.set_location('Entering:'||l_proc, 5);
1557: --
1558: l_api_updating := ben_apr_shd.api_updating
1559: (p_actl_prem_id => p_actl_prem_id,
1560: p_effective_date => p_effective_date,

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

1684: end if;
1685: --
1686: end if;
1687: --
1688: hr_utility.set_location('Leaving:'||l_proc,10);
1689: --
1690: end chk_lookups;
1691: --
1692: -- ----------------------------------------------------------------------------

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

1747: and ff.effective_end_date;
1748: --
1749: Begin
1750: --
1751: hr_utility.set_location('Entering:'||l_proc, 5);
1752: --
1753: l_api_updating := ben_apr_shd.api_updating
1754: (p_actl_prem_id => p_actl_prem_id,
1755: p_effective_date => p_effective_date,

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

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

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

1898: and a.actl_prem_id = p_actl_prem_id;
1899: --
1900: Begin
1901: --
1902: hr_utility.set_location('Entering:'||l_proc, 5);
1903: --
1904: --
1905: -- Check if prem_asnmt_cd is 'PROC'
1906: --

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

1927: close c1;
1928: end if;
1929: --
1930:
1931: hr_utility.set_location('Leaving:'||l_proc, 10);
1932: --
1933: End chk_child_data;
1934:
1935: -- ----------------------------------------------------------------------------

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

1971: l_integrity_error Exception;
1972: l_table_name all_tables.table_name%TYPE;
1973: --
1974: Begin
1975: hr_utility.set_location('Entering:'||l_proc, 5);
1976: --
1977: -- Ensure that the p_datetrack_mode argument is not null
1978: --
1979: hr_api.mandatory_arg_error

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

2012: */
2013: --
2014: End If;
2015: --
2016: hr_utility.set_location(' Leaving:'||l_proc, 10);
2017: Exception
2018: When l_integrity_error Then
2019: --
2020: -- A referential integrity check was violated therefore

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

2077: l_rows_exist Exception;
2078: l_table_name all_tables.table_name%TYPE;
2079: --
2080: Begin
2081: hr_utility.set_location('Entering:'||l_proc, 5);
2082: --
2083: -- Ensure that the p_datetrack_mode argument is not null
2084: --
2085: hr_api.mandatory_arg_error

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

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

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

2226: and coa.oipl_id = cvg.oipl_id (+)
2227: and coa.business_group_id = p_business_group_id;
2228:
2229: Begin
2230: hr_utility.set_location('Entering:'||l_proc, 5);
2231: l_api_updating := ben_apr_shd.api_updating
2232: (p_actl_prem_id => p_actl_prem_id,
2233: p_effective_date => p_effective_date,
2234: p_object_version_number => p_object_version_number);

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

2287: fnd_message.set_name('BEN','BEN_91548_VAL_CALC_RL_RQD');
2288: fnd_message.raise_error;
2289: end if;
2290: end if;
2291: hr_utility.set_location('Leaving:'||l_proc,10);
2292: end chk_mlt_cd_dependencies;
2293: --
2294: --
2295: -- ----------------------------------------------------------------------------

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

2304: --
2305: l_proc varchar2(72) := g_package||'insert_validate';
2306: --
2307: Begin
2308: hr_utility.set_location('Entering:'||l_proc, 5);
2309: --
2310: -- Call all supporting business operations
2311: --
2312: --

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

2461: p_prem_asnmt_cd => p_rec.prem_asnmt_cd,
2462: p_effective_date => p_effective_date,
2463: p_business_group_id => p_rec.business_group_id);
2464: --
2465: hr_utility.set_location(' Leaving:'||l_proc, 10);
2466: End insert_validate;
2467: --
2468: -- ----------------------------------------------------------------------------
2469: -- |---------------------------< update_validate >----------------------------|

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

2477: --
2478: l_proc varchar2(72) := g_package||'update_validate';
2479: --
2480: Begin
2481: hr_utility.set_location('Entering:'||l_proc, 5);
2482: --
2483: -- Call all supporting business operations
2484: --
2485: --

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

2655: p_business_group_id => p_rec.business_group_id,
2656: p_prem_asnmt_cd => p_rec.prem_asnmt_cd,
2657: p_cost_allocation_keyflex_id => p_rec.cost_allocation_keyflex_id);
2658: --
2659: hr_utility.set_location(' Leaving:'||l_proc, 10);
2660: End update_validate;
2661: --
2662: -- ----------------------------------------------------------------------------
2663: -- |---------------------------< delete_validate >----------------------------|

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

2671: --
2672: l_proc varchar2(72) := g_package||'delete_validate';
2673: --
2674: Begin
2675: hr_utility.set_location('Entering:'||l_proc, 5);
2676: --
2677: -- Call all supporting business operations
2678: --
2679: dt_delete_validate

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

2681: p_validation_start_date => p_validation_start_date,
2682: p_validation_end_date => p_validation_end_date,
2683: p_actl_prem_id => p_rec.actl_prem_id);
2684: --
2685: hr_utility.set_location(' Leaving:'||l_proc, 10);
2686: End delete_validate;
2687: --
2688: --
2689: -- ---------------------------------------------------------------------------

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

2708: l_proc varchar2(72) := g_package||'return_legislation_code';
2709: --
2710: begin
2711: --
2712: hr_utility.set_location('Entering:'|| l_proc, 10);
2713: --
2714: -- Ensure that all the mandatory parameter are not null
2715: --
2716: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

2733: end if;
2734: --
2735: close csr_leg_code;
2736: --
2737: hr_utility.set_location(' Leaving:'|| l_proc, 20);
2738: --
2739: return l_legislation_code;
2740: --
2741: end return_legislation_code;