DBA Data[Home] [Help]

APPS.BEN_ELV_BUS dependencies on FND_MESSAGE

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

150: p_effective_date => p_effective_date) then
151: --
152: -- raise error as does not exist as lookup
153: --
154: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
155: fnd_message.set_token('FIELD','p_lvg_rsn_cd');
156: fnd_message.set_token('TYPE','LEAV_REAS');
157: fnd_message.raise_error;
158: --

Line 155: fnd_message.set_token('FIELD','p_lvg_rsn_cd');

151: --
152: -- raise error as does not exist as lookup
153: --
154: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
155: fnd_message.set_token('FIELD','p_lvg_rsn_cd');
156: fnd_message.set_token('TYPE','LEAV_REAS');
157: fnd_message.raise_error;
158: --
159: end if;

Line 156: fnd_message.set_token('TYPE','LEAV_REAS');

152: -- raise error as does not exist as lookup
153: --
154: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
155: fnd_message.set_token('FIELD','p_lvg_rsn_cd');
156: fnd_message.set_token('TYPE','LEAV_REAS');
157: fnd_message.raise_error;
158: --
159: end if;
160: --

Line 157: fnd_message.raise_error;

153: --
154: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
155: fnd_message.set_token('FIELD','p_lvg_rsn_cd');
156: fnd_message.set_token('TYPE','LEAV_REAS');
157: fnd_message.raise_error;
158: --
159: end if;
160: --
161: open c3;

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

164: close c3;
165: --
166: -- raise error as this criteria already exists for this profile
167: --
168: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
169: fnd_message.raise_error;
170: --
171: end if;
172: close c3;

Line 169: fnd_message.raise_error;

165: --
166: -- raise error as this criteria already exists for this profile
167: --
168: fnd_message.set_name('BEN', 'BEN_91349_DUP_ELIG_CRITERIA');
169: fnd_message.raise_error;
170: --
171: end if;
172: close c3;
173: --

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

234: p_effective_date => p_effective_date) then
235: --
236: -- raise error as does not exist as lookup
237: --
238: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
239: fnd_message.set_token('FIELD','p_excld_flag');
240: fnd_message.set_token('TYPE','YES_NO');
241: fnd_message.raise_error;
242: --

Line 239: fnd_message.set_token('FIELD','p_excld_flag');

235: --
236: -- raise error as does not exist as lookup
237: --
238: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
239: fnd_message.set_token('FIELD','p_excld_flag');
240: fnd_message.set_token('TYPE','YES_NO');
241: fnd_message.raise_error;
242: --
243: end if;

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

236: -- raise error as does not exist as lookup
237: --
238: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
239: fnd_message.set_token('FIELD','p_excld_flag');
240: fnd_message.set_token('TYPE','YES_NO');
241: fnd_message.raise_error;
242: --
243: end if;
244: --

Line 241: fnd_message.raise_error;

237: --
238: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
239: fnd_message.set_token('FIELD','p_excld_flag');
240: fnd_message.set_token('TYPE','YES_NO');
241: fnd_message.raise_error;
242: --
243: end if;
244: --
245: end if;

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

299: open c1;
300: fetch c1 into l_dummy;
301: if c1%found then
302: close c1;
303: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
304: fnd_message.raise_error;
305: end if;
306: close c1;
307: --

Line 304: fnd_message.raise_error;

300: fetch c1 into l_dummy;
301: if c1%found then
302: close c1;
303: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
304: fnd_message.raise_error;
305: end if;
306: close c1;
307: --
308: hr_utility.set_location('Leaving:'||l_proc, 15);

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

399: --
400: -- An unhandled or unexpected error has occurred which
401: -- we must report
402: --
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','15');
406: fnd_message.raise_error;
407: End dt_update_validate;

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

400: -- An unhandled or unexpected error has occurred which
401: -- we must report
402: --
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','15');
406: fnd_message.raise_error;
407: End dt_update_validate;
408: --

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

401: -- we must report
402: --
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','15');
406: fnd_message.raise_error;
407: End dt_update_validate;
408: --
409: -- ----------------------------------------------------------------------------

Line 406: fnd_message.raise_error;

402: --
403: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
404: fnd_message.set_token('PROCEDURE', l_proc);
405: fnd_message.set_token('STEP','15');
406: fnd_message.raise_error;
407: End dt_update_validate;
408: --
409: -- ----------------------------------------------------------------------------
410: -- |--------------------------< dt_delete_validate >--------------------------|

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

495: --
496: -- A referential integrity check was violated therefore
497: -- we must error
498: --
499: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
500: fnd_message.set_token('TABLE_NAME', l_table_name);
501: fnd_message.raise_error;
502: When Others Then
503: --

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

496: -- A referential integrity check was violated therefore
497: -- we must error
498: --
499: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
500: fnd_message.set_token('TABLE_NAME', l_table_name);
501: fnd_message.raise_error;
502: When Others Then
503: --
504: -- An unhandled or unexpected error has occurred which

Line 501: fnd_message.raise_error;

497: -- we must error
498: --
499: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
500: fnd_message.set_token('TABLE_NAME', l_table_name);
501: fnd_message.raise_error;
502: When Others Then
503: --
504: -- An unhandled or unexpected error has occurred which
505: -- we must report

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

503: --
504: -- An unhandled or unexpected error has occurred which
505: -- we must report
506: --
507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
508: fnd_message.set_token('PROCEDURE', l_proc);
509: fnd_message.set_token('STEP','15');
510: fnd_message.raise_error;
511: End dt_delete_validate;

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

504: -- An unhandled or unexpected error has occurred which
505: -- we must report
506: --
507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
508: fnd_message.set_token('PROCEDURE', l_proc);
509: fnd_message.set_token('STEP','15');
510: fnd_message.raise_error;
511: End dt_delete_validate;
512: --

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

505: -- we must report
506: --
507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
508: fnd_message.set_token('PROCEDURE', l_proc);
509: fnd_message.set_token('STEP','15');
510: fnd_message.raise_error;
511: End dt_delete_validate;
512: --
513: -- ----------------------------------------------------------------------------

Line 510: fnd_message.raise_error;

506: --
507: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
508: fnd_message.set_token('PROCEDURE', l_proc);
509: fnd_message.set_token('STEP','15');
510: fnd_message.raise_error;
511: End dt_delete_validate;
512: --
513: -- ----------------------------------------------------------------------------
514: -- |---------------------------< insert_validate >----------------------------|

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

685: close csr_leg_code;
686: --
687: -- The primary key is invalid therefore we must error
688: --
689: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
690: fnd_message.raise_error;
691: --
692: end if;
693: --

Line 690: fnd_message.raise_error;

686: --
687: -- The primary key is invalid therefore we must error
688: --
689: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
690: fnd_message.raise_error;
691: --
692: end if;
693: --
694: close csr_leg_code;