DBA Data[Home] [Help]

APPS.BEN_EDG_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_edg_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_dpnt_cvrd_othr_pgm_id => p_elig_dpnt_cvrd_othr_pgm_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_dpnt_cvrd_othr_pgm_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_edg_shd.api_updating
118: (p_elig_dpnt_cvrd_othr_pgm_id => p_elig_dpnt_cvrd_othr_pgm_id,
119: p_effective_date => p_effective_date,

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

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

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

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

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_only_pls_subj_cobra_flag;
220: --
221: -- ----------------------------------------------------------------------------

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

253: l_api_updating boolean;
254: --
255: Begin
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := ben_edg_shd.api_updating
260: (p_elig_dpnt_cvrd_othr_pgm_id => p_elig_dpnt_cvrd_othr_pgm_id,
261: p_effective_date => p_effective_date,

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

284: end if;
285: --
286: end if;
287: --
288: hr_utility.set_location('Leaving:'||l_proc,10);
289: --
290: end chk_excld_flag;
291: --
292: --Bug:5054189

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

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

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

344: fnd_message.raise_error;
345: end if;
346: close c1;
347: --
348: hr_utility.set_location('Leaving:'||l_proc, 15);
349: End chk_duplicate_ordr_num;
350: -- ----------------------------------------------------------------------------
351: -- |--------------------------< dt_update_validate >--------------------------|
352: -- ----------------------------------------------------------------------------

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

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

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

436: End If;
437: --
438: End If;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: Exception
442: When l_integrity_error Then
443: --
444: -- A referential integrity check was violated therefore

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

502: l_rows_exist Exception;
503: l_table_name all_tables.table_name%TYPE;
504: --
505: Begin
506: hr_utility.set_location('Entering:'||l_proc, 5);
507: --
508: -- Ensure that the p_datetrack_mode argument is not null
509: --
510: hr_api.mandatory_arg_error

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

539: --
540: --
541: End If;
542: --
543: hr_utility.set_location(' Leaving:'||l_proc, 10);
544: Exception
545: When l_rows_exist Then
546: --
547: -- A referential integrity check was violated therefore

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

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

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

609: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
610: ,p_ordr_num => p_rec.ordr_num
611: ,p_business_group_id => p_rec.business_group_id);
612: --
613: hr_utility.set_location(' Leaving:'||l_proc, 10);
614: End insert_validate;
615: --
616: -- ----------------------------------------------------------------------------
617: -- |---------------------------< update_validate >----------------------------|

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

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

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

670: p_datetrack_mode => p_datetrack_mode,
671: p_validation_start_date => p_validation_start_date,
672: p_validation_end_date => p_validation_end_date);
673: --
674: hr_utility.set_location(' Leaving:'||l_proc, 10);
675: End update_validate;
676: --
677: -- ----------------------------------------------------------------------------
678: -- |---------------------------< delete_validate >----------------------------|

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

686: --
687: l_proc varchar2(72) := g_package||'delete_validate';
688: --
689: Begin
690: hr_utility.set_location('Entering:'||l_proc, 5);
691: --
692: -- Call all supporting business operations
693: --
694: dt_delete_validate

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

696: p_validation_start_date => p_validation_start_date,
697: p_validation_end_date => p_validation_end_date,
698: p_elig_dpnt_cvrd_othr_pgm_id => p_rec.elig_dpnt_cvrd_othr_pgm_id);
699: --
700: hr_utility.set_location(' Leaving:'||l_proc, 10);
701: End delete_validate;
702: --
703: --
704: -- ---------------------------------------------------------------------------

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

723: l_proc varchar2(72) := g_package||'return_legislation_code';
724: --
725: begin
726: --
727: hr_utility.set_location('Entering:'|| l_proc, 10);
728: --
729: -- Ensure that all the mandatory parameter are not null
730: --
731: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

748: end if;
749: --
750: close csr_leg_code;
751: --
752: hr_utility.set_location(' Leaving:'|| l_proc, 20);
753: --
754: return l_legislation_code;
755: --
756: end return_legislation_code;