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_VPR_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_vpr_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_vrbl_rt_prfl_rl_id => p_vrbl_rt_prfl_rl_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_rt_prfl_rl_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_vpr_shd.api_updating
118: (p_vrbl_rt_prfl_rl_id => p_vrbl_rt_prfl_rl_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_drvbl_fctr_apls_flag;
147: --
148: -- |--------------------< chk_duplicate_ordr_to_aply_num >----------------------------|

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

187: and business_group_id + 0 = p_business_group_id
188: and ordr_to_aply_num = p_ordr_to_aply_num;
189: --
190: Begin
191: hr_utility.set_location('Entering:'||l_proc, 5);
192:
193: --
194: open c1;
195: fetch c1 into l_dummy;

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

199: fnd_message.raise_error;
200: end if;
201: close c1;
202: --
203: hr_utility.set_location('Leaving:'||l_proc, 15);
204: End chk_duplicate_ordr_to_aply_num;
205:
206: --
207: -- ----------------------------------------------------------------------------

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

257: and ff.effective_end_date;
258: --
259: Begin
260: --
261: hr_utility.set_location('Entering:'||l_proc, 5);
262: --
263: l_api_updating := ben_vpr_shd.api_updating
264: (p_vrbl_rt_prfl_rl_id => p_vrbl_rt_prfl_rl_id,
265: p_effective_date => p_effective_date,

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

292: close c1;
293: --
294: end if;
295: --
296: hr_utility.set_location('Leaving:'||l_proc,10);
297: --
298: end chk_formula_id;
299:
300: --

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

354: and p_validation_end_date >= effective_start_date;
355: --
356: BEGIN
357: --
358: hr_utility.set_location('Entering:'||l_proc, 5);
359: --
360: l_api_updating := ben_vpr_shd.api_updating
361: (p_vrbl_rt_prfl_rl_id => p_vrbl_rt_prfl_rl_id,
362: p_effective_date => p_effective_date,

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

381: end if;
382: close c_dup;
383: --
384: end if;
385: hr_utility.set_location('Leaving:'||l_proc,10);
386: --
387: END chk_dup_record;
388:
389: --

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

426: l_integrity_error Exception;
427: l_table_name all_tables.table_name%TYPE;
428: --
429: Begin
430: hr_utility.set_location('Entering:'||l_proc, 5);
431: --
432: -- Ensure that the p_datetrack_mode argument is not null
433: --
434: hr_api.mandatory_arg_error

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

465: End If;
466: --
467: End If;
468: --
469: hr_utility.set_location(' Leaving:'||l_proc, 10);
470: Exception
471: When l_integrity_error Then
472: --
473: -- A referential integrity check was violated therefore

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

479: --
480: -- An unhandled or unexpected error has occurred which
481: -- we must report
482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','15');
486: hr_utility.raise_error;
487: End dt_update_validate;

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

480: -- An unhandled or unexpected error has occurred which
481: -- we must report
482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','15');
486: hr_utility.raise_error;
487: End dt_update_validate;
488: --

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

481: -- we must report
482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','15');
486: hr_utility.raise_error;
487: End dt_update_validate;
488: --
489: -- ----------------------------------------------------------------------------

Line 486: hr_utility.raise_error;

482: --
483: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
484: hr_utility.set_message_token('PROCEDURE', l_proc);
485: hr_utility.set_message_token('STEP','15');
486: hr_utility.raise_error;
487: End dt_update_validate;
488: --
489: -- ----------------------------------------------------------------------------
490: -- |--------------------------< dt_delete_validate >--------------------------|

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

531: l_rows_exist Exception;
532: l_table_name all_tables.table_name%TYPE;
533: --
534: Begin
535: hr_utility.set_location('Entering:'||l_proc, 5);
536: --
537: -- Ensure that the p_datetrack_mode argument is not null
538: --
539: hr_api.mandatory_arg_error

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

568: --
569: --
570: End If;
571: --
572: hr_utility.set_location(' Leaving:'||l_proc, 10);
573: Exception
574: When l_rows_exist Then
575: --
576: -- A referential integrity check was violated therefore

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

575: --
576: -- A referential integrity check was violated therefore
577: -- we must error
578: --
579: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
580: hr_utility.set_message_token('TABLE_NAME', l_table_name);
581: hr_utility.raise_error;
582: When Others Then
583: --

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

576: -- A referential integrity check was violated therefore
577: -- we must error
578: --
579: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
580: hr_utility.set_message_token('TABLE_NAME', l_table_name);
581: hr_utility.raise_error;
582: When Others Then
583: --
584: -- An unhandled or unexpected error has occurred which

Line 581: hr_utility.raise_error;

577: -- we must error
578: --
579: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
580: hr_utility.set_message_token('TABLE_NAME', l_table_name);
581: hr_utility.raise_error;
582: When Others Then
583: --
584: -- An unhandled or unexpected error has occurred which
585: -- we must report

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

583: --
584: -- An unhandled or unexpected error has occurred which
585: -- we must report
586: --
587: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
588: hr_utility.set_message_token('PROCEDURE', l_proc);
589: hr_utility.set_message_token('STEP','15');
590: hr_utility.raise_error;
591: End dt_delete_validate;

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

584: -- An unhandled or unexpected error has occurred which
585: -- we must report
586: --
587: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
588: hr_utility.set_message_token('PROCEDURE', l_proc);
589: hr_utility.set_message_token('STEP','15');
590: hr_utility.raise_error;
591: End dt_delete_validate;
592: --

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

585: -- we must report
586: --
587: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
588: hr_utility.set_message_token('PROCEDURE', l_proc);
589: hr_utility.set_message_token('STEP','15');
590: hr_utility.raise_error;
591: End dt_delete_validate;
592: --
593: -- ----------------------------------------------------------------------------

Line 590: hr_utility.raise_error;

586: --
587: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
588: hr_utility.set_message_token('PROCEDURE', l_proc);
589: hr_utility.set_message_token('STEP','15');
590: hr_utility.raise_error;
591: End dt_delete_validate;
592: --
593: -- ----------------------------------------------------------------------------
594: -- |---------------------------< insert_validate >----------------------------|

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

602: --
603: l_proc varchar2(72) := g_package||'insert_validate';
604: --
605: Begin
606: hr_utility.set_location('Entering:'||l_proc, 5);
607: --
608: -- Call all supporting business operations
609: --
610: --

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

644: ,p_ordr_to_aply_num => p_rec.ordr_to_aply_num
645: ,p_effective_date => p_effective_date
646: ,p_business_group_id => p_rec.business_group_id);
647: --
648: hr_utility.set_location(' Leaving:'||l_proc, 10);
649: End insert_validate;
650: --
651: -- ----------------------------------------------------------------------------
652: -- |---------------------------< update_validate >----------------------------|

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

660: --
661: l_proc varchar2(72) := g_package||'update_validate';
662: --
663: Begin
664: hr_utility.set_location('Entering:'||l_proc, 5);
665: --
666: -- Call all supporting business operations
667: --
668: --

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

711: ,p_ordr_to_aply_num => p_rec.ordr_to_aply_num
712: ,p_effective_date => p_effective_date
713: ,p_business_group_id => p_rec.business_group_id);
714: --
715: hr_utility.set_location(' Leaving:'||l_proc, 10);
716: End update_validate;
717: --
718: -- ----------------------------------------------------------------------------
719: -- |---------------------------< delete_validate >----------------------------|

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

727: --
728: l_proc varchar2(72) := g_package||'delete_validate';
729: --
730: Begin
731: hr_utility.set_location('Entering:'||l_proc, 5);
732: --
733: -- Call all supporting business operations
734: --
735: dt_delete_validate

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

737: p_validation_start_date => p_validation_start_date,
738: p_validation_end_date => p_validation_end_date,
739: p_vrbl_rt_prfl_rl_id => p_rec.vrbl_rt_prfl_rl_id);
740: --
741: hr_utility.set_location(' Leaving:'||l_proc, 10);
742: End delete_validate;
743: --
744: --
745: -- ---------------------------------------------------------------------------

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

764: l_proc varchar2(72) := g_package||'return_legislation_code';
765: --
766: begin
767: --
768: hr_utility.set_location('Entering:'|| l_proc, 10);
769: --
770: -- Ensure that all the mandatory parameter are not null
771: --
772: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

782: close csr_leg_code;
783: --
784: -- The primary key is invalid therefore we must error
785: --
786: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
787: hr_utility.raise_error;
788: --
789: end if;
790: --

Line 787: hr_utility.raise_error;

783: --
784: -- The primary key is invalid therefore we must error
785: --
786: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
787: hr_utility.raise_error;
788: --
789: end if;
790: --
791: close csr_leg_code;

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

789: end if;
790: --
791: close csr_leg_code;
792: --
793: hr_utility.set_location(' Leaving:'|| l_proc, 20);
794: --
795: return l_legislation_code;
796: --
797: end return_legislation_code;