278: exception
279: when no_data_found then
280: null;
281: when others then
282: po_message_s.sql_error('default_po_dist_interface',x_progress,
283: sqlcode);
284: raise;
285: end;
286: end if;
295: exception
296: when no_data_found then
297: null;
298: when others then
299: po_message_s.sql_error('default_po_dist_interface',x_progress,
300: sqlcode);
301: raise;
302: end;
303: end if;
312: exception
313: when no_data_found then
314: null;
315: when others then
316: po_message_s.sql_error('default_po_dist_interface',x_progress,
317: sqlcode);
318: raise;
319: end;
320: end if;
328: exception
329: when no_data_found then
330: null;
331: when others then
332: po_message_s.sql_error('default_po_dist_interface',x_progress,
333: sqlcode);
334: raise;
335: end;
336: end if;
419: po_periods_sv.get_period_name(x_def_sob_id,
420: x_gl_date,
421: l_gl_encumbered_period);
422: IF l_gl_encumbered_period is NULL THEN
423: --po_message_s.sql_error('default_po_dist_interface',x_progress,sqlcode);
424: null;--raise;
425: END IF;
426: ELSE
427: l_gl_encumbered_date := NULL;
652:
653:
654: EXCEPTION
655: WHEN others THEN
656: po_message_s.sql_error('default_po_dist_interface', X_progress, sqlcode);
657: raise;
658: END default_po_dist_interface;
659:
660:
911: x_column1);
912: end if;
913: exception
914: when others then
915: po_message_s.sql_error('handle_sourcing_attachments',x_progress,sqlcode);
916: raise;
917: end handle_sourcing_attachments;
918:
919:
1285:
1286: CLOSE shorttext;
1287: CLOSE longtext;
1288: CLOSE fnd_lobs_cur;
1289: po_message_s.sql_error('copy_attachments',x_progress, sqlcode);
1290: raise;
1291: END copy_attachments;
1292:
1293: PROCEDURE add_attch_dynamic(
1495:
1496: EXCEPTION
1497: --Bug# 2288408
1498: WHEN pon_get_attachment_exception then
1499: po_message_s.sql_error('add_attch_dynamic',x_progress, sqlcode);
1500: raise;
1501: WHEN OTHERS THEN
1502: po_message_s.sql_error('add_attch_dynamic',x_progress, sqlcode);
1503: raise;
1498: WHEN pon_get_attachment_exception then
1499: po_message_s.sql_error('add_attch_dynamic',x_progress, sqlcode);
1500: raise;
1501: WHEN OTHERS THEN
1502: po_message_s.sql_error('add_attch_dynamic',x_progress, sqlcode);
1503: raise;
1504: END add_attch_dynamic;
1505:
1506:
1627:
1628: EXCEPTION
1629:
1630: WHEN OTHERS THEN
1631: PO_MESSAGE_S.sql_error ( 'PO_NEGOTIATIONS_SV2.CONVERT_TEXT_TO_ATTACHMENT', '000', SQLCODE );
1632: RAISE;
1633:
1634: END convert_text_to_attachment;
1635: