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_EQG_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_eqg_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_QUA_IN_GR_PRTE_id => p_ELIG_QUA_IN_GR_PRTE_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_ELIG_QUA_IN_GR_PRTE_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_eqg_shd.api_updating
118: (p_ELIG_QUA_IN_GR_PRTE_id => p_ELIG_QUA_IN_GR_PRTE_id,
119: p_effective_date => p_effective_date,

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

143: end if;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: end chk_excld_flag;
150: --
151: -- ----------------------------------------------------------------------------

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

183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_eqg_shd.api_updating
190: (p_ELIG_QUA_IN_GR_PRTE_id => p_ELIG_QUA_IN_GR_PRTE_id,
191: p_effective_date => p_effective_date,

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

215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_quar_in_grade_cd;
222: --
223: -- ----------------------------------------------------------------------------

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

263: and eqg.ELIG_QUA_IN_GR_PRTE_id <> nvl(p_ELIG_QUA_IN_GR_PRTE_id, hr_api.g_number) ;
264: --
265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: l_api_updating := ben_eqg_shd.api_updating
270: (p_ELIG_QUA_IN_GR_PRTE_id => p_ELIG_QUA_IN_GR_PRTE_id,
271: p_effective_date => p_effective_date,

Line 281: hr_utility.set_location(l_proc, 7);

277: fetch c_ELIG_QUA_IN_GR_PRTE into l_dummy;
278: if c_ELIG_QUA_IN_GR_PRTE%found then
279: --
280: close c_ELIG_QUA_IN_GR_PRTE;
281: hr_utility.set_location(l_proc, 7);
282: --
283: -- raise error as duplicate criteria has been entered
284: --
285: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');

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

288: end if;
289: --
290: close c_ELIG_QUA_IN_GR_PRTE;
291: --
292: hr_utility.set_location('Leaving:'||l_proc,10);
293: --
294: end chk_dup_elig_criteria;
295: --
296: --Bug:5054189

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

337: and ordr_num = p_ordr_num
338: and business_group_id = p_business_group_id;
339: --
340: Begin
341: hr_utility.set_location('Entering:'||l_proc, 5);
342: --
343: open c1;
344: fetch c1 into l_dummy;
345: if c1%found then

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

348: fnd_message.raise_error;
349: end if;
350: close c1;
351: --
352: hr_utility.set_location('Leaving:'||l_proc, 15);
353: End chk_duplicate_ordr_num;
354: -- ----------------------------------------------------------------------------
355: -- |--------------------------< dt_update_validate >--------------------------|
356: -- ----------------------------------------------------------------------------

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

390: l_integrity_error Exception;
391: l_table_name all_tables.table_name%TYPE;
392: --
393: Begin
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: -- Ensure that the p_datetrack_mode argument is not null
397: --
398: hr_api.mandatory_arg_error

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

429: End If;
430: --
431: End If;
432: --
433: hr_utility.set_location(' Leaving:'||l_proc, 10);
434: Exception
435: When l_integrity_error Then
436: --
437: -- A referential integrity check was violated therefore

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

495: l_rows_exist Exception;
496: l_table_name all_tables.table_name%TYPE;
497: --
498: Begin
499: hr_utility.set_location('Entering:'||l_proc, 5);
500: --
501: -- Ensure that the p_datetrack_mode argument is not null
502: --
503: hr_api.mandatory_arg_error

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

532: --
533: --
534: End If;
535: --
536: hr_utility.set_location(' Leaving:'||l_proc, 10);
537: Exception
538: When l_rows_exist Then
539: --
540: -- A referential integrity check was violated therefore

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

566: --
567: l_proc varchar2(72) := g_package||'insert_validate';
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: -- Call all supporting business operations
573: --
574: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

602: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
603: ,p_ordr_num => p_rec.ordr_num
604: ,p_business_group_id => p_rec.business_group_id);
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 10);
607: End insert_validate;
608: --
609: -- ----------------------------------------------------------------------------
610: -- |---------------------------< update_validate >----------------------------|

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

618: --
619: l_proc varchar2(72) := g_package||'update_validate';
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

662: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
663: ,p_ordr_num => p_rec.ordr_num
664: ,p_business_group_id => p_rec.business_group_id);
665: --
666: hr_utility.set_location(' Leaving:'||l_proc, 10);
667: End update_validate;
668: --
669: -- ----------------------------------------------------------------------------
670: -- |---------------------------< delete_validate >----------------------------|

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

678: --
679: l_proc varchar2(72) := g_package||'delete_validate';
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: -- Call all supporting business operations
685: --
686: dt_delete_validate

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

688: p_validation_start_date => p_validation_start_date,
689: p_validation_end_date => p_validation_end_date,
690: p_ELIG_QUA_IN_GR_PRTE_id => p_rec.ELIG_QUA_IN_GR_PRTE_id);
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 10);
693: End delete_validate;
694: --
695: --
696: -- ---------------------------------------------------------------------------

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

715: l_proc varchar2(72) := g_package||'return_legislation_code';
716: --
717: begin
718: --
719: hr_utility.set_location('Entering:'|| l_proc, 10);
720: --
721: -- Ensure that all the mandatory parameter are not null
722: --
723: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

740: end if;
741: --
742: close csr_leg_code;
743: --
744: hr_utility.set_location(' Leaving:'|| l_proc, 20);
745: --
746: return l_legislation_code;
747: --
748: end return_legislation_code;