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_DMSOURCE_PVT dependencies on FND_API

Line 154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

150:
151: -- Hint: Primary key needs to be returned.
152: PROCEDURE Lock_Source(
153: p_api_version IN NUMBER,
154: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
155:
156: X_Return_Status OUT NOCOPY VARCHAR2,
157: X_Msg_Count OUT NOCOPY NUMBER,
158: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 186: IF FND_API.to_Boolean( p_init_msg_list )

182: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
183: END IF;
184:
185: -- Initialize message list if p_init_msg_list is set to TRUE.
186: IF FND_API.to_Boolean( p_init_msg_list )
187: THEN
188: FND_MSG_PUB.initialize;
189: END IF;
190:

Line 192: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

188: FND_MSG_PUB.initialize;
189: END IF;
190:
191: -- Standard call to check for call compatibility.
192: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
193: p_api_version,
194: l_api_name,
195: G_PKG_NAME)
196: THEN

Line 197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

193: p_api_version,
194: l_api_name,
195: G_PKG_NAME)
196: THEN
197: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
198: END IF;
199:
200:
201: -- Initialize API return status to SUCCESS

Line 202: x_return_status := FND_API.G_RET_STS_SUCCESS;

198: END IF;
199:
200:
201: -- Initialize API return status to SUCCESS
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
204:
205: ------------------------ lock -------------------------
206:

Line 224: RAISE FND_API.g_exc_error;

220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
221: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
222: FND_MSG_PUB.add;
223: END IF;
224: RAISE FND_API.g_exc_error;
225: END IF;
226:
227: CLOSE c_Source;
228:

Line 231: p_encoded => FND_API.g_false,

227: CLOSE c_Source;
228:
229: -------------------- finish --------------------------
230: FND_MSG_PUB.count_and_get(
231: p_encoded => FND_API.g_false,
232: p_count => x_msg_count,
233: p_data => x_msg_data);
234: IF (AMS_DEBUG_HIGH_ON) THEN
235:

Line 241: x_return_status := FND_API.g_ret_sts_error;

237: END IF;
238: EXCEPTION
239:
240: WHEN AMS_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
243: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
244: FND_MSG_PUB.add;
245: END IF;

Line 247: WHEN FND_API.G_EXC_ERROR THEN

243: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
244: FND_MSG_PUB.add;
245: END IF;
246:
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO LOCK_source_PVT;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (

Line 249: x_return_status := FND_API.G_RET_STS_ERROR;

245: END IF;
246:
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO LOCK_source_PVT;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,

Line 252: p_encoded => FND_API.G_FALSE,

248: ROLLBACK TO LOCK_source_PVT;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data
255: );
256:

Line 257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

253: p_count => x_msg_count,
254: p_data => x_msg_data
255: );
256:
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO LOCK_source_PVT;
259: x_return_status := FND_API.G_RET_STS_UNEXP_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_UNEXP_ERROR;

255: );
256:
257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO LOCK_source_PVT;
259: x_return_status := FND_API.G_RET_STS_UNEXP_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 LOCK_source_PVT;
259: x_return_status := FND_API.G_RET_STS_UNEXP_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 269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

265: );
266:
267: WHEN OTHERS THEN
268: ROLLBACK TO LOCK_source_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: THEN
272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
273: END IF;

Line 276: p_encoded => FND_API.G_FALSE,

272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
273: END IF;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );
280: End Lock_Source;

Line 287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

283:
284: -- Hint: Primary key needs to be returned.
285: PROCEDURE Create_Source(
286: p_api_version IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290:
291: X_Return_Status OUT NOCOPY VARCHAR2,

Line 288: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

284: -- Hint: Primary key needs to be returned.
285: PROCEDURE Create_Source(
286: p_api_version IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290:
291: X_Return_Status OUT NOCOPY VARCHAR2,
292: X_Msg_Count OUT NOCOPY NUMBER,

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

285: PROCEDURE Create_Source(
286: p_api_version IN NUMBER,
287: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
288: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
289: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
290:
291: X_Return_Status OUT NOCOPY VARCHAR2,
292: X_Msg_Count OUT NOCOPY NUMBER,
293: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 304: l_org_id NUMBER := FND_API.G_MISS_NUM;

300: l_api_name CONSTANT VARCHAR2(30) := 'Create_Source';
301: l_api_version_number CONSTANT NUMBER := 1.0;
302: l_return_status_full VARCHAR2(1);
303: l_object_version_number NUMBER := 1;
304: l_org_id NUMBER := FND_API.G_MISS_NUM;
305: l_SOURCE_ID NUMBER;
306: l_dummy NUMBER;
307:
308: CURSOR c_id IS

Line 322: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 331: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 344: x_return_status := FND_API.G_RET_STS_SUCCESS;

340: END IF;
341:
342:
343: -- Initialize API return status to SUCCESS
344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346: -- Local variable initialization
347:
348: IF p_source_rec.SOURCE_ID IS NULL OR p_source_rec.SOURCE_ID = FND_API.g_miss_num THEN

Line 348: IF p_source_rec.SOURCE_ID IS NULL OR p_source_rec.SOURCE_ID = FND_API.g_miss_num THEN

344: x_return_status := FND_API.G_RET_STS_SUCCESS;
345:
346: -- Local variable initialization
347:
348: IF p_source_rec.SOURCE_ID IS NULL OR p_source_rec.SOURCE_ID = FND_API.g_miss_num THEN
349: LOOP
350: l_dummy := NULL;
351: OPEN c_id;
352: FETCH c_id INTO l_SOURCE_ID;

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

360: ELSE
361: l_source_id := p_source_rec.source_id;
362: END IF;
363:
364: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
365: THEN
366: -- Debug message
367: IF (AMS_DEBUG_HIGH_ON) THEN
368:

Line 375: p_init_msg_list => FND_API.G_FALSE,

371:
372: -- Invoke validation procedures
373: Validate_Source(
374: p_api_version => 1.0,
375: p_init_msg_list => FND_API.G_FALSE,
376: p_validation_level => p_validation_level,
377: p_validation_mode => JTF_PLSQL_API.g_create,
378: P_source_rec => P_source_rec,
379: x_return_status => x_return_status,

Line 384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

380: x_msg_count => x_msg_count,
381: x_msg_data => x_msg_data);
382: END IF;
383:
384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388:

Line 385: RAISE FND_API.G_EXC_ERROR;

381: x_msg_data => x_msg_data);
382: END IF;
383:
384: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
385: RAISE FND_API.G_EXC_ERROR;
386: END IF;
387:
388:
389: -- Debug Message

Line 418: RAISE FND_API.g_exc_error;

414: p_percentile => p_source_rec.percentile);
415: EXCEPTION
416: WHEN NO_DATA_FOUND THEN
417: AMS_Utility_PVT.error_message ('AMS_API_NO_INSERT');
418: RAISE FND_API.g_exc_error;
419: END;
420: --
421: -- End of API body
422: --

Line 425: IF FND_API.to_Boolean( p_commit )

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

Line 445: x_return_status := FND_API.g_ret_sts_error;

441: );
442: EXCEPTION
443:
444: WHEN AMS_Utility_PVT.resource_locked THEN
445: x_return_status := FND_API.g_ret_sts_error;
446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
447: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
448: FND_MSG_PUB.add;
449: END IF;

Line 451: WHEN FND_API.G_EXC_ERROR THEN

447: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
448: FND_MSG_PUB.add;
449: END IF;
450:
451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO CREATE_source_PVT;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (

Line 453: x_return_status := FND_API.G_RET_STS_ERROR;

449: END IF;
450:
451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO CREATE_source_PVT;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,

Line 456: p_encoded => FND_API.G_FALSE,

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

Line 461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 466: p_encoded => FND_API.G_FALSE,

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

Line 473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 480: p_encoded => FND_API.G_FALSE,

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

Line 489: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

485:
486:
487: PROCEDURE Update_Source(
488: p_api_version IN NUMBER,
489: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
490: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492:
493: X_Return_Status OUT NOCOPY VARCHAR2,

Line 490: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

486:
487: PROCEDURE Update_Source(
488: p_api_version IN NUMBER,
489: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
490: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492:
493: X_Return_Status OUT NOCOPY VARCHAR2,
494: X_Msg_Count OUT NOCOPY NUMBER,

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

487: PROCEDURE Update_Source(
488: p_api_version IN NUMBER,
489: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
490: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
491: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
492:
493: X_Return_Status OUT NOCOPY VARCHAR2,
494: X_Msg_Count OUT NOCOPY NUMBER,
495: X_Msg_Data OUT NOCOPY VARCHAR2,

Line 521: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

517: -- Standard Start of API savepoint
518: SAVEPOINT UPDATE_source_PVT;
519:
520: -- Standard call to check for call compatibility.
521: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
522: p_api_version,
523: l_api_name,
524: G_PKG_NAME)
525: THEN

Line 526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

522: p_api_version,
523: l_api_name,
524: G_PKG_NAME)
525: THEN
526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean( p_init_msg_list )

Line 530: IF FND_API.to_Boolean( p_init_msg_list )

526: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
527: END IF;
528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean( p_init_msg_list )
531: THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534:

Line 543: x_return_status := FND_API.G_RET_STS_SUCCESS;

539: END IF;
540:
541:
542: -- Initialize API return status to SUCCESS
543: x_return_status := FND_API.G_RET_STS_SUCCESS;
544:
545: -- Debug Message
546: IF (AMS_DEBUG_HIGH_ON) THEN
547:

Line 560: RAISE FND_API.g_exc_error;

556: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
557: FND_MESSAGE.Set_Token ('INFO', 'dm_source', FALSE);
558: FND_MSG_PUB.Add;
559: END IF;
560: RAISE FND_API.g_exc_error;
561: END IF;
562: -- Debug Message
563: IF (AMS_DEBUG_HIGH_ON) THEN
564:

Line 576: RAISE FND_API.g_exc_error;

572: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
573: FND_MESSAGE.Set_Token('INFO', 'dm_source', FALSE);
574: FND_MSG_PUB.ADD;
575: END IF;
576: RAISE FND_API.g_exc_error;
577: END IF;
578:
579: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
580: -- Debug message

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

575: END IF;
576: RAISE FND_API.g_exc_error;
577: END IF;
578:
579: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL) THEN
580: -- Debug message
581: IF (AMS_DEBUG_HIGH_ON) THEN
582:
583: AMS_UTILITY_PVT.debug_message('Private API: Validate_Source');

Line 589: p_init_msg_list => FND_API.G_FALSE,

585:
586: -- Invoke validation procedures
587: Validate_Source(
588: p_api_version => 1.0,
589: p_init_msg_list => FND_API.G_FALSE,
590: p_validation_level => p_validation_level,
591: p_validation_mode => JTF_PLSQL_API.g_update,
592: P_source_rec => P_source_rec,
593: x_return_status => x_return_status,

Line 596: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

592: P_source_rec => P_source_rec,
593: x_return_status => x_return_status,
594: x_msg_count => x_msg_count,
595: x_msg_data => x_msg_data);
596: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600: END IF;

Line 597: RAISE FND_API.G_EXC_ERROR;

593: x_return_status => x_return_status,
594: x_msg_count => x_msg_count,
595: x_msg_data => x_msg_data);
596: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
597: RAISE FND_API.G_EXC_ERROR;
598: END IF;
599:
600: END IF;
601:

Line 630: IF FND_API.to_Boolean( p_commit )

626: -- End of API body.
627: --
628:
629: -- Standard check for p_commit
630: IF FND_API.to_Boolean( p_commit )
631: THEN
632: COMMIT WORK;
633: END IF;
634:

Line 650: x_return_status := FND_API.g_ret_sts_error;

646: );
647: EXCEPTION
648:
649: WHEN AMS_Utility_PVT.resource_locked THEN
650: x_return_status := FND_API.g_ret_sts_error;
651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
652: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
653: FND_MSG_PUB.add;
654: END IF;

Line 656: WHEN FND_API.G_EXC_ERROR THEN

652: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
653: FND_MSG_PUB.add;
654: END IF;
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO UPDATE_source_PVT;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: -- Standard call to get message count and if count=1, get the message
660: FND_MSG_PUB.Count_And_Get (

Line 658: x_return_status := FND_API.G_RET_STS_ERROR;

654: END IF;
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO UPDATE_source_PVT;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: -- Standard call to get message count and if count=1, get the message
660: FND_MSG_PUB.Count_And_Get (
661: p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count,

Line 661: p_encoded => FND_API.G_FALSE,

657: ROLLBACK TO UPDATE_source_PVT;
658: x_return_status := FND_API.G_RET_STS_ERROR;
659: -- Standard call to get message count and if count=1, get the message
660: FND_MSG_PUB.Count_And_Get (
661: p_encoded => FND_API.G_FALSE,
662: p_count => x_msg_count,
663: p_data => x_msg_data
664: );
665:

Line 666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

662: p_count => x_msg_count,
663: p_data => x_msg_data
664: );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO UPDATE_source_PVT;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: -- Standard call to get message count and if count=1, get the message
670: FND_MSG_PUB.Count_And_Get (

Line 668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

664: );
665:
666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO UPDATE_source_PVT;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: -- Standard call to get message count and if count=1, get the message
670: FND_MSG_PUB.Count_And_Get (
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,

Line 671: p_encoded => FND_API.G_FALSE,

667: ROLLBACK TO UPDATE_source_PVT;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: -- Standard call to get message count and if count=1, get the message
670: FND_MSG_PUB.Count_And_Get (
671: p_encoded => FND_API.G_FALSE,
672: p_count => x_msg_count,
673: p_data => x_msg_data
674: );
675:

Line 678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

674: );
675:
676: WHEN OTHERS THEN
677: ROLLBACK TO UPDATE_source_PVT;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
680: THEN
681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
682: END IF;

Line 685: p_encoded => FND_API.G_FALSE,

681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
682: END IF;
683: -- Standard call to get message count and if count=1, get the message
684: FND_MSG_PUB.Count_And_Get (
685: p_encoded => FND_API.G_FALSE,
686: p_count => x_msg_count,
687: p_data => x_msg_data
688: );
689: End Update_Source;

Line 694: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

690:
691:
692: PROCEDURE Delete_Source(
693: p_api_version IN NUMBER,
694: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
695: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
696: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
697: X_Return_Status OUT NOCOPY VARCHAR2,
698: X_Msg_Count OUT NOCOPY NUMBER,

Line 695: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

691:
692: PROCEDURE Delete_Source(
693: p_api_version IN NUMBER,
694: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
695: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
696: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
697: X_Return_Status OUT NOCOPY VARCHAR2,
698: X_Msg_Count OUT NOCOPY NUMBER,
699: X_Msg_Data OUT NOCOPY VARCHAR2,

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

692: PROCEDURE Delete_Source(
693: p_api_version IN NUMBER,
694: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
695: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
696: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
697: X_Return_Status OUT NOCOPY VARCHAR2,
698: X_Msg_Count OUT NOCOPY NUMBER,
699: X_Msg_Data OUT NOCOPY VARCHAR2,
700: P_SOURCE_ID IN NUMBER,

Line 718: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

714: -- Standard Start of API savepoint
715: SAVEPOINT DELETE_source_PVT;
716:
717: -- Standard call to check for call compatibility.
718: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
719: p_api_version,
720: l_api_name,
721: G_PKG_NAME)
722: THEN

Line 723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

719: p_api_version,
720: l_api_name,
721: G_PKG_NAME)
722: THEN
723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725:
726: -- Initialize message list if p_init_msg_list is set to TRUE.
727: IF FND_API.to_Boolean( p_init_msg_list )

Line 727: IF FND_API.to_Boolean( p_init_msg_list )

723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
724: END IF;
725:
726: -- Initialize message list if p_init_msg_list is set to TRUE.
727: IF FND_API.to_Boolean( p_init_msg_list )
728: THEN
729: FND_MSG_PUB.initialize;
730: END IF;
731:

Line 739: x_return_status := FND_API.G_RET_STS_SUCCESS;

735: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' start');
736: END IF;
737:
738: -- Initialize API return status to SUCCESS
739: x_return_status := FND_API.G_RET_STS_SUCCESS;
740:
741: IF (AMS_DEBUG_HIGH_ON) THEN
742:
743:

Line 753: RAISE FND_API.g_exc_error;

749: OPEN c_obj_version(p_source_id);
750: FETCH c_obj_version INTO l_object_version_number;
751: IF ( c_obj_version%NOTFOUND) THEN
752: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
753: RAISE FND_API.g_exc_error;
754: END IF;
755: -- Debug Message
756: IF (AMS_DEBUG_HIGH_ON) THEN
757:

Line 779: RAISE FND_API.g_exc_error;

775: p_source_id => p_source_id);
776: EXCEPTION
777: WHEN NO_DATA_FOUND THEN
778: AMS_Utility_PVT.error_message ('AMS_API_RECORD_NOT_FOUND');
779: RAISE FND_API.g_exc_error;
780: END;
781: --
782: -- End of API body
783: --

Line 786: IF FND_API.to_Boolean( p_commit )

782: -- End of API body
783: --
784:
785: -- Standard check for p_commit
786: IF FND_API.to_Boolean( p_commit )
787: THEN
788: COMMIT WORK;
789: END IF;
790:

Line 809: raise FND_API.G_EXC_ERROR;

805: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
806: FND_MESSAGE.Set_Token('INFO', 'dm_source', FALSE);
807: FND_MSG_PUB.ADD;
808: END IF;
809: raise FND_API.G_EXC_ERROR;
810: END IF;
811:
812: EXCEPTION
813:

Line 815: x_return_status := FND_API.g_ret_sts_error;

811:
812: EXCEPTION
813:
814: WHEN AMS_Utility_PVT.resource_locked THEN
815: x_return_status := FND_API.g_ret_sts_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
818: FND_MSG_PUB.add;
819: END IF;

Line 821: WHEN FND_API.G_EXC_ERROR THEN

817: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
818: FND_MSG_PUB.add;
819: END IF;
820:
821: WHEN FND_API.G_EXC_ERROR THEN
822: ROLLBACK TO DELETE_source_PVT;
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (

Line 823: x_return_status := FND_API.G_RET_STS_ERROR;

819: END IF;
820:
821: WHEN FND_API.G_EXC_ERROR THEN
822: ROLLBACK TO DELETE_source_PVT;
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,

Line 826: p_encoded => FND_API.G_FALSE,

822: ROLLBACK TO DELETE_source_PVT;
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830:

Line 831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );
830:
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO DELETE_source_PVT;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (

Line 833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: );
830:
831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO DELETE_source_PVT;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,

Line 836: p_encoded => FND_API.G_FALSE,

832: ROLLBACK TO DELETE_source_PVT;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840:

Line 843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

839: );
840:
841: WHEN OTHERS THEN
842: ROLLBACK TO DELETE_source_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
845: THEN
846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
847: END IF;

Line 850: p_encoded => FND_API.G_FALSE,

846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
847: END IF;
848: -- Standard call to get message count and if count=1, get the message
849: FND_MSG_PUB.Count_And_Get (
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: End Delete_Source;

Line 869: x_return_status := FND_API.g_ret_sts_success;

865: IF (AMS_DEBUG_HIGH_ON) THEN
866:
867: AMS_UTILITY_PVT.debug_message('Private API:check_source_uk_items');
868: END IF;
869: x_return_status := FND_API.g_ret_sts_success;
870: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
871: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
872: 'ams_dm_source',
873: 'SOURCE_ID = ''' || p_source_rec.SOURCE_ID ||''''

Line 883: IF l_valid_flag = FND_API.g_false THEN

879: ''' AND SOURCE_ID <> ' || p_source_rec.SOURCE_ID
880: );
881: END IF;
882:
883: IF l_valid_flag = FND_API.g_false THEN
884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
885: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_ID_DUPLICATE');
886: FND_MSG_PUB.add;
887: END IF;

Line 888: x_return_status := FND_API.g_ret_sts_error;

884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
885: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_ID_DUPLICATE');
886: FND_MSG_PUB.add;
887: END IF;
888: x_return_status := FND_API.g_ret_sts_error;
889: END IF;
890:
891: END check_source_uk_items;
892:

Line 904: x_return_status := FND_API.g_ret_sts_success;

900: IF (AMS_DEBUG_HIGH_ON) THEN
901:
902: AMS_UTILITY_PVT.debug_message('Private API:check_source_req_items');
903: END IF;
904: x_return_status := FND_API.g_ret_sts_success;
905:
906: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
907: IF p_source_rec.ARC_USED_FOR_OBJECT = FND_API.g_miss_char OR p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN
908: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 907: IF p_source_rec.ARC_USED_FOR_OBJECT = FND_API.g_miss_char OR p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN

903: END IF;
904: x_return_status := FND_API.g_ret_sts_success;
905:
906: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
907: IF p_source_rec.ARC_USED_FOR_OBJECT = FND_API.g_miss_char OR p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN
908: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
909: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
910: FND_MSG_PUB.add;
911: END IF;

Line 912: x_return_status := FND_API.g_ret_sts_error;

908: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
909: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
913: END IF;
914:
915:
916: IF p_source_rec.USED_FOR_OBJECT_ID = FND_API.g_miss_num OR p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN

Line 916: IF p_source_rec.USED_FOR_OBJECT_ID = FND_API.g_miss_num OR p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN

912: x_return_status := FND_API.g_ret_sts_error;
913: END IF;
914:
915:
916: IF p_source_rec.USED_FOR_OBJECT_ID = FND_API.g_miss_num OR p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN
917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
918: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_USED_FOR_OBJ_ID');
919: FND_MSG_PUB.add;
920: END IF;

Line 921: x_return_status := FND_API.g_ret_sts_error;

917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
918: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_USED_FOR_OBJ_ID');
919: FND_MSG_PUB.add;
920: END IF;
921: x_return_status := FND_API.g_ret_sts_error;
922: END IF;
923:
924:
925: IF p_source_rec.PARTY_ID = FND_API.g_miss_num OR p_source_rec.PARTY_ID IS NULL THEN

Line 925: IF p_source_rec.PARTY_ID = FND_API.g_miss_num OR p_source_rec.PARTY_ID IS NULL THEN

921: x_return_status := FND_API.g_ret_sts_error;
922: END IF;
923:
924:
925: IF p_source_rec.PARTY_ID = FND_API.g_miss_num OR p_source_rec.PARTY_ID IS NULL THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
928: FND_MSG_PUB.add;
929: END IF;

Line 930: x_return_status := FND_API.g_ret_sts_error;

926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
928: FND_MSG_PUB.add;
929: END IF;
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932: ELSE -- update mode
933: IF p_source_rec.SOURCE_ID IS NULL THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 938: x_return_status := FND_API.g_ret_sts_error;

934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
935: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_SOURCE_ID');
936: FND_MSG_PUB.add;
937: END IF;
938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;
940:
941: IF p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN
942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

Line 946: x_return_status := FND_API.g_ret_sts_error;

942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
943: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
944: FND_MSG_PUB.add;
945: END IF;
946: x_return_status := FND_API.g_ret_sts_error;
947: END IF;
948:
949:
950: IF p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN

Line 955: x_return_status := FND_API.g_ret_sts_error;

951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
952: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_USED_FOR_OBJ_ID');
953: FND_MSG_PUB.add;
954: END IF;
955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957:
958:
959: IF p_source_rec.PARTY_ID IS NULL THEN

Line 964: x_return_status := FND_API.g_ret_sts_error;

960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
961: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
962: FND_MSG_PUB.add;
963: END IF;
964: x_return_status := FND_API.g_ret_sts_error;
965: END IF;
966: END IF;
967:
968: END check_source_req_items;

Line 980: x_return_status := FND_API.g_ret_sts_success;

976: IF (AMS_DEBUG_HIGH_ON) THEN
977:
978: AMS_UTILITY_PVT.debug_message('Private API:check_source_fk_items');
979: END IF;
980: x_return_status := FND_API.g_ret_sts_success;
981:
982: --------------------used_for_object_id---------------------------
983: IF p_source_rec.arc_used_for_object = 'MODL' THEN
984: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN

Line 984: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN

980: x_return_status := FND_API.g_ret_sts_success;
981:
982: --------------------used_for_object_id---------------------------
983: IF p_source_rec.arc_used_for_object = 'MODL' THEN
984: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN
985: IF AMS_Utility_PVT.check_fk_exists(
986: 'ams_dm_models_all_b',
987: 'model_id',
988: p_source_rec.used_for_object_id

Line 989: ) = FND_API.g_false

985: IF AMS_Utility_PVT.check_fk_exists(
986: 'ams_dm_models_all_b',
987: 'model_id',
988: p_source_rec.used_for_object_id
989: ) = FND_API.g_false
990: THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_MODEL_ID');
993: FND_MSG_PUB.add;

Line 995: x_return_status := FND_API.g_ret_sts_error;

991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_MODEL_ID');
993: FND_MSG_PUB.add;
994: END IF;
995: x_return_status := FND_API.g_ret_sts_error;
996: END IF;
997: END IF;
998: ELSIF p_source_rec.arc_used_for_object = 'SCOR' THEN
999: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN

Line 999: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN

995: x_return_status := FND_API.g_ret_sts_error;
996: END IF;
997: END IF;
998: ELSIF p_source_rec.arc_used_for_object = 'SCOR' THEN
999: IF p_source_rec.used_for_object_id <> FND_API.g_miss_num THEN
1000: IF AMS_Utility_PVT.check_fk_exists(
1001: 'ams_dm_scores_all_b',
1002: 'score_id',
1003: p_source_rec.used_for_object_id

Line 1004: ) = FND_API.g_false

1000: IF AMS_Utility_PVT.check_fk_exists(
1001: 'ams_dm_scores_all_b',
1002: 'score_id',
1003: p_source_rec.used_for_object_id
1004: ) = FND_API.g_false
1005: THEN
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_SCORE_ID');
1008: FND_MSG_PUB.add;

Line 1010: x_return_status := FND_API.g_ret_sts_error;

1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_SCORE_ID');
1008: FND_MSG_PUB.add;
1009: END IF;
1010: x_return_status := FND_API.g_ret_sts_error;
1011: END IF;
1012: END IF;
1013: END IF;
1014:

Line 1023: x_return_status := FND_API.g_ret_sts_success;

1019: x_return_status OUT NOCOPY VARCHAR2
1020: )
1021: IS
1022: BEGIN
1023: x_return_status := FND_API.g_ret_sts_success;
1024:
1025: END check_source_Lookup_items;
1026:
1027: PROCEDURE Check_source_Items (

Line 1076: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1072: END Complete_source_rec;
1073:
1074: PROCEDURE Validate_Source(
1075: p_api_version IN NUMBER,
1076: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1077: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1078: P_Validation_mode IN VARCHAR2,
1079: P_source_rec IN Source_Rec_Type,
1080: X_Return_Status OUT NOCOPY VARCHAR2,

Line 1077: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1073:
1074: PROCEDURE Validate_Source(
1075: p_api_version IN NUMBER,
1076: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1077: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1078: P_Validation_mode IN VARCHAR2,
1079: P_source_rec IN Source_Rec_Type,
1080: X_Return_Status OUT NOCOPY VARCHAR2,
1081: X_Msg_Count OUT NOCOPY NUMBER,

Line 1092: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1088: l_source_rec AMS_DMSource_PVT.Source_Rec_Type;
1089:
1090: BEGIN
1091: -- Standard call to check for call compatibility.
1092: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1093: p_api_version,
1094: l_api_name,
1095: G_PKG_NAME)
1096: THEN

Line 1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1093: p_api_version,
1094: l_api_name,
1095: G_PKG_NAME)
1096: THEN
1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099:
1100: -- Initialize message list if p_init_msg_list is set to TRUE.
1101: IF FND_API.to_Boolean( p_init_msg_list )

Line 1101: IF FND_API.to_Boolean( p_init_msg_list )

1097: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1098: END IF;
1099:
1100: -- Initialize message list if p_init_msg_list is set to TRUE.
1101: IF FND_API.to_Boolean( p_init_msg_list )
1102: THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN

Line 1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1108: p_validation_mode => p_validation_mode,
1109: x_return_status => x_return_status
1110: );
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;

Line 1113: RAISE FND_API.G_EXC_ERROR;

1109: x_return_status => x_return_status
1110: );
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: END IF;

Line 1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1110: );
1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: END IF;
1118:

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1111:
1112: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1113: RAISE FND_API.G_EXC_ERROR;
1114: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: END IF;
1117: END IF;
1118:
1119: Complete_source_rec(

Line 1127: p_init_msg_list => FND_API.G_FALSE,

1123:
1124: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_record THEN
1125: Validate_source_rec(
1126: p_api_version => 1.0,
1127: p_init_msg_list => FND_API.G_FALSE,
1128: x_return_status => x_return_status,
1129: x_msg_count => x_msg_count,
1130: x_msg_data => x_msg_data,
1131: P_source_rec => l_source_rec);

Line 1133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1129: x_msg_count => x_msg_count,
1130: x_msg_data => x_msg_data,
1131: P_source_rec => l_source_rec);
1132:
1133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: END IF;

Line 1134: RAISE FND_API.G_EXC_ERROR;

1130: x_msg_data => x_msg_data,
1131: P_source_rec => l_source_rec);
1132:
1133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: END IF;
1138: END IF;

Line 1135: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1131: P_source_rec => l_source_rec);
1132:
1133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: END IF;
1138: END IF;
1139:

Line 1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1132:
1133: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1137: END IF;
1138: END IF;
1139:
1140:

Line 1149: x_return_status := FND_API.G_RET_STS_SUCCESS;

1145: END IF;
1146:
1147:
1148: -- Initialize API return status to SUCCESS
1149: x_return_status := FND_API.G_RET_STS_SUCCESS;
1150:
1151:
1152: -- Debug Message
1153: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1166: x_return_status := FND_API.g_ret_sts_error;

1162: );
1163: EXCEPTION
1164:
1165: WHEN AMS_Utility_PVT.resource_locked THEN
1166: x_return_status := FND_API.g_ret_sts_error;
1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1168: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1169: FND_MSG_PUB.add;
1170: END IF;

Line 1172: WHEN FND_API.G_EXC_ERROR THEN

1168: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1169: FND_MSG_PUB.add;
1170: END IF;
1171:
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,

Line 1173: x_return_status := FND_API.G_RET_STS_ERROR;

1169: FND_MSG_PUB.add;
1170: END IF;
1171:
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,

Line 1176: p_encoded => FND_API.G_FALSE,

1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );
1180:

Line 1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );
1180:
1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (
1185: p_encoded => FND_API.G_FALSE,

Line 1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1178: p_data => x_msg_data
1179: );
1180:
1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (
1185: p_encoded => FND_API.G_FALSE,
1186: p_count => x_msg_count,

Line 1185: p_encoded => FND_API.G_FALSE,

1181: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1182: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: -- Standard call to get message count and if count=1, get the message
1184: FND_MSG_PUB.Count_And_Get (
1185: p_encoded => FND_API.G_FALSE,
1186: p_count => x_msg_count,
1187: p_data => x_msg_data
1188: );
1189:

Line 1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1187: p_data => x_msg_data
1188: );
1189:
1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1195: END IF;

Line 1198: p_encoded => FND_API.G_FALSE,

1194: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1195: END IF;
1196: -- Standard call to get message count and if count=1, get the message
1197: FND_MSG_PUB.Count_And_Get (
1198: p_encoded => FND_API.G_FALSE,
1199: p_count => x_msg_count,
1200: p_data => x_msg_data
1201: );
1202: End Validate_Source;

Line 1207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1203:
1204:
1205: PROCEDURE Validate_source_rec(
1206: p_api_version IN NUMBER,
1207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1208: X_Return_Status OUT NOCOPY VARCHAR2,
1209: X_Msg_Count OUT NOCOPY NUMBER,
1210: X_Msg_Data OUT NOCOPY VARCHAR2,
1211: P_source_rec IN Source_Rec_Type

Line 1216: IF FND_API.to_Boolean( p_init_msg_list )

1212: )
1213: IS
1214: BEGIN
1215: -- Initialize message list if p_init_msg_list is set to TRUE.
1216: IF FND_API.to_Boolean( p_init_msg_list )
1217: THEN
1218: FND_MSG_PUB.initialize;
1219: END IF;
1220:

Line 1222: x_return_status := FND_API.G_RET_STS_SUCCESS;

1218: FND_MSG_PUB.initialize;
1219: END IF;
1220:
1221: -- Initialize API return status to SUCCESS
1222: x_return_status := FND_API.G_RET_STS_SUCCESS;
1223:
1224: -- Hint: Validate data
1225: -- If data not valid
1226: -- THEN

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

1223:
1224: -- Hint: Validate data
1225: -- If data not valid
1226: -- THEN
1227: -- x_return_status := FND_API.G_RET_STS_ERROR;
1228:
1229: -- Debug Message
1230: IF (AMS_DEBUG_HIGH_ON) THEN
1231:

Line 1259: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1255: -- Standard Start of API savepoint
1256: SAVEPOINT bin_probability;
1257:
1258: -- Standard call to check for call compatibility.
1259: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1260: p_api_version,
1261: l_api_name,
1262: G_PKG_NAME)
1263: THEN

Line 1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1260: p_api_version,
1261: l_api_name,
1262: G_PKG_NAME)
1263: THEN
1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize API return status to SUCCESS
1268: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1268: x_return_status := FND_API.G_RET_STS_SUCCESS;

1264: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1265: END IF;
1266:
1267: -- Initialize API return status to SUCCESS
1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:
1270: -- Initialize message list if p_init_msg_list is set to TRUE.
1271: IF FND_API.to_Boolean (p_init_msg_list) THEN
1272: FND_MSG_PUB.initialize;

Line 1271: IF FND_API.to_Boolean (p_init_msg_list) THEN

1267: -- Initialize API return status to SUCCESS
1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:
1270: -- Initialize message list if p_init_msg_list is set to TRUE.
1271: IF FND_API.to_Boolean (p_init_msg_list) THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:
1275: UPDATE ams_dm_source

Line 1288: IF FND_API.to_Boolean (p_commit) THEN

1284: AND used_for_object_id = p_score_id
1285: AND continuous_score IS NOT NULL;
1286:
1287: -- Standard check for p_commit
1288: IF FND_API.to_Boolean (p_commit) THEN
1289: COMMIT WORK;
1290: END IF;
1291: EXCEPTION
1292: WHEN OTHERS THEN

Line 1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1290: END IF;
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: ROLLBACK TO bin_probability;
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1297: END IF;
1298: -- Standard call to get message count and if count=1, get the message

Line 1300: p_encoded => FND_API.G_FALSE,

1296: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1297: END IF;
1298: -- Standard call to get message count and if count=1, get the message
1299: FND_MSG_PUB.Count_And_Get (
1300: p_encoded => FND_API.G_FALSE,
1301: p_count => x_msg_count,
1302: p_data => x_msg_data
1303: );
1304: END bin_probability;

Line 1366: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1362: -- Standard Start of API savepoint
1363: SAVEPOINT process_scores;
1364:
1365: -- Standard call to check for call compatibility.
1366: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1367: p_api_version,
1368: l_api_name,
1369: G_PKG_NAME)
1370: THEN

Line 1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1367: p_api_version,
1368: l_api_name,
1369: G_PKG_NAME)
1370: THEN
1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END IF;
1373:
1374: -- Initialize message list if p_init_msg_list is set to TRUE.
1375: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1375: IF FND_API.to_Boolean (p_init_msg_list) THEN

1371: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1372: END IF;
1373:
1374: -- Initialize message list if p_init_msg_list is set to TRUE.
1375: IF FND_API.to_Boolean (p_init_msg_list) THEN
1376: FND_MSG_PUB.initialize;
1377: END IF;
1378:
1379: -- Initialize API return status to SUCCESS

Line 1380: x_return_status := FND_API.G_RET_STS_SUCCESS;

1376: FND_MSG_PUB.initialize;
1377: END IF;
1378:
1379: -- Initialize API return status to SUCCESS
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;
1381:
1382: -- if the data mining database is remote
1383: -- from the CRM database, then we need to
1384: -- access the results through a database

Line 1444: IF FND_API.to_Boolean (p_commit) THEN

1440: -- DELETE FROM ams_dm_apply_stg;
1441: DELETE FROM ams_dm_apply_stg_gt;
1442:
1443: -- Standard check for p_commit
1444: IF FND_API.to_Boolean (p_commit) THEN
1445: COMMIT WORK;
1446: END IF;
1447: EXCEPTION
1448: WHEN OTHERS THEN

Line 1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1446: END IF;
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: ROLLBACK TO process_scores;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1453: END IF;
1454: -- Standard call to get message count and if count=1, get the message

Line 1456: p_encoded => FND_API.G_FALSE,

1452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1453: END IF;
1454: -- Standard call to get message count and if count=1, get the message
1455: FND_MSG_PUB.Count_And_Get (
1456: p_encoded => FND_API.G_FALSE,
1457: p_count => x_msg_count,
1458: p_data => x_msg_data
1459: );
1460: END process_scores;

Line 1607: IF NOT FND_API.Compatible_API_Call (l_api_version_number,

1603: l_dummy NUMBER;
1604:
1605: BEGIN
1606: -- Standard call to check for call compatibility.
1607: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1608: p_api_version,
1609: l_api_name,
1610: G_PKG_NAME)
1611: THEN

Line 1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1608: p_api_version,
1609: l_api_name,
1610: G_PKG_NAME)
1611: THEN
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1613: END IF;
1614:
1615: -- Initialize message list if p_init_msg_list is set to TRUE.
1616: IF FND_API.to_Boolean (p_init_msg_list) THEN

Line 1616: IF FND_API.to_Boolean (p_init_msg_list) THEN

1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1613: END IF;
1614:
1615: -- Initialize message list if p_init_msg_list is set to TRUE.
1616: IF FND_API.to_Boolean (p_init_msg_list) THEN
1617: FND_MSG_PUB.initialize;
1618: END IF;
1619:
1620: -- Initialize API return status to SUCCESS

Line 1621: x_return_status := FND_API.G_RET_STS_SUCCESS;

1617: FND_MSG_PUB.initialize;
1618: END IF;
1619:
1620: -- Initialize API return status to SUCCESS
1621: x_return_status := FND_API.G_RET_STS_SUCCESS;
1622:
1623: -- kbasavar 27-Jun-2003 validate for object type. Call randomize_build_data only for build
1624: IF p_object_type = 'MODL' THEN
1625: randomize_build_data (

Line 1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1670: x_select_fields => l_select_list,
1671: x_return_status => l_return_status
1672: );
1673:
1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: END IF;
1677:
1678: --kbasavar 12/17/2004 Perf Bug 4074433

Line 1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1671: x_return_status => l_return_status
1672: );
1673:
1674: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1675: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1676: END IF;
1677:
1678: --kbasavar 12/17/2004 Perf Bug 4074433
1679: --This procedure will return two where clause strings one for creating view and the other for querying

Line 1691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1687: x_where_clause => l_where_clause,
1688: x_return_status => l_return_status
1689: );
1690:
1691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;
1694:
1695: AMS_Utility_PVT.create_log (

Line 1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1688: x_return_status => l_return_status
1689: );
1690:
1691: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1693: END IF;
1694:
1695: AMS_Utility_PVT.create_log (
1696: x_return_status => l_log_return_status,

Line 1738: RAISE FND_API.G_EXC_ERROR;

1734:
1735: IF l_dummy = 1 THEN
1736: AMS_UTILITY_PVT.debug_message(L_API_NAME || ' :: ' || 'Data Source mapping not 1-to-1, raising error...');
1737: AMS_Utility_PVT.Error_Message('AMS_DM_DS_MAPPING_ERROR');
1738: RAISE FND_API.G_EXC_ERROR;
1739: END IF;
1740:
1741: IF p_object_type = 'MODL' THEN
1742: create_build_views (

Line 1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1754: );
1755: END IF;
1756: EXCEPTION
1757: WHEN OTHERS THEN
1758: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1759: AMS_Utility_PVT.create_log (
1760: x_return_status => l_log_return_status,
1761: p_arc_log_used_by => p_object_type,
1762: p_log_used_by_id => p_object_id,

Line 1770: p_encoded => FND_API.G_FALSE,

1766: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1767: END IF;
1768: -- Standard call to get message count and if count=1, get the message
1769: FND_MSG_PUB.Count_And_Get (
1770: p_encoded => FND_API.G_FALSE,
1771: p_count => x_msg_count,
1772: p_data => x_msg_data
1773: );
1774: END generate_odm_input_views;

Line 1826: RAISE FND_API.G_EXC_ERROR;

1822: END IF;
1823:
1824: IF (c_check_targets%NOTFOUND OR l_target_count=0) THEN
1825: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');
1826: RAISE FND_API.G_EXC_ERROR;
1827: END IF;
1828:
1829: CLOSE c_check_targets;
1830:

Line 1840: RAISE FND_API.G_EXC_ERROR;

1836: END IF;
1837:
1838: IF (c_check_targets%NOTFOUND OR l_target_count=0) THEN
1839: AMS_Utility_PVT.Error_Message('AMS_MODEL_NO_BAL_POSITIVE_TGTS');
1840: RAISE FND_API.G_EXC_ERROR;
1841: END IF;
1842:
1843: CLOSE c_check_targets;
1844:

Line 2118: x_return_status := FND_API.G_RET_STS_SUCCESS;

2114: l_target_field NUMBER;
2115: l_count NUMBER;
2116: l_dup_fields VARCHAR2(32767);
2117: BEGIN
2118: x_return_status := FND_API.G_RET_STS_SUCCESS;
2119:
2120: x_select_fields := 'distinct s.source_id'; -- mandatory identifier for ODM results
2121:
2122: OPEN c_target_field (p_target_id);

Line 2140: x_return_status := FND_API.G_RET_STS_ERROR;

2136: l_count:=c_dup_fields_custprof%ROWCOUNT;
2137: IF l_count <> 0 THEN
2138: IF l_count <= 15 THEN
2139: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: ELSE
2142: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2143: x_return_status := FND_API.G_RET_STS_ERROR;
2144: END IF;

Line 2143: x_return_status := FND_API.G_RET_STS_ERROR;

2139: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2140: x_return_status := FND_API.G_RET_STS_ERROR;
2141: ELSE
2142: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2143: x_return_status := FND_API.G_RET_STS_ERROR;
2144: END IF;
2145: CLOSE c_dup_fields_custprof;
2146: return;
2147: END IF;

Line 2175: x_return_status := FND_API.G_RET_STS_ERROR;

2171: END LOOP;
2172:
2173: IF c_fields_custprof%ROWCOUNT = 0 THEN
2174: AMS_Utility_PVT.error_message ('AMS_DM_NO_VALID_SOURCE_FIELDS');
2175: x_return_status := FND_API.G_RET_STS_ERROR;
2176: END IF;
2177: CLOSE c_fields_custprof;
2178:
2179:

Line 2195: x_return_status := FND_API.G_RET_STS_ERROR;

2191: l_count:=c_dup_fields%ROWCOUNT;
2192: IF l_count <> 0 THEN
2193: IF l_count <= 15 THEN
2194: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2195: x_return_status := FND_API.G_RET_STS_ERROR;
2196: ELSE
2197: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2198: x_return_status := FND_API.G_RET_STS_ERROR;
2199: END IF;

Line 2198: x_return_status := FND_API.G_RET_STS_ERROR;

2194: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS' , 'FIELDS' , l_dup_fields);
2195: x_return_status := FND_API.G_RET_STS_ERROR;
2196: ELSE
2197: AMS_Utility_PVT.error_message ('AMS_DM_DUP_SOURCE_FIELDS_NUM' , 'FIELD_COUNT' , l_count);
2198: x_return_status := FND_API.G_RET_STS_ERROR;
2199: END IF;
2200: CLOSE c_dup_fields;
2201: return;
2202: END IF;

Line 2231: x_return_status := FND_API.G_RET_STS_ERROR;

2227: END LOOP;
2228:
2229: IF c_fields%ROWCOUNT = 0 THEN
2230: AMS_Utility_PVT.error_message ('AMS_DM_NO_VALID_SOURCE_FIELDS');
2231: x_return_status := FND_API.G_RET_STS_ERROR;
2232: END IF;
2233: CLOSE c_fields;
2234:
2235: END IF;

Line 2319: x_return_status := FND_API.G_RET_STS_SUCCESS;

2315: l_is_b2b BOOLEAN := FALSE;
2316: l_is_seeded BOOLEAN := FALSE;
2317:
2318: BEGIN
2319: x_return_status := FND_API.G_RET_STS_SUCCESS;
2320:
2321: OPEN c_data_source (p_data_source_id);
2322: FETCH c_data_source INTO l_object_name, l_object_name_full, l_pk_field;
2323: IF c_data_source%NOTFOUND THEN

Line 2325: x_return_status := FND_API.G_RET_STS_ERROR;

2321: OPEN c_data_source (p_data_source_id);
2322: FETCH c_data_source INTO l_object_name, l_object_name_full, l_pk_field;
2323: IF c_data_source%NOTFOUND THEN
2324: CLOSE c_data_source;
2325: x_return_status := FND_API.G_RET_STS_ERROR;
2326: RETURN;
2327: END IF;
2328: CLOSE c_data_source;
2329: