DBA Data[Home] [Help]

APPS.BEN_PRY_BUS dependencies on FND_MESSAGE

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

55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;

Line 60: fnd_message.raise_error;

56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --

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

128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --

Line 133: fnd_message.raise_error;

129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are

Line 282: fnd_message.set_name('BEN', 'BEN_92713_PYMT_MORE_THAN_RMT');

278:
279:
280: --- whne the total submited more than requst amounnt throw errors
281: if nvl(l_total_pymt_amt,0) + p_rec.aprvd_fr_pymt_amt > nvl(l_rqst_amt,0) then
282: fnd_message.set_name('BEN', 'BEN_92713_PYMT_MORE_THAN_RMT');
283: fnd_message.raise_error;
284: end if ;
285: --
286:

Line 283: fnd_message.raise_error;

279:
280: --- whne the total submited more than requst amounnt throw errors
281: if nvl(l_total_pymt_amt,0) + p_rec.aprvd_fr_pymt_amt > nvl(l_rqst_amt,0) then
282: fnd_message.set_name('BEN', 'BEN_92713_PYMT_MORE_THAN_RMT');
283: fnd_message.raise_error;
284: end if ;
285: --
286:
287:

Line 491: fnd_message.set_name('BEN','BEN_92662_AMT_EXCEEDS_BAL');

487:
488: if nvl(l_rqst_amt,0) + nvl(p_rec.aprvd_fr_pymt_amt,0)- nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0)
489: > l_total_pymt_amt then
490:
491: fnd_message.set_name('BEN','BEN_92662_AMT_EXCEEDS_BAL');
492: fnd_message.set_token('BAL', l_total_pymt_amt );
493: fnd_message.raise_error;
494: end if ;
495:

Line 492: fnd_message.set_token('BAL', l_total_pymt_amt );

488: if nvl(l_rqst_amt,0) + nvl(p_rec.aprvd_fr_pymt_amt,0)- nvl(ben_pry_shd.g_old_rec.aprvd_fr_pymt_amt,0)
489: > l_total_pymt_amt then
490:
491: fnd_message.set_name('BEN','BEN_92662_AMT_EXCEEDS_BAL');
492: fnd_message.set_token('BAL', l_total_pymt_amt );
493: fnd_message.raise_error;
494: end if ;
495:
496:

Line 493: fnd_message.raise_error;

489: > l_total_pymt_amt then
490:
491: fnd_message.set_name('BEN','BEN_92662_AMT_EXCEEDS_BAL');
492: fnd_message.set_token('BAL', l_total_pymt_amt );
493: fnd_message.raise_error;
494: end if ;
495:
496:
497: end if ;

Line 729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

725: (p_prtt_rmt_aprvd_fr_pymt_id => p_rec.prtt_rmt_aprvd_fr_pymt_id
726: ,p_effective_date => p_effective_date
727: ,p_object_version_number => p_rec.object_version_number
728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;

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

726: ,p_effective_date => p_effective_date
727: ,p_object_version_number => p_rec.object_version_number
728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;
734: --

Line 731: fnd_message.set_token('STEP ', '5');

727: ,p_object_version_number => p_rec.object_version_number
728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;
734: --
735: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 732: fnd_message.raise_error;

728: ) THEN
729: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
730: fnd_message.set_token('PROCEDURE ', l_proc);
731: fnd_message.set_token('STEP ', '5');
732: fnd_message.raise_error;
733: END IF;
734: --
735: -- EDIT_HERE: Add checks to ensure non-updateable args have
736: -- not been updated.

Line 830: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

826: --
827: -- A referential integrity check was violated therefore
828: -- we must error
829: --
830: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
831: fnd_message.set_token('TABLE_NAME', l_table_name);
832: fnd_message.raise_error;
833: When Others Then
834: --

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

827: -- A referential integrity check was violated therefore
828: -- we must error
829: --
830: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
831: fnd_message.set_token('TABLE_NAME', l_table_name);
832: fnd_message.raise_error;
833: When Others Then
834: --
835: -- An unhandled or unexpected error has occurred which

Line 832: fnd_message.raise_error;

828: -- we must error
829: --
830: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
831: fnd_message.set_token('TABLE_NAME', l_table_name);
832: fnd_message.raise_error;
833: When Others Then
834: --
835: -- An unhandled or unexpected error has occurred which
836: -- we must report

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

834: --
835: -- An unhandled or unexpected error has occurred which
836: -- we must report
837: --
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','15');
841: fnd_message.raise_error;
842: End dt_update_validate;

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

835: -- An unhandled or unexpected error has occurred which
836: -- we must report
837: --
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','15');
841: fnd_message.raise_error;
842: End dt_update_validate;
843: --

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

836: -- we must report
837: --
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','15');
841: fnd_message.raise_error;
842: End dt_update_validate;
843: --
844: -- ----------------------------------------------------------------------------

Line 841: fnd_message.raise_error;

837: --
838: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
839: fnd_message.set_token('PROCEDURE', l_proc);
840: fnd_message.set_token('STEP','15');
841: fnd_message.raise_error;
842: End dt_update_validate;
843: --
844: -- ----------------------------------------------------------------------------
845: -- |--------------------------< dt_delete_validate >--------------------------|

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

933: --
934: -- A referential integrity check was violated therefore
935: -- we must error
936: --
937: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
938: fnd_message.set_token('TABLE_NAME', l_table_name);
939: fnd_message.raise_error;
940: When Others Then
941: --

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

934: -- A referential integrity check was violated therefore
935: -- we must error
936: --
937: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
938: fnd_message.set_token('TABLE_NAME', l_table_name);
939: fnd_message.raise_error;
940: When Others Then
941: --
942: -- An unhandled or unexpected error has occurred which

Line 939: fnd_message.raise_error;

935: -- we must error
936: --
937: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
938: fnd_message.set_token('TABLE_NAME', l_table_name);
939: fnd_message.raise_error;
940: When Others Then
941: --
942: -- An unhandled or unexpected error has occurred which
943: -- we must report

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

941: --
942: -- An unhandled or unexpected error has occurred which
943: -- we must report
944: --
945: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
946: fnd_message.set_token('PROCEDURE', l_proc);
947: fnd_message.set_token('STEP','15');
948: fnd_message.raise_error;
949: --

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

942: -- An unhandled or unexpected error has occurred which
943: -- we must report
944: --
945: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
946: fnd_message.set_token('PROCEDURE', l_proc);
947: fnd_message.set_token('STEP','15');
948: fnd_message.raise_error;
949: --
950: End dt_delete_validate;

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

943: -- we must report
944: --
945: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
946: fnd_message.set_token('PROCEDURE', l_proc);
947: fnd_message.set_token('STEP','15');
948: fnd_message.raise_error;
949: --
950: End dt_delete_validate;
951: --

Line 948: fnd_message.raise_error;

944: --
945: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
946: fnd_message.set_token('PROCEDURE', l_proc);
947: fnd_message.set_token('STEP','15');
948: fnd_message.raise_error;
949: --
950: End dt_delete_validate;
951: --
952: -- ----------------------------------------------------------------------------