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 AR_CASH_RECEIPTS

Line 38: PROCEDURE reverse_receipt(p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

34: FUNCTION default_reversal_gl_date(p_cash_receipt_id IN NUMBER) RETURN DATE;
35:
36: FUNCTION default_reversal_date(p_cash_receipt_id IN NUMBER) RETURN DATE;
37:
38: PROCEDURE reverse_receipt(p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
39: x_reversal_comments IN VARCHAR2 DEFAULT NULL);
40:
41: /*Bug 8341117, Removed the parameter 'expiration_date' as part of the changes
42: for PA - DSS Project.*/

Line 745: FROM ar_cash_receipts

741: WHERE cash_receipt_id = p_cash_receipt_id;
742:
743: SELECT set_of_books_id
744: INTO l_sob_id
745: FROM ar_cash_receipts
746: WHERE cash_receipt_id = p_cash_receipt_id;
747:
748: IF (arp_util.validate_and_default_gl_date(
749: l_gl_date,

Line 817: FROM ar_cash_receipts

813: arp_standard.debug( 'ARP_CORRECT_CC_ERRORS.default_reversal_date()+' );
814: END IF;
815: SELECT receipt_date
816: INTO l_receipt_date
817: FROM ar_cash_receipts
818: WHERE cash_receipt_id = p_cash_receipt_id;
819:
820: IF trunc(l_receipt_date) < trunc(sysdate) THEN
821: RETURN trunc(sysdate);

Line 854: PROCEDURE reverse_receipt(p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,

850: |
851: | MODIFICATION HISTORY - Created by Srinivasa Kini - 25-Aug-2004
852: |
853: +===========================================================================*/
854: PROCEDURE reverse_receipt(p_cash_receipt_id IN ar_cash_receipts.cash_receipt_id%TYPE,
855: x_reversal_comments IN VARCHAR2 DEFAULT NULL) IS
856: l_reversal_gl_date DATE;
857: l_reversal_date DATE;
858: l_called_from VARCHAR2(30) DEFAULT NULL;

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

Line 1592: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN

1588: BEGIN
1589: IF PG_DEBUG in ('Y', 'C') THEN
1590: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()+');
1591: END IF;
1592: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1593: arp_cash_receipts_pkg.nowaitlock_version_p(p_key,p_object_version_number);
1594: ELSE
1595: -- Here we need to consider calling some procedure
1596: -- which does locking

Line 1604: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN

1600: arp_util.debug('ARP_CORRECT_CC_ERRORS.lock_table_nowait()-');
1601: END IF;
1602: EXCEPTION
1603: WHEN NO_DATA_FOUND THEN
1604: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1605: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_CHANGED');
1606: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1607: FND_MSG_PUB.Add;
1608: ELSE

Line 1618: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN

1614: arp_util.debug('EXCEPTION: ARP_CORRECT_CC_ERRORS.lock_table_nowait()');
1615: END IF;
1616: app_exception.raise_exception;
1617: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN
1618: IF p_table_name in ('AR_CASH_RECEIPTS','CASH','MISC') THEN
1619: FND_MESSAGE.SET_NAME('AR','AR_RECEIPT_RECORD_LOCKED');
1620: FND_MESSAGE.SET_TOKEN('PARAMETER',p_trx_number);
1621: FND_MSG_PUB.Add;
1622: ELSE

Line 1672: FROM ar_cash_receipts

1668: SELECT 'Y'
1669: INTO l_return_status
1670: FROM dual
1671: WHERE EXISTS (SELECT 1
1672: FROM ar_cash_receipts
1673: WHERE request_id IN ( select request_id
1674: from fnd_concurrent_requests
1675: where request_id = p_request_id
1676: or parent_request_id = p_request_id )

Line 1754: FROM ar_cash_receipts

1750: payment_trxn_extension_id,
1751: cc_error_code,
1752: cc_error_text,
1753: request_id
1754: FROM ar_cash_receipts
1755: WHERE request_id IN ( select request_id
1756: from fnd_concurrent_requests
1757: where request_id = p_request_id
1758: or parent_request_id = p_request_id )

Line 2011: arp_util.debug('Updating ar_cash_receipts record');

2007: ELSE
2008: l_error_notes := p_error_notes;
2009: END IF;
2010: IF p_cc_trx_category IN ('CASH','MISC') THEN
2011: arp_util.debug('Updating ar_cash_receipts record');
2012: arp_util.debug('cash_receipt_id '|| p_cc_trx_id);
2013:
2014: UPDATE ar_cash_receipts
2015: SET cc_error_flag = NULL,

Line 2014: UPDATE ar_cash_receipts

2010: IF p_cc_trx_category IN ('CASH','MISC') THEN
2011: arp_util.debug('Updating ar_cash_receipts record');
2012: arp_util.debug('cash_receipt_id '|| p_cc_trx_id);
2013:
2014: UPDATE ar_cash_receipts
2015: SET cc_error_flag = NULL,
2016: cc_error_code = NULL,
2017: cc_error_text = NULL,
2018: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),

Line 2099: l_receipt_number ar_cash_receipts.receipt_number%TYPE;

2095: l_org_id NUMBER;
2096: l_org_type VARCHAR2(30);
2097: l_payment_function VARCHAR2(30);
2098: l_payment_channel VARCHAR2(30);
2099: l_receipt_number ar_cash_receipts.receipt_number%TYPE;
2100:
2101: BEGIN
2102: IF PG_DEBUG in ('Y', 'C') THEN
2103: arp_util.debug('ARP_CORRECT_CC_ERRORS.reauthorize()+');

Line 2113: UPDATE ar_cash_receipts

2109: END IF;
2110: -- Ideally this check is not necessary
2111: -- as there won't be reauthorization failure for invoice
2112: IF p_cc_trx_category = 'CASH' THEN
2113: UPDATE ar_cash_receipts
2114: SET approval_code = NULL,
2115: cc_error_flag = NULL,
2116: cc_error_code = NULL,
2117: cc_error_text = NULL,

Line 2147: AR_CASH_RECEIPTS CR

2143: FROM
2144: IBY_FNDCPT_TX_EXTENSIONS B,
2145: IBY_EXTERNAL_PAYERS_ALL P,
2146: IBY_PMT_INSTR_USES_ALL U,
2147: AR_CASH_RECEIPTS CR
2148: WHERE B.TRXN_EXTENSION_ID = p_payment_trxn_extension_id
2149: AND B.INSTR_ASSIGNMENT_ID = U.INSTRUMENT_PAYMENT_USE_ID
2150: AND U.EXT_PMT_PARTY_ID = P.EXT_PAYER_ID
2151: AND CR.CASH_RECEIPT_ID = p_cc_trx_id

Line 2185: update ar_cash_receipts set

2181: x_response => l_response_rec);
2182:
2183: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2184:
2185: update ar_cash_receipts set
2186: payment_trxn_extension_id = l_payment_trxn_extension_id
2187: where cash_receipt_id = p_cc_trx_id;
2188:
2189: ELSE

Line 2245: ar_cash_receipts cr,

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
2248: AND ra.cash_receipt_id = cr.cash_receipt_id
2249: AND cr.payment_trxn_extension_id = trx.payment_trxn_extension_id

Line 2255: l_cash_receipt_id ar_cash_receipts.cash_receipt_id%TYPE;

2251: AND ra.display = 'Y'
2252: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
2253: AND cr.cash_receipt_id = p_cc_trx_id;
2254:
2255: l_cash_receipt_id ar_cash_receipts.cash_receipt_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;

Line 2256: l_rec_number ar_cash_receipts.receipt_number%TYPE;

2252: AND trx_types.cust_trx_type_id = trx.cust_trx_type_id
2253: AND cr.cash_receipt_id = p_cc_trx_id;
2254:
2255: l_cash_receipt_id ar_cash_receipts.cash_receipt_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;

Line 2262: l_object_version_number ar_cash_receipts.rec_version_number%TYPE;

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);
2266: l_cc_trx_number ar_cash_receipts.receipt_number%TYPE;

Line 2263: l_cc_error_code ar_cash_receipts.cc_error_code%TYPE;

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);
2266: l_cc_trx_number ar_cash_receipts.receipt_number%TYPE;
2267: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;

Line 2264: l_cc_error_desc ar_cash_receipts.cc_error_text%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);
2266: l_cc_trx_number ar_cash_receipts.receipt_number%TYPE;
2267: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;
2268: l_cc_trx_amount NUMBER;

Line 2266: l_cc_trx_number ar_cash_receipts.receipt_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);
2266: l_cc_trx_number ar_cash_receipts.receipt_number%TYPE;
2267: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;
2268: l_cc_trx_amount NUMBER;
2269: l_cc_trx_date DATE;
2270: l_customer_name hz_parties.party_name%TYPE;

Line 2267: l_cc_trx_currency ar_cash_receipts.currency_code%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);
2266: l_cc_trx_number ar_cash_receipts.receipt_number%TYPE;
2267: l_cc_trx_currency ar_cash_receipts.currency_code%TYPE;
2268: l_cc_trx_amount NUMBER;
2269: l_cc_trx_date DATE;
2270: l_customer_name hz_parties.party_name%TYPE;
2271: l_customer_number hz_cust_accounts.account_number%TYPE;

Line 2274: l_payment_trxn_extension_id ar_cash_receipts.payment_trxn_extension_id%TYPE;

2270: l_customer_name hz_parties.party_name%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;

Line 2376: FROM ar_cash_receipts cr,

2372: l_payment_trxn_extension_id,
2373: l_approval_code,
2374: l_collector,
2375: l_payment_method_name
2376: FROM ar_cash_receipts cr,
2377: ar_receipt_methods rm,
2378: hz_parties party,
2379: hz_cust_accounts cust,
2380: hz_cust_site_uses site_uses,

Line 2393: UPDATE ar_cash_receipts

2389: AND cr.cash_receipt_id = p_cc_trx_id;
2390: -- reverse the receipt
2391: reverse_receipt(p_cc_trx_id,l_error_notes);
2392: -- Attach comment to the invoice
2393: UPDATE ar_cash_receipts
2394: SET comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000))
2395: WHERE cash_receipt_id = p_cc_trx_id;
2396:
2397: IF p_cc_trx_category = 'CASH' THEN

Line 2421: FROM ar_cash_receipts cr

2417: SELECT cr.cash_receipt_id,
2418: cr.receipt_number
2419: INTO l_cash_receipt_id,
2420: l_rec_number
2421: FROM ar_cash_receipts cr
2422: WHERE cash_receipt_id in (SELECT ra.cash_receipt_id
2423: FROM ar_receivable_applications ra
2424: WHERE ra.application_ref_id = p_cc_trx_id
2425: AND ra.applied_payment_schedule_id = -6);

Line 2503: FROM ar_cash_receipts

2499: p_request_id IN NUMBER,
2500: p_mode IN VARCHAR2) IS
2501: CURSOR lock_cr IS
2502: SELECT 'lock'
2503: FROM ar_cash_receipts
2504: WHERE request_id IN ( select request_id
2505: from fnd_concurrent_requests
2506: where request_id = p_request_id
2507: or parent_request_id = p_request_id )

Line 2531: arp_util.debug('Locking ar_cash_receipts records for processing..');

2527: arp_util.debug('Called from : '||p_mode);
2528: END IF;
2529: IF (p_mode = 'REMITTANCE') THEN
2530: IF PG_DEBUG in ('Y', 'C') THEN
2531: arp_util.debug('Locking ar_cash_receipts records for processing..');
2532: END IF;
2533: OPEN lock_cr;
2534: CLOSE lock_cr;
2535: correct_remittance_errors(p_request_id);

Line 2616: UPDATE ar_cash_receipts

2612:
2613: IF p_corrective_action = 'Retry' THEN
2614:
2615: IF p_cc_trx_category IN ('CASH','MISC') THEN
2616: UPDATE ar_cash_receipts
2617: SET cc_error_flag = NULL,
2618: cc_error_code = NULL,
2619: cc_error_text = NULL,
2620: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),

Line 2636: UPDATE ar_cash_receipts

2632: END IF; /* end Retry */
2633:
2634: IF p_corrective_action = 'Change Instrument' THEN
2635: IF p_cc_trx_category IN ('CASH','MISC') THEN
2636: UPDATE ar_cash_receipts
2637: SET cc_error_flag = NULL,
2638: cc_error_code = NULL,
2639: cc_error_text = NULL,
2640: comments = DECODE(p_error_notes,NULL,comments,substrb('<'||l_error_notes||'>'||comments,1,2000)),

Line 2667: UPDATE ar_cash_receipts_all

2663:
2664: IF p_corrective_action = 'Clear Payment Information' THEN
2665: IF p_cc_trx_category IN ('CASH','MISC') THEN
2666: /* i) update receipt_method and payment info of RECEIPT to null */
2667: UPDATE ar_cash_receipts_all
2668: SET payment_trxn_extension_id = NULL,
2669: receipt_method_id = NULL,
2670: cc_error_flag = NULL,
2671: last_update_date = sysdate,