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_SAR_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_sar_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_svc_area_rt_id => p_svc_area_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_svc_area_rt_id;
78:
79: --

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

141: --
142: --
143: Begin
144: --
145: hr_utility.set_location('Entering:'||l_proc,5);
146: --
147: l_api_updating := ben_sar_shd.api_updating
148: (p_svc_area_rt_id => p_svc_area_rt_id,
149: p_effective_date => p_effective_date,

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

189: --
190: --
191: end if;
192: --
193: hr_utility.set_location('Leaving:'||l_proc,10);
194: --
195: End chk_svc_area_id;
196: --
197:

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

238: and business_group_id + 0 = p_business_group_id
239: and ordr_num = p_ordr_num;
240: --
241: Begin
242: hr_utility.set_location('Entering:'||l_proc, 5);
243:
244: --
245: open c1;
246: fetch c1 into l_dummy;

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

250: fnd_message.raise_error;
251: end if;
252: close c1;
253: --
254: hr_utility.set_location('Leaving:'||l_proc, 15);
255: End chk_duplicate_ordr_num;
256:
257: --
258: -- ----------------------------------------------------------------------------

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

290: l_api_updating boolean;
291: --
292: Begin
293: --
294: hr_utility.set_location('Entering:'||l_proc, 5);
295: --
296: l_api_updating := ben_sar_shd.api_updating
297: (p_svc_area_rt_id => p_svc_area_rt_id,
298: p_effective_date => p_effective_date,

Line 316: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');

312: p_effective_date => p_effective_date) then
313: --
314: -- raise error as does not exist as lookup
315: --
316: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
317: hr_utility.raise_error;
318: --
319: end if;
320: --

Line 317: hr_utility.raise_error;

313: --
314: -- raise error as does not exist as lookup
315: --
316: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
317: hr_utility.raise_error;
318: --
319: end if;
320: --
321: end if;

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

319: end if;
320: --
321: end if;
322: --
323: hr_utility.set_location('Leaving:'||l_proc,10);
324: --
325: end chk_excld_flag;
326: --
327: -- ----------------------------------------------------------------------------

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

364: l_integrity_error Exception;
365: l_table_name all_tables.table_name%TYPE;
366: --
367: Begin
368: hr_utility.set_location('Entering:'||l_proc, 5);
369: --
370: -- Ensure that the p_datetrack_mode argument is not null
371: --
372: hr_api.mandatory_arg_error

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

413: End If;
414: --
415: End If;
416: --
417: hr_utility.set_location(' Leaving:'||l_proc, 10);
418: Exception
419: When l_integrity_error Then
420: --
421: -- A referential integrity check was violated therefore

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

420: --
421: -- A referential integrity check was violated therefore
422: -- we must error
423: --
424: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
425: hr_utility.set_message_token('TABLE_NAME', l_table_name);
426: hr_utility.raise_error;
427: When Others Then
428: --

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

421: -- A referential integrity check was violated therefore
422: -- we must error
423: --
424: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
425: hr_utility.set_message_token('TABLE_NAME', l_table_name);
426: hr_utility.raise_error;
427: When Others Then
428: --
429: -- An unhandled or unexpected error has occurred which

Line 426: hr_utility.raise_error;

422: -- we must error
423: --
424: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
425: hr_utility.set_message_token('TABLE_NAME', l_table_name);
426: hr_utility.raise_error;
427: When Others Then
428: --
429: -- An unhandled or unexpected error has occurred which
430: -- we must report

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

428: --
429: -- An unhandled or unexpected error has occurred which
430: -- we must report
431: --
432: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
433: hr_utility.set_message_token('PROCEDURE', l_proc);
434: hr_utility.set_message_token('STEP','15');
435: hr_utility.raise_error;
436: End dt_update_validate;

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

429: -- An unhandled or unexpected error has occurred which
430: -- we must report
431: --
432: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
433: hr_utility.set_message_token('PROCEDURE', l_proc);
434: hr_utility.set_message_token('STEP','15');
435: hr_utility.raise_error;
436: End dt_update_validate;
437: --

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

430: -- we must report
431: --
432: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
433: hr_utility.set_message_token('PROCEDURE', l_proc);
434: hr_utility.set_message_token('STEP','15');
435: hr_utility.raise_error;
436: End dt_update_validate;
437: --
438: -- ----------------------------------------------------------------------------

Line 435: hr_utility.raise_error;

431: --
432: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
433: hr_utility.set_message_token('PROCEDURE', l_proc);
434: hr_utility.set_message_token('STEP','15');
435: hr_utility.raise_error;
436: End dt_update_validate;
437: --
438: -- ----------------------------------------------------------------------------
439: -- |--------------------------< dt_delete_validate >--------------------------|

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

480: l_rows_exist Exception;
481: l_table_name all_tables.table_name%TYPE;
482: --
483: Begin
484: hr_utility.set_location('Entering:'||l_proc, 5);
485: --
486: -- Ensure that the p_datetrack_mode argument is not null
487: --
488: hr_api.mandatory_arg_error

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

517: --
518: --
519: End If;
520: --
521: hr_utility.set_location(' Leaving:'||l_proc, 10);
522: Exception
523: When l_rows_exist Then
524: --
525: -- A referential integrity check was violated therefore

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

524: --
525: -- A referential integrity check was violated therefore
526: -- we must error
527: --
528: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
529: hr_utility.set_message_token('TABLE_NAME', l_table_name);
530: hr_utility.raise_error;
531: When Others Then
532: --

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

525: -- A referential integrity check was violated therefore
526: -- we must error
527: --
528: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
529: hr_utility.set_message_token('TABLE_NAME', l_table_name);
530: hr_utility.raise_error;
531: When Others Then
532: --
533: -- An unhandled or unexpected error has occurred which

Line 530: hr_utility.raise_error;

526: -- we must error
527: --
528: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
529: hr_utility.set_message_token('TABLE_NAME', l_table_name);
530: hr_utility.raise_error;
531: When Others Then
532: --
533: -- An unhandled or unexpected error has occurred which
534: -- we must report

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

532: --
533: -- An unhandled or unexpected error has occurred which
534: -- we must report
535: --
536: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
537: hr_utility.set_message_token('PROCEDURE', l_proc);
538: hr_utility.set_message_token('STEP','15');
539: hr_utility.raise_error;
540: End dt_delete_validate;

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

533: -- An unhandled or unexpected error has occurred which
534: -- we must report
535: --
536: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
537: hr_utility.set_message_token('PROCEDURE', l_proc);
538: hr_utility.set_message_token('STEP','15');
539: hr_utility.raise_error;
540: End dt_delete_validate;
541: --

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

534: -- we must report
535: --
536: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
537: hr_utility.set_message_token('PROCEDURE', l_proc);
538: hr_utility.set_message_token('STEP','15');
539: hr_utility.raise_error;
540: End dt_delete_validate;
541: --
542: -- ----------------------------------------------------------------------------

Line 539: hr_utility.raise_error;

535: --
536: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
537: hr_utility.set_message_token('PROCEDURE', l_proc);
538: hr_utility.set_message_token('STEP','15');
539: hr_utility.raise_error;
540: End dt_delete_validate;
541: --
542: -- ----------------------------------------------------------------------------
543: -- |---------------------------< insert_validate >----------------------------|

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

551: --
552: l_proc varchar2(72) := g_package||'insert_validate';
553: --
554: Begin
555: hr_utility.set_location('Entering:'||l_proc, 5);
556: --
557: -- Call all supporting business operations
558: --
559: --

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

586: ,p_effective_date => p_effective_date
587: ,p_business_group_id => p_rec.business_group_id
588: ,p_svc_area_rt_id => p_rec.svc_area_rt_id);
589: --
590: hr_utility.set_location(' Leaving:'||l_proc, 10);
591: End insert_validate;
592: --
593: -- ----------------------------------------------------------------------------
594: -- |---------------------------< update_validate >----------------------------|

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

602: --
603: l_proc varchar2(72) := g_package||'update_validate';
604: --
605: Begin
606: hr_utility.set_location('Entering:'||l_proc, 5);
607: --
608: -- Call all supporting business operations
609: --
610: --

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

646: ,p_effective_date => p_effective_date
647: ,p_business_group_id => p_rec.business_group_id
648: , p_svc_area_rt_id => p_rec.svc_area_rt_id);
649: --
650: hr_utility.set_location(' Leaving:'||l_proc, 10);
651: End update_validate;
652: --
653: -- ----------------------------------------------------------------------------
654: -- |---------------------------< delete_validate >----------------------------|

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

662: --
663: l_proc varchar2(72) := g_package||'delete_validate';
664: --
665: Begin
666: hr_utility.set_location('Entering:'||l_proc, 5);
667: --
668: -- Call all supporting business operations
669: --
670: dt_delete_validate

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

672: p_validation_start_date => p_validation_start_date,
673: p_validation_end_date => p_validation_end_date,
674: p_svc_area_rt_id => p_rec.svc_area_rt_id);
675: --
676: hr_utility.set_location(' Leaving:'||l_proc, 10);
677: End delete_validate;
678: --
679: --
680: -- ---------------------------------------------------------------------------

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

699: l_proc varchar2(72) := g_package||'return_legislation_code';
700: --
701: begin
702: --
703: hr_utility.set_location('Entering:'|| l_proc, 10);
704: --
705: -- Ensure that all the mandatory parameter are not null
706: --
707: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

717: close csr_leg_code;
718: --
719: -- The primary key is invalid therefore we must error
720: --
721: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
722: hr_utility.raise_error;
723: --
724: end if;
725: --

Line 722: hr_utility.raise_error;

718: --
719: -- The primary key is invalid therefore we must error
720: --
721: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
722: hr_utility.raise_error;
723: --
724: end if;
725: --
726: close csr_leg_code;

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

724: end if;
725: --
726: close csr_leg_code;
727: --
728: hr_utility.set_location(' Leaving:'|| l_proc, 20);
729: --
730: return l_legislation_code;
731: --
732: end return_legislation_code;