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;
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: --
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: --
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
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:
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:
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:
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:
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 ;
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;
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: --
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
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.
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: --
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
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
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >--------------------------|
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: --
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
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
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: --
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;
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: --
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: -- ----------------------------------------------------------------------------