[Home] [Help]
34:
35: when no_data_found then
36: return (FALSE);
37: when others then
38: po_message_s.sql_error('val_vendor',X_progress,sqlcode);
39: raise;
40:
41: END val_vendor;
42:
107: end if;
108:
109: exception
110: when others then
111: po_message_s.sql_error('get_vendor_info',X_progress,sqlcode);
112: -- app_exception.raise_exception;
113: end get_vendor_info;
114:
115: /*===========================================================================
369:
370:
371: exception
372: when others then
373: po_message_s.sql_error('get_vendor_defaults',X_progress,sqlcode);
374: raise;
375: end get_vendor_defaults;
376:
377:
407: X_res_fob := '';
408: when too_many_rows then
409: X_res_fob := '';
410: when others then
411: po_message_s.sql_error('val_fob',X_progress,sqlcode);
412: raise;
413: end val_fob;
414:
415: /*===========================================================================
444: X_res_freight_terms := '';
445: when too_many_rows then
446: X_res_freight_terms := '';
447: when others then
448: po_message_s.sql_error('val_freght_terms',X_progress,sqlcode);
449: raise;
450: end val_freight_terms;
451:
452: /*===========================================================================
479: X_res_ship_via := '';
480: when too_many_rows then
481: X_res_ship_via := '';
482: when others then
483: po_message_s.sql_error('val_freight_carrier',X_progress,sqlcode);
484: raise;
485:
486: end val_freight_carrier;
487:
526: x_res_shipping_control := '';
527: WHEN TOO_MANY_ROWS THEN
528: x_res_shipping_control := '';
529: WHEN OTHERS THEN
530: PO_MESSAGE_S.sql_error('val_shipping_control', x_progress, sqlcode);
531: RAISE;
532:
533: END val_shipping_control;
534:
572: WHERE po_header_id = p_po_header_id;
573:
574: EXCEPTION
575: WHEN OTHERS THEN
576: PO_MESSAGE_S.sql_error('get_terms_conditions','000',sqlcode);
577: raise;
578:
579: END get_terms_conditions;
580:
630: X_fob_dsp := '';
631: when too_many_rows then
632: X_fob_dsp := '';
633: when others then
634: po_message_s.sql_error('get_displayed_values',X_progress,sqlcode);
635: raise;
636: end; */
637:
638: /* Get the displayed value for a given Lookup_Type = 'FREIGHT TERMS'*/
660: X_freight_terms_dsp := '';
661: when too_many_rows then
662: X_freight_terms_dsp := '';
663: when others then
664: po_message_s.sql_error('get_displayed_values',X_progress,sqlcode);
665: raise;
666: end; */
667:
668: /* There is no po_core rooutine to return this */
685: X_ship_via_dsp := '';
686: when too_many_rows then
687: X_ship_via_dsp := '';
688: when others then
689: po_message_s.sql_error('get_displayed_values',X_progress,sqlcode);
690: raise;
691: end;
692:
693: /* No equivalent routine in PO CORE for this one too */
708: X_terms_dsp := '';
709: when too_many_rows then
710: X_terms_dsp := '';
711: when others then
712: po_message_s.sql_error('get_displayed_values',X_progress,sqlcode);
713: raise;
714: end;
715:
716: end get_displayed_values;
823: X_ship_to_loc_dsp := '';
824: when too_many_rows then
825: X_ship_to_loc_dsp := '';
826: when others then
827: po_message_s.sql_error('get_ship_to_loc_attributes',X_progress,sqlcode);
828: raise;
829:
830:
831: end get_ship_to_loc_attributes;
863: X_bill_to_loc_dsp := '';
864: when too_many_rows then
865: X_bill_to_loc_dsp := '';
866: when others then
867: po_message_s.sql_error('get_bill_to_loc_attributes',X_progress,sqlcode);
868: raise;
869:
870: end get_bill_to_loc_attributes;
871:
910: EXCEPTION
911:
912: when others then
913: -- dbms_output.put_line('In exception');
914: po_message_s.sql_error('get_vendor_name', X_progress, sqlcode);
915: raise;
916: END get_vendor_name;
917:
918:
961: RETURN X_vendor_name;
962:
963: EXCEPTION
964: WHEN OTHERS THEN
965: -- po_message_s.sql_error('get_vendor_name',X_progress,sqlcode);
966: raise;
967:
968: END get_vendor_name_func;
969:
1003: x_vendor_phone);
1004:
1005: EXCEPTION
1006: WHEN OTHERS THEN
1007: po_message_s.sql_error('get_vendor_details',x_progress,sqlcode);
1008: raise;
1009:
1010: END get_vendor_details;
1011: