DBA Data[Home] [Help]

APPS.BEN_EPZ_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_epz_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_pstl_cd_r_rng_prte_id => p_elig_pstl_cd_r_rng_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_pstl_cd_r_rng_prte_id;
78: --
79: -- ----------------------------------------------------------------------------

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

139: --
140: --
141: Begin
142: --
143: hr_utility.set_location('Entering:'||l_proc,5);
144: --
145: l_api_updating := ben_epz_shd.api_updating
146: (p_elig_pstl_cd_r_rng_prte_id => p_elig_pstl_cd_r_rng_prte_id,
147: p_effective_date => p_effective_date,

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

185: --
186: --
187: end if;
188: --
189: hr_utility.set_location('Leaving:'||l_proc,10);
190: --
191: End chk_pstl_zip_rng_id;
192: --
193: --

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

226: l_api_updating boolean;
227: --
228: Begin
229: --
230: hr_utility.set_location('Entering:'||l_proc, 5);
231: --
232: l_api_updating := ben_epz_shd.api_updating
233: (p_elig_pstl_cd_r_rng_prte_id => p_elig_pstl_cd_r_rng_prte_id,
234: p_effective_date => p_effective_date,

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

255: end if;
256: --
257: end if;
258: --
259: hr_utility.set_location('Leaving:'||l_proc,10);
260: --
261: end chk_excld_flag;
262: --
263: --Bug:5054189

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

304: and ordr_num = p_ordr_num
305: and business_group_id = p_business_group_id;
306: --
307: Begin
308: hr_utility.set_location('Entering:'||l_proc, 5);
309: --
310: open c1;
311: fetch c1 into l_dummy;
312: if c1%found then

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

315: fnd_message.raise_error;
316: end if;
317: close c1;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 15);
320: End chk_duplicate_ordr_num;
321:
322: -- ----------------------------------------------------------------------------
323: -- |--------------------------< dt_update_validate >--------------------------|

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

359: l_integrity_error Exception;
360: l_table_name all_tables.table_name%TYPE;
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Ensure that the p_datetrack_mode argument is not null
366: --
367: hr_api.mandatory_arg_error

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

408: End If;
409: --
410: End If;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: Exception
414: When l_integrity_error Then
415: --
416: -- A referential integrity check was violated therefore

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

475: l_rows_exist Exception;
476: l_table_name all_tables.table_name%TYPE;
477: --
478: Begin
479: hr_utility.set_location('Entering:'||l_proc, 5);
480: --
481: -- Ensure that the p_datetrack_mode argument is not null
482: --
483: hr_api.mandatory_arg_error

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

512: --
513: --
514: End If;
515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 10);
517: Exception
518: When l_rows_exist Then
519: --
520: -- A referential integrity check was violated therefore

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

546: --
547: l_proc varchar2(72) := g_package||'insert_validate';
548: --
549: Begin
550: hr_utility.set_location('Entering:'||l_proc, 5);
551: --
552: -- Call all supporting business operations
553: --
554: --

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

579: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
580: ,p_ordr_num => p_rec.ordr_num
581: ,p_business_group_id => p_rec.business_group_id);
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 10);
584: End insert_validate;
585: --
586: -- ----------------------------------------------------------------------------
587: -- |---------------------------< update_validate >----------------------------|

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

595: --
596: l_proc varchar2(72) := g_package||'update_validate';
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Call all supporting business operations
602: --
603: --

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

637: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
638: ,p_ordr_num => p_rec.ordr_num
639: ,p_business_group_id => p_rec.business_group_id);
640: --
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: End update_validate;
643: --
644: -- ----------------------------------------------------------------------------
645: -- |---------------------------< delete_validate >----------------------------|

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

653: --
654: l_proc varchar2(72) := g_package||'delete_validate';
655: --
656: Begin
657: hr_utility.set_location('Entering:'||l_proc, 5);
658: --
659: -- Call all supporting business operations
660: --
661: dt_delete_validate

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

663: p_validation_start_date => p_validation_start_date,
664: p_validation_end_date => p_validation_end_date,
665: p_elig_pstl_cd_r_rng_prte_id => p_rec.elig_pstl_cd_r_rng_prte_id);
666: --
667: hr_utility.set_location(' Leaving:'||l_proc, 10);
668: End delete_validate;
669: --
670: --
671: -- ---------------------------------------------------------------------------

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

690: l_proc varchar2(72) := g_package||'return_legislation_code';
691: --
692: begin
693: --
694: hr_utility.set_location('Entering:'|| l_proc, 10);
695: --
696: -- Ensure that all the mandatory parameter are not null
697: --
698: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

715: end if;
716: --
717: close csr_leg_code;
718: --
719: hr_utility.set_location(' Leaving:'|| l_proc, 20);
720: --
721: return l_legislation_code;
722: --
723: end return_legislation_code;