DBA Data[Home] [Help]

APPS.AR_INVOICE_TABLE_HANDLER dependencies on AR_INVOICE_TABLE_HANDLER

Line 1: PACKAGE BODY AR_INVOICE_TABLE_HANDLER AS

1: PACKAGE BODY AR_INVOICE_TABLE_HANDLER AS
2: /* $Header: ARXVINTB.pls 120.28.12010000.5 2009/02/13 13:18:38 pbapna ship $ */
3:
4: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'),'N');
5:

Line 51: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.generate_default_salescredit '||sqlerrm;

47: END;
48:
49: EXCEPTION
50: WHEN OTHERS THEN
51: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.generate_default_salescredit '||sqlerrm;
52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
53: return;
54:
55:

Line 72: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER(+)' );

68: l_copy_doc_number_flag varchar2(1):='N';
69: BEGIN
70: IF pg_debug = 'Y'
71: THEN
72: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER(+)' );
73: END IF;
74:
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76: /* 5921925 - removed trx_number sequence from here. Moved it to

Line 100: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER(-)' );

96:
97: IF pg_debug = 'Y'
98: THEN
99: ar_invoice_utils.debug ('Before calling AR_TRX_BULK_PROCESS_HEADER.insert_row (-)' );
100: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER(-)' );
101: END IF;
102: EXCEPTION
103: WHEN OTHERS THEN
104: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER '||sqlerrm;

Line 104: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER '||sqlerrm;

100: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER(-)' );
101: END IF;
102: EXCEPTION
103: WHEN OTHERS THEN
104: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_HEADER '||sqlerrm;
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: return;
107: END;
108:

Line 119: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES(+)' );

115:
116: BEGIN
117: IF pg_debug = 'Y'
118: THEN
119: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES(+)' );
120: END IF;
121:
122: x_return_status := FND_API.G_RET_STS_SUCCESS;
123:

Line 136: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES(-)' );

132: return;
133: END IF;
134: IF pg_debug = 'Y'
135: THEN
136: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES(-)' );
137: END IF;
138: EXCEPTION
139: WHEN OTHERS THEN
140: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES '||sqlerrm;

Line 140: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES '||sqlerrm;

136: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES(-)' );
137: END IF;
138: EXCEPTION
139: WHEN OTHERS THEN
140: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_LINES '||sqlerrm;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
142: return;
143: END;
144:

Line 155: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_DIST(+)' );

151:
152: BEGIN
153: IF pg_debug = 'Y'
154: THEN
155: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_DIST(+)' );
156: END IF;
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159: AR_TRX_BULK_PROCESS_DIST.INSERT_ROW (

Line 170: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_DIST(-)' );

166: return;
167: END IF;
168: IF pg_debug = 'Y'
169: THEN
170: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_TRX_DIST(-)' );
171: END IF;
172:
173: EXCEPTION
174: WHEN OTHERS THEN

Line 175: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_DIST '||sqlerrm;

171: END IF;
172:
173: EXCEPTION
174: WHEN OTHERS THEN
175: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_DIST '||sqlerrm;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: return;
178:
179: END INSERT_TRX_DIST;

Line 190: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_SALESCR(+)' );

186:
187: BEGIN
188: IF pg_debug = 'Y'
189: THEN
190: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_SALESCR(+)' );
191: END IF;
192:
193: x_return_status := FND_API.G_RET_STS_SUCCESS;
194:

Line 209: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_SALESCR(-)' );

205: return;
206: END IF;
207: IF pg_debug = 'Y'
208: THEN
209: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_SALESCR(-)' );
210: END IF;
211:
212: EXCEPTION
213: WHEN OTHERS THEN

Line 214: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_SALESCR '||sqlerrm;

210: END IF;
211:
212: EXCEPTION
213: WHEN OTHERS THEN
214: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.INSERT_TRX_SALESCR '||sqlerrm;
215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
216: return;
217: END INSERT_TRX_SALESCR;
218:

Line 232: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.create_batch(+)' );

228: l_cnt NUMBER;
229: BEGIN
230: IF pg_debug = 'Y'
231: THEN
232: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.create_batch(+)' );
233: END IF;
234:
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236:

Line 283: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.create_batch(-)' );

279:
280: IF pg_debug = 'Y'
281: THEN
282: ar_invoice_utils.debug ('Batch Id :'|| p_batch_id );
283: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.create_batch(-)' );
284: END IF;
285: EXCEPTION
286: WHEN OTHERS THEN
287: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.CREATE_BATCH '||sqlerrm;

Line 287: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.CREATE_BATCH '||sqlerrm;

283: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.create_batch(-)' );
284: END IF;
285: EXCEPTION
286: WHEN OTHERS THEN
287: x_errmsg := 'Error in AR_INVOICE_TABLE_HANDLER.CREATE_BATCH '||sqlerrm;
288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
289: return;
290:
291: END;

Line 310: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.GET_DEFAULT_TAX_CODE(+)' );

306: l_amt_incl_tax_override ar_vat_tax.amount_includes_tax_override%type;
307: BEGIN
308: IF pg_debug = 'Y'
309: THEN
310: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.GET_DEFAULT_TAX_CODE(+)' );
311: END IF;
312:
313: x_return_status := FND_API.G_RET_STS_SUCCESS;
314: IF pg_debug = 'Y'

Line 331: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.GET_DEFAULT_TAX_CODE(-)' );

327: /* 4188835 - defaulting code removed */
328:
329: IF pg_debug = 'Y'
330: THEN
331: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.GET_DEFAULT_TAX_CODE(-)' );
332: END IF;
333: EXCEPTION
334: WHEN OTHERS THEN
335: x_errmsg := 'Error during default Tax Code';

Line 530: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.insert_row(+)' );

526:
527: BEGIN
528: IF pg_debug = 'Y'
529: THEN
530: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.insert_row(+)' );
531: END IF;
532:
533: x_return_status := FND_API.G_RET_STS_SUCCESS;
534:

Line 962: arp_util.debug('EXCEPTION: ar_invoice_table_handler.insert_row()');

958: p_trx_system_parameters_rec.trx_header_level_rounding,
959: 'N' -- activity flag
960: ) = 0) -- FALSE
961: THEN
962: arp_util.debug('EXCEPTION: ar_invoice_table_handler.insert_row()');
963: arp_util.debug(l_error_message);
964: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
965:
966: APP_EXCEPTION.raise_exception;

Line 1078: END AR_INVOICE_TABLE_HANDLER;

1074: return;
1075:
1076: END INSERT_ROW;
1077:
1078: END AR_INVOICE_TABLE_HANDLER;