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_TABLE_HANDLER dependencies on FND_API

Line 20: x_return_status := FND_API.G_RET_STS_SUCCESS;

16: IF pg_debug = 'Y'
17: THEN
18: ar_invoice_utils.debug ('generate_default_salescredit (+)');
19: END IF;
20: x_return_status := FND_API.G_RET_STS_SUCCESS;
21: -- check whether user has passed any sales credit for this line
22: BEGIN
23: SELECT COUNT(*)
24: INTO l_cnt

Line 43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

39: l_status1 );
40: IF l_status1 <> 'OK'
41: THEN
42: x_errmsg := l_status1;
43: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
44: return;
45: END IF;
46: END IF;
47: END;

Line 52: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
56: END;

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
77: ar_invoice_utils.populate_doc_sequence */
78:
79: -- call table handler to insert into ra_customer_trx

Line 90: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

86: p_trx_header_id => ar_trx_header_rec.trx_header_id,
87: x_errmsg => x_errmsg,
88: x_return_status => x_return_status);
89:
90: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
91: THEN
92: return;
93: END IF;
94:

Line 105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
109: PROCEDURE INSERT_TRX_LINES (

Line 122: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
124: -- call table handler to insert into ra_customer_trx
125: AR_TRX_BULK_PROCESS_LINES.insert_row(
126: p_trx_header_id => ar_trx_lines_rec.trx_header_id,

Line 130: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

126: p_trx_header_id => ar_trx_lines_rec.trx_header_id,
127: p_trx_line_id => ar_trx_lines_rec.trx_line_id,
128: x_errmsg => x_errmsg,
129: x_return_status => x_return_status );
130: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
131: THEN
132: return;
133: END IF;
134: IF pg_debug = 'Y'

Line 141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
145:

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

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 (
160: p_trx_dist_id => p_trx_dist_id,
161: x_errmsg => x_errmsg,

Line 164: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

160: p_trx_dist_id => p_trx_dist_id,
161: x_errmsg => x_errmsg,
162: x_return_status => x_return_status );
163:
164: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
165: THEN
166: return;
167: END IF;
168: IF pg_debug = 'Y'

Line 176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
180:

Line 193: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
195: UPDATE ar_trx_salescredits_gt
196: SET request_id = -(p_batch_id);
197:

Line 203: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

199: p_trx_salescredit_id => p_trx_salescredit_id,
200: x_errmsg => x_errmsg,
201: x_return_status => x_return_status );
202:
203: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
204: THEN
205: return;
206: END IF;
207: IF pg_debug = 'Y'

Line 215: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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:
219:

Line 235: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
237: INSERT INTO RA_BATCHES
238: (
239: CREATED_BY,

Line 288: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
292:

Line 313: x_return_status := FND_API.G_RET_STS_SUCCESS;

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'
315: THEN
316: ar_invoice_utils.debug ('Ship to site use Id :' || ar_trx_header_rec.ship_to_site_use_id);
317: ar_invoice_utils.debug ('Bill to site use Id :' || ar_trx_header_rec.bill_to_site_use_id);

Line 336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

332: END IF;
333: EXCEPTION
334: WHEN OTHERS THEN
335: x_errmsg := 'Error during default Tax Code';
336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
337: return;
338: END GET_DEFAULT_TAX_CODE;
339:
340: PROCEDURE populate_error_stack (

Line 533: x_return_status := FND_API.G_RET_STS_SUCCESS;

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:
535: l_batch_id := g_batch_id;
536:
537: IF pg_debug = 'Y'

Line 571: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

567: p_batch_id => l_batch_id,
568: x_errmsg => x_errmsg,
569: x_return_status => x_return_status);
570:
571: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
572: THEN
573: return;
574: END IF;
575:

Line 625: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

621: p_batch_id => l_batch_id,
622: x_errmsg => x_errmsg,
623: x_return_status => x_return_status);
624:
625: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
626: THEN
627: return;
628: END IF;
629: IF pg_debug = 'Y'

Line 670: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

666: x_errmsg => x_errmsg,
667: x_return_status => x_return_status);
668: END IF;
669:
670: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
671: THEN
672: return;
673: END IF;
674: IF pg_debug = 'Y'

Line 734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

730: l_status);
731:
732: EXCEPTION
733: WHEN OTHERS THEN
734: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735: x_errmsg :=
736: 'arp_process_header.update_header_freight_cover '
737: || 'raised unexpected error!';
738: RETURN;

Line 779: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

775: INSERT_TRX_DIST( p_trx_dist_id => null,
776: p_batch_id => l_batch_id,
777: x_errmsg => x_errmsg,
778: x_return_status => x_return_status );
779: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
780: THEN
781: cleanup(p_customer_trx_id => l_cust_trx_id);
782: return;
783: END IF;

Line 793: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR

789: p_batch_id => l_batch_id,
790: x_errmsg => x_errmsg,
791: x_return_status => x_return_status );
792:
793: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR
794: THEN
795: cleanup(p_customer_trx_id => l_cust_trx_id);
796: return;
797: END IF;

Line 1053: x_return_status := fnd_api.g_ret_sts_unexp_error;

1049: WHEN OTHERS
1050: THEN
1051: cleanup(p_customer_trx_id => l_cust_trx_id);
1052: x_errmsg := sqlerrm;
1053: x_return_status := fnd_api.g_ret_sts_unexp_error;
1054: INSERT INTO ar_trx_errors_gt (
1055: trx_header_id,
1056: error_message)
1057: VALUES

Line 1073: x_return_status := fnd_api.g_ret_sts_unexp_error;

1069: EXCEPTION
1070: WHEN OTHERS THEN
1071: cleanup(p_customer_trx_id => l_cust_trx_id);
1072: x_errmsg := 'Fatal Error' || sqlerrm;
1073: x_return_status := fnd_api.g_ret_sts_unexp_error;
1074: return;
1075:
1076: END INSERT_ROW;
1077: