[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_egn_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ELIG_GNDR_PRTE_id => p_ELIG_GNDR_PRTE_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_ELIG_GNDR_PRTE_id;
78: --
79: -- ----------------------------------------------------------------------------
119: and egn.ELIG_GNDR_PRTE_id <> nvl(p_ELIG_GNDR_PRTE_id, hr_api.g_number) ;
120: --
121: Begin
122: --
123: hr_utility.set_location('Entering:'||l_proc, 5);
124: --
125: l_api_updating := ben_egn_shd.api_updating
126: (p_ELIG_GNDR_PRTE_id => p_ELIG_GNDR_PRTE_id,
127: p_effective_date => p_effective_date,
133: fetch c_elig_gndr_prte into l_dummy;
134: if c_elig_gndr_prte%found then
135: --
136: close c_elig_gndr_prte;
137: hr_utility.set_location(l_proc, 7);
138: --
139: -- raise error as duplicate criteria has been entered
140: --
141: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
144: end if;
145: --
146: close c_elig_gndr_prte;
147: --
148: hr_utility.set_location('Leaving:'||l_proc,10);
149: --
150: end chk_dup_elig_criteria;
151: --
152: -- ----------------------------------------------------------------------------
186: l_dummy char(1);
187: --
188: Begin
189: --
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: l_api_updating := ben_egn_shd.api_updating
193: (p_ELIG_GNDR_PRTE_id => p_ELIG_GNDR_PRTE_id,
194: p_effective_date => p_effective_date,
215: end if;
216: --
217: end if;
218: --
219: hr_utility.set_location('Leaving:'||l_proc,10);
220: --
221: end chk_sex;
222: --
223: -- ---------------------------------------------------------------------------
263: and ordr_num = p_ordr_num
264: and business_group_id = p_business_group_id;
265: --
266: Begin
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: open c1;
270: fetch c1 into l_dummy;
271: if c1%found then
274: fnd_message.raise_error;
275: end if;
276: close c1;
277: --
278: hr_utility.set_location('Leaving:'||l_proc, 15);
279: End chk_duplicate_ordr_num;
280: --
281: -- ----------------------------------------------------------------------------
282: -- |------< chk_excld_flag >------|
313: l_api_updating boolean;
314: --
315: Begin
316: --
317: hr_utility.set_location('Entering:'||l_proc, 5);
318: --
319: l_api_updating := ben_egn_shd.api_updating
320: (p_ELIG_GNDR_PRTE_id => p_ELIG_GNDR_PRTE_id,
321: p_effective_date => p_effective_date,
342: end if;
343: --
344: end if;
345: --
346: hr_utility.set_location('Leaving:'||l_proc,10);
347: --
348: end chk_excld_flag;
349: --
350: -- ----------------------------------------------------------------------------
387: l_integrity_error Exception;
388: l_table_name all_tables.table_name%TYPE;
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Ensure that the p_datetrack_mode argument is not null
394: --
395: hr_api.mandatory_arg_error
426: End If;
427: --
428: End If;
429: --
430: hr_utility.set_location(' Leaving:'||l_proc, 10);
431: Exception
432: When l_integrity_error Then
433: --
434: -- A referential integrity check was violated therefore
491: l_rows_exist Exception;
492: l_table_name all_tables.table_name%TYPE;
493: --
494: Begin
495: hr_utility.set_location('Entering:'||l_proc, 5);
496: --
497: -- Ensure that the p_datetrack_mode argument is not null
498: --
499: hr_api.mandatory_arg_error
528: --
529: --
530: End If;
531: --
532: hr_utility.set_location(' Leaving:'||l_proc, 10);
533: Exception
534: When l_rows_exist Then
535: --
536: -- A referential integrity check was violated therefore
560: --
561: l_proc varchar2(72) := g_package||'insert_validate';
562: --
563: Begin
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- Call all supporting business operations
567: --
568: chk_ELIG_GNDR_PRTE_id
597: --
598:
599: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
600: --
601: hr_utility.set_location(' Leaving:'||l_proc, 10);
602: End insert_validate;
603: --
604: -- ----------------------------------------------------------------------------
605: -- |---------------------------< update_validate >----------------------------|
613: --
614: l_proc varchar2(72) := g_package||'update_validate';
615: --
616: Begin
617: hr_utility.set_location('Entering:'||l_proc, 5);
618: --
619: -- Call all supporting business operations
620: --
621: chk_ELIG_GNDR_PRTE_id
659: p_datetrack_mode => p_datetrack_mode,
660: p_validation_start_date => p_validation_start_date,
661: p_validation_end_date => p_validation_end_date);
662: --
663: hr_utility.set_location(' Leaving:'||l_proc, 10);
664: End update_validate;
665: --
666: -- ----------------------------------------------------------------------------
667: -- |---------------------------< delete_validate >----------------------------|
675: --
676: l_proc varchar2(72) := g_package||'delete_validate';
677: --
678: Begin
679: hr_utility.set_location('Entering:'||l_proc, 5);
680: --
681: -- Call all supporting business operations
682: --
683: dt_delete_validate
685: p_validation_start_date => p_validation_start_date,
686: p_validation_end_date => p_validation_end_date,
687: p_ELIG_GNDR_PRTE_id => p_rec.ELIG_GNDR_PRTE_id);
688: --
689: hr_utility.set_location(' Leaving:'||l_proc, 10);
690: End delete_validate;
691: --
692: --
693: -- ---------------------------------------------------------------------------
712: l_proc varchar2(72) := g_package||'return_legislation_code';
713: --
714: begin
715: --
716: hr_utility.set_location('Entering:'|| l_proc, 10);
717: --
718: -- Ensure that all the mandatory parameter are not null
719: --
720: hr_api.mandatory_arg_error(p_api_name => l_proc,
737: end if;
738: --
739: close csr_leg_code;
740: --
741: hr_utility.set_location(' Leaving:'|| l_proc, 20);
742: --
743: return l_legislation_code;
744: --
745: end return_legislation_code;