DBA Data[Home] [Help]

APPS.BEN_DCO_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_dco_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_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_dpnt_cvrd_othr_ptip_rt_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_dco_shd.api_updating
118: (p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_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_only_pls_subj_cobra_flag;
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_dco_shd.api_updating
189: (p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_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_enrl_det_dt_cd;
220:
221: -- ----------------------------------------------------------------------------

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

278: and p_validation_end_date >= effective_start_date;
279: --
280: BEGIN
281: --
282: hr_utility.set_location('Entering:'||l_proc, 5);
283: --
284: l_api_updating := ben_dco_shd.api_updating
285: (p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_id,
286: p_effective_date => p_effective_date,

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

307: end if;
308: close c_dup;
309: --
310: end if;
311: hr_utility.set_location('Leaving:'||l_proc,10);
312: --
313: END chk_dup_record;
314: --
315: -- ----------------------------------------------------------------------------

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

347: l_api_updating boolean;
348: --
349: Begin
350: --
351: hr_utility.set_location('Entering:'||l_proc, 5);
352: --
353: l_api_updating := ben_dco_shd.api_updating
354: (p_dpnt_cvrd_othr_ptip_rt_id => p_dpnt_cvrd_othr_ptip_rt_id,
355: p_effective_date => p_effective_date,

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

378: end if;
379: --
380: end if;
381: --
382: hr_utility.set_location('Leaving:'||l_proc,10);
383: --
384: end chk_excld_flag;
385: --
386: --

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

435: and business_group_id + 0 = p_business_group_id
436: and ordr_num = p_ordr_num;
437: --
438: Begin
439: hr_utility.set_location('Entering:'||l_proc, 5);
440:
441: --
442: open c1;
443: fetch c1 into l_dummy;

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

447: fnd_message.raise_error;
448: end if;
449: close c1;
450: --
451: hr_utility.set_location('Leaving:'||l_proc, 15);
452: End chk_duplicate_ordr_num;
453:
454: -- ----------------------------------------------------------------------------
455: -- |--------------------------< dt_update_validate >--------------------------|

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

491: l_integrity_error Exception;
492: l_table_name all_tables.table_name%TYPE;
493: --
494: Begin
495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: -- Ensure that the p_datetrack_mode argument is not null
498: --
499: hr_api.mandatory_arg_error

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

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

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

606: l_rows_exist Exception;
607: l_table_name all_tables.table_name%TYPE;
608: --
609: Begin
610: hr_utility.set_location('Entering:'||l_proc, 5);
611: --
612: -- Ensure that the p_datetrack_mode argument is not null
613: --
614: hr_api.mandatory_arg_error

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

643: --
644: --
645: End If;
646: --
647: hr_utility.set_location(' Leaving:'||l_proc, 10);
648: Exception
649: When l_rows_exist Then
650: --
651: -- A referential integrity check was violated therefore

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

677: --
678: l_proc varchar2(72) := g_package||'insert_validate';
679: --
680: Begin
681: hr_utility.set_location('Entering:'||l_proc, 5);
682: --
683: -- Call all supporting business operations
684: --
685: --

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

729: ,p_validation_end_date => p_validation_end_date
730: ,p_business_group_id => p_rec.business_group_id);
731:
732: --
733: hr_utility.set_location(' Leaving:'||l_proc, 10);
734: End insert_validate;
735: --
736: -- ----------------------------------------------------------------------------
737: -- |---------------------------< update_validate >----------------------------|

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

745: --
746: l_proc varchar2(72) := g_package||'update_validate';
747: --
748: Begin
749: hr_utility.set_location('Entering:'||l_proc, 5);
750: --
751: -- Call all supporting business operations
752: --
753: --

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

806: ,p_validation_end_date => p_validation_end_date
807: ,p_business_group_id => p_rec.business_group_id);
808:
809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 10);
811: End update_validate;
812: --
813: -- ----------------------------------------------------------------------------
814: -- |---------------------------< delete_validate >----------------------------|

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

822: --
823: l_proc varchar2(72) := g_package||'delete_validate';
824: --
825: Begin
826: hr_utility.set_location('Entering:'||l_proc, 5);
827: --
828: -- Call all supporting business operations
829: --
830: dt_delete_validate

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

832: p_validation_start_date => p_validation_start_date,
833: p_validation_end_date => p_validation_end_date,
834: p_dpnt_cvrd_othr_ptip_rt_id => p_rec.dpnt_cvrd_othr_ptip_rt_id);
835: --
836: hr_utility.set_location(' Leaving:'||l_proc, 10);
837: End delete_validate;
838: --
839: --
840: -- ---------------------------------------------------------------------------

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

859: l_proc varchar2(72) := g_package||'return_legislation_code';
860: --
861: begin
862: --
863: hr_utility.set_location('Entering:'|| l_proc, 10);
864: --
865: -- Ensure that all the mandatory parameter are not null
866: --
867: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

884: end if;
885: --
886: close csr_leg_code;
887: --
888: hr_utility.set_location(' Leaving:'|| l_proc, 20);
889: --
890: return l_legislation_code;
891: --
892: end return_legislation_code;