42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_egr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_grd_prte_id => p_elig_grd_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_grd_prte_id;
78: --
79: -- ----------------------------------------------------------------------------
137: ;
138: --
139: Begin
140: --
141: hr_utility.set_location('Entering:'||l_proc,5);
142: --
143: l_api_updating := ben_egr_shd.api_updating
144: (p_elig_grd_prte_id => p_elig_grd_prte_id,
145: p_effective_date => p_effective_date,
169: close c1;
170: --
171: end if;
172: --
173: hr_utility.set_location('Leaving:'||l_proc,10);
174: --
175: End chk_grade_id;
176: --
177: -- ----------------------------------------------------------------------------
209: l_api_updating boolean;
210: --
211: Begin
212: --
213: hr_utility.set_location('Entering:'||l_proc, 5);
214: --
215: l_api_updating := ben_egr_shd.api_updating
216: (p_elig_grd_prte_id => p_elig_grd_prte_id,
217: p_effective_date => p_effective_date,
238: end if;
239: --
240: end if;
241: --
242: hr_utility.set_location('Leaving:'||l_proc,10);
243: --
244: end chk_excld_flag;
245: --
246: --Bug:5054189
287: and ordr_num = p_ordr_num
288: and business_group_id = p_business_group_id;
289: --
290: Begin
291: hr_utility.set_location('Entering:'||l_proc, 5);
292: --
293: open c1;
294: fetch c1 into l_dummy;
295: if c1%found then
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 15);
303: End chk_duplicate_ordr_num;
304: -- ----------------------------------------------------------------------------
305: -- |--------------------------< dt_update_validate >--------------------------|
306: -- ----------------------------------------------------------------------------
340: l_integrity_error Exception;
341: l_table_name all_tables.table_name%TYPE;
342: --
343: Begin
344: hr_utility.set_location('Entering:'||l_proc, 5);
345: --
346: -- Ensure that the p_datetrack_mode argument is not null
347: --
348: 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_eligy_prfl_id => p_rec.eligy_prfl_id
550: ,p_ordr_num => p_rec.ordr_num
551: ,p_business_group_id => p_rec.business_group_id);
552: --
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: --
607: p_datetrack_mode => p_datetrack_mode,
608: p_validation_start_date => p_validation_start_date,
609: p_validation_end_date => p_validation_end_date);
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End update_validate;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< delete_validate >----------------------------|
623: --
624: l_proc varchar2(72) := g_package||'delete_validate';
625: --
626: Begin
627: hr_utility.set_location('Entering:'||l_proc, 5);
628: --
629: -- Call all supporting business operations
630: --
631: dt_delete_validate
633: p_validation_start_date => p_validation_start_date,
634: p_validation_end_date => p_validation_end_date,
635: p_elig_grd_prte_id => p_rec.elig_grd_prte_id);
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 10);
638: End delete_validate;
639: --
640: --
641: -- ---------------------------------------------------------------------------
660: l_proc varchar2(72) := g_package||'return_legislation_code';
661: --
662: begin
663: --
664: hr_utility.set_location('Entering:'|| l_proc, 10);
665: --
666: -- Ensure that all the mandatory parameter are not null
667: --
668: hr_api.mandatory_arg_error(p_api_name => l_proc,
685: end if;
686: --
687: close csr_leg_code;
688: --
689: hr_utility.set_location(' Leaving:'|| l_proc, 20);
690: --
691: return l_legislation_code;
692: --
693: end return_legislation_code;