DBA Data[Home] [Help]

APPS.IEX_SCORE_NEW_PVT dependencies on FND_API

Line 78: p_init_msg_list =>fnd_api.g_false);

74: p_table_name => l_table_name,
75: x_msg_count => l_msg_count,
76: x_msg_data => l_msg_data,
77: x_return_status => l_return_status,
78: p_init_msg_list =>fnd_api.g_false);
79:
80: If l_return_Status = 'S' then
81: return TRUE;
82: else

Line 725: RAISE FND_API.G_EXC_ERROR;

721: Exception
722:
723: When Others Then
724: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in getScores: ' || sqlerrm );
725: RAISE FND_API.G_EXC_ERROR;
726: END getScores;
727:
728: /*
729: || Overview: score all objects for a given scoring engine

Line 800: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,

796:
797: l_api_name := 'scoreObjects';
798:
799: -- Standard call to check for call compatibility.
800: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
801: l_api_name, G_PKG_NAME)
802: THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;

Line 803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

799: -- Standard call to check for call compatibility.
800: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
801: l_api_name, G_PKG_NAME)
802: THEN
803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;
805:
806: -- Initialize message list IF p_init_msg_list is set to TRUE.
807: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 807: IF FND_API.to_Boolean( p_init_msg_list ) THEN

803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
804: END IF;
805:
806: -- Initialize message list IF p_init_msg_list is set to TRUE.
807: IF FND_API.to_Boolean( p_init_msg_list ) THEN
808: FND_MSG_PUB.initialize;
809: END IF;
810:
811: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 816: x_return_status := FND_API.G_RET_STS_SUCCESS;

812: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
813: END IF;
814:
815: -- Initialize API return status to SUCCESS
816: x_return_status := FND_API.G_RET_STS_SUCCESS;
817:
818: --
819: -- Api body
820: --

Line 838: RAISE FND_API.G_EXC_ERROR;

834: END IF;
835: FND_FILE.PUT_LINE(FND_FILE.LOG, 'IEX_SCORE: scoreObjects: No score components for engine ' || p_score_id);
836: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE_ENG_COMPONENTS');
837: FND_MSG_PUB.Add;
838: RAISE FND_API.G_EXC_ERROR;
839: end if;
840:
841: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
842: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');

Line 884: --RAISE FND_API.G_EXC_ERROR;

880: FND_MESSAGE.Set_Name('IEX', 'IEX_UNIVERSE_SIZE_ZERO');
881: FND_MSG_PUB.Add;
882:
883: --START jsanju 10/19/05 for bug 3549051
884: --RAISE FND_API.G_EXC_ERROR;
885: RAISE IEX_UNIVERSE_SIZE_ZERO_ERROR;
886: --END jsanju 10/19/05 for bug 3549051
887:
888: end if;

Line 906: RAISE FND_API.G_EXC_ERROR;

902: FND_FILE.PUT_LINE(FND_FILE.LOG,
903: 'Score Comp Weight are required for Engine '|| p_score_id);
904: FND_MESSAGE.Set_Name('IEX', 'IEX_WEIGHT_REQUIRED');
905: FND_MSG_PUB.Add;
906: RAISE FND_API.G_EXC_ERROR;
907: end if;
908: END LOOP;
909: END IF;
910: -- end clchang added 10/20/04 for 11.5.11 score engine enhancement

Line 1026: IF FND_API.to_Boolean(p_commit)

1022: -- End of API body
1023: --
1024:
1025: -- Standard check for p_commit
1026: IF FND_API.to_Boolean(p_commit)
1027: THEN
1028: COMMIT WORK;
1029: END IF;
1030:

Line 1041: WHEN FND_API.G_EXC_ERROR THEN

1037: (p_count => x_msg_count,
1038: p_data => x_msg_data);
1039:
1040: EXCEPTION
1041: WHEN FND_API.G_EXC_ERROR THEN
1042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1043: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Expected Error ' || sqlerrm);
1044: END IF;
1045: RAISE FND_API.G_EXC_ERROR;

Line 1045: RAISE FND_API.G_EXC_ERROR;

1041: WHEN FND_API.G_EXC_ERROR THEN
1042: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1043: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Expected Error ' || sqlerrm);
1044: END IF;
1045: RAISE FND_API.G_EXC_ERROR;
1046: ROLLBACK TO scoreObjects_PVT;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1044: END IF;
1045: RAISE FND_API.G_EXC_ERROR;
1046: ROLLBACK TO scoreObjects_PVT;
1047:
1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1050: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: UnExpected Error ' || sqlerrm);
1051: END IF;
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1048: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1049: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1050: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: UnExpected Error ' || sqlerrm);
1051: END IF;
1052: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1053: ROLLBACK TO scoreObjects_PVT;
1054:
1055: --START jsanju 10/19/05 for bug 3549051, pass the exception to the score_concur procedure
1056:

Line 1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1066: WHEN OTHERS THEN
1067: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1068: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Other Error ' || sqlerrm);
1069: END IF;
1070: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1071: ROLLBACK TO scoreObjects_PVT;
1072:
1073: END scoreObjects;
1074:

Line 1143: -- IF FND_API.to_Boolean(p_commit)

1139: -- t_object_ids => l_universe,
1140: -- x_scores_tbl => l_scores_tbl);
1141: --
1142: -- if (l_scores_tbl is not null) and (l_scores_tbl.count > 0) then
1143: -- IF FND_API.to_Boolean(p_commit)
1144: -- THEN
1145: -- insert into iex_score_histories(SCORE_HISTORY_ID
1146: -- ,SCORE_OBJECT_ID
1147: -- ,SCORE_OBJECT_CODE

Line 1255: p_init_msg_list => FND_API.G_TRUE,

1251: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Operating Unit: ' || nvl(mo_global.get_ou_name(mo_global.get_current_org_id), 'All')); --Added for moac
1252: if l_num_score_engines(x) is not null then
1253: BEGIN
1254: IEX_SCORE_NEW_PVT.scoreObjects(p_api_version => 1.0,
1255: p_init_msg_list => FND_API.G_TRUE,
1256: p_commit => FND_API.G_TRUE,
1257: x_return_status => l_return_status,
1258: x_msg_count => l_msg_count,
1259: x_msg_data => l_msg_data,

Line 1256: p_commit => FND_API.G_TRUE,

1252: if l_num_score_engines(x) is not null then
1253: BEGIN
1254: IEX_SCORE_NEW_PVT.scoreObjects(p_api_version => 1.0,
1255: p_init_msg_list => FND_API.G_TRUE,
1256: p_commit => FND_API.G_TRUE,
1257: x_return_status => l_return_status,
1258: x_msg_count => l_msg_count,
1259: x_msg_data => l_msg_data,
1260: p_score_id => l_num_score_engines(x));

Line 1264: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1260: p_score_id => l_num_score_engines(x));
1261: FND_FILE.PUT_LINE(FND_FILE.LOG,
1262: 'Score Engine: ' || l_num_score_engines(x) ||
1263: ' Status: ' || l_return_status);
1264: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1265: RAISE FND_API.G_EXC_ERROR;
1266: end if;
1267:
1268: EXCEPTION

Line 1265: RAISE FND_API.G_EXC_ERROR;

1261: FND_FILE.PUT_LINE(FND_FILE.LOG,
1262: 'Score Engine: ' || l_num_score_engines(x) ||
1263: ' Status: ' || l_return_status);
1264: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1265: RAISE FND_API.G_EXC_ERROR;
1266: end if;
1267:
1268: EXCEPTION
1269:

Line 1271: WHEN FND_API.G_EXC_ERROR THEN

1267:
1268: EXCEPTION
1269:
1270: -- note do not set retcode when error is expected
1271: WHEN FND_API.G_EXC_ERROR THEN
1272: RETCODE := -1;
1273: ERRBUF := l_msg_data;
1274: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1275: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error in Score ' || sqlerrm);

Line 1309: WHEN FND_API.G_EXC_ERROR THEN

1305: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1306: END IF;
1307: Exception
1308:
1309: WHEN FND_API.G_EXC_ERROR THEN
1310: RETCODE := -1;
1311: ERRBUF := l_msg_data;
1312: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1313: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm);

Line 1602: WHEN FND_API.G_EXC_ERROR THEN

1598: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1599: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1600: END IF;
1601: Exception
1602: WHEN FND_API.G_EXC_ERROR THEN
1603: RETCODE := -1;
1604: ERRBUF := l_msg_data;
1605: -- IF PG_DEBUG < 10 THEN
1606: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1756: WHEN FND_API.G_EXC_ERROR THEN

1752: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1753: END IF;
1754:
1755: Exception
1756: WHEN FND_API.G_EXC_ERROR THEN
1757: -- IF PG_DEBUG < 10 THEN
1758: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1759: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Expected Error ' || sqlerrm );
1760: END IF;

Line 1870: WHEN FND_API.G_EXC_ERROR THEN

1866: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Return' );
1867: END IF;
1868:
1869: Exception
1870: WHEN FND_API.G_EXC_ERROR THEN
1871: IF PG_DEBUG < 10 THEN
1872: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Expected Error ' || sqlerrm );
1873: END IF;
1874: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory:' || sqlerrm);

Line 1985: WHEN FND_API.G_EXC_ERROR THEN

1981: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Return' );
1982: END IF;
1983:
1984: Exception
1985: WHEN FND_API.G_EXC_ERROR THEN
1986: IF PG_DEBUG < 10 THEN
1987: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm );
1988: END IF;
1989: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm);

Line 2225: WHEN FND_API.G_EXC_ERROR THEN

2221:
2222: return l_running_score;
2223:
2224: Exception
2225: WHEN FND_API.G_EXC_ERROR THEN
2226: IF PG_DEBUG < 10 THEN
2227: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Expected Error ' || sqlerrm );
2228: END IF;
2229: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: Expected Error ' || sqlerrm);