APPS.BSC_KPI_PVT dependencies on FND_MESSAGE

Line 87: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_ID_EXISTS');

83: FROM BSC_KPIS_B
84: WHERE INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
85:
86: IF l_count <> 0 THEN
87: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_ID_EXISTS');
88: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
89: FND_MSG_PUB.ADD;
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;

Line 88: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

84: WHERE INDICATOR = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
85:
86: IF l_count <> 0 THEN
87: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_ID_EXISTS');
88: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
89: FND_MSG_PUB.ADD;
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
92: ELSE

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

89: FND_MSG_PUB.ADD;
90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
92: ELSE
93: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
94: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
95: FND_MSG_PUB.ADD;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;

Line 94: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

90: RAISE FND_API.G_EXC_ERROR;
91: END IF;
92: ELSE
93: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
94: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
95: FND_MSG_PUB.ADD;
96: RAISE FND_API.G_EXC_ERROR;
97: END IF;
98:

Line 113: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');

109: WHERE SHORT_NAME = l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name
110: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
111:
112: IF l_Count <> 0 THEN
113: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
114: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'));
115: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name );
116: FND_MSG_PUB.ADD;
117: RAISE FND_API.G_EXC_ERROR;

Line 114: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'));

110: AND PROTOTYPE_FLAG <> BSC_KPI_PUB.DELETE_KPI_FLAG;
111:
112: IF l_Count <> 0 THEN
113: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
114: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'));
115: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name );
116: FND_MSG_PUB.ADD;
117: RAISE FND_API.G_EXC_ERROR;
118: END IF;

Line 115: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name );

111:
112: IF l_Count <> 0 THEN
113: FND_MESSAGE.SET_NAME('BSC','BSC_UNIQUE_NAME_REQUIRED');
114: FND_MESSAGE.SET_TOKEN('SHORT_NAME', BSC_APPS.GET_LOOKUP_VALUE('BSC_UI_BUILDER', 'MEASURE_SHORT_NAME'));
115: FND_MESSAGE.SET_TOKEN('NAME_VALUE', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Short_Name );
116: FND_MSG_PUB.ADD;
117: RAISE FND_API.G_EXC_ERROR;
118: END IF;
119: END IF;

Line 267: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

263: WHEN OTHERS THEN
264: ROLLBACK TO BscKpiPvt_CrtKPI;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: if (SQLCODE = -01400) then
267: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
268: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
269: FND_MSG_PUB.ADD;
270: RAISE FND_API.G_EXC_ERROR;
271: end if;

Line 268: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

264: ROLLBACK TO BscKpiPvt_CrtKPI;
265: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
266: if (SQLCODE = -01400) then
267: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
268: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
269: FND_MSG_PUB.ADD;
270: RAISE FND_API.G_EXC_ERROR;
271: end if;
272: IF (x_msg_data IS NOT NULL) THEN

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

388: RAISE;
389: WHEN NO_DATA_FOUND THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Initialize;
392: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
393: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
394: FND_MSG_PUB.ADD;
395: RAISE FND_API.G_EXC_ERROR;
396: WHEN OTHERS THEN

Line 393: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

389: WHEN NO_DATA_FOUND THEN
390: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.Initialize;
392: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
393: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
394: FND_MSG_PUB.ADD;
395: RAISE FND_API.G_EXC_ERROR;
396: WHEN OTHERS THEN
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

427: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
428: ,'indicator'
429: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
430: if l_count = 0 then
431: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
432: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
433: FND_MSG_PUB.ADD;
434: RAISE FND_API.G_EXC_ERROR;
435: end if;

Line 432: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

428: ,'indicator'
429: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
430: if l_count = 0 then
431: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
432: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
433: FND_MSG_PUB.ADD;
434: RAISE FND_API.G_EXC_ERROR;
435: end if;
436: else

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

433: FND_MSG_PUB.ADD;
434: RAISE FND_API.G_EXC_ERROR;
435: end if;
436: else
437: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
438: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
439: FND_MSG_PUB.ADD;
440: RAISE FND_API.G_EXC_ERROR;
441: end if;

Line 438: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

434: RAISE FND_API.G_EXC_ERROR;
435: end if;
436: else
437: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
438: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
439: FND_MSG_PUB.ADD;
440: RAISE FND_API.G_EXC_ERROR;
441: end if;
442:

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

642: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
643: ,'indicator'
644: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
645: if l_count = 0 then
646: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
647: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
648: FND_MSG_PUB.ADD;
649: RAISE FND_API.G_EXC_ERROR;
650: end if;

Line 647: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

643: ,'indicator'
644: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
645: if l_count = 0 then
646: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
647: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
648: FND_MSG_PUB.ADD;
649: RAISE FND_API.G_EXC_ERROR;
650: end if;
651: else

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

648: FND_MSG_PUB.ADD;
649: RAISE FND_API.G_EXC_ERROR;
650: end if;
651: else
652: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
653: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
654: FND_MSG_PUB.ADD;
655: RAISE FND_API.G_EXC_ERROR;
656: end if;

Line 653: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

649: RAISE FND_API.G_EXC_ERROR;
650: end if;
651: else
652: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
653: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
654: FND_MSG_PUB.ADD;
655: RAISE FND_API.G_EXC_ERROR;
656: end if;
657:

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

771:
772: --DBMS_OUTPUT.PUT_LINE(' Create_Kpi_Defaults - BSC_INVALID_KPI_ID');
773: --DBMS_OUTPUT.PUT_LINE(' Create_Kpi_Defaults - l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id = ' || l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
774:
775: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
776: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
777: FND_MSG_PUB.ADD;
778: RAISE FND_API.G_EXC_ERROR;
779: end if;

Line 776: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

772: --DBMS_OUTPUT.PUT_LINE(' Create_Kpi_Defaults - BSC_INVALID_KPI_ID');
773: --DBMS_OUTPUT.PUT_LINE(' Create_Kpi_Defaults - l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id = ' || l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
774:
775: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
776: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
777: FND_MSG_PUB.ADD;
778: RAISE FND_API.G_EXC_ERROR;
779: end if;
780: else

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

778: RAISE FND_API.G_EXC_ERROR;
779: end if;
780: else
781: --DBMS_OUTPUT.PUT_LINE(' Create_Kpi_Defaults - BSC_NO_KPI_ID_ENTERED');
782: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
783: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
784: FND_MSG_PUB.ADD;
785: RAISE FND_API.G_EXC_ERROR;
786: end if;

Line 783: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

779: end if;
780: else
781: --DBMS_OUTPUT.PUT_LINE(' Create_Kpi_Defaults - BSC_NO_KPI_ID_ENTERED');
782: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
783: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
784: FND_MSG_PUB.ADD;
785: RAISE FND_API.G_EXC_ERROR;
786: end if;
787:

Line 872: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

868: WHEN NO_DATA_FOUND THEN
869: ROLLBACK TO BscKpiPvt_CrtKPIDef;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: if (SQLCODE = -01400) then
872: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
873: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_ERROR;
876: end if;

Line 873: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

869: ROLLBACK TO BscKpiPvt_CrtKPIDef;
870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
871: if (SQLCODE = -01400) then
872: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
873: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
874: FND_MSG_PUB.ADD;
875: RAISE FND_API.G_EXC_ERROR;
876: end if;
877: IF (x_msg_data IS NOT NULL) THEN

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

962: RAISE;
963: WHEN NO_DATA_FOUND THEN
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MSG_PUB.Initialize;
966: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
967: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
968: FND_MSG_PUB.ADD;
969: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
970: RAISE FND_API.G_EXC_ERROR;

Line 967: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

963: WHEN NO_DATA_FOUND THEN
964: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
965: FND_MSG_PUB.Initialize;
966: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
967: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
968: FND_MSG_PUB.ADD;
969: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
970: RAISE FND_API.G_EXC_ERROR;
971: WHEN OTHERS THEN

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

1122: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1123: ,'indicator'
1124: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1125: if l_count = 0 then
1126: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1127: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1128: FND_MSG_PUB.ADD;
1129: RAISE FND_API.G_EXC_ERROR;
1130: end if;

Line 1127: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1123: ,'indicator'
1124: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1125: if l_count = 0 then
1126: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1127: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1128: FND_MSG_PUB.ADD;
1129: RAISE FND_API.G_EXC_ERROR;
1130: end if;
1131: else

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

1128: FND_MSG_PUB.ADD;
1129: RAISE FND_API.G_EXC_ERROR;
1130: end if;
1131: else
1132: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1133: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1134: FND_MSG_PUB.ADD;
1135: RAISE FND_API.G_EXC_ERROR;
1136: end if;

Line 1133: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1129: RAISE FND_API.G_EXC_ERROR;
1130: end if;
1131: else
1132: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1133: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1134: FND_MSG_PUB.ADD;
1135: RAISE FND_API.G_EXC_ERROR;
1136: end if;
1137:

Line 1189: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

1185: WHEN OTHERS THEN
1186: ROLLBACK TO BscKpiPvt_CrtKPIProp;
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: if (SQLCODE = -01400) then
1189: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
1190: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1191: FND_MSG_PUB.ADD;
1192: RAISE FND_API.G_EXC_ERROR;
1193: end if;

Line 1190: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

1186: ROLLBACK TO BscKpiPvt_CrtKPIProp;
1187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1188: if (SQLCODE = -01400) then
1189: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
1190: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1191: FND_MSG_PUB.ADD;
1192: RAISE FND_API.G_EXC_ERROR;
1193: end if;
1194: IF (x_msg_data IS NOT NULL) THEN

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

1254: WHEN NO_DATA_FOUND THEN
1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1257: FND_MSG_PUB.Initialize;
1258: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
1259: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1260: FND_MSG_PUB.ADD;
1261: RAISE FND_API.G_EXC_ERROR;
1262: WHEN OTHERS THEN

Line 1259: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

1255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1256: --DBMS_OUTPUT.PUT_LINE('EXCEPTION OTHERS '||x_msg_data);
1257: FND_MSG_PUB.Initialize;
1258: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
1259: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1260: FND_MSG_PUB.ADD;
1261: RAISE FND_API.G_EXC_ERROR;
1262: WHEN OTHERS THEN
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1294: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1295: ,'indicator'
1296: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1297: if l_count = 0 then
1298: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1299: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1300: FND_MSG_PUB.ADD;
1301: RAISE FND_API.G_EXC_ERROR;
1302: end if;

Line 1299: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1295: ,'indicator'
1296: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1297: if l_count = 0 then
1298: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1299: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1300: FND_MSG_PUB.ADD;
1301: RAISE FND_API.G_EXC_ERROR;
1302: end if;
1303: else

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

1300: FND_MSG_PUB.ADD;
1301: RAISE FND_API.G_EXC_ERROR;
1302: end if;
1303: else
1304: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1305: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308: end if;

Line 1305: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1301: RAISE FND_API.G_EXC_ERROR;
1302: end if;
1303: else
1304: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1305: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308: end if;
1309:

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

1405: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1406: ,'indicator'
1407: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1408: if l_count = 0 then
1409: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1410: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1411: FND_MSG_PUB.ADD;
1412: RAISE FND_API.G_EXC_ERROR;
1413: end if;

Line 1410: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1406: ,'indicator'
1407: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1408: if l_count = 0 then
1409: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1410: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1411: FND_MSG_PUB.ADD;
1412: RAISE FND_API.G_EXC_ERROR;
1413: end if;
1414: else

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

1411: FND_MSG_PUB.ADD;
1412: RAISE FND_API.G_EXC_ERROR;
1413: end if;
1414: else
1415: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1416: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_ERROR;
1419: end if;

Line 1416: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1412: RAISE FND_API.G_EXC_ERROR;
1413: end if;
1414: else
1415: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1416: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1417: FND_MSG_PUB.ADD;
1418: RAISE FND_API.G_EXC_ERROR;
1419: end if;
1420:

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

1497: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1498: ,'indicator'
1499: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1500: if l_count = 0 then
1501: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1502: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_ERROR;
1505: end if;

Line 1502: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1498: ,'indicator'
1499: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1500: if l_count = 0 then
1501: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1502: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_ERROR;
1505: end if;
1506: else

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

1503: FND_MSG_PUB.ADD;
1504: RAISE FND_API.G_EXC_ERROR;
1505: end if;
1506: else
1507: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1508: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1509: FND_MSG_PUB.ADD;
1510: RAISE FND_API.G_EXC_ERROR;
1511: end if;

Line 1508: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1504: RAISE FND_API.G_EXC_ERROR;
1505: end if;
1506: else
1507: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1508: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1509: FND_MSG_PUB.ADD;
1510: RAISE FND_API.G_EXC_ERROR;
1511: end if;
1512:

Line 1619: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

1615: WHEN OTHERS THEN
1616: ROLLBACK TO BscKpiPvt_CrtKPIAnal;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: if (SQLCODE = -01400) then
1619: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
1620: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1621: FND_MSG_PUB.ADD;
1622: RAISE FND_API.G_EXC_ERROR;
1623: end if;

Line 1620: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

1616: ROLLBACK TO BscKpiPvt_CrtKPIAnal;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: if (SQLCODE = -01400) then
1619: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
1620: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1621: FND_MSG_PUB.ADD;
1622: RAISE FND_API.G_EXC_ERROR;
1623: end if;
1624: IF (x_msg_data IS NOT NULL) THEN

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

1712: RAISE;
1713: WHEN NO_DATA_FOUND THEN
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1715: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1716: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
1717: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1718: FND_MSG_PUB.ADD;
1719: RAISE FND_API.G_EXC_ERROR;
1720: WHEN OTHERS THEN

Line 1717: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

1713: WHEN NO_DATA_FOUND THEN
1714: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1715: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
1716: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
1717: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
1718: FND_MSG_PUB.ADD;
1719: RAISE FND_API.G_EXC_ERROR;
1720: WHEN OTHERS THEN
1721: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

1752: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1753: ,'indicator'
1754: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1755: if l_count = 0 then
1756: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1757: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1758: FND_MSG_PUB.ADD;
1759: RAISE FND_API.G_EXC_ERROR;
1760: end if;

Line 1757: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1753: ,'indicator'
1754: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1755: if l_count = 0 then
1756: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1757: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1758: FND_MSG_PUB.ADD;
1759: RAISE FND_API.G_EXC_ERROR;
1760: end if;
1761: else

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

1758: FND_MSG_PUB.ADD;
1759: RAISE FND_API.G_EXC_ERROR;
1760: end if;
1761: else
1762: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1763: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1764: FND_MSG_PUB.ADD;
1765: RAISE FND_API.G_EXC_ERROR;
1766: end if;

Line 1763: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1759: RAISE FND_API.G_EXC_ERROR;
1760: end if;
1761: else
1762: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1763: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1764: FND_MSG_PUB.ADD;
1765: RAISE FND_API.G_EXC_ERROR;
1766: end if;
1767:

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

1906: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
1907: ,'indicator'
1908: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1909: IF(l_count = 0 )THEN
1910: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1911: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;

Line 1911: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1907: ,'indicator'
1908: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1909: IF(l_count = 0 )THEN
1910: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
1911: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915: ELSE

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

1912: FND_MSG_PUB.ADD;
1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915: ELSE
1916: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1917: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1918: FND_MSG_PUB.ADD;
1919: RAISE FND_API.G_EXC_ERROR;
1920: END IF;

Line 1917: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

1913: RAISE FND_API.G_EXC_ERROR;
1914: END IF;
1915: ELSE
1916: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
1917: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
1918: FND_MSG_PUB.ADD;
1919: RAISE FND_API.G_EXC_ERROR;
1920: END IF;
1921:

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

2013: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2014: ,'indicator'
2015: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2016: IF(l_count = 0 )THEN
2017: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2018: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2019: FND_MSG_PUB.ADD;
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;

Line 2018: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2014: ,'indicator'
2015: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2016: IF(l_count = 0 )THEN
2017: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2018: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2019: FND_MSG_PUB.ADD;
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022: ELSE

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

2019: FND_MSG_PUB.ADD;
2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022: ELSE
2023: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2024: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2025: FND_MSG_PUB.ADD;
2026: RAISE FND_API.G_EXC_ERROR;
2027: END IF;

Line 2024: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2020: RAISE FND_API.G_EXC_ERROR;
2021: END IF;
2022: ELSE
2023: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2024: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2025: FND_MSG_PUB.ADD;
2026: RAISE FND_API.G_EXC_ERROR;
2027: END IF;
2028:

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

2135: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2136: ,'indicator'
2137: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2138: if l_count = 0 then
2139: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2140: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: end if;

Line 2140: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2136: ,'indicator'
2137: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2138: if l_count = 0 then
2139: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2140: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: end if;
2144: else

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

2141: FND_MSG_PUB.ADD;
2142: RAISE FND_API.G_EXC_ERROR;
2143: end if;
2144: else
2145: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2146: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2147: FND_MSG_PUB.ADD;
2148: RAISE FND_API.G_EXC_ERROR;
2149: end if;

Line 2146: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2142: RAISE FND_API.G_EXC_ERROR;
2143: end if;
2144: else
2145: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2146: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2147: FND_MSG_PUB.ADD;
2148: RAISE FND_API.G_EXC_ERROR;
2149: end if;
2150:

Line 2158: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_PERIODICITY_ID');

2154: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_SYS_PERIODICITIES'
2155: ,'periodicity_id'
2156: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id);
2157: if l_count = 0 then
2158: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_PERIODICITY_ID');
2159: FND_MESSAGE.SET_TOKEN('BSC_PERIODICITY', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id);
2160: FND_MSG_PUB.ADD;
2161: RAISE FND_API.G_EXC_ERROR;
2162: end if;

Line 2159: FND_MESSAGE.SET_TOKEN('BSC_PERIODICITY', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id);

2155: ,'periodicity_id'
2156: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id);
2157: if l_count = 0 then
2158: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_PERIODICITY_ID');
2159: FND_MESSAGE.SET_TOKEN('BSC_PERIODICITY', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Periodicity_Id);
2160: FND_MSG_PUB.ADD;
2161: RAISE FND_API.G_EXC_ERROR;
2162: end if;
2163: else

Line 2244: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

2240: WHEN OTHERS THEN
2241: ROLLBACK TO BscKpiPvt_CrtKPIPerid;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: if (SQLCODE = -01400) then
2244: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
2245: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: end if;

Line 2245: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

2241: ROLLBACK TO BscKpiPvt_CrtKPIPerid;
2242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2243: if (SQLCODE = -01400) then
2244: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
2245: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2246: FND_MSG_PUB.ADD;
2247: RAISE FND_API.G_EXC_ERROR;
2248: end if;
2249: IF (x_msg_data IS NOT NULL) THEN

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

2328: RAISE;
2329: WHEN NO_DATA_FOUND THEN
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2332: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
2333: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: WHEN OTHERS THEN

Line 2333: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

2329: WHEN NO_DATA_FOUND THEN
2330: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2331: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2332: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
2333: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2334: FND_MSG_PUB.ADD;
2335: RAISE FND_API.G_EXC_ERROR;
2336: WHEN OTHERS THEN
2337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2368: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2369: ,'indicator'
2370: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2371: if l_count = 0 then
2372: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2373: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;
2376: end if;

Line 2373: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2369: ,'indicator'
2370: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2371: if l_count = 0 then
2372: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2373: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;
2376: end if;
2377: else

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

2374: FND_MSG_PUB.ADD;
2375: RAISE FND_API.G_EXC_ERROR;
2376: end if;
2377: else
2378: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2379: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;
2382: end if;

Line 2379: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2375: RAISE FND_API.G_EXC_ERROR;
2376: end if;
2377: else
2378: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2379: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2380: FND_MSG_PUB.ADD;
2381: RAISE FND_API.G_EXC_ERROR;
2382: end if;
2383:

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

2520: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2521: ,'indicator'
2522: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2523: if l_count = 0 then
2524: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2525: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2526: FND_MSG_PUB.ADD;
2527: RAISE FND_API.G_EXC_ERROR;
2528: end if;

Line 2525: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2521: ,'indicator'
2522: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2523: if l_count = 0 then
2524: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2525: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2526: FND_MSG_PUB.ADD;
2527: RAISE FND_API.G_EXC_ERROR;
2528: end if;
2529: else

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

2526: FND_MSG_PUB.ADD;
2527: RAISE FND_API.G_EXC_ERROR;
2528: end if;
2529: else
2530: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2531: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2532: FND_MSG_PUB.ADD;
2533: RAISE FND_API.G_EXC_ERROR;
2534: end if;

Line 2531: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2527: RAISE FND_API.G_EXC_ERROR;
2528: end if;
2529: else
2530: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2531: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2532: FND_MSG_PUB.ADD;
2533: RAISE FND_API.G_EXC_ERROR;
2534: end if;
2535:

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

2608: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2609: ,'indicator'
2610: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2611: if l_count = 0 then
2612: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2613: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2614: FND_MSG_PUB.ADD;
2615: RAISE FND_API.G_EXC_ERROR;
2616: end if;

Line 2613: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2609: ,'indicator'
2610: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2611: if l_count = 0 then
2612: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2613: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2614: FND_MSG_PUB.ADD;
2615: RAISE FND_API.G_EXC_ERROR;
2616: end if;
2617: else

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

2614: FND_MSG_PUB.ADD;
2615: RAISE FND_API.G_EXC_ERROR;
2616: end if;
2617: else
2618: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2619: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: end if;

Line 2619: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2615: RAISE FND_API.G_EXC_ERROR;
2616: end if;
2617: else
2618: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2619: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2620: FND_MSG_PUB.ADD;
2621: RAISE FND_API.G_EXC_ERROR;
2622: end if;
2623:

Line 2679: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

2675: WHEN OTHERS THEN
2676: ROLLBACK TO BscKpiPvt_CrtKPIDaTab;
2677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2678: if (SQLCODE = -01400) then
2679: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
2680: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2681: FND_MSG_PUB.ADD;
2682: RAISE FND_API.G_EXC_ERROR;
2683: end if;

Line 2680: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

2676: ROLLBACK TO BscKpiPvt_CrtKPIDaTab;
2677: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2678: if (SQLCODE = -01400) then
2679: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
2680: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2681: FND_MSG_PUB.ADD;
2682: RAISE FND_API.G_EXC_ERROR;
2683: end if;
2684: IF (x_msg_data IS NOT NULL) THEN

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

2746: WHEN NO_DATA_FOUND THEN
2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2748: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2749: FND_MSG_PUB.Initialize;
2750: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
2751: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2752: FND_MSG_PUB.ADD;
2753: RAISE FND_API.G_EXC_ERROR;
2754: WHEN OTHERS THEN

Line 2751: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

2747: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2748: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
2749: FND_MSG_PUB.Initialize;
2750: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
2751: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
2752: FND_MSG_PUB.ADD;
2753: RAISE FND_API.G_EXC_ERROR;
2754: WHEN OTHERS THEN
2755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

2786: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2787: ,'indicator'
2788: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2789: if l_count = 0 then
2790: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2791: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2792: FND_MSG_PUB.ADD;
2793: RAISE FND_API.G_EXC_ERROR;
2794: end if;

Line 2791: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2787: ,'indicator'
2788: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2789: if l_count = 0 then
2790: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2791: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2792: FND_MSG_PUB.ADD;
2793: RAISE FND_API.G_EXC_ERROR;
2794: end if;
2795: else

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

2792: FND_MSG_PUB.ADD;
2793: RAISE FND_API.G_EXC_ERROR;
2794: end if;
2795: else
2796: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2797: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;
2800: end if;

Line 2797: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2793: RAISE FND_API.G_EXC_ERROR;
2794: end if;
2795: else
2796: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2797: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2798: FND_MSG_PUB.ADD;
2799: RAISE FND_API.G_EXC_ERROR;
2800: end if;
2801:

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

2904: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
2905: ,'indicator'
2906: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2907: if l_count = 0 then
2908: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2909: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2910: FND_MSG_PUB.ADD;
2911: RAISE FND_API.G_EXC_ERROR;
2912: end if;

Line 2909: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2905: ,'indicator'
2906: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2907: if l_count = 0 then
2908: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
2909: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2910: FND_MSG_PUB.ADD;
2911: RAISE FND_API.G_EXC_ERROR;
2912: end if;
2913: else

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

2910: FND_MSG_PUB.ADD;
2911: RAISE FND_API.G_EXC_ERROR;
2912: end if;
2913: else
2914: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2915: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_ERROR;
2918: end if;

Line 2915: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

2911: RAISE FND_API.G_EXC_ERROR;
2912: end if;
2913: else
2914: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
2915: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
2916: FND_MSG_PUB.ADD;
2917: RAISE FND_API.G_EXC_ERROR;
2918: end if;
2919:

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

3012: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3013: ,'indicator'
3014: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3015: if l_count = 0 then
3016: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3017: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: end if;

Line 3017: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3013: ,'indicator'
3014: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3015: if l_count = 0 then
3016: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3017: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: end if;
3021: else

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

3018: FND_MSG_PUB.ADD;
3019: RAISE FND_API.G_EXC_ERROR;
3020: end if;
3021: else
3022: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3023: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3024: FND_MSG_PUB.ADD;
3025: RAISE FND_API.G_EXC_ERROR;
3026: end if;

Line 3023: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3019: RAISE FND_API.G_EXC_ERROR;
3020: end if;
3021: else
3022: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3023: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3024: FND_MSG_PUB.ADD;
3025: RAISE FND_API.G_EXC_ERROR;
3026: end if;
3027:

Line 3086: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

3082: WHEN OTHERS THEN
3083: ROLLBACK TO BscKpiPvt_CrtKPICalc;
3084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3085: if (SQLCODE = -01400) then
3086: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
3087: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: end if;

Line 3087: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

3083: ROLLBACK TO BscKpiPvt_CrtKPICalc;
3084: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3085: if (SQLCODE = -01400) then
3086: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
3087: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3088: FND_MSG_PUB.ADD;
3089: RAISE FND_API.G_EXC_ERROR;
3090: end if;
3091: IF (x_msg_data IS NOT NULL) THEN

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

3157: RAISE;
3158: WHEN NO_DATA_FOUND THEN
3159: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3160: FND_MSG_PUB.Initialize;
3161: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
3162: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3163: FND_MSG_PUB.ADD;
3164: RAISE FND_API.G_EXC_ERROR;
3165: WHEN OTHERS THEN

Line 3162: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

3158: WHEN NO_DATA_FOUND THEN
3159: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3160: FND_MSG_PUB.Initialize;
3161: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
3162: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3163: FND_MSG_PUB.ADD;
3164: RAISE FND_API.G_EXC_ERROR;
3165: WHEN OTHERS THEN
3166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3198: ,'indicator'
3199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3200: if l_count = 0 then
3201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3202: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_ERROR;
3205: end if;

Line 3202: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3198: ,'indicator'
3199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3200: if l_count = 0 then
3201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3202: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_ERROR;
3205: end if;
3206: else

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

3203: FND_MSG_PUB.ADD;
3204: RAISE FND_API.G_EXC_ERROR;
3205: end if;
3206: else
3207: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3208: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3209: FND_MSG_PUB.ADD;
3210: RAISE FND_API.G_EXC_ERROR;
3211: end if;

Line 3208: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3204: RAISE FND_API.G_EXC_ERROR;
3205: end if;
3206: else
3207: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3208: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3209: FND_MSG_PUB.ADD;
3210: RAISE FND_API.G_EXC_ERROR;
3211: end if;
3212:

Line 3219: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_CALCULATION_ID');

3215: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPI_CALCULATIONS'
3216: ,'calculation_id'
3217: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);
3218: if l_count = 0 then
3219: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_CALCULATION_ID');
3220: FND_MESSAGE.SET_TOKEN('BSC_CALCULATION', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);
3221: FND_MSG_PUB.ADD;
3222: RAISE FND_API.G_EXC_ERROR;
3223: end if;

Line 3220: FND_MESSAGE.SET_TOKEN('BSC_CALCULATION', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);

3216: ,'calculation_id'
3217: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);
3218: if l_count = 0 then
3219: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_CALCULATION_ID');
3220: FND_MESSAGE.SET_TOKEN('BSC_CALCULATION', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);
3221: FND_MSG_PUB.ADD;
3222: RAISE FND_API.G_EXC_ERROR;
3223: end if;
3224: else

Line 3225: FND_MESSAGE.SET_NAME('BSC','BSC_NO_CALCULATION_ID_ENTERED');

3221: FND_MSG_PUB.ADD;
3222: RAISE FND_API.G_EXC_ERROR;
3223: end if;
3224: else
3225: FND_MESSAGE.SET_NAME('BSC','BSC_NO_CALCULATION_ID_ENTERED');
3226: FND_MESSAGE.SET_TOKEN('BSC_CALCULATION', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);
3227: FND_MSG_PUB.ADD;
3228: RAISE FND_API.G_EXC_ERROR;
3229: end if;

Line 3226: FND_MESSAGE.SET_TOKEN('BSC_CALCULATION', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);

3222: RAISE FND_API.G_EXC_ERROR;
3223: end if;
3224: else
3225: FND_MESSAGE.SET_NAME('BSC','BSC_NO_CALCULATION_ID_ENTERED');
3226: FND_MESSAGE.SET_TOKEN('BSC_CALCULATION', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Calculation_Id);
3227: FND_MSG_PUB.ADD;
3228: RAISE FND_API.G_EXC_ERROR;
3229: end if;
3230:

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

3341: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3342: ,'indicator'
3343: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3344: IF (l_count = 0) THEN
3345: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3346: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3347: FND_MSG_PUB.ADD;
3348: RAISE FND_API.G_EXC_ERROR;
3349: END IF;

Line 3346: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3342: ,'indicator'
3343: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3344: IF (l_count = 0) THEN
3345: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3346: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3347: FND_MSG_PUB.ADD;
3348: RAISE FND_API.G_EXC_ERROR;
3349: END IF;
3350: ELSE

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

3347: FND_MSG_PUB.ADD;
3348: RAISE FND_API.G_EXC_ERROR;
3349: END IF;
3350: ELSE
3351: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3352: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3353: FND_MSG_PUB.ADD;
3354: RAISE FND_API.G_EXC_ERROR;
3355: END IF;

Line 3352: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3348: RAISE FND_API.G_EXC_ERROR;
3349: END IF;
3350: ELSE
3351: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3352: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3353: FND_MSG_PUB.ADD;
3354: RAISE FND_API.G_EXC_ERROR;
3355: END IF;
3356:

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

3433: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3434: ,'indicator'
3435: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3436: if l_count = 0 then
3437: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3438: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3439: FND_MSG_PUB.ADD;
3440: RAISE FND_API.G_EXC_ERROR;
3441: end if;

Line 3438: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3434: ,'indicator'
3435: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3436: if l_count = 0 then
3437: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3438: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3439: FND_MSG_PUB.ADD;
3440: RAISE FND_API.G_EXC_ERROR;
3441: end if;
3442: else

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

3439: FND_MSG_PUB.ADD;
3440: RAISE FND_API.G_EXC_ERROR;
3441: end if;
3442: else
3443: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3444: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3445: FND_MSG_PUB.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: end if;

Line 3444: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3440: RAISE FND_API.G_EXC_ERROR;
3441: end if;
3442: else
3443: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3444: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3445: FND_MSG_PUB.ADD;
3446: RAISE FND_API.G_EXC_ERROR;
3447: end if;
3448:

Line 3504: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

3500: WHEN NO_DATA_FOUND THEN
3501: ROLLBACK TO BscKpiPvt_CrtKPIUsrAcc;
3502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3503: if (SQLCODE = -01400) then
3504: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
3505: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3506: FND_MSG_PUB.ADD;
3507: RAISE FND_API.G_EXC_ERROR;
3508: end if;

Line 3505: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

3501: ROLLBACK TO BscKpiPvt_CrtKPIUsrAcc;
3502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3503: if (SQLCODE = -01400) then
3504: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
3505: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3506: FND_MSG_PUB.ADD;
3507: RAISE FND_API.G_EXC_ERROR;
3508: end if;
3509: IF (x_msg_data IS NOT NULL) THEN

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

3591: WHEN NO_DATA_FOUND THEN
3592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3593: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3594: FND_MSG_PUB.Initialize;
3595: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
3596: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3597: FND_MSG_PUB.ADD;
3598: RAISE FND_API.G_EXC_ERROR;
3599: WHEN OTHERS THEN

Line 3596: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

3592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3593: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
3594: FND_MSG_PUB.Initialize;
3595: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
3596: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
3597: FND_MSG_PUB.ADD;
3598: RAISE FND_API.G_EXC_ERROR;
3599: WHEN OTHERS THEN
3600: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

3631: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3632: ,'indicator'
3633: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3634: if l_count = 0 then
3635: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3636: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3637: FND_MSG_PUB.ADD;
3638: RAISE FND_API.G_EXC_ERROR;
3639: end if;

Line 3636: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3632: ,'indicator'
3633: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3634: if l_count = 0 then
3635: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3636: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3637: FND_MSG_PUB.ADD;
3638: RAISE FND_API.G_EXC_ERROR;
3639: end if;
3640: else

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

3637: FND_MSG_PUB.ADD;
3638: RAISE FND_API.G_EXC_ERROR;
3639: end if;
3640: else
3641: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3642: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_ERROR;
3645: end if;

Line 3642: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3638: RAISE FND_API.G_EXC_ERROR;
3639: end if;
3640: else
3641: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3642: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3643: FND_MSG_PUB.ADD;
3644: RAISE FND_API.G_EXC_ERROR;
3645: end if;
3646:

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

3763: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3764: ,'indicator'
3765: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3766: if l_count = 0 then
3767: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3768: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3769: FND_MSG_PUB.ADD;
3770: RAISE FND_API.G_EXC_ERROR;
3771: end if;

Line 3768: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3764: ,'indicator'
3765: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3766: if l_count = 0 then
3767: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3768: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3769: FND_MSG_PUB.ADD;
3770: RAISE FND_API.G_EXC_ERROR;
3771: end if;
3772: else

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

3769: FND_MSG_PUB.ADD;
3770: RAISE FND_API.G_EXC_ERROR;
3771: end if;
3772: else
3773: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3774: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3775: FND_MSG_PUB.ADD;
3776: RAISE FND_API.G_EXC_ERROR;
3777: end if;

Line 3774: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3770: RAISE FND_API.G_EXC_ERROR;
3771: end if;
3772: else
3773: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3774: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3775: FND_MSG_PUB.ADD;
3776: RAISE FND_API.G_EXC_ERROR;
3777: end if;
3778:

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

3855: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
3856: ,'indicator'
3857: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3858: if l_count = 0 then
3859: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3860: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3861: FND_MSG_PUB.ADD;
3862: RAISE FND_API.G_EXC_ERROR;
3863: end if;

Line 3860: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3856: ,'indicator'
3857: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3858: if l_count = 0 then
3859: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
3860: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3861: FND_MSG_PUB.ADD;
3862: RAISE FND_API.G_EXC_ERROR;
3863: end if;
3864: else

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

3861: FND_MSG_PUB.ADD;
3862: RAISE FND_API.G_EXC_ERROR;
3863: end if;
3864: else
3865: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3866: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3867: FND_MSG_PUB.ADD;
3868: RAISE FND_API.G_EXC_ERROR;
3869: end if;

Line 3866: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

3862: RAISE FND_API.G_EXC_ERROR;
3863: end if;
3864: else
3865: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
3866: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
3867: FND_MSG_PUB.ADD;
3868: RAISE FND_API.G_EXC_ERROR;
3869: end if;
3870:

Line 4017: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

4013: WHEN OTHERS THEN
4014: ROLLBACK TO BscKpiPvt_CrtKPIDefVals;
4015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4016: if (SQLCODE = -01400) then
4017: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
4018: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4019: FND_MSG_PUB.ADD;
4020: RAISE FND_API.G_EXC_ERROR;
4021: end if;

Line 4018: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

4014: ROLLBACK TO BscKpiPvt_CrtKPIDefVals;
4015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4016: if (SQLCODE = -01400) then
4017: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
4018: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4019: FND_MSG_PUB.ADD;
4020: RAISE FND_API.G_EXC_ERROR;
4021: end if;
4022: IF (x_msg_data IS NOT NULL) THEN

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

4157: WHEN NO_DATA_FOUND THEN
4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4159: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
4160: FND_MSG_PUB.Initialize;
4161: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
4162: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4163: FND_MSG_PUB.ADD;
4164: RAISE FND_API.G_EXC_ERROR;
4165: WHEN OTHERS THEN

Line 4162: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

4158: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4159: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
4160: FND_MSG_PUB.Initialize;
4161: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
4162: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4163: FND_MSG_PUB.ADD;
4164: RAISE FND_API.G_EXC_ERROR;
4165: WHEN OTHERS THEN
4166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4197: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4198: ,'indicator'
4199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4200: if l_count = 0 then
4201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4202: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4203: FND_MSG_PUB.ADD;
4204: RAISE FND_API.G_EXC_ERROR;
4205: end if;

Line 4202: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4198: ,'indicator'
4199: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4200: if l_count = 0 then
4201: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4202: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4203: FND_MSG_PUB.ADD;
4204: RAISE FND_API.G_EXC_ERROR;
4205: end if;
4206: else

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

4203: FND_MSG_PUB.ADD;
4204: RAISE FND_API.G_EXC_ERROR;
4205: end if;
4206: else
4207: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4208: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4209: FND_MSG_PUB.ADD;
4210: RAISE FND_API.G_EXC_ERROR;
4211: end if;

Line 4208: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4204: RAISE FND_API.G_EXC_ERROR;
4205: end if;
4206: else
4207: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4208: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4209: FND_MSG_PUB.ADD;
4210: RAISE FND_API.G_EXC_ERROR;
4211: end if;
4212:

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

4460: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4461: ,'indicator'
4462: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4463: if l_count = 0 then
4464: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4465: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4466: FND_MSG_PUB.ADD;
4467: RAISE FND_API.G_EXC_ERROR;
4468: end if;

Line 4465: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4461: ,'indicator'
4462: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4463: if l_count = 0 then
4464: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4465: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4466: FND_MSG_PUB.ADD;
4467: RAISE FND_API.G_EXC_ERROR;
4468: end if;
4469: else

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

4466: FND_MSG_PUB.ADD;
4467: RAISE FND_API.G_EXC_ERROR;
4468: end if;
4469: else
4470: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4471: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4472: FND_MSG_PUB.ADD;
4473: RAISE FND_API.G_EXC_ERROR;
4474: end if;

Line 4471: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4467: RAISE FND_API.G_EXC_ERROR;
4468: end if;
4469: else
4470: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4471: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4472: FND_MSG_PUB.ADD;
4473: RAISE FND_API.G_EXC_ERROR;
4474: end if;
4475:

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

4558: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4559: ,'indicator'
4560: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4561: if l_count = 0 then
4562: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4563: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4564: FND_MSG_PUB.ADD;
4565: RAISE FND_API.G_EXC_ERROR;
4566: end if;

Line 4563: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4559: ,'indicator'
4560: ,l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4561: if l_count = 0 then
4562: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4563: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4564: FND_MSG_PUB.ADD;
4565: RAISE FND_API.G_EXC_ERROR;
4566: end if;
4567: else

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

4564: FND_MSG_PUB.ADD;
4565: RAISE FND_API.G_EXC_ERROR;
4566: end if;
4567: else
4568: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4569: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4570: FND_MSG_PUB.ADD;
4571: RAISE FND_API.G_EXC_ERROR;
4572: end if;

Line 4569: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4565: RAISE FND_API.G_EXC_ERROR;
4566: end if;
4567: else
4568: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4569: FND_MESSAGE.SET_TOKEN('BSC_KPI', l_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4570: FND_MSG_PUB.ADD;
4571: RAISE FND_API.G_EXC_ERROR;
4572: end if;
4573:

Line 4586: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');

4582: ,l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
4583: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Kpi_In_Tab - Flag 3');
4584:
4585: if l_count = 0 then
4586: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
4587: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
4588: FND_MSG_PUB.ADD;
4589: RAISE FND_API.G_EXC_ERROR;
4590: end if;

Line 4587: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);

4583: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Kpi_In_Tab - Flag 3');
4584:
4585: if l_count = 0 then
4586: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
4587: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
4588: FND_MSG_PUB.ADD;
4589: RAISE FND_API.G_EXC_ERROR;
4590: end if;
4591: else

Line 4592: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');

4588: FND_MSG_PUB.ADD;
4589: RAISE FND_API.G_EXC_ERROR;
4590: end if;
4591: else
4592: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
4593: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
4594: FND_MSG_PUB.ADD;
4595: RAISE FND_API.G_EXC_ERROR;
4596: end if;

Line 4593: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);

4589: RAISE FND_API.G_EXC_ERROR;
4590: end if;
4591: else
4592: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
4593: FND_MESSAGE.SET_TOKEN('BSC_TAB', l_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
4594: FND_MSG_PUB.ADD;
4595: RAISE FND_API.G_EXC_ERROR;
4596: end if;
4597: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Kpi_In_Tab - Flag 4');

Line 4731: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');

4727: WHEN OTHERS THEN
4728: ROLLBACK TO BscKpiPvt_CrtKPIInTab;
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: if (SQLCODE = -01400) then
4731: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
4732: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4733: FND_MSG_PUB.ADD;
4734: RAISE FND_API.G_EXC_ERROR;
4735: end if;

Line 4732: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

4728: ROLLBACK TO BscKpiPvt_CrtKPIInTab;
4729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4730: if (SQLCODE = -01400) then
4731: FND_MESSAGE.SET_NAME('BSC','BSC_TABLE_NULL_VALUE');
4732: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4733: FND_MSG_PUB.ADD;
4734: RAISE FND_API.G_EXC_ERROR;
4735: end if;
4736: IF (x_msg_data IS NOT NULL) THEN

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

4808: WHEN NO_DATA_FOUND THEN
4809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4810: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
4811: FND_MSG_PUB.Initialize;
4812: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
4813: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4814: FND_MSG_PUB.ADD;
4815: RAISE FND_API.G_EXC_ERROR;
4816: WHEN OTHERS THEN

Line 4813: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);

4809: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4810: --DBMS_OUTPUT.PUT_LINE('EXCEPTION NO_DATA_FOUND '||x_msg_data);
4811: FND_MSG_PUB.Initialize;
4812: FND_MESSAGE.SET_NAME('BSC','BSC_NO_VALUE_FOUND');
4813: FND_MESSAGE.SET_TOKEN('BSC_OBJECT', l_db_object);
4814: FND_MSG_PUB.ADD;
4815: RAISE FND_API.G_EXC_ERROR;
4816: WHEN OTHERS THEN
4817: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

4848: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4849: ,'indicator'
4850: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4851: if l_count = 0 then
4852: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4853: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4854: FND_MSG_PUB.ADD;
4855: RAISE FND_API.G_EXC_ERROR;
4856: end if;

Line 4853: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4849: ,'indicator'
4850: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4851: if l_count = 0 then
4852: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4853: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4854: FND_MSG_PUB.ADD;
4855: RAISE FND_API.G_EXC_ERROR;
4856: end if;
4857: else

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

4854: FND_MSG_PUB.ADD;
4855: RAISE FND_API.G_EXC_ERROR;
4856: end if;
4857: else
4858: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4859: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4860: FND_MSG_PUB.ADD;
4861: RAISE FND_API.G_EXC_ERROR;
4862: end if;

Line 4859: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4855: RAISE FND_API.G_EXC_ERROR;
4856: end if;
4857: else
4858: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4859: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4860: FND_MSG_PUB.ADD;
4861: RAISE FND_API.G_EXC_ERROR;
4862: end if;
4863:

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

4964: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
4965: ,'indicator'
4966: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4967: if l_count = 0 then
4968: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4969: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_ERROR;
4972: end if;

Line 4969: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4965: ,'indicator'
4966: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4967: if l_count = 0 then
4968: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
4969: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_ERROR;
4972: end if;
4973: else

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

4970: FND_MSG_PUB.ADD;
4971: RAISE FND_API.G_EXC_ERROR;
4972: end if;
4973: else
4974: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4975: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4976: FND_MSG_PUB.ADD;
4977: RAISE FND_API.G_EXC_ERROR;
4978: end if;

Line 4975: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

4971: RAISE FND_API.G_EXC_ERROR;
4972: end if;
4973: else
4974: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
4975: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
4976: FND_MSG_PUB.ADD;
4977: RAISE FND_API.G_EXC_ERROR;
4978: end if;
4979:

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

5130: l_count := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_KPIS_B'
5131: ,'indicator'
5132: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5133: if l_count = 0 then
5134: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
5135: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_ERROR;
5138: end if;

Line 5135: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

5131: ,'indicator'
5132: ,p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5133: if l_count = 0 then
5134: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
5135: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_ERROR;
5138: end if;
5139: else

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

5136: FND_MSG_PUB.ADD;
5137: RAISE FND_API.G_EXC_ERROR;
5138: end if;
5139: else
5140: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
5141: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5142: FND_MSG_PUB.ADD;
5143: RAISE FND_API.G_EXC_ERROR;
5144: end if;

Line 5141: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

5137: RAISE FND_API.G_EXC_ERROR;
5138: end if;
5139: else
5140: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
5141: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
5142: FND_MSG_PUB.ADD;
5143: RAISE FND_API.G_EXC_ERROR;
5144: end if;
5145:

Line 5158: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');

5154: ,p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
5155: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Master_Kpi Flag 3');
5156:
5157: if l_count = 0 then
5158: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
5159: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
5160: FND_MSG_PUB.ADD;
5161: RAISE FND_API.G_EXC_ERROR;
5162: end if;

Line 5159: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);

5155: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Master_Kpi Flag 3');
5156:
5157: if l_count = 0 then
5158: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
5159: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
5160: FND_MSG_PUB.ADD;
5161: RAISE FND_API.G_EXC_ERROR;
5162: end if;
5163: else

Line 5164: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');

5160: FND_MSG_PUB.ADD;
5161: RAISE FND_API.G_EXC_ERROR;
5162: end if;
5163: else
5164: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
5165: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
5166: FND_MSG_PUB.ADD;
5167: RAISE FND_API.G_EXC_ERROR;
5168: end if;

Line 5165: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);

5161: RAISE FND_API.G_EXC_ERROR;
5162: end if;
5163: else
5164: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
5165: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_Bsc_Kpi_Entity_Rec.Bsc_Tab_Id);
5166: FND_MSG_PUB.ADD;
5167: RAISE FND_API.G_EXC_ERROR;
5168: end if;
5169: --DBMS_OUTPUT.PUT_LINE(' BSC_KPI_PVT.Create_Master_Kpi Flag 4');

Line 5351: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');

5347: FROM BSC_TAB_IND_GROUPS_B
5348: WHERE IND_GROUP_ID = l_x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id;
5349:
5350: if l_count = 0 then
5351: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');
5352: FND_MESSAGE.SET_TOKEN('BSC_KGROUP',l_x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id);
5353: FND_MSG_PUB.ADD;
5354: RAISE FND_API.G_EXC_ERROR;
5355: end if;

Line 5352: FND_MESSAGE.SET_TOKEN('BSC_KGROUP',l_x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id);

5348: WHERE IND_GROUP_ID = l_x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id;
5349:
5350: if l_count = 0 then
5351: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KGROUP_ID');
5352: FND_MESSAGE.SET_TOKEN('BSC_KGROUP',l_x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Group_Id);
5353: FND_MSG_PUB.ADD;
5354: RAISE FND_API.G_EXC_ERROR;
5355: end if;
5356: else

Line 5357: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KGROUP_ID_ENTERED');

5353: FND_MSG_PUB.ADD;
5354: RAISE FND_API.G_EXC_ERROR;
5355: end if;
5356: else
5357: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KGROUP_ID_ENTERED');
5358: FND_MSG_PUB.ADD;
5359: RAISE FND_API.G_EXC_ERROR;
5360: end if;
5361: l_x_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Share_Flag := 2;

Line 5601: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');

5597: l_cnt := BSC_DIMENSION_LEVELS_PVT.Validate_Value( 'BSC_TABS_B'
5598: ,'tab_id'
5599: ,p_tab_id);
5600: if l_cnt = 0 then
5601: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
5602: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);
5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;
5605: end if;

Line 5602: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);

5598: ,'tab_id'
5599: ,p_tab_id);
5600: if l_cnt = 0 then
5601: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_TAB_ID');
5602: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);
5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;
5605: end if;
5606: else

Line 5607: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');

5603: FND_MSG_PUB.ADD;
5604: RAISE FND_API.G_EXC_ERROR;
5605: end if;
5606: else
5607: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
5608: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);
5609: FND_MSG_PUB.ADD;
5610: RAISE FND_API.G_EXC_ERROR;
5611: end if;

Line 5608: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);

5604: RAISE FND_API.G_EXC_ERROR;
5605: end if;
5606: else
5607: FND_MESSAGE.SET_NAME('BSC','BSC_NO_TAB_ID_ENTERED');
5608: FND_MESSAGE.SET_TOKEN('BSC_TAB', p_tab_id);
5609: FND_MSG_PUB.ADD;
5610: RAISE FND_API.G_EXC_ERROR;
5611: end if;
5612:

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

6850: FROM bsc_kpis_b
6851: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6852:
6853: IF (l_count = 0) THEN
6854: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
6855: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_ERROR;
6858: END IF;

Line 6855: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

6851: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6852:
6853: IF (l_count = 0) THEN
6854: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
6855: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_ERROR;
6858: END IF;
6859: ELSE

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

6856: FND_MSG_PUB.ADD;
6857: RAISE FND_API.G_EXC_ERROR;
6858: END IF;
6859: ELSE
6860: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
6861: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6862: FND_MSG_PUB.ADD;
6863: RAISE FND_API.G_EXC_ERROR;
6864: END IF;

Line 6861: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

6857: RAISE FND_API.G_EXC_ERROR;
6858: END IF;
6859: ELSE
6860: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
6861: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6862: FND_MSG_PUB.ADD;
6863: RAISE FND_API.G_EXC_ERROR;
6864: END IF;
6865:

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

6953: FROM bsc_kpis_b
6954: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6955:
6956: IF (l_count = 0) THEN
6957: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
6958: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6959: FND_MSG_PUB.ADD;
6960: RAISE FND_API.G_EXC_ERROR;
6961: END IF;

Line 6958: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

6954: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
6955:
6956: IF (l_count = 0) THEN
6957: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
6958: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6959: FND_MSG_PUB.ADD;
6960: RAISE FND_API.G_EXC_ERROR;
6961: END IF;
6962: ELSE

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

6959: FND_MSG_PUB.ADD;
6960: RAISE FND_API.G_EXC_ERROR;
6961: END IF;
6962: ELSE
6963: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
6964: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6965: FND_MSG_PUB.ADD;
6966: RAISE FND_API.G_EXC_ERROR;
6967: END IF;

Line 6964: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

6960: RAISE FND_API.G_EXC_ERROR;
6961: END IF;
6962: ELSE
6963: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
6964: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
6965: FND_MSG_PUB.ADD;
6966: RAISE FND_API.G_EXC_ERROR;
6967: END IF;
6968:

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

7052: FROM bsc_kpis_b
7053: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7054:
7055: IF (l_count = 0) THEN
7056: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7057: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7058: FND_MSG_PUB.ADD;
7059: RAISE FND_API.G_EXC_ERROR;
7060: END IF;

Line 7057: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7053: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7054:
7055: IF (l_count = 0) THEN
7056: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7057: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7058: FND_MSG_PUB.ADD;
7059: RAISE FND_API.G_EXC_ERROR;
7060: END IF;
7061: ELSE

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

7058: FND_MSG_PUB.ADD;
7059: RAISE FND_API.G_EXC_ERROR;
7060: END IF;
7061: ELSE
7062: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7063: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7064: FND_MSG_PUB.ADD;
7065: RAISE FND_API.G_EXC_ERROR;
7066: END IF;

Line 7063: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7059: RAISE FND_API.G_EXC_ERROR;
7060: END IF;
7061: ELSE
7062: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7063: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7064: FND_MSG_PUB.ADD;
7065: RAISE FND_API.G_EXC_ERROR;
7066: END IF;
7067:

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

7145: FROM bsc_kpis_b
7146: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7147:
7148: IF (l_count = 0) THEN
7149: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7150: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7151: FND_MSG_PUB.ADD;
7152: RAISE FND_API.G_EXC_ERROR;
7153: END IF;

Line 7150: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7146: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7147:
7148: IF (l_count = 0) THEN
7149: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7150: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7151: FND_MSG_PUB.ADD;
7152: RAISE FND_API.G_EXC_ERROR;
7153: END IF;
7154: ELSE

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

7151: FND_MSG_PUB.ADD;
7152: RAISE FND_API.G_EXC_ERROR;
7153: END IF;
7154: ELSE
7155: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7156: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7157: FND_MSG_PUB.ADD;
7158: RAISE FND_API.G_EXC_ERROR;
7159: END IF;

Line 7156: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7152: RAISE FND_API.G_EXC_ERROR;
7153: END IF;
7154: ELSE
7155: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7156: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7157: FND_MSG_PUB.ADD;
7158: RAISE FND_API.G_EXC_ERROR;
7159: END IF;
7160:

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

7239: FROM bsc_kpis_b
7240: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7241:
7242: IF (l_count = 0) THEN
7243: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7244: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7245: FND_MSG_PUB.ADD;
7246: RAISE FND_API.G_EXC_ERROR;
7247: END IF;

Line 7244: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7240: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7241:
7242: IF (l_count = 0) THEN
7243: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7244: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7245: FND_MSG_PUB.ADD;
7246: RAISE FND_API.G_EXC_ERROR;
7247: END IF;
7248: ELSE

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

7245: FND_MSG_PUB.ADD;
7246: RAISE FND_API.G_EXC_ERROR;
7247: END IF;
7248: ELSE
7249: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7250: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7251: FND_MSG_PUB.ADD;
7252: RAISE FND_API.G_EXC_ERROR;
7253: END IF;

Line 7250: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7246: RAISE FND_API.G_EXC_ERROR;
7247: END IF;
7248: ELSE
7249: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7250: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7251: FND_MSG_PUB.ADD;
7252: RAISE FND_API.G_EXC_ERROR;
7253: END IF;
7254:

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

7333: FROM bsc_kpis_b
7334: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7335:
7336: IF (l_count = 0) THEN
7337: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7338: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7339: FND_MSG_PUB.ADD;
7340: RAISE FND_API.G_EXC_ERROR;
7341: END IF;

Line 7338: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7334: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7335:
7336: IF (l_count = 0) THEN
7337: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7338: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7339: FND_MSG_PUB.ADD;
7340: RAISE FND_API.G_EXC_ERROR;
7341: END IF;
7342: ELSE

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

7339: FND_MSG_PUB.ADD;
7340: RAISE FND_API.G_EXC_ERROR;
7341: END IF;
7342: ELSE
7343: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7344: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7345: FND_MSG_PUB.ADD;
7346: RAISE FND_API.G_EXC_ERROR;
7347: END IF;

Line 7344: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7340: RAISE FND_API.G_EXC_ERROR;
7341: END IF;
7342: ELSE
7343: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7344: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7345: FND_MSG_PUB.ADD;
7346: RAISE FND_API.G_EXC_ERROR;
7347: END IF;
7348:

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

7438: FROM bsc_kpis_b
7439: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7440:
7441: IF (l_count = 0) THEN
7442: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7443: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7444: FND_MSG_PUB.ADD;
7445: RAISE FND_API.G_EXC_ERROR;
7446: END IF;

Line 7443: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7439: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7440:
7441: IF (l_count = 0) THEN
7442: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7443: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7444: FND_MSG_PUB.ADD;
7445: RAISE FND_API.G_EXC_ERROR;
7446: END IF;
7447: ELSE

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

7444: FND_MSG_PUB.ADD;
7445: RAISE FND_API.G_EXC_ERROR;
7446: END IF;
7447: ELSE
7448: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7449: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7450: FND_MSG_PUB.ADD;
7451: RAISE FND_API.G_EXC_ERROR;
7452: END IF;

Line 7449: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7445: RAISE FND_API.G_EXC_ERROR;
7446: END IF;
7447: ELSE
7448: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7449: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7450: FND_MSG_PUB.ADD;
7451: RAISE FND_API.G_EXC_ERROR;
7452: END IF;
7453:

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

7560: FROM bsc_kpis_b
7561: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7562:
7563: IF (l_count = 0) THEN
7564: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7565: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7566: FND_MSG_PUB.ADD;
7567: RAISE FND_API.G_EXC_ERROR;
7568: END IF;

Line 7565: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7561: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7562:
7563: IF (l_count = 0) THEN
7564: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7565: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7566: FND_MSG_PUB.ADD;
7567: RAISE FND_API.G_EXC_ERROR;
7568: END IF;
7569: ELSE

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

7566: FND_MSG_PUB.ADD;
7567: RAISE FND_API.G_EXC_ERROR;
7568: END IF;
7569: ELSE
7570: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7571: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7572: FND_MSG_PUB.ADD;
7573: RAISE FND_API.G_EXC_ERROR;
7574: END IF;

Line 7571: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7567: RAISE FND_API.G_EXC_ERROR;
7568: END IF;
7569: ELSE
7570: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7571: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7572: FND_MSG_PUB.ADD;
7573: RAISE FND_API.G_EXC_ERROR;
7574: END IF;
7575:

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

7653: FROM bsc_kpis_b
7654: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7655:
7656: IF (l_count = 0) THEN
7657: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7658: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7659: FND_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_ERROR;
7661: END IF;

Line 7658: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7654: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7655:
7656: IF (l_count = 0) THEN
7657: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7658: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7659: FND_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_ERROR;
7661: END IF;
7662: ELSE

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

7659: FND_MSG_PUB.ADD;
7660: RAISE FND_API.G_EXC_ERROR;
7661: END IF;
7662: ELSE
7663: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7664: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7665: FND_MSG_PUB.ADD;
7666: RAISE FND_API.G_EXC_ERROR;
7667: END IF;

Line 7664: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7660: RAISE FND_API.G_EXC_ERROR;
7661: END IF;
7662: ELSE
7663: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7664: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7665: FND_MSG_PUB.ADD;
7666: RAISE FND_API.G_EXC_ERROR;
7667: END IF;
7668:

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

7751: FROM bsc_kpis_b
7752: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7753:
7754: IF (l_count = 0) THEN
7755: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7756: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7757: FND_MSG_PUB.ADD;
7758: RAISE FND_API.G_EXC_ERROR;
7759: END IF;

Line 7756: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7752: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7753:
7754: IF (l_count = 0) THEN
7755: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7756: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7757: FND_MSG_PUB.ADD;
7758: RAISE FND_API.G_EXC_ERROR;
7759: END IF;
7760: ELSE

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

7757: FND_MSG_PUB.ADD;
7758: RAISE FND_API.G_EXC_ERROR;
7759: END IF;
7760: ELSE
7761: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7762: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7763: FND_MSG_PUB.ADD;
7764: RAISE FND_API.G_EXC_ERROR;
7765: END IF;

Line 7762: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7758: RAISE FND_API.G_EXC_ERROR;
7759: END IF;
7760: ELSE
7761: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7762: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7763: FND_MSG_PUB.ADD;
7764: RAISE FND_API.G_EXC_ERROR;
7765: END IF;
7766:

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

7856: FROM bsc_kpis_b
7857: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7858:
7859: IF (l_count = 0) THEN
7860: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7861: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7862: FND_MSG_PUB.ADD;
7863: RAISE FND_API.G_EXC_ERROR;
7864: END IF;

Line 7861: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7857: WHERE indicator = p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id;
7858:
7859: IF (l_count = 0) THEN
7860: FND_MESSAGE.SET_NAME('BSC','BSC_INVALID_KPI_ID');
7861: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7862: FND_MSG_PUB.ADD;
7863: RAISE FND_API.G_EXC_ERROR;
7864: END IF;
7865: ELSE

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

7862: FND_MSG_PUB.ADD;
7863: RAISE FND_API.G_EXC_ERROR;
7864: END IF;
7865: ELSE
7866: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7867: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7868: FND_MSG_PUB.ADD;
7869: RAISE FND_API.G_EXC_ERROR;
7870: END IF;

Line 7867: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);

7863: RAISE FND_API.G_EXC_ERROR;
7864: END IF;
7865: ELSE
7866: FND_MESSAGE.SET_NAME('BSC','BSC_NO_KPI_ID_ENTERED');
7867: FND_MESSAGE.SET_TOKEN('BSC_KPI', p_Bsc_Kpi_Entity_Rec.Bsc_Kpi_Id);
7868: FND_MSG_PUB.ADD;
7869: RAISE FND_API.G_EXC_ERROR;
7870: END IF;
7871: