This discussion is archived
2 Replies Latest reply: Jul 8, 2013 7:04 PM by 961813 RSS

aso_quote_pub.update_quote doesn't update shipment level

961813 Newbie
Currently Being Moderated

Dear experts,

 

     I want to make use of aso_quote_pub.update_quote API to update shipment data but fail. It reports "An unexpected error has occured during processing of the ASO_QUOTE_HEADER AFTER UPDATE  information." If I remove the shipment update, it works fine.

Can anyone help on that?

 

Here is the code.

 

      l_qte_header_rec.quote_header_id  := p_quote_header_id;

      l_qte_header_rec.last_update_date := ld_last_update_date;

 

      l_qte_line_tbl(1).operation_code := 'UPDATE';

      l_qte_line_tbl(1).quote_line_id := p_quote_line_id;

      l_qte_line_tbl(1).inventory_item_id := p_inventory_item_id;

 

 

 

      l_ln_shipment_tbl(1).operation_code := 'UPDATE';

      l_ln_shipment_tbl(1).quote_line_id := p_quote_line_id;

      l_ln_shipment_tbl(1).request_date   := p_req_date;

 

aso_quote_pub.update_quote(p_api_version_number      => 2.0,

                               p_init_msg_list           => fnd_api.g_false,

                               p_commit                  => fnd_api.g_false,

                               p_control_rec             => l_control_rec,

                               p_qte_header_rec          => l_qte_header_rec,

                               p_hd_price_attributes_tbl => lr_hd_price_attributes_tbl,

                               p_hd_payment_tbl          => l_hd_payment_tbl,

                               p_hd_shipment_tbl         => l_hd_shipment_tbl,

                               p_hd_freight_charge_tbl   => lr_hd_freight_charge_tbl,

                               p_hd_tax_detail_tbl       => l_hd_tax_detail_tbl,

                               p_qte_line_tbl            => l_qte_line_tbl,

                               p_qte_line_dtl_tbl        => lr_qte_line_dtl_tbl,

                               p_line_attr_ext_tbl       => lr_line_attr_ext_tbl,

                               p_line_rltship_tbl        => lr_line_rltship_tbl,

                               p_price_adjustment_tbl    => lr_price_adjustment_tbl,

                               p_price_adj_attr_tbl      => lr_price_adj_attr_tbl,

                               p_price_adj_rltship_tbl   => lr_price_adj_rltship_tbl,

                               p_ln_price_attributes_tbl => lr_ln_price_attributes_tbl,

                               p_ln_payment_tbl          => lr_ln_payment_tbl,

                               p_ln_shipment_tbl         => l_ln_shipment_tbl,

                               p_ln_freight_charge_tbl   => lr_ln_freight_charge_tbl,

                               p_ln_tax_detail_tbl       => lr_ln_tax_detail_tbl,

                               x_qte_header_rec          => lx_qte_header_rec,

                               x_qte_line_tbl            => lx_qte_line_tbl,

                               x_qte_line_dtl_tbl        => lx_qte_line_dtl_tbl,

                               x_hd_price_attributes_tbl => lx_hd_price_attr_tbl,

                               x_hd_payment_tbl          => lx_hd_payment_tbl,

                               x_hd_shipment_tbl         => lx_hd_shipment_rec,

                               x_hd_freight_charge_tbl   => lx_hd_freight_charge_tbl,

                               x_hd_tax_detail_tbl       => lx_hd_tax_detail_tbl,

                               x_line_attr_ext_tbl       => lx_line_attr_ext_tbl,

                               x_line_rltship_tbl        => lx_line_rltship_tbl,

                               x_price_adjustment_tbl    => lx_price_adjustment_tbl,

                               x_price_adj_attr_tbl      => lx_price_adj_attr_tbl,

                               x_price_adj_rltship_tbl   => lx_price_adj_rltship_tbl,

                               x_ln_price_attributes_tbl => lx_ln_price_attr_tbl,

                               x_ln_payment_tbl          => lx_ln_payment_tbl,

                               x_ln_shipment_tbl         => lx_ln_shipment_tbl,

                               x_ln_freight_charge_tbl   => lx_ln_freight_charge_tbl,

                               x_ln_tax_detail_tbl       => lx_ln_tax_detail_tbl,

                               x_return_status           => lx_return_status,

                               x_msg_count               => lx_msg_count,

                               x_msg_data                => lx_msg_data);

 

Thanks

  • 1. Re: aso_quote_pub.update_quote doesn't update shipment level
    shreevat Pro
    Currently Being Moderated

    Try printing the actual error message to debug further (see below code as a sample)

     

     

    Declare variable ln_msg_index_out NUMBER;

     

     

    IF (fnd_msg_pub.count_msg > 0)

    THEN

       FOR i IN 1 .. fnd_msg_pub.count_msg

       LOOP

          fnd_msg_pub.get (p_msg_index  => i,

               p_encoded            => 'F',

               p_data               => lx_msg_data,

               p_msg_index_out      => ln_msg_index_out

              );

          DBMS_OUTPUT.PUT_LINE('Error : '||lx_msg_data);     

      END LOOP;

    FND_MSG_PUB.delete_msg (NULL);         

     

    Thanks

    Shree

  • 2. Re: aso_quote_pub.update_quote doesn't update shipment level
    961813 Newbie
    Currently Being Moderated

    Thanks Shree,

    I have identified the cause. In order to update shipment, I have to assign value for l_ln_shipment_tbl(1).shipment_id.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points