42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_cer_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prtn_eligy_rl_id => p_prtn_eligy_rl_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_prtn_eligy_rl_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_cer_shd.api_updating
118: (p_prtn_eligy_rl_id => p_prtn_eligy_rl_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_mndtry_flag;
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_cer_shd.api_updating
189: (p_prtn_eligy_rl_id => p_prtn_eligy_rl_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_drvbl_fctr_apls_flag;
220: --
221: --
270: and ff.effective_end_date;
271: --
272: Begin
273: --
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: l_api_updating := ben_cer_shd.api_updating
277: (p_prtn_eligy_rl_id => p_prtn_eligy_rl_id,
278: p_effective_date => p_effective_date,
308: close c1;
309: --
310: end if;
311: --
312: hr_utility.set_location('Leaving:'||l_proc,10);
313: --
314: end chk_formula_id;
315: --
316: -- ----------------------------------------------------------------------------
359: and effective_end_date;
360: --
361: Begin
362: --
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: open c1;
366: fetch c1 into l_dummy;
367: if c1%found then
365: open c1;
366: fetch c1 into l_dummy;
367: if c1%found then
368: close c1;
369: hr_utility.set_message(801,'Duplicate sequence#');
370: hr_utility.raise_error;
371: end if;
372: close c1;
373: --
366: fetch c1 into l_dummy;
367: if c1%found then
368: close c1;
369: hr_utility.set_message(801,'Duplicate sequence#');
370: hr_utility.raise_error;
371: end if;
372: close c1;
373: --
374: hr_utility.set_location('Leaving:'||l_proc, 15);
370: hr_utility.raise_error;
371: end if;
372: close c1;
373: --
374: hr_utility.set_location('Leaving:'||l_proc, 15);
375: --
376: End chk_duplicate_ordr_num;
377: --
378: -- bug 3876692
437: and plip.effective_end_date;
438: --
439: Begin
440: --
441: hr_utility.set_location('Entering:'||l_proc,5);
442: --
443: open c1;
444: fetch c1 into l_exists;
445: if c1%found then
469: close c2;
470: --
471: end if;
472: --
473: hr_utility.set_location('Leaving:'||l_proc,10);
474: --
475: End chk_flx_impt_extnce;
476: --
477: --
514: l_integrity_error Exception;
515: l_table_name all_tables.table_name%TYPE;
516: --
517: Begin
518: hr_utility.set_location('Entering:'||l_proc, 5);
519: --
520: -- Ensure that the p_datetrack_mode argument is not null
521: --
522: hr_api.mandatory_arg_error
553: End If;
554: --
555: End If;
556: --
557: hr_utility.set_location(' Leaving:'||l_proc, 10);
558: Exception
559: When l_integrity_error Then
560: --
561: -- A referential integrity check was violated therefore
560: --
561: -- A referential integrity check was violated therefore
562: -- we must error
563: --
564: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
565: hr_utility.set_message_token('TABLE_NAME', l_table_name);
566: hr_utility.raise_error;
567: When Others Then
568: --
561: -- A referential integrity check was violated therefore
562: -- we must error
563: --
564: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
565: hr_utility.set_message_token('TABLE_NAME', l_table_name);
566: hr_utility.raise_error;
567: When Others Then
568: --
569: -- An unhandled or unexpected error has occurred which
562: -- we must error
563: --
564: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
565: hr_utility.set_message_token('TABLE_NAME', l_table_name);
566: hr_utility.raise_error;
567: When Others Then
568: --
569: -- An unhandled or unexpected error has occurred which
570: -- we must report
568: --
569: -- An unhandled or unexpected error has occurred which
570: -- we must report
571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;
569: -- An unhandled or unexpected error has occurred which
570: -- we must report
571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;
577: --
570: -- we must report
571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;
577: --
578: -- ----------------------------------------------------------------------------
571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;
577: --
578: -- ----------------------------------------------------------------------------
579: -- |--------------------------< dt_delete_validate >--------------------------|
620: l_rows_exist Exception;
621: l_table_name all_tables.table_name%TYPE;
622: --
623: Begin
624: hr_utility.set_location('Entering:'||l_proc, 5);
625: --
626: -- Ensure that the p_datetrack_mode argument is not null
627: --
628: hr_api.mandatory_arg_error
657: --
658: --
659: End If;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 10);
662: Exception
663: When l_rows_exist Then
664: --
665: -- A referential integrity check was violated therefore
664: --
665: -- A referential integrity check was violated therefore
666: -- we must error
667: --
668: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
669: hr_utility.set_message_token('TABLE_NAME', l_table_name);
670: hr_utility.raise_error;
671: When Others Then
672: --
665: -- A referential integrity check was violated therefore
666: -- we must error
667: --
668: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
669: hr_utility.set_message_token('TABLE_NAME', l_table_name);
670: hr_utility.raise_error;
671: When Others Then
672: --
673: -- An unhandled or unexpected error has occurred which
666: -- we must error
667: --
668: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
669: hr_utility.set_message_token('TABLE_NAME', l_table_name);
670: hr_utility.raise_error;
671: When Others Then
672: --
673: -- An unhandled or unexpected error has occurred which
674: -- we must report
672: --
673: -- An unhandled or unexpected error has occurred which
674: -- we must report
675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;
673: -- An unhandled or unexpected error has occurred which
674: -- we must report
675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;
681: --
674: -- we must report
675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;
681: --
682: -- ----------------------------------------------------------------------------
675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;
681: --
682: -- ----------------------------------------------------------------------------
683: -- |---------------------------< insert_validate >----------------------------|
691: --
692: l_proc varchar2(72) := g_package||'insert_validate';
693: --
694: Begin
695: hr_utility.set_location('Entering:'||l_proc, 5);
696: --
697: -- Call all supporting business operations
698: --
699: --
734: --
735: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
736: p_effective_date => p_effective_date);
737: --
738: hr_utility.set_location(' Leaving:'||l_proc, 10);
739: End insert_validate;
740: --
741: -- ----------------------------------------------------------------------------
742: -- |---------------------------< update_validate >----------------------------|
750: --
751: l_proc varchar2(72) := g_package||'update_validate';
752: --
753: Begin
754: hr_utility.set_location('Entering:'||l_proc, 5);
755: --
756: -- Call all supporting business operations
757: --
758: --
801: --
802: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
803: p_effective_date => p_effective_date);
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 10);
806: End update_validate;
807: --
808: -- ----------------------------------------------------------------------------
809: -- |---------------------------< delete_validate >----------------------------|
817: --
818: l_proc varchar2(72) := g_package||'delete_validate';
819: --
820: Begin
821: hr_utility.set_location('Entering:'||l_proc, 5);
822: --
823: -- Call all supporting business operations
824: --
825: dt_delete_validate
827: p_validation_start_date => p_validation_start_date,
828: p_validation_end_date => p_validation_end_date,
829: p_prtn_eligy_rl_id => p_rec.prtn_eligy_rl_id);
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: End delete_validate;
833: --
834: --
835: -- ---------------------------------------------------------------------------
854: l_proc varchar2(72) := g_package||'return_legislation_code';
855: --
856: begin
857: --
858: hr_utility.set_location('Entering:'|| l_proc, 10);
859: --
860: -- Ensure that all the mandatory parameter are not null
861: --
862: hr_api.mandatory_arg_error(p_api_name => l_proc,
872: close csr_leg_code;
873: --
874: -- The primary key is invalid therefore we must error
875: --
876: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
877: hr_utility.raise_error;
878: --
879: end if;
880: --
873: --
874: -- The primary key is invalid therefore we must error
875: --
876: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
877: hr_utility.raise_error;
878: --
879: end if;
880: --
881: close csr_leg_code;
879: end if;
880: --
881: close csr_leg_code;
882: --
883: hr_utility.set_location(' Leaving:'|| l_proc, 20);
884: --
885: return l_legislation_code;
886: --
887: end return_legislation_code;