89:
90: EXCEPTION
91: WHEN OTHERS THEN
92: --dbms_output.put_line('In Exception');
93: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_DOCUMENT_TYPES', x_progress, sqlcode);
94: RAISE;
95: END;
96:
97: /*===========================================================================
220:
221: WHEN NO_DATA_FOUND THEN
222: RETURN;
223: WHEN OTHERS THEN
224: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_APPROVAL_PATH', x_progress, sqlcode);
225: RAISE;
226: END;
227:
228:
277: end if;
278:
279: EXCEPTION
280: WHEN OTHERS THEN
281: PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.GET_DOCUMENT_TYPES',
282: l_progress, sqlcode);
283: RAISE;
284: END get_document_types;
285: /* RETROACTIVE FPI END */
360:
361: l_progress := '100';
362: EXCEPTION
363: WHEN OTHERS THEN
364: -- PO_MESSAGE_S.SQL_ERROR('PO_APPROVE_SV.get_change_summary',
365: -- l_progress, sqlcode);
366: -- RAISE;
367: NULL;
368: END get_change_summary;