API – Ship Confirm of the Deliveries
p_api_version_number NUMBER;
p_init_msg_list VARCHAR2(2000);
V_return_status VARCHAR2(2000);
V_msg_data VARCHAR2(2000);
p_action_code VARCHAR2(2000);
p_delivery_id NUMBER ;
V_trip_id VARCHAR2(30);
V_trip_name VARCHAR2(30);
V_msg_details VARCHAR2(3000);
V_msg_summary VARCHAR2(3000);
V_msg_count NUMBER;
V_init_msg_list VARCHAR(2000);
begin
p_delivery_id := 7102; — dELIVERY ID FROM SALES TRANSACTION SCREEN
p_action_code :=’CONFIRM’;
WSH_DELIVERIES_PUB.Delivery_Action(
p_api_version_number => 1.0,
p_init_msg_list => V_init_msg_list,
x_return_status => V_return_status,
x_msg_count => V_msg_count,
x_msg_data => V_msg_data,
p_action_code => p_action_code,
p_delivery_id => p_delivery_id,
x_trip_id => V_trip_id,
x_trip_name => V_trip_name);
IF (V_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS) THEN
WSH_UTIL_CORE.get_messages(‘Y’, V_msg_summary, V_msg_details, V_msg_count);
dbms_output.put_line(V_msg_details);
END IF;
end;
Leave a Reply
Want to join the discussion?Feel free to contribute!