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.

[Home] [Help]

APPS.LNS_BORROWERS_SUMMARY_PUB dependencies on FND_API

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

566: SAVEPOINT PROCESS_SINGLE_LOAN_PVT;
567: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');
568:
569: -- Standard call to check for call compatibility
570: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE

Line 571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

567: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Established savepoint');
568:
569: -- Standard call to check for call compatibility
570: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE
575: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 575: IF FND_API.To_Boolean(p_init_msg_list) THEN

571: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
572: END IF;
573:
574: -- Initialize message list if p_init_msg_list is set to TRUE
575: IF FND_API.To_Boolean(p_init_msg_list) THEN
576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: -- Initialize API return status to success

Line 580: l_return_status := FND_API.G_RET_STS_SUCCESS;

576: FND_MSG_PUB.initialize;
577: END IF;
578:
579: -- Initialize API return status to success
580: l_return_status := FND_API.G_RET_STS_SUCCESS;
581:
582: -- START OF BODY OF API
583:
584: l_Count := 0;

Line 783: if P_COMMIT = FND_API.G_TRUE then

779: END LOOP;
780:
781: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Success!');
782:
783: if P_COMMIT = FND_API.G_TRUE then
784: COMMIT WORK;
785: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited borrower');
786: end if;
787:

Line 789: x_return_status := FND_API.G_RET_STS_SUCCESS;

785: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited borrower');
786: end if;
787:
788: -- END OF BODY OF API
789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:
791: -- Standard call to get message count and if count is 1, get message info
792: FND_MSG_PUB.Count_And_Get(
793: p_encoded => FND_API.G_FALSE,

Line 793: p_encoded => FND_API.G_FALSE,

789: x_return_status := FND_API.G_RET_STS_SUCCESS;
790:
791: -- Standard call to get message count and if count is 1, get message info
792: FND_MSG_PUB.Count_And_Get(
793: p_encoded => FND_API.G_FALSE,
794: p_count => x_msg_count,
795: p_data => x_msg_data);
796:
797: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully processed borrower');

Line 801: WHEN FND_API.G_EXC_ERROR THEN

797: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Successfully processed borrower');
798: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
799:
800: EXCEPTION
801: WHEN FND_API.G_EXC_ERROR THEN
802: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
805: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');

Line 803: x_return_status := FND_API.G_RET_STS_ERROR;

799:
800: EXCEPTION
801: WHEN FND_API.G_EXC_ERROR THEN
802: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
805: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;

Line 806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

802: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
803: x_return_status := FND_API.G_RET_STS_ERROR;
804: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
805: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
810: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');

Line 808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

804: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
805: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
806: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
807: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
810: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
811: WHEN OTHERS THEN
812: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;

Line 813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

809: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
810: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked borrower');
811: WHEN OTHERS THEN
812: ROLLBACK TO PROCESS_SINGLE_LOAN_PVT;
813: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
814: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
815: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
816: END IF;
817: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 871: P_INIT_MSG_LIST => FND_API.G_TRUE,

867: LogMessage(FND_LOG.LEVEL_STATEMENT, '<<--------Generating borrowers summary...-------->>');
868:
869: GENERATE_BORROWERS_SUMMARY(
870: P_API_VERSION => 1.0,
871: P_INIT_MSG_LIST => FND_API.G_TRUE,
872: P_COMMIT => FND_API.G_TRUE,
873: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
874: P_BORROWER_PARTY_ID => BORROWER_PARTY_ID,
875: X_RETURN_STATUS => RETCODE,

Line 872: P_COMMIT => FND_API.G_TRUE,

868:
869: GENERATE_BORROWERS_SUMMARY(
870: P_API_VERSION => 1.0,
871: P_INIT_MSG_LIST => FND_API.G_TRUE,
872: P_COMMIT => FND_API.G_TRUE,
873: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
874: P_BORROWER_PARTY_ID => BORROWER_PARTY_ID,
875: X_RETURN_STATUS => RETCODE,
876: X_MSG_COUNT => l_msg_count,

Line 873: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

869: GENERATE_BORROWERS_SUMMARY(
870: P_API_VERSION => 1.0,
871: P_INIT_MSG_LIST => FND_API.G_TRUE,
872: P_COMMIT => FND_API.G_TRUE,
873: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
874: P_BORROWER_PARTY_ID => BORROWER_PARTY_ID,
875: X_RETURN_STATUS => RETCODE,
876: X_MSG_COUNT => l_msg_count,
877: X_MSG_DATA => ERRBUF);

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

970: SAVEPOINT GENERATE_BORR_SUM;
971: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
972:
973: -- Standard call to check for call compatibility
974: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE

Line 975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

971: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
972:
973: -- Standard call to check for call compatibility
974: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE
979: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 979: IF FND_API.To_Boolean(p_init_msg_list) THEN

975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE
979: IF FND_API.To_Boolean(p_init_msg_list) THEN
980: FND_MSG_PUB.initialize;
981: END IF;
982:
983: -- Initialize API return status to success

Line 984: l_return_status := FND_API.G_RET_STS_SUCCESS;

980: FND_MSG_PUB.initialize;
981: END IF;
982:
983: -- Initialize API return status to success
984: l_return_status := FND_API.G_RET_STS_SUCCESS;
985:
986: -- START OF BODY OF API
987:
988: init;

Line 1034: P_INIT_MSG_LIST => FND_API.G_FALSE,

1030: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Processing borrower #' || l_Count1);
1031:
1032: GEN_SINGLE_BORROWER_SUMMARY(
1033: P_API_VERSION => 1.0,
1034: P_INIT_MSG_LIST => FND_API.G_FALSE,
1035: P_COMMIT => P_COMMIT,
1036: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1037: P_BORROWER_PARTY_ID => l_borrowers_tbl(l_Count1),
1038: X_RETURN_STATUS => l_return_status,

Line 1036: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

1032: GEN_SINGLE_BORROWER_SUMMARY(
1033: P_API_VERSION => 1.0,
1034: P_INIT_MSG_LIST => FND_API.G_FALSE,
1035: P_COMMIT => P_COMMIT,
1036: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
1037: P_BORROWER_PARTY_ID => l_borrowers_tbl(l_Count1),
1038: X_RETURN_STATUS => l_return_status,
1039: X_MSG_COUNT => l_msg_count,
1040: X_MSG_DATA => l_msg_data);

Line 1049: if P_COMMIT = FND_API.G_TRUE then

1045:
1046: LogMessage(FND_LOG.LEVEL_STATEMENT, '______________');
1047: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Total processed ' || l_Count || ' borrowers');
1048:
1049: if P_COMMIT = FND_API.G_TRUE then
1050: COMMIT WORK;
1051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1052: end if;
1053:

Line 1055: x_return_status := FND_API.G_RET_STS_SUCCESS;

1051: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited');
1052: end if;
1053:
1054: -- END OF BODY OF API
1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: -- Standard call to get message count and if count is 1, get message info
1058: FND_MSG_PUB.Count_And_Get(
1059: p_encoded => FND_API.G_FALSE,

Line 1059: p_encoded => FND_API.G_FALSE,

1055: x_return_status := FND_API.G_RET_STS_SUCCESS;
1056:
1057: -- Standard call to get message count and if count is 1, get message info
1058: FND_MSG_PUB.Count_And_Get(
1059: p_encoded => FND_API.G_FALSE,
1060: p_count => x_msg_count,
1061: p_data => x_msg_data);
1062:
1063: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 1066: WHEN FND_API.G_EXC_ERROR THEN

1062:
1063: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
1064:
1065: EXCEPTION
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: ROLLBACK TO GENERATE_BORR_SUM;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 1068: x_return_status := FND_API.G_RET_STS_ERROR;

1064:
1065: EXCEPTION
1066: WHEN FND_API.G_EXC_ERROR THEN
1067: ROLLBACK TO GENERATE_BORR_SUM;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1072: ROLLBACK TO GENERATE_BORR_SUM;

Line 1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1067: ROLLBACK TO GENERATE_BORR_SUM;
1068: x_return_status := FND_API.G_RET_STS_ERROR;
1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1072: ROLLBACK TO GENERATE_BORR_SUM;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1075: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');

Line 1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1069: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1070: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1071: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1072: ROLLBACK TO GENERATE_BORR_SUM;
1073: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1075: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1076: WHEN OTHERS THEN
1077: ROLLBACK TO GENERATE_BORR_SUM;

Line 1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1074: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
1075: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked');
1076: WHEN OTHERS THEN
1077: ROLLBACK TO GENERATE_BORR_SUM;
1078: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1079: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
1080: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
1081: END IF;
1082: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);