55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name(801,'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(801,'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(801,'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(801,'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
190: (p_iterative_rule_id => p_rec.iterative_rule_id
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- EDIT_HERE: Add checks to ensure non-updateable args have
193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- EDIT_HERE: Add checks to ensure non-updateable args have
201: -- not been updated.
513: pay_itr_shd.constraint_error('PAY_ITR_SEV_LEVEL_CHK');
514: end if;
515: --
516: if (p_input_value_id is not null) then
517: fnd_message.set_name('PAY', 'PAY_52906_ITR_MESSAGE_ERRROR');
518: fnd_message.raise_error;
519: end if;
520: --
521: elsif (p_iterative_rule_type = 'A') then
514: end if;
515: --
516: if (p_input_value_id is not null) then
517: fnd_message.set_name('PAY', 'PAY_52906_ITR_MESSAGE_ERRROR');
518: fnd_message.raise_error;
519: end if;
520: --
521: elsif (p_iterative_rule_type = 'A') then
522: --
529: open C1;
530: fetch C1 into l_exists;
531: if ( C1%notfound ) then
532: close C1;
533: fnd_message.set_name('PAY', 'PAY_52904_ITR_INPVAL_ERROR');
534: fnd_message.raise_error;
535: else Close c1;
536: end if;
537: --
530: fetch C1 into l_exists;
531: if ( C1%notfound ) then
532: close C1;
533: fnd_message.set_name('PAY', 'PAY_52904_ITR_INPVAL_ERROR');
534: fnd_message.raise_error;
535: else Close c1;
536: end if;
537: --
538: if (p_severity_level is not null) then
535: else Close c1;
536: end if;
537: --
538: if (p_severity_level is not null) then
539: fnd_message.set_name('PAY', 'PAY_52907_ITR_ADJUST_ERROR');
540: fnd_message.raise_error;
541: end if;
542: --
543: elsif (p_iterative_rule_type = 'S') then
536: end if;
537: --
538: if (p_severity_level is not null) then
539: fnd_message.set_name('PAY', 'PAY_52907_ITR_ADJUST_ERROR');
540: fnd_message.raise_error;
541: end if;
542: --
543: elsif (p_iterative_rule_type = 'S') then
544: if (p_input_value_id is not null or p_severity_level is not null) then
541: end if;
542: --
543: elsif (p_iterative_rule_type = 'S') then
544: if (p_input_value_id is not null or p_severity_level is not null) then
545: fnd_message.set_name('PAY', 'PAY_52905_ITR_STOP_ERROR');
546: fnd_message.raise_error;
547: end if;
548: end if;
549: end chk_iterative_rule_cond;
542: --
543: elsif (p_iterative_rule_type = 'S') then
544: if (p_input_value_id is not null or p_severity_level is not null) then
545: fnd_message.set_name('PAY', 'PAY_52905_ITR_STOP_ERROR');
546: fnd_message.raise_error;
547: end if;
548: end if;
549: end chk_iterative_rule_cond;
550: --
620: --
621: -- A referential integrity check was violated therefore
622: -- we must error
623: --
624: fnd_message.set_name(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --
621: -- A referential integrity check was violated therefore
622: -- we must error
623: --
624: fnd_message.set_name(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --
629: -- An unhandled or unexpected error has occurred which
622: -- we must error
623: --
624: fnd_message.set_name(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --
629: -- An unhandled or unexpected error has occurred which
630: -- we must report
628: --
629: -- An unhandled or unexpected error has occurred which
630: -- we must report
631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;
629: -- An unhandled or unexpected error has occurred which
630: -- we must report
631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;
637: --
630: -- we must report
631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;
637: --
638: -- ----------------------------------------------------------------------------
631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;
637: --
638: -- ----------------------------------------------------------------------------
639: -- |--------------------------< dt_delete_validate >--------------------------|
727: --
728: -- A referential integrity check was violated therefore
729: -- we must error
730: --
731: fnd_message.set_name(801, 'HR_7215_DT_CHILD_EXISTS');
732: fnd_message.set_token('TABLE_NAME', l_table_name);
733: fnd_message.raise_error;
734: When Others Then
735: --
728: -- A referential integrity check was violated therefore
729: -- we must error
730: --
731: fnd_message.set_name(801, 'HR_7215_DT_CHILD_EXISTS');
732: fnd_message.set_token('TABLE_NAME', l_table_name);
733: fnd_message.raise_error;
734: When Others Then
735: --
736: -- An unhandled or unexpected error has occurred which
729: -- we must error
730: --
731: fnd_message.set_name(801, 'HR_7215_DT_CHILD_EXISTS');
732: fnd_message.set_token('TABLE_NAME', l_table_name);
733: fnd_message.raise_error;
734: When Others Then
735: --
736: -- An unhandled or unexpected error has occurred which
737: -- we must report
735: --
736: -- An unhandled or unexpected error has occurred which
737: -- we must report
738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --
736: -- An unhandled or unexpected error has occurred which
737: -- we must report
738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --
744: End dt_delete_validate;
737: -- we must report
738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --
744: End dt_delete_validate;
745: --
738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --
744: End dt_delete_validate;
745: --
746: -- ----------------------------------------------------------------------------