DBA Data[Home] [Help]

APPS.BEN_BPL_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_bpl_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_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_prvdd_ldgr_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_bpl_shd.api_updating
118: (p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id,
119: p_effective_date => p_effective_date,

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

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

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

185: l_api_updating boolean;
186: --
187: Begin
188: --
189: hr_utility.set_location('Entering:'||l_proc, 5);
190: --
191: l_api_updating := ben_bpl_shd.api_updating
192: (p_bnft_prvdd_ldgr_id => p_bnft_prvdd_ldgr_id,
193: p_effective_date => p_effective_date,

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

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

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

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

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

337: End If;
338: --
339: End If;
340: --
341: hr_utility.set_location(' Leaving:'||l_proc, 10);
342: Exception
343: When l_integrity_error Then
344: --
345: -- A referential integrity check was violated therefore

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

351: --
352: -- An unhandled or unexpected error has occurred which
353: -- we must report
354: --
355: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
356: hr_utility.set_message_token('PROCEDURE', l_proc);
357: hr_utility.set_message_token('STEP','15');
358: hr_utility.raise_error;
359: End dt_update_validate;

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

352: -- An unhandled or unexpected error has occurred which
353: -- we must report
354: --
355: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
356: hr_utility.set_message_token('PROCEDURE', l_proc);
357: hr_utility.set_message_token('STEP','15');
358: hr_utility.raise_error;
359: End dt_update_validate;
360: --

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

353: -- we must report
354: --
355: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
356: hr_utility.set_message_token('PROCEDURE', l_proc);
357: hr_utility.set_message_token('STEP','15');
358: hr_utility.raise_error;
359: End dt_update_validate;
360: --
361: -- ----------------------------------------------------------------------------

Line 358: hr_utility.raise_error;

354: --
355: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
356: hr_utility.set_message_token('PROCEDURE', l_proc);
357: hr_utility.set_message_token('STEP','15');
358: hr_utility.raise_error;
359: End dt_update_validate;
360: --
361: -- ----------------------------------------------------------------------------
362: -- |--------------------------< dt_delete_validate >--------------------------|

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

403: l_rows_exist Exception;
404: l_table_name all_tables.table_name%TYPE;
405: --
406: Begin
407: hr_utility.set_location('Entering:'||l_proc, 5);
408: --
409: -- Ensure that the p_datetrack_mode argument is not null
410: --
411: hr_api.mandatory_arg_error

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

440: --
441: --
442: End If;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 10);
445: Exception
446: When l_rows_exist Then
447: --
448: -- A referential integrity check was violated therefore

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

454: --
455: -- An unhandled or unexpected error has occurred which
456: -- we must report
457: --
458: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE', l_proc);
460: hr_utility.set_message_token('STEP','15');
461: hr_utility.raise_error;
462: End dt_delete_validate;

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

455: -- An unhandled or unexpected error has occurred which
456: -- we must report
457: --
458: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE', l_proc);
460: hr_utility.set_message_token('STEP','15');
461: hr_utility.raise_error;
462: End dt_delete_validate;
463: --

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

456: -- we must report
457: --
458: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE', l_proc);
460: hr_utility.set_message_token('STEP','15');
461: hr_utility.raise_error;
462: End dt_delete_validate;
463: --
464: -- ----------------------------------------------------------------------------

Line 461: hr_utility.raise_error;

457: --
458: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
459: hr_utility.set_message_token('PROCEDURE', l_proc);
460: hr_utility.set_message_token('STEP','15');
461: hr_utility.raise_error;
462: End dt_delete_validate;
463: --
464: -- ----------------------------------------------------------------------------
465: -- |---------------------------< insert_validate >----------------------------|

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

473: --
474: l_proc varchar2(72) := g_package||'insert_validate';
475: --
476: Begin
477: hr_utility.set_location('Entering:'||l_proc, 5);
478: --
479: -- Call all supporting business operations
480: --
481: --

Line 502: hr_utility.set_location('business_group_id '||to_char(p_rec.business_group_id), 10);

498: -- p_cmcd_ref_perd_cd => p_rec.cmcd_ref_perd_cd,
499: -- p_effective_date => p_effective_date,
500: -- p_object_version_number => p_rec.object_version_number);
501:
502: hr_utility.set_location('business_group_id '||to_char(p_rec.business_group_id), 10);
503: hr_utility.set_location(' Leaving:'||l_proc, 10);
504: End insert_validate;
505: --
506: -- ----------------------------------------------------------------------------

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

499: -- p_effective_date => p_effective_date,
500: -- p_object_version_number => p_rec.object_version_number);
501:
502: hr_utility.set_location('business_group_id '||to_char(p_rec.business_group_id), 10);
503: hr_utility.set_location(' Leaving:'||l_proc, 10);
504: End insert_validate;
505: --
506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< update_validate >----------------------------|

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

515: --
516: l_proc varchar2(72) := g_package||'update_validate';
517: --
518: Begin
519: hr_utility.set_location('Entering:'||l_proc, 5);
520:
521: -- Call all supporting business operations
522: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
523:

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

549: p_datetrack_mode => p_datetrack_mode,
550: p_validation_start_date => p_validation_start_date,
551: p_validation_end_date => p_validation_end_date);
552: --
553: hr_utility.set_location(' Leaving:'||l_proc, 10);
554: End update_validate;
555: --
556: -- ----------------------------------------------------------------------------
557: -- |---------------------------< delete_validate >----------------------------|

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

565: --
566: l_proc varchar2(72) := g_package||'delete_validate';
567: --
568: Begin
569: hr_utility.set_location('Entering:'||l_proc, 5);
570: --
571: -- Call all supporting business operations
572: --
573: dt_delete_validate

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

575: p_validation_start_date => p_validation_start_date,
576: p_validation_end_date => p_validation_end_date,
577: p_bnft_prvdd_ldgr_id => p_rec.bnft_prvdd_ldgr_id);
578: --
579: hr_utility.set_location(' Leaving:'||l_proc, 10);
580: End delete_validate;
581: --
582: --
583: -- ---------------------------------------------------------------------------

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

602: l_proc varchar2(72) := g_package||'return_legislation_code';
603: --
604: begin
605: --
606: hr_utility.set_location('Entering:'|| l_proc, 10);
607: --
608: -- Ensure that all the mandatory parameter are not null
609: --
610: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

620: close csr_leg_code;
621: --
622: -- The primary key is invalid therefore we must error
623: --
624: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
625: hr_utility.raise_error;
626: --
627: end if;
628: --

Line 625: hr_utility.raise_error;

621: --
622: -- The primary key is invalid therefore we must error
623: --
624: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
625: hr_utility.raise_error;
626: --
627: end if;
628: --
629: close csr_leg_code;

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

627: end if;
628: --
629: close csr_leg_code;
630: --
631: hr_utility.set_location(' Leaving:'|| l_proc, 20);
632: --
633: return l_legislation_code;
634: --
635: end return_legislation_code;