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.IEX_DISPUTE_PVT dependencies on FND_API

Line 13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

9: --Added parameters p_skip_workflow_flag and p_dispute_date
10: --for bug#6347547 by schekuri on 08-Nov-2007
11: -- Bug #6777367 bibeura 28-Jan-2008 Added parameter p_batch_source_name
12: PROCEDURE Create_Dispute(p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_disp_header_rec IN IEX_DISPUTE_PUB.DISP_HEADER_REC,
16: p_disp_line_tbl IN IEX_DISPUTE_PUB.DISPUTE_LINE_TBL,
17: x_request_id OUT NOCOPY NUMBER,

Line 14: p_commit IN VARCHAR2 := FND_API.G_FALSE,

10: --for bug#6347547 by schekuri on 08-Nov-2007
11: -- Bug #6777367 bibeura 28-Jan-2008 Added parameter p_batch_source_name
12: PROCEDURE Create_Dispute(p_api_version IN NUMBER,
13: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
14: p_commit IN VARCHAR2 := FND_API.G_FALSE,
15: p_disp_header_rec IN IEX_DISPUTE_PUB.DISP_HEADER_REC,
16: p_disp_line_tbl IN IEX_DISPUTE_PUB.DISPUTE_LINE_TBL,
17: x_request_id OUT NOCOPY NUMBER,
18: x_return_status OUT NOCOPY VARCHAR2,

Line 68: x_return_status := FND_API.G_RET_STS_SUCCESS;

64:
65: SAVEPOINT create_dispute_pvt;
66:
67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
72: p_api_version,

Line 71: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

67: -- Initialize API return status to SUCCESS
68: x_return_status := FND_API.G_RET_STS_SUCCESS;
69:
70: -- Standard call to check for call compatibility.
71: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
72: p_api_version,
73: l_api_name,
74: G_PKG_NAME)
75: THEN

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: p_api_version,
73: l_api_name,
74: G_PKG_NAME)
75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean(p_init_msg_list)

Line 80: IF FND_API.to_Boolean(p_init_msg_list)

76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean(p_init_msg_list)
81: THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:

Line 162: select decode(l_disp_header_rec.line_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.line_amt) into l_line

158: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: multiplier is ' || l_multiplier);
159: END IF;
160:
161: -- add this to avoid bug# 2166002
162: select decode(l_disp_header_rec.line_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.line_amt) into l_line
163: from dual;
164: select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax
165: from dual;
166: select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight

Line 164: select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax

160:
161: -- add this to avoid bug# 2166002
162: select decode(l_disp_header_rec.line_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.line_amt) into l_line
163: from dual;
164: select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax
165: from dual;
166: select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight
167: from dual;
168:

Line 166: select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight

162: select decode(l_disp_header_rec.line_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.line_amt) into l_line
163: from dual;
164: select decode(l_disp_header_rec.tax_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.tax_amt) into l_tax
165: from dual;
166: select decode(l_disp_header_rec.freight_amt, FND_API.G_MISS_NUM, 0, l_disp_header_rec.freight_amt) into l_freight
167: from dual;
168:
169: if lp_disp_line_tbl is not null then
170: lines_count := lp_disp_line_tbl.count;

Line 193: x_return_status := FND_API.G_RET_STS_ERROR;

189: EXCEPTION
190: WHEN NO_DATA_FOUND THEN
191: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_UNIT_PRICE');
192: FND_MSG_PUB.Add;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: RAISE FND_API.G_EXC_ERROR;
195: END ;
196: -- dbms_output.put_line('price for customer_trx_id is'||to_char(l_disp_line_tbl(i).price)) ;
197:

Line 194: RAISE FND_API.G_EXC_ERROR;

190: WHEN NO_DATA_FOUND THEN
191: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_UNIT_PRICE');
192: FND_MSG_PUB.Add;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: RAISE FND_API.G_EXC_ERROR;
195: END ;
196: -- dbms_output.put_line('price for customer_trx_id is'||to_char(l_disp_line_tbl(i).price)) ;
197:
198: END LOOP ;

Line 208: p_init_msg_list => FND_API.G_TRUE,

204: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Calling AR Create Request API');
205: END IF;
206: AR_CREDIT_MEMO_API_PUB.create_request(
207: p_api_version => l_api_version_number,
208: p_init_msg_list => FND_API.G_TRUE,
209: p_commit => FND_API.G_TRUE,
210: p_validation_level => FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
211: x_return_status => l_return_status,
212: x_msg_count => l_msg_count,

Line 209: p_commit => FND_API.G_TRUE,

205: END IF;
206: AR_CREDIT_MEMO_API_PUB.create_request(
207: p_api_version => l_api_version_number,
208: p_init_msg_list => FND_API.G_TRUE,
209: p_commit => FND_API.G_TRUE,
210: p_validation_level => FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
211: x_return_status => l_return_status,
212: x_msg_count => l_msg_count,
213: x_msg_data => l_msg_data,

Line 235: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

231: p_org_id => l_org_id, --Bug4696678. Fix by LKKUMAR on 26-Oct-2005. Pass Org_id.
232: p_dispute_date => p_dispute_date --Added for bug#6347547 by schekuri on 08-Nov-2007
233: );
234:
235: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
236: SELECT iex_disputes_s.nextval INTO l_dis_id FROM dual;
237:
238: -- IF PG_DEBUG < 10 THEN
239: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Insert Failed');
256: END IF;
257: FND_MESSAGE.SET_NAME('IEX', 'IEX_DISPUTE_FAILED');
258: FND_MSG_PUB.Add;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: RAISE FND_API.G_EXC_ERROR;
261:
262: END IF ;
263:

Line 260: RAISE FND_API.G_EXC_ERROR;

256: END IF;
257: FND_MESSAGE.SET_NAME('IEX', 'IEX_DISPUTE_FAILED');
258: FND_MSG_PUB.Add;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: RAISE FND_API.G_EXC_ERROR;
261:
262: END IF ;
263:
264: else -- no credit memo associated with transaction

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Credit Memo Configuration failure');
268: END IF;
269: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_CREDIT_MEMO');
270: FND_MSG_PUB.Add;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: RAISE FND_API.G_EXC_ERROR;
273:
274: end if;
275:

Line 272: RAISE FND_API.G_EXC_ERROR;

268: END IF;
269: FND_MESSAGE.SET_NAME('IEX', 'IEX_NO_CREDIT_MEMO');
270: FND_MSG_PUB.Add;
271: x_return_status := FND_API.G_RET_STS_ERROR;
272: RAISE FND_API.G_EXC_ERROR;
273:
274: end if;
275:
276: IF FND_API.to_Boolean( p_commit )

Line 276: IF FND_API.to_Boolean( p_commit )

272: RAISE FND_API.G_EXC_ERROR;
273:
274: end if;
275:
276: IF FND_API.to_Boolean( p_commit )
277: THEN
278: COMMIT WORK;
279: END IF;
280:

Line 297: WHEN FND_API.G_EXC_ERROR THEN

293: -- Standard call to get message count and if count is 1, get message info.
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count,
295: p_data => x_msg_data);
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO create_dispute_pvt;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 299: x_return_status := FND_API.G_RET_STS_ERROR;

295: p_data => x_msg_data);
296: EXCEPTION
297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO create_dispute_pvt;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO create_dispute_pvt;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

297: WHEN FND_API.G_EXC_ERROR THEN
298: ROLLBACK TO create_dispute_pvt;
299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO create_dispute_pvt;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
305: WHEN OTHERS THEN

Line 303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

299: x_return_status := FND_API.G_RET_STS_ERROR;
300: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
301: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
302: ROLLBACK TO create_dispute_pvt;
303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
305: WHEN OTHERS THEN
306: ROLLBACK TO create_dispute_pvt;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

303: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
304: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
305: WHEN OTHERS THEN
306: ROLLBACK TO create_dispute_pvt;
307: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
308: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
309: THEN
310: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
311: END IF;

Line 335: x_return_status := FND_API.G_RET_STS_SUCCESS;

331: -- Standard Start of API savepoint
332: SAVEPOINT is_delinquency_dispute_pvt;
333:
334: -- Initialize API return status to SUCCESS
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
339: p_api_version,

Line 338: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

334: -- Initialize API return status to SUCCESS
335: x_return_status := FND_API.G_RET_STS_SUCCESS;
336:
337: -- Standard call to check for call compatibility.
338: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
339: p_api_version,
340: l_api_name,
341: G_PKG_NAME)
342: THEN

Line 343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

339: p_api_version,
340: l_api_name,
341: G_PKG_NAME)
342: THEN
343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list )

Line 347: IF FND_API.to_Boolean( p_init_msg_list )

343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
344: END IF;
345:
346: -- Initialize message list if p_init_msg_list is set to TRUE.
347: IF FND_API.to_Boolean( p_init_msg_list )
348: THEN
349: FND_MSG_PUB.initialize;
350: END IF;
351:

Line 409: WHEN FND_API.G_EXC_ERROR THEN

405: p_data => x_msg_data
406: );
407:
408: EXCEPTION
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO is_delinquency_dispute_pvt;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 411: x_return_status := FND_API.G_RET_STS_ERROR;

407:
408: EXCEPTION
409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO is_delinquency_dispute_pvt;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO is_delinquency_dispute_pvt;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

409: WHEN FND_API.G_EXC_ERROR THEN
410: ROLLBACK TO is_delinquency_dispute_pvt;
411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO is_delinquency_dispute_pvt;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
417: WHEN OTHERS THEN

Line 415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

411: x_return_status := FND_API.G_RET_STS_ERROR;
412: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
413: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
414: ROLLBACK TO is_delinquency_dispute_pvt;
415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
417: WHEN OTHERS THEN
418: ROLLBACK TO is_delinquency_dispute_pvt;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

415: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
416: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
417: WHEN OTHERS THEN
418: ROLLBACK TO is_delinquency_dispute_pvt;
419: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
420: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
421: THEN
422: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
423: END IF;

Line 518: l_return_status := FND_API.G_RET_STS_SUCCESS;

514:
515: SAVEPOINT CANCEL_DISPUTE;
516:
517: -- Initialize API return status to success
518: l_return_status := FND_API.G_RET_STS_SUCCESS;
519:
520: OPEN c_item_type(p_dispute_id);
521: FETCH c_item_type
522: INTO l_item_type;

Line 557: x_return_status := FND_API.G_RET_STS_ERROR;

553:
554: EXCEPTION
555: WHEN others THEN
556: ROLLBACK TO CANCEL_DISPUTE;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
559: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
560: errmsg := SQLERRM;
561: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);

Line 563: RAISE FND_API.G_EXC_ERROR;

559: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
560: errmsg := SQLERRM;
561: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);
562: END IF;
563: RAISE FND_API.G_EXC_ERROR;
564:
565: END;
566: ---------------------------------------------------------
567: l_debug_mesg := 'Remove Transaction from Dispute';

Line 638: x_return_status := FND_API.G_RET_STS_ERROR;

634:
635: EXCEPTION
636: WHEN others THEN
637: ROLLBACK TO CANCEL_DISPUTE;
638: x_return_status := FND_API.G_RET_STS_ERROR;
639: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
640: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
641: errmsg := SQLERRM;
642: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);

Line 644: RAISE FND_API.G_EXC_ERROR;

640: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
641: errmsg := SQLERRM;
642: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);
643: END IF;
644: RAISE FND_API.G_EXC_ERROR;
645:
646: END;
647:
648: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 672: x_return_status := FND_API.G_RET_STS_ERROR;

668:
669: EXCEPTION
670: WHEN others THEN
671: ROLLBACK TO CANCEL_DISPUTE;
672: x_return_status := FND_API.G_RET_STS_ERROR;
673: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
674: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
675: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: abort process ' || l_item_type || 'itemkey ' || p_dispute_id || 'has failed');
676: errmsg := SQLERRM;

Line 679: RAISE FND_API.G_EXC_ERROR;

675: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: abort process ' || l_item_type || 'itemkey ' || p_dispute_id || 'has failed');
676: errmsg := SQLERRM;
677: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);
678: END IF;
679: RAISE FND_API.G_EXC_ERROR;
680:
681: END;
682:
683: ---------------------------------------------------------------------

Line 769: x_return_status := FND_API.G_RET_STS_ERROR;

765:
766: EXCEPTION
767: WHEN others THEN
768: ROLLBACK TO CANCEL_DISPUTE;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
771: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
772: errmsg := SQLERRM;
773: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);

Line 775: RAISE FND_API.G_EXC_ERROR;

771: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
772: errmsg := SQLERRM;
773: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);
774: END IF;
775: RAISE FND_API.G_EXC_ERROR;
776: END;
777: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
778: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: After calling arp_notes_pkg.insert_cover');
779: END IF;

Line 860: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN

856: iex_debug_pub.LogMessage('CANCEL_DISPUTE: Status = ' || L_RETURN_STATUS);
857: END IF;
858:
859: -- check for errors
860: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
861: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
862: iex_debug_pub.LogMessage('CANCEL_DISPUTE: IEX_NOTES_PVT.Create_Note failed');
863: END IF;
864: RAISE FND_API.G_EXC_ERROR;

Line 864: RAISE FND_API.G_EXC_ERROR;

860: IF l_return_status<>FND_API.G_RET_STS_SUCCESS THEN
861: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
862: iex_debug_pub.LogMessage('CANCEL_DISPUTE: IEX_NOTES_PVT.Create_Note failed');
863: END IF;
864: RAISE FND_API.G_EXC_ERROR;
865: END IF;
866: else
867: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
868: iex_debug_pub.LogMessage('CANCEL_DISPUTE: no note to save');

Line 875: IF FND_API.to_Boolean( p_commit )

871:
872: END IF; --IF l_item_type IS NOT NULL THEN
873:
874: -- Standard check for p_commit
875: IF FND_API.to_Boolean( p_commit )
876: THEN
877: COMMIT WORK;
878: END IF;
879:

Line 883: p_encoded => FND_API.G_FALSE,

879:
880: x_return_status := l_return_status;
881: -- Standard call to get message count and if count is 1, get message info
882: FND_MSG_PUB.Count_And_Get(
883: p_encoded => FND_API.G_FALSE,
884: p_count => x_msg_count,
885: p_data => x_msg_data);
886:
887: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 892: WHEN FND_API.G_EXC_ERROR THEN

888: IEX_DEBUG_PUB.logMessage('**** END IEX_DISPUTE_PVT.CANCEL_DISPUTE ************');
889: END IF;
890:
891: EXCEPTION
892: WHEN FND_API.G_EXC_ERROR THEN
893: ROLLBACK TO CANCEL_DISPUTE;
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
896: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');

Line 894: x_return_status := FND_API.G_RET_STS_ERROR;

890:
891: EXCEPTION
892: WHEN FND_API.G_EXC_ERROR THEN
893: ROLLBACK TO CANCEL_DISPUTE;
894: x_return_status := FND_API.G_RET_STS_ERROR;
895: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
896: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
897: errmsg := SQLERRM;
898: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);

Line 903: x_return_status := FND_API.G_RET_STS_ERROR;

899: END IF;
900: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
901: WHEN others THEN
902: ROLLBACK TO CANCEL_DISPUTE;
903: x_return_status := FND_API.G_RET_STS_ERROR;
904: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
905: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - exception');
906: errmsg := SQLERRM;
907: IEX_DEBUG_PUB.logMessage('CANCEL_DISPUTE: - errmsg='||errmsg);