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_GRR_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_grr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_grade_rt_id => p_grade_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_grade_rt_id;
78: --
79: -- ----------------------------------------------------------------------------

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

116: and business_group_id = p_business_group_id;
117: --
118: Begin
119: --
120: hr_utility.set_location('Entering:'||l_proc, 5);
121: --
122: if p_grade_id is not null then
123: open c1;
124: fetch c1 into l_dummy;

Line 126: hr_utility.set_message(801,'Grade_Id_not_exist');

122: if p_grade_id is not null then
123: open c1;
124: fetch c1 into l_dummy;
125: if c1%notfound then
126: hr_utility.set_message(801,'Grade_Id_not_exist');
127: hr_utility.raise_error;
128: end if;
129: close c1;
130: end if;

Line 127: hr_utility.raise_error;

123: open c1;
124: fetch c1 into l_dummy;
125: if c1%notfound then
126: hr_utility.set_message(801,'Grade_Id_not_exist');
127: hr_utility.raise_error;
128: end if;
129: close c1;
130: end if;
131: --

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

128: end if;
129: close c1;
130: end if;
131: --
132: hr_utility.set_location('Leaving:'||l_proc, 10);
133: --
134: End chk_grade_id;
135:
136: --

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

190: and p_validation_end_date >= effective_start_date;
191: --
192: BEGIN
193: --
194: hr_utility.set_location('Entering:'||l_proc, 5);
195: --
196: l_api_updating := ben_grr_shd.api_updating
197: (p_grade_rt_id => p_grade_rt_id,
198: p_effective_date => p_effective_date,

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

217: end if;
218: close c_dup;
219: --
220: end if;
221: hr_utility.set_location('Leaving:'||l_proc,10);
222: --
223: END chk_dup_record;
224:
225: --

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

265: and business_group_id + 0 = p_business_group_id
266: and ordr_num = p_ordr_num;
267: --
268: Begin
269: hr_utility.set_location('Entering:'||l_proc, 5);
270:
271: --
272: open c1;
273: fetch c1 into l_dummy;

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

277: fnd_message.raise_error;
278: end if;
279: close c1;
280: --
281: hr_utility.set_location('Leaving:'||l_proc, 15);
282: End chk_duplicate_ordr_num;
283:
284:
285:

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

324: l_api_updating boolean;
325: --
326: Begin
327: --
328: hr_utility.set_location('Entering:'||l_proc, 5);
329: --
330: l_api_updating := ben_grr_shd.api_updating
331: (p_grade_rt_id => p_grade_rt_id,
332: p_effective_date => p_effective_date,

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

346: p_effective_date => p_effective_date) then
347: --
348: -- raise error as does not exist as lookup
349: --
350: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
351: hr_utility.raise_error;
352: --
353: end if;
354: --

Line 351: hr_utility.raise_error;

347: --
348: -- raise error as does not exist as lookup
349: --
350: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
351: hr_utility.raise_error;
352: --
353: end if;
354: --
355: end if;

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

353: end if;
354: --
355: end if;
356: --
357: hr_utility.set_location('Leaving:'||l_proc,10);
358: --
359: end chk_excld_flag;
360: --
361: -- ----------------------------------------------------------------------------

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

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

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

436: End If;
437: --
438: End If;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 10);
441: Exception
442: When l_integrity_error Then
443: --
444: -- A referential integrity check was violated therefore

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

450: --
451: -- An unhandled or unexpected error has occurred which
452: -- we must report
453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','15');
457: hr_utility.raise_error;
458: End dt_update_validate;

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

451: -- An unhandled or unexpected error has occurred which
452: -- we must report
453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','15');
457: hr_utility.raise_error;
458: End dt_update_validate;
459: --

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

452: -- we must report
453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','15');
457: hr_utility.raise_error;
458: End dt_update_validate;
459: --
460: -- ----------------------------------------------------------------------------

Line 457: hr_utility.raise_error;

453: --
454: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
455: hr_utility.set_message_token('PROCEDURE', l_proc);
456: hr_utility.set_message_token('STEP','15');
457: hr_utility.raise_error;
458: End dt_update_validate;
459: --
460: -- ----------------------------------------------------------------------------
461: -- |--------------------------< dt_delete_validate >--------------------------|

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

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

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

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

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

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

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

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

Line 552: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 561: hr_utility.raise_error;

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

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

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

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

613: ,p_effective_date => p_effective_date
614: ,p_business_group_id => p_rec.business_group_id
615: ,p_grade_rt_id => p_rec.grade_rt_id);
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 10);
618: End insert_validate;
619: --
620: -- ----------------------------------------------------------------------------
621: -- |---------------------------< update_validate >----------------------------|

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

629: --
630: l_proc varchar2(72) := g_package||'update_validate';
631: --
632: Begin
633: hr_utility.set_location('Entering:'||l_proc, 5);
634: --
635: -- Call all supporting business operations
636: --
637: --

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

677: ,p_effective_date => p_effective_date
678: ,p_business_group_id => p_rec.business_group_id
679: ,p_grade_rt_id => p_rec.grade_rt_id);
680: --
681: hr_utility.set_location(' Leaving:'||l_proc, 10);
682: End update_validate;
683: --
684: -- ----------------------------------------------------------------------------
685: -- |---------------------------< delete_validate >----------------------------|

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

693: --
694: l_proc varchar2(72) := g_package||'delete_validate';
695: --
696: Begin
697: hr_utility.set_location('Entering:'||l_proc, 5);
698: --
699: -- Call all supporting business operations
700: --
701: dt_delete_validate

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

703: p_validation_start_date => p_validation_start_date,
704: p_validation_end_date => p_validation_end_date,
705: p_grade_rt_id => p_rec.grade_rt_id);
706: --
707: hr_utility.set_location(' Leaving:'||l_proc, 10);
708: End delete_validate;
709: --
710: --
711: -- ---------------------------------------------------------------------------

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

730: l_proc varchar2(72) := g_package||'return_legislation_code';
731: --
732: begin
733: --
734: hr_utility.set_location('Entering:'|| l_proc, 10);
735: --
736: -- Ensure that all the mandatory parameter are not null
737: --
738: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

748: close csr_leg_code;
749: --
750: -- The primary key is invalid therefore we must error
751: --
752: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
753: hr_utility.raise_error;
754: --
755: end if;
756: --

Line 753: hr_utility.raise_error;

749: --
750: -- The primary key is invalid therefore we must error
751: --
752: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
753: hr_utility.raise_error;
754: --
755: end if;
756: --
757: close csr_leg_code;

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

755: end if;
756: --
757: close csr_leg_code;
758: --
759: hr_utility.set_location(' Leaving:'|| l_proc, 20);
760: --
761: return l_legislation_code;
762: --
763: end return_legislation_code;