[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_ecf_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_enrt_ctfn_id => p_enrt_ctfn_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_enrt_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_ecf_shd.api_updating
118: (p_enrt_ctfn_id => p_enrt_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: -- ----------------------------------------------------------------------------
200: or (p_validation_end_date between
201: effective_start_date and effective_end_date)) ;
202: --
203: Begin
204: hr_utility.set_location('Entering:'||l_proc, 5);
205: --
206: open c1;
207: fetch c1 into l_dummy;
208: if c1%found then
210: fnd_message.set_name('BEN','BEN_92248_ENRT_TYP_UNIQUE');
211: fnd_message.raise_error;
212: end if;
213: --
214: hr_utility.set_location('Leaving:'||l_proc, 15);
215: End chk_enrt_ctfn_typ_cd_unique;
216: --
217: -- ----------------------------------------------------------------------------
218: -- |------< chk_rqd_flag >------|
249: l_api_updating boolean;
250: --
251: Begin
252: --
253: hr_utility.set_location('Entering:'||l_proc, 5);
254: --
255: l_api_updating := ben_ecf_shd.api_updating
256: (p_enrt_ctfn_id => p_enrt_ctfn_id,
257: p_effective_date => p_effective_date,
280: end if;
281: --
282: end if;
283: --
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: end chk_rqd_flag;
287: --
288: -- ----------------------------------------------------------------------------
321: l_api_updating boolean;
322: --
323: Begin
324: --
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: l_api_updating := ben_ecf_shd.api_updating
328: (p_enrt_ctfn_id => p_enrt_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: -- ----------------------------------------------------------------------------
398: l_integrity_error Exception;
399: l_table_name all_tables.table_name%TYPE;
400: --
401: Begin
402: hr_utility.set_location('Entering:'||l_proc, 5);
403: --
404: -- Ensure that the p_datetrack_mode argument is not null
405: --
406: hr_api.mandatory_arg_error
447: End If;
448: --
449: End If;
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: Exception
453: When l_integrity_error Then
454: --
455: -- A referential integrity check was violated therefore
514: l_rows_exist 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
551: --
552: --
553: End If;
554: --
555: hr_utility.set_location(' Leaving:'||l_proc, 10);
556: Exception
557: When l_rows_exist Then
558: --
559: -- A referential integrity check was violated therefore
585: --
586: l_proc varchar2(72) := g_package||'insert_validate';
587: --
588: Begin
589: hr_utility.set_location('Entering:'||l_proc, 5);
590: --
591: -- Call all supporting business operations
592: --
593: --
625: p_business_group_id => p_rec.business_group_id,
626: p_effective_date => p_effective_date,
627: p_object_version_number => p_rec.object_version_number);
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 10);
630: End insert_validate;
631: --
632: -- ----------------------------------------------------------------------------
633: -- |---------------------------< update_validate >----------------------------|
641: --
642: l_proc varchar2(72) := g_package||'update_validate';
643: --
644: Begin
645: hr_utility.set_location('Entering:'||l_proc, 5);
646: --
647: -- Call all supporting business operations
648: --
649: --
690: p_datetrack_mode => p_datetrack_mode,
691: p_validation_start_date => p_validation_start_date,
692: p_validation_end_date => p_validation_end_date);
693: --
694: hr_utility.set_location(' Leaving:'||l_proc, 10);
695: End update_validate;
696: --
697: -- ----------------------------------------------------------------------------
698: -- |---------------------------< delete_validate >----------------------------|
706: --
707: l_proc varchar2(72) := g_package||'delete_validate';
708: --
709: Begin
710: hr_utility.set_location('Entering:'||l_proc, 5);
711: --
712: -- Call all supporting business operations
713: --
714: dt_delete_validate
716: p_validation_start_date => p_validation_start_date,
717: p_validation_end_date => p_validation_end_date,
718: p_enrt_ctfn_id => p_rec.enrt_ctfn_id);
719: --
720: hr_utility.set_location(' Leaving:'||l_proc, 10);
721: End delete_validate;
722: --
723: --
724: -- ---------------------------------------------------------------------------
743: l_proc varchar2(72) := g_package||'return_legislation_code';
744: --
745: begin
746: --
747: hr_utility.set_location('Entering:'|| l_proc, 10);
748: --
749: -- Ensure that all the mandatory parameter are not null
750: --
751: hr_api.mandatory_arg_error(p_api_name => l_proc,
768: end if;
769: --
770: close csr_leg_code;
771: --
772: hr_utility.set_location(' Leaving:'|| l_proc, 20);
773: --
774: return l_legislation_code;
775: --
776: end return_legislation_code;