[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_elr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_loa_rsn_prte_id => p_elig_loa_rsn_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_loa_rsn_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_elr_shd.api_updating
118: (p_elig_loa_rsn_prte_id => p_elig_loa_rsn_prte_id,
119: p_effective_date => p_effective_date,
143: end if;
144: --
145: end if;
146: --
147: hr_utility.set_location('Leaving:'||l_proc,10);
148: --
149: end chk_excld_flag;
150: --
151: -- ----------------------------------------------------------------------------
190: and abs.business_group_id = p_business_group_id;
191: --
192: Begin
193: --
194: hr_utility.set_location('Entering:'||l_proc,5);
195: --
196: l_api_updating := ben_elr_shd.api_updating
197: (p_elig_loa_rsn_prte_id => p_elig_loa_rsn_prte_id,
198: p_effective_date => p_effective_date,
224: close c1;
225: --
226: end if;
227: --
228: hr_utility.set_location('Leaving:'||l_proc,10);
229: --
230: End chk_absence_attendance_type_id;
231: --
232: -- ----------------------------------------------------------------------------
271: and abr.business_group_id = p_business_group_id;
272: --
273: Begin
274: --
275: hr_utility.set_location('Entering:'||l_proc,5);
276: --
277: l_api_updating := ben_elr_shd.api_updating
278: (p_elig_loa_rsn_prte_id => p_elig_loa_rsn_prte_id,
279: p_effective_date => p_effective_date,
305: close c1;
306: --
307: end if;
308: --
309: hr_utility.set_location('Leaving:'||l_proc,10);
310: --
311: End chk_abs_attendance_reason_id;
312: --
313: -- ----------------------------------------------------------------------------
364:
365: --
366: Begin
367: --
368: hr_utility.set_location('Entering:'||l_proc,5);
369: --
370: open c1;
371: --
372: fetch c1 into l_dummy;
381: --
382: end if;
383: close c1;
384: --
385: hr_utility.set_location('Leaving:'||l_proc,10);
386: --
387: End chk_dup_abs_criteria;
388: --
389:
431: and ordr_num = p_ordr_num
432: and business_group_id = p_business_group_id;
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: --
437: open c1;
438: fetch c1 into l_dummy;
439: if c1%found then
442: fnd_message.raise_error;
443: end if;
444: close c1;
445: --
446: hr_utility.set_location('Leaving:'||l_proc, 15);
447: End chk_duplicate_ordr_num;
448:
449: -- ----------------------------------------------------------------------------
450: -- |--------------------------< dt_update_validate >--------------------------|
485: l_integrity_error Exception;
486: l_table_name all_tables.table_name%TYPE;
487: --
488: Begin
489: hr_utility.set_location('Entering:'||l_proc, 5);
490: --
491: -- Ensure that the p_datetrack_mode argument is not null
492: --
493: hr_api.mandatory_arg_error
524: End If;
525: --
526: End If;
527: --
528: hr_utility.set_location(' Leaving:'||l_proc, 10);
529: Exception
530: When l_integrity_error Then
531: --
532: -- A referential integrity check was violated therefore
590: l_rows_exist Exception;
591: l_table_name all_tables.table_name%TYPE;
592: --
593: Begin
594: hr_utility.set_location('Entering:'||l_proc, 5);
595: --
596: -- Ensure that the p_datetrack_mode argument is not null
597: --
598: hr_api.mandatory_arg_error
627: --
628: --
629: End If;
630: --
631: hr_utility.set_location(' Leaving:'||l_proc, 10);
632: Exception
633: When l_rows_exist Then
634: --
635: -- A referential integrity check was violated therefore
661: --
662: l_proc varchar2(72) := g_package||'insert_validate';
663: --
664: Begin
665: hr_utility.set_location('Entering:'||l_proc, 5);
666: --
667: -- Call all supporting business operations
668: --
669: --
708: p_eligy_prfl_id => p_rec.eligy_prfl_id,
709: p_ordr_num => p_rec.ordr_num,
710: p_business_group_id => p_rec.business_group_id);
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 10);
713: End insert_validate;
714: --
715: -- ----------------------------------------------------------------------------
716: -- |---------------------------< update_validate >----------------------------|
724: --
725: l_proc varchar2(72) := g_package||'update_validate';
726: --
727: Begin
728: hr_utility.set_location('Entering:'||l_proc, 5);
729: --
730: -- Call all supporting business operations
731: --
732: --
780: p_datetrack_mode => p_datetrack_mode,
781: p_validation_start_date => p_validation_start_date,
782: p_validation_end_date => p_validation_end_date);
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 10);
785: End update_validate;
786: --
787: -- ----------------------------------------------------------------------------
788: -- |---------------------------< delete_validate >----------------------------|
796: --
797: l_proc varchar2(72) := g_package||'delete_validate';
798: --
799: Begin
800: hr_utility.set_location('Entering:'||l_proc, 5);
801: --
802: -- Call all supporting business operations
803: --
804: dt_delete_validate
806: p_validation_start_date => p_validation_start_date,
807: p_validation_end_date => p_validation_end_date,
808: p_elig_loa_rsn_prte_id => p_rec.elig_loa_rsn_prte_id);
809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 10);
811: End delete_validate;
812: --
813: --
814: -- ---------------------------------------------------------------------------
833: l_proc varchar2(72) := g_package||'return_legislation_code';
834: --
835: begin
836: --
837: hr_utility.set_location('Entering:'|| l_proc, 10);
838: --
839: -- Ensure that all the mandatory parameter are not null
840: --
841: hr_api.mandatory_arg_error(p_api_name => l_proc,
858: end if;
859: --
860: close csr_leg_code;
861: --
862: hr_utility.set_location(' Leaving:'|| l_proc, 20);
863: --
864: return l_legislation_code;
865: --
866: end return_legislation_code;