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

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

59: and o.effective_end_date;
60: --
61: Begin
62: --
63: hr_utility.set_location('Entering:'||l_proc, 5);
64: --
65: l_api_updating := ben_epo_shd.api_updating
66: (p_effective_date => p_effective_date,
67: p_elig_per_opt_id => p_elig_per_opt_id,

Line 92: hr_utility.set_location('In:'||l_proc, 7);

88: end if;
89: --
90: end if;
91:
92: hr_utility.set_location('In:'||l_proc, 7);
93:
94: if (l_api_updating
95: and p_elig_per_opt_id
96: <> nvl(ben_epo_shd.g_old_rec.elig_per_opt_id,hr_api.g_number)

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

111: close c1;
112: --
113: end if;
114: --
115: hr_utility.set_location('Leaving:'||l_proc, 10);
116: --
117: End chk_elig_per_opt_id;
118: --
119: -- ---------------------------------------------------------------------------

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

165: where a.currency_code = p_rt_comp_ref_uom;
166: --
167: begin
168: --
169: hr_utility.set_location('Entering :'||l_proc,5);
170: --
171: if (p_comp_ref_val is null and p_comp_ref_uom is not null) or
172: (p_comp_ref_uom is null and p_comp_ref_val is not null) then
173: --

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

232: close c2;
233: --
234: end if;
235: --
236: hr_utility.set_location('Leaving :'||l_proc,10);
237: --
238: end chk_comp_ref_uom;
239: -- ---------------------------------------------------------------------------
240: -- |----------------------------------------------|

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

272: l_api_updating boolean;
273: --
274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: l_api_updating := ben_epo_shd.api_updating
279: (p_elig_per_opt_id => p_elig_per_opt_id,
280: p_effective_date => p_effective_date,

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

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

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

358: l_api_updating boolean;
359: --
360: Begin
361: --
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: --
364: if (p_pct_val IS NOT NULL and (p_pct_val < 0 OR p_pct_val > 100)) then
365: --
366: fnd_message.set_name('BEN','BEN_91257_INV_PCT_VAL');

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

374: fnd_message.raise_error;
375: --
376: end if;
377: --
378: hr_utility.set_location('Leaving:'||l_proc,10);
379: --
380: end chk_pct_val;
381: -- ---------------------------------------------------------------------------
382: -- |------------------------------------------------------------|

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

416: l_api_updating boolean;
417: --
418: Begin
419: --
420: hr_utility.set_location('Entering:'||l_proc, 5);
421: --
422: if (p_age_val is null and p_age_uom is not null) or
423: (p_age_uom is null and p_age_val is not null) then
424: --

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

485: end if;
486: --
487: end if;
488: --
489: hr_utility.set_location('Leaving:'||l_proc,10);
490: --
491: end chk_age_uom;
492: -- ---------------------------------------------------------------------------
493: -- |----------------------------------------------------|

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

524: l_api_updating boolean;
525: --
526: Begin
527: --
528: hr_utility.set_location('Entering:'||l_proc, 5);
529: --
530: l_api_updating := ben_epo_shd.api_updating
531: (p_elig_per_opt_id => p_elig_per_opt_id,
532: p_effective_date => p_effective_date,

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

554: end if;
555: --
556: end if;
557: --
558: hr_utility.set_location('Leaving:'||l_proc,10);
559: --
560: end chk_once_r_cntug_cd;
561: -- ---------------------------------------------------------------------------
562: -- |-------------------------------------------------------|

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

593: l_api_updating boolean;
594: --
595: Begin
596: --
597: hr_utility.set_location('Entering:'||l_proc, 5);
598: --
599: l_api_updating := ben_epo_shd.api_updating
600: (p_elig_per_opt_id => p_elig_per_opt_id,
601: p_effective_date => p_effective_date,

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

623: end if;
624: --
625: end if;
626: --
627: hr_utility.set_location('Leaving:'||l_proc,10);
628: --
629: end chk_inelg_rsn_cd;
630: -- ---------------------------------------------------------------------------
631: -- |------------------------------------------------------------|

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

665: l_api_updating boolean;
666: --
667: Begin
668: --
669: hr_utility.set_location('Entering:'||l_proc, 5);
670: --
671: if (p_los_val is null and p_los_uom is not null) or
672: (p_los_uom is null and p_los_val is not null) then
673: --

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

734: end if;
735: --
736: end if;
737: --
738: hr_utility.set_location('Leaving:'||l_proc,10);
739: --
740: end chk_los_uom;
741: -- ----------------------------------------------------------------------------
742: -- |--------------------------< chk_prtn_ovridn_rsn_cd >----------------------|

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

773: l_api_updating boolean;
774: --
775: Begin
776: --
777: hr_utility.set_location('Entering:'||l_proc, 5);
778: --
779: l_api_updating := ben_epo_shd.api_updating
780: (p_elig_per_opt_id => p_elig_per_opt_id,
781: p_effective_date => p_effective_date,

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

804: end if;
805: --
806: end if;
807: --
808: hr_utility.set_location('Leaving:'||l_proc,10);
809: --
810: end chk_prtn_ovridn_rsn_cd;
811: --
812: -- ----------------------------------------------------------------------------

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

844: l_api_updating boolean;
845: --
846: Begin
847: --
848: hr_utility.set_location('Entering:'||l_proc, 5);
849: --
850: l_api_updating := ben_epo_shd.api_updating
851: (p_elig_per_opt_id => p_elig_per_opt_id,
852: p_effective_date => p_effective_date,

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

874: end if;
875: --
876: end if;
877: --
878: hr_utility.set_location('Leaving:'||l_proc,10);
879: --
880: end chk_elig_flag;
881: --
882: -- ----------------------------------------------------------------------------

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

915: l_api_updating boolean;
916: --
917: Begin
918: --
919: hr_utility.set_location('Entering:'||l_proc, 5);
920: --
921: l_api_updating := ben_epo_shd.api_updating
922: (p_elig_per_opt_id => p_elig_per_opt_id,
923: p_effective_date => p_effective_date,

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

946: end if;
947: --
948: end if;
949: --
950: hr_utility.set_location('Leaving:'||l_proc,10);
951: --
952: end chk_no_mx_prtn_ovrid_thru_flag;
953: --
954: -- ----------------------------------------------------------------------------

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

1009: l_api_updating boolean;
1010: --
1011: Begin
1012: --
1013: hr_utility.set_location('Entering:'||l_proc, 5);
1014: --
1015: l_api_updating := ben_epo_shd.api_updating
1016: (p_elig_per_opt_id => p_elig_per_opt_id,
1017: p_effective_date => p_effective_date,

Line 1020: hr_utility.set_location('RFLF:'||l_proc, 5);

1016: (p_elig_per_opt_id => p_elig_per_opt_id,
1017: p_effective_date => p_effective_date,
1018: p_object_version_number => p_object_version_number);
1019: --
1020: hr_utility.set_location('RFLF:'||l_proc, 5);
1021: if (l_api_updating
1022: and p_rt_frz_los_flag
1023: <> nvl(ben_epo_shd.g_old_rec.rt_frz_los_flag,hr_api.g_varchar2)
1024: or not l_api_updating) then

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

1024: or not l_api_updating) then
1025: --
1026: -- check if value of lookup falls within lookup type.
1027: --
1028: hr_utility.set_location('HRAPI_NEIHL:'||l_proc, 5);
1029: if hr_api.not_exists_in_hr_lookups
1030: (p_lookup_type => 'YES_NO',
1031: p_lookup_code => p_rt_frz_los_flag,
1032: p_effective_date => p_effective_date) then

Line 1045: hr_utility.set_location('RFAF:'||l_proc, 5);

1041: end if;
1042: --
1043: end if;
1044: --
1045: hr_utility.set_location('RFAF:'||l_proc, 5);
1046: if (l_api_updating
1047: and p_rt_frz_age_flag
1048: <> nvl(ben_epo_shd.g_old_rec.rt_frz_age_flag,hr_api.g_varchar2)
1049: or not l_api_updating) then

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

1065: end if;
1066: --
1067: end if;
1068: --
1069: hr_utility.set_location('RFCLF:'||l_proc, 5);
1070: if (l_api_updating
1071: and p_rt_frz_cmp_lvl_flag
1072: <> nvl(ben_epo_shd.g_old_rec.rt_frz_cmp_lvl_flag,hr_api.g_varchar2)
1073: or not l_api_updating) then

Line 1093: hr_utility.set_location('RFPFTF:'||l_proc, 5);

1089: end if;
1090: --
1091: end if;
1092: --
1093: hr_utility.set_location('RFPFTF:'||l_proc, 5);
1094: if (l_api_updating
1095: and p_rt_frz_pct_fl_tm_flag
1096: <> nvl(ben_epo_shd.g_old_rec.rt_frz_pct_fl_tm_flag,hr_api.g_varchar2)
1097: or not l_api_updating) then

Line 1117: hr_utility.set_location('RFHWF:'||l_proc, 5);

1113: end if;
1114: --
1115: end if;
1116: --
1117: hr_utility.set_location('RFHWF:'||l_proc, 5);
1118: if (l_api_updating
1119: and p_rt_frz_hrs_wkd_flag
1120: <> nvl(ben_epo_shd.g_old_rec.rt_frz_hrs_wkd_flag,hr_api.g_varchar2)
1121: or not l_api_updating) then

Line 1141: hr_utility.set_location('RFCAALF:'||l_proc, 5);

1137: end if;
1138: --
1139: end if;
1140: --
1141: hr_utility.set_location('RFCAALF:'||l_proc, 5);
1142: if (l_api_updating
1143: and p_rt_frz_comb_age_and_los_flag
1144: <> nvl(ben_epo_shd.g_old_rec.rt_frz_comb_age_and_los_flag,hr_api.g_varchar2)
1145: or not l_api_updating) then

Line 1165: hr_utility.set_location('FLF:'||l_proc, 5);

1161: end if;
1162: --
1163: end if;
1164: --
1165: hr_utility.set_location('FLF:'||l_proc, 5);
1166: if (l_api_updating
1167: and p_frz_los_flag
1168: <> nvl(ben_epo_shd.g_old_rec.frz_los_flag,hr_api.g_varchar2)
1169: or not l_api_updating) then

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

1185: end if;
1186: --
1187: end if;
1188: --
1189: hr_utility.set_location('FAF:'||l_proc, 5);
1190: if (l_api_updating
1191: and p_frz_age_flag
1192: <> nvl(ben_epo_shd.g_old_rec.frz_age_flag,hr_api.g_varchar2)
1193: or not l_api_updating) then

Line 1213: hr_utility.set_location('FCLF:'||l_proc, 5);

1209: end if;
1210: --
1211: end if;
1212: --
1213: hr_utility.set_location('FCLF:'||l_proc, 5);
1214: if (l_api_updating
1215: and p_frz_cmp_lvl_flag
1216: <> nvl(ben_epo_shd.g_old_rec.frz_cmp_lvl_flag,hr_api.g_varchar2)
1217: or not l_api_updating) then

Line 1237: hr_utility.set_location('FPFTF:'||l_proc, 5);

1233: end if;
1234: --
1235: end if;
1236: --
1237: hr_utility.set_location('FPFTF:'||l_proc, 5);
1238: if (l_api_updating
1239: and p_frz_pct_fl_tm_flag
1240: <> nvl(ben_epo_shd.g_old_rec.frz_pct_fl_tm_flag,hr_api.g_varchar2)
1241: or not l_api_updating) then

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

1257: end if;
1258: --
1259: end if;
1260: --
1261: hr_utility.set_location('FHWFF:'||l_proc, 5);
1262: if (l_api_updating
1263: and p_frz_hrs_wkd_flag
1264: <> nvl(ben_epo_shd.g_old_rec.frz_hrs_wkd_flag,hr_api.g_varchar2)
1265: or not l_api_updating) then

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

1281: end if;
1282: --
1283: end if;
1284: --
1285: hr_utility.set_location('Leaving:'||l_proc,10);
1286: --
1287: end chk_all_freeze_flags;
1288: -- ----------------------------------------------------------------------------
1289: -- |----------------------------< chk_prtn_ovridn_flag >----------------------|

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

1320: l_api_updating boolean;
1321: --
1322: Begin
1323: --
1324: hr_utility.set_location('Entering:'||l_proc, 5);
1325: --
1326: l_api_updating := ben_epo_shd.api_updating
1327: (p_elig_per_opt_id => p_elig_per_opt_id,
1328: p_effective_date => p_effective_date,

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

1350: end if;
1351: --
1352: end if;
1353: --
1354: hr_utility.set_location('Leaving:'||l_proc,10);
1355: --
1356: end chk_prtn_ovridn_flag;
1357: --
1358: -- ----------------------------------------------------------------------------

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

1395: l_integrity_error Exception;
1396: l_table_name all_tables.table_name%TYPE;
1397: --
1398: Begin
1399: hr_utility.set_location('Entering:'||l_proc, 5);
1400: --
1401: -- Ensure that the p_datetrack_mode argument is not null
1402: --
1403: hr_api.mandatory_arg_error

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

1444: End If;
1445: --
1446: End If;
1447: --
1448: hr_utility.set_location(' Leaving:'||l_proc, 10);
1449: Exception
1450: When l_integrity_error Then
1451: --
1452: -- A referential integrity check was violated therefore

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

1511: l_rows_exist Exception;
1512: l_table_name all_tables.table_name%TYPE;
1513: --
1514: Begin
1515: hr_utility.set_location('Entering:'||l_proc, 5);
1516: --
1517: -- Ensure that the p_datetrack_mode argument is not null
1518: --
1519: hr_api.mandatory_arg_error

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

1548: --
1549: --
1550: End If;
1551: --
1552: hr_utility.set_location(' Leaving:'||l_proc, 10);
1553: Exception
1554: When l_rows_exist Then
1555: --
1556: -- A referential integrity check was violated therefore

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

1582: --
1583: l_proc varchar2(72) := g_package||'insert_validate';
1584: --
1585: Begin
1586: hr_utility.set_location('Entering:'||l_proc, 5);
1587: --
1588: -- Call all supporting business operations
1589: --
1590: --

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

1687: p_inelg_rsn_cd => p_rec.inelg_rsn_cd,
1688: p_effective_date => p_effective_date,
1689: p_object_version_number => p_rec.object_version_number);
1690: --
1691: hr_utility.set_location(' Leaving:'||l_proc, 10);
1692: End insert_validate;
1693: --
1694: -- ----------------------------------------------------------------------------
1695: -- |---------------------------< update_validate >----------------------------|

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

1703: --
1704: l_proc varchar2(72) := g_package||'update_validate';
1705: --
1706: Begin
1707: hr_utility.set_location('Entering:'||l_proc, 5);
1708: --
1709: -- Call all supporting business operations
1710: --
1711: --

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

1817: p_datetrack_mode => p_datetrack_mode,
1818: p_validation_start_date => p_validation_start_date,
1819: p_validation_end_date => p_validation_end_date);
1820: --
1821: hr_utility.set_location(' Leaving:'||l_proc, 10);
1822: End update_validate;
1823: --
1824: -- ----------------------------------------------------------------------------
1825: -- |---------------------------< delete_validate >----------------------------|

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

1833: --
1834: l_proc varchar2(72) := g_package||'delete_validate';
1835: --
1836: Begin
1837: hr_utility.set_location('Entering:'||l_proc, 5);
1838: --
1839: -- Call all supporting business operations
1840: --
1841: dt_delete_validate

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

1843: p_validation_start_date => p_validation_start_date,
1844: p_validation_end_date => p_validation_end_date,
1845: p_elig_per_opt_id => p_rec.elig_per_opt_id);
1846: --
1847: hr_utility.set_location(' Leaving:'||l_proc, 10);
1848: End delete_validate;
1849: --
1850: -- ---------------------------------------------------------------------------
1851: -- |---------------------< return_legislation_code >-------------------------|

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

1869: l_proc varchar2(72) := g_package||'return_legislation_code';
1870: --
1871: begin
1872: --
1873: hr_utility.set_location('Entering:'|| l_proc, 10);
1874: --
1875: -- Ensure that all the mandatory parameter are not null
1876: --
1877: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1894: end if;
1895: --
1896: close csr_leg_code;
1897: --
1898: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1899: --
1900: return l_legislation_code;
1901: --
1902: end return_legislation_code;