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.ARP_CORRECT_CC_ERRORS dependencies on RA_CUSTOMER_TRX

Line 541: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;

537: p_cc_trx_category IN VARCHAR2,
538: p_source_receipt_id IN NUMBER DEFAULT NULL,
539: p_source_receipt_number IN VARCHAR2 DEFAULT NULL,
540: p_error_notes IN VARCHAR2) IS
541: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
542: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
543: l_cc_trx_category_dsp VARCHAR2(240);
544: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
545: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;

Line 542: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;

538: p_source_receipt_id IN NUMBER DEFAULT NULL,
539: p_source_receipt_number IN VARCHAR2 DEFAULT NULL,
540: p_error_notes IN VARCHAR2) IS
541: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
542: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
543: l_cc_trx_category_dsp VARCHAR2(240);
544: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
545: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
546: l_cc_trx_amount NUMBER;

Line 544: l_cc_trx_number ra_customer_trx.trx_number%TYPE;

540: p_error_notes IN VARCHAR2) IS
541: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
542: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
543: l_cc_trx_category_dsp VARCHAR2(240);
544: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
545: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
546: l_cc_trx_amount NUMBER;
547: l_cc_trx_date DATE;
548: l_customer_name hz_parties.party_name%TYPE;

Line 545: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;

541: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
542: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
543: l_cc_trx_category_dsp VARCHAR2(240);
544: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
545: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
546: l_cc_trx_amount NUMBER;
547: l_cc_trx_date DATE;
548: l_customer_name hz_parties.party_name%TYPE;
549: l_customer_number hz_cust_accounts.account_number%TYPE;

Line 553: l_payment_server_id ra_customer_trx.payment_server_order_num%TYPE;

549: l_customer_number hz_cust_accounts.account_number%TYPE;
550: l_customer_location hz_cust_site_uses.location%TYPE;
551: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
552: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;
553: l_payment_server_id ra_customer_trx.payment_server_order_num%TYPE;
554: l_approval_code ra_customer_trx.approval_code%TYPE;
555: l_collector ar_collectors.name%TYPE;
556: l_payment_method_name ar_receipt_methods.name%TYPE;
557: l_days_late NUMBER;

Line 554: l_approval_code ra_customer_trx.approval_code%TYPE;

550: l_customer_location hz_cust_site_uses.location%TYPE;
551: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
552: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;
553: l_payment_server_id ra_customer_trx.payment_server_order_num%TYPE;
554: l_approval_code ra_customer_trx.approval_code%TYPE;
555: l_collector ar_collectors.name%TYPE;
556: l_payment_method_name ar_receipt_methods.name%TYPE;
557: l_days_late NUMBER;
558: l_billto_contact varchar2(150);

Line 594: FROM ra_customer_trx trx,

590: l_payment_server_id,
591: l_approval_code,
592: l_collector,
593: l_payment_method_name
594: FROM ra_customer_trx trx,
595: ar_receipt_methods rm,
596: hz_parties party,
597: hz_cust_accounts cust,
598: hz_cust_site_uses site_uses,

Line 630: FROM ra_customer_trx CT,

626: substrb(RACO_BILL_PARTY.person_first_name,1,50),
627: substrb(RA_SALES.NAME,1,50)
628: INTO l_billto_contact,
629: l_salesrep_name
630: FROM ra_customer_trx CT,
631: hz_cust_account_roles RACO_BILL,
632: hz_parties RACO_BILL_PARTY,
633: hz_relationships RACO_BILL_REL,
634: ra_salesreps RA_SALES

Line 646: UPDATE ra_customer_trx_all

642: and raco_bill_rel.status(+) = 'A'
643: and ct.primary_salesrep_id = ra_sales.salesrep_id (+)
644: and ct.customer_trx_id = p_customer_trx_id;
645:
646: UPDATE ra_customer_trx_all
647: SET payment_trxn_extension_id = NULL,
648: receipt_method_id = NULL,
649: cc_error_flag = NULL,
650: last_update_date = sysdate,

Line 1567: | p_table_name - RA_CUSTOMER_TRX/AR_CASH_RECEIPTS/CASH/MISC

Line 1685: FROM ra_customer_trx

1681: SELECT 'Y'
1682: INTO l_return_status
1683: FROM dual
1684: WHERE EXISTS (SELECT 1
1685: FROM ra_customer_trx
1686: WHERE request_id = p_request_id
1687: AND cc_error_flag = 'Y');
1688: EXCEPTION
1689: WHEN NO_DATA_FOUND THEN

Line 1863: FROM ra_customer_trx trx,

1859: trx.customer_bank_account_id,
1860: trx.cc_error_code,
1861: trx.cc_error_text,
1862: trx.payment_server_order_num
1863: FROM ra_customer_trx trx,
1864: ra_cust_trx_types trx_type
1865: WHERE trx.cust_trx_type_id = trx_type.cust_trx_type_id
1866: AND trx.request_id = p_request_id
1867: AND trx.cc_error_flag = 'Y'

Line 1989: UPDATE ra_customer_trx

1985: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),
1986: rec_version_number = rec_version_number+1
1987: WHERE cash_receipt_id = p_cc_trx_id;
1988: ELSE
1989: UPDATE ra_customer_trx
1990: SET cc_error_flag =NULL,
1991: cc_error_code = NULL,
1992: cc_error_text = NULL,
1993: customer_bank_account_id = customer_bank_account_id

Line 2105: FROM ra_customer_trx trx,

2101: SELECT trx.customer_trx_id,
2102: trx.trx_number,
2103: trx_types.type,
2104: cr.receipt_number
2105: FROM ra_customer_trx trx,
2106: ar_receivable_applications ra,
2107: ar_cash_receipts cr,
2108: ra_cust_trx_types trx_types
2109: WHERE trx.customer_trx_id = ra.applied_customer_trx_id

Line 2122: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

2118: l_rec_number ar_cash_receipts.receipt_number%TYPE;
2119: l_error_notes VARCHAR2(240);
2120: l_dummy_number NUMBER;
2121: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2122: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
2123: l_trx_number ra_customer_trx.trx_number%TYPE;
2124: l_object_version_number ar_cash_receipts.rec_version_number%TYPE;
2125: l_cc_error_code ar_cash_receipts.cc_error_code%TYPE;
2126: l_cc_error_desc ar_cash_receipts.cc_error_text%TYPE;

Line 2123: l_trx_number ra_customer_trx.trx_number%TYPE;

2119: l_error_notes VARCHAR2(240);
2120: l_dummy_number NUMBER;
2121: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2122: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
2123: l_trx_number ra_customer_trx.trx_number%TYPE;
2124: l_object_version_number ar_cash_receipts.rec_version_number%TYPE;
2125: l_cc_error_code ar_cash_receipts.cc_error_code%TYPE;
2126: l_cc_error_desc ar_cash_receipts.cc_error_text%TYPE;
2127: l_cc_trx_category_dsp VARCHAR2(240);

Line 2138: l_approval_code ra_customer_trx.approval_code%TYPE;

2134: l_customer_location hz_cust_site_uses.location%TYPE;
2135: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
2136: l_expiration_date IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_EXPIRYDATE%TYPE;
2137: l_payment_server_id ar_cash_receipts.payment_server_order_num%TYPE;
2138: l_approval_code ra_customer_trx.approval_code%TYPE;
2139: l_collector ar_collectors.name%TYPE;
2140: l_payment_method_name ar_receipt_methods.name%TYPE;
2141: PAY_exception EXCEPTION;
2142:

Line 2188: FROM ra_customer_trx

2184: IF ARP_GLOBAL.request_id IS NOT NULL then
2185: BEGIN
2186: SELECT 1
2187: INTO l_dummy_number
2188: FROM ra_customer_trx
2189: WHERE customer_trx_id = inv_cur.customer_trx_id
2190: FOR UPDATE OF customer_trx_id;
2191: EXCEPTION
2192: WHEN OTHERS THEN

Line 2197: p_table_name=>'RA_CUSTOMER_TRX',

2193: raise;
2194: END;
2195: ELSE
2196: lock_table_nowait(p_key=>inv_cur.customer_trx_id,
2197: p_table_name=>'RA_CUSTOMER_TRX',
2198: p_trx_number=>inv_cur.trx_number);
2199: END IF;
2200: -- Clear the credit card information and payment method from invoice
2201: clear_invoice_pay_info(p_customer_trx_id=>inv_cur.customer_trx_id,

Line 2386: FROM ra_customer_trx

2382: AND cc_error_code IS NOT NULL
2383: FOR UPDATE OF cash_receipt_id;
2384: CURSOR lock_trx IS
2385: SELECT 'lock'
2386: FROM ra_customer_trx
2387: WHERE request_id = p_request_id
2388: AND cc_error_flag = 'Y'
2389: AND cc_error_code IS NOT NULL
2390: FOR UPDATE OF customer_trx_id;

Line 2408: arp_util.debug('Locking ra_customer_trx records for processing..');

2404: CLOSE lock_cr;
2405: correct_remittance_errors(p_request_id);
2406: ELSE
2407: IF PG_DEBUG in ('Y', 'C') THEN
2408: arp_util.debug('Locking ra_customer_trx records for processing..');
2409: END IF;
2410: OPEN lock_trx;
2411: CLOSE lock_trx;
2412: correct_creation_errors(p_request_id);

Line 2494: UPDATE ra_customer_trx

2490: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),
2491: rec_version_number = rec_version_number+1
2492: WHERE cash_receipt_id = p_cc_trx_id;
2493: ELSE
2494: UPDATE ra_customer_trx
2495: SET cc_error_flag =NULL,
2496: cc_error_code = NULL,
2497: cc_error_text = NULL
2498: WHERE customer_trx_id = p_cc_trx_id;

Line 2514: UPDATE ra_customer_trx

2510: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),
2511: rec_version_number = rec_version_number+1
2512: WHERE cash_receipt_id = p_cc_trx_id;
2513: ELSE
2514: UPDATE ra_customer_trx
2515: SET cc_error_flag =NULL,
2516: cc_error_code = NULL,
2517: cc_error_text = NULL
2518: WHERE customer_trx_id = p_cc_trx_id;

Line 2549: UPDATE ra_customer_trx_all

2545:
2546:
2547: ELSE
2548: /* i) update receipt_method and payment info of inv to null */
2549: UPDATE ra_customer_trx_all
2550: SET payment_trxn_extension_id = NULL,
2551: receipt_method_id = NULL,
2552: cc_error_flag = NULL,
2553: last_update_date = sysdate,