134: p_effective_date => p_effective_date) then
135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
139: fnd_message.raise_error;
140: --
141: end if;
142: --
135: --
136: -- raise error as does not exist as lookup
137: --
138: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
139: fnd_message.raise_error;
140: --
141: end if;
142: --
143: end if;
229: close c_dup;
230: --
231: -- raise error as this Leave of Absence criteria already exists for this profile
232: --
233: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
234: fnd_message.set_token('VAR1','Leave of Absence criteria',TRUE);
235: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
236: fnd_message.raise_error;
237: --
230: --
231: -- raise error as this Leave of Absence criteria already exists for this profile
232: --
233: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
234: fnd_message.set_token('VAR1','Leave of Absence criteria',TRUE);
235: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
236: fnd_message.raise_error;
237: --
238: end if;
231: -- raise error as this Leave of Absence criteria already exists for this profile
232: --
233: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
234: fnd_message.set_token('VAR1','Leave of Absence criteria',TRUE);
235: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
236: fnd_message.raise_error;
237: --
238: end if;
239: close c_dup;
232: --
233: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
234: fnd_message.set_token('VAR1','Leave of Absence criteria',TRUE);
235: fnd_message.set_token('VAR2','Variable Rate Profile',TRUE);
236: fnd_message.raise_error;
237: --
238: end if;
239: close c_dup;
240: --
293: open c1;
294: fetch c1 into l_dummy;
295: --
296: if c1%found then
297: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
294: fetch c1 into l_dummy;
295: --
296: if c1%found then
297: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 15);
359: p_effective_date => p_effective_date) then
360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
360: --
361: -- raise error as does not exist as lookup
362: --
363: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
364: fnd_message.raise_error;
365: --
366: end if;
367: --
368: end if;
624: --
625: -- An unhandled or unexpected error has occurred which
626: -- we must report
627: --
628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE', l_proc);
630: fnd_message.set_token('STEP','15');
631: fnd_message.raise_error;
632: End dt_update_validate;
625: -- An unhandled or unexpected error has occurred which
626: -- we must report
627: --
628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE', l_proc);
630: fnd_message.set_token('STEP','15');
631: fnd_message.raise_error;
632: End dt_update_validate;
633: --
626: -- we must report
627: --
628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE', l_proc);
630: fnd_message.set_token('STEP','15');
631: fnd_message.raise_error;
632: End dt_update_validate;
633: --
634: -- ----------------------------------------------------------------------------
627: --
628: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE', l_proc);
630: fnd_message.set_token('STEP','15');
631: fnd_message.raise_error;
632: End dt_update_validate;
633: --
634: -- ----------------------------------------------------------------------------
635: -- |--------------------------< dt_delete_validate >--------------------------|
720: --
721: -- A referential integrity check was violated therefore
722: -- we must error
723: --
724: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
725: fnd_message.set_token('TABLE_NAME', l_table_name);
726: fnd_message.raise_error;
727: When Others Then
728: --
721: -- A referential integrity check was violated therefore
722: -- we must error
723: --
724: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
725: fnd_message.set_token('TABLE_NAME', l_table_name);
726: fnd_message.raise_error;
727: When Others Then
728: --
729: -- An unhandled or unexpected error has occurred which
722: -- we must error
723: --
724: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
725: fnd_message.set_token('TABLE_NAME', l_table_name);
726: fnd_message.raise_error;
727: When Others Then
728: --
729: -- An unhandled or unexpected error has occurred which
730: -- we must report
728: --
729: -- An unhandled or unexpected error has occurred which
730: -- we must report
731: --
732: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
733: fnd_message.set_token('PROCEDURE', l_proc);
734: fnd_message.set_token('STEP','15');
735: fnd_message.raise_error;
736: End dt_delete_validate;
729: -- An unhandled or unexpected error has occurred which
730: -- we must report
731: --
732: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
733: fnd_message.set_token('PROCEDURE', l_proc);
734: fnd_message.set_token('STEP','15');
735: fnd_message.raise_error;
736: End dt_delete_validate;
737: --
730: -- we must report
731: --
732: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
733: fnd_message.set_token('PROCEDURE', l_proc);
734: fnd_message.set_token('STEP','15');
735: fnd_message.raise_error;
736: End dt_delete_validate;
737: --
738: -- ----------------------------------------------------------------------------
731: --
732: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
733: fnd_message.set_token('PROCEDURE', l_proc);
734: fnd_message.set_token('STEP','15');
735: fnd_message.raise_error;
736: End dt_delete_validate;
737: --
738: -- ----------------------------------------------------------------------------
739: -- |---------------------------< insert_validate >----------------------------|
956: close csr_leg_code;
957: --
958: -- The primary key is invalid therefore we must error
959: --
960: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
961: fnd_message.raise_error;
962: --
963: end if;
964: --
957: --
958: -- The primary key is invalid therefore we must error
959: --
960: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
961: fnd_message.raise_error;
962: --
963: end if;
964: --
965: close csr_leg_code;