32: return (x_line_num);
33:
34: EXCEPTION
35: WHEN OTHERS THEN
36: po_message_s.sql_error('get_line_num', '000', sqlcode);
37: raise;
38:
39: END get_line_num;
40:
68: END IF;
69:
70: EXCEPTION
71: WHEN OTHERS THEN
72: po_message_s.sql_error('is_cumulative_pricing', '000', sqlcode);
73: raise;
74:
75: END is_cumulative_pricing;
76:
210: X_num_of_ship := 0 ; /* Set the value to 0 */
211: when too_many_rows then
212: X_num_of_ship := 2; /* Set it to a value > 1 */
213: when others then
214: po_message_s.sql_error('get_ship_dist_num', x_progress, sqlcode);
215: raise;
216: end;
217:
218: /* If the control ever went into the above anonymous block's exception,
262: X_num_of_dist := 0;
263: when too_many_rows then
264: X_num_of_dist := 2;
265: when others then
266: po_message_s.sql_error('get_ship_dist_num', x_progress, sqlcode);
267: raise;
268: end get_ship_dist_num;
269:
270:
300: WHEN NO_DATA_FOUND THEN
301: RETURN (0);
302: WHEN OTHERS THEN
303: -- dbms_output.put_line('In exception');
304: po_message_s.sql_error('get_encumbered_quantity', X_progress, sqlcode);
305: RAISE;
306:
307: END get_encumbered_quantity;
308:
347: WHEN NO_DATA_FOUND THEN
348: RETURN (NULL);
349: WHEN OTHERS THEN
350: -- dbms_output.put_line('In exception');
351: po_message_s.sql_error('get_receipt_required_flag', X_progress, sqlcode);
352: RAISE;
353:
354: END get_receipt_required_flag;
355:
611: EXCEPTION
612:
613: WHEN OTHERS THEN
614: -- dbms_output.put_line('In exception');
615: po_message_s.sql_error('PO_LINES_SV4','get_ship_quantity_info',
616: x_progress, sqlcode, sqlerrm);
617: RAISE;
618:
619:
716: EXCEPTION
717:
718: WHEN OTHERS THEN
719: -- dbms_output.put_line('In exception');
720: po_message_s.sql_error('get_quotation_info', X_progress, sqlcode);
721: RAISE;
722:
723:
724: END get_quotation_info;
746: and polc.lookup_code = X_lookup_code ;
747:
748: exception
749: when others then
750: po_message_s.sql_error('get_lookup_code_dsp', X_progress, sqlcode);
751: raise;
752:
753: end get_lookup_code_dsp;
754:
920: exception
921: when no_data_found then
922: X_oke_contract_num := to_char(null) ; /* Set the value to null */
923: when others then
924: po_message_s.sql_error('get_oke_contract_header_info', x_progress, sqlcode);
925: raise;
926: end;
927:
928: exception
926: end;
927:
928: exception
929: when others then
930: po_message_s.sql_error('get_oke_contract_header_info', x_progress, sqlcode);
931: raise;
932: end get_oke_contract_header_info;
933:
934: --Bug# 1625462
953: ** Bug 1689746
954: ** In the Receiving transactions form you can't query up
955: ** RMA receipts. Commenting out the error and raise so that
956: ** transaction may proceed.
957: po_message_s.sql_error('get_unit_meas_lookup_code_tl', x_progress, sqlcode);
958: raise;
959: */
960: null;
961: