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.36.12020000.3 2013/01/25 15:46:00 rravikir 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 210: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.INSERT_SALESCR(-)' );

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

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

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

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

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

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

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

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

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

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

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

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

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

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

534:
535: BEGIN
536: IF pg_debug = 'Y'
537: THEN
538: ar_invoice_utils.debug ('AR_INVOICE_TABLE_HANDLER.insert_row(+)' );
539: END IF;
540:
541: x_return_status := FND_API.G_RET_STS_SUCCESS;
542:

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

1008: p_trx_system_parameters_rec.trx_header_level_rounding,
1009: 'N' -- activity flag
1010: ) = 0) -- FALSE
1011: THEN
1012: arp_util.debug('EXCEPTION: ar_invoice_table_handler.insert_row()');
1013: arp_util.debug(l_error_message);
1014: fnd_message.set_name('AR', 'AR_PLCRE_FHLR_CCID');
1015:
1016: APP_EXCEPTION.raise_exception;

Line 1129: END AR_INVOICE_TABLE_HANDLER;

1125: return;
1126:
1127: END INSERT_ROW;
1128:
1129: END AR_INVOICE_TABLE_HANDLER;