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.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.34 2011/07/08 00:43:49 dgaurab 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 827: temp_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;

823: p_return_flag boolean;
824: p_return_code number;
825: p_return_message varchar2(1024);
826: BEGIN
827: temp_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
828:
829: jg_zz_ar_trx_pkg.do_trx_complete(null,temp_customer_trx_id,'INVOICEAPI',p_return_flag, p_return_code,p_return_message);
830:
831: IF (p_return_flag = FALSE) THEN

Line 855: temp_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;

851: temp_customer_trx_id ra_customer_trx_all.customer_trx_id%type;
852: t_code number;
853: t_errmsg varchar2(1024);
854: BEGIN
855: temp_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
856: JG_ZZ_AR_AUTO_INVOICE.Trx_Num_Upd_Single_API(temp_customer_trx_id);
857: UPDATE ar_payment_schedules ps
858: SET trx_number = (SELECT ct.trx_number
859: FROM ra_customer_trx ct

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

895:
896: IF pg_debug = 'Y'
897: THEN
898: ar_invoice_utils.debug ('Calling Table Handler ar_invoice_table_handler.insert_row (-) ');
899: ar_invoice_utils.debug ('ar_invoice_api_pub.create_invoice(-)' );
900: END IF;
901:
902:
903: END CREATE_INVOICE;

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

924:
925: BEGIN
926: IF pg_debug = 'Y'
927: THEN
928: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(2)(+)' );
929: END IF;
930:
931: x_return_status := FND_API.G_RET_STS_SUCCESS;
932:

Line 945: AR_INVOICE_API_PUB.g_customer_trx_id := NULL; -- manishri, Bug 9915107.

941: x_msg_data := arp_standard.fnd_message('AR_INAPI_MULTIPLE_HEADERS');
942: return;
943: END IF;
944:
945: AR_INVOICE_API_PUB.g_customer_trx_id := NULL; -- manishri, Bug 9915107.
946:
947: CREATE_INVOICE (
948: p_api_version => p_api_version,
949: p_init_msg_list => p_init_msg_list,

Line 965: x_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;

961: -- added code nvl(x_msg_count,0)=-99 for bug10349867
962: IF x_return_status = FND_API.G_RET_STS_SUCCESS
963: THEN
964: -- get the value of cust_trx_id
965: x_customer_trx_id := AR_INVOICE_API_PUB.g_customer_trx_id;
966: END IF;
967:
968: IF pg_debug = 'Y'
969: THEN

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

966: END IF;
967:
968: IF pg_debug = 'Y'
969: THEN
970: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
971: END IF;
972:
973: END CREATE_SINGLE_INVOICE;
974:

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

994:
995: BEGIN
996:
997: IF pg_debug = 'Y' THEN
998: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );
999: END IF;
1000:
1001: -- call the api with a null trx_contingencies_tbl
1002:

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

1014: x_msg_count => x_msg_count,
1015: x_msg_data => x_msg_data);
1016:
1017: IF pg_debug = 'Y' THEN
1018: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
1019: END IF;
1020:
1021: END create_invoice;
1022:

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

1039:
1040: BEGIN
1041:
1042: IF pg_debug = 'Y' THEN
1043: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(+)' );
1044: END IF;
1045:
1046: -- call the api with a null trx_contingencies_tbl
1047:

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

1060: x_msg_count => x_msg_count,
1061: x_msg_data => x_msg_data);
1062:
1063: IF pg_debug = 'Y' THEN
1064: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.CREATE_SINGLE_INVOICE(-)' );
1065: END IF;
1066:
1067: END create_single_invoice;
1068:

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

1557: x_return_status VARCHAR2(240);
1558: l_payment_trxn_extn_id ra_customer_trx.PAYMENT_TRXN_EXTENSION_ID%TYPE;
1559: l_fnd_api_constants_rec ar_bills_main.fnd_api_constants_type := ar_bills_main.get_fnd_api_constants_rec;
1560: Begin
1561: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Trxn_Extn_Details()+ ');
1562:
1563: p_return_status := FND_API.G_RET_STS_SUCCESS;
1564:
1565:

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

1602: p_return_status := FND_API.G_RET_STS_ERROR;
1603: END IF;
1604: EXCEPTION
1605: WHEN OTHERS THEN
1606: ar_invoice_utils.debug('exception in AR_INVOICE_API_PUB.Delete_Trxn_Extn_Detail ');
1607: p_return_status := FND_API.G_RET_STS_ERROR;
1608: END Delete_Trxn_Extn_Details;
1609:
1610:

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

1739: /*---------------------------------------------+
1740: | ========== Start of API Body ========== |
1741: +---------------------------------------------*/
1742:
1743: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(+)' );
1744:
1745:
1746: Validate_Delete_Transaction(
1747: p_customer_trx_id,

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

1957: THEN ar_invoice_utils.debug('committing');
1958: Commit;
1959: END IF;
1960:
1961: ar_invoice_utils.debug('AR_INVOICE_API_PUB.Delete_Transaction(-)' );
1962:
1963:
1964: EXCEPTION
1965: WHEN NO_DATA_FOUND THEN

Line 2062: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (+)' );

2058: l_count NUMBER;
2059:
2060: BEGIN
2061: IF pg_debug = 'Y' THEN
2062: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (+)' );
2063: ar_invoice_utils.debug ('Customer_trx_id: ' || p_customer_trx_id);
2064: ar_invoice_utils.debug ('interface_line_attribute6: ' || p_interface_line_attribute6);
2065: END IF;
2066:

Line 2096: x_msg_data := 'Error in AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE: '||sqlerrm;

2092: AND ct.customer_trx_id = p_customer_trx_id;
2093: EXCEPTION
2094: WHEN OTHERS THEN
2095: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2096: x_msg_data := 'Error in AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE: '||sqlerrm;
2097: return;
2098: END;
2099:
2100: ELSE

Line 2130: x_msg_data := 'Error in AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE: '||sqlerrm;

2126: and ctl.INTERFACE_LINE_ATTRIBUTE6 = p_interface_line_attribute6;
2127: EXCEPTION
2128: WHEN OTHERS THEN
2129: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2130: x_msg_data := 'Error in AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE: '||sqlerrm;
2131: return;
2132: END;
2133: END IF;
2134:

Line 2136: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (-)' );

2132: END;
2133: END IF;
2134:
2135: IF pg_debug = 'Y' THEN
2136: ar_invoice_utils.debug ('AR_INVOICE_API_PUB.GET_TRXN_LINE_BALANCE (-)' );
2137: END IF;
2138: END;
2139:
2140:

Line 2143: END AR_INVOICE_API_PUB;

2139:
2140:
2141: BEGIN
2142: g_one_time_init_org := -98;
2143: END AR_INVOICE_API_PUB;