[Home] [Help]
25:
26: -- Initialize message list IF p_init_msg_list is set to TRUE.
27: IF FND_API.to_Boolean( p_init_msg_list )
28: THEN
29: FND_MSG_PUB.initialize;
30: END IF;
31: IEX_UTILITIES.VALIDATE_ANY_ID(P_COL_ID => l_score_rec.score_id,
32: P_COL_NAME => 'SCORE_ID',
33: P_TABLE_NAME => 'IEX_SCORES',
87:
88: -- Initialize message list IF p_init_msg_list is set to TRUE.
89: IF FND_API.to_Boolean( p_init_msg_list )
90: THEN
91: FND_MSG_PUB.initialize;
92: END IF;
93:
94: -- Initialize API return status to SUCCESS
95: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
112:
115:
116: IF (C_Get_Score_Name%FOUND)
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);
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;
128: END IF;
133: WriteLog(l_msg || 'x_dup_status='||x_dup_status);
134:
135: -- Standard call to get message count and IF count is 1, get message info.
136:
137: FND_MSG_PUB.Count_And_Get
138: ( p_count => x_msg_count,
139: p_data => x_msg_data );
140:
141: END Validate_Score_Name;
160: BEGIN
161: -- Initialize message list IF p_init_msg_list is set to TRUE.
162: IF FND_API.to_Boolean( p_init_msg_list )
163: THEN
164: FND_MSG_PUB.initialize;
165: END IF;
166:
167: -- Initialize API return status to SUCCESS
168: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
180:
182: FETCH C_Get_Score_ID_Name INTO l_score_Name;
183:
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);
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;
195: END IF;
197: END IF;
198:
199: -- Standard call to get message count and IF count is 1, get message info.
200:
201: FND_MSG_PUB.Count_And_Get
202: ( p_count => x_msg_count,
203: p_data => x_msg_data );
204:
205: END Validate_Score_ID_Name;
222: BEGIN
223: -- Initialize message list IF p_init_msg_list is set to TRUE.
224: IF FND_API.to_Boolean( p_init_msg_list )
225: THEN
226: FND_MSG_PUB.initialize;
227: END IF;
228:
229: -- Initialize API return status to SUCCESS
230: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
242:
244: FETCH C_Get_SCORE_COMP_Name INTO l_SCORE_COMP_NAME;
245:
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);
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;
257: END IF;
259: END IF;
260:
261: -- Standard call to get message count and IF count is 1, get message info.
262:
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data );
266:
267: END Validate_Score_Comp_Type_NAME;
286: BEGIN
287: -- Initialize message list IF p_init_msg_list is set to TRUE.
288: IF FND_API.to_Boolean( p_init_msg_list )
289: THEN
290: FND_MSG_PUB.initialize;
291: END IF;
292:
293: -- Initialize API return status to SUCCESS
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
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
306:
308: FETCH C_Get_SCORE_COMP_ID_Name INTO l_SCORE_COMP_NAME;
309:
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);
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;
321: END IF;
323: END IF;
324:
325: -- Standard call to get message count and IF count is 1, get message info.
326:
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,
329: p_data => x_msg_data );
330:
331: END Val_Score_Comp_Type_ID_NAME;
373:
374: -- Initialize message list IF p_init_msg_list is set to TRUE.
375: IF FND_API.to_Boolean( p_init_msg_list )
376: THEN
377: FND_MSG_PUB.initialize;
378: END IF;
379:
380: -- Debug Message
381: l_msg := 'iexvscrb:CreateScore:';
411: -- ******************************************************************
412: /*
413: IF FND_GLOBAL.User_Id IS NULL
414: THEN
415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
416: THEN
417: AS_UTILITY_PVT.Set_Message(
418: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
419: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
414: THEN
415: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
416: THEN
417: AS_UTILITY_PVT.Set_Message(
418: p_msg_level => FND_MSG_PUB.G_MSG_LVL_ERROR,
419: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
420: p_token1 => 'PROFILE',
421: p_token1_value => 'USER_ID');
422:
528: -- Debug Message
529: WriteLog(l_msg || 'END');
530:
531: -- Standard call to get message count and IF count is 1, get message info.
532: FND_MSG_PUB.Count_And_Get
533: ( p_count => x_msg_count,
534: p_data => x_msg_data);
535:
536: EXCEPTION
537: WHEN FND_API.G_EXC_ERROR THEN
538: ROLLBACK TO CREATE_SCORE_PVT;
539: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: exc exp:'||SQLERRM);
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: FND_MSG_PUB.Count_And_Get
542: ( p_count => x_msg_count,
543: p_data => x_msg_data);
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ROLLBACK TO CREATE_SCORE_PVT;
547: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: unexc exp:'||SQLERRM);
548: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
549: FND_MSG_PUB.Count_And_Get
550: ( p_count => x_msg_count,
551: p_data => x_msg_data);
552:
553: WHEN OTHERS THEN
553: WHEN OTHERS THEN
554: ROLLBACK TO CREATE_SCORE_PVT;
555: IEX_SCORE_PVT.WriteLog('iexvscrb:CreateScr: other exp:'||SQLERRM);
556: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
557: FND_MSG_PUB.Count_And_Get
558: ( p_count => x_msg_count,
559: p_data => x_msg_data);
560:
561: END CREATE_SCORE;
626:
627: -- Initialize message list IF p_init_msg_list is set to TRUE.
628: IF FND_API.to_Boolean( p_init_msg_list )
629: THEN
630: FND_MSG_PUB.initialize;
631: END IF;
632:
633: -- Debug Message
634: WriteLog('iexvscrb:UpdScr: Start');
689: l_score_ref_rec.SCORE_RANGE_HIGH,
690: l_score_ref_rec.OUT_OF_RANGE_RULE;
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;
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;
701:
705:
706: IF (l_score_rec.last_update_date is NULL or
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;
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;
717:
823: -- Debug Message
824: WriteLog('iexvscrb:UpdScr: End');
825:
826: -- Standard call to get message count and IF count is 1, get message info.
827: FND_MSG_PUB.Count_And_Get
828: ( p_count => x_msg_count,
829: p_data => x_msg_data );
830:
831: EXCEPTION
832: WHEN FND_API.G_EXC_ERROR THEN
833: ROLLBACK TO UPDATE_SCORE_PVT;
834: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: exc exp:'||SQLERRM);
835: x_return_status := FND_API.G_RET_STS_ERROR;
836: FND_MSG_PUB.Count_And_Get
837: ( p_count => x_msg_count,
838: p_data => x_msg_data);
839:
840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
840: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
841: ROLLBACK TO UPDATE_SCORE_PVT;
842: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: unexc exp:'||SQLERRM);
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data);
847:
848: WHEN OTHERS THEN
848: WHEN OTHERS THEN
849: ROLLBACK TO UPDATE_SCORE_PVT;
850: IEX_SCORE_PVT.WriteLog('iexvscrb:UpdateScr: other exp:'||SQLERRM);
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
852: FND_MSG_PUB.Count_And_Get
853: ( p_count => x_msg_count,
854: p_data => x_msg_data);
855:
856: END Update_Score;
913:
914: -- Initialize message list IF p_init_msg_list is set to TRUE.
915: IF FND_API.to_Boolean( p_init_msg_list )
916: THEN
917: FND_MSG_PUB.initialize;
918: END IF;
919:
920: -- Debug Message
921: WriteLog( 'iexvscrb: DelScr: Start');
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;
943:
1031:
1032: -- Debug Message
1033: WriteLog('iexvscrb:DeleteScore: End');
1034:
1035: FND_MSG_PUB.Count_And_Get
1036: ( p_count => x_msg_count,
1037: p_data => x_msg_data );
1038:
1039: EXCEPTION
1039: EXCEPTION
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: ROLLBACK TO DELETE_SCORE_PVT;
1042: x_return_status := FND_API.G_RET_STS_ERROR;
1043: FND_MSG_PUB.Count_And_Get
1044: ( p_count => x_msg_count,
1045: p_data => x_msg_data);
1046:
1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046:
1047: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1048: ROLLBACK TO DELETE_SCORE_PVT;
1049: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1050: FND_MSG_PUB.Count_And_Get
1051: ( p_count => x_msg_count,
1052: p_data => x_msg_data);
1053:
1054: WHEN OTHERS THEN
1053:
1054: WHEN OTHERS THEN
1055: ROLLBACK TO DELETE_SCORE_PVT;
1056: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1057: FND_MSG_PUB.Count_And_Get
1058: ( p_count => x_msg_count,
1059: p_data => x_msg_data);
1060:
1061: END Delete_Score;
1103:
1104: -- Initialize message list IF p_init_msg_list is set to TRUE.
1105: IF FND_API.to_Boolean( p_init_msg_list )
1106: THEN
1107: FND_MSG_PUB.initialize;
1108: END IF;
1109:
1110: -- Debug Message
1111: l_msg := 'iexvscrb:CreateScrComp:';
1209: -- Debug Message
1210: WriteLog(l_msg || 'End' );
1211:
1212: -- Standard call to get message count and IF count is 1, get message info.
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_count => x_msg_count,
1215: p_data => x_msg_data);
1216:
1217: EXCEPTION
1217: EXCEPTION
1218: WHEN FND_API.G_EXC_ERROR THEN
1219: ROLLBACK TO CREATE_SCORE_COMP_PVT;
1220: x_return_status := FND_API.G_RET_STS_ERROR;
1221: FND_MSG_PUB.Count_And_Get
1222: ( p_count => x_msg_count,
1223: p_data => x_msg_data);
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1224:
1225: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1226: ROLLBACK TO CREATE_SCORE_COMP_PVT;
1227: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1228: FND_MSG_PUB.Count_And_Get
1229: ( p_count => x_msg_count,
1230: p_data => x_msg_data);
1231:
1232: WHEN OTHERS THEN
1231:
1232: WHEN OTHERS THEN
1233: ROLLBACK TO CREATE_SCORE_COMP_PVT;
1234: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1235: FND_MSG_PUB.Count_And_Get
1236: ( p_count => x_msg_count,
1237: p_data => x_msg_data);
1238:
1239: END Create_Score_Comp;
1292:
1293: -- Initialize message list IF p_init_msg_list is set to TRUE.
1294: IF FND_API.to_Boolean( p_init_msg_list )
1295: THEN
1296: FND_MSG_PUB.initialize;
1297: END IF;
1298:
1299: -- Debug Message
1300: WriteLog('iexvscrb:UpdScrComp: Start');
1357: l_score_comp_ref_rec.CREATED_BY,
1358: l_score_comp_ref_rec.LAST_UPDATE_LOGIN;
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;
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;
1369:
1374:
1375: IF (l_score_comp_rec.last_update_date is NULL or
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;
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;
1386:
1445: WriteLog('iexvscrb:UpdScrComp: End');
1446:
1447:
1448: -- Standard call to get message count and IF count is 1, get message info.
1449: FND_MSG_PUB.Count_And_Get
1450: ( p_count => x_msg_count,
1451: p_data => x_msg_data );
1452:
1453: EXCEPTION
1453: EXCEPTION
1454: WHEN FND_API.G_EXC_ERROR THEN
1455: ROLLBACK TO UPDATE_SCORE_COMP_PVT;
1456: x_return_status := FND_API.G_RET_STS_ERROR;
1457: FND_MSG_PUB.Count_And_Get
1458: ( p_count => x_msg_count,
1459: p_data => x_msg_data);
1460:
1461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1460:
1461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1462: ROLLBACK TO UPDATE_SCORE_COMP_PVT;
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: FND_MSG_PUB.Count_And_Get
1465: ( p_count => x_msg_count,
1466: p_data => x_msg_data);
1467:
1468: WHEN OTHERS THEN
1467:
1468: WHEN OTHERS THEN
1469: ROLLBACK TO UPDATE_SCORE_COMP_PVT;
1470: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1471: FND_MSG_PUB.Count_And_Get
1472: ( p_count => x_msg_count,
1473: p_data => x_msg_data);
1474:
1475: END Update_SCORE_COMP;
1523:
1524: -- Initialize message list IF p_init_msg_list is set to TRUE.
1525: IF FND_API.to_Boolean( p_init_msg_list )
1526: THEN
1527: FND_MSG_PUB.initialize;
1528: END IF;
1529:
1530: -- Debug Message
1531:
1540: Fetch C_Get_SCORE_COMP into
1541: l_rowid;
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;
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;
1552:
1604:
1605: -- Debug Message
1606: WriteLog('iexvscrb:Delete_Score_Comp=>end');
1607:
1608: FND_MSG_PUB.Count_And_Get
1609: ( p_count => x_msg_count,
1610: p_data => x_msg_data );
1611:
1612: EXCEPTION
1612: EXCEPTION
1613: WHEN FND_API.G_EXC_ERROR THEN
1614: ROLLBACK TO DELETE_SCORE_COMP_PVT;
1615: x_return_status := FND_API.G_RET_STS_ERROR;
1616: FND_MSG_PUB.Count_And_Get
1617: ( p_count => x_msg_count,
1618: p_data => x_msg_data);
1619:
1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1619:
1620: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1621: ROLLBACK TO DELETE_SCORE_COMP_PVT;
1622: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1623: FND_MSG_PUB.Count_And_Get
1624: ( p_count => x_msg_count,
1625: p_data => x_msg_data);
1626:
1627: WHEN OTHERS THEN
1626:
1627: WHEN OTHERS THEN
1628: ROLLBACK TO DELETE_SCORE_COMP_PVT;
1629: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1630: FND_MSG_PUB.Count_And_Get
1631: ( p_count => x_msg_count,
1632: p_data => x_msg_data);
1633: END Delete_Score_Comp;
1634:
1680:
1681: -- Initialize message list IF p_init_msg_list is set to TRUE.
1682: IF FND_API.to_Boolean( p_init_msg_list )
1683: THEN
1684: FND_MSG_PUB.initialize;
1685: END IF;
1686:
1687: -- Debug Message
1688: WriteLog('iexvscrb:CreateScrCompType: Start');
1765: WriteLog('iexvscrb:CreateScrCompType: End');
1766:
1767:
1768: -- Standard call to get message count and IF count is 1, get message info.
1769: FND_MSG_PUB.Count_And_Get
1770: ( p_count => x_msg_count,
1771: p_data => x_msg_data);
1772:
1773: EXCEPTION
1773: EXCEPTION
1774: WHEN FND_API.G_EXC_ERROR THEN
1775: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PVT;
1776: x_return_status := FND_API.G_RET_STS_ERROR;
1777: FND_MSG_PUB.Count_And_Get
1778: ( p_count => x_msg_count,
1779: p_data => x_msg_data);
1780:
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1780:
1781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1782: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PVT;
1783: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1784: FND_MSG_PUB.Count_And_Get
1785: ( p_count => x_msg_count,
1786: p_data => x_msg_data);
1787:
1788: WHEN OTHERS THEN
1787:
1788: WHEN OTHERS THEN
1789: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PVT;
1790: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1791: FND_MSG_PUB.Count_And_Get
1792: ( p_count => x_msg_count,
1793: p_data => x_msg_data);
1794:
1795: END Create_Score_Comp_Type;
1869:
1870: -- Initialize message list IF p_init_msg_list is set to TRUE.
1871: IF FND_API.to_Boolean( p_init_msg_list )
1872: THEN
1873: FND_MSG_PUB.initialize;
1874: END IF;
1875:
1876: -- Debug Message
1877: WriteLog ('iexvscrb:UpdScrCompType: Start');
1903: l_score_comp_type_ref_rec.METRIC_flag,
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;
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;
1914:
1928: l_score_comp_type_ref_rec.LAST_UPDATE_LOGIN,
1929: l_score_comp_type_ref_rec.DESCRIPTION;
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;
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;
1940:
1944:
1945: IF (l_score_comp_type_rec.last_update_date is NULL or
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;
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;
1956:
2037: -- Debug Message
2038: WriteLog('iexvscrb:UpdScrCompType:End');
2039:
2040: -- Standard call to get message count and IF count is 1, get message info.
2041: FND_MSG_PUB.Count_And_Get
2042: ( p_count => x_msg_count,
2043: p_data => x_msg_data );
2044:
2045: EXCEPTION
2045: EXCEPTION
2046: WHEN FND_API.G_EXC_ERROR THEN
2047: ROLLBACK To UPDATE_Score_Comp_TYPE_PVT;
2048: x_return_status := FND_API.G_RET_STS_ERROR;
2049: FND_MSG_PUB.Count_And_Get
2050: ( p_count => x_msg_count,
2051: p_data => x_msg_data );
2052:
2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2052:
2053: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2054: ROLLBACK To UPDATE_Score_Comp_TYPE_PVT;
2055: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2056: FND_MSG_PUB.Count_And_Get
2057: ( p_count => x_msg_count,
2058: p_data => x_msg_data );
2059:
2060: WHEN OTHERS THEN
2059:
2060: WHEN OTHERS THEN
2061: ROLLBACK To UPDATE_Score_Comp_TYPE_PVT;
2062: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2063: FND_MSG_PUB.Count_And_Get
2064: ( p_count => x_msg_count,
2065: p_data => x_msg_data );
2066:
2067: END Update_SCORE_COMP_TYPE;
2109:
2110: -- Initialize message list IF p_init_msg_list is set to TRUE.
2111: IF FND_API.to_Boolean( p_init_msg_list )
2112: THEN
2113: FND_MSG_PUB.initialize;
2114: END IF;
2115:
2116: -- Debug Message
2117: WriteLog('iexvscrb:DelScrCompType:Start');
2128: Fetch C_Get_TYPE into
2129: l_rowid;
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;
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;
2140:
2166:
2167: -- Debug Message
2168: WriteLog('iexvscrb:DelScrCompType:End');
2169:
2170: FND_MSG_PUB.Count_And_Get
2171: ( p_count => x_msg_count,
2172: p_data => x_msg_data );
2173:
2174: EXCEPTION
2174: EXCEPTION
2175: WHEN FND_API.G_EXC_ERROR THEN
2176: ROLLBACK To DELETE_Score_Comp_TYPE_PVT;
2177: x_return_status := FND_API.G_RET_STS_ERROR;
2178: FND_MSG_PUB.Count_And_Get
2179: ( p_count => x_msg_count,
2180: p_data => x_msg_data );
2181:
2182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2181:
2182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2183: ROLLBACK To DELETE_Score_Comp_TYPE_PVT;
2184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2185: FND_MSG_PUB.Count_And_Get
2186: ( p_count => x_msg_count,
2187: p_data => x_msg_data );
2188:
2189: WHEN OTHERS THEN
2188:
2189: WHEN OTHERS THEN
2190: ROLLBACK To DELETE_Score_Comp_TYPE_PVT;
2191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2192: FND_MSG_PUB.Count_And_Get
2193: ( p_count => x_msg_count,
2194: p_data => x_msg_data );
2195:
2196: END Delete_Score_comp_TYpe;
2240:
2241: -- Initialize message list IF p_init_msg_list is set to TRUE.
2242: IF FND_API.to_Boolean( p_init_msg_list )
2243: THEN
2244: FND_MSG_PUB.initialize;
2245: END IF;
2246:
2247: -- Debug Message
2248: l_msg := 'iexvscrb:CreateScrCompDet:';
2335: -- Debug Message
2336: WriteLog(l_msg || 'END');
2337:
2338: -- Standard call to get message count and IF count is 1, get message info.
2339: FND_MSG_PUB.Count_And_Get
2340: ( p_count => x_msg_count,
2341: p_data => x_msg_data
2342: );
2343:
2344: EXCEPTION
2345: WHEN FND_API.G_EXC_ERROR THEN
2346: ROLLBACK To CREATE_Score_Comp_DET_PVT;
2347: x_return_status := FND_API.G_RET_STS_ERROR;
2348: FND_MSG_PUB.Count_And_Get
2349: ( p_count => x_msg_count,
2350: p_data => x_msg_data );
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2351:
2352: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2353: ROLLBACK To CREATE_Score_Comp_DET_PVT;
2354: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2355: FND_MSG_PUB.Count_And_Get
2356: ( p_count => x_msg_count,
2357: p_data => x_msg_data );
2358:
2359: WHEN OTHERS THEN
2358:
2359: WHEN OTHERS THEN
2360: ROLLBACK To CREATE_Score_Comp_DET_PVT;
2361: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2362: FND_MSG_PUB.Count_And_Get
2363: ( p_count => x_msg_count,
2364: p_data => x_msg_data );
2365:
2366: END Create_Score_Comp_det;
2423:
2424: -- Initialize message list IF p_init_msg_list is set to TRUE.
2425: IF FND_API.to_Boolean( p_init_msg_list )
2426: THEN
2427: FND_MSG_PUB.initialize;
2428: END IF;
2429:
2430: -- Debug Message
2431: WriteLog('iexvscrb:UpdScrCompDet: Start');
2458: l_score_comp_det_ref_rec.CREATED_BY,
2459: l_score_comp_det_ref_rec.LAST_UPDATE_LOGIN;
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;
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;
2470:
2476:
2477: IF (l_score_comp_det_rec.last_update_date is NULL or
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;
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;
2488:
2558: WriteLog('iexvscrb: UpdSrCompDet: End');
2559:
2560:
2561: -- Standard call to get message count and IF count is 1, get message info.
2562: FND_MSG_PUB.Count_And_Get
2563: ( p_count => x_msg_count,
2564: p_data => x_msg_data );
2565:
2566: EXCEPTION
2566: EXCEPTION
2567: WHEN FND_API.G_EXC_ERROR THEN
2568: ROLLBACK To UPDATE_Score_Comp_DET_PVT;
2569: x_return_status := FND_API.G_RET_STS_ERROR;
2570: FND_MSG_PUB.Count_And_Get
2571: ( p_count => x_msg_count,
2572: p_data => x_msg_data );
2573:
2574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2573:
2574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2575: ROLLBACK To UPDATE_Score_Comp_DET_PVT;
2576: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2577: FND_MSG_PUB.Count_And_Get
2578: ( p_count => x_msg_count,
2579: p_data => x_msg_data );
2580:
2581: WHEN OTHERS THEN
2580:
2581: WHEN OTHERS THEN
2582: ROLLBACK To UPDATE_Score_Comp_DET_PVT;
2583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2584: FND_MSG_PUB.Count_And_Get
2585: ( p_count => x_msg_count,
2586: p_data => x_msg_data );
2587: END Update_SCORE_COMP_DET;
2588:
2626:
2627: -- Initialize message list IF p_init_msg_list is set to TRUE.
2628: IF FND_API.to_Boolean( p_init_msg_list )
2629: THEN
2630: FND_MSG_PUB.initialize;
2631: END IF;
2632:
2633: -- Debug Message
2634: WriteLog('iexvscrb: DelSrCompDet: Start');
2645: Fetch C_Get_SCORE_COMP_DET into
2646: l_rowid;
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;
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;
2657:
2680:
2681: -- Debug Message
2682: WriteLog('iexvscrb: DelScrCompDet: End');
2683:
2684: FND_MSG_PUB.Count_And_Get
2685: ( p_count => x_msg_count,
2686: p_data => x_msg_data );
2687:
2688: EXCEPTION
2688: EXCEPTION
2689: WHEN FND_API.G_EXC_ERROR THEN
2690: ROLLBACK To DELETE_Score_Comp_DET_PVT;
2691: x_return_status := FND_API.G_RET_STS_ERROR;
2692: FND_MSG_PUB.Count_And_Get
2693: ( p_count => x_msg_count,
2694: p_data => x_msg_data );
2695:
2696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2695:
2696: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2697: ROLLBACK To DELETE_Score_Comp_DET_PVT;
2698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2699: FND_MSG_PUB.Count_And_Get
2700: ( p_count => x_msg_count,
2701: p_data => x_msg_data );
2702:
2703: WHEN OTHERS THEN
2702:
2703: WHEN OTHERS THEN
2704: ROLLBACK To DELETE_Score_Comp_DET_PVT;
2705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2706: FND_MSG_PUB.Count_And_Get
2707: ( p_count => x_msg_count,
2708: p_data => x_msg_data );
2709: END Delete_Score_Comp_Det;
2710:
2842:
2843: -- Initialize message list IF p_init_msg_list is set to TRUE.
2844: IF FND_API.to_Boolean( p_init_msg_list )
2845: THEN
2846: FND_MSG_PUB.initialize;
2847: END IF;
2848:
2849:
2850: -- Initialize API return status to SUCCESS
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:
2893: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: len(scrname)= '||l_len);
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;
2921: GOTO END_COPY;
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:
3121: l_filter_name := 'Copy Of ' || l_filter_rec.object_filter_name;
3239: COMMIT WORK;
3240: END IF;
3241:
3242:
3243: FND_MSG_PUB.Count_And_Get
3244: ( p_count => x_msg_count,
3245: p_data => x_msg_data );
3246:
3247: EXCEPTION
3248: WHEN FND_API.G_EXC_ERROR THEN
3249: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: exc exp:'||SQLERRM);
3250: ROLLBACK To Copy_ScoringEngine_PVT;
3251: x_return_status := FND_API.G_RET_STS_ERROR;
3252: FND_MSG_PUB.Count_And_Get
3253: ( p_count => x_msg_count,
3254: p_data => x_msg_data );
3255:
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: ROLLBACK To Copy_ScoringEngine_PVT;
3258: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: unexc exp:'||SQLERRM);
3259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3260: FND_MSG_PUB.Count_And_Get
3261: ( p_count => x_msg_count,
3262: p_data => x_msg_data );
3263:
3264: WHEN OTHERS THEN
3264: WHEN OTHERS THEN
3265: ROLLBACK To Copy_ScoringEngine_PVT;
3266: IEX_SCORE_PVT.WriteLog('iexvscrb:Copy_SE: other exp:'||SQLERRM);
3267: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3268: FND_MSG_PUB.Count_And_Get
3269: ( p_count => x_msg_count,
3270: p_data => x_msg_data );
3271:
3272: END Copy_ScoringEngine;
3360:
3361: -- Initialize message list IF p_init_msg_list is set to TRUE.
3362: IF FND_API.to_Boolean( p_init_msg_list )
3363: THEN
3364: FND_MSG_PUB.initialize;
3365: END IF;
3366:
3367: -- Debug Message
3368:
3515: END IF;
3516:
3517: -- Debug Message
3518:
3519: FND_MSG_PUB.Count_And_Get
3520: ( p_count => x_msg_count,
3521: p_data => x_msg_data );
3522:
3523: EXCEPTION
3524: WHEN FND_API.G_EXC_ERROR THEN
3525: as_utility_pvt.HANDLE_EXCEPTIONS(
3526: P_API_NAME => L_API_NAME
3527: ,P_PKG_NAME => G_PKG_NAME
3528: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3529: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3530: ,X_MSG_COUNT => X_MSG_COUNT
3531: ,X_MSG_DATA => X_MSG_DATA
3532: ,X_RETURN_STATUS => X_RETURN_STATUS);
3534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3535: as_utility_pvt.HANDLE_EXCEPTIONS(
3536: P_API_NAME => L_API_NAME
3537: ,P_PKG_NAME => G_PKG_NAME
3538: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3539: ,P_PACKAGE_TYPE => AS_UTILITY_PVT.G_PVT
3540: ,X_MSG_COUNT => X_MSG_COUNT
3541: ,X_MSG_DATA => X_MSG_DATA
3542: ,X_RETURN_STATUS => X_RETURN_STATUS);
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
3620: l_score_id := p_score_id;