DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on IBY_TRANSACTION_ERRORS_GT

Line 1618: | failures, the errors are store in table iby_transaction_errors_gt|

1614: | This procedure calls Payments online validations api and is called|
1615: | from the UI on clicking the validate icon. However, before |
1616: | the api is called, we need to populate the GT iby_docs_payment_gt|
1617: | After the validations are done, and if there are any validations|
1618: | failures, the errors are store in table iby_transaction_errors_gt|
1619: | This errors table is queried and shown from the UI.
1620: | |
1621: | HISTORY |
1622: | 24-JUL-2005 Shaik Vali Created |

Line 1635: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;

1631: l_return_status VARCHAR2(20);
1632: l_msg_count NUMBER;
1633: l_msg_data VARCHAR2(1000);
1634: l_transaction_id NUMBER;
1635: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1636: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1637: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1638: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1639: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;

Line 1636: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;

1632: l_msg_count NUMBER;
1633: l_msg_data VARCHAR2(1000);
1634: l_transaction_id NUMBER;
1635: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1636: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1637: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1638: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1639: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1640: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;

Line 1637: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;

1633: l_msg_data VARCHAR2(1000);
1634: l_transaction_id NUMBER;
1635: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1636: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1637: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1638: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1639: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1640: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1641: l_cnt NUMBER;

Line 1638: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;

1634: l_transaction_id NUMBER;
1635: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1636: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1637: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1638: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1639: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1640: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1641: l_cnt NUMBER;
1642:

Line 1639: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;

1635: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1636: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1637: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1638: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1639: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1640: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1641: l_cnt NUMBER;
1642:
1643: -- Bug 16402102: Added

Line 1640: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;

1636: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1637: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1638: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1639: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1640: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1641: l_cnt NUMBER;
1642:
1643: -- Bug 16402102: Added
1644: l_debug_proc VARCHAR2(30) := 'call_iby_validate';