92: close c;
93:
94: EXCEPTION
95: when others then
96: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
97: p_procedure_name => 'INSERT_ROW',
98: p_error_text => SUBSTRB(SQLERRM, 1, 240));
99: x_return_status := fnd_api.g_ret_sts_unexp_error;
100: raise;
163: and record_version_number = p_record_version_number;
164:
165: if (sql%notfound) then
166: fnd_message.set_name('IGW', 'IGW_SS_RECORD_CHANGED');
167: fnd_msg_pub.Add;
168: x_return_status := 'E';
169: end if;
170:
171: EXCEPTION
169: end if;
170:
171: EXCEPTION
172: when others then
173: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
174: p_procedure_name => 'UPDATE_ROW',
175: p_error_text => SUBSTRB(SQLERRM, 1, 240));
176: x_return_status := fnd_api.g_ret_sts_unexp_error;
177: raise;
194: and record_version_number = p_record_version_number;
195:
196: if (sql%notfound) then
197: fnd_message.set_name('IGW', 'IGW_SS_RECORD_CHANGED');
198: fnd_msg_pub.Add;
199: x_return_status := 'E';
200: end if;
201:
202:
201:
202:
203: EXCEPTION
204: when others then
205: fnd_msg_pub.add_exc_msg(p_pkg_name => 'IGW_PROP_NARRATIVES_TBH',
206: p_procedure_name => 'DELETE_ROW',
207: p_error_text => SUBSTRB(SQLERRM, 1, 240));
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: raise;