123: open c;
124: fetch c into X_ROWID;
125: if (c%notfound) then
126: close c;
127: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
128: hr_utility.set_message_token('PROCEDURE',
129: 'hr_ki_options.insert_row');
130: hr_utility.set_message_token('STEP','1');
131: hr_utility.raise_error;
124: fetch c into X_ROWID;
125: if (c%notfound) then
126: close c;
127: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
128: hr_utility.set_message_token('PROCEDURE',
129: 'hr_ki_options.insert_row');
130: hr_utility.set_message_token('STEP','1');
131: hr_utility.raise_error;
132: end if;
126: close c;
127: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
128: hr_utility.set_message_token('PROCEDURE',
129: 'hr_ki_options.insert_row');
130: hr_utility.set_message_token('STEP','1');
131: hr_utility.raise_error;
132: end if;
133: close c;
134:
127: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
128: hr_utility.set_message_token('PROCEDURE',
129: 'hr_ki_options.insert_row');
130: hr_utility.set_message_token('STEP','1');
131: hr_utility.raise_error;
132: end if;
133: close c;
134:
135: