DBA Data[Home] [Help]

APPS.BEN_EHC_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_ehc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_HLTH_CVG_PRTE_id => p_ELIG_HLTH_CVG_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_HLTH_CVG_PRTE_id;
78: --
79: --

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

121: between pto.effective_start_date and pto.effective_end_date;
122: --
123: Begin
124: --
125: hr_utility.set_location('Entering:'||l_proc,5);
126: --
127: hr_api.mandatory_arg_error(p_api_name => l_proc,
128: p_argument => 'pl_typ_opt_typ_id',
129: p_argument_value => p_pl_typ_opt_typ_id);

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

159: close c1;
160: --
161: end if;
162: --
163: hr_utility.set_location('Leaving:'||l_proc,10);
164: --
165: End chk_pl_typ_opt_typ_id;
166: --
167: --

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

209: between oipl.effective_start_date and oipl.effective_end_date;
210: --
211: Begin
212: --
213: hr_utility.set_location('Entering:'||l_proc,5);
214: --
215: hr_api.mandatory_arg_error(p_api_name => l_proc,
216: p_argument => 'oipl_id',
217: p_argument_value => p_oipl_id);

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

247: close c1;
248: --
249: end if;
250: --
251: hr_utility.set_location('Leaving:'||l_proc,10);
252: --
253: End chk_oipl_id;
254: --
255: -- ----------------------------------------------------------------------------

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

287: l_api_updating boolean;
288: --
289: Begin
290: --
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: l_api_updating := ben_ehc_shd.api_updating
294: (p_ELIG_HLTH_CVG_PRTE_id => p_ELIG_HLTH_CVG_PRTE_id,
295: p_effective_date => p_effective_date,

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

316: end if;
317: --
318: end if;
319: --
320: hr_utility.set_location('Leaving:'||l_proc,10);
321: --
322: end chk_excld_flag;
323: --
324: -- ---------------------------------------------------------------------------

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

364: and ordr_num = p_ordr_num
365: and business_group_id = p_business_group_id;
366: --
367: Begin
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: open c1;
371: fetch c1 into l_dummy;
372: if c1%found then

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

375: fnd_message.raise_error;
376: end if;
377: close c1;
378: --
379: hr_utility.set_location('Leaving:'||l_proc, 15);
380: End chk_duplicate_ordr_num;
381: --
382: -- ----------------------------------------------------------------------------
383: -- |--------------------------< dt_update_validate >--------------------------|

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

419: l_integrity_error Exception;
420: l_table_name all_tables.table_name%TYPE;
421: --
422: Begin
423: hr_utility.set_location('Entering:'||l_proc, 5);
424: --
425: -- Ensure that the p_datetrack_mode argument is not null
426: --
427: hr_api.mandatory_arg_error

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

458: End If;
459: --
460: End If;
461: --
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: Exception
464: When l_integrity_error Then
465: --
466: -- A referential integrity check was violated therefore

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

523: l_rows_exist Exception;
524: l_table_name all_tables.table_name%TYPE;
525: --
526: Begin
527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: -- Ensure that the p_datetrack_mode argument is not null
530: --
531: hr_api.mandatory_arg_error

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

560: --
561: --
562: End If;
563: --
564: hr_utility.set_location(' Leaving:'||l_proc, 10);
565: Exception
566: When l_rows_exist Then
567: --
568: -- A referential integrity check was violated therefore

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

592: --
593: l_proc varchar2(72) := g_package||'insert_validate';
594: --
595: Begin
596: hr_utility.set_location('Entering:'||l_proc, 5);
597: --
598: -- Call all supporting business operations
599: --
600: chk_ELIG_HLTH_CVG_PRTE_id

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

629: p_business_group_id => p_rec.business_group_id);
630: --
631: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
632: --
633: hr_utility.set_location(' Leaving:'||l_proc, 10);
634: End insert_validate;
635: --
636: -- ----------------------------------------------------------------------------
637: -- |---------------------------< update_validate >----------------------------|

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

645: --
646: l_proc varchar2(72) := g_package||'update_validate';
647: --
648: Begin
649: hr_utility.set_location('Entering:'||l_proc, 5);
650: --
651: -- Call all supporting business operations
652: --
653: chk_ELIG_HLTH_CVG_PRTE_id

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

691: p_datetrack_mode => p_datetrack_mode,
692: p_validation_start_date => p_validation_start_date,
693: p_validation_end_date => p_validation_end_date);
694: --
695: hr_utility.set_location(' Leaving:'||l_proc, 10);
696: End update_validate;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< delete_validate >----------------------------|

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

707: --
708: l_proc varchar2(72) := g_package||'delete_validate';
709: --
710: Begin
711: hr_utility.set_location('Entering:'||l_proc, 5);
712: --
713: -- Call all supporting business operations
714: --
715: dt_delete_validate

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

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

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

744: l_proc varchar2(72) := g_package||'return_legislation_code';
745: --
746: begin
747: --
748: hr_utility.set_location('Entering:'|| l_proc, 10);
749: --
750: -- Ensure that all the mandatory parameter are not null
751: --
752: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

769: end if;
770: --
771: close csr_leg_code;
772: --
773: hr_utility.set_location(' Leaving:'|| l_proc, 20);
774: --
775: return l_legislation_code;
776: --
777: end return_legislation_code;