APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on IBY_TRANSACTION_ERRORS

Line 7753: l_error_code IBY_TRANSACTION_ERRORS.error_code%TYPE;

7749:
7750: l_icx_numeric_characters VARCHAR2(30); -- Bug 6411356
7751: l_bool_val boolean; -- Bug 6411356
7752:
7753: l_error_code IBY_TRANSACTION_ERRORS.error_code%TYPE;
7754:
7755: /*
7756: * Cursor to pick up all calling applications associated
7757: * with a particular payment instruction.

Line 8948: | for validation errors stored in iby_transaction_errors

8944: | NAME: get_message_text
8945: |
8946: |
8947: | PURPOSE: This function will return the transalated message text
8948: | for validation errors stored in iby_transaction_errors
8949: | This function should be used from the UI pages.
8950: |
8951: | PARAMETERS:
8952: | IN p_transaction_error_id - Transaction error id for the error

Line 8955: | iby_transaction_errors table again.

8951: | PARAMETERS:
8952: | IN p_transaction_error_id - Transaction error id for the error
8953: | IN p_error_code - Error code. This paramester is required
8954: | so that the function does not hit the
8955: | iby_transaction_errors table again.
8956: |
8957: | RETURNS: translated message_text
8958: |
8959: | NOTES:

Line 8977: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS

8973: TYPE l_token_info_tab IS TABLE OF l_token_info_rec;
8974:
8975: l_token_info l_token_info_tab;
8976:
8977: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS
8978: SELECT t.token_name, t.token_value, t.lookup_type_source, l.meaning
8979: FROM iby_trxn_error_tokens t, fnd_lookups l
8980: WHERE t.transaction_error_id = (c_trxn_error_id)
8981: AND t.lookup_type_source = l.lookup_type(+)

Line 9023: | for validation errors stored in iby_transaction_errors for an

9019: | NAME: get_message_list
9020: |
9021: |
9022: | PURPOSE: This function will return the transalated message text
9023: | for validation errors stored in iby_transaction_errors for an
9024: | specific transaction. This function will return the list of
9025: | messages in html format.
9026: | This function should be used from the UI pages.
9027: |

Line 9044: trxn_error_id iby_transaction_errors.transaction_error_id%TYPE,

9040: RETURN VARCHAR2 AS
9041:
9042: l_contact_mes varchar2(4000);
9043: TYPE l_mes_info_rec IS RECORD (
9044: trxn_error_id iby_transaction_errors.transaction_error_id%TYPE,
9045: error_code iby_transaction_errors.error_code%TYPE);
9046:
9047: TYPE l_token_info_rec IS RECORD(
9048: token_name iby_trxn_error_tokens.token_name%TYPE,

Line 9045: error_code iby_transaction_errors.error_code%TYPE);

9041:
9042: l_contact_mes varchar2(4000);
9043: TYPE l_mes_info_rec IS RECORD (
9044: trxn_error_id iby_transaction_errors.transaction_error_id%TYPE,
9045: error_code iby_transaction_errors.error_code%TYPE);
9046:
9047: TYPE l_token_info_rec IS RECORD(
9048: token_name iby_trxn_error_tokens.token_name%TYPE,
9049: token_value iby_trxn_error_tokens.token_value%TYPE,

Line 9061: FROM iby_transaction_errors

9057: l_token_info l_token_info_tab;
9058:
9059: CURSOR trxn_errors IS
9060: SELECT transaction_error_id, error_code
9061: FROM iby_transaction_errors
9062: WHERE transaction_id = p_transaction_id
9063: AND transaction_type = p_transaction_type
9064: AND error_status = 'ACTIVE';
9065:

Line 9066: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS

9062: WHERE transaction_id = p_transaction_id
9063: AND transaction_type = p_transaction_type
9064: AND error_status = 'ACTIVE';
9065:
9066: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS
9067: SELECT t.token_name, t.token_value, t.lookup_type_source, l.meaning
9068: FROM iby_trxn_error_tokens t, fnd_lookups l
9069: WHERE t.transaction_error_id = (c_trxn_error_id)
9070: AND t.lookup_type_source = l.lookup_type(+)