eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_PAYGROUP_PUB dependencies on IBY_TRANSACTION_ERRORS

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

51: REJ_LVL_PAYMENT CONSTANT VARCHAR2(100) := 'PAYMENT';
52: REJ_LVL_PAYEE CONSTANT VARCHAR2(100) := 'PAYEE';
53: REJ_LVL_NONE CONSTANT VARCHAR2(100) := 'NONE';
54:
55: -- Transaction types (for inserting into IBY_TRANSACTION_ERRORS table)
56: TRXN_TYPE_DOC CONSTANT VARCHAR2(100) := 'DOCUMENT_PAYABLE';
57: TRXN_TYPE_PMT CONSTANT VARCHAR2(100) := 'PAYMENT';
58: l_DocsInPmtCount NUMBER;
59:

Line 10378: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

10374: l_ce_currency_code VARCHAR2(15);
10375: l_ce_min_pmt_ctrl NUMBER(15);
10376: l_ce_max_pmt_ctrl NUMBER(15);
10377:
10378: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
10379:
10380: l_error_code VARCHAR2(100);
10381: l_error_msg VARCHAR2(500);
10382: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;

Line 10972: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

10968:
10969: l_compare_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
10970: l_compare_doc_id IBY_DOCS_PAYABLE_ALL.document_payable_id%TYPE;
10971:
10972: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
10973:
10974: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
10975: '.performPmtGrpNumberValidation';
10976:

Line 12402: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

12398: l_preHook_cntr integer;
12399: l_preHookDocsInPmtTab hookDocsInPaymentTabType;
12400: l_str VARCHAR2(2000);
12401:
12402: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
12403:
12404: BEGIN
12405:
12406: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 12978: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

12974: l_preHook_cntr integer;
12975: l_preHookDocsInPmtTab hookDocsInPaymentTabType;
12976: l_str VARCHAR2(2000);
12977:
12978: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
12979: l_docsingt_count NUMBER;
12980:
12981: l_pmts_tab_count NUMBER;
12982: l_posthook_count NUMBER;

Line 13636: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

13632: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
13633: )
13634: IS
13635:
13636: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
13637:
13638: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
13639: '.adjustSisterDocsAndPmts';
13640:

Line 13827: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

13823: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
13824: )
13825: IS
13826:
13827: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
13828:
13829: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
13830: '.adjustSisterDocsAndPmts';
13831:

Line 14056: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

14052: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
14053: )
14054: IS
14055:
14056: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
14057:
14058: l_module_name CONSTANT VARCHAR2(200) := G_PKG_NAME ||
14059: '.adjustSisterDocsAndPmtsPost';
14060:

Line 15605: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

15601: '.failDocsOfPayment';
15602: l_calc_doc_details VARCHAR2(2000) := '';
15603: l_sql_string VARCHAR2(4000) := '';
15604:
15605: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
15606:
15607: BEGIN
15608:
15609: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 15702: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

15698: '.failDocsOfPayment';
15699: l_calc_doc_details VARCHAR2(2000) := '';
15700: l_sql_string VARCHAR2(4000) := '';
15701:
15702: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
15703:
15704: CURSOR c_fail_docs_of_payment(p_paymentId IBY_PAYMENTS_ALL.payment_id%TYPE)
15705: IS
15706: SELECT idpt.payment_id,

Line 16599: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

16595: l_allfailed_flag BOOLEAN := TRUE;
16596: l_request_status VARCHAR2(200);
16597: l_orig_req_status VARCHAR2(200);
16598:
16599: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
16600: l_triggering_pmt_id IBY_PAYMENTS_ALL.payment_id%TYPE;
16601:
16602: BEGIN
16603: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

Line 17237: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

17233: l_request_status VARCHAR2(200);
17234: l_orig_req_status VARCHAR2(200);
17235:
17236: l_pmt_count NUMBER;
17237: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
17238: l_triggering_pmt_id IBY_PAYMENTS_ALL.payment_reference_number%TYPE;
17239:
17240: l_validpayment_flag VARCHAR2(1) := 'N'; --bug 13854619
17241:

Line 18097: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

18093: l_stmt VARCHAR2(200);
18094: l_result NUMBER := 0;
18095: l_check_val BOOLEAN := FALSE;
18096: l_error_code VARCHAR2(100);
18097: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
18098:
18099:
18100:
18101:

Line 18452: * status in the IBY_TRANSACTION_ERRORS table.

18448: *
18449: * Before doing any validations, set any
18450: * existing validation error messages that
18451: * exist against this payment to 'inactive'
18452: * status in the IBY_TRANSACTION_ERRORS table.
18453: *
18454: * Unless we do this, the old errors will
18455: * continue to show up against this payment
18456: * in the IBY UI even if the payment is validated

Line 26697: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;

26693: x_errTokenTab IN OUT NOCOPY IBY_VALIDATIONSETS_PUB.trxnErrTokenTabType
26694: )
26695: IS
26696: l_module_name VARCHAR2(200) := G_PKG_NAME || '.negativePmtAmountCheck';
26697: l_doc_err_rec IBY_TRANSACTION_ERRORS%ROWTYPE;
26698: l_error_code VARCHAR2(100);
26699: l_error_msg VARCHAR2(500);
26700: l_token_rec IBY_TRXN_ERROR_TOKENS%ROWTYPE;
26701: BEGIN