42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_dop_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_cvrd_othr_pgm_rt_id => p_dpnt_cvrd_othr_pgm_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_dpnt_cvrd_othr_pgm_rt_id;
78: --
79: -- ----------------------------------------------------------------------------
111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_dop_shd.api_updating
118: (p_dpnt_cvrd_othr_pgm_rt_id => p_dpnt_cvrd_othr_pgm_rt_id,
119: p_effective_date => p_effective_date,
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: -- ----------------------------------------------------------------------------
182: l_api_updating boolean;
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_dop_shd.api_updating
189: (p_dpnt_cvrd_othr_pgm_rt_id => p_dpnt_cvrd_othr_pgm_rt_id,
190: p_effective_date => p_effective_date,
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: -- |------< chk_dup_record >------|
275: and p_validation_end_date >= effective_start_date;
276: --
277: BEGIN
278: --
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: l_api_updating := ben_dop_shd.api_updating
282: (p_dpnt_cvrd_othr_pgm_rt_id => p_dpnt_cvrd_othr_pgm_rt_id,
283: p_effective_date => p_effective_date,
303: end if;
304: close c_dup;
305: --
306: end if;
307: hr_utility.set_location('Leaving:'||l_proc,10);
308: --
309: END chk_dup_record;
310:
311: --
344: l_api_updating boolean;
345: --
346: Begin
347: --
348: hr_utility.set_location('Entering:'||l_proc, 5);
349: --
350: l_api_updating := ben_dop_shd.api_updating
351: (p_dpnt_cvrd_othr_pgm_rt_id => p_dpnt_cvrd_othr_pgm_rt_id,
352: p_effective_date => p_effective_date,
375: end if;
376: --
377: end if;
378: --
379: hr_utility.set_location('Leaving:'||l_proc,10);
380: --
381: end chk_excld_flag;
382: --
383: --
433: and business_group_id + 0 = p_business_group_id
434: and ordr_num = p_ordr_num;
435: --
436: Begin
437: hr_utility.set_location('Entering:'||l_proc, 5);
438:
439: --
440: open c1;
441: fetch c1 into l_dummy;
445: fnd_message.raise_error;
446: end if;
447: close c1;
448: --
449: hr_utility.set_location('Leaving:'||l_proc, 15);
450: End chk_duplicate_ordr_num;
451:
452:
453:
492: l_integrity_error Exception;
493: l_table_name all_tables.table_name%TYPE;
494: --
495: Begin
496: hr_utility.set_location('Entering:'||l_proc, 5);
497: --
498: -- Ensure that the p_datetrack_mode argument is not null
499: --
500: hr_api.mandatory_arg_error
541: End If;
542: --
543: End If;
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);
546: Exception
547: When l_integrity_error Then
548: --
549: -- A referential integrity check was violated therefore
607: l_rows_exist Exception;
608: l_table_name all_tables.table_name%TYPE;
609: --
610: Begin
611: hr_utility.set_location('Entering:'||l_proc, 5);
612: --
613: -- Ensure that the p_datetrack_mode argument is not null
614: --
615: hr_api.mandatory_arg_error
644: --
645: --
646: End If;
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649: Exception
650: When l_rows_exist Then
651: --
652: -- A referential integrity check was violated therefore
678: --
679: l_proc varchar2(72) := g_package||'insert_validate';
680: --
681: Begin
682: hr_utility.set_location('Entering:'||l_proc, 5);
683: --
684: -- Call all supporting business operations
685: --
686: --
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 >----------------------------|
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: --
805: p_datetrack_mode => p_datetrack_mode,
806: p_validation_start_date => p_validation_start_date,
807: p_validation_end_date => p_validation_end_date);
808: --
809: hr_utility.set_location(' Leaving:'||l_proc, 10);
810: End update_validate;
811: --
812: -- ----------------------------------------------------------------------------
813: -- |---------------------------< delete_validate >----------------------------|
821: --
822: l_proc varchar2(72) := g_package||'delete_validate';
823: --
824: Begin
825: hr_utility.set_location('Entering:'||l_proc, 5);
826: --
827: -- Call all supporting business operations
828: --
829: dt_delete_validate
831: p_validation_start_date => p_validation_start_date,
832: p_validation_end_date => p_validation_end_date,
833: p_dpnt_cvrd_othr_pgm_rt_id => p_rec.dpnt_cvrd_othr_pgm_rt_id);
834: --
835: hr_utility.set_location(' Leaving:'||l_proc, 10);
836: End delete_validate;
837: --
838: --
839: -- ---------------------------------------------------------------------------
858: l_proc varchar2(72) := g_package||'return_legislation_code';
859: --
860: begin
861: --
862: hr_utility.set_location('Entering:'|| l_proc, 10);
863: --
864: -- Ensure that all the mandatory parameter are not null
865: --
866: hr_api.mandatory_arg_error(p_api_name => l_proc,
883: end if;
884: --
885: close csr_leg_code;
886: --
887: hr_utility.set_location(' Leaving:'|| l_proc, 20);
888: --
889: return l_legislation_code;
890: --
891: end return_legislation_code;