DBA Data[Home] [Help]

APPS.BEN_CTT_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_ctt_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_cm_typ_trgr_id => p_cm_typ_trgr_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_trgr_id;
78: --
79: -- ----------------------------------------------------------------------------

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

112: l_api_updating boolean;
113: --
114: Begin
115: --
116: hr_utility.set_location('Entering:'||l_proc, 5);
117: --
118: l_api_updating := ben_ctt_shd.api_updating
119: (p_cm_typ_trgr_id => p_cm_typ_trgr_id,
120: 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_cm_typ_trgr_rl;
149: --
150: -- ----------------------------------------------------------------------------

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

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

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

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

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

238: --
239: -- An unhandled or unexpected error has occurred which
240: -- we must report
241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;

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

239: -- An unhandled or unexpected error has occurred which
240: -- we must report
241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;
247: --

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

240: -- we must report
241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;
247: --
248: -- ----------------------------------------------------------------------------

Line 245: hr_utility.raise_error;

241: --
242: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
243: hr_utility.set_message_token('PROCEDURE', l_proc);
244: hr_utility.set_message_token('STEP','15');
245: hr_utility.raise_error;
246: End dt_update_validate;
247: --
248: -- ----------------------------------------------------------------------------
249: -- |--------------------------< dt_delete_validate >--------------------------|

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

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

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

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

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

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

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

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

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

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

Line 347: hr_utility.raise_error;

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

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 382: hr_utility.set_location(' Leaving:'||l_proc, 10);

378: p_effective_date => p_effective_date,
379: p_business_group_id => p_rec.business_group_id,
380: p_object_version_number => p_rec.object_version_number);
381: --
382: hr_utility.set_location(' Leaving:'||l_proc, 10);
383: End insert_validate;
384: --
385: -- ----------------------------------------------------------------------------
386: -- |---------------------------< update_validate >----------------------------|

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

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

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

421: p_datetrack_mode => p_datetrack_mode,
422: p_validation_start_date => p_validation_start_date,
423: p_validation_end_date => p_validation_end_date);
424: --
425: hr_utility.set_location(' Leaving:'||l_proc, 10);
426: End update_validate;
427: --
428: -- ----------------------------------------------------------------------------
429: -- |---------------------------< delete_validate >----------------------------|

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

437: --
438: l_proc varchar2(72) := g_package||'delete_validate';
439: --
440: Begin
441: hr_utility.set_location('Entering:'||l_proc, 5);
442: --
443: -- Call all supporting business operations
444: --
445: dt_delete_validate

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

447: p_validation_start_date => p_validation_start_date,
448: p_validation_end_date => p_validation_end_date,
449: p_cm_typ_trgr_id => p_rec.cm_typ_trgr_id);
450: --
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452: End delete_validate;
453: --
454: --
455: -- ---------------------------------------------------------------------------

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

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

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

492: close csr_leg_code;
493: --
494: -- The primary key is invalid therefore we must error
495: --
496: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
497: hr_utility.raise_error;
498: --
499: end if;
500: --

Line 497: hr_utility.raise_error;

493: --
494: -- The primary key is invalid therefore we must error
495: --
496: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
497: hr_utility.raise_error;
498: --
499: end if;
500: --
501: close csr_leg_code;

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

499: end if;
500: --
501: close csr_leg_code;
502: --
503: hr_utility.set_location(' Leaving:'|| l_proc, 20);
504: --
505: return l_legislation_code;
506: --
507: end return_legislation_code;