149: );
150: x_percent_complete_id := l_percent_complete_id;
151: exception when others then
152: x_percent_complete_id := NULL;
153: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PERCENT_COMPLETES_PKG',
154: p_procedure_name => 'INSERT_ROW',
155: p_error_text => SUBSTRB(SQLERRM,1,240));
156: raise;
157: End;
267: and record_version_number = p_record_version_number;
268:
269: if (sql%notfound) then
270: fnd_message.set_name('PA','PA_XC_RECORD_CHANGED');
271: fnd_msg_pub.add;
272: end if;
273:
274: exception when others then
275: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PERCENT_COMPLETES_PKG',
271: fnd_msg_pub.add;
272: end if;
273:
274: exception when others then
275: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_PERCENT_COMPLETES_PKG',
276: p_procedure_name => 'UPDATE_ROW',
277: p_error_text => SUBSTRB(SQLERRM,1,240));
278: raise;
279: End UPDATE_ROW;