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

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

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_egl_shd.api_updating
47: (p_eligy_criteria_id => p_eligy_criteria_id,
48: p_object_version_number => p_object_version_number);

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

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_eligy_criteria_id;
75: --
76: -- ----------------------------------------------------------------------------

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

113: and business_group_id = p_business_group_id;
114:
115: --
116: Begin
117: hr_utility.set_location('Entering:'||l_proc, 5);
118: --
119: open c1;
120: fetch c1 into l_dummy;
121: if c1%found then

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

124: fnd_message.raise_error;
125: end if;
126: close c1;
127: --
128: hr_utility.set_location('Leaving:'||l_proc, 15);
129: --
130: End chk_name_unique;
131:
132: /* Bug 5338058 - Commenting this check as short_code need not to be unique

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

171: and business_group_id = p_business_group_id;
172:
173: --
174: Begin
175: hr_utility.set_location('Entering:'||l_proc, 5);
176: --
177: open c1;
178: fetch c1 into l_dummy;
179: if c1%found then

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

182: fnd_message.set_token('FIELD','Short Code');
183: fnd_message.raise_error;
184: end if;
185: --
186: hr_utility.set_location('Leaving:'||l_proc, 15);
187:
188: End chk_short_code_unique;
189: --
190: */

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

240: l_dummy varchar2(30);
241: --
242: Begin
243: --
244: hr_utility.set_location('Entering:'||l_proc, 5);
245: --
246: l_api_updating := ben_egl_shd.api_updating
247: (p_eligy_criteria_id => p_eligy_criteria_id,
248: p_object_version_number => p_object_version_number);

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

423: end if;
424: --
425: end if;
426: --
427: hr_utility.set_location('Leaving:'||l_proc,10);
428: --
429: end chk_all_lookups;
430:
431: --

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

497: );
498: --
499: --
500: begin
501: hr_utility.set_location('Entering:'||l_proc, 5);
502: --
503: --
504: l_api_updating := ben_egl_shd.api_updating
505: (p_eligy_criteria_id => p_eligy_criteria_id,

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

541: close c1;
542: --
543: end if;
544: --
545: hr_utility.set_location('Leaving:'||l_proc, 15);
546:
547: end chk_col_lookup_type;
548: --
549: -- ----------------------------------------------------------------------------

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

592: AND formula_type_id = -552
593: AND nvl(business_group_id, p_business_group_id) = p_business_group_id;
594: --
595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: --
599: l_api_updating := ben_egl_shd.api_updating
600: (p_eligy_criteria_id => p_eligy_criteria_id,

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

639: close c_formula;
640: --
641: end if;
642: --
643: hr_utility.set_location('Leaving:'||l_proc, 15);
644:
645: end chk_access_calc_rule;
646:
647: --

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

686:
687: --
688: --
689: Begin
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: --
693: l_api_updating := ben_egl_shd.api_updating
694: (p_eligy_criteria_id => p_eligy_criteria_id,

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

730: close c1;
731: --
732: end if;
733: --
734: hr_utility.set_location('Leaving:'||l_proc, 15);
735:
736: end chk_col_value_set_id;
737:
738: --

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

770: from ben_eligy_crit_values_f ecv
771: where ecv.eligy_criteria_id = p_eligy_criteria_id;
772: begin
773: --
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- check if eligy criteria exists in the eligy_crit_values_f table
777: --
778: open chk_eligy_criteria;

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

791: end if;
792: --
793: close chk_eligy_criteria;
794: --
795: hr_utility.set_location('Leaving:'||l_proc,10);
796: --
797: end chk_child_records;
798: -- ----------------------------------------------------------------------------
799: -- |---------------------< chk_access_exclusive >---------------------------|

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

828: l_proc varchar2(72) := g_package||'chk_access_exclusive';
829: --
830: Begin
831: --
832: hr_utility.set_location('Entering:'||l_proc, 5);
833: --
834: if (p_access_calc_rule is not null and
835: (p_access_table_name1 is not null
836: or p_access_column_name1 is not null ) )

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

841: fnd_message.raise_error;
842: --
843: end if;
844:
845: hr_utility.set_location('Leaving:'||l_proc, 10);
846:
847: end chk_access_exclusive;
848: --
849: -- ----------------------------------------------------------------------------

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

897: and column_name = p_access_column_name;
898: --
899: --
900: Begin
901: hr_utility.set_location('Entering:'||l_proc, 5);
902: --
903:
904: if p_access_table_name1 is not null then
905: --

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

1005: end if;
1006: --
1007: end if;
1008: --
1009: hr_utility.set_location('Leaving:'||l_proc, 15);
1010:
1011: end chk_table_column;
1012: --
1013: -- ----------------------------------------------------------------------------

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

1050: --
1051:
1052: --
1053: Begin
1054: hr_utility.set_location('Entering:'||l_proc, 5);
1055: --
1056: if p_crit_col_val_type_cd is not null
1057: then
1058: --

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

1159: end if;
1160: --
1161: end if;-- upd
1162: --
1163: hr_utility.set_location('Leaving:'||l_proc, 15);
1164: --
1165: end chk_col_val_type_cd;
1166: --
1167: -- ----------------------------------------------------------------------------

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

1209: from ben_eligy_crit_values_f ecv
1210: where ecv.eligy_criteria_id = p_eligy_criteria_id;
1211: --
1212: Begin
1213: hr_utility.set_location('Entering:'||l_proc, 5);
1214: --
1215: --
1216: l_api_updating := ben_egl_shd.api_updating
1217: (p_eligy_criteria_id => p_eligy_criteria_id,

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

1271: --
1272: end if;-- upd
1273: --
1274: end if;--if null
1275: hr_utility.set_location('Leaving:'||l_proc, 15);
1276:
1277: end chk_col_val_type_cd_upd;
1278:
1279: -- ----------------------------------------------------------------------------

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

1309: l_proc varchar2(72) := g_package||'chk_tab_col_rl_null';
1310: --
1311: Begin
1312: --
1313: hr_utility.set_location('Entering:'||l_proc, 5);
1314: --
1315: if (p_access_calc_rule is null and
1316: (p_access_table_name1 is null
1317: and p_access_column_name1 is null ) )

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

1322: fnd_message.raise_error;
1323: --
1324: end if;
1325: --
1326: hr_utility.set_location('Leaving:'||l_proc, 10);
1327:
1328: end chk_tab_col_rl_null;
1329: --
1330: -- ----------------------------------------------------------------------------

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

1363: l_api_updating boolean;
1364: --
1365:
1366: Begin
1367: hr_utility.set_location('Entering:'||l_proc, 5);
1368: --
1369: --
1370: l_api_updating := ben_egl_shd.api_updating
1371: (p_eligy_criteria_id => p_eligy_criteria_id,

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

1402: --
1403: end if;
1404: --
1405:
1406: hr_utility.set_location('Leaving:'||l_proc, 15);
1407:
1408: end chk_tab_col_rl_upd;
1409: --
1410: --

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

1456: l_proc varchar2(72) := g_package||'insert_validate';
1457: l_set2_empty varchar2(1) := 'Y';
1458: --
1459: Begin
1460: hr_utility.set_location('Entering:'||l_proc, 5);
1461: --
1462: -- Call all supporting business operations
1463: --
1464: --

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

1602: p_access_column_name1 => p_rec.access_column_name2);
1603: end if;
1604: end if;
1605:
1606: hr_utility.set_location(' Leaving:'||l_proc, 10);
1607:
1608: End insert_validate;
1609: --
1610: -- ----------------------------------------------------------------------------

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

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

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

1794: p_access_column_name1 => p_rec.access_column_name2);
1795: end if;
1796: end if;
1797:
1798: hr_utility.set_location(' Leaving:'||l_proc, 10);
1799: End update_validate;
1800: --
1801: -- ----------------------------------------------------------------------------
1802: -- |---------------------------< delete_validate >----------------------------|

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

1806: --
1807: l_proc varchar2(72) := g_package||'delete_validate';
1808: --
1809: Begin
1810: hr_utility.set_location('Entering:'||l_proc, 5);
1811: --
1812: -- Call all supporting business operations
1813: --
1814: chk_child_records

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

1813: --
1814: chk_child_records
1815: (p_eligy_criteria_id => p_rec.eligy_criteria_id);
1816: --
1817: hr_utility.set_location(' Leaving:'||l_proc, 10);
1818: End delete_validate;
1819: --
1820: --
1821: -- ---------------------------------------------------------------------------

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

1840: l_proc varchar2(72) := g_package||'return_legislation_code';
1841: --
1842: begin
1843: --
1844: hr_utility.set_location('Entering:'|| l_proc, 10);
1845: --
1846: -- Ensure that all the mandatory parameter are not null
1847: --
1848: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 1862: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

1858: close csr_leg_code;
1859: --
1860: -- The primary key is invalid therefore we must error
1861: --
1862: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1863: hr_utility.raise_error;
1864: --
1865:
1866: end if;

Line 1863: hr_utility.raise_error;

1859: --
1860: -- The primary key is invalid therefore we must error
1861: --
1862: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1863: hr_utility.raise_error;
1864: --
1865:
1866: end if;
1867: --

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

1866: end if;
1867: --
1868: close csr_leg_code;
1869: --
1870: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1871: --
1872: return l_legislation_code;
1873: --
1874: end return_legislation_code;