DBA Data[Home] [Help]

APPS.IEX_DISPUTE_PVT dependencies on IEX_DISPUTES

Line 97: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: getting creation_sign');

93:
94:
95: -- IF PG_DEBUG < 10 THEN
96: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
97: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: getting creation_sign');
98: END IF;
99: -- added by ehuh for URL parameters
100: Open Get_Currency_Code;
101: Fetch Get_Currency_Code into l_currency_code, l_org_id;

Line 154: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: creation_sign is ' || l_creationSign);

150: l_multiplier := 1;
151: end if;
152: -- IF PG_DEBUG < 10 THEN
153: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
154: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: creation_sign is ' || l_creationSign);
155: END IF;
156: -- IF PG_DEBUG < 10 THEN
157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
158: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: multiplier is ' || l_multiplier);

Line 158: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: multiplier is ' || l_multiplier);

154: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: creation_sign is ' || l_creationSign);
155: END IF;
156: -- IF PG_DEBUG < 10 THEN
157: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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

Line 204: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Calling AR Create Request API');

200: end if;
201:
202: -- IF PG_DEBUG < 10 THEN
203: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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,

Line 236: SELECT iex_disputes_s.nextval INTO l_dis_id FROM dual;

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
240: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Inserting a dispute row in IEX_DISPUTES');

Line 240: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Inserting a dispute row in IEX_DISPUTES');

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
240: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Inserting a dispute row in IEX_DISPUTES');
241: END IF;
242: IEX_DISPUTES_PKG.Insert_Row(x_rowid => x,
243: p_dispute_id => l_dis_id,
244: p_last_update_date => sysdate,

Line 242: IEX_DISPUTES_PKG.Insert_Row(x_rowid => x,

238: -- IF PG_DEBUG < 10 THEN
239: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
240: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Inserting a dispute row in IEX_DISPUTES');
241: END IF;
242: IEX_DISPUTES_PKG.Insert_Row(x_rowid => x,
243: p_dispute_id => l_dis_id,
244: p_last_update_date => sysdate,
245: p_last_updated_by => FND_GLOBAL.USER_ID,
246: p_creation_date => sysdate,

Line 255: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Insert Failed');

251: p_delinquency_id => p_disp_header_rec.delinquency_id);
252: ELSE
253: -- IF PG_DEBUG < 10 THEN
254: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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;

Line 267: IEX_DEBUG_PUB.logMessage('Create_Dispute: ' || 'IEX_DISPUTES_PVT: CreateDispute: Credit Memo Configuration failure');

263:
264: else -- no credit memo associated with transaction
265: -- IF PG_DEBUG < 10 THEN
266: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
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;

Line 363: from iex_disputes

359: -- API body
360: --
361:
362: select count(1) into l_count
363: from iex_disputes
364: where DELINQUENCY_ID = l_delinquency_id ;
365:
366: IF (l_count = 0 ) THEN
367: --dbms_output.put_line('No dispute exist for this delinquency') ;

Line 373: from iex_disputes

369: FND_MSG_PUB.Add;
370: x_return_status := 'F' ;
371: ELSE
372: select cm_request_id into l_request_id
373: from iex_disputes
374: where delinquency_id = l_delinquency_id ;
375:
376: select status into l_status
377: from ra_cm_requests