14: l_Anal_Opt_Rec BSC_ANALYSIS_OPTION_PUB.Bsc_Option_Rec_Type;
15:
16: l_msg_count number;
17:
18: l_commit varchar2(100) := FND_API.G_TRUE;
19: l_return_status varchar2(100);
20: l_msg_data varchar2(100);
21: l_sql varchar2(2000);
22:
55: end loop;
56: close dc_value;
57:
58: EXCEPTION
59: WHEN FND_API.G_EXC_ERROR THEN
60: rollback;
61: l_return_status := FND_API.G_RET_STS_ERROR;
62: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
63: ,p_data => l_msg_data);
57:
58: EXCEPTION
59: WHEN FND_API.G_EXC_ERROR THEN
60: rollback;
61: l_return_status := FND_API.G_RET_STS_ERROR;
62: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
63: ,p_data => l_msg_data);
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: rollback;
60: rollback;
61: l_return_status := FND_API.G_RET_STS_ERROR;
62: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
63: ,p_data => l_msg_data);
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: rollback;
66: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
68: ,p_data => l_msg_data);
62: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
63: ,p_data => l_msg_data);
64: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
65: rollback;
66: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
67: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
68: ,p_data => l_msg_data);
69: WHEN NO_DATA_FOUND THEN
70: rollback;
67: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
68: ,p_data => l_msg_data);
69: WHEN NO_DATA_FOUND THEN
70: rollback;
71: l_return_status := FND_API.G_RET_STS_ERROR;
72: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
73: ,p_data => l_msg_data);
74: WHEN OTHERS THEN
75: rollback;
72: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
73: ,p_data => l_msg_data);
74: WHEN OTHERS THEN
75: rollback;
76: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
77: FND_MSG_PUB.Count_And_Get( p_count => l_msg_count
78: ,p_data => l_msg_data);
79:
80: