DBA Data[Home] [Help]

APPS.BEN_EQG_BUS dependencies on FND_MESSAGE

Line 137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('VALUE',p_excld_flag);
139: fnd_message.set_token('FIELD','EXCLD_FLAG');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;

Line 138: fnd_message.set_token('VALUE',p_excld_flag);

134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('VALUE',p_excld_flag);
139: fnd_message.set_token('FIELD','EXCLD_FLAG');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --

Line 139: fnd_message.set_token('FIELD','EXCLD_FLAG');

135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('VALUE',p_excld_flag);
139: fnd_message.set_token('FIELD','EXCLD_FLAG');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: end if;

Line 140: fnd_message.set_token('TYPE','YES_NO');

136: --
137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('VALUE',p_excld_flag);
139: fnd_message.set_token('FIELD','EXCLD_FLAG');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: end if;
144: --

Line 141: fnd_message.raise_error;

137: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('VALUE',p_excld_flag);
139: fnd_message.set_token('FIELD','EXCLD_FLAG');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: end if;
144: --
145: end if;

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

205: p_effective_date => p_effective_date) then
206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('VALUE',p_quar_in_grade_cd);
211: fnd_message.set_token('FIELD','QUAR_IN_GRADE_CD');
212: fnd_message.set_token('TYPE','BEN_CWB_QUAR_IN_GRD');
213: fnd_message.raise_error;

Line 210: fnd_message.set_token('VALUE',p_quar_in_grade_cd);

206: --
207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('VALUE',p_quar_in_grade_cd);
211: fnd_message.set_token('FIELD','QUAR_IN_GRADE_CD');
212: fnd_message.set_token('TYPE','BEN_CWB_QUAR_IN_GRD');
213: fnd_message.raise_error;
214: --

Line 211: fnd_message.set_token('FIELD','QUAR_IN_GRADE_CD');

207: -- raise error as does not exist as lookup
208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('VALUE',p_quar_in_grade_cd);
211: fnd_message.set_token('FIELD','QUAR_IN_GRADE_CD');
212: fnd_message.set_token('TYPE','BEN_CWB_QUAR_IN_GRD');
213: fnd_message.raise_error;
214: --
215: end if;

Line 212: fnd_message.set_token('TYPE','BEN_CWB_QUAR_IN_GRD');

208: --
209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('VALUE',p_quar_in_grade_cd);
211: fnd_message.set_token('FIELD','QUAR_IN_GRADE_CD');
212: fnd_message.set_token('TYPE','BEN_CWB_QUAR_IN_GRD');
213: fnd_message.raise_error;
214: --
215: end if;
216: --

Line 213: fnd_message.raise_error;

209: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
210: fnd_message.set_token('VALUE',p_quar_in_grade_cd);
211: fnd_message.set_token('FIELD','QUAR_IN_GRADE_CD');
212: fnd_message.set_token('TYPE','BEN_CWB_QUAR_IN_GRD');
213: fnd_message.raise_error;
214: --
215: end if;
216: --
217: end if;

Line 285: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');

281: hr_utility.set_location(l_proc, 7);
282: --
283: -- raise error as duplicate criteria has been entered
284: --
285: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
286: fnd_message.raise_error;
287: --
288: end if;
289: --

Line 286: fnd_message.raise_error;

282: --
283: -- raise error as duplicate criteria has been entered
284: --
285: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
286: fnd_message.raise_error;
287: --
288: end if;
289: --
290: close c_ELIG_QUA_IN_GR_PRTE;

Line 347: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

343: open c1;
344: fetch c1 into l_dummy;
345: if c1%found then
346: close c1;
347: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
348: fnd_message.raise_error;
349: end if;
350: close c1;
351: --

Line 348: fnd_message.raise_error;

344: fetch c1 into l_dummy;
345: if c1%found then
346: close c1;
347: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
348: fnd_message.raise_error;
349: end if;
350: close c1;
351: --
352: hr_utility.set_location('Leaving:'||l_proc, 15);

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

443: --
444: -- An unhandled or unexpected error has occurred which
445: -- we must report
446: --
447: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
448: fnd_message.set_token('PROCEDURE', l_proc);
449: fnd_message.set_token('STEP','15');
450: fnd_message.raise_error;
451: End dt_update_validate;

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

444: -- An unhandled or unexpected error has occurred which
445: -- we must report
446: --
447: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
448: fnd_message.set_token('PROCEDURE', l_proc);
449: fnd_message.set_token('STEP','15');
450: fnd_message.raise_error;
451: End dt_update_validate;
452: --

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

445: -- we must report
446: --
447: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
448: fnd_message.set_token('PROCEDURE', l_proc);
449: fnd_message.set_token('STEP','15');
450: fnd_message.raise_error;
451: End dt_update_validate;
452: --
453: -- ----------------------------------------------------------------------------

Line 450: fnd_message.raise_error;

446: --
447: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
448: fnd_message.set_token('PROCEDURE', l_proc);
449: fnd_message.set_token('STEP','15');
450: fnd_message.raise_error;
451: End dt_update_validate;
452: --
453: -- ----------------------------------------------------------------------------
454: -- |--------------------------< dt_delete_validate >--------------------------|

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

539: --
540: -- A referential integrity check was violated therefore
541: -- we must error
542: --
543: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
544: fnd_message.set_token('TABLE_NAME', l_table_name);
545: fnd_message.raise_error;
546: When Others Then
547: --

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

540: -- A referential integrity check was violated therefore
541: -- we must error
542: --
543: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
544: fnd_message.set_token('TABLE_NAME', l_table_name);
545: fnd_message.raise_error;
546: When Others Then
547: --
548: -- An unhandled or unexpected error has occurred which

Line 545: fnd_message.raise_error;

541: -- we must error
542: --
543: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
544: fnd_message.set_token('TABLE_NAME', l_table_name);
545: fnd_message.raise_error;
546: When Others Then
547: --
548: -- An unhandled or unexpected error has occurred which
549: -- we must report

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

547: --
548: -- An unhandled or unexpected error has occurred which
549: -- we must report
550: --
551: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE', l_proc);
553: fnd_message.set_token('STEP','15');
554: fnd_message.raise_error;
555: End dt_delete_validate;

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

548: -- An unhandled or unexpected error has occurred which
549: -- we must report
550: --
551: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE', l_proc);
553: fnd_message.set_token('STEP','15');
554: fnd_message.raise_error;
555: End dt_delete_validate;
556: --

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

549: -- we must report
550: --
551: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE', l_proc);
553: fnd_message.set_token('STEP','15');
554: fnd_message.raise_error;
555: End dt_delete_validate;
556: --
557: -- ----------------------------------------------------------------------------

Line 554: fnd_message.raise_error;

550: --
551: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
552: fnd_message.set_token('PROCEDURE', l_proc);
553: fnd_message.set_token('STEP','15');
554: fnd_message.raise_error;
555: End dt_delete_validate;
556: --
557: -- ----------------------------------------------------------------------------
558: -- |---------------------------< insert_validate >----------------------------|

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

733: close csr_leg_code;
734: --
735: -- The primary key is invalid therefore we must error
736: --
737: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
738: fnd_message.raise_error;
739: --
740: end if;
741: --

Line 738: fnd_message.raise_error;

734: --
735: -- The primary key is invalid therefore we must error
736: --
737: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
738: fnd_message.raise_error;
739: --
740: end if;
741: --
742: close csr_leg_code;