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

Line 71: IF FND_API.to_Boolean(p_init_msg_list) THEN

67: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin UPDATE_LINE_ADJUSTMENT_NUMBER for loan_line_id: '|| p_loan_line_id);
68: END IF;
69:
70: -- Initialize message list IF p_init_msg_list is set to TRUE.
71: IF FND_API.to_Boolean(p_init_msg_list) THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Initialize API return status to SUCCESS

Line 76: x_return_status := FND_API.G_RET_STS_SUCCESS;

72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Initialize API return status to SUCCESS
76: x_return_status := FND_API.G_RET_STS_SUCCESS;
77:
78:
79: --Call to record history
80: LNS_LOAN_HISTORY_PUB.log_record_pre(

Line 118: WHEN FND_API.G_EXC_ERROR THEN

114: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End UPDATE_LINE_ADJUSTMENT_NUMBER for loan_line_id: '|| p_loan_line_id);
115: END IF;
116:
117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
121: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
122: END IF;

Line 119: x_return_status := FND_API.G_RET_STS_ERROR;

115: END IF;
116:
117: EXCEPTION
118: WHEN FND_API.G_EXC_ERROR THEN
119: x_return_status := FND_API.G_RET_STS_ERROR;
120: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
121: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
122: END IF;
123:

Line 124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

120: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
121: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
122: END IF;
123:
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
128: END IF;

Line 125: x_return_status := FND_API.G_RET_STS_ERROR;

121: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
122: END IF;
123:
124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
125: x_return_status := FND_API.G_RET_STS_ERROR;
126: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
127: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
128: END IF;
129:

Line 131: x_return_status := FND_API.G_RET_STS_ERROR;

127: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
128: END IF;
129:
130: WHEN OTHERS THEN
131: x_return_status := FND_API.G_RET_STS_ERROR;
132: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
133: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
134: END IF;
135:

Line 362: RAISE FND_API.G_EXC_ERROR;

358: --throw exception
359: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_LOAN_ID');
360: FND_MSG_PUB.Add;
361: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
362: RAISE FND_API.G_EXC_ERROR;
363: end if;
364:
365: --Initialize the local variables
366: l_loan_amount := 0;

Line 391: RAISE FND_API.G_EXC_ERROR;

387: --throw exception
388: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_LINES_EXIST');
389: FND_MSG_PUB.Add;
390: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
391: RAISE FND_API.G_EXC_ERROR;
392:
393: end if;
394:
395: if (p_primary_borrower_id is null OR p_currency_code is null OR p_org_id is null OR p_loan_product_id is null) then

Line 410: RAISE FND_API.G_EXC_ERROR;

406: --throw exception
407: FND_MESSAGE.SET_NAME('LNS', 'LNS_SOME_REQ_FIELDS_EMPTY');
408: FND_MSG_PUB.Add;
409: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
410: RAISE FND_API.G_EXC_ERROR;
411:
412: end if;
413:
414:

Line 430: RAISE FND_API.G_EXC_ERROR;

426: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_loan_product_id');
427: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_product_id);
428: FND_MSG_PUB.Add;
429: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
430: RAISE FND_API.G_EXC_ERROR;
431:
432: end if;
433:
434: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || ' - passed IN parameters:');

Line 578: RAISE FND_API.G_EXC_ERROR;

574: --throw exception
575: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_FOUND');
576: FND_MSG_PUB.Add;
577: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
578: RAISE FND_API.G_EXC_ERROR;
579: END IF;
580:
581: l_last_api_called := 'Bulk insert into lns_loan_lines';
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || ' - BEGIN: ' || l_last_api_called);

Line 657: WHEN FND_API.G_EXC_ERROR THEN

653:
654: return l_loan_amount;
655:
656: EXCEPTION
657: WHEN FND_API.G_EXC_ERROR THEN
658: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - before rollback');
659: ROLLBACK TO loan_lines_derivation;
660: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after rollback');
661: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);