How to do pick release using API [message #337457] |
Thu, 31 July 2008 00:01 |
ramisetti1
Messages: 30 Registered: January 2007
|
Member |
|
|
Hi friends,
Requirement : when user raise the PO ,it has to create the Sales order-->Pick release-->ship confirm-->Reciept.
Initial Validations: I need for sale order: all the periods should open and items should available for shiping
I tried some pseudo coding for sales order creation and ship confirm.but I need coding (API) for Pick Release which involve s the Move order.
I f u have coding for Sales order-->Pick release-->ship confirm-->Reciept please send it.
I need to do automation procees. Once we run the request, all these process has to be done.
Thanks
suresh
|
|
|
|
Re: How to do pick release using API [message #340064 is a reply to message #337457] |
Mon, 11 August 2008 05:42 |
jaganerp@gmail.com
Messages: 63 Registered: April 2008
|
Member |
|
|
Hai,actuval waht you want, i have that code on annomus block with out validation,
**************************
declare
p_api_version_number NUMBER :=1.0;
init_msg_list VARCHAR2(200);
x_msg_details VARCHAR2(3000);
x_msg_summary VARCHAR2(3000);
p_line_rows WSH_UTIL_CORE.ID_TAB_TYPE;
x_del_rows WSH_UTIL_CORE.ID_TAB_TYPE;
l_ship_method_code VARCHAR2(100);
l_commit VARCHAR2(30);
p_delivery_id NUMBER;
p_delivery_name VARCHAR2(30);
x_trip_id VARCHAR2(30);
x_trip_name VARCHAR2(30);
l_picked_flag VARCHAR2(10);
l_return_status VARCHAR2(1000);
l_msg_count NUMBER;
l_msg_data VARCHAR2(1000);
l_detail number;
x_return_status varchar2(100);
x_msg_count varchar2(100);
x_msg_data varchar2(100);
BEGIN
SELECT DELIVERY_DETAIL_ID INTO l_detail FROM WSH_DELIVERY_DETAILS WHERE SOURCE_HEADER_ID=(
SELECT HEADER_ID FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER=58297 AND ORDER_SOURCE_ID=
(SELECT ORDER_SOURCE_ID FROM OE_ORDER_SOURCES WHERE NAME='Online') AND ORDER_TYPE_ID=
(SELECT TRANSACTION_TYPE_ID FROM OE_TRANSACTION_TYPES_TL WHERE NAME ='Mixed'));
fnd_global.apps_initialize( 1318, 21623, 660 );
x_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
p_line_rows(1):= l_detail;
WSH_DELIVERY_DETAILS_PUB.AUTOCREATE_DELIVERIES(
p_api_version_number => 1.0,
p_init_msg_list => APPS.FND_API.G_TRUE,
p_commit => l_commit,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_line_rows => p_line_rows,
x_del_rows => x_del_rows );
p_delivery_id := x_del_rows(1);
p_delivery_name := TO_CHAR( x_del_rows(1) );
l_detail := p_delivery_id;
wsh_deliveries_pub.delivery_action(
p_api_version_number => 1.0 ,
p_init_msg_list => null,
x_return_status => x_return_status,
x_msg_count => x_msg_count,
x_msg_data => x_msg_data,
p_action_code => 'PICK-RELEASE',
p_delivery_id => p_delivery_id,
p_delivery_name => p_delivery_name,
x_trip_id => x_trip_id,
x_trip_name => x_trip_name
);
IF X_RETURN_STATUS=FND_API.G_RET_STS_SUCCESS THEN
DBMS_OUTPUT.PUT_LINE('SUCESS');
COMMIT;
ELSE
DBMS_OUTPUT.PUT_LINE('FAILURE');
ROLLBACK;
END IF;
DBMS_OUTPUT.PUT_LINE('return staus is:'||X_RETURN_STATUS);
DBMS_OUTPUT.PUT_LINE('message count is :'||X_MSG_COUNT);
DBMS_OUTPUT.PUT_LINE('message data is :'|| X_MSG_DATA);
DBMS_OUTPUT.PUT_LINE('TRIP_ID IS '||x_trip_id );
DBMS_OUTPUT.PUT_LINE('TRIP_NAME IS :'|| x_trip_name);
END;
******************
please see the attachment
if u want complete cyle api tell me
|
|
|