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

Line 72: FND_MSG_PUB.Initialize;

68: l_No_Ind NUMBER;
69: l_Count NUMBER;
70: BEGIN
71:
72: FND_MSG_PUB.Initialize;
73: x_return_status := FND_API.G_RET_STS_SUCCESS;
74: -- Assign all values in the passed "Record" parameter to the locally defined
75: -- "Record" variable.
76: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;

Line 115: FND_MSG_PUB.ADD;

111:
112: if l_count = 0 then
113: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');
114: FND_MESSAGE.SET_TOKEN('BSC_KGROUP', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id);
115: FND_MSG_PUB.ADD;
116: RAISE FND_API.G_EXC_ERROR;
117: end if;
118: else
119: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KGROUP_ID_ENTERED');

Line 120: FND_MSG_PUB.ADD;

116: RAISE FND_API.G_EXC_ERROR;
117: end if;
118: else
119: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KGROUP_ID_ENTERED');
120: FND_MSG_PUB.ADD;
121: RAISE FND_API.G_EXC_ERROR;
122: end if;
123:
124: IF (l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Share_Flag <> 2) THEN

Line 137: FND_MSG_PUB.ADD;

133: AND B.Prototype_Flag <> 2;
134: IF (l_No_Ind > 0) THEN
135: FND_MESSAGE.SET_NAME('BSC', 'BSC_GROUP_BESIDES_TO_BELOW');
136: FND_MESSAGE.SET_TOKEN('BESIDES_THE_NAME', BSC_APPS.Get_Lookup_Value('BSC_UI_BUILDER', 'BESIDE_THE_NAME'), TRUE);
137: FND_MSG_PUB.ADD;
138: RAISE FND_API.G_EXC_ERROR;
139: END IF;
140: END IF;
141:

Line 170: FND_MSG_PUB.Count_And_Get

166:
167: EXCEPTION
168: WHEN FND_API.G_EXC_ERROR THEN
169: IF (x_msg_data IS NULL) THEN
170: FND_MSG_PUB.Count_And_Get
171: ( p_encoded => FND_API.G_FALSE
172: , p_count => x_msg_count
173: , p_data => x_msg_data
174: );

Line 180: FND_MSG_PUB.Count_And_Get

176: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
177: x_return_status := FND_API.G_RET_STS_ERROR;
178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
179: IF (x_msg_data IS NULL) THEN
180: FND_MSG_PUB.Count_And_Get
181: ( p_encoded => FND_API.G_FALSE
182: , p_count => x_msg_count
183: , p_data => x_msg_data
184: );

Line 231: FND_MSG_PUB.Initialize;

227: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
228: l_Bsc_Kpi_Entity_Rec_Out BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
229:
230: begin
231: FND_MSG_PUB.Initialize;
232: x_return_status := FND_API.G_RET_STS_SUCCESS;
233:
234: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
235:

Line 250: FND_MSG_PUB.Count_And_Get

246:
247: EXCEPTION
248: WHEN FND_API.G_EXC_ERROR THEN
249: IF (x_msg_data IS NULL) THEN
250: FND_MSG_PUB.Count_And_Get
251: ( p_encoded => FND_API.G_FALSE
252: , p_count => x_msg_count
253: , p_data => x_msg_data
254: );

Line 260: FND_MSG_PUB.Count_And_Get

256: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
257: x_return_status := FND_API.G_RET_STS_ERROR;
258: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
259: IF (x_msg_data IS NULL) THEN
260: FND_MSG_PUB.Count_And_Get
261: ( p_encoded => FND_API.G_FALSE
262: , p_count => x_msg_count
263: , p_data => x_msg_data
264: );

Line 299: FND_MSG_PUB.Initialize;

295: ,x_msg_data OUT NOCOPY varchar2
296: ) is
297:
298: begin
299: FND_MSG_PUB.Initialize;
300: x_return_status := FND_API.G_RET_STS_SUCCESS;
301:
302: x_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
303:

Line 360: FND_MSG_PUB.Initialize;

356: ,x_msg_data OUT NOCOPY varchar2
357: ) is
358:
359: begin
360: FND_MSG_PUB.Initialize;
361: x_return_status := FND_API.G_RET_STS_SUCCESS;
362: BSC_KPI_PVT.Retrieve_Kpi( p_commit
363: ,p_Bsc_Kpi_Entity_Rec
364: ,x_Bsc_Kpi_Entity_Rec

Line 382: FND_MSG_PUB.Count_And_Get

378:
379: EXCEPTION
380: WHEN FND_API.G_EXC_ERROR THEN
381: IF (x_msg_data IS NULL) THEN
382: FND_MSG_PUB.Count_And_Get
383: ( p_encoded => FND_API.G_FALSE
384: , p_count => x_msg_count
385: , p_data => x_msg_data
386: );

Line 392: FND_MSG_PUB.Count_And_Get

388: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
389: x_return_status := FND_API.G_RET_STS_ERROR;
390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
391: IF (x_msg_data IS NULL) THEN
392: FND_MSG_PUB.Count_And_Get
393: ( p_encoded => FND_API.G_FALSE
394: , p_count => x_msg_count
395: , p_data => x_msg_data
396: );

Line 446: FND_MSG_PUB.Initialize;

442: WHERE SOURCE_INDICATOR = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id
443: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.Delete_Kpi_Flag;
444:
445: begin
446: FND_MSG_PUB.Initialize;
447: x_return_status := FND_API.G_RET_STS_SUCCESS;
448:
449: BSC_KPI_PVT.Update_Kpi( p_commit
450: ,p_Bsc_Kpi_Entity_Rec

Line 520: FND_MSG_PUB.Count_And_Get

516:
517: EXCEPTION
518: WHEN FND_API.G_EXC_ERROR THEN
519: IF (x_msg_data IS NULL) THEN
520: FND_MSG_PUB.Count_And_Get
521: ( p_encoded => FND_API.G_FALSE
522: , p_count => x_msg_count
523: , p_data => x_msg_data
524: );

Line 530: FND_MSG_PUB.Count_And_Get

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

Line 674: FND_MSG_PUB.Initialize;

670: x_dim_short_names BSC_UTILITY.t_array_of_varchar2;
671: l_config_type BSC_KPIS_B.config_type%TYPE;
672:
673: BEGIN
674: FND_MSG_PUB.Initialize;
675: x_return_status := FND_API.G_RET_STS_SUCCESS;
676: -- Assign all values in the passed "Record" parameter to the locally defined
677: -- "Record" variable.
678: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;

Line 851: FND_MSG_PUB.Count_And_Get

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

Line 861: FND_MSG_PUB.Count_And_Get

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

Line 904: FND_MSG_PUB.Initialize;

900:
901: l_Bsc_Dim_Rec BSC_DIMENSION_LEVELS_PUB.Bsc_Dim_Level_Rec_Type;
902:
903: begin
904: FND_MSG_PUB.Initialize;
905: x_return_status := FND_API.G_RET_STS_SUCCESS;
906: -- Assign all values in the passed "Record" parameter to the locally defined
907: -- "Record" variable.
908: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;

Line 1007: FND_MSG_PUB.Count_And_Get

1003:
1004: EXCEPTION
1005: WHEN FND_API.G_EXC_ERROR THEN
1006: IF (x_msg_data IS NULL) THEN
1007: FND_MSG_PUB.Count_And_Get
1008: ( p_encoded => FND_API.G_FALSE
1009: , p_count => x_msg_count
1010: , p_data => x_msg_data
1011: );

Line 1017: FND_MSG_PUB.Count_And_Get

1013: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1014: x_return_status := FND_API.G_RET_STS_ERROR;
1015: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1016: IF (x_msg_data IS NULL) THEN
1017: FND_MSG_PUB.Count_And_Get
1018: ( p_encoded => FND_API.G_FALSE
1019: , p_count => x_msg_count
1020: , p_data => x_msg_data
1021: );

Line 1056: FND_MSG_PUB.Initialize;

1052: ,x_msg_data OUT NOCOPY varchar2
1053: ) is
1054:
1055: begin
1056: FND_MSG_PUB.Initialize;
1057: x_return_status := FND_API.G_RET_STS_SUCCESS;
1058: BSC_KPI_PVT.Retrieve_Kpi_Defaults( p_commit
1059: ,p_Bsc_Kpi_Entity_Rec
1060: ,x_Bsc_Kpi_Entity_Rec

Line 1123: FND_MSG_PUB.Count_And_Get

1119:
1120: EXCEPTION
1121: WHEN FND_API.G_EXC_ERROR THEN
1122: IF (x_msg_data IS NULL) THEN
1123: FND_MSG_PUB.Count_And_Get
1124: ( p_encoded => FND_API.G_FALSE
1125: , p_count => x_msg_count
1126: , p_data => x_msg_data
1127: );

Line 1133: FND_MSG_PUB.Count_And_Get

1129: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1130: x_return_status := FND_API.G_RET_STS_ERROR;
1131: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1132: IF (x_msg_data IS NULL) THEN
1133: FND_MSG_PUB.Count_And_Get
1134: ( p_encoded => FND_API.G_FALSE
1135: , p_count => x_msg_count
1136: , p_data => x_msg_data
1137: );

Line 1170: FND_MSG_PUB.Initialize;

1166: ,x_msg_count OUT NOCOPY number
1167: ,x_msg_data OUT NOCOPY varchar2
1168: ) is
1169: begin
1170: FND_MSG_PUB.Initialize;
1171: x_return_status := FND_API.G_RET_STS_SUCCESS;
1172: IF (p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Property_Code IS NOT NULL) THEN
1173: Update_Kpi_Properties( p_commit
1174: ,p_Bsc_Kpi_Entity_Rec

Line 1255: FND_MSG_PUB.Count_And_Get

1251:
1252: EXCEPTION
1253: WHEN FND_API.G_EXC_ERROR THEN
1254: IF (x_msg_data IS NULL) THEN
1255: FND_MSG_PUB.Count_And_Get
1256: ( p_encoded => FND_API.G_FALSE
1257: , p_count => x_msg_count
1258: , p_data => x_msg_data
1259: );

Line 1265: FND_MSG_PUB.Count_And_Get

1261: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1262: x_return_status := FND_API.G_RET_STS_ERROR;
1263: WHEN FND_API.G_EXC_UNEXPECTED_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 1302: FND_MSG_PUB.Initialize;

1298: )
1299: IS
1300: BEGIN
1301:
1302: FND_MSG_PUB.Initialize;
1303: x_return_status := FND_API.G_RET_STS_SUCCESS;
1304:
1305: -- Delete from BSC_KPI_MEASURE_PROPS
1306: BSC_KPI_MEASURE_PROPS_PUB.Delete_Obj_Kpi_Measure_Props (

Line 1348: FND_MSG_PUB.Count_And_Get

1344:
1345: EXCEPTION
1346: WHEN FND_API.G_EXC_ERROR THEN
1347: IF (x_msg_data IS NULL) THEN
1348: FND_MSG_PUB.Count_And_Get
1349: ( p_encoded => FND_API.G_FALSE
1350: , p_count => x_msg_count
1351: , p_data => x_msg_data
1352: );

Line 1357: FND_MSG_PUB.Count_And_Get

1353: END IF;
1354: x_return_status := FND_API.G_RET_STS_ERROR;
1355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1356: IF (x_msg_data IS NULL) THEN
1357: FND_MSG_PUB.Count_And_Get
1358: ( p_encoded => FND_API.G_FALSE
1359: , p_count => x_msg_count
1360: , p_data => x_msg_data
1361: );

Line 1393: FND_MSG_PUB.Initialize;

1389:
1390: l_count number;
1391:
1392: begin
1393: FND_MSG_PUB.Initialize;
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;
1395: BSC_KPI_PVT.Delete_Objective_Color_Data( p_commit
1396: ,p_Bsc_Kpi_Entity_Rec
1397: ,x_return_status

Line 1407: FND_MSG_PUB.Count_And_Get

1403:
1404: EXCEPTION
1405: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1406: IF (x_msg_data IS NULL) THEN
1407: FND_MSG_PUB.Count_And_Get
1408: ( p_encoded => FND_API.G_FALSE
1409: , p_count => x_msg_count
1410: , p_data => x_msg_data
1411: );

Line 1444: FND_MSG_PUB.Initialize;

1440:
1441: l_sql1 varchar2(1000);
1442: l_sql2 varchar2(1000);
1443: begin
1444: FND_MSG_PUB.Initialize;
1445: x_return_status := FND_API.G_RET_STS_SUCCESS;
1446: -- Call procedure to Delete Dimension sets and assign appropriate values to the Record.
1447: l_Bsc_Dim_Set_Rec.Bsc_Kpi_Id := p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
1448:

Line 1599: FND_MSG_PUB.Count_And_Get

1595:
1596: EXCEPTION
1597: WHEN FND_API.G_EXC_ERROR THEN
1598: IF (x_msg_data IS NULL) THEN
1599: FND_MSG_PUB.Count_And_Get
1600: ( p_encoded => FND_API.G_FALSE
1601: , p_count => x_msg_count
1602: , p_data => x_msg_data
1603: );

Line 1609: FND_MSG_PUB.Count_And_Get

1605: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1606: x_return_status := FND_API.G_RET_STS_ERROR;
1607: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1608: IF (x_msg_data IS NULL) THEN
1609: FND_MSG_PUB.Count_And_Get
1610: ( p_encoded => FND_API.G_FALSE
1611: , p_count => x_msg_count
1612: , p_data => x_msg_data
1613: );

Line 1650: FND_MSG_PUB.Initialize;

1646: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
1647: l_count NUMBER;
1648:
1649: begin
1650: FND_MSG_PUB.Initialize;
1651: x_return_status := FND_API.G_RET_STS_SUCCESS;
1652: -- Assign all values in the passed "Record" parameter to the locally defined
1653: -- "Record" variable.
1654: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;

Line 1707: FND_MSG_PUB.Count_And_Get

1703:
1704: EXCEPTION
1705: WHEN FND_API.G_EXC_ERROR THEN
1706: IF (x_msg_data IS NULL) THEN
1707: FND_MSG_PUB.Count_And_Get
1708: ( p_encoded => FND_API.G_FALSE
1709: , p_count => x_msg_count
1710: , p_data => x_msg_data
1711: );

Line 1717: FND_MSG_PUB.Count_And_Get

1713: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1714: x_return_status := FND_API.G_RET_STS_ERROR;
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1716: IF (x_msg_data IS NULL) THEN
1717: FND_MSG_PUB.Count_And_Get
1718: ( p_encoded => FND_API.G_FALSE
1719: , p_count => x_msg_count
1720: , p_data => x_msg_data
1721: );

Line 1756: FND_MSG_PUB.Initialize;

1752: ,x_msg_data OUT NOCOPY varchar2
1753: ) is
1754:
1755: begin
1756: FND_MSG_PUB.Initialize;
1757: x_return_status := FND_API.G_RET_STS_SUCCESS;
1758: BSC_KPI_PVT.Retrieve_Kpi_Properties( p_commit
1759: ,p_Bsc_Kpi_Entity_Rec
1760: ,x_Bsc_Kpi_Entity_Rec

Line 1768: FND_MSG_PUB.Count_And_Get

1764:
1765: EXCEPTION
1766: WHEN FND_API.G_EXC_ERROR THEN
1767: IF (x_msg_data IS NULL) THEN
1768: FND_MSG_PUB.Count_And_Get
1769: ( p_encoded => FND_API.G_FALSE
1770: , p_count => x_msg_count
1771: , p_data => x_msg_data
1772: );

Line 1778: FND_MSG_PUB.Count_And_Get

1774: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1775: x_return_status := FND_API.G_RET_STS_ERROR;
1776: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1777: IF (x_msg_data IS NULL) THEN
1778: FND_MSG_PUB.Count_And_Get
1779: ( p_encoded => FND_API.G_FALSE
1780: , p_count => x_msg_count
1781: , p_data => x_msg_data
1782: );

Line 1816: FND_MSG_PUB.Initialize;

1812: ,x_msg_data OUT NOCOPY varchar2
1813: ) is
1814:
1815: begin
1816: FND_MSG_PUB.Initialize;
1817: x_return_status := FND_API.G_RET_STS_SUCCESS;
1818: BSC_KPI_PVT.Update_Kpi_Properties( p_commit
1819: ,p_Bsc_Kpi_Entity_Rec
1820: ,x_return_status

Line 1827: FND_MSG_PUB.Count_And_Get

1823:
1824: EXCEPTION
1825: WHEN FND_API.G_EXC_ERROR THEN
1826: IF (x_msg_data IS NULL) THEN
1827: FND_MSG_PUB.Count_And_Get
1828: ( p_encoded => FND_API.G_FALSE
1829: , p_count => x_msg_count
1830: , p_data => x_msg_data
1831: );

Line 1837: FND_MSG_PUB.Count_And_Get

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

Line 1877: FND_MSG_PUB.Initialize;

1873:
1874: l_count number;
1875:
1876: begin
1877: FND_MSG_PUB.Initialize;
1878: x_return_status := FND_API.G_RET_STS_SUCCESS;
1879: BSC_KPI_PVT.Delete_Kpi_Properties( p_commit
1880: ,p_Bsc_Kpi_Entity_Rec
1881: ,x_return_status

Line 1889: FND_MSG_PUB.Count_And_Get

1885:
1886: EXCEPTION
1887: WHEN FND_API.G_EXC_ERROR THEN
1888: IF (x_msg_data IS NULL) THEN
1889: FND_MSG_PUB.Count_And_Get
1890: ( p_encoded => FND_API.G_FALSE
1891: , p_count => x_msg_count
1892: , p_data => x_msg_data
1893: );

Line 1899: FND_MSG_PUB.Count_And_Get

1895: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1896: x_return_status := FND_API.G_RET_STS_ERROR;
1897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1898: IF (x_msg_data IS NULL) THEN
1899: FND_MSG_PUB.Count_And_Get
1900: ( p_encoded => FND_API.G_FALSE
1901: , p_count => x_msg_count
1902: , p_data => x_msg_data
1903: );

Line 1937: FND_MSG_PUB.Initialize;

1933: ,x_msg_data OUT NOCOPY varchar2
1934: ) is
1935:
1936: begin
1937: FND_MSG_PUB.Initialize;
1938: x_return_status := FND_API.G_RET_STS_SUCCESS;
1939: -- Call private version of procedure.
1940: BSC_KPI_PVT.Create_Kpi_Analysis( p_commit
1941: ,p_Bsc_Kpi_Entity_Rec

Line 1949: FND_MSG_PUB.Count_And_Get

1945:
1946: EXCEPTION
1947: WHEN FND_API.G_EXC_ERROR THEN
1948: IF (x_msg_data IS NULL) THEN
1949: FND_MSG_PUB.Count_And_Get
1950: ( p_encoded => FND_API.G_FALSE
1951: , p_count => x_msg_count
1952: , p_data => x_msg_data
1953: );

Line 1959: FND_MSG_PUB.Count_And_Get

1955: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
1956: x_return_status := FND_API.G_RET_STS_ERROR;
1957: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1958: IF (x_msg_data IS NULL) THEN
1959: FND_MSG_PUB.Count_And_Get
1960: ( p_encoded => FND_API.G_FALSE
1961: , p_count => x_msg_count
1962: , p_data => x_msg_data
1963: );

Line 1998: FND_MSG_PUB.Initialize;

1994: ,x_msg_data OUT NOCOPY varchar2
1995: ) is
1996:
1997: begin
1998: FND_MSG_PUB.Initialize;
1999: x_return_status := FND_API.G_RET_STS_SUCCESS;
2000: BSC_KPI_PVT.Retrieve_Kpi_Analysis( p_commit
2001: ,p_Bsc_Kpi_Entity_Rec
2002: ,x_Bsc_Kpi_Entity_Rec

Line 2010: FND_MSG_PUB.Count_And_Get

2006:
2007: EXCEPTION
2008: WHEN FND_API.G_EXC_ERROR THEN
2009: IF (x_msg_data IS NULL) THEN
2010: FND_MSG_PUB.Count_And_Get
2011: ( p_encoded => FND_API.G_FALSE
2012: , p_count => x_msg_count
2013: , p_data => x_msg_data
2014: );

Line 2020: FND_MSG_PUB.Count_And_Get

2016: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2017: x_return_status := FND_API.G_RET_STS_ERROR;
2018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2019: IF (x_msg_data IS NULL) THEN
2020: FND_MSG_PUB.Count_And_Get
2021: ( p_encoded => FND_API.G_FALSE
2022: , p_count => x_msg_count
2023: , p_data => x_msg_data
2024: );

Line 2058: FND_MSG_PUB.Initialize;

2054: ,x_msg_data OUT NOCOPY varchar2
2055: ) is
2056:
2057: begin
2058: FND_MSG_PUB.Initialize;
2059: x_return_status := FND_API.G_RET_STS_SUCCESS;
2060: BSC_KPI_PVT.Update_Kpi_Analysis( p_commit
2061: ,p_Bsc_Kpi_Entity_Rec
2062: ,x_return_status

Line 2069: FND_MSG_PUB.Count_And_Get

2065:
2066: EXCEPTION
2067: WHEN FND_API.G_EXC_ERROR THEN
2068: IF (x_msg_data IS NULL) THEN
2069: FND_MSG_PUB.Count_And_Get
2070: ( p_encoded => FND_API.G_FALSE
2071: , p_count => x_msg_count
2072: , p_data => x_msg_data
2073: );

Line 2079: FND_MSG_PUB.Count_And_Get

2075: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2076: x_return_status := FND_API.G_RET_STS_ERROR;
2077: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2078: IF (x_msg_data IS NULL) THEN
2079: FND_MSG_PUB.Count_And_Get
2080: ( p_encoded => FND_API.G_FALSE
2081: , p_count => x_msg_count
2082: , p_data => x_msg_data
2083: );

Line 2119: FND_MSG_PUB.Initialize;

2115:
2116: l_count number;
2117:
2118: begin
2119: FND_MSG_PUB.Initialize;
2120: x_return_status := FND_API.G_RET_STS_SUCCESS;
2121: -- Before deleting analysis Groups/Options which will delete the KPI_Measure_Id also,
2122: -- we need to delete from KPI Measure Properties from Props, Thresholds and Weights tables.
2123: Delete_Obj_Kpi_Measure_Props (

Line 2143: FND_MSG_PUB.Count_And_Get

2139:
2140: EXCEPTION
2141: WHEN FND_API.G_EXC_ERROR THEN
2142: IF (x_msg_data IS NULL) THEN
2143: FND_MSG_PUB.Count_And_Get
2144: ( p_encoded => FND_API.G_FALSE
2145: , p_count => x_msg_count
2146: , p_data => x_msg_data
2147: );

Line 2153: FND_MSG_PUB.Count_And_Get

2149: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2150: x_return_status := FND_API.G_RET_STS_ERROR;
2151: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2152: IF (x_msg_data IS NULL) THEN
2153: FND_MSG_PUB.Count_And_Get
2154: ( p_encoded => FND_API.G_FALSE
2155: , p_count => x_msg_count
2156: , p_data => x_msg_data
2157: );

Line 2192: FND_MSG_PUB.Initialize;

2188: ) is
2189:
2190:
2191: begin
2192: FND_MSG_PUB.Initialize;
2193: x_return_status := FND_API.G_RET_STS_SUCCESS;
2194: BSC_KPI_PVT.Create_Kpi_Periodicity( p_commit
2195: ,p_Bsc_Kpi_Entity_Rec
2196: ,x_return_status

Line 2203: FND_MSG_PUB.Count_And_Get

2199:
2200: EXCEPTION
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: IF (x_msg_data IS NULL) THEN
2203: FND_MSG_PUB.Count_And_Get
2204: ( p_encoded => FND_API.G_FALSE
2205: , p_count => x_msg_count
2206: , p_data => x_msg_data
2207: );

Line 2213: FND_MSG_PUB.Count_And_Get

2209: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2210: x_return_status := FND_API.G_RET_STS_ERROR;
2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212: IF (x_msg_data IS NULL) THEN
2213: FND_MSG_PUB.Count_And_Get
2214: ( p_encoded => FND_API.G_FALSE
2215: , p_count => x_msg_count
2216: , p_data => x_msg_data
2217: );

Line 2252: FND_MSG_PUB.Initialize;

2248: ,x_msg_data OUT NOCOPY varchar2
2249: ) is
2250:
2251: begin
2252: FND_MSG_PUB.Initialize;
2253: x_return_status := FND_API.G_RET_STS_SUCCESS;
2254: BSC_KPI_PVT.Retrieve_Kpi_Periodicity( p_commit
2255: ,p_Bsc_Kpi_Entity_Rec
2256: ,x_Bsc_Kpi_Entity_Rec

Line 2264: FND_MSG_PUB.Count_And_Get

2260:
2261: EXCEPTION
2262: WHEN FND_API.G_EXC_ERROR THEN
2263: IF (x_msg_data IS NULL) THEN
2264: FND_MSG_PUB.Count_And_Get
2265: ( p_encoded => FND_API.G_FALSE
2266: , p_count => x_msg_count
2267: , p_data => x_msg_data
2268: );

Line 2274: FND_MSG_PUB.Count_And_Get

2270: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2271: x_return_status := FND_API.G_RET_STS_ERROR;
2272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2273: IF (x_msg_data IS NULL) THEN
2274: FND_MSG_PUB.Count_And_Get
2275: ( p_encoded => FND_API.G_FALSE
2276: , p_count => x_msg_count
2277: , p_data => x_msg_data
2278: );

Line 2312: FND_MSG_PUB.Initialize;

2308: ,x_msg_data OUT NOCOPY varchar2
2309: ) is
2310:
2311: begin
2312: FND_MSG_PUB.Initialize;
2313: x_return_status := FND_API.G_RET_STS_SUCCESS;
2314: BSC_KPI_PVT.Update_Kpi_Periodicity( p_commit
2315: ,p_Bsc_Kpi_Entity_Rec
2316: ,x_return_status

Line 2323: FND_MSG_PUB.Count_And_Get

2319:
2320: EXCEPTION
2321: WHEN FND_API.G_EXC_ERROR THEN
2322: IF (x_msg_data IS NULL) THEN
2323: FND_MSG_PUB.Count_And_Get
2324: ( p_encoded => FND_API.G_FALSE
2325: , p_count => x_msg_count
2326: , p_data => x_msg_data
2327: );

Line 2333: FND_MSG_PUB.Count_And_Get

2329: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2330: x_return_status := FND_API.G_RET_STS_ERROR;
2331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2332: IF (x_msg_data IS NULL) THEN
2333: FND_MSG_PUB.Count_And_Get
2334: ( p_encoded => FND_API.G_FALSE
2335: , p_count => x_msg_count
2336: , p_data => x_msg_data
2337: );

Line 2371: FND_MSG_PUB.Initialize;

2367: ,x_msg_data OUT NOCOPY varchar2
2368: ) is
2369:
2370: begin
2371: FND_MSG_PUB.Initialize;
2372: x_return_status := FND_API.G_RET_STS_SUCCESS;
2373: BSC_KPI_PVT.Delete_Kpi_Periodicity( p_commit
2374: ,p_Bsc_Kpi_Entity_Rec
2375: ,x_return_status

Line 2382: FND_MSG_PUB.Count_And_Get

2378:
2379: EXCEPTION
2380: WHEN FND_API.G_EXC_ERROR THEN
2381: IF (x_msg_data IS NULL) THEN
2382: FND_MSG_PUB.Count_And_Get
2383: ( p_encoded => FND_API.G_FALSE
2384: , p_count => x_msg_count
2385: , p_data => x_msg_data
2386: );

Line 2392: FND_MSG_PUB.Count_And_Get

2388: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2389: x_return_status := FND_API.G_RET_STS_ERROR;
2390: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2391: IF (x_msg_data IS NULL) THEN
2392: FND_MSG_PUB.Count_And_Get
2393: ( p_encoded => FND_API.G_FALSE
2394: , p_count => x_msg_count
2395: , p_data => x_msg_data
2396: );

Line 2430: FND_MSG_PUB.Initialize;

2426: ,x_msg_data OUT NOCOPY varchar2
2427: ) is
2428:
2429: begin
2430: FND_MSG_PUB.Initialize;
2431: x_return_status := FND_API.G_RET_STS_SUCCESS;
2432: BSC_KPI_PVT.Create_Kpi_Data_Tables( p_commit
2433: ,p_Bsc_Kpi_Entity_Rec
2434: ,x_return_status

Line 2441: FND_MSG_PUB.Count_And_Get

2437:
2438: EXCEPTION
2439: WHEN FND_API.G_EXC_ERROR THEN
2440: IF (x_msg_data IS NULL) THEN
2441: FND_MSG_PUB.Count_And_Get
2442: ( p_encoded => FND_API.G_FALSE
2443: , p_count => x_msg_count
2444: , p_data => x_msg_data
2445: );

Line 2451: FND_MSG_PUB.Count_And_Get

2447: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2448: x_return_status := FND_API.G_RET_STS_ERROR;
2449: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2450: IF (x_msg_data IS NULL) THEN
2451: FND_MSG_PUB.Count_And_Get
2452: ( p_encoded => FND_API.G_FALSE
2453: , p_count => x_msg_count
2454: , p_data => x_msg_data
2455: );

Line 2490: FND_MSG_PUB.Initialize;

2486: ,x_msg_data OUT NOCOPY varchar2
2487: ) is
2488:
2489: begin
2490: FND_MSG_PUB.Initialize;
2491: x_return_status := FND_API.G_RET_STS_SUCCESS;
2492: BSC_KPI_PVT.Retrieve_Kpi_Data_Tables( p_commit
2493: ,p_Bsc_Kpi_Entity_Rec
2494: ,x_Bsc_Kpi_Entity_Rec

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 2550: FND_MSG_PUB.Initialize;

2546: ,x_msg_data OUT NOCOPY varchar2
2547: ) is
2548:
2549: begin
2550: FND_MSG_PUB.Initialize;
2551: x_return_status := FND_API.G_RET_STS_SUCCESS;
2552: BSC_KPI_PVT.Update_Kpi_Data_Tables( p_commit
2553: ,p_Bsc_Kpi_Entity_Rec
2554: ,x_return_status

Line 2561: FND_MSG_PUB.Count_And_Get

2557:
2558: EXCEPTION
2559: WHEN FND_API.G_EXC_ERROR THEN
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 2571: FND_MSG_PUB.Count_And_Get

2567: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2568: x_return_status := FND_API.G_RET_STS_ERROR;
2569: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2570: IF (x_msg_data IS NULL) THEN
2571: FND_MSG_PUB.Count_And_Get
2572: ( p_encoded => FND_API.G_FALSE
2573: , p_count => x_msg_count
2574: , p_data => x_msg_data
2575: );

Line 2609: FND_MSG_PUB.Initialize;

2605: ,x_msg_data OUT NOCOPY varchar2
2606: ) is
2607:
2608: begin
2609: FND_MSG_PUB.Initialize;
2610: x_return_status := FND_API.G_RET_STS_SUCCESS;
2611: BSC_KPI_PVT.Delete_Kpi_Data_Tables( p_commit
2612: ,p_Bsc_Kpi_Entity_Rec
2613: ,x_return_status

Line 2620: FND_MSG_PUB.Count_And_Get

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

Line 2630: FND_MSG_PUB.Count_And_Get

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

Line 2670: FND_MSG_PUB.Initialize;

2666:
2667: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2668:
2669: begin
2670: FND_MSG_PUB.Initialize;
2671: x_return_status := FND_API.G_RET_STS_SUCCESS;
2672: -- Assign all values in the passed "Record" parameter to the locally defined
2673: -- "Record" variable.
2674: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;

Line 2837: FND_MSG_PUB.Count_And_Get

2833:
2834: EXCEPTION
2835: WHEN FND_API.G_EXC_ERROR THEN
2836: IF (x_msg_data IS NULL) THEN
2837: FND_MSG_PUB.Count_And_Get
2838: ( p_encoded => FND_API.G_FALSE
2839: , p_count => x_msg_count
2840: , p_data => x_msg_data
2841: );

Line 2847: FND_MSG_PUB.Count_And_Get

2843: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2844: x_return_status := FND_API.G_RET_STS_ERROR;
2845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2846: IF (x_msg_data IS NULL) THEN
2847: FND_MSG_PUB.Count_And_Get
2848: ( p_encoded => FND_API.G_FALSE
2849: , p_count => x_msg_count
2850: , p_data => x_msg_data
2851: );

Line 2886: FND_MSG_PUB.Initialize;

2882: ,x_msg_data OUT NOCOPY varchar2
2883: ) is
2884:
2885: begin
2886: FND_MSG_PUB.Initialize;
2887: x_return_status := FND_API.G_RET_STS_SUCCESS;
2888: BSC_KPI_PVT.Retrieve_Kpi_Calculations( p_commit
2889: ,p_Bsc_Kpi_Entity_Rec
2890: ,x_Bsc_Kpi_Entity_Rec

Line 2898: FND_MSG_PUB.Count_And_Get

2894:
2895: EXCEPTION
2896: WHEN FND_API.G_EXC_ERROR THEN
2897: IF (x_msg_data IS NULL) THEN
2898: FND_MSG_PUB.Count_And_Get
2899: ( p_encoded => FND_API.G_FALSE
2900: , p_count => x_msg_count
2901: , p_data => x_msg_data
2902: );

Line 2908: FND_MSG_PUB.Count_And_Get

2904: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
2905: x_return_status := FND_API.G_RET_STS_ERROR;
2906: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2907: IF (x_msg_data IS NULL) THEN
2908: FND_MSG_PUB.Count_And_Get
2909: ( p_encoded => FND_API.G_FALSE
2910: , p_count => x_msg_count
2911: , p_data => x_msg_data
2912: );

Line 2948: FND_MSG_PUB.Initialize;

2944:
2945: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
2946:
2947: begin
2948: FND_MSG_PUB.Initialize;
2949: x_return_status := FND_API.G_RET_STS_SUCCESS;
2950: -- At this point we are using default values. This should be redone.
2951:
2952: -- Assign all values in the passed "Record" parameter to the locally defined

Line 3097: FND_MSG_PUB.Count_And_Get

3093:
3094: EXCEPTION
3095: WHEN FND_API.G_EXC_ERROR THEN
3096: IF (x_msg_data IS NULL) THEN
3097: FND_MSG_PUB.Count_And_Get
3098: ( p_encoded => FND_API.G_FALSE
3099: , p_count => x_msg_count
3100: , p_data => x_msg_data
3101: );

Line 3107: FND_MSG_PUB.Count_And_Get

3103: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3104: x_return_status := FND_API.G_RET_STS_ERROR;
3105: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3106: IF (x_msg_data IS NULL) THEN
3107: FND_MSG_PUB.Count_And_Get
3108: ( p_encoded => FND_API.G_FALSE
3109: , p_count => x_msg_count
3110: , p_data => x_msg_data
3111: );

Line 3146: FND_MSG_PUB.Initialize;

3142: ,x_msg_data OUT NOCOPY varchar2
3143: ) is
3144:
3145: begin
3146: FND_MSG_PUB.Initialize;
3147: x_return_status := FND_API.G_RET_STS_SUCCESS;
3148: BSC_KPI_PVT.Delete_Kpi_Calculations( p_commit
3149: ,p_Bsc_Kpi_Entity_Rec
3150: ,x_return_status

Line 3157: FND_MSG_PUB.Count_And_Get

3153:
3154: EXCEPTION
3155: WHEN FND_API.G_EXC_ERROR THEN
3156: IF (x_msg_data IS NULL) THEN
3157: FND_MSG_PUB.Count_And_Get
3158: ( p_encoded => FND_API.G_FALSE
3159: , p_count => x_msg_count
3160: , p_data => x_msg_data
3161: );

Line 3167: FND_MSG_PUB.Count_And_Get

3163: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3164: x_return_status := FND_API.G_RET_STS_ERROR;
3165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3166: IF (x_msg_data IS NULL) THEN
3167: FND_MSG_PUB.Count_And_Get
3168: ( p_encoded => FND_API.G_FALSE
3169: , p_count => x_msg_count
3170: , p_data => x_msg_data
3171: );

Line 3217: FND_MSG_PUB.Initialize;

3213: FROM fnd_responsibility
3214: WHERE INSTR(','||p_Comma_Sep_Resposibility_Key||',',','||responsibility_key||',') > 0;
3215:
3216: BEGIN
3217: FND_MSG_PUB.Initialize;
3218: x_return_status := FND_API.G_RET_STS_SUCCESS;
3219: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
3220:
3221: FOR CD IN c_Resp_Ids LOOP

Line 3248: FND_MSG_PUB.Count_And_Get

3244:
3245: EXCEPTION
3246: WHEN FND_API.G_EXC_ERROR THEN
3247: IF (x_msg_data IS NULL) THEN
3248: FND_MSG_PUB.Count_And_Get
3249: ( p_encoded => FND_API.G_FALSE
3250: , p_count => x_msg_count
3251: , p_data => x_msg_data
3252: );

Line 3258: FND_MSG_PUB.Count_And_Get

3254: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3255: x_return_status := FND_API.G_RET_STS_ERROR;
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: IF (x_msg_data IS NULL) THEN
3258: FND_MSG_PUB.Count_And_Get
3259: ( p_encoded => FND_API.G_FALSE
3260: , p_count => x_msg_count
3261: , p_data => x_msg_data
3262: );

Line 3298: FND_MSG_PUB.Initialize;

3294: l_Kpi_Short_Name BSC_KPIS_B.SHORT_NAME%TYPE;
3295: l_Comma_Sep_Resp_Key VARCHAR2(32000):= NULL;
3296:
3297: BEGIN
3298: FND_MSG_PUB.Initialize;
3299: x_return_status := FND_API.G_RET_STS_SUCCESS;
3300: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
3301:
3302: BEGIN

Line 3347: FND_MSG_PUB.Count_And_Get

3343:
3344: EXCEPTION
3345: WHEN FND_API.G_EXC_ERROR THEN
3346: IF (x_msg_data IS NULL) THEN
3347: FND_MSG_PUB.Count_And_Get
3348: ( p_encoded => FND_API.G_FALSE
3349: , p_count => x_msg_count
3350: , p_data => x_msg_data
3351: );

Line 3357: FND_MSG_PUB.Count_And_Get

3353: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3354: x_return_status := FND_API.G_RET_STS_ERROR;
3355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3356: IF (x_msg_data IS NULL) THEN
3357: FND_MSG_PUB.Count_And_Get
3358: ( p_encoded => FND_API.G_FALSE
3359: , p_count => x_msg_count
3360: , p_data => x_msg_data
3361: );

Line 3396: FND_MSG_PUB.Initialize;

3392: ,x_msg_data OUT NOCOPY varchar2
3393: ) is
3394:
3395: begin
3396: FND_MSG_PUB.Initialize;
3397: x_return_status := FND_API.G_RET_STS_SUCCESS;
3398: BSC_KPI_PVT.Retrieve_Kpi_User_Access( p_commit
3399: ,p_Bsc_Kpi_Entity_Rec
3400: ,x_Bsc_Kpi_Entity_Rec

Line 3408: FND_MSG_PUB.Count_And_Get

3404:
3405: EXCEPTION
3406: WHEN FND_API.G_EXC_ERROR THEN
3407: IF (x_msg_data IS NULL) THEN
3408: FND_MSG_PUB.Count_And_Get
3409: ( p_encoded => FND_API.G_FALSE
3410: , p_count => x_msg_count
3411: , p_data => x_msg_data
3412: );

Line 3418: FND_MSG_PUB.Count_And_Get

3414: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3415: x_return_status := FND_API.G_RET_STS_ERROR;
3416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3417: IF (x_msg_data IS NULL) THEN
3418: FND_MSG_PUB.Count_And_Get
3419: ( p_encoded => FND_API.G_FALSE
3420: , p_count => x_msg_count
3421: , p_data => x_msg_data
3422: );

Line 3456: FND_MSG_PUB.Initialize;

3452: ,x_msg_data OUT NOCOPY varchar2
3453: ) is
3454:
3455: begin
3456: FND_MSG_PUB.Initialize;
3457: x_return_status := FND_API.G_RET_STS_SUCCESS;
3458: BSC_KPI_PVT.Update_Kpi_User_Access( p_commit
3459: ,p_Bsc_Kpi_Entity_Rec
3460: ,x_return_status

Line 3467: FND_MSG_PUB.Count_And_Get

3463:
3464: EXCEPTION
3465: WHEN FND_API.G_EXC_ERROR THEN
3466: IF (x_msg_data IS NULL) THEN
3467: FND_MSG_PUB.Count_And_Get
3468: ( p_encoded => FND_API.G_FALSE
3469: , p_count => x_msg_count
3470: , p_data => x_msg_data
3471: );

Line 3477: FND_MSG_PUB.Count_And_Get

3473: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3474: x_return_status := FND_API.G_RET_STS_ERROR;
3475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3476: IF (x_msg_data IS NULL) THEN
3477: FND_MSG_PUB.Count_And_Get
3478: ( p_encoded => FND_API.G_FALSE
3479: , p_count => x_msg_count
3480: , p_data => x_msg_data
3481: );

Line 3515: FND_MSG_PUB.Initialize;

3511: ,x_msg_data OUT NOCOPY varchar2
3512: ) is
3513:
3514: begin
3515: FND_MSG_PUB.Initialize;
3516: x_return_status := FND_API.G_RET_STS_SUCCESS;
3517: BSC_KPI_PVT.Delete_Kpi_User_Access( p_commit
3518: ,p_Bsc_Kpi_Entity_Rec
3519: ,x_return_status

Line 3526: FND_MSG_PUB.Count_And_Get

3522:
3523: EXCEPTION
3524: WHEN FND_API.G_EXC_ERROR THEN
3525: IF (x_msg_data IS NULL) THEN
3526: FND_MSG_PUB.Count_And_Get
3527: ( p_encoded => FND_API.G_FALSE
3528: , p_count => x_msg_count
3529: , p_data => x_msg_data
3530: );

Line 3536: FND_MSG_PUB.Count_And_Get

3532: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3533: x_return_status := FND_API.G_RET_STS_ERROR;
3534: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3535: IF (x_msg_data IS NULL) THEN
3536: FND_MSG_PUB.Count_And_Get
3537: ( p_encoded => FND_API.G_FALSE
3538: , p_count => x_msg_count
3539: , p_data => x_msg_data
3540: );

Line 3578: FND_MSG_PUB.Initialize;

3574:
3575: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
3576:
3577: begin
3578: FND_MSG_PUB.Initialize;
3579: x_return_status := FND_API.G_RET_STS_SUCCESS;
3580: -- set the local record equal to the passed record.
3581: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
3582:

Line 3632: FND_MSG_PUB.Count_And_Get

3628:
3629: EXCEPTION
3630: WHEN FND_API.G_EXC_ERROR THEN
3631: IF (x_msg_data IS NULL) THEN
3632: FND_MSG_PUB.Count_And_Get
3633: ( p_encoded => FND_API.G_FALSE
3634: , p_count => x_msg_count
3635: , p_data => x_msg_data
3636: );

Line 3642: FND_MSG_PUB.Count_And_Get

3638: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3639: x_return_status := FND_API.G_RET_STS_ERROR;
3640: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3641: IF (x_msg_data IS NULL) THEN
3642: FND_MSG_PUB.Count_And_Get
3643: ( p_encoded => FND_API.G_FALSE
3644: , p_count => x_msg_count
3645: , p_data => x_msg_data
3646: );

Line 3681: FND_MSG_PUB.Initialize;

3677: ,x_msg_data OUT NOCOPY varchar2
3678: ) is
3679:
3680: begin
3681: FND_MSG_PUB.Initialize;
3682: x_return_status := FND_API.G_RET_STS_SUCCESS;
3683: BSC_KPI_PVT.Retrieve_Kpi_Default_Values( p_commit
3684: ,p_Bsc_Kpi_Entity_Rec
3685: ,x_Bsc_Kpi_Entity_Rec

Line 3693: FND_MSG_PUB.Count_And_Get

3689:
3690: EXCEPTION
3691: WHEN FND_API.G_EXC_ERROR THEN
3692: IF (x_msg_data IS NULL) THEN
3693: FND_MSG_PUB.Count_And_Get
3694: ( p_encoded => FND_API.G_FALSE
3695: , p_count => x_msg_count
3696: , p_data => x_msg_data
3697: );

Line 3703: FND_MSG_PUB.Count_And_Get

3699: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3700: x_return_status := FND_API.G_RET_STS_ERROR;
3701: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3702: IF (x_msg_data IS NULL) THEN
3703: FND_MSG_PUB.Count_And_Get
3704: ( p_encoded => FND_API.G_FALSE
3705: , p_count => x_msg_count
3706: , p_data => x_msg_data
3707: );

Line 3742: FND_MSG_PUB.Initialize;

3738: ,x_msg_data OUT NOCOPY varchar2
3739: ) is
3740:
3741: begin
3742: FND_MSG_PUB.Initialize;
3743: x_return_status := FND_API.G_RET_STS_SUCCESS;
3744: BSC_KPI_PVT.Update_Kpi_Default_Values( p_commit
3745: ,p_Bsc_Kpi_Entity_Rec
3746: ,x_return_status

Line 3753: FND_MSG_PUB.Count_And_Get

3749:
3750: EXCEPTION
3751: WHEN FND_API.G_EXC_ERROR THEN
3752: IF (x_msg_data IS NULL) THEN
3753: FND_MSG_PUB.Count_And_Get
3754: ( p_encoded => FND_API.G_FALSE
3755: , p_count => x_msg_count
3756: , p_data => x_msg_data
3757: );

Line 3763: FND_MSG_PUB.Count_And_Get

3759: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3760: x_return_status := FND_API.G_RET_STS_ERROR;
3761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3762: IF (x_msg_data IS NULL) THEN
3763: FND_MSG_PUB.Count_And_Get
3764: ( p_encoded => FND_API.G_FALSE
3765: , p_count => x_msg_count
3766: , p_data => x_msg_data
3767: );

Line 3802: FND_MSG_PUB.Initialize;

3798: ,x_msg_data OUT NOCOPY varchar2
3799: ) is
3800:
3801: begin
3802: FND_MSG_PUB.Initialize;
3803: x_return_status := FND_API.G_RET_STS_SUCCESS;
3804: BSC_KPI_PVT.Delete_Kpi_Default_Values( p_commit
3805: ,p_Bsc_Kpi_Entity_Rec
3806: ,x_return_status

Line 3814: FND_MSG_PUB.Count_And_Get

3810:
3811: EXCEPTION
3812: WHEN FND_API.G_EXC_ERROR THEN
3813: IF (x_msg_data IS NULL) THEN
3814: FND_MSG_PUB.Count_And_Get
3815: ( p_encoded => FND_API.G_FALSE
3816: , p_count => x_msg_count
3817: , p_data => x_msg_data
3818: );

Line 3824: FND_MSG_PUB.Count_And_Get

3820: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3821: x_return_status := FND_API.G_RET_STS_ERROR;
3822: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3823: IF (x_msg_data IS NULL) THEN
3824: FND_MSG_PUB.Count_And_Get
3825: ( p_encoded => FND_API.G_FALSE
3826: , p_count => x_msg_count
3827: , p_data => x_msg_data
3828: );

Line 3867: FND_MSG_PUB.Initialize;

3863: ,x_msg_data OUT NOCOPY varchar2
3864: ) is
3865:
3866: begin
3867: FND_MSG_PUB.Initialize;
3868: x_return_status := FND_API.G_RET_STS_SUCCESS;
3869: BSC_KPI_PVT.Create_Kpi_In_Tab( p_commit
3870: ,p_Bsc_Kpi_Entity_Rec
3871: ,x_return_status

Line 3879: FND_MSG_PUB.Count_And_Get

3875:
3876: EXCEPTION
3877: WHEN FND_API.G_EXC_ERROR THEN
3878: IF (x_msg_data IS NULL) THEN
3879: FND_MSG_PUB.Count_And_Get
3880: ( p_encoded => FND_API.G_FALSE
3881: , p_count => x_msg_count
3882: , p_data => x_msg_data
3883: );

Line 3889: FND_MSG_PUB.Count_And_Get

3885: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3886: x_return_status := FND_API.G_RET_STS_ERROR;
3887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3888: IF (x_msg_data IS NULL) THEN
3889: FND_MSG_PUB.Count_And_Get
3890: ( p_encoded => FND_API.G_FALSE
3891: , p_count => x_msg_count
3892: , p_data => x_msg_data
3893: );

Line 3929: FND_MSG_PUB.Initialize;

3925: ,x_msg_data OUT NOCOPY varchar2
3926: ) is
3927:
3928: begin
3929: FND_MSG_PUB.Initialize;
3930: x_return_status := FND_API.G_RET_STS_SUCCESS;
3931: BSC_KPI_PVT.Retrieve_Kpi_In_Tab( p_commit
3932: ,p_Bsc_Kpi_Entity_Rec
3933: ,x_Bsc_Kpi_Entity_Rec

Line 3941: FND_MSG_PUB.Count_And_Get

3937:
3938: EXCEPTION
3939: WHEN FND_API.G_EXC_ERROR THEN
3940: IF (x_msg_data IS NULL) THEN
3941: FND_MSG_PUB.Count_And_Get
3942: ( p_encoded => FND_API.G_FALSE
3943: , p_count => x_msg_count
3944: , p_data => x_msg_data
3945: );

Line 3951: FND_MSG_PUB.Count_And_Get

3947: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
3948: x_return_status := FND_API.G_RET_STS_ERROR;
3949: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3950: IF (x_msg_data IS NULL) THEN
3951: FND_MSG_PUB.Count_And_Get
3952: ( p_encoded => FND_API.G_FALSE
3953: , p_count => x_msg_count
3954: , p_data => x_msg_data
3955: );

Line 4000: FND_MSG_PUB.Initialize;

3996: if l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level_Id is null then
3997: l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Dim_Level_Id := 0;
3998: end if;
3999: */
4000: FND_MSG_PUB.Initialize;
4001: x_return_status := FND_API.G_RET_STS_SUCCESS;
4002: BSC_KPI_PVT.Update_Kpi_In_Tab( p_commit
4003: ,p_Bsc_Kpi_Entity_Rec
4004: ,x_return_status

Line 4011: FND_MSG_PUB.Count_And_Get

4007:
4008: EXCEPTION
4009: WHEN FND_API.G_EXC_ERROR THEN
4010: IF (x_msg_data IS NULL) THEN
4011: FND_MSG_PUB.Count_And_Get
4012: ( p_encoded => FND_API.G_FALSE
4013: , p_count => x_msg_count
4014: , p_data => x_msg_data
4015: );

Line 4021: FND_MSG_PUB.Count_And_Get

4017: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4018: x_return_status := FND_API.G_RET_STS_ERROR;
4019: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4020: IF (x_msg_data IS NULL) THEN
4021: FND_MSG_PUB.Count_And_Get
4022: ( p_encoded => FND_API.G_FALSE
4023: , p_count => x_msg_count
4024: , p_data => x_msg_data
4025: );

Line 4060: FND_MSG_PUB.Initialize;

4056: ,x_msg_data OUT NOCOPY varchar2
4057: ) is
4058:
4059: begin
4060: FND_MSG_PUB.Initialize;
4061: x_return_status := FND_API.G_RET_STS_SUCCESS;
4062: BSC_KPI_PVT.Delete_Kpi_In_Tab( p_commit
4063: ,p_Bsc_Kpi_Entity_Rec
4064: ,x_return_status

Line 4072: FND_MSG_PUB.Count_And_Get

4068:
4069: EXCEPTION
4070: WHEN FND_API.G_EXC_ERROR THEN
4071: IF (x_msg_data IS NULL) THEN
4072: FND_MSG_PUB.Count_And_Get
4073: ( p_encoded => FND_API.G_FALSE
4074: , p_count => x_msg_count
4075: , p_data => x_msg_data
4076: );

Line 4082: FND_MSG_PUB.Count_And_Get

4078: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4079: x_return_status := FND_API.G_RET_STS_ERROR;
4080: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4081: IF (x_msg_data IS NULL) THEN
4082: FND_MSG_PUB.Count_And_Get
4083: ( p_encoded => FND_API.G_FALSE
4084: , p_count => x_msg_count
4085: , p_data => x_msg_data
4086: );

Line 4121: FND_MSG_PUB.Initialize;

4117: ,x_msg_data OUT NOCOPY varchar2
4118: ) is
4119:
4120: begin
4121: FND_MSG_PUB.Initialize;
4122: x_return_status := FND_API.G_RET_STS_SUCCESS;
4123: BSC_KPI_PVT.Update_Kpi_Time_Stamp( p_commit
4124: ,p_Bsc_Kpi_Entity_Rec
4125: ,x_return_status

Line 4132: FND_MSG_PUB.Count_And_Get

4128:
4129: EXCEPTION
4130: WHEN FND_API.G_EXC_ERROR THEN
4131: IF (x_msg_data IS NULL) THEN
4132: FND_MSG_PUB.Count_And_Get
4133: ( p_encoded => FND_API.G_FALSE
4134: , p_count => x_msg_count
4135: , p_data => x_msg_data
4136: );

Line 4142: FND_MSG_PUB.Count_And_Get

4138: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4139: x_return_status := FND_API.G_RET_STS_ERROR;
4140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4141: IF (x_msg_data IS NULL) THEN
4142: FND_MSG_PUB.Count_And_Get
4143: ( p_encoded => FND_API.G_FALSE
4144: , p_count => x_msg_count
4145: , p_data => x_msg_data
4146: );

Line 4181: FND_MSG_PUB.Initialize;

4177: ,x_msg_data OUT NOCOPY varchar2
4178: ) is
4179:
4180: begin
4181: FND_MSG_PUB.Initialize;
4182: x_return_status := FND_API.G_RET_STS_SUCCESS;
4183: BSC_KPI_PVT.Create_Master_Kpi( p_commit
4184: ,p_Bsc_Kpi_Entity_Rec
4185: ,x_return_status

Line 4192: FND_MSG_PUB.Count_And_Get

4188:
4189: EXCEPTION
4190: WHEN FND_API.G_EXC_ERROR THEN
4191: IF (x_msg_data IS NULL) THEN
4192: FND_MSG_PUB.Count_And_Get
4193: ( p_encoded => FND_API.G_FALSE
4194: , p_count => x_msg_count
4195: , p_data => x_msg_data
4196: );

Line 4202: FND_MSG_PUB.Count_And_Get

4198: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4199: x_return_status := FND_API.G_RET_STS_ERROR;
4200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4201: IF (x_msg_data IS NULL) THEN
4202: FND_MSG_PUB.Count_And_Get
4203: ( p_encoded => FND_API.G_FALSE
4204: , p_count => x_msg_count
4205: , p_data => x_msg_data
4206: );

Line 4243: FND_MSG_PUB.Initialize;

4239:
4240: l_Bsc_Kpi_Entity_Rec BSC_KPI_PUB.Bsc_Kpi_Entity_Rec;
4241:
4242: begin
4243: FND_MSG_PUB.Initialize;
4244: x_return_status := FND_API.G_RET_STS_SUCCESS;
4245: l_Bsc_Kpi_Entity_Rec := p_Bsc_Kpi_Entity_Rec;
4246:
4247: if p_Bsc_Kpi_Entity_Rec.Bsc_Language is null then

Line 4267: FND_MSG_PUB.Count_And_Get

4263:
4264: EXCEPTION
4265: WHEN FND_API.G_EXC_ERROR THEN
4266: IF (x_msg_data IS NULL) THEN
4267: FND_MSG_PUB.Count_And_Get
4268: ( p_encoded => FND_API.G_FALSE
4269: , p_count => x_msg_count
4270: , p_data => x_msg_data
4271: );

Line 4277: FND_MSG_PUB.Count_And_Get

4273: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4274: x_return_status := FND_API.G_RET_STS_ERROR;
4275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4276: IF (x_msg_data IS NULL) THEN
4277: FND_MSG_PUB.Count_And_Get
4278: ( p_encoded => FND_API.G_FALSE
4279: , p_count => x_msg_count
4280: , p_data => x_msg_data
4281: );

Line 4316: FND_MSG_PUB.Initialize;

4312: ,x_msg_data OUT NOCOPY varchar2
4313: ) is
4314:
4315: begin
4316: FND_MSG_PUB.Initialize;
4317: x_return_status := FND_API.G_RET_STS_SUCCESS;
4318: BSC_KPI_PVT.Set_Default_Option( p_commit
4319: ,p_Bsc_Kpi_Entity_Rec
4320: ,x_return_status

Line 4328: FND_MSG_PUB.Count_And_Get

4324:
4325: EXCEPTION
4326: WHEN FND_API.G_EXC_ERROR THEN
4327: IF (x_msg_data IS NULL) THEN
4328: FND_MSG_PUB.Count_And_Get
4329: ( p_encoded => FND_API.G_FALSE
4330: , p_count => x_msg_count
4331: , p_data => x_msg_data
4332: );

Line 4338: FND_MSG_PUB.Count_And_Get

4334: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4335: x_return_status := FND_API.G_RET_STS_ERROR;
4336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4337: IF (x_msg_data IS NULL) THEN
4338: FND_MSG_PUB.Count_And_Get
4339: ( p_encoded => FND_API.G_FALSE
4340: , p_count => x_msg_count
4341: , p_data => x_msg_data
4342: );

Line 4377: FND_MSG_PUB.Initialize;

4373: ,x_msg_data OUT NOCOPY varchar2
4374: ) is
4375:
4376: begin
4377: FND_MSG_PUB.Initialize;
4378: x_return_status := FND_API.G_RET_STS_SUCCESS;
4379: BSC_KPI_PUB.Set_Default_Option_MG( p_commit
4380: ,p_Bsc_Kpi_Entity_Rec
4381: ,x_return_status

Line 4388: FND_MSG_PUB.Count_And_Get

4384:
4385: EXCEPTION
4386: WHEN FND_API.G_EXC_ERROR THEN
4387: IF (x_msg_data IS NULL) THEN
4388: FND_MSG_PUB.Count_And_Get
4389: ( p_encoded => FND_API.G_FALSE
4390: , p_count => x_msg_count
4391: , p_data => x_msg_data
4392: );

Line 4398: FND_MSG_PUB.Count_And_Get

4394: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4395: x_return_status := FND_API.G_RET_STS_ERROR;
4396: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4397: IF (x_msg_data IS NULL) THEN
4398: FND_MSG_PUB.Count_And_Get
4399: ( p_encoded => FND_API.G_FALSE
4400: , p_count => x_msg_count
4401: , p_data => x_msg_data
4402: );

Line 4435: FND_MSG_PUB.Initialize;

4431: ,x_msg_data OUT NOCOPY varchar2
4432: ) IS
4433:
4434: Begin
4435: FND_MSG_PUB.Initialize;
4436: x_return_status := FND_API.G_RET_STS_SUCCESS;
4437: BSC_KPI_PVT.Assign_Analysis_Option(
4438: p_Bsc_kpi_Entity_Rec
4439: ,x_return_status

Line 4446: FND_MSG_PUB.Count_And_Get

4442:
4443: EXCEPTION
4444: WHEN FND_API.G_EXC_ERROR THEN
4445: IF (x_msg_data IS NULL) THEN
4446: FND_MSG_PUB.Count_And_Get
4447: ( p_encoded => FND_API.G_FALSE
4448: , p_count => x_msg_count
4449: , p_data => x_msg_data
4450: );

Line 4456: FND_MSG_PUB.Count_And_Get

4452: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4453: x_return_status := FND_API.G_RET_STS_ERROR;
4454: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4455: IF (x_msg_data IS NULL) THEN
4456: FND_MSG_PUB.Count_And_Get
4457: ( p_encoded => FND_API.G_FALSE
4458: , p_count => x_msg_count
4459: , p_data => x_msg_data
4460: );

Line 4494: FND_MSG_PUB.Initialize;

4490: ,x_msg_data OUT NOCOPY varchar2
4491: ) IS
4492:
4493: Begin
4494: FND_MSG_PUB.Initialize;
4495: x_return_status := FND_API.G_RET_STS_SUCCESS;
4496: BSC_KPI_PVT.Unassign_Analysis_Option(
4497: p_Bsc_kpi_Entity_Rec
4498: ,x_return_status

Line 4505: FND_MSG_PUB.Count_And_Get

4501:
4502: EXCEPTION
4503: WHEN FND_API.G_EXC_ERROR THEN
4504: IF (x_msg_data IS NULL) THEN
4505: FND_MSG_PUB.Count_And_Get
4506: ( p_encoded => FND_API.G_FALSE
4507: , p_count => x_msg_count
4508: , p_data => x_msg_data
4509: );

Line 4515: FND_MSG_PUB.Count_And_Get

4511: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4512: x_return_status := FND_API.G_RET_STS_ERROR;
4513: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4514: IF (x_msg_data IS NULL) THEN
4515: FND_MSG_PUB.Count_And_Get
4516: ( p_encoded => FND_API.G_FALSE
4517: , p_count => x_msg_count
4518: , p_data => x_msg_data
4519: );

Line 4554: FND_MSG_PUB.Initialize;

4550: ,x_msg_data OUT NOCOPY varchar2
4551: ) return varchar2 IS
4552: l_temp varchar2(5);
4553: Begin
4554: FND_MSG_PUB.Initialize;
4555: x_return_status := FND_API.G_RET_STS_SUCCESS;
4556: l_temp := BSC_KPI_PVT.Is_Analysis_Option_Selected(
4557: p_Bsc_kpi_Entity_Rec
4558: ,x_return_status

Line 4566: FND_MSG_PUB.Count_And_Get

4562:
4563: EXCEPTION
4564: WHEN FND_API.G_EXC_ERROR THEN
4565: IF (x_msg_data IS NULL) THEN
4566: FND_MSG_PUB.Count_And_Get
4567: ( p_encoded => FND_API.G_FALSE
4568: , p_count => x_msg_count
4569: , p_data => x_msg_data
4570: );

Line 4576: FND_MSG_PUB.Count_And_Get

4572: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4573: x_return_status := FND_API.G_RET_STS_ERROR;
4574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4575: IF (x_msg_data IS NULL) THEN
4576: FND_MSG_PUB.Count_And_Get
4577: ( p_encoded => FND_API.G_FALSE
4578: , p_count => x_msg_count
4579: , p_data => x_msg_data
4580: );

Line 4614: FND_MSG_PUB.Initialize;

4610: ,x_msg_data OUT NOCOPY varchar2
4611: ) return varchar2 IS
4612: l_temp varchar2(5);
4613: Begin
4614: FND_MSG_PUB.Initialize;
4615: x_return_status := FND_API.G_RET_STS_SUCCESS;
4616: --DBMS_OUTPUT.PUT_LINE('Begin BSC_KPI_PUB.Is_Leaf_Analysis_Option ');
4617:
4618: l_temp := BSC_KPI_PVT.Is_Leaf_Analysis_Option(

Line 4631: FND_MSG_PUB.Count_And_Get

4627:
4628: EXCEPTION
4629: WHEN FND_API.G_EXC_ERROR THEN
4630: IF (x_msg_data IS NULL) THEN
4631: FND_MSG_PUB.Count_And_Get
4632: ( p_encoded => FND_API.G_FALSE
4633: , p_count => x_msg_count
4634: , p_data => x_msg_data
4635: );

Line 4641: FND_MSG_PUB.Count_And_Get

4637: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4638: x_return_status := FND_API.G_RET_STS_ERROR;
4639: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4640: IF (x_msg_data IS NULL) THEN
4641: FND_MSG_PUB.Count_And_Get
4642: ( p_encoded => FND_API.G_FALSE
4643: , p_count => x_msg_count
4644: , p_data => x_msg_data
4645: );

Line 4728: FND_MSG_PUB.Initialize;

4724: FROM bsc_kpi_dim_levels_b
4725: WHERE indicator = l_share_kpi;
4726:
4727: begin
4728: FND_MSG_PUB.Initialize;
4729: x_return_status := FND_API.G_RET_STS_SUCCESS;
4730: l_commit := FND_API.G_TRUE;
4731: l_master_kpi := p_master_kpi;
4732:

Line 4854: FND_MSG_PUB.Initialize;

4850: , x_msg_data OUT NOCOPY VARCHAR2
4851:
4852: )IS
4853: BEGIN
4854: FND_MSG_PUB.Initialize;
4855: x_return_status := FND_API.G_RET_STS_SUCCESS;
4856:
4857: BSC_KPI_PUB.Delete_Ind_User_Access
4858: (

Line 4980: FND_MSG_PUB.Count_And_Get

4976:
4977: EXCEPTION
4978: WHEN FND_API.G_EXC_ERROR THEN
4979: IF (x_msg_data IS NULL) THEN
4980: FND_MSG_PUB.Count_And_Get
4981: ( p_encoded => FND_API.G_FALSE
4982: , p_count => x_msg_count
4983: , p_data => x_msg_data
4984: );

Line 4990: FND_MSG_PUB.Count_And_Get

4986: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
4987: x_return_status := FND_API.G_RET_STS_ERROR;
4988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4989: IF (x_msg_data IS NULL) THEN
4990: FND_MSG_PUB.Count_And_Get
4991: ( p_encoded => FND_API.G_FALSE
4992: , p_count => x_msg_count
4993: , p_data => x_msg_data
4994: );

Line 5033: FND_MSG_PUB.Initialize;

5029: ) IS
5030: l_count NUMBER;
5031:
5032: BEGIN
5033: FND_MSG_PUB.Initialize;
5034: x_return_status := FND_API.G_RET_STS_SUCCESS;
5035:
5036: BSC_KPI_PVT.Delete_Ind_Cause_Effect_Rels
5037: (

Line 5048: FND_MSG_PUB.Count_And_Get

5044:
5045: EXCEPTION
5046: WHEN FND_API.G_EXC_ERROR THEN
5047: IF (x_msg_data IS NULL) THEN
5048: FND_MSG_PUB.Count_And_Get
5049: ( p_encoded => FND_API.G_FALSE
5050: , p_count => x_msg_count
5051: , p_data => x_msg_data
5052: );

Line 5058: FND_MSG_PUB.Count_And_Get

5054: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5055: x_return_status := FND_API.G_RET_STS_ERROR;
5056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5057: IF (x_msg_data IS NULL) THEN
5058: FND_MSG_PUB.Count_And_Get
5059: ( p_encoded => FND_API.G_FALSE
5060: , p_count => x_msg_count
5061: , p_data => x_msg_data
5062: );

Line 5101: FND_MSG_PUB.Initialize;

5097: ) IS
5098: l_count NUMBER;
5099:
5100: BEGIN
5101: FND_MSG_PUB.Initialize;
5102: x_return_status := FND_API.G_RET_STS_SUCCESS;
5103:
5104: BSC_KPI_PVT.Delete_Ind_Shell_Cmds
5105: (

Line 5116: FND_MSG_PUB.Count_And_Get

5112:
5113: EXCEPTION
5114: WHEN FND_API.G_EXC_ERROR THEN
5115: IF (x_msg_data IS NULL) THEN
5116: FND_MSG_PUB.Count_And_Get
5117: ( p_encoded => FND_API.G_FALSE
5118: , p_count => x_msg_count
5119: , p_data => x_msg_data
5120: );

Line 5126: FND_MSG_PUB.Count_And_Get

5122: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5123: x_return_status := FND_API.G_RET_STS_ERROR;
5124: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5125: IF (x_msg_data IS NULL) THEN
5126: FND_MSG_PUB.Count_And_Get
5127: ( p_encoded => FND_API.G_FALSE
5128: , p_count => x_msg_count
5129: , p_data => x_msg_data
5130: );

Line 5169: FND_MSG_PUB.Initialize;

5165: ) IS
5166: l_count NUMBER;
5167:
5168: BEGIN
5169: FND_MSG_PUB.Initialize;
5170: x_return_status := FND_API.G_RET_STS_SUCCESS;
5171:
5172: BSC_KPI_PVT.Delete_Ind_MM_Controls
5173: (

Line 5184: FND_MSG_PUB.Count_And_Get

5180:
5181: EXCEPTION
5182: WHEN FND_API.G_EXC_ERROR THEN
5183: IF (x_msg_data IS NULL) THEN
5184: FND_MSG_PUB.Count_And_Get
5185: ( p_encoded => FND_API.G_FALSE
5186: , p_count => x_msg_count
5187: , p_data => x_msg_data
5188: );

Line 5194: FND_MSG_PUB.Count_And_Get

5190: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5191: x_return_status := FND_API.G_RET_STS_ERROR;
5192: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5193: IF (x_msg_data IS NULL) THEN
5194: FND_MSG_PUB.Count_And_Get
5195: ( p_encoded => FND_API.G_FALSE
5196: , p_count => x_msg_count
5197: , p_data => x_msg_data
5198: );

Line 5236: FND_MSG_PUB.Initialize;

5232: ) IS
5233: l_count NUMBER;
5234:
5235: BEGIN
5236: FND_MSG_PUB.Initialize;
5237: x_return_status := FND_API.G_RET_STS_SUCCESS;
5238:
5239: BSC_KPI_PVT.Delete_Ind_Subtitles
5240: (

Line 5251: FND_MSG_PUB.Count_And_Get

5247:
5248: EXCEPTION
5249: WHEN FND_API.G_EXC_ERROR THEN
5250: IF (x_msg_data IS NULL) THEN
5251: FND_MSG_PUB.Count_And_Get
5252: ( p_encoded => FND_API.G_FALSE
5253: , p_count => x_msg_count
5254: , p_data => x_msg_data
5255: );

Line 5261: FND_MSG_PUB.Count_And_Get

5257: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5258: x_return_status := FND_API.G_RET_STS_ERROR;
5259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5260: IF (x_msg_data IS NULL) THEN
5261: FND_MSG_PUB.Count_And_Get
5262: ( p_encoded => FND_API.G_FALSE
5263: , p_count => x_msg_count
5264: , p_data => x_msg_data
5265: );

Line 5303: FND_MSG_PUB.Initialize;

5299: ) IS
5300: l_count NUMBER;
5301:
5302: BEGIN
5303: FND_MSG_PUB.Initialize;
5304: x_return_status := FND_API.G_RET_STS_SUCCESS;
5305:
5306: BSC_KPI_PVT.Delete_Ind_SeriesColors
5307: (

Line 5318: FND_MSG_PUB.Count_And_Get

5314:
5315: EXCEPTION
5316: WHEN FND_API.G_EXC_ERROR THEN
5317: IF (x_msg_data IS NULL) THEN
5318: FND_MSG_PUB.Count_And_Get
5319: ( p_encoded => FND_API.G_FALSE
5320: , p_count => x_msg_count
5321: , p_data => x_msg_data
5322: );

Line 5328: FND_MSG_PUB.Count_And_Get

5324: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5325: x_return_status := FND_API.G_RET_STS_ERROR;
5326: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5327: IF (x_msg_data IS NULL) THEN
5328: FND_MSG_PUB.Count_And_Get
5329: ( p_encoded => FND_API.G_FALSE
5330: , p_count => x_msg_count
5331: , p_data => x_msg_data
5332: );

Line 5371: FND_MSG_PUB.Initialize;

5367: ) IS
5368: l_count NUMBER;
5369:
5370: BEGIN
5371: FND_MSG_PUB.Initialize;
5372: x_return_status := FND_API.G_RET_STS_SUCCESS;
5373:
5374: BSC_KPI_PVT.Delete_Ind_Images
5375: (

Line 5386: FND_MSG_PUB.Count_And_Get

5382:
5383: EXCEPTION
5384: WHEN FND_API.G_EXC_ERROR THEN
5385: IF (x_msg_data IS NULL) THEN
5386: FND_MSG_PUB.Count_And_Get
5387: ( p_encoded => FND_API.G_FALSE
5388: , p_count => x_msg_count
5389: , p_data => x_msg_data
5390: );

Line 5396: FND_MSG_PUB.Count_And_Get

5392: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5393: x_return_status := FND_API.G_RET_STS_ERROR;
5394: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5395: IF (x_msg_data IS NULL) THEN
5396: FND_MSG_PUB.Count_And_Get
5397: ( p_encoded => FND_API.G_FALSE
5398: , p_count => x_msg_count
5399: , p_data => x_msg_data
5400: );

Line 5438: FND_MSG_PUB.Initialize;

5434: ) IS
5435: l_count NUMBER;
5436:
5437: BEGIN
5438: FND_MSG_PUB.Initialize;
5439: x_return_status := FND_API.G_RET_STS_SUCCESS;
5440:
5441: BSC_KPI_PVT.Delete_Ind_Sys_Prop
5442: (

Line 5453: FND_MSG_PUB.Count_And_Get

5449:
5450: EXCEPTION
5451: WHEN FND_API.G_EXC_ERROR THEN
5452: IF (x_msg_data IS NULL) THEN
5453: FND_MSG_PUB.Count_And_Get
5454: ( p_encoded => FND_API.G_FALSE
5455: , p_count => x_msg_count
5456: , p_data => x_msg_data
5457: );

Line 5463: FND_MSG_PUB.Count_And_Get

5459: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5460: x_return_status := FND_API.G_RET_STS_ERROR;
5461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5462: IF (x_msg_data IS NULL) THEN
5463: FND_MSG_PUB.Count_And_Get
5464: ( p_encoded => FND_API.G_FALSE
5465: , p_count => x_msg_count
5466: , p_data => x_msg_data
5467: );

Line 5506: FND_MSG_PUB.Initialize;

5502: ) IS
5503: l_count NUMBER;
5504:
5505: BEGIN
5506: FND_MSG_PUB.Initialize;
5507: x_return_status := FND_API.G_RET_STS_SUCCESS;
5508:
5509: BSC_KPI_PVT.Delete_Ind_Comments
5510: (

Line 5521: FND_MSG_PUB.Count_And_Get

5517:
5518: EXCEPTION
5519: WHEN FND_API.G_EXC_ERROR THEN
5520: IF (x_msg_data IS NULL) THEN
5521: FND_MSG_PUB.Count_And_Get
5522: ( p_encoded => FND_API.G_FALSE
5523: , p_count => x_msg_count
5524: , p_data => x_msg_data
5525: );

Line 5531: FND_MSG_PUB.Count_And_Get

5527: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5528: x_return_status := FND_API.G_RET_STS_ERROR;
5529: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5530: IF (x_msg_data IS NULL) THEN
5531: FND_MSG_PUB.Count_And_Get
5532: ( p_encoded => FND_API.G_FALSE
5533: , p_count => x_msg_count
5534: , p_data => x_msg_data
5535: );

Line 5574: FND_MSG_PUB.Initialize;

5570: ) IS
5571: l_count NUMBER;
5572:
5573: BEGIN
5574: FND_MSG_PUB.Initialize;
5575: x_return_status := FND_API.G_RET_STS_SUCCESS;
5576:
5577: BSC_KPI_PVT.Delete_Ind_Tree_Nodes
5578: (

Line 5589: FND_MSG_PUB.Count_And_Get

5585:
5586: EXCEPTION
5587: WHEN FND_API.G_EXC_ERROR THEN
5588: IF (x_msg_data IS NULL) THEN
5589: FND_MSG_PUB.Count_And_Get
5590: ( p_encoded => FND_API.G_FALSE
5591: , p_count => x_msg_count
5592: , p_data => x_msg_data
5593: );

Line 5599: FND_MSG_PUB.Count_And_Get

5595: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5596: x_return_status := FND_API.G_RET_STS_ERROR;
5597: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5598: IF (x_msg_data IS NULL) THEN
5599: FND_MSG_PUB.Count_And_Get
5600: ( p_encoded => FND_API.G_FALSE
5601: , p_count => x_msg_count
5602: , p_data => x_msg_data
5603: );

Line 5642: FND_MSG_PUB.Initialize;

5638: ) IS
5639: l_count NUMBER;
5640:
5641: BEGIN
5642: FND_MSG_PUB.Initialize;
5643: x_return_status := FND_API.G_RET_STS_SUCCESS;
5644:
5645: BSC_KPI_PVT.Delete_Ind_User_Access
5646: (

Line 5657: FND_MSG_PUB.Count_And_Get

5653:
5654: EXCEPTION
5655: WHEN FND_API.G_EXC_ERROR THEN
5656: IF (x_msg_data IS NULL) THEN
5657: FND_MSG_PUB.Count_And_Get
5658: ( p_encoded => FND_API.G_FALSE
5659: , p_count => x_msg_count
5660: , p_data => x_msg_data
5661: );

Line 5667: FND_MSG_PUB.Count_And_Get

5663: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5664: x_return_status := FND_API.G_RET_STS_ERROR;
5665: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5666: IF (x_msg_data IS NULL) THEN
5667: FND_MSG_PUB.Count_And_Get
5668: ( p_encoded => FND_API.G_FALSE
5669: , p_count => x_msg_count
5670: , p_data => x_msg_data
5671: );

Line 5704: FND_MSG_PUB.Initialize;

5700: , x_msg_data OUT NOCOPY VARCHAR2
5701: )IS
5702:
5703: BEGIN
5704: FND_MSG_PUB.Initialize;
5705: x_return_status := FND_API.G_RET_STS_SUCCESS;
5706:
5707:
5708:

Line 5722: FND_MSG_PUB.Count_And_Get

5718:
5719: EXCEPTION
5720: WHEN FND_API.G_EXC_ERROR THEN
5721: IF (x_msg_data IS NULL) THEN
5722: FND_MSG_PUB.Count_And_Get
5723: ( p_encoded => FND_API.G_FALSE
5724: , p_count => x_msg_count
5725: , p_data => x_msg_data
5726: );

Line 5732: FND_MSG_PUB.Count_And_Get

5728: --DBMS_OUTPUT.PUT_LINE('EXCEPTION FND_API.G_EXC_ERROR '||x_msg_data);
5729: x_return_status := FND_API.G_RET_STS_ERROR;
5730: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5731: IF (x_msg_data IS NULL) THEN
5732: FND_MSG_PUB.Count_And_Get
5733: ( p_encoded => FND_API.G_FALSE
5734: , p_count => x_msg_count
5735: , p_data => x_msg_data
5736: );