DBA Data[Home] [Help]

APPS.BSC_SIMULATION_VIEW_PVT dependencies on FND_MSG_PUB

Line 600: FND_MSG_PUB.INITIALIZE;

596:
597:
598: BEGIN
599: SAVEPOINT Duplicatekpimetadata;
600: FND_MSG_PUB.INITIALIZE;
601: x_return_status := FND_API.G_RET_STS_SUCCESS;
602:
603:
604: --Need to check if the records already exists for duplicate objective

Line 728: FND_MSG_PUB.Count_And_Get

724:
725: EXCEPTION
726: WHEN FND_API.G_EXC_ERROR THEN
727: ROLLBACK TO Duplicatekpimetadata;
728: FND_MSG_PUB.Count_And_Get
729: ( p_encoded => FND_API.G_FALSE
730: , p_count => x_msg_count
731: , p_data => x_msg_data
732: );

Line 737: FND_MSG_PUB.Count_And_Get

733: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
736: ROLLBACK TO Duplicatekpimetadata;
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 792: FND_MSG_PUB.INITIALIZE;

788: AND B.config_type = BSC_SIMULATION_VIEW_PUB.c_TYPE;
789:
790: BEGIN
791: SAVEPOINT AddOrUpdateYTD;
792: FND_MSG_PUB.INITIALIZE;
793: x_return_status := FND_API.G_RET_STS_SUCCESS;
794:
795: l_YTD :=p_YTD;
796:

Line 909: FND_MSG_PUB.Count_And_Get

905:
906: EXCEPTION
907: WHEN FND_API.G_EXC_ERROR THEN
908: ROLLBACK TO AddOrUpdateYTD;
909: FND_MSG_PUB.Count_And_Get
910: ( p_encoded => FND_API.G_FALSE
911: , p_count => x_msg_count
912: , p_data => x_msg_data
913: );

Line 918: FND_MSG_PUB.Count_And_Get

914: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
915: x_return_status := FND_API.G_RET_STS_ERROR;
916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
917: ROLLBACK TO AddOrUpdateYTD;
918: FND_MSG_PUB.Count_And_Get
919: ( p_encoded => FND_API.G_FALSE
920: , p_count => x_msg_count
921: , p_data => x_msg_data
922: );

Line 960: FND_MSG_PUB.INITIALIZE;

956: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
957: l_kpi_measure_rec BSC_KPI_MEASURE_PROPS_PUB.kpi_measure_props_rec;
958: BEGIN
959: SAVEPOINT SetKpiColorFlag;
960: FND_MSG_PUB.INITIALIZE;
961: x_return_status := FND_API.G_RET_STS_SUCCESS;
962:
963: l_kpi_measure_id := BSC_SIMULATION_VIEW_PUB.Get_Kpi_Measure_Id
964: (

Line 1000: FND_MSG_PUB.Count_And_Get

996:
997: EXCEPTION
998: WHEN FND_API.G_EXC_ERROR THEN
999: ROLLBACK TO SetKpiColorFlag;
1000: FND_MSG_PUB.Count_And_Get
1001: ( p_encoded => FND_API.G_FALSE
1002: , p_count => x_msg_count
1003: , p_data => x_msg_data
1004: );

Line 1009: FND_MSG_PUB.Count_And_Get

1005: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1006: x_return_status := FND_API.G_RET_STS_ERROR;
1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO SetKpiColorFlag;
1009: FND_MSG_PUB.Count_And_Get
1010: ( p_encoded => FND_API.G_FALSE
1011: , p_count => x_msg_count
1012: , p_data => x_msg_data
1013: );

Line 1060: FND_MSG_PUB.INITIALIZE;

1056: l_kpi_measure_id bsc_kpi_analysis_measures_b.kpi_measure_id%TYPE;
1057:
1058: BEGIN
1059: SAVEPOINT SetKpiColorMethod;
1060: FND_MSG_PUB.INITIALIZE;
1061: x_return_status := FND_API.G_RET_STS_SUCCESS;
1062:
1063: l_count :=0;
1064:

Line 1120: FND_MSG_PUB.Count_And_Get

1116:
1117: EXCEPTION
1118: WHEN FND_API.G_EXC_ERROR THEN
1119: ROLLBACK TO SetKpiColorMethod;
1120: FND_MSG_PUB.Count_And_Get
1121: ( p_encoded => FND_API.G_FALSE
1122: , p_count => x_msg_count
1123: , p_data => x_msg_data
1124: );

Line 1129: FND_MSG_PUB.Count_And_Get

1125: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1126: x_return_status := FND_API.G_RET_STS_ERROR;
1127: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1128: ROLLBACK TO SetKpiColorMethod;
1129: FND_MSG_PUB.Count_And_Get
1130: ( p_encoded => FND_API.G_FALSE
1131: , p_count => x_msg_count
1132: , p_data => x_msg_data
1133: );

Line 1224: FND_MSG_PUB.Count_And_Get

1220: END IF;
1221: END IF;
1222: EXCEPTION
1223: WHEN FND_API.G_EXC_ERROR THEN
1224: FND_MSG_PUB.Count_And_Get
1225: ( p_encoded => FND_API.G_FALSE
1226: , p_count => x_msg_count
1227: , p_data => x_msg_data
1228: );

Line 1232: FND_MSG_PUB.Count_And_Get

1228: );
1229: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1230: x_return_status := FND_API.G_RET_STS_ERROR;
1231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1232: FND_MSG_PUB.Count_And_Get
1233: ( p_encoded => FND_API.G_FALSE
1234: , p_count => x_msg_count
1235: , p_data => x_msg_data
1236: );

Line 1284: FND_MSG_PUB.INITIALIZE;

1280:
1281:
1282: BEGIN
1283: SAVEPOINT copysimmetadata;
1284: FND_MSG_PUB.INITIALIZE;
1285: x_return_status := FND_API.G_RET_STS_SUCCESS;
1286:
1287: BSC_APPS.Init_Bsc_Apps;
1288:

Line 1369: FND_MSG_PUB.INITIALIZE;

1365: AND a.attribute2= l_meas_short_name;
1366:
1367: BEGIN
1368: SAVEPOINT SetAkFormatId;
1369: FND_MSG_PUB.INITIALIZE;
1370: x_return_status := FND_API.G_RET_STS_SUCCESS;
1371:
1372: FOR cd IN c_ind LOOP
1373:

Line 1402: FND_MSG_PUB.Count_And_Get

1398:
1399: EXCEPTION
1400: WHEN FND_API.G_EXC_ERROR THEN
1401: ROLLBACK TO SetAkFormatId;
1402: FND_MSG_PUB.Count_And_Get
1403: ( p_encoded => FND_API.G_FALSE
1404: , p_count => x_msg_count
1405: , p_data => x_msg_data
1406: );

Line 1411: FND_MSG_PUB.Count_And_Get

1407: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1408: x_return_status := FND_API.G_RET_STS_ERROR;
1409: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1410: ROLLBACK TO SetAkFormatId;
1411: FND_MSG_PUB.Count_And_Get
1412: ( p_encoded => FND_API.G_FALSE
1413: , p_count => x_msg_count
1414: , p_data => x_msg_data
1415: );

Line 1476: FND_MSG_PUB.INITIALIZE;

1472: --then copy the data to the shared objectives
1473: --flag the objective to the same flag as master
1474: -- also copy the default node value to the shared objective
1475: SAVEPOINT HandleSharedObject;
1476: FND_MSG_PUB.INITIALIZE;
1477: x_return_status := FND_API.G_RET_STS_SUCCESS;
1478: l_count := 0;
1479:
1480: FOR cd IN c_kpi_ids LOOP

Line 1565: FND_MSG_PUB.Count_And_Get

1561: END IF;
1562: EXCEPTION
1563: WHEN FND_API.G_EXC_ERROR THEN
1564: ROLLBACK TO HandleSharedObject;
1565: FND_MSG_PUB.Count_And_Get
1566: ( p_encoded => FND_API.G_FALSE
1567: , p_count => x_msg_count
1568: , p_data => x_msg_data
1569: );

Line 1574: FND_MSG_PUB.Count_And_Get

1570: ----DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1571: x_return_status := FND_API.G_RET_STS_ERROR;
1572: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1573: ROLLBACK TO HandleSharedObject;
1574: FND_MSG_PUB.Count_And_Get
1575: ( p_encoded => FND_API.G_FALSE
1576: , p_count => x_msg_count
1577: , p_data => x_msg_data
1578: );

Line 1650: FND_MSG_PUB.Initialize;

1646: FROM
1647: TABLE(CAST(p_New_Dim_Levels AS FND_TABLE_OF_NUMBER)));
1648:
1649: BEGIN
1650: FND_MSG_PUB.Initialize;
1651: x_return_status := FND_API.G_RET_STS_SUCCESS;
1652:
1653: SAVEPOINT BscSimCopyDimGrp;
1654:

Line 1719: FND_MSG_PUB.Count_And_Get

1715: EXCEPTION
1716: WHEN FND_API.G_EXC_ERROR THEN
1717: ROLLBACK TO BscSimCopyDimGrp;
1718: IF (x_msg_data IS NULL) THEN
1719: FND_MSG_PUB.Count_And_Get
1720: ( p_encoded => FND_API.G_FALSE
1721: , p_count => x_msg_count
1722: , p_data => x_msg_data
1723: );

Line 1729: FND_MSG_PUB.Count_And_Get

1725: x_return_status := FND_API.G_RET_STS_ERROR;
1726: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1727: ROLLBACK TO BscSimCopyDimGrp;
1728: IF (x_msg_data IS NULL) THEN
1729: FND_MSG_PUB.Count_And_Get
1730: ( p_encoded => FND_API.G_FALSE
1731: , p_count => x_msg_count
1732: , p_data => x_msg_data
1733: );

Line 1784: FND_MSG_PUB.INITIALIZE;

1780: l_dim_obj_sht_name BSC_SYS_DIM_LEVELS_VL.short_name%TYPE;
1781: l_dim_set_id NUMBER :=0;
1782:
1783: BEGIN
1784: FND_MSG_PUB.INITIALIZE;
1785: x_return_status := FND_API.G_RET_STS_SUCCESS;
1786: IF(p_ind_Sht_Name IS NOT NULL)THEN
1787:
1788: FOR cd IN c_form_functions LOOP

Line 1831: FND_MSG_PUB.Count_And_Get

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

Line 1839: FND_MSG_PUB.Count_And_Get

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