[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_lcc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_chg_dpnt_cvg_ctfn_id => p_ler_chg_dpnt_cvg_ctfn_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ler_chg_dpnt_cvg_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------
112: l_api_updating boolean;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_lcc_shd.api_updating
119: (p_ler_chg_dpnt_cvg_ctfn_id => p_ler_chg_dpnt_cvg_ctfn_id,
120: 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_dpnt_cvg_ctfn_typ_cd;
149: --
150: -- ----------------------------------------------------------------------------
199: or (p_validation_end_date between
200: effective_start_date and effective_end_date)) ;
201: --
202: Begin
203: hr_utility.set_location('Entering:'||l_proc, 5);
204: --
205: open c1;
206: fetch c1 into l_dummy;
207: if c1%found then
209: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
210: fnd_message.raise_error;
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc, 15);
214: --
215: End chk_dpnt_cvg_ctfn_typ_unique;
216: --
217: -- ----------------------------------------------------------------------------
249: l_api_updating boolean;
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_lcc_shd.api_updating
256: (p_ler_chg_dpnt_cvg_ctfn_id => p_ler_chg_dpnt_cvg_ctfn_id,
257: p_effective_date => p_effective_date,
279: end if;
280: --
281: end if;
282: --
283: hr_utility.set_location('Leaving:'||l_proc,10);
284: --
285: end chk_rlshp_typ_cd;
286: --
287: -- ----------------------------------------------------------------------------
321: --
322: --
323: Begin
324: --
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: l_api_updating := ben_lcc_shd.api_updating
328: (p_ler_chg_dpnt_cvg_ctfn_id => p_ler_chg_dpnt_cvg_ctfn_id,
329: p_effective_date => p_effective_date,
353: end if;
354: --
355: end if;
356: --
357: hr_utility.set_location('Leaving:'||l_proc,10);
358: --
359: end chk_ctfn_rqd_when_rl;
360: --
361: -- ----------------------------------------------------------------------------
397: l_integrity_error Exception;
398: l_table_name all_tables.table_name%TYPE;
399: --
400: Begin
401: hr_utility.set_location('Entering:'||l_proc, 5);
402: --
403: -- Ensure that the p_datetrack_mode argument is not null
404: --
405: hr_api.mandatory_arg_error
436: End If;
437: --
438: End If;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: Exception
442: When l_integrity_error Then
443: --
444: -- A referential integrity check was violated therefore
501: l_rows_exist Exception;
502: l_table_name all_tables.table_name%TYPE;
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Ensure that the p_datetrack_mode argument is not null
508: --
509: hr_api.mandatory_arg_error
538: --
539: --
540: End If;
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);
543: Exception
544: When l_rows_exist Then
545: --
546: -- A referential integrity check was violated therefore
570: --
571: l_proc varchar2(72) := g_package||'insert_validate';
572: --
573: Begin
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- Call all supporting business operations
577: --
578: --
610: p_ctfn_rqd_when_rl => p_rec.ctfn_rqd_when_rl,
611: p_effective_date => p_effective_date,
612: p_object_version_number => p_rec.object_version_number);
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End insert_validate;
616: --
617: -- ----------------------------------------------------------------------------
618: -- |---------------------------< update_validate >----------------------------|
626: --
627: l_proc varchar2(72) := g_package||'update_validate';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: -- Call all supporting business operations
633: --
634: --
674: p_datetrack_mode => p_datetrack_mode,
675: p_validation_start_date => p_validation_start_date,
676: p_validation_end_date => p_validation_end_date);
677: --
678: hr_utility.set_location(' Leaving:'||l_proc, 10);
679: End update_validate;
680: --
681: -- ----------------------------------------------------------------------------
682: -- |---------------------------< delete_validate >----------------------------|
690: --
691: l_proc varchar2(72) := g_package||'delete_validate';
692: --
693: Begin
694: hr_utility.set_location('Entering:'||l_proc, 5);
695: --
696: -- Call all supporting business operations
697: --
698: dt_delete_validate
700: p_validation_start_date => p_validation_start_date,
701: p_validation_end_date => p_validation_end_date,
702: p_ler_chg_dpnt_cvg_ctfn_id => p_rec.ler_chg_dpnt_cvg_ctfn_id);
703: --
704: hr_utility.set_location(' Leaving:'||l_proc, 10);
705: End delete_validate;
706: --
707: --
708: -- ---------------------------------------------------------------------------
727: l_proc varchar2(72) := g_package||'return_legislation_code';
728: --
729: begin
730: --
731: hr_utility.set_location('Entering:'|| l_proc, 10);
732: --
733: -- Ensure that all the mandatory parameter are not null
734: --
735: hr_api.mandatory_arg_error(p_api_name => l_proc,
752: end if;
753: --
754: close csr_leg_code;
755: --
756: hr_utility.set_location(' Leaving:'|| l_proc, 20);
757: --
758: return l_legislation_code;
759: --
760: end return_legislation_code;