DBA Data[Home] [Help]

APPS.BEN_BEC_BUS dependencies on HR_UTILITY

Line 44: hr_utility.set_location('Entering:'||l_proc, 5);

40: l_api_updating boolean;
41: --
42: Begin
43: --
44: hr_utility.set_location('Entering:'||l_proc, 5);
45: --
46: l_api_updating := ben_bec_shd.api_updating
47: (p_batch_elctbl_id => p_batch_elctbl_id,
48: p_object_version_number => p_object_version_number);

Line 72: hr_utility.set_location('Leaving:'||l_proc, 10);

68: end if;
69: --
70: end if;
71: --
72: hr_utility.set_location('Leaving:'||l_proc, 10);
73: --
74: End chk_batch_elctbl_id;
75: --
76: -- ----------------------------------------------------------------------------

Line 121: hr_utility.set_location('Entering:'||l_proc,5);

117: and a.effective_end_date;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_bec_shd.api_updating
124: (p_batch_elctbl_id => p_batch_elctbl_id,
125: p_object_version_number => p_object_version_number);

Line 152: hr_utility.set_location('Leaving:'||l_proc,10);

148: close c1;
149: --
150: end if;
151: --
152: hr_utility.set_location('Leaving:'||l_proc,10);
153: --
154: End chk_person_id;
155: --
156: -- ----------------------------------------------------------------------------

Line 201: hr_utility.set_location('Entering:'||l_proc,5);

197: and a.effective_end_date;
198: --
199: Begin
200: --
201: hr_utility.set_location('Entering:'||l_proc,5);
202: --
203: l_api_updating := ben_bec_shd.api_updating
204: (p_batch_elctbl_id => p_batch_elctbl_id,
205: p_object_version_number => p_object_version_number);

Line 233: hr_utility.set_location('Leaving:'||l_proc,10);

229: close c1;
230: --
231: end if;
232: --
233: hr_utility.set_location('Leaving:'||l_proc,10);
234: --
235: End chk_oipl_id;
236: --
237: -- ----------------------------------------------------------------------------

Line 282: hr_utility.set_location('Entering:'||l_proc,5);

278: and a.effective_end_date;
279: --
280: Begin
281: --
282: hr_utility.set_location('Entering:'||l_proc,5);
283: --
284: l_api_updating := ben_bec_shd.api_updating
285: (p_batch_elctbl_id => p_batch_elctbl_id,
286: p_object_version_number => p_object_version_number);

Line 314: hr_utility.set_location('Leaving:'||l_proc,10);

310: close c1;
311: --
312: end if;
313: --
314: hr_utility.set_location('Leaving:'||l_proc,10);
315: --
316: End chk_pl_id;
317: --
318: -- ----------------------------------------------------------------------------

Line 363: hr_utility.set_location('Entering:'||l_proc,5);

359: and a.effective_end_date;
360: --
361: Begin
362: --
363: hr_utility.set_location('Entering:'||l_proc,5);
364: --
365: l_api_updating := ben_bec_shd.api_updating
366: (p_batch_elctbl_id => p_batch_elctbl_id,
367: p_object_version_number => p_object_version_number);

Line 395: hr_utility.set_location('Leaving:'||l_proc,10);

391: close c1;
392: --
393: end if;
394: --
395: hr_utility.set_location('Leaving:'||l_proc,10);
396: --
397: End chk_pgm_id;
398: --
399: -- ----------------------------------------------------------------------------

Line 439: hr_utility.set_location('Entering:'||l_proc,5);

435: where a.benefit_action_id = p_benefit_action_id;
436: --
437: Begin
438: --
439: hr_utility.set_location('Entering:'||l_proc,5);
440: --
441: l_api_updating := ben_bec_shd.api_updating
442: (p_batch_elctbl_id => p_batch_elctbl_id,
443: p_object_version_number => p_object_version_number);

Line 470: hr_utility.set_location('Leaving:'||l_proc,10);

466: close c1;
467: --
468: end if;
469: --
470: hr_utility.set_location('Leaving:'||l_proc,10);
471: --
472: End chk_benefit_action_id;
473: --
474: -- ----------------------------------------------------------------------------

Line 510: hr_utility.set_location('Entering:'||l_proc, 5);

506: l_api_updating boolean;
507: --
508: Begin
509: --
510: hr_utility.set_location('Entering:'||l_proc, 5);
511: --
512: l_api_updating := ben_bec_shd.api_updating
513: (p_batch_elctbl_id => p_batch_elctbl_id,
514: p_object_version_number => p_object_version_number);

Line 540: hr_utility.set_location('Leaving:'||l_proc,10);

536: end if;
537: --
538: end if;
539: --
540: hr_utility.set_location('Leaving:'||l_proc,10);
541: --
542: end chk_dflt_flag;
543: --
544: -- ----------------------------------------------------------------------------

Line 580: hr_utility.set_location('Entering:'||l_proc, 5);

576: l_api_updating boolean;
577: --
578: Begin
579: --
580: hr_utility.set_location('Entering:'||l_proc, 5);
581: --
582: l_api_updating := ben_bec_shd.api_updating
583: (p_batch_elctbl_id => p_batch_elctbl_id,
584: p_object_version_number => p_object_version_number);

Line 610: hr_utility.set_location('Leaving:'||l_proc,10);

606: end if;
607: --
608: end if;
609: --
610: hr_utility.set_location('Leaving:'||l_proc,10);
611: --
612: end chk_mndtry_flag;
613: --
614: -- ----------------------------------------------------------------------------

Line 650: hr_utility.set_location('Entering:'||l_proc, 5);

646: l_api_updating boolean;
647: --
648: Begin
649: --
650: hr_utility.set_location('Entering:'||l_proc, 5);
651: --
652: l_api_updating := ben_bec_shd.api_updating
653: (p_batch_elctbl_id => p_batch_elctbl_id,
654: p_object_version_number => p_object_version_number);

Line 680: hr_utility.set_location('Leaving:'||l_proc,10);

676: end if;
677: --
678: end if;
679: --
680: hr_utility.set_location('Leaving:'||l_proc,10);
681: --
682: end chk_comp_lvl_cd;
683: --
684: -- ----------------------------------------------------------------------------

Line 720: hr_utility.set_location('Entering:'||l_proc, 5);

716: l_api_updating boolean;
717: --
718: Begin
719: --
720: hr_utility.set_location('Entering:'||l_proc, 5);
721: --
722: l_api_updating := ben_bec_shd.api_updating
723: (p_batch_elctbl_id => p_batch_elctbl_id,
724: p_object_version_number => p_object_version_number);

Line 750: hr_utility.set_location('Leaving:'||l_proc,10);

746: end if;
747: --
748: end if;
749: --
750: hr_utility.set_location('Leaving:'||l_proc,10);
751: --
752: end chk_enrt_typ_cycl_cd;
753: --
754: -- ----------------------------------------------------------------------------

Line 763: hr_utility.set_location('Entering:'||l_proc, 5);

759: --
760: l_proc varchar2(72) := g_package||'insert_validate';
761: --
762: Begin
763: hr_utility.set_location('Entering:'||l_proc, 5);
764: --
765: -- Call all supporting business operations
766: --
767: --

Line 827: hr_utility.set_location(' Leaving:'||l_proc, 10);

823: p_enrt_typ_cycl_cd => p_rec.enrt_typ_cycl_cd,
824: p_effective_date => p_effective_date,
825: p_object_version_number => p_rec.object_version_number);
826: --
827: hr_utility.set_location(' Leaving:'||l_proc, 10);
828: End insert_validate;
829: --
830: -- ----------------------------------------------------------------------------
831: -- |---------------------------< update_validate >----------------------------|

Line 839: hr_utility.set_location('Entering:'||l_proc, 5);

835: --
836: l_proc varchar2(72) := g_package||'update_validate';
837: --
838: Begin
839: hr_utility.set_location('Entering:'||l_proc, 5);
840: --
841: -- Call all supporting business operations
842: --
843: --

Line 903: hr_utility.set_location(' Leaving:'||l_proc, 10);

899: p_enrt_typ_cycl_cd => p_rec.enrt_typ_cycl_cd,
900: p_effective_date => p_effective_date,
901: p_object_version_number => p_rec.object_version_number);
902: --
903: hr_utility.set_location(' Leaving:'||l_proc, 10);
904: End update_validate;
905: --
906: -- ----------------------------------------------------------------------------
907: -- |---------------------------< delete_validate >----------------------------|

Line 915: hr_utility.set_location('Entering:'||l_proc, 5);

911: --
912: l_proc varchar2(72) := g_package||'delete_validate';
913: --
914: Begin
915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: -- Call all supporting business operations
918: --
919: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 919: hr_utility.set_location(' Leaving:'||l_proc, 10);

915: hr_utility.set_location('Entering:'||l_proc, 5);
916: --
917: -- Call all supporting business operations
918: --
919: hr_utility.set_location(' Leaving:'||l_proc, 10);
920: End delete_validate;
921: --
922: --
923: -- ---------------------------------------------------------------------------

Line 946: hr_utility.set_location('Entering:'|| l_proc, 10);

942: l_proc varchar2(72) := g_package||'return_legislation_code';
943: --
944: begin
945: --
946: hr_utility.set_location('Entering:'|| l_proc, 10);
947: --
948: -- Ensure that all the mandatory parameter are not null
949: --
950: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 964: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

960: close csr_leg_code;
961: --
962: -- The primary key is invalid therefore we must error
963: --
964: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
965: hr_utility.raise_error;
966: --
967: end if;
968: --

Line 965: hr_utility.raise_error;

961: --
962: -- The primary key is invalid therefore we must error
963: --
964: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
965: hr_utility.raise_error;
966: --
967: end if;
968: --
969: close csr_leg_code;

Line 971: hr_utility.set_location(' Leaving:'|| l_proc, 20);

967: end if;
968: --
969: close csr_leg_code;
970: --
971: hr_utility.set_location(' Leaving:'|| l_proc, 20);
972: --
973: return l_legislation_code;
974: --
975: end return_legislation_code;