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 742: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

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

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

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

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

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

Line 1165: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

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

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

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

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

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

Line 1268: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

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

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

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

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

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

Line 1314: lns_loan_header_pub.update_loan(

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

Line 1520: l_loan_header_rec LNS_LOAN_HEADER_PUB.LOAN_HEADER_REC_TYPE;

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

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

1575: fetch C_GET_LOAN_OVN into l_object_version;
1576: close C_GET_LOAN_OVN;
1577:
1578: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1579: 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');
1580: END IF;
1581:
1582: lns_loan_header_pub.update_loan(
1583: p_init_msg_list => FND_API.G_TRUE

Line 1582: lns_loan_header_pub.update_loan(

1578: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1579: 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');
1580: END IF;
1581:
1582: lns_loan_header_pub.update_loan(
1583: p_init_msg_list => FND_API.G_TRUE
1584: ,P_LOAN_HEADER_REC => l_loan_header_rec
1585: ,P_OBJECT_VERSION_NUMBER => l_object_version
1586: ,X_RETURN_STATUS => l_return_status

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

1593: COMMIT;
1594: end if;
1595:
1596: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1597: 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);
1598: END IF;
1599:
1600:
1601: END IF; -- IF (l_case_folder_id IS NOT NULL) THEN