[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_esa_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_svc_area_prte_id => p_elig_svc_area_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_svc_area_prte_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_esa_shd.api_updating
118: (p_elig_svc_area_prte_id => p_elig_svc_area_prte_id,
119: p_effective_date => p_effective_date,
140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_excld_flag;
147: --
148: --
198: or (esa.effective_start_date > p_effective_date)) ;
199: --
200: Begin
201: --
202: hr_utility.set_location('Entering:'||l_proc, 5);
203: --
204: l_api_updating := ben_esa_shd.api_updating
205: (p_elig_svc_area_prte_id => p_elig_svc_area_prte_id,
206: p_effective_date => p_effective_date,
212: fetch c_elig_svc_area_prte into l_dummy;
213: if c_elig_svc_area_prte%found then
214: --
215: close c_elig_svc_area_prte;
216: hr_utility.set_location(l_proc, 7);
217: --
218: -- raise error as duplicate criteria has been entered
219: --
220: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
223: end if;
224: --
225: close c_elig_svc_area_prte;
226: --
227: hr_utility.set_location('Leaving:'||l_proc,10);
228: --
229: end chk_dup_elig_criteria;
230: --
231: -- ---------------------------------------------------------------------------
274: and ((p_effective_date between esa.effective_start_date and esa.effective_end_date)
275: or (esa.effective_start_date > p_effective_date)) ;
276: --
277: Begin
278: hr_utility.set_location('Entering:'||l_proc, 5);
279: --
280: open c1;
281: fetch c1 into l_dummy;
282: if c1%found then
285: fnd_message.raise_error;
286: end if;
287: close c1;
288: --
289: hr_utility.set_location('Leaving:'||l_proc, 15);
290: End chk_duplicate_ordr_num;
291: --
292: --End Bug 4449556
293: -- ----------------------------------------------------------------------------
330: l_integrity_error Exception;
331: l_table_name all_tables.table_name%TYPE;
332: --
333: Begin
334: hr_utility.set_location('Entering:'||l_proc, 5);
335: --
336: -- Ensure that the p_datetrack_mode argument is not null
337: --
338: hr_api.mandatory_arg_error
379: End If;
380: --
381: End If;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: Exception
385: When l_integrity_error Then
386: --
387: -- A referential integrity check was violated therefore
445: l_rows_exist Exception;
446: l_table_name all_tables.table_name%TYPE;
447: --
448: Begin
449: hr_utility.set_location('Entering:'||l_proc, 5);
450: --
451: -- Ensure that the p_datetrack_mode argument is not null
452: --
453: hr_api.mandatory_arg_error
482: --
483: --
484: End If;
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: Exception
488: When l_rows_exist Then
489: --
490: -- A referential integrity check was violated therefore
515: --
516: l_proc varchar2(72) := g_package||'insert_validate';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520: --
521: -- Call all supporting business operations
522: --
523: --
549: p_effective_date => p_effective_date,
550: p_object_version_number => p_rec.object_version_number,
551: p_business_group_id => p_rec.business_group_id);
552: -- End Bug 4449556
553: hr_utility.set_location(' Leaving:'||l_proc, 10);
554: End insert_validate;
555: --
556: -- ----------------------------------------------------------------------------
557: -- |---------------------------< update_validate >----------------------------|
565: --
566: l_proc varchar2(72) := g_package||'update_validate';
567: --
568: Begin
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: -- Call all supporting business operations
572: --
573: --
610:
611: --End Bug 4449556
612:
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End update_validate;
616: --
617: -- ----------------------------------------------------------------------------
618: -- |---------------------------< delete_validate >----------------------------|
626: --
627: l_proc varchar2(72) := g_package||'delete_validate';
628: --
629: Begin
630: hr_utility.set_location('Entering:'||l_proc, 5);
631: --
632: -- Call all supporting business operations
633: --
634: dt_delete_validate
636: p_validation_start_date => p_validation_start_date,
637: p_validation_end_date => p_validation_end_date,
638: p_elig_svc_area_prte_id => p_rec.elig_svc_area_prte_id);
639: --
640: hr_utility.set_location(' Leaving:'||l_proc, 10);
641: End delete_validate;
642: --
643: --
644: -- ---------------------------------------------------------------------------
663: l_proc varchar2(72) := g_package||'return_legislation_code';
664: --
665: begin
666: --
667: hr_utility.set_location('Entering:'|| l_proc, 10);
668: --
669: -- Ensure that all the mandatory parameter are not null
670: --
671: hr_api.mandatory_arg_error(p_api_name => l_proc,
688: end if;
689: --
690: close csr_leg_code;
691: --
692: hr_utility.set_location(' Leaving:'|| l_proc, 20);
693: --
694: return l_legislation_code;
695: --
696: end return_legislation_code;