136: if c_uniq_optip%found then
137: --
138: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
139: close c_uniq_optip ;
140: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
141: fnd_message.raise_error;
142: --
143: end if;
144: close c_uniq_optip ;
137: --
138: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
139: close c_uniq_optip ;
140: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
141: fnd_message.raise_error;
142: --
143: end if;
144: close c_uniq_optip ;
145: --
189: close csr_sec_grp;
190: --
191: -- The primary key is invalid therefore we must error
192: --
193: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
194: fnd_message.raise_error;
195: --
196: end if;
197: close csr_sec_grp;
190: --
191: -- The primary key is invalid therefore we must error
192: --
193: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
194: fnd_message.raise_error;
195: --
196: end if;
197: close csr_sec_grp;
198: --
266: --
267: -- The primary key is invalid therefore we must error
268: --
269: close csr_leg_code;
270: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
271: fnd_message.raise_error;
272: end if;
273: hr_utility.set_location(l_proc,30);
274: --
267: -- The primary key is invalid therefore we must error
268: --
269: close csr_leg_code;
270: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
271: fnd_message.raise_error;
272: end if;
273: hr_utility.set_location(l_proc,30);
274: --
275: -- Set the global variables so the values are
517: (p_optip_id => p_rec.optip_id
518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_rec.object_version_number
520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;
518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_rec.object_version_number
520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;
526: --
519: ,p_object_version_number => p_rec.object_version_number
520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;
526: --
527: -- EDIT_HERE: Add checks to ensure non-updateable args have
520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;
526: --
527: -- EDIT_HERE: Add checks to ensure non-updateable args have
528: -- not been updated.
641: --
642: -- A referential integrity check was violated therefore
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
642: -- A referential integrity check was violated therefore
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
650: -- An unhandled or unexpected error has occurred which
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
650: -- An unhandled or unexpected error has occurred which
651: -- we must report
649: --
650: -- An unhandled or unexpected error has occurred which
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
650: -- An unhandled or unexpected error has occurred which
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
659: -- ----------------------------------------------------------------------------
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
659: -- ----------------------------------------------------------------------------
660: -- |--------------------------< dt_delete_validate >--------------------------|
748: --
749: -- A referential integrity check was violated therefore
750: -- we must error
751: --
752: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
753: fnd_message.set_token('TABLE_NAME', l_table_name);
754: fnd_message.raise_error;
755: When Others Then
756: --
749: -- A referential integrity check was violated therefore
750: -- we must error
751: --
752: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
753: fnd_message.set_token('TABLE_NAME', l_table_name);
754: fnd_message.raise_error;
755: When Others Then
756: --
757: -- An unhandled or unexpected error has occurred which
750: -- we must error
751: --
752: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
753: fnd_message.set_token('TABLE_NAME', l_table_name);
754: fnd_message.raise_error;
755: When Others Then
756: --
757: -- An unhandled or unexpected error has occurred which
758: -- we must report
756: --
757: -- An unhandled or unexpected error has occurred which
758: -- we must report
759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --
757: -- An unhandled or unexpected error has occurred which
758: -- we must report
759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --
765: End dt_delete_validate;
758: -- we must report
759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --
765: End dt_delete_validate;
766: --
759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --
765: End dt_delete_validate;
766: --
767: -- ----------------------------------------------------------------------------