65:
66: -- Initialize message list if p_init_msg_list is set to TRUE.
67: IF FND_API.to_Boolean( p_init_msg_list )
68: THEN
69: FND_MSG_PUB.initialize;
70: END IF;
71:
72:
73: -- Initialize API return status to SUCCESS
165: COMMIT WORK;
166: END IF;
167:
168: -- Standard callto get message count and if count is 1, get message info.
169: FND_MSG_PUB.Count_And_Get
170: ( p_count => x_msg_count,
171: p_data => x_msg_data
172: );
173: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: ROLLBACK TO create_item_PVT;
177: x_return_status := FND_API.G_RET_STS_ERROR ;
178:
179: FND_MSG_PUB.Count_And_Get
180:
181: ( p_count => x_msg_count,
182: p_data => x_msg_data
183: );
184:
185: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186: ROLLBACK TO create_item_PVT;
187: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
188: FND_MSG_PUB.Count_And_Get
189: ( p_count => x_msg_count,
190: p_data => x_msg_data
191: );
192:
192:
193: WHEN OTHERS THEN
194: ROLLBACK TO create_item_PVT;
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level
197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg
200: ( G_PKG_NAME ,
193: WHEN OTHERS THEN
194: ROLLBACK TO create_item_PVT;
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level
197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg
200: ( G_PKG_NAME ,
201: l_api_name
195: x_return_status := FND_API.G_RET_STS_ERROR;
196: IF FND_MSG_PUB.Check_Msg_Level
197: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
198: THEN
199: FND_MSG_PUB.Add_Exc_Msg
200: ( G_PKG_NAME ,
201: l_api_name
202: );
203: END IF;
201: l_api_name
202: );
203: END IF;
204:
205: FND_MSG_PUB.Count_And_Get
206: ( p_count => x_msg_count,
207: p_data => x_msg_data
208:
209: );