DBA Data[Home] [Help]

APPS.BEN_RZR_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_rzr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_pstl_zip_rng_id => p_pstl_zip_rng_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_pstl_zip_rng_id;
78: --
79: -- ----------------------------------------------------------------------------

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

108: l_api_updating boolean;
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'||l_proc, 5);
113: --
114: declare
115: v_to_value number;
116: v_from_value number ;

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

142: end if;
143: --
144: end;
145: --
146: hr_utility.set_location('Leaving:'||l_proc, 10);
147: --
148: End chk_pstl_zip_from_to_range;
149: --
150: -- ----------------------------------------------------------------------------

Line 197: hr_utility.set_location('Entering:'||l_proc, 6);

193:
194: --
195: Begin
196: --
197: hr_utility.set_location('Entering:'||l_proc, 6);
198: --
199: open c1;
200: fetch c1 into dummy;
201: if c1%found then

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

204: fnd_message.raise_error;
205: end if;
206: close c1;
207: --
208: hr_utility.set_location('Leaving:'||l_proc, 10);
209: --
210: End chk_duplicate_rows;
211: -- ----------------------------------------------------------------------------
212: -- |--------------------------< dt_update_validate >--------------------------|

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

247: l_integrity_error Exception;
248: l_table_name all_tables.table_name%TYPE;
249: --
250: Begin
251: hr_utility.set_location('Entering:'||l_proc, 5);
252: --
253: -- Ensure that the p_datetrack_mode argument is not null
254: --
255: hr_api.mandatory_arg_error

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

277: --
278: --
279: End If;
280: --
281: hr_utility.set_location(' Leaving:'||l_proc, 10);
282: Exception
283: When l_integrity_error Then
284: --
285: -- A referential integrity check was violated therefore

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

345: -- l_table_name all_tables.table_name%TYPE;
346: l_child_rec varchar2(50);
347: --
348: Begin
349: hr_utility.set_location('Entering:'||l_proc, 5);
350: --
351: -- Ensure that the p_datetrack_mode argument is not null
352: --
353: hr_api.mandatory_arg_error

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

421: End If;
422: --
423: End If;
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: Exception
427: When l_rows_exist Then
428: --
429: -- A referential integrity check was violated therefore

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

460: --
461: l_proc varchar2(72) := g_package||'insert_validate';
462: --
463: Begin
464: hr_utility.set_location('Entering:'||l_proc, 5);
465: --
466: -- Call all supporting business operations
467: --
468: --

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

489: p_effective_date => p_effective_date,
490: p_validation_start_date => p_validation_start_date,
491: p_validation_end_date => p_validation_end_date);
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: End insert_validate;
495: --
496: -- ----------------------------------------------------------------------------
497: -- |---------------------------< update_validate >----------------------------|

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

505: --
506: l_proc varchar2(72) := g_package||'update_validate';
507: --
508: Begin
509: hr_utility.set_location('Entering:'||l_proc, 5);
510: --
511: -- Call all supporting business operations
512: --
513: --

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

541: p_datetrack_mode => p_datetrack_mode,
542: p_validation_start_date => p_validation_start_date,
543: p_validation_end_date => p_validation_end_date);
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);
546: End update_validate;
547: --
548: -- ----------------------------------------------------------------------------
549: -- |---------------------------< delete_validate >----------------------------|

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

557: --
558: l_proc varchar2(72) := g_package||'delete_validate';
559: --
560: Begin
561: hr_utility.set_location('Entering:'||l_proc, 5);
562: --
563: -- Call all supporting business operations
564: --
565: dt_delete_validate

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

567: p_validation_start_date => p_validation_start_date,
568: p_validation_end_date => p_validation_end_date,
569: p_pstl_zip_rng_id => p_rec.pstl_zip_rng_id);
570: --
571: hr_utility.set_location(' Leaving:'||l_proc, 10);
572: End delete_validate;
573: --
574: --
575: -- ---------------------------------------------------------------------------

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

594: l_proc varchar2(72) := g_package||'return_legislation_code';
595: --
596: begin
597: --
598: hr_utility.set_location('Entering:'|| l_proc, 10);
599: --
600: -- Ensure that all the mandatory parameter are not null
601: --
602: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

619: end if;
620: --
621: close csr_leg_code;
622: --
623: hr_utility.set_location(' Leaving:'|| l_proc, 20);
624: --
625: return l_legislation_code;
626: --
627: end return_legislation_code;