[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_abc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_acty_base_rt_ctfn_id => p_acty_base_rt_ctfn_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_acty_base_rt_ctfn_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_abc_shd.api_updating
118: (p_acty_base_rt_ctfn_id => p_acty_base_rt_ctfn_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_enrt_ctfn_typ_cd;
149: --
150: -- ----------------------------------------------------------------------------
197: or (p_validation_end_date between
198: effective_start_date and effective_end_date)) ;
199: --
200: Begin
201: hr_utility.set_location('Entering:'||l_proc, 5);
202: --
203: open c1;
204: fetch c1 into l_dummy;
205: if c1%found then
207: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
208: fnd_message.raise_error;
209: end if;
210: --
211: hr_utility.set_location('Leaving:'||l_proc, 15);
212: End chk_enrt_ctfn_typ_cd_unique;
213: --
214: -- ----------------------------------------------------------------------------
215: -- |------< chk_rqd_flag >------|
246: l_api_updating boolean;
247: --
248: Begin
249: --
250: hr_utility.set_location('Entering:'||l_proc, 5);
251: --
252: l_api_updating := ben_abc_shd.api_updating
253: (p_acty_base_rt_ctfn_id => p_acty_base_rt_ctfn_id,
254: p_effective_date => p_effective_date,
277: end if;
278: --
279: end if;
280: --
281: hr_utility.set_location('Leaving:'||l_proc,10);
282: --
283: end chk_rqd_flag;
284: --
285: -- ----------------------------------------------------------------------------
318: l_api_updating boolean;
319: --
320: Begin
321: --
322: hr_utility.set_location('Entering:'||l_proc, 5);
323: --
324: l_api_updating := ben_abc_shd.api_updating
325: (p_acty_base_rt_ctfn_id => p_acty_base_rt_ctfn_id,
326: p_effective_date => p_effective_date,
350: end if;
351: --
352: end if;
353: --
354: hr_utility.set_location('Leaving:'||l_proc,10);
355: --
356: end chk_ctfn_rqd_when_rl;
357: --
358: -- ----------------------------------------------------------------------------
394: l_integrity_error Exception;
395: l_table_name all_tables.table_name%TYPE;
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Ensure that the p_datetrack_mode argument is not null
401: --
402: hr_api.mandatory_arg_error
433: End If;
434: --
435: End If;
436: --
437: hr_utility.set_location(' Leaving:'||l_proc, 10);
438: Exception
439: When l_integrity_error Then
440: --
441: -- A referential integrity check was violated therefore
500: l_rows_exist Exception;
501: l_table_name all_tables.table_name%TYPE;
502: --
503: Begin
504: hr_utility.set_location('Entering:'||l_proc, 5);
505: --
506: -- Ensure that the p_datetrack_mode argument is not null
507: --
508: hr_api.mandatory_arg_error
537: --
538: --
539: End If;
540: --
541: hr_utility.set_location(' Leaving:'||l_proc, 10);
542: Exception
543: When l_rows_exist Then
544: --
545: -- A referential integrity check was violated therefore
571: --
572: l_proc varchar2(72) := g_package||'insert_validate';
573: --
574: Begin
575: hr_utility.set_location('Entering:'||l_proc, 5);
576: --
577: -- Call all supporting business operations
578: --
579: --
610: p_business_group_id => p_rec.business_group_id,
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: --
673: p_datetrack_mode => p_datetrack_mode,
674: p_validation_start_date => p_validation_start_date,
675: p_validation_end_date => p_validation_end_date);
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: End update_validate;
679: --
680: -- ----------------------------------------------------------------------------
681: -- |---------------------------< delete_validate >----------------------------|
689: --
690: l_proc varchar2(72) := g_package||'delete_validate';
691: --
692: Begin
693: hr_utility.set_location('Entering:'||l_proc, 5);
694: --
695: -- Call all supporting business operations
696: --
697: dt_delete_validate
699: p_validation_start_date => p_validation_start_date,
700: p_validation_end_date => p_validation_end_date,
701: p_acty_base_rt_ctfn_id => p_rec.acty_base_rt_ctfn_id);
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 10);
704: End delete_validate;
705: --
706: --
707: -- ---------------------------------------------------------------------------
726: l_proc varchar2(72) := g_package||'return_legislation_code';
727: --
728: begin
729: --
730: hr_utility.set_location('Entering:'|| l_proc, 10);
731: --
732: -- Ensure that all the mandatory parameter are not null
733: --
734: hr_api.mandatory_arg_error(p_api_name => l_proc,
751: end if;
752: --
753: close csr_leg_code;
754: --
755: hr_utility.set_location(' Leaving:'|| l_proc, 20);
756: --
757: return l_legislation_code;
758: --
759: end return_legislation_code;