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_OUR_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_our_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_org_unit_rt_id => p_org_unit_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_org_unit_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_our_shd.api_updating
118: (p_org_unit_rt_id => p_org_unit_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 190: hr_utility.set_location('Entering:'||l_proc, 5);

186: --
187:
188: Begin
189: --
190: hr_utility.set_location('Entering:'||l_proc, 5);
191: --
192: if p_organization_id is not null then
193: open c1;
194: fetch c1 into l_dummy;

Line 196: hr_utility.set_message(801,'Org_Id_not_exist');

192: if p_organization_id is not null then
193: open c1;
194: fetch c1 into l_dummy;
195: if c1%notfound then
196: hr_utility.set_message(801,'Org_Id_not_exist');
197: hr_utility.raise_error;
198: end if;
199: close c1;
200: end if;

Line 197: hr_utility.raise_error;

193: open c1;
194: fetch c1 into l_dummy;
195: if c1%notfound then
196: hr_utility.set_message(801,'Org_Id_not_exist');
197: hr_utility.raise_error;
198: end if;
199: close c1;
200: end if;
201: --

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

198: end if;
199: close c1;
200: end if;
201: --
202: hr_utility.set_location('Leaving:'||l_proc, 10);
203: --
204: End chk_organization_id;
205: --
206: -- ----------------------------------------------------------------------------

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

259: and p_validation_end_date >= effective_start_date;
260: --
261: BEGIN
262: --
263: hr_utility.set_location('Entering:'||l_proc, 5);
264: --
265: l_api_updating := ben_our_shd.api_updating
266: (p_org_unit_rt_id => p_org_unit_rt_id,
267: p_effective_date => p_effective_date,

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

286: end if;
287: close c_dup;
288: --
289: end if;
290: hr_utility.set_location('Leaving:'||l_proc,10);
291: --
292: END chk_dup_record;
293: --
294:

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

343: and business_group_id + 0 = p_business_group_id
344: and ordr_num = p_ordr_num;
345: --
346: Begin
347: hr_utility.set_location('Entering:'||l_proc, 5);
348:
349: --
350: open c1;
351: fetch c1 into l_dummy;

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

355: fnd_message.raise_error;
356: end if;
357: close c1;
358: --
359: hr_utility.set_location('Leaving:'||l_proc, 15);
360: End chk_duplicate_ordr_num;
361:
362: --
363: -- ----------------------------------------------------------------------------

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

399: l_integrity_error Exception;
400: l_table_name all_tables.table_name%TYPE;
401: --
402: Begin
403: hr_utility.set_location('Entering:'||l_proc, 5);
404: --
405: -- Ensure that the p_datetrack_mode argument is not null
406: --
407: hr_api.mandatory_arg_error

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

438: End If;
439: --
440: End If;
441: --
442: hr_utility.set_location(' Leaving:'||l_proc, 10);
443: Exception
444: When l_integrity_error Then
445: --
446: -- 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_update_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_update_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_update_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_update_validate;
461: --
462: -- ----------------------------------------------------------------------------
463: -- |--------------------------< dt_delete_validate >--------------------------|

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

504: l_rows_exist Exception;
505: l_table_name all_tables.table_name%TYPE;
506: --
507: Begin
508: hr_utility.set_location('Entering:'||l_proc, 5);
509: --
510: -- Ensure that the p_datetrack_mode argument is not null
511: --
512: hr_api.mandatory_arg_error

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

541: --
542: --
543: End If;
544: --
545: hr_utility.set_location(' Leaving:'||l_proc, 10);
546: Exception
547: When l_rows_exist Then
548: --
549: -- A referential integrity check was violated therefore

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

548: --
549: -- A referential integrity check was violated therefore
550: -- we must error
551: --
552: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
553: hr_utility.set_message_token('TABLE_NAME', l_table_name);
554: hr_utility.raise_error;
555: When Others Then
556: --

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

549: -- A referential integrity check was violated therefore
550: -- we must error
551: --
552: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
553: hr_utility.set_message_token('TABLE_NAME', l_table_name);
554: hr_utility.raise_error;
555: When Others Then
556: --
557: -- An unhandled or unexpected error has occurred which

Line 554: hr_utility.raise_error;

550: -- we must error
551: --
552: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
553: hr_utility.set_message_token('TABLE_NAME', l_table_name);
554: hr_utility.raise_error;
555: When Others Then
556: --
557: -- An unhandled or unexpected error has occurred which
558: -- we must report

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

556: --
557: -- An unhandled or unexpected error has occurred which
558: -- we must report
559: --
560: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
561: hr_utility.set_message_token('PROCEDURE', l_proc);
562: hr_utility.set_message_token('STEP','15');
563: hr_utility.raise_error;
564: End dt_delete_validate;

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

557: -- An unhandled or unexpected error has occurred which
558: -- we must report
559: --
560: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
561: hr_utility.set_message_token('PROCEDURE', l_proc);
562: hr_utility.set_message_token('STEP','15');
563: hr_utility.raise_error;
564: End dt_delete_validate;
565: --

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

558: -- we must report
559: --
560: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
561: hr_utility.set_message_token('PROCEDURE', l_proc);
562: hr_utility.set_message_token('STEP','15');
563: hr_utility.raise_error;
564: End dt_delete_validate;
565: --
566: -- ----------------------------------------------------------------------------

Line 563: hr_utility.raise_error;

559: --
560: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
561: hr_utility.set_message_token('PROCEDURE', l_proc);
562: hr_utility.set_message_token('STEP','15');
563: hr_utility.raise_error;
564: End dt_delete_validate;
565: --
566: -- ----------------------------------------------------------------------------
567: -- |---------------------------< insert_validate >----------------------------|

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

575: --
576: l_proc varchar2(72) := g_package||'insert_validate';
577: --
578: Begin
579: hr_utility.set_location('Entering:'||l_proc, 5);
580: --
581: -- Call all supporting business operations
582: --
583: --

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

618: ,p_validation_end_date => p_validation_end_date
619: ,p_business_group_id => p_rec.business_group_id);
620:
621: --
622: hr_utility.set_location(' Leaving:'||l_proc, 10);
623: End insert_validate;
624: --
625: -- ----------------------------------------------------------------------------
626: -- |---------------------------< update_validate >----------------------------|

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

634: --
635: l_proc varchar2(72) := g_package||'update_validate';
636: --
637: Begin
638: hr_utility.set_location('Entering:'||l_proc, 5);
639: --
640: -- Call all supporting business operations
641: --
642: --

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

685: p_datetrack_mode => p_datetrack_mode,
686: p_validation_start_date => p_validation_start_date,
687: p_validation_end_date => p_validation_end_date);
688: --
689: hr_utility.set_location(' Leaving:'||l_proc, 10);
690: End update_validate;
691: --
692: -- ----------------------------------------------------------------------------
693: -- |---------------------------< delete_validate >----------------------------|

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

701: --
702: l_proc varchar2(72) := g_package||'delete_validate';
703: --
704: Begin
705: hr_utility.set_location('Entering:'||l_proc, 5);
706: --
707: -- Call all supporting business operations
708: --
709: dt_delete_validate

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

711: p_validation_start_date => p_validation_start_date,
712: p_validation_end_date => p_validation_end_date,
713: p_org_unit_rt_id => p_rec.org_unit_rt_id);
714: --
715: hr_utility.set_location(' Leaving:'||l_proc, 10);
716: End delete_validate;
717: --
718: --
719: -- ---------------------------------------------------------------------------

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

738: l_proc varchar2(72) := g_package||'return_legislation_code';
739: --
740: begin
741: --
742: hr_utility.set_location('Entering:'|| l_proc, 10);
743: --
744: -- Ensure that all the mandatory parameter are not null
745: --
746: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

756: close csr_leg_code;
757: --
758: -- The primary key is invalid therefore we must error
759: --
760: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
761: hr_utility.raise_error;
762: --
763: end if;
764: --

Line 761: hr_utility.raise_error;

757: --
758: -- The primary key is invalid therefore we must error
759: --
760: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
761: hr_utility.raise_error;
762: --
763: end if;
764: --
765: close csr_leg_code;

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

763: end if;
764: --
765: close csr_leg_code;
766: --
767: hr_utility.set_location(' Leaving:'|| l_proc, 20);
768: --
769: return l_legislation_code;
770: --
771: end return_legislation_code;