104: END IF;
105: END IF;
106:
107: IF (l_return_status IS NULL) THEN
108: l_return_status := FND_API.g_ret_sts_success;
109: END IF;
110:
111: IF (l_return_status = FND_API.g_ret_sts_error) THEN
112: RAISE FND_API.g_exc_error;
107: IF (l_return_status IS NULL) THEN
108: l_return_status := FND_API.g_ret_sts_success;
109: END IF;
110:
111: IF (l_return_status = FND_API.g_ret_sts_error) THEN
112: RAISE FND_API.g_exc_error;
113: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
114: RAISE FND_API.g_exc_unexpected_error;
115: END IF;
108: l_return_status := FND_API.g_ret_sts_success;
109: END IF;
110:
111: IF (l_return_status = FND_API.g_ret_sts_error) THEN
112: RAISE FND_API.g_exc_error;
113: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
114: RAISE FND_API.g_exc_unexpected_error;
115: END IF;
116:
109: END IF;
110:
111: IF (l_return_status = FND_API.g_ret_sts_error) THEN
112: RAISE FND_API.g_exc_error;
113: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
114: RAISE FND_API.g_exc_unexpected_error;
115: END IF;
116:
117: l_progress := '030';
110:
111: IF (l_return_status = FND_API.g_ret_sts_error) THEN
112: RAISE FND_API.g_exc_error;
113: ELSIF (l_return_status = FND_API.g_ret_sts_unexp_error) THEN
114: RAISE FND_API.g_exc_unexpected_error;
115: END IF;
116:
117: l_progress := '030';
118: IF (l_updatable_flag = 'Y') THEN
165:
166: return TRUE;
167:
168: EXCEPTION
169: WHEN FND_API.G_EXC_ERROR THEN
170: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
171: l_return_status := FND_API.G_RET_STS_ERROR;
172: return FALSE;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
167:
168: EXCEPTION
169: WHEN FND_API.G_EXC_ERROR THEN
170: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
171: l_return_status := FND_API.G_RET_STS_ERROR;
172: return FALSE;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
175: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: WHEN FND_API.G_EXC_ERROR THEN
170: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
171: l_return_status := FND_API.G_RET_STS_ERROR;
172: return FALSE;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
175: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: return FALSE;
177: WHEN OTHERS THEN
171: l_return_status := FND_API.G_RET_STS_ERROR;
172: return FALSE;
173: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
175: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
176: return FALSE;
177: WHEN OTHERS THEN
178: FND_MSG_PUB.add_exc_msg('', l_api_name || '.' || l_progress);
179: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
176: return FALSE;
177: WHEN OTHERS THEN
178: FND_MSG_PUB.add_exc_msg('', l_api_name || '.' || l_progress);
179: FND_MSG_PUB.Count_And_Get(p_count => l_msg_count, p_data => l_msg_data);
180: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: return FALSE;
182: END chk_drop_ship;
183: --
184: