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_APPROVAL_ACTION_PUB dependencies on LNS_LOAN_HEADER_PUB

Line 411: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

407: ) IS
408:
409: l_api_name CONSTANT VARCHAR2(30) := 'create_approval_action';
410: l_approval_action_rec APPROVAL_ACTION_REC_TYPE;
411: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;
412: l_object_version_number NUMBER;
413: l_resource_id NUMBER;
414: l_status VARCHAR2(30);
415: l_currency_code VARCHAR2(15);

Line 600: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');

596: ,x_return_status);
597:
598: END IF;
599: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to do_create_approval_action proc');
600: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');
601: OPEN C_Get_Loan_Info(l_approval_action_rec.loan_id);
602: FETCH C_Get_Loan_Info
603: INTO l_object_version_number
604: ,l_status

Line 1262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');

1258: open loan_version_cur(l_loan_header_rec.loan_id);
1259: fetch loan_version_cur into l_object_version_number;
1260: close loan_version_cur;
1261:
1262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');
1263: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
1264: ,p_loan_header_rec => l_loan_header_rec
1265: ,p_object_version_number => l_object_version_number
1266: ,x_return_status => x_return_status

Line 1263: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE

1259: fetch loan_version_cur into l_object_version_number;
1260: close loan_version_cur;
1261:
1262: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');
1263: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
1264: ,p_loan_header_rec => l_loan_header_rec
1265: ,p_object_version_number => l_object_version_number
1266: ,x_return_status => x_return_status
1267: ,x_msg_count => x_msg_count

Line 1269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');

1265: ,p_object_version_number => l_object_version_number
1266: ,x_return_status => x_return_status
1267: ,x_msg_count => x_msg_count
1268: ,x_msg_data => x_msg_data);
1269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');
1270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1272: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1273: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';

Line 1272: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

1268: ,x_msg_data => x_msg_data);
1269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');
1270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1272: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1273: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:

Line 1273: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';

1269: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');
1270: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1271: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1272: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1273: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: END IF;
1276:
1277: -- activate loan if BILL_ON_APPR_AMOUNT_FLAG = 'Y'

Line 1297: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan 2');

1293: l_loan_header_rec := null;
1294: l_loan_header_rec.loan_id := l_approval_action_rec.loan_id;
1295: l_loan_header_rec.loan_status := 'ACTIVE';
1296:
1297: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan 2');
1298: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
1299: ,p_loan_header_rec => l_loan_header_rec
1300: ,p_object_version_number => l_object_version_number
1301: ,x_return_status => x_return_status

Line 1298: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE

1294: l_loan_header_rec.loan_id := l_approval_action_rec.loan_id;
1295: l_loan_header_rec.loan_status := 'ACTIVE';
1296:
1297: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan 2');
1298: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
1299: ,p_loan_header_rec => l_loan_header_rec
1300: ,p_object_version_number => l_object_version_number
1301: ,x_return_status => x_return_status
1302: ,x_msg_count => x_msg_count

Line 1304: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan 2 proc');

1300: ,p_object_version_number => l_object_version_number
1301: ,x_return_status => x_return_status
1302: ,x_msg_count => x_msg_count
1303: ,x_msg_data => x_msg_data);
1304: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan 2 proc');
1305: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1307: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1308: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';

Line 1307: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));

1303: ,x_msg_data => x_msg_data);
1304: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan 2 proc');
1305: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1307: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1308: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: END IF;
1311:

Line 1308: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';

1304: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan 2 proc');
1305: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - x_return_status = ' || x_return_status);
1306: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1307: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - LNS_LOAN_HEADER_PUB.update_loan failed with message: ' ||FND_MSG_PUB.Get(p_encoded => 'F'));
1308: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: END IF;
1311:
1312: END IF;

Line 1634: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

1630: l_cond_count number;
1631: l_adj_date date;
1632: l_currency varchar2(15);
1633:
1634: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
1635:
1636: /*-----------------------------------------------------------------------+
1637: | Cursor Declarations |
1638: +-----------------------------------------------------------------------*/

Line 1773: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,

1769: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'LOAN_STATUS: ' || l_loan_header_rec.LOAN_STATUS);
1770: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'funded_amount: ' || l_loan_header_rec.funded_amount);
1771: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'ADD_REQUESTED_AMOUNT: ' || l_loan_header_rec.ADD_REQUESTED_AMOUNT);
1772:
1773: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
1774: P_LOAN_HEADER_REC => l_loan_header_rec,
1775: P_INIT_MSG_LIST => FND_API.G_FALSE,
1776: X_RETURN_STATUS => l_return_status,
1777: X_MSG_COUNT => l_msg_count,

Line 1909: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;

1905: l_adj_amount_str varchar2(30);
1906: l_currency varchar2(15);
1907: l_DESCRIPTION VARCHAR2(250);
1908:
1909: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
1910:
1911: /*-----------------------------------------------------------------------+
1912: | Cursor Declarations |
1913: +-----------------------------------------------------------------------*/