DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALIDATIONS_PUB dependencies on FND_API

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

22:
23:
24: PROCEDURE Update_Attr_Validations(
25: p_api_version_number IN NUMBER
26: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
27: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
28: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
29:
30: ,x_return_status OUT NOCOPY VARCHAR2

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

23:
24: PROCEDURE Update_Attr_Validations(
25: p_api_version_number IN NUMBER
26: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
27: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
28: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
29:
30: ,x_return_status OUT NOCOPY VARCHAR2
31: ,x_msg_count OUT NOCOPY NUMBER

Line 28: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

24: PROCEDURE Update_Attr_Validations(
25: p_api_version_number IN NUMBER
26: ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
27: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
28: ,p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
29:
30: ,x_return_status OUT NOCOPY VARCHAR2
31: ,x_msg_count OUT NOCOPY NUMBER
32: ,x_msg_data OUT NOCOPY VARCHAR2

Line 69: IF NOT FND_API.Compatible_API_Call (

65: -- Standard Start of API savepoint
66: SAVEPOINT Update_Attr_Validations_PUB;
67:
68: -- Standard call to check for call compatibility.
69: IF NOT FND_API.Compatible_API_Call (
70: l_api_version_number
71: ,p_api_version_number
72: ,l_api_name
73: ,G_PKG_NAME

Line 76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

72: ,l_api_name
73: ,G_PKG_NAME
74: )
75: THEN
76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean( p_init_msg_list )

Line 80: IF FND_API.to_Boolean( p_init_msg_list )

76: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
77: END IF;
78:
79: -- Initialize message list if p_init_msg_list is set to TRUE.
80: IF FND_API.to_Boolean( p_init_msg_list )
81: THEN
82: FND_MSG_PUB.initialize;
83: END IF;
84:

Line 92: x_return_status := FND_API.G_RET_STS_SUCCESS;

88: END IF;
89:
90:
91: -- Initialize API return status to SUCCESS
92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93:
94: --first call validations API, get valiodation id and update entity_attr_values API with that validation_id
95: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
96: PVX_Utility_PVT.debug_message('Public API: '||l_full_name||' - calling PV_ENTY_ATTR_VALIDATIONS_PVT.Create_Enty_Attr_Validation');

Line 112: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

108: ,p_enty_attr_validation_rec => p_enty_attr_validation_rec
109: ,x_enty_attr_validation_id => l_enty_attr_validation_id
110: );
111:
112: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116:

Line 113: RAISE FND_API.G_EXC_ERROR;

109: ,x_enty_attr_validation_id => l_enty_attr_validation_id
110: );
111:
112: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:
116:
117:

Line 174: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

170: ,p_enty_attr_val_rec => l_tar_enty_attr_val_rec
171: ,x_object_version_number => l_object_version_number
172: );
173:
174: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178: l_count := l_count +1;

Line 175: RAISE FND_API.G_EXC_ERROR;

171: ,x_object_version_number => l_object_version_number
172: );
173:
174: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
175: RAISE FND_API.G_EXC_ERROR;
176: END IF;
177:
178: l_count := l_count +1;
179: END LOOP;

Line 195: RAISE FND_API.G_EXC_ERROR;

191: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
192: FND_MESSAGE.set_token('ID','Entity:' || p_entity || ' entity id:' || p_entity_id || ' attribute id:' || p_attribute_id);
193: FND_MSG_PUB.add;
194: END IF;
195: RAISE FND_API.G_EXC_ERROR;
196: end if;
197:
198:
199:

Line 205: IF FND_API.to_Boolean( p_commit )

201: -- End of API body.
202: --
203:
204: -- Standard check for p_commit
205: IF FND_API.to_Boolean( p_commit )
206: THEN
207: COMMIT WORK;
208: END IF;
209:

Line 223: x_return_status := FND_API.g_ret_sts_error;

219: );
220: EXCEPTION
221: /*
222: WHEN PVX_Utility_PVT.resource_locked THEN
223: x_return_status := FND_API.g_ret_sts_error;
224: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
225: */
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO Update_Attr_Validations_PUB;

Line 226: WHEN FND_API.G_EXC_ERROR THEN

222: WHEN PVX_Utility_PVT.resource_locked THEN
223: x_return_status := FND_API.g_ret_sts_error;
224: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
225: */
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO Update_Attr_Validations_PUB;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: -- Standard call to get message count and if count=1, get the message
230: FND_MSG_PUB.Count_And_Get (

Line 228: x_return_status := FND_API.G_RET_STS_ERROR;

224: PVX_Utility_PVT.Error_Message(p_message_name => 'PV_API_RESOURCE_LOCKED');
225: */
226: WHEN FND_API.G_EXC_ERROR THEN
227: ROLLBACK TO Update_Attr_Validations_PUB;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: -- Standard call to get message count and if count=1, get the message
230: FND_MSG_PUB.Count_And_Get (
231: p_encoded => FND_API.G_FALSE
232: ,p_count => x_msg_count

Line 231: p_encoded => FND_API.G_FALSE

227: ROLLBACK TO Update_Attr_Validations_PUB;
228: x_return_status := FND_API.G_RET_STS_ERROR;
229: -- Standard call to get message count and if count=1, get the message
230: FND_MSG_PUB.Count_And_Get (
231: p_encoded => FND_API.G_FALSE
232: ,p_count => x_msg_count
233: ,p_data => x_msg_data
234: );
235:

Line 236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

232: ,p_count => x_msg_count
233: ,p_data => x_msg_data
234: );
235:
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO Update_Attr_Validations_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (

Line 238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

234: );
235:
236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
237: ROLLBACK TO Update_Attr_Validations_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.G_FALSE
242: ,p_count => x_msg_count

Line 241: p_encoded => FND_API.G_FALSE

237: ROLLBACK TO Update_Attr_Validations_PUB;
238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
239: -- Standard call to get message count and if count=1, get the message
240: FND_MSG_PUB.Count_And_Get (
241: p_encoded => FND_API.G_FALSE
242: ,p_count => x_msg_count
243: ,p_data => x_msg_data
244: );
245:

Line 248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

244: );
245:
246: WHEN OTHERS THEN
247: ROLLBACK TO Update_Attr_Validations_PUB;
248: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
249: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
250: THEN
251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;

Line 255: p_encoded => FND_API.G_FALSE

251: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
252: END IF;
253: -- Standard call to get message count and if count=1, get the message
254: FND_MSG_PUB.Count_And_Get (
255: p_encoded => FND_API.G_FALSE
256: ,p_count => x_msg_count
257: ,p_data => x_msg_data
258: );
259: End Update_Attr_Validations;