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 404: l_init_msg_list := FND_API.G_FALSE;

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

Line 416: IF FND_API.to_Boolean(l_init_msg_list) THEN

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

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

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

Line 446: RAISE FND_API.G_EXC_ERROR;

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

Line 462: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 475: RAISE FND_API.G_EXC_ERROR;

471: FETCH CheckDupParty INTO l_dup_party_count;
472: IF (l_dup_party_count > 0) THEN
473: FND_MESSAGE.SET_NAME('LNS', 'LNS_PARTICIPANT_DUP_PARTY');
474: FND_MSG_PUB.ADD;
475: RAISE FND_API.G_EXC_ERROR;
476: END IF;
477:
478: 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
479: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling createCreditRequest');

Line 485: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 520: WHEN FND_API.G_EXC_ERROR THEN

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

Line 521: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 528: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 529: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 537: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 568: l_init_msg_list := FND_API.G_FALSE;

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

Line 580: IF FND_API.to_Boolean(l_init_msg_list) THEN

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

Line 617: RAISE FND_API.G_EXC_ERROR;

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

Line 627: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 640: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 641: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

Line 697: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 702: WHEN FND_API.G_EXC_ERROR THEN

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

Line 703: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 710: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 711: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 719: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 771: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 795: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 810: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

Line 817: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

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

Line 818: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

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

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

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

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

Line 840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 848: WHEN FND_API.G_EXC_ERROR THEN

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

Line 849: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 856: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 857: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 865: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 926: x_return_status := FND_API.G_RET_STS_SUCCESS;

922: l_credit_classification := p_loan_participant_rec.CREDIT_CLASSIFICATION;
923:
924: -- Standard Start of API savepoint
925: SAVEPOINT createCreditRequest;
926: x_return_status := FND_API.G_RET_STS_SUCCESS;
927:
928: open c_get_loan_info(l_loan_id);
929: 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;
930: close c_get_loan_info;

Line 958: ,P_INIT_MSG_LIST => FND_API.G_FALSE

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

Line 959: ,P_COMMIT => FND_API.G_FALSE

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

Line 960: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL

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

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

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

Line 1008: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1056: ,P_INIT_MSG_LIST => FND_API.G_FALSE

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

Line 1057: ,P_COMMIT => FND_API.G_FALSE

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

Line 1058: ,P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL

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

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

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

Line 1112: RAISE FND_API.G_EXC_ERROR;

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

Line 1126: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1127: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1134: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1135: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1143: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1187: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 1216: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 1224: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1232: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1275: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1290: p_init_msg_list => FND_API.G_TRUE,

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

Line 1291: p_commit => FND_API.G_TRUE,

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

Line 1292: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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

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

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

Line 1315: p_init_msg_list => FND_API.G_TRUE

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

Line 1330: RAISE FND_API.G_EXC_ERROR;

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

Line 1338: RAISE FND_API.G_EXC_ERROR;

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

Line 1583: p_init_msg_list => FND_API.G_TRUE

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

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

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

Line 1648: x_return_status := FND_API.G_RET_STS_ERROR;

1644:
1645: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1646: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, p_loan_participant_rec.LOAN_PARTICIPANT_TYPE);
1647: IF p_loan_participant_rec.LOAN_PARTICIPANT_TYPE <> 'PRIMARY_BORROWER' THEN
1648: x_return_status := FND_API.G_RET_STS_ERROR;
1649: END IF;
1650:
1651: 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);
1652:

Line 1653: 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

1649: END IF;
1650:
1651: 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);
1652:
1653: 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
1654: (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
1655: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person and PartyId are NULL');
1656: p_loan_participant_rec.CONTACT_REL_PARTY_ID := p_loan_participant_rec.HZ_PARTY_ID;
1657:

Line 1654: (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

1650:
1651: 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);
1652:
1653: 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
1654: (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
1655: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person and PartyId are NULL');
1656: p_loan_participant_rec.CONTACT_REL_PARTY_ID := p_loan_participant_rec.HZ_PARTY_ID;
1657:
1658: open c_get_party_type(p_loan_participant_rec.HZ_PARTY_ID);