118: /* Single element linked to more than one absence category */
119:
120: if c_absence_category%ROWCOUNT > 1
121: then
122: fnd_message.set_name('PAY', 'HR_AU_NZ_DUP_ELEMENT_FOUND');
123: fnd_message.set_token('ELEMENT', l_element_name);
124: fnd_message.raise_error;
125: end if;
126: end loop;
119:
120: if c_absence_category%ROWCOUNT > 1
121: then
122: fnd_message.set_name('PAY', 'HR_AU_NZ_DUP_ELEMENT_FOUND');
123: fnd_message.set_token('ELEMENT', l_element_name);
124: fnd_message.raise_error;
125: end if;
126: end loop;
127:
120: if c_absence_category%ROWCOUNT > 1
121: then
122: fnd_message.set_name('PAY', 'HR_AU_NZ_DUP_ELEMENT_FOUND');
123: fnd_message.set_token('ELEMENT', l_element_name);
124: fnd_message.raise_error;
125: end if;
126: end loop;
127:
128: close c_absence_category;