149: open c;
150: fetch c into X_ROWID;
151: if (c%notfound) then
152: close c;
153: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE',
155: 'hr_ki_option_types.insert_row');
156: hr_utility.set_message_token('STEP','1');
157: hr_utility.raise_error;
150: fetch c into X_ROWID;
151: if (c%notfound) then
152: close c;
153: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE',
155: 'hr_ki_option_types.insert_row');
156: hr_utility.set_message_token('STEP','1');
157: hr_utility.raise_error;
158: end if;
152: close c;
153: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE',
155: 'hr_ki_option_types.insert_row');
156: hr_utility.set_message_token('STEP','1');
157: hr_utility.raise_error;
158: end if;
159: close c;
160:
153: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
154: hr_utility.set_message_token('PROCEDURE',
155: 'hr_ki_option_types.insert_row');
156: hr_utility.set_message_token('STEP','1');
157: hr_utility.raise_error;
158: end if;
159: close c;
160:
161: