111: IF FND_API.To_Boolean(p_commit) THEN
112: COMMIT WORK;
113: END IF;
114: -- Standard callto get message count and if count is 1, get message info.
115: FND_MSG_PUB.Count_And_Get
116: ( p_count => x_msg_count,
117: p_data => x_msg_data
118: );
119: EXCEPTION
118: );
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: x_return_status := FND_API.G_RET_STS_ERROR ;
122: FND_MSG_PUB.Count_And_Get
123: ( p_count => x_msg_count,
124: p_data => x_msg_data
125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
124: p_data => x_msg_data
125: );
126: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
127: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
128: FND_MSG_PUB.Count_And_Get
129: ( p_count => x_msg_count,
130: p_data => x_msg_data
131: );
132: WHEN OTHERS THEN
130: p_data => x_msg_data
131: );
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level
135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME ,
131: );
132: WHEN OTHERS THEN
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level
135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME ,
139: l_api_name
133: x_return_status := FND_API.G_RET_STS_ERROR;
134: IF FND_MSG_PUB.Check_Msg_Level
135: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
136: THEN
137: FND_MSG_PUB.Add_Exc_Msg
138: ( G_PKG_NAME ,
139: l_api_name
140: );
141: END IF;
138: ( G_PKG_NAME ,
139: l_api_name
140: );
141: END IF;
142: FND_MSG_PUB.Count_And_Get
143: ( p_count => x_msg_count ,
144: p_data => x_msg_data
145: );
146:
178: IF FND_API.To_Boolean(p_commit) THEN
179: COMMIT WORK;
180: END IF;
181: -- Standard callto get message count and if count is 1, get message info.
182: FND_MSG_PUB.Count_And_Get
183: ( p_count => x_msg_count,
184: p_data => x_msg_data
185: );
186: EXCEPTION
186: EXCEPTION
187: WHEN FND_API.G_EXC_ERROR THEN
188: ROLLBACK TO select_item_pvt;
189: x_return_status := FND_API.G_RET_STS_ERROR ;
190: FND_MSG_PUB.Count_And_Get
191: ( p_count => x_msg_count,
192: p_data => x_msg_data
193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
193: );
194: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
195: ROLLBACK TO select_item_pvt;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
197: FND_MSG_PUB.Count_And_Get
198: ( p_count => x_msg_count,
199: p_data => x_msg_data
200: );
201: WHEN OTHERS THEN
200: );
201: WHEN OTHERS THEN
202: ROLLBACK TO select_item_pvt;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,
201: WHEN OTHERS THEN
202: ROLLBACK TO select_item_pvt;
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,
209: l_api_name
203: x_return_status := FND_API.G_RET_STS_ERROR;
204: IF FND_MSG_PUB.Check_Msg_Level
205: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
206: THEN
207: FND_MSG_PUB.Add_Exc_Msg
208: ( G_PKG_NAME ,
209: l_api_name
210: );
211: END IF;
208: ( G_PKG_NAME ,
209: l_api_name
210: );
211: END IF;
212: FND_MSG_PUB.Count_And_Get
213: ( p_count => x_msg_count ,
214: p_data => x_msg_data
215: );
216:
245:
246: -- Initialize message list if p_init_msg_list is set to TRUE.
247: IF FND_API.to_Boolean( p_init_msg_list )
248: THEN
249: FND_MSG_PUB.initialize;
250: END IF;
251:
252: -- Initialize API return status to SUCCESS
253: x_return_status := FND_API.G_RET_STS_SUCCESS;
290: EXCEPTION
291: WHEN CREATE_ITEM_EXCP THEN
292: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
293: x_return_status := FND_API.G_RET_STS_ERROR ;
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
294: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
295: WHEN FND_API.G_EXC_ERROR THEN
296: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
297: x_return_status := FND_API.G_RET_STS_ERROR ;
298: FND_MSG_PUB.Count_And_Get
299: ( p_count => x_msg_count,
300: p_data => x_msg_data
301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
301: );
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
303: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
304: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
305: FND_MSG_PUB.Count_And_Get
306: ( p_count => x_msg_count,
307: p_data => x_msg_data
308: );
309: WHEN OTHERS THEN
308: );
309: WHEN OTHERS THEN
310: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level
313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: FND_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,
309: WHEN OTHERS THEN
310: ROLLBACK TO CREATE_ITEM_WRAP_PVT;
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level
313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: FND_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,
317: l_api_name
311: x_return_status := FND_API.G_RET_STS_ERROR;
312: IF FND_MSG_PUB.Check_Msg_Level
313: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
314: THEN
315: FND_MSG_PUB.Add_Exc_Msg
316: ( G_PKG_NAME ,
317: l_api_name
318: );
319: END IF;
316: ( G_PKG_NAME ,
317: l_api_name
318: );
319: END IF;
320: FND_MSG_PUB.Count_And_Get
321: ( p_count => x_msg_count ,
322: p_data => x_msg_data
323: );
324: END create_item_wrap;