DBA Data[Home] [Help]

APPS.BEN_DBR_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_dbr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_dsbld_rt_id => p_dsbld_rt_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_dsbld_rt_id;
78: --
79: -- |--------------------< chk_duplicate_ordr_num >----------------------------|

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

118: and business_group_id + 0 = p_business_group_id
119: and ordr_num = p_ordr_num;
120: --
121: Begin
122: hr_utility.set_location('Entering:'||l_proc, 5);
123:
124: --
125: open c1;
126: fetch c1 into l_dummy;

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

130: fnd_message.raise_error;
131: end if;
132: close c1;
133: --
134: hr_utility.set_location('Leaving:'||l_proc, 15);
135: End chk_duplicate_ordr_num;
136:
137: --
138: -- ----------------------------------------------------------------------------

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

170: l_api_updating boolean;
171: --
172: Begin
173: --
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: l_api_updating := ben_dbr_shd.api_updating
177: (p_dsbld_rt_id => p_dsbld_rt_id,
178: p_effective_date => p_effective_date,

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

199: end if;
200: --
201: end if;
202: --
203: hr_utility.set_location('Leaving:'||l_proc,10);
204: --
205: end chk_excld_flag;
206: --
207: -- ----------------------------------------------------------------------------

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

257: and p_validation_end_date >= effective_start_date;
258: -- end bug # 2452735
259: Begin
260: --
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: l_api_updating := ben_dbr_shd.api_updating
264: (p_dsbld_rt_id => p_dsbld_rt_id,
265: p_effective_date => p_effective_date,

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

303: close c3;
304: -- end bug # 2452735
305: end if;
306: --
307: hr_utility.set_location('Leaving:'||l_proc,10);
308: --
309: end chk_dsbld_cd;
310: --
311: -- ----------------------------------------------------------------------------

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

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

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

386: End If;
387: --
388: End If;
389: --
390: hr_utility.set_location(' Leaving:'||l_proc, 10);
391: Exception
392: When l_integrity_error Then
393: --
394: -- A referential integrity check was violated therefore

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

452: l_rows_exist Exception;
453: l_table_name all_tables.table_name%TYPE;
454: --
455: Begin
456: hr_utility.set_location('Entering:'||l_proc, 5);
457: --
458: -- Ensure that the p_datetrack_mode argument is not null
459: --
460: hr_api.mandatory_arg_error

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

489: --
490: --
491: End If;
492: --
493: hr_utility.set_location(' Leaving:'||l_proc, 10);
494: Exception
495: When l_rows_exist Then
496: --
497: -- A referential integrity check was violated therefore

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

523: --
524: l_proc varchar2(72) := g_package||'insert_validate';
525: --
526: Begin
527: hr_utility.set_location('Entering:'||l_proc, 5);
528: --
529: -- Call all supporting business operations
530: --
531: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

557: ,p_effective_date => p_effective_date
558: ,p_business_group_id => p_rec.business_group_id
559: ,p_dsbld_rt_id => p_rec.dsbld_rt_id);
560: --
561: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: End insert_validate;
563: --
564: -- ----------------------------------------------------------------------------
565: -- |---------------------------< update_validate >----------------------------|

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

573: --
574: l_proc varchar2(72) := g_package||'update_validate';
575: --
576: Begin
577: hr_utility.set_location('Entering:'||l_proc, 5);
578: --
579: -- Call all supporting business operations
580: --
581: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

615: ,p_effective_date => p_effective_date
616: ,p_business_group_id => p_rec.business_group_id
617: ,p_dsbld_rt_id => p_rec.dsbld_rt_id);
618: --
619: hr_utility.set_location(' Leaving:'||l_proc, 10);
620: End update_validate;
621: --
622: -- ----------------------------------------------------------------------------
623: -- |---------------------------< delete_validate >----------------------------|

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

631: --
632: l_proc varchar2(72) := g_package||'delete_validate';
633: --
634: Begin
635: hr_utility.set_location('Entering:'||l_proc, 5);
636: --
637: -- Call all supporting business operations
638: --
639: dt_delete_validate

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

641: p_validation_start_date => p_validation_start_date,
642: p_validation_end_date => p_validation_end_date,
643: p_dsbld_rt_id => p_rec.dsbld_rt_id);
644: --
645: hr_utility.set_location(' Leaving:'||l_proc, 10);
646: End delete_validate;
647: --
648: --
649: -- ---------------------------------------------------------------------------

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

668: l_proc varchar2(72) := g_package||'return_legislation_code';
669: --
670: begin
671: --
672: hr_utility.set_location('Entering:'|| l_proc, 10);
673: --
674: -- Ensure that all the mandatory parameter are not null
675: --
676: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

693: end if;
694: --
695: close csr_leg_code;
696: --
697: hr_utility.set_location(' Leaving:'|| l_proc, 20);
698: --
699: return l_legislation_code;
700: --
701: end return_legislation_code;