[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_enl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_enrld_anthr_pl_rt_id => p_enrld_anthr_pl_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_pl_rt_id;
78: --
79: -- ----------------------------------------------------------------------------
136: and p_validation_end_date >= enl.effective_start_date;
137: --
138: Begin
139: --
140: hr_utility.set_location('Entering:'||l_proc,5);
141: --
142: l_api_updating := ben_enl_shd.api_updating
143: (p_enrld_anthr_pl_rt_id => p_enrld_anthr_pl_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_pl_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_enl_shd.api_updating
230: (p_enrld_anthr_pl_rt_id => p_enrld_anthr_pl_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_enl_shd.api_updating
301: (p_enrld_anthr_pl_rt_id => p_enrld_anthr_pl_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_start_date => p_validation_start_date
670: ,p_validation_end_date => p_validation_end_date
671: ,p_business_group_id => p_rec.business_group_id);
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: --
738: p_datetrack_mode => p_datetrack_mode,
739: p_validation_start_date => p_validation_start_date,
740: p_validation_end_date => p_validation_end_date);
741: --
742: hr_utility.set_location(' Leaving:'||l_proc, 10);
743: End update_validate;
744: --
745: -- ----------------------------------------------------------------------------
746: -- |---------------------------< delete_validate >----------------------------|
754: --
755: l_proc varchar2(72) := g_package||'delete_validate';
756: --
757: Begin
758: hr_utility.set_location('Entering:'||l_proc, 5);
759: --
760: -- Call all supporting business operations
761: --
762: dt_delete_validate
764: p_validation_start_date => p_validation_start_date,
765: p_validation_end_date => p_validation_end_date,
766: p_enrld_anthr_pl_rt_id => p_rec.enrld_anthr_pl_rt_id);
767: --
768: hr_utility.set_location(' Leaving:'||l_proc, 10);
769: End delete_validate;
770: --
771: --
772: -- ---------------------------------------------------------------------------
791: l_proc varchar2(72) := g_package||'return_legislation_code';
792: --
793: begin
794: --
795: hr_utility.set_location('Entering:'|| l_proc, 10);
796: --
797: -- Ensure that all the mandatory parameter are not null
798: --
799: hr_api.mandatory_arg_error(p_api_name => l_proc,
816: end if;
817: --
818: close csr_leg_code;
819: --
820: hr_utility.set_location(' Leaving:'|| l_proc, 20);
821: --
822: return l_legislation_code;
823: --
824: end return_legislation_code;