APPS.AS_LEAD_ROUTING_WF_CUHK dependencies on FND_API

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

91: -- The above three parameters are standard output.
92: --
93: PROCEDURE Get_Owner_Pre(
94: p_api_version_number IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_resource_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
99: p_group_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,

Line 96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,

92: --
93: PROCEDURE Get_Owner_Pre(
94: p_api_version_number IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_resource_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
99: p_group_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
100: p_person_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,

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

93: PROCEDURE Get_Owner_Pre(
94: p_api_version_number IN NUMBER,
95: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
96: p_validation_level IN VARCHAR2 := FND_API.G_VALID_LEVEL_FULL,
97: p_commit IN VARCHAR2 := FND_API.G_FALSE,
98: p_resource_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
99: p_group_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
100: p_person_id_tbl IN AS_LEAD_ROUTING_WF.NUMBER_TABLE,
101: p_resource_flag_tbl IN AS_LEAD_ROUTING_WF.FLAG_TABLE,

Line 160: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

156: -- Standard Start of API savepoint
157: SAVEPOINT GET_OWNER_PRE_PVT;
158:
159: -- Standard call to check for call compatibility.
160: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
161: p_api_version_number,
162: l_api_name,
163: G_PKG_NAME)
164: THEN

Line 165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

161: p_api_version_number,
162: l_api_name,
163: G_PKG_NAME)
164: THEN
165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:
168: -- Initialize message list IF p_init_msg_list is set to TRUE.
169: IF FND_API.to_Boolean( p_init_msg_list )

Line 169: IF FND_API.to_Boolean( p_init_msg_list )

165: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
166: END IF;
167:
168: -- Initialize message list IF p_init_msg_list is set to TRUE.
169: IF FND_API.to_Boolean( p_init_msg_list )
170: THEN
171: FND_MSG_PUB.initialize;
172: END IF;
173:

Line 179: x_return_status := FND_API.G_RET_STS_SUCCESS;

175: AS_UTILITY_PVT.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,
176: 'PVT:' || l_api_name || ' Start');
177:
178: -- Initialize API return status to SUCCESS
179: x_return_status := FND_API.G_RET_STS_SUCCESS;
180:
181: --
182: -- Api body
183: --

Line 198: RAISE FND_API.G_EXC_ERROR;

194: p_msg_name => 'UT_CANNOT_GET_PROFILE_VALUE',
195: p_token1 => 'PROFILE',
196: p_token1_value => 'USER_ID');
197: END IF;
198: RAISE FND_API.G_EXC_ERROR;
199: END IF;
200:
201: -- For Oracle internal use, p_resource_id_tbl, p_person_id_tbl,
202: -- p_group_id_tbl, p_resource_flag_tbl are all NULL. p_sales_lead_rec

Line 249: IF FND_API.to_Boolean( p_commit )

245: -- END of API body
246: --
247:
248: -- Standard check for p_commit
249: IF FND_API.to_Boolean( p_commit )
250: THEN
251: COMMIT WORK;
252: END IF;
253:

Line 264: WHEN FND_API.G_EXC_ERROR THEN

260: ( p_count => x_msg_count,
261: p_data => x_msg_data );
262:
263: EXCEPTION
264: WHEN FND_API.G_EXC_ERROR THEN
265: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
266: P_API_NAME => L_API_NAME
267: ,P_PKG_NAME => G_PKG_NAME
268: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

270: ,X_MSG_COUNT => X_MSG_COUNT
271: ,X_MSG_DATA => X_MSG_DATA
272: ,X_RETURN_STATUS => X_RETURN_STATUS);
273:
274: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
275: AS_UTILITY_PVT.HANDLE_EXCEPTIONS(
276: P_API_NAME => L_API_NAME
277: ,P_PKG_NAME => G_PKG_NAME
278: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR