DBA Data[Home] [Help]

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 554: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');

550: ,x_action_id
551: ,x_return_status);
552:
553: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to do_create_approval_action proc');
554: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before call to LNS_LOAN_HEADER_PUB.update_loan proc');
555:
556: OPEN C_Get_Loan_Info(l_approval_action_rec.loan_id);
557: FETCH C_Get_Loan_Info
558: INTO l_object_version_number

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

1006: open loan_version_cur(l_loan_header_rec.loan_id);
1007: fetch loan_version_cur into l_object_version_number;
1008: close loan_version_cur;
1009:
1010: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');
1011: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
1012: ,p_loan_header_rec => l_loan_header_rec
1013: ,p_object_version_number => l_object_version_number
1014: ,x_return_status => x_return_status

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

1007: fetch loan_version_cur into l_object_version_number;
1008: close loan_version_cur;
1009:
1010: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Before call to LNS_LOAN_HEADER_PUB.update_loan');
1011: LNS_LOAN_HEADER_PUB.update_loan(p_init_msg_list => FND_API.G_FALSE
1012: ,p_loan_header_rec => l_loan_header_rec
1013: ,p_object_version_number => l_object_version_number
1014: ,x_return_status => x_return_status
1015: ,x_msg_count => x_msg_count

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

1013: ,p_object_version_number => l_object_version_number
1014: ,x_return_status => x_return_status
1015: ,x_msg_count => x_msg_count
1016: ,x_msg_data => x_msg_data);
1017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');
1018:
1019: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: 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'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';

Line 1020: 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'));

1016: ,x_msg_data => x_msg_data);
1017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');
1018:
1019: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: 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'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');

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

1017: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'After call to LNS_LOAN_HEADER_PUB.update_loan');
1018:
1019: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1020: 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'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');
1025:

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

1020: 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'));
1021: l_last_api_called := 'LNS_LOAN_HEADER_PUB.update_loan';
1022: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1023: END IF;
1024: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call to LNS_LOAN_HEADER_PUB.update_loan proc');
1025:
1026: END IF;
1027:
1028: if (x_return_status = FND_API.G_RET_STS_SUCCESS AND l_approval_action_rec.action_type = 'APPROVE' and (l_loan_header_rec.loan_status = 'ACTIVE' or l_loan_header_rec.loan_status = 'APPROVED')) then