DBA Data[Home] [Help]

APPS.AS_SCORECARD_PUB dependencies on FND_API

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

23: AS_DEBUG_ERROR_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_ERROR);
24:
25: Procedure Get_Score (
26: p_api_version IN NUMBER := 2.0,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
30: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_sales_lead_id IN NUMBER,

Line 28: p_commit IN VARCHAR2 := FND_API.G_FALSE,

24:
25: Procedure Get_Score (
26: p_api_version IN NUMBER := 2.0,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
30: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_sales_lead_id IN NUMBER,
32: p_scorecard_id IN NUMBER,

Line 30: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,

26: p_api_version IN NUMBER := 2.0,
27: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
28: p_commit IN VARCHAR2 := FND_API.G_FALSE,
29: p_validation_level IN NUMBER := AS_UTILITY_PUB.G_VALID_LEVEL_ITEM,
30: P_Check_Access_Flag IN VARCHAR2 := FND_API.G_MISS_CHAR,
31: p_sales_lead_id IN NUMBER,
32: p_scorecard_id IN NUMBER,
33: -- swkhanna 2260459
34: p_marketing_score IN NUMBER := 0,

Line 55: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

51: -- Standard Start of API savepoint
52: SAVEPOINT GET_SCORE_PUB;
53:
54: -- Standard call to check for call compatibility.
55: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
56: p_api_version,
57: l_api_name,
58: G_PKG_NAME)
59: THEN

Line 60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

56: p_api_version,
57: l_api_name,
58: G_PKG_NAME)
59: THEN
60: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
61: END IF;
62:
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 65: IF FND_API.to_Boolean( p_init_msg_list )

61: END IF;
62:
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list )
66: THEN
67: FND_MSG_PUB.initialize;
68: END IF;
69:

Line 84: x_return_status := FND_API.G_RET_STS_SUCCESS;

80: END IF;
81:
82:
83: -- Initialize API return status to SUCCESS
84: x_return_status := FND_API.G_RET_STS_SUCCESS;
85:
86: --
87: -- API body
88: --

Line 100: p_init_msg_list => FND_API.G_FALSE,

96:
97: -- implement AS_SCORECARD_PVT here
98: AS_SCORECARD_PVT.Get_Score (
99: p_api_version => 2.0,
100: p_init_msg_list => FND_API.G_FALSE,
101: p_commit => FND_API.G_FALSE, -- p_commit,
102: p_validation_level => p_validation_level,
103: p_check_access_flag => p_check_access_flag,
104: p_sales_lead_id => p_sales_lead_id,

Line 101: p_commit => FND_API.G_FALSE, -- p_commit,

97: -- implement AS_SCORECARD_PVT here
98: AS_SCORECARD_PVT.Get_Score (
99: p_api_version => 2.0,
100: p_init_msg_list => FND_API.G_FALSE,
101: p_commit => FND_API.G_FALSE, -- p_commit,
102: p_validation_level => p_validation_level,
103: p_check_access_flag => p_check_access_flag,
104: p_sales_lead_id => p_sales_lead_id,
105: p_scorecard_id => p_scorecard_id,

Line 118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

114: x_msg_count => l_msg_count,
115: x_msg_data => l_msg_data);
116:
117:
118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;

Line 119: RAISE FND_API.G_EXC_ERROR;

115: x_msg_data => l_msg_data);
116:
117:
118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:

Line 120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

116:
117:
118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: --

Line 121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

117:
118: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
119: RAISE FND_API.G_EXC_ERROR;
120: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
121: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
122: END IF;
123:
124: --
125: -- End of API body

Line 129: IF FND_API.to_Boolean( p_commit )

125: -- End of API body
126: --
127:
128: -- Standard check for p_commit
129: IF FND_API.to_Boolean( p_commit )
130: THEN
131: COMMIT WORK;
132: END IF;
133:

Line 154: WHEN FND_API.G_EXC_ERROR THEN

150: p_data => x_msg_data
151: );
152:
153: EXCEPTION
154: WHEN FND_API.G_EXC_ERROR THEN
155: as_utility_pvt.HANDLE_EXCEPTIONS(
156: P_API_NAME => L_API_NAME
157: ,P_PKG_NAME => G_PKG_NAME
158: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

160: ,X_MSG_COUNT => X_MSG_COUNT
161: ,X_MSG_DATA => X_MSG_DATA
162: ,X_RETURN_STATUS => X_RETURN_STATUS);
163:
164: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
165: as_utility_pvt.HANDLE_EXCEPTIONS(
166: P_API_NAME => L_API_NAME
167: ,P_PKG_NAME => G_PKG_NAME
168: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR