[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_dcl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dpnt_cvrd_othr_pl_rt_id => p_dpnt_cvrd_othr_pl_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_pl_rt_id;
78: --
79: --
137: and p_validation_end_date >= dcl.effective_start_date;
138: --
139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc,5);
142: --
143: l_api_updating := ben_dcl_shd.api_updating
144: (p_dpnt_cvrd_othr_pl_rt_id => p_dpnt_cvrd_othr_pl_rt_id,
145: p_effective_date => p_effective_date,
184: end if;
185: close c3;
186: --
187: --
188: hr_utility.set_location('Leaving:'||l_proc,10);
189: --
190: End chk_pl_id;
191: --
192: -- ----------------------------------------------------------------------------
224: l_api_updating boolean;
225: --
226: Begin
227: --
228: hr_utility.set_location('Entering:'||l_proc, 5);
229: --
230: l_api_updating := ben_dcl_shd.api_updating
231: (p_dpnt_cvrd_othr_pl_rt_id => p_dpnt_cvrd_othr_pl_rt_id,
232: p_effective_date => p_effective_date,
255: end if;
256: --
257: end if;
258: --
259: hr_utility.set_location('Leaving:'||l_proc,10);
260: --
261: end chk_cvg_det_dt_cd;
262: --
263: -- ----------------------------------------------------------------------------
295: l_api_updating boolean;
296: --
297: Begin
298: --
299: hr_utility.set_location('Entering:'||l_proc, 5);
300: --
301: l_api_updating := ben_dcl_shd.api_updating
302: (p_dpnt_cvrd_othr_pl_rt_id => p_dpnt_cvrd_othr_pl_rt_id,
303: p_effective_date => p_effective_date,
326: end if;
327: --
328: end if;
329: --
330: hr_utility.set_location('Leaving:'||l_proc,10);
331: --
332: --
333: --
334: end chk_excld_flag;
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: -- |--------------------------< dt_update_validate >--------------------------|
439: l_integrity_error Exception;
440: l_table_name all_tables.table_name%TYPE;
441: --
442: Begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error
488: End If;
489: --
490: End If;
491: --
492: hr_utility.set_location(' Leaving:'||l_proc, 10);
493: Exception
494: When l_integrity_error Then
495: --
496: -- A referential integrity check was violated therefore
553: l_rows_exist Exception;
554: l_table_name all_tables.table_name%TYPE;
555: --
556: Begin
557: hr_utility.set_location('Entering:'||l_proc, 5);
558: --
559: -- Ensure that the p_datetrack_mode argument is not null
560: --
561: hr_api.mandatory_arg_error
590: --
591: --
592: End If;
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 10);
595: Exception
596: When l_rows_exist Then
597: --
598: -- A referential integrity check was violated therefore
624: --
625: l_proc varchar2(72) := g_package||'insert_validate';
626: --
627: Begin
628: hr_utility.set_location('Entering:'||l_proc, 5);
629: --
630: -- Call all supporting business operations
631: --
632: --
668: ,p_validation_end_date => p_validation_end_date
669: ,p_business_group_id => p_rec.business_group_id);
670:
671: --
672: hr_utility.set_location(' Leaving:'||l_proc, 10);
673: End insert_validate;
674: --
675: -- ----------------------------------------------------------------------------
676: -- |---------------------------< update_validate >----------------------------|
684: --
685: l_proc varchar2(72) := g_package||'update_validate';
686: --
687: Begin
688: hr_utility.set_location('Entering:'||l_proc, 5);
689: --
690: -- Call all supporting business operations
691: --
692: --
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_dpnt_cvrd_othr_pl_rt_id => p_rec.dpnt_cvrd_othr_pl_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;