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

Line 66: FND_MSG_PUB.Initialize;

62: WHERE source_indicator = p_objective_id
63: AND share_flag = 2 -- shared objective.
64: AND prototype_flag <> 2;
65: BEGIN
66: FND_MSG_PUB.Initialize;
67: x_return_status := FND_API.G_RET_STS_SUCCESS;
68:
69: SAVEPOINT BscColorRangePub_CrtColorRng;
70:

Line 145: FND_MSG_PUB.Count_And_Get

141: WHEN OTHERS THEN
142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
143: ROLLBACK TO BscColorRangePub_CrtColorRng;
144: IF (x_msg_data IS NULL) THEN
145: FND_MSG_PUB.Count_And_Get
146: ( p_encoded => FND_API.G_FALSE
147: ,p_count => x_msg_count
148: ,p_data => x_msg_data
149: );

Line 190: FND_MSG_PUB.Initialize;

186: AND prototype_flag <> 2;
187:
188: BEGIN
189:
190: FND_MSG_PUB.Initialize;
191: x_return_status := FND_API.G_RET_STS_SUCCESS;
192:
193: SAVEPOINT BscColorPub_CrtDefClrRngCM;
194:

Line 197: FND_MSG_PUB.ADD;

193: SAVEPOINT BscColorPub_CrtDefClrRngCM;
194:
195: IF (p_kpi_measure_id IS NULL) THEN
196: FND_MESSAGE.SET_NAME('BSC','BSC_KPI_MEASURE_ID_NULL');
197: FND_MSG_PUB.ADD;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:
201: SELECT BSC_COLOR_RANGE_ID_S.NEXTVAL

Line 210: FND_MSG_PUB.ADD;

206:
207: IF (p_color_method IS NULL OR p_color_method > 3) THEN
208: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_METHOD_ISSUE');
209: FND_MESSAGE.SET_TOKEN('BSC_COLOR_METHOD', p_color_method);
210: FND_MSG_PUB.ADD;
211: RAISE FND_API.G_EXC_ERROR;
212: END IF;
213:
214: l_Bsc_Kpi_Color_Range_Rec := Get_Def_Color_Range_Rec(p_color_method);

Line 300: FND_MSG_PUB.Count_And_Get

296: WHEN OTHERS THEN
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: ROLLBACK TO BscColorPub_CrtDefClrRngCM;
299: IF (x_msg_data IS NULL) THEN
300: FND_MSG_PUB.Count_And_Get
301: ( p_encoded => FND_API.G_FALSE
302: ,p_count => x_msg_count
303: ,p_data => x_msg_data
304: );

Line 371: FND_MSG_PUB.Count_And_Get

367: EXCEPTION
368: WHEN OTHERS THEN
369: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
370: IF (x_msg_data IS NULL) THEN
371: FND_MSG_PUB.Count_And_Get
372: ( p_encoded => FND_API.G_FALSE
373: ,p_count => x_msg_count
374: ,p_data => x_msg_data
375: );

Line 396: FND_MSG_PUB.Initialize;

392: IS
393: l_color_method NUMBER;
394: BEGIN
395:
396: FND_MSG_PUB.Initialize;
397: x_return_status := FND_API.G_RET_STS_SUCCESS;
398:
399: IF (p_property_value IS NOT NULL) THEN
400: l_color_method := p_property_value;

Line 431: FND_MSG_PUB.Count_And_Get

427: EXCEPTION
428: WHEN OTHERS THEN
429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
430: IF (x_msg_data IS NULL) THEN
431: FND_MSG_PUB.Count_And_Get
432: ( p_encoded => FND_API.G_FALSE
433: ,p_count => x_msg_count
434: ,p_data => x_msg_data
435: );

Line 506: FND_MSG_PUB.Initialize;

502: l_user_id FND_USER.user_id%TYPE;
503: l_range_count NUMBER;
504:
505: BEGIN
506: FND_MSG_PUB.Initialize;
507: x_return_status := FND_API.G_RET_STS_SUCCESS;
508:
509: SAVEPOINT BscColorRangePub_SaveColorRng;
510: IF (p_kpi_measure_id IS NULL) THEN

Line 587: FND_MSG_PUB.Count_And_Get

583: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
584: ROLLBACK TO BscColorRangePub_SaveColorRng;
585:
586: IF (x_msg_data IS NULL) THEN
587: FND_MSG_PUB.Count_And_Get
588: ( p_encoded => FND_API.G_FALSE
589: ,p_count => x_msg_count
590: ,p_data => x_msg_data
591: );

Line 857: FND_MSG_PUB.Initialize;

853: WHERE source_indicator = p_objective_id
854: AND share_flag = 2 -- shared objective.
855: AND prototype_flag <> 2;
856: BEGIN
857: FND_MSG_PUB.Initialize;
858: x_return_status := FND_API.G_RET_STS_SUCCESS;
859:
860: SAVEPOINT BscColorRangePub_CrtColorRng;
861:

Line 877: FND_MSG_PUB.ADD;

873:
874: IF (p_time_stamp IS NOT NULL AND l_color_range_ids_rec.last_update_date IS NOT NULL
875: AND p_time_stamp <> l_color_range_ids_rec.last_update_date) THEN
876: FND_MESSAGE.SET_NAME('BSC','BSC_UPDATED_KPI_MEASURE');
877: FND_MSG_PUB.ADD;
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880: IF (p_kpi_measure_id IS NULL) THEN
881: UPDATE bsc_color_type_props

Line 991: FND_MSG_PUB.Count_And_Get

987: EXCEPTION
988: WHEN OTHERS THEN
989: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
990: IF (x_msg_data IS NULL) THEN
991: FND_MSG_PUB.Count_And_Get
992: ( p_encoded => FND_API.G_FALSE
993: ,p_count => x_msg_count
994: ,p_data => x_msg_data
995: );

Line 1019: FND_MSG_PUB.Initialize;

1015: l_range_id NUMBER;
1016: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1017: BEGIN
1018:
1019: FND_MSG_PUB.Initialize;
1020: x_return_status := FND_API.G_RET_STS_SUCCESS;
1021:
1022: SAVEPOINT BscColorRangePub_CrtColorRng;
1023:

Line 1063: FND_MSG_PUB.Count_And_Get

1059: EXCEPTION
1060: WHEN FND_API.G_EXC_ERROR THEN
1061: IF (x_msg_data IS NULL) THEN
1062: ROLLBACK TO BscColorRangePub_CrtColorRng;
1063: FND_MSG_PUB.Count_And_Get
1064: ( p_encoded => FND_API.G_FALSE
1065: , p_count => x_msg_count
1066: , p_data => x_msg_data
1067: );

Line 1072: FND_MSG_PUB.Count_And_Get

1068: END IF;
1069: x_return_status := FND_API.G_RET_STS_ERROR;
1070: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1071: IF (x_msg_data IS NULL) THEN
1072: FND_MSG_PUB.Count_And_Get
1073: ( p_encoded => FND_API.G_FALSE
1074: , p_count => x_msg_count
1075: , p_data => x_msg_data
1076: );

Line 1140: FND_MSG_PUB.Initialize;

1136: l_threshold_color VARCHAR2(2000);
1137: l_Bsc_Kpi_Color_Range_Rec BSC_COLOR_RANGES_PUB.Bsc_Color_Range_Rec;
1138: l_format_issue BOOLEAN:= FALSE;
1139: BEGIN
1140: FND_MSG_PUB.Initialize;
1141: x_return_status := FND_API.G_RET_STS_SUCCESS;
1142:
1143: IF(p_color_range_id IS NULL) THEN
1144: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_RANGE_ID_NULL');

Line 1145: FND_MSG_PUB.ADD;

1141: x_return_status := FND_API.G_RET_STS_SUCCESS;
1142:
1143: IF(p_color_range_id IS NULL) THEN
1144: FND_MESSAGE.SET_NAME('BSC','BSC_COLOR_RANGE_ID_NULL');
1145: FND_MSG_PUB.ADD;
1146: RAISE FND_API.G_EXC_ERROR;
1147: END IF;
1148:
1149: -- p_threshold_color value will be in format -> 1:20:345;2:40:345;3:80:456

Line 1188: FND_MSG_PUB.Count_And_Get

1184: EXCEPTION
1185: WHEN FND_API.G_EXC_ERROR THEN
1186: IF (x_msg_data IS NULL) THEN
1187: ROLLBACK TO BscColorRangePub_CrtColorRng;
1188: FND_MSG_PUB.Count_And_Get
1189: ( p_encoded => FND_API.G_FALSE
1190: , p_count => x_msg_count
1191: , p_data => x_msg_data
1192: );

Line 1197: FND_MSG_PUB.Count_And_Get

1193: END IF;
1194: x_return_status := FND_API.G_RET_STS_ERROR;
1195: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1196: IF (x_msg_data IS NULL) THEN
1197: FND_MSG_PUB.Count_And_Get
1198: ( p_encoded => FND_API.G_FALSE
1199: , p_count => x_msg_count
1200: , p_data => x_msg_data
1201: );

Line 1259: FND_MSG_PUB.Initialize;

1255: WHERE indicator = l_objective_id
1256: AND kpi_measure_id = l_kpi_measure_id;
1257:
1258: BEGIN
1259: FND_MSG_PUB.Initialize;
1260: x_return_status := FND_API.G_RET_STS_SUCCESS;
1261:
1262: SAVEPOINT BscColorRangePub_DelColorRng;
1263:

Line 1266: FND_MSG_PUB.ADD;

1262: SAVEPOINT BscColorRangePub_DelColorRng;
1263:
1264: IF(p_objective_id IS NULL) THEN
1265: FND_MESSAGE.SET_NAME('BSC','BSC_OBJECTIVE_ID_NULL');
1266: FND_MSG_PUB.ADD;
1267: RAISE FND_API.G_EXC_ERROR;
1268: END IF;
1269: l_objective_id := p_objective_id;
1270: l_kpi_measure_id := p_kpi_measure_id;

Line 1356: FND_MSG_PUB.Count_And_Get

1352: WHEN OTHERS THEN
1353: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1354: ROLLBACK TO BscColorRangePub_DelColorRng;
1355: IF (x_msg_data IS NULL) THEN
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_encoded => FND_API.G_FALSE
1358: ,p_count => x_msg_count
1359: ,p_data => x_msg_data
1360: );

Line 1393: FND_MSG_PUB.Initialize;

1389: AND share_flag = 2 -- shared objective.
1390: AND prototype_flag <> 2;
1391:
1392: BEGIN
1393: FND_MSG_PUB.Initialize;
1394: x_return_status := FND_API.G_RET_STS_SUCCESS;
1395:
1396: SAVEPOINT BscColorRangePub_DelColorRng;
1397:

Line 1400: FND_MSG_PUB.ADD;

1396: SAVEPOINT BscColorRangePub_DelColorRng;
1397:
1398: IF(p_color_range_id IS NULL) THEN
1399: FND_MESSAGE.SET_NAME('BSC','BSC_RANGE_ID_NULL');
1400: FND_MSG_PUB.ADD;
1401: RAISE FND_API.G_EXC_ERROR;
1402: END IF;
1403: -- ppandey get all the shared objectives and cascade the ranges to it.
1404: -- This is existing approach also, and it allows us to provide functionality

Line 1454: FND_MSG_PUB.Count_And_Get

1450: WHEN OTHERS THEN
1451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1452: ROLLBACK TO BscColorRangePub_DelColorRng;
1453: IF (x_msg_data IS NULL) THEN
1454: FND_MSG_PUB.Count_And_Get
1455: ( p_encoded => FND_API.G_FALSE
1456: ,p_count => x_msg_count
1457: ,p_data => x_msg_data
1458: );