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

Line 787: FND_MSG_PUB.Initialize;

783:
784: l_count number;
785: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
786: begin
787: FND_MSG_PUB.Initialize;
788: x_return_status := FND_API.G_RET_STS_SUCCESS;
789: SAVEPOINT CreateBSCAnaOptPVT;
790: -- Check that valid Kpi id was entered.
791: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then

Line 803: FND_MSG_PUB.ADD;

799:
800: if l_count = 0 then
801: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
802: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
803: FND_MSG_PUB.ADD;
804: RAISE FND_API.G_EXC_ERROR;
805: end if;
806: else
807: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 809: FND_MSG_PUB.ADD;

805: end if;
806: else
807: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
808: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
809: FND_MSG_PUB.ADD;
810: RAISE FND_API.G_EXC_ERROR;
811: end if;
812:
813: g_db_object := 'BSC_KPI_ANALYSIS_OPTIONS_B';

Line 886: FND_MSG_PUB.Count_And_Get

882:
883: EXCEPTION
884: WHEN FND_API.G_EXC_ERROR THEN
885: ROLLBACK TO CreateBSCAnaOptPVT;
886: FND_MSG_PUB.Count_And_Get
887: ( p_encoded => 'F'
888: , p_count => x_msg_count
889: , p_data => x_msg_data
890: );

Line 896: FND_MSG_PUB.Count_And_Get

892: x_return_status := FND_API.G_RET_STS_ERROR;
893: RAISE;
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: ROLLBACK TO CreateBSCAnaOptPVT;
896: FND_MSG_PUB.Count_And_Get
897: ( p_encoded => 'F'
898: , p_count => x_msg_count
899: , p_data => x_msg_data
900: );

Line 942: FND_MSG_PUB.Initialize;

938: , x_msg_data OUT NOCOPY varchar2
939: ) is
940:
941: begin
942: FND_MSG_PUB.Initialize;
943: x_return_status := FND_API.G_RET_STS_SUCCESS;
944: g_db_object := 'Retrieve_Analysis_Options';
945: IF ((p_Data_Source IS NOT NULL) AND
946: (p_Data_Source = 'BSC') AND

Line 1037: FND_MSG_PUB.Count_And_Get

1033: end if;
1034:
1035: EXCEPTION
1036: WHEN FND_API.G_EXC_ERROR THEN
1037: FND_MSG_PUB.Count_And_Get
1038: ( p_encoded => FND_API.G_FALSE
1039: , p_count => x_msg_count
1040: , p_data => x_msg_data
1041: );

Line 1046: FND_MSG_PUB.Count_And_Get

1042: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1043: x_return_status := FND_API.G_RET_STS_ERROR;
1044: RAISE;
1045: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1046: FND_MSG_PUB.Count_And_Get
1047: ( p_encoded => FND_API.G_FALSE
1048: , p_count => x_msg_count
1049: , p_data => x_msg_data
1050: );

Line 1089: FND_MSG_PUB.Initialize;

1085: ) IS
1086: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
1087: l_count number;
1088: begin
1089: FND_MSG_PUB.Initialize;
1090: x_return_status := FND_API.G_RET_STS_SUCCESS;
1091: SAVEPOINT UpdateBSCAnaOptPVT;
1092: -- Check that valid Kpi id was entered.
1093: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then

Line 1105: FND_MSG_PUB.ADD;

1101:
1102: if l_count = 0 then
1103: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1104: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1105: FND_MSG_PUB.ADD;
1106: RAISE FND_API.G_EXC_ERROR;
1107: end if;
1108: else
1109: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1111: FND_MSG_PUB.ADD;

1107: end if;
1108: else
1109: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1110: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1111: FND_MSG_PUB.ADD;
1112: RAISE FND_API.G_EXC_ERROR;
1113: end if;
1114: -- update LOCAL language ,source language, group id and level Id values with PASSED values.
1115: l_Anal_Opt_Rec.Bsc_Language := p_Anal_Opt_Rec.Bsc_Language;

Line 1256: FND_MSG_PUB.Count_And_Get

1252: END IF;
1253: EXCEPTION
1254: WHEN FND_API.G_EXC_ERROR THEN
1255: ROLLBACK TO UpdateBSCAnaOptPVT;
1256: FND_MSG_PUB.Count_And_Get
1257: ( p_encoded => FND_API.G_FALSE
1258: , p_count => x_msg_count
1259: , p_data => x_msg_data
1260: );

Line 1266: FND_MSG_PUB.Count_And_Get

1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: RAISE;
1264: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1265: ROLLBACK TO UpdateBSCAnaOptPVT;
1266: FND_MSG_PUB.Count_And_Get
1267: ( p_encoded => FND_API.G_FALSE
1268: , p_count => x_msg_count
1269: , p_data => x_msg_data
1270: );

Line 1328: FND_MSG_PUB.Initialize;

1324: FROM BSC_KPIS_B
1325: WHERE Source_Indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id
1326: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;
1327: BEGIN
1328: FND_MSG_PUB.Initialize;
1329: x_return_status := FND_API.G_RET_STS_SUCCESS;
1330: SAVEPOINT DeleteBSCAnaOptPVT;
1331: l_Anal_Opt_Rec := p_Anal_Opt_Rec;
1332: -- Check that valid Kpi id was entered.

Line 1338: FND_MSG_PUB.ADD;

1334: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B', 'indicator', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1335: IF l_count = 0 THEN
1336: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1337: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1338: FND_MSG_PUB.ADD;
1339: RAISE FND_API.G_EXC_ERROR;
1340: END IF;
1341: ELSE
1342: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1344: FND_MSG_PUB.ADD;

1340: END IF;
1341: ELSE
1342: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1343: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1344: FND_MSG_PUB.ADD;
1345: RAISE FND_API.G_EXC_ERROR;
1346: END IF;
1347: l_delete := Delete_Analysis_Option( l_Anal_Opt_Rec.Bsc_Kpi_Id
1348: ,l_Anal_Opt_Rec.Bsc_Analysis_Option_Id

Line 1356: FND_MSG_PUB.ADD;

1352: ,l_Anal_Opt_Rec.Bsc_Analysis_Group_Id);
1353: IF (l_delete = 'S') THEN
1354: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');
1355: FND_MESSAGE.SET_TOKEN('BSC_AO_DELETE', l_Anal_Opt_Rec.Bsc_Kpi_Id);
1356: FND_MSG_PUB.ADD;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359: IF l_delete = 'L' THEN
1360: IF is_custom_kpi(l_Anal_Opt_Rec.Bsc_Kpi_Id,l_Kpi_Name) = FALSE THEN

Line 1362: FND_MSG_PUB.ADD;

1358: END IF;
1359: IF l_delete = 'L' THEN
1360: IF is_custom_kpi(l_Anal_Opt_Rec.Bsc_Kpi_Id,l_Kpi_Name) = FALSE THEN
1361: FND_MESSAGE.SET_NAME('BSC','BSC_LAST_AO_IN_KPI');
1362: FND_MSG_PUB.ADD;
1363: RAISE FND_API.G_EXC_ERROR;
1364: ELSE
1365: FND_MESSAGE.SET_NAME('BSC','BSC_LAST_AO_IN_CUST_KPI');
1366: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);

Line 1367: FND_MSG_PUB.ADD;

1363: RAISE FND_API.G_EXC_ERROR;
1364: ELSE
1365: FND_MESSAGE.SET_NAME('BSC','BSC_LAST_AO_IN_CUST_KPI');
1366: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);
1367: FND_MSG_PUB.ADD;
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370: END IF;
1371:

Line 1570: FND_MSG_PUB.Count_And_Get

1566: END IF;
1567: EXCEPTION
1568: WHEN FND_API.G_EXC_ERROR THEN
1569: ROLLBACK TO DeleteBSCAnaOptPVT;
1570: FND_MSG_PUB.Count_And_Get
1571: ( p_encoded => FND_API.G_FALSE
1572: , p_count => x_msg_count
1573: , p_data => x_msg_data
1574: );

Line 1580: FND_MSG_PUB.Count_And_Get

1576: x_return_status := FND_API.G_RET_STS_ERROR;
1577: RAISE;
1578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1579: ROLLBACK TO DeleteBSCAnaOptPVT;
1580: FND_MSG_PUB.Count_And_Get
1581: ( p_encoded => FND_API.G_FALSE
1582: , p_count => x_msg_count
1583: , p_data => x_msg_data
1584: );

Line 1627: FND_MSG_PUB.Initialize;

1623:
1624: l_count number;
1625:
1626: begin
1627: FND_MSG_PUB.Initialize;
1628: x_return_status := FND_API.G_RET_STS_SUCCESS;
1629: SAVEPOINT CreateBSCAnaMeasPVT;
1630: -- Check that valid Kpi id was entered.
1631: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then

Line 1642: FND_MSG_PUB.ADD;

1638: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1639: if l_count = 0 then
1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1641: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1642: FND_MSG_PUB.ADD;
1643: RAISE FND_API.G_EXC_ERROR;
1644: end if;
1645: else
1646: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1648: FND_MSG_PUB.ADD;

1644: end if;
1645: else
1646: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1647: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1648: FND_MSG_PUB.ADD;
1649: RAISE FND_API.G_EXC_ERROR;
1650: end if;
1651:
1652:

Line 1662: FND_MSG_PUB.ADD;

1658: p_Anal_Opt_Rec.Bsc_New_Kpi <> 'Y') then
1659:
1660: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_OPTION_ID');
1661: FND_MESSAGE.SET_TOKEN('BSC_OPTION', p_Anal_Opt_Rec.Bsc_Option_Group0);
1662: FND_MSG_PUB.ADD;
1663: RAISE FND_API.G_EXC_ERROR;
1664:
1665: else
1666:

Line 1745: FND_MSG_PUB.Count_And_Get

1741:
1742: EXCEPTION
1743: WHEN FND_API.G_EXC_ERROR THEN
1744: ROLLBACK TO CreateBSCAnaMeasPVT;
1745: FND_MSG_PUB.Count_And_Get
1746: ( p_encoded => FND_API.G_FALSE
1747: , p_count => x_msg_count
1748: , p_data => x_msg_data
1749: );

Line 1755: FND_MSG_PUB.Count_And_Get

1751: x_return_status := FND_API.G_RET_STS_ERROR;
1752: RAISE;
1753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1754: ROLLBACK TO CreateBSCAnaMeasPVT;
1755: FND_MSG_PUB.Count_And_Get
1756: ( p_encoded => FND_API.G_FALSE
1757: , p_count => x_msg_count
1758: , p_data => x_msg_data
1759: );

Line 1798: FND_MSG_PUB.Initialize;

1794: , x_msg_count OUT NOCOPY number
1795: , x_msg_data OUT NOCOPY varchar2
1796: ) is
1797: begin
1798: FND_MSG_PUB.Initialize;
1799: x_return_status := FND_API.G_RET_STS_SUCCESS;
1800: g_db_object := 'Retrieve_Analysis_Measures';
1801: IF (p_Anal_Opt_Rec.Bsc_Dataset_Series_Id IS NULL) THEN
1802: select distinct series_id

Line 1876: FND_MSG_PUB.Count_And_Get

1872: end if;
1873:
1874: EXCEPTION
1875: WHEN FND_API.G_EXC_ERROR THEN
1876: FND_MSG_PUB.Count_And_Get
1877: ( p_encoded => FND_API.G_FALSE
1878: , p_count => x_msg_count
1879: , p_data => x_msg_data
1880: );

Line 1885: FND_MSG_PUB.Count_And_Get

1881: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1882: x_return_status := FND_API.G_RET_STS_ERROR;
1883: RAISE;
1884: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1885: FND_MSG_PUB.Count_And_Get
1886: ( p_encoded => FND_API.G_FALSE
1887: , p_count => x_msg_count
1888: , p_data => x_msg_data
1889: );

Line 1895: FND_MSG_PUB.Initialize;

1891: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_UNEXPECTED_ERROR '||x_msg_data);
1892: RAISE;
1893: WHEN NO_DATA_FOUND THEN
1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1895: FND_MSG_PUB.Initialize;
1896: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
1897: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
1898: FND_MSG_PUB.ADD;
1899: RAISE FND_API.G_EXC_ERROR;

Line 1898: FND_MSG_PUB.ADD;

1894: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1895: FND_MSG_PUB.Initialize;
1896: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
1897: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);
1898: FND_MSG_PUB.ADD;
1899: RAISE FND_API.G_EXC_ERROR;
1900: WHEN OTHERS THEN
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1902: IF (x_msg_data IS NOT NULL) THEN

Line 1931: FND_MSG_PUB.Initialize;

1927: l_dataset_color_change BOOLEAN := FALSE;
1928: l_old_color_method bsc_sys_datasets_b.color_method%TYPE;
1929: l_new_color_method bsc_sys_datasets_b.color_method%TYPE;
1930: begin
1931: FND_MSG_PUB.Initialize;
1932: x_return_status := FND_API.G_RET_STS_SUCCESS;
1933: SAVEPOINT UpdateBSCAnaMeasPVT;
1934: -- Check that valid Kpi id was entered.
1935: if p_Anal_Opt_Rec.Bsc_Kpi_Id is not null then

Line 1946: FND_MSG_PUB.ADD;

1942: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
1943: if l_count = 0 then
1944: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1945: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1946: FND_MSG_PUB.ADD;
1947: RAISE FND_API.G_EXC_ERROR;
1948: end if;
1949: else
1950: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 1952: FND_MSG_PUB.ADD;

1948: end if;
1949: else
1950: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1951: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
1952: FND_MSG_PUB.ADD;
1953: RAISE FND_API.G_EXC_ERROR;
1954: end if;
1955:
1956: -- Not all values will be passed. We need to make sure values not passed are not

Line 2157: FND_MSG_PUB.Count_And_Get

2153:
2154: EXCEPTION
2155: WHEN FND_API.G_EXC_ERROR THEN
2156: ROLLBACK TO UpdateBSCAnaMeasPVT;
2157: FND_MSG_PUB.Count_And_Get
2158: ( p_encoded => FND_API.G_FALSE
2159: , p_count => x_msg_count
2160: , p_data => x_msg_data
2161: );

Line 2167: FND_MSG_PUB.Count_And_Get

2163: x_return_status := FND_API.G_RET_STS_ERROR;
2164: RAISE;
2165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2166: ROLLBACK TO UpdateBSCAnaMeasPVT;
2167: FND_MSG_PUB.Count_And_Get
2168: ( p_encoded => FND_API.G_FALSE
2169: , p_count => x_msg_count
2170: , p_data => x_msg_data
2171: );

Line 2258: FND_MSG_PUB.Initialize;

2254:
2255: l_Temp number;
2256: l_Delete_Flag BOOLEAN := FALSE;
2257: BEGIN
2258: FND_MSG_PUB.Initialize;
2259: SAVEPOINT DeleteBSCAnaMeasPVT;
2260: x_return_status := FND_API.G_RET_STS_SUCCESS;
2261: -- Check that valid Kpi id was entered.
2262: IF (p_Anal_Opt_Rec.Bsc_Kpi_Id IS NOT NULL) THEN

Line 2267: FND_MSG_PUB.ADD;

2263: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B', 'indicator', p_Anal_Opt_Rec.Bsc_Kpi_Id);
2264: IF (l_count = 0) THEN
2265: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2266: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
2267: FND_MSG_PUB.ADD;
2268: RAISE FND_API.G_EXC_ERROR;
2269: END IF;
2270: ELSE
2271: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 2273: FND_MSG_PUB.ADD;

2269: END IF;
2270: ELSE
2271: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2272: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);
2273: FND_MSG_PUB.ADD;
2274: RAISE FND_API.G_EXC_ERROR;
2275: END IF;
2276: l_Count := 0;
2277: IF (c_Grand_Parent_depend%ISOPEN) THEN

Line 2540: FND_MSG_PUB.Count_And_Get

2536: IF (c_Parent_depend%ISOPEN) THEN
2537: CLOSE c_Parent_depend;
2538: END IF;
2539: ROLLBACK TO DeleteBSCAnaMeasPVT;
2540: FND_MSG_PUB.Count_And_Get
2541: ( p_encoded => FND_API.G_FALSE
2542: , p_count => x_msg_count
2543: , p_data => x_msg_data
2544: );

Line 2556: FND_MSG_PUB.Count_And_Get

2552: IF (c_Parent_depend%ISOPEN) THEN
2553: CLOSE c_Parent_depend;
2554: END IF;
2555: ROLLBACK TO DeleteBSCAnaMeasPVT;
2556: FND_MSG_PUB.Count_And_Get
2557: ( p_encoded => FND_API.G_FALSE
2558: , p_count => x_msg_count
2559: , p_data => x_msg_data
2560: );

Line 2631: FND_MSG_PUB.Initialize;

2627: AND B.analysis_group_id = p_anal_group_id
2628: AND B.option_id = p_anal_option_id
2629: AND Prototype_Flag <> BSC_KPI_PUB.Delete_Kpi_Flag;
2630: BEGIN
2631: FND_MSG_PUB.Initialize;
2632: x_return_status := FND_API.G_RET_STS_SUCCESS;
2633: -- First check if it is a Shared Kpi. If it is then no deletion.
2634: SELECT DISTINCT(Share_Flag)
2635: INTO l_value

Line 2679: FND_MSG_PUB.Count_And_Get

2675: -- displaying the option therefore it may be deleted.
2676: RETURN 'Y';
2677: EXCEPTION
2678: WHEN FND_API.G_EXC_ERROR THEN
2679: FND_MSG_PUB.Count_And_Get
2680: ( p_encoded => FND_API.G_FALSE
2681: , p_count => x_msg_count
2682: , p_data => x_msg_data
2683: );

Line 2688: FND_MSG_PUB.Count_And_Get

2684: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2685: x_return_status := FND_API.G_RET_STS_ERROR;
2686: RAISE;
2687: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2688: FND_MSG_PUB.Count_And_Get
2689: ( p_encoded => FND_API.G_FALSE
2690: , p_count => x_msg_count
2691: , p_data => x_msg_data
2692: );

Line 2909: FND_MSG_PUB.Initialize;

2905: l_parent_option_id BSC_KPI_ANALYSIS_OPTIONS_B.Parent_Option_Id%TYPE;
2906: l_Anal_Det_Opt_Tbl BSC_ANALYSIS_OPTION_PUB.Bsc_Anal_Opt_Det_Tbl_Type;
2907: l_anal_opt_name VARCHAR2(3000);
2908: BEGIN
2909: FND_MSG_PUB.Initialize;
2910: x_return_status := FND_API.G_RET_STS_SUCCESS;
2911: SAVEPOINT DeleteBSCAnaOptMultGroups;
2912: l_Anal_Opt_Rec.Bsc_Kpi_Id := p_Kpi_id;
2913:

Line 2916: FND_MSG_PUB.ADD;

2912: l_Anal_Opt_Rec.Bsc_Kpi_Id := p_Kpi_id;
2913:
2914: IF(Validate_If_single_Anal_Opt(p_Anal_Opt_Tbl)) THEN
2915: FND_MESSAGE.SET_NAME('BSC','BSC_LAST_AO_IN_KPI');
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_ERROR;
2918: END IF;
2919:
2920:

Line 2943: FND_MSG_PUB.ADD;

2939: IF((l_Anal_Det_Opt_Tbl(l_count).Bsc_dependency_flag = 1)AND(l_Anal_Det_Opt_Tbl.EXISTS(l_count-1))AND(l_Anal_Det_Opt_Tbl(l_count-1).No_of_child <>0)) THEN
2940:
2941: IF((l_Anal_Det_Opt_Tbl(l_count-1).No_of_child >1)AND(l_Anal_Det_Opt_Tbl(l_count).Bsc_Option_Id=0)) THEN
2942: FND_MESSAGE.SET_NAME('BSC','BSC_D_NOT_DELETE_AO_DEPEN');
2943: FND_MSG_PUB.ADD;
2944: RAISE FND_API.G_EXC_ERROR;
2945: END IF;
2946:
2947: l_Anal_Opt_Rec.Bsc_Analysis_Group_Id := l_count;

Line 2964: FND_MSG_PUB.ADD;

2960: IF((l_Anal_Det_Opt_Tbl.EXISTS(l_count-1))AND(l_Anal_Det_Opt_Tbl(l_count-1).No_of_child =1)) THEN
2961:
2962: IF((l_Anal_Det_Opt_Tbl(l_count).Bsc_dependency_flag = 1)AND(l_Anal_Det_Opt_Tbl.EXISTS(l_count-2))AND(l_Anal_Det_Opt_Tbl(l_count-2).No_of_child >1)AND(l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Option_Id=0)) THEN
2963: FND_MESSAGE.SET_NAME('BSC','BSC_D_NOT_DELETE_AO_DEPEN');
2964: FND_MSG_PUB.ADD;
2965: RAISE FND_API.G_EXC_ERROR;
2966: END IF;
2967:
2968: l_Anal_Opt_Rec.Bsc_Analysis_Group_Id := l_count -1;

Line 3016: FND_MSG_PUB.ADD;

3012: );
3013: ELSE
3014: IF((l_Anal_Det_Opt_Tbl(l_count-1).Bsc_dependency_flag = 1)AND(l_Anal_Det_Opt_Tbl.EXISTS(l_count-2))AND(l_Anal_Det_Opt_Tbl(l_count-2).No_of_child >1)AND(l_Anal_Det_Opt_Tbl(l_count -1).Bsc_Option_Id=0)) THEN
3015: FND_MESSAGE.SET_NAME('BSC','BSC_D_NOT_DELETE_AO_DEPEN');
3016: FND_MSG_PUB.ADD;
3017: RAISE FND_API.G_EXC_ERROR;
3018: END IF;
3019:
3020: l_Anal_Opt_Rec.Bsc_Analysis_Group_Id := l_count -1;

Line 3066: FND_MSG_PUB.Count_And_Get

3062: END IF;
3063: EXCEPTION
3064: WHEN FND_API.G_EXC_ERROR THEN
3065: ROLLBACK TO DeleteBSCAnaOptMultGroups;
3066: FND_MSG_PUB.Count_And_Get
3067: ( p_encoded => FND_API.G_FALSE
3068: , p_count => x_msg_count
3069: , p_data => x_msg_data
3070: );

Line 3076: FND_MSG_PUB.Count_And_Get

3072: x_return_status := FND_API.G_RET_STS_ERROR;
3073: RAISE;
3074: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3075: ROLLBACK TO DeleteBSCAnaOptMultGroups;
3076: FND_MSG_PUB.Count_And_Get
3077: ( p_encoded => FND_API.G_FALSE
3078: , p_count => x_msg_count
3079: , p_data => x_msg_data
3080: );

Line 3123: FND_MSG_PUB.Initialize;

3119: l_new_group_count NUMBER;
3120: l_group_count NUMBER;
3121: l_Num_Opt_Id NUMBER;
3122: BEGIN
3123: FND_MSG_PUB.Initialize;
3124: x_return_status := FND_API.G_RET_STS_SUCCESS;
3125: SAVEPOINT BSCSynchKpiAnalGroup;
3126:
3127: l_Anal_Opt_Tbl := p_Anal_Opt_Tbl;

Line 3168: FND_MSG_PUB.Count_And_Get

3164: END LOOP;
3165: EXCEPTION
3166: WHEN FND_API.G_EXC_ERROR THEN
3167: ROLLBACK TO BSCSynchKpiAnalGroup;
3168: FND_MSG_PUB.Count_And_Get
3169: ( p_encoded => FND_API.G_FALSE
3170: , p_count => x_msg_count
3171: , p_data => x_msg_data
3172: );

Line 3178: FND_MSG_PUB.Count_And_Get

3174: x_return_status := FND_API.G_RET_STS_ERROR;
3175: RAISE;
3176: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3177: ROLLBACK TO BSCSynchKpiAnalGroup;
3178: FND_MSG_PUB.Count_And_Get
3179: ( p_encoded => FND_API.G_FALSE
3180: , p_count => x_msg_count
3181: , p_data => x_msg_data
3182: );

Line 3235: FND_MSG_PUB.Initialize;

3231: AND SHORT_NAME IS NOT NULL;
3232:
3233: BEGIN
3234: SAVEPOINT AORefreshShortNamesPVT;
3235: FND_MSG_PUB.Initialize;
3236: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3237:
3238:
3239: FOR cUSN IN c_Update_Short_Names LOOP

Line 3252: FND_MSG_PUB.Count_And_Get

3248: EXCEPTION
3249: WHEN FND_API.G_EXC_ERROR THEN
3250: ROLLBACK TO AORefreshShortNamesPVT;
3251: IF (x_msg_data IS NULL) THEN
3252: FND_MSG_PUB.Count_And_Get
3253: ( p_encoded => FND_API.G_FALSE
3254: , p_count => x_msg_count
3255: , p_data => x_msg_data
3256: );

Line 3262: FND_MSG_PUB.Count_And_Get

3258: x_Return_Status := FND_API.G_RET_STS_ERROR;
3259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3260: ROLLBACK TO AORefreshShortNamesPVT;
3261: IF (x_msg_data IS NULL) THEN
3262: FND_MSG_PUB.Count_And_Get
3263: ( p_encoded => FND_API.G_FALSE
3264: , p_count => x_msg_count
3265: , p_data => x_msg_data
3266: );

Line 3365: FND_MSG_PUB.Initialize;

3361: FROM BSC_KPIS_VL
3362: WHERE indicator = p_kpi_id;
3363:
3364: BEGIN
3365: FND_MSG_PUB.Initialize;
3366: x_return_status := FND_API.G_RET_STS_SUCCESS;
3367: l_Allow_Delete := TRUE;
3368:
3369: IF (c_Measure_ak%ISOPEN) THEN

Line 3396: FND_MSG_PUB.ADD;

3392: IF (l_Measure_AKRegion <> l_AnaOpt_AKRegion) THEN
3393: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_NOT_PRIM_SOURCE');
3394: FND_MESSAGE.SET_TOKEN('AK_KPI', l_AnaOpt_AKRegion);
3395: FND_MESSAGE.SET_TOKEN('AK_MES', l_Measure_AKRegion);
3396: FND_MSG_PUB.ADD;
3397: RAISE FND_API.G_EXC_ERROR;
3398: END IF;
3399:
3400: l_parent_obj_table := BIS_RSG_PUB_API_PKG.GetParentObjects(l_Measure_Function

Line 3403: FND_MSG_PUB.Initialize;

3399:
3400: l_parent_obj_table := BIS_RSG_PUB_API_PKG.GetParentObjects(l_Measure_Function
3401: ,'REPORT','PORTLET',l_ret_status,l_msg_data);
3402: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
3403: FND_MSG_PUB.Initialize;
3404: FND_MESSAGE.SET_NAME('BIS',l_msg_data);
3405: FND_MSG_PUB.ADD;
3406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3407: END IF;

Line 3405: FND_MSG_PUB.ADD;

3401: ,'REPORT','PORTLET',l_ret_status,l_msg_data);
3402: IF ((l_ret_status IS NOT NULL) AND (l_ret_status <> FND_API.G_RET_STS_SUCCESS)) THEN
3403: FND_MSG_PUB.Initialize;
3404: FND_MESSAGE.SET_NAME('BIS',l_msg_data);
3405: FND_MSG_PUB.ADD;
3406: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3407: END IF;
3408:
3409: l_mess_count := 1;

Line 3458: FND_MSG_PUB.ADD;

3454: FND_MESSAGE.SET_NAME('BSC','BSC_OBJ_DELETE');
3455: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_objective_name);
3456: FND_MESSAGE.SET_TOKEN('KPI_NAME', l_AnaOpt_Name);
3457: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_message);
3458: FND_MSG_PUB.ADD;
3459: RAISE FND_API.G_EXC_ERROR;
3460: END IF;
3461:
3462: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_DELETE');

Line 3466: FND_MSG_PUB.ADD;

3462: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_DELETE');
3463: FND_MESSAGE.SET_TOKEN('MEASURE', l_AnaOpt_Name);
3464: FND_MESSAGE.SET_TOKEN('AK_REGION', l_Measure_AKRegion);
3465: FND_MESSAGE.SET_TOKEN('FORM_FUNCTION', l_Measure_Function);
3466: FND_MSG_PUB.ADD;
3467:
3468: FND_MSG_PUB.Count_And_Get
3469: ( p_encoded => FND_API.G_FALSE
3470: , p_count => x_msg_count

Line 3468: FND_MSG_PUB.Count_And_Get

3464: FND_MESSAGE.SET_TOKEN('AK_REGION', l_Measure_AKRegion);
3465: FND_MESSAGE.SET_TOKEN('FORM_FUNCTION', l_Measure_Function);
3466: FND_MSG_PUB.ADD;
3467:
3468: FND_MSG_PUB.Count_And_Get
3469: ( p_encoded => FND_API.G_FALSE
3470: , p_count => x_msg_count
3471: , p_data => x_msg_data
3472: );

Line 3482: FND_MSG_PUB.Count_And_Get

3478: END IF;
3479: IF (c_KpiName%ISOPEN) THEN
3480: CLOSE c_KpiMeasure;
3481: END IF;
3482: FND_MSG_PUB.Count_And_Get
3483: ( p_encoded => FND_API.G_FALSE
3484: , p_count => x_msg_count
3485: , p_data => x_msg_data
3486: );

Line 3497: FND_MSG_PUB.Count_And_Get

3493: END IF;
3494: IF (c_KpiName%ISOPEN) THEN
3495: CLOSE c_KpiMeasure;
3496: END IF;
3497: FND_MSG_PUB.Count_And_Get
3498: ( p_encoded => FND_API.G_FALSE
3499: , p_count => x_msg_count
3500: , p_data => x_msg_data
3501: );

Line 3546: FND_MSG_PUB.Initialize;

3542: ) IS
3543: l_Bsc_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
3544: BEGIN
3545: x_return_status := FND_API.G_RET_STS_SUCCESS;
3546: FND_MSG_PUB.Initialize;
3547: --DBMS_OUTPUT.PUT_LINE('in private delte');
3548:
3549: DELETE FROM BSC_KPI_ANALYSIS_MEASURES_B
3550: WHERE indicator = p_Bsc_Anal_Opt_Rec.Bsc_Kpi_Id

Line 3569: FND_MSG_PUB.Count_And_Get

3565:
3566: EXCEPTION
3567: WHEN FND_API.G_EXC_ERROR THEN
3568: IF (x_msg_data IS NULL) THEN
3569: FND_MSG_PUB.Count_And_Get
3570: ( p_encoded => FND_API.G_FALSE
3571: , p_count => x_msg_count
3572: , p_data => x_msg_data
3573: );

Line 3579: FND_MSG_PUB.Count_And_Get

3575: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3576: x_return_status := FND_API.G_RET_STS_ERROR;
3577: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3578: IF (x_msg_data IS NULL) THEN
3579: FND_MSG_PUB.Count_And_Get
3580: ( p_encoded => FND_API.G_FALSE
3581: , p_count => x_msg_count
3582: , p_data => x_msg_data
3583: );

Line 3632: FND_MSG_PUB.Initialize;

3628:
3629: l_Count NUMBER;
3630:
3631: BEGIN
3632: FND_MSG_PUB.Initialize;
3633: SAVEPOINT DeleteBSCDataSeriesPVT;
3634: x_return_status := FND_API.G_RET_STS_SUCCESS;
3635:
3636: -- Delete the Data Series

Line 3708: FND_MSG_PUB.Count_And_Get

3704: IF (c_Dataseries%ISOPEN) THEN
3705: CLOSE c_Dataseries;
3706: END IF;
3707: ROLLBACK TO DeleteBSCDataSeriesPVT;
3708: FND_MSG_PUB.Count_And_Get
3709: ( p_encoded => FND_API.G_FALSE
3710: , p_count => x_msg_count
3711: , p_data => x_msg_data
3712: );

Line 3721: FND_MSG_PUB.Count_And_Get

3717: IF (c_Dataseries%ISOPEN) THEN
3718: CLOSE c_Dataseries;
3719: END IF;
3720: ROLLBACK TO DeleteBSCDataSeriesPVT;
3721: FND_MSG_PUB.Count_And_Get
3722: ( p_encoded => FND_API.G_FALSE
3723: , p_count => x_msg_count
3724: , p_data => x_msg_data
3725: );

Line 3780: FND_MSG_PUB.Initialize;

3776: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
3777: l_temp_value number := -999;
3778:
3779: BEGIN
3780: FND_MSG_PUB.Initialize;
3781: SAVEPOINT SwapDataSeriesPVT;
3782:
3783: x_return_status := FND_API.G_RET_STS_SUCCESS;
3784:

Line 3848: FND_MSG_PUB.Count_And_Get

3844: IF (c_Data_Series%ISOPEN) THEN
3845: CLOSE c_Data_Series;
3846: END IF;
3847: ROLLBACK TO SwapDataSeriesPVT;
3848: FND_MSG_PUB.Count_And_Get
3849: ( p_encoded => FND_API.G_FALSE
3850: , p_count => x_msg_count
3851: , p_data => x_msg_data
3852: );

Line 3861: FND_MSG_PUB.Count_And_Get

3857: IF (c_Data_Series%ISOPEN) THEN
3858: CLOSE c_Data_Series;
3859: END IF;
3860: ROLLBACK TO SwapDataSeriesPVT;
3861: FND_MSG_PUB.Count_And_Get
3862: ( p_encoded => FND_API.G_FALSE
3863: , p_count => x_msg_count
3864: , p_data => x_msg_data
3865: );

Line 3955: FND_MSG_PUB.Initialize;

3951: l_Count NUMBER;
3952: l_Max_Series_Id NUMBER;
3953: l_Upd_Series_Id NUMBER;
3954: BEGIN
3955: FND_MSG_PUB.Initialize;
3956: SAVEPOINT CascadedSeriesPVT;
3957:
3958: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
3959:

Line 4153: FND_MSG_PUB.Initialize;

4149: l_Enable_Link BIS_INDICATORS.ENABLE_LINK%TYPE;
4150: l_Comparison_Source BIS_INDICATORS.COMPARISON_SOURCE%TYPE;
4151:
4152: BEGIN
4153: FND_MSG_PUB.Initialize;
4154: SAVEPOINT CascadedDataSrcPVT;
4155:
4156: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
4157:

Line 4232: FND_MSG_PUB.Initialize;

4228: l_Anal_Opt_Comb_Tbl BSC_ANALYSIS_OPTION_PUB.Anal_Opt_Comb_Num_Tbl_Type;
4229: BEGIN
4230: SAVEPOINT SetDftAnalOption;
4231: x_return_status := FND_API.G_RET_STS_SUCCESS;
4232: FND_MSG_PUB.Initialize;
4233:
4234: IF( p_Anal_Opt_Comb_Tbl IS NOT NULL) THEN
4235: l_Anal_Opt_Comb_Tbl := p_Anal_Opt_Comb_Tbl;
4236: l_anal_grp_id := p_Anal_Grp_Id;

Line 4278: FND_MSG_PUB.Count_And_Get

4274:
4275: EXCEPTION
4276: WHEN FND_API.G_EXC_ERROR THEN
4277: ROLLBACK TO SetDftAnalOption;
4278: FND_MSG_PUB.Count_And_Get
4279: ( p_encoded => FND_API.G_FALSE
4280: , p_count => x_msg_count
4281: , p_data => x_msg_data
4282: );

Line 4288: FND_MSG_PUB.Count_And_Get

4284: x_return_status := FND_API.G_RET_STS_ERROR;
4285: RAISE;
4286: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4287: ROLLBACK TO SetDftAnalOption;
4288: FND_MSG_PUB.Count_And_Get
4289: ( p_encoded => FND_API.G_FALSE
4290: , p_count => x_msg_count
4291: , p_data => x_msg_data
4292: );