DBA Data[Home] [Help]

APPS.BEN_CQR_BUS dependencies on FND_MESSAGE

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

163: close c_dup;
164: --
165: -- raise error as this < > criteria already exists for this profile
166: --
167: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
168: fnd_message.set_token('VAR1','Cobra qualified beneficiary criteria',TRUE);
169: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
170: fnd_message.raise_error;
171: --

Line 168: fnd_message.set_token('VAR1','Cobra qualified beneficiary criteria',TRUE);

164: --
165: -- raise error as this < > criteria already exists for this profile
166: --
167: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
168: fnd_message.set_token('VAR1','Cobra qualified beneficiary criteria',TRUE);
169: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
170: fnd_message.raise_error;
171: --
172: end if;

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

165: -- raise error as this < > criteria already exists for this profile
166: --
167: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
168: fnd_message.set_token('VAR1','Cobra qualified beneficiary criteria',TRUE);
169: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
170: fnd_message.raise_error;
171: --
172: end if;
173: close c_dup;

Line 170: fnd_message.raise_error;

166: --
167: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
168: fnd_message.set_token('VAR1','Cobra qualified beneficiary criteria',TRUE);
169: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
170: fnd_message.raise_error;
171: --
172: end if;
173: close c_dup;
174: --

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

390: p_effective_date => p_effective_date) then
391: --
392: -- raise error as does not exist as lookup
393: --
394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
395: fnd_message.set_token('FIELD','p_quald_bnf_flag');
396: fnd_message.set_token('TYPE','YES_NO');
397: fnd_message.raise_error;
398: --

Line 395: fnd_message.set_token('FIELD','p_quald_bnf_flag');

391: --
392: -- raise error as does not exist as lookup
393: --
394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
395: fnd_message.set_token('FIELD','p_quald_bnf_flag');
396: fnd_message.set_token('TYPE','YES_NO');
397: fnd_message.raise_error;
398: --
399: end if;

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

392: -- raise error as does not exist as lookup
393: --
394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
395: fnd_message.set_token('FIELD','p_quald_bnf_flag');
396: fnd_message.set_token('TYPE','YES_NO');
397: fnd_message.raise_error;
398: --
399: end if;
400: --

Line 397: fnd_message.raise_error;

393: --
394: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
395: fnd_message.set_token('FIELD','p_quald_bnf_flag');
396: fnd_message.set_token('TYPE','YES_NO');
397: fnd_message.raise_error;
398: --
399: end if;
400: --
401: end if;

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

460: open c1;
461: fetch c1 into l_dummy;
462: --
463: if c1%found then
464: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
465: fnd_message.raise_error;
466: end if;
467: close c1;
468: --

Line 465: fnd_message.raise_error;

461: fetch c1 into l_dummy;
462: --
463: if c1%found then
464: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
465: fnd_message.raise_error;
466: end if;
467: close c1;
468: --
469: hr_utility.set_location('Leaving:'||l_proc, 15);

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

584: --
585: -- An unhandled or unexpected error has occurred which
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_update_validate;

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

585: -- An unhandled or unexpected error has occurred which
586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_update_validate;
593: --

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

586: -- we must report
587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_update_validate;
593: --
594: -- ----------------------------------------------------------------------------

Line 591: fnd_message.raise_error;

587: --
588: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
589: fnd_message.set_token('PROCEDURE', l_proc);
590: fnd_message.set_token('STEP','15');
591: fnd_message.raise_error;
592: End dt_update_validate;
593: --
594: -- ----------------------------------------------------------------------------
595: -- |--------------------------< dt_delete_validate >--------------------------|

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

680: --
681: -- A referential integrity check was violated therefore
682: -- we must error
683: --
684: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
685: fnd_message.set_token('TABLE_NAME', l_table_name);
686: fnd_message.raise_error;
687: When Others Then
688: --

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

681: -- A referential integrity check was violated therefore
682: -- we must error
683: --
684: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
685: fnd_message.set_token('TABLE_NAME', l_table_name);
686: fnd_message.raise_error;
687: When Others Then
688: --
689: -- An unhandled or unexpected error has occurred which

Line 686: fnd_message.raise_error;

682: -- we must error
683: --
684: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
685: fnd_message.set_token('TABLE_NAME', l_table_name);
686: fnd_message.raise_error;
687: When Others Then
688: --
689: -- An unhandled or unexpected error has occurred which
690: -- we must report

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

688: --
689: -- An unhandled or unexpected error has occurred which
690: -- we must report
691: --
692: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
693: fnd_message.set_token('PROCEDURE', l_proc);
694: fnd_message.set_token('STEP','15');
695: fnd_message.raise_error;
696: End dt_delete_validate;

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

689: -- An unhandled or unexpected error has occurred which
690: -- we must report
691: --
692: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
693: fnd_message.set_token('PROCEDURE', l_proc);
694: fnd_message.set_token('STEP','15');
695: fnd_message.raise_error;
696: End dt_delete_validate;
697: --

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

690: -- we must report
691: --
692: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
693: fnd_message.set_token('PROCEDURE', l_proc);
694: fnd_message.set_token('STEP','15');
695: fnd_message.raise_error;
696: End dt_delete_validate;
697: --
698: -- ----------------------------------------------------------------------------

Line 695: fnd_message.raise_error;

691: --
692: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
693: fnd_message.set_token('PROCEDURE', l_proc);
694: fnd_message.set_token('STEP','15');
695: fnd_message.raise_error;
696: End dt_delete_validate;
697: --
698: -- ----------------------------------------------------------------------------
699: -- |---------------------------< insert_validate >----------------------------|

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

907: close csr_leg_code;
908: --
909: -- The primary key is invalid therefore we must error
910: --
911: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
912: fnd_message.raise_error;
913: --
914: end if;
915: --

Line 912: fnd_message.raise_error;

908: --
909: -- The primary key is invalid therefore we must error
910: --
911: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
912: fnd_message.raise_error;
913: --
914: end if;
915: --
916: close csr_leg_code;