848: l_order_type_id NUMBER := NULL;
849: l_document_set_id NUMBER := NULL;
850: l_sub_inventory VARCHAR2(30) := '';
851:
852: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
853: source_code VARCHAR2(15);
854: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
855:
856: /* Handle exceptions */
850: l_sub_inventory VARCHAR2(30) := '';
851:
852: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
853: source_code VARCHAR2(15);
854: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
855:
856: /* Handle exceptions */
857: fail_api EXCEPTION;
858: -- Added Mtl_Sytem_items_B to get serial_number_control_Code for the item that is being
979: changed_attributes(1)
980: .shipped_quantity);
981: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
982: END IF;
983: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
984: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
985: p_init_msg_list => p_init_msg_list,
986: p_commit => p_commit,
987: x_return_status => x_return_status,
980: .shipped_quantity);
981: Csd_Gen_Utility_Pvt.ADD('Calling Update_Shipping_Attributes');
982: END IF;
983: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
984: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
985: p_init_msg_list => p_init_msg_list,
986: p_commit => p_commit,
987: x_return_status => x_return_status,
988: x_msg_count => x_msg_count,
1287: l_shipped_serial_number VARCHAR2(30);
1288: l_lot_number VARCHAR2(80); -- fix for bug#4625226
1289: l_SN_at_SO_new_SN_number BOOLEAN; /*This flag is true when user provide new SN for serialized item at SO */
1290:
1291: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1292: source_code VARCHAR2(15);
1293: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
1294:
1295: /*Handle exceptions*/
1289: l_SN_at_SO_new_SN_number BOOLEAN; /*This flag is true when user provide new SN for serialized item at SO */
1290:
1291: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1292: source_code VARCHAR2(15);
1293: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;
1294:
1295: /*Handle exceptions*/
1296: fail_api EXCEPTION;
1297:
1819: Debug('Calling Update_Shipping_Attributes',
1820: l_mod_name,
1821: 1);
1822:
1823: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1824: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
1825: p_init_msg_list => p_init_msg_list,
1826: p_commit => p_commit,
1827: x_return_status => x_return_status,
1820: l_mod_name,
1821: 1);
1822:
1823: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1824: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,
1825: p_init_msg_list => p_init_msg_list,
1826: p_commit => p_commit,
1827: x_return_status => x_return_status,
1828: x_msg_count => x_msg_count,
1849: If Item is Reservable then
1850: Check if item is Serial Controlled @ SO Issue
1851: ( This is existing solution and it will continue to stay
1852: If item is serial controlled at Sales Order issue then
1853: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
1854: and update with serial_number and quantity.
1855: End If;
1856: Else If Item is Non-Reservable
1857: If Item is serial Controlled then
1857: If Item is serial Controlled then
1858: Get Lot_Number, Revision, Sub Inventory Information from
1859: Mtl_Serial_numbers for a given serial_number, item_id,organization_id
1860:
1861: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and
1862: Update Serial_Number, Quantity ( will be 1 for serial controlled
1863: items), lot_number, Revision and subinventory
1864: Else if item is non serial controlled then
1865: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
1861: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and
1862: Update Serial_Number, Quantity ( will be 1 for serial controlled
1863: items), lot_number, Revision and subinventory
1864: Else if item is non serial controlled then
1865: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes
1866: Values for Quantity, Lot_Number, Revision and Sub Inventory
1867: should be pulled from UI.
1868: Update Quantity, Lot_Number, Revision and Sub-Inventory
1869: End If ;
1891: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
1892: END IF;
1893:
1894:
1895: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1896: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
1897: p_api_version_number => 1.0,
1898: p_init_msg_list => p_init_msg_list,
1899: p_commit => p_commit,
1892: END IF;
1893:
1894:
1895: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.
1896: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
1897: p_api_version_number => 1.0,
1898: p_init_msg_list => p_init_msg_list,
1899: p_commit => p_commit,
1900: x_return_status => x_return_status,
2039: csd_gen_utility_pvt.ADD('shipped_quantity ='||changed_attributes(1).shipped_quantity );
2040: csd_gen_utility_pvt.ADD('Calling Update_Shipping_Attributes');
2041: END IF;
2042:
2043: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(
2044: p_api_version_number => 1.0,
2045: p_init_msg_list => p_init_msg_list,
2046: p_commit => p_commit,
2047: x_return_status => x_return_status,