DBA Data[Home] [Help]

APPS.BEN_PIL_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_pil_shd.api_updating
47: (p_per_in_ler_id => p_per_in_ler_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_per_in_ler_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_pil_shd.api_updating
124: (p_per_in_ler_id => p_per_in_ler_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_ler_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_pil_shd.api_updating
204: (p_per_in_ler_id => p_per_in_ler_id,
205: p_object_version_number => p_object_version_number);

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

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

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

269: l_api_updating boolean;
270: --
271: Begin
272: --
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: l_api_updating := ben_pil_shd.api_updating
276: (p_per_in_ler_id => p_per_in_ler_id,
277: p_object_version_number => p_object_version_number);

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

299: end if;
300: --
301: end if;
302: --
303: hr_utility.set_location('Leaving:'||l_proc,10);
304: --
305: end chk_prvs_stat_cd;
306: --
307: -- ----------------------------------------------------------------------------

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

339: l_api_updating boolean;
340: --
341: Begin
342: --
343: hr_utility.set_location('Entering:'||l_proc, 5);
344: --
345: l_api_updating := ben_pil_shd.api_updating
346: (p_per_in_ler_id => p_per_in_ler_id,
347: p_object_version_number => p_object_version_number);

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

369: end if;
370: --
371: end if;
372: --
373: hr_utility.set_location('Leaving:'||l_proc,10);
374: --
375: end chk_per_in_ler_stat_cd;
376: --
377: -- ----------------------------------------------------------------------------

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

415: where a.per_in_ler_id = p_bckt_per_in_ler_id;
416: --
417: Begin
418: --
419: hr_utility.set_location('Entering:'||l_proc,5);
420: --
421: l_api_updating := ben_pil_shd.api_updating
422: (p_per_in_ler_id => p_per_in_ler_id,
423: p_object_version_number => p_object_version_number);

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

448: close c1;
449: --
450: end if;
451: --
452: hr_utility.set_location('Leaving:'||l_proc,10);
453: --
454: End chk_bckt_per_in_ler_id;
455: --
456: -- ----------------------------------------------------------------------------

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

493: l_proc varchar2(72) := g_package||'chk_ws_mgr_id';
494:
495: begin
496:
497: hr_utility.set_location(' Entering:'||l_proc, 10);
498:
499: if (p_ws_mgr_id
500: <> nvl(ben_pil_shd.g_old_rec.ws_mgr_id,hr_api.g_number)) then
501:

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

511: close c1;
512:
513: end if;
514:
515: hr_utility.set_location(' Leaving:'||l_proc, 20);
516: end chk_ws_mgr_id;
517: -- ----------------------------------------------------------------------------
518: -- |---------------------------< insert_validate >----------------------------|
519: -- ----------------------------------------------------------------------------

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

522: --
523: l_proc varchar2(72) := g_package||'insert_validate';
524: --
525: Begin
526: hr_utility.set_location('Entering:'||l_proc, 5);
527: --
528: -- Call all supporting business operations
529: --
530: --

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

552: p_bckt_per_in_ler_id => p_rec.bckt_per_in_ler_id,
553: p_effective_date => p_effective_date,
554: p_object_version_number => p_rec.object_version_number);
555: --
556: hr_utility.set_location(' Leaving:'||l_proc, 10);
557: End insert_validate;
558: --
559: -- ----------------------------------------------------------------------------
560: -- |---------------------------< update_validate >----------------------------|

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

564: --
565: l_proc varchar2(72) := g_package||'update_validate';
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Call all supporting business operations
571: --
572: --

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

598: (p_per_in_ler_id => p_rec.per_in_ler_id,
599: p_ws_mgr_id => p_rec.ws_mgr_id ,
600: p_effective_date => p_effective_date
601: );
602: hr_utility.set_location(' Leaving:'||l_proc, 10);
603: End update_validate;
604: --
605: -- ----------------------------------------------------------------------------
606: -- |---------------------------< delete_validate >----------------------------|

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

610: --
611: l_proc varchar2(72) := g_package||'delete_validate';
612: --
613: Begin
614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- Call all supporting business operations
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

614: hr_utility.set_location('Entering:'||l_proc, 5);
615: --
616: -- Call all supporting business operations
617: --
618: hr_utility.set_location(' Leaving:'||l_proc, 10);
619: End delete_validate;
620: --
621: --
622: -- ---------------------------------------------------------------------------

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

641: l_proc varchar2(72) := g_package||'return_legislation_code';
642: --
643: begin
644: --
645: hr_utility.set_location('Entering:'|| l_proc, 10);
646: --
647: -- Ensure that all the mandatory parameter are not null
648: --
649: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

659: close csr_leg_code;
660: --
661: -- The primary key is invalid therefore we must error
662: --
663: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
664: hr_utility.raise_error;
665: --
666: end if;
667: --

Line 664: hr_utility.raise_error;

660: --
661: -- The primary key is invalid therefore we must error
662: --
663: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
664: hr_utility.raise_error;
665: --
666: end if;
667: --
668: close csr_leg_code;

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

666: end if;
667: --
668: close csr_leg_code;
669: --
670: hr_utility.set_location(' Leaving:'|| l_proc, 20);
671: --
672: return l_legislation_code;
673: --
674: end return_legislation_code;