79: x_return_status := FND_API.G_RET_STS_SUCCESS;
80:
81: EXCEPTION
82: WHEN FND_API.G_EXC_ERROR THEN
83: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: WHEN OTHERS THEN
86: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
87: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
82: WHEN FND_API.G_EXC_ERROR THEN
83: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: WHEN OTHERS THEN
86: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
87: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89:
90: END validate_inputs;
83: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
84: x_return_status := FND_API.G_RET_STS_ERROR;
85: WHEN OTHERS THEN
86: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
87: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
88: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
89:
90: END validate_inputs;
91:
148: l_progress := '020';
149:
150: EXCEPTION
151: WHEN FND_API.G_EXC_ERROR THEN
152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
151: WHEN FND_API.G_EXC_ERROR THEN
152: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
153: x_return_status := FND_API.G_RET_STS_ERROR;
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: WHEN OTHERS THEN
158: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
154: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: WHEN OTHERS THEN
158: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
162: END update_requisition;
155: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
156: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
157: WHEN OTHERS THEN
158: FND_MSG_PUB.add_exc_msg(G_PKG_NAME, l_api_name || '.' || l_progress);
159: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
160: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
161:
162: END update_requisition;
163: