DBA Data[Home] [Help]

APPS.BEN_DCR_BUS dependencies on FND_MESSAGE

Line 137: fnd_message.set_name('PAY','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: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.set_token('PER_RELSHP_TYP_CD', p_per_relshp_typ_cd);
139: fnd_message.raise_error;
140: --
141: end if;

Line 138: fnd_message.set_token('PER_RELSHP_TYP_CD', p_per_relshp_typ_cd);

134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.set_token('PER_RELSHP_TYP_CD', p_per_relshp_typ_cd);
139: fnd_message.raise_error;
140: --
141: end if;
142: --

Line 139: fnd_message.raise_error;

135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
138: fnd_message.set_token('PER_RELSHP_TYP_CD', p_per_relshp_typ_cd);
139: fnd_message.raise_error;
140: --
141: end if;
142: --
143: end if;

Line 221: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

217: close c1;
218: --
219: -- raise error
220: --
221: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
222: fnd_message.set_token('RULE_ID', p_cvg_strt_dt_rl);
223: fnd_message.raise_error;
224: --
225: end if;

Line 222: fnd_message.set_token('RULE_ID', p_cvg_strt_dt_rl);

218: --
219: -- raise error
220: --
221: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
222: fnd_message.set_token('RULE_ID', p_cvg_strt_dt_rl);
223: fnd_message.raise_error;
224: --
225: end if;
226: --

Line 223: fnd_message.raise_error;

219: -- raise error
220: --
221: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
222: fnd_message.set_token('RULE_ID', p_cvg_strt_dt_rl);
223: fnd_message.raise_error;
224: --
225: end if;
226: --
227: close c1;

Line 293: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

289: p_effective_date => p_effective_date) then
290: --
291: -- raise error as does not exist as lookup
292: --
293: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
294: fnd_message.set_token('THRU_DT_CD', p_cvg_thru_dt_cd);
295: fnd_message.raise_error;
296: --
297: end if;

Line 294: fnd_message.set_token('THRU_DT_CD', p_cvg_thru_dt_cd);

290: --
291: -- raise error as does not exist as lookup
292: --
293: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
294: fnd_message.set_token('THRU_DT_CD', p_cvg_thru_dt_cd);
295: fnd_message.raise_error;
296: --
297: end if;
298: --

Line 295: fnd_message.raise_error;

291: -- raise error as does not exist as lookup
292: --
293: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
294: fnd_message.set_token('THRU_DT_CD', p_cvg_thru_dt_cd);
295: fnd_message.raise_error;
296: --
297: end if;
298: --
299: end if;

Line 377: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');

373: close c1;
374: --
375: -- raise error
376: --
377: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
378: fnd_message.set_token('CVG_THRU_RL', to_char(p_cvg_thru_dt_rl));
379: fnd_message.raise_error;
380: --
381: end if;

Line 378: fnd_message.set_token('CVG_THRU_RL', to_char(p_cvg_thru_dt_rl));

374: --
375: -- raise error
376: --
377: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
378: fnd_message.set_token('CVG_THRU_RL', to_char(p_cvg_thru_dt_rl));
379: fnd_message.raise_error;
380: --
381: end if;
382: --

Line 379: fnd_message.raise_error;

375: -- raise error
376: --
377: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
378: fnd_message.set_token('CVG_THRU_RL', to_char(p_cvg_thru_dt_rl));
379: fnd_message.raise_error;
380: --
381: end if;
382: --
383: close c1;

Line 449: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

445: p_effective_date => p_effective_date) then
446: --
447: -- raise error as does not exist as lookup
448: --
449: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
450: fnd_message.set_token('Strt_Cd' , p_cvg_strt_dt_cd);
451: fnd_message.raise_error;
452: --
453: end if;

Line 450: fnd_message.set_token('Strt_Cd' , p_cvg_strt_dt_cd);

446: --
447: -- raise error as does not exist as lookup
448: --
449: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
450: fnd_message.set_token('Strt_Cd' , p_cvg_strt_dt_cd);
451: fnd_message.raise_error;
452: --
453: end if;
454: --

Line 451: fnd_message.raise_error;

447: -- raise error as does not exist as lookup
448: --
449: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
450: fnd_message.set_token('Strt_Cd' , p_cvg_strt_dt_cd);
451: fnd_message.raise_error;
452: --
453: end if;
454: --
455: end if;

Line 523: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');

519: -- check dependency of Code and Rule.
520: --
521: if ( nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) <> 'RL' and
522: p_cvg_strt_dt_rl is not null) then
523: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
524: fnd_message.raise_error;
525: end if;
526:
527: if ( nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_dt_rl is null) then

Line 524: fnd_message.raise_error;

520: --
521: if ( nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) <> 'RL' and
522: p_cvg_strt_dt_rl is not null) then
523: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
524: fnd_message.raise_error;
525: end if;
526:
527: if ( nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_dt_rl is null) then
528: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');

Line 528: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');

524: fnd_message.raise_error;
525: end if;
526:
527: if ( nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_dt_rl is null) then
528: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
529: fnd_message.raise_error;
530: end if;
531: end if;
532:

Line 529: fnd_message.raise_error;

525: end if;
526:
527: if ( nvl(p_cvg_strt_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_strt_dt_rl is null) then
528: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
529: fnd_message.raise_error;
530: end if;
531: end if;
532:
533: --

Line 602: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');

598: -- check dependency of Code and Rule.
599: --
600: if ( nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) <> 'RL' and
601: p_cvg_thru_dt_rl is not null) then
602: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
603: fnd_message.raise_error;
604: end if;
605:
606: if ( nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_dt_rl is null) then

Line 603: fnd_message.raise_error;

599: --
600: if ( nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) <> 'RL' and
601: p_cvg_thru_dt_rl is not null) then
602: fnd_message.set_name('BEN', 'BEN_67890_field_CWOR');
603: fnd_message.raise_error;
604: end if;
605:
606: if ( nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_dt_rl is null) then
607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');

Line 607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');

603: fnd_message.raise_error;
604: end if;
605:
606: if ( nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_dt_rl is null) then
607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
608: fnd_message.raise_error;
609: end if;
610: end if;
611:

Line 608: fnd_message.raise_error;

604: end if;
605:
606: if ( nvl(p_cvg_thru_dt_cd, hr_api.g_varchar2) = 'RL' and p_cvg_thru_dt_rl is null) then
607: fnd_message.set_name('BEN', 'BEN_12345_field_CWOR');
608: fnd_message.raise_error;
609: end if;
610: end if;
611:
612: --

Line 680: fnd_message.set_name('BEN', 'HR_51895_APR_END_DATE_NULL');

676: --
677: -- check dependent Relationship of Start Date and through Date.
678: --
679: if ( p_cvg_strt_dt_cd is not null and p_cvg_thru_dt_cd is null) then
680: fnd_message.set_name('BEN', 'HR_51895_APR_END_DATE_NULL');
681: fnd_message.raise_error;
682: end if;
683:
684: if ( p_cvg_strt_dt_cd is null and p_cvg_thru_dt_cd is not null) then

Line 681: fnd_message.raise_error;

677: -- check dependent Relationship of Start Date and through Date.
678: --
679: if ( p_cvg_strt_dt_cd is not null and p_cvg_thru_dt_cd is null) then
680: fnd_message.set_name('BEN', 'HR_51895_APR_END_DATE_NULL');
681: fnd_message.raise_error;
682: end if;
683:
684: if ( p_cvg_strt_dt_cd is null and p_cvg_thru_dt_cd is not null) then
685: fnd_message.set_name('BEN', 'HR_51895_APR_START_DATE_NULL');

Line 685: fnd_message.set_name('BEN', 'HR_51895_APR_START_DATE_NULL');

681: fnd_message.raise_error;
682: end if;
683:
684: if ( p_cvg_strt_dt_cd is null and p_cvg_thru_dt_cd is not null) then
685: fnd_message.set_name('BEN', 'HR_51895_APR_START_DATE_NULL');
686: fnd_message.raise_error;
687: end if;
688: end if;
689:

Line 686: fnd_message.raise_error;

682: end if;
683:
684: if ( p_cvg_strt_dt_cd is null and p_cvg_thru_dt_cd is not null) then
685: fnd_message.set_name('BEN', 'HR_51895_APR_START_DATE_NULL');
686: fnd_message.raise_error;
687: end if;
688: end if;
689:
690: --

Line 752: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

748: open c1;
749: fetch c1 into dummy;
750: if c1%found then
751: close c1;
752: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
753: fnd_message.raise_error;
754: end if;
755: close c1;
756: --

Line 753: fnd_message.raise_error;

749: fetch c1 into dummy;
750: if c1%found then
751: close c1;
752: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
753: fnd_message.raise_error;
754: end if;
755: close c1;
756: --
757: hr_utility.set_location('Leaving:'||l_proc, 10);

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

851: --
852: -- An unhandled or unexpected error has occurred which
853: -- we must report
854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;

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

852: -- An unhandled or unexpected error has occurred which
853: -- we must report
854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;
860: --

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

853: -- we must report
854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;
860: --
861: -- ----------------------------------------------------------------------------

Line 858: fnd_message.raise_error;

854: --
855: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
856: fnd_message.set_token('PROCEDURE', l_proc);
857: fnd_message.set_token('STEP','15');
858: fnd_message.raise_error;
859: End dt_update_validate;
860: --
861: -- ----------------------------------------------------------------------------
862: -- |--------------------------< dt_delete_validate >--------------------------|

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

954: --
955: -- An unhandled or unexpected error has occurred which
956: -- we must report
957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_delete_validate;

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

955: -- An unhandled or unexpected error has occurred which
956: -- we must report
957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_delete_validate;
963: --

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

956: -- we must report
957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_delete_validate;
963: --
964: -- ----------------------------------------------------------------------------

Line 961: fnd_message.raise_error;

957: --
958: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
959: fnd_message.set_token('PROCEDURE', l_proc);
960: fnd_message.set_token('STEP','15');
961: fnd_message.raise_error;
962: End dt_delete_validate;
963: --
964: -- ----------------------------------------------------------------------------
965: -- |---------------------------< insert_validate >----------------------------|

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

1195: close csr_leg_code;
1196: --
1197: -- The primary key is invalid therefore we must error
1198: --
1199: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1200: fnd_message.raise_error;
1201: --
1202: end if;
1203: --

Line 1200: fnd_message.raise_error;

1196: --
1197: -- The primary key is invalid therefore we must error
1198: --
1199: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1200: fnd_message.raise_error;
1201: --
1202: end if;
1203: --
1204: close csr_leg_code;