249: RAISE;
250:
251: WHEN OTHERS THEN
252:
253: po_message_s.sql_error('get_available_quantity', x_progress, sqlcode);
254:
255: RAISE;
256:
257: END get_available_quantity;
338: RAISE;
339:
340: WHEN OTHERS THEN
341:
342: po_message_s.sql_error('get_available_quantity', x_progress, sqlcode);
343:
344: RAISE;
345:
346: END get_available_quantity;
428:
429: IF (g_asn_debug = 'Y') THEN
430: asn_debug.put_line('When others exception in get_available_amt' );
431: end if;
432: po_message_s.sql_error('get_available_amount', x_progress, sqlcode);
433:
434: RAISE;
435:
436: END get_available_amount;
496: RAISE;
497:
498: WHEN OTHERS THEN
499:
500: po_message_s.sql_error('get_receive_quantity', x_progress, sqlcode);
501:
502: RAISE;
503:
504: END get_receive_quantity;
568:
569: IF (g_asn_debug = 'Y') THEN
570: asn_debug.put_line('Exception get_receive_amount ' );
571: end if;
572: po_message_s.sql_error('get_receive_amount', x_progress, sqlcode);
573:
574: RAISE;
575:
576: END get_receive_amount;
652: EXCEPTION
653:
654: WHEN OTHERS THEN
655:
656: po_message_s.sql_error('get_rma_quantity', x_progress, sqlcode);
657:
658: RAISE;
659:
660:
875: EXCEPTION
876:
877: WHEN OTHERS THEN
878:
879: po_message_s.sql_error('get_po_quantity', x_progress, sqlcode);
880:
881: RAISE;
882:
883: END get_po_quantity;
973: EXCEPTION
974:
975: WHEN OTHERS THEN
976:
977: po_message_s.sql_error('get_po_amount', x_progress, sqlcode);
978:
979: RAISE;
980:
981: END get_po_amount;
1109: asn_debug.put_line('p_secondary_available_qty = ' || p_secondary_available_qty);
1110: asn_debug.put_line('***END*** get_po_quantity');
1111: EXCEPTION
1112: WHEN OTHERS THEN
1113: po_message_s.sql_error('get_rma_quantity',
1114: x_progress,
1115: SQLCODE
1116: );
1117: RAISE;
1277: EXCEPTION
1278:
1279: WHEN OTHERS THEN
1280:
1281: po_message_s.sql_error('get_shipment_quantity', x_progress, sqlcode);
1282:
1283: RAISE;
1284:
1285: END get_shipment_quantity;
1497: EXCEPTION
1498:
1499: WHEN OTHERS THEN
1500:
1501: po_message_s.sql_error('get_transaction_quantity', x_progress, sqlcode);
1502:
1503: RAISE;
1504:
1505: END get_transaction_quantity;
1632:
1633: IF (g_asn_debug = 'Y') THEN
1634: asn_debug.put_line('Exception in get_transaction_amount');
1635: end if;
1636: po_message_s.sql_error('get_transaction_amount', x_progress, sqlcode);
1637:
1638: RAISE;
1639:
1640: END get_transaction_amount;
1882:
1883:
1884: WHEN OTHERS THEN
1885:
1886: po_message_s.sql_error('get_correction_quantity', x_progress, sqlcode);
1887:
1888: RAISE;
1889:
1890: END get_correction_quantity;
2040:
2041:
2042: WHEN OTHERS THEN
2043:
2044: po_message_s.sql_error('get_correction_amount', x_progress, sqlcode);
2045:
2046: RAISE;
2047:
2048: END get_correction_amount;
2411: EXCEPTION
2412:
2413: WHEN OTHERS THEN
2414:
2415: po_message_s.sql_error('get_deliver_quantity', x_progress, sqlcode);
2416:
2417: RAISE;
2418:
2419: END get_deliver_quantity;
2516: EXCEPTION
2517:
2518: WHEN OTHERS THEN
2519:
2520: po_message_s.sql_error('get_deliver_amount', x_progress, sqlcode);
2521:
2522: RAISE;
2523:
2524: END get_deliver_amount;
2696: EXCEPTION
2697:
2698: WHEN OTHERS THEN
2699:
2700: po_message_s.sql_error('get_po_dist_quantity',
2701: x_progress, sqlcode);
2702:
2703: RAISE;
2704:
2810: EXCEPTION
2811:
2812: WHEN OTHERS THEN
2813:
2814: po_message_s.sql_error('get_po_dist_amount',
2815: x_progress, sqlcode);
2816:
2817: RAISE;
2818:
2922: EXCEPTION
2923:
2924: WHEN OTHERS THEN
2925:
2926: po_message_s.sql_error('get_rcv_dist_quantity',
2927: x_progress, sqlcode);
2928:
2929: RAISE;
2930:
2947: EXCEPTION
2948:
2949: WHEN OTHERS THEN
2950:
2951: po_message_s.sql_error('val_quantity', x_progress, sqlcode);
2952:
2953: RAISE;
2954:
2955: END val_quantity;
3033: RETURN;
3034:
3035: EXCEPTION
3036: WHEN OTHERS THEN
3037: po_message_s.sql_error('get_primary_qty_uom', X_progress, sqlcode);
3038: RAISE;
3039:
3040: END get_primary_qty_uom;
3041:
3101: /* Had to remove the exception handling section because it violates WNDS pragma */
3102: /*
3103: EXCEPTION
3104: WHEN OTHERS THEN
3105: po_message_s.sql_error('get_pending_qty',x_progress,SQLCODE);
3106: RAISE;
3107: */
3108:
3109: END get_pending_qty;
3181: p_ship_qty_in_int := x_interface_qty_in_ship_uom;
3182:
3183: EXCEPTION
3184: WHEN OTHERS THEN
3185: po_message_s.sql_error('get_ship_qty_in_int', X_progress, sqlcode);
3186: RAISE;
3187:
3188: END get_ship_qty_in_int;
3189:
3488: END IF;
3489:
3490: EXCEPTION
3491: WHEN OTHERS THEN
3492: po_message_s.sql_error('get_available_asn_quantity', l_progress, sqlcode);
3493: RAISE;
3494:
3495: END get_available_asn_quantity;
3496: