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

Line 744: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

740: l_return_status VARCHAR2(1);
741: l_msg_count NUMBER;
742: l_msg_data VARCHAR2(32767);
743: l_loan_participant_rec loan_participant_rec_type;
744: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;
745: l_loan_id NUMBER;
746: l_object_version NUMBER;
747: l_old_credit_request_id NUMBER;
748: l_new_credit_request_id NUMBER;

Line 829: l_last_api_called := 'lns_loan_header_pub.update_loan';

825: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
826: open C_GET_LOAN_OVN(l_loan_id);
827: fetch C_GET_LOAN_OVN into l_object_version;
828: close C_GET_LOAN_OVN;
829: l_last_api_called := 'lns_loan_header_pub.update_loan';
830: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
831: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE
832: ,P_LOAN_HEADER_REC => l_loan_header_rec
833: ,P_OBJECT_VERSION_NUMBER => l_object_version

Line 831: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE

827: fetch C_GET_LOAN_OVN into l_object_version;
828: close C_GET_LOAN_OVN;
829: l_last_api_called := 'lns_loan_header_pub.update_loan';
830: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
831: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE
832: ,P_LOAN_HEADER_REC => l_loan_header_rec
833: ,P_OBJECT_VERSION_NUMBER => l_object_version
834: ,X_RETURN_STATUS => x_return_status
835: ,X_MSG_COUNT => x_msg_count

Line 1167: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

1163: l_participant_type varchar2(30);
1164: l_return_status VARCHAR2(1);
1165: l_msg_count NUMBER;
1166: l_msg_data VARCHAR2(32767);
1167: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;
1168: l_object_version NUMBER;
1169: l_loan_id number;
1170: l_last_api_called varchar2(500); --Store the last api that was called before exception
1171: l_api_name CONSTANT VARCHAR2(30) := 'denormalizePrimaryInfo';

Line 1202: l_last_api_called := 'lns_loan_header_pub.update_loan';

1198: l_loan_header_rec.CONTACT_PERS_PARTY_ID := p_loan_participant_rec.CONTACT_PERS_PARTY_ID;
1199: open C_GET_LOAN_OVN(l_loan_id);
1200: fetch C_GET_LOAN_OVN into l_object_version;
1201: close C_GET_LOAN_OVN;
1202: l_last_api_called := 'lns_loan_header_pub.update_loan';
1203: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
1204: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE
1205: ,P_LOAN_HEADER_REC => l_loan_header_rec
1206: ,P_OBJECT_VERSION_NUMBER => l_object_version

Line 1204: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE

1200: fetch C_GET_LOAN_OVN into l_object_version;
1201: close C_GET_LOAN_OVN;
1202: l_last_api_called := 'lns_loan_header_pub.update_loan';
1203: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
1204: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE
1205: ,P_LOAN_HEADER_REC => l_loan_header_rec
1206: ,P_OBJECT_VERSION_NUMBER => l_object_version
1207: ,X_RETURN_STATUS => x_return_status
1208: ,X_MSG_COUNT => x_msg_count

Line 1270: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

1266: LNS_LOAN_HEADERS_ALL
1267: WHERE LOAN_ID = pLoanId;
1268:
1269: l_primary_credit_request_id number;
1270: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;
1271: l_object_version number;
1272:
1273: BEGIN
1274: l_last_api_called := 'submitCreditRequest';

Line 1311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In submitCreditRequest: Before calling lns_loan_header_pub.update_loan api');

1307: fetch C_GET_LOAN_OVN into l_object_version;
1308: close C_GET_LOAN_OVN;
1309:
1310: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In submitCreditRequest: Before calling lns_loan_header_pub.update_loan api');
1312: END IF;
1313:
1314: l_last_api_called := 'lns_loan_header_pub.update_loan';
1315: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

Line 1314: l_last_api_called := 'lns_loan_header_pub.update_loan';

1310: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1311: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In submitCreditRequest: Before calling lns_loan_header_pub.update_loan api');
1312: END IF;
1313:
1314: l_last_api_called := 'lns_loan_header_pub.update_loan';
1315: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
1316: lns_loan_header_pub.update_loan(
1317: p_init_msg_list => FND_API.G_TRUE
1318: ,P_LOAN_HEADER_REC => l_loan_header_rec

Line 1316: lns_loan_header_pub.update_loan(

1312: END IF;
1313:
1314: l_last_api_called := 'lns_loan_header_pub.update_loan';
1315: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
1316: lns_loan_header_pub.update_loan(
1317: p_init_msg_list => FND_API.G_TRUE
1318: ,P_LOAN_HEADER_REC => l_loan_header_rec
1319: ,P_OBJECT_VERSION_NUMBER => l_object_version
1320: ,X_RETURN_STATUS => x_return_status

Line 1522: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

1518: l_resp_id NUMBER;
1519: l_resp_appl_id NUMBER;
1520: l_security_group_id NUMBER;
1521: l_case_folder_id NUMBER;
1522: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;
1523: l_object_version number;
1524: l_update_status_flag VARCHAR2(1);
1525:
1526: CURSOR C_GET_LOAN_OVN(pLoanId Number) IS

Line 1581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In OCM_WORKFLOW_CREDIT_RECO_EVENT: Before calling lns_loan_header_pub.update_loan api');

1577: fetch C_GET_LOAN_OVN into l_object_version;
1578: close C_GET_LOAN_OVN;
1579:
1580: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In OCM_WORKFLOW_CREDIT_RECO_EVENT: Before calling lns_loan_header_pub.update_loan api');
1582: END IF;
1583:
1584: lns_loan_header_pub.update_loan(
1585: p_init_msg_list => FND_API.G_TRUE

Line 1584: lns_loan_header_pub.update_loan(

1580: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1581: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In OCM_WORKFLOW_CREDIT_RECO_EVENT: Before calling lns_loan_header_pub.update_loan api');
1582: END IF;
1583:
1584: lns_loan_header_pub.update_loan(
1585: p_init_msg_list => FND_API.G_TRUE
1586: ,P_LOAN_HEADER_REC => l_loan_header_rec
1587: ,P_OBJECT_VERSION_NUMBER => l_object_version
1588: ,X_RETURN_STATUS => l_return_status

Line 1599: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In OCM_WORKFLOW_CREDIT_RECO_EVENT: After calling lns_loan_header_pub.update_loan api: return_status:'||l_return_status);

1595: COMMIT;
1596: end if;
1597:
1598: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1599: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In OCM_WORKFLOW_CREDIT_RECO_EVENT: After calling lns_loan_header_pub.update_loan api: return_status:'||l_return_status);
1600: END IF;
1601:
1602:
1603: END IF; -- IF (l_case_folder_id IS NOT NULL) THEN