[Home] [Help]
183: MO_GLOBAL.set_policy_context('S', l_org_id);
184:
185: IEX_SCOREAPI_PUB.GETSCORESTATUS(
186: P_API_VERSION => 1.0,
187: P_INIT_MSG_LIST => FND_API.G_TRUE,
188: P_SCORE_ID => 8, -- hardcoded value from collections seeded data
189: P_OBJECT_ID => l_loan_id,
190: X_STATUS => l_status,
191: X_SCORE => l_score,
195:
196: EXCEPTION
197: WHEN OTHERS THEN
198: LogMessage(FND_LOG.LEVEL_ERROR, 'Collections scoring engine API is not installed. Please install it first.');
199: RAISE FND_API.G_EXC_ERROR;
200: END;
201:
202: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
203:
200: END;
201:
202: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
203:
204: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
205:
206: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to collections scoring engine failed with following error:');
207: while (l_indexNo <= l_msg_Count ) loop
208: fnd_msg_pub.get(l_indexNo, 'F', l_msg, l_index);
209: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_msg);
210: l_indexNo := l_indexNo + 1;
211: End Loop;
212:
213: RAISE FND_API.G_EXC_ERROR;
214:
215: END IF;
216:
217: LogMessage(FND_LOG.LEVEL_STATEMENT, 'New score: ' || l_score);
229: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Updating loan header...');
230:
231: LNS_LOAN_HEADER_PUB.UPDATE_LOAN(P_OBJECT_VERSION_NUMBER => l_version_number,
232: P_LOAN_HEADER_REC => l_loan_header_rec,
233: P_INIT_MSG_LIST => FND_API.G_TRUE,
234: X_RETURN_STATUS => l_return_status,
235: X_MSG_COUNT => l_msg_count,
236: X_MSG_DATA => l_msg_data);
237:
242: ELSE
243: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
244: FND_MSG_PUB.Add;
245: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
246: RAISE FND_API.G_EXC_ERROR;
247: END IF;
248:
249: END LOOP;
250: