DBA Data[Home] [Help]

APPS.BSC_KPI_SERIES_PUB dependencies on FND_MSG_PUB

Line 68: FND_MSG_PUB.Initialize;

64: BEGIN
65:
66: SAVEPOINT Check_Color_Props_PUB;
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68: FND_MSG_PUB.Initialize;
69:
70: OPEN c_kpi_measure_id;
71: FETCH c_kpi_measure_id INTO l_kpi_measure_id;
72: CLOSE c_kpi_measure_id;

Line 126: FND_MSG_PUB.Count_And_Get

122: EXCEPTION
123: WHEN FND_API.G_EXC_ERROR THEN
124: ROLLBACK TO Check_Color_Props_PUB;
125: IF (x_msg_data IS NULL) THEN
126: FND_MSG_PUB.Count_And_Get
127: ( p_encoded => FND_API.G_FALSE
128: , p_count => x_msg_count
129: , p_data => x_msg_data
130: );

Line 136: FND_MSG_PUB.Count_And_Get

132: x_return_status := FND_API.G_RET_STS_ERROR;
133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
134: ROLLBACK TO Check_Color_Props_PUB;
135: IF (x_msg_data IS NULL) THEN
136: FND_MSG_PUB.Count_And_Get
137: ( p_encoded => FND_API.G_FALSE
138: , p_count => x_msg_count
139: , p_data => x_msg_data
140: );

Line 210: FND_MSG_PUB.Initialize;

206: BEGIN
207:
208: SAVEPOINT Save_Default_Calculation_PUB;
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210: FND_MSG_PUB.Initialize;
211:
212: OPEN c_kpi_measure_id;
213: FETCH c_kpi_measure_id INTO l_kpi_measure_id;
214: CLOSE c_kpi_measure_id;

Line 283: FND_MSG_PUB.Count_And_Get

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

Line 293: FND_MSG_PUB.Count_And_Get

289: x_return_status := FND_API.G_RET_STS_ERROR;
290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
291: ROLLBACK TO Save_Default_Calculation_PUB;
292: IF (x_msg_data IS NULL) THEN
293: FND_MSG_PUB.Count_And_Get
294: ( p_encoded => FND_API.G_FALSE
295: , p_count => x_msg_count
296: , p_data => x_msg_data
297: );

Line 353: FND_MSG_PUB.Initialize;

349:
350: BEGIN
351: SAVEPOINT Check_Series_Default_Props_PUB;
352: x_return_status := FND_API.G_RET_STS_SUCCESS;
353: FND_MSG_PUB.Initialize;
354:
355: SELECT
356: a0_default,a1_default,a2_default
357: INTO

Line 462: FND_MSG_PUB.Count_And_Get

458:
459: EXCEPTION
460: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
461: IF (x_msg_data IS NULL) THEN
462: FND_MSG_PUB.Count_And_Get
463: ( p_encoded => FND_API.G_FALSE
464: , p_count => x_msg_count
465: , p_data => x_msg_data
466: );

Line 566: FND_MSG_PUB.ADD;

562: , p_Indicator);
563: IF l_Count = 0 THEN
564: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
565: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
566: FND_MSG_PUB.ADD;
567: RAISE FND_API.G_EXC_ERROR;
568: END IF;
569: ELSE
570: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 572: FND_MSG_PUB.ADD;

568: END IF;
569: ELSE
570: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
571: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
572: FND_MSG_PUB.ADD;
573: RAISE FND_API.G_EXC_ERROR;
574: END IF;
575: BSC_BIS_LOCKS_PUB.LOCK_KPI
576: ( p_Kpi_Id => p_Indicator

Line 721: FND_MSG_PUB.Count_And_Get

717:
718: EXCEPTION
719: WHEN FND_API.G_EXC_ERROR THEN
720: IF (x_msg_data IS NULL) THEN
721: FND_MSG_PUB.Count_And_Get
722: ( p_encoded => FND_API.G_FALSE
723: , p_count => x_msg_count
724: , p_data => x_msg_data
725: );

Line 730: FND_MSG_PUB.Count_And_Get

726: END IF;
727: x_return_status := FND_API.G_RET_STS_ERROR;
728: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
729: IF (x_msg_data IS NULL) THEN
730: FND_MSG_PUB.Count_And_Get
731: ( p_encoded => FND_API.G_FALSE
732: , p_count => x_msg_count
733: , p_data => x_msg_data
734: );

Line 814: FND_MSG_PUB.ADD;

810: , p_Indicator);
811: IF l_Count = 0 THEN
812: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
813: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
814: FND_MSG_PUB.ADD;
815: RAISE FND_API.G_EXC_ERROR;
816: END IF;
817: ELSE
818: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

Line 820: FND_MSG_PUB.ADD;

816: END IF;
817: ELSE
818: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
819: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
820: FND_MSG_PUB.ADD;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823: BSC_BIS_LOCKS_PUB.LOCK_KPI
824: ( p_Kpi_Id => p_Indicator

Line 1028: FND_MSG_PUB.Count_And_Get

1024:
1025: EXCEPTION
1026: WHEN FND_API.G_EXC_ERROR THEN
1027: IF (x_msg_data IS NULL) THEN
1028: FND_MSG_PUB.Count_And_Get
1029: ( p_encoded => FND_API.G_FALSE
1030: , p_count => x_msg_count
1031: , p_data => x_msg_data
1032: );

Line 1037: FND_MSG_PUB.Count_And_Get

1033: END IF;
1034: x_return_status := FND_API.G_RET_STS_ERROR;
1035: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1036: IF (x_msg_data IS NULL) 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 1105: FND_MSG_PUB.ADD;

1101: , p_Indicator);
1102: IF l_Count = 0 THEN
1103: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1104: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Indicator);
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_Indicator);
1111: FND_MSG_PUB.ADD;
1112: RAISE FND_API.G_EXC_ERROR;
1113: END IF;
1114: BSC_BIS_LOCKS_PUB.LOCK_KPI
1115: ( p_Kpi_Id => p_Indicator

Line 1231: FND_MSG_PUB.Count_And_Get

1227:
1228: EXCEPTION
1229: WHEN FND_API.G_EXC_ERROR THEN
1230: IF (x_msg_data IS NULL) THEN
1231: FND_MSG_PUB.Count_And_Get
1232: ( p_encoded => FND_API.G_FALSE
1233: , p_count => x_msg_count
1234: , p_data => x_msg_data
1235: );

Line 1240: FND_MSG_PUB.Count_And_Get

1236: END IF;
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1239: IF (x_msg_data IS NULL) THEN
1240: FND_MSG_PUB.Count_And_Get
1241: ( p_encoded => FND_API.G_FALSE
1242: , p_count => x_msg_count
1243: , p_data => x_msg_data
1244: );

Line 1285: FND_MSG_PUB.Initialize;

1281: l_bm_color bsc_kpi_series_colors.color%TYPE;
1282: BEGIN
1283:
1284: SAVEPOINT Pop_Kpi_Series_PUB;
1285: FND_MSG_PUB.Initialize;
1286: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1287:
1288: DELETE FROM bsc_kpi_series_colors
1289: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND

Line 1328: FND_MSG_PUB.Count_And_Get

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

Line 1338: FND_MSG_PUB.Count_And_Get

1334: x_return_status := FND_API.G_RET_STS_ERROR;
1335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1336: ROLLBACK TO Pop_Kpi_Series_PUB;
1337: IF (x_msg_data IS NULL) THEN
1338: FND_MSG_PUB.Count_And_Get
1339: ( p_encoded => FND_API.G_FALSE
1340: , p_count => x_msg_count
1341: , p_data => x_msg_data
1342: );

Line 1380: FND_MSG_PUB.Initialize;

1376: ) IS
1377: BEGIN
1378:
1379: SAVEPOINT Delete_Kpi_SeriesColor_PUB;
1380: FND_MSG_PUB.Initialize;
1381: x_Return_Status := FND_API.G_RET_STS_SUCCESS;
1382:
1383: DELETE FROM bsc_kpi_series_colors
1384: WHERE indicator = p_Anal_Opt_Rec.Bsc_Kpi_Id AND

Line 1399: FND_MSG_PUB.Count_And_Get

1395: EXCEPTION
1396: WHEN FND_API.G_EXC_ERROR THEN
1397: ROLLBACK TO Delete_Kpi_SeriesColor_PUB;
1398: IF (x_msg_data IS NULL) THEN
1399: FND_MSG_PUB.Count_And_Get
1400: ( p_encoded => FND_API.G_FALSE
1401: , p_count => x_msg_count
1402: , p_data => x_msg_data
1403: );

Line 1409: FND_MSG_PUB.Count_And_Get

1405: x_return_status := FND_API.G_RET_STS_ERROR;
1406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1407: ROLLBACK TO Delete_Kpi_SeriesColor_PUB;
1408: IF (x_msg_data IS NULL) THEN
1409: FND_MSG_PUB.Count_And_Get
1410: ( p_encoded => FND_API.G_FALSE
1411: , p_count => x_msg_count
1412: , p_data => x_msg_data
1413: );

Line 1578: FND_MSG_PUB.Initialize;

1574: prototype_flag <> 2 AND
1575: share_flag = 2;
1576: BEGIN
1577:
1578: FND_MSG_PUB.Initialize;
1579:
1580: OPEN c_Dim_Set;
1581: FETCH c_Dim_Set INTO l_Current_DimSet;
1582: CLOSE c_Dim_Set;

Line 1703: FND_MSG_PUB.ADD;

1699:
1700: IF l_Structure_Change THEN
1701: FND_MESSAGE.SET_NAME('BSC','BSC_PMD_KPI_STRUCT_INVALID');
1702: FND_MESSAGE.SET_TOKEN('INDICATORS', BSC_BIS_LOCKS_PVT.Get_Kpi_Name(p_Indicator));
1703: FND_MSG_PUB.ADD;
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:
1707:

Line 1711: FND_MSG_PUB.Count_And_Get

1707:
1708: EXCEPTION
1709: WHEN FND_API.G_EXC_ERROR THEN
1710: IF (x_msg_data IS NULL) THEN
1711: FND_MSG_PUB.Count_And_Get
1712: ( p_encoded => FND_API.G_FALSE
1713: , p_count => x_msg_count
1714: , p_data => x_msg_data
1715: );

Line 1792: FND_MSG_PUB.Count_And_Get

1788: EXCEPTION
1789: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1790: ROLLBACK TO ObjKpiTimeStampPUB;
1791: IF (x_msg_data IS NULL) THEN
1792: FND_MSG_PUB.Count_And_Get
1793: ( p_encoded => FND_API.G_FALSE
1794: , p_count => x_msg_count
1795: , p_data => x_msg_data
1796: );