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.BSC_ANALYSIS_OPTION_PUB dependencies on FND_MSG_PUB

Line 73: FND_MSG_PUB.Initialize;

69: FROM BSC_KPIS_B
70: WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
71: AND Prototype_Flag <> 2;
72: begin
73: FND_MSG_PUB.Initialize;
74: x_return_status := FND_API.G_RET_STS_SUCCESS;
75: -- Assign all values in the passed "Record" parameter to the locally defined
76: -- "Record" variable.
77: l_Anal_Opt_Rec := p_Anal_Opt_Rec;

Line 144: FND_MSG_PUB.ADD;

140:
141: if l_share_flag = 2 then
142: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
143: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
144: FND_MSG_PUB.ADD;
145: RAISE FND_API.G_EXC_ERROR;
146: end if;
147:
148: -- Select the number of the last analysis option plus 1 more for the given KPI

Line 218: FND_MSG_PUB.Count_And_Get

214: END LOOP;
215: EXCEPTION
216: WHEN FND_API.G_EXC_ERROR THEN
217: IF (x_msg_data IS NULL) THEN
218: FND_MSG_PUB.Count_And_Get
219: ( p_encoded => FND_API.G_FALSE
220: , p_count => x_msg_count
221: , p_data => x_msg_data
222: );

Line 228: FND_MSG_PUB.Count_And_Get

224: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
225: x_return_status := FND_API.G_RET_STS_ERROR;
226: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
227: IF (x_msg_data IS NULL) THEN
228: FND_MSG_PUB.Count_And_Get
229: ( p_encoded => FND_API.G_FALSE
230: , p_count => x_msg_count
231: , p_data => x_msg_data
232: );

Line 284: FND_MSG_PUB.Count_And_Get

280: END IF;
281: EXCEPTION
282: WHEN FND_API.G_EXC_ERROR THEN
283: IF (x_msg_data IS NULL) THEN
284: FND_MSG_PUB.Count_And_Get
285: ( p_encoded => FND_API.G_FALSE
286: , p_count => x_msg_count
287: , p_data => x_msg_data
288: );

Line 294: FND_MSG_PUB.Count_And_Get

290: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
291: x_return_status := FND_API.G_RET_STS_ERROR;
292: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
293: IF (x_msg_data IS NULL) THEN
294: FND_MSG_PUB.Count_And_Get
295: ( p_encoded => FND_API.G_FALSE
296: , p_count => x_msg_count
297: , p_data => x_msg_data
298: );

Line 354: FND_MSG_PUB.Count_And_Get

350: END IF;
351: EXCEPTION
352: WHEN FND_API.G_EXC_ERROR THEN
353: IF (x_msg_data IS NULL) THEN
354: FND_MSG_PUB.Count_And_Get
355: ( p_encoded => FND_API.G_FALSE
356: , p_count => x_msg_count
357: , p_data => x_msg_data
358: );

Line 364: FND_MSG_PUB.Count_And_Get

360: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
361: x_return_status := FND_API.G_RET_STS_ERROR;
362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
363: IF (x_msg_data IS NULL) THEN
364: FND_MSG_PUB.Count_And_Get
365: ( p_encoded => FND_API.G_FALSE
366: , p_count => x_msg_count
367: , p_data => x_msg_data
368: );

Line 451: FND_MSG_PUB.Count_And_Get

447: END LOOP;
448: EXCEPTION
449: WHEN FND_API.G_EXC_ERROR THEN
450: IF (x_msg_data IS NULL) THEN
451: FND_MSG_PUB.Count_And_Get
452: ( p_encoded => FND_API.G_FALSE
453: , p_count => x_msg_count
454: , p_data => x_msg_data
455: );

Line 461: FND_MSG_PUB.Count_And_Get

457: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
458: x_return_status := FND_API.G_RET_STS_ERROR;
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: IF (x_msg_data IS NULL) THEN
461: FND_MSG_PUB.Count_And_Get
462: ( p_encoded => FND_API.G_FALSE
463: , p_count => x_msg_count
464: , p_data => x_msg_data
465: );

Line 516: FND_MSG_PUB.Count_And_Get

512: END IF;
513: EXCEPTION
514: WHEN FND_API.G_EXC_ERROR THEN
515: IF (x_msg_data IS NULL) THEN
516: FND_MSG_PUB.Count_And_Get
517: ( p_encoded => FND_API.G_FALSE
518: , p_count => x_msg_count
519: , p_data => x_msg_data
520: );

Line 526: FND_MSG_PUB.Count_And_Get

522: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
523: x_return_status := FND_API.G_RET_STS_ERROR;
524: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
525: IF (x_msg_data IS NULL) THEN
526: FND_MSG_PUB.Count_And_Get
527: ( p_encoded => FND_API.G_FALSE
528: , p_count => x_msg_count
529: , p_data => x_msg_data
530: );

Line 575: FND_MSG_PUB.Count_And_Get

571:
572: EXCEPTION
573: WHEN FND_API.G_EXC_ERROR THEN
574: IF (x_msg_data IS NULL) THEN
575: FND_MSG_PUB.Count_And_Get
576: ( p_encoded => FND_API.G_FALSE
577: , p_count => x_msg_count
578: , p_data => x_msg_data
579: );

Line 585: FND_MSG_PUB.Count_And_Get

581: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
582: x_return_status := FND_API.G_RET_STS_ERROR;
583: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
584: IF (x_msg_data IS NULL) THEN
585: FND_MSG_PUB.Count_And_Get
586: ( p_encoded => FND_API.G_FALSE
587: , p_count => x_msg_count
588: , p_data => x_msg_data
589: );

Line 710: FND_MSG_PUB.Count_And_Get

706: EXCEPTION
707: WHEN FND_API.G_EXC_ERROR THEN
708: ROLLBACK TO Create_Analysis_Measures_PUB;
709: IF (x_msg_data IS NULL) THEN
710: FND_MSG_PUB.Count_And_Get
711: ( p_encoded => FND_API.G_FALSE
712: , p_count => x_msg_count
713: , p_data => x_msg_data
714: );

Line 721: FND_MSG_PUB.Count_And_Get

717: x_return_status := FND_API.G_RET_STS_ERROR;
718: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
719: ROLLBACK TO Create_Analysis_Measures_PUB;
720: IF (x_msg_data IS NULL) THEN
721: FND_MSG_PUB.Count_And_Get
722: ( p_encoded => FND_API.G_FALSE
723: , p_count => x_msg_count
724: , p_data => x_msg_data
725: );

Line 773: FND_MSG_PUB.Count_And_Get

769:
770: EXCEPTION
771: WHEN FND_API.G_EXC_ERROR THEN
772: IF (x_msg_data IS NULL) THEN
773: FND_MSG_PUB.Count_And_Get
774: ( p_encoded => FND_API.G_FALSE
775: , p_count => x_msg_count
776: , p_data => x_msg_data
777: );

Line 783: FND_MSG_PUB.Count_And_Get

779: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
780: x_return_status := FND_API.G_RET_STS_ERROR;
781: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
782: IF (x_msg_data IS NULL) THEN
783: FND_MSG_PUB.Count_And_Get
784: ( p_encoded => FND_API.G_FALSE
785: , p_count => x_msg_count
786: , p_data => x_msg_data
787: );

Line 854: FND_MSG_PUB.Count_And_Get

850: ,x_msg_data);
851: EXCEPTION
852: WHEN FND_API.G_EXC_ERROR THEN
853: IF (x_msg_data IS NULL) THEN
854: FND_MSG_PUB.Count_And_Get
855: ( p_encoded => FND_API.G_FALSE
856: , p_count => x_msg_count
857: , p_data => x_msg_data
858: );

Line 864: FND_MSG_PUB.Count_And_Get

860: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
861: x_return_status := FND_API.G_RET_STS_ERROR;
862: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
863: IF (x_msg_data IS NULL) THEN
864: FND_MSG_PUB.Count_And_Get
865: ( p_encoded => FND_API.G_FALSE
866: , p_count => x_msg_count
867: , p_data => x_msg_data
868: );

Line 1021: FND_MSG_PUB.Count_And_Get

1017:
1018: EXCEPTION
1019: WHEN FND_API.G_EXC_ERROR THEN
1020: IF (x_msg_data IS NULL) THEN
1021: FND_MSG_PUB.Count_And_Get
1022: ( p_encoded => FND_API.G_FALSE
1023: , p_count => x_msg_count
1024: , p_data => x_msg_data
1025: );

Line 1031: FND_MSG_PUB.Count_And_Get

1027: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1028: x_return_status := FND_API.G_RET_STS_ERROR;
1029: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1030: IF (x_msg_data IS NULL) THEN
1031: FND_MSG_PUB.Count_And_Get
1032: ( p_encoded => FND_API.G_FALSE
1033: , p_count => x_msg_count
1034: , p_data => x_msg_data
1035: );

Line 1086: FND_MSG_PUB.Count_And_Get

1082: );
1083: EXCEPTION
1084: WHEN FND_API.G_EXC_ERROR THEN
1085: IF (x_msg_data IS NULL) THEN
1086: FND_MSG_PUB.Count_And_Get
1087: ( p_encoded => FND_API.G_FALSE
1088: , p_count => x_msg_count
1089: , p_data => x_msg_data
1090: );

Line 1096: FND_MSG_PUB.Count_And_Get

1092: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1093: x_return_status := FND_API.G_RET_STS_ERROR;
1094: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1095: IF (x_msg_data IS NULL) THEN
1096: FND_MSG_PUB.Count_And_Get
1097: ( p_encoded => FND_API.G_FALSE
1098: , p_count => x_msg_count
1099: , p_data => x_msg_data
1100: );

Line 1148: FND_MSG_PUB.Count_And_Get

1144:
1145: EXCEPTION
1146: WHEN FND_API.G_EXC_ERROR THEN
1147: IF (x_msg_data IS NULL) THEN
1148: FND_MSG_PUB.Count_And_Get
1149: ( p_encoded => FND_API.G_FALSE
1150: , p_count => x_msg_count
1151: , p_data => x_msg_data
1152: );

Line 1158: FND_MSG_PUB.Count_And_Get

1154: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1155: x_return_status := FND_API.G_RET_STS_ERROR;
1156: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1157: IF (x_msg_data IS NULL) THEN
1158: FND_MSG_PUB.Count_And_Get
1159: ( p_encoded => FND_API.G_FALSE
1160: , p_count => x_msg_count
1161: , p_data => x_msg_data
1162: );

Line 1231: FND_MSG_PUB.Initialize;

1227: AND DS.ANALYSIS_OPTION2 = p_option2
1228: AND DS.SERIES_ID = p_series_id
1229: AND OBJ.INDICATOR = DS.INDICATOR;
1230: BEGIN
1231: FND_MSG_PUB.Initialize;
1232: x_return_status := FND_API.G_RET_STS_SUCCESS;
1233:
1234: -- adrao modified cursor and introduced new call to is_Objective_Report_Type, which is appropriate.
1235: -- Bug#4357962

Line 1246: FND_MSG_PUB.ADD;

1242: IF (l_Kpi_Short_Name IS NOT NULL) THEN
1243: IF (BSC_BIS_CUSTOM_KPI_UTIL_PUB.is_Objective_Report_Type(l_Kpi_Short_Name) = FND_API.G_TRUE) THEN
1244: FND_MESSAGE.SET_NAME('BSC','BSC_D_DELETE_RPT_KPI_OBJ');
1245: FND_MESSAGE.SET_TOKEN('OBJECTIVE', l_Kpi_Name);
1246: FND_MSG_PUB.ADD;
1247: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1248: END IF;
1249: END IF;
1250: END LOOP;

Line 1265: FND_MSG_PUB.Count_And_Get

1261: );
1262: EXCEPTION
1263: WHEN FND_API.G_EXC_ERROR THEN
1264: IF (x_msg_data IS NULL) THEN
1265: FND_MSG_PUB.Count_And_Get
1266: ( p_encoded => FND_API.G_FALSE
1267: , p_count => x_msg_count
1268: , p_data => x_msg_data
1269: );

Line 1275: FND_MSG_PUB.Count_And_Get

1271: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1272: x_return_status := FND_API.G_RET_STS_ERROR;
1273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1274: IF (x_msg_data IS NULL) THEN
1275: FND_MSG_PUB.Count_And_Get
1276: ( p_encoded => FND_API.G_FALSE
1277: , p_count => x_msg_count
1278: , p_data => x_msg_data
1279: );

Line 1311: FND_MSG_PUB.Initialize;

1307: , x_msg_data OUT NOCOPY VARCHAR2
1308: ) IS
1309: BEGIN
1310: x_return_status := FND_API.G_RET_STS_SUCCESS;
1311: FND_MSG_PUB.Initialize;
1312:
1313: BSC_ANALYSIS_OPTION_PVT.delete_extra_series(
1314: p_Bsc_Anal_Opt_Rec => p_Bsc_Anal_Opt_Rec
1315: , x_return_status => x_return_status

Line 1327: FND_MSG_PUB.Count_And_Get

1323:
1324: EXCEPTION
1325: WHEN FND_API.G_EXC_ERROR THEN
1326: IF (x_msg_data IS NULL) THEN
1327: FND_MSG_PUB.Count_And_Get
1328: ( p_encoded => FND_API.G_FALSE
1329: , p_count => x_msg_count
1330: , p_data => x_msg_data
1331: );

Line 1337: FND_MSG_PUB.Count_And_Get

1333: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: IF (x_msg_data IS NULL) THEN
1337: FND_MSG_PUB.Count_And_Get
1338: ( p_encoded => FND_API.G_FALSE
1339: , p_count => x_msg_count
1340: , p_data => x_msg_data
1341: );

Line 1407: FND_MSG_PUB.Initialize;

1403: ORDER BY SERIES_ID DESC;
1404:
1405:
1406: begin
1407: FND_MSG_PUB.Initialize;
1408: x_return_status := FND_API.G_RET_STS_SUCCESS;
1409: -- Assign all values in the passed "Record" parameter to the locally defined
1410: -- "Record" variable.
1411: l_Anal_Opt_Rec := p_Anal_Opt_Rec;

Line 1422: FND_MSG_PUB.ADD;

1418: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1419: if l_count = 0 then
1420: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1421: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1422: FND_MSG_PUB.ADD;
1423: RAISE FND_API.G_EXC_ERROR;
1424: end if;
1425: else
1426: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1428: FND_MSG_PUB.ADD;

1424: end if;
1425: else
1426: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1427: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1428: FND_MSG_PUB.ADD;
1429: RAISE FND_API.G_EXC_ERROR;
1430: end if;
1431:
1432: -- Verify that this is not a Shared KPI.

Line 1441: FND_MSG_PUB.ADD;

1437:
1438: if l_share_flag = 2 then
1439: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1440: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1441: FND_MSG_PUB.ADD;
1442: RAISE FND_API.G_EXC_ERROR;
1443: end if;
1444:
1445: -- Set Default values for Anaysis options parameter

Line 1606: FND_MSG_PUB.Count_And_Get

1602: IF (c_Series_color%ISOPEN) THEN
1603: CLOSE c_Series_color;
1604: END IF;
1605: IF (x_msg_data IS NULL) THEN
1606: FND_MSG_PUB.Count_And_Get
1607: ( p_encoded => FND_API.G_FALSE
1608: , p_count => x_msg_count
1609: , p_data => x_msg_data
1610: );

Line 1619: FND_MSG_PUB.Count_And_Get

1615: IF (c_Series_color%ISOPEN) THEN
1616: CLOSE c_Series_color;
1617: END IF;
1618: IF (x_msg_data IS NULL) THEN
1619: FND_MSG_PUB.Count_And_Get
1620: ( p_encoded => FND_API.G_FALSE
1621: , p_count => x_msg_count
1622: , p_data => x_msg_data
1623: );

Line 1682: FND_MSG_PUB.ADD;

1678: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1679: if l_count = 0 then
1680: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1681: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1682: FND_MSG_PUB.ADD;
1683: RAISE FND_API.G_EXC_ERROR;
1684: end if;
1685: else
1686: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1688: FND_MSG_PUB.ADD;

1684: end if;
1685: else
1686: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1687: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1688: FND_MSG_PUB.ADD;
1689: RAISE FND_API.G_EXC_ERROR;
1690: end if;
1691:
1692: -- Verify that this is not a Shared KPI.

Line 1701: FND_MSG_PUB.ADD;

1697:
1698: if l_share_flag = 2 then
1699: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1700: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1701: FND_MSG_PUB.ADD;
1702: RAISE FND_API.G_EXC_ERROR;
1703: end if;
1704:
1705: -- Set Default vaues for Anaysis options parameter

Line 1749: FND_MSG_PUB.Count_And_Get

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

Line 1759: FND_MSG_PUB.Count_And_Get

1755: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1756: x_return_status := FND_API.G_RET_STS_ERROR;
1757: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1758: IF (x_msg_data IS NULL) THEN
1759: FND_MSG_PUB.Count_And_Get
1760: ( p_encoded => FND_API.G_FALSE
1761: , p_count => x_msg_count
1762: , p_data => x_msg_data
1763: );

Line 1808: FND_MSG_PUB.Initialize;

1804: AND Prototype_Flag <> 2;
1805:
1806:
1807: BEGIN
1808: FND_MSG_PUB.Initialize;
1809: SAVEPOINT DeleteBSCDataSeriesPUB;
1810: x_return_status := FND_API.G_RET_STS_SUCCESS;
1811: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
1812:

Line 1823: FND_MSG_PUB.ADD;

1819: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1820: if l_count = 0 then
1821: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1822: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1823: FND_MSG_PUB.ADD;
1824: RAISE FND_API.G_EXC_ERROR;
1825: end if;
1826: else
1827: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1829: FND_MSG_PUB.ADD;

1825: end if;
1826: else
1827: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1828: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1829: FND_MSG_PUB.ADD;
1830: RAISE FND_API.G_EXC_ERROR;
1831: end if;
1832:
1833: -- Verify that this is not a Shared KPI.

Line 1842: FND_MSG_PUB.ADD;

1838:
1839: if l_share_flag = 2 then
1840: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1841: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1842: FND_MSG_PUB.ADD;
1843: RAISE FND_API.G_EXC_ERROR;
1844: end if;
1845:
1846: -- Set Default vaues for Anaysis options parameter

Line 1958: FND_MSG_PUB.Count_And_Get

1954:
1955: EXCEPTION
1956: WHEN FND_API.G_EXC_ERROR THEN
1957: ROLLBACK TO DeleteBSCDataSeriesPUB;
1958: FND_MSG_PUB.Count_And_Get
1959: ( p_encoded => FND_API.G_FALSE
1960: , p_count => x_msg_count
1961: , p_data => x_msg_data
1962: );

Line 1968: FND_MSG_PUB.Count_And_Get

1964: x_return_status := FND_API.G_RET_STS_ERROR;
1965: RAISE;
1966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1967: ROLLBACK TO DeleteBSCDataSeriesPUB;
1968: FND_MSG_PUB.Count_And_Get
1969: ( p_encoded => FND_API.G_FALSE
1970: , p_count => x_msg_count
1971: , p_data => x_msg_data
1972: );

Line 2042: FND_MSG_PUB.Initialize;

2038: WHERE Source_Indicator = l_Anal_Opt_Rec.Bsc_Kpi_Id
2039: AND Prototype_Flag <> 2;
2040:
2041: BEGIN
2042: FND_MSG_PUB.Initialize;
2043: SAVEPOINT SwapDataSeriesPUB;
2044:
2045: x_return_status := FND_API.G_RET_STS_SUCCESS;
2046:

Line 2078: FND_MSG_PUB.Count_And_Get

2074: IF (c_kpi_ids%ISOPEN) THEN
2075: CLOSE c_kpi_ids;
2076: END IF;
2077: ROLLBACK TO SwapDataSeriesPUB;
2078: FND_MSG_PUB.Count_And_Get
2079: ( p_encoded => FND_API.G_FALSE
2080: , p_count => x_msg_count
2081: , p_data => x_msg_data
2082: );

Line 2091: FND_MSG_PUB.Count_And_Get

2087: IF (c_kpi_ids%ISOPEN) THEN
2088: CLOSE c_kpi_ids;
2089: END IF;
2090: ROLLBACK TO SwapDataSeriesPUB;
2091: FND_MSG_PUB.Count_And_Get
2092: ( p_encoded => FND_API.G_FALSE
2093: , p_count => x_msg_count
2094: , p_data => x_msg_data
2095: );

Line 2185: FND_MSG_PUB.Initialize;

2181: AND SERIES_ID >= l_count
2182: ORDER BY SERIES_ID DESC;
2183:
2184: BEGIN
2185: FND_MSG_PUB.Initialize;
2186: SAVEPOINT Rearrange_Data_SeriesVT;
2187:
2188: l_Anal_Opt_Rec.Bsc_Option_Group0 := 0;
2189: l_Anal_Opt_Rec.Bsc_Option_Group1 := 0;

Line 2250: FND_MSG_PUB.ADD;

2246: END IF;
2247: ELSE
2248: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_MEAS_ID');
2249: FND_MESSAGE.SET_TOKEN('BSC_MEAS', l_short_name);
2250: FND_MSG_PUB.ADD;
2251: RAISE FND_API.G_EXC_ERROR;
2252: END IF;
2253:
2254: END LOOP;

Line 2278: FND_MSG_PUB.Count_And_Get

2274: IF (c_Data_Series%ISOPEN) THEN
2275: CLOSE c_Data_Series;
2276: END IF;
2277: ROLLBACK TO SwapDataSeriesPVT;
2278: FND_MSG_PUB.Count_And_Get
2279: ( p_encoded => FND_API.G_FALSE
2280: , p_count => x_msg_count
2281: , p_data => x_msg_data
2282: );

Line 2291: FND_MSG_PUB.Count_And_Get

2287: IF (c_Data_Series%ISOPEN) THEN
2288: CLOSE c_Data_Series;
2289: END IF;
2290: ROLLBACK TO RearrangeDataSeriesPVT;
2291: FND_MSG_PUB.Count_And_Get
2292: ( p_encoded => FND_API.G_FALSE
2293: , p_count => x_msg_count
2294: , p_data => x_msg_data
2295: );

Line 2502: FND_MSG_PUB.Count_And_Get

2498:
2499:
2500: EXCEPTION
2501: WHEN FND_API.G_EXC_ERROR 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 2511: FND_MSG_PUB.Count_And_Get

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