[Home] [Help]
42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_eao_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_enrld_anthr_oipl_rt_id => p_enrld_anthr_oipl_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_enrld_anthr_oipl_rt_id;
78: --
79: -- ----------------------------------------------------------------------------
136: and p_validation_end_date >= eao.effective_start_date;
137: --
138: Begin
139: --
140: hr_utility.set_location('Entering:'||l_proc,5);
141: --
142: l_api_updating := ben_eao_shd.api_updating
143: (p_enrld_anthr_oipl_rt_id => p_enrld_anthr_oipl_rt_id,
144: p_effective_date => p_effective_date,
183: end if;
184: close c3;
185: --
186: --
187: hr_utility.set_location('Leaving:'||l_proc,10);
188: --
189: End chk_oipl_id;
190: --
191: -- ----------------------------------------------------------------------------
223: l_api_updating boolean;
224: --
225: Begin
226: --
227: hr_utility.set_location('Entering:'||l_proc, 5);
228: --
229: l_api_updating := ben_eao_shd.api_updating
230: (p_enrld_anthr_oipl_rt_id => p_enrld_anthr_oipl_rt_id,
231: p_effective_date => p_effective_date,
254: end if;
255: --
256: end if;
257: --
258: hr_utility.set_location('Leaving:'||l_proc,10);
259: --
260: end chk_enrl_det_dt_cd;
261: --
262: -- ----------------------------------------------------------------------------
294: l_api_updating boolean;
295: --
296: Begin
297: --
298: hr_utility.set_location('Entering:'||l_proc, 5);
299: --
300: l_api_updating := ben_eao_shd.api_updating
301: (p_enrld_anthr_oipl_rt_id => p_enrld_anthr_oipl_rt_id,
302: p_effective_date => p_effective_date,
325: end if;
326: --
327: end if;
328: --
329: hr_utility.set_location('Leaving:'||l_proc,10);
330: --
331: end chk_excld_flag;
332: --
333: --
383: and business_group_id + 0 = p_business_group_id
384: and ordr_num = p_ordr_num;
385: --
386: Begin
387: hr_utility.set_location('Entering:'||l_proc, 5);
388:
389: --
390: open c1;
391: fetch c1 into l_dummy;
395: fnd_message.raise_error;
396: end if;
397: close c1;
398: --
399: hr_utility.set_location('Leaving:'||l_proc, 15);
400: End chk_duplicate_ordr_num;
401:
402: --
403:
441: l_integrity_error Exception;
442: l_table_name all_tables.table_name%TYPE;
443: --
444: Begin
445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: -- Ensure that the p_datetrack_mode argument is not null
448: --
449: hr_api.mandatory_arg_error
490: End If;
491: --
492: End If;
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 10);
495: Exception
496: When l_integrity_error Then
497: --
498: -- A referential integrity check was violated therefore
555: l_rows_exist Exception;
556: l_table_name all_tables.table_name%TYPE;
557: --
558: Begin
559: hr_utility.set_location('Entering:'||l_proc, 5);
560: --
561: -- Ensure that the p_datetrack_mode argument is not null
562: --
563: hr_api.mandatory_arg_error
592: --
593: --
594: End If;
595: --
596: hr_utility.set_location(' Leaving:'||l_proc, 10);
597: Exception
598: When l_rows_exist Then
599: --
600: -- A referential integrity check was violated therefore
626: --
627: l_proc varchar2(72) := g_package||'insert_validate';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: -- Call all supporting business operations
633: --
634: --
669: ,p_validation_end_date => p_validation_end_date
670: ,p_business_group_id => p_rec.business_group_id);
671:
672: --
673: hr_utility.set_location(' Leaving:'||l_proc, 10);
674: End insert_validate;
675: --
676: -- ----------------------------------------------------------------------------
677: -- |---------------------------< update_validate >----------------------------|
685: --
686: l_proc varchar2(72) := g_package||'update_validate';
687: --
688: Begin
689: hr_utility.set_location('Entering:'||l_proc, 5);
690: --
691: -- Call all supporting business operations
692: --
693: --
737: p_datetrack_mode => p_datetrack_mode,
738: p_validation_start_date => p_validation_start_date,
739: p_validation_end_date => p_validation_end_date);
740: --
741: hr_utility.set_location(' Leaving:'||l_proc, 10);
742: End update_validate;
743: --
744: -- ----------------------------------------------------------------------------
745: -- |---------------------------< delete_validate >----------------------------|
753: --
754: l_proc varchar2(72) := g_package||'delete_validate';
755: --
756: Begin
757: hr_utility.set_location('Entering:'||l_proc, 5);
758: --
759: -- Call all supporting business operations
760: --
761: dt_delete_validate
763: p_validation_start_date => p_validation_start_date,
764: p_validation_end_date => p_validation_end_date,
765: p_enrld_anthr_oipl_rt_id => p_rec.enrld_anthr_oipl_rt_id);
766: --
767: hr_utility.set_location(' Leaving:'||l_proc, 10);
768: End delete_validate;
769: --
770: --
771: -- ---------------------------------------------------------------------------
790: l_proc varchar2(72) := g_package||'return_legislation_code';
791: --
792: begin
793: --
794: hr_utility.set_location('Entering:'|| l_proc, 10);
795: --
796: -- Ensure that all the mandatory parameter are not null
797: --
798: hr_api.mandatory_arg_error(p_api_name => l_proc,
815: end if;
816: --
817: close csr_leg_code;
818: --
819: hr_utility.set_location(' Leaving:'|| l_proc, 20);
820: --
821: return l_legislation_code;
822: --
823: end return_legislation_code;