Thursday, April 18, 2013

API to Cancel the Oracle AP Invoice


Is_Invoice_Cancellable is a Function in the AP_CANCEL_PKG package that checks that an Invoice is cancellable or not when an Invoice Cancellation process starts.
It follows the following steps and returns a Boolean value depending on the result.
    If invoice contains distribution that does not have open GL period return FALSE.
    If invoice has an effective payment, return FALSE.
    If invoice is selected for payment, return FALSE.
    If invoice is already cancelled, return FALSE.
    If invoice is credited invoice, return FALSE.
    If invoices have been applied against this invoice, return FALSE.
    If invoice is matched 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, return FALSE.
    If none of above, invoice is cancellable return True.
Here is a small procedure to check if an Invoice is cancellable or not.

Create or replace procedure XX_INV_CANCELLABLE (p_inv_id IN NUMBER)
    v_boolean               BOOLEAN;
    v_error_code            VARCHAR2(100);
    v_debug_info            VARCHAR2(1000);
                             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
       DBMS_OUTPUT.put_line ('Invoice '||p_inv_id|| ' is cancellable' );
       DBMS_OUTPUT.put_line ('Invoice '||p_inv_id|| ' is not cancellable :'|| v_error_code );
    END IF;

Execute XX_INV_CANCELLABLE(88888);

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect