DBA Data[Home] [Help]

APPS.PO_RELEASES_SV dependencies on DBMS_OUTPUT

Line 39: dbms_output.put_line('In Exception');

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:

Line 104: -- dbms_output.put_line('after delete children');

100: */
101:
102: po_headers_sv1.delete_events_entities('RELEASE', X_po_release_id);
103: po_releases_sv.delete_children(X_po_release_id);
104: -- dbms_output.put_line('after delete children');
105:
106: po_releases_pkg_s2.delete_row(X_row_id);
107: -- dbms_output.put_line('after call to delete row');
108:

Line 107: -- dbms_output.put_line('after call to delete row');

103: po_releases_sv.delete_children(X_po_release_id);
104: -- dbms_output.put_line('after delete children');
105:
106: po_releases_pkg_s2.delete_row(X_row_id);
107: -- dbms_output.put_line('after call to delete row');
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: -- dbms_output.put_line('In exception');

Line 111: -- dbms_output.put_line('In exception');

107: -- dbms_output.put_line('after call to delete row');
108:
109: EXCEPTION
110: WHEN OTHERS THEN
111: -- dbms_output.put_line('In exception');
112: po_message_s.sql_error('delete_release', X_progress, sqlcode);
113: raise;
114: END delete_release;
115:

Line 201: dbms_output.put_line('In exception');

197:
198:
199: EXCEPTION
200: WHEN OTHERS THEN
201: dbms_output.put_line('In exception');
202: po_message_s.sql_error('delete_children', X_progress, sqlcode);
203: END delete_children;
204:
205: