40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bft_shd.api_updating
47: (p_benefit_action_id => p_benefit_action_id,
48: p_object_version_number => p_object_version_number);
68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_benefit_action_id;
75: --
76: -- ----------------------------------------------------------------------------
108: l_api_updating boolean;
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: l_api_updating := ben_bft_shd.api_updating
115: (p_benefit_action_id => p_benefit_action_id,
116: p_object_version_number => p_object_version_number);
137: end if;
138: --
139: end if;
140: --
141: hr_utility.set_location('Leaving:'||l_proc,10);
142: --
143: end chk_debug_messages_flag;
144: --
145: -- ----------------------------------------------------------------------------
178: l_api_updating boolean;
179: --
180: Begin
181: --
182: hr_utility.set_location('Entering:'||l_proc, 5);
183: --
184: l_api_updating := ben_bft_shd.api_updating
185: (p_benefit_action_id => p_benefit_action_id,
186: p_object_version_number => p_object_version_number);
209: end if;
210: --
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc,10);
214: --
215: end chk_person_selection_rl;
216: --
217: -- ----------------------------------------------------------------------------
250: l_api_updating boolean;
251: --
252: Begin
253: --
254: hr_utility.set_location('Entering:'||l_proc, 5);
255: --
256: l_api_updating := ben_bft_shd.api_updating
257: (p_benefit_action_id => p_benefit_action_id,
258: p_object_version_number => p_object_version_number);
281: end if;
282: --
283: end if;
284: --
285: hr_utility.set_location('Leaving:'||l_proc,10);
286: --
287: end chk_comp_selection_rl;
288: --
289: -- ----------------------------------------------------------------------------
321: l_api_updating boolean;
322: --
323: Begin
324: --
325: hr_utility.set_location('Entering:'||l_proc, 5);
326: --
327: l_api_updating := ben_bft_shd.api_updating
328: (p_benefit_action_id => p_benefit_action_id,
329: p_object_version_number => p_object_version_number);
350: end if;
351: --
352: end if;
353: --
354: hr_utility.set_location('Leaving:'||l_proc,10);
355: --
356: end chk_no_plans_flag;
357: --
358: -- ----------------------------------------------------------------------------
390: l_api_updating boolean;
391: --
392: Begin
393: --
394: hr_utility.set_location('Entering:'||l_proc, 5);
395: --
396: l_api_updating := ben_bft_shd.api_updating
397: (p_benefit_action_id => p_benefit_action_id,
398: p_object_version_number => p_object_version_number);
419: end if;
420: --
421: end if;
422: --
423: hr_utility.set_location('Leaving:'||l_proc,10);
424: --
425: end chk_no_programs_flag;
426: --
427: -- ----------------------------------------------------------------------------
459: l_api_updating boolean;
460: --
461: Begin
462: --
463: hr_utility.set_location('Entering:'||l_proc, 5);
464: --
465: l_api_updating := ben_bft_shd.api_updating
466: (p_benefit_action_id => p_benefit_action_id,
467: p_object_version_number => p_object_version_number);
488: end if;
489: --
490: end if;
491: --
492: hr_utility.set_location('Leaving:'||l_proc,10);
493: --
494: end chk_validate_flag;
495: --
496: -- ----------------------------------------------------------------------------
528: l_api_updating boolean;
529: --
530: Begin
531: --
532: hr_utility.set_location('Entering:'||l_proc, 5);
533: --
534: l_api_updating := ben_bft_shd.api_updating
535: (p_benefit_action_id => p_benefit_action_id,
536: p_object_version_number => p_object_version_number);
557: end if;
558: --
559: end if;
560: --
561: hr_utility.set_location('Leaving:'||l_proc,10);
562: --
563: end chk_derivable_factors_flag;
564: --
565: -- ----------------------------------------------------------------------------
597: l_api_updating boolean;
598: --
599: Begin
600: --
601: hr_utility.set_location('Entering:'||l_proc, 5);
602: --
603: l_api_updating := ben_bft_shd.api_updating
604: (p_benefit_action_id => p_benefit_action_id,
605: p_object_version_number => p_object_version_number);
626: end if;
627: --
628: end if;
629: --
630: hr_utility.set_location('Leaving:'||l_proc,10);
631: --
632: end chk_close_uneai_flag ;
633: --
634: -- ----------------------------------------------------------------------------
666: l_api_updating boolean;
667: --
668: Begin
669: --
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: l_api_updating := ben_bft_shd.api_updating
673: (p_benefit_action_id => p_benefit_action_id,
674: p_object_version_number => p_object_version_number);
698: then
699: --
700: -- raise error as does not exist as lookup
701: --
702: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
703: hr_utility.raise_error;
704: --
705: end if;
706: --
699: --
700: -- raise error as does not exist as lookup
701: --
702: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
703: hr_utility.raise_error;
704: --
705: end if;
706: --
707: end if;
705: end if;
706: --
707: end if;
708: --
709: hr_utility.set_location('Leaving:'||l_proc,10);
710: --
711: end chk_mode_cd;
712: --
713: -- ----------------------------------------------------------------------------
718: --
719: l_proc varchar2(72) := g_package||'insert_validate';
720: --
721: Begin
722: hr_utility.set_location('Entering:'||l_proc, 5);
723: --
724: -- Call lookup cache structure
725: --
726: benutils.init_lookups(p_lookup_type_1 => 'YES_NO',
790: p_mode_cd => p_rec.mode_cd,
791: p_effective_date => p_effective_date,
792: p_object_version_number => p_rec.object_version_number);
793: --
794: hr_utility.set_location(' Leaving:'||l_proc, 10);
795: End insert_validate;
796: --
797: -- ----------------------------------------------------------------------------
798: -- |---------------------------< update_validate >----------------------------|
802: --
803: l_proc varchar2(72) := g_package||'update_validate';
804: --
805: Begin
806: hr_utility.set_location('Entering:'||l_proc, 5);
807: --
808: -- Call lookup cache structure
809: --
810: benutils.init_lookups(p_lookup_type_1 => 'YES_NO',
874: p_mode_cd => p_rec.mode_cd,
875: p_effective_date => p_effective_date,
876: p_object_version_number => p_rec.object_version_number);
877: --
878: hr_utility.set_location(' Leaving:'||l_proc, 10);
879: End update_validate;
880: --
881: -- ----------------------------------------------------------------------------
882: -- |---------------------------< delete_validate >----------------------------|
886: --
887: l_proc varchar2(72) := g_package||'delete_validate';
888: --
889: Begin
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: -- Call all supporting business operations
893: --
894: hr_utility.set_location(' Leaving:'||l_proc, 10);
890: hr_utility.set_location('Entering:'||l_proc, 5);
891: --
892: -- Call all supporting business operations
893: --
894: hr_utility.set_location(' Leaving:'||l_proc, 10);
895: End delete_validate;
896: --
897: --
898: -- ---------------------------------------------------------------------------
917: l_proc varchar2(72) := g_package||'return_legislation_code';
918: --
919: begin
920: --
921: hr_utility.set_location('Entering:'|| l_proc, 10);
922: --
923: -- Ensure that all the mandatory parameter are not null
924: --
925: hr_api.mandatory_arg_error(p_api_name => l_proc,
935: close csr_leg_code;
936: --
937: -- The primary key is invalid therefore we must error
938: --
939: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
940: hr_utility.raise_error;
941: --
942: end if;
943: --
936: --
937: -- The primary key is invalid therefore we must error
938: --
939: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
940: hr_utility.raise_error;
941: --
942: end if;
943: --
944: close csr_leg_code;
942: end if;
943: --
944: close csr_leg_code;
945: --
946: hr_utility.set_location(' Leaving:'|| l_proc, 20);
947: --
948: return l_legislation_code;
949: --
950: end return_legislation_code;