DBA Data[Home] [Help]

APPS.BEN_QTR_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('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --

Line 139: fnd_message.set_token('FIELD','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('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --

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

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('FIELD','p_excld_flag');
140: fnd_message.set_token('TYPE','YES_NO');
141: fnd_message.raise_error;
142: --
143: --
144: end if;

Line 141: fnd_message.raise_error;

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

Line 298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');

294: close c1;
295: --
296: -- raise error as this pl already exists for this profile
297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Qualification Title criteria');
300: fnd_message.set_token('VAR2','Variable Rate Profile');
301: fnd_message.raise_error;
302: --

Line 299: fnd_message.set_token('VAR1','Qualification Title criteria');

295: --
296: -- raise error as this pl already exists for this profile
297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Qualification Title criteria');
300: fnd_message.set_token('VAR2','Variable Rate Profile');
301: fnd_message.raise_error;
302: --
303: end if;

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

296: -- raise error as this pl already exists for this profile
297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Qualification Title criteria');
300: fnd_message.set_token('VAR2','Variable Rate Profile');
301: fnd_message.raise_error;
302: --
303: end if;
304: close c1;

Line 301: fnd_message.raise_error;

297: --
298: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
299: fnd_message.set_token('VAR1','Qualification Title criteria');
300: fnd_message.set_token('VAR2','Variable Rate Profile');
301: fnd_message.raise_error;
302: --
303: end if;
304: close c1;
305: --

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

365: open c1;
366: fetch c1 into l_dummy;
367: --
368: if c1%found then
369: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
370: fnd_message.raise_error;
371: end if;
372: close c1;
373: --

Line 370: fnd_message.raise_error;

366: fetch c1 into l_dummy;
367: --
368: if c1%found then
369: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
370: fnd_message.raise_error;
371: end if;
372: close c1;
373: --
374: hr_utility.set_location('Leaving:'||l_proc, 15);

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

466: --
467: -- An unhandled or unexpected error has occurred which
468: -- we must report
469: --
470: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE', l_proc);
472: fnd_message.set_token('STEP','15');
473: fnd_message.raise_error;
474: End dt_update_validate;

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

467: -- An unhandled or unexpected error has occurred which
468: -- we must report
469: --
470: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE', l_proc);
472: fnd_message.set_token('STEP','15');
473: fnd_message.raise_error;
474: End dt_update_validate;
475: --

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

468: -- we must report
469: --
470: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE', l_proc);
472: fnd_message.set_token('STEP','15');
473: fnd_message.raise_error;
474: End dt_update_validate;
475: --
476: -- ----------------------------------------------------------------------------

Line 473: fnd_message.raise_error;

469: --
470: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
471: fnd_message.set_token('PROCEDURE', l_proc);
472: fnd_message.set_token('STEP','15');
473: fnd_message.raise_error;
474: End dt_update_validate;
475: --
476: -- ----------------------------------------------------------------------------
477: -- |--------------------------< dt_delete_validate >--------------------------|

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

562: --
563: -- A referential integrity check was violated therefore
564: -- we must error
565: --
566: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
567: fnd_message.set_token('TABLE_NAME', l_table_name);
568: fnd_message.raise_error;
569: When Others Then
570: --

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

563: -- A referential integrity check was violated therefore
564: -- we must error
565: --
566: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
567: fnd_message.set_token('TABLE_NAME', l_table_name);
568: fnd_message.raise_error;
569: When Others Then
570: --
571: -- An unhandled or unexpected error has occurred which

Line 568: fnd_message.raise_error;

564: -- we must error
565: --
566: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
567: fnd_message.set_token('TABLE_NAME', l_table_name);
568: fnd_message.raise_error;
569: When Others Then
570: --
571: -- An unhandled or unexpected error has occurred which
572: -- we must report

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

570: --
571: -- An unhandled or unexpected error has occurred which
572: -- we must report
573: --
574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
575: fnd_message.set_token('PROCEDURE', l_proc);
576: fnd_message.set_token('STEP','15');
577: fnd_message.raise_error;
578: End dt_delete_validate;

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

571: -- An unhandled or unexpected error has occurred which
572: -- we must report
573: --
574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
575: fnd_message.set_token('PROCEDURE', l_proc);
576: fnd_message.set_token('STEP','15');
577: fnd_message.raise_error;
578: End dt_delete_validate;
579: --

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

572: -- we must report
573: --
574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
575: fnd_message.set_token('PROCEDURE', l_proc);
576: fnd_message.set_token('STEP','15');
577: fnd_message.raise_error;
578: End dt_delete_validate;
579: --
580: -- ----------------------------------------------------------------------------

Line 577: fnd_message.raise_error;

573: --
574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
575: fnd_message.set_token('PROCEDURE', l_proc);
576: fnd_message.set_token('STEP','15');
577: fnd_message.raise_error;
578: End dt_delete_validate;
579: --
580: -- ----------------------------------------------------------------------------
581: -- |---------------------------< insert_validate >----------------------------|

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

771: close csr_leg_code;
772: --
773: -- The primary key is invalid therefore we must error
774: --
775: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
776: fnd_message.raise_error;
777: --
778: end if;
779: --

Line 776: fnd_message.raise_error;

772: --
773: -- The primary key is invalid therefore we must error
774: --
775: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
776: fnd_message.raise_error;
777: --
778: end if;
779: --
780: close csr_leg_code;