DBA Data[Home] [Help]

APPS.BEN_BVR_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_bvr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnft_vrbl_rt_id => p_bnft_vrbl_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_bnft_vrbl_rt_id;
78: --
79: -- ---------------------------------------------------------------------------

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

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

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

128: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
129: fnd_message.raise_error;
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 15);
133: End chk_ordr_num_unique;
134: --
135: -- ----------------------------------------------------------------------------
136: -- |------------------------< chk_brr_bvr_mutexcl >--------------------------|

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

181: and a.effective_end_date;
182: --
183: Begin
184: --
185: hr_utility.set_location('Entering:'||l_proc, 5);
186: --
187: l_api_updating := ben_bvr_shd.api_updating
188: (p_effective_date => p_effective_date,
189: p_bnft_vrbl_rt_id => p_bnft_vrbl_rt_id,

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

211: close c1;
212: --
213: end if;
214: --
215: hr_utility.set_location('Leaving:'||l_proc, 10);
216: --
217: End chk_brr_bvr_mutexcl;
218: --
219: -- ----------------------------------------------------------------------------

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

256: l_integrity_error Exception;
257: l_table_name all_tables.table_name%TYPE;
258: --
259: Begin
260: hr_utility.set_location('Entering:'||l_proc, 5);
261: --
262: -- Ensure that the p_datetrack_mode argument is not null
263: --
264: hr_api.mandatory_arg_error

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

305: End If;
306: --
307: End If;
308: --
309: hr_utility.set_location(' Leaving:'||l_proc, 10);
310: Exception
311: When l_integrity_error Then
312: --
313: -- A referential integrity check was violated therefore

Line 323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

319: --
320: -- An unhandled or unexpected error has occurred which
321: -- we must report
322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;

Line 324: hr_utility.set_message_token('PROCEDURE', l_proc);

320: -- An unhandled or unexpected error has occurred which
321: -- we must report
322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;
328: --

Line 325: hr_utility.set_message_token('STEP','15');

321: -- we must report
322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;
328: --
329: -- ----------------------------------------------------------------------------

Line 326: hr_utility.raise_error;

322: --
323: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
324: hr_utility.set_message_token('PROCEDURE', l_proc);
325: hr_utility.set_message_token('STEP','15');
326: hr_utility.raise_error;
327: End dt_update_validate;
328: --
329: -- ----------------------------------------------------------------------------
330: -- |--------------------------< dt_delete_validate >--------------------------|

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

371: l_rows_exist Exception;
372: l_table_name all_tables.table_name%TYPE;
373: --
374: Begin
375: hr_utility.set_location('Entering:'||l_proc, 5);
376: --
377: -- Ensure that the p_datetrack_mode argument is not null
378: --
379: hr_api.mandatory_arg_error

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

408: --
409: --
410: End If;
411: --
412: hr_utility.set_location(' Leaving:'||l_proc, 10);
413: Exception
414: When l_rows_exist Then
415: --
416: -- A referential integrity check was violated therefore

Line 426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

422: --
423: -- An unhandled or unexpected error has occurred which
424: -- we must report
425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;

Line 427: hr_utility.set_message_token('PROCEDURE', l_proc);

423: -- An unhandled or unexpected error has occurred which
424: -- we must report
425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;
431: --

Line 428: hr_utility.set_message_token('STEP','15');

424: -- we must report
425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;
431: --
432: -- ----------------------------------------------------------------------------

Line 429: hr_utility.raise_error;

425: --
426: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
427: hr_utility.set_message_token('PROCEDURE', l_proc);
428: hr_utility.set_message_token('STEP','15');
429: hr_utility.raise_error;
430: End dt_delete_validate;
431: --
432: -- ----------------------------------------------------------------------------
433: -- |---------------------------< insert_validate >----------------------------|

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

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

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

466: p_effective_date => p_effective_date,
467: p_business_group_id => p_rec.business_group_id,
468: p_object_version_number => p_rec.object_version_number);
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 10);
471: End insert_validate;
472: --
473: -- ----------------------------------------------------------------------------
474: -- |---------------------------< update_validate >----------------------------|

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

482: --
483: l_proc varchar2(72) := g_package||'update_validate';
484: --
485: Begin
486: hr_utility.set_location('Entering:'||l_proc, 5);
487: --
488: -- Call all supporting business operations
489: --
490: --

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

516: p_datetrack_mode => p_datetrack_mode,
517: p_validation_start_date => p_validation_start_date,
518: p_validation_end_date => p_validation_end_date);
519: --
520: hr_utility.set_location(' Leaving:'||l_proc, 10);
521: End update_validate;
522: --
523: -- ----------------------------------------------------------------------------
524: -- |---------------------------< delete_validate >----------------------------|

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

532: --
533: l_proc varchar2(72) := g_package||'delete_validate';
534: --
535: Begin
536: hr_utility.set_location('Entering:'||l_proc, 5);
537: --
538: -- Call all supporting business operations
539: --
540: dt_delete_validate

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

542: p_validation_start_date => p_validation_start_date,
543: p_validation_end_date => p_validation_end_date,
544: p_bnft_vrbl_rt_id => p_rec.bnft_vrbl_rt_id);
545: --
546: hr_utility.set_location(' Leaving:'||l_proc, 10);
547: End delete_validate;
548: --
549: --
550: -- ---------------------------------------------------------------------------

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

569: l_proc varchar2(72) := g_package||'return_legislation_code';
570: --
571: begin
572: --
573: hr_utility.set_location('Entering:'|| l_proc, 10);
574: --
575: -- Ensure that all the mandatory parameter are not null
576: --
577: hr_api.mandatory_arg_error(p_api_name => l_proc,

Line 591: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');

587: close csr_leg_code;
588: --
589: -- The primary key is invalid therefore we must error
590: --
591: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
592: hr_utility.raise_error;
593: --
594: end if;
595: --

Line 592: hr_utility.raise_error;

588: --
589: -- The primary key is invalid therefore we must error
590: --
591: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
592: hr_utility.raise_error;
593: --
594: end if;
595: --
596: close csr_leg_code;

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

594: end if;
595: --
596: close csr_leg_code;
597: --
598: hr_utility.set_location(' Leaving:'|| l_proc, 20);
599: --
600: return l_legislation_code;
601: --
602: end return_legislation_code;