840: | NOTES:
841: |
842: *---------------------------------------------------------------------*/
843: PROCEDURE createPmtErrorRecord(
844: p_pmt_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
845: p_pmt_status IN IBY_PAYMENTS_ALL.
846: payment_status%TYPE,
847: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
848: DEFAULT NULL,
841: |
842: *---------------------------------------------------------------------*/
843: PROCEDURE createPmtErrorRecord(
844: p_pmt_id IN IBY_PAYMENTS_ALL.payment_id%TYPE,
845: p_pmt_status IN IBY_PAYMENTS_ALL.
846: payment_status%TYPE,
847: p_error_code IN IBY_TRANSACTION_ERRORS.error_code%TYPE
848: DEFAULT NULL,
849: p_error_msg IN IBY_TRANSACTION_ERRORS.error_message%TYPE
1351: || PAY_STATUS_CREATED
1352: );
1353:
1354: UPDATE
1355: IBY_PAYMENTS_ALL pmt
1356: SET
1357: pmt.payment_status = PAY_STATUS_CREATED
1358: WHERE
1359: pmt.payment_id = p_trxn_id