DBA Data[Home] [Help]

APPS.IEX_SCORE_PVT dependencies on FND_MESSAGE

Line 105: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');

101: IF P_SCORE_Name is NULL
102: or P_SCORE_Name = FND_API.G_FALSE
103: THEN
104: WriteLog(l_msg || ' no score name');
105: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
106: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_Name', FALSE);
107: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);
108: FND_MSG_PUB.Add;
109: x_return_status := FND_API.G_RET_STS_ERROR;

Line 106: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_Name', FALSE);

102: or P_SCORE_Name = FND_API.G_FALSE
103: THEN
104: WriteLog(l_msg || ' no score name');
105: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
106: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_Name', FALSE);
107: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);
108: FND_MSG_PUB.Add;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110:

Line 107: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);

103: THEN
104: WriteLog(l_msg || ' no score name');
105: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
106: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_Name', FALSE);
107: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);
108: FND_MSG_PUB.Add;
109: x_return_status := FND_API.G_RET_STS_ERROR;
110:
111: ELSE -- IF P_SCORE_Name is NULL or P_SCORE_Name = FND_API.G_FALSE

Line 121: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');

117: THEN
118: WriteLog(l_msg || ' got dup score name');
119: --IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
120: --THEN
121: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
122: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
123: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);
124: FND_MSG_PUB.Add;
125: --END IF;

Line 122: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);

118: WriteLog(l_msg || ' got dup score name');
119: --IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
120: --THEN
121: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
122: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
123: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);
124: FND_MSG_PUB.Add;
125: --END IF;
126: x_return_status := FND_API.G_RET_STS_ERROR;

Line 123: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);

119: --IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
120: --THEN
121: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
122: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
123: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);
124: FND_MSG_PUB.Add;
125: --END IF;
126: x_return_status := FND_API.G_RET_STS_ERROR;
127: x_dup_status := IEX_DUPLICATE_NAME;

Line 173: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');

169:
170: IF P_SCORE_Name is NULL
171: or P_SCORE_Name = FND_API.G_FALSE
172: THEN
173: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
174: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_ID_Name', FALSE);
175: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);
176: FND_MSG_PUB.Add;
177: x_return_status := FND_API.G_RET_STS_ERROR;

Line 174: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_ID_Name', FALSE);

170: IF P_SCORE_Name is NULL
171: or P_SCORE_Name = FND_API.G_FALSE
172: THEN
173: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
174: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_ID_Name', FALSE);
175: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);
176: FND_MSG_PUB.Add;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178:

Line 175: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);

171: or P_SCORE_Name = FND_API.G_FALSE
172: THEN
173: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
174: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_ID_Name', FALSE);
175: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_NAME', FALSE);
176: FND_MSG_PUB.Add;
177: x_return_status := FND_API.G_RET_STS_ERROR;
178:
179: ELSE -- IF P_SCORE_Name is NULL or P_SCORE_Name = FND_API.G_FALSE

Line 188: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');

184: IF (C_Get_Score_ID_Name%FOUND)
185: THEN
186: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
187: THEN
188: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
189: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
190: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);
191: FND_MSG_PUB.Add;
192: END IF;

Line 189: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);

185: THEN
186: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
187: THEN
188: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
189: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
190: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);
191: FND_MSG_PUB.Add;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_ERROR;

Line 190: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);

186: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
187: THEN
188: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
189: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
190: FND_MESSAGE.Set_Token('VALUE', p_score_Name, FALSE);
191: FND_MSG_PUB.Add;
192: END IF;
193: x_return_status := FND_API.G_RET_STS_ERROR;
194: x_dup_status := IEX_DUPLICATE_NAME;

Line 235: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');

231:
232: IF P_SCORE_COMP_NAME is NULL
233: or P_SCORE_COMP_NAME = FND_API.G_FALSE
234: THEN
235: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
236: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_COMP_TYPE_NAME', FALSE);
237: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);
238: FND_MSG_PUB.Add;
239: x_return_status := FND_API.G_RET_STS_ERROR;

Line 236: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_COMP_TYPE_NAME', FALSE);

232: IF P_SCORE_COMP_NAME is NULL
233: or P_SCORE_COMP_NAME = FND_API.G_FALSE
234: THEN
235: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
236: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_COMP_TYPE_NAME', FALSE);
237: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);
238: FND_MSG_PUB.Add;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240:

Line 237: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);

233: or P_SCORE_COMP_NAME = FND_API.G_FALSE
234: THEN
235: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
236: FND_MESSAGE.Set_Token('API_NAME', 'Validate_SCORE_COMP_TYPE_NAME', FALSE);
237: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);
238: FND_MSG_PUB.Add;
239: x_return_status := FND_API.G_RET_STS_ERROR;
240:
241: ELSE -- IF P_SCORE_COMP_NAME is NOT NULL and P_SCORE_COMP_NAME <> FND_API.G_FALSE

Line 250: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');

246: IF (C_Get_SCORE_COMP_NAME%FOUND)
247: THEN
248: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
249: THEN
250: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
251: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);
252: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);
253: FND_MSG_PUB.Add;
254: END IF;

Line 251: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);

247: THEN
248: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
249: THEN
250: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
251: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);
252: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);
253: FND_MSG_PUB.Add;
254: END IF;
255: x_return_status := FND_API.G_RET_STS_ERROR;

Line 252: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);

248: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
249: THEN
250: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
251: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);
252: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);
253: FND_MSG_PUB.Add;
254: END IF;
255: x_return_status := FND_API.G_RET_STS_ERROR;
256: x_dup_status := IEX_DUPLICATE_NAME;

Line 299: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');

295:
296: IF P_SCORE_COMP_NAME is NULL
297: or P_SCORE_COMP_NAME = FND_API.G_FALSE
298: THEN
299: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
300: FND_MESSAGE.Set_Token('API_NAME', 'Val_SCORE_COMP_TYPE_ID_NAME', FALSE);
301: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);
302: FND_MSG_PUB.Add;
303: x_return_status := FND_API.G_RET_STS_ERROR;

Line 300: FND_MESSAGE.Set_Token('API_NAME', 'Val_SCORE_COMP_TYPE_ID_NAME', FALSE);

296: IF P_SCORE_COMP_NAME is NULL
297: or P_SCORE_COMP_NAME = FND_API.G_FALSE
298: THEN
299: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
300: FND_MESSAGE.Set_Token('API_NAME', 'Val_SCORE_COMP_TYPE_ID_NAME', FALSE);
301: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);
302: FND_MSG_PUB.Add;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304:

Line 301: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);

297: or P_SCORE_COMP_NAME = FND_API.G_FALSE
298: THEN
299: FND_MESSAGE.Set_Name('IEX', 'IEX_API_ALL_MISSING_PARAM');
300: FND_MESSAGE.Set_Token('API_NAME', 'Val_SCORE_COMP_TYPE_ID_NAME', FALSE);
301: FND_MESSAGE.Set_Token('MISSING_PARAM', 'SCORE_COMP_NAME', FALSE);
302: FND_MSG_PUB.Add;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304:
305: ELSE -- IF P_SCORE_COMP_NAME is NOT NULL and P_SCORE_COMP_NAME <> FND_API.G_FALSE

Line 314: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');

310: IF (C_Get_SCORE_COMP_ID_NAME%FOUND)
311: THEN
312: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
313: THEN
314: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
315: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);
316: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);
317: FND_MSG_PUB.Add;
318: END IF;

Line 315: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);

311: THEN
312: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
313: THEN
314: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
315: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);
316: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);
317: FND_MSG_PUB.Add;
318: END IF;
319: x_return_status := FND_API.G_RET_STS_ERROR;

Line 316: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);

312: IF FND_MSG_PUB.CHECK_MSG_LEVEL (FND_MSG_PUB.G_MSG_LVL_ERROR)
313: THEN
314: FND_MESSAGE.Set_Name('IEX', 'IEX_API_DUPLICATE_NAME');
315: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_COMP_NAME', FALSE);
316: FND_MESSAGE.Set_Token('VALUE', p_SCORE_COMP_NAME, FALSE);
317: FND_MSG_PUB.Add;
318: END IF;
319: x_return_status := FND_API.G_RET_STS_ERROR;
320: x_dup_status := IEX_DUPLICATE_NAME;

Line 695: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

691:
692: IF ( C_Get_SCORE_REC%NOTFOUND) THEN
693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
694: THEN
695: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
696: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);
697: FND_MSG_PUB.Add;
698: END IF;
699: RAISE FND_API.G_EXC_ERROR;

Line 696: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);

692: IF ( C_Get_SCORE_REC%NOTFOUND) THEN
693: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
694: THEN
695: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
696: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);
697: FND_MSG_PUB.Add;
698: END IF;
699: RAISE FND_API.G_EXC_ERROR;
700: END IF;

Line 711: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

707: l_score_rec.last_update_date = FND_API.G_MISS_Date )
708: THEN
709: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
712: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
713: FND_MSG_PUB.ADD;
714: END IF;
715: RAISE FND_API.G_EXC_ERROR;

Line 712: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

708: THEN
709: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
710: THEN
711: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
712: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
713: FND_MSG_PUB.ADD;
714: END IF;
715: RAISE FND_API.G_EXC_ERROR;
716: End IF;

Line 937: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

933: Fetch C_Get_SCORE into
934: l_rowid;
935:
936: IF ( C_Get_Score%NOTFOUND) THEN
937: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
938: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);
939: FND_MSG_PUB.Add;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: RAISE FND_API.G_EXC_ERROR;

Line 938: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);

934: l_rowid;
935:
936: IF ( C_Get_Score%NOTFOUND) THEN
937: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
938: FND_MESSAGE.Set_Token ('INFO', 'iex_scores', FALSE);
939: FND_MSG_PUB.Add;
940: x_return_status := FND_API.G_RET_STS_ERROR;
941: RAISE FND_API.G_EXC_ERROR;
942: END IF;

Line 1363: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

1359:
1360: IF ( C_Get_SCORE_COMP_REC%NOTFOUND) THEN
1361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1364: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);
1365: FND_MSG_PUB.Add;
1366: END IF;
1367: RAISE FND_API.G_EXC_ERROR;

Line 1364: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);

1360: IF ( C_Get_SCORE_COMP_REC%NOTFOUND) THEN
1361: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1362: THEN
1363: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1364: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);
1365: FND_MSG_PUB.Add;
1366: END IF;
1367: RAISE FND_API.G_EXC_ERROR;
1368: END IF;

Line 1380: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

1376: l_score_comp_rec.last_update_date = FND_API.G_MISS_Date )
1377: THEN
1378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1379: THEN
1380: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
1381: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1382: FND_MSG_PUB.ADD;
1383: END IF;
1384: RAISE FND_API.G_EXC_ERROR;

Line 1381: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

1377: THEN
1378: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1379: THEN
1380: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
1381: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1382: FND_MSG_PUB.ADD;
1383: END IF;
1384: RAISE FND_API.G_EXC_ERROR;
1385: End IF;

Line 1546: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

1542:
1543: IF ( C_Get_Score_Comp%NOTFOUND) THEN
1544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1545: THEN
1546: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1547: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);
1548: FND_MSG_PUB.Add;
1549: END IF;
1550: RAISE FND_API.G_EXC_ERROR;

Line 1547: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);

1543: IF ( C_Get_Score_Comp%NOTFOUND) THEN
1544: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1545: THEN
1546: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1547: FND_MESSAGE.Set_Token ('INFO', 'iex_score_components', FALSE);
1548: FND_MSG_PUB.Add;
1549: END IF;
1550: RAISE FND_API.G_EXC_ERROR;
1551: END IF;

Line 1908: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

1904: l_score_comp_type_ref_rec.DISPLAY_ORDER;
1905:
1906: IF ( C_Get_SCORE_COMP_TYPE_B_REC%NOTFOUND) THEN
1907: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1908: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1909: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_b', FALSE);
1910: FND_MSG_PUB.Add;
1911: END IF;
1912: RAISE FND_API.G_EXC_ERROR;

Line 1909: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_b', FALSE);

1905:
1906: IF ( C_Get_SCORE_COMP_TYPE_B_REC%NOTFOUND) THEN
1907: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1908: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1909: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_b', FALSE);
1910: FND_MSG_PUB.Add;
1911: END IF;
1912: RAISE FND_API.G_EXC_ERROR;
1913: END IF;

Line 1934: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

1930:
1931: IF ( C_Get_SCORE_COMP_TYPE_TL_REC%NOTFOUND) THEN
1932: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1933: THEN
1934: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1935: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_TL', FALSE);
1936: FND_MSG_PUB.Add;
1937: END IF;
1938: RAISE FND_API.G_EXC_ERROR;

Line 1935: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_TL', FALSE);

1931: IF ( C_Get_SCORE_COMP_TYPE_TL_REC%NOTFOUND) THEN
1932: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1933: THEN
1934: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
1935: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_types_TL', FALSE);
1936: FND_MSG_PUB.Add;
1937: END IF;
1938: RAISE FND_API.G_EXC_ERROR;
1939: END IF;

Line 1950: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

1946: l_score_comp_type_rec.last_update_date = FND_API.G_MISS_Date )
1947: THEN
1948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1949: THEN
1950: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
1951: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1952: FND_MSG_PUB.ADD;
1953: END IF;
1954: RAISE FND_API.G_EXC_ERROR;

Line 1951: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

1947: THEN
1948: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1949: THEN
1950: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
1951: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
1952: FND_MSG_PUB.ADD;
1953: END IF;
1954: RAISE FND_API.G_EXC_ERROR;
1955: End IF;

Line 2134: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

2130:
2131: IF ( C_Get_TYPE%NOTFOUND) THEN
2132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2133: THEN
2134: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2135: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_Types', FALSE);
2136: FND_MSG_PUB.Add;
2137: END IF;
2138: RAISE FND_API.G_EXC_ERROR;

Line 2135: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_Types', FALSE);

2131: IF ( C_Get_TYPE%NOTFOUND) THEN
2132: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2133: THEN
2134: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2135: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_Types', FALSE);
2136: FND_MSG_PUB.Add;
2137: END IF;
2138: RAISE FND_API.G_EXC_ERROR;
2139: END IF;

Line 2464: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

2460:
2461: IF ( C_Get_SCORE_COMP_DET_REC%NOTFOUND) THEN
2462: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2463: THEN
2464: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2465: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_det', FALSE);
2466: FND_MSG_PUB.Add;
2467: END IF;
2468: RAISE FND_API.G_EXC_ERROR;

Line 2465: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_det', FALSE);

2461: IF ( C_Get_SCORE_COMP_DET_REC%NOTFOUND) THEN
2462: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2463: THEN
2464: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2465: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_det', FALSE);
2466: FND_MSG_PUB.Add;
2467: END IF;
2468: RAISE FND_API.G_EXC_ERROR;
2469: END IF;

Line 2482: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');

2478: l_score_comp_det_rec.last_update_date = FND_API.G_MISS_Date )
2479: THEN
2480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2481: THEN
2482: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
2483: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2484: FND_MSG_PUB.ADD;
2485: END IF;
2486: RAISE FND_API.G_EXC_ERROR;

Line 2483: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);

2479: THEN
2480: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2481: THEN
2482: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_ID');
2483: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
2484: FND_MSG_PUB.ADD;
2485: END IF;
2486: RAISE FND_API.G_EXC_ERROR;
2487: End IF;

Line 2651: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

2647:
2648: IF ( C_Get_Score_Comp_Det%NOTFOUND) THEN
2649: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2650: THEN
2651: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2652: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_det', FALSE);
2653: FND_MSG_PUB.Add;
2654: END IF;
2655: RAISE FND_API.G_EXC_ERROR;

Line 2652: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_det', FALSE);

2648: IF ( C_Get_Score_Comp_Det%NOTFOUND) THEN
2649: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
2650: THEN
2651: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2652: FND_MESSAGE.Set_Token ('INFO', 'iex_score_comp_det', FALSE);
2653: FND_MSG_PUB.Add;
2654: END IF;
2655: RAISE FND_API.G_EXC_ERROR;
2656: END IF;

Line 2887: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

2883:
2884:
2885: IF ( C_Get_Score%NOTFOUND) THEN
2886: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Score notfound');
2887: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2888: FND_MESSAGE.Set_Token ('INFO', 'iex_Score', FALSE);
2889: FND_MSG_PUB.Add;
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;

Line 2888: FND_MESSAGE.Set_Token ('INFO', 'iex_Score', FALSE);

2884:
2885: IF ( C_Get_Score%NOTFOUND) THEN
2886: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: Score notfound');
2887: FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
2888: FND_MESSAGE.Set_Token ('INFO', 'iex_Score', FALSE);
2889: FND_MSG_PUB.Add;
2890: RAISE FND_API.G_EXC_ERROR;
2891: END IF;
2892:

Line 2913: FND_MESSAGE.Set_Name('IEX', 'IEX_API_LEN_ERR');

2909: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName Loop');
2910: if (l_len > 248) then
2911: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName > 256');
2912: l_tmp_score_name := 'Copy of ' || l_score_name;
2913: FND_MESSAGE.Set_Name('IEX', 'IEX_API_LEN_ERR');
2914: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
2915: FND_MESSAGE.Set_Token('VALUE', l_tmp_score_Name, FALSE);
2916: FND_MESSAGE.Set_Token ('LEN', '256', FALSE);
2917: FND_MSG_PUB.Add;

Line 2914: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);

2910: if (l_len > 248) then
2911: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName > 256');
2912: l_tmp_score_name := 'Copy of ' || l_score_name;
2913: FND_MESSAGE.Set_Name('IEX', 'IEX_API_LEN_ERR');
2914: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
2915: FND_MESSAGE.Set_Token('VALUE', l_tmp_score_Name, FALSE);
2916: FND_MESSAGE.Set_Token ('LEN', '256', FALSE);
2917: FND_MSG_PUB.Add;
2918: x_dup_status := '';

Line 2915: FND_MESSAGE.Set_Token('VALUE', l_tmp_score_Name, FALSE);

2911: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: ScoreName > 256');
2912: l_tmp_score_name := 'Copy of ' || l_score_name;
2913: FND_MESSAGE.Set_Name('IEX', 'IEX_API_LEN_ERR');
2914: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
2915: FND_MESSAGE.Set_Token('VALUE', l_tmp_score_Name, FALSE);
2916: FND_MESSAGE.Set_Token ('LEN', '256', FALSE);
2917: FND_MSG_PUB.Add;
2918: x_dup_status := '';
2919: --x_score_id := l_add;

Line 2916: FND_MESSAGE.Set_Token ('LEN', '256', FALSE);

2912: l_tmp_score_name := 'Copy of ' || l_score_name;
2913: FND_MESSAGE.Set_Name('IEX', 'IEX_API_LEN_ERR');
2914: FND_MESSAGE.Set_Token('COLUMN', 'SCORE_NAME', FALSE);
2915: FND_MESSAGE.Set_Token('VALUE', l_tmp_score_Name, FALSE);
2916: FND_MESSAGE.Set_Token ('LEN', '256', FALSE);
2917: FND_MSG_PUB.Add;
2918: x_dup_status := '';
2919: --x_score_id := l_add;
2920: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3115: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');

3111:
3112:
3113: IF ( C_Get_SCORE_FILTER%NOTFOUND) THEN
3114: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: SCORE_FILTER notfound');
3115: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3116: --FND_MESSAGE.Set_Token ('INFO', 'iex_SCORE_FILTER', FALSE);
3117: --FND_MSG_PUB.Add;
3118: --RAISE FND_API.G_EXC_ERROR;
3119: ELSE

Line 3116: --FND_MESSAGE.Set_Token ('INFO', 'iex_SCORE_FILTER', FALSE);

3112:
3113: IF ( C_Get_SCORE_FILTER%NOTFOUND) THEN
3114: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: SCORE_FILTER notfound');
3115: --FND_MESSAGE.Set_Name('IEX', 'API_MISSING_UPDATE_TARGET');
3116: --FND_MESSAGE.Set_Token ('INFO', 'iex_SCORE_FILTER', FALSE);
3117: --FND_MSG_PUB.Add;
3118: --RAISE FND_API.G_EXC_ERROR;
3119: ELSE
3120:

Line 3615: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE_ENGINE');

3611: CLOSE c_score_name;
3612:
3613: -- the profile is not set OR the engine is not valid and active -> raise an error
3614: IF l_score_id IS NULL THEN
3615: FND_MESSAGE.Set_Name('IEX', 'IEX_NO_SCORE_ENGINE');
3616: FND_MSG_PUB.Add;
3617: RAISE FND_API.G_EXC_ERROR;
3618: END IF;
3619: ELSE