0 Replies Latest reply on Oct 18, 2014 12:11 PM by 943327

    Using po_asl_ths.insert_row to create Approved Supplier List (ASL)

    943327

      Hi All,

       

      We are using Oracle Applications : 11.5.10.2.

       

      Our requirement is to create the Item's Approved Supplier List and for the same I am using the API po_asl_ths.insert_row.

      The code for the same is as follows -

       

       

      DECLARE
      l_row_id VARCHAR2(
      20);

      l_asl_id NUMBER;
      begin
      po_asl_ths.insert_row
      (x_row_id => l_row_id,
      x_asl_id => l_asl_id,
      x_item_id =>
      109275,
      x_vendor_id =>
      9528,
      x_vendor_site_id =>
      16557,
      x_vendor_business_type =>
      'DIRECT',
      x_asl_status_id =>
      2,
      x_created_by =>
      5500,
      x_creation_date => SYSDATE,
      x_last_updated_by =>
      5500,
      x_last_update_login => NULL,
      x_last_update_date => SYSDATE,
      x_using_organization_id => -
      1,
      x_owning_organization_id =>
      2191,
      x_manufacturer_id => NULL,
      x_category_id => NULL,
      x_primary_vendor_item =>
      'D0GA105JA023',
      x_manufacturer_asl_id => NULL,
      x_comments => NULL,
      x_review_by_date => NULL,
      x_attribute_category => NULL,
      x_attribute1 => NULL,
      x_attribute2 => NULL,
      x_attribute3 => NULL,
      x_attribute4 => NULL,
      x_attribute5 => NULL,
      x_attribute6 => NULL,
      x_attribute7 => NULL,
      x_attribute8 => NULL,
      x_attribute9 => NULL,
      x_attribute10 => NULL,
      x_attribute11 => NULL,
      x_attribute12 => NULL,
      x_attribute13 => NULL,
      x_attribute14 => NULL,
      x_attribute15 => NULL,
      x_disable_flag => NULL);

      commit;
      EXCEPTION
      WHEN OTHERS then
      dbms_output.put_line(
      'SQLERRM' || SQLERRM);

      END;

      But the ASL is not getting created for the same.

      Please advise if I am doing something wrong or if there is any other API which should be called to create the Item's Approved Supplier List


      Regards,

      SS