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_CER_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_cer_shd.api_updating
49: (p_effective_date => p_effective_date,
50: p_prtn_eligy_rl_id => p_prtn_eligy_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_prtn_eligy_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_cer_shd.api_updating
118: (p_prtn_eligy_rl_id => p_prtn_eligy_rl_id,
119: p_effective_date => p_effective_date,

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

142: end if;
143: --
144: end if;
145: --
146: hr_utility.set_location('Leaving:'||l_proc,10);
147: --
148: end chk_mndtry_flag;
149: --
150: -- ----------------------------------------------------------------------------

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

182: l_api_updating boolean;
183: --
184: Begin
185: --
186: hr_utility.set_location('Entering:'||l_proc, 5);
187: --
188: l_api_updating := ben_cer_shd.api_updating
189: (p_prtn_eligy_rl_id => p_prtn_eligy_rl_id,
190: p_effective_date => p_effective_date,

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

213: end if;
214: --
215: end if;
216: --
217: hr_utility.set_location('Leaving:'||l_proc,10);
218: --
219: end chk_drvbl_fctr_apls_flag;
220: --
221: --

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

270: and ff.effective_end_date;
271: --
272: Begin
273: --
274: hr_utility.set_location('Entering:'||l_proc, 5);
275: --
276: l_api_updating := ben_cer_shd.api_updating
277: (p_prtn_eligy_rl_id => p_prtn_eligy_rl_id,
278: p_effective_date => p_effective_date,

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

308: close c1;
309: --
310: end if;
311: --
312: hr_utility.set_location('Leaving:'||l_proc,10);
313: --
314: end chk_formula_id;
315: --
316: -- ----------------------------------------------------------------------------

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

359: and effective_end_date;
360: --
361: Begin
362: --
363: hr_utility.set_location('Entering:'||l_proc, 5);
364: --
365: open c1;
366: fetch c1 into l_dummy;
367: if c1%found then

Line 369: hr_utility.set_message(801,'Duplicate sequence#');

365: open c1;
366: fetch c1 into l_dummy;
367: if c1%found then
368: close c1;
369: hr_utility.set_message(801,'Duplicate sequence#');
370: hr_utility.raise_error;
371: end if;
372: close c1;
373: --

Line 370: hr_utility.raise_error;

366: fetch c1 into l_dummy;
367: if c1%found then
368: close c1;
369: hr_utility.set_message(801,'Duplicate sequence#');
370: hr_utility.raise_error;
371: end if;
372: close c1;
373: --
374: hr_utility.set_location('Leaving:'||l_proc, 15);

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

370: hr_utility.raise_error;
371: end if;
372: close c1;
373: --
374: hr_utility.set_location('Leaving:'||l_proc, 15);
375: --
376: End chk_duplicate_ordr_num;
377: --
378: -- bug 3876692

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

437: and plip.effective_end_date;
438: --
439: Begin
440: --
441: hr_utility.set_location('Entering:'||l_proc,5);
442: --
443: open c1;
444: fetch c1 into l_exists;
445: if c1%found then

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

469: close c2;
470: --
471: end if;
472: --
473: hr_utility.set_location('Leaving:'||l_proc,10);
474: --
475: End chk_flx_impt_extnce;
476: --
477: --

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

514: l_integrity_error Exception;
515: l_table_name all_tables.table_name%TYPE;
516: --
517: Begin
518: hr_utility.set_location('Entering:'||l_proc, 5);
519: --
520: -- Ensure that the p_datetrack_mode argument is not null
521: --
522: hr_api.mandatory_arg_error

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

553: End If;
554: --
555: End If;
556: --
557: hr_utility.set_location(' Leaving:'||l_proc, 10);
558: Exception
559: When l_integrity_error Then
560: --
561: -- A referential integrity check was violated therefore

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

560: --
561: -- A referential integrity check was violated therefore
562: -- we must error
563: --
564: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
565: hr_utility.set_message_token('TABLE_NAME', l_table_name);
566: hr_utility.raise_error;
567: When Others Then
568: --

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

561: -- A referential integrity check was violated therefore
562: -- we must error
563: --
564: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
565: hr_utility.set_message_token('TABLE_NAME', l_table_name);
566: hr_utility.raise_error;
567: When Others Then
568: --
569: -- An unhandled or unexpected error has occurred which

Line 566: hr_utility.raise_error;

562: -- we must error
563: --
564: hr_utility.set_message(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
565: hr_utility.set_message_token('TABLE_NAME', l_table_name);
566: hr_utility.raise_error;
567: When Others Then
568: --
569: -- An unhandled or unexpected error has occurred which
570: -- we must report

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

568: --
569: -- An unhandled or unexpected error has occurred which
570: -- we must report
571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;

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

569: -- An unhandled or unexpected error has occurred which
570: -- we must report
571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;
577: --

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

570: -- we must report
571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;
577: --
578: -- ----------------------------------------------------------------------------

Line 575: hr_utility.raise_error;

571: --
572: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
573: hr_utility.set_message_token('PROCEDURE', l_proc);
574: hr_utility.set_message_token('STEP','15');
575: hr_utility.raise_error;
576: End dt_update_validate;
577: --
578: -- ----------------------------------------------------------------------------
579: -- |--------------------------< dt_delete_validate >--------------------------|

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

620: l_rows_exist Exception;
621: l_table_name all_tables.table_name%TYPE;
622: --
623: Begin
624: hr_utility.set_location('Entering:'||l_proc, 5);
625: --
626: -- Ensure that the p_datetrack_mode argument is not null
627: --
628: hr_api.mandatory_arg_error

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

657: --
658: --
659: End If;
660: --
661: hr_utility.set_location(' Leaving:'||l_proc, 10);
662: Exception
663: When l_rows_exist Then
664: --
665: -- A referential integrity check was violated therefore

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

664: --
665: -- A referential integrity check was violated therefore
666: -- we must error
667: --
668: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
669: hr_utility.set_message_token('TABLE_NAME', l_table_name);
670: hr_utility.raise_error;
671: When Others Then
672: --

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

665: -- A referential integrity check was violated therefore
666: -- we must error
667: --
668: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
669: hr_utility.set_message_token('TABLE_NAME', l_table_name);
670: hr_utility.raise_error;
671: When Others Then
672: --
673: -- An unhandled or unexpected error has occurred which

Line 670: hr_utility.raise_error;

666: -- we must error
667: --
668: hr_utility.set_message(801, 'HR_7215_DT_CHILD_EXISTS');
669: hr_utility.set_message_token('TABLE_NAME', l_table_name);
670: hr_utility.raise_error;
671: When Others Then
672: --
673: -- An unhandled or unexpected error has occurred which
674: -- we must report

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

672: --
673: -- An unhandled or unexpected error has occurred which
674: -- we must report
675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;

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

673: -- An unhandled or unexpected error has occurred which
674: -- we must report
675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;
681: --

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

674: -- we must report
675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;
681: --
682: -- ----------------------------------------------------------------------------

Line 679: hr_utility.raise_error;

675: --
676: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
677: hr_utility.set_message_token('PROCEDURE', l_proc);
678: hr_utility.set_message_token('STEP','15');
679: hr_utility.raise_error;
680: End dt_delete_validate;
681: --
682: -- ----------------------------------------------------------------------------
683: -- |---------------------------< insert_validate >----------------------------|

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

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

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

734: --
735: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
736: p_effective_date => p_effective_date);
737: --
738: hr_utility.set_location(' Leaving:'||l_proc, 10);
739: End insert_validate;
740: --
741: -- ----------------------------------------------------------------------------
742: -- |---------------------------< update_validate >----------------------------|

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

750: --
751: l_proc varchar2(72) := g_package||'update_validate';
752: --
753: Begin
754: hr_utility.set_location('Entering:'||l_proc, 5);
755: --
756: -- Call all supporting business operations
757: --
758: --

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

801: --
802: chk_flx_impt_extnce(p_prtn_elig_id => p_rec.prtn_elig_id,
803: p_effective_date => p_effective_date);
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 10);
806: End update_validate;
807: --
808: -- ----------------------------------------------------------------------------
809: -- |---------------------------< delete_validate >----------------------------|

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

817: --
818: l_proc varchar2(72) := g_package||'delete_validate';
819: --
820: Begin
821: hr_utility.set_location('Entering:'||l_proc, 5);
822: --
823: -- Call all supporting business operations
824: --
825: dt_delete_validate

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

827: p_validation_start_date => p_validation_start_date,
828: p_validation_end_date => p_validation_end_date,
829: p_prtn_eligy_rl_id => p_rec.prtn_eligy_rl_id);
830: --
831: hr_utility.set_location(' Leaving:'||l_proc, 10);
832: End delete_validate;
833: --
834: --
835: -- ---------------------------------------------------------------------------

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

854: l_proc varchar2(72) := g_package||'return_legislation_code';
855: --
856: begin
857: --
858: hr_utility.set_location('Entering:'|| l_proc, 10);
859: --
860: -- Ensure that all the mandatory parameter are not null
861: --
862: hr_api.mandatory_arg_error(p_api_name => l_proc,

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

872: close csr_leg_code;
873: --
874: -- The primary key is invalid therefore we must error
875: --
876: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
877: hr_utility.raise_error;
878: --
879: end if;
880: --

Line 877: hr_utility.raise_error;

873: --
874: -- The primary key is invalid therefore we must error
875: --
876: hr_utility.set_message(801,'HR_7220_INVALID_PRIMARY_KEY');
877: hr_utility.raise_error;
878: --
879: end if;
880: --
881: close csr_leg_code;

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

879: end if;
880: --
881: close csr_leg_code;
882: --
883: hr_utility.set_location(' Leaving:'|| l_proc, 20);
884: --
885: return l_legislation_code;
886: --
887: end return_legislation_code;