DBA Data[Home] [Help]

APPS.IEX_SCORE_NEW_PVT dependencies on FND_API

Line 82: p_init_msg_list =>fnd_api.g_false);

78: p_table_name => l_table_name,
79: x_msg_count => l_msg_count,
80: x_msg_data => l_msg_data,
81: x_return_status => l_return_status,
82: p_init_msg_list =>fnd_api.g_false);
83:
84: If l_return_Status = 'S' then
85: return TRUE;
86: else

Line 975: RAISE FND_API.G_EXC_ERROR;

971: Exception
972:
973: When Others Then
974: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Error in getScores: ' || sqlerrm );
975: RAISE FND_API.G_EXC_ERROR;
976: END getScores;
977:
978: /*
979: || Overview: score all objects for a given scoring engine

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

1080:
1081: l_api_name := 'scoreObjects';
1082:
1083: -- Standard call to check for call compatibility.
1084: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1085: l_api_name, G_PKG_NAME)
1086: THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;

Line 1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1083: -- Standard call to check for call compatibility.
1084: IF NOT FND_API.Compatible_API_Call (l_api_version_number, p_api_version,
1085: l_api_name, G_PKG_NAME)
1086: THEN
1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- Initialize message list IF p_init_msg_list is set to TRUE.
1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1087: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1088: END IF;
1089:
1090: -- Initialize message list IF p_init_msg_list is set to TRUE.
1091: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1092: FND_MSG_PUB.initialize;
1093: END IF;
1094:
1095: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1100: x_return_status := FND_API.G_RET_STS_SUCCESS;

1096: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Start time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1097: END IF;
1098:
1099: -- Initialize API return status to SUCCESS
1100: x_return_status := FND_API.G_RET_STS_SUCCESS;
1101:
1102: /*select score_name
1103: into l_score_name
1104: from iex_scores

Line 1174: RAISE FND_API.G_EXC_ERROR;

1170: -- l_xml_body:= l_xml_body||l_new_line||'';
1171: dbms_lob.writeAppend(tempResult, length(l_xml_body), l_xml_body);
1172: --End Bug 8933776 30-Nov-2009 barathsr
1173: FND_MSG_PUB.Add;
1174: RAISE FND_API.G_EXC_ERROR;
1175: end if;
1176:
1177: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1178: IEX_DEBUG_PUB.logMessage('scoreObjects: ' || 'Batch Size is ' || G_BATCH_SIZE || ' rows');

Line 1290: --RAISE FND_API.G_EXC_ERROR;

1286: FND_MESSAGE.Set_Name('IEX', 'IEX_UNIVERSE_SIZE_ZERO');
1287: FND_MSG_PUB.Add;
1288:
1289: --START jsanju 10/19/05 for bug 3549051
1290: --RAISE FND_API.G_EXC_ERROR;
1291: RAISE IEX_UNIVERSE_SIZE_ZERO_ERROR;
1292: --END jsanju 10/19/05 for bug 3549051
1293:
1294: end if; */

Line 1354: RAISE FND_API.G_EXC_ERROR;

1350: FND_FILE.PUT_LINE(FND_FILE.LOG,
1351: 'Score Comp Weight are required for Engine '|| p_score_id);
1352: FND_MESSAGE.Set_Name('IEX', 'IEX_WEIGHT_REQUIRED');
1353: FND_MSG_PUB.Add;
1354: RAISE FND_API.G_EXC_ERROR;
1355: end if;
1356: END LOOP;
1357: END IF;
1358: -- end clchang added 10/20/04 for 11.5.11 score engine enhancement

Line 1490: IF FND_API.to_Boolean(p_commit)

1486: -- End of API body
1487: --
1488:
1489: -- Standard check for p_commit
1490: IF FND_API.to_Boolean(p_commit)
1491: THEN
1492: COMMIT WORK;
1493: END IF;
1494:

Line 1511: WHEN FND_API.G_EXC_ERROR THEN

1507:
1508: -- FND_FILE.PUT_LINE(FND_FILE.LOG, '***close score details body***');
1509:
1510: EXCEPTION
1511: WHEN FND_API.G_EXC_ERROR THEN
1512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1513: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Expected Error ' || sqlerrm);
1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;

Line 1515: RAISE FND_API.G_EXC_ERROR;

1511: WHEN FND_API.G_EXC_ERROR THEN
1512: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1513: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Expected Error ' || sqlerrm);
1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;
1516: ROLLBACK TO scoreObjects_PVT;
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1514: END IF;
1515: RAISE FND_API.G_EXC_ERROR;
1516: ROLLBACK TO scoreObjects_PVT;
1517:
1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1520: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: UnExpected Error ' || sqlerrm);
1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1518: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1519: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1520: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: UnExpected Error ' || sqlerrm);
1521: END IF;
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ROLLBACK TO scoreObjects_PVT;
1524:
1525: --START jsanju 10/19/05 for bug 3549051, pass the exception to the score_concur procedure
1526:

Line 1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1536: WHEN OTHERS THEN
1537: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1538: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreObjects: Other Error ' || sqlerrm);
1539: END IF;
1540: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1541: ROLLBACK TO scoreObjects_PVT;
1542:
1543: END scoreObjects;
1544:

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

1609: -- t_object_ids => l_universe,
1610: -- x_scores_tbl => l_scores_tbl);
1611: --
1612: -- if (l_scores_tbl is not null) and (l_scores_tbl.count > 0) then
1613: -- IF FND_API.to_Boolean(p_commit)
1614: -- THEN
1615: -- insert into iex_score_histories(SCORE_HISTORY_ID
1616: -- ,SCORE_OBJECT_ID
1617: -- ,SCORE_OBJECT_CODE

Line 1842: p_init_msg_list => FND_API.G_TRUE,

1838: 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
1839: if l_num_score_engines(x) is not null then
1840: BEGIN
1841: IEX_SCORE_NEW_PVT.scoreObjects(p_api_version => 1.0,
1842: p_init_msg_list => FND_API.G_TRUE,
1843: p_commit => FND_API.G_TRUE,
1844: x_return_status => l_return_status,
1845: x_msg_count => l_msg_count,
1846: x_msg_data => l_msg_data,

Line 1843: p_commit => FND_API.G_TRUE,

1839: if l_num_score_engines(x) is not null then
1840: BEGIN
1841: IEX_SCORE_NEW_PVT.scoreObjects(p_api_version => 1.0,
1842: p_init_msg_list => FND_API.G_TRUE,
1843: p_commit => FND_API.G_TRUE,
1844: x_return_status => l_return_status,
1845: x_msg_count => l_msg_count,
1846: x_msg_data => l_msg_data,
1847: p_score_id => l_num_score_engines(x),

Line 1856: if l_return_status <> FND_API.G_RET_STS_SUCCESS then

1852: ' Status: ' || l_return_status);
1853:
1854:
1855:
1856: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1857: RAISE FND_API.G_EXC_ERROR;
1858: end if;
1859:
1860:

Line 1857: RAISE FND_API.G_EXC_ERROR;

1853:
1854:
1855:
1856: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
1857: RAISE FND_API.G_EXC_ERROR;
1858: end if;
1859:
1860:
1861:

Line 1866: WHEN FND_API.G_EXC_ERROR THEN

1862:
1863: EXCEPTION
1864:
1865: -- note do not set retcode when error is expected
1866: WHEN FND_API.G_EXC_ERROR THEN
1867: RETCODE := -1;
1868: ERRBUF := l_msg_data;
1869: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1870: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error in Score ' || sqlerrm);

Line 1921: WHEN FND_API.G_EXC_ERROR THEN

1917: IEX_DEBUG_PUB.logMessage('Score_Concur: ' || 'IEX_SCORE: scoreConcur: End time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
1918: END IF;
1919: Exception
1920:
1921: WHEN FND_API.G_EXC_ERROR THEN
1922: RETCODE := -1;
1923: ERRBUF := l_msg_data;
1924: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
1925: IEX_DEBUG_PUB.logMessage('IEX_SCORE: scoreConcur: Expected Error ' || sqlerrm);

Line 2277: WHEN FND_API.G_EXC_ERROR THEN

2273: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2274: IEX_DEBUG_PUB.logMessage('IEX_SCORE: eraseScores: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2275: END IF;
2276: Exception
2277: WHEN FND_API.G_EXC_ERROR THEN
2278: RETCODE := -1;
2279: ERRBUF := l_msg_data;
2280: -- IF PG_DEBUG < 10 THEN
2281: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN

Line 2431: WHEN FND_API.G_EXC_ERROR THEN

2427: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: end time:'|| TO_CHAR(SYSDATE, 'HH24:MI:SSSSS'));
2428: END IF;
2429:
2430: Exception
2431: WHEN FND_API.G_EXC_ERROR THEN
2432: -- IF PG_DEBUG < 10 THEN
2433: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
2434: IEX_DEBUG_PUB.logMessage('IEX_SCORE: getScoreHistory: Expected Error ' || sqlerrm );
2435: END IF;

Line 2551: WHEN FND_API.G_EXC_ERROR THEN

2547: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Return' );
2548: END IF;
2549:
2550: Exception
2551: WHEN FND_API.G_EXC_ERROR THEN
2552: IF PG_DEBUG < 10 THEN
2553: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeScoreHistory: Expected Error ' || sqlerrm );
2554: END IF;
2555: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR: IEX_SCORE: storeScoreHistory:' || sqlerrm);

Line 2667: WHEN FND_API.G_EXC_ERROR THEN

2663: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Return' );
2664: END IF;
2665:
2666: Exception
2667: WHEN FND_API.G_EXC_ERROR THEN
2668: IF PG_DEBUG < 10 THEN
2669: IEX_DEBUG_PUB.logMessage('IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm );
2670: END IF;
2671: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: storeDelBuffers: Expected Error ' || sqlerrm);

Line 2974: WHEN FND_API.G_EXC_ERROR THEN

2970:
2971: return l_running_score;
2972:
2973: Exception
2974: WHEN FND_API.G_EXC_ERROR THEN
2975: IF PG_DEBUG < 10 THEN
2976: IEX_DEBUG_PUB.logMessage('IEX_SCORE: get1Score: Expected Error ' || sqlerrm );
2977: END IF;
2978: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN CONCUR:IEX_SCORE: get1Score: Expected Error ' || sqlerrm);