[Home] [Help]
128: WHERE EXISTS (SELECT 1 FROM AMS_DM_SCORE_RESULTS
129: WHERE SCORE_RESULT_ID = l_id);
130:
131: BEGIN
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,
131: BEGIN
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)
229: --
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;
242:
243: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
244: END IF;
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get
248: (p_count => x_msg_count,
249: p_data => x_msg_data
250: );
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,
264: p_data => x_msg_data
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,
274: p_data => x_msg_data
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;
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
316: FROM AMS_DM_SCORE_RESULTS
317: WHERE score_result_id = p_score_result_id;
318: l_ref_scoreresult_rec c_get_Scoreresult%ROWTYPE ;
319: BEGIN
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,
319: BEGIN
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)
421: --
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;
434:
435: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
436: END IF;
437:
438: -- Standard call to get message count and if count is 1, get message info.
439: FND_MSG_PUB.Count_And_Get
440: (p_count => x_msg_count,
441: p_data => x_msg_data
442: );
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,
456: p_data => x_msg_data
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,
466: p_data => x_msg_data
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;
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
496: IS
497: L_API_NAME CONSTANT VARCHAR2(30) := 'Delete_Scoreresult';
498: L_API_VERSION_NUMBER CONSTANT NUMBER := 1.0;
499: BEGIN
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,
499: BEGIN
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)
540: --
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;
553:
554: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
555: END IF;
556:
557: -- Standard call to get message count and if count is 1, get message info.
558: FND_MSG_PUB.Count_And_Get
559: (p_count => x_msg_count,
560: p_data => x_msg_data
561: );
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,
575: p_data => x_msg_data
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,
585: p_data => x_msg_data
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;
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
640: THEN
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)
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,
704: p_data => x_msg_data
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,
714: p_data => x_msg_data
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;
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
944: l_object_version_number NUMBER;
945: l_scoreresult_rec AMS_Scoreresult_PVT.scoreresult_rec_type;
946:
947: BEGIN
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,
947: BEGIN
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)
1013: IF (AMS_DEBUG_HIGH_ON) THEN
1014: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1015: END IF;
1016:
1017: -- Standard call to get message count and if count is 1, get message info.
1018: FND_MSG_PUB.Count_And_Get
1019: (p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );
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,
1035: p_data => x_msg_data
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,
1045: p_data => x_msg_data
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;
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
1089: IF (AMS_DEBUG_HIGH_ON) THEN
1090:
1091: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1092: END IF;
1093: -- Standard call to get message count and if count is 1, get message info.
1094: FND_MSG_PUB.Count_And_Get
1095: (p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );
1146: l_avg_conf_cum_list dbms_sql.NUMBER_table;
1147:
1148: BEGIN
1149:
1150: -- Standard Start of API savepoint
1151: SAVEPOINT insert_percentile_results;
1152:
1153: -- Debug Message
1154: IF (AMS_DEBUG_HIGH_ON) THEN
1462: l_model_id NUMBER;
1463: l_model_type VARCHAR2(30);
1464: l_is_org_prod BOOLEAN;
1465: BEGIN
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,
1465: BEGIN
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)
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,
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,
1575: p_data => x_msg_data
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;
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
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,
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,
1805: p_data => x_msg_data
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,
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,
1865: p_data => x_msg_data