DBA Data[Home] [Help]

APPS.BEN_PGC_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_pgc_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_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_pgm_dpnt_cvg_ctfn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

131: and p_validation_end_date >= effective_start_date;
132:
133: Begin
134: --
135: hr_utility.set_location('Entering:'||l_proc, 5);
136: --
137: l_api_updating := ben_pgc_shd.api_updating
138: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
139: p_effective_date => p_effective_date,

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

176: close chk_unique;
177: --
178: end if;
179: --
180: hr_utility.set_location('Leaving:'||l_proc,10);
181: --
182: end chk_dpnt_cvg_ctfn_typ_cd;
183: --
184: -- ----------------------------------------------------------------------------

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

235: and p_validation_end_date >= effective_start_date;
236: --
237: Begin
238: --
239: hr_utility.set_location('Entering:'||l_proc, 5);
240: --
241: l_api_updating := ben_pgc_shd.api_updating
242: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
243: p_effective_date => p_effective_date,

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

280: close chk_unique;
281: --
282: end if;
283: --
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: end chk_pfd_flag;
287: --
288: -- ----------------------------------------------------------------------------

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

320: l_api_updating boolean;
321: --
322: Begin
323: --
324: hr_utility.set_location('Entering:'||l_proc, 5);
325: --
326: l_api_updating := ben_pgc_shd.api_updating
327: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
328: p_effective_date => p_effective_date,

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

349: end if;
350: --
351: end if;
352: --
353: hr_utility.set_location('Leaving:'||l_proc,10);
354: --
355: end chk_rqd_flag;
356: --
357: -- ----------------------------------------------------------------------------

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

406: and ff.effective_end_date;
407: --
408: Begin
409: --
410: hr_utility.set_location('Entering:'||l_proc, 5);
411: --
412: l_api_updating := ben_pgc_shd.api_updating
413: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
414: p_effective_date => p_effective_date,

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

444: close c1;
445: --
446: end if;
447: --
448: hr_utility.set_location('Leaving:'||l_proc,10);
449: --
450: end chk_ctfn_rqd_when_rl;
451: --
452: -- ----------------------------------------------------------------------------

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

484: l_api_updating boolean;
485: --
486: Begin
487: --
488: hr_utility.set_location('Entering:'||l_proc, 5);
489: --
490: l_api_updating := ben_pgc_shd.api_updating
491: (p_pgm_dpnt_cvg_ctfn_id => p_pgm_dpnt_cvg_ctfn_id,
492: p_effective_date => p_effective_date,

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

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

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

558: l_integrity_error Exception;
559: l_table_name all_tables.table_name%TYPE;
560: --
561: Begin
562: hr_utility.set_location('Entering:'||l_proc, 5);
563: --
564: -- Ensure that the p_datetrack_mode argument is not null
565: --
566: hr_api.mandatory_arg_error

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

607: End If;
608: --
609: End If;
610: --
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: Exception
613: When l_integrity_error Then
614: --
615: -- A referential integrity check was violated therefore

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

672: l_rows_exist Exception;
673: l_table_name all_tables.table_name%TYPE;
674: --
675: Begin
676: hr_utility.set_location('Entering:'||l_proc, 5);
677: --
678: -- Ensure that the p_datetrack_mode argument is not null
679: --
680: hr_api.mandatory_arg_error

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

709: --
710: --
711: End If;
712: --
713: hr_utility.set_location(' Leaving:'||l_proc, 10);
714: Exception
715: When l_rows_exist Then
716: --
717: -- A referential integrity check was violated therefore

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

741: --
742: l_proc varchar2(72) := g_package||'insert_validate';
743: --
744: Begin
745: hr_utility.set_location('Entering:'||l_proc, 5);
746: --
747: -- Call all supporting business operations
748: --
749: --

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

793: p_lack_ctfn_sspnd_enrt_flag => p_rec.lack_ctfn_sspnd_enrt_flag,
794: p_effective_date => p_effective_date,
795: p_object_version_number => p_rec.object_version_number);
796: --
797: hr_utility.set_location(' Leaving:'||l_proc, 10);
798: End insert_validate;
799: --
800: -- ----------------------------------------------------------------------------
801: -- |---------------------------< update_validate >----------------------------|

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

809: --
810: l_proc varchar2(72) := g_package||'update_validate';
811: --
812: Begin
813: hr_utility.set_location('Entering:'||l_proc, 5);
814: --
815: -- Call all supporting business operations
816: --
817: --

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

870: p_datetrack_mode => p_datetrack_mode,
871: p_validation_start_date => p_validation_start_date,
872: p_validation_end_date => p_validation_end_date);
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
875: End update_validate;
876: --
877: -- ----------------------------------------------------------------------------
878: -- |---------------------------< delete_validate >----------------------------|

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

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: dt_delete_validate

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

896: p_validation_start_date => p_validation_start_date,
897: p_validation_end_date => p_validation_end_date,
898: p_pgm_dpnt_cvg_ctfn_id => p_rec.pgm_dpnt_cvg_ctfn_id);
899: --
900: hr_utility.set_location(' Leaving:'||l_proc, 10);
901: End delete_validate;
902: --
903: --
904: -- ---------------------------------------------------------------------------

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

923: l_proc varchar2(72) := g_package||'return_legislation_code';
924: --
925: begin
926: --
927: hr_utility.set_location('Entering:'|| l_proc, 10);
928: --
929: -- Ensure that all the mandatory parameter are not null
930: --
931: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

948: end if;
949: --
950: close csr_leg_code;
951: --
952: hr_utility.set_location(' Leaving:'|| l_proc, 20);
953: --
954: return l_legislation_code;
955: --
956: end return_legislation_code;