DBA Data[Home] [Help]

APPS.IBY_PAYGROUP_PUB dependencies on IBY_TRANSACTION_ERRORS

Line 53: -- Transaction types (for inserting into IBY_TRANSACTION_ERRORS table)

49: REJ_LVL_REQUEST CONSTANT VARCHAR2(100) := 'REQUEST';
50: REJ_LVL_PAYMENT CONSTANT VARCHAR2(100) := 'PAYMENT';
51: REJ_LVL_NONE CONSTANT VARCHAR2(100) := 'NONE';
52:
53: -- Transaction types (for inserting into IBY_TRANSACTION_ERRORS table)
54: TRXN_TYPE_DOC CONSTANT VARCHAR2(100) := 'DOCUMENT_PAYABLE';
55: TRXN_TYPE_PMT CONSTANT VARCHAR2(100) := 'PAYMENT';
56:
57: --

Line 4360: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

4356:
4357: l_ce_min_pmt_ctrl NUMBER(15);
4358: l_ce_max_pmt_ctrl NUMBER(15);
4359:
4360: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
4361:
4362: l_error_code VARCHAR2(100);
4363: l_error_msg VARCHAR2(500);
4364: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;

Line 4814: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

4810:
4811: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
4812: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
4813:
4814: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
4815:
4816: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
4817: '.performPmtGrpNumberValidation';
4818:

Line 5710: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

5706: l_preHook_cntr integer;
5707: l_preHookDocsInPmtTab hookDocsInPaymentTabType;
5708: l_str VARCHAR2(2000);
5709:
5710: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
5711:
5712: BEGIN
5713:
5714: print_debuginfo(l_module_name, 'ENTER');

Line 6250: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

6246: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
6247: )
6248: IS
6249:
6250: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
6251:
6252: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
6253: '.adjustSisterDocsAndPmts';
6254:

Line 7187: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

7183: '.failDocsOfPayment';
7184: l_calc_doc_details VARCHAR2(2000) := '';
7185: l_sql_string VARCHAR2(4000) := '';
7186:
7187: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
7188:
7189: BEGIN
7190:
7191: print_debuginfo(l_module_name, 'ENTER');

Line 7608: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

7604: l_allfailed_flag BOOLEAN := TRUE;
7605: l_request_status VARCHAR2(200);
7606: l_orig_req_status VARCHAR2(200);
7607:
7608: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
7609: l_triggering_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
7610:
7611: BEGIN
7612:

Line 8209: * status in the IBY_TRANSACTION_ERRORS table.

8205: *
8206: * Before doing any validations, set any
8207: * existing validation error messages that
8208: * exist against this payment to 'inactive'
8209: * status in the IBY_TRANSACTION_ERRORS table.
8210: *
8211: * Unless we do this, the old errors will
8212: * continue to show up against this payment
8213: * in the IBY UI even if the payment is validated