139: /* Single element linked to more than one absence category */
140:
141: if c_absence_category%ROWCOUNT > 1
142: then
143: fnd_message.set_name('PAY', 'HR_AU_NZ_DUP_ELEMENT_FOUND');
144: fnd_message.set_token('ELEMENT', l_element_name);
145: fnd_message.raise_error;
146: end if;
147: end loop;
140:
141: if c_absence_category%ROWCOUNT > 1
142: then
143: fnd_message.set_name('PAY', 'HR_AU_NZ_DUP_ELEMENT_FOUND');
144: fnd_message.set_token('ELEMENT', l_element_name);
145: fnd_message.raise_error;
146: end if;
147: end loop;
148: close c_absence_category;
141: if c_absence_category%ROWCOUNT > 1
142: then
143: fnd_message.set_name('PAY', 'HR_AU_NZ_DUP_ELEMENT_FOUND');
144: fnd_message.set_token('ELEMENT', l_element_name);
145: fnd_message.raise_error;
146: end if;
147: end loop;
148: close c_absence_category;
149: