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

Line 175: P_INIT_MSG_LIST => FND_API.G_FALSE,

171: MO_GLOBAL.set_policy_context('S', l_org_id);
172:
173: UPDATE_LOAN_STATUS_FROM_IEX(
174: P_API_VERSION => 1.0,
175: P_INIT_MSG_LIST => FND_API.G_FALSE,
176: P_COMMIT => FND_API.G_FALSE,
177: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
178: P_LOAN_ID => l_loan_id,
179: P_SCORING_ENGINE_ID => l_scoring_engine,

Line 176: P_COMMIT => FND_API.G_FALSE,

172:
173: UPDATE_LOAN_STATUS_FROM_IEX(
174: P_API_VERSION => 1.0,
175: P_INIT_MSG_LIST => FND_API.G_FALSE,
176: P_COMMIT => FND_API.G_FALSE,
177: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
178: P_LOAN_ID => l_loan_id,
179: P_SCORING_ENGINE_ID => l_scoring_engine,
180: X_NEW_STATUS => l_status,

Line 177: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

173: UPDATE_LOAN_STATUS_FROM_IEX(
174: P_API_VERSION => 1.0,
175: P_INIT_MSG_LIST => FND_API.G_FALSE,
176: P_COMMIT => FND_API.G_FALSE,
177: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
178: P_LOAN_ID => l_loan_id,
179: P_SCORING_ENGINE_ID => l_scoring_engine,
180: X_NEW_STATUS => l_status,
181: X_RETURN_STATUS => l_return_status,

Line 185: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

181: X_RETURN_STATUS => l_return_status,
182: X_MSG_COUNT => l_msg_count,
183: X_MSG_DATA => l_msg_data);
184:
185: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: END LOOP;

Line 186: RAISE FND_API.G_EXC_ERROR;

182: X_MSG_COUNT => l_msg_count,
183: X_MSG_DATA => l_msg_data);
184:
185: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
186: RAISE FND_API.G_EXC_ERROR;
187: END IF;
188:
189: END LOOP;
190:

Line 274: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

270: SAVEPOINT UPDATE_LOAN_STATUS_FROM_IEX;
271: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
272:
273: -- Standard call to check for call compatibility
274: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
272:
273: -- Standard call to check for call compatibility
274: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE
279: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 279: IF FND_API.To_Boolean(p_init_msg_list) THEN

275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277:
278: -- Initialize message list if p_init_msg_list is set to TRUE
279: IF FND_API.To_Boolean(p_init_msg_list) THEN
280: FND_MSG_PUB.initialize;
281: END IF;
282:
283: -- Initialize API return status to success

Line 284: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

280: FND_MSG_PUB.initialize;
281: END IF;
282:
283: -- Initialize API return status to success
284: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
285:
286: -- START OF BODY OF API
287: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input loan_id = ' || P_LOAN_ID);
288: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Input scoring_engine_id = ' || P_SCORING_ENGINE_ID);

Line 295: RAISE FND_API.G_EXC_ERROR;

291: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
292: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
293: FND_MESSAGE.SET_TOKEN('VALUE', P_LOAN_ID);
294: FND_MSG_PUB.ADD;
295: RAISE FND_API.G_EXC_ERROR;
296: end if;
297:
298: -- update status to paid off if the loan is already paid off
299: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(

Line 301: P_INIT_MSG_LIST => FND_API.G_TRUE,

297:
298: -- update status to paid off if the loan is already paid off
299: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(
300: P_API_VERSION => 1.0,
301: P_INIT_MSG_LIST => FND_API.G_TRUE,
302: P_COMMIT => FND_API.G_TRUE,
303: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
304: P_LOAN_ID => P_LOAN_ID,
305: P_PAYOFF_DATE => sysdate,

Line 302: P_COMMIT => FND_API.G_TRUE,

298: -- update status to paid off if the loan is already paid off
299: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(
300: P_API_VERSION => 1.0,
301: P_INIT_MSG_LIST => FND_API.G_TRUE,
302: P_COMMIT => FND_API.G_TRUE,
303: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
304: P_LOAN_ID => P_LOAN_ID,
305: P_PAYOFF_DATE => sysdate,
306: X_RETURN_STATUS => l_return_status,

Line 303: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

299: LNS_BILLING_BATCH_PUB.PROCESS_PAID_LOANS(
300: P_API_VERSION => 1.0,
301: P_INIT_MSG_LIST => FND_API.G_TRUE,
302: P_COMMIT => FND_API.G_TRUE,
303: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
304: P_LOAN_ID => P_LOAN_ID,
305: P_PAYOFF_DATE => sysdate,
306: X_RETURN_STATUS => l_return_status,
307: X_MSG_COUNT => l_msg_count,

Line 324: P_INIT_MSG_LIST => FND_API.G_TRUE,

320:
321: -- update status from funding
322: LNS_FUNDING_PUB.CHECK_FOR_VOIDED_INVOICES(
323: P_API_VERSION => 1.0,
324: P_INIT_MSG_LIST => FND_API.G_TRUE,
325: P_COMMIT => FND_API.G_TRUE,
326: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
327: P_LOAN_ID => P_LOAN_ID,
328: X_RETURN_STATUS => l_return_status,

Line 325: P_COMMIT => FND_API.G_TRUE,

321: -- update status from funding
322: LNS_FUNDING_PUB.CHECK_FOR_VOIDED_INVOICES(
323: P_API_VERSION => 1.0,
324: P_INIT_MSG_LIST => FND_API.G_TRUE,
325: P_COMMIT => FND_API.G_TRUE,
326: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
327: P_LOAN_ID => P_LOAN_ID,
328: X_RETURN_STATUS => l_return_status,
329: X_MSG_COUNT => l_msg_count,

Line 326: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

322: LNS_FUNDING_PUB.CHECK_FOR_VOIDED_INVOICES(
323: P_API_VERSION => 1.0,
324: P_INIT_MSG_LIST => FND_API.G_TRUE,
325: P_COMMIT => FND_API.G_TRUE,
326: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
327: P_LOAN_ID => P_LOAN_ID,
328: X_RETURN_STATUS => l_return_status,
329: X_MSG_COUNT => l_msg_count,
330: X_MSG_DATA => l_msg_data);

Line 345: P_INIT_MSG_LIST => FND_API.G_TRUE,

341: BEGIN
342:
343: IEX_SCOREAPI_PUB.GETSCORESTATUS(
344: P_API_VERSION => 1.0,
345: P_INIT_MSG_LIST => FND_API.G_TRUE,
346: P_SCORE_ID => l_scoring_engine,
347: P_OBJECT_ID => P_LOAN_ID,
348: X_STATUS => l_status,
349: X_SCORE => l_score,

Line 357: RAISE FND_API.G_EXC_ERROR;

353:
354: EXCEPTION
355: WHEN OTHERS THEN
356: LogMessage(FND_LOG.LEVEL_ERROR, 'Collections scoring engine API is not installed. Please install it first.');
357: RAISE FND_API.G_EXC_ERROR;
358: END;
359:
360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
361:

Line 362: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

358: END;
359:
360: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
361:
362: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
363:
364: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to collections scoring engine failed with following error:');
365: while (l_indexNo <= l_msg_Count ) loop
366: fnd_msg_pub.get(l_indexNo, 'F', l_msg, l_index);

Line 371: RAISE FND_API.G_EXC_ERROR;

367: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_msg);
368: l_indexNo := l_indexNo + 1;
369: End Loop;
370:
371: RAISE FND_API.G_EXC_ERROR;
372:
373: END IF;
374:
375: LogMessage(FND_LOG.LEVEL_STATEMENT, 'New score: ' || l_score);

Line 395: P_INIT_MSG_LIST => FND_API.G_TRUE,

391: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
392:
393: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
394: P_LOAN_HEADER_REC => l_loan_header_rec,
395: P_INIT_MSG_LIST => FND_API.G_TRUE,
396: X_RETURN_STATUS => l_return_status,
397: X_MSG_COUNT => l_msg_count,
398: X_MSG_DATA => l_msg_data);
399:

Line 408: RAISE FND_API.G_EXC_ERROR;

404: ELSE
405: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
406: FND_MSG_PUB.Add;
407: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
408: RAISE FND_API.G_EXC_ERROR;
409: END IF;
410:
411: end if;
412:

Line 415: if P_COMMIT = FND_API.G_TRUE then

411: end if;
412:
413: end if;
414:
415: if P_COMMIT = FND_API.G_TRUE then
416: COMMIT WORK;
417: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
418: end if;
419:

Line 421: x_return_status := FND_API.G_RET_STS_SUCCESS;

417: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
418: end if;
419:
420: -- END OF BODY OF API
421: x_return_status := FND_API.G_RET_STS_SUCCESS;
422: X_NEW_STATUS := l_status;
423:
424: -- Standard call to get message count and if count is 1, get message info
425: FND_MSG_PUB.Count_And_Get(

Line 426: p_encoded => FND_API.G_FALSE,

422: X_NEW_STATUS := l_status;
423:
424: -- Standard call to get message count and if count is 1, get message info
425: FND_MSG_PUB.Count_And_Get(
426: p_encoded => FND_API.G_FALSE,
427: p_count => x_msg_count,
428: p_data => x_msg_data);
429:
430: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 433: WHEN FND_API.G_EXC_ERROR THEN

429:
430: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
431:
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
437: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 435: x_return_status := FND_API.G_RET_STS_ERROR;

431:
432: EXCEPTION
433: WHEN FND_API.G_EXC_ERROR THEN
434: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
437: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;

Line 438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

434: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;
435: x_return_status := FND_API.G_RET_STS_ERROR;
436: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
437: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
442: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

436: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
437: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
438: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
439: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;
440: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
441: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
442: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
443: WHEN OTHERS THEN
444: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
442: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
443: WHEN OTHERS THEN
444: ROLLBACK TO UPDATE_LOAN_STATUS_FROM_IEX;
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
447: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
448: END IF;
449: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);