DBA Data[Home] [Help]

APPS.BEN_ERG_BUS dependencies on FND_MESSAGE

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

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

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

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

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

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

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

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

Line 142: fnd_message.raise_error;

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

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

210: p_effective_date => p_effective_date) then
211: --
212: -- raise error as does not exist as lookup
213: --
214: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
215: fnd_message.set_token('VALUE',p_event_type);
216: fnd_message.set_token('FIELD','EVENT_TYPE');
217: fnd_message.set_token('TYPE','EMP_INTERVIEW_TYPE');
218: fnd_message.raise_error;

Line 215: fnd_message.set_token('VALUE',p_event_type);

211: --
212: -- raise error as does not exist as lookup
213: --
214: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
215: fnd_message.set_token('VALUE',p_event_type);
216: fnd_message.set_token('FIELD','EVENT_TYPE');
217: fnd_message.set_token('TYPE','EMP_INTERVIEW_TYPE');
218: fnd_message.raise_error;
219: --

Line 216: fnd_message.set_token('FIELD','EVENT_TYPE');

212: -- raise error as does not exist as lookup
213: --
214: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
215: fnd_message.set_token('VALUE',p_event_type);
216: fnd_message.set_token('FIELD','EVENT_TYPE');
217: fnd_message.set_token('TYPE','EMP_INTERVIEW_TYPE');
218: fnd_message.raise_error;
219: --
220: --

Line 217: fnd_message.set_token('TYPE','EMP_INTERVIEW_TYPE');

213: --
214: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
215: fnd_message.set_token('VALUE',p_event_type);
216: fnd_message.set_token('FIELD','EVENT_TYPE');
217: fnd_message.set_token('TYPE','EMP_INTERVIEW_TYPE');
218: fnd_message.raise_error;
219: --
220: --
221: end if;

Line 218: fnd_message.raise_error;

214: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
215: fnd_message.set_token('VALUE',p_event_type);
216: fnd_message.set_token('FIELD','EVENT_TYPE');
217: fnd_message.set_token('TYPE','EMP_INTERVIEW_TYPE');
218: fnd_message.raise_error;
219: --
220: --
221: end if;
222: --

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

286: p_effective_date => p_effective_date) then
287: --
288: -- raise error as does not exist as lookup
289: --
290: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
291: fnd_message.set_token('VALUE',p_perf_rtng_cd);
292: fnd_message.set_token('FIELD','PERF_RTNG_CD');
293: fnd_message.set_token('TYPE','PERFORMANCE_RATING');
294: fnd_message.raise_error;

Line 291: fnd_message.set_token('VALUE',p_perf_rtng_cd);

287: --
288: -- raise error as does not exist as lookup
289: --
290: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
291: fnd_message.set_token('VALUE',p_perf_rtng_cd);
292: fnd_message.set_token('FIELD','PERF_RTNG_CD');
293: fnd_message.set_token('TYPE','PERFORMANCE_RATING');
294: fnd_message.raise_error;
295: --

Line 292: fnd_message.set_token('FIELD','PERF_RTNG_CD');

288: -- raise error as does not exist as lookup
289: --
290: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
291: fnd_message.set_token('VALUE',p_perf_rtng_cd);
292: fnd_message.set_token('FIELD','PERF_RTNG_CD');
293: fnd_message.set_token('TYPE','PERFORMANCE_RATING');
294: fnd_message.raise_error;
295: --
296: --

Line 293: fnd_message.set_token('TYPE','PERFORMANCE_RATING');

289: --
290: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
291: fnd_message.set_token('VALUE',p_perf_rtng_cd);
292: fnd_message.set_token('FIELD','PERF_RTNG_CD');
293: fnd_message.set_token('TYPE','PERFORMANCE_RATING');
294: fnd_message.raise_error;
295: --
296: --
297: end if;

Line 294: fnd_message.raise_error;

290: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
291: fnd_message.set_token('VALUE',p_perf_rtng_cd);
292: fnd_message.set_token('FIELD','PERF_RTNG_CD');
293: fnd_message.set_token('TYPE','PERFORMANCE_RATING');
294: fnd_message.raise_error;
295: --
296: --
297: end if;
298: --

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

363: close c1;
364: --
365: -- raise error as duplicate criteria has been entered
366: --
367: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
368: fnd_message.raise_error;
369: --
370: end if;
371: close c1;

Line 368: fnd_message.raise_error;

364: --
365: -- raise error as duplicate criteria has been entered
366: --
367: fnd_message.set_name('BEN','BEN_91349_DUP_ELIG_CRITERIA');
368: fnd_message.raise_error;
369: --
370: end if;
371: close c1;
372: --

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

424: open c1;
425: fetch c1 into l_dummy;
426: if c1%found then
427: close c1;
428: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
429: fnd_message.raise_error;
430: end if;
431: close c1;
432: --

Line 429: fnd_message.raise_error;

425: fetch c1 into l_dummy;
426: if c1%found then
427: close c1;
428: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
429: fnd_message.raise_error;
430: end if;
431: close c1;
432: --
433: hr_utility.set_location('Leaving:'||l_proc, 15);

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

524: --
525: -- An unhandled or unexpected error has occurred which
526: -- we must report
527: --
528: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE', l_proc);
530: fnd_message.set_token('STEP','15');
531: fnd_message.raise_error;
532: End dt_update_validate;

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

525: -- An unhandled or unexpected error has occurred which
526: -- we must report
527: --
528: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE', l_proc);
530: fnd_message.set_token('STEP','15');
531: fnd_message.raise_error;
532: End dt_update_validate;
533: --

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

526: -- we must report
527: --
528: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE', l_proc);
530: fnd_message.set_token('STEP','15');
531: fnd_message.raise_error;
532: End dt_update_validate;
533: --
534: -- ----------------------------------------------------------------------------

Line 531: fnd_message.raise_error;

527: --
528: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
529: fnd_message.set_token('PROCEDURE', l_proc);
530: fnd_message.set_token('STEP','15');
531: fnd_message.raise_error;
532: End dt_update_validate;
533: --
534: -- ----------------------------------------------------------------------------
535: -- |--------------------------< dt_delete_validate >--------------------------|

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

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

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

621: -- A referential integrity check was violated therefore
622: -- we must error
623: --
624: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --
629: -- An unhandled or unexpected error has occurred which

Line 626: fnd_message.raise_error;

622: -- we must error
623: --
624: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --
629: -- An unhandled or unexpected error has occurred which
630: -- we must report

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

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

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

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

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

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

Line 635: fnd_message.raise_error;

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

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

832: close csr_leg_code;
833: --
834: -- The primary key is invalid therefore we must error
835: --
836: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
837: fnd_message.raise_error;
838: --
839: end if;
840: --

Line 837: fnd_message.raise_error;

833: --
834: -- The primary key is invalid therefore we must error
835: --
836: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
837: fnd_message.raise_error;
838: --
839: end if;
840: --
841: close csr_leg_code;