DBA Data[Home] [Help]

APPS.BEN_PCX_BUS dependencies on HR_UTILITY

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

42: l_api_updating boolean;
43: --
44: Begin
45: --
46: hr_utility.set_location('Entering:'||l_proc, 5);
47: --
48: l_api_updating := ben_pcx_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pl_bnf_ctfn_id => p_pl_bnf_ctfn_id,

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

71: end if;
72: --
73: end if;
74: --
75: hr_utility.set_location('Leaving:'||l_proc, 10);
76: --
77: End chk_pl_bnf_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

128: or (p_validation_end_date between
129: effective_start_date and effective_end_date)) ;
130: --
131: Begin
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: open c1;
135: fetch c1 into l_dummy;
136: if c1%found then

Line 142: hr_utility.set_location('Leaving:'||l_proc, 15);

138: fnd_message.set_name('BEN','BEN_92122_CTFN_TYP_UNIQUE');
139: fnd_message.raise_error;
140: end if;
141: --
142: hr_utility.set_location('Leaving:'||l_proc, 15);
143: End chk_bnf_ctfn_typ_cd_unique;
144: --
145: -- ----------------------------------------------------------------------------
146: -- |------< chk_ctfn_rqd_when_rl >------|

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

194: and ff.effective_end_date;
195: --
196: Begin
197: --
198: hr_utility.set_location('Entering:'||l_proc, 5);
199: --
200: l_api_updating := ben_pcx_shd.api_updating
201: (p_pl_bnf_ctfn_id => p_pl_bnf_ctfn_id,
202: p_effective_date => p_effective_date,

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

232: close c1;
233: --
234: end if;
235: --
236: hr_utility.set_location('Leaving:'||l_proc,10);
237: --
238: end chk_ctfn_rqd_when_rl;
239: --
240: -- ----------------------------------------------------------------------------

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

272: l_api_updating boolean;
273: --
274: Begin
275: --
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: l_api_updating := ben_pcx_shd.api_updating
279: (p_pl_bnf_ctfn_id => p_pl_bnf_ctfn_id,
280: p_effective_date => p_effective_date,

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

301: end if;
302: --
303: end if;
304: --
305: hr_utility.set_location('Leaving:'||l_proc,10);
306: --
307: end chk_pfd_flag;
308: --
309: -- ----------------------------------------------------------------------------

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

341: l_api_updating boolean;
342: --
343: Begin
344: --
345: hr_utility.set_location('Entering:'||l_proc, 5);
346: --
347: l_api_updating := ben_pcx_shd.api_updating
348: (p_pl_bnf_ctfn_id => p_pl_bnf_ctfn_id,
349: p_effective_date => p_effective_date,

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

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

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

410: l_api_updating boolean;
411: --
412: Begin
413: --
414: hr_utility.set_location('Entering:'||l_proc, 5);
415: --
416: l_api_updating := ben_pcx_shd.api_updating
417: (p_pl_bnf_ctfn_id => p_pl_bnf_ctfn_id,
418: p_effective_date => p_effective_date,

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

439: end if;
440: --
441: end if;
442: --
443: hr_utility.set_location('Leaving:'||l_proc,10);
444: --
445: end chk_bnf_ctfn_typ_cd;
446: --
447: -- ----------------------------------------------------------------------------

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

483: l_integrity_error Exception;
484: l_table_name all_tables.table_name%TYPE;
485: --
486: Begin
487: hr_utility.set_location('Entering:'||l_proc, 5);
488: --
489: -- Ensure that the p_datetrack_mode argument is not null
490: --
491: hr_api.mandatory_arg_error

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

522: End If;
523: --
524: End If;
525: --
526: hr_utility.set_location(' Leaving:'||l_proc, 10);
527: Exception
528: When l_integrity_error Then
529: --
530: -- A referential integrity check was violated therefore

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

588: l_rows_exist Exception;
589: l_table_name all_tables.table_name%TYPE;
590: --
591: Begin
592: hr_utility.set_location('Entering:'||l_proc, 5);
593: --
594: -- Ensure that the p_datetrack_mode argument is not null
595: --
596: hr_api.mandatory_arg_error

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

625: --
626: --
627: End If;
628: --
629: hr_utility.set_location(' Leaving:'||l_proc, 10);
630: Exception
631: When l_rows_exist Then
632: --
633: -- A referential integrity check was violated therefore

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

658: --
659: l_proc varchar2(72) := g_package||'insert_validate';
660: --
661: Begin
662: hr_utility.set_location('Entering:'||l_proc, 5);
663: --
664: -- Call all supporting business operations
665: --
666: --

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

704: p_bnf_ctfn_typ_cd => p_rec.bnf_ctfn_typ_cd,
705: p_effective_date => p_effective_date,
706: p_object_version_number => p_rec.object_version_number);
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 10);
709: End insert_validate;
710: --
711: -- ----------------------------------------------------------------------------
712: -- |---------------------------< update_validate >----------------------------|

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

720: --
721: l_proc varchar2(72) := g_package||'update_validate';
722: --
723: Begin
724: hr_utility.set_location('Entering:'||l_proc, 5);
725: --
726: -- Call all supporting business operations
727: --
728: --

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

774: p_datetrack_mode => p_datetrack_mode,
775: p_validation_start_date => p_validation_start_date,
776: p_validation_end_date => p_validation_end_date);
777: --
778: hr_utility.set_location(' Leaving:'||l_proc, 10);
779: End update_validate;
780: --
781: -- ----------------------------------------------------------------------------
782: -- |---------------------------< delete_validate >----------------------------|

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

790: --
791: l_proc varchar2(72) := g_package||'delete_validate';
792: --
793: Begin
794: hr_utility.set_location('Entering:'||l_proc, 5);
795: --
796: -- Call all supporting business operations
797: --
798: dt_delete_validate

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

800: p_validation_start_date => p_validation_start_date,
801: p_validation_end_date => p_validation_end_date,
802: p_pl_bnf_ctfn_id => p_rec.pl_bnf_ctfn_id);
803: --
804: hr_utility.set_location(' Leaving:'||l_proc, 10);
805: End delete_validate;
806: --
807: --
808: -- ---------------------------------------------------------------------------

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

827: l_proc varchar2(72) := g_package||'return_legislation_code';
828: --
829: begin
830: --
831: hr_utility.set_location('Entering:'|| l_proc, 10);
832: --
833: -- Ensure that all the mandatory parameter are not null
834: --
835: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

852: end if;
853: --
854: close csr_leg_code;
855: --
856: hr_utility.set_location(' Leaving:'|| l_proc, 20);
857: --
858: return l_legislation_code;
859: --
860: end return_legislation_code;