39: l_effect_indicator NUMBER;
40:
41: BEGIN
42:
43: FND_MSG_PUB.Initialize;
44:
45: -- Get and array with the causes
46:
47: l_num_causes := 0;
109:
110: IF l_invalid_indicators IS NOT NULL THEN
111: FND_MESSAGE.SET_NAME('BSC','BSC_CAE_USED_AT_SAME_TIME');
112: FND_MESSAGE.SET_TOKEN('LIST', l_invalid_indicators);
113: FND_MSG_PUB.ADD;
114: RAISE FND_API.G_EXC_ERROR;
115: END IF;
116:
117:
173: EXCEPTION
174: WHEN FND_API.G_EXC_ERROR THEN
175: rollback;
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: rollback;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
178: ,p_data => x_msg_data);
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: rollback;
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
182: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
183: ,p_data => x_msg_data);
184: WHEN NO_DATA_FOUND THEN
185: rollback;
186: x_return_status := FND_API.G_RET_STS_ERROR;
183: ,p_data => x_msg_data);
184: WHEN NO_DATA_FOUND THEN
185: rollback;
186: x_return_status := FND_API.G_RET_STS_ERROR;
187: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
188: ,p_data => x_msg_data);
189: WHEN OTHERS THEN
190: rollback;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
188: ,p_data => x_msg_data);
189: WHEN OTHERS THEN
190: rollback;
191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
192: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
193: ,p_data => x_msg_data);
194:
195: END Apply_Cause_Effect_Rels;
196:
430: l_ranking_parameter VARCHAR2(32000);
431:
432: BEGIN
433:
434: FND_MSG_PUB.Initialize;
435:
436: x_indicator_link := NULL;
437:
438: IF p_level = 'DATASET' THEN
600: EXCEPTION
601: WHEN FND_API.G_EXC_ERROR THEN
602: rollback;
603: x_return_status := FND_API.G_RET_STS_ERROR;
604: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
605: ,p_data => x_msg_data);
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: rollback;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605: ,p_data => x_msg_data);
606: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
607: rollback;
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
610: ,p_data => x_msg_data);
611: WHEN NO_DATA_FOUND THEN
612: rollback;
613: x_return_status := FND_API.G_RET_STS_ERROR;
610: ,p_data => x_msg_data);
611: WHEN NO_DATA_FOUND THEN
612: rollback;
613: x_return_status := FND_API.G_RET_STS_ERROR;
614: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
615: ,p_data => x_msg_data);
616: WHEN OTHERS THEN
617: rollback;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: ,p_data => x_msg_data);
616: WHEN OTHERS THEN
617: rollback;
618: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
619: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
620: ,p_data => x_msg_data);
621:
622: END Get_Indicator_Link;
623: