DBA Data[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.21 2006/02/23 11:52:37 bichatte noship $ */
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('process_prepayments: ' ||
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('process_prepayments: ' || 'ar_prepayments.process prepayment (-)');

657: RETURN;
658: END IF;
659:
660: IF PG_DEBUG in ('Y', 'C') THEN
661: arp_util.debug('process_prepayments: ' || '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 1615: arp_util.debug('ar_prepayments.match_prepayment (+)');

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

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

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

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

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

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

1830: x_return_status := FND_API.G_RET_STS_SUCCESS;
1831: END IF;
1832:
1833: IF PG_DEBUG in ('Y', 'C') THEN
1834: arp_util.debug('ar_prepayments.match_prepayment (-)');
1835: END IF;
1836:
1837: EXCEPTION
1838: WHEN others THEN

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

1836:
1837: EXCEPTION
1838: WHEN others THEN
1839: IF PG_DEBUG in ('Y', 'C') THEN
1840: arp_util.debug('EXCEPTION : ar_prepayments.match_prepayment ||SQLERRM');
1841: END IF;
1842: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1843: END match_prepayment;
1844:

Line 1873: | ar_prepayments_pub.installment_tbl

1869: | Date Author Description of Changes
1870: | 10-JUL-2003 Jyoti Pandey o Created
1871: | 12-DEC-2003 Jyoti Pandey o Forward Port Bug 3316165 for Base bug
1872: | 3248093. Changing p_installment_tbl
1873: | ar_prepayments_pub.installment_tbl
1874: |
1875: *=======================================================================*/
1876: PROCEDURE get_installment(
1877: p_term_id IN NUMBER,

Line 1881: p_installment_tbl OUT NOCOPY ar_prepayments_pub.installment_tbl,

1877: p_term_id IN NUMBER,
1878: p_amount IN NUMBER,
1879: p_currency_code IN VARCHAR2,
1880: --bug 3248093 --
1881: p_installment_tbl OUT NOCOPY ar_prepayments_pub.installment_tbl,
1882: x_return_status OUT NOCOPY VARCHAR2,
1883: x_msg_count OUT NOCOPY NUMBER,
1884: x_msg_data OUT NOCOPY VARCHAR2) IS
1885:

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

2081: FND_MESSAGE.SET_NAME( 'AR', 'GENERIC_MESSAGE' );
2082: FND_MESSAGE.SET_TOKEN( 'GENERIC_TEXT' ,SQLERRM );
2083: FND_MSG_PUB.ADD;
2084:
2085: WF_CORE.CONTEXT('AR_PREPAYMENTS', 'RULE_SELECT_PREPAYMENTS', p_event.getEventName(), p_subscription_guid);
2086: WF_EVENT.setErrorInfo(p_event, 'ERROR');
2087:
2088: RETURN 'ERROR';
2089:

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

2206: /*-------------------------------------------------------------------------+
2207: |Call the match prepay routine
2208: +-------------------------------------------------------------------------*/
2209: IF PG_DEBUG in ('Y', 'C') THEN
2210: arp_util.debug('Starting ar_prepayments.match_prepayment Routine(+) ');
2211: END IF;
2212:
2213: begin
2214: SAVEPOINT match_start;

Line 2217: ar_prepayments.match_prepayment (

2213: begin
2214: SAVEPOINT match_start;
2215:
2216: ---Recipt API apply or unapply
2217: ar_prepayments.match_prepayment (
2218: p_payment_schedule_id => l_payment_schedule_id,
2219: p_apply_date => null,
2220: p_apply_gl_date => null,
2221: p_cash_receipt_id => l_cash_receipt_id,

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

2226: l_retcode := 10;
2227: END IF;
2228:
2229: IF PG_DEBUG in ('Y', 'C') then
2230: arp_util.debug('ar_prepayments.match_prepayment-after: P Cash Receipt Id >' || l_cash_receipt_id);
2231: arp_util.debug('AR-ARZPREPAY-after: PS Amt Due Remaining>'
2232: || l_ps_amt_due_remain);
2233: END IF;
2234:

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

2236: EXCEPTION
2237:
2238: WHEN others THEN
2239:
2240: fnd_file.put_line(fnd_file.log,'EXCEPTION :AR_PREPAYMENTS_PUB.MATCH_PREPAYMENT Routine'||SQLERRM);
2241: l_retcode := 10;
2242: ROLLBACK to match_start;
2243:
2244: end; ---end to call to match_prepayment

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

2251:
2252: END LOOP;
2253: close get_prepay_invoices;
2254: IF PG_DEBUG in ('Y', 'C') THEN
2255: arp_util.debug('End ar_prepayments.match_prepayment Routine (-)');
2256: END IF;
2257:
2258: if (l_retcode <> 0) then
2259: RAISE FND_API.G_EXC_ERROR;

Line 2279: END AR_PREPAYMENTS;

2275: retcode := l_retcode;
2276:
2277: END select_prepayments;
2278:
2279: END AR_PREPAYMENTS;