DBA Data[Home] [Help]

APPS.BEN_CTU_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_ctu_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cm_typ_usg_id => p_cm_typ_usg_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_cm_typ_usg_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_ctu_shd.api_updating
118: (p_cm_typ_usg_id => p_cm_typ_usg_id,
119: p_effective_date => p_effective_date,

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

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

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

183: l_api_updating boolean;
184: --
185: Begin
186: --
187: hr_utility.set_location('Entering:'||l_proc, 5);
188: --
189: l_api_updating := ben_ctu_shd.api_updating
190: (p_cm_typ_usg_id => p_cm_typ_usg_id,
191: p_effective_date => p_effective_date,

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_cm_usg_rl;
220: --
221: -- ----------------------------------------------------------------------------

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

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

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

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

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

342: --
343: -- An unhandled or unexpected error has occurred which
344: -- we must report
345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_update_validate;

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

343: -- An unhandled or unexpected error has occurred which
344: -- we must report
345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_update_validate;
351: --

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

344: -- we must report
345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_update_validate;
351: --
352: -- ----------------------------------------------------------------------------

Line 349: hr_utility.raise_error;

345: --
346: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
347: hr_utility.set_message_token('PROCEDURE', l_proc);
348: hr_utility.set_message_token('STEP','15');
349: hr_utility.raise_error;
350: End dt_update_validate;
351: --
352: -- ----------------------------------------------------------------------------
353: -- |--------------------------< dt_delete_validate >--------------------------|

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

394: l_rows_exist Exception;
395: l_table_name all_tables.table_name%TYPE;
396: --
397: Begin
398: hr_utility.set_location('Entering:'||l_proc, 5);
399: --
400: -- Ensure that the p_datetrack_mode argument is not null
401: --
402: hr_api.mandatory_arg_error

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

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

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

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

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

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

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

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

Line 459: hr_utility.raise_error;

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

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

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

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

496: p_effective_date => p_effective_date,
497: p_business_group_id => p_rec.business_group_id,
498: p_object_version_number => p_rec.object_version_number);
499: --
500: hr_utility.set_location(' Leaving:'||l_proc, 10);
501: End insert_validate;
502: --
503: -- ----------------------------------------------------------------------------
504: -- |---------------------------< update_validate >----------------------------|

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

512: --
513: l_proc varchar2(72) := g_package||'update_validate';
514: --
515: Begin
516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Call all supporting business operations
519: --
520: --

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

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

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

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

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

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

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

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

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

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

Line 624: hr_utility.raise_error;

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

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

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