DBA Data[Home] [Help]

APPS.BEN_EEI_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_eei_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_enrld_anthr_oipl_id => p_elig_enrld_anthr_oipl_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_enrld_anthr_oipl_id;
78: --
79: -- ----------------------------------------------------------------------------

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

136: and p_validation_end_date >= eei.effective_start_date;
137: --
138: Begin
139: --
140: hr_utility.set_location('Entering:'||l_proc,5);
141: --
142: l_api_updating := ben_eei_shd.api_updating
143: (p_elig_enrld_anthr_oipl_id => p_elig_enrld_anthr_oipl_id,
144: p_effective_date => p_effective_date,

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

181: end if;
182: close c3;
183: --
184: --
185: hr_utility.set_location('Leaving:'||l_proc,10);
186: --
187: End chk_oipl_id;
188: --
189: -- ----------------------------------------------------------------------------

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

221: l_api_updating boolean;
222: --
223: Begin
224: --
225: hr_utility.set_location('Entering:'||l_proc, 5);
226: --
227: l_api_updating := ben_eei_shd.api_updating
228: (p_elig_enrld_anthr_oipl_id => p_elig_enrld_anthr_oipl_id,
229: p_effective_date => p_effective_date,

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

252: end if;
253: --
254: end if;
255: --
256: hr_utility.set_location('Leaving:'||l_proc,10);
257: --
258: end chk_enrl_det_dt_cd;
259: --
260: -- ----------------------------------------------------------------------------

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

292: l_api_updating boolean;
293: --
294: Begin
295: --
296: hr_utility.set_location('Entering:'||l_proc, 5);
297: --
298: l_api_updating := ben_eei_shd.api_updating
299: (p_elig_enrld_anthr_oipl_id => p_elig_enrld_anthr_oipl_id,
300: p_effective_date => p_effective_date,

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

323: end if;
324: --
325: end if;
326: --
327: hr_utility.set_location('Leaving:'||l_proc,10);
328: --
329: end chk_excld_flag;
330: --
331: --Bug:5054189

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

372: and ordr_num = p_ordr_num
373: and business_group_id = p_business_group_id;
374: --
375: Begin
376: hr_utility.set_location('Entering:'||l_proc, 5);
377: --
378: open c1;
379: fetch c1 into l_dummy;
380: if c1%found then

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

383: fnd_message.raise_error;
384: end if;
385: close c1;
386: --
387: hr_utility.set_location('Leaving:'||l_proc, 15);
388: End chk_duplicate_ordr_num;
389: -- ----------------------------------------------------------------------------
390: -- |--------------------------< dt_update_validate >--------------------------|
391: -- ----------------------------------------------------------------------------

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

426: l_integrity_error Exception;
427: l_table_name all_tables.table_name%TYPE;
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: -- Ensure that the p_datetrack_mode argument is not null
433: --
434: hr_api.mandatory_arg_error

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

475: End If;
476: --
477: End If;
478: --
479: hr_utility.set_location(' Leaving:'||l_proc, 10);
480: Exception
481: When l_integrity_error Then
482: --
483: -- A referential integrity check was violated therefore

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

540: l_rows_exist Exception;
541: l_table_name all_tables.table_name%TYPE;
542: --
543: Begin
544: hr_utility.set_location('Entering:'||l_proc, 5);
545: --
546: -- Ensure that the p_datetrack_mode argument is not null
547: --
548: hr_api.mandatory_arg_error

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

577: --
578: --
579: End If;
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 10);
582: Exception
583: When l_rows_exist Then
584: --
585: -- A referential integrity check was violated therefore

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

611: --
612: l_proc varchar2(72) := g_package||'insert_validate';
613: --
614: Begin
615: hr_utility.set_location('Entering:'||l_proc, 5);
616: --
617: -- Call all supporting business operations
618: --
619: --

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

651: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
652: ,p_ordr_num => p_rec.ordr_num
653: ,p_business_group_id => p_rec.business_group_id);
654: --
655: hr_utility.set_location(' Leaving:'||l_proc, 10);
656: End insert_validate;
657: --
658: -- ----------------------------------------------------------------------------
659: -- |---------------------------< update_validate >----------------------------|

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

667: --
668: l_proc varchar2(72) := g_package||'update_validate';
669: --
670: Begin
671: hr_utility.set_location('Entering:'||l_proc, 5);
672: --
673: -- Call all supporting business operations
674: --
675: --

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

716: p_datetrack_mode => p_datetrack_mode,
717: p_validation_start_date => p_validation_start_date,
718: p_validation_end_date => p_validation_end_date);
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 10);
721: End update_validate;
722: --
723: -- ----------------------------------------------------------------------------
724: -- |---------------------------< delete_validate >----------------------------|

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

732: --
733: l_proc varchar2(72) := g_package||'delete_validate';
734: --
735: Begin
736: hr_utility.set_location('Entering:'||l_proc, 5);
737: --
738: -- Call all supporting business operations
739: --
740: dt_delete_validate

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

742: p_validation_start_date => p_validation_start_date,
743: p_validation_end_date => p_validation_end_date,
744: p_elig_enrld_anthr_oipl_id => p_rec.elig_enrld_anthr_oipl_id);
745: --
746: hr_utility.set_location(' Leaving:'||l_proc, 10);
747: End delete_validate;
748: --
749: --
750: -- ---------------------------------------------------------------------------

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

769: l_proc varchar2(72) := g_package||'return_legislation_code';
770: --
771: begin
772: --
773: hr_utility.set_location('Entering:'|| l_proc, 10);
774: --
775: -- Ensure that all the mandatory parameter are not null
776: --
777: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

794: end if;
795: --
796: close csr_leg_code;
797: --
798: hr_utility.set_location(' Leaving:'|| l_proc, 20);
799: --
800: return l_legislation_code;
801: --
802: end return_legislation_code;