[Home] [Help]
161: | |
162: | SCOPE - PUBLIC |
163: | |
164: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
165: | arp_app_pkg.fetch_p - Fetch a record from |
166: | AR_RECEIVABLE_APPLICATIONS table |
167: | arp_app_pkg.lock_p - lock a record in |
168: | AR_RECEIVABLE_APPLICATIONS table |
169: | |
163: | |
164: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
165: | arp_app_pkg.fetch_p - Fetch a record from |
166: | AR_RECEIVABLE_APPLICATIONS table |
167: | arp_app_pkg.lock_p - lock a record in |
168: | AR_RECEIVABLE_APPLICATIONS table |
169: | |
170: | ARGUMENTS : IN: |
171: | p_ra_id - Id of application to be reversed |
232: -- ar_receivable_applications table.
233:
234: --Bug:4068781
235: BEGIN
236: arp_app_pkg.lock_p( p_ra_id );
237: EXCEPTION
238: WHEN OTHERS
239: THEN
240: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
241: FND_MSG_PUB.Add;
242: APP_EXCEPTION.raise_exception;
243: END;
244:
245: arp_app_pkg.fetch_p( p_ra_id, l_ra_rec );
246: --apandit Bug : 2641517
247: l_status := l_ra_rec.status;
248:
249: -- get the payment schedule id of the trx that receipt was
582: | |
583: | SCOPE - PUBLIC |
584: | |
585: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - NONE |
586: | arp_app_pkg.fetch_p - Fetch a record from
587: | AR_RECEIVABLE_APPLICATIONS table
588: | |
589: | ARGUMENTS : IN: |
590: | pn_ra_id Id of application to be reversed
637: -- for selection.
638:
639: --Bug:4068781
640: BEGIN
641: arp_app_pkg.lock_p( pn_ra_id );
642: EXCEPTION
643: WHEN OTHERS
644: THEN
645: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
646: FND_MSG_PUB.Add;
647: APP_EXCEPTION.raise_exception;
648: END;
649:
650: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
651:
652: -- need some information to check if we have a regular cm or
653: -- on acct credit memo also if we have invoice with rules.
654: -- to do some processing before the application is reversed.
972: -- for selection.
973:
974: --Bug:4068781
975: BEGIN
976: arp_app_pkg.lock_p( pn_ra_id );
977: EXCEPTION
978: WHEN OTHERS
979: THEN
980: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
980: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
981: FND_MSG_PUB.Add;
982: APP_EXCEPTION.raise_exception;
983: END;
984: arp_app_pkg.fetch_p( pn_ra_id, lr_ra_rec );
985:
986: -- Before we update the APP row, we need to calculate the change in amount
987: -- so we can update the UNAPP row for the cash receipt.
988: IF lr_ra_rec.amount_applied <> pn_amount_applied THEN
1058: lr_ra_rec.global_attribute18 := p_global_attribute18;
1059: lr_ra_rec.global_attribute19 := p_global_attribute19;
1060: lr_ra_rec.global_attribute20 := p_global_attribute20;
1061:
1062: arp_app_pkg.update_p(lr_ra_rec);
1063:
1064: l_app_ra_rec := lr_ra_rec;
1065: --------------------------------------------------------------------
1066: -- Now that we have updated the APP row we need to update the UNAPP
1076: and ra.status = 'UNAPP';
1077:
1078: --Bug:4068781
1079: BEGIN
1080: arp_app_pkg.lock_p( ln_unapp_ra_id );
1081: EXCEPTION
1082: WHEN OTHERS
1083: THEN
1084: FND_MESSAGE.SET_NAME( 'FND', 'FND_LOCK_RECORD_ERROR');
1086: APP_EXCEPTION.raise_exception;
1087: END;
1088:
1089: -- Fetch the UNAPP row.
1090: arp_app_pkg.fetch_p( ln_unapp_ra_id, lr_ra_rec );
1091:
1092: -- Set the amount with the new value.
1093: lr_ra_rec.amount_applied := lr_ra_rec.amount_applied - ln_amount_change;
1094:
1101: , precision => NULL
1102: , min_acc_unit => NULL );
1103:
1104: -- Update the UNAPP row.
1105: arp_app_pkg.update_p(lr_ra_rec);
1106:
1107: -- Call MRC to replace receivable apps rows
1108: -- ar_mrc_engine3.update_selected_transaction(
1109: -- pn_amount_applied,
1459: | SCOPE - PRIVATE |
1460: | |
1461: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
1462: | ARCIAPPS.pls |
1463: | arp_app_pkg.insert_p Table handler to insert into |
1464: | ar_receivable_applications table. |
1465: | |
1466: | ARGUMENTS : IN: |
1467: | p_ra_rec Receivables application record |
1640: ---------------------------------------------------
1641: -- Create the opposing receivable application row.
1642: --
1643: ---------------------------------------------------
1644: arp_app_pkg.insert_p( p_ra_rec, l_ra_id );
1645:
1646: -- Bug 7241111 Updating the ar_activity_details reversal record with RA IDs
1647:
1648: IF p_ra_rec.status = 'APP' or p_ra_rec.application_type = 'CASH' THEN
1865: p_ra_rec.posting_control_id := -3;
1866: p_ra_rec.gl_posted_date := NULL;
1867:
1868: -- Call the table handler to insert the APP or ACC row.
1869: arp_app_pkg.insert_p(
1870: p_ra_rec -- IN
1871: , l_ra_id -- OUT NOCOPY
1872: );
1873:
2176: arp_debug.debug(' l_ra_id = ' || l_ra_id);
2177: l_ra_id := NULL;
2178:
2179: -- Call the table handler to insert the UNAPP row.
2180: arp_app_pkg.insert_p(
2181: p_ra_rec -- IN
2182: , l_ra_id -- OUT NOCOPY
2183: );
2184: --Bug 6660834
2285: | |
2286: | SCOPE - PUBLIC |
2287: | |
2288: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED |
2289: | arp_app_pkg.update_p - table handler to update |
2290: | ar_receivable_applications table |
2291: | |
2292: | ARGUMENTS : IN: |
2293: | p_ra_rec - Receivables application record |
2316: ELSE
2317: p_ra_rec.reversal_gl_date := p_ra_rec.gl_date;
2318: END IF;
2319: --
2320: arp_app_pkg.update_p( p_ra_rec );
2321: --
2322: IF PG_DEBUG in ('Y', 'C') THEN
2323: arp_debug.debug( 'arp_process_application.reversal_update_old_ra_rec()-' );
2324: END IF;
2404: IF PG_DEBUG in ('Y', 'C') THEN
2405: arp_debug.debug( 'arp_process_application.check_reversable()+' );
2406: END IF;
2407: --
2408: arp_app_pkg.fetch_p(p_ra_id, l_ra_rec );
2409:
2410: IF (SIGN(l_ra_rec.applied_payment_schedule_id) <> -1) THEN
2411:
2412: BEGIN
3883: --
3884: --
3885: IF nvl(p_called_from,'NONE') <> 'AUTORECAPI' THEN -- autorecapi bichatte project
3886:
3887: arp_app_pkg.insert_p( l_rec_ra_rec,
3888: l_rec_ra_rec.receivable_application_id );
3889:
3890: END IF;
3891:
4206: x_application_ref_num := l_inv_ra_rec.application_ref_num;
4207:
4208: -- Call the applications table handler to create the APP row.
4209: --
4210: arp_app_pkg.insert_p( l_inv_ra_rec,
4211: l_ra_app_id );
4212:
4213: /* 5677984 - copy l_ra_app_id into l_inv_ra_rec to preserve it for
4214: later processing */
4213: /* 5677984 - copy l_ra_app_id into l_inv_ra_rec to preserve it for
4214: later processing */
4215: l_inv_ra_rec.receivable_application_id := l_ra_app_id;
4216:
4217: arp_debug.debug('Calling arp_app_pkg.insert_p and created l_inv_ra_rec.receivable_application_id :'||
4218: l_inv_ra_rec.receivable_application_id);
4219:
4220: --apandit
4221: --Bug : 2641517 raise Apply business event.
4953: --------------------------------------------------------------------------
4954: -- Create the APP row in receivable applications.
4955: --
4956: --------------------------------------------------------------------------
4957: arp_app_pkg.insert_p( l_inv_ra_rec,
4958: l_inv_ra_rec.receivable_application_id );
4959:
4960: IF l_inv_ra_rec.receivable_application_id IS NOT NULL THEN
4961: l_xla_ev_rec.xla_from_doc_id := l_inv_ra_rec.receivable_application_id;
5130: | |
5131: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
5132: | ARPCURR.functional_amount - Get the acctd amount of amount applied|
5133: | arp_ps_pkg.fetch_p - Fetch a PS row |
5134: | arp_app_pkg.insert_p - Insert a row into RA table |
5135: | |
5136: | ARGUMENTS : IN: |
5137: | p_ps_id - PS id of the receipt |
5138: | p_amount_applied - Input amount applied |
5395:
5396: --
5397: -- Insert UNAPP record
5398: --
5399: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
5400:
5401: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
5402: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
5403: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
5448: l_ra_rec.on_acct_po_num := p_on_acct_po_num;
5449:
5450: -- Insert ACC record
5451:
5452: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
5453:
5454: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
5455: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
5456: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
6302: l_ra_rec.comments := p_comments;
6303:
6304:
6305: /* Insert UNAPP record */
6306: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
6307:
6308: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
6309: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
6310: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
6378: l_ra_rec.amount_applied_from := p_amount_applied;
6379:
6380:
6381: /* Insert ACTIVITY record */
6382: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
6383:
6384: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
6385: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
6386: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
6954: | |
6955: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
6956: | ARPCURR.functional_amount - Get the acctd amount of amount applied|
6957: | arp_ps_pkg.fetch_p - Fetch a PS row |
6958: | arp_app_pkg.insert_p - Insert a row into RA table |
6959: | |
6960: | ARGUMENTS : IN: |
6961: | p_ps_id - PS id of the receipt |
6962: | p_amount_applied - Input amount applied |
7299: l_ra_rec.comments := p_comments;
7300: --
7301: -- Insert UNAPP record
7302: --
7303: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
7304:
7305: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
7306: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
7307: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
7444: x_application_ref_num := l_ra_rec.application_ref_num;
7445:
7446: -- Insert OTHER ACC record
7447:
7448: arp_app_pkg.insert_p( l_ra_rec, l_ra_rec.receivable_application_id );
7449:
7450: IF l_ra_rec.receivable_application_id IS NOT NULL THEN
7451: l_xla_ev_rec.xla_from_doc_id := l_ra_rec.receivable_application_id;
7452: l_xla_ev_rec.xla_to_doc_id := l_ra_rec.receivable_application_id;
8627: | EXETERNAL PROCEDURES/FUNCTIONS ACCESSED - |
8628: | |
8629: | ARPCURR.functional_amount - Get the acctd amount of amount applied|
8630: | arp_ps_pkg.fetch_p - Fetch a PS row |
8631: | arp_app_pkg.insert_p - Insert a row into RA table |
8632: | |
8633: | ARGUMENTS : IN: |
8634: | p_cm_ps_id - PS id of the receipt |
8635: | p_application_ps_id - PS id of the special application |
8973: --------------------------------------------------------------------------
8974: -- Create the APP row in receivable applications.
8975: --
8976: --------------------------------------------------------------------------
8977: arp_app_pkg.insert_p( l_inv_ra_rec,
8978: l_receivable_application_id );
8979:
8980: l_inv_ra_rec.receivable_application_id := l_receivable_application_id;
8981: