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.

[Home] [Help]

APPS.AR_PREPAYMENTS dependencies on AR_PREPAYMENTS

Line 1: PACKAGE BODY AR_PREPAYMENTS AS

1: PACKAGE BODY AR_PREPAYMENTS AS
2: /* $Header: ARPREPYB.pls 120.27 2010/12/17 11:55:15 manishri ship $ */
3:
4: /*=======================================================================+
5: | Package Global Constants

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_PREPAYMENTS';

3:
4: /*=======================================================================+
5: | Package Global Constants
6: +=======================================================================*/
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_PREPAYMENTS';
8: G_MSG_UERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR;
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10: G_MSG_SUCCESS CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_SUCCESS;
11: G_MSG_HIGH CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH;

Line 59: arp_standard.debug('ar_prepayments.check_rec_in_doubt()+ ');

55: x_rid_reason OUT NOCOPY VARCHAR2) IS
56: BEGIN
57: ---
58: IF PG_DEBUG in ('Y', 'C') THEN
59: arp_standard.debug('ar_prepayments.check_rec_in_doubt()+ ');
60: END IF;
61: ---
62: x_rec_in_doubt := 'N';
63: x_rid_reason := null;

Line 86: ' occurred in ar_prepayments.check_rec_in_doubt');

82: WHEN NO_DATA_FOUND THEN
83: NULL;
84: WHEN OTHERS THEN
85: arp_standard.debug('Unexpected error '||sqlerrm||
86: ' occurred in ar_prepayments.check_rec_in_doubt');
87: RAISE;
88: END;
89:
90: ---

Line 117: ' occurred in ar_prepayments.check_rec_in_doubt');

113: WHEN NO_DATA_FOUND THEN
114: NULL;
115: WHEN OTHERS THEN
116: arp_standard.debug('Unexpected error '||sqlerrm||
117: ' occurred in ar_prepayments.check_rec_in_doubt');
118: RAISE;
119: END;
120:
121: ---

Line 147: ' occurred in ar_prepayments.check_rec_in_doubt');

143: WHEN NO_DATA_FOUND THEN
144: NULL;
145: WHEN OTHERS THEN
146: arp_standard.debug('Unexpected error '||sqlerrm||
147: ' occurred in ar_prepayments.check_rec_in_doubt');
148: RAISE;
149: END;
150:
151: ---

Line 160: arp_standard.debug('ar_prepayments.check_rec_in_doubt()- ');

156: ---
157: <>
158: ---
159: IF PG_DEBUG in ('Y', 'C') THEN
160: arp_standard.debug('ar_prepayments.check_rec_in_doubt()- ');
161: END IF;
162: ---
163: EXCEPTION
164: WHEN OTHERS THEN

Line 242: 'ar_prepayments.process prepayment (+)');

238:
239: BEGIN
240: IF PG_DEBUG in ('Y', 'C') THEN
241: arp_util.debug(
242: 'ar_prepayments.process prepayment (+)');
243: END IF;
244:
245: x_return_status := FND_API.G_RET_STS_SUCCESS;
246: l_cash_receipt_id := p_cash_receipt_id;

Line 661: arp_util.debug( 'ar_prepayments.process prepayment (-)');

657: RETURN;
658: END IF;
659:
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_util.debug( 'ar_prepayments.process prepayment (-)');
662: END IF;
663:
664: EXCEPTION
665:

Line 673: arp_util.debug('EXCEPTION :ar_prepayments.process_prepayments :'||SQLERRM);

669: p_count => x_msg_count,
670: p_data => x_msg_data);
671:
672: IF PG_DEBUG in ('Y', 'C') THEN
673: arp_util.debug('EXCEPTION :ar_prepayments.process_prepayments :'||SQLERRM);
674: END IF;
675:
676: END Process_Prepayments;
677:

Line 810: arp_standard.debug('ar_prepayments.Create_Prepayment ()+');

806:
807: BEGIN
808:
809: IF PG_DEBUG in ('Y', 'C') THEN
810: arp_standard.debug('ar_prepayments.Create_Prepayment ()+');
811: END IF;
812:
813: /*--------------------------------------------------------------+
814: | Initialize message list if p_init_msg_list is set to TRUE |

Line 837: arp_standard.debug('ar_prepayments.Create_Prepayment ()+'|| p_org_id);

833: --get the value of receipt_number into local variable
834: l_receipt_number := p_receipt_number;
835:
836: IF PG_DEBUG in ('Y', 'C') THEN
837: arp_standard.debug('ar_prepayments.Create_Prepayment ()+'|| p_org_id);
838: arp_util.debug('Create_Prepayment: payment_trxn_extension_id' || to_char(p_payment_trxn_extension_id) );
839: END IF;
840:
841:

Line 842: ----Call the AR_PREPAYMENTS_PUB.Create_Prepayment API----

838: arp_util.debug('Create_Prepayment: payment_trxn_extension_id' || to_char(p_payment_trxn_extension_id) );
839: END IF;
840:
841:
842: ----Call the AR_PREPAYMENTS_PUB.Create_Prepayment API----
843: AR_PREPAYMENTS_PUB.Create_Prepayment(
844: -- Standard API parameters.
845: p_api_version ,
846: p_init_msg_list ,

Line 843: AR_PREPAYMENTS_PUB.Create_Prepayment(

839: END IF;
840:
841:
842: ----Call the AR_PREPAYMENTS_PUB.Create_Prepayment API----
843: AR_PREPAYMENTS_PUB.Create_Prepayment(
844: -- Standard API parameters.
845: p_api_version ,
846: p_init_msg_list ,
847: p_commit ,

Line 936: arp_util.debug('AR_PREPAYMENTS.Create_Prepayment ()-');

932: p_count => x_msg_count,
933: p_data => x_msg_data);
934:
935: IF PG_DEBUG in ('Y', 'C') THEN
936: arp_util.debug('AR_PREPAYMENTS.Create_Prepayment ()-');
937: END IF;
938:
939:
940: END IF; /* SSA changes */

Line 1501: arp_util.debug('ar_prepayments.refund_prepayments(-)');

1497: p_count => x_msg_count,
1498: p_data => x_msg_data);
1499:
1500: IF PG_DEBUG in ('Y', 'C') THEN
1501: arp_util.debug('ar_prepayments.refund_prepayments(-)');
1502: END IF;
1503:
1504:
1505: EXCEPTION

Line 1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);

1533:
1534: -- Display_Parameters;
1535: x_return_status := FND_API.G_RET_STS_ERROR ;
1536: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1537: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_PREPAYMENTS_PUB.refund : '||SQLERRM);
1538: FND_MSG_PUB.Add;
1539: FND_MSG_PUB.Count_And_Get( p_encoded => FND_API.G_FALSE,
1540: p_count => x_msg_count,
1541: p_data => x_msg_data);

Line 1616: arp_util.debug('ar_prepayments.match_prepayment (+)');

1612: BEGIN
1613: SAVEPOINT match_prepayment_PVT;
1614:
1615: IF PG_DEBUG in ('Y', 'C') THEN
1616: arp_util.debug('ar_prepayments.match_prepayment (+)');
1617: END IF;
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619: l_payment_schedule_id := p_payment_schedule_id;
1620:

Line 1633: arp_util.debug('ar_prepayments.match_prepayment No prepayment exists');

1629:
1630: EXCEPTION
1631: WHEN no_data_found THEN
1632: IF PG_DEBUG in ('Y', 'C') THEN
1633: arp_util.debug('ar_prepayments.match_prepayment No prepayment exists');
1634: END IF;
1635: x_return_status := FND_API.G_RET_STS_SUCCESS;
1636: RETURN;
1637: WHEN others THEN

Line 1639: arp_util.debug('EXCEPTION :ar_prepayments.match_prepayment Check ');

1635: x_return_status := FND_API.G_RET_STS_SUCCESS;
1636: RETURN;
1637: WHEN others THEN
1638: IF PG_DEBUG in ('Y', 'C') THEN
1639: arp_util.debug('EXCEPTION :ar_prepayments.match_prepayment Check ');
1640: END IF;
1641: x_return_status := FND_API.G_RET_STS_ERROR;
1642: RETURN;
1643: END;

Line 1857: arp_util.debug('ar_prepayments.match_prepayment (-)');

1853: x_return_status := FND_API.G_RET_STS_SUCCESS;
1854: END IF;
1855:
1856: IF PG_DEBUG in ('Y', 'C') THEN
1857: arp_util.debug('ar_prepayments.match_prepayment (-)');
1858: END IF;
1859:
1860: EXCEPTION
1861: WHEN others THEN

Line 1863: arp_util.debug('EXCEPTION : ar_prepayments.match_prepayment ||SQLERRM');

1859:
1860: EXCEPTION
1861: WHEN others THEN
1862: IF PG_DEBUG in ('Y', 'C') THEN
1863: arp_util.debug('EXCEPTION : ar_prepayments.match_prepayment ||SQLERRM');
1864: END IF;
1865: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1866: END match_prepayment;
1867:

Line 1896: | ar_prepayments_pub.installment_tbl

1892: | Date Author Description of Changes
1893: | 10-JUL-2003 Jyoti Pandey o Created
1894: | 12-DEC-2003 Jyoti Pandey o Forward Port Bug 3316165 for Base bug
1895: | 3248093. Changing p_installment_tbl
1896: | ar_prepayments_pub.installment_tbl
1897: |
1898: *=======================================================================*/
1899: PROCEDURE get_installment(
1900: p_term_id IN NUMBER,

Line 1904: p_installment_tbl OUT NOCOPY ar_prepayments_pub.installment_tbl,

1900: p_term_id IN NUMBER,
1901: p_amount IN NUMBER,
1902: p_currency_code IN VARCHAR2,
1903: --bug 3248093 --
1904: p_installment_tbl OUT NOCOPY ar_prepayments_pub.installment_tbl,
1905: x_return_status OUT NOCOPY VARCHAR2,
1906: x_msg_count OUT NOCOPY NUMBER,
1907: x_msg_data OUT NOCOPY VARCHAR2) IS
1908:

Line 2137: WF_CORE.CONTEXT('AR_PREPAYMENTS', 'RULE_SELECT_PREPAYMENTS', p_event.getEventName(), p_subscription_guid);

2133: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2134: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2135: FND_MSG_PUB.ADD;
2136:
2137: WF_CORE.CONTEXT('AR_PREPAYMENTS', 'RULE_SELECT_PREPAYMENTS', p_event.getEventName(), p_subscription_guid);
2138: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2139:
2140: RETURN 'ERROR';
2141:

Line 2302: arp_util.debug('Starting ar_prepayments.match_prepayment Routine(+) ');

2298: /*-------------------------------------------------------------------------+
2299: |Call the match prepay routine
2300: +-------------------------------------------------------------------------*/
2301: IF PG_DEBUG in ('Y', 'C') THEN
2302: arp_util.debug('Starting ar_prepayments.match_prepayment Routine(+) ');
2303: END IF;
2304:
2305: begin
2306: SAVEPOINT match_start;

Line 2309: ar_prepayments.match_prepayment (

2305: begin
2306: SAVEPOINT match_start;
2307:
2308: ---Recipt API apply or unapply
2309: ar_prepayments.match_prepayment (
2310: p_payment_schedule_id => l_payment_schedule_id,
2311: p_apply_date => null,
2312: p_apply_gl_date => null,
2313: p_cash_receipt_id => l_cash_receipt_id,

Line 2326: arp_util.debug('ar_prepayments.match_prepayment-after: P Cash Receipt Id >' || l_cash_receipt_id);

2322: COMMIT;
2323: END IF;
2324:
2325: IF PG_DEBUG in ('Y', 'C') then
2326: arp_util.debug('ar_prepayments.match_prepayment-after: P Cash Receipt Id >' || l_cash_receipt_id);
2327: arp_util.debug('AR-ARZPREPAY-after: PS Amt Due Remaining>'
2328: || l_ps_amt_due_remain);
2329: END IF;
2330:

Line 2334: fnd_file.put_line(fnd_file.log,'EXCEPTION :AR_PREPAYMENTS_PUB.MATCH_PREPAYMENT Routine'||SQLERRM);

2330:
2331: EXCEPTION
2332:
2333: WHEN others THEN
2334: fnd_file.put_line(fnd_file.log,'EXCEPTION :AR_PREPAYMENTS_PUB.MATCH_PREPAYMENT Routine'||SQLERRM);
2335: l_retcode := 10;
2336: ROLLBACK to match_start;
2337:
2338: end; ---end to call to match_prepayment

Line 2351: arp_util.debug('End ar_prepayments.match_prepayment Routine (-)');

2347: close get_prepay_invoices;
2348: /*bug 8372888*/
2349: COMMIT;
2350: IF PG_DEBUG in ('Y', 'C') THEN
2351: arp_util.debug('End ar_prepayments.match_prepayment Routine (-)');
2352: END IF;
2353:
2354: if (l_retcode <> 0) then
2355: FND_FILE.put_line(fnd_file.log,'There are few prepayments which could not match. Pl check log file for details');

Line 2378: END AR_PREPAYMENTS;

2374: retcode := l_retcode;
2375:
2376: END select_prepayments;
2377:
2378: END AR_PREPAYMENTS;