42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_ecq_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_elig_cbr_quald_bnf_id;
78: --
79: -- ----------------------------------------------------------------------------
116: where a.pgm_id = p_pgm_id;
117: --
118: Begin
119: --
120: hr_utility.set_location('Entering:'||l_proc,5);
121: --
122: l_api_updating := ben_ecq_shd.api_updating
123: (p_effective_date => p_effective_date,
124: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
148: close c1;
149: --
150: end if;
151: --
152: hr_utility.set_location('Leaving:'||l_proc,10);
153: --
154: End chk_pgm_id;
155: --
156: -- ----------------------------------------------------------------------------
193: where a.ptip_id = p_ptip_id;
194: --
195: Begin
196: --
197: hr_utility.set_location('Entering:'||l_proc,5);
198: --
199: l_api_updating := ben_ecq_shd.api_updating
200: (p_effective_date => p_effective_date,
201: p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
225: close c1;
226: --
227: end if;
228: --
229: hr_utility.set_location('Leaving:'||l_proc,10);
230: --
231: End chk_ptip_id;
232: --
233: -- ----------------------------------------------------------------------------
265: l_api_updating boolean;
266: --
267: Begin
268: --
269: hr_utility.set_location('Entering:'||l_proc, 5);
270: --
271: l_api_updating := ben_ecq_shd.api_updating
272: (p_elig_cbr_quald_bnf_id => p_elig_cbr_quald_bnf_id,
273: p_effective_date => p_effective_date,
296: end if;
297: --
298: end if;
299: --
300: hr_utility.set_location('Leaving:'||l_proc,10);
301: --
302: end chk_quald_bnf_flag;
303: --
304: --Bug:5054189
345: and ordr_num = p_ordr_num
346: and business_group_id = p_business_group_id;
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: open c1;
352: fetch c1 into l_dummy;
353: if c1%found then
356: fnd_message.raise_error;
357: end if;
358: close c1;
359: --
360: hr_utility.set_location('Leaving:'||l_proc, 15);
361: End chk_duplicate_ordr_num;
362: -- ----------------------------------------------------------------------------
363: -- |--------------------------< dt_update_validate >--------------------------|
364: -- ----------------------------------------------------------------------------
400: l_integrity_error Exception;
401: l_table_name all_tables.table_name%TYPE;
402: --
403: Begin
404: hr_utility.set_location('Entering:'||l_proc, 5);
405: --
406: -- Ensure that the p_datetrack_mode argument is not null
407: --
408: hr_api.mandatory_arg_error
459: End If;
460: --
461: End If;
462: --
463: hr_utility.set_location(' Leaving:'||l_proc, 10);
464: Exception
465: When l_integrity_error Then
466: --
467: -- A referential integrity check was violated therefore
525: l_rows_exist Exception;
526: l_table_name all_tables.table_name%TYPE;
527: --
528: Begin
529: hr_utility.set_location('Entering:'||l_proc, 5);
530: --
531: -- Ensure that the p_datetrack_mode argument is not null
532: --
533: hr_api.mandatory_arg_error
562: --
563: --
564: End If;
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 10);
567: Exception
568: When l_rows_exist Then
569: --
570: -- A referential integrity check was violated therefore
596: --
597: l_proc varchar2(72) := g_package||'insert_validate';
598: --
599: Begin
600: hr_utility.set_location('Entering:'||l_proc, 5);
601: --
602: -- Call all supporting business operations
603: --
604: --
632: ,p_eligy_prfl_id => p_rec.eligy_prfl_id
633: ,p_ordr_num => p_rec.ordr_num
634: ,p_business_group_id => p_rec.business_group_id);
635: --
636: hr_utility.set_location(' Leaving:'||l_proc, 10);
637: End insert_validate;
638: --
639: -- ----------------------------------------------------------------------------
640: -- |---------------------------< update_validate >----------------------------|
648: --
649: l_proc varchar2(72) := g_package||'update_validate';
650: --
651: Begin
652: hr_utility.set_location('Entering:'||l_proc, 5);
653: --
654: -- Call all supporting business operations
655: --
656: --
694: p_datetrack_mode => p_datetrack_mode,
695: p_validation_start_date => p_validation_start_date,
696: p_validation_end_date => p_validation_end_date);
697: --
698: hr_utility.set_location(' Leaving:'||l_proc, 10);
699: End update_validate;
700: --
701: -- ----------------------------------------------------------------------------
702: -- |---------------------------< delete_validate >----------------------------|
710: --
711: l_proc varchar2(72) := g_package||'delete_validate';
712: --
713: Begin
714: hr_utility.set_location('Entering:'||l_proc, 5);
715: --
716: -- Call all supporting business operations
717: --
718: dt_delete_validate
720: p_validation_start_date => p_validation_start_date,
721: p_validation_end_date => p_validation_end_date,
722: p_elig_cbr_quald_bnf_id => p_rec.elig_cbr_quald_bnf_id);
723: --
724: hr_utility.set_location(' Leaving:'||l_proc, 10);
725: End delete_validate;
726: --
727: --
728: -- ---------------------------------------------------------------------------
747: l_proc varchar2(72) := g_package||'return_legislation_code';
748: --
749: begin
750: --
751: hr_utility.set_location('Entering:'|| l_proc, 10);
752: --
753: -- Ensure that all the mandatory parameter are not null
754: --
755: hr_api.mandatory_arg_error(p_api_name => l_proc,
772: end if;
773: --
774: close csr_leg_code;
775: --
776: hr_utility.set_location(' Leaving:'|| l_proc, 20);
777: --
778: return l_legislation_code;
779: --
780: end return_legislation_code;