DBA Data[Home] [Help]

APPS.BEN_LRN_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_92992_DUPS_ROW');

164: close c3;
165: --
166: -- raise error as this criteria already exists for this profile
167: --
168: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
169: fnd_message.set_token('VAR1','Leaving Reason criteria');
170: fnd_message.set_token('VAR2','Variable Rate Profile');
171: fnd_message.raise_error;
172: --

Line 169: fnd_message.set_token('VAR1','Leaving Reason criteria');

165: --
166: -- raise error as this criteria already exists for this profile
167: --
168: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
169: fnd_message.set_token('VAR1','Leaving Reason criteria');
170: fnd_message.set_token('VAR2','Variable Rate Profile');
171: fnd_message.raise_error;
172: --
173: end if;

Line 170: fnd_message.set_token('VAR2','Variable Rate Profile');

166: -- raise error as this criteria already exists for this profile
167: --
168: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
169: fnd_message.set_token('VAR1','Leaving Reason criteria');
170: fnd_message.set_token('VAR2','Variable Rate Profile');
171: fnd_message.raise_error;
172: --
173: end if;
174: close c3;

Line 171: fnd_message.raise_error;

167: --
168: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
169: fnd_message.set_token('VAR1','Leaving Reason criteria');
170: fnd_message.set_token('VAR2','Variable Rate Profile');
171: fnd_message.raise_error;
172: --
173: end if;
174: close c3;
175: --

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

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

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

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

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

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

Line 243: fnd_message.raise_error;

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

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

310: open c1;
311: fetch c1 into l_dummy;
312: --
313: if c1%found then
314: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
315: fnd_message.raise_error;
316: end if;
317: close c1;
318: --

Line 315: fnd_message.raise_error;

311: fetch c1 into l_dummy;
312: --
313: if c1%found then
314: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
315: fnd_message.raise_error;
316: end if;
317: close c1;
318: --
319: hr_utility.set_location('Leaving:'||l_proc, 15);

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

410: --
411: -- An unhandled or unexpected error has occurred which
412: -- we must report
413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;

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

411: -- An unhandled or unexpected error has occurred which
412: -- we must report
413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;
419: --

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

412: -- we must report
413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;
419: --
420: -- ----------------------------------------------------------------------------

Line 417: fnd_message.raise_error;

413: --
414: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
415: fnd_message.set_token('PROCEDURE', l_proc);
416: fnd_message.set_token('STEP','15');
417: fnd_message.raise_error;
418: End dt_update_validate;
419: --
420: -- ----------------------------------------------------------------------------
421: -- |--------------------------< dt_delete_validate >--------------------------|

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

506: --
507: -- A referential integrity check was violated therefore
508: -- we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
511: fnd_message.set_token('TABLE_NAME', l_table_name);
512: fnd_message.raise_error;
513: When Others Then
514: --

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

507: -- A referential integrity check was violated therefore
508: -- we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
511: fnd_message.set_token('TABLE_NAME', l_table_name);
512: fnd_message.raise_error;
513: When Others Then
514: --
515: -- An unhandled or unexpected error has occurred which

Line 512: fnd_message.raise_error;

508: -- we must error
509: --
510: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
511: fnd_message.set_token('TABLE_NAME', l_table_name);
512: fnd_message.raise_error;
513: When Others Then
514: --
515: -- An unhandled or unexpected error has occurred which
516: -- we must report

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

514: --
515: -- An unhandled or unexpected error has occurred which
516: -- we must report
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;

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

515: -- An unhandled or unexpected error has occurred which
516: -- we must report
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;
523: --

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

516: -- we must report
517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;
523: --
524: -- ----------------------------------------------------------------------------

Line 521: fnd_message.raise_error;

517: --
518: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
519: fnd_message.set_token('PROCEDURE', l_proc);
520: fnd_message.set_token('STEP','15');
521: fnd_message.raise_error;
522: End dt_delete_validate;
523: --
524: -- ----------------------------------------------------------------------------
525: -- |---------------------------< insert_validate >----------------------------|

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

704: close csr_leg_code;
705: --
706: -- The primary key is invalid therefore we must error
707: --
708: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
709: fnd_message.raise_error;
710: --
711: end if;
712: --

Line 709: fnd_message.raise_error;

705: --
706: -- The primary key is invalid therefore we must error
707: --
708: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
709: fnd_message.raise_error;
710: --
711: end if;
712: --
713: close csr_leg_code;