add

About Me

My photo
Oracle Apps - Techno Functional consultant

Thursday, April 18

API to Cancel the Oracle AP Invoice



AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE:

Is_Invoice_Cancellable is a Function in the AP_CANCEL_PKG package that checks that an Invoice is cancellable or not whenan Invoice Cancellation process starts.
It follows the following steps and returns a Booleanvalue depending on the result.
    If invoice containsdistribution that does not have open GL period return FALSE.
    If invoice has an effective payment, return FALSE.
    If invoice isselected for payment, return FALSE.
    If invoice isalready cancelled, return FALSE.
    If invoice iscredited invoice, return FALSE.
    If invoices have been applied against this invoice, return FALSE.
    If invoice ismatched to Finally Closed PO’s, return FALSE.
    If project related invoices have pending adjustments, return FALSE.
    If cancelling will cause qty_billed or amount_billed to less than 0, returnFALSE.
    If none ofabove, invoice is cancellable return True.
Here is a small procedure to check ifan Invoice is cancellable or not.

Create or replace procedure XX_INV_CANCELLABLE (p_inv_id IN NUMBER)
is
    v_boolean               BOOLEAN;
    v_error_code            VARCHAR2(100);
    v_debug_info            VARCHAR2(1000);
begin
    v_boolean := AP_CANCEL_PKG.IS_INVOICE_CANCELLABLE
                         (
                             P_invoice_id       => p_inv_id,
                            P_error_code       => v_error_code,
                            P_debug_info       => v_debug_info,
                            P_calling_sequence => NULL
                         );
    IF v_boolean=TRUE
    THEN
       DBMS_OUTPUT.put_line ('Invoice '||p_inv_id|| ' is cancellable' );
    ELSE
       DBMS_OUTPUT.put_line ('Invoice '||p_inv_id|| ' is not cancellable :'|| v_error_code );
    END IF;
End XX_INV_CANCELLABLE;

Execute XX_INV_CANCELLABLE(88888);


No comments: