DBA Data[Home] [Help]

APPS.BEN_RRB_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_rrb_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_regn_for_regy_body_id => p_regn_for_regy_body_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_regn_for_regy_body_id;
78: --
79: -- ----------------------------------------------------------------------------

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

111: l_api_updating boolean;
112: --
113: Begin
114: --
115: hr_utility.set_location('Entering:'||l_proc, 5);
116: --
117: l_api_updating := ben_rrb_shd.api_updating
118: (p_regn_for_regy_body_id => p_regn_for_regy_body_id,
119: p_effective_date => p_effective_date,

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_regn_admin_cd;
147: --
148: -- ----------------------------------------------------------------------------

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

201: ;
202: --
203: Begin
204: --
205: hr_utility.set_location('Entering:'||l_proc, 5);
206: --
207: l_api_updating := ben_rrb_shd.api_updating
208: (p_effective_date => p_effective_date,
209: p_regn_for_regy_body_id => p_regn_for_regy_body_id,

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

213: and p_organization_id <> ben_rrb_shd.g_old_rec.organization_id) or
214: not l_api_updating then
215: --
216: --
217: hr_utility.set_location('Entering:'||l_proc, 10);
218: --
219: -- check if this regy body already exists for this regulation
220: --
221: open csr_organization_id;

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

231: end if;
232: --
233: end if;
234: --
235: hr_utility.set_location('Leaving:'||l_proc, 20);
236: --
237: End chk_organization_id;
238: --
239: -- ----------------------------------------------------------------------------

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

275: l_integrity_error Exception;
276: l_table_name all_tables.table_name%TYPE;
277: --
278: Begin
279: hr_utility.set_location('Entering:'||l_proc, 5);
280: --
281: -- Ensure that the p_datetrack_mode argument is not null
282: --
283: hr_api.mandatory_arg_error

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

314: End If;
315: --
316: End If;
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 10);
319: Exception
320: When l_integrity_error Then
321: --
322: -- A referential integrity check was violated therefore

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

381: l_rows_exist Exception;
382: l_table_name all_tables.table_name%TYPE;
383: --
384: Begin
385: hr_utility.set_location('Entering:'||l_proc, 5);
386: --
387: -- Ensure that the p_datetrack_mode argument is not null
388: --
389: hr_api.mandatory_arg_error

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

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

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

452: --
453: l_proc varchar2(72) := g_package||'insert_validate';
454: --
455: Begin
456: hr_utility.set_location('Entering:'||l_proc, 5);
457: --
458: -- Call all supporting business operations
459: --
460: --

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

480: p_validation_end_date => p_validation_end_date,
481: p_business_group_id => p_rec.business_group_id,
482: p_object_version_number => p_rec.object_version_number);
483: --
484: hr_utility.set_location(' Leaving:'||l_proc, 10);
485: End insert_validate;
486: --
487: -- ----------------------------------------------------------------------------
488: -- |---------------------------< update_validate >----------------------------|

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

496: --
497: l_proc varchar2(72) := g_package||'update_validate';
498: --
499: Begin
500: hr_utility.set_location('Entering:'||l_proc, 5);
501: --
502: -- Call all supporting business operations
503: --
504: --

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

533: p_datetrack_mode => p_datetrack_mode,
534: p_validation_start_date => p_validation_start_date,
535: p_validation_end_date => p_validation_end_date);
536: --
537: hr_utility.set_location(' Leaving:'||l_proc, 10);
538: End update_validate;
539: --
540: -- ----------------------------------------------------------------------------
541: -- |---------------------------< delete_validate >----------------------------|

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

549: --
550: l_proc varchar2(72) := g_package||'delete_validate';
551: --
552: Begin
553: hr_utility.set_location('Entering:'||l_proc, 5);
554: --
555: -- Call all supporting business operations
556: --
557: dt_delete_validate

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

559: p_validation_start_date => p_validation_start_date,
560: p_validation_end_date => p_validation_end_date,
561: p_regn_for_regy_body_id => p_rec.regn_for_regy_body_id);
562: --
563: hr_utility.set_location(' Leaving:'||l_proc, 10);
564: End delete_validate;
565: --
566: --
567: -- ---------------------------------------------------------------------------

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

586: l_proc varchar2(72) := g_package||'return_legislation_code';
587: --
588: begin
589: --
590: hr_utility.set_location('Entering:'|| l_proc, 10);
591: --
592: -- Ensure that all the mandatory parameter are not null
593: --
594: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

611: end if;
612: --
613: close csr_leg_code;
614: --
615: hr_utility.set_location(' Leaving:'|| l_proc, 20);
616: --
617: return l_legislation_code;
618: --
619: end return_legislation_code;