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_HSR_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_hsr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_hrly_slrd_rt_id => p_hrly_slrd_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_hrly_slrd_rt_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_hsr_shd.api_updating
118: (p_hrly_slrd_rt_id => p_hrly_slrd_rt_id,
119: p_effective_date => p_effective_date,

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

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --

Line 138: hr_utility.raise_error;

134: --
135: -- raise error as does not exist as lookup
136: --
137: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
138: hr_utility.raise_error;
139: --
140: end if;
141: --
142: end if;

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

140: end if;
141: --
142: end if;
143: --
144: hr_utility.set_location('Leaving:'||l_proc,10);
145: --
146: end chk_excld_flag;
147: --
148: -- ----------------------------------------------------------------------------

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

180: l_api_updating boolean;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: l_api_updating := ben_hsr_shd.api_updating
187: (p_hrly_slrd_rt_id => p_hrly_slrd_rt_id,
188: p_effective_date => p_effective_date,

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

202: p_effective_date => p_effective_date) then
203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --

Line 207: hr_utility.raise_error;

203: --
204: -- raise error as does not exist as lookup
205: --
206: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
207: hr_utility.raise_error;
208: --
209: end if;
210: --
211: end if;

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

209: end if;
210: --
211: end if;
212: --
213: hr_utility.set_location('Leaving:'||l_proc,10);
214: --
215: end chk_hrly_slrd_cd;
216:
217:

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

272: and p_validation_end_date >= effective_start_date;
273: --
274: BEGIN
275: --
276: hr_utility.set_location('Entering:'||l_proc, 5);
277: --
278: l_api_updating := ben_hsr_shd.api_updating
279: (p_hrly_slrd_rt_id => p_hrly_slrd_rt_id,
280: p_effective_date => p_effective_date,

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

299: end if;
300: close c_dup;
301: --
302: end if;
303: hr_utility.set_location('Leaving:'||l_proc,10);
304: --
305: END chk_dup_record;
306: --
307: -- added for Bug 5078478 .. add this procedure to check the duplicate seq no

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

355: and business_group_id + 0 = p_business_group_id
356: and ordr_num = p_ordr_num;
357: --
358: Begin
359: hr_utility.set_location('Entering:'||l_proc, 5);
360:
361: --
362: open c1;
363: fetch c1 into l_dummy;

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

367: fnd_message.raise_error;
368: end if;
369: close c1;
370: --
371: hr_utility.set_location('Leaving:'||l_proc, 15);
372: End chk_duplicate_ordr_num;
373:
374: --
375: -- ----------------------------------------------------------------------------

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

411: l_integrity_error Exception;
412: l_table_name all_tables.table_name%TYPE;
413: --
414: Begin
415: hr_utility.set_location('Entering:'||l_proc, 5);
416: --
417: -- Ensure that the p_datetrack_mode argument is not null
418: --
419: hr_api.mandatory_arg_error

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

450: End If;
451: --
452: End If;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 10);
455: Exception
456: When l_integrity_error Then
457: --
458: -- A referential integrity check was violated therefore

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

457: --
458: -- A referential integrity check was violated therefore
459: -- we must error
460: --
461: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
462: hr_utility.set_message_token('TABLE_NAME', l_table_name);
463: hr_utility.raise_error;
464: When Others Then
465: --

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

458: -- A referential integrity check was violated therefore
459: -- we must error
460: --
461: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
462: hr_utility.set_message_token('TABLE_NAME', l_table_name);
463: hr_utility.raise_error;
464: When Others Then
465: --
466: -- An unhandled or unexpected error has occurred which

Line 463: hr_utility.raise_error;

459: -- we must error
460: --
461: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
462: hr_utility.set_message_token('TABLE_NAME', l_table_name);
463: hr_utility.raise_error;
464: When Others Then
465: --
466: -- An unhandled or unexpected error has occurred which
467: -- we must report

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

465: --
466: -- An unhandled or unexpected error has occurred which
467: -- we must report
468: --
469: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
470: hr_utility.set_message_token('PROCEDURE', l_proc);
471: hr_utility.set_message_token('STEP','15');
472: hr_utility.raise_error;
473: End dt_update_validate;

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

466: -- An unhandled or unexpected error has occurred which
467: -- we must report
468: --
469: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
470: hr_utility.set_message_token('PROCEDURE', l_proc);
471: hr_utility.set_message_token('STEP','15');
472: hr_utility.raise_error;
473: End dt_update_validate;
474: --

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

467: -- we must report
468: --
469: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
470: hr_utility.set_message_token('PROCEDURE', l_proc);
471: hr_utility.set_message_token('STEP','15');
472: hr_utility.raise_error;
473: End dt_update_validate;
474: --
475: -- ----------------------------------------------------------------------------

Line 472: hr_utility.raise_error;

468: --
469: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
470: hr_utility.set_message_token('PROCEDURE', l_proc);
471: hr_utility.set_message_token('STEP','15');
472: hr_utility.raise_error;
473: End dt_update_validate;
474: --
475: -- ----------------------------------------------------------------------------
476: -- |--------------------------< dt_delete_validate >--------------------------|

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

517: l_rows_exist Exception;
518: l_table_name all_tables.table_name%TYPE;
519: --
520: Begin
521: hr_utility.set_location('Entering:'||l_proc, 5);
522: --
523: -- Ensure that the p_datetrack_mode argument is not null
524: --
525: hr_api.mandatory_arg_error

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

554: --
555: --
556: End If;
557: --
558: hr_utility.set_location(' Leaving:'||l_proc, 10);
559: Exception
560: When l_rows_exist Then
561: --
562: -- A referential integrity check was violated therefore

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

561: --
562: -- A referential integrity check was violated therefore
563: -- we must error
564: --
565: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
566: hr_utility.set_message_token('TABLE_NAME', l_table_name);
567: hr_utility.raise_error;
568: When Others Then
569: --

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

562: -- A referential integrity check was violated therefore
563: -- we must error
564: --
565: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
566: hr_utility.set_message_token('TABLE_NAME', l_table_name);
567: hr_utility.raise_error;
568: When Others Then
569: --
570: -- An unhandled or unexpected error has occurred which

Line 567: hr_utility.raise_error;

563: -- we must error
564: --
565: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
566: hr_utility.set_message_token('TABLE_NAME', l_table_name);
567: hr_utility.raise_error;
568: When Others Then
569: --
570: -- An unhandled or unexpected error has occurred which
571: -- we must report

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

569: --
570: -- An unhandled or unexpected error has occurred which
571: -- we must report
572: --
573: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE', l_proc);
575: hr_utility.set_message_token('STEP','15');
576: hr_utility.raise_error;
577: End dt_delete_validate;

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

570: -- An unhandled or unexpected error has occurred which
571: -- we must report
572: --
573: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE', l_proc);
575: hr_utility.set_message_token('STEP','15');
576: hr_utility.raise_error;
577: End dt_delete_validate;
578: --

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

571: -- we must report
572: --
573: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE', l_proc);
575: hr_utility.set_message_token('STEP','15');
576: hr_utility.raise_error;
577: End dt_delete_validate;
578: --
579: -- ----------------------------------------------------------------------------

Line 576: hr_utility.raise_error;

572: --
573: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
574: hr_utility.set_message_token('PROCEDURE', l_proc);
575: hr_utility.set_message_token('STEP','15');
576: hr_utility.raise_error;
577: End dt_delete_validate;
578: --
579: -- ----------------------------------------------------------------------------
580: -- |---------------------------< insert_validate >----------------------------|

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

588: --
589: l_proc varchar2(72) := g_package||'insert_validate';
590: --
591: Begin
592: hr_utility.set_location('Entering:'||l_proc, 5);
593: --
594: -- Call all supporting business operations
595: --
596: --

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

633: ,p_validation_end_date => p_validation_end_date
634: ,p_business_group_id => p_rec.business_group_id);
635:
636: --
637: hr_utility.set_location(' Leaving:'||l_proc, 10);
638: End insert_validate;
639: --
640: -- ----------------------------------------------------------------------------
641: -- |---------------------------< update_validate >----------------------------|

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

649: --
650: l_proc varchar2(72) := g_package||'update_validate';
651: --
652: Begin
653: hr_utility.set_location('Entering:'||l_proc, 5);
654: --
655: -- Call all supporting business operations
656: --
657: --

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

702: p_datetrack_mode => p_datetrack_mode,
703: p_validation_start_date => p_validation_start_date,
704: p_validation_end_date => p_validation_end_date);
705: --
706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: End update_validate;
708: --
709: -- ----------------------------------------------------------------------------
710: -- |---------------------------< delete_validate >----------------------------|

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

718: --
719: l_proc varchar2(72) := g_package||'delete_validate';
720: --
721: Begin
722: hr_utility.set_location('Entering:'||l_proc, 5);
723: --
724: -- Call all supporting business operations
725: --
726: dt_delete_validate

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

728: p_validation_start_date => p_validation_start_date,
729: p_validation_end_date => p_validation_end_date,
730: p_hrly_slrd_rt_id => p_rec.hrly_slrd_rt_id);
731: --
732: hr_utility.set_location(' Leaving:'||l_proc, 10);
733: End delete_validate;
734: --
735: --
736: -- ---------------------------------------------------------------------------

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

755: l_proc varchar2(72) := g_package||'return_legislation_code';
756: --
757: begin
758: --
759: hr_utility.set_location('Entering:'|| l_proc, 10);
760: --
761: -- Ensure that all the mandatory parameter are not null
762: --
763: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

773: close csr_leg_code;
774: --
775: -- The primary key is invalid therefore we must error
776: --
777: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
778: hr_utility.raise_error;
779: --
780: end if;
781: --

Line 778: hr_utility.raise_error;

774: --
775: -- The primary key is invalid therefore we must error
776: --
777: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
778: hr_utility.raise_error;
779: --
780: end if;
781: --
782: close csr_leg_code;

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

780: end if;
781: --
782: close csr_leg_code;
783: --
784: hr_utility.set_location(' Leaving:'|| l_proc, 20);
785: --
786: return l_legislation_code;
787: --
788: end return_legislation_code;