48: -- this module.
49: --
50: REJ_LVL_REQUEST CONSTANT VARCHAR2(100) := 'REQUEST';
51:
52: -- Transaction types (for selection from IBY_TRANSACTION_ERRORS table)
53: TRXN_TYPE_DOC CONSTANT VARCHAR2(100) := 'DOCUMENT_PAYABLE';
54: TRXN_TYPE_PMT CONSTANT VARCHAR2(100) := 'PAYMENT';
55: TRXN_TYPE_INS CONSTANT VARCHAR2(100) := 'INSTRUCTION';
56:
271: | U - Unexpected / system error
272: |
273: | x_error_ids_tab
274: | List of validation error ids that map to
275: | IBY_TRANSACTION_ERRORS.transaction_error_id. Use these
276: | error ids to look up this table for list of validation errors.
277: |
278: | This parameter is only relevant when the return status is E.
279: |
429: IS
430: SELECT
431: err.transaction_error_id
432: FROM
433: IBY_TRANSACTION_ERRORS err,
434: IBY_DOCS_PAYABLE_ALL doc,
435: IBY_PAY_SERVICE_REQUESTS prq
436: WHERE
437: err.transaction_id = doc.document_payable_id AND
449: IS
450: SELECT
451: err.transaction_error_id
452: FROM
453: IBY_TRANSACTION_ERRORS err,
454: IBY_PAYMENTS_ALL pmt,
455: IBY_PAY_SERVICE_REQUESTS prq
456: WHERE
457: err.transaction_id = pmt.payment_id AND
469: IS
470: SELECT
471: err.transaction_error_id
472: FROM
473: IBY_TRANSACTION_ERRORS err,
474: IBY_PAYMENTS_ALL pmt,
475: IBY_PAY_INSTRUCTIONS_ALL ins,
476: IBY_PAY_SERVICE_REQUESTS prq
477: WHERE
2806: IS
2807: SELECT
2808: err.transaction_error_id
2809: FROM
2810: IBY_TRANSACTION_ERRORS err,
2811: IBY_DOCS_PAYABLE_ALL doc,
2812: IBY_PAY_SERVICE_REQUESTS prq
2813: WHERE
2814: err.transaction_id = doc.document_payable_id AND
2826: IS
2827: SELECT
2828: err.transaction_error_id
2829: FROM
2830: IBY_TRANSACTION_ERRORS err,
2831: IBY_PAYMENTS_ALL pmt,
2832: IBY_PAY_SERVICE_REQUESTS prq
2833: WHERE
2834: err.transaction_id = pmt.payment_id AND
2846: IS
2847: SELECT
2848: err.transaction_error_id
2849: FROM
2850: IBY_TRANSACTION_ERRORS err,
2851: IBY_PAYMENTS_ALL pmt,
2852: IBY_PAY_INSTRUCTIONS_ALL ins,
2853: IBY_PAY_SERVICE_REQUESTS prq
2854: WHERE