DBA Data[Home] [Help]

APPS.BSC_OPTION_WRAPPER dependencies on FND_API

Line 18: l_commit varchar2(100) := FND_API.G_TRUE;

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:

Line 59: WHEN FND_API.G_EXC_ERROR THEN

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

Line 61: l_return_status := FND_API.G_RET_STS_ERROR;

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;

Line 64: WHEN FND_API.G_EXC_UNEXPECTED_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;
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);

Line 66: l_return_status := FND_API.G_RET_STS_UNEXP_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);
69: WHEN NO_DATA_FOUND THEN
70: rollback;

Line 71: l_return_status := FND_API.G_RET_STS_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;
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;

Line 76: l_return_status := FND_API.G_RET_STS_UNEXP_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;
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: