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.

APPS.AMS_SCORERESULT_PVT dependencies on FND_API

Line 101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

97:
98: -- Hint: Primary key needs to be returned.
99: PROCEDURE Create_Scoreresult(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,

Line 102: p_commit IN VARCHAR2 := FND_API.G_FALSE,

98: -- Hint: Primary key needs to be returned.
99: PROCEDURE Create_Scoreresult(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,

Line 103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

99: PROCEDURE Create_Scoreresult(
100: p_api_version IN NUMBER,
101: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
102: p_commit IN VARCHAR2 := FND_API.G_FALSE,
103: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
104:
105: x_return_status OUT NOCOPY VARCHAR2,
106: x_msg_count OUT NOCOPY NUMBER,
107: x_msg_data OUT NOCOPY VARCHAR2,

Line 118: l_org_id NUMBER := FND_API.G_MISS_NUM;

114: L_API_NAME CONSTANT VARCHAR2(30) := 'Create_Scoreresult';
115: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
116: l_return_status_full VARCHAR2(1);
117: l_object_version_number NUMBER := 1;
118: l_org_id NUMBER := FND_API.G_MISS_NUM;
119: l_SCORE_RESULT_ID NUMBER;
120: l_dummy NUMBER;
121:
122: CURSOR c_id IS

Line 136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

132: -- Standard Start of API savepoint
133: SAVEPOINT CREATE_Scoreresult_PVT;
134:
135: -- Standard call to check for call compatibility.
136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
137: p_api_version,
138: l_api_name,
139: G_PKG_NAME)
140: THEN

Line 141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

137: p_api_version,
138: l_api_name,
139: G_PKG_NAME)
140: THEN
141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: -- Initialize message list if p_init_msg_list is set to TRUE.
145: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 145: IF FND_API.to_Boolean( p_init_msg_list ) THEN

141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
142: END IF;
143:
144: -- Initialize message list if p_init_msg_list is set to TRUE.
145: IF FND_API.to_Boolean( p_init_msg_list ) THEN
146: FND_MSG_PUB.initialize;
147: END IF;
148:
149: -- Debug Message

Line 157: x_return_status := FND_API.G_RET_STS_SUCCESS;

153: END IF;
154:
155:
156: -- Initialize API return status to SUCCESS
157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159: -- Local variable initialization
160:
161: IF p_scoreresult_rec.SCORE_RESULT_ID IS NULL OR p_scoreresult_rec.SCORE_RESULT_ID = FND_API.g_miss_num THEN

Line 161: IF p_scoreresult_rec.SCORE_RESULT_ID IS NULL OR p_scoreresult_rec.SCORE_RESULT_ID = FND_API.g_miss_num THEN

157: x_return_status := FND_API.G_RET_STS_SUCCESS;
158:
159: -- Local variable initialization
160:
161: IF p_scoreresult_rec.SCORE_RESULT_ID IS NULL OR p_scoreresult_rec.SCORE_RESULT_ID = FND_API.g_miss_num THEN
162: LOOP
163: l_dummy := NULL;
164: OPEN c_id;
165: FETCH c_id INTO l_SCORE_RESULT_ID;

Line 179: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

175: -- =========================================================================
176: -- Validate Environment
177: -- =========================================================================
178:
179: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
180: THEN
181: -- Debug message
182: IF (AMS_DEBUG_HIGH_ON) THEN
183:

Line 190: p_init_msg_list => FND_API.G_FALSE,

186:
187: -- Invoke validation procedures
188: Validate_scoreresult(
189: p_api_version => 1.0,
190: p_init_msg_list => FND_API.G_FALSE,
191: p_validation_level => p_validation_level,
192: p_validation_mode => JTF_PLSQL_API.g_create,
193: p_scoreresult_rec => p_scoreresult_rec,
194: x_return_status => x_return_status,

Line 197: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

193: p_scoreresult_rec => p_scoreresult_rec,
194: x_return_status => x_return_status,
195: x_msg_count => x_msg_count,
196: x_msg_data => x_msg_data);
197: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: END IF;
201:

Line 198: RAISE FND_API.G_EXC_ERROR;

194: x_return_status => x_return_status,
195: x_msg_count => x_msg_count,
196: x_msg_data => x_msg_data);
197: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200: END IF;
201:
202: -- Debug Message

Line 223: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

219: p_num_records => p_scoreresult_rec.num_records,
220: p_score => p_scoreresult_rec.score,
221: p_confidence => p_scoreresult_rec.confidence
222: );
223: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: x_score_result_id := l_score_result_id;

Line 224: RAISE FND_API.G_EXC_ERROR;

220: p_score => p_scoreresult_rec.score,
221: p_confidence => p_scoreresult_rec.confidence
222: );
223: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227: x_score_result_id := l_score_result_id;
228:

Line 234: IF FND_API.to_Boolean( p_commit )

230: -- End of API body
231: --
232:
233: -- Standard check for p_commit
234: IF FND_API.to_Boolean( p_commit )
235: THEN
236: COMMIT WORK;
237: END IF;
238:

Line 254: x_return_status := FND_API.g_ret_sts_error;

250: );
251: EXCEPTION
252:
253: WHEN AMS_Utility_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Scoreresult_PVT;

Line 257: WHEN FND_API.G_EXC_ERROR THEN

253: WHEN AMS_Utility_PVT.resource_locked THEN
254: x_return_status := FND_API.g_ret_sts_error;
255: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Scoreresult_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (

Line 259: x_return_status := FND_API.G_RET_STS_ERROR;

255: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
256:
257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Scoreresult_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,

Line 262: p_encoded => FND_API.G_FALSE,

258: ROLLBACK TO CREATE_Scoreresult_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:

Line 267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO CREATE_Scoreresult_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (

Line 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: );
266:
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO CREATE_Scoreresult_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,

Line 272: p_encoded => FND_API.G_FALSE,

268: ROLLBACK TO CREATE_Scoreresult_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
275: );
276:

Line 279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

275: );
276:
277: WHEN OTHERS THEN
278: ROLLBACK TO CREATE_Scoreresult_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;

Line 286: p_encoded => FND_API.G_FALSE,

282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data
289: );
290: End Create_Scoreresult;

Line 295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

291:
292:
293: PROCEDURE Update_Scoreresult(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298:
299: x_return_status OUT NOCOPY VARCHAR2,

Line 296: p_commit IN VARCHAR2 := FND_API.G_FALSE,

292:
293: PROCEDURE Update_Scoreresult(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298:
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,

Line 297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

293: PROCEDURE Update_Scoreresult(
294: p_api_version IN NUMBER,
295: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
296: p_commit IN VARCHAR2 := FND_API.G_FALSE,
297: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
298:
299: x_return_status OUT NOCOPY VARCHAR2,
300: x_msg_count OUT NOCOPY NUMBER,
301: x_msg_data OUT NOCOPY VARCHAR2,

Line 324: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

320: -- Standard Start of API savepoint
321: SAVEPOINT UPDATE_Scoreresult_PVT;
322:
323: -- Standard call to check for call compatibility.
324: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
325: p_api_version,
326: l_api_name,
327: G_PKG_NAME)
328: THEN

Line 329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

325: p_api_version,
326: l_api_name,
327: G_PKG_NAME)
328: THEN
329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list )

Line 333: IF FND_API.to_Boolean( p_init_msg_list )

329: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
330: END IF;
331:
332: -- Initialize message list if p_init_msg_list is set to TRUE.
333: IF FND_API.to_Boolean( p_init_msg_list )
334: THEN
335: FND_MSG_PUB.initialize;
336: END IF;
337:

Line 346: x_return_status := FND_API.G_RET_STS_SUCCESS;

342: END IF;
343:
344:
345: -- Initialize API return status to SUCCESS
346: x_return_status := FND_API.G_RET_STS_SUCCESS;
347:
348: -- Debug Message
349: IF (AMS_DEBUG_HIGH_ON) THEN
350:

Line 362: RAISE FND_API.G_EXC_ERROR;

358: IF ( c_get_Scoreresult%NOTFOUND) THEN
359: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
360: p_token_name => 'INFO',
361: p_token_value => 'Scoreresult') ;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: -- Debug Message
365: IF (AMS_DEBUG_HIGH_ON) THEN
366:

Line 376: RAISE FND_API.G_EXC_ERROR;

372: IF (l_tar_scoreresult_rec.object_version_number <> l_ref_scoreresult_rec.object_version_number) THEN
373: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
374: p_token_name => 'INFO',
375: p_token_value => 'Scoreresult') ;
376: RAISE FND_API.G_EXC_ERROR;
377: End if;
378: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
379: -- Debug message
380: IF (AMS_DEBUG_HIGH_ON) THEN

Line 378: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN

374: p_token_name => 'INFO',
375: p_token_value => 'Scoreresult') ;
376: RAISE FND_API.G_EXC_ERROR;
377: End if;
378: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
379: -- Debug message
380: IF (AMS_DEBUG_HIGH_ON) THEN
381:
382: AMS_UTILITY_PVT.debug_message('Private API: Validate_Scoreresult');

Line 388: p_init_msg_list => FND_API.G_FALSE,

384:
385: -- Invoke validation procedures
386: Validate_scoreresult(
387: p_api_version => 1.0,
388: p_init_msg_list => FND_API.G_FALSE,
389: p_validation_level => p_validation_level,
390: p_validation_mode => JTF_PLSQL_API.g_update,
391: p_scoreresult_rec => p_scoreresult_rec,
392: x_return_status => x_return_status,

Line 395: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

391: p_scoreresult_rec => p_scoreresult_rec,
392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data);
395: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398: END IF;
399:

Line 396: RAISE FND_API.G_EXC_ERROR;

392: x_return_status => x_return_status,
393: x_msg_count => x_msg_count,
394: x_msg_data => x_msg_data);
395: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
396: RAISE FND_API.G_EXC_ERROR;
397: END IF;
398: END IF;
399:
400: -- Debug Message

Line 426: IF FND_API.to_Boolean( p_commit )

422: -- End of API body.
423: --
424:
425: -- Standard check for p_commit
426: IF FND_API.to_Boolean( p_commit )
427: THEN
428: COMMIT WORK;
429: END IF;
430:

Line 446: x_return_status := FND_API.g_ret_sts_error;

442: );
443: EXCEPTION
444:
445: WHEN AMS_Utility_PVT.resource_locked THEN
446: x_return_status := FND_API.g_ret_sts_error;
447: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
448:
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO UPDATE_Scoreresult_PVT;

Line 449: WHEN FND_API.G_EXC_ERROR THEN

445: WHEN AMS_Utility_PVT.resource_locked THEN
446: x_return_status := FND_API.g_ret_sts_error;
447: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
448:
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO UPDATE_Scoreresult_PVT;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (

Line 451: x_return_status := FND_API.G_RET_STS_ERROR;

447: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
448:
449: WHEN FND_API.G_EXC_ERROR THEN
450: ROLLBACK TO UPDATE_Scoreresult_PVT;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,

Line 454: p_encoded => FND_API.G_FALSE,

450: ROLLBACK TO UPDATE_Scoreresult_PVT;
451: x_return_status := FND_API.G_RET_STS_ERROR;
452: -- Standard call to get message count and if count=1, get the message
453: FND_MSG_PUB.Count_And_Get (
454: p_encoded => FND_API.G_FALSE,
455: p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458:

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

455: p_count => x_msg_count,
456: p_data => x_msg_data
457: );
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO UPDATE_Scoreresult_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (

Line 461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

457: );
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: ROLLBACK TO UPDATE_Scoreresult_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,

Line 464: p_encoded => FND_API.G_FALSE,

460: ROLLBACK TO UPDATE_Scoreresult_PVT;
461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,
466: p_data => x_msg_data
467: );
468:

Line 471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

467: );
468:
469: WHEN OTHERS THEN
470: ROLLBACK TO UPDATE_Scoreresult_PVT;
471: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
472: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
473: THEN
474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;

Line 478: p_encoded => FND_API.G_FALSE,

474: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
475: END IF;
476: -- Standard call to get message count and if count=1, get the message
477: FND_MSG_PUB.Count_And_Get (
478: p_encoded => FND_API.G_FALSE,
479: p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482: End Update_Scoreresult;

Line 487: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

483:
484:
485: PROCEDURE Delete_Scoreresult(
486: p_api_version IN NUMBER,
487: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
488: p_commit IN VARCHAR2 := FND_API.G_FALSE,
489: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
490: x_return_status OUT NOCOPY VARCHAR2,
491: x_msg_count OUT NOCOPY NUMBER,

Line 488: p_commit IN VARCHAR2 := FND_API.G_FALSE,

484:
485: PROCEDURE Delete_Scoreresult(
486: p_api_version IN NUMBER,
487: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
488: p_commit IN VARCHAR2 := FND_API.G_FALSE,
489: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
490: x_return_status OUT NOCOPY VARCHAR2,
491: x_msg_count OUT NOCOPY NUMBER,
492: x_msg_data OUT NOCOPY VARCHAR2,

Line 489: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

485: PROCEDURE Delete_Scoreresult(
486: p_api_version IN NUMBER,
487: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
488: p_commit IN VARCHAR2 := FND_API.G_FALSE,
489: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
490: x_return_status OUT NOCOPY VARCHAR2,
491: x_msg_count OUT NOCOPY NUMBER,
492: x_msg_data OUT NOCOPY VARCHAR2,
493: p_score_result_id IN NUMBER,

Line 504: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

500: -- Standard Start of API savepoint
501: SAVEPOINT DELETE_Scoreresult_PVT;
502:
503: -- Standard call to check for call compatibility.
504: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
505: p_api_version,
506: l_api_name,
507: G_PKG_NAME)
508: THEN

Line 509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

505: p_api_version,
506: l_api_name,
507: G_PKG_NAME)
508: THEN
509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean( p_init_msg_list )

Line 513: IF FND_API.to_Boolean( p_init_msg_list )

509: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
510: END IF;
511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean( p_init_msg_list )
514: THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:

Line 526: x_return_status := FND_API.G_RET_STS_SUCCESS;

522: END IF;
523:
524:
525: -- Initialize API return status to SUCCESS
526: x_return_status := FND_API.G_RET_STS_SUCCESS;
527:
528: --
529: -- Api body
530: --

Line 545: IF FND_API.to_Boolean( p_commit )

541: -- End of API body
542: --
543:
544: -- Standard check for p_commit
545: IF FND_API.to_Boolean( p_commit )
546: THEN
547: COMMIT WORK;
548: END IF;
549:

Line 565: x_return_status := FND_API.g_ret_sts_error;

561: );
562: EXCEPTION
563:
564: WHEN AMS_Utility_PVT.resource_locked THEN
565: x_return_status := FND_API.g_ret_sts_error;
566: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
567:
568: WHEN FND_API.G_EXC_ERROR THEN
569: ROLLBACK TO DELETE_Scoreresult_PVT;

Line 568: WHEN FND_API.G_EXC_ERROR THEN

564: WHEN AMS_Utility_PVT.resource_locked THEN
565: x_return_status := FND_API.g_ret_sts_error;
566: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
567:
568: WHEN FND_API.G_EXC_ERROR THEN
569: ROLLBACK TO DELETE_Scoreresult_PVT;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: -- Standard call to get message count and if count=1, get the message
572: FND_MSG_PUB.Count_And_Get (

Line 570: x_return_status := FND_API.G_RET_STS_ERROR;

566: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
567:
568: WHEN FND_API.G_EXC_ERROR THEN
569: ROLLBACK TO DELETE_Scoreresult_PVT;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: -- Standard call to get message count and if count=1, get the message
572: FND_MSG_PUB.Count_And_Get (
573: p_encoded => FND_API.G_FALSE,
574: p_count => x_msg_count,

Line 573: p_encoded => FND_API.G_FALSE,

569: ROLLBACK TO DELETE_Scoreresult_PVT;
570: x_return_status := FND_API.G_RET_STS_ERROR;
571: -- Standard call to get message count and if count=1, get the message
572: FND_MSG_PUB.Count_And_Get (
573: p_encoded => FND_API.G_FALSE,
574: p_count => x_msg_count,
575: p_data => x_msg_data
576: );
577:

Line 578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

574: p_count => x_msg_count,
575: p_data => x_msg_data
576: );
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO DELETE_Scoreresult_PVT;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: -- Standard call to get message count and if count=1, get the message
582: FND_MSG_PUB.Count_And_Get (

Line 580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

576: );
577:
578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO DELETE_Scoreresult_PVT;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: -- Standard call to get message count and if count=1, get the message
582: FND_MSG_PUB.Count_And_Get (
583: p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,

Line 583: p_encoded => FND_API.G_FALSE,

579: ROLLBACK TO DELETE_Scoreresult_PVT;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: -- Standard call to get message count and if count=1, get the message
582: FND_MSG_PUB.Count_And_Get (
583: p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => x_msg_data
586: );
587:

Line 590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

586: );
587:
588: WHEN OTHERS THEN
589: ROLLBACK TO DELETE_Scoreresult_PVT;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
594: END IF;

Line 597: p_encoded => FND_API.G_FALSE,

593: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
594: END IF;
595: -- Standard call to get message count and if count=1, get the message
596: FND_MSG_PUB.Count_And_Get (
597: p_encoded => FND_API.G_FALSE,
598: p_count => x_msg_count,
599: p_data => x_msg_data
600: );
601: End Delete_Scoreresult;

Line 608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

604:
605: -- Hint: Primary key needs to be returned.
606: PROCEDURE Lock_Scoreresult(
607: p_api_version IN NUMBER,
608: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
609:
610: x_return_status OUT NOCOPY VARCHAR2,
611: x_msg_count OUT NOCOPY NUMBER,
612: x_msg_data OUT NOCOPY VARCHAR2,

Line 639: IF FND_API.to_Boolean( p_init_msg_list )

635: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
636: END IF;
637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )
640: THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:

Line 645: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

641: FND_MSG_PUB.initialize;
642: END IF;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
646: p_api_version,
647: l_api_name,
648: G_PKG_NAME)
649: THEN

Line 650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

646: p_api_version,
647: l_api_name,
648: G_PKG_NAME)
649: THEN
650: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
651: END IF;
652:
653:
654: -- Initialize API return status to SUCCESS

Line 655: x_return_status := FND_API.G_RET_STS_SUCCESS;

651: END IF;
652:
653:
654: -- Initialize API return status to SUCCESS
655: x_return_status := FND_API.G_RET_STS_SUCCESS;
656:
657:
658: ------------------------ lock -------------------------
659:

Line 677: RAISE FND_API.g_exc_error;

673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
674: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
675: FND_MSG_PUB.add;
676: END IF;
677: RAISE FND_API.g_exc_error;
678: END IF;
679:
680: CLOSE c_Scoreresult;
681:

Line 684: p_encoded => FND_API.g_false,

680: CLOSE c_Scoreresult;
681:
682: -------------------- finish --------------------------
683: FND_MSG_PUB.count_and_get(
684: p_encoded => FND_API.g_false,
685: p_count => x_msg_count,
686: p_data => x_msg_data);
687: IF (AMS_DEBUG_HIGH_ON) THEN
688:

Line 694: x_return_status := FND_API.g_ret_sts_error;

690: END IF;
691: EXCEPTION
692:
693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Scoreresult_PVT;

Line 697: WHEN FND_API.G_EXC_ERROR THEN

693: WHEN AMS_Utility_PVT.resource_locked THEN
694: x_return_status := FND_API.g_ret_sts_error;
695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Scoreresult_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (

Line 699: x_return_status := FND_API.G_RET_STS_ERROR;

695: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
696:
697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Scoreresult_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,

Line 702: p_encoded => FND_API.G_FALSE,

698: ROLLBACK TO LOCK_Scoreresult_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data
705: );
706:

Line 707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

703: p_count => x_msg_count,
704: p_data => x_msg_data
705: );
706:
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO LOCK_Scoreresult_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (

Line 709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

705: );
706:
707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO LOCK_Scoreresult_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,

Line 712: p_encoded => FND_API.G_FALSE,

708: ROLLBACK TO LOCK_Scoreresult_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: );
716:

Line 719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

715: );
716:
717: WHEN OTHERS THEN
718: ROLLBACK TO LOCK_Scoreresult_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;

Line 726: p_encoded => FND_API.G_FALSE,

722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );
730: End Lock_Scoreresult;

Line 741: x_return_status := FND_API.g_ret_sts_success;

737: IS
738: l_valid_flag VARCHAR2(1);
739:
740: BEGIN
741: x_return_status := FND_API.g_ret_sts_success;
742: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
743: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
744: 'AMS_DM_SCORE_RESULTS',
745: 'SCORE_RESULT_ID = ''' || p_scoreresult_rec.SCORE_RESULT_ID ||''''

Line 755: IF l_valid_flag = FND_API.g_false THEN

751: ''' AND SCORE_RESULT_ID <> ' || p_scoreresult_rec.SCORE_RESULT_ID
752: );
753: END IF;
754:
755: IF l_valid_flag = FND_API.g_false THEN
756: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','SCORE_RESULT_ID');
757: x_return_status := FND_API.g_ret_sts_error;
758: END IF;
759:

Line 757: x_return_status := FND_API.g_ret_sts_error;

753: END IF;
754:
755: IF l_valid_flag = FND_API.g_false THEN
756: AMS_Utility_PVT.Error_Message('AMS_API_DUPLICATE_ID', 'ID_FIELD','SCORE_RESULT_ID');
757: x_return_status := FND_API.g_ret_sts_error;
758: END IF;
759:
760: END check_scoreresult_uk_items;
761:

Line 769: x_return_status := FND_API.g_ret_sts_success;

765: x_return_status OUT NOCOPY VARCHAR2
766: )
767: IS
768: BEGIN
769: x_return_status := FND_API.g_ret_sts_success;
770:
771: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
772: IF p_scoreresult_rec.score_id = FND_API.g_miss_num OR p_scoreresult_rec.score_id IS NULL THEN
773: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE_ID');

Line 772: IF p_scoreresult_rec.score_id = FND_API.g_miss_num OR p_scoreresult_rec.score_id IS NULL THEN

768: BEGIN
769: x_return_status := FND_API.g_ret_sts_success;
770:
771: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
772: IF p_scoreresult_rec.score_id = FND_API.g_miss_num OR p_scoreresult_rec.score_id IS NULL THEN
773: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE_ID');
774: x_return_status := FND_API.g_ret_sts_error;
775: END IF;
776:

Line 774: x_return_status := FND_API.g_ret_sts_error;

770:
771: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
772: IF p_scoreresult_rec.score_id = FND_API.g_miss_num OR p_scoreresult_rec.score_id IS NULL THEN
773: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE_ID');
774: x_return_status := FND_API.g_ret_sts_error;
775: END IF;
776:
777:
778: IF p_scoreresult_rec.decile = FND_API.g_miss_char OR p_scoreresult_rec.decile IS NULL THEN

Line 778: IF p_scoreresult_rec.decile = FND_API.g_miss_char OR p_scoreresult_rec.decile IS NULL THEN

774: x_return_status := FND_API.g_ret_sts_error;
775: END IF;
776:
777:
778: IF p_scoreresult_rec.decile = FND_API.g_miss_char OR p_scoreresult_rec.decile IS NULL THEN
779: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_DECILE');
780: x_return_status := FND_API.g_ret_sts_error;
781: END IF;
782:

Line 780: x_return_status := FND_API.g_ret_sts_error;

776:
777:
778: IF p_scoreresult_rec.decile = FND_API.g_miss_char OR p_scoreresult_rec.decile IS NULL THEN
779: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_DECILE');
780: x_return_status := FND_API.g_ret_sts_error;
781: END IF;
782:
783:
784: IF p_scoreresult_rec.num_records = FND_API.g_miss_num OR p_scoreresult_rec.num_records IS NULL THEN

Line 784: IF p_scoreresult_rec.num_records = FND_API.g_miss_num OR p_scoreresult_rec.num_records IS NULL THEN

780: x_return_status := FND_API.g_ret_sts_error;
781: END IF;
782:
783:
784: IF p_scoreresult_rec.num_records = FND_API.g_miss_num OR p_scoreresult_rec.num_records IS NULL THEN
785: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_NUM_RECORDS');
786: x_return_status := FND_API.g_ret_sts_error;
787: END IF;
788:

Line 786: x_return_status := FND_API.g_ret_sts_error;

782:
783:
784: IF p_scoreresult_rec.num_records = FND_API.g_miss_num OR p_scoreresult_rec.num_records IS NULL THEN
785: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_NUM_RECORDS');
786: x_return_status := FND_API.g_ret_sts_error;
787: END IF;
788:
789:
790: IF p_scoreresult_rec.score = FND_API.g_miss_char OR p_scoreresult_rec.score IS NULL THEN

Line 790: IF p_scoreresult_rec.score = FND_API.g_miss_char OR p_scoreresult_rec.score IS NULL THEN

786: x_return_status := FND_API.g_ret_sts_error;
787: END IF;
788:
789:
790: IF p_scoreresult_rec.score = FND_API.g_miss_char OR p_scoreresult_rec.score IS NULL THEN
791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE');
792: x_return_status := FND_API.g_ret_sts_error;
793: END IF;
794:

Line 792: x_return_status := FND_API.g_ret_sts_error;

788:
789:
790: IF p_scoreresult_rec.score = FND_API.g_miss_char OR p_scoreresult_rec.score IS NULL THEN
791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE');
792: x_return_status := FND_API.g_ret_sts_error;
793: END IF;
794:
795:
796: IF p_scoreresult_rec.confidence = FND_API.g_miss_num OR p_scoreresult_rec.confidence IS NULL THEN

Line 796: IF p_scoreresult_rec.confidence = FND_API.g_miss_num OR p_scoreresult_rec.confidence IS NULL THEN

792: x_return_status := FND_API.g_ret_sts_error;
793: END IF;
794:
795:
796: IF p_scoreresult_rec.confidence = FND_API.g_miss_num OR p_scoreresult_rec.confidence IS NULL THEN
797: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_CONFIDENCE');
798: x_return_status := FND_API.g_ret_sts_error;
799: END IF;
800: ELSE -- update mode

Line 798: x_return_status := FND_API.g_ret_sts_error;

794:
795:
796: IF p_scoreresult_rec.confidence = FND_API.g_miss_num OR p_scoreresult_rec.confidence IS NULL THEN
797: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_CONFIDENCE');
798: x_return_status := FND_API.g_ret_sts_error;
799: END IF;
800: ELSE -- update mode
801: IF p_scoreresult_rec.score_result_id IS NULL THEN
802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_ID');

Line 803: x_return_status := FND_API.g_ret_sts_error;

799: END IF;
800: ELSE -- update mode
801: IF p_scoreresult_rec.score_result_id IS NULL THEN
802: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_ID');
803: x_return_status := FND_API.g_ret_sts_error;
804: END IF;
805:
806:
807: IF p_scoreresult_rec.score_id IS NULL THEN

Line 809: x_return_status := FND_API.g_ret_sts_error;

805:
806:
807: IF p_scoreresult_rec.score_id IS NULL THEN
808: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_score_id');
809: x_return_status := FND_API.g_ret_sts_error;
810: END IF;
811:
812:
813: IF p_scoreresult_rec.decile IS NULL THEN

Line 815: x_return_status := FND_API.g_ret_sts_error;

811:
812:
813: IF p_scoreresult_rec.decile IS NULL THEN
814: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_DECILE');
815: x_return_status := FND_API.g_ret_sts_error;
816: END IF;
817:
818:
819: IF p_scoreresult_rec.num_records IS NULL THEN

Line 821: x_return_status := FND_API.g_ret_sts_error;

817:
818:
819: IF p_scoreresult_rec.num_records IS NULL THEN
820: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_NUM_RECORDS');
821: x_return_status := FND_API.g_ret_sts_error;
822: END IF;
823:
824:
825: IF p_scoreresult_rec.score IS NULL THEN

Line 827: x_return_status := FND_API.g_ret_sts_error;

823:
824:
825: IF p_scoreresult_rec.score IS NULL THEN
826: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_SCORE');
827: x_return_status := FND_API.g_ret_sts_error;
828: END IF;
829:
830:
831: IF p_scoreresult_rec.confidence IS NULL THEN

Line 833: x_return_status := FND_API.g_ret_sts_error;

829:
830:
831: IF p_scoreresult_rec.confidence IS NULL THEN
832: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SCORRES_NO_CONFIDENCE');
833: x_return_status := FND_API.g_ret_sts_error;
834: END IF;
835: END IF;
836:
837: END check_scoreresult_req_items;

Line 845: x_return_status := FND_API.g_ret_sts_success;

841: x_return_status OUT NOCOPY VARCHAR2
842: )
843: IS
844: BEGIN
845: x_return_status := FND_API.g_ret_sts_success;
846:
847: IF p_scoreresult_rec.score_id <> FND_API.g_miss_num THEN
848: IF AMS_Utility_PVT.check_fk_exists (
849: 'ams_dm_scores_all_b',

Line 847: IF p_scoreresult_rec.score_id <> FND_API.g_miss_num THEN

843: IS
844: BEGIN
845: x_return_status := FND_API.g_ret_sts_success;
846:
847: IF p_scoreresult_rec.score_id <> FND_API.g_miss_num THEN
848: IF AMS_Utility_PVT.check_fk_exists (
849: 'ams_dm_scores_all_b',
850: 'score_id',
851: p_scoreresult_rec.score_id

Line 852: ) = FND_API.g_false THEN

848: IF AMS_Utility_PVT.check_fk_exists (
849: 'ams_dm_scores_all_b',
850: 'score_id',
851: p_scoreresult_rec.score_id
852: ) = FND_API.g_false THEN
853: AMS_Utility_PVT.error_message ('AMS_SCORRES_BAD_SCORE_ID');
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856: END IF;

Line 854: x_return_status := FND_API.g_ret_sts_error;

850: 'score_id',
851: p_scoreresult_rec.score_id
852: ) = FND_API.g_false THEN
853: AMS_Utility_PVT.error_message ('AMS_SCORRES_BAD_SCORE_ID');
854: x_return_status := FND_API.g_ret_sts_error;
855: END IF;
856: END IF;
857:
858: END check_scoreresult_FK_items;

Line 866: x_return_status := FND_API.g_ret_sts_success;

862: x_return_status OUT NOCOPY VARCHAR2
863: )
864: IS
865: BEGIN
866: x_return_status := FND_API.g_ret_sts_success;
867:
868: END check_scoreresult_Lookup_items;
869:
870: PROCEDURE Check_scoreresult_Items (

Line 884: IF x_return_status <> FND_API.g_ret_sts_success THEN

880: check_scoreresult_uk_items(
881: p_scoreresult_rec => p_scoreresult_rec,
882: p_validation_mode => p_validation_mode,
883: x_return_status => x_return_status);
884: IF x_return_status <> FND_API.g_ret_sts_success THEN
885: RETURN;
886: END IF;
887:
888: -- Check Items Required/NOT NULL API calls

Line 894: IF x_return_status <> FND_API.g_ret_sts_success THEN

890: check_scoreresult_req_items(
891: p_scoreresult_rec => p_scoreresult_rec,
892: p_validation_mode => p_validation_mode,
893: x_return_status => x_return_status);
894: IF x_return_status <> FND_API.g_ret_sts_success THEN
895: RETURN;
896: END IF;
897: -- Check Items Foreign Keys API calls
898:

Line 902: IF x_return_status <> FND_API.g_ret_sts_success THEN

898:
899: check_scoreresult_FK_items(
900: p_scoreresult_rec => p_scoreresult_rec,
901: x_return_status => x_return_status);
902: IF x_return_status <> FND_API.g_ret_sts_success THEN
903: RETURN;
904: END IF;
905: -- Check Items Lookups
906:

Line 910: IF x_return_status <> FND_API.g_ret_sts_success THEN

906:
907: check_scoreresult_Lookup_items(
908: p_scoreresult_rec => p_scoreresult_rec,
909: x_return_status => x_return_status);
910: IF x_return_status <> FND_API.g_ret_sts_success THEN
911: RETURN;
912: END IF;
913:
914: END Check_scoreresult_Items;

Line 933: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

929: END Complete_scoreresult_Rec;
930:
931: PROCEDURE Validate_scoreresult(
932: p_api_version IN NUMBER,
933: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
934: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
935: p_validation_mode IN VARCHAR2,
936: p_scoreresult_rec IN scoreresult_rec_type,
937: x_return_status OUT NOCOPY VARCHAR2,

Line 934: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

930:
931: PROCEDURE Validate_scoreresult(
932: p_api_version IN NUMBER,
933: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
934: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
935: p_validation_mode IN VARCHAR2,
936: p_scoreresult_rec IN scoreresult_rec_type,
937: x_return_status OUT NOCOPY VARCHAR2,
938: x_msg_count OUT NOCOPY NUMBER,

Line 952: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

948: -- Standard Start of API savepoint
949: SAVEPOINT VALIDATE_Scoreresult_;
950:
951: -- Standard call to check for call compatibility.
952: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
953: p_api_version,
954: l_api_name,
955: G_PKG_NAME)
956: THEN

Line 957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

953: p_api_version,
954: l_api_name,
955: G_PKG_NAME)
956: THEN
957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
958: END IF;
959:
960: -- Initialize message list if p_init_msg_list is set to TRUE.
961: IF FND_API.to_Boolean( p_init_msg_list )

Line 961: IF FND_API.to_Boolean( p_init_msg_list )

957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
958: END IF;
959:
960: -- Initialize message list if p_init_msg_list is set to TRUE.
961: IF FND_API.to_Boolean( p_init_msg_list )
962: THEN
963: FND_MSG_PUB.initialize;
964: END IF;
965: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 972: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

968: p_validation_mode => JTF_PLSQL_API.g_update,
969: x_return_status => x_return_status
970: );
971:
972: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;

Line 973: RAISE FND_API.G_EXC_ERROR;

969: x_return_status => x_return_status
970: );
971:
972: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977: END IF;

Line 974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

970: );
971:
972: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977: END IF;
978:

Line 975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

971:
972: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
973: RAISE FND_API.G_EXC_ERROR;
974: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
975: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
976: END IF;
977: END IF;
978:
979: Complete_scoreresult_Rec(

Line 987: p_init_msg_list => FND_API.G_FALSE,

983:
984: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
985: Validate_scoreresult_Rec(
986: p_api_version => 1.0,
987: p_init_msg_list => FND_API.G_FALSE,
988: x_return_status => x_return_status,
989: x_msg_count => x_msg_count,
990: x_msg_data => x_msg_data,
991: p_scoreresult_rec => l_scoreresult_rec);

Line 993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

989: x_msg_count => x_msg_count,
990: x_msg_data => x_msg_data,
991: p_scoreresult_rec => l_scoreresult_rec);
992:
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;

Line 994: RAISE FND_API.G_EXC_ERROR;

990: x_msg_data => x_msg_data,
991: p_scoreresult_rec => l_scoreresult_rec);
992:
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998: END IF;

Line 995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

991: p_scoreresult_rec => l_scoreresult_rec);
992:
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998: END IF;
999:

Line 996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

992:
993: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
994: RAISE FND_API.G_EXC_ERROR;
995: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
996: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
997: END IF;
998: END IF;
999:
1000:

Line 1009: x_return_status := FND_API.G_RET_STS_SUCCESS;

1005: END IF;
1006:
1007:
1008: -- Initialize API return status to SUCCESS
1009: x_return_status := FND_API.G_RET_STS_SUCCESS;
1010:
1011:
1012: -- Debug Message
1013: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1025: x_return_status := FND_API.g_ret_sts_error;

1021: );
1022: EXCEPTION
1023:
1024: WHEN AMS_Utility_PVT.resource_locked THEN
1025: x_return_status := FND_API.g_ret_sts_error;
1026: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO VALIDATE_Scoreresult_;

Line 1028: WHEN FND_API.G_EXC_ERROR THEN

1024: WHEN AMS_Utility_PVT.resource_locked THEN
1025: x_return_status := FND_API.g_ret_sts_error;
1026: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO VALIDATE_Scoreresult_;
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: -- Standard call to get message count and if count=1, get the message
1032: FND_MSG_PUB.Count_And_Get (

Line 1030: x_return_status := FND_API.G_RET_STS_ERROR;

1026: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1027:
1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO VALIDATE_Scoreresult_;
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: -- Standard call to get message count and if count=1, get the message
1032: FND_MSG_PUB.Count_And_Get (
1033: p_encoded => FND_API.G_FALSE,
1034: p_count => x_msg_count,

Line 1033: p_encoded => FND_API.G_FALSE,

1029: ROLLBACK TO VALIDATE_Scoreresult_;
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: -- Standard call to get message count and if count=1, get the message
1032: FND_MSG_PUB.Count_And_Get (
1033: p_encoded => FND_API.G_FALSE,
1034: p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037:

Line 1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1034: p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );
1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO VALIDATE_Scoreresult_;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: -- Standard call to get message count and if count=1, get the message
1042: FND_MSG_PUB.Count_And_Get (

Line 1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1036: );
1037:
1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO VALIDATE_Scoreresult_;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: -- Standard call to get message count and if count=1, get the message
1042: FND_MSG_PUB.Count_And_Get (
1043: p_encoded => FND_API.G_FALSE,
1044: p_count => x_msg_count,

Line 1043: p_encoded => FND_API.G_FALSE,

1039: ROLLBACK TO VALIDATE_Scoreresult_;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: -- Standard call to get message count and if count=1, get the message
1042: FND_MSG_PUB.Count_And_Get (
1043: p_encoded => FND_API.G_FALSE,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data
1046: );
1047:

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1046: );
1047:
1048: WHEN OTHERS THEN
1049: ROLLBACK TO VALIDATE_Scoreresult_;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;

Line 1057: p_encoded => FND_API.G_FALSE,

1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => FND_API.G_FALSE,
1058: p_count => x_msg_count,
1059: p_data => x_msg_data
1060: );
1061: End Validate_Scoreresult;

Line 1066: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1062:
1063:
1064: PROCEDURE Validate_scoreresult_rec(
1065: p_api_version IN NUMBER,
1066: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1067: x_return_status OUT NOCOPY VARCHAR2,
1068: x_msg_count OUT NOCOPY NUMBER,
1069: x_msg_data OUT NOCOPY VARCHAR2,
1070: p_scoreresult_rec IN scoreresult_rec_type

Line 1075: IF FND_API.to_Boolean( p_init_msg_list )

1071: )
1072: IS
1073: BEGIN
1074: -- Initialize message list if p_init_msg_list is set to TRUE.
1075: IF FND_API.to_Boolean( p_init_msg_list )
1076: THEN
1077: FND_MSG_PUB.initialize;
1078: END IF;
1079:

Line 1081: x_return_status := FND_API.G_RET_STS_SUCCESS;

1077: FND_MSG_PUB.initialize;
1078: END IF;
1079:
1080: -- Initialize API return status to SUCCESS
1081: x_return_status := FND_API.G_RET_STS_SUCCESS;
1082:
1083: -- Hint: Validate data
1084: -- If data not valid
1085: -- THEN

Line 1086: -- x_return_status := FND_API.G_RET_STS_ERROR;

1082:
1083: -- Hint: Validate data
1084: -- If data not valid
1085: -- THEN
1086: -- x_return_status := FND_API.G_RET_STS_ERROR;
1087:
1088: -- Debug Message
1089: IF (AMS_DEBUG_HIGH_ON) THEN
1090:

Line 1413: WHEN FND_API.G_EXC_ERROR THEN

1409: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1410: END IF;
1411:
1412: EXCEPTION
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: ROLLBACK TO insert_percentile_results;
1415: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1416: RAISE FND_API.G_EXC_ERROR;
1417:

Line 1416: RAISE FND_API.G_EXC_ERROR;

1412: EXCEPTION
1413: WHEN FND_API.G_EXC_ERROR THEN
1414: ROLLBACK TO insert_percentile_results;
1415: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1416: RAISE FND_API.G_EXC_ERROR;
1417:
1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1419: ROLLBACK TO insert_percentile_results;
1420: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');

Line 1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1414: ROLLBACK TO insert_percentile_results;
1415: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1416: RAISE FND_API.G_EXC_ERROR;
1417:
1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1419: ROLLBACK TO insert_percentile_results;
1420: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:

Line 1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1417:
1418: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1419: ROLLBACK TO insert_percentile_results;
1420: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1422:
1423: WHEN OTHERS THEN
1424: ROLLBACK TO insert_percentile_results;
1425: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');

Line 1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1422:
1423: WHEN OTHERS THEN
1424: ROLLBACK TO insert_percentile_results;
1425: AMS_UTILITY_PVT.debug_message(l_api_name || ': Error ');
1426: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1427:
1428: END insert_percentile_results;
1429:
1430:

Line 1433: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1429:
1430:
1431: PROCEDURE summarize_results (
1432: p_api_version IN NUMBER,
1433: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1434: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1435: x_return_status OUT NOCOPY VARCHAR2,
1436: x_msg_count OUT NOCOPY NUMBER,
1437: x_msg_data OUT NOCOPY VARCHAR2,

Line 1434: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1430:
1431: PROCEDURE summarize_results (
1432: p_api_version IN NUMBER,
1433: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1434: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1435: x_return_status OUT NOCOPY VARCHAR2,
1436: x_msg_count OUT NOCOPY NUMBER,
1437: x_msg_data OUT NOCOPY VARCHAR2,
1438: p_score_id IN NUMBER

Line 1470: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1466: -- Standard Start of API savepoint
1467: SAVEPOINT summarize_Scoreresult_PVT;
1468:
1469: -- Standard call to check for call compatibility.
1470: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1471: p_api_version,
1472: l_api_name,
1473: G_PKG_NAME)
1474: THEN

Line 1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1471: p_api_version,
1472: l_api_name,
1473: G_PKG_NAME)
1474: THEN
1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: END IF;
1477:
1478: -- Initialize message list if p_init_msg_list is set to TRUE.
1479: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1479: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1475: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1476: END IF;
1477:
1478: -- Initialize message list if p_init_msg_list is set to TRUE.
1479: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1480: FND_MSG_PUB.initialize;
1481: END IF;
1482:
1483: -- Debug Message

Line 1490: x_return_status := FND_API.G_RET_STS_SUCCESS;

1486: END IF;
1487:
1488:
1489: -- Initialize API return status to SUCCESS
1490: x_return_status := FND_API.G_RET_STS_SUCCESS;
1491:
1492: -- clear results from any previous execution
1493: DELETE FROM ams_dm_score_results
1494: WHERE score_id = p_score_id;

Line 1549: IF p_commit = FND_API.g_true THEN

1545: insert_percentile_results (p_score_id);
1546: END IF;
1547: --kbasavar 12/30/2003 End Modified to Call insert_percentile_results only for models enabled for optimal targeting
1548:
1549: IF p_commit = FND_API.g_true THEN
1550: COMMIT;
1551: END IF;
1552:
1553: -- Debug Message

Line 1559: WHEN FND_API.G_EXC_ERROR THEN

1555: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1556: END IF;
1557:
1558: EXCEPTION
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO summarize_Scoreresult_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (

Line 1561: x_return_status := FND_API.G_RET_STS_ERROR;

1557:
1558: EXCEPTION
1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO summarize_Scoreresult_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,

Line 1564: p_encoded => FND_API.G_FALSE,

1560: ROLLBACK TO summarize_Scoreresult_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO summarize_Scoreresult_PVT;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: -- Standard call to get message count and if count=1, get the message
1572: FND_MSG_PUB.Count_And_Get (

Line 1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1566: p_data => x_msg_data
1567: );
1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO summarize_Scoreresult_PVT;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: -- Standard call to get message count and if count=1, get the message
1572: FND_MSG_PUB.Count_And_Get (
1573: p_encoded => FND_API.G_FALSE,
1574: p_count => x_msg_count,

Line 1573: p_encoded => FND_API.G_FALSE,

1569: ROLLBACK TO summarize_Scoreresult_PVT;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: -- Standard call to get message count and if count=1, get the message
1572: FND_MSG_PUB.Count_And_Get (
1573: p_encoded => FND_API.G_FALSE,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data
1576: );
1577: WHEN OTHERS THEN

Line 1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1575: p_data => x_msg_data
1576: );
1577: WHEN OTHERS THEN
1578: ROLLBACK TO summarize_Scoreresult_PVT;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;

Line 1586: p_encoded => FND_API.G_FALSE,

1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,
1587: p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );
1590: END Summarize_Results;

Line 1682: RAISE FND_API.G_EXC_ERROR;

1678: FETCH c_ListSourceTypeCode INTO l_master_type, l_primary_key, l_target_id;
1679:
1680: IF (c_ListSourceTypeCode%NOTFOUND) THEN
1681: CLOSE c_ListSourceTypeCode;
1682: RAISE FND_API.G_EXC_ERROR;
1683: END IF;
1684:
1685: CLOSE c_ListSourceTypeCode;
1686:

Line 1757: p_init_msg_list => FND_API.G_FALSE,

1753: -- holds the primary key defined from the data source. For
1754: -- seeded data sources, this holds the party id from TCA.
1755: AMS_LISTGENERATION_PKG.CREATE_LIST (
1756: p_api_version => 1.0,
1757: p_init_msg_list => FND_API.G_FALSE,
1758: p_commit => FND_API.G_TRUE,
1759: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1760: p_list_name => p_list_name,
1761: p_owner_user_id => p_owner_user_id,

Line 1758: p_commit => FND_API.G_TRUE,

1754: -- seeded data sources, this holds the party id from TCA.
1755: AMS_LISTGENERATION_PKG.CREATE_LIST (
1756: p_api_version => 1.0,
1757: p_init_msg_list => FND_API.G_FALSE,
1758: p_commit => FND_API.G_TRUE,
1759: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1760: p_list_name => p_list_name,
1761: p_owner_user_id => p_owner_user_id,
1762: p_sql_string => l_sql_str,

Line 1759: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1755: AMS_LISTGENERATION_PKG.CREATE_LIST (
1756: p_api_version => 1.0,
1757: p_init_msg_list => FND_API.G_FALSE,
1758: p_commit => FND_API.G_TRUE,
1759: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1760: p_list_name => p_list_name,
1761: p_owner_user_id => p_owner_user_id,
1762: p_sql_string => l_sql_str,
1763: p_primary_key => 'PARTY_ID',

Line 1771: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN

1767: x_msg_count => x_msg_count,
1768: x_msg_data => x_msg_data,
1769: x_list_header_id => x_list_header_id
1770: );
1771: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1772: RAISE Fnd_Api.G_EXC_ERROR;
1773: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1774: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1775: ELSE -- If List Generation is successful then insert into AMS_DM_SCORE_LISTS. kbasavar 1/22/2004 for 3363509

Line 1772: RAISE Fnd_Api.G_EXC_ERROR;

1768: x_msg_data => x_msg_data,
1769: x_list_header_id => x_list_header_id
1770: );
1771: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1772: RAISE Fnd_Api.G_EXC_ERROR;
1773: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1774: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1775: ELSE -- If List Generation is successful then insert into AMS_DM_SCORE_LISTS. kbasavar 1/22/2004 for 3363509
1776:

Line 1773: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

1769: x_list_header_id => x_list_header_id
1770: );
1771: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1772: RAISE Fnd_Api.G_EXC_ERROR;
1773: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1774: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1775: ELSE -- If List Generation is successful then insert into AMS_DM_SCORE_LISTS. kbasavar 1/22/2004 for 3363509
1776:
1777: l_insertSql := 'INSERT INTO AMS_DM_SCORE_LISTS(SCORE_LIST_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,';

Line 1774: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1770: );
1771: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1772: RAISE Fnd_Api.G_EXC_ERROR;
1773: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1774: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1775: ELSE -- If List Generation is successful then insert into AMS_DM_SCORE_LISTS. kbasavar 1/22/2004 for 3363509
1776:
1777: l_insertSql := 'INSERT INTO AMS_DM_SCORE_LISTS(SCORE_LIST_ID, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE,';
1778: l_insertSql := l_insertSql || 'CREATED_BY, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER, SCORE_ID, LIST_HEADER_ID)' ;

Line 1790: WHEN Fnd_Api.G_EXC_ERROR THEN

1786: EXECUTE Immediate l_insertSql USING FND_GLOBAL.USER_ID,FND_GLOBAL.USER_ID,FND_GLOBAL.CONC_LOGIN_ID,p_score_id, x_list_header_id ;
1787:
1788: END IF;
1789: EXCEPTION
1790: WHEN Fnd_Api.G_EXC_ERROR THEN
1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1792: -- Standard call to get message count and if count=1, get the message
1793: Fnd_Msg_Pub.Count_And_Get (
1794: p_encoded => Fnd_Api.G_FALSE,

Line 1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1787:
1788: END IF;
1789: EXCEPTION
1790: WHEN Fnd_Api.G_EXC_ERROR THEN
1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1792: -- Standard call to get message count and if count=1, get the message
1793: Fnd_Msg_Pub.Count_And_Get (
1794: p_encoded => Fnd_Api.G_FALSE,
1795: p_count => x_msg_count,

Line 1794: p_encoded => Fnd_Api.G_FALSE,

1790: WHEN Fnd_Api.G_EXC_ERROR THEN
1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1792: -- Standard call to get message count and if count=1, get the message
1793: Fnd_Msg_Pub.Count_And_Get (
1794: p_encoded => Fnd_Api.G_FALSE,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data
1797: );
1798:

Line 1799: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1795: p_count => x_msg_count,
1796: p_data => x_msg_data
1797: );
1798:
1799: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1801: -- Standard call to get message count and if count=1, get the message
1802: Fnd_Msg_Pub.Count_And_Get (
1803: p_encoded => Fnd_Api.G_FALSE,

Line 1800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1796: p_data => x_msg_data
1797: );
1798:
1799: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1801: -- Standard call to get message count and if count=1, get the message
1802: Fnd_Msg_Pub.Count_And_Get (
1803: p_encoded => Fnd_Api.G_FALSE,
1804: p_count => x_msg_count,

Line 1803: p_encoded => Fnd_Api.G_FALSE,

1799: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1801: -- Standard call to get message count and if count=1, get the message
1802: Fnd_Msg_Pub.Count_And_Get (
1803: p_encoded => Fnd_Api.G_FALSE,
1804: p_count => x_msg_count,
1805: p_data => x_msg_data
1806: );
1807: END generate_list;

Line 1844: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN

1840: x_msg_count => x_msg_count,
1841: x_msg_data => x_msg_data,
1842: x_list_header_id => x_list_header_id
1843: );
1844: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1845: RAISE Fnd_Api.G_EXC_ERROR;
1846: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1848: END IF;

Line 1845: RAISE Fnd_Api.G_EXC_ERROR;

1841: x_msg_data => x_msg_data,
1842: x_list_header_id => x_list_header_id
1843: );
1844: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1845: RAISE Fnd_Api.G_EXC_ERROR;
1846: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: EXCEPTION

Line 1846: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN

1842: x_list_header_id => x_list_header_id
1843: );
1844: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1845: RAISE Fnd_Api.G_EXC_ERROR;
1846: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: EXCEPTION
1850: WHEN Fnd_Api.G_EXC_ERROR THEN

Line 1847: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;

1843: );
1844: IF x_return_status = Fnd_Api.G_RET_STS_ERROR THEN
1845: RAISE Fnd_Api.G_EXC_ERROR;
1846: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: EXCEPTION
1850: WHEN Fnd_Api.G_EXC_ERROR THEN
1851: x_return_status := Fnd_Api.G_RET_STS_ERROR;

Line 1850: WHEN Fnd_Api.G_EXC_ERROR THEN

1846: ELSIF x_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
1847: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: EXCEPTION
1850: WHEN Fnd_Api.G_EXC_ERROR THEN
1851: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1852: -- Standard call to get message count and if count=1, get the message
1853: Fnd_Msg_Pub.Count_And_Get (
1854: p_encoded => Fnd_Api.G_FALSE,

Line 1851: x_return_status := Fnd_Api.G_RET_STS_ERROR;

1847: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
1848: END IF;
1849: EXCEPTION
1850: WHEN Fnd_Api.G_EXC_ERROR THEN
1851: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1852: -- Standard call to get message count and if count=1, get the message
1853: Fnd_Msg_Pub.Count_And_Get (
1854: p_encoded => Fnd_Api.G_FALSE,
1855: p_count => x_msg_count,

Line 1854: p_encoded => Fnd_Api.G_FALSE,

1850: WHEN Fnd_Api.G_EXC_ERROR THEN
1851: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1852: -- Standard call to get message count and if count=1, get the message
1853: Fnd_Msg_Pub.Count_And_Get (
1854: p_encoded => Fnd_Api.G_FALSE,
1855: p_count => x_msg_count,
1856: p_data => x_msg_data
1857: );
1858:

Line 1859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN

1855: p_count => x_msg_count,
1856: p_data => x_msg_data
1857: );
1858:
1859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1861: -- Standard call to get message count and if count=1, get the message
1862: Fnd_Msg_Pub.Count_And_Get (
1863: p_encoded => Fnd_Api.G_FALSE,

Line 1860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;

1856: p_data => x_msg_data
1857: );
1858:
1859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1861: -- Standard call to get message count and if count=1, get the message
1862: Fnd_Msg_Pub.Count_And_Get (
1863: p_encoded => Fnd_Api.G_FALSE,
1864: p_count => x_msg_count,

Line 1863: p_encoded => Fnd_Api.G_FALSE,

1859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1861: -- Standard call to get message count and if count=1, get the message
1862: Fnd_Msg_Pub.Count_And_Get (
1863: p_encoded => Fnd_Api.G_FALSE,
1864: p_count => x_msg_count,
1865: p_data => x_msg_data
1866: );
1867: END generate_list;