DBA Data[Home] [Help]

APPS.AR_INVOICE_API_PUB dependencies on AR_INVOICE_API_PUB

Line 1: PACKAGE BODY AR_INVOICE_API_PUB AS

1: PACKAGE BODY AR_INVOICE_API_PUB AS
2: /* $Header: ARXPINVB.pls 120.26.12010000.2 2008/11/12 10:12:46 ankuagar ship $ */
3:
4: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
5:

Line 21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );

17: BEGIN
18:
19: x_return_status := FND_API.G_RET_STS_SUCCESS;
20: IF pg_debug = 'Y' THEN
21: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(+)' );
22: ar_invoice_utils.debug ('All Default Values ' );
23: ar_invoice_utils.debug ('Set of Books Id '||
24: p_trx_system_param_rec.set_of_books_id);
25: ar_invoice_utils.debug ('Trx Currency '||

Line 49: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(-)' );

45: /* 5921925 - Removed defaulting UPDATE statement and integrated it
46: into ar_trx_global_process_header.insert_row */
47:
48: IF pg_debug = 'Y' THEN
49: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_header(-)' );
50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN

Line 54: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate_header '||sqlerrm;

50: END IF;
51:
52: EXCEPTION
53: WHEN OTHERS THEN
54: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate_header '||sqlerrm;
55: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
56: RETURN;
57:
58: END;

Line 83: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(+)' );

79:
80: BEGIN
81:
82: IF pg_debug = 'Y' THEN
83: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(+)' );
84: END IF;
85:
86: x_return_status := FND_API.G_RET_STS_SUCCESS;
87:

Line 137: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(-)' );

133: request_id = AR_INVOICE_TABLE_HANDLER.g_request_id;
134:
135: IF pg_debug = 'Y'
136: THEN
137: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_lines(-)' );
138: END IF;
139:
140: EXCEPTION
141: WHEN OTHERS THEN

Line 142: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate_lines '||sqlerrm;

138: END IF;
139:
140: EXCEPTION
141: WHEN OTHERS THEN
142: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate_lines '||sqlerrm;
143: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
144: return;
145: END;
146:

Line 165: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(+)' );

161:
162: BEGIN
163:
164: IF pg_debug = 'Y' THEN
165: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(+)' );
166: END IF;
167:
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
169:

Line 207: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(-)' );

203: AND dist.account_class = 'REC');
204:
205:
206: IF pg_debug = 'Y' THEN
207: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_distributions(-)' );
208: END IF;
209:
210: EXCEPTION
211: WHEN OTHERS THEN

Line 212: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate distributions'

208: END IF;
209:
210: EXCEPTION
211: WHEN OTHERS THEN
212: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate distributions'
213: || sqlerrm;
214: x_return_status := fnd_api.g_ret_sts_unexp_error;
215: RETURN;
216:

Line 229: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(+)' );

225:
226: BEGIN
227: IF pg_debug = 'Y'
228: THEN
229: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(+)' );
230: END IF;
231: x_return_status := FND_API.G_RET_STS_SUCCESS;
232: --populate global dist. table
233: AR_TRX_GLOBAL_PROCESS_SALESCR.INSERT_ROW(

Line 259: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(-)' );

255:
256:
257: IF pg_debug = 'Y'
258: THEN
259: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(-)' );
260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN
263: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate sales credits '||sqlerrm;

Line 263: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate sales credits '||sqlerrm;

259: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_salescredits(-)' );
260: END IF;
261: EXCEPTION
262: WHEN OTHERS THEN
263: x_errmsg := 'Error in AR_INVOICE_API_PUB.populate sales credits '||sqlerrm;
264: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
265: return;
266:
267: END populate_salescredits;

Line 281: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_contingencies(+)' );

277:
278: BEGIN
279:
280: IF pg_debug = 'Y' THEN
281: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.populate_contingencies(+)' );
282: END IF;
283:
284: x_return_status := FND_API.G_RET_STS_SUCCESS;
285: -- populate global contingencies table

Line 309: ar_invoice_utils.debug ('ar_invoice_api_pub.populate_contingencies(-)' );

305: WHERE tlg.trx_line_id = tcg.trx_line_id
306: AND rownum = 1);
307:
308: IF pg_debug = 'Y' THEN
309: ar_invoice_utils.debug ('ar_invoice_api_pub.populate_contingencies(-)' );
310: END IF;
311:
312: EXCEPTION
313: WHEN OTHERS THEN

Line 314: x_errmsg := 'error ar_invoice_api_pub.populate_contingencies: '||sqlerrm;

310: END IF;
311:
312: EXCEPTION
313: WHEN OTHERS THEN
314: x_errmsg := 'error ar_invoice_api_pub.populate_contingencies: '||sqlerrm;
315: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
316: RETURN;
317:
318: END populate_contingencies;

Line 382: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_INVOICE(2)(+)' );

378: BEGIN
379:
380: IF pg_debug = 'Y'
381: THEN
382: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_INVOICE(2)(+)' );
383: END IF;
384:
385: SAVEPOINT Create_Invoice;
386: /*--------------------------------------------------+

Line 833: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );

829:
830: IF pg_debug = 'Y'
831: THEN
832: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');
833: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );
834: END IF;
835:
836:
837: END CREATE_INVOICE;

Line 862: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(2)(+)' );

858:
859: BEGIN
860: IF pg_debug = 'Y'
861: THEN
862: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(2)(+)' );
863: END IF;
864:
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:

Line 898: x_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;

894:
895: IF x_return_status = FND_API.G_RET_STS_SUCCESS
896: THEN
897: -- get the value of cust_trx_id
898: x_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
899: END IF;
900:
901: IF pg_debug = 'Y'
902: THEN

Line 903: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );

899: END IF;
900:
901: IF pg_debug = 'Y'
902: THEN
903: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
904: END IF;
905:
906: END CREATE_SINGLE_INVOICE;
907:

Line 931: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );

927:
928: BEGIN
929:
930: IF pg_debug = 'Y' THEN
931: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );
932: END IF;
933:
934: -- call the api with a null trx_contingencies_tbl
935:

Line 951: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );

947: x_msg_count => x_msg_count,
948: x_msg_data => x_msg_data);
949:
950: IF pg_debug = 'Y' THEN
951: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
952: END IF;
953:
954: END create_invoice;
955:

Line 976: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );

972:
973: BEGIN
974:
975: IF pg_debug = 'Y' THEN
976: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );
977: END IF;
978:
979: -- call the api with a null trx_contingencies_tbl
980:

Line 997: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );

993: x_msg_count => x_msg_count,
994: x_msg_data => x_msg_data);
995:
996: IF pg_debug = 'Y' THEN
997: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
998: END IF;
999:
1000: END create_single_invoice;
1001:

Line 1494: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');

1490: x_return_status VARCHAR2(240);
1491: l_payment_trxn_extn_id ra_customer_trx.PAYMENT_TRXN_EXTENSION_ID%TYPE;
1492: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1493: Begin
1494: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1495:
1496: p_return_status := FND_API.G_RET_STS_SUCCESS;
1497:
1498:

Line 1539: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');

1535: p_return_status := FND_API.G_RET_STS_ERROR;
1536: END IF;
1537: EXCEPTION
1538: WHEN OTHERS THEN
1539: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');
1540: p_return_status := FND_API.G_RET_STS_ERROR;
1541: END Delete_Trxn_Extn_Details;
1542:
1543:

Line 1676: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(+)' );

1672: /*---------------------------------------------+
1673: | ========== Start of API Body ========== |
1674: +---------------------------------------------*/
1675:
1676: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(+)' );
1677:
1678:
1679: Validate_Delete_Transaction(
1680: p_customer_trx_id,

Line 1894: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(-)' );

1890: THEN ar_invoice_utils.debug('committing');
1891: Commit;
1892: END IF;
1893:
1894: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(-)' );
1895:
1896:
1897: EXCEPTION
1898: WHEN NO_DATA_FOUND THEN

Line 1982: END AR_INVOICE_API_PUB;

1978: -- Bug 7194381 End
1979:
1980: BEGIN
1981: g_one_time_init_org := -98;
1982: END AR_INVOICE_API_PUB;