257:
258:
259: EXCEPTION
260: WHEN OTHERS THEN
261: po_message_s.sql_error('val_receiving_controls', x_progress, sqlcode);
262: RAISE;
263:
264: END val_receiving_controls;
265:
415: RETURN 0;
416:
417: EXCEPTION
418: WHEN OTHERS THEN
419: po_message_s.sql_error('val_wip_info', X_progress, sqlcode);
420: RAISE;
421:
422: END val_wip_info;
423:
472: END IF;
473:
474: EXCEPTION
475: WHEN OTHERS THEN
476: po_message_s.sql_error('val_if_inventory_destination', x_progress, sqlcode);
477: RAISE;
478:
479: END val_if_inventory_destination;
480:
601:
602: EXCEPTION
603: WHEN OTHERS THEN
604: -- dbms_output.put_line('Progess is :' || X_Progress);
605: po_message_s.sql_error('val_deliver_destination', X_progress, sqlcode);
606: RAISE;
607:
608: END val_deliver_destination;
609:
748: RETURN;
749:
750: EXCEPTION
751: WHEN OTHERS THEN
752: po_message_s.sql_error('val_destination_info', x_progress, sqlcode);
753: RAISE;
754:
755: END val_destination_info;
756:
825: */
826: WHEN NO_DATA_FOUND THEN
827: RETURN TRUE;
828: WHEN OTHERS THEN
829: po_message_s.sql_error('val_pending_receipt_trx', x_progress, sqlcode);
830: RAISE;
831:
832: END val_pending_receipt_trx;
833:
988: END IF;
989:
990: EXCEPTION
991: WHEN OTHERS THEN
992: po_message_s.sql_error('get_wip_info', x_progress, sqlcode);
993: RAISE;
994:
995: END get_wip_info;
996:
1087: END IF;
1088:
1089: EXCEPTION
1090: WHEN OTHERS THEN
1091: po_message_s.sql_error('get_rma_dest_info', x_progress, sqlcode);
1092: RAISE;
1093:
1094: END get_rma_dest_info;
1095: