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 FND_API

Line 120: x_return_status := FND_API.G_RET_STS_SUCCESS;

116: --SAVEPOINT validateParticipant;
117:
118: --dbms_output.put_line('validate');
119: -- Initialize API return status to SUCCESS
120: x_return_status := FND_API.G_RET_STS_SUCCESS;
121:
122: IF (p_mode = 'CREATE') THEN
123:
124: -- validate loan_id

Line 126: l_LOAN_ID <> FND_API.G_MISS_NUM

122: IF (p_mode = 'CREATE') THEN
123:
124: -- validate loan_id
125: IF l_LOAN_ID IS NOT NULL AND
126: l_LOAN_ID <> FND_API.G_MISS_NUM
127: THEN
128:
129: -- check to see if primary_borrower. if so then CUST_ACCOUNT_ID,bill_to_acct_site_id and PARTY_ID MUST
130: -- be valid combination with valid BILL_TO purpose

Line 142: RAISE FND_API.G_EXC_ERROR;

138: --dbms_output.put_line('Site use number is ' || l_num_acct_site_uses);
139: if l_valid_acct_site_party <> 'Y' then
140: FND_MESSAGE.SET_NAME('LNS', 'LNS_BORROWER_NO_BILL_TO');
141: FND_MSG_PUB.ADD;
142: RAISE FND_API.G_EXC_ERROR;
143: end if;
144: exception
145: when NO_DATA_FOUND then
146: FND_MESSAGE.SET_NAME('LNS', 'LNS_BORROWER_NO_BILL_TO');

Line 148: RAISE FND_API.G_EXC_ERROR;

144: exception
145: when NO_DATA_FOUND then
146: FND_MESSAGE.SET_NAME('LNS', 'LNS_BORROWER_NO_BILL_TO');
147: FND_MSG_PUB.ADD;
148: RAISE FND_API.G_EXC_ERROR;
149: End;
150:
151: end if; --end if (l_loan_participant_type = 'PRIMARY_BORROWER') then
152:

Line 163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

159: P_COL_NAME => 'LOAN_ID',
160: P_TABLE_NAME => 'LNS_LOAN_HEADERS_ALL');
161: --dbms_output.put_line('output');
162:
163: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
164: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
165: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
166: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_id);
167: FND_MSG_PUB.ADD;

Line 168: RAISE FND_API.G_EXC_ERROR;

164: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
165: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');
166: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_id);
167: FND_MSG_PUB.ADD;
168: RAISE FND_API.G_EXC_ERROR;
169: end if;
170:
171: END IF;
172:

Line 175: l_hz_party_id <> FND_API.G_MISS_NUM

171: END IF;
172:
173: -- validate hz_party_id
174: IF l_hz_party_id IS NOT NULL AND
175: l_hz_party_id <> FND_API.G_MISS_NUM
176: THEN
177:
178: LNS_UTILITY_PUB.VALIDATE_ANY_ID(P_API_VERSION => 1.0,
179: P_INIT_MSG_LIST => 'F',

Line 188: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

184: P_COL_NAME => 'PARTY_ID',
185: P_TABLE_NAME => 'HZ_PARTIES');
186: --dbms_output.put_line('output2');
187:
188: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
189: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
190: FND_MESSAGE.SET_TOKEN('PARAMETER', 'HZ_PARTY_ID');
191: FND_MESSAGE.SET_TOKEN('VALUE', l_hz_party_id);
192: FND_MSG_PUB.ADD;

Line 193: RAISE FND_API.G_EXC_ERROR;

189: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
190: FND_MESSAGE.SET_TOKEN('PARAMETER', 'HZ_PARTY_ID');
191: FND_MESSAGE.SET_TOKEN('VALUE', l_hz_party_id);
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_ERROR;
194: end if;
195:
196: END IF;
197:

Line 201: l_loan_participant_type <> FND_API.G_MISS_CHAR

197:
198:
199: -- validate l_loan_participant_type
200: IF l_loan_participant_type IS NOT NULL AND
201: l_loan_participant_type <> FND_API.G_MISS_CHAR
202: THEN
203: LNS_UTILITY_PUB.VALIDATE_LOOKUP_CODE(P_API_VERSION => 1.0,
204: P_INIT_MSG_LIST => 'F',
205: X_MSG_COUNT => l_msg_count,

Line 213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

209: P_LOOKUP_CODE => l_loan_participant_type,
210: P_LOOKUP_VIEW => 'LNS_LOOKUPS');
211: --dbms_output.put_line('output3');
212:
213: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PARTICIPANT_TYPE');
216: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_participant_type);
217: FND_MSG_PUB.ADD;

Line 218: RAISE FND_API.G_EXC_ERROR;

214: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
215: FND_MESSAGE.SET_TOKEN('PARAMETER', 'PARTICIPANT_TYPE');
216: FND_MESSAGE.SET_TOKEN('VALUE', l_loan_participant_type);
217: FND_MSG_PUB.ADD;
218: RAISE FND_API.G_EXC_ERROR;
219: end if;
220:
221: END IF;
222:

Line 224: l_cust_account_id <> FND_API.G_MISS_NUM

220:
221: END IF;
222:
223: IF l_cust_account_id IS NOT NULL AND
224: l_cust_account_id <> FND_API.G_MISS_NUM
225: THEN
226:
227: LNS_UTILITY_PUB.VALIDATE_ANY_ID(P_API_VERSION => 1.0,
228: P_INIT_MSG_LIST => 'F',

Line 237: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

233: P_COL_NAME => 'CUST_ACCOUNT_ID',
234: P_TABLE_NAME => 'HZ_CUST_ACCOUNTS');
235: --dbms_output.put_line('output5');
236:
237: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
238: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
239: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CUST_ACCOUNT_ID');
240: FND_MESSAGE.SET_TOKEN('VALUE', l_cust_account_id);
241: FND_MSG_PUB.ADD;

Line 242: RAISE FND_API.G_EXC_ERROR;

238: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
239: FND_MESSAGE.SET_TOKEN('PARAMETER', 'CUST_ACCOUNT_ID');
240: FND_MESSAGE.SET_TOKEN('VALUE', l_cust_account_id);
241: FND_MSG_PUB.ADD;
242: RAISE FND_API.G_EXC_ERROR;
243: end if;
244:
245: END IF;
246:

Line 254: RAISE FND_API.G_EXC_ERROR;

250: if l_end_date is not null then
251: if trunc(l_start_date) > trunc(l_end_date) then
252: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_ACTIVE_DATE');
253: FND_MSG_PUB.ADD;
254: RAISE FND_API.G_EXC_ERROR;
255: end if;
256: end if;
257: end if;
258:

Line 267: WHEN FND_API.G_EXC_ERROR THEN

263:
264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
265:
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: --ROLLBACK TO validateParticipant;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
271:

Line 269: x_return_status := FND_API.G_RET_STS_ERROR;

265:
266: EXCEPTION
267: WHEN FND_API.G_EXC_ERROR THEN
268: --ROLLBACK TO validateParticipant;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: --ROLLBACK TO validateParticipant;

Line 272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

268: --ROLLBACK TO validateParticipant;
269: x_return_status := FND_API.G_RET_STS_ERROR;
270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: --ROLLBACK TO validateParticipant;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
276:

Line 274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

270: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
271:
272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: --ROLLBACK TO validateParticipant;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
276:
277: WHEN OTHERS THEN
278: --ROLLBACK TO Validate_any_id_PVT;

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
276:
277: WHEN OTHERS THEN
278: --ROLLBACK TO Validate_any_id_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
281:
282: END validateParticipant;
283:

Line 297: x_return_status := FND_API.G_RET_STS_SUCCESS;

293: BEGIN
294: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
295:
296: -- initialize API return status to success.
297: x_return_status := FND_API.G_RET_STS_SUCCESS;
298:
299:
300: lns_participants_pkg.INSERT_ROW(
301: x_PARTICIPANT_ID => p_loan_participant_rec.PARTICIPANT_ID

Line 405: l_init_msg_list := FND_API.G_FALSE;

401: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
402:
403: l_init_msg_list := p_init_msg_list;
404: if (l_init_msg_list is null) then
405: l_init_msg_list := FND_API.G_FALSE;
406: end if;
407:
408: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createParticipant';
409: l_participant_id := p_loan_participant_rec.participant_id;

Line 417: IF FND_API.to_Boolean(l_init_msg_list) THEN

413:
414: SAVEPOINT createParticipant;
415:
416: -- initialize message list if l_init_msg_list is set to TRUE.
417: IF FND_API.to_Boolean(l_init_msg_list) THEN
418: FND_MSG_PUB.initialize;
419: END IF;
420: -- Get the default values of ContactPerson PartyId and ContactRel PartyId
421: getDefaultPrimaryContact(p_loan_participant_rec => l_loan_participant_rec,

Line 438: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN

434: ELSE
435: l_loan_participant_rec.REVIEW_TYPE := nvl(l_borrower_review_type,'LNS');
436: END IF;
437:
438: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
439:
440: open c_get_party_type(l_hz_party_id);
441: fetch c_get_party_type into l_party_type;
442: close c_get_party_type;

Line 447: RAISE FND_API.G_EXC_ERROR;

443:
444: if (l_party_type <> l_loan_party_type OR l_party_type NOT IN ('ORGANIZATION','PERSON')) then
445: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_PARTY_TYPE');
446: FND_MSG_PUB.ADD;
447: RAISE FND_API.G_EXC_ERROR;
448: end if;
449:
450: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
451: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In createParticipant: Before call to validateParticipant');

Line 463: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In createParticipant: After call to validateParticipant');
461: END IF;
462:
463: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: end if;
466:
467: END IF; --end IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN

Line 464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

460: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In createParticipant: After call to validateParticipant');
461: END IF;
462:
463: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: end if;
466:
467: END IF; --end IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
468:

Line 467: END IF; --end IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN

463: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
464: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
465: end if;
466:
467: END IF; --end IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL) THEN
468:
469: --validate duplicate entry for same party
470: l_dup_party_count := 0;
471: OPEN CheckDupParty(l_loan_id,l_hz_party_id);

Line 476: RAISE FND_API.G_EXC_ERROR;

472: FETCH CheckDupParty INTO l_dup_party_count;
473: IF (l_dup_party_count > 0) THEN
474: FND_MESSAGE.SET_NAME('LNS', 'LNS_PARTICIPANT_DUP_PARTY');
475: FND_MSG_PUB.ADD;
476: RAISE FND_API.G_EXC_ERROR;
477: END IF;
478:
479: if (l_loan_credit_review_flag = 'Y' and l_loan_status = 'INCOMPLETE' and (l_loan_sec_status is null OR l_loan_sec_status NOT IN ('IN_CREDIT_REVIEW','CREDIT_REVIEW_COMPLETE'))) then
480: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling createCreditRequest');

Line 486: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

482: createCreditRequest(p_loan_participant_rec => l_loan_participant_rec,
483: x_return_status => l_return_status,
484: x_msg_count => l_msg_count,
485: x_msg_data => l_msg_data);
486: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: end if;
489: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling createCreditRequest');
490:

Line 487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

483: x_return_status => l_return_status,
484: x_msg_count => l_msg_count,
485: x_msg_data => l_msg_data);
486: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
487: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
488: end if;
489: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling createCreditRequest');
490:
491: else

Line 521: WHEN FND_API.G_EXC_ERROR THEN

517:
518: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
519:
520: Exception
521: WHEN FND_API.G_EXC_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;
523: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
524: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
525: FND_MSG_PUB.ADD;

Line 522: x_return_status := FND_API.G_RET_STS_ERROR;

518: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
519:
520: Exception
521: WHEN FND_API.G_EXC_ERROR THEN
522: x_return_status := FND_API.G_RET_STS_ERROR;
523: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
524: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
525: FND_MSG_PUB.ADD;
526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

525: FND_MSG_PUB.ADD;
526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
527: ROLLBACK TO createParticipant;
528:
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
532: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
533: FND_MSG_PUB.ADD;

Line 530: x_return_status := FND_API.G_RET_STS_ERROR;

526: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
527: ROLLBACK TO createParticipant;
528:
529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
530: x_return_status := FND_API.G_RET_STS_ERROR;
531: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
532: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
533: FND_MSG_PUB.ADD;
534: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 538: x_return_status := FND_API.G_RET_STS_ERROR;

534: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
535: ROLLBACK TO createParticipant;
536:
537: WHEN OTHERS THEN
538: x_return_status := FND_API.G_RET_STS_ERROR;
539: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
540: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
541: FND_MSG_PUB.ADD;
542: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 569: l_init_msg_list := FND_API.G_FALSE;

565: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
566:
567: l_init_msg_list := p_init_msg_list;
568: if (l_init_msg_list is null) then
569: l_init_msg_list := FND_API.G_FALSE;
570: end if;
571:
572: l_last_api_called := 'LNS_PARTICIPANTS_PUB.updateParticipant';
573: l_loan_participant_rec := p_loan_participant_rec;

Line 581: IF FND_API.to_Boolean(l_init_msg_list) THEN

577: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin update participant');
578: END IF;
579:
580: -- initialize message list if l_init_msg_list is set to TRUE.
581: IF FND_API.to_Boolean(l_init_msg_list) THEN
582: FND_MSG_PUB.initialize;
583: END IF;
584:
585:

Line 618: RAISE FND_API.G_EXC_ERROR;

614: THEN
615: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_RECORD_CHANGED');
616: FND_MESSAGE.SET_TOKEN('TABLE', 'lns_participants');
617: FND_MSG_PUB.ADD;
618: RAISE FND_API.G_EXC_ERROR;
619: END IF;
620:
621: x_object_version_number := nvl(x_object_version_number, 1) + 1;
622:

Line 628: RAISE FND_API.G_EXC_ERROR;

624: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_NO_RECORD');
625: FND_MESSAGE.SET_TOKEN('RECORD', 'loan participant');
626: FND_MESSAGE.SET_TOKEN('VALUE', NVL(TO_CHAR(p_loan_participant_rec.participant_id), 'null'));
627: FND_MSG_PUB.ADD;
628: RAISE FND_API.G_EXC_ERROR;
629: END;
630:
631: if (p_validation_level = FND_API.G_VALID_LEVEL_FULL) then
632:

Line 631: if (p_validation_level = FND_API.G_VALID_LEVEL_FULL) then

627: FND_MSG_PUB.ADD;
628: RAISE FND_API.G_EXC_ERROR;
629: END;
630:
631: if (p_validation_level = FND_API.G_VALID_LEVEL_FULL) then
632:
633: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'Before calling validateParticipant');
634: l_last_api_called := 'validateParticipant';
635: validateParticipant(p_loan_participant_rec => p_loan_participant_rec,

Line 641: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

637: x_return_status => l_return_status,
638: x_msg_count => l_msg_count,
639: x_msg_data => l_msg_data);
640:
641: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: end if;
644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling validateParticipant');
645:

Line 642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

638: x_msg_count => l_msg_count,
639: x_msg_data => l_msg_data);
640:
641: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: end if;
644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling validateParticipant');
645:
646: end if; -- end if (p_validation_level = FND_API.G_VALID_LEVEL_FULL) then

Line 646: end if; -- end if (p_validation_level = FND_API.G_VALID_LEVEL_FULL) then

642: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
643: end if;
644: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling validateParticipant');
645:
646: end if; -- end if (p_validation_level = FND_API.G_VALID_LEVEL_FULL) then
647:
648:
649: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'Before calling LNS_PARTICIPANTS_PKG.Update_Row');
650: l_last_api_called := 'LNS_PARTICIPANTS_PKG.Update_Row';

Line 699: x_return_status := FND_API.G_RET_STS_SUCCESS;

695: x_msg_count => l_msg_count,
696: x_msg_data => l_msg_data);
697: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling denormalizePrimaryInfo');
698:
699: x_return_status := FND_API.G_RET_STS_SUCCESS;
700:
701: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
702:
703: Exception

Line 704: WHEN FND_API.G_EXC_ERROR THEN

700:
701: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
702:
703: Exception
704: WHEN FND_API.G_EXC_ERROR THEN
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
707: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
708: FND_MSG_PUB.ADD;

Line 705: x_return_status := FND_API.G_RET_STS_ERROR;

701: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
702:
703: Exception
704: WHEN FND_API.G_EXC_ERROR THEN
705: x_return_status := FND_API.G_RET_STS_ERROR;
706: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
707: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
708: FND_MSG_PUB.ADD;
709: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

708: FND_MSG_PUB.ADD;
709: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
710: ROLLBACK TO updateParticipant;
711:
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
715: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
716: FND_MSG_PUB.ADD;

Line 713: x_return_status := FND_API.G_RET_STS_ERROR;

709: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
710: ROLLBACK TO updateParticipant;
711:
712: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
713: x_return_status := FND_API.G_RET_STS_ERROR;
714: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
715: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
716: FND_MSG_PUB.ADD;
717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 721: x_return_status := FND_API.G_RET_STS_ERROR;

717: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
718: ROLLBACK TO updateParticipant;
719:
720: WHEN OTHERS THEN
721: x_return_status := FND_API.G_RET_STS_ERROR;
722: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
723: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
724: FND_MSG_PUB.ADD;
725: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 773: x_return_status := FND_API.G_RET_STS_SUCCESS;

769:
770: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createAppealCreditRequest';
771: -- Standard Start of API savepoint
772: SAVEPOINT createAppealCreditRequest;
773: x_return_status := FND_API.G_RET_STS_SUCCESS;
774: l_loan_id := p_loan_id;
775:
776: open c_get_primary_borrower(l_loan_id);
777: fetch c_get_primary_borrower into l_loan_participant_rec.participant_id, l_loan_participant_rec.loan_id,

Line 797: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

793: x_return_status => l_return_status,
794: x_msg_count => l_msg_count,
795: x_msg_data => l_msg_data);
796:
797: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: end if;
800: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
801:

Line 798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

794: x_msg_count => l_msg_count,
795: x_msg_data => l_msg_data);
796:
797: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: end if;
800: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
801:
802: l_new_credit_request_id := l_loan_participant_rec.credit_request_id;

Line 812: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

808: l_last_api_called := 'LNS_PARTICIPANTS_PUB.updateParticipant';
809: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
810: l_object_version := l_loan_participant_rec.object_version_number;
811: updateParticipant(p_init_msg_list => 'T',
812: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
813: p_loan_participant_rec => l_loan_participant_rec,
814: x_object_version_number => l_object_version,
815: x_return_status => l_return_status,
816: x_msg_count => l_msg_count,

Line 819: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

815: x_return_status => l_return_status,
816: x_msg_count => l_msg_count,
817: x_msg_data => l_msg_data);
818:
819: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: end if;
822: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
823:

Line 820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

816: x_msg_count => l_msg_count,
817: x_msg_data => l_msg_data);
818:
819: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
820: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
821: end if;
822: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
823:
824: l_loan_header_rec.loan_id := l_loan_id;

Line 825: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;

821: end if;
822: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
823:
824: l_loan_header_rec.loan_id := l_loan_id;
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';

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 841: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

837:
838: x_return_status := l_return_status;
839: x_msg_count := l_msg_count;
840: x_msg_data := l_msg_data;
841: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: end if;
844: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
845:

Line 842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

838: x_return_status := l_return_status;
839: x_msg_count := l_msg_count;
840: x_msg_data := l_msg_data;
841: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
842: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
843: end if;
844: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
845:
846: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

Line 850: WHEN FND_API.G_EXC_ERROR THEN

846: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
847:
848:
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
853: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
854: FND_MSG_PUB.ADD;

Line 851: x_return_status := FND_API.G_RET_STS_ERROR;

847:
848:
849: EXCEPTION
850: WHEN FND_API.G_EXC_ERROR THEN
851: x_return_status := FND_API.G_RET_STS_ERROR;
852: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
853: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
854: FND_MSG_PUB.ADD;
855: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

854: FND_MSG_PUB.ADD;
855: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
856: ROLLBACK TO createAppealCreditRequest;
857:
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
861: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
862: FND_MSG_PUB.ADD;

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
856: ROLLBACK TO createAppealCreditRequest;
857:
858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
861: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
862: FND_MSG_PUB.ADD;
863: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 867: x_return_status := FND_API.G_RET_STS_ERROR;

863: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
864: ROLLBACK TO createAppealCreditRequest;
865:
866: WHEN OTHERS THEN
867: x_return_status := FND_API.G_RET_STS_ERROR;
868: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
869: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
870: FND_MSG_PUB.ADD;
871: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 928: x_return_status := FND_API.G_RET_STS_SUCCESS;

924: l_credit_classification := p_loan_participant_rec.CREDIT_CLASSIFICATION;
925:
926: -- Standard Start of API savepoint
927: SAVEPOINT createCreditRequest;
928: x_return_status := FND_API.G_RET_STS_SUCCESS;
929:
930: open c_get_loan_info(l_loan_id);
931: fetch c_get_loan_info into l_org_id,l_credit_review_flag,l_loan_number,l_requested_amount,l_loan_currency,l_loan_description,l_loan_status,l_loan_sec_status;
932: close c_get_loan_info;

Line 960: ,P_INIT_MSG_LIST => FND_API.G_FALSE

956: l_last_api_called := 'AR_CMGT_CREDIT_REQUEST_API.CREATE_CREDIT_REQUEST';
957: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
958: AR_CMGT_CREDIT_REQUEST_API.CREATE_CREDIT_REQUEST(
959: P_API_VERSION => 1.0
960: ,P_INIT_MSG_LIST => FND_API.G_FALSE
961: ,P_COMMIT => FND_API.G_FALSE
962: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
963: ,X_RETURN_STATUS => l_return_status
964: ,X_MSG_COUNT => l_msg_count

Line 961: ,P_COMMIT => FND_API.G_FALSE

957: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
958: AR_CMGT_CREDIT_REQUEST_API.CREATE_CREDIT_REQUEST(
959: P_API_VERSION => 1.0
960: ,P_INIT_MSG_LIST => FND_API.G_FALSE
961: ,P_COMMIT => FND_API.G_FALSE
962: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
963: ,X_RETURN_STATUS => l_return_status
964: ,X_MSG_COUNT => l_msg_count
965: ,X_MSG_DATA => l_msg_data

Line 962: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL

958: AR_CMGT_CREDIT_REQUEST_API.CREATE_CREDIT_REQUEST(
959: P_API_VERSION => 1.0
960: ,P_INIT_MSG_LIST => FND_API.G_FALSE
961: ,P_COMMIT => FND_API.G_FALSE
962: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
963: ,X_RETURN_STATUS => l_return_status
964: ,X_MSG_COUNT => l_msg_count
965: ,X_MSG_DATA => l_msg_data
966: ,P_APPLICATION_NUMBER => l_loan_number

Line 1007: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1003:
1004: x_return_status := l_return_status;
1005: x_msg_count := l_msg_count;
1006: x_msg_data := l_msg_data;
1007: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1008: FND_MESSAGE.Set_Name('LNS', 'LNS_CREDIT_REQUEST_API_FAILED');
1009: FND_MSG_PUB.Add;
1010: RAISE FND_API.G_EXC_ERROR;
1011: else

Line 1010: RAISE FND_API.G_EXC_ERROR;

1006: x_msg_data := l_msg_data;
1007: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1008: FND_MESSAGE.Set_Name('LNS', 'LNS_CREDIT_REQUEST_API_FAILED');
1009: FND_MSG_PUB.Add;
1010: RAISE FND_API.G_EXC_ERROR;
1011: else
1012: p_loan_participant_rec.CREDIT_REQUEST_ID := l_credit_request_id;
1013: if (l_credit_request_type = 'RESUBMISSION') then
1014: --set case_folder_id to null

Line 1015: p_loan_participant_rec.case_folder_id := FND_API.G_MISS_NUM;

1011: else
1012: p_loan_participant_rec.CREDIT_REQUEST_ID := l_credit_request_id;
1013: if (l_credit_request_type = 'RESUBMISSION') then
1014: --set case_folder_id to null
1015: p_loan_participant_rec.case_folder_id := FND_API.G_MISS_NUM;
1016: end if;
1017: end if;
1018:
1019: elsif (l_participant_type = 'COBORROWER') then

Line 1058: ,P_INIT_MSG_LIST => FND_API.G_FALSE

1054: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
1055: l_guarantor_application_number := l_loan_number;
1056: OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST(
1057: P_API_VERSION => 1.0
1058: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1059: ,P_COMMIT => FND_API.G_FALSE
1060: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
1061: ,X_RETURN_STATUS => l_return_status
1062: ,X_MSG_COUNT => l_msg_count

Line 1059: ,P_COMMIT => FND_API.G_FALSE

1055: l_guarantor_application_number := l_loan_number;
1056: OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST(
1057: P_API_VERSION => 1.0
1058: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1059: ,P_COMMIT => FND_API.G_FALSE
1060: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
1061: ,X_RETURN_STATUS => l_return_status
1062: ,X_MSG_COUNT => l_msg_count
1063: ,X_MSG_DATA => l_msg_data

Line 1060: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL

1056: OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST(
1057: P_API_VERSION => 1.0
1058: ,P_INIT_MSG_LIST => FND_API.G_FALSE
1059: ,P_COMMIT => FND_API.G_FALSE
1060: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL
1061: ,X_RETURN_STATUS => l_return_status
1062: ,X_MSG_COUNT => l_msg_count
1063: ,X_MSG_DATA => l_msg_data
1064: ,X_GUARANTOR_CREDIT_REQUEST_ID => l_credit_request_id

Line 1111: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then

1107:
1108: x_return_status := l_return_status;
1109: x_msg_count := l_msg_count;
1110: x_msg_data := l_msg_data;
1111: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1112: FND_MESSAGE.Set_Name('LNS', 'LNS_G_CRDT_REQ_API_FAILED');
1113: FND_MSG_PUB.Add;
1114: RAISE FND_API.G_EXC_ERROR;
1115: else

Line 1114: RAISE FND_API.G_EXC_ERROR;

1110: x_msg_data := l_msg_data;
1111: if (x_return_status <> FND_API.G_RET_STS_SUCCESS) then
1112: FND_MESSAGE.Set_Name('LNS', 'LNS_G_CRDT_REQ_API_FAILED');
1113: FND_MSG_PUB.Add;
1114: RAISE FND_API.G_EXC_ERROR;
1115: else
1116: p_loan_participant_rec.CREDIT_REQUEST_ID := l_credit_request_id;
1117: end if;
1118:

Line 1128: WHEN FND_API.G_EXC_ERROR THEN

1124:
1125: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1126:
1127: EXCEPTION
1128: WHEN FND_API.G_EXC_ERROR THEN
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1131: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1132: FND_MSG_PUB.ADD;

Line 1129: x_return_status := FND_API.G_RET_STS_ERROR;

1125: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1126:
1127: EXCEPTION
1128: WHEN FND_API.G_EXC_ERROR THEN
1129: x_return_status := FND_API.G_RET_STS_ERROR;
1130: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1131: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1132: FND_MSG_PUB.ADD;
1133: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1132: FND_MSG_PUB.ADD;
1133: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1134: ROLLBACK TO createCreditRequest;
1135:
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1139: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1140: FND_MSG_PUB.ADD;

Line 1137: x_return_status := FND_API.G_RET_STS_ERROR;

1133: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1134: ROLLBACK TO createCreditRequest;
1135:
1136: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1139: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1140: FND_MSG_PUB.ADD;
1141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1145: x_return_status := FND_API.G_RET_STS_ERROR;

1141: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1142: ROLLBACK TO createCreditRequest;
1143:
1144: WHEN OTHERS THEN
1145: x_return_status := FND_API.G_RET_STS_ERROR;
1146: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1147: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1148: FND_MSG_PUB.ADD;
1149: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1189: x_return_status := FND_API.G_RET_STS_SUCCESS;

1185: -- Standard Start of API savepoint
1186: SAVEPOINT denormalizePrimaryInfo;
1187:
1188: -- Initialize API return status to SUCCESS
1189: x_return_status := FND_API.G_RET_STS_SUCCESS;
1190:
1191: if (l_participant_type = 'PRIMARY_BORROWER') then
1192:
1193: l_loan_header_rec.loan_id := p_loan_participant_rec.loan_id;

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 1217: WHEN FND_API.G_EXC_ERROR THEN

1213: x_msg_data := l_msg_data;
1214: end if; -- end if (l_participant_type = 'PRIMARY_BORROWER') then
1215: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1216: EXCEPTION
1217: WHEN FND_API.G_EXC_ERROR THEN
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1220: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1221: FND_MSG_PUB.ADD;

Line 1218: x_return_status := FND_API.G_RET_STS_ERROR;

1214: end if; -- end if (l_participant_type = 'PRIMARY_BORROWER') then
1215: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1216: EXCEPTION
1217: WHEN FND_API.G_EXC_ERROR THEN
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1220: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1221: FND_MSG_PUB.ADD;
1222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1221: FND_MSG_PUB.ADD;
1222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1223: ROLLBACK TO denormalizePrimaryInfo;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1228: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1229: FND_MSG_PUB.ADD;

Line 1226: x_return_status := FND_API.G_RET_STS_ERROR;

1222: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1223: ROLLBACK TO denormalizePrimaryInfo;
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: x_return_status := FND_API.G_RET_STS_ERROR;
1227: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1228: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1229: FND_MSG_PUB.ADD;
1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1234: x_return_status := FND_API.G_RET_STS_ERROR;

1230: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1231: ROLLBACK TO denormalizePrimaryInfo;
1232:
1233: WHEN OTHERS THEN
1234: x_return_status := FND_API.G_RET_STS_ERROR;
1235: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
1236: FND_MESSAGE.SET_TOKEN('ERROR' ,'Failed API call: ' || l_last_api_called || ' SQLERRM: ' || SQLERRM);
1237: FND_MSG_PUB.ADD;
1238: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

1273: BEGIN
1274: l_last_api_called := 'submitCreditRequest';
1275: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1276:
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278:
1279: open C_GET_PRIMARY_CREQ_ID(p_loan_id);
1280: fetch C_GET_PRIMARY_CREQ_ID into l_primary_credit_request_id;
1281: close C_GET_PRIMARY_CREQ_ID;

Line 1292: p_init_msg_list => FND_API.G_TRUE,

1288: l_last_api_called := 'OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status';
1289: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
1290: OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status (
1291: p_api_version => 1.0,
1292: p_init_msg_list => FND_API.G_TRUE,
1293: p_commit => FND_API.G_TRUE,
1294: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1295: x_return_status => x_return_status,
1296: x_msg_count => x_msg_count,

Line 1293: p_commit => FND_API.G_TRUE,

1289: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
1290: OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status (
1291: p_api_version => 1.0,
1292: p_init_msg_list => FND_API.G_TRUE,
1293: p_commit => FND_API.G_TRUE,
1294: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1295: x_return_status => x_return_status,
1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,

Line 1294: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1290: OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status (
1291: p_api_version => 1.0,
1292: p_init_msg_list => FND_API.G_TRUE,
1293: p_commit => FND_API.G_TRUE,
1294: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1295: x_return_status => x_return_status,
1296: x_msg_count => x_msg_count,
1297: x_msg_data => x_msg_data,
1298: p_credit_request_id => l_primary_credit_request_id,

Line 1303: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then

1299: p_credit_request_status => 'SUBMIT');
1300: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
1301:
1302:
1303: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
1304: l_loan_header_rec.loan_id := p_loan_id;
1305: l_loan_header_rec.secondary_status := 'IN_CREDIT_REVIEW';
1306: open C_GET_LOAN_OVN(p_loan_id);
1307: fetch C_GET_LOAN_OVN into l_object_version;

Line 1317: p_init_msg_list => FND_API.G_TRUE

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
1321: ,X_MSG_COUNT => x_msg_count

Line 1332: RAISE FND_API.G_EXC_ERROR;

1328:
1329: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1330: FND_MESSAGE.Set_Name('LNS', 'LNS_CRDT_REQ_SUBMIT_API_FAILED');
1331: FND_MSG_PUB.Add;
1332: RAISE FND_API.G_EXC_ERROR;
1333:
1334: end if;
1335:
1336: else

Line 1340: RAISE FND_API.G_EXC_ERROR;

1336: else
1337:
1338: FND_MESSAGE.Set_Name('LNS', 'LNS_CREDIT_REQUEST_NOT_FOUND');
1339: FND_MSG_PUB.Add;
1340: RAISE FND_API.G_EXC_ERROR;
1341:
1342: end if;
1343: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1344: END submitCreditRequest;

Line 1585: p_init_msg_list => FND_API.G_TRUE

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
1589: ,X_MSG_COUNT => l_msg_count

Line 1592: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then

1588: ,X_RETURN_STATUS => l_return_status
1589: ,X_MSG_COUNT => l_msg_count
1590: ,X_MSG_DATA => l_msg_data);
1591:
1592: if (l_return_status <> FND_API.G_RET_STS_SUCCESS) then
1593: l_wf_return_status := 'ERROR';
1594: else
1595: COMMIT;
1596: end if;

Line 1650: x_return_status := FND_API.G_RET_STS_ERROR;

1646:
1647: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1648: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, p_loan_participant_rec.LOAN_PARTICIPANT_TYPE);
1649: IF p_loan_participant_rec.LOAN_PARTICIPANT_TYPE <> 'PRIMARY_BORROWER' THEN
1650: x_return_status := FND_API.G_RET_STS_ERROR;
1651: END IF;
1652:
1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person '||p_loan_participant_rec.CONTACT_PERS_PARTY_ID||' and Rel PartyId is '||p_loan_participant_rec.CONTACT_REL_PARTY_ID);
1654:

Line 1655: IF (p_loan_participant_rec.CONTACT_PERS_PARTY_ID IS NULL or p_loan_participant_rec.CONTACT_PERS_PARTY_ID = FND_API.G_MISS_NUM) AND

1651: END IF;
1652:
1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person '||p_loan_participant_rec.CONTACT_PERS_PARTY_ID||' and Rel PartyId is '||p_loan_participant_rec.CONTACT_REL_PARTY_ID);
1654:
1655: IF (p_loan_participant_rec.CONTACT_PERS_PARTY_ID IS NULL or p_loan_participant_rec.CONTACT_PERS_PARTY_ID = FND_API.G_MISS_NUM) AND
1656: (p_loan_participant_rec.CONTACT_REL_PARTY_ID IS NULL OR p_loan_participant_rec.CONTACT_REL_PARTY_ID = FND_API.G_MISS_NUM) THEN
1657: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person and PartyId are NULL');
1658: p_loan_participant_rec.CONTACT_REL_PARTY_ID := p_loan_participant_rec.HZ_PARTY_ID;
1659:

Line 1656: (p_loan_participant_rec.CONTACT_REL_PARTY_ID IS NULL OR p_loan_participant_rec.CONTACT_REL_PARTY_ID = FND_API.G_MISS_NUM) THEN

1652:
1653: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person '||p_loan_participant_rec.CONTACT_PERS_PARTY_ID||' and Rel PartyId is '||p_loan_participant_rec.CONTACT_REL_PARTY_ID);
1654:
1655: IF (p_loan_participant_rec.CONTACT_PERS_PARTY_ID IS NULL or p_loan_participant_rec.CONTACT_PERS_PARTY_ID = FND_API.G_MISS_NUM) AND
1656: (p_loan_participant_rec.CONTACT_REL_PARTY_ID IS NULL OR p_loan_participant_rec.CONTACT_REL_PARTY_ID = FND_API.G_MISS_NUM) THEN
1657: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person and PartyId are NULL');
1658: p_loan_participant_rec.CONTACT_REL_PARTY_ID := p_loan_participant_rec.HZ_PARTY_ID;
1659:
1660: open c_get_party_type(p_loan_participant_rec.HZ_PARTY_ID);