DBA Data[Home] [Help]

APPS.BEN_LOR_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_lor_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_ler_chg_plip_enrt_rl_id => p_ler_chg_plip_enrt_rl_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_ler_chg_plip_enrt_rl_id;
78: --
79: -- ----------------------------------------------------------------------------

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

129: and p_validation_end_date >= effective_start_date;
130: --
131: Begin
132: --
133: hr_utility.set_location('Entering:'||l_proc, 5);
134: --
135: l_api_updating := ben_lor_shd.api_updating
136: (p_ler_chg_plip_enrt_rl_id => p_ler_chg_plip_enrt_rl_id ,
137: p_effective_date => p_effective_date,

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

159: close chk_unique;
160: --
161: end if;
162: --
163: hr_utility.set_location('Leaving:'||l_proc,10);
164: --
165: end chk_ordr_to_aply_num;
166: --
167: -- ----------------------------------------------------------------------------

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

217: and p_validation_end_date >= effective_start_date;
218: --
219: Begin
220: --
221: hr_utility.set_location('Entering:'||l_proc, 5);
222: --
223: l_api_updating := ben_lor_shd.api_updating
224: (p_ler_chg_plip_enrt_rl_id => p_ler_chg_plip_enrt_rl_id ,
225: p_effective_date => p_effective_date,

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

249: close chk_unique;
250: --
251: end if;
252: --
253: hr_utility.set_location('Leaving:'||l_proc,10);
254: --
255: end chk_formula_id;
256: --
257: -- ----------------------------------------------------------------------------

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

306: and ff.effective_end_date;
307: --
308: Begin
309: --
310: hr_utility.set_location('Entering:'||l_proc, 5);
311: --
312: l_api_updating := ben_lor_shd.api_updating
313: (p_ler_chg_plip_enrt_rl_id => p_ler_chg_plip_enrt_rl_id,
314: p_effective_date => p_effective_date,

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

342: close c1;
343: --
344: end if;
345: --
346: hr_utility.set_location('Leaving:'||l_proc,10);
347: --
348: end chk_valid_formula_id ;
349: --
350: -- ----------------------------------------------------------------------------

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

387: l_integrity_error Exception;
388: l_table_name all_tables.table_name%TYPE;
389: --
390: Begin
391: hr_utility.set_location('Entering:'||l_proc, 5);
392: --
393: -- Ensure that the p_datetrack_mode argument is not null
394: --
395: hr_api.mandatory_arg_error

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

436: End If;
437: --
438: End If;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: Exception
442: When l_integrity_error Then
443: --
444: -- A referential integrity check was violated therefore

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

501: l_rows_exist Exception;
502: l_table_name all_tables.table_name%TYPE;
503: --
504: Begin
505: hr_utility.set_location('Entering:'||l_proc, 5);
506: --
507: -- Ensure that the p_datetrack_mode argument is not null
508: --
509: hr_api.mandatory_arg_error

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

538: --
539: --
540: End If;
541: --
542: hr_utility.set_location(' Leaving:'||l_proc, 10);
543: Exception
544: When l_rows_exist Then
545: --
546: -- A referential integrity check was violated therefore

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

570: --
571: l_proc varchar2(72) := g_package||'insert_validate';
572: --
573: Begin
574: hr_utility.set_location('Entering:'||l_proc, 5);
575: --
576: -- Call all supporting business operations
577: --
578: --

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

609: p_formula_id => p_rec.formula_id,
610: p_effective_date => p_effective_date,
611: p_object_version_number => p_rec.object_version_number);
612: --
613: hr_utility.set_location(' Leaving:'||l_proc, 10);
614: End insert_validate;
615: --
616: -- ----------------------------------------------------------------------------
617: -- |---------------------------< update_validate >----------------------------|

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

625: --
626: l_proc varchar2(72) := g_package||'update_validate';
627: --
628: Begin
629: hr_utility.set_location('Entering:'||l_proc, 5);
630: --
631: -- Call all supporting business operations
632: --
633: --

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

673: p_datetrack_mode => p_datetrack_mode,
674: p_validation_start_date => p_validation_start_date,
675: p_validation_end_date => p_validation_end_date);
676: --
677: hr_utility.set_location(' Leaving:'||l_proc, 10);
678: End update_validate;
679: --
680: -- ----------------------------------------------------------------------------
681: -- |---------------------------< delete_validate >----------------------------|

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

689: --
690: l_proc varchar2(72) := g_package||'delete_validate';
691: --
692: Begin
693: hr_utility.set_location('Entering:'||l_proc, 5);
694: --
695: -- Call all supporting business operations
696: --
697: dt_delete_validate

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

699: p_validation_start_date => p_validation_start_date,
700: p_validation_end_date => p_validation_end_date,
701: p_ler_chg_plip_enrt_rl_id => p_rec.ler_chg_plip_enrt_rl_id);
702: --
703: hr_utility.set_location(' Leaving:'||l_proc, 10);
704: End delete_validate;
705: --
706: --
707: -- ---------------------------------------------------------------------------

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

726: l_proc varchar2(72) := g_package||'return_legislation_code';
727: --
728: begin
729: --
730: hr_utility.set_location('Entering:'|| l_proc, 10);
731: --
732: -- Ensure that all the mandatory parameter are not null
733: --
734: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

751: end if;
752: --
753: close csr_leg_code;
754: --
755: hr_utility.set_location(' Leaving:'|| l_proc, 20);
756: --
757: return l_legislation_code;
758: --
759: end return_legislation_code;