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 69: IF FND_API.to_Boolean(p_init_msg_list) THEN

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

Line 74: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 111: WHEN FND_API.G_EXC_ERROR THEN

107: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'End UPDATE_LINE_ADJUSTMENT_NUMBER for loan_line_id: '|| p_loan_line_id);
108: END IF;
109:
110: EXCEPTION
111: WHEN FND_API.G_EXC_ERROR THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
114: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
115: END IF;

Line 112: x_return_status := FND_API.G_RET_STS_ERROR;

108: END IF;
109:
110: EXCEPTION
111: WHEN FND_API.G_EXC_ERROR THEN
112: x_return_status := FND_API.G_RET_STS_ERROR;
113: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
114: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
115: END IF;
116:

Line 117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

113: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
114: FND_LOG.STRING(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);
115: END IF;
116:
117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
118: x_return_status := FND_API.G_RET_STS_ERROR;
119: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
120: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, sqlerrm);
121: END IF;

Line 118: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 124: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 355: RAISE FND_API.G_EXC_ERROR;

351: --throw exception
352: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_LOAN_ID');
353: FND_MSG_PUB.Add;
354: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
355: RAISE FND_API.G_EXC_ERROR;
356: end if;
357:
358: --Initialize the local variables
359: l_loan_amount := 0;

Line 384: RAISE FND_API.G_EXC_ERROR;

380: --throw exception
381: FND_MESSAGE.SET_NAME('LNS', 'LNS_LOAN_LINES_EXIST');
382: FND_MSG_PUB.Add;
383: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
384: RAISE FND_API.G_EXC_ERROR;
385:
386: end if;
387:
388: 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 403: RAISE FND_API.G_EXC_ERROR;

399: --throw exception
400: FND_MESSAGE.SET_NAME('LNS', 'LNS_SOME_REQ_FIELDS_EMPTY');
401: FND_MSG_PUB.Add;
402: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
403: RAISE FND_API.G_EXC_ERROR;
404:
405: end if;
406:
407:

Line 423: RAISE FND_API.G_EXC_ERROR;

419: FND_MESSAGE.SET_TOKEN('PARAMETER', 'p_loan_product_id');
420: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_product_id);
421: FND_MSG_PUB.Add;
422: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
423: RAISE FND_API.G_EXC_ERROR;
424:
425: end if;
426:
427: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || ' - passed IN parameters:');

Line 571: RAISE FND_API.G_EXC_ERROR;

567: --throw exception
568: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_REC_FOUND');
569: FND_MSG_PUB.Add;
570: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, l_api_name || ': ' || FND_MSG_PUB.Get(p_encoded => 'F'));
571: RAISE FND_API.G_EXC_ERROR;
572: END IF;
573:
574: l_last_api_called := 'Bulk insert into lns_loan_lines';
575: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ': ' || ' - BEGIN: ' || l_last_api_called);

Line 650: WHEN FND_API.G_EXC_ERROR THEN

646:
647: return l_loan_amount;
648:
649: EXCEPTION
650: WHEN FND_API.G_EXC_ERROR THEN
651: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - before rollback');
652: ROLLBACK TO loan_lines_derivation;
653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after rollback');
654: logMessage(FND_LOG.LEVEL_ERROR, G_PKG_NAME, sqlerrm);