[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_epm_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_enrld_anthr_pgm_rt_id => p_enrld_anthr_pgm_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_pgm_rt_id;
78: --
79: -- ----------------------------------------------------------------------------
136: and p_validation_end_date >= epm.effective_start_date;
137: --
138: Begin
139: --
140: hr_utility.set_location('Entering:'||l_proc,5);
141: --
142: l_api_updating := ben_epm_shd.api_updating
143: (p_enrld_anthr_pgm_rt_id => p_enrld_anthr_pgm_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_pgm_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_epm_shd.api_updating
230: (p_enrld_anthr_pgm_rt_id => p_enrld_anthr_pgm_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_epm_shd.api_updating
301: (p_enrld_anthr_pgm_rt_id => p_enrld_anthr_pgm_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: --
381: and business_group_id + 0 = p_business_group_id
382: and ordr_num = p_ordr_num;
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386:
387: --
388: open c1;
389: fetch c1 into l_dummy;
393: fnd_message.raise_error;
394: end if;
395: close c1;
396: --
397: hr_utility.set_location('Leaving:'||l_proc, 15);
398: End chk_duplicate_ordr_num;
399: --
400:
401: -- ----------------------------------------------------------------------------
438: l_integrity_error Exception;
439: l_table_name all_tables.table_name%TYPE;
440: --
441: Begin
442: hr_utility.set_location('Entering:'||l_proc, 5);
443: --
444: -- Ensure that the p_datetrack_mode argument is not null
445: --
446: hr_api.mandatory_arg_error
487: End If;
488: --
489: End If;
490: --
491: hr_utility.set_location(' Leaving:'||l_proc, 10);
492: Exception
493: When l_integrity_error Then
494: --
495: -- A referential integrity check was violated therefore
552: l_rows_exist Exception;
553: l_table_name all_tables.table_name%TYPE;
554: --
555: Begin
556: hr_utility.set_location('Entering:'||l_proc, 5);
557: --
558: -- Ensure that the p_datetrack_mode argument is not null
559: --
560: hr_api.mandatory_arg_error
589: --
590: --
591: End If;
592: --
593: hr_utility.set_location(' Leaving:'||l_proc, 10);
594: Exception
595: When l_rows_exist Then
596: --
597: -- A referential integrity check was violated therefore
623: --
624: l_proc varchar2(72) := g_package||'insert_validate';
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Call all supporting business operations
630: --
631: --
667: ,p_validation_end_date => p_validation_end_date
668: ,p_business_group_id => p_rec.business_group_id);
669:
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 10);
672: End insert_validate;
673: --
674: -- ----------------------------------------------------------------------------
675: -- |---------------------------< update_validate >----------------------------|
683: --
684: l_proc varchar2(72) := g_package||'update_validate';
685: --
686: Begin
687: hr_utility.set_location('Entering:'||l_proc, 5);
688: --
689: -- Call all supporting business operations
690: --
691: --
736: p_datetrack_mode => p_datetrack_mode,
737: p_validation_start_date => p_validation_start_date,
738: p_validation_end_date => p_validation_end_date);
739: --
740: hr_utility.set_location(' Leaving:'||l_proc, 10);
741: End update_validate;
742: --
743: -- ----------------------------------------------------------------------------
744: -- |---------------------------< delete_validate >----------------------------|
752: --
753: l_proc varchar2(72) := g_package||'delete_validate';
754: --
755: Begin
756: hr_utility.set_location('Entering:'||l_proc, 5);
757: --
758: -- Call all supporting business operations
759: --
760: dt_delete_validate
762: p_validation_start_date => p_validation_start_date,
763: p_validation_end_date => p_validation_end_date,
764: p_enrld_anthr_pgm_rt_id => p_rec.enrld_anthr_pgm_rt_id);
765: --
766: hr_utility.set_location(' Leaving:'||l_proc, 10);
767: End delete_validate;
768: --
769: --
770: -- ---------------------------------------------------------------------------
789: l_proc varchar2(72) := g_package||'return_legislation_code';
790: --
791: begin
792: --
793: hr_utility.set_location('Entering:'|| l_proc, 10);
794: --
795: -- Ensure that all the mandatory parameter are not null
796: --
797: hr_api.mandatory_arg_error(p_api_name => l_proc,
814: end if;
815: --
816: close csr_leg_code;
817: --
818: hr_utility.set_location(' Leaving:'|| l_proc, 20);
819: --
820: return l_legislation_code;
821: --
822: end return_legislation_code;