89: END IF;
90:
91: -- Check p_init_msg_list
92: IF FND_API.to_Boolean( p_init_msg_list ) THEN
93: FND_MSG_PUB.initialize;
94: END IF;
95:
96: -- Implementation of User Hooks
97: /* Copy all parameters to local variables to be passed to Pre, Post and Business APIs */
258: COMMIT WORK;
259: END IF;
260:
261: -- Standard call to get message count and if count is 1, get message info
262: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
263:
264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: ROLLBACK TO Query_SearchURL_PVT;
268: x_return_status := FND_API.G_RET_STS_ERROR;
269: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO Query_SearchURL_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270:
271: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
272: ROLLBACK TO Query_SearchURL_PVT;
273: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
274: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
275:
276: WHEN OTHERS THEN
277: ROLLBACK TO Query_SearchURL_PVT;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275:
276: WHEN OTHERS THEN
277: ROLLBACK TO Query_SearchURL_PVT;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
280: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
281: END IF;
282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
283:
276: WHEN OTHERS THEN
277: ROLLBACK TO Query_SearchURL_PVT;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
280: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
281: END IF;
282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
283:
284: END;
278: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
279: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
280: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
281: END IF;
282: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
283:
284: END;
285: END;