Update the Project Status using API
Introduction: This blog has the SQL Script to update the Project Status using API along with each task. Cause of the issue: To update status of the project and…
Read MoreAPI Script To Update Supplier Details
This blog has the script to update the supplier details using API AP_VENDOR_PUB_PKG.UPDATE_VENDOR. Cause of the issue: Some of the fields are not visible and don’t have option to…
Read MoreShip Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2)IS–Standard Parameters.p_api_version NUMBER := 1.0;p_init_msg_list VARCHAR2(30);–Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15);p_delivery_id NUMBER:= p_delivery_id_s;p_delivery_name VARCHAR2(30);p_asg_trip_id NUMBER:=p_trip_id;p_asg_trip_name VARCHAR2(30);p_asg_pickup_stop_id NUMBER;p_asg_pickup_loc_id NUMBER;p_asg_pickup_loc_code VARCHAR2(30);p_asg_pickup_arr_date DATE;p_asg_pickup_dep_date DATE;p_asg_dropoff_stop_id NUMBER;p_asg_dropoff_loc_id NUMBER;p_asg_dropoff_loc_code…
Read MoreShipment Tracking Number Update using API
procedure xxdm_upd_ship_num_in_orcl(p_delivery_detail_id NUMBER, p_thirsd_party_tracking_number VARCHAR2) is l_index NUMBER; l_msg_return NUMBER; x_return_status VARCHAR2 (1); x_msg_count NUMBER; x_msg_data VARCHAR2 (32767); l_changedattributetabtype wsh_delivery_details_pub.changedattributetabtype; BEGIN fnd_global.APPS_INITIALIZE (0, 21676, 385); — Provide user_id, resp_id and…
Read MoreShip Confirm of multiple deliveries Using API in EBS
PROCEDURE XDM_SHIP_CONFIRM(p_delivery_id_s NUMBER, p_shipping_method VARCHAR2, p_trip_id number, p_close_trip_flag VARCHAR2) IS –Standard Parameters. p_api_version NUMBER := 1.0; p_init_msg_list VARCHAR2(30); –Parameters for WSH_DELIVERIES_PUB.Delivery_Action. p_action_code VARCHAR2(15); p_delivery_id NUMBER:= p_delivery_id_s; p_delivery_name VARCHAR2(30); p_asg_trip_id NUMBER:=p_trip_id;…
Read MoreTo Upload Credit Memos in EBS
DEclare l_tax_combination_id number; l_return_status VARCHAR2 (100); l_error VARCHAR2 (1000); v_request_id NUMBER; v_msg_count NUMBER; v_msg_data VARCHAR2 (2000); v_return_status VARCHAR2 (1); l_cm_trx_header_id NUMBER; l_cm_trx_line_id NUMBER; lc_customer_trx_id NUMBER; pc_msg_count NUMBER; pc_msg_data VARCHAR2 (1000);…
Read MoreInterfacing EBS Orders with External Application
We made use of utl_http to post json_data. This piece of code will help in sending data to Custom Applications DECLARE vrequest CLOB; oresp_status_code VARCHAR2 (32000); oresp_reason_phrase …
Read MoreXML Publisher Bursting Barcode Font is Ignored
In XML Publisher Bursting Barcode Font is Ignored. An XML Publisher concurrent program that produces a PDF output with barcodes works when running the concurrent program and viewing the output.…
Read More