DBA Data[Home] [Help]

APPS.CSD_PROCESS_PVT dependencies on WSH_DELIVERY_DETAILS_PUB

Line 852: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

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 */

Line 854: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;

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

Line 983: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

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,

Line 984: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,

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,

Line 1291: --Parameters for WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

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*/

Line 1293: changed_attributes Wsh_Delivery_Details_Pub.ChangedAttributeTabType;

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:

Line 1823: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

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,

Line 1824: Wsh_Delivery_Details_Pub.Update_Shipping_Attributes(p_api_version_number => 1.0,

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,

Line 1853: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes

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

Line 1861: Call API WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes and

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

Line 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 ;

Line 1895: --Call to WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes.

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,

Line 1896: WSH_DELIVERY_DETAILS_PUB.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,
1900: x_return_status => x_return_status,

Line 2043: WSH_DELIVERY_DETAILS_PUB.Update_Shipping_Attributes(

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,