[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_lnc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_enrt_ctfn_id => p_ler_enrt_ctfn_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ler_enrt_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_lnc_shd.api_updating
119: (p_ler_enrt_ctfn_id => p_ler_enrt_ctfn_id,
120: p_effective_date => p_effective_date,
144: end if;
145: --
146: end if;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: end chk_ctfn_rqd_when_rl;
151: --
152: -- ----------------------------------------------------------------------------
184: l_api_updating boolean;
185: --
186: Begin
187: --
188: hr_utility.set_location('Entering:'||l_proc, 5);
189: --
190: l_api_updating := ben_lnc_shd.api_updating
191: (p_ler_enrt_ctfn_id => p_ler_enrt_ctfn_id,
192: p_effective_date => p_effective_date,
214: end if;
215: --
216: end if;
217: --
218: hr_utility.set_location('Leaving:'||l_proc,10);
219: --
220: end chk_enrt_ctfn_typ_cd;
221: --
222: -- ----------------------------------------------------------------------------
269: or (p_validation_end_date between
270: effective_start_date and effective_end_date)) ;
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: open c1;
276: fetch c1 into l_dummy;
277: if c1%found then
279: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
280: fnd_message.raise_error;
281: end if;
282: --
283: hr_utility.set_location('Leaving:'||l_proc, 15);
284: End chk_enrt_ctfn_typ_cd_unique;
285: --
286: -- ----------------------------------------------------------------------------
287: -- |------< chk_rqd_flag >------|
318: l_api_updating boolean;
319: --
320: Begin
321: --
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: l_api_updating := ben_lnc_shd.api_updating
325: (p_ler_enrt_ctfn_id => p_ler_enrt_ctfn_id,
326: p_effective_date => p_effective_date,
349: end if;
350: --
351: end if;
352: --
353: hr_utility.set_location('Leaving:'||l_proc,10);
354: --
355: end chk_rqd_flag;
356: --
357: -- ----------------------------------------------------------------------------
393: l_integrity_error Exception;
394: l_table_name all_tables.table_name%TYPE;
395: --
396: Begin
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: -- Ensure that the p_datetrack_mode argument is not null
400: --
401: hr_api.mandatory_arg_error
432: End If;
433: --
434: End If;
435: --
436: hr_utility.set_location(' Leaving:'||l_proc, 10);
437: Exception
438: When l_integrity_error Then
439: --
440: -- A referential integrity check was violated therefore
499: l_rows_exist Exception;
500: l_table_name all_tables.table_name%TYPE;
501: --
502: Begin
503: hr_utility.set_location('Entering:'||l_proc, 5);
504: --
505: -- Ensure that the p_datetrack_mode argument is not null
506: --
507: hr_api.mandatory_arg_error
536: --
537: --
538: End If;
539: --
540: hr_utility.set_location(' Leaving:'||l_proc, 10);
541: Exception
542: When l_rows_exist Then
543: --
544: -- 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: --
609: p_rqd_flag => p_rec.rqd_flag,
610: p_effective_date => p_effective_date,
611: p_object_version_number => p_rec.object_version_number);
612: --
613: hr_utility.set_location(' Leaving:'||l_proc, 10);
614: End insert_validate;
615: --
616: -- ----------------------------------------------------------------------------
617: -- |---------------------------< update_validate >----------------------------|
625: --
626: l_proc varchar2(72) := g_package||'update_validate';
627: --
628: Begin
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: -- Call all supporting business operations
632: --
633: --
672: p_datetrack_mode => p_datetrack_mode,
673: p_validation_start_date => p_validation_start_date,
674: p_validation_end_date => p_validation_end_date);
675: --
676: hr_utility.set_location(' Leaving:'||l_proc, 10);
677: End update_validate;
678: --
679: -- ----------------------------------------------------------------------------
680: -- |---------------------------< delete_validate >----------------------------|
688: --
689: l_proc varchar2(72) := g_package||'delete_validate';
690: --
691: Begin
692: hr_utility.set_location('Entering:'||l_proc, 5);
693: --
694: -- Call all supporting business operations
695: --
696: dt_delete_validate
698: p_validation_start_date => p_validation_start_date,
699: p_validation_end_date => p_validation_end_date,
700: p_ler_enrt_ctfn_id => p_rec.ler_enrt_ctfn_id);
701: --
702: hr_utility.set_location(' Leaving:'||l_proc, 10);
703: End delete_validate;
704: --
705: --
706: -- ---------------------------------------------------------------------------
725: l_proc varchar2(72) := g_package||'return_legislation_code';
726: --
727: begin
728: --
729: hr_utility.set_location('Entering:'|| l_proc, 10);
730: --
731: -- Ensure that all the mandatory parameter are not null
732: --
733: hr_api.mandatory_arg_error(p_api_name => l_proc,
750: end if;
751: --
752: close csr_leg_code;
753: --
754: hr_utility.set_location(' Leaving:'|| l_proc, 20);
755: --
756: return l_legislation_code;
757: --
758: end return_legislation_code;