35: WHEN app_exception.record_lock_exception THEN
36: po_message_s.app_error ('PO_ALL_CANNOT_RESERVE_RECORD');
37:
38: WHEN OTHERS THEN
39: dbms_output.put_line('In Exception');
40: PO_MESSAGE_S.SQL_ERROR('LOCK_ROW_FOR_STATUS_UPDATE', x_progress, sqlcode);
41: RAISE;
42: END;
43:
93: /* Bug 2904413 */
94: X_progress := '050';
95:
96: po_releases_pkg_s2.delete_row(X_row_id);
97: -- dbms_output.put_line('after call to delete row');
98:
99: /*
100: ** Call the cover routine to delete all of the children
101: */
99: /*
100: ** Call the cover routine to delete all of the children
101: */
102: po_releases_sv.delete_children(X_po_release_id);
103: -- dbms_output.put_line('after delete children');
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: -- dbms_output.put_line('In exception');
103: -- dbms_output.put_line('after delete children');
104:
105: EXCEPTION
106: WHEN OTHERS THEN
107: -- dbms_output.put_line('In exception');
108: po_message_s.sql_error('delete_release', X_progress, sqlcode);
109: raise;
110: END delete_release;
111:
193:
194:
195: EXCEPTION
196: WHEN OTHERS THEN
197: dbms_output.put_line('In exception');
198: po_message_s.sql_error('delete_children', X_progress, sqlcode);
199: END delete_children;
200:
201: