47: -- this module.
48: --
49: REJ_LVL_REQUEST CONSTANT VARCHAR2(100) := 'REQUEST';
50:
51: -- Transaction types (for selection from IBY_TRANSACTION_ERRORS table)
52: TRXN_TYPE_DOC CONSTANT VARCHAR2(100) := 'DOCUMENT_PAYABLE';
53: TRXN_TYPE_PMT CONSTANT VARCHAR2(100) := 'PAYMENT';
54: TRXN_TYPE_INS CONSTANT VARCHAR2(100) := 'INSTRUCTION';
55:
270: | U - Unexpected / system error
271: |
272: | x_error_ids_tab
273: | List of validation error ids that map to
274: | IBY_TRANSACTION_ERRORS.transaction_error_id. Use these
275: | error ids to look up this table for list of validation errors.
276: |
277: | This parameter is only relevant when the return status is E.
278: |
426: IS
427: SELECT
428: err.transaction_error_id
429: FROM
430: IBY_TRANSACTION_ERRORS err,
431: IBY_DOCS_PAYABLE_ALL doc,
432: IBY_PAY_SERVICE_REQUESTS prq
433: WHERE
434: err.transaction_id = doc.document_payable_id AND
446: IS
447: SELECT
448: err.transaction_error_id
449: FROM
450: IBY_TRANSACTION_ERRORS err,
451: IBY_PAYMENTS_ALL pmt,
452: IBY_PAY_SERVICE_REQUESTS prq
453: WHERE
454: err.transaction_id = pmt.payment_id AND
466: IS
467: SELECT
468: err.transaction_error_id
469: FROM
470: IBY_TRANSACTION_ERRORS err,
471: IBY_PAYMENTS_ALL pmt,
472: IBY_PAY_INSTRUCTIONS_ALL ins,
473: IBY_PAY_SERVICE_REQUESTS prq
474: WHERE
2551: IS
2552: SELECT
2553: err.transaction_error_id
2554: FROM
2555: IBY_TRANSACTION_ERRORS err,
2556: IBY_DOCS_PAYABLE_ALL doc,
2557: IBY_PAY_SERVICE_REQUESTS prq
2558: WHERE
2559: err.transaction_id = doc.document_payable_id AND
2571: IS
2572: SELECT
2573: err.transaction_error_id
2574: FROM
2575: IBY_TRANSACTION_ERRORS err,
2576: IBY_PAYMENTS_ALL pmt,
2577: IBY_PAY_SERVICE_REQUESTS prq
2578: WHERE
2579: err.transaction_id = pmt.payment_id AND
2591: IS
2592: SELECT
2593: err.transaction_error_id
2594: FROM
2595: IBY_TRANSACTION_ERRORS err,
2596: IBY_PAYMENTS_ALL pmt,
2597: IBY_PAY_INSTRUCTIONS_ALL ins,
2598: IBY_PAY_SERVICE_REQUESTS prq
2599: WHERE