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_PBR_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_pbr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_py_bss_rt_id => p_py_bss_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_py_bss_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_pbr_shd.api_updating
118: (p_py_bss_rt_id => p_py_bss_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: and business_group_id = p_business_group_id;
181: --
182: Begin
183: --
184: hr_utility.set_location('Entering:'||l_proc, 5);
185: --
186: if p_pay_basis_id is not null then
187: open c1;
188: fetch c1 into l_dummy;

Line 190: hr_utility.set_message(801,'PayBasis_NotFound');

186: if p_pay_basis_id is not null then
187: open c1;
188: fetch c1 into l_dummy;
189: if c1%notfound then
190: hr_utility.set_message(801,'PayBasis_NotFound');
191: hr_utility.raise_error;
192: end if;
193: close c1;
194: end if;

Line 191: hr_utility.raise_error;

187: open c1;
188: fetch c1 into l_dummy;
189: if c1%notfound then
190: hr_utility.set_message(801,'PayBasis_NotFound');
191: hr_utility.raise_error;
192: end if;
193: close c1;
194: end if;
195: --

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

192: end if;
193: close c1;
194: end if;
195: --
196: hr_utility.set_location('Leaving:'||l_proc, 10);
197: --
198: End chk_pay_basis_id;
199: --
200: -- ----------------------------------------------------------------------------

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

253: and p_validation_end_date >= effective_start_date;
254: --
255: BEGIN
256: --
257: hr_utility.set_location('Entering:'||l_proc, 5);
258: --
259: l_api_updating := ben_pbr_shd.api_updating
260: (p_py_bss_rt_id => p_py_bss_rt_id,
261: p_effective_date => p_effective_date,

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

280: end if;
281: close c_dup;
282: --
283: end if;
284: hr_utility.set_location('Leaving:'||l_proc,10);
285: --
286: END chk_dup_record;
287:
288: --

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

337: and business_group_id + 0 = p_business_group_id
338: and ordr_num = p_ordr_num;
339: --
340: Begin
341: hr_utility.set_location('Entering:'||l_proc, 5);
342:
343: --
344: open c1;
345: fetch c1 into l_dummy;

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

349: fnd_message.raise_error;
350: end if;
351: close c1;
352: --
353: hr_utility.set_location('Leaving:'||l_proc, 15);
354: End chk_duplicate_ordr_num;
355:
356:
357:

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

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

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

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

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

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

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

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

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

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

Line 455: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

Line 550: hr_utility.raise_error;

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

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

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

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

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

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

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

Line 559: hr_utility.raise_error;

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

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

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

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

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

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

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

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

678: p_datetrack_mode => p_datetrack_mode,
679: p_validation_start_date => p_validation_start_date,
680: p_validation_end_date => p_validation_end_date);
681: --
682: hr_utility.set_location(' Leaving:'||l_proc, 10);
683: End update_validate;
684: --
685: -- ----------------------------------------------------------------------------
686: -- |---------------------------< delete_validate >----------------------------|

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

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

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

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

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

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

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

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

Line 754: hr_utility.raise_error;

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

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

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