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_DPNT_EGD_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_dpnt_egd_shd.api_updating
47: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_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_dpnt_id;
75: --
76: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

634: close c_formula;
635: --
636: end if;
637: --
638: hr_utility.set_location('Leaving:'||l_proc, 15);
639:
640: end chk_access_calc_rule;
641: */
642:

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

682:
683: --
684: --
685: Begin
686: hr_utility.set_location('Entering:'||l_proc, 5);
687: --
688: --
689: l_api_updating := ben_dpnt_egd_shd.api_updating
690: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,

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

726: close c1;
727: --
728: end if;
729: --
730: hr_utility.set_location('Leaving:'||l_proc, 15);
731:
732: end chk_col_value_set_id;
733:
734: --

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

767: where ecv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;
768:
769: begin
770: --
771: hr_utility.set_location('Entering:'||l_proc, 5);
772: --
773: -- check if eligy criteria exists in the eligy_crit_values_f table
774: --
775: open chk_eligy_criteria;

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

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

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

824: l_proc varchar2(72) := g_package||'chk_access_exclusive';
825: --
826: Begin
827: --
828: hr_utility.set_location('Entering:'||l_proc, 5);
829: --
830: if (
831: (p_access_table_name1 is not null
832: or p_access_column_name1 is not null ) )

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

837: fnd_message.raise_error;
838: --
839: end if;
840:
841: hr_utility.set_location('Leaving:'||l_proc, 10);
842:
843: end chk_access_exclusive;
844: --
845: -- ----------------------------------------------------------------------------

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

893: and column_name = p_access_column_name;
894: --
895: --
896: Begin
897: hr_utility.set_location('Entering:'||l_proc, 5);
898: --
899:
900: if p_access_table_name1 is not null then
901: --

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

1001: end if;
1002: --
1003: end if;
1004: --
1005: hr_utility.set_location('Leaving:'||l_proc, 15);
1006:
1007: end chk_table_column;
1008: --
1009: -- ----------------------------------------------------------------------------

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

1045: --
1046:
1047: --
1048: Begin
1049: hr_utility.set_location('Entering:'||l_proc, 5);
1050: --
1051: if p_crit_col_val_type_cd is not null
1052: then
1053: --

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

1154: end if;
1155: --
1156: end if;-- upd
1157: --
1158: hr_utility.set_location('Leaving:'||l_proc, 15);
1159: --
1160: end chk_col_val_type_cd;
1161: --
1162: -- ----------------------------------------------------------------------------

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

1203: from ben_dpnt_eligy_crit_values_f ecv
1204: where ecv.eligy_criteria_dpnt_id = p_eligy_criteria_dpnt_id;
1205: --
1206: Begin
1207: hr_utility.set_location('Entering:'||l_proc, 5);
1208: --
1209: --
1210: l_api_updating := ben_dpnt_egd_shd.api_updating
1211: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,

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

1264: --
1265: end if;-- upd
1266: --
1267: end if;--if null
1268: hr_utility.set_location('Leaving:'||l_proc, 15);
1269:
1270: end chk_col_val_type_cd_upd;
1271:
1272: -- ----------------------------------------------------------------------------

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

1301: l_proc varchar2(72) := g_package||'chk_tab_col_rl_null';
1302: --
1303: Begin
1304: --
1305: hr_utility.set_location('Entering:'||l_proc, 5);
1306: --
1307: if (
1308: (p_access_table_name1 is null
1309: and p_access_column_name1 is null ) )

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

1314: fnd_message.raise_error;
1315: --
1316: end if;
1317: --
1318: hr_utility.set_location('Leaving:'||l_proc, 10);
1319:
1320: end chk_tab_col_rl_null;
1321: --
1322: -- ----------------------------------------------------------------------------

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

1354: l_api_updating boolean;
1355: --
1356:
1357: Begin
1358: hr_utility.set_location('Entering:'||l_proc, 5);
1359: --
1360: --
1361: l_api_updating := ben_dpnt_egd_shd.api_updating
1362: (p_eligy_criteria_dpnt_id => p_eligy_criteria_dpnt_id,

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

1391: --
1392: end if;
1393: --
1394:
1395: hr_utility.set_location('Leaving:'||l_proc, 15);
1396:
1397: end chk_tab_col_rl_upd;
1398: --
1399: --

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

1445: l_proc varchar2(72) := g_package||'insert_validate';
1446: l_set2_empty varchar2(1) := 'Y';
1447: --
1448: Begin
1449: hr_utility.set_location('Entering:'||l_proc, 5);
1450: --
1451: -- Call all supporting business operations
1452: --
1453: --

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

1585: p_access_column_name1 => p_rec.access_column_name2);
1586: end if;
1587: end if;
1588:
1589: hr_utility.set_location(' Leaving:'||l_proc, 10);
1590:
1591: End insert_validate;
1592: --
1593: -- ----------------------------------------------------------------------------

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

1599: l_proc varchar2(72) := g_package||'update_validate';
1600: l_set2_empty varchar2(1) := 'Y';
1601: --
1602: Begin
1603: hr_utility.set_location('Entering:'||l_proc, 5);
1604: --
1605: -- Call all supporting business operations
1606: --
1607: --

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

1768: p_access_column_name1 => p_rec.access_column_name2);
1769: end if;
1770: end if;
1771:
1772: hr_utility.set_location(' Leaving:'||l_proc, 10);
1773: End update_validate;
1774: --
1775: -- ----------------------------------------------------------------------------
1776: -- |---------------------------< delete_validate >----------------------------|

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

1780: --
1781: l_proc varchar2(72) := g_package||'delete_validate';
1782: --
1783: Begin
1784: hr_utility.set_location('Entering:'||l_proc, 5);
1785: --
1786: -- Call all supporting business operations
1787: --
1788: chk_child_records

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

1787: --
1788: chk_child_records
1789: (p_eligy_criteria_dpnt_id => p_rec.eligy_criteria_dpnt_id);
1790: --
1791: hr_utility.set_location(' Leaving:'||l_proc, 10);
1792: End delete_validate;
1793: --
1794: --
1795: /*

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

1816: l_proc varchar2(72) := g_package||'return_legislation_code';
1817: --
1818: begin
1819: --
1820: hr_utility.set_location('Entering:'|| l_proc, 10);
1821: --
1822: -- Ensure that all the mandatory parameter are not null
1823: --
1824: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

1834: close csr_leg_code;
1835: --
1836: -- The primary key is invalid therefore we must error
1837: --
1838: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1839: hr_utility.raise_error;
1840: --
1841:
1842: end if;

Line 1839: hr_utility.raise_error;

1835: --
1836: -- The primary key is invalid therefore we must error
1837: --
1838: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
1839: hr_utility.raise_error;
1840: --
1841:
1842: end if;
1843: --

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

1842: end if;
1843: --
1844: close csr_leg_code;
1845: --
1846: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1847: --
1848: return l_legislation_code;
1849: --
1850: end return_legislation_code;