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_UTILITY_PUB dependencies on FND_LOG

Line 18: IF log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

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

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

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

Line 533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);

529: WHERE fndc.currency_code = p_to_currency;
530: begin
531:
532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

Line 534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);

530: begin
531:
532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

Line 535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);

531:
532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:

Line 536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);

532: l_api_name := 'convertAmount';
533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:
540: if p_to_currency is null then

Line 537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

533: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:
540: if p_to_currency is null then
541: SELECT sb.currency_code into l_to_currency

Line 538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

534: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
535: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_to_currency ' || p_to_currency);
536: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_type ' || p_exchange_type);
537: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
538: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
539:
540: if p_to_currency is null then
541: SELECT sb.currency_code into l_to_currency
542: FROM lns_system_options so,

Line 580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);

576: X_TO_CURRENCY => p_to_currency,
577: X_CONVERSION_DATE => p_exchange_date,
578: X_CONVERSION_TYPE => p_exchange_type);
579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

Line 581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);

577: X_CONVERSION_DATE => p_exchange_date,
578: X_CONVERSION_TYPE => p_exchange_type);
579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

Line 582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);

578: X_CONVERSION_TYPE => p_exchange_type);
579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:

Line 583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);

579: */
580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');

Line 584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);

580: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_amount ' || p_from_amount);
581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');
588: l_convert_amount := gl_currency_api.convert_amount(X_FROM_CURRENCY => p_from_currency

Line 585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);

581: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_from_currency ' || p_from_currency);
582: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_to_currency ' || l_to_currency);
583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');
588: l_convert_amount := gl_currency_api.convert_amount(X_FROM_CURRENCY => p_from_currency
589: ,X_TO_CURRENCY => l_to_currency

Line 587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');

583: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_exchange_type ' || l_exchange_type);
584: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_date ' || p_exchange_date);
585: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - p_exchange_rate ' || p_exchange_rate);
586:
587: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calling gl_currency API....');
588: l_convert_amount := gl_currency_api.convert_amount(X_FROM_CURRENCY => p_from_currency
589: ,X_TO_CURRENCY => l_to_currency
590: ,X_CONVERSION_DATE => l_exchange_date
591: ,X_CONVERSION_TYPE => l_exchange_type

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

1002: l_compile_state VARCHAR2(200);
1003: l_return boolean;
1004: BEGIN
1005:
1006: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1007:
1008: OPEN Check_MV_Exists(l_entity_name);
1009: FETCH Check_MV_Exists INTO l_mv_name,l_compile_state;
1010: CLOSE Check_MV_Exists;

Line 1030: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' : Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');

1026: end if; --if (l_compile_state <> 'VALID') then
1027:
1028: else
1029:
1030: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' : Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1031: fnd_file.put_line(FND_FILE.LOG,
1032: 'Materialized View '|| l_entity_name || 'NOT FOUND - nothing to refresh');
1033: fnd_file.put_line(FND_FILE.LOG,
1034: 'Exiting program without performing any action');

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

1039: message => 'Materialized View Refresh has failed. Please review log file.');
1040:
1041: end if; --if (l_mv_name is not null) then
1042:
1043: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1044:
1045: EXCEPTION
1046: when others then
1047: fnd_file.put_line(FND_FILE.LOG,

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

1080:
1081: BEGIN
1082: l_is_pending := 'N';
1083:
1084: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1085:
1086: open C_CHECK_CP_REQ;
1087: fetch C_CHECK_CP_REQ into l_request_id;
1088: close C_CHECK_CP_REQ;

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

1090: if (l_request_id IS NOT NULL) then
1091: l_is_pending := 'Y';
1092: end if;
1093:
1094: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1095:
1096: return l_is_pending;
1097:
1098: END is_concurrent_request_pending;

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

1105: l_customer_contact_flag VARCHAR2(1) ;
1106: l_api_name CONSTANT VARCHAR2(30) := 'IS_CUSTOMER_CONTACT';
1107:
1108: BEGIN
1109: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1110: l_customer_contact_flag := 'N' ;
1111:
1112: SELECT 'Y' INTO l_customer_contact_flag
1113: FROM hz_parties party, fnd_user fnduser

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

1115: AND party.status ='A'
1116: AND fnduser.customer_id = party.party_id
1117: AND fnduser.user_id = p_fnd_user_id;
1118:
1119: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1120: return l_customer_contact_flag ;
1121: EXCEPTION
1122: WHEN NO_DATA_FOUND THEN
1123: l_customer_contact_flag := 'N' ;

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

1141: l_subject_id NUMBER;
1142: l_api_name CONSTANT VARCHAR2(30) := 'CUSTOMER_CONTACT_LOANS_COUNT';
1143: l_org_id NUMBER;
1144: BEGIN
1145: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' ORGID - ' || p_org_id);
1147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' FND_USER_ID - ' || p_fnd_user_id);
1148: l_number_of_loans := 0 ;
1149: l_fnd_user_id := p_fnd_user_id;

Line 1146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' ORGID - ' || p_org_id);

1142: l_api_name CONSTANT VARCHAR2(30) := 'CUSTOMER_CONTACT_LOANS_COUNT';
1143: l_org_id NUMBER;
1144: BEGIN
1145: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' ORGID - ' || p_org_id);
1147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' FND_USER_ID - ' || p_fnd_user_id);
1148: l_number_of_loans := 0 ;
1149: l_fnd_user_id := p_fnd_user_id;
1150: l_subject_id := -1;

Line 1147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' FND_USER_ID - ' || p_fnd_user_id);

1143: l_org_id NUMBER;
1144: BEGIN
1145: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :BEGIN');
1146: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' ORGID - ' || p_org_id);
1147: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' FND_USER_ID - ' || p_fnd_user_id);
1148: l_number_of_loans := 0 ;
1149: l_fnd_user_id := p_fnd_user_id;
1150: l_subject_id := -1;
1151: l_org_id := p_org_id;

Line 1161: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' Subject_ID - ' || l_subject_id);

1157: AND party.status ='A'
1158: AND fnduser.customer_id = party.party_id
1159: AND fnduser.user_id = l_fnd_user_id;
1160:
1161: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, ' Subject_ID - ' || l_subject_id);
1162:
1163: SELECT count(participant.loan_id) INTO l_number_of_loans
1164: FROM lns_participants participant, LNS_LOAN_HEADERS_ALL header
1165: WHERE participant.loan_participant_type in ('PRIMARY_BORROWER','COBORROWER','GUARANTOR')

Line 1186: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,' Loan Count - ' || l_number_of_loans);

1182: 'GUARANTOR',fnd_profile.value('LNS_GUAR_ACCESS_LEVEL'))) <> 'NO_ACCESS'
1183: AND header.loan_status in ('INCOMPLETE','ACTIVE', 'APPROVED', 'DEFAULT', 'DELINQUENT', 'IN_FUNDING', 'PAIDOFF', 'PENDING_CANCELLATION')
1184: AND participant.hz_party_id = p_borrower_id;
1185:
1186: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,' Loan Count - ' || l_number_of_loans);
1187: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1188:
1189: return l_number_of_loans ;
1190: EXCEPTION

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

1183: AND header.loan_status in ('INCOMPLETE','ACTIVE', 'APPROVED', 'DEFAULT', 'DELINQUENT', 'IN_FUNDING', 'PAIDOFF', 'PENDING_CANCELLATION')
1184: AND participant.hz_party_id = p_borrower_id;
1185:
1186: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,' Loan Count - ' || l_number_of_loans);
1187: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' :END');
1188:
1189: return l_number_of_loans ;
1190: EXCEPTION
1191: WHEN NO_DATA_FOUND THEN