75: --
76: -- The primary key is invalid therefore we must error
77: --
78: close csr_leg_code;
79: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
80: fnd_message.raise_error;
81: end if;
82: hr_utility.set_location(l_proc,30);
83: --
76: -- The primary key is invalid therefore we must error
77: --
78: close csr_leg_code;
79: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
80: fnd_message.raise_error;
81: end if;
82: hr_utility.set_location(l_proc,30);
83: --
84: -- Set the global variables so the values are
134: IF NOT per_abt_shd.api_updating
135: (p_absence_attendance_type_id => p_rec.absence_attendance_type_id
136: ,p_language => p_rec.language
137: ) THEN
138: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE ', l_proc);
140: fnd_message.set_token('STEP ', '5');
141: fnd_message.raise_error;
142: END IF;
135: (p_absence_attendance_type_id => p_rec.absence_attendance_type_id
136: ,p_language => p_rec.language
137: ) THEN
138: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE ', l_proc);
140: fnd_message.set_token('STEP ', '5');
141: fnd_message.raise_error;
142: END IF;
143: --
136: ,p_language => p_rec.language
137: ) THEN
138: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE ', l_proc);
140: fnd_message.set_token('STEP ', '5');
141: fnd_message.raise_error;
142: END IF;
143: --
144: --
137: ) THEN
138: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
139: fnd_message.set_token('PROCEDURE ', l_proc);
140: fnd_message.set_token('STEP ', '5');
141: fnd_message.raise_error;
142: END IF;
143: --
144: --
145: End chk_non_updateable_args;
193: open csr_chk_unique_name;
194: fetch csr_chk_unique_name into l_dummy;
195: if csr_chk_unique_name%found then
196: close csr_chk_unique_name;
197: fnd_message.set_name('PER','HR_7806_DEF_ABS_EXISTS');
198: fnd_message.raise_error;
199: else
200: close csr_chk_unique_name;
201: end if;
194: fetch csr_chk_unique_name into l_dummy;
195: if csr_chk_unique_name%found then
196: close csr_chk_unique_name;
197: fnd_message.set_name('PER','HR_7806_DEF_ABS_EXISTS');
198: fnd_message.raise_error;
199: else
200: close csr_chk_unique_name;
201: end if;
202: end if;
354: open csr_chk_unique_name;
355: fetch csr_chk_unique_name into l_dummy;
356: if csr_chk_unique_name%found then
357: close csr_chk_unique_name;
358: fnd_message.set_name('PER','HR_7806_DEF_ABS_EXISTS');
359: fnd_message.raise_error;
360: else
361: close csr_chk_unique_name;
362: end if;
355: fetch csr_chk_unique_name into l_dummy;
356: if csr_chk_unique_name%found then
357: close csr_chk_unique_name;
358: fnd_message.set_name('PER','HR_7806_DEF_ABS_EXISTS');
359: fnd_message.raise_error;
360: else
361: close csr_chk_unique_name;
362: end if;
363: --