APPS.AS_SCN_FORECAST_PUB dependencies on FND_API

Line 15: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE (Standard)

11: -- Pre-reqs:
12: --
13: -- IN PARAMETERS:
14: -- p_api_version_number IN NUMBER (Standard)
15: -- p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE (Standard)
16: -- p_check_access_flag IN VARCHAR2 (Standard - "Y" by default) to verify the access.
17: -- p_resource_id IN NUMBER (resource_id for which forecast needs to be collected
18: -- p_quota_id IN NUMBER (Plan Element ID )
19: -- p_period_name IN VARCHAR2 ( period name as in OSO)

Line 39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

35: -- End of Comments
36:
37: PROCEDURE Get_Forecast_Amounts (
38: p_api_version_number IN NUMBER,
39: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
40: p_check_access_flag IN VARCHAR2,
41: p_resource_id IN NUMBER,
42: p_quota_id IN NUMBER,
43: p_period_name IN VARCHAR2,

Line 58: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

54: l_status_code VARCHAR2(30);
55:
56: BEGIN
57: -- Standard call to check for call compatibility.
58: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
59: p_api_version_number,
60: l_api_name,
61: G_PKG_NAME) THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

58: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
59: p_api_version_number,
60: l_api_name,
61: G_PKG_NAME) THEN
62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 66: IF FND_API.to_Boolean( p_init_msg_list ) THEN

62: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
63: END IF;
64:
65: -- Initialize message list if p_init_msg_list is set to TRUE.
66: IF FND_API.to_Boolean( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 70: x_return_status := FND_API.G_RET_STS_SUCCESS;

66: IF FND_API.to_Boolean( p_init_msg_list ) THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69: -- Initialize API return status to SUCCESS
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
71: --
72: -- API body
73: --
74: AS_SCN_FORECAST_PVT.Get_Forecast_Amounts (

Line 76: p_init_msg_list => FND_API.G_FALSE,

72: -- API body
73: --
74: AS_SCN_FORECAST_PVT.Get_Forecast_Amounts (
75: p_api_version_number => 2.0,
76: p_init_msg_list => FND_API.G_FALSE,
77: p_check_access_flag => p_check_access_flag,
78: p_resource_id => p_resource_id,
79: p_quota_id => p_quota_id,
80: p_period_name => p_period_name,

Line 87: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

83: x_msg_count => x_msg_count,
84: x_msg_data => x_msg_data,
85: x_forecast_amount_tbl => x_forecast_amount_tbl);
86:
87: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:

Line 88: x_return_status := FND_API.G_RET_STS_ERROR;

84: x_msg_data => x_msg_data,
85: x_forecast_amount_tbl => x_forecast_amount_tbl);
86:
87: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: --

Line 89: RAISE FND_API.G_EXC_ERROR;

85: x_forecast_amount_tbl => x_forecast_amount_tbl);
86:
87: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
88: x_return_status := FND_API.G_RET_STS_ERROR;
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: --
93: -- End of API body

Line 101: WHEN FND_API.G_EXC_ERROR THEN

97: ( p_count => x_msg_count,
98: p_data => x_msg_data);
99:
100: EXCEPTION
101: WHEN FND_API.G_EXC_ERROR THEN
102: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
103: P_API_NAME => L_API_NAME
104: ,P_PKG_NAME => G_PKG_NAME
105: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

108: ,X_MSG_COUNT => X_MSG_COUNT
109: ,X_MSG_DATA => X_MSG_DATA
110: ,X_RETURN_STATUS => X_RETURN_STATUS);
111:
112: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
113: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
114: P_API_NAME => L_API_NAME
115: ,P_PKG_NAME => G_PKG_NAME
116: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR