42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_cpn_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cntng_prtn_prfl_rt_id => p_cntng_prtn_prfl_rt_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_cntng_prtn_prfl_rt_id;
78: --
79: /*
128: and ff.effective_end_date;
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_cpn_shd.api_updating
135: (p_cntng_prtn_prfl_rt_id => p_cntng_prtn_prfl_rt_id,
136: p_effective_date => p_effective_date,
164: close c1;
165: --
166: end if;
167: --
168: hr_utility.set_location('Leaving:'||l_proc,10);
169: --
170: end chk_cntng_frmr_prtt_dsge_rl;
171: --
172: -- ----------------------------------------------------------------------------
213: and ff.effective_end_date;
214: --
215: Begin
216: --
217: hr_utility.set_location('Entering:'||l_proc, 5);
218: --
219: l_api_updating := ben_cpn_shd.api_updating
220: (p_cntng_prtn_prfl_rt_id => p_cntng_prtn_prfl_rt_id,
221: p_effective_date => p_effective_date,
249: close c1;
250: --
251: end if;
252: --
253: hr_utility.set_location('Leaving:'||l_proc,10);
254: --
255: end chk_cntng_frmr_prtt_rl;
256: --
257: -- ----------------------------------------------------------------------------
289: l_api_updating boolean;
290: --
291: Begin
292: --
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: l_api_updating := ben_cpn_shd.api_updating
296: (p_cntng_prtn_prfl_rt_id => p_cntng_prtn_prfl_rt_id,
297: p_effective_date => p_effective_date,
318: end if;
319: --
320: end if;
321: --
322: hr_utility.set_location('Leaving:'||l_proc,10);
323: --
324: end chk_dsge_must_be_redsgd_flag;
325: --
326: */
376: and ff.effective_end_date;
377: --
378: Begin
379: --
380: hr_utility.set_location('Entering:'||l_proc, 5);
381: --
382: l_api_updating := ben_cpn_shd.api_updating
383: (p_cntng_prtn_prfl_rt_id => p_cntng_prtn_prfl_rt_id,
384: p_effective_date => p_effective_date,
414: close c1;
415: --
416: end if;
417: --
418: hr_utility.set_location('Leaving:'||l_proc,10);
419: --
420: end chk_pymt_must_be_rcvd_rl;
421: --
422: -- ----------------------------------------------------------------------------
455: l_api_updating boolean;
456: --
457: Begin
458: --
459: hr_utility.set_location('Entering:'||l_proc, 5);
460: --
461: l_api_updating := ben_cpn_shd.api_updating
462: (p_cntng_prtn_prfl_rt_id => p_cntng_prtn_prfl_rt_id,
463: p_effective_date => p_effective_date,
487: end if;
488: --
489: end if;
490: --
491: hr_utility.set_location('Leaving:'||l_proc,10);
492: --
493: end chk_pymt_must_be_rcvd_uom;
494: --
495: -- ----------------------------------------------------------------------------
535: l_api_updating boolean;
536: --
537: Begin
538: --
539: hr_utility.set_location('Entering:'||l_proc, 5);
540: --
541: l_api_updating := ben_cpn_shd.api_updating
542: (p_cntng_prtn_prfl_rt_id => p_cntng_prtn_prfl_rt_id,
543: p_effective_date => p_effective_date,
572: --
573: --
574: end if;
575: --
576: hr_utility.set_location('Leaving:'||l_proc,10);
577: --
578: end chk_pymt_must_be_rcvd_dep;
579: --
580: --
617: l_integrity_error Exception;
618: l_table_name all_tables.table_name%TYPE;
619: --
620: Begin
621: hr_utility.set_location('Entering:'||l_proc, 5);
622: --
623: -- Ensure that the p_datetrack_mode argument is not null
624: --
625: hr_api.mandatory_arg_error
656: End If;
657: --
658: End If;
659: --
660: hr_utility.set_location(' Leaving:'||l_proc, 10);
661: Exception
662: When l_integrity_error Then
663: --
664: -- A referential integrity check was violated therefore
722: l_rows_exist Exception;
723: l_table_name all_tables.table_name%TYPE;
724: --
725: Begin
726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- Ensure that the p_datetrack_mode argument is not null
729: --
730: hr_api.mandatory_arg_error
769: */
770: --
771: End If;
772: --
773: hr_utility.set_location(' Leaving:'||l_proc, 10);
774: Exception
775: When l_rows_exist Then
776: --
777: -- A referential integrity check was violated therefore
802: --
803: l_proc varchar2(72) := g_package||'insert_validate';
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 5);
807: --
808: -- Call all supporting business operations
809: --
810: --
855: p_business_group_id => p_rec.business_group_id,
856: p_effective_date => p_effective_date,
857: p_object_version_number => p_rec.object_version_number);
858: --
859: hr_utility.set_location(' Leaving:'||l_proc, 10);
860: End insert_validate;
861: --
862: -- ----------------------------------------------------------------------------
863: -- |---------------------------< update_validate >----------------------------|
871: --
872: l_proc varchar2(72) := g_package||'update_validate';
873: --
874: Begin
875: hr_utility.set_location('Entering:'||l_proc, 5);
876: --
877: -- Call all supporting business operations
878: --
879: --
934: p_datetrack_mode => p_datetrack_mode,
935: p_validation_start_date => p_validation_start_date,
936: p_validation_end_date => p_validation_end_date);
937: --
938: hr_utility.set_location(' Leaving:'||l_proc, 10);
939: End update_validate;
940: --
941: -- ----------------------------------------------------------------------------
942: -- |---------------------------< delete_validate >----------------------------|
950: --
951: l_proc varchar2(72) := g_package||'delete_validate';
952: --
953: Begin
954: hr_utility.set_location('Entering:'||l_proc, 5);
955: --
956: -- Call all supporting business operations
957: --
958: dt_delete_validate
960: p_validation_start_date => p_validation_start_date,
961: p_validation_end_date => p_validation_end_date,
962: p_cntng_prtn_prfl_rt_id => p_rec.cntng_prtn_prfl_rt_id);
963: --
964: hr_utility.set_location(' Leaving:'||l_proc, 10);
965: End delete_validate;
966: --
967: --
968: -- ---------------------------------------------------------------------------
987: l_proc varchar2(72) := g_package||'return_legislation_code';
988: --
989: begin
990: --
991: hr_utility.set_location('Entering:'|| l_proc, 10);
992: --
993: -- Ensure that all the mandatory parameter are not null
994: --
995: hr_api.mandatory_arg_error(p_api_name => l_proc,
1012: end if;
1013: --
1014: close csr_leg_code;
1015: --
1016: hr_utility.set_location(' Leaving:'|| l_proc, 20);
1017: --
1018: return l_legislation_code;
1019: --
1020: end return_legislation_code;