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 551: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;

547: p_cc_trx_category IN VARCHAR2,
548: p_source_receipt_id IN NUMBER DEFAULT NULL,
549: p_source_receipt_number IN VARCHAR2 DEFAULT NULL,
550: p_error_notes IN VARCHAR2) IS
551: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
552: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
553: l_cc_trx_category_dsp VARCHAR2(240);
554: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
555: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;

Line 552: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;

548: p_source_receipt_id IN NUMBER DEFAULT NULL,
549: p_source_receipt_number IN VARCHAR2 DEFAULT NULL,
550: p_error_notes IN VARCHAR2) IS
551: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
552: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
553: l_cc_trx_category_dsp VARCHAR2(240);
554: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
555: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
556: l_cc_trx_amount NUMBER;

Line 554: l_cc_trx_number ra_customer_trx.trx_number%TYPE;

550: p_error_notes IN VARCHAR2) IS
551: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
552: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
553: l_cc_trx_category_dsp VARCHAR2(240);
554: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
555: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
556: l_cc_trx_amount NUMBER;
557: l_cc_trx_date DATE;
558: l_customer_name hz_parties.party_name%TYPE;

Line 555: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;

551: l_cc_error_code ra_customer_trx.cc_error_code%TYPE;
552: l_cc_error_desc ra_customer_trx.cc_error_text%TYPE;
553: l_cc_trx_category_dsp VARCHAR2(240);
554: l_cc_trx_number ra_customer_trx.trx_number%TYPE;
555: l_cc_trx_currency ra_customer_trx.invoice_currency_code%TYPE;
556: l_cc_trx_amount NUMBER;
557: l_cc_trx_date DATE;
558: l_customer_name hz_parties.party_name%TYPE;
559: l_customer_number hz_cust_accounts.account_number%TYPE;

Line 562: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%TYPE;

558: l_customer_name hz_parties.party_name%TYPE;
559: l_customer_number hz_cust_accounts.account_number%TYPE;
560: l_customer_location hz_cust_site_uses.location%TYPE;
561: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
562: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%TYPE;
563: l_approval_code ra_customer_trx.approval_code%TYPE;
564: l_collector ar_collectors.name%TYPE;
565: l_payment_method_name ar_receipt_methods.name%TYPE;
566: l_days_late NUMBER;

Line 563: l_approval_code ra_customer_trx.approval_code%TYPE;

559: l_customer_number hz_cust_accounts.account_number%TYPE;
560: l_customer_location hz_cust_site_uses.location%TYPE;
561: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
562: l_payment_trxn_extension_id ra_customer_trx.payment_trxn_extension_id%TYPE;
563: l_approval_code ra_customer_trx.approval_code%TYPE;
564: l_collector ar_collectors.name%TYPE;
565: l_payment_method_name ar_receipt_methods.name%TYPE;
566: l_days_late NUMBER;
567: l_billto_contact varchar2(150);

Line 601: FROM ra_customer_trx trx,

597: l_payment_trxn_extension_id,
598: l_approval_code,
599: l_collector,
600: l_payment_method_name
601: FROM ra_customer_trx trx,
602: ar_receipt_methods rm,
603: hz_parties party,
604: hz_cust_accounts cust,
605: hz_cust_site_uses site_uses,

Line 639: FROM ra_customer_trx CT,

635: substrb(RACO_BILL_PARTY.person_first_name,1,50),
636: substrb(RA_SALES.NAME,1,50)
637: INTO l_billto_contact,
638: l_salesrep_name
639: FROM ra_customer_trx CT,
640: hz_cust_account_roles RACO_BILL,
641: hz_parties RACO_BILL_PARTY,
642: hz_relationships RACO_BILL_REL,
643: ra_salesreps RA_SALES

Line 655: UPDATE ra_customer_trx

651: and raco_bill_rel.status(+) = 'A'
652: and ct.primary_salesrep_id = ra_sales.salesrep_id (+)
653: and ct.customer_trx_id = p_customer_trx_id;
654:
655: UPDATE ra_customer_trx
656: SET payment_trxn_extension_id = NULL,
657: receipt_method_id = NULL,
658: cc_error_flag = NULL,
659: cc_error_code = NULL,

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

Line 1693: FROM ra_customer_trx

1689: SELECT 'Y'
1690: INTO l_return_status
1691: FROM dual
1692: WHERE EXISTS (SELECT 1
1693: FROM ra_customer_trx
1694: WHERE request_id IN ( select request_id
1695: from fnd_concurrent_requests
1696: where request_id = p_request_id
1697: or parent_request_id = p_request_id )

Line 1880: FROM ra_customer_trx trx,

1876: trx.payment_trxn_extension_id,
1877: trx.cc_error_code,
1878: trx.cc_error_text,
1879: trx.request_id
1880: FROM ra_customer_trx trx,
1881: ra_cust_trx_types trx_type
1882: WHERE trx.cust_trx_type_id = trx_type.cust_trx_type_id
1883: AND trx.request_id IN ( select request_id
1884: from fnd_concurrent_requests

Line 2025: arp_util.debug('Updating ra_customer_trx records');

2021:
2022: arp_util.debug ('Sql rows updated ' || sql%rowcount);
2023:
2024: ELSE
2025: arp_util.debug('Updating ra_customer_trx records');
2026: arp_util.debug('customer_trx_id '|| p_cc_trx_id);
2027:
2028: UPDATE ra_customer_trx
2029: SET cc_error_flag =NULL,

Line 2028: UPDATE ra_customer_trx

2024: ELSE
2025: arp_util.debug('Updating ra_customer_trx records');
2026: arp_util.debug('customer_trx_id '|| p_cc_trx_id);
2027:
2028: UPDATE ra_customer_trx
2029: SET cc_error_flag =NULL,
2030: cc_error_code = NULL,
2031: cc_error_text = NULL
2032: WHERE customer_trx_id = p_cc_trx_id;

Line 2243: FROM ra_customer_trx trx,

2239: SELECT trx.customer_trx_id,
2240: trx.trx_number,
2241: trx_types.type,
2242: cr.receipt_number
2243: FROM ra_customer_trx trx,
2244: ar_receivable_applications ra,
2245: ar_cash_receipts cr,
2246: ra_cust_trx_types trx_types
2247: WHERE trx.customer_trx_id = ra.applied_customer_trx_id

Line 2260: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

2256: l_rec_number ar_cash_receipts.receipt_number%TYPE;
2257: l_error_notes VARCHAR2(240);
2258: l_dummy_number NUMBER;
2259: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2260: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
2261: l_trx_number ra_customer_trx.trx_number%TYPE;
2262: l_object_version_number ar_cash_receipts.rec_version_number%TYPE;
2263: l_cc_error_code ar_cash_receipts.cc_error_code%TYPE;
2264: l_cc_error_desc ar_cash_receipts.cc_error_text%TYPE;

Line 2261: l_trx_number ra_customer_trx.trx_number%TYPE;

2257: l_error_notes VARCHAR2(240);
2258: l_dummy_number NUMBER;
2259: l_receivable_application_id ar_receivable_applications.receivable_application_id%TYPE;
2260: l_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
2261: l_trx_number ra_customer_trx.trx_number%TYPE;
2262: l_object_version_number ar_cash_receipts.rec_version_number%TYPE;
2263: l_cc_error_code ar_cash_receipts.cc_error_code%TYPE;
2264: l_cc_error_desc ar_cash_receipts.cc_error_text%TYPE;
2265: l_cc_trx_category_dsp VARCHAR2(240);

Line 2275: l_approval_code ra_customer_trx.approval_code%TYPE;

2271: l_customer_number hz_cust_accounts.account_number%TYPE;
2272: l_customer_location hz_cust_site_uses.location%TYPE;
2273: l_cc_number IBY_FNDCPT_PAYER_ASSGN_INSTR_V.CARD_NUMBER%TYPE;
2274: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;
2275: l_approval_code ra_customer_trx.approval_code%TYPE;
2276: l_collector ar_collectors.name%TYPE;
2277: l_payment_method_name ar_receipt_methods.name%TYPE;
2278: PAY_exception EXCEPTION;
2279:

Line 2326: FROM ra_customer_trx

2322: IF ARP_GLOBAL.request_id IS NOT NULL then
2323: BEGIN
2324: SELECT 1
2325: INTO l_dummy_number
2326: FROM ra_customer_trx
2327: WHERE customer_trx_id = inv_cur.customer_trx_id
2328: FOR UPDATE OF customer_trx_id;
2329: EXCEPTION
2330: WHEN OTHERS THEN

Line 2335: p_table_name=>'RA_CUSTOMER_TRX',

2331: raise;
2332: END;
2333: ELSE
2334: lock_table_nowait(p_key=>inv_cur.customer_trx_id,
2335: p_table_name=>'RA_CUSTOMER_TRX',
2336: p_trx_number=>inv_cur.trx_number);
2337: END IF;
2338: -- Clear the credit card information and payment method from invoice
2339: clear_invoice_pay_info(p_customer_trx_id=>inv_cur.customer_trx_id,

Line 2513: FROM ra_customer_trx

2509: AND cc_error_code IS NOT NULL
2510: FOR UPDATE OF cash_receipt_id;
2511: CURSOR lock_trx IS
2512: SELECT 'lock'
2513: FROM ra_customer_trx
2514: WHERE request_id IN ( select request_id
2515: from fnd_concurrent_requests
2516: where request_id = p_request_id
2517: or parent_request_id = p_request_id )

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

2534: CLOSE lock_cr;
2535: correct_remittance_errors(p_request_id);
2536: ELSE
2537: IF PG_DEBUG in ('Y', 'C') THEN
2538: arp_util.debug('Locking ra_customer_trx records for processing..');
2539: END IF;
2540: OPEN lock_trx;
2541: CLOSE lock_trx;
2542: correct_creation_errors(p_request_id);

Line 2624: UPDATE ra_customer_trx

2620: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),
2621: rec_version_number = rec_version_number+1
2622: WHERE cash_receipt_id = p_cc_trx_id;
2623: ELSE
2624: UPDATE ra_customer_trx
2625: SET cc_error_flag =NULL,
2626: cc_error_code = NULL,
2627: cc_error_text = NULL
2628: WHERE customer_trx_id = p_cc_trx_id;

Line 2644: UPDATE ra_customer_trx

2640: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),
2641: rec_version_number = rec_version_number+1
2642: WHERE cash_receipt_id = p_cc_trx_id;
2643: ELSE
2644: UPDATE ra_customer_trx
2645: SET cc_error_flag =NULL,
2646: cc_error_code = NULL,
2647: cc_error_text = NULL
2648: WHERE customer_trx_id = p_cc_trx_id;

Line 2679: UPDATE ra_customer_trx_all

2675:
2676:
2677: ELSE
2678: /* i) update receipt_method and payment info of inv to null */
2679: UPDATE ra_customer_trx_all
2680: SET payment_trxn_extension_id = NULL,
2681: receipt_method_id = NULL,
2682: cc_error_flag = NULL,
2683: last_update_date = sysdate,