Home » Applications » Oracle Fusion Apps & E-Business Suite » How to do pick release using API
How to do pick release using API [message #337457] Thu, 31 July 2008 00:01 Go to next message
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 #339572 is a reply to message #337457] Thu, 07 August 2008 19:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I will move thread this to the right forum.

David
Re: How to do pick release using API [message #340064 is a reply to message #337457] Mon, 11 August 2008 05:42 Go to previous message
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
Previous Topic: Query Description Table Fields
Next Topic: combining two bank statements in one to reconcile
Goto Forum:
  


Current Time: Tue Dec 06 12:30:58 CST 2016

Total time taken to generate the page: 0.06834 seconds