DBA Data[Home] [Help]

APPS.BEN_EGR_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_egr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_grd_prte_id => p_elig_grd_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_grd_prte_id;
78: --
79: -- ----------------------------------------------------------------------------

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

137: ;
138: --
139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc,5);
142: --
143: l_api_updating := ben_egr_shd.api_updating
144: (p_elig_grd_prte_id => p_elig_grd_prte_id,
145: p_effective_date => p_effective_date,

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

169: close c1;
170: --
171: end if;
172: --
173: hr_utility.set_location('Leaving:'||l_proc,10);
174: --
175: End chk_grade_id;
176: --
177: -- ----------------------------------------------------------------------------

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

209: l_api_updating boolean;
210: --
211: Begin
212: --
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: l_api_updating := ben_egr_shd.api_updating
216: (p_elig_grd_prte_id => p_elig_grd_prte_id,
217: p_effective_date => p_effective_date,

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

238: end if;
239: --
240: end if;
241: --
242: hr_utility.set_location('Leaving:'||l_proc,10);
243: --
244: end chk_excld_flag;
245: --
246: --Bug:5054189

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

287: and ordr_num = p_ordr_num
288: and business_group_id = p_business_group_id;
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: open c1;
294: fetch c1 into l_dummy;
295: if c1%found then

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

298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 15);
303: End chk_duplicate_ordr_num;
304: -- ----------------------------------------------------------------------------
305: -- |--------------------------< dt_update_validate >--------------------------|
306: -- ----------------------------------------------------------------------------

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

340: l_integrity_error Exception;
341: l_table_name all_tables.table_name%TYPE;
342: --
343: Begin
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- Ensure that the p_datetrack_mode argument is not null
347: --
348: hr_api.mandatory_arg_error

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

379: End If;
380: --
381: End If;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: Exception
385: When l_integrity_error Then
386: --
387: -- A referential integrity check was violated therefore

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

445: l_rows_exist Exception;
446: l_table_name all_tables.table_name%TYPE;
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: --
451: -- Ensure that the p_datetrack_mode argument is not null
452: --
453: hr_api.mandatory_arg_error

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

482: --
483: --
484: End If;
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: Exception
488: When l_rows_exist Then
489: --
490: -- A referential integrity check was violated therefore

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

515: --
516: l_proc varchar2(72) := g_package||'insert_validate';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call all supporting business operations
522: --
523: --

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

549: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
550: ,p_ordr_num => p_rec.ordr_num
551: ,p_business_group_id => p_rec.business_group_id);
552: --
553: hr_utility.set_location(' Leaving:'||l_proc, 10);
554: End insert_validate;
555: --
556: -- ----------------------------------------------------------------------------
557: -- |---------------------------< update_validate >----------------------------|

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

565: --
566: l_proc varchar2(72) := g_package||'update_validate';
567: --
568: Begin
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: -- Call all supporting business operations
572: --
573: --

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

607: p_datetrack_mode => p_datetrack_mode,
608: p_validation_start_date => p_validation_start_date,
609: p_validation_end_date => p_validation_end_date);
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End update_validate;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< delete_validate >----------------------------|

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

623: --
624: l_proc varchar2(72) := g_package||'delete_validate';
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Call all supporting business operations
630: --
631: dt_delete_validate

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

633: p_validation_start_date => p_validation_start_date,
634: p_validation_end_date => p_validation_end_date,
635: p_elig_grd_prte_id => p_rec.elig_grd_prte_id);
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 10);
638: End delete_validate;
639: --
640: --
641: -- ---------------------------------------------------------------------------

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

660: l_proc varchar2(72) := g_package||'return_legislation_code';
661: --
662: begin
663: --
664: hr_utility.set_location('Entering:'|| l_proc, 10);
665: --
666: -- Ensure that all the mandatory parameter are not null
667: --
668: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

685: end if;
686: --
687: close csr_leg_code;
688: --
689: hr_utility.set_location(' Leaving:'|| l_proc, 20);
690: --
691: return l_legislation_code;
692: --
693: end return_legislation_code;