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_RGR_BUS dependencies on FND_MESSAGE

Line 136: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');

132: --
133: close c1;
134: --
135: -- raise error
136: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
137: fnd_message.raise_error;
138: --
139: end if;
140: --

Line 137: fnd_message.raise_error;

133: close c1;
134: --
135: -- raise error
136: fnd_message.set_name('BEN','BEN_92776_PARENT_REC_EXISTS');
137: fnd_message.raise_error;
138: --
139: end if;
140: --
141: close c1;

Line 209: fnd_message.set_name('BEN','BEN_93266_RPTG_GRP_NAME_NULL');

205: -- check if rptg_grp_id value exists in ben_rptg_grp table
206: --
207: if p_rptg_grp_id is null then
208:
209: fnd_message.set_name('BEN','BEN_93266_RPTG_GRP_NAME_NULL');
210: fnd_message.raise_error;
211:
212: else
213:

Line 210: fnd_message.raise_error;

206: --
207: if p_rptg_grp_id is null then
208:
209: fnd_message.set_name('BEN','BEN_93266_RPTG_GRP_NAME_NULL');
210: fnd_message.raise_error;
211:
212: else
213:
214: open c1;

Line 337: fnd_message.set_name('BEN','BEN_91313_DUP_RPTG_GRP_PL_ID');

333: --
334: -- raise error as UK1 is violated
335: --
336: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');
337: fnd_message.set_name('BEN','BEN_91313_DUP_RPTG_GRP_PL_ID');
338: fnd_message.raise_error;
339: --
340: end if;
341: --

Line 338: fnd_message.raise_error;

334: -- raise error as UK1 is violated
335: --
336: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');
337: fnd_message.set_name('BEN','BEN_91313_DUP_RPTG_GRP_PL_ID');
338: fnd_message.raise_error;
339: --
340: end if;
341: --
342: close crs_pl_id;

Line 363: fnd_message.set_name('BEN','BEN_93920_RPTG_IREC_NONICD_PLN'); --Bug#5204203

359: --
360: --Raise error : plan being added or modified has Plan Type other than Individual Compensation Distribution
361: --at some point of time later than p_validation_start_date
362: --
363: fnd_message.set_name('BEN','BEN_93920_RPTG_IREC_NONICD_PLN'); --Bug#5204203
364: fnd_message.raise_error;
365: --
366: end if;
367: --

Line 364: fnd_message.raise_error;

360: --Raise error : plan being added or modified has Plan Type other than Individual Compensation Distribution
361: --at some point of time later than p_validation_start_date
362: --
363: fnd_message.set_name('BEN','BEN_93920_RPTG_IREC_NONICD_PLN'); --Bug#5204203
364: fnd_message.raise_error;
365: --
366: end if;
367: --
368: close crs_irec_pln;

Line 457: fnd_message.set_name('BEN','BEN_91314_DUP_RPTG_GRP_PGM_ID');

453: --
454: -- raise error as UK1 is violated
455: --
456: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');
457: fnd_message.set_name('BEN','BEN_91314_DUP_RPTG_GRP_PGM_ID');
458: fnd_message.raise_error;
459: --
460: end if;
461: --

Line 458: fnd_message.raise_error;

454: -- raise error as UK1 is violated
455: --
456: -- ben_rgr_shd.constraint_error('BEN_REGN_UK1');
457: fnd_message.set_name('BEN','BEN_91314_DUP_RPTG_GRP_PGM_ID');
458: fnd_message.raise_error;
459: --
460: end if;
461: --
462: close csr_pgm_id;

Line 508: fnd_message.set_name('BEN','BEN_91111_WO_PGM_OR_PL_ID');

504: If p_pgm_id is null and p_pl_id is null then
505: --
506: -- raise error as both pl_id and pgm_id can't be null
507: --
508: fnd_message.set_name('BEN','BEN_91111_WO_PGM_OR_PL_ID');
509: fnd_message.raise_error;
510: --
511: elsif p_pgm_id is not null and p_pl_id is not null then
512: --

Line 509: fnd_message.raise_error;

505: --
506: -- raise error as both pl_id and pgm_id can't be null
507: --
508: fnd_message.set_name('BEN','BEN_91111_WO_PGM_OR_PL_ID');
509: fnd_message.raise_error;
510: --
511: elsif p_pgm_id is not null and p_pl_id is not null then
512: --
513: -- raise error as both pl_id and pgm_id can't be not null

Line 515: fnd_message.set_name('BEN','BEN_91110_EITHER_PGM_OR_PL_ID');

511: elsif p_pgm_id is not null and p_pl_id is not null then
512: --
513: -- raise error as both pl_id and pgm_id can't be not null
514: --
515: fnd_message.set_name('BEN','BEN_91110_EITHER_PGM_OR_PL_ID');
516: fnd_message.raise_error;
517: --
518: --
519: end if;

Line 516: fnd_message.raise_error;

512: --
513: -- raise error as both pl_id and pgm_id can't be not null
514: --
515: fnd_message.set_name('BEN','BEN_91110_EITHER_PGM_OR_PL_ID');
516: fnd_message.raise_error;
517: --
518: --
519: end if;
520: --

Line 622: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

618: --
619: -- A referential integrity check was violated therefore
620: -- we must error
621: --
622: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
623: -- fnd_message.set_token('TABLE_NAME', l_table_name);
624: -- fnd_message.raise_error;
625: ben_utility.parent_integrity_error(p_table_name => l_table_name);
626: When Others Then

Line 623: -- fnd_message.set_token('TABLE_NAME', l_table_name);

619: -- A referential integrity check was violated therefore
620: -- we must error
621: --
622: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
623: -- fnd_message.set_token('TABLE_NAME', l_table_name);
624: -- fnd_message.raise_error;
625: ben_utility.parent_integrity_error(p_table_name => l_table_name);
626: When Others Then
627: --

Line 624: -- fnd_message.raise_error;

620: -- we must error
621: --
622: -- fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
623: -- fnd_message.set_token('TABLE_NAME', l_table_name);
624: -- fnd_message.raise_error;
625: ben_utility.parent_integrity_error(p_table_name => l_table_name);
626: When Others Then
627: --
628: -- An unhandled or unexpected error has occurred which

Line 631: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

627: --
628: -- An unhandled or unexpected error has occurred which
629: -- we must report
630: --
631: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
632: fnd_message.set_token('PROCEDURE', l_proc);
633: fnd_message.set_token('STEP','15');
634: fnd_message.raise_error;
635: End dt_update_validate;

Line 632: fnd_message.set_token('PROCEDURE', l_proc);

628: -- An unhandled or unexpected error has occurred which
629: -- we must report
630: --
631: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
632: fnd_message.set_token('PROCEDURE', l_proc);
633: fnd_message.set_token('STEP','15');
634: fnd_message.raise_error;
635: End dt_update_validate;
636: --

Line 633: fnd_message.set_token('STEP','15');

629: -- we must report
630: --
631: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
632: fnd_message.set_token('PROCEDURE', l_proc);
633: fnd_message.set_token('STEP','15');
634: fnd_message.raise_error;
635: End dt_update_validate;
636: --
637: -- ----------------------------------------------------------------------------

Line 634: fnd_message.raise_error;

630: --
631: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
632: fnd_message.set_token('PROCEDURE', l_proc);
633: fnd_message.set_token('STEP','15');
634: fnd_message.raise_error;
635: End dt_update_validate;
636: --
637: -- ----------------------------------------------------------------------------
638: -- |--------------------------< dt_delete_validate >--------------------------|

Line 727: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');

723: --
724: -- A referential integrity check was violated therefore
725: -- we must error
726: --
727: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
728: -- fnd_message.set_token('TABLE_NAME', l_table_name);
729: -- fnd_message.raise_error;
730: ben_utility.child_exists_error(p_table_name => l_table_name);
731: When Others Then

Line 728: -- fnd_message.set_token('TABLE_NAME', l_table_name);

724: -- A referential integrity check was violated therefore
725: -- we must error
726: --
727: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
728: -- fnd_message.set_token('TABLE_NAME', l_table_name);
729: -- fnd_message.raise_error;
730: ben_utility.child_exists_error(p_table_name => l_table_name);
731: When Others Then
732: --

Line 729: -- fnd_message.raise_error;

725: -- we must error
726: --
727: -- fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
728: -- fnd_message.set_token('TABLE_NAME', l_table_name);
729: -- fnd_message.raise_error;
730: ben_utility.child_exists_error(p_table_name => l_table_name);
731: When Others Then
732: --
733: -- An unhandled or unexpected error has occurred which

Line 736: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

732: --
733: -- An unhandled or unexpected error has occurred which
734: -- we must report
735: --
736: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
737: fnd_message.set_token('PROCEDURE', l_proc);
738: fnd_message.set_token('STEP','15');
739: fnd_message.raise_error;
740: End dt_delete_validate;

Line 737: fnd_message.set_token('PROCEDURE', l_proc);

733: -- An unhandled or unexpected error has occurred which
734: -- we must report
735: --
736: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
737: fnd_message.set_token('PROCEDURE', l_proc);
738: fnd_message.set_token('STEP','15');
739: fnd_message.raise_error;
740: End dt_delete_validate;
741: --

Line 738: fnd_message.set_token('STEP','15');

734: -- we must report
735: --
736: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
737: fnd_message.set_token('PROCEDURE', l_proc);
738: fnd_message.set_token('STEP','15');
739: fnd_message.raise_error;
740: End dt_delete_validate;
741: --
742: -- ----------------------------------------------------------------------------

Line 739: fnd_message.raise_error;

735: --
736: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
737: fnd_message.set_token('PROCEDURE', l_proc);
738: fnd_message.set_token('STEP','15');
739: fnd_message.raise_error;
740: End dt_delete_validate;
741: --
742: -- ----------------------------------------------------------------------------
743: -- |---------------------------< insert_validate >----------------------------|

Line 956: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

952: close csr_leg_code;
953: --
954: -- The primary key is invalid therefore we must error
955: --
956: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
957: fnd_message.raise_error;
958: --
959: end if;
960: */

Line 957: fnd_message.raise_error;

953: --
954: -- The primary key is invalid therefore we must error
955: --
956: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
957: fnd_message.raise_error;
958: --
959: end if;
960: */
961: --