DBA Data[Home] [Help]

APPS.BEN_BNR_BUS dependencies on HR_UTILITY

Line 54: hr_utility.set_location (l_package_name,10);

50: l_business_group_id NUMBER := nvl(p_business_group_id, g_business_group_id);
51: l_legislation_code VARCHAR2(150) := nvl(p_legislation_code, g_legislation_code);
52:
53: BEGIN
54: hr_utility.set_location (l_package_name,10);
55: OPEN c_translation(language, rpt_grp_name,rpt_grp_id,l_business_group_id,l_legislation_code );
56: hr_utility.set_location (l_package_name,50);
57: FETCH c_translation INTO g_dummy;
58:

Line 56: hr_utility.set_location (l_package_name,50);

52:
53: BEGIN
54: hr_utility.set_location (l_package_name,10);
55: OPEN c_translation(language, rpt_grp_name,rpt_grp_id,l_business_group_id,l_legislation_code );
56: hr_utility.set_location (l_package_name,50);
57: FETCH c_translation INTO g_dummy;
58:
59: IF c_translation%NOTFOUND THEN
60: hr_utility.set_location (l_package_name,60);

Line 60: hr_utility.set_location (l_package_name,60);

56: hr_utility.set_location (l_package_name,50);
57: FETCH c_translation INTO g_dummy;
58:
59: IF c_translation%NOTFOUND THEN
60: hr_utility.set_location (l_package_name,60);
61: CLOSE c_translation;
62: ELSE
63: hr_utility.set_location (l_package_name,70);
64: CLOSE c_translation;

Line 63: hr_utility.set_location (l_package_name,70);

59: IF c_translation%NOTFOUND THEN
60: hr_utility.set_location (l_package_name,60);
61: CLOSE c_translation;
62: ELSE
63: hr_utility.set_location (l_package_name,70);
64: CLOSE c_translation;
65: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
66: fnd_message.raise_error;
67: END IF;

Line 68: hr_utility.set_location ('Leaving:'||l_package_name,80);

64: CLOSE c_translation;
65: fnd_message.set_name('PAY','HR_TRANSLATION_EXISTS');
66: fnd_message.raise_error;
67: END IF;
68: hr_utility.set_location ('Leaving:'||l_package_name,80);
69: END validate_translation;
70: -- ----------------------------------------------------------------------------
71: -- |------< chk_rptg_grp_id >------|
72: -- ----------------------------------------------------------------------------

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

100: l_api_updating boolean;
101: --
102: Begin
103: --
104: hr_utility.set_location('Entering:'||l_proc, 5);
105: --
106: l_api_updating := ben_bnr_shd.api_updating
107: (p_rptg_grp_id => p_rptg_grp_id,
108: p_object_version_number => p_object_version_number);

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

128: end if;
129: --
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 10);
133: --
134: End chk_rptg_grp_id;
135: --
136: -- ----------------------------------------------------------------------------

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

168: l_api_updating boolean;
169: --
170: Begin
171: --
172: hr_utility.set_location('Entering:'||l_proc, 5);
173: --
174: l_api_updating := ben_bnr_shd.api_updating
175: (p_rptg_grp_id => p_rptg_grp_id,
176: p_object_version_number => p_object_version_number);

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

196: end if;
197: --
198: end if;
199: --
200: hr_utility.set_location('Leaving:'||l_proc,10);
201: --
202: end chk_rptg_prps_cd;
203: --
204: --

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

263: l_dummy varchar2(1);
264: --
265: Begin
266: --
267: hr_utility.set_location('Entering:'||l_proc, 5);
268: --
269: l_api_updating := ben_bnr_shd.api_updating
270: (p_rptg_grp_id => p_rptg_grp_id,
271: p_object_version_number => p_object_version_number);

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

319: --
320: end if;
321: --
322: --
323: hr_utility.set_location('Leaving:'||l_proc,10);
324: --
325: end chk_irec_plans ;
326: --
327: ------------------------------------------------------------------------

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

377: and bnr.rptg_grp_id <> nvl( p_rptg_grp_id , -1)
378: and bnr.name = p_name;
379: Begin
380: --
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: hr_utility.set_location('business:'||p_business_group_id, 5);
383: --
384: l_api_updating := ben_bnr_shd.api_updating
385: (p_rptg_grp_id => p_rptg_grp_id,

Line 382: hr_utility.set_location('business:'||p_business_group_id, 5);

378: and bnr.name = p_name;
379: Begin
380: --
381: hr_utility.set_location('Entering:'||l_proc, 5);
382: hr_utility.set_location('business:'||p_business_group_id, 5);
383: --
384: l_api_updating := ben_bnr_shd.api_updating
385: (p_rptg_grp_id => p_rptg_grp_id,
386: -- p_effective_date => p_effective_date,

Line 416: hr_utility.set_location(' comming for update ' || p_rptg_grp_id, 99 );

412: --
413: -- fetch value from cursor if it returns a record then the
414: -- name is invalid otherwise its valid
415: --
416: hr_utility.set_location(' comming for update ' || p_rptg_grp_id, 99 );
417: fetch c1 into l_dummy;
418: if c1%found then
419: --
420: close c1;

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

428: --
429: close c1;
430: end if;
431: --
432: hr_utility.set_location('Leaving:'||l_proc,10);
433: --
434: end chk_name;
435: --
436: ----

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

489: where pre.business_group_id <> p_business_group_id
490: and pre.rptg_grp_id = p_rptg_grp_id;
491: Begin
492: --
493: hr_utility.set_location('Entering:'||l_proc, 5);
494: --
495: if p_business_group_id is not null then
496: --
497: open c1;

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

512: --
513: close c1;
514: --
515: end if;
516: hr_utility.set_location('Leaving:'||l_proc,10);
517: --
518: end chk_child_exist_in_other_bg;
519: --
520: --

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

564: l_table_name all_tables.table_name%TYPE;
565:
566: --
567: Begin
568: hr_utility.set_location('Entering:'||l_proc, 5);
569: --
570: -- Ensure that the p_datetrack_mode argument is not null
571:
572: --

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

635:
636: --
637: End If;
638: --
639: hr_utility.set_location(' Leaving:'||l_proc, 10);
640: Exception
641: When l_rows_exist Then
642: --
643: -- A referential integrity check was violated therefore

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

666: --
667: l_proc varchar2(72) := g_package||'insert_validate';
668: --
669: Begin
670: hr_utility.set_location('Entering:'||l_proc, 5);
671: --
672: -- Call all supporting business operations
673: --
674: -- CWB Changes

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

701: p_business_group_id => p_rec.business_group_id,
702: p_effective_date => p_effective_date,
703: p_object_version_number => p_rec.object_version_number) ;
704: --
705: hr_utility.set_location(' Leaving:'||l_proc, 10);
706: End insert_validate;
707: --
708: -- ----------------------------------------------------------------------------
709: -- |---------------------------< update_validate >----------------------------|

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

713: --
714: l_proc varchar2(72) := g_package||'update_validate';
715: --
716: Begin
717: hr_utility.set_location('Entering:'||l_proc, 5);
718: --
719: -- Call all supporting business operations
720: --
721: --

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

758: p_effective_date => p_effective_date,
759: p_object_version_number => p_rec.object_version_number) ;
760:
761: --
762: hr_utility.set_location(' Leaving:'||l_proc, 10);
763: End update_validate;
764: --
765: -- ----------------------------------------------------------------------------
766: -- |---------------------------< delete_validate >----------------------------|

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

770: --
771: l_proc varchar2(72) := g_package||'delete_validate';
772: --
773: Begin
774: hr_utility.set_location('Entering:'||l_proc, 5);
775: --
776: -- Call all supporting business operations
777:
778: -- Bug 2660590

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

789:
790: -- End of Bug 2660590
791:
792: --
793: hr_utility.set_location(' Leaving:'||l_proc, 10);
794: End delete_validate;
795: --
796: --
797: -- ---------------------------------------------------------------------------

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

816: l_proc varchar2(72) := g_package||'return_legislation_code';
817: --
818: begin
819: --
820: hr_utility.set_location('Entering:'|| l_proc, 10);
821: --
822: -- Ensure that all the mandatory parameter are not null
823: --
824: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

843: */
844: --
845: close csr_leg_code;
846: --
847: hr_utility.set_location(' Leaving:'|| l_proc, 20);
848: --
849: return l_legislation_code;
850: --
851: end return_legislation_code;