DBA Data[Home] [Help]

APPS.BIS_WEIGHTED_MEASURE_PUB dependencies on FND_MSG_PUB

Line 98: FND_MSG_PUB.Count_And_Get

94: EXCEPTION
95: WHEN FND_API.G_EXC_ERROR THEN
96: ROLLBACK TO BisDeleteBulkWeightsScores;
97: IF (x_msg_data IS NULL) THEN
98: FND_MSG_PUB.Count_And_Get
99: ( p_encoded => FND_API.G_FALSE
100: , p_count => x_msg_count
101: , p_data => x_msg_data
102: );

Line 109: FND_MSG_PUB.Count_And_Get

105: raise;
106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
107: ROLLBACK TO BisDeleteBulkWeightsScores;
108: IF (x_msg_data IS NULL) THEN
109: FND_MSG_PUB.Count_And_Get
110: ( p_encoded => FND_API.G_FALSE
111: , p_count => x_msg_count
112: , p_data => x_msg_data
113: );

Line 203: FND_MSG_PUB.Count_And_Get

199: EXCEPTION
200: WHEN FND_API.G_EXC_ERROR THEN
201: ROLLBACK TO BisDeleteCascadeWMParameters;
202: IF (x_msg_data IS NULL) THEN
203: FND_MSG_PUB.Count_And_Get
204: ( p_encoded => FND_API.G_FALSE
205: , p_count => x_msg_count
206: , p_data => x_msg_data
207: );

Line 215: FND_MSG_PUB.Count_And_Get

211: raise;
212: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
213: ROLLBACK TO BisDeleteCascadeWMParameters;
214: IF (x_msg_data IS NULL) THEN
215: FND_MSG_PUB.Count_And_Get
216: ( p_encoded => FND_API.G_FALSE
217: , p_count => x_msg_count
218: , p_data => x_msg_data
219: );

Line 288: FND_MSG_PUB.ADD;

284: --weighted_measure_id
285: IF BIS_WEIGHTED_MEASURE_PVT.validate_measure_id(p_Bis_WM_Rec.weighted_measure_id) = FND_API.G_FALSE THEN
286: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_W_MEASURE_ID');
287: FND_MESSAGE.SET_TOKEN('MEASURE', p_Bis_WM_Rec.weighted_measure_id);
288: FND_MSG_PUB.ADD;
289: RAISE FND_API.G_EXC_ERROR;
290: end if;
291: --dependent_measure_id
292: IF BIS_WEIGHTED_MEASURE_PVT.validate_measure_id(p_Bis_WM_Rec.dependent_measure_id) = FND_API.G_FALSE THEN

Line 295: FND_MSG_PUB.ADD;

291: --dependent_measure_id
292: IF BIS_WEIGHTED_MEASURE_PVT.validate_measure_id(p_Bis_WM_Rec.dependent_measure_id) = FND_API.G_FALSE THEN
293: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_D_MEASURE_ID');
294: FND_MESSAGE.SET_TOKEN('MEASURE', p_Bis_WM_Rec.weighted_measure_id);
295: FND_MSG_PUB.ADD;
296: RAISE FND_API.G_EXC_ERROR;
297: end if;
298:
299: -- WHO COLUMNS

Line 323: FND_MSG_PUB.Count_And_Get

319: EXCEPTION
320: WHEN FND_API.G_EXC_ERROR THEN
321: ROLLBACK TO CreateWMDependencyPUB;
322: IF (x_msg_data IS NULL) THEN
323: FND_MSG_PUB.Count_And_Get
324: ( p_encoded => FND_API.G_FALSE
325: , p_count => x_msg_count
326: , p_data => x_msg_data
327: );

Line 335: FND_MSG_PUB.Count_And_Get

331: raise;
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: ROLLBACK TO CreateWMDependencyPUB;
334: IF (x_msg_data IS NULL) THEN
335: FND_MSG_PUB.Count_And_Get
336: ( p_encoded => FND_API.G_FALSE
337: , p_count => x_msg_count
338: , p_data => x_msg_data
339: );

Line 385: FND_MSG_PUB.Count_And_Get

381: EXCEPTION
382: WHEN FND_API.G_EXC_ERROR THEN
383: ROLLBACK TO Retrieve_WM_Dependency_pub;
384: IF (x_msg_data IS NULL) THEN
385: FND_MSG_PUB.Count_And_Get
386: ( p_encoded => FND_API.G_FALSE
387: , p_count => x_msg_count
388: , p_data => x_msg_data
389: );

Line 397: FND_MSG_PUB.Count_And_Get

393: raise;
394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
395: ROLLBACK TO Retrieve_WM_Dependency_pub;
396: IF (x_msg_data IS NULL) THEN
397: FND_MSG_PUB.Count_And_Get
398: ( p_encoded => FND_API.G_FALSE
399: , p_count => x_msg_count
400: , p_data => x_msg_data
401: );

Line 462: FND_MSG_PUB.Count_And_Get

458: EXCEPTION
459: WHEN FND_API.G_EXC_ERROR THEN
460: ROLLBACK TO bis_Update_WM_Dependency_pub;
461: IF (x_msg_data IS NULL) THEN
462: FND_MSG_PUB.Count_And_Get
463: ( p_encoded => FND_API.G_FALSE
464: , p_count => x_msg_count
465: , p_data => x_msg_data
466: );

Line 474: FND_MSG_PUB.Count_And_Get

470: raise;
471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
472: ROLLBACK TO bis_Update_WM_Dependency_pub;
473: IF (x_msg_data IS NULL) THEN
474: FND_MSG_PUB.Count_And_Get
475: ( p_encoded => FND_API.G_FALSE
476: , p_count => x_msg_count
477: , p_data => x_msg_data
478: );

Line 534: FND_MSG_PUB.ADD;

530: CLOSE c_measure_name;
531:
532: FND_MESSAGE.SET_NAME('BIS','BIS_REMOVE_VALID_WKPI');
533: FND_MESSAGE.SET_TOKEN('MEASURE_NAME', l_measure_name);
534: FND_MSG_PUB.ADD;
535: RAISE FND_API.G_EXC_ERROR;
536: END IF;
537:
538: -- Delete the Dependent Measure

Line 556: FND_MSG_PUB.Count_And_Get

552: END IF;
553:
554: ROLLBACK TO Delete_WM_Dependency_pub;
555: IF (x_msg_data IS NULL) THEN
556: FND_MSG_PUB.Count_And_Get
557: ( p_encoded => FND_API.G_FALSE
558: , p_count => x_msg_count
559: , p_data => x_msg_data
560: );

Line 572: FND_MSG_PUB.Count_And_Get

568: END IF;
569:
570: ROLLBACK TO Delete_WM_Dependency_pub;
571: IF (x_msg_data IS NULL) THEN
572: FND_MSG_PUB.Count_And_Get
573: ( p_encoded => FND_API.G_FALSE
574: , p_count => x_msg_count
575: , p_data => x_msg_data
576: );

Line 620: FND_MSG_PUB.ADD;

616: -- l_Bis_WM_Rec.weighted_measure_id
617: IF BIS_WEIGHTED_MEASURE_PVT.validate_measure_id(p_Bis_WM_Rec.weighted_measure_id) = FND_API.G_FALSE THEN
618: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_W_MEASURE_ID');
619: FND_MESSAGE.SET_TOKEN('MEASURE', p_Bis_WM_Rec.weighted_measure_id);
620: FND_MSG_PUB.ADD;
621: RAISE FND_API.G_EXC_ERROR;
622: end if;
623:
624: -- l_Bis_WM_Rec.VIEWBY_dimension_SN

Line 676: FND_MSG_PUB.Count_And_Get

672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: ROLLBACK TO CreateWMDefinitionPUB;
675: IF (x_msg_data IS NULL) THEN
676: FND_MSG_PUB.Count_And_Get
677: ( p_encoded => FND_API.G_FALSE
678: , p_count => x_msg_count
679: , p_data => x_msg_data
680: );

Line 688: FND_MSG_PUB.Count_And_Get

684: raise;
685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
686: ROLLBACK TO CreateWMDefinitionPUB;
687: IF (x_msg_data IS NULL) THEN
688: FND_MSG_PUB.Count_And_Get
689: ( p_encoded => FND_API.G_FALSE
690: , p_count => x_msg_count
691: , p_data => x_msg_data
692: );

Line 737: FND_MSG_PUB.Count_And_Get

733: EXCEPTION
734: WHEN FND_API.G_EXC_ERROR THEN
735: ROLLBACK TO Retrieve_WM_Definition_pub;
736: IF (x_msg_data IS NULL) THEN
737: FND_MSG_PUB.Count_And_Get
738: ( p_encoded => FND_API.G_FALSE
739: , p_count => x_msg_count
740: , p_data => x_msg_data
741: );

Line 749: FND_MSG_PUB.Count_And_Get

745: raise;
746: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
747: ROLLBACK TO Retrieve_WM_Definition_pub;
748: IF (x_msg_data IS NULL) THEN
749: FND_MSG_PUB.Count_And_Get
750: ( p_encoded => FND_API.G_FALSE
751: , p_count => x_msg_count
752: , p_data => x_msg_data
753: );

Line 792: FND_MSG_PUB.ADD;

788: -- l_Bis_WM_Rec.weighted_measure_id
789: IF BIS_WEIGHTED_MEASURE_PVT.validate_measure_id(p_Bis_WM_Rec.weighted_measure_id) = FND_API.G_FALSE THEN
790: FND_MESSAGE.SET_NAME('BIS','BIS_INVALIDE_WEIGHTED_MEASURE');
791: FND_MESSAGE.SET_TOKEN('MEASURE_ID', p_Bis_WM_Rec.weighted_measure_id);
792: FND_MSG_PUB.ADD;
793: RAISE FND_API.G_EXC_ERROR;
794: end if;
795:
796: BIS_WEIGHTED_MEASURE_PUB.Retrieve_WM_Definition(

Line 886: FND_MSG_PUB.Count_And_Get

882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: ROLLBACK TO bis_Update_WM_Definition_pub;
885: IF (x_msg_data IS NULL) THEN
886: FND_MSG_PUB.Count_And_Get
887: ( p_encoded => FND_API.G_FALSE
888: , p_count => x_msg_count
889: , p_data => x_msg_data
890: );

Line 898: FND_MSG_PUB.Count_And_Get

894: raise;
895: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
896: ROLLBACK TO bis_Update_WM_Definition_pub;
897: IF (x_msg_data IS NULL) THEN
898: FND_MSG_PUB.Count_And_Get
899: ( p_encoded => FND_API.G_FALSE
900: , p_count => x_msg_count
901: , p_data => x_msg_data
902: );

Line 958: FND_MSG_PUB.Count_And_Get

954: EXCEPTION
955: WHEN FND_API.G_EXC_ERROR THEN
956: ROLLBACK TO Delete_WM_Definition_pub;
957: IF (x_msg_data IS NULL) THEN
958: FND_MSG_PUB.Count_And_Get
959: ( p_encoded => FND_API.G_FALSE
960: , p_count => x_msg_count
961: , p_data => x_msg_data
962: );

Line 970: FND_MSG_PUB.Count_And_Get

966: raise;
967: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
968: ROLLBACK TO Delete_WM_Definition_pub;
969: IF (x_msg_data IS NULL) THEN
970: FND_MSG_PUB.Count_And_Get
971: ( p_encoded => FND_API.G_FALSE
972: , p_count => x_msg_count
973: , p_data => x_msg_data
974: );

Line 1022: FND_MSG_PUB.ADD;

1018: WHERE WEIGHTED_DEFINITION_ID = p_Bis_WM_Rec.weighted_definition_id;
1019: IF l_count = 0 THEN
1020: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_DEF');
1021: FND_MESSAGE.SET_TOKEN('DEF', p_Bis_WM_Rec.weighted_measure_id);
1022: FND_MSG_PUB.ADD;
1023: RAISE FND_API.G_EXC_ERROR;
1024: END IF;
1025:
1026: -- Set the weighted_parameter_id

Line 1055: FND_MSG_PUB.Count_And_Get

1051: EXCEPTION
1052: WHEN FND_API.G_EXC_ERROR THEN
1053: ROLLBACK TO CreateWMParameterPUB;
1054: IF (x_msg_data IS NULL) THEN
1055: FND_MSG_PUB.Count_And_Get
1056: ( p_encoded => FND_API.G_FALSE
1057: , p_count => x_msg_count
1058: , p_data => x_msg_data
1059: );

Line 1067: FND_MSG_PUB.Count_And_Get

1063: raise;
1064: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1065: ROLLBACK TO CreateWMParameterPUB;
1066: IF (x_msg_data IS NULL) THEN
1067: FND_MSG_PUB.Count_And_Get
1068: ( p_encoded => FND_API.G_FALSE
1069: , p_count => x_msg_count
1070: , p_data => x_msg_data
1071: );

Line 1115: FND_MSG_PUB.Count_And_Get

1111: EXCEPTION
1112: WHEN FND_API.G_EXC_ERROR THEN
1113: ROLLBACK TO Retrieve_WM_Parameter_pub;
1114: IF (x_msg_data IS NULL) THEN
1115: FND_MSG_PUB.Count_And_Get
1116: ( p_encoded => FND_API.G_FALSE
1117: , p_count => x_msg_count
1118: , p_data => x_msg_data
1119: );

Line 1127: FND_MSG_PUB.Count_And_Get

1123: raise;
1124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1125: ROLLBACK TO Retrieve_WM_Parameter_pub;
1126: IF (x_msg_data IS NULL) THEN
1127: FND_MSG_PUB.Count_And_Get
1128: ( p_encoded => FND_API.G_FALSE
1129: , p_count => x_msg_count
1130: , p_data => x_msg_data
1131: );

Line 1196: FND_MSG_PUB.Count_And_Get

1192: EXCEPTION
1193: WHEN FND_API.G_EXC_ERROR THEN
1194: ROLLBACK TO bis_Update_WM_Parameter_pub;
1195: IF (x_msg_data IS NULL) THEN
1196: FND_MSG_PUB.Count_And_Get
1197: ( p_encoded => FND_API.G_FALSE
1198: , p_count => x_msg_count
1199: , p_data => x_msg_data
1200: );

Line 1208: FND_MSG_PUB.Count_And_Get

1204: raise;
1205: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1206: ROLLBACK TO bis_Update_WM_Parameter_pub;
1207: IF (x_msg_data IS NULL) THEN
1208: FND_MSG_PUB.Count_And_Get
1209: ( p_encoded => FND_API.G_FALSE
1210: , p_count => x_msg_count
1211: , p_data => x_msg_data
1212: );

Line 1278: FND_MSG_PUB.Count_And_Get

1274: EXCEPTION
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: ROLLBACK TO Delete_WM_Parameter_pub;
1277: IF (x_msg_data IS NULL) THEN
1278: FND_MSG_PUB.Count_And_Get
1279: ( p_encoded => FND_API.G_FALSE
1280: , p_count => x_msg_count
1281: , p_data => x_msg_data
1282: );

Line 1290: FND_MSG_PUB.Count_And_Get

1286: raise;
1287: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1288: ROLLBACK TO Delete_WM_Parameter_pub;
1289: IF (x_msg_data IS NULL) THEN
1290: FND_MSG_PUB.Count_And_Get
1291: ( p_encoded => FND_API.G_FALSE
1292: , p_count => x_msg_count
1293: , p_data => x_msg_data
1294: );

Line 1343: FND_MSG_PUB.ADD;

1339: WHERE WEIGHTED_PARAMETER_ID = p_Bis_WM_Rec.weighted_parameter_id;
1340: IF l_count = 0 THEN
1341: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_PARAM');
1342: FND_MESSAGE.SET_TOKEN('PARAM', p_Bis_WM_Rec.weighted_parameter_id);
1343: FND_MSG_PUB.ADD;
1344: RAISE FND_API.G_EXC_ERROR;
1345: END IF;
1346:
1347:

Line 1378: FND_MSG_PUB.Count_And_Get

1374: EXCEPTION
1375: WHEN FND_API.G_EXC_ERROR THEN
1376: ROLLBACK TO Create_WM_Weight_PUB;
1377: IF (x_msg_data IS NULL) THEN
1378: FND_MSG_PUB.Count_And_Get
1379: ( p_encoded => FND_API.G_FALSE
1380: , p_count => x_msg_count
1381: , p_data => x_msg_data
1382: );

Line 1390: FND_MSG_PUB.Count_And_Get

1386: raise;
1387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1388: ROLLBACK TO Create_WM_Weight_PUB;
1389: IF (x_msg_data IS NULL) THEN
1390: FND_MSG_PUB.Count_And_Get
1391: ( p_encoded => FND_API.G_FALSE
1392: , p_count => x_msg_count
1393: , p_data => x_msg_data
1394: );

Line 1438: FND_MSG_PUB.Count_And_Get

1434: EXCEPTION
1435: WHEN FND_API.G_EXC_ERROR THEN
1436: ROLLBACK TO bis_Retrieve_WM_Weight_pub;
1437: IF (x_msg_data IS NULL) THEN
1438: FND_MSG_PUB.Count_And_Get
1439: ( p_encoded => FND_API.G_FALSE
1440: , p_count => x_msg_count
1441: , p_data => x_msg_data
1442: );

Line 1450: FND_MSG_PUB.Count_And_Get

1446: raise;
1447: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1448: ROLLBACK TO bis_Retrieve_WM_Weight_pub;
1449: IF (x_msg_data IS NULL) THEN
1450: FND_MSG_PUB.Count_And_Get
1451: ( p_encoded => FND_API.G_FALSE
1452: , p_count => x_msg_count
1453: , p_data => x_msg_data
1454: );

Line 1526: FND_MSG_PUB.Count_And_Get

1522: EXCEPTION
1523: WHEN FND_API.G_EXC_ERROR THEN
1524: ROLLBACK TO bis_Update_WM_Weight_pub;
1525: IF (x_msg_data IS NULL) THEN
1526: FND_MSG_PUB.Count_And_Get
1527: ( p_encoded => FND_API.G_FALSE
1528: , p_count => x_msg_count
1529: , p_data => x_msg_data
1530: );

Line 1538: FND_MSG_PUB.Count_And_Get

1534: raise;
1535: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1536: ROLLBACK TO bis_Update_WM_Weight_pub;
1537: IF (x_msg_data IS NULL) THEN
1538: FND_MSG_PUB.Count_And_Get
1539: ( p_encoded => FND_API.G_FALSE
1540: , p_count => x_msg_count
1541: , p_data => x_msg_data
1542: );

Line 1603: FND_MSG_PUB.Count_And_Get

1599: EXCEPTION
1600: WHEN FND_API.G_EXC_ERROR THEN
1601: ROLLBACK TO Delete_WM_Weight_pub;
1602: IF (x_msg_data IS NULL) THEN
1603: FND_MSG_PUB.Count_And_Get
1604: ( p_encoded => FND_API.G_FALSE
1605: , p_count => x_msg_count
1606: , p_data => x_msg_data
1607: );

Line 1615: FND_MSG_PUB.Count_And_Get

1611: raise;
1612: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1613: ROLLBACK TO Delete_WM_Weight_pub;
1614: IF (x_msg_data IS NULL) THEN
1615: FND_MSG_PUB.Count_And_Get
1616: ( p_encoded => FND_API.G_FALSE
1617: , p_count => x_msg_count
1618: , p_data => x_msg_data
1619: );

Line 1661: FND_MSG_PUB.ADD;

1657: WHERE WEIGHT_ID = p_Bis_WM_Rec.weight_id;
1658: IF l_count = 0 THEN
1659: FND_MESSAGE.SET_NAME('BIS','BIS_WM_INVALIDE_WEIGHT_ID');
1660: FND_MESSAGE.SET_TOKEN('WEIGHT_ID', p_Bis_WM_Rec.weight_id);
1661: FND_MSG_PUB.ADD;
1662: RAISE FND_API.G_EXC_ERROR;
1663: END IF;
1664:
1665: -- WHO COLUMNS

Line 1688: FND_MSG_PUB.Count_And_Get

1684: EXCEPTION
1685: WHEN FND_API.G_EXC_ERROR THEN
1686: ROLLBACK TO Create_WM_Score_PUB;
1687: IF (x_msg_data IS NULL) THEN
1688: FND_MSG_PUB.Count_And_Get
1689: ( p_encoded => FND_API.G_FALSE
1690: , p_count => x_msg_count
1691: , p_data => x_msg_data
1692: );

Line 1700: FND_MSG_PUB.Count_And_Get

1696: raise;
1697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1698: ROLLBACK TO Create_WM_Score_PUB;
1699: IF (x_msg_data IS NULL) THEN
1700: FND_MSG_PUB.Count_And_Get
1701: ( p_encoded => FND_API.G_FALSE
1702: , p_count => x_msg_count
1703: , p_data => x_msg_data
1704: );

Line 1748: FND_MSG_PUB.Count_And_Get

1744: EXCEPTION
1745: WHEN FND_API.G_EXC_ERROR THEN
1746: ROLLBACK TO bis_Retrieve_WM_Score_pub;
1747: IF (x_msg_data IS NULL) THEN
1748: FND_MSG_PUB.Count_And_Get
1749: ( p_encoded => FND_API.G_FALSE
1750: , p_count => x_msg_count
1751: , p_data => x_msg_data
1752: );

Line 1760: FND_MSG_PUB.Count_And_Get

1756: raise;
1757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1758: ROLLBACK TO bis_Retrieve_WM_Score_pub;
1759: IF (x_msg_data IS NULL) THEN
1760: FND_MSG_PUB.Count_And_Get
1761: ( p_encoded => FND_API.G_FALSE
1762: , p_count => x_msg_count
1763: , p_data => x_msg_data
1764: );

Line 1835: FND_MSG_PUB.Count_And_Get

1831: EXCEPTION
1832: WHEN FND_API.G_EXC_ERROR THEN
1833: ROLLBACK TO bis_Update_WM_Score_pub;
1834: IF (x_msg_data IS NULL) THEN
1835: FND_MSG_PUB.Count_And_Get
1836: ( p_encoded => FND_API.G_FALSE
1837: , p_count => x_msg_count
1838: , p_data => x_msg_data
1839: );

Line 1847: FND_MSG_PUB.Count_And_Get

1843: raise;
1844: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1845: ROLLBACK TO bis_Update_WM_Score_pub;
1846: IF (x_msg_data IS NULL) THEN
1847: FND_MSG_PUB.Count_And_Get
1848: ( p_encoded => FND_API.G_FALSE
1849: , p_count => x_msg_count
1850: , p_data => x_msg_data
1851: );

Line 1895: FND_MSG_PUB.Count_And_Get

1891: EXCEPTION
1892: WHEN FND_API.G_EXC_ERROR THEN
1893: ROLLBACK TO Delete_WM_Score_pub;
1894: IF (x_msg_data IS NULL) THEN
1895: FND_MSG_PUB.Count_And_Get
1896: ( p_encoded => FND_API.G_FALSE
1897: , p_count => x_msg_count
1898: , p_data => x_msg_data
1899: );

Line 1907: FND_MSG_PUB.Count_And_Get

1903: raise;
1904: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1905: ROLLBACK TO Delete_WM_Score_pub;
1906: IF (x_msg_data IS NULL) THEN
1907: FND_MSG_PUB.Count_And_Get
1908: ( p_encoded => FND_API.G_FALSE
1909: , p_count => x_msg_count
1910: , p_data => x_msg_data
1911: );

Line 1978: FND_MSG_PUB.Count_And_Get

1974:
1975: EXCEPTION
1976: WHEN FND_API.G_EXC_ERROR THEN
1977: IF (x_msg_data IS NULL) THEN
1978: FND_MSG_PUB.Count_And_Get
1979: ( p_encoded => FND_API.G_FALSE
1980: , p_count => x_msg_count
1981: , p_data => x_msg_data
1982: );

Line 1988: FND_MSG_PUB.Count_And_Get

1984: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1985: x_return_status := FND_API.G_RET_STS_ERROR;
1986: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1987: IF (x_msg_data IS NULL) THEN
1988: FND_MSG_PUB.Count_And_Get
1989: ( p_encoded => FND_API.G_FALSE
1990: , p_count => x_msg_count
1991: , p_data => x_msg_data
1992: );

Line 2047: FND_MSG_PUB.Count_And_Get

2043:
2044: EXCEPTION
2045: WHEN FND_API.G_EXC_ERROR THEN
2046: IF (x_msg_data IS NULL) THEN
2047: FND_MSG_PUB.Count_And_Get
2048: ( p_encoded => FND_API.G_FALSE
2049: , p_count => x_msg_count
2050: , p_data => x_msg_data
2051: );

Line 2057: FND_MSG_PUB.Count_And_Get

2053: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2054: x_return_status := FND_API.G_RET_STS_ERROR;
2055: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2056: IF (x_msg_data IS NULL) THEN
2057: FND_MSG_PUB.Count_And_Get
2058: ( p_encoded => FND_API.G_FALSE
2059: , p_count => x_msg_count
2060: , p_data => x_msg_data
2061: );

Line 2121: FND_MSG_PUB.Count_And_Get

2117: EXCEPTION
2118: WHEN FND_API.G_EXC_ERROR THEN
2119: ROLLBACK TO bis_Update_WM_Definition_pub;
2120: IF (x_msg_data IS NULL) THEN
2121: FND_MSG_PUB.Count_And_Get
2122: ( p_encoded => FND_API.G_FALSE
2123: , p_count => x_msg_count
2124: , p_data => x_msg_data
2125: );

Line 2133: FND_MSG_PUB.Count_And_Get

2129: raise;
2130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2131: ROLLBACK TO bis_Update_WM_Definition_pub;
2132: IF (x_msg_data IS NULL) THEN
2133: FND_MSG_PUB.Count_And_Get
2134: ( p_encoded => FND_API.G_FALSE
2135: , p_count => x_msg_count
2136: , p_data => x_msg_data
2137: );

Line 2184: FND_MSG_PUB.Count_And_Get

2180:
2181: EXCEPTION
2182: WHEN FND_API.G_EXC_ERROR THEN
2183: IF (x_msg_data IS NULL) THEN
2184: FND_MSG_PUB.Count_And_Get
2185: ( p_encoded => FND_API.G_FALSE
2186: , p_count => x_msg_count
2187: , p_data => x_msg_data
2188: );

Line 2194: FND_MSG_PUB.Count_And_Get

2190: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2191: x_return_status := FND_API.G_RET_STS_ERROR;
2192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2193: IF (x_msg_data IS NULL) THEN
2194: FND_MSG_PUB.Count_And_Get
2195: ( p_encoded => FND_API.G_FALSE
2196: , p_count => x_msg_count
2197: , p_data => x_msg_data
2198: );

Line 2245: FND_MSG_PUB.Count_And_Get

2241:
2242: EXCEPTION
2243: WHEN FND_API.G_EXC_ERROR THEN
2244: IF (x_msg_data IS NULL) THEN
2245: FND_MSG_PUB.Count_And_Get
2246: ( p_encoded => FND_API.G_FALSE
2247: , p_count => x_msg_count
2248: , p_data => x_msg_data
2249: );

Line 2255: FND_MSG_PUB.Count_And_Get

2251: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2252: x_return_status := FND_API.G_RET_STS_ERROR;
2253: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2254: IF (x_msg_data IS NULL) THEN
2255: FND_MSG_PUB.Count_And_Get
2256: ( p_encoded => FND_API.G_FALSE
2257: , p_count => x_msg_count
2258: , p_data => x_msg_data
2259: );

Line 2306: FND_MSG_PUB.Count_And_Get

2302:
2303: EXCEPTION
2304: WHEN FND_API.G_EXC_ERROR THEN
2305: IF (x_msg_data IS NULL) THEN
2306: FND_MSG_PUB.Count_And_Get
2307: ( p_encoded => FND_API.G_FALSE
2308: , p_count => x_msg_count
2309: , p_data => x_msg_data
2310: );

Line 2316: FND_MSG_PUB.Count_And_Get

2312: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2313: x_return_status := FND_API.G_RET_STS_ERROR;
2314: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2315: IF (x_msg_data IS NULL) THEN
2316: FND_MSG_PUB.Count_And_Get
2317: ( p_encoded => FND_API.G_FALSE
2318: , p_count => x_msg_count
2319: , p_data => x_msg_data
2320: );

Line 2370: FND_MSG_PUB.Count_And_Get

2366:
2367: EXCEPTION
2368: WHEN FND_API.G_EXC_ERROR THEN
2369: IF (x_msg_data IS NULL) THEN
2370: FND_MSG_PUB.Count_And_Get
2371: ( p_encoded => FND_API.G_FALSE
2372: , p_count => x_msg_count
2373: , p_data => x_msg_data
2374: );

Line 2380: FND_MSG_PUB.Count_And_Get

2376: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2377: x_return_status := FND_API.G_RET_STS_ERROR;
2378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2379: IF (x_msg_data IS NULL) THEN
2380: FND_MSG_PUB.Count_And_Get
2381: ( p_encoded => FND_API.G_FALSE
2382: , p_count => x_msg_count
2383: , p_data => x_msg_data
2384: );

Line 2430: FND_MSG_PUB.Count_And_Get

2426: EXCEPTION
2427: WHEN FND_API.G_EXC_ERROR THEN
2428: ROLLBACK TO Delete_WM_Parameter_pub;
2429: IF (x_msg_data IS NULL) THEN
2430: FND_MSG_PUB.Count_And_Get
2431: ( p_encoded => FND_API.G_FALSE
2432: , p_count => x_msg_count
2433: , p_data => x_msg_data
2434: );

Line 2442: FND_MSG_PUB.Count_And_Get

2438: raise;
2439: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2440: ROLLBACK TO Delete_WM_Parameter_pub;
2441: IF (x_msg_data IS NULL) THEN
2442: FND_MSG_PUB.Count_And_Get
2443: ( p_encoded => FND_API.G_FALSE
2444: , p_count => x_msg_count
2445: , p_data => x_msg_data
2446: );

Line 2502: FND_MSG_PUB.Count_And_Get

2498:
2499: EXCEPTION
2500: WHEN FND_API.G_EXC_ERROR THEN
2501: IF (x_msg_data IS NULL) THEN
2502: FND_MSG_PUB.Count_And_Get
2503: ( p_encoded => FND_API.G_FALSE
2504: , p_count => x_msg_count
2505: , p_data => x_msg_data
2506: );

Line 2512: FND_MSG_PUB.Count_And_Get

2508: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2509: x_return_status := FND_API.G_RET_STS_ERROR;
2510: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2511: IF (x_msg_data IS NULL) THEN
2512: FND_MSG_PUB.Count_And_Get
2513: ( p_encoded => FND_API.G_FALSE
2514: , p_count => x_msg_count
2515: , p_data => x_msg_data
2516: );

Line 2561: FND_MSG_PUB.Count_And_Get

2557: EXCEPTION
2558: WHEN FND_API.G_EXC_ERROR THEN
2559: ROLLBACK TO bis_Update_WM_Weight_pub;
2560: IF (x_msg_data IS NULL) THEN
2561: FND_MSG_PUB.Count_And_Get
2562: ( p_encoded => FND_API.G_FALSE
2563: , p_count => x_msg_count
2564: , p_data => x_msg_data
2565: );

Line 2573: FND_MSG_PUB.Count_And_Get

2569: raise;
2570: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2571: ROLLBACK TO bis_Update_WM_Weight_pub;
2572: IF (x_msg_data IS NULL) THEN
2573: FND_MSG_PUB.Count_And_Get
2574: ( p_encoded => FND_API.G_FALSE
2575: , p_count => x_msg_count
2576: , p_data => x_msg_data
2577: );

Line 2623: FND_MSG_PUB.Count_And_Get

2619:
2620: EXCEPTION
2621: WHEN FND_API.G_EXC_ERROR THEN
2622: IF (x_msg_data IS NULL) THEN
2623: FND_MSG_PUB.Count_And_Get
2624: ( p_encoded => FND_API.G_FALSE
2625: , p_count => x_msg_count
2626: , p_data => x_msg_data
2627: );

Line 2633: FND_MSG_PUB.Count_And_Get

2629: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2630: x_return_status := FND_API.G_RET_STS_ERROR;
2631: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2632: IF (x_msg_data IS NULL) THEN
2633: FND_MSG_PUB.Count_And_Get
2634: ( p_encoded => FND_API.G_FALSE
2635: , p_count => x_msg_count
2636: , p_data => x_msg_data
2637: );

Line 2684: FND_MSG_PUB.Count_And_Get

2680:
2681: EXCEPTION
2682: WHEN FND_API.G_EXC_ERROR THEN
2683: IF (x_msg_data IS NULL) THEN
2684: FND_MSG_PUB.Count_And_Get
2685: ( p_encoded => FND_API.G_FALSE
2686: , p_count => x_msg_count
2687: , p_data => x_msg_data
2688: );

Line 2694: FND_MSG_PUB.Count_And_Get

2690: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2691: x_return_status := FND_API.G_RET_STS_ERROR;
2692: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2693: IF (x_msg_data IS NULL) THEN
2694: FND_MSG_PUB.Count_And_Get
2695: ( p_encoded => FND_API.G_FALSE
2696: , p_count => x_msg_count
2697: , p_data => x_msg_data
2698: );

Line 2740: FND_MSG_PUB.Count_And_Get

2736:
2737: EXCEPTION
2738: WHEN FND_API.G_EXC_ERROR THEN
2739: IF (x_msg_data IS NULL) THEN
2740: FND_MSG_PUB.Count_And_Get
2741: ( p_encoded => FND_API.G_FALSE
2742: , p_count => x_msg_count
2743: , p_data => x_msg_data
2744: );

Line 2750: FND_MSG_PUB.Count_And_Get

2746: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2747: x_return_status := FND_API.G_RET_STS_ERROR;
2748: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2749: IF (x_msg_data IS NULL) THEN
2750: FND_MSG_PUB.Count_And_Get
2751: ( p_encoded => FND_API.G_FALSE
2752: , p_count => x_msg_count
2753: , p_data => x_msg_data
2754: );

Line 2954: FND_MSG_PUB.Count_And_Get

2950: EXCEPTION
2951: WHEN FND_API.G_EXC_ERROR THEN
2952: ROLLBACK TO Delete_WM_Definition_pub;
2953: IF (x_msg_data IS NULL) THEN
2954: FND_MSG_PUB.Count_And_Get
2955: ( p_encoded => FND_API.G_FALSE
2956: , p_count => x_msg_count
2957: , p_data => x_msg_data
2958: );

Line 2966: FND_MSG_PUB.Count_And_Get

2962: -- raise;
2963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2964: ROLLBACK TO Delete_WM_Definition_pub;
2965: IF (x_msg_data IS NULL) THEN
2966: FND_MSG_PUB.Count_And_Get
2967: ( p_encoded => FND_API.G_FALSE
2968: , p_count => x_msg_count
2969: , p_data => x_msg_data
2970: );

Line 3114: FND_MSG_PUB.Count_And_Get

3110: EXCEPTION
3111: WHEN FND_API.G_EXC_ERROR THEN
3112: ROLLBACK TO BisCreateWeightedMeasure;
3113: IF (x_msg_data IS NULL) THEN
3114: FND_MSG_PUB.Count_And_Get
3115: ( p_encoded => FND_API.G_FALSE
3116: , p_count => x_msg_count
3117: , p_data => x_msg_data
3118: );

Line 3126: FND_MSG_PUB.Count_And_Get

3122: -- raise;
3123: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3124: ROLLBACK TO BisCreateWeightedMeasure;
3125: IF (x_msg_data IS NULL) THEN
3126: FND_MSG_PUB.Count_And_Get
3127: ( p_encoded => FND_API.G_FALSE
3128: , p_count => x_msg_count
3129: , p_data => x_msg_data
3130: );

Line 3195: FND_MSG_PUB.ADD;

3191: IF l_count = 0 THEN
3192: FND_MESSAGE.SET_NAME('BIS','BIS_WM_DEP_MEASURE_NO_FOUND');
3193: FND_MESSAGE.SET_TOKEN('DEP_MEASURE',p_dependent_measure_id);
3194: FND_MESSAGE.SET_TOKEN('MEASURE',p_weighted_measure_id);
3195: FND_MSG_PUB.ADD;
3196: RAISE FND_API.G_EXC_ERROR;
3197: END IF;
3198:
3199: l_User_Id := FND_GLOBAL.user_id;

Line 3309: FND_MSG_PUB.Count_And_Get

3305: EXCEPTION
3306: WHEN FND_API.G_EXC_ERROR THEN
3307: ROLLBACK TO BisSetWeightDataPUB1;
3308: IF (x_msg_data IS NULL) THEN
3309: FND_MSG_PUB.Count_And_Get
3310: ( p_encoded => FND_API.G_FALSE
3311: , p_count => x_msg_count
3312: , p_data => x_msg_data
3313: );

Line 3321: FND_MSG_PUB.Count_And_Get

3317: -- raise;
3318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3319: ROLLBACK TO BisSetWeightDataPUB1;
3320: IF (x_msg_data IS NULL) THEN
3321: FND_MSG_PUB.Count_And_Get
3322: ( p_encoded => FND_API.G_FALSE
3323: , p_count => x_msg_count
3324: , p_data => x_msg_data
3325: );

Line 3357: fnd_msg_pub.initialize;

3353: l_measure_id NUMBER;
3354:
3355: begin
3356:
3357: fnd_msg_pub.initialize;
3358:
3359: FOR i in 1..p_depend_measure_short_names.COUNT LOOP
3360:
3361: l_measure_rec.measure_short_name := p_depend_measure_short_names(i);

Line 3386: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

3382:
3383: EXCEPTION
3384: WHEN FND_API.G_EXC_ERROR THEN
3385: x_return_status := FND_API.G_RET_STS_ERROR;
3386: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3387: ,p_data => x_msg_data);
3388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3390: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 3390: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

3386: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3387: ,p_data => x_msg_data);
3388: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3389: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3390: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3391: ,p_data => x_msg_data);
3392: WHEN NO_DATA_FOUND THEN
3393: x_return_status := FND_API.G_RET_STS_ERROR;
3394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 3394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

3390: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3391: ,p_data => x_msg_data);
3392: WHEN NO_DATA_FOUND THEN
3393: x_return_status := FND_API.G_RET_STS_ERROR;
3394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3395: ,p_data => x_msg_data);
3396: WHEN OTHERS THEN
3397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3398: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

Line 3398: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count

3394: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3395: ,p_data => x_msg_data);
3396: WHEN OTHERS THEN
3397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3398: FND_MSG_PUB.Count_And_Get( p_encoded => 'F' ,p_count => x_msg_count
3399: ,p_data => x_msg_data);
3400: if (x_msg_data is null) then
3401: x_msg_data := SQLERRM;
3402: end if;

Line 3464: FND_MSG_PUB.Count_And_Get

3460: EXCEPTION
3461: WHEN FND_API.G_EXC_ERROR THEN
3462: ROLLBACK TO Update_WM_LU_Info_pub;
3463: IF (x_msg_data IS NULL) THEN
3464: FND_MSG_PUB.Count_And_Get
3465: ( p_encoded => FND_API.G_FALSE
3466: , p_count => x_msg_count
3467: , p_data => x_msg_data
3468: );

Line 3476: FND_MSG_PUB.Count_And_Get

3472: raise;
3473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3474: ROLLBACK TO Update_WM_LU_Info_pub;
3475: IF (x_msg_data IS NULL) THEN
3476: FND_MSG_PUB.Count_And_Get
3477: ( p_encoded => FND_API.G_FALSE
3478: , p_count => x_msg_count
3479: , p_data => x_msg_data
3480: );

Line 3884: FND_MSG_PUB.Count_And_Get

3880: EXCEPTION
3881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3882: ROLLBACK TO BisSave_Mass_Update_Values_Pub;
3883: IF (x_msg_data IS NULL) THEN
3884: FND_MSG_PUB.Count_And_Get
3885: ( p_encoded => FND_API.G_FALSE
3886: , p_count => x_msg_count
3887: , p_data => x_msg_data
3888: );