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_MESSAGE

Line 801: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

797: FROM BSC_KPIS_B
798: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
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;

Line 802: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

798: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
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

Line 807: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

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');
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;

Line 808: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

804: RAISE FND_API.G_EXC_ERROR;
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:

Line 1103: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

1099: FROM BSC_KPIS_B
1100: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
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;

Line 1104: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1100: WHERE INDICATOR = p_Anal_Opt_Rec.Bsc_Kpi_Id;
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

Line 1109: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

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');
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;

Line 1110: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1106: RAISE FND_API.G_EXC_ERROR;
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.

Line 1336: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

1332: -- Check that valid Kpi id was entered.
1333: IF (p_Anal_Opt_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
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;

Line 1337: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1333: IF (p_Anal_Opt_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
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

Line 1342: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

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');
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;

Line 1343: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1339: RAISE FND_API.G_EXC_ERROR;
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

Line 1354: FND_MESSAGE.SET_NAME('BSC','BSC_SHARED_KPI');

1350: ,x_msg_count
1351: ,x_msg_data
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;

Line 1355: FND_MESSAGE.SET_TOKEN('BSC_AO_DELETE', l_Anal_Opt_Rec.Bsc_Kpi_Id);

1351: ,x_msg_data
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

Line 1361: FND_MESSAGE.SET_NAME('BSC','BSC_LAST_AO_IN_KPI');

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
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');

Line 1365: FND_MESSAGE.SET_NAME('BSC','BSC_LAST_AO_IN_CUST_KPI');

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);
1367: FND_MSG_PUB.ADD;
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;

Line 1366: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_Kpi_Name);

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);
1367: FND_MSG_PUB.ADD;
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370: END IF;

Line 1640: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

1636: INTO l_count
1637: FROM BSC_KPIS_B
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;

Line 1641: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1637: FROM BSC_KPIS_B
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

Line 1646: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

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');
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;

Line 1647: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1643: RAISE FND_API.G_EXC_ERROR;
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:

Line 1660: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_OPTION_ID');

1656: p_Anal_Opt_Rec.Bsc_Option_Group2 = 0 and
1657: p_Anal_Opt_Rec.Bsc_Dataset_Series_Id = 0 and
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:

Line 1661: FND_MESSAGE.SET_TOKEN('BSC_OPTION', p_Anal_Opt_Rec.Bsc_Option_Group0);

1657: p_Anal_Opt_Rec.Bsc_Dataset_Series_Id = 0 and
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

Line 1896: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');

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;
1900: WHEN OTHERS THEN

Line 1897: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', g_db_object);

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;
1900: WHEN OTHERS THEN
1901: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1944: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

1940: INTO l_count
1941: FROM BSC_KPIS_B
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;

Line 1945: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1941: FROM BSC_KPIS_B
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

Line 1950: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

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');
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;

Line 1951: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

1947: RAISE FND_API.G_EXC_ERROR;
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:

Line 2265: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');

2261: -- Check that valid Kpi id was entered.
2262: IF (p_Anal_Opt_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
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;

Line 2266: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

2262: IF (p_Anal_Opt_Rec.Bsc_Kpi_Id IS NOT NULL) THEN
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

Line 2271: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');

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');
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;

Line 2272: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Anal_Opt_Rec.Bsc_Kpi_Id);

2268: RAISE FND_API.G_EXC_ERROR;
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;

Line 2915: FND_MESSAGE.SET_NAME('BSC','BSC_LAST_AO_IN_KPI');

2911: SAVEPOINT DeleteBSCAnaOptMultGroups;
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:

Line 2942: FND_MESSAGE.SET_NAME('BSC','BSC_D_NOT_DELETE_AO_DEPEN');

2938:
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:

Line 2963: FND_MESSAGE.SET_NAME('BSC','BSC_D_NOT_DELETE_AO_DEPEN');

2959:
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:

Line 3015: FND_MESSAGE.SET_NAME('BSC','BSC_D_NOT_DELETE_AO_DEPEN');

3011: , x_msg_data => x_msg_data
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:

Line 3393: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_NOT_PRIM_SOURCE');

3389: END IF;
3390: END IF;
3391:
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;

Line 3394: FND_MESSAGE.SET_TOKEN('AK_KPI', l_AnaOpt_AKRegion);

3390: END IF;
3391:
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;

Line 3395: FND_MESSAGE.SET_TOKEN('AK_MES', l_Measure_AKRegion);

3391:
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:

Line 3404: FND_MESSAGE.SET_NAME('BIS',l_msg_data);

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;
3408:

Line 3415: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION');

3411: IF (l_parent_obj_table.COUNT > 0) THEN
3412: l_Allow_Delete := FALSE;
3413: l_index := l_parent_obj_table.first;
3414: LOOP
3415: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION');
3416: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_parent_obj_table(l_index).object_name));
3417: l_dep_obj_message := FND_MESSAGE.GET;
3418: l_message := l_message || '

'||l_dep_obj_message || '

';
3419: l_mess_count := l_mess_count + 1;

Line 3416: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_parent_obj_table(l_index).object_name));

3412: l_Allow_Delete := FALSE;
3413: l_index := l_parent_obj_table.first;
3414: LOOP
3415: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION');
3416: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_parent_obj_table(l_index).object_name));
3417: l_dep_obj_message := FND_MESSAGE.GET;
3418: l_message := l_message || '

'||l_dep_obj_message || '

';
3419: l_mess_count := l_mess_count + 1;
3420: EXIT WHEN l_index = l_parent_obj_table.last;

Line 3417: l_dep_obj_message := FND_MESSAGE.GET;

3413: l_index := l_parent_obj_table.first;
3414: LOOP
3415: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI_REGION');
3416: FND_MESSAGE.SET_TOKEN('DEP_OBJECT',BSC_BIS_CUSTOM_KPI_UTIL_PUB.Get_User_Function_Name(l_parent_obj_table(l_index).object_name));
3417: l_dep_obj_message := FND_MESSAGE.GET;
3418: l_message := l_message || '

'||l_dep_obj_message || '

';
3419: l_mess_count := l_mess_count + 1;
3420: EXIT WHEN l_index = l_parent_obj_table.last;
3421: l_index := l_parent_obj_table.next(l_index);

Line 3434: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI');

3430: LOOP
3431: FETCH c_KpiMeasure INTO l_kpi_name,l_objective_name;
3432: EXIT WHEN c_KpiMeasure%NOTFOUND;
3433: l_Allow_Delete := FALSE;
3434: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI');
3435: FND_MESSAGE.SET_TOKEN('KPI_NAME',l_kpi_name);
3436: FND_MESSAGE.SET_TOKEN('OBJECTIVE_NAME',l_objective_name);
3437: l_dep_obj_message := FND_MESSAGE.GET;
3438: l_message := l_message || '

'|| l_dep_obj_message ||'

Line 3435: FND_MESSAGE.SET_TOKEN('KPI_NAME',l_kpi_name);

3431: FETCH c_KpiMeasure INTO l_kpi_name,l_objective_name;
3432: EXIT WHEN c_KpiMeasure%NOTFOUND;
3433: l_Allow_Delete := FALSE;
3434: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI');
3435: FND_MESSAGE.SET_TOKEN('KPI_NAME',l_kpi_name);
3436: FND_MESSAGE.SET_TOKEN('OBJECTIVE_NAME',l_objective_name);
3437: l_dep_obj_message := FND_MESSAGE.GET;
3438: l_message := l_message || '

'|| l_dep_obj_message ||'

';
3439: l_mess_count := l_mess_count + 1;

Line 3436: FND_MESSAGE.SET_TOKEN('OBJECTIVE_NAME',l_objective_name);

3432: EXIT WHEN c_KpiMeasure%NOTFOUND;
3433: l_Allow_Delete := FALSE;
3434: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI');
3435: FND_MESSAGE.SET_TOKEN('KPI_NAME',l_kpi_name);
3436: FND_MESSAGE.SET_TOKEN('OBJECTIVE_NAME',l_objective_name);
3437: l_dep_obj_message := FND_MESSAGE.GET;
3438: l_message := l_message || '

'|| l_dep_obj_message ||'

';
3439: l_mess_count := l_mess_count + 1;
3440: END LOOP;

Line 3437: l_dep_obj_message := FND_MESSAGE.GET;

3433: l_Allow_Delete := FALSE;
3434: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_DEP_KPI');
3435: FND_MESSAGE.SET_TOKEN('KPI_NAME',l_kpi_name);
3436: FND_MESSAGE.SET_TOKEN('OBJECTIVE_NAME',l_objective_name);
3437: l_dep_obj_message := FND_MESSAGE.GET;
3438: l_message := l_message || '

'|| l_dep_obj_message ||'

';
3439: l_mess_count := l_mess_count + 1;
3440: END LOOP;
3441: CLOSE c_KpiMeasure;

Line 3454: FND_MESSAGE.SET_NAME('BSC','BSC_OBJ_DELETE');

3450: OPEN c_KpiName(p_kpi_id);
3451: FETCH c_KpiName INTO l_objective_name;
3452: CLOSE c_KpiName;
3453:
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;

Line 3455: FND_MESSAGE.SET_TOKEN('OBJ_NAME', l_objective_name);

3451: FETCH c_KpiName INTO l_objective_name;
3452: CLOSE c_KpiName;
3453:
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;

Line 3456: FND_MESSAGE.SET_TOKEN('KPI_NAME', l_AnaOpt_Name);

3452: CLOSE c_KpiName;
3453:
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;

Line 3457: FND_MESSAGE.SET_TOKEN('DEP_OBJ_LIST', l_message);

3453:
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:

Line 3462: FND_MESSAGE.SET_NAME('BSC','BSC_MEASURE_DELETE');

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');
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;

Line 3463: FND_MESSAGE.SET_TOKEN('MEASURE', l_AnaOpt_Name);

3459: RAISE FND_API.G_EXC_ERROR;
3460: END IF;
3461:
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:

Line 3464: FND_MESSAGE.SET_TOKEN('AK_REGION', l_Measure_AKRegion);

3460: END IF;
3461:
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

Line 3465: FND_MESSAGE.SET_TOKEN('FORM_FUNCTION', l_Measure_Function);

3461:
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