DBA Data[Home] [Help]

APPS.BEN_EDP_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_edp_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_dpnt_cvrd_othr_pl_id => p_elig_dpnt_cvrd_othr_pl_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_pl_id;
78: --
79: --

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

137: and p_validation_end_date >= edp.effective_start_date;
138: --
139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc,5);
142: --
143: l_api_updating := ben_edp_shd.api_updating
144: (p_elig_dpnt_cvrd_othr_pl_id => p_elig_dpnt_cvrd_othr_pl_id,
145: p_effective_date => p_effective_date,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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