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_SIMULATION_VIEW_PUB dependencies on FND_MSG_PUB

Line 248: FND_MSG_PUB.INITIALIZE;

244: l_str VARCHAR2(100);
245: BEGIN
246:
247: SAVEPOINT CreateSimTreebg;
248: FND_MSG_PUB.INITIALIZE;
249: x_return_status := FND_API.G_RET_STS_SUCCESS;
250:
251: SELECT BSC_SYS_IMAGE_ID_S.NEXTVAL
252: INTO l_next_image_id

Line 330: FND_MSG_PUB.INITIALIZE;

326: l_count NUMBER;
327: l_next_image_id BSC_SYS_IMAGES.image_id%TYPE;
328: BEGIN
329: SAVEPOINT AddOrUpdateSimTreeBg;
330: FND_MSG_PUB.INITIALIZE;
331: x_return_status := FND_API.G_RET_STS_SUCCESS;
332:
333:
334: SELECT COUNT(0)

Line 481: FND_MSG_PUB.INITIALIZE;

477: )IS
478: l_count NUMBER := 0;
479: BEGIN
480: --DBMS_OUTPUT.PUT_LINE('entering -->'||l_count);
481: FND_MSG_PUB.INITIALIZE;
482: x_return_status := FND_API.G_RET_STS_SUCCESS;
483: --DBMS_OUTPUT.PUT_LINE('entering 1 -->'||l_count);
484:
485: x_indicator := NULL;

Line 531: FND_MSG_PUB.Count_And_Get

527:
528: EXCEPTION
529: WHEN FND_API.G_EXC_ERROR THEN
530: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_ERROR -->');
531: FND_MSG_PUB.Count_And_Get
532: ( p_encoded => FND_API.G_FALSE
533: , p_count => x_msg_count
534: , p_data => x_msg_data
535: );

Line 540: FND_MSG_PUB.Count_And_Get

536: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
537: x_return_status := FND_API.G_RET_STS_ERROR;
538: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
539: --DBMS_OUTPUT.PUT_LINE('FND_API.G_EXC_UNEXPECTED_ERROR -->');
540: FND_MSG_PUB.Count_And_Get
541: ( p_encoded => FND_API.G_FALSE
542: , p_count => x_msg_count
543: , p_data => x_msg_data
544: );

Line 634: FND_MSG_PUB.INITIALIZE;

630: ) IS
631: l_count NUMBER;
632: l_dataset_id BSC_SYS_DATASETS_B.dataset_id%TYPE;
633: BEGIN
634: FND_MSG_PUB.INITIALIZE;
635: x_return_status := FND_API.G_RET_STS_SUCCESS;
636:
637: l_dataset_id := p_indicator_id;
638: IF(p_SimulateFlag=BSC_SIMULATION_VIEW_PUB.c_NON_SIM_NODE AND p_Node_Id =BSC_SIMULATION_VIEW_PUB.c_DEFAULT_SIM_NODE_ID)THEN

Line 822: FND_MSG_PUB.Count_And_Get

818: END IF;
819:
820: EXCEPTION
821: WHEN FND_API.G_EXC_ERROR THEN
822: FND_MSG_PUB.Count_And_Get
823: ( p_encoded => FND_API.G_FALSE
824: , p_count => x_msg_count
825: , p_data => x_msg_data
826: );

Line 830: FND_MSG_PUB.Count_And_Get

826: );
827: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
828: x_return_status := FND_API.G_RET_STS_ERROR;
829: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
830: FND_MSG_PUB.Count_And_Get
831: ( p_encoded => FND_API.G_FALSE
832: , p_count => x_msg_count
833: , p_data => x_msg_data
834: );

Line 885: fnd_msg_pub.initialize;

881: l_count NUMBER;
882:
883: BEGIN
884: SAVEPOINT addorupdatesimnodeprops;
885: fnd_msg_pub.initialize;
886: x_return_status := FND_API.G_RET_STS_SUCCESS;
887:
888: --Node id will be the same as the dataset id
889: --There cannot be two nodes whose dataset_ids are same.

Line 974: FND_MSG_PUB.Count_And_Get

970: END IF;
971: EXCEPTION
972: WHEN FND_API.G_EXC_ERROR THEN
973:
974: FND_MSG_PUB.Count_And_Get
975: ( p_encoded => FND_API.G_FALSE
976: , p_count => x_msg_count
977: , p_data => x_msg_data
978: );

Line 983: FND_MSG_PUB.Count_And_Get

979: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
980: x_return_status := FND_API.G_RET_STS_ERROR;
981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982:
983: FND_MSG_PUB.Count_And_Get
984: ( p_encoded => FND_API.G_FALSE
985: , p_count => x_msg_count
986: , p_data => x_msg_data
987: );

Line 1070: FND_MSG_PUB.INITIALIZE;

1066: --Before deleting label get the label type and check if it is labeltype is with --in the range of (10,11,12,14,13)
1067: -- if it is then get the link id for it and delete the corresponding entry from
1068: -- BSC_KPI_TREE_NODES_VL
1069: SAVEPOINT removesimviewitems;
1070: FND_MSG_PUB.INITIALIZE;
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072:
1073: l_labels := p_labels;
1074:

Line 1165: FND_MSG_PUB.Count_And_Get

1161:
1162: EXCEPTION
1163: WHEN FND_API.G_EXC_ERROR THEN
1164: ROLLBACK TO removesimviewitems;
1165: FND_MSG_PUB.Count_And_Get
1166: ( p_encoded => FND_API.G_FALSE
1167: , p_count => x_msg_count
1168: , p_data => x_msg_data
1169: );

Line 1174: FND_MSG_PUB.Count_And_Get

1170: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1171: x_return_status := FND_API.G_RET_STS_ERROR;
1172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1173: ROLLBACK TO removesimviewitems;
1174: FND_MSG_PUB.Count_And_Get
1175: ( p_encoded => FND_API.G_FALSE
1176: , p_count => x_msg_count
1177: , p_data => x_msg_data
1178: );

Line 1212: FND_MSG_PUB.INITIALIZE;

1208: ,x_msg_data OUT NOCOPY VARCHAR2
1209: )IS
1210: BEGIN
1211: SAVEPOINT Duplicatekpimetadata;
1212: FND_MSG_PUB.INITIALIZE;
1213: x_return_status := FND_API.G_RET_STS_SUCCESS;
1214:
1215: --We need to copy the source indicator data from the following tables
1216: --BSC_SYS_IMAGES

Line 1250: FND_MSG_PUB.Count_And_Get

1246:
1247: EXCEPTION
1248: WHEN FND_API.G_EXC_ERROR THEN
1249: ROLLBACK TO Duplicatekpimetadata;
1250: FND_MSG_PUB.Count_And_Get
1251: ( p_encoded => FND_API.G_FALSE
1252: , p_count => x_msg_count
1253: , p_data => x_msg_data
1254: );

Line 1259: FND_MSG_PUB.Count_And_Get

1255: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1256: x_return_status := FND_API.G_RET_STS_ERROR;
1257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1258: ROLLBACK TO Duplicatekpimetadata;
1259: FND_MSG_PUB.Count_And_Get
1260: ( p_encoded => FND_API.G_FALSE
1261: , p_count => x_msg_count
1262: , p_data => x_msg_data
1263: );

Line 1299: FND_MSG_PUB.INITIALIZE;

1295: )IS
1296: l_same_name NUMBER;
1297: BEGIN
1298:
1299: FND_MSG_PUB.INITIALIZE;
1300: x_return_status := FND_API.G_RET_STS_SUCCESS;
1301:
1302:
1303: SELECT COUNT(0)

Line 1314: FND_MSG_PUB.ADD;

1310: -- if there are kpis in this tab which have the same name it throws an error.
1311: IF l_same_name <> 0 then
1312: FND_MESSAGE.SET_NAME('BSC','BSC_B_NO_SAMEKPI_TAB');
1313: FND_MESSAGE.SET_TOKEN('Indicator name: ', p_name);
1314: FND_MSG_PUB.ADD;
1315: RAISE FND_API.G_EXC_ERROR;
1316: END IF;
1317:
1318:

Line 1322: FND_MSG_PUB.Count_And_Get

1318:
1319: EXCEPTION
1320: WHEN FND_API.G_EXC_ERROR THEN
1321:
1322: FND_MSG_PUB.Count_And_Get
1323: ( p_encoded => FND_API.G_FALSE
1324: , p_count => x_msg_count
1325: , p_data => x_msg_data
1326: );

Line 1331: FND_MSG_PUB.Count_And_Get

1327: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1330:
1331: FND_MSG_PUB.Count_And_Get
1332: ( p_encoded => FND_API.G_FALSE
1333: , p_count => x_msg_count
1334: , p_data => x_msg_data
1335: );

Line 1370: FND_MSG_PUB.INITIALIZE;

1366: ,x_msg_count OUT NOCOPY NUMBER
1367: ,x_msg_data OUT NOCOPY VARCHAR2
1368: ) IS
1369: BEGIN
1370: FND_MSG_PUB.INITIALIZE;
1371: x_return_status := FND_API.G_RET_STS_SUCCESS;
1372:
1373: BSC_SIMULATION_VIEW_PVT.Add_Or_Update_YTD
1374: (

Line 1389: FND_MSG_PUB.Count_And_Get

1385:
1386: EXCEPTION
1387: WHEN FND_API.G_EXC_ERROR THEN
1388:
1389: FND_MSG_PUB.Count_And_Get
1390: ( p_encoded => FND_API.G_FALSE
1391: , p_count => x_msg_count
1392: , p_data => x_msg_data
1393: );

Line 1398: FND_MSG_PUB.Count_And_Get

1394: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1395: x_return_status := FND_API.G_RET_STS_ERROR;
1396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1397:
1398: FND_MSG_PUB.Count_And_Get
1399: ( p_encoded => FND_API.G_FALSE
1400: , p_count => x_msg_count
1401: , p_data => x_msg_data
1402: );

Line 1451: FND_MSG_PUB.INITIALIZE;

1447: AND b.kpi_measure_id =l_kpi_measure_id
1448: ORDER BY a.color_range_sequence;
1449:
1450: BEGIN
1451: FND_MSG_PUB.INITIALIZE;
1452: x_return_status := FND_API.G_RET_STS_SUCCESS;
1453:
1454: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
1455: (

Line 1545: FND_MSG_PUB.Count_And_Get

1541:
1542: EXCEPTION
1543: WHEN FND_API.G_EXC_ERROR THEN
1544:
1545: FND_MSG_PUB.Count_And_Get
1546: ( p_encoded => FND_API.G_FALSE
1547: , p_count => x_msg_count
1548: , p_data => x_msg_data
1549: );

Line 1554: FND_MSG_PUB.Count_And_Get

1550: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1551: x_return_status := FND_API.G_RET_STS_ERROR;
1552: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1553:
1554: FND_MSG_PUB.Count_And_Get
1555: ( p_encoded => FND_API.G_FALSE
1556: , p_count => x_msg_count
1557: , p_data => x_msg_data
1558: );

Line 1628: FND_MSG_PUB.Count_And_Get

1624:
1625: EXCEPTION
1626: WHEN FND_API.G_EXC_ERROR THEN
1627:
1628: FND_MSG_PUB.Count_And_Get
1629: ( p_encoded => FND_API.G_FALSE
1630: , p_count => x_msg_count
1631: , p_data => x_msg_data
1632: );

Line 1637: FND_MSG_PUB.Count_And_Get

1633: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1634: x_return_status := FND_API.G_RET_STS_ERROR;
1635: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1636:
1637: FND_MSG_PUB.Count_And_Get
1638: ( p_encoded => FND_API.G_FALSE
1639: , p_count => x_msg_count
1640: , p_data => x_msg_data
1641: );

Line 1735: FND_MSG_PUB.Count_And_Get

1731:
1732: EXCEPTION
1733: WHEN FND_API.G_EXC_ERROR THEN
1734:
1735: FND_MSG_PUB.Count_And_Get
1736: ( p_encoded => FND_API.G_FALSE
1737: , p_count => x_msg_count
1738: , p_data => x_msg_data
1739: );

Line 1744: FND_MSG_PUB.Count_And_Get

1740: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1741: x_return_status := FND_API.G_RET_STS_ERROR;
1742: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1743:
1744: FND_MSG_PUB.Count_And_Get
1745: ( p_encoded => FND_API.G_FALSE
1746: , p_count => x_msg_count
1747: , p_data => x_msg_data
1748: );

Line 1791: FND_MSG_PUB.INITIALIZE;

1787: l_count NUMBER;
1788: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1789:
1790: BEGIN
1791: FND_MSG_PUB.INITIALIZE;
1792: x_return_status := FND_API.G_RET_STS_SUCCESS;
1793:
1794: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
1795: (

Line 1832: FND_MSG_PUB.Count_And_Get

1828: END LOOP;
1829: EXCEPTION
1830: WHEN FND_API.G_EXC_ERROR THEN
1831:
1832: FND_MSG_PUB.Count_And_Get
1833: ( p_encoded => FND_API.G_FALSE
1834: , p_count => x_msg_count
1835: , p_data => x_msg_data
1836: );

Line 1841: FND_MSG_PUB.Count_And_Get

1837: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1838: x_return_status := FND_API.G_RET_STS_ERROR;
1839: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1840:
1841: FND_MSG_PUB.Count_And_Get
1842: ( p_encoded => FND_API.G_FALSE
1843: , p_count => x_msg_count
1844: , p_data => x_msg_data
1845: );