72: END IF;
73:
74: EXCEPTION
75: WHEN OTHERS THEN
76: PO_MESSAGE_S.add_exc_msg
77: (
78: p_pkg_name => d_pkg_name,
79: p_procedure_name => d_api_name || '.' || d_position
80: );
151: RETURN g_quotation_class_code_tbl(p_doc_subtype);
152:
153: EXCEPTION
154: WHEN OTHERS THEN
155: PO_MESSAGE_S.add_exc_msg
156: (
157: p_pkg_name => d_pkg_name,
158: p_procedure_name => d_api_name || '.' || d_position
159: );
315: END IF;
316:
317: EXCEPTION
318: WHEN OTHERS THEN
319: PO_MESSAGE_S.add_exc_msg
320: (
321: p_pkg_name => d_pkg_name,
322: p_procedure_name => d_api_name || '.' || d_position
323: );
376:
377: RETURN g_max_line_num_tbl(p_po_header_id);
378: EXCEPTION
379: WHEN OTHERS THEN
380: PO_MESSAGE_S.add_exc_msg
381: (
382: p_pkg_name => d_pkg_name,
383: p_procedure_name => d_api_name || '.' || d_position
384: );
559: END IF;
560:
561: EXCEPTION
562: WHEN OTHERS THEN
563: PO_MESSAGE_S.add_exc_msg
564: (
565: p_pkg_name => d_pkg_name,
566: p_procedure_name => d_api_name || '.' || d_position
567: );
752: END IF;
753:
754: EXCEPTION
755: WHEN OTHERS THEN
756: PO_MESSAGE_S.add_exc_msg
757: (
758: p_pkg_name => d_pkg_name,
759: p_procedure_name => d_api_name || '.' || d_position
760: );
985: END IF;
986:
987: EXCEPTION
988: WHEN OTHERS THEN
989: PO_MESSAGE_S.add_exc_msg
990: (
991: p_pkg_name => d_pkg_name,
992: p_procedure_name => d_api_name || '.' || d_position
993: );
1147: END IF;
1148:
1149: EXCEPTION
1150: WHEN OTHERS THEN
1151: PO_MESSAGE_S.add_exc_msg
1152: (
1153: p_pkg_name => d_pkg_name,
1154: p_procedure_name => d_api_name || '.' || d_position
1155: );
1256:
1257: RETURN l_next_dist_id;
1258: EXCEPTION
1259: WHEN OTHERS THEN
1260: PO_MESSAGE_S.add_exc_msg
1261: (
1262: p_pkg_name => d_pkg_name,
1263: p_procedure_name => d_api_name || '.' || d_position
1264: );
1390: END IF;
1391:
1392: EXCEPTION
1393: WHEN OTHERS THEN
1394: PO_MESSAGE_S.add_exc_msg
1395: (
1396: p_pkg_name => d_pkg_name,
1397: p_procedure_name => d_api_name || '.' || d_position
1398: );
1550: END IF;
1551:
1552: EXCEPTION
1553: WHEN OTHERS THEN
1554: PO_MESSAGE_S.add_exc_msg
1555: (
1556: p_pkg_name => d_pkg_name,
1557: p_procedure_name => d_api_name || '.' || d_position
1558: );
1785: END IF;
1786:
1787: EXCEPTION
1788: WHEN OTHERS THEN
1789: PO_MESSAGE_S.add_exc_msg
1790: (
1791: p_pkg_name => d_pkg_name,
1792: p_procedure_name => d_api_name || '.' || d_position
1793: );
1871: END IF;
1872:
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: PO_MESSAGE_S.add_exc_msg
1876: (
1877: p_pkg_name => d_pkg_name,
1878: p_procedure_name => d_api_name || '.' || d_position
1879: );
1988: EXCEPTION
1989: WHEN NO_DATA_FOUND THEN
1990: return 0;
1991: WHEN OTHERS THEN
1992: PO_MESSAGE_S.add_exc_msg
1993: (
1994: p_pkg_name => d_pkg_name,
1995: p_procedure_name => d_api_name || '.' || d_position
1996: );