DBA Data[Home] [Help]

APPS.CE_BAT_API dependencies on IBY_TRANSACTION_ERRORS_GT

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

1389: | This procedure calls Payments online validations api and is called|
1390: | from the UI on clicking the validate icon. However, before |
1391: | the api is called, we need to populate the GT iby_docs_payment_gt|
1392: | After the validations are done, and if there are any validations|
1393: | failures, the errors are store in table iby_transaction_errors_gt|
1394: | This errors table is queried and shown from the UI.
1395: | |
1396: | HISTORY |
1397: | 24-JUL-2005 Shaik Vali Created |

Line 1410: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;

1406: l_return_status VARCHAR2(20);
1407: l_msg_count NUMBER;
1408: l_msg_data VARCHAR2(1000);
1409: l_transaction_id NUMBER;
1410: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1411: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1412: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1413: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1414: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;

Line 1411: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;

1407: l_msg_count NUMBER;
1408: l_msg_data VARCHAR2(1000);
1409: l_transaction_id NUMBER;
1410: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1411: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1412: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1413: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1414: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1415: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;

Line 1412: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;

1408: l_msg_data VARCHAR2(1000);
1409: l_transaction_id NUMBER;
1410: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1411: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1412: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1413: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1414: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1415: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1416: l_cnt NUMBER;

Line 1413: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;

1409: l_transaction_id NUMBER;
1410: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1411: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1412: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1413: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1414: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1415: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1416: l_cnt NUMBER;
1417:

Line 1414: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;

1410: l_error_type IBY_TRANSACTION_ERRORS_GT.error_type%TYPE;
1411: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1412: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1413: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1414: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1415: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1416: l_cnt NUMBER;
1417:
1418: BEGIN

Line 1415: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;

1411: l_error_code IBY_TRANSACTION_ERRORS_GT.error_code%TYPE;
1412: l_error_message IBY_TRANSACTION_ERRORS_GT.error_message%TYPE;
1413: l_error_date IBY_TRANSACTION_ERRORS_GT.error_date%TYPE;
1414: l_error_status IBY_TRANSACTION_ERRORS_GT.error_status%TYPE;
1415: l_validation_Set_code IBY_TRANSACTION_ERRORS_GT.validation_set_code%TYPE;
1416: l_cnt NUMBER;
1417:
1418: BEGIN
1419: log('>> call_iby_validate');