58: END IF;
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64: -- Initialize API return status to SUCCESS
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
128: p_ATTRIBUTE15
129: );
130:
131: -- Standard callto get message count and if count is 1, get message info.
132: FND_MSG_PUB.Count_And_Get
133: ( p_count => x_msg_count,
134: p_data => x_msg_data
135: );
136: EXCEPTION
136: EXCEPTION
137: WHEN FND_API.G_EXC_ERROR THEN
138: ROLLBACK TO create_item_PVT;
139: x_return_status := FND_API.G_RET_STS_ERROR ;
140: FND_MSG_PUB.Count_And_Get
141: ( p_count => x_msg_count,
142: p_data => x_msg_data
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
143: );
144: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
145: ROLLBACK TO create_item_PVT;
146: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
147: FND_MSG_PUB.Count_And_Get
148: ( p_count => x_msg_count,
149: p_data => x_msg_data
150: );
151: WHEN OTHERS THEN
150: );
151: WHEN OTHERS THEN
152: ROLLBACK TO create_item_PVT;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: ( G_PKG_NAME ,
151: WHEN OTHERS THEN
152: ROLLBACK TO create_item_PVT;
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: ( G_PKG_NAME ,
159: l_api_name
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: IF FND_MSG_PUB.Check_Msg_Level
155: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
156: THEN
157: FND_MSG_PUB.Add_Exc_Msg
158: ( G_PKG_NAME ,
159: l_api_name
160: );
161: END IF;
158: ( G_PKG_NAME ,
159: l_api_name
160: );
161: END IF;
162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count ,
164: p_data => x_msg_data
165: );
166:
192: END IF;
193: -- Initialize message list if p_init_msg_list is set to TRUE.
194: IF FND_API.to_Boolean( p_init_msg_list )
195: THEN
196: FND_MSG_PUB.initialize;
197: END IF;
198: -- Initialize API return status to SUCCESS
199: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
211: IF FND_API.To_Boolean(p_commit) THEN
212: COMMIT WORK;
213: END IF;
214: -- Standard callto get message count and if count is 1, get message info.
215: FND_MSG_PUB.Count_And_Get
216: ( p_count => x_msg_count,
217: p_data => x_msg_data
218: );
219: EXCEPTION
219: EXCEPTION
220: WHEN FND_API.G_EXC_ERROR THEN
221: ROLLBACK TO delete_item_PVT;
222: x_return_status := FND_API.G_RET_STS_ERROR ;
223: FND_MSG_PUB.Count_And_Get
224: ( p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
226: );
227: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
228: ROLLBACK TO delete_item_PVT;
229: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
230: FND_MSG_PUB.Count_And_Get
231: ( p_count => x_msg_count,
232: p_data => x_msg_data
233: );
234: WHEN OTHERS THEN
233: );
234: WHEN OTHERS THEN
235: ROLLBACK TO delete_item_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME ,
234: WHEN OTHERS THEN
235: ROLLBACK TO delete_item_PVT;
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME ,
242: l_api_name
236: x_return_status := FND_API.G_RET_STS_ERROR;
237: IF FND_MSG_PUB.Check_Msg_Level
238: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
239: THEN
240: FND_MSG_PUB.Add_Exc_Msg
241: ( G_PKG_NAME ,
242: l_api_name
243: );
244: END IF;
241: ( G_PKG_NAME ,
242: l_api_name
243: );
244: END IF;
245: FND_MSG_PUB.Count_And_Get
246: ( p_count => x_msg_count ,
247: p_data => x_msg_data
248: );
249:
301: END IF;
302: -- Initialize message list if p_init_msg_list is set to TRUE.
303: IF FND_API.to_Boolean( p_init_msg_list )
304: THEN
305: FND_MSG_PUB.initialize;
306: END IF;
307: -- Initialize API return status to SUCCESS
308: x_return_status := FND_API.G_RET_STS_SUCCESS;
309:
338: IF FND_API.To_Boolean(p_commit) THEN
339: COMMIT WORK;
340: END IF;
341: -- Standard callto get message count and if count is 1, get message info.
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count,
344: p_data => x_msg_data
345: );
346: EXCEPTION
346: EXCEPTION
347: WHEN FND_API.G_EXC_ERROR THEN
348: ROLLBACK TO update_item_PVT;
349: x_return_status := FND_API.G_RET_STS_ERROR ;
350: FND_MSG_PUB.Count_And_Get
351: ( p_count => x_msg_count,
352: p_data => x_msg_data
353: );
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
353: );
354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
355: ROLLBACK TO update_item_PVT;
356: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
357: FND_MSG_PUB.Count_And_Get
358: ( p_count => x_msg_count,
359: p_data => x_msg_data
360: );
361: WHEN OTHERS THEN
360: );
361: WHEN OTHERS THEN
362: ROLLBACK TO update_item_PVT;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF FND_MSG_PUB.Check_Msg_Level
365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME ,
361: WHEN OTHERS THEN
362: ROLLBACK TO update_item_PVT;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF FND_MSG_PUB.Check_Msg_Level
365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME ,
369: l_api_name
363: x_return_status := FND_API.G_RET_STS_ERROR;
364: IF FND_MSG_PUB.Check_Msg_Level
365: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
366: THEN
367: FND_MSG_PUB.Add_Exc_Msg
368: ( G_PKG_NAME ,
369: l_api_name
370: );
371: END IF;
368: ( G_PKG_NAME ,
369: l_api_name
370: );
371: END IF;
372: FND_MSG_PUB.Count_And_Get
373: ( p_count => x_msg_count ,
374: p_data => x_msg_data
375: );
376: