API For Orclae apps r12

1.if you get error related to rate type when create po then define tha rate value in gl_daily_rate forms 2. if you get problem related to get_lot_sublot its reason is in mtl table do not have correct product_id 3. if you get this type of error in delivery po Error: PO Shipment (NUMBER = 1) is not open. Error: Transaction type DIRECT is not currently supported by Receiving Open Interface. its solution is update qty_rcv_exception_code to none in po_line_locations_all table

PROCEDURE xxuflx_rcv_proc (p_po_number IN VARCHAR2, p_org_id IN NUMBER)    IS       lv_group_id           NUMBER;       lv_resp_id            NUMBER;       v_resp_code           VARCHAR2 (20);       lv_request_id         NUMBER;       lc_phase              VARCHAR2 (50);       lc_status             VARCHAR2 (50);       lc_dev_phase          VARCHAR2 (50);       lc_dev_status         VARCHAR2 (50);       lc_message            VARCHAR2 (50);       l_req_return_status   BOOLEAN;    BEGIN             xxuflx_po_rcv_trx_intf (p_po_number, p_...

PROCEDURE xxuflx_po_api_with_packing (       errbuff                 OUT   VARCHAR2,       retcode                 OUT   VARCHAR2,       p_packing_list_number         VARCHAR2 DEFAULT NULL    )    IS       --       lv_po_number             po_headers_all.segment1%TYPE;       lv_seq                   NUMBER                         := 0;       lv_interface_header_id   NUMBER;       lv_count                 NUMBER;       lv_interface_lines_id    NUMBER;       lv_distributions_id      NUMBER;   ...

hello this API use for control lot number when you ship. normally oracle select lot number as FIFO based so if we want to ship lot which based on order number then we need to manual allocation of that lot number here we suppose manufacturing unit is maxico and shipping unit means supplier is USA step  1. insert in a table  CREATE OR REPLACE procedure APPS.inst_lot_int_tab (p_po_header_id in number,p_org_id in number ,p_pack_list in varchar2) is    CURSOR get_po_line_det    IS       SELECT poh.vendor_id, pol.item_id, pol.attribute13 order_line_id,              pol.item_id inventory_item_id, pll.*         FROM po_headers_all poh, po_lines_all pol, po_line_locations_all pll        WHERE 1 = 1          AND poh.po_header_id = pol.po_header_id          AND pol.po_header_id = pll.po_header_id     ...