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_BORROWERS_SUMMARY_PUB dependencies on FND_API

Line 588: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

584: SAVEPOINT PROCESS_SINGLE_LOAN_PVT;
585: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');
586:
587: -- Standard call to check for call compatibility
588: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE

Line 589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

585: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');
586:
587: -- Standard call to check for call compatibility
588: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE
593: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 593: IF FND_API.To_Boolean(p_init_msg_list) THEN

589: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
590: END IF;
591:
592: -- Initialize message list if p_init_msg_list is set to TRUE
593: IF FND_API.To_Boolean(p_init_msg_list) THEN
594: FND_MSG_PUB.initialize;
595: END IF;
596:
597: -- Initialize API return status to success

Line 598: l_return_status := FND_API.G_RET_STS_SUCCESS;

594: FND_MSG_PUB.initialize;
595: END IF;
596:
597: -- Initialize API return status to success
598: l_return_status := FND_API.G_RET_STS_SUCCESS;
599:
600: -- START OF BODY OF API
601:
602: l_Count := 0;

Line 801: if P_COMMIT = FND_API.G_TRUE then

797: END LOOP;
798:
799: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Success!');
800:
801: if P_COMMIT = FND_API.G_TRUE then
802: COMMIT WORK;
803: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited borrower');
804: end if;
805:

Line 807: x_return_status := FND_API.G_RET_STS_SUCCESS;

803: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited borrower');
804: end if;
805:
806: -- END OF BODY OF API
807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808:
809: -- Standard call to get message count and if count is 1, get message info
810: FND_MSG_PUB.Count_And_Get(
811: p_encoded => FND_API.G_FALSE,

Line 811: p_encoded => FND_API.G_FALSE,

807: x_return_status := FND_API.G_RET_STS_SUCCESS;
808:
809: -- Standard call to get message count and if count is 1, get message info
810: FND_MSG_PUB.Count_And_Get(
811: p_encoded => FND_API.G_FALSE,
812: p_count => x_msg_count,
813: p_data => x_msg_data);
814:
815: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully processed borrower');

Line 819: WHEN FND_API.G_EXC_ERROR THEN

815: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully processed borrower');
816: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
817:
818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
823: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');

Line 821: x_return_status := FND_API.G_RET_STS_ERROR;

817:
818: EXCEPTION
819: WHEN FND_API.G_EXC_ERROR THEN
820: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
823: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;

Line 824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

820: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
821: x_return_status := FND_API.G_RET_STS_ERROR;
822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
823: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
828: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');

Line 826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

822: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
823: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
824: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
825: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
826: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
828: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
829: WHEN OTHERS THEN
830: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;

Line 831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

827: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
828: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
829: WHEN OTHERS THEN
830: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
831: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
832: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
833: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
834: END IF;
835: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 889: P_INIT_MSG_LIST => FND_API.G_TRUE,

885: LogMessage(FND_LOG.LEVEL_STATEMENT, '<<--------Generating borrowers summary...-------->>');
886:
887: GENERATE_BORROWERS_SUMMARY(
888: P_API_VERSION => 1.0,
889: P_INIT_MSG_LIST => FND_API.G_TRUE,
890: P_COMMIT => FND_API.G_TRUE,
891: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
892: P_BORROWER_PARTY_ID => BORROWER_PARTY_ID,
893: X_RETURN_STATUS => RETCODE,

Line 890: P_COMMIT => FND_API.G_TRUE,

886:
887: GENERATE_BORROWERS_SUMMARY(
888: P_API_VERSION => 1.0,
889: P_INIT_MSG_LIST => FND_API.G_TRUE,
890: P_COMMIT => FND_API.G_TRUE,
891: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
892: P_BORROWER_PARTY_ID => BORROWER_PARTY_ID,
893: X_RETURN_STATUS => RETCODE,
894: X_MSG_COUNT => l_msg_count,

Line 891: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

887: GENERATE_BORROWERS_SUMMARY(
888: P_API_VERSION => 1.0,
889: P_INIT_MSG_LIST => FND_API.G_TRUE,
890: P_COMMIT => FND_API.G_TRUE,
891: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
892: P_BORROWER_PARTY_ID => BORROWER_PARTY_ID,
893: X_RETURN_STATUS => RETCODE,
894: X_MSG_COUNT => l_msg_count,
895: X_MSG_DATA => ERRBUF);

Line 992: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

988: SAVEPOINT GENERATE_BORR_SUM;
989: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
990:
991: -- Standard call to check for call compatibility
992: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995:
996: -- Initialize message list if p_init_msg_list is set to TRUE

Line 993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

989: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
990:
991: -- Standard call to check for call compatibility
992: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995:
996: -- Initialize message list if p_init_msg_list is set to TRUE
997: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 997: IF FND_API.To_Boolean(p_init_msg_list) THEN

993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
994: END IF;
995:
996: -- Initialize message list if p_init_msg_list is set to TRUE
997: IF FND_API.To_Boolean(p_init_msg_list) THEN
998: FND_MSG_PUB.initialize;
999: END IF;
1000:
1001: -- Initialize API return status to success

Line 1002: l_return_status := FND_API.G_RET_STS_SUCCESS;

998: FND_MSG_PUB.initialize;
999: END IF;
1000:
1001: -- Initialize API return status to success
1002: l_return_status := FND_API.G_RET_STS_SUCCESS;
1003:
1004: -- START OF BODY OF API
1005:
1006: init;

Line 1052: P_INIT_MSG_LIST => FND_API.G_FALSE,

1048: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing borrower #' || l_Count1);
1049:
1050: GEN_SINGLE_BORROWER_SUMMARY(
1051: P_API_VERSION => 1.0,
1052: P_INIT_MSG_LIST => FND_API.G_FALSE,
1053: P_COMMIT => P_COMMIT,
1054: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1055: P_BORROWER_PARTY_ID => l_borrowers_tbl(l_Count1),
1056: X_RETURN_STATUS => l_return_status,

Line 1054: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1050: GEN_SINGLE_BORROWER_SUMMARY(
1051: P_API_VERSION => 1.0,
1052: P_INIT_MSG_LIST => FND_API.G_FALSE,
1053: P_COMMIT => P_COMMIT,
1054: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1055: P_BORROWER_PARTY_ID => l_borrowers_tbl(l_Count1),
1056: X_RETURN_STATUS => l_return_status,
1057: X_MSG_COUNT => l_msg_count,
1058: X_MSG_DATA => l_msg_data);

Line 1067: if P_COMMIT = FND_API.G_TRUE then

1063:
1064: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
1065: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Total processed ' || l_Count || ' borrowers');
1066:
1067: if P_COMMIT = FND_API.G_TRUE then
1068: COMMIT WORK;
1069: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1070: end if;
1071:

Line 1073: x_return_status := FND_API.G_RET_STS_SUCCESS;

1069: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1070: end if;
1071:
1072: -- END OF BODY OF API
1073: x_return_status := FND_API.G_RET_STS_SUCCESS;
1074:
1075: -- Standard call to get message count and if count is 1, get message info
1076: FND_MSG_PUB.Count_And_Get(
1077: p_encoded => FND_API.G_FALSE,

Line 1077: p_encoded => FND_API.G_FALSE,

1073: x_return_status := FND_API.G_RET_STS_SUCCESS;
1074:
1075: -- Standard call to get message count and if count is 1, get message info
1076: FND_MSG_PUB.Count_And_Get(
1077: p_encoded => FND_API.G_FALSE,
1078: p_count => x_msg_count,
1079: p_data => x_msg_data);
1080:
1081: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 1084: WHEN FND_API.G_EXC_ERROR THEN

1080:
1081: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1082:
1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO GENERATE_BORR_SUM;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 1086: x_return_status := FND_API.G_RET_STS_ERROR;

1082:
1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: ROLLBACK TO GENERATE_BORR_SUM;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: ROLLBACK TO GENERATE_BORR_SUM;

Line 1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1085: ROLLBACK TO GENERATE_BORR_SUM;
1086: x_return_status := FND_API.G_RET_STS_ERROR;
1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: ROLLBACK TO GENERATE_BORR_SUM;
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1093: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1087: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1088: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: ROLLBACK TO GENERATE_BORR_SUM;
1091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1092: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1093: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1094: WHEN OTHERS THEN
1095: ROLLBACK TO GENERATE_BORR_SUM;

Line 1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1092: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1093: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1094: WHEN OTHERS THEN
1095: ROLLBACK TO GENERATE_BORR_SUM;
1096: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1098: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1099: END IF;
1100: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);