[Home] [Help]
131:
132: WriteLog(l_msg || 'x_return_status='||x_return_status);
133: WriteLog(l_msg || 'x_dup_status='||x_dup_status);
134:
135: -- Standard call to get message count and IF count is 1, get message info.
136:
137: FND_MSG_PUB.Count_And_Get
138: ( p_count => x_msg_count,
139: p_data => x_msg_data );
195: END IF;
196: CLOSE C_GET_SCORE_ID_Name;
197: END IF;
198:
199: -- Standard call to get message count and IF count is 1, get message info.
200:
201: FND_MSG_PUB.Count_And_Get
202: ( p_count => x_msg_count,
203: p_data => x_msg_data );
257: END IF;
258: CLOSE C_GET_SCORE_COMP_NAME;
259: END IF;
260:
261: -- Standard call to get message count and IF count is 1, get message info.
262:
263: FND_MSG_PUB.Count_And_Get
264: ( p_count => x_msg_count,
265: p_data => x_msg_data );
321: END IF;
322: CLOSE C_GET_SCORE_COMP_ID_NAME;
323: END IF;
324:
325: -- Standard call to get message count and IF count is 1, get message info.
326:
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,
329: p_data => x_msg_data );
358: BEGIN
359: l_SCORE_REC := p_score_rec;
360:
361:
362: -- Standard Start of API savepoint
363: SAVEPOINT CREATE_SCORE_PVT;
364:
365: -- Standard call to check for call compatibility.
366: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
361:
362: -- Standard Start of API savepoint
363: SAVEPOINT CREATE_SCORE_PVT;
364:
365: -- Standard call to check for call compatibility.
366: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
367: p_api_version,
368: l_api_name,
369: G_PKG_NAME)
518: --
519: -- End of API body
520: --
521:
522: -- Standard check for p_commit
523: IF FND_API.to_Boolean( p_commit )
524: THEN
525: COMMIT WORK;
526: END IF;
527:
528: -- Debug Message
529: WriteLog(l_msg || 'END');
530:
531: -- Standard call to get message count and IF count is 1, get message info.
532: FND_MSG_PUB.Count_And_Get
533: ( p_count => x_msg_count,
534: p_data => x_msg_data);
535:
611: BEGIN
612:
613: l_SCORE_REC := p_score_rec;
614:
615: -- Standard Start of API savepoint
616: SAVEPOINT UPDATE_SCORE_PVT;
617:
618: -- Standard call to check for call compatibility.
619: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
614:
615: -- Standard Start of API savepoint
616: SAVEPOINT UPDATE_SCORE_PVT;
617:
618: -- Standard call to check for call compatibility.
619: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
620: p_api_version,
621: l_api_name,
622: G_PKG_NAME)
813: --
814: -- End of API body.
815: --
816:
817: -- Standard check for p_commit
818: IF FND_API.to_Boolean( p_commit )
819: THEN
820: COMMIT WORK;
821: END IF;
822:
823: -- Debug Message
824: WriteLog('iexvscrb:UpdScr: End');
825:
826: -- Standard call to get message count and IF count is 1, get message info.
827: FND_MSG_PUB.Count_And_Get
828: ( p_count => x_msg_count,
829: p_data => x_msg_data );
830:
893: l_rowid Varchar2(50);
894:
895:
896: BEGIN
897: -- Standard Start of API savepoint
898: SAVEPOINT DELETE_SCORE_PVT;
899:
900: -- IF PG_DEBUG < 10 THEN
901: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
901: IF (FND_LOG.LEVEL_EVENT >= PG_DEBUG) THEN
902: IEX_DEBUG_PUB.LogMessage('Delete_Score: ' || 'iexvscrb.pls:Delete_Score=>scoreid='||p_score_id);
903: END IF;
904:
905: -- Standard call to check for call compatibility.
906: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
907: p_api_version,
908: l_api_name,
909: G_PKG_NAME)
1022: --
1023: -- End of API body
1024: --
1025:
1026: -- Standard check for p_commit
1027: IF FND_API.to_Boolean( p_commit )
1028: THEN
1029: COMMIT WORK;
1030: END IF;
1087:
1088: BEGIN
1089: l_SCORE_COMP_REC := p_score_comp_rec;
1090:
1091: -- Standard Start of API savepoint
1092: SAVEPOINT CREATE_Score_Comp_PVT;
1093:
1094: -- Standard call to check for call compatibility.
1095: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1090:
1091: -- Standard Start of API savepoint
1092: SAVEPOINT CREATE_Score_Comp_PVT;
1093:
1094: -- Standard call to check for call compatibility.
1095: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1096: p_api_version,
1097: l_api_name,
1098: G_PKG_NAME)
1199: --
1200: -- End of API body
1201: --
1202:
1203: -- Standard check for p_commit
1204: IF FND_API.to_Boolean( p_commit )
1205: THEN
1206: COMMIT WORK;
1207: END IF;
1208:
1209: -- Debug Message
1210: WriteLog(l_msg || 'End' );
1211:
1212: -- Standard call to get message count and IF count is 1, get message info.
1213: FND_MSG_PUB.Count_And_Get
1214: ( p_count => x_msg_count,
1215: p_data => x_msg_data);
1216:
1277:
1278: BEGIN
1279: l_SCORE_COMP_REC := p_score_comp_rec;
1280:
1281: -- Standard Start of API savepoint
1282: SAVEPOINT UPDATE_Score_Comp_PVT;
1283:
1284: -- Standard call to check for call compatibility.
1285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1280:
1281: -- Standard Start of API savepoint
1282: SAVEPOINT UPDATE_Score_Comp_PVT;
1283:
1284: -- Standard call to check for call compatibility.
1285: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1286: p_api_version,
1287: l_api_name,
1288: G_PKG_NAME)
1434: --
1435: -- End of API body.
1436: --
1437:
1438: -- Standard check for p_commit
1439: IF FND_API.to_Boolean( p_commit )
1440: THEN
1441: COMMIT WORK;
1442: END IF;
1444: -- Debug Message
1445: WriteLog('iexvscrb:UpdScrComp: End');
1446:
1447:
1448: -- Standard call to get message count and IF count is 1, get message info.
1449: FND_MSG_PUB.Count_And_Get
1450: ( p_count => x_msg_count,
1451: p_data => x_msg_data );
1452:
1505: l_msg_data VARCHAR2(32767);
1506: l_rowid Varchar2(50);
1507:
1508: BEGIN
1509: -- Standard Start of API savepoint
1510: SAVEPOINT DELETE_SCORE_COMP_PVT;
1511:
1512: WriteLog('iexvscrb:Delete_Score_Comp=>Start');
1513: WriteLog('iexvscrb:Delete_Score_Comp=>scorecompid='||p_score_comp_id);
1511:
1512: WriteLog('iexvscrb:Delete_Score_Comp=>Start');
1513: WriteLog('iexvscrb:Delete_Score_Comp=>scorecompid='||p_score_comp_id);
1514:
1515: -- Standard call to check for call compatibility.
1516: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1517: p_api_version,
1518: l_api_name,
1519: G_PKG_NAME)
1595: --
1596: -- End of API body
1597: --
1598:
1599: -- Standard check for p_commit
1600: IF FND_API.to_Boolean( p_commit )
1601: THEN
1602: COMMIT WORK;
1603: END IF;
1665:
1666: BEGIN
1667: l_SCORE_COMP_Type_REC := p_score_comp_type_rec;
1668:
1669: -- Standard Start of API savepoint
1670: SAVEPOINT CREATE_Score_Comp_TYPE_PVT;
1671:
1672: -- Standard call to check for call compatibility.
1673: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1668:
1669: -- Standard Start of API savepoint
1670: SAVEPOINT CREATE_Score_Comp_TYPE_PVT;
1671:
1672: -- Standard call to check for call compatibility.
1673: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1674: p_api_version,
1675: l_api_name,
1676: G_PKG_NAME)
1754: --
1755: -- End of API body
1756: --
1757:
1758: -- Standard check for p_commit
1759: IF FND_API.to_Boolean( p_commit )
1760: THEN
1761: COMMIT WORK;
1762: END IF;
1764: -- Debug Message
1765: WriteLog('iexvscrb:CreateScrCompType: End');
1766:
1767:
1768: -- Standard call to get message count and IF count is 1, get message info.
1769: FND_MSG_PUB.Count_And_Get
1770: ( p_count => x_msg_count,
1771: p_data => x_msg_data);
1772:
1854: BEGIN
1855:
1856: l_SCORE_COMP_TYPE_REC := p_score_comp_type_rec;
1857:
1858: -- Standard Start of API savepoint
1859: SAVEPOINT UPDATE_Score_Comp_TYPE_PVT;
1860:
1861: -- Standard call to check for call compatibility.
1862: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1857:
1858: -- Standard Start of API savepoint
1859: SAVEPOINT UPDATE_Score_Comp_TYPE_PVT;
1860:
1861: -- Standard call to check for call compatibility.
1862: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
1863: p_api_version,
1864: l_api_name,
1865: G_PKG_NAME)
2027: --
2028: -- End of API body.
2029: --
2030:
2031: -- Standard check for p_commit
2032: IF FND_API.to_Boolean( p_commit )
2033: THEN
2034: COMMIT WORK;
2035: END IF;
2036:
2037: -- Debug Message
2038: WriteLog('iexvscrb:UpdScrCompType:End');
2039:
2040: -- Standard call to get message count and IF count is 1, get message info.
2041: FND_MSG_PUB.Count_And_Get
2042: ( p_count => x_msg_count,
2043: p_data => x_msg_data );
2044:
2094:
2095: BEGIN
2096: l_score_comp_Type_id := p_score_comp_type_id;
2097:
2098: -- Standard Start of API savepoint
2099: SAVEPOINT DELETE_SCORE_COMP_TYPE_PVT;
2100:
2101: -- Standard call to check for call compatibility.
2102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2097:
2098: -- Standard Start of API savepoint
2099: SAVEPOINT DELETE_SCORE_COMP_TYPE_PVT;
2100:
2101: -- Standard call to check for call compatibility.
2102: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2103: p_api_version,
2104: l_api_name,
2105: G_PKG_NAME)
2157: --
2158: -- End of API body
2159: --
2160:
2161: -- Standard check for p_commit
2162: IF FND_API.to_Boolean( p_commit )
2163: THEN
2164: COMMIT WORK;
2165: END IF;
2224:
2225: BEGIN
2226: l_SCORE_COMP_DET_REC := p_SCORE_COMP_DET_REC;
2227:
2228: -- Standard Start of API savepoint
2229: SAVEPOINT CREATE_Score_Comp_Det_PVT;
2230:
2231: -- Standard call to check for call compatibility.
2232: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2227:
2228: -- Standard Start of API savepoint
2229: SAVEPOINT CREATE_Score_Comp_Det_PVT;
2230:
2231: -- Standard call to check for call compatibility.
2232: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2233: p_api_version,
2234: l_api_name,
2235: G_PKG_NAME)
2325: --
2326: -- End of API body
2327: --
2328:
2329: -- Standard check for p_commit
2330: IF FND_API.to_Boolean( p_commit )
2331: THEN
2332: COMMIT WORK;
2333: END IF;
2334:
2335: -- Debug Message
2336: WriteLog(l_msg || 'END');
2337:
2338: -- Standard call to get message count and IF count is 1, get message info.
2339: FND_MSG_PUB.Count_And_Get
2340: ( p_count => x_msg_count,
2341: p_data => x_msg_data
2342: );
2408: BEGIN
2409:
2410: l_SCORE_COMP_DET_REC := p_score_comp_det_rec;
2411:
2412: -- Standard Start of API savepoint
2413: SAVEPOINT UPDATE_Score_Comp_DET_PVT;
2414:
2415: -- Standard call to check for call compatibility.
2416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2411:
2412: -- Standard Start of API savepoint
2413: SAVEPOINT UPDATE_Score_Comp_DET_PVT;
2414:
2415: -- Standard call to check for call compatibility.
2416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2417: p_api_version,
2418: l_api_name,
2419: G_PKG_NAME)
2547: --
2548: -- End of API body.
2549: --
2550:
2551: -- Standard check for p_commit
2552: IF FND_API.to_Boolean( p_commit )
2553: THEN
2554: COMMIT WORK;
2555: END IF;
2557: -- Debug Message
2558: WriteLog('iexvscrb: UpdSrCompDet: End');
2559:
2560:
2561: -- Standard call to get message count and IF count is 1, get message info.
2562: FND_MSG_PUB.Count_And_Get
2563: ( p_count => x_msg_count,
2564: p_data => x_msg_data );
2565:
2611: l_msg_data VARCHAR2(32767);
2612: l_rowid Varchar2(50);
2613:
2614: BEGIN
2615: -- Standard Start of API savepoint
2616: SAVEPOINT DELETE_SCORE_COMP_DET_PVT;
2617:
2618: -- Standard call to check for call compatibility.
2619: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2614: BEGIN
2615: -- Standard Start of API savepoint
2616: SAVEPOINT DELETE_SCORE_COMP_DET_PVT;
2617:
2618: -- Standard call to check for call compatibility.
2619: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2620: p_api_version,
2621: l_api_name,
2622: G_PKG_NAME)
2671: --
2672: -- End of API body
2673: --
2674:
2675: -- Standard check for p_commit
2676: IF FND_API.to_Boolean( p_commit )
2677: THEN
2678: COMMIT WORK;
2679: END IF;
2827: l_rowid Varchar2(50);
2828: x_dup_status VARCHAR2(1);
2829:
2830: BEGIN
2831: -- Standard Start of API savepoint
2832: SAVEPOINT COPY_SCORINGENGINE_PVT;
2833:
2834: -- Standard call to check for call compatibility.
2835: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2830: BEGIN
2831: -- Standard Start of API savepoint
2832: SAVEPOINT COPY_SCORINGENGINE_PVT;
2833:
2834: -- Standard call to check for call compatibility.
2835: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
2836: p_api_version,
2837: l_api_name,
2838: G_PKG_NAME)
3232: --
3233: -- End of API body
3234: --
3235:
3236: -- Standard check for p_commit
3237: IF FND_API.to_Boolean( p_commit )
3238: THEN
3239: COMMIT WORK;
3240: END IF;
3345: BEGIN
3346:
3347: l_raw_score := IEX_SCORE_PVT.G_MIN_SCORE;
3348:
3349: -- Standard Start of API savepoint
3350: SAVEPOINT Get_Score_PVT;
3351:
3352: -- Standard call to check for call compatibility.
3353: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3348:
3349: -- Standard Start of API savepoint
3350: SAVEPOINT Get_Score_PVT;
3351:
3352: -- Standard call to check for call compatibility.
3353: IF NOT FND_API.Compatible_API_Call (l_api_version_number,
3354: p_api_version,
3355: l_api_name,
3356: G_PKG_NAME)
3507: --
3508: -- End of API body
3509: --
3510:
3511: -- Standard check for p_commit
3512: IF FND_API.to_Boolean(p_commit)
3513: THEN
3514: COMMIT WORK;
3515: END IF;