68:
69: -- Initialize message list if p_init_msg_list is set to TRUE.
70: IF FND_API.to_Boolean( p_init_msg_list )
71: THEN
72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Debug Message
76: iex_score_pvt.WriteLog('iexpscrb:CreateScore:Start');
113: -- Debug Message
114: iex_score_pvt.WriteLog('iexpscrb:CreateScore:End');
115:
116: -- Standard call to get message count and if count is 1, get message info.
117: FND_MSG_PUB.Count_And_Get
118: ( p_count => x_msg_count,
119: p_data => x_msg_data
120: );
121:
122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO CREATE_SCORE_PUB;
125: x_return_status := FND_API.G_RET_STS_ERROR ;
126: FND_MSG_PUB.Count_And_Get
127: ( p_count => x_msg_count,
128: p_data => x_msg_data
129: );
130:
130:
131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
132: ROLLBACK TO CREATE_SCORE_PUB;
133: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
134: FND_MSG_PUB.Count_And_Get
135: ( p_count => x_msg_count,
136: p_data => x_msg_data
137: );
138:
138:
139: WHEN OTHERS THEN
140: ROLLBACK TO CREATE_SCORE_PUB;
141: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count,
144: p_data => x_msg_data
145: );
146:
183:
184: -- Initialize message list if p_init_msg_list is set to TRUE.
185: IF FND_API.to_Boolean( p_init_msg_list )
186: THEN
187: FND_MSG_PUB.initialize;
188: END IF;
189:
190: -- Debug Message
191: iex_score_pvt.WriteLog('iexpscrb:UpdateScore:Start');
234: -- Debug Message
235: iex_score_pvt.WriteLog('iexpscrb:UpdateScore:End');
236:
237: -- Standard call to get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: ( p_count => x_msg_count,
240: p_data => x_msg_data );
241:
242: EXCEPTION
242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO UPDATE_SCORE_PUB;
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246: FND_MSG_PUB.Count_And_Get
247: ( p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250:
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: ROLLBACK TO UPDATE_SCORE_PUB;
253: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
254: FND_MSG_PUB.Count_And_Get
255: ( p_count => x_msg_count,
256: p_data => x_msg_data
257: );
258:
258:
259: WHEN OTHERS THEN
260: ROLLBACK TO UPDATE_SCORE_PUB;
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
262: FND_MSG_PUB.Count_And_Get
263: ( p_count => x_msg_count,
264: p_data => x_msg_data
265: );
266:
301:
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307:
308: -- Debug Message
309: iex_score_pvt.WriteLog('iexpscrb:DeleteScore:Start');
352:
353: -- Debug Message
354: iex_score_pvt.WriteLog('iexpscrb:DeleteScore:End');
355:
356: FND_MSG_PUB.Count_And_Get
357: ( p_count => x_msg_count,
358: p_data => x_msg_data );
359:
360: EXCEPTION
360: EXCEPTION
361: WHEN FND_API.G_EXC_ERROR THEN
362: ROLLBACK TO DELETE_SCORE_PUB;
363: x_return_status := FND_API.G_RET_STS_ERROR ;
364: FND_MSG_PUB.Count_And_Get
365: ( p_count => x_msg_count,
366: p_data => x_msg_data
367: );
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
367: );
368: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
369: ROLLBACK TO DELETE_SCORE_PUB;
370: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
371: FND_MSG_PUB.Count_And_Get
372: ( p_count => x_msg_count,
373: p_data => x_msg_data
374: );
375: WHEN OTHERS THEN
374: );
375: WHEN OTHERS THEN
376: ROLLBACK TO DELETE_SCORE_PUB;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
378: FND_MSG_PUB.Count_And_Get
379: ( p_count => x_msg_count,
380: p_data => x_msg_data
381: );
382:
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list )
420: THEN
421: FND_MSG_PUB.initialize;
422: END IF;
423:
424: -- Debug Message
425: iex_score_pvt.WriteLog('iexpscrb:CreateScoreComp: Start');
465: iex_score_pvt.WriteLog('iexpscrb:CreateScoreComp: End');
466:
467:
468: -- Standard call to get message count and if count is 1, get message info.
469: FND_MSG_PUB.Count_And_Get
470: ( p_count => x_msg_count,
471: p_data => x_msg_data
472: );
473:
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476: ROLLBACK TO CREATE_SCORE_COMP_PUB;
477: x_return_status := FND_API.G_RET_STS_ERROR ;
478: FND_MSG_PUB.Count_And_Get
479: ( p_count => x_msg_count,
480: p_data => x_msg_data
481: );
482:
482:
483: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
484: ROLLBACK TO CREATE_SCORE_COMP_PUB;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
486: FND_MSG_PUB.Count_And_Get
487: ( p_count => x_msg_count,
488: p_data => x_msg_data
489: );
490:
490:
491: WHEN OTHERS THEN
492: ROLLBACK TO CREATE_SCORE_COMP_PUB;
493: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
494: FND_MSG_PUB.Count_And_Get
495: ( p_count => x_msg_count,
496: p_data => x_msg_data
497: );
498:
534:
535: -- Initialize message list if p_init_msg_list is set to TRUE.
536: IF FND_API.to_Boolean( p_init_msg_list )
537: THEN
538: FND_MSG_PUB.initialize;
539: END IF;
540:
541: -- Debug Message
542: iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: Start');
587: iex_score_pvt.WriteLog('iexpscrb:UpdateScoreComp: End');
588:
589:
590: -- Standard call to get message count and if count is 1, get message info.
591: FND_MSG_PUB.Count_And_Get
592: ( p_count => x_msg_count,
593: p_data => x_msg_data );
594:
595: EXCEPTION
595: EXCEPTION
596: WHEN FND_API.G_EXC_ERROR THEN
597: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
598: x_return_status := FND_API.G_RET_STS_ERROR ;
599: FND_MSG_PUB.Count_And_Get
600: ( p_count => x_msg_count,
601: p_data => x_msg_data
602: );
603:
603:
604: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
605: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
606: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
607: FND_MSG_PUB.Count_And_Get
608: ( p_count => x_msg_count,
609: p_data => x_msg_data
610: );
611:
611:
612: WHEN OTHERS THEN
613: ROLLBACK TO UPDATE_SCORE_COMP_PUB;
614: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
615: FND_MSG_PUB.Count_And_Get
616: ( p_count => x_msg_count,
617: p_data => x_msg_data
618: );
619:
654:
655: -- Initialize message list if p_init_msg_list is set to TRUE.
656: IF FND_API.to_Boolean( p_init_msg_list )
657: THEN
658: FND_MSG_PUB.initialize;
659: END IF;
660:
661: -- Debug Message
662: iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: Start');
705:
706: -- Debug Message
707: iex_score_pvt.WriteLog('iexpscrb:DeleteScoreComp: End');
708:
709: FND_MSG_PUB.Count_And_Get
710: ( p_count => x_msg_count,
711: p_data => x_msg_data );
712:
713: EXCEPTION
713: EXCEPTION
714: WHEN FND_API.G_EXC_ERROR THEN
715: ROLLBACK TO DELETE_SCORE_COMP_PUB;
716: x_return_status := FND_API.G_RET_STS_ERROR ;
717: FND_MSG_PUB.Count_And_Get
718: ( p_count => x_msg_count,
719: p_data => x_msg_data
720: );
721:
721:
722: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
723: ROLLBACK TO DELETE_SCORE_COMP_PUB;
724: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count,
727: p_data => x_msg_data
728: );
729:
729:
730: WHEN OTHERS THEN
731: ROLLBACK TO DELETE_SCORE_COMP_PUB;
732: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
733: FND_MSG_PUB.Count_And_Get
734: ( p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737:
774:
775: -- Initialize message list if p_init_msg_list is set to TRUE.
776: IF FND_API.to_Boolean( p_init_msg_list )
777: THEN
778: FND_MSG_PUB.initialize;
779: END IF;
780:
781: -- Debug Message
782: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompType: Start');
823: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompType: End');
824:
825:
826: -- Standard call to get message count and if count is 1, get message info.
827: FND_MSG_PUB.Count_And_Get
828: ( p_count => x_msg_count,
829: p_data => x_msg_data
830: );
831:
832: EXCEPTION
833: WHEN FND_API.G_EXC_ERROR THEN
834: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
835: x_return_status := FND_API.G_RET_STS_ERROR ;
836: FND_MSG_PUB.Count_And_Get
837: ( p_count => x_msg_count,
838: p_data => x_msg_data
839: );
840:
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
844: FND_MSG_PUB.Count_And_Get
845: ( p_count => x_msg_count,
846: p_data => x_msg_data
847: );
848:
848:
849: WHEN OTHERS THEN
850: ROLLBACK TO CREATE_SCORE_COMP_TYPE_PUB;
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: FND_MSG_PUB.Count_And_Get
853: ( p_count => x_msg_count,
854: p_data => x_msg_data
855: );
856:
893:
894: -- Initialize message list if p_init_msg_list is set to TRUE.
895: IF FND_API.to_Boolean( p_init_msg_list )
896: THEN
897: FND_MSG_PUB.initialize;
898: END IF;
899:
900: -- Debug Message
901: iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');
946: iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: End');
947:
948:
949: -- Standard call to get message count and if count is 1, get message info.
950: FND_MSG_PUB.Count_And_Get
951: ( p_count => x_msg_count,
952: p_data => x_msg_data );
953:
954: EXCEPTION
954: EXCEPTION
955: WHEN FND_API.G_EXC_ERROR THEN
956: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
957: x_return_status := FND_API.G_RET_STS_ERROR ;
958: FND_MSG_PUB.Count_And_Get
959: ( p_count => x_msg_count,
960: p_data => x_msg_data
961: );
962:
962:
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
966: FND_MSG_PUB.Count_And_Get
967: ( p_count => x_msg_count,
968: p_data => x_msg_data
969: );
970:
970:
971: WHEN OTHERS THEN
972: ROLLBACK To UPDATE_Score_Comp_TYPE_PUB;
973: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
974: FND_MSG_PUB.Count_And_Get
975: ( p_count => x_msg_count,
976: p_data => x_msg_data
977: );
978:
1014:
1015: -- Initialize message list if p_init_msg_list is set to TRUE.
1016: IF FND_API.to_Boolean( p_init_msg_list )
1017: THEN
1018: FND_MSG_PUB.initialize;
1019: END IF;
1020:
1021: -- Debug Message
1022: iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: Start');
1066:
1067: -- Debug Message
1068: iex_score_pvt.WriteLog('iexpscrb:UpdateScrCompType: End');
1069:
1070: FND_MSG_PUB.Count_And_Get
1071: ( p_count => x_msg_count,
1072: p_data => x_msg_data );
1073:
1074: EXCEPTION
1074: EXCEPTION
1075: WHEN FND_API.G_EXC_ERROR THEN
1076: ROLLBACK To DELETE_Score_Comp_TYPE_PUB;
1077: x_return_status := FND_API.G_RET_STS_ERROR ;
1078: FND_MSG_PUB.Count_And_Get
1079: ( p_count => x_msg_count,
1080: p_data => x_msg_data
1081: );
1082:
1082:
1083: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1084: ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;
1085: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1086: FND_MSG_PUB.Count_And_Get
1087: ( p_count => x_msg_count,
1088: p_data => x_msg_data
1089: );
1090:
1090:
1091: WHEN OTHERS THEN
1092: ROLLBACK TO DELETE_SCORE_COMP_TYPE_PUB;
1093: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1094: FND_MSG_PUB.Count_And_Get
1095: ( p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );
1098:
1137:
1138: -- Initialize message list if p_init_msg_list is set to TRUE.
1139: IF FND_API.to_Boolean( p_init_msg_list )
1140: THEN
1141: FND_MSG_PUB.initialize;
1142: END IF;
1143:
1144: -- Debug Message
1145: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompDet: Start');
1198: iex_score_pvt.WriteLog('iexpscrb:CreateScrCompDet: End');
1199:
1200:
1201: -- Standard call to get message count and if count is 1, get message info.
1202: FND_MSG_PUB.Count_And_Get
1203: ( p_count => x_msg_count,
1204: p_data => x_msg_data
1205: );
1206:
1207: EXCEPTION
1208: WHEN FND_API.G_EXC_ERROR THEN
1209: ROLLBACK To DELETE_Score_Comp_DET_PUB;
1210: x_return_status := FND_API.G_RET_STS_ERROR ;
1211: FND_MSG_PUB.Count_And_Get
1212: ( p_count => x_msg_count,
1213: p_data => x_msg_data
1214: );
1215:
1215:
1216: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1217: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1218: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1219: FND_MSG_PUB.Count_And_Get
1220: ( p_count => x_msg_count,
1221: p_data => x_msg_data
1222: );
1223:
1223:
1224: WHEN OTHERS THEN
1225: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1226: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1227: FND_MSG_PUB.Count_And_Get
1228: ( p_count => x_msg_count,
1229: p_data => x_msg_data
1230: );
1231:
1266:
1267: -- Initialize message list if p_init_msg_list is set to TRUE.
1268: IF FND_API.to_Boolean( p_init_msg_list )
1269: THEN
1270: FND_MSG_PUB.initialize;
1271: END IF;
1272:
1273: -- Debug Message
1274: iex_score_pvt.WriteLog('iexpscrb:UpdScrCompDet: Start');
1317: iex_score_pvt.WriteLog('iexpscrb:UpdScrCompDet: End');
1318:
1319:
1320: -- Standard call to get message count and if count is 1, get message info.
1321: FND_MSG_PUB.Count_And_Get
1322: ( p_count => x_msg_count,
1323: p_data => x_msg_data );
1324:
1325: EXCEPTION
1325: EXCEPTION
1326: WHEN FND_API.G_EXC_ERROR THEN
1327: ROLLBACK To UPDATE_Score_Comp_DET_PUB;
1328: x_return_status := FND_API.G_RET_STS_ERROR ;
1329: FND_MSG_PUB.Count_And_Get
1330: ( p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );
1333:
1333:
1334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1335: ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;
1336: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1337: FND_MSG_PUB.Count_And_Get
1338: ( p_count => x_msg_count,
1339: p_data => x_msg_data
1340: );
1341:
1341:
1342: WHEN OTHERS THEN
1343: ROLLBACK TO UPDATE_SCORE_COMP_DET_PUB;
1344: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1345: FND_MSG_PUB.Count_And_Get
1346: ( p_count => x_msg_count,
1347: p_data => x_msg_data
1348: );
1349:
1384:
1385: -- Initialize message list if p_init_msg_list is set to TRUE.
1386: IF FND_API.to_Boolean( p_init_msg_list )
1387: THEN
1388: FND_MSG_PUB.initialize;
1389: END IF;
1390:
1391: -- Debug Message
1392: iex_score_pvt.WriteLog('iexpscrb:DelScrCompDet: Start');
1434:
1435: -- Debug Message
1436: iex_score_pvt.WriteLog('iexpscrb:DelScrCompDet: End');
1437:
1438: FND_MSG_PUB.Count_And_Get
1439: ( p_count => x_msg_count,
1440: p_data => x_msg_data );
1441:
1442: EXCEPTION
1442: EXCEPTION
1443: WHEN FND_API.G_EXC_ERROR THEN
1444: ROLLBACK To DELETE_Score_Comp_DET_PUB;
1445: x_return_status := FND_API.G_RET_STS_ERROR ;
1446: FND_MSG_PUB.Count_And_Get
1447: ( p_count => x_msg_count,
1448: p_data => x_msg_data
1449: );
1450:
1450:
1451: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1452: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1454: FND_MSG_PUB.Count_And_Get
1455: ( p_count => x_msg_count,
1456: p_data => x_msg_data
1457: );
1458:
1458:
1459: WHEN OTHERS THEN
1460: ROLLBACK TO DELETE_SCORE_COMP_DET_PUB;
1461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1462: FND_MSG_PUB.Count_And_Get
1463: ( p_count => x_msg_count,
1464: p_data => x_msg_data
1465: );
1466:
1504:
1505: -- Initialize message list if p_init_msg_list is set to TRUE.
1506: IF FND_API.to_Boolean( p_init_msg_list )
1507: THEN
1508: FND_MSG_PUB.initialize;
1509: END IF;
1510:
1511: -- Initialize API return status to SUCCESS
1512: x_return_status := FND_API.G_RET_STS_SUCCESS;
1558: IEX_SCORE_PVT.WriteLog(l_msg ||'score_id='||x_score_id);
1559:
1560: -- Debug Message
1561:
1562: FND_MSG_PUB.Count_And_Get
1563: ( p_count => x_msg_count,
1564: p_data => x_msg_data );
1565:
1566: EXCEPTION
1566: EXCEPTION
1567: WHEN FND_API.G_EXC_ERROR THEN
1568: ROLLBACK To COPY_SCORINGENGINE_PUB;
1569: x_return_status := FND_API.G_RET_STS_ERROR ;
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_count => x_msg_count,
1572: p_data => x_msg_data
1573: );
1574:
1574:
1575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1576: ROLLBACK TO COPY_SCORINGENGINE_PUB;
1577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1578: FND_MSG_PUB.Count_And_Get
1579: ( p_count => x_msg_count,
1580: p_data => x_msg_data
1581: );
1582: WHEN OTHERS THEN
1581: );
1582: WHEN OTHERS THEN
1583: ROLLBACK TO COPY_SCORINGENGINE_PUB;
1584: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1585: FND_MSG_PUB.Count_And_Get
1586: ( p_count => x_msg_count,
1587: p_data => x_msg_data
1588: );
1589:
1621:
1622: -- Initialize message list if p_init_msg_list is set to TRUE.
1623: IF FND_API.to_Boolean( p_init_msg_list )
1624: THEN
1625: FND_MSG_PUB.initialize;
1626: END IF;
1627:
1628: -- Debug Message
1629:
1659: END IF;
1660:
1661: -- Debug Message
1662:
1663: FND_MSG_PUB.Count_And_Get
1664: ( p_count => x_msg_count,
1665: p_data => x_msg_data );
1666:
1667: EXCEPTION
1667: EXCEPTION
1668: WHEN FND_API.G_EXC_ERROR THEN
1669: ROLLBACK To GET_SCORE_PUB;
1670: x_return_status := FND_API.G_RET_STS_ERROR ;
1671: FND_MSG_PUB.Count_And_Get
1672: ( p_count => x_msg_count,
1673: p_data => x_msg_data
1674: );
1675:
1675:
1676: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1677: ROLLBACK To GET_SCORE_PUB;
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1679: FND_MSG_PUB.Count_And_Get
1680: ( p_count => x_msg_count,
1681: p_data => x_msg_data
1682: );
1683: WHEN OTHERS THEN
1682: );
1683: WHEN OTHERS THEN
1684: ROLLBACK To GET_SCORE_PUB;
1685: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1686: FND_MSG_PUB.Count_And_Get
1687: ( p_count => x_msg_count,
1688: p_data => x_msg_data
1689: );
1690: