DBA Data[Home] [Help]

APPS.BEN_PBB_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_pbb_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_per_bnfts_bal_id => p_per_bnfts_bal_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_per_bnfts_bal_id;
78: --
79: -- ----------------------------------------------------------------------------

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

128: and p_validation_end_date));
129: --
130: begin
131: --
132: hr_utility.set_location('Entering:'||l_proc, 5);
133: --
134: open c1;
135: fetch c1 into v_dummy;
136: --

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

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

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

185: l_integrity_error Exception;
186: l_table_name all_tables.table_name%TYPE;
187: --
188: Begin
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: -- Ensure that the p_datetrack_mode argument is not null
192: --
193: hr_api.mandatory_arg_error

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

224: End If;
225: --
226: End If;
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 10);
229: Exception
230: When l_integrity_error Then
231: --
232: -- A referential integrity check was violated therefore

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

289: l_rows_exist Exception;
290: l_table_name all_tables.table_name%TYPE;
291: --
292: Begin
293: hr_utility.set_location('Entering:'||l_proc, 5);
294: --
295: -- Ensure that the p_datetrack_mode argument is not null
296: --
297: hr_api.mandatory_arg_error

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

326: --
327: --
328: End If;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 10);
331: Exception
332: When l_rows_exist Then
333: --
334: -- A referential integrity check was violated therefore

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

359: --
360: l_proc varchar2(72) := g_package||'insert_validate';
361: --
362: Begin
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: -- Call all supporting business operations
366: --
367: --

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

380: p_validation_start_date => p_validation_start_date,
381: p_validation_end_date => p_validation_end_date,
382: p_effective_date => p_effective_date);
383: --
384: hr_utility.set_location(' Leaving:'||l_proc, 10);
385: End insert_validate;
386: --
387: -- ----------------------------------------------------------------------------
388: -- |---------------------------< update_validate >----------------------------|

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

396: --
397: l_proc varchar2(72) := g_package||'update_validate';
398: --
399: Begin
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: --
402: -- Call all supporting business operations
403: --
404: --

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

425: p_validation_start_date => p_validation_start_date,
426: p_validation_end_date => p_validation_end_date,
427: p_effective_date => p_effective_date);
428: --
429: hr_utility.set_location(' Leaving:'||l_proc, 10);
430: End update_validate;
431: --
432: -- ----------------------------------------------------------------------------
433: -- |---------------------------< delete_validate >----------------------------|

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

441: --
442: l_proc varchar2(72) := g_package||'delete_validate';
443: --
444: Begin
445: hr_utility.set_location('Entering:'||l_proc, 5);
446: --
447: -- Call all supporting business operations
448: --
449: dt_delete_validate

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

451: p_validation_start_date => p_validation_start_date,
452: p_validation_end_date => p_validation_end_date,
453: p_per_bnfts_bal_id => p_rec.per_bnfts_bal_id);
454: --
455: hr_utility.set_location(' Leaving:'||l_proc, 10);
456: End delete_validate;
457: --
458: --
459: -- ---------------------------------------------------------------------------

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

478: l_proc varchar2(72) := g_package||'return_legislation_code';
479: --
480: begin
481: --
482: hr_utility.set_location('Entering:'|| l_proc, 10);
483: --
484: -- Ensure that all the mandatory parameter are not null
485: --
486: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

503: end if;
504: --
505: close csr_leg_code;
506: --
507: hr_utility.set_location(' Leaving:'|| l_proc, 20);
508: --
509: return l_legislation_code;
510: --
511: end return_legislation_code;