Wrapper Code Calling API Process_limits Is Throwing Error : Limit Cannot Be Modified Because Balance Exists for This Limit (Doc ID 2970391.1)

Limit cannot be modified because balance exists for this Limit.

Sample code used:

SET SERVEROUTPUT ON;



DECLARE
    x_return_status           VARCHAR2(240) := fnd_api.g_ret_sts_success;
    x_msg_count               NUMBER;
    x_msg_data                VARCHAR2(32000);
    p_limits_rec              qp_limits_pub.limits_rec_type;
    p_limits_val_rec          qp_limits_pub.limits_val_rec_type;
    p_limit_attrs_tbl         qp_limits_pub.limit_attrs_tbl_type;
    p_limit_attrs_val_tbl     qp_limits_pub.limit_attrs_val_tbl_type;
    p_limit_balances_tbl      qp_limits_pub.limit_balances_tbl_type;
    p_limit_balances_val_tbl  qp_limits_pub.limit_balances_val_tbl_type;
    x_limits_rec              qp_limits_pub.limits_rec_type;
    x_limits_val_rec          qp_limits_pub.limits_val_rec_type;
    x_limit_attrs_tbl         qp_limits_pub.limit_attrs_tbl_type;
    x_limit_attrs_val_tbl     qp_limits_pub.limit_attrs_val_tbl_type;
    x_limit_balances_tbl      qp_limits_pub.limit_balances_tbl_type;
    x_limit_balances_val_tbl  qp_limits_pub.limit_balances_val_tbl_type;
BEGIN
    oe_debug_pub.setdebuglevel(5);
    oe_debug_pub.g_dir := '/usr/tmp'; -- Example
    dbms_output.put_line('The File is' || oe_debug_pub.set_debug_mode('FILE'));
    oe_debug_pub.initialize;
    oe_debug_pub.debug_on;
    p_limits_rec.amount := 1;
    p_limits_rec.limit_id := &limit_id;
    p_limits_rec.list_header_id := &list_header_id;
    p_limits_rec.list_line_id := &list_line_id;
    p_limits_rec.last_updated_by := '-1';
    p_limits_rec.last_update_date := sysdate;
    p_limits_rec.operation := 'UPDATE';
    qp_limits_pub.process_limits(1.0, 'T',
                                'T',
                                'T',
                                x_return_status,
                                x_msg_count,
                                x_msg_data,
                                p_limits_rec,
                                p_limits_val_rec,
                                p_limit_attrs_tbl,
                                p_limit_attrs_val_tbl,
                                p_limit_balances_tbl,
                                p_limit_balances_val_tbl,
                                x_limits_rec,
                                x_limits_val_rec,
                                x_limit_attrs_tbl,
                                x_limit_attrs_val_tbl,
                                x_limit_balances_tbl,
                                x_limit_balances_val_tbl);

    COMMIT;
    dbms_output.put_line('x_msg_data limit - ' || x_msg_data);
    dbms_output.put_line('x_return_status limit - ' || x_return_status);
EXCEPTION
    WHEN OTHERS THEN
        dbms_output.put_line('Some error occurred' || sqlerrm);
        ROLLBACK;
END;
/