33: END IF;
34: -- Initialize message list if p_init_msg_list is set to TRUE.
35: IF FND_API.to_Boolean( p_init_msg_list )
36: THEN
37: FND_MSG_PUB.initialize;
38: END IF;
39: -- Initialize API return status to SUCCESS
40: x_return_status := FND_API.G_RET_STS_SUCCESS;
41:
67: IF FND_API.To_Boolean(p_commit) THEN
68: COMMIT WORK;
69: END IF;
70: -- Standard callto get message count and if count is 1, get message info.
71: FND_MSG_PUB.Count_And_Get
72: ( p_count => x_msg_count,
73: p_data => x_msg_data
74: );
75:
77:
78: WHEN FND_API.G_EXC_ERROR THEN
79: ROLLBACK TO create_item_PVT;
80: x_return_status := FND_API.G_RET_STS_ERROR ;
81: FND_MSG_PUB.Count_And_Get
82: ( p_count => x_msg_count,
83: p_data => x_msg_data
84: );
85:
85:
86: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
87: ROLLBACK TO create_item_PVT;
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
89: FND_MSG_PUB.Count_And_Get
90: ( p_count => x_msg_count,
91: p_data => x_msg_data
92: );
93:
93:
94: WHEN OTHERS THEN
95: ROLLBACK TO create_item_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level
98: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
99: THEN
100: FND_MSG_PUB.Add_Exc_Msg
101: ( G_PKG_NAME ,
94: WHEN OTHERS THEN
95: ROLLBACK TO create_item_PVT;
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level
98: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
99: THEN
100: FND_MSG_PUB.Add_Exc_Msg
101: ( G_PKG_NAME ,
102: l_api_name
96: x_return_status := FND_API.G_RET_STS_ERROR;
97: IF FND_MSG_PUB.Check_Msg_Level
98: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
99: THEN
100: FND_MSG_PUB.Add_Exc_Msg
101: ( G_PKG_NAME ,
102: l_api_name
103: );
104: END IF;
101: ( G_PKG_NAME ,
102: l_api_name
103: );
104: END IF;
105: FND_MSG_PUB.Count_And_Get
106: ( p_count => x_msg_count ,
107: p_data => x_msg_data
108: );
109:
139: END IF;
140: -- Initialize message list if p_init_msg_list is set to TRUE.
141: IF FND_API.to_Boolean( p_init_msg_list )
142: THEN
143: FND_MSG_PUB.initialize;
144: END IF;
145: -- Initialize API return status to SUCCESS
146: x_return_status := FND_API.G_RET_STS_SUCCESS;
147:
158: IF FND_API.To_Boolean(p_commit) THEN
159: COMMIT WORK;
160: END IF;
161: -- Standard callto get message count and if count is 1, get message info.
162: FND_MSG_PUB.Count_And_Get
163: ( p_count => x_msg_count,
164: p_data => x_msg_data
165: );
166: EXCEPTION
167:
168: WHEN FND_API.G_EXC_ERROR THEN
169: ROLLBACK TO update_item_PVT;
170: x_return_status := FND_API.G_RET_STS_ERROR ;
171: FND_MSG_PUB.Count_And_Get
172: ( p_count => x_msg_count,
173: p_data => x_msg_data
174: );
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: );
175: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
176: ROLLBACK TO update_item_PVT;
177: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
178: FND_MSG_PUB.Count_And_Get
179: ( p_count => x_msg_count,
180: p_data => x_msg_data
181: );
182: WHEN OTHERS THEN
181: );
182: WHEN OTHERS THEN
183: ROLLBACK TO update_item_PVT;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: IF FND_MSG_PUB.Check_Msg_Level
186: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: FND_MSG_PUB.Add_Exc_Msg
189: ( G_PKG_NAME ,
182: WHEN OTHERS THEN
183: ROLLBACK TO update_item_PVT;
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: IF FND_MSG_PUB.Check_Msg_Level
186: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: FND_MSG_PUB.Add_Exc_Msg
189: ( G_PKG_NAME ,
190: l_api_name
184: x_return_status := FND_API.G_RET_STS_ERROR;
185: IF FND_MSG_PUB.Check_Msg_Level
186: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
187: THEN
188: FND_MSG_PUB.Add_Exc_Msg
189: ( G_PKG_NAME ,
190: l_api_name
191: );
192: END IF;
189: ( G_PKG_NAME ,
190: l_api_name
191: );
192: END IF;
193: FND_MSG_PUB.Count_And_Get
194: ( p_count => x_msg_count ,
195: p_data => x_msg_data
196: );
197:
221: END IF;
222: -- Initialize message list if p_init_msg_list is set to TRUE.
223: IF FND_API.to_Boolean( p_init_msg_list )
224: THEN
225: FND_MSG_PUB.initialize;
226: END IF;
227: -- Initialize API return status to SUCCESS
228: x_return_status := FND_API.G_RET_STS_SUCCESS;
229:
234: IF FND_API.To_Boolean(p_commit) THEN
235: COMMIT WORK;
236: END IF;
237: -- Standard callto get message count and if count is 1, get message info.
238: FND_MSG_PUB.Count_And_Get
239: ( p_count => x_msg_count,
240: p_data => x_msg_data
241: );
242: EXCEPTION
242: EXCEPTION
243: WHEN FND_API.G_EXC_ERROR THEN
244: ROLLBACK TO delete_item_PVT;
245: x_return_status := FND_API.G_RET_STS_ERROR ;
246: FND_MSG_PUB.Count_And_Get
247: ( p_count => x_msg_count,
248: p_data => x_msg_data
249: );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: );
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: ROLLBACK TO delete_item_PVT;
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
253: FND_MSG_PUB.Count_And_Get
254: ( p_count => x_msg_count,
255: p_data => x_msg_data
256: );
257: WHEN OTHERS THEN
256: );
257: WHEN OTHERS THEN
258: ROLLBACK TO delete_item_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: IF FND_MSG_PUB.Check_Msg_Level
261: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
262: THEN
263: FND_MSG_PUB.Add_Exc_Msg
264: ( G_PKG_NAME ,
257: WHEN OTHERS THEN
258: ROLLBACK TO delete_item_PVT;
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: IF FND_MSG_PUB.Check_Msg_Level
261: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
262: THEN
263: FND_MSG_PUB.Add_Exc_Msg
264: ( G_PKG_NAME ,
265: l_api_name
259: x_return_status := FND_API.G_RET_STS_ERROR;
260: IF FND_MSG_PUB.Check_Msg_Level
261: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
262: THEN
263: FND_MSG_PUB.Add_Exc_Msg
264: ( G_PKG_NAME ,
265: l_api_name
266: );
267: END IF;
264: ( G_PKG_NAME ,
265: l_api_name
266: );
267: END IF;
268: FND_MSG_PUB.Count_And_Get
269: ( p_count => x_msg_count ,
270: p_data => x_msg_data
271: );
272:
295: END IF;
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297: IF FND_API.to_Boolean( p_init_msg_list )
298: THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301: -- Initialize API return status to SUCCESS
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
308: IF FND_API.To_Boolean(p_commit) THEN
309: COMMIT WORK;
310: END IF;
311: -- Standard callto get message count and if count is 1, get message info.
312: FND_MSG_PUB.Count_And_Get
313: ( p_count => x_msg_count,
314: p_data => x_msg_data
315: );
316: EXCEPTION
316: EXCEPTION
317: WHEN FND_API.G_EXC_ERROR THEN
318: ROLLBACK TO delete_item_PVT;
319: x_return_status := FND_API.G_RET_STS_ERROR ;
320: FND_MSG_PUB.Count_And_Get
321: ( p_count => x_msg_count,
322: p_data => x_msg_data
323: );
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
323: );
324: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
325: ROLLBACK TO delete_item_PVT;
326: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
327: FND_MSG_PUB.Count_And_Get
328: ( p_count => x_msg_count,
329: p_data => x_msg_data
330: );
331: WHEN OTHERS THEN
330: );
331: WHEN OTHERS THEN
332: ROLLBACK TO delete_item_PVT;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: IF FND_MSG_PUB.Check_Msg_Level
335: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: ( G_PKG_NAME ,
331: WHEN OTHERS THEN
332: ROLLBACK TO delete_item_PVT;
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: IF FND_MSG_PUB.Check_Msg_Level
335: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: ( G_PKG_NAME ,
339: l_api_name
333: x_return_status := FND_API.G_RET_STS_ERROR;
334: IF FND_MSG_PUB.Check_Msg_Level
335: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
336: THEN
337: FND_MSG_PUB.Add_Exc_Msg
338: ( G_PKG_NAME ,
339: l_api_name
340: );
341: END IF;
338: ( G_PKG_NAME ,
339: l_api_name
340: );
341: END IF;
342: FND_MSG_PUB.Count_And_Get
343: ( p_count => x_msg_count ,
344: p_data => x_msg_data
345: );
346: