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 := 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
DBMS_OUTPUT.put_line ('Invoice '||p_inv_id|| ' is cancellable' );
DBMS_OUTPUT.put_line ('Invoice '||p_inv_id|| ' is not cancellable :'|| v_error_code );