eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_PARTICIPANTS_PUB dependencies on LNS_PARTICIPANTS_PUB

Line 1: PACKAGE BODY LNS_PARTICIPANTS_PUB AS

1: PACKAGE BODY LNS_PARTICIPANTS_PUB AS
2: /* $Header: LNS_PART_PUBP_B.pls 120.20 2010/08/10 11:48:59 gparuchu ship $ */
3: G_DEBUG_COUNT CONSTANT NUMBER := 0;
4: G_DEBUG CONSTANT BOOLEAN := FALSE;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_PARTICIPANTS_PUB';

Line 5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_PARTICIPANTS_PUB';

1: PACKAGE BODY LNS_PARTICIPANTS_PUB AS
2: /* $Header: LNS_PART_PUBP_B.pls 120.20 2010/08/10 11:48:59 gparuchu ship $ */
3: G_DEBUG_COUNT CONSTANT NUMBER := 0;
4: G_DEBUG CONSTANT BOOLEAN := FALSE;
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_PARTICIPANTS_PUB';
6:
7: --------------------------------------------------
8: -- Procedure for logging debug messages
9: --------------------------------------------------

Line 408: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createParticipant';

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;
410: l_loan_id := p_loan_participant_rec.loan_id;
411: l_hz_party_id := p_loan_participant_rec.hz_party_id;
412: l_loan_participant_rec := p_loan_participant_rec;

Line 453: l_last_api_called := 'LNS_PARTICIPANTS_PUB.validateParticipant';

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');
452: END IF;
453: l_last_api_called := 'LNS_PARTICIPANTS_PUB.validateParticipant';
454: validateParticipant(p_loan_participant_rec => p_loan_participant_rec,
455: p_mode => 'CREATE',
456: x_return_status => l_return_status,
457: x_msg_count => l_msg_count,

Line 481: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';

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');
481: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';
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);

Line 501: l_last_api_called := 'LNS_PARTICIPANTS_PUB.do_create_participant';

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

Line 572: l_last_api_called := 'LNS_PARTICIPANTS_PUB.updateParticipant';

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;
574: savepoint updateParticipant;
575:
576: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN

Line 770: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createAppealCreditRequest';

766:
767: BEGIN
768: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
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;

Line 790: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';

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

Line 808: l_last_api_called := 'LNS_PARTICIPANTS_PUB.updateParticipant';

804: --new credit request has not been submitted!
805: return;
806: end if;
807:
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,

Line 919: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';

915: BEGIN
916:
917: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
918:
919: l_last_api_called := 'LNS_PARTICIPANTS_PUB.createCreditRequest';
920: l_participant_type := p_loan_participant_rec.LOAN_PARTICIPANT_TYPE;
921: l_loan_id := p_loan_participant_rec.loan_id;
922: l_credit_request_id := null;
923: l_review_type := p_loan_participant_rec.REVIEW_TYPE;

Line 1181: l_last_api_called := 'LNS_PARTICIPANTS_PUB.denormalizePrimaryInfo';

1177: WHERE LOAN_ID = pLoanId;
1178:
1179: BEGIN
1180: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');
1181: l_last_api_called := 'LNS_PARTICIPANTS_PUB.denormalizePrimaryInfo';
1182: l_participant_type := p_loan_participant_rec.LOAN_PARTICIPANT_TYPE;
1183: l_loan_id := p_loan_participant_rec.loan_id;
1184:
1185: -- Standard Start of API savepoint

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

1408: return l_return_flag;
1409: end if;
1410:
1411: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1412: 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');
1413: END IF;
1414:
1415: l_user_id := LNS_UTILITY_PUB.created_by;
1416: l_login_id := LNS_UTILITY_PUB.last_update_login;

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

1427: WHERE PARTICIPANT_ID = case_folder_rec.participant_id;
1428: END LOOP;
1429:
1430: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1431: 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');
1432: END IF;
1433:
1434: --Call to record history
1435: LNS_LOAN_HISTORY_PUB.log_record_pre(

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

1438: p_table_name => 'LNS_LOAN_HEADERS_ALL'
1439: );
1440:
1441: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1442: 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');
1443: END IF;
1444:
1445: UPDATE LNS_LOAN_HEADERS_ALL
1446: SET SECONDARY_STATUS = 'CREDIT_REVIEW_COMPLETE',

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

1454: FROM LNS_PARTICIPANTS
1455: WHERE loan_id = LNS_LOAN_HEADERS_ALL.loan_id and hz_party_id = LNS_LOAN_HEADERS_ALL.primary_borrower_id);
1456:
1457: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1458: 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');
1459: END IF;
1460:
1461: --Call to record history
1462: LNS_LOAN_HISTORY_PUB.log_record_post(

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

1483: EXCEPTION
1484: WHEN OTHERS THEN
1485:
1486: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1487: 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);
1488: END IF;
1489:
1490: return l_return_flag;
1491:

Line 1556: l_update_status_flag := LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE(l_loan_id);

1552: MO_GLOBAL.set_policy_context('S',l_org_id);
1553:
1554: IF (l_source_name = 'LNS') THEN
1555: l_loan_id := l_source_column1;
1556: l_update_status_flag := LNS_PARTICIPANTS_PUB.CASE_FOLDER_UPDATE(l_loan_id);
1557:
1558: if (l_update_status_flag NOT IN ('I', 'Y')) then
1559: l_wf_return_status := 'ERROR';
1560: end if;

Line 1675: END LNS_PARTICIPANTS_PUB;

1671: END getDefaultPrimaryContact;
1672:
1673:
1674:
1675: END LNS_PARTICIPANTS_PUB;