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_LOG

Line 17: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

13: is
14:
15: begin
16:
17: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
18: FND_LOG.STRING(log_level, module, message);
19: END IF;
20:
21: end;

Line 18: FND_LOG.STRING(log_level, module, message);

14:
15: begin
16:
17: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
18: FND_LOG.STRING(log_level, module, message);
19: END IF;
20:
21: end;
22:

Line 103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

99: l_last_api_called varchar2(500); --Store the last api that was called before exception
100:
101: BEGIN
102:
103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
104: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_mode: ' || p_mode);
105:
106:
107: l_last_api_called := 'validateParticipant';

Line 104: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_mode: ' || p_mode);

100:
101: BEGIN
102:
103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
104: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_mode: ' || p_mode);
105:
106:
107: l_last_api_called := 'validateParticipant';
108: l_participant_id := p_loan_participant_rec.participant_id;

Line 260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

256: end if;
257: end if;
258:
259:
260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
261: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'create participant validation passed OK');
262: END IF;
263:
264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

Line 261: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'create participant validation passed OK');

257: end if;
258:
259:
260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
261: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'create participant validation passed OK');
262: END IF;
263:
264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
265:

Line 264: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

260: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
261: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'create participant validation passed OK');
262: END IF;
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;

Line 294: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

290: l_msg_data VARCHAR2(2000);
291: l_return_Status VARCHAR2(1);
292: l_api_name CONSTANT VARCHAR2(30) := 'do_create_participant';
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:

Line 341: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

337: );
338: --dbms_output.put_line('after tblH');
339: x_participant_id := p_loan_participant_rec.PARTICIPANT_ID;
340:
341: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_participant procedure: After call to lns_participants_pkg.Insert_Row');
343: END IF;
344: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
345:

Line 342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_participant procedure: After call to lns_participants_pkg.Insert_Row');

338: --dbms_output.put_line('after tblH');
339: x_participant_id := p_loan_participant_rec.PARTICIPANT_ID;
340:
341: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_participant procedure: After call to lns_participants_pkg.Insert_Row');
343: END IF;
344: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
345:
346: END do_create_participant;

Line 344: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

340:
341: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
342: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In do_create_participant procedure: After call to lns_participants_pkg.Insert_Row');
343: END IF;
344: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
345:
346: END do_create_participant;
347:
348:

Line 400: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

396:
397:
398: BEGIN
399:
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;

Line 449: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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');
451: END IF;
452: l_last_api_called := 'LNS_PARTICIPANTS_PUB.validateParticipant';
453: validateParticipant(p_loan_participant_rec => p_loan_participant_rec,

Line 450: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In createParticipant: Before call to validateParticipant');

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');
451: END IF;
452: l_last_api_called := 'LNS_PARTICIPANTS_PUB.validateParticipant';
453: validateParticipant(p_loan_participant_rec => p_loan_participant_rec,
454: p_mode => 'CREATE',

Line 458: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

454: p_mode => 'CREATE',
455: x_return_status => l_return_status,
456: x_msg_count => l_msg_count,
457: x_msg_data => l_msg_data);
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

Line 459: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In createParticipant: After call to validateParticipant');

455: x_return_status => l_return_status,
456: x_msg_count => l_msg_count,
457: x_msg_data => l_msg_data);
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;

Line 479: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling createCreditRequest');

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');
480: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';
481: createCreditRequest(p_loan_participant_rec => l_loan_participant_rec,
482: x_return_status => l_return_status,
483: x_msg_count => l_msg_count,

Line 488: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling createCreditRequest');

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
491: --default the credit_request_id to -1 for the financial data component
492: l_loan_participant_rec.credit_request_id := -1;

Line 495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

491: --default the credit_request_id to -1 for the financial data component
492: l_loan_participant_rec.credit_request_id := -1;
493: end if; -- end 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
494:
495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_participant procedure');
497: END IF;
498:
499: -- call to business logic.

Line 496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_participant procedure');

492: l_loan_participant_rec.credit_request_id := -1;
493: end if; -- end 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
494:
495: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
496: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin do_create_participant procedure');
497: END IF;
498:
499: -- call to business logic.
500: l_last_api_called := 'LNS_PARTICIPANTS_PUB.do_create_participant';

Line 501: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling do_create_participant');

497: END IF;
498:
499: -- call to business logic.
500: l_last_api_called := 'LNS_PARTICIPANTS_PUB.do_create_participant';
501: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling do_create_participant');
502: do_create_participant(
503: l_loan_participant_rec,
504: x_participant_id,
505: x_return_status

Line 508: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call do_create_participant');

504: x_participant_id,
505: x_return_status
506: );
507:
508: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call do_create_participant');
509:
510: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling denormalizePrimaryInfo');
511: denormalizePrimaryInfo(p_loan_participant_rec => l_loan_participant_rec,
512: x_return_status => l_return_status,

Line 510: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling denormalizePrimaryInfo');

506: );
507:
508: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After call do_create_participant');
509:
510: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling denormalizePrimaryInfo');
511: denormalizePrimaryInfo(p_loan_participant_rec => l_loan_participant_rec,
512: x_return_status => l_return_status,
513: x_msg_count => l_msg_count,
514: x_msg_data => l_msg_data);

Line 515: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling denormalizePrimaryInfo');

511: denormalizePrimaryInfo(p_loan_participant_rec => l_loan_participant_rec,
512: x_return_status => l_return_status,
513: x_msg_count => l_msg_count,
514: x_msg_data => l_msg_data);
515: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling denormalizePrimaryInfo');
516:
517: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
518:
519: Exception

Line 517: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

513: x_msg_count => l_msg_count,
514: x_msg_data => l_msg_data);
515: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling denormalizePrimaryInfo');
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;

Line 564: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

560: l_loan_participant_rec loan_participant_rec_type;
561: l_last_api_called varchar2(500); --Store the last api that was called before exception
562: l_api_name CONSTANT VARCHAR2(30) := 'updateParticipant';
563: BEGIN
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;

Line 575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

571: l_last_api_called := 'LNS_PARTICIPANTS_PUB.updateParticipant';
572: l_loan_participant_rec := p_loan_participant_rec;
573: savepoint updateParticipant;
574:
575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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.

Line 576: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Begin update participant');

572: l_loan_participant_rec := p_loan_participant_rec;
573: savepoint updateParticipant;
574:
575: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) 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

Line 632: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'Before calling validateParticipant');

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,
635: p_mode => 'UPDATE',
636: x_return_status => l_return_status,

Line 643: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling validateParticipant');

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
646:
647:

Line 648: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'Before calling LNS_PARTICIPANTS_PKG.Update_Row');

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';
650: LNS_PARTICIPANTS_PKG.Update_Row(x_rowid => l_rowid
651: ,p_PARTICIPANT_ID => l_loan_participant_rec.PARTICIPANT_ID
652: ,p_LOAN_ID => l_loan_participant_rec.LOAN_ID

Line 688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'After calling LNS_PARTICIPANTS_PKG.Update_Row');

684: ,p_CASE_FOLDER_ID => l_loan_participant_rec.CASE_FOLDER_ID
685: ,p_REVIEW_TYPE => l_loan_participant_rec.REVIEW_TYPE
686: ,p_CREDIT_CLASSIFICATION => l_loan_participant_rec.CREDIT_CLASSIFICATION
687: );
688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'After calling LNS_PARTICIPANTS_PKG.Update_Row');
689:
690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling denormalizePrimaryInfo');
691: denormalizePrimaryInfo(p_loan_participant_rec => l_loan_participant_rec,
692: x_return_status => l_return_status,

Line 690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling denormalizePrimaryInfo');

686: ,p_CREDIT_CLASSIFICATION => l_loan_participant_rec.CREDIT_CLASSIFICATION
687: );
688: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || 'After calling LNS_PARTICIPANTS_PKG.Update_Row');
689:
690: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling denormalizePrimaryInfo');
691: denormalizePrimaryInfo(p_loan_participant_rec => l_loan_participant_rec,
692: x_return_status => l_return_status,
693: x_msg_count => l_msg_count,
694: x_msg_data => l_msg_data);

Line 695: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling denormalizePrimaryInfo');

691: denormalizePrimaryInfo(p_loan_participant_rec => l_loan_participant_rec,
692: x_return_status => l_return_status,
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');

Line 699: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

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
702: WHEN FND_API.G_EXC_ERROR THEN
703: x_return_status := FND_API.G_RET_STS_ERROR;

Line 766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

762: LNS_LOAN_HEADERS_ALL
763: WHERE LOAN_ID = pLoanId;
764:
765: BEGIN
766: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
767:
768: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createAppealCreditRequest';
769: -- Standard Start of API savepoint
770: SAVEPOINT createAppealCreditRequest;

Line 787: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling ');

783: if (l_old_credit_request_id is null) then
784: return;
785: end if;
786:
787: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling ');
788: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';
789: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
790: createCreditRequest(p_loan_participant_rec => l_loan_participant_rec,
791: x_return_status => l_return_status,

Line 789: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

785: end if;
786:
787: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling ');
788: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';
789: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);
790: createCreditRequest(p_loan_participant_rec => l_loan_participant_rec,
791: x_return_status => l_return_status,
792: x_msg_count => l_msg_count,
793: x_msg_data => l_msg_data);

Line 798: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

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;
801: if (l_old_credit_request_id = l_new_credit_request_id) then
802: --new credit request has not been submitted!

Line 807: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

803: return;
804: end if;
805:
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,

Line 820: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

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;
823: l_loan_header_rec.secondary_status := FND_API.G_MISS_CHAR;
824: open C_GET_LOAN_OVN(l_loan_id);

Line 828: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

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

Line 842: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

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');
845:
846:

Line 844: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

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');
845:
846:
847: EXCEPTION
848: WHEN FND_API.G_EXC_ERROR THEN

Line 915: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

911: where loan_id = p_loan_id;
912:
913: BEGIN
914:
915: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
916:
917: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';
918: l_participant_type := p_loan_participant_rec.LOAN_PARTICIPANT_TYPE;
919: l_loan_id := p_loan_participant_rec.loan_id;

Line 955: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

951: --need to call credit request api
952: --if (AR_CMGT_CREDIT_REQUEST_API.IS_CREDIT_MANAGEMENT_INSTALLED = true) then
953:
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

Line 1000: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

996: ,P_SCORE_MODEL_ID => null
997: ,P_PARENT_CREDIT_REQUEST_ID => l_parent_credit_request_id
998: ,P_CREDIT_REQUEST_TYPE => l_credit_request_type
999: );
1000: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
1001:
1002: x_return_status := l_return_status;
1003: x_msg_count := l_msg_count;
1004: x_msg_data := l_msg_data;

Line 1046: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1042: and end_date_active is null;
1043:
1044: if (l_parent_credit_request_id is not null) then
1045:
1046: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1047: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In checkPrimary: Before calling OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST api');
1048: END IF;
1049:
1050: --Create Credit Request for Guarantor

Line 1047: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In checkPrimary: Before calling OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST api');

1043:
1044: if (l_parent_credit_request_id is not null) then
1045:
1046: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1047: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In checkPrimary: Before calling OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST api');
1048: END IF;
1049:
1050: --Create Credit Request for Guarantor
1051: l_last_api_called := 'OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST';

Line 1052: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

1048: END IF;
1049:
1050: --Create Credit Request for Guarantor
1051: l_last_api_called := 'OCM_GUARANTOR_PUB.CREATE_GUARANTOR_CREDITREQUEST';
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

Line 1103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

1099: ,P_VALUATION_DATE => null
1100: ,P_ACQUISITION_DATE => null
1101: ,P_ASSET_IDENTIFIER => null
1102: );
1103: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
1104:
1105:
1106: x_return_status := l_return_status;
1107: x_msg_count := l_msg_count;

Line 1123: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

1119: end if; -- if (p_loan_participant_rec.credit_request_id is null) then
1120:
1121: end if; --if (l_participant_type = 'PRIMARY_BORROWER') 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;

Line 1178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

1174: LNS_LOAN_HEADERS_ALL
1175: WHERE LOAN_ID = pLoanId;
1176:
1177: BEGIN
1178: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1179: l_last_api_called := 'LNS_PARTICIPANTS_PUB.denormalizePrimaryInfo';
1180: l_participant_type := p_loan_participant_rec.LOAN_PARTICIPANT_TYPE;
1181: l_loan_id := p_loan_participant_rec.loan_id;
1182:

Line 1201: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

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

Line 1208: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

1204: ,P_OBJECT_VERSION_NUMBER => l_object_version
1205: ,X_RETURN_STATUS => x_return_status
1206: ,X_MSG_COUNT => x_msg_count
1207: ,X_MSG_DATA => x_msg_data);
1208: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
1209: x_return_status := l_return_status;
1210: x_msg_count := l_msg_count;
1211: x_msg_data := l_msg_data;
1212: end if; -- end if (l_participant_type = 'PRIMARY_BORROWER') then

Line 1213: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

1209: x_return_status := l_return_status;
1210: x_msg_count := l_msg_count;
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');

Line 1273: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

1269: l_object_version number;
1270:
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);

Line 1283: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1279: close C_GET_PRIMARY_CREQ_ID;
1280:
1281: if (l_primary_credit_request_id is not null) then
1282:
1283: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In submitCreditRequest: Before calling OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status api');
1285: END IF;
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);

Line 1284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In submitCreditRequest: Before calling OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status api');

1280:
1281: if (l_primary_credit_request_id is not null) then
1282:
1283: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In submitCreditRequest: Before calling OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status api');
1285: END IF;
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 (

Line 1287: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

1283: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1284: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In submitCreditRequest: Before calling OCM_CREDIT_REQUEST_UPDATE_PUB.update_credit_request_status api');
1285: END IF;
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,

Line 1298: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

1294: x_msg_count => x_msg_count,
1295: x_msg_data => x_msg_data,
1296: p_credit_request_id => l_primary_credit_request_id,
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;

Line 1308: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

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

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

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

Line 1313: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - Before calling '|| l_last_api_called);

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

Line 1321: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);

1317: ,P_OBJECT_VERSION_NUMBER => l_object_version
1318: ,X_RETURN_STATUS => x_return_status
1319: ,X_MSG_COUNT => x_msg_count
1320: ,X_MSG_DATA => x_msg_data);
1321: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - After calling '|| l_last_api_called);
1322:
1323: COMMIT;
1324:
1325: else

Line 1341: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

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;
1343:
1344:
1345: ----------------------------------------------------------------

Line 1389: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

1385: AND type = 'CASE'
1386: AND status = 'CLOSED';
1387:
1388: BEGIN
1389: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1390:
1391: l_return_flag := 'N';
1392:
1393: open check_loan_sec_status(p_loan_id);

Line 1409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1405: l_return_flag := 'I';
1406: return l_return_flag;
1407: end if;
1408:
1409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_participants to update case_folder_id');
1411: END IF;
1412:
1413: l_user_id := LNS_UTILITY_PUB.created_by;

Line 1410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_participants to update case_folder_id');

1406: return l_return_flag;
1407: end if;
1408:
1409: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1410: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_participants to update case_folder_id');
1411: END IF;
1412:
1413: l_user_id := LNS_UTILITY_PUB.created_by;
1414: l_login_id := LNS_UTILITY_PUB.last_update_login;

Line 1428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1424: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1
1425: WHERE PARTICIPANT_ID = case_folder_rec.participant_id;
1426: END LOOP;
1427:
1428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_participants to update case_folder_id');
1430: END IF;
1431:
1432: --Call to record history

Line 1429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_participants to update case_folder_id');

1425: WHERE PARTICIPANT_ID = case_folder_rec.participant_id;
1426: END LOOP;
1427:
1428: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1429: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_participants to update case_folder_id');
1430: END IF;
1431:
1432: --Call to record history
1433: LNS_LOAN_HISTORY_PUB.log_record_pre(

Line 1439: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1435: p_primary_key_name => 'LOAN_ID',
1436: p_table_name => 'LNS_LOAN_HEADERS_ALL'
1437: );
1438:
1439: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_loan_headers_all to update new secondary status');
1441: END IF;
1442:
1443: UPDATE LNS_LOAN_HEADERS_ALL

Line 1440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_loan_headers_all to update new secondary status');

1436: p_table_name => 'LNS_LOAN_HEADERS_ALL'
1437: );
1438:
1439: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1440: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Before calling update for lns_loan_headers_all to update new secondary status');
1441: END IF;
1442:
1443: UPDATE LNS_LOAN_HEADERS_ALL
1444: SET SECONDARY_STATUS = 'CREDIT_REVIEW_COMPLETE',

Line 1455: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1451: AND EXISTS (SELECT case_folder_id
1452: FROM LNS_PARTICIPANTS
1453: WHERE loan_id = LNS_LOAN_HEADERS_ALL.loan_id and hz_party_id = LNS_LOAN_HEADERS_ALL.primary_borrower_id);
1454:
1455: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1456: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_loan_headers_all to update new secondary status');
1457: END IF;
1458:
1459: --Call to record history

Line 1456: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_loan_headers_all to update new secondary status');

1452: FROM LNS_PARTICIPANTS
1453: WHERE loan_id = LNS_LOAN_HEADERS_ALL.loan_id and hz_party_id = LNS_LOAN_HEADERS_ALL.primary_borrower_id);
1454:
1455: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1456: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: After calling update for lns_loan_headers_all to update new secondary status');
1457: END IF;
1458:
1459: --Call to record history
1460: LNS_LOAN_HISTORY_PUB.log_record_post(

Line 1477: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

1473: if (l_secondary_status = 'CREDIT_REVIEW_COMPLETE') then
1474: l_return_flag := 'Y';
1475: end if;
1476:
1477: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1478:
1479: return l_return_flag;
1480:
1481: EXCEPTION

Line 1484: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1480:
1481: EXCEPTION
1482: WHEN OTHERS THEN
1483:
1484: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Unexpected ERROR in the function call. SQLERRM is: ' || SQLERRM);
1486: END IF;
1487:
1488: return l_return_flag;

Line 1485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Unexpected ERROR in the function call. SQLERRM is: ' || SQLERRM);

1481: EXCEPTION
1482: WHEN OTHERS THEN
1483:
1484: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1485: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE: Unexpected ERROR in the function call. SQLERRM is: ' || SQLERRM);
1486: END IF;
1487:
1488: return l_return_flag;
1489:

Line 1578: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1574: open C_GET_LOAN_OVN(l_loan_id);
1575: fetch C_GET_LOAN_OVN into l_object_version;
1576: close C_GET_LOAN_OVN;
1577:
1578: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1579: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In OCM_WORKFLOW_CREDIT_RECO_EVENT: Before calling lns_loan_header_pub.update_loan api');
1580: END IF;
1581:
1582: lns_loan_header_pub.update_loan(

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

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

Line 1596: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

1592: else
1593: COMMIT;
1594: end if;
1595:
1596: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1597: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'In OCM_WORKFLOW_CREDIT_RECO_EVENT: After calling lns_loan_header_pub.update_loan api: return_status:'||l_return_status);
1598: END IF;
1599:
1600:

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

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

Line 1645: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

1641: where party_id = p_party_id;
1642:
1643: BEGIN
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;

Line 1646: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, p_loan_participant_rec.LOAN_PARTICIPANT_TYPE);

1642:
1643: BEGIN
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:

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

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

Line 1655: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Contact Person and PartyId are NULL');

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);
1659: fetch c_get_party_type into l_party_type;

Line 1662: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Party Type is '||l_party_type ||' for '||p_loan_participant_rec.HZ_PARTY_ID);

1658: open c_get_party_type(p_loan_participant_rec.HZ_PARTY_ID);
1659: fetch c_get_party_type into l_party_type;
1660: close c_get_party_type;
1661:
1662: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Party Type is '||l_party_type ||' for '||p_loan_participant_rec.HZ_PARTY_ID);
1663: IF l_party_type = 'PERSON' THEN
1664: p_loan_participant_rec.CONTACT_PERS_PARTY_ID := p_loan_participant_rec.HZ_PARTY_ID;
1665: END IF;
1666: END IF;

Line 1667: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');

1663: IF l_party_type = 'PERSON' THEN
1664: p_loan_participant_rec.CONTACT_PERS_PARTY_ID := p_loan_participant_rec.HZ_PARTY_ID;
1665: END IF;
1666: END IF;
1667: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
1668:
1669: END getDefaultPrimaryContact;
1670:
1671: