Wednesday, March 26, 2014

Script to Update Shipping Attributes in wsh_delivery_details

   CURSOR dev_header_cur
      SELECT *
        FROM apps.wsh_delivery_details
       WHERE delivery_detail_id IN
                (970938993, 970938998, 970938997); -- Provide delivery_detail_id

   l_index                     NUMBER;
   l_msg_return                NUMBER;
   x_return_status             VARCHAR2 (1);
   x_msg_count                 NUMBER;
   x_msg_data                  VARCHAR2 (2000);
   l_changedattributetabtype   wsh_delivery_details_pub.changedattributetabtype;
   l_file_name                 VARCHAR2 (32767);
   l_return_status             VARCHAR2 (32767);
   l_msg_data                  VARCHAR2 (32767);
   l_msg_count                 NUMBER;
   fnd_global.APPS_INITIALIZE (2861, 67384, 660); -- Provide user_id, resp_id and appl_id to initialize

   fnd_profile.put ('WSH_DEBUG_MODULE', '%');
   fnd_profile.put ('WSH_DEBUG_LEVEL', WSH_DEBUG_SV.C_STMT_LEVEL);
   wsh_debug_sv.start_debugger (l_file_name,
   l_index := 0;

   FOR dev_header_rec IN dev_header_cur
      l_index := L_index + 1;

      l_changedattributetabtype (l_index).delivery_detail_id :=
      l_changedattributetabtype (l_index).subinventory := 'ICENI'; -- Provide subinventory to update

   wsh_delivery_details_pub.Update_Shipping_Attributes (
      p_api_version_number   => 1.0,
      p_init_msg_list        => FND_API.G_FALSE,
      p_commit               => FND_API.G_FALSE,
      x_return_status        => X_return_status,
      x_msg_count            => X_msg_count,
      x_msg_data             => X_msg_data,
      p_changed_attributes   => l_changedattributetabtype,
      p_source_code          => 'OE');


   IF x_return_status <> fnd_api.G_RET_STS_SUCCESS
      FOR i IN 1 .. x_msg_count
         fnd_msg_pub.get (p_msg_index       => I,
                          P_encoded         => 'F',
                          P_data            => X_msg_data,
                          P_msg_index_out   => l_msg_return);
         DBMS_OUTPUT.PUT_LINE (x_msg_data);
      END LOOP;
   END IF;


  1. Thanks for your informative post. Placement training is excellent option for students willing to enter software development industry with lucrative salary package.

  2. The best thing is that your blog really informative thanks for your great information!
    erp software in chennai

  3. This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information, this is useful to me…
    No.1 IOS Training Institute in Chennai | Best Android Training Institute in Chennai | Java Training Institute in Chennai

  4. Very interesting blog which helps me to get the in depth knowledge about the technology, Thanks for sharing such a nice blog.MatLab Training Institute in Chennai | Mat Lab Project Center in Chennai | Online Training in Chennai

  5. Nice and good article.. it is very useful for me to learn and understand easily.. thanks for sharing your valuable information and time.. please keep updating.
    Java Training Institute in Chennai | DotNet Training Institute in Chennai | Web Designing Training Institute in Chennai

  6. Nice post... The strategy you have posted on this technology helped me to get into the next level and had lot of information in it. Thank you for sharing such a great blog.. Software Testing Training Institute in Chennai | Selenium Training Institute in Chennai | ISTQB Training Institute in Chennai


  7. Interesting post! This is really helpful for me. I like it! Thanks for sharing!
    PHP developers Chennai | PHP developers in Chennai

  8. Those guidelines additionally worked to become a good way to recognize that other people online have the identical fervor like mine to grasp great deal more around this condition.
    dotnet training in bangalore

  9. Your new valuable key points imply much a person like me and extremely more to my office workers. With thanks; from every one of us.

    white label website builder

    mobile website builder

  10. I really enjoyed while reading your article, the information you have delivered in this post was damn good. Keep sharing your post with efficient news. RPA Training Institute in Chennai | UI Path Training Institute in Chennai | Blue Prism Training Institute in Chennai

  11. The strategy you have posted on the oracle hepled me to get into the next level of this technology and had lot of informations in it.
    Best VMware Training Institute in Chennai | Best VMware Training Institute in Velachery

  12. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas. Automation Anywhere Training in Chennai | RPA Training Institute in Chennai | UI Path Training Institute in Chennai | Blue Prism Training Institute in Chennai


  13. Thanks for sharing this niche useful informative post to our knowledge.
    brochure designers in chennai | brochure design company in chennai

  14. I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.
    aws training in Chennai

  15. Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.

    blue prism training in chennai

  16. Bottles Filled with Liquids. Perhaps understandably, it is not advisable to ship open bottles filled with liquids or other contents in cargo containers for international shipment. atlantic way russia

  17. Excellent information with unique content and it is very useful to know about the information based on blogs... Digital Marketing Summer Camp in Velachery | Digital Marketing Summer Classes in Chennai | Digital Marketing Summer courses in Taramani

  18. Love how wonderfully every word is written with proper balance.
    importados da china


Note: Only a member of this blog may post a comment.