42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_elu_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_lbr_mmbr_prte_id => p_elig_lbr_mmbr_prte_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_lbr_mmbr_prte_id;
78: --
79: -- ----------------------------------------------------------------------------
128: --
129: --
130: Begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: l_api_updating := ben_elu_shd.api_updating
135: (p_elig_lbr_mmbr_prte_id => p_elig_lbr_mmbr_prte_id,
136: p_effective_date => p_effective_date,
171: --
172: --
173: end if;
174: --
175: hr_utility.set_location('Leaving:'||l_proc,10);
176: --
177: end chk_lbr_mmbr_flag;
178: --
179: -- ----------------------------------------------------------------------------
211: l_api_updating boolean;
212: --
213: Begin
214: --
215: hr_utility.set_location('Entering:'||l_proc, 5);
216: --
217: l_api_updating := ben_elu_shd.api_updating
218: (p_elig_lbr_mmbr_prte_id => p_elig_lbr_mmbr_prte_id,
219: p_effective_date => p_effective_date,
240: end if;
241: --
242: end if;
243: --
244: hr_utility.set_location('Leaving:'||l_proc,10);
245: --
246: end chk_excld_flag;
247: --
248: --Bug:5054189
289: and ordr_num = p_ordr_num
290: and business_group_id = p_business_group_id;
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: open c1;
296: fetch c1 into l_dummy;
297: if c1%found then
300: fnd_message.raise_error;
301: end if;
302: close c1;
303: --
304: hr_utility.set_location('Leaving:'||l_proc, 15);
305: End chk_duplicate_ordr_num;
306: -- ----------------------------------------------------------------------------
307: -- |--------------------------< dt_update_validate >--------------------------|
308: -- ----------------------------------------------------------------------------
342: l_integrity_error Exception;
343: l_table_name all_tables.table_name%TYPE;
344: --
345: Begin
346: hr_utility.set_location('Entering:'||l_proc, 5);
347: --
348: -- Ensure that the p_datetrack_mode argument is not null
349: --
350: hr_api.mandatory_arg_error
372: --
373: --
374: End If;
375: --
376: hr_utility.set_location(' Leaving:'||l_proc, 10);
377: Exception
378: When l_integrity_error Then
379: --
380: -- A referential integrity check was violated therefore
439: l_rows_exist Exception;
440: l_table_name all_tables.table_name%TYPE;
441: --
442: Begin
443: hr_utility.set_location('Entering:'||l_proc, 5);
444: --
445: -- Ensure that the p_datetrack_mode argument is not null
446: --
447: hr_api.mandatory_arg_error
476: --
477: --
478: End If;
479: --
480: hr_utility.set_location(' Leaving:'||l_proc, 10);
481: Exception
482: When l_rows_exist Then
483: --
484: -- A referential integrity check was violated therefore
510: --
511: l_proc varchar2(72) := g_package||'insert_validate';
512: --
513: Begin
514: hr_utility.set_location('Entering:'||l_proc, 5);
515: --
516: -- Call all supporting business operations
517: --
518: --
544: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
545: ,p_ordr_num => p_rec.ordr_num
546: ,p_business_group_id => p_rec.business_group_id);
547: --
548: hr_utility.set_location(' Leaving:'||l_proc, 10);
549: End insert_validate;
550: --
551: -- ----------------------------------------------------------------------------
552: -- |---------------------------< update_validate >----------------------------|
560: --
561: l_proc varchar2(72) := g_package||'update_validate';
562: --
563: Begin
564: hr_utility.set_location('Entering:'||l_proc, 5);
565: --
566: -- Call all supporting business operations
567: --
568: --
602: p_datetrack_mode => p_datetrack_mode,
603: p_validation_start_date => p_validation_start_date,
604: p_validation_end_date => p_validation_end_date);
605: --
606: hr_utility.set_location(' Leaving:'||l_proc, 10);
607: End update_validate;
608: --
609: -- ----------------------------------------------------------------------------
610: -- |---------------------------< delete_validate >----------------------------|
618: --
619: l_proc varchar2(72) := g_package||'delete_validate';
620: --
621: Begin
622: hr_utility.set_location('Entering:'||l_proc, 5);
623: --
624: -- Call all supporting business operations
625: --
626: dt_delete_validate
628: p_validation_start_date => p_validation_start_date,
629: p_validation_end_date => p_validation_end_date,
630: p_elig_lbr_mmbr_prte_id => p_rec.elig_lbr_mmbr_prte_id);
631: --
632: hr_utility.set_location(' Leaving:'||l_proc, 10);
633: End delete_validate;
634: --
635: --
636: -- ---------------------------------------------------------------------------
655: l_proc varchar2(72) := g_package||'return_legislation_code';
656: --
657: begin
658: --
659: hr_utility.set_location('Entering:'|| l_proc, 10);
660: --
661: -- Ensure that all the mandatory parameter are not null
662: --
663: hr_api.mandatory_arg_error(p_api_name => l_proc,
680: end if;
681: --
682: close csr_leg_code;
683: --
684: hr_utility.set_location(' Leaving:'|| l_proc, 20);
685: --
686: return l_legislation_code;
687: --
688: end return_legislation_code;