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_VMR_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_vmr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_vrbl_mtchg_rt_id => p_vrbl_mtchg_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_vrbl_mtchg_rt_id;
78: --
79: -- |--------------------< chk_duplicate_ordr_num >----------------------------|

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

117: and business_group_id + 0 = p_business_group_id
118: and ordr_num = p_ordr_num;
119: --
120: Begin
121: hr_utility.set_location('Entering:'||l_proc, 5);
122:
123: --
124: open c1;
125: fetch c1 into l_dummy;

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

129: fnd_message.raise_error;
130: end if;
131: close c1;
132: --
133: hr_utility.set_location('Leaving:'||l_proc, 15);
134: End chk_duplicate_ordr_num;
135:
136: --
137: -- ----------------------------------------------------------------------------

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

169: l_api_updating boolean;
170: --
171: Begin
172: --
173: hr_utility.set_location('Entering:'||l_proc, 5);
174: --
175: l_api_updating := ben_vmr_shd.api_updating
176: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
177: p_effective_date => p_effective_date,

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

191: p_effective_date => p_effective_date) then
192: --
193: -- raise error as does not exist as lookup
194: --
195: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
196: hr_utility.raise_error;
197: --
198: end if;
199: --

Line 196: hr_utility.raise_error;

192: --
193: -- raise error as does not exist as lookup
194: --
195: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
196: hr_utility.raise_error;
197: --
198: end if;
199: --
200: end if;

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

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

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

238: l_api_updating boolean;
239: --
240: Begin
241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: l_api_updating := ben_vmr_shd.api_updating
245: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
246: p_effective_date => p_effective_date,

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

260: p_effective_date => p_effective_date) then
261: --
262: -- raise error as does not exist as lookup
263: --
264: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
265: hr_utility.raise_error;
266: --
267: end if;
268: --

Line 265: hr_utility.raise_error;

261: --
262: -- raise error as does not exist as lookup
263: --
264: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
265: hr_utility.raise_error;
266: --
267: end if;
268: --
269: end if;

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

267: end if;
268: --
269: end if;
270: --
271: hr_utility.set_location('Leaving:'||l_proc,10);
272: --
273: end chk_no_mx_pct_of_py_num_flag;
274: --
275: -- ----------------------------------------------------------------------------

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

307: l_api_updating boolean;
308: --
309: Begin
310: --
311: hr_utility.set_location('Entering:'||l_proc, 5);
312: --
313: l_api_updating := ben_vmr_shd.api_updating
314: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
315: p_effective_date => p_effective_date,

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

329: p_effective_date => p_effective_date) then
330: --
331: -- raise error as does not exist as lookup
332: --
333: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
334: hr_utility.raise_error;
335: --
336: end if;
337: --

Line 334: hr_utility.raise_error;

330: --
331: -- raise error as does not exist as lookup
332: --
333: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
334: hr_utility.raise_error;
335: --
336: end if;
337: --
338: end if;

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

336: end if;
337: --
338: end if;
339: --
340: hr_utility.set_location('Leaving:'||l_proc,10);
341: --
342: end chk_cntnu_mtch_aftr_max_rl_fg;
343: --
344: -- ----------------------------------------------------------------------------

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

393: and ff.effective_end_date;
394: --
395: Begin
396: --
397: hr_utility.set_location('Entering:'||l_proc, 5);
398: --
399: l_api_updating := ben_vmr_shd.api_updating
400: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
401: p_effective_date => p_effective_date,

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

432: close c1;
433: --
434: end if;
435: --
436: hr_utility.set_location('Leaving:'||l_proc,10);
437: --
438: end chk_mtchg_rt_calc_rl;
439: --
440: -- ----------------------------------------------------------------------------

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

472: l_api_updating boolean;
473: --
474: Begin
475: --
476: hr_utility.set_location('Entering:'||l_proc, 5);
477: --
478: l_api_updating := ben_vmr_shd.api_updating
479: (p_vrbl_mtchg_rt_id => p_vrbl_mtchg_rt_id,
480: p_effective_date => p_effective_date,

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

494: p_effective_date => p_effective_date) then
495: --
496: -- raise error as does not exist as lookup
497: --
498: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
499: hr_utility.raise_error;
500: --
501: end if;
502: --

Line 499: hr_utility.raise_error;

495: --
496: -- raise error as does not exist as lookup
497: --
498: hr_utility.set_message(801,'HR_LOOKUP_DOES_NOT_EXIST');
499: hr_utility.raise_error;
500: --
501: end if;
502: --
503: end if;

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

501: end if;
502: --
503: end if;
504: --
505: hr_utility.set_location('Leaving:'||l_proc,10);
506: --
507: end chk_no_mx_mtch_amt_flag;
508: --
509: -- ----------------------------------------------------------------------------

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

545: l_integrity_error Exception;
546: l_table_name all_tables.table_name%TYPE;
547: --
548: Begin
549: hr_utility.set_location('Entering:'||l_proc, 5);
550: --
551: -- Ensure that the p_datetrack_mode argument is not null
552: --
553: hr_api.mandatory_arg_error

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

584: End If;
585: --
586: End If;
587: --
588: hr_utility.set_location(' Leaving:'||l_proc, 10);
589: Exception
590: When l_integrity_error Then
591: --
592: -- A referential integrity check was violated therefore

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

591: --
592: -- A referential integrity check was violated therefore
593: -- we must error
594: --
595: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
596: hr_utility.set_message_token('TABLE_NAME', l_table_name);
597: hr_utility.raise_error;
598: When Others Then
599: --

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

592: -- A referential integrity check was violated therefore
593: -- we must error
594: --
595: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
596: hr_utility.set_message_token('TABLE_NAME', l_table_name);
597: hr_utility.raise_error;
598: When Others Then
599: --
600: -- An unhandled or unexpected error has occurred which

Line 597: hr_utility.raise_error;

593: -- we must error
594: --
595: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
596: hr_utility.set_message_token('TABLE_NAME', l_table_name);
597: hr_utility.raise_error;
598: When Others Then
599: --
600: -- An unhandled or unexpected error has occurred which
601: -- we must report

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

599: --
600: -- An unhandled or unexpected error has occurred which
601: -- we must report
602: --
603: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
604: hr_utility.set_message_token('PROCEDURE', l_proc);
605: hr_utility.set_message_token('STEP','15');
606: hr_utility.raise_error;
607: End dt_update_validate;

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

600: -- An unhandled or unexpected error has occurred which
601: -- we must report
602: --
603: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
604: hr_utility.set_message_token('PROCEDURE', l_proc);
605: hr_utility.set_message_token('STEP','15');
606: hr_utility.raise_error;
607: End dt_update_validate;
608: --

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

601: -- we must report
602: --
603: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
604: hr_utility.set_message_token('PROCEDURE', l_proc);
605: hr_utility.set_message_token('STEP','15');
606: hr_utility.raise_error;
607: End dt_update_validate;
608: --
609: -- ----------------------------------------------------------------------------

Line 606: hr_utility.raise_error;

602: --
603: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
604: hr_utility.set_message_token('PROCEDURE', l_proc);
605: hr_utility.set_message_token('STEP','15');
606: hr_utility.raise_error;
607: End dt_update_validate;
608: --
609: -- ----------------------------------------------------------------------------
610: -- |--------------------------< dt_delete_validate >--------------------------|

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

651: l_rows_exist Exception;
652: l_table_name all_tables.table_name%TYPE;
653: --
654: Begin
655: hr_utility.set_location('Entering:'||l_proc, 5);
656: --
657: -- Ensure that the p_datetrack_mode argument is not null
658: --
659: hr_api.mandatory_arg_error

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

688: --
689: --
690: End If;
691: --
692: hr_utility.set_location(' Leaving:'||l_proc, 10);
693: Exception
694: When l_rows_exist Then
695: --
696: -- A referential integrity check was violated therefore

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

695: --
696: -- A referential integrity check was violated therefore
697: -- we must error
698: --
699: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
700: hr_utility.set_message_token('TABLE_NAME', l_table_name);
701: hr_utility.raise_error;
702: When Others Then
703: --

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

696: -- A referential integrity check was violated therefore
697: -- we must error
698: --
699: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
700: hr_utility.set_message_token('TABLE_NAME', l_table_name);
701: hr_utility.raise_error;
702: When Others Then
703: --
704: -- An unhandled or unexpected error has occurred which

Line 701: hr_utility.raise_error;

697: -- we must error
698: --
699: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
700: hr_utility.set_message_token('TABLE_NAME', l_table_name);
701: hr_utility.raise_error;
702: When Others Then
703: --
704: -- An unhandled or unexpected error has occurred which
705: -- we must report

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

703: --
704: -- An unhandled or unexpected error has occurred which
705: -- we must report
706: --
707: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE', l_proc);
709: hr_utility.set_message_token('STEP','15');
710: hr_utility.raise_error;
711: End dt_delete_validate;

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

704: -- An unhandled or unexpected error has occurred which
705: -- we must report
706: --
707: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE', l_proc);
709: hr_utility.set_message_token('STEP','15');
710: hr_utility.raise_error;
711: End dt_delete_validate;
712: --

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

705: -- we must report
706: --
707: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE', l_proc);
709: hr_utility.set_message_token('STEP','15');
710: hr_utility.raise_error;
711: End dt_delete_validate;
712: --
713: -- ----------------------------------------------------------------------------

Line 710: hr_utility.raise_error;

706: --
707: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
708: hr_utility.set_message_token('PROCEDURE', l_proc);
709: hr_utility.set_message_token('STEP','15');
710: hr_utility.raise_error;
711: End dt_delete_validate;
712: --
713: -- ----------------------------------------------------------------------------
714: -- |---------------------------< insert_validate >----------------------------|

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

722: --
723: l_proc varchar2(72) := g_package||'insert_validate';
724: --
725: Begin
726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- Call all supporting business operations
729: --
730: --

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

771: ,p_ordr_num => p_rec.ordr_num
772: ,p_effective_date => p_effective_date
773: ,p_business_group_id => p_rec.business_group_id);
774: --
775: hr_utility.set_location(' Leaving:'||l_proc, 10);
776: End insert_validate;
777: --
778: -- ----------------------------------------------------------------------------
779: -- |---------------------------< update_validate >----------------------------|

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

787: --
788: l_proc varchar2(72) := g_package||'update_validate';
789: --
790: Begin
791: hr_utility.set_location('Entering:'||l_proc, 5);
792: --
793: -- Call all supporting business operations
794: --
795: --

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

844: ,p_ordr_num => p_rec.ordr_num
845: ,p_effective_date => p_effective_date
846: ,p_business_group_id => p_rec.business_group_id);
847: --
848: hr_utility.set_location(' Leaving:'||l_proc, 10);
849: End update_validate;
850: --
851: -- ----------------------------------------------------------------------------
852: -- |---------------------------< delete_validate >----------------------------|

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

860: --
861: l_proc varchar2(72) := g_package||'delete_validate';
862: --
863: Begin
864: hr_utility.set_location('Entering:'||l_proc, 5);
865: --
866: -- Call all supporting business operations
867: --
868: dt_delete_validate

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

870: p_validation_start_date => p_validation_start_date,
871: p_validation_end_date => p_validation_end_date,
872: p_vrbl_mtchg_rt_id => p_rec.vrbl_mtchg_rt_id);
873: --
874: hr_utility.set_location(' Leaving:'||l_proc, 10);
875: End delete_validate;
876: --
877: --
878: -- ---------------------------------------------------------------------------

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

897: l_proc varchar2(72) := g_package||'return_legislation_code';
898: --
899: begin
900: --
901: hr_utility.set_location('Entering:'|| l_proc, 10);
902: --
903: -- Ensure that all the mandatory parameter are not null
904: --
905: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

915: close csr_leg_code;
916: --
917: -- The primary key is invalid therefore we must error
918: --
919: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
920: hr_utility.raise_error;
921: --
922: end if;
923: --

Line 920: hr_utility.raise_error;

916: --
917: -- The primary key is invalid therefore we must error
918: --
919: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
920: hr_utility.raise_error;
921: --
922: end if;
923: --
924: close csr_leg_code;

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

922: end if;
923: --
924: close csr_leg_code;
925: --
926: hr_utility.set_location(' Leaving:'|| l_proc, 20);
927: --
928: return l_legislation_code;
929: --
930: end return_legislation_code;