eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PEA_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_pea_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prtt_enrt_actn_id => p_prtt_enrt_actn_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_prtt_enrt_actn_id;
78: --
79: -- ----------------------------------------------------------------------------

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

117: where a.actn_typ_id = p_actn_typ_id;
118: --
119: Begin
120: --
121: hr_utility.set_location('Entering:'||l_proc,5);
122: --
123: l_api_updating := ben_pea_shd.api_updating
124: (p_prtt_enrt_actn_id => p_prtt_enrt_actn_id,
125: p_effective_date => p_effective_date,

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

149: close c1;
150: --
151: end if;
152: --
153: hr_utility.set_location('Leaving:'||l_proc,10);
154: --
155: End chk_actn_typ_id;
156: --
157: -- ----------------------------------------------------------------------------

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

193: l_integrity_error Exception;
194: l_table_name all_tables.table_name%TYPE;
195: --
196: Begin
197: hr_utility.set_location('Entering:'||l_proc, 5);
198: --
199: -- Ensure that the p_datetrack_mode argument is not null
200: --
201: hr_api.mandatory_arg_error

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

232: End If;
233: --
234: End If;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: Exception
238: When l_integrity_error Then
239: --
240: -- A referential integrity check was violated therefore

Line 243: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

239: --
240: -- A referential integrity check was violated therefore
241: -- we must error
242: --
243: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
244: hr_utility.set_message_token('TABLE_NAME', l_table_name);
245: hr_utility.raise_error;
246: When Others Then
247: --

Line 244: hr_utility.set_message_token('TABLE_NAME', l_table_name);

240: -- A referential integrity check was violated therefore
241: -- we must error
242: --
243: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
244: hr_utility.set_message_token('TABLE_NAME', l_table_name);
245: hr_utility.raise_error;
246: When Others Then
247: --
248: -- An unhandled or unexpected error has occurred which

Line 245: hr_utility.raise_error;

241: -- we must error
242: --
243: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
244: hr_utility.set_message_token('TABLE_NAME', l_table_name);
245: hr_utility.raise_error;
246: When Others Then
247: --
248: -- An unhandled or unexpected error has occurred which
249: -- we must report

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

247: --
248: -- An unhandled or unexpected error has occurred which
249: -- we must report
250: --
251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
252: hr_utility.set_message_token('PROCEDURE', l_proc);
253: hr_utility.set_message_token('STEP','15');
254: hr_utility.raise_error;
255: End dt_update_validate;

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

248: -- An unhandled or unexpected error has occurred which
249: -- we must report
250: --
251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
252: hr_utility.set_message_token('PROCEDURE', l_proc);
253: hr_utility.set_message_token('STEP','15');
254: hr_utility.raise_error;
255: End dt_update_validate;
256: --

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

249: -- we must report
250: --
251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
252: hr_utility.set_message_token('PROCEDURE', l_proc);
253: hr_utility.set_message_token('STEP','15');
254: hr_utility.raise_error;
255: End dt_update_validate;
256: --
257: -- ----------------------------------------------------------------------------

Line 254: hr_utility.raise_error;

250: --
251: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
252: hr_utility.set_message_token('PROCEDURE', l_proc);
253: hr_utility.set_message_token('STEP','15');
254: hr_utility.raise_error;
255: End dt_update_validate;
256: --
257: -- ----------------------------------------------------------------------------
258: -- |--------------------------< dt_delete_validate >--------------------------|

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

299: l_rows_exist Exception;
300: l_table_name all_tables.table_name%TYPE;
301: --
302: Begin
303: hr_utility.set_location('Entering:'||l_proc, 5);
304: --
305: -- Ensure that the p_datetrack_mode argument is not null
306: --
307: hr_api.mandatory_arg_error

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

362: End If;
363: --
364: End If;
365: --
366: hr_utility.set_location(' Leaving:'||l_proc, 10);
367: Exception
368: When l_rows_exist Then
369: --
370: -- A referential integrity check was violated therefore

Line 373: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');

369: --
370: -- A referential integrity check was violated therefore
371: -- we must error
372: --
373: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
374: hr_utility.set_message_token('TABLE_NAME', l_table_name);
375: hr_utility.raise_error;
376: When Others Then
377: --

Line 374: hr_utility.set_message_token('TABLE_NAME', l_table_name);

370: -- A referential integrity check was violated therefore
371: -- we must error
372: --
373: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
374: hr_utility.set_message_token('TABLE_NAME', l_table_name);
375: hr_utility.raise_error;
376: When Others Then
377: --
378: -- An unhandled or unexpected error has occurred which

Line 375: hr_utility.raise_error;

371: -- we must error
372: --
373: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
374: hr_utility.set_message_token('TABLE_NAME', l_table_name);
375: hr_utility.raise_error;
376: When Others Then
377: --
378: -- An unhandled or unexpected error has occurred which
379: -- we must report

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

377: --
378: -- An unhandled or unexpected error has occurred which
379: -- we must report
380: --
381: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
382: hr_utility.set_message_token('PROCEDURE', l_proc);
383: hr_utility.set_message_token('STEP','15');
384: hr_utility.raise_error;
385: End dt_delete_validate;

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

378: -- An unhandled or unexpected error has occurred which
379: -- we must report
380: --
381: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
382: hr_utility.set_message_token('PROCEDURE', l_proc);
383: hr_utility.set_message_token('STEP','15');
384: hr_utility.raise_error;
385: End dt_delete_validate;
386: --

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

379: -- we must report
380: --
381: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
382: hr_utility.set_message_token('PROCEDURE', l_proc);
383: hr_utility.set_message_token('STEP','15');
384: hr_utility.raise_error;
385: End dt_delete_validate;
386: --
387: -- ----------------------------------------------------------------------------

Line 384: hr_utility.raise_error;

380: --
381: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
382: hr_utility.set_message_token('PROCEDURE', l_proc);
383: hr_utility.set_message_token('STEP','15');
384: hr_utility.raise_error;
385: End dt_delete_validate;
386: --
387: -- ----------------------------------------------------------------------------
388: -- |---------------------------< insert_validate >----------------------------|

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

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

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

414: p_actn_typ_id => p_rec.actn_typ_id,
415: p_effective_date => p_effective_date,
416: p_object_version_number => p_rec.object_version_number);
417: --
418: hr_utility.set_location(' Leaving:'||l_proc, 10);
419: End insert_validate;
420: --
421: -- ----------------------------------------------------------------------------
422: -- |---------------------------< update_validate >----------------------------|

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

430: --
431: l_proc varchar2(72) := g_package||'update_validate';
432: --
433: Begin
434: hr_utility.set_location('Entering:'||l_proc, 5);
435: --
436: -- Call all supporting business operations
437: --
438: --

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

456: p_datetrack_mode => p_datetrack_mode,
457: p_validation_start_date => p_validation_start_date,
458: p_validation_end_date => p_validation_end_date);
459: --
460: hr_utility.set_location(' Leaving:'||l_proc, 10);
461: End update_validate;
462: --
463: -- ----------------------------------------------------------------------------
464: -- |---------------------------< delete_validate >----------------------------|

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

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

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

482: p_validation_start_date => p_validation_start_date,
483: p_validation_end_date => p_validation_end_date,
484: p_prtt_enrt_actn_id => p_rec.prtt_enrt_actn_id);
485: --
486: hr_utility.set_location(' Leaving:'||l_proc, 10);
487: End delete_validate;
488: --
489: --
490: -- ---------------------------------------------------------------------------

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

509: l_proc varchar2(72) := g_package||'return_legislation_code';
510: --
511: begin
512: --
513: hr_utility.set_location('Entering:'|| l_proc, 10);
514: --
515: -- Ensure that all the mandatory parameter are not null
516: --
517: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

527: close csr_leg_code;
528: --
529: -- The primary key is invalid therefore we must error
530: --
531: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
532: hr_utility.raise_error;
533: --
534: end if;
535: --

Line 532: hr_utility.raise_error;

528: --
529: -- The primary key is invalid therefore we must error
530: --
531: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
532: hr_utility.raise_error;
533: --
534: end if;
535: --
536: close csr_leg_code;

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

534: end if;
535: --
536: close csr_leg_code;
537: --
538: hr_utility.set_location(' Leaving:'|| l_proc, 20);
539: --
540: return l_legislation_code;
541: --
542: end return_legislation_code;