DBA Data[Home] [Help]

APPS.BEN_ELV_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_elv_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_lvg_rsn_prte_id => p_elig_lvg_rsn_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_lvg_rsn_prte_id;
78: --
79: -- ----------------------------------------------------------------------------

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

128:
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_elv_shd.api_updating
135: (p_elig_lvg_rsn_prte_id => p_elig_lvg_rsn_prte_id,
136: p_effective_date => p_effective_date,

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

172: close c3;
173: --
174: end if;
175: --
176: hr_utility.set_location('Leaving:'||l_proc,10);
177: --
178: end chk_lvg_rsn_cd;
179: --
180: -- ----------------------------------------------------------------------------

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

212: l_api_updating boolean;
213: --
214: Begin
215: --
216: hr_utility.set_location('Entering:'||l_proc, 5);
217: --
218: l_api_updating := ben_elv_shd.api_updating
219: (p_elig_lvg_rsn_prte_id => p_elig_lvg_rsn_prte_id,
220: p_effective_date => p_effective_date,

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

243: end if;
244: --
245: end if;
246: --
247: hr_utility.set_location('Leaving:'||l_proc,10);
248: --
249: end chk_excld_flag;
250: --
251:

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

293: and ordr_num = p_ordr_num
294: and business_group_id = p_business_group_id;
295: --
296: Begin
297: hr_utility.set_location('Entering:'||l_proc, 5);
298: --
299: open c1;
300: fetch c1 into l_dummy;
301: if c1%found then

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

304: fnd_message.raise_error;
305: end if;
306: close c1;
307: --
308: hr_utility.set_location('Leaving:'||l_proc, 15);
309: End chk_duplicate_ordr_num;
310:
311: -- ----------------------------------------------------------------------------
312: -- |--------------------------< dt_update_validate >--------------------------|

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

347: l_integrity_error Exception;
348: l_table_name all_tables.table_name%TYPE;
349: --
350: Begin
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: -- Ensure that the p_datetrack_mode argument is not null
354: --
355: hr_api.mandatory_arg_error

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

386: End If;
387: --
388: End If;
389: --
390: hr_utility.set_location(' Leaving:'||l_proc, 10);
391: Exception
392: When l_integrity_error Then
393: --
394: -- A referential integrity check was violated therefore

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

451: l_rows_exist Exception;
452: l_table_name all_tables.table_name%TYPE;
453: --
454: Begin
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: -- Ensure that the p_datetrack_mode argument is not null
458: --
459: hr_api.mandatory_arg_error

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

488: --
489: --
490: End If;
491: --
492: hr_utility.set_location(' Leaving:'||l_proc, 10);
493: Exception
494: When l_rows_exist Then
495: --
496: -- A referential integrity check was violated therefore

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

522: --
523: l_proc varchar2(72) := g_package||'insert_validate';
524: --
525: Begin
526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- Call all supporting business operations
529: --
530: --

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

556: p_eligy_prfl_id => p_rec.eligy_prfl_id,
557: p_ordr_num => p_rec.ordr_num,
558: p_business_group_id => p_rec.business_group_id);
559: --
560: hr_utility.set_location(' Leaving:'||l_proc, 10);
561: End insert_validate;
562: --
563: -- ----------------------------------------------------------------------------
564: -- |---------------------------< update_validate >----------------------------|

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

572: --
573: l_proc varchar2(72) := g_package||'update_validate';
574: --
575: Begin
576: hr_utility.set_location('Entering:'||l_proc, 5);
577: --
578: -- Call all supporting business operations
579: --
580: --

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

614: p_eligy_prfl_id => p_rec.eligy_prfl_id,
615: p_ordr_num => p_rec.ordr_num,
616: p_business_group_id => p_rec.business_group_id);
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: End update_validate;
620: --
621: -- ----------------------------------------------------------------------------
622: -- |---------------------------< delete_validate >----------------------------|

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

630: --
631: l_proc varchar2(72) := g_package||'delete_validate';
632: --
633: Begin
634: hr_utility.set_location('Entering:'||l_proc, 5);
635: --
636: -- Call all supporting business operations
637: --
638: dt_delete_validate

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

640: p_validation_start_date => p_validation_start_date,
641: p_validation_end_date => p_validation_end_date,
642: p_elig_lvg_rsn_prte_id => p_rec.elig_lvg_rsn_prte_id);
643: --
644: hr_utility.set_location(' Leaving:'||l_proc, 10);
645: End delete_validate;
646: --
647: --
648: -- ---------------------------------------------------------------------------

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

667: l_proc varchar2(72) := g_package||'return_legislation_code';
668: --
669: begin
670: --
671: hr_utility.set_location('Entering:'|| l_proc, 10);
672: --
673: -- Ensure that all the mandatory parameter are not null
674: --
675: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

692: end if;
693: --
694: close csr_leg_code;
695: --
696: hr_utility.set_location(' Leaving:'|| l_proc, 20);
697: --
698: return l_legislation_code;
699: --
700: end return_legislation_code;