APPS.IBY_DISBURSE_UI_API_PUB_PKG dependencies on IBY_TRANSACTION_ERRORS

Line 8958: l_error_code IBY_TRANSACTION_ERRORS.error_code%TYPE;

8954:
8955: l_icx_numeric_characters VARCHAR2(30); -- Bug 6411356
8956: l_bool_val boolean; -- Bug 6411356
8957:
8958: l_error_code IBY_TRANSACTION_ERRORS.error_code%TYPE;
8959: /*
8960: * Cursor to pick up all the distinct PPR ids for the set
8961: * of payments which are with this instruction.
8962: *

Line 10472: | for validation errors stored in iby_transaction_errors

10468: | NAME: get_message_text
10469: |
10470: |
10471: | PURPOSE: This function will return the transalated message text
10472: | for validation errors stored in iby_transaction_errors
10473: | This function should be used from the UI pages.
10474: |
10475: | PARAMETERS:
10476: | IN p_transaction_error_id - Transaction error id for the error

Line 10479: | iby_transaction_errors table again.

10475: | PARAMETERS:
10476: | IN p_transaction_error_id - Transaction error id for the error
10477: | IN p_error_code - Error code. This paramester is required
10478: | so that the function does not hit the
10479: | iby_transaction_errors table again.
10480: |
10481: | RETURNS: translated message_text
10482: |
10483: | NOTES:

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

10497: TYPE l_token_info_tab IS TABLE OF l_token_info_rec;
10498:
10499: l_token_info l_token_info_tab;
10500:
10501: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS
10502: SELECT t.token_name, t.token_value, t.lookup_type_source, l.meaning
10503: FROM iby_trxn_error_tokens t, fnd_lookups l
10504: WHERE t.transaction_error_id = (c_trxn_error_id)
10505: AND t.lookup_type_source = l.lookup_type(+)

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

10543: | NAME: get_message_list
10544: |
10545: |
10546: | PURPOSE: This function will return the transalated message text
10547: | for validation errors stored in iby_transaction_errors for an
10548: | specific transaction. This function will return the list of
10549: | messages in html format.
10550: | This function should be used from the UI pages.
10551: |

Line 10568: trxn_error_id iby_transaction_errors.transaction_error_id%TYPE,

10564: RETURN VARCHAR2 AS
10565:
10566: l_contact_mes varchar2(4000);
10567: TYPE l_mes_info_rec IS RECORD (
10568: trxn_error_id iby_transaction_errors.transaction_error_id%TYPE,
10569: error_code iby_transaction_errors.error_code%TYPE);
10570:
10571: TYPE l_token_info_rec IS RECORD(
10572: token_name iby_trxn_error_tokens.token_name%TYPE,

Line 10569: error_code iby_transaction_errors.error_code%TYPE);

10565:
10566: l_contact_mes varchar2(4000);
10567: TYPE l_mes_info_rec IS RECORD (
10568: trxn_error_id iby_transaction_errors.transaction_error_id%TYPE,
10569: error_code iby_transaction_errors.error_code%TYPE);
10570:
10571: TYPE l_token_info_rec IS RECORD(
10572: token_name iby_trxn_error_tokens.token_name%TYPE,
10573: token_value iby_trxn_error_tokens.token_value%TYPE,

Line 10585: FROM iby_transaction_errors

10581: l_token_info l_token_info_tab;
10582:
10583: CURSOR trxn_errors IS
10584: SELECT transaction_error_id, error_code
10585: FROM iby_transaction_errors
10586: WHERE transaction_id = p_transaction_id
10587: AND transaction_type = p_transaction_type
10588: AND error_status = 'ACTIVE';
10589:

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

10586: WHERE transaction_id = p_transaction_id
10587: AND transaction_type = p_transaction_type
10588: AND error_status = 'ACTIVE';
10589:
10590: CURSOR token_info(c_trxn_error_id IN iby_transaction_errors.transaction_error_id%TYPE) IS
10591: SELECT t.token_name, t.token_value, t.lookup_type_source, l.meaning
10592: FROM iby_trxn_error_tokens t, fnd_lookups l
10593: WHERE t.transaction_error_id = (c_trxn_error_id)
10594: AND t.lookup_type_source = l.lookup_type(+)