[Home] [Help]
1: package body PA_PERCENT_COMPLETES_PKG as
2: /* $Header: PAPCPKGB.pls 120.1.12020000.2 2013/03/28 12:52:37 bpottipa ship $*/
3:
4: procedure INSERT_ROW( p_TASK_ID IN NUMBER,
5: p_DATE_COMPUTED IN DATE,
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;
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;