DBA Data[Home] [Help]

APPS.GME_REVERT_STEP_PVT dependencies on FND_API

Line 78: x_return_status := FND_API.G_RET_STS_SUCCESS;

74: l_api_name CONSTANT VARCHAR2 (30) := 'revert_step';
75: l_dep_step_rec Cur_dep_steps%ROWTYPE;
76: BEGIN
77: /* Set the return status to success initially */
78: x_return_status := FND_API.G_RET_STS_SUCCESS;
79: IF g_debug <= gme_debug.g_log_procedure THEN
80: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
81: || 'Entering');
82: END IF;

Line 144: gme_common_pvt.g_batch_status_check := fnd_api.g_false;

140: -- remove actual date from step record
141: l_batch_step_rec.actual_cmplt_date := NULL;
142: -- Update step status to WIP
143: l_batch_step_rec.step_status := 2;
144: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
145: -- Update the batch step to the database
146: IF NOT (gme_batch_steps_dbl.update_row (l_batch_step_rec)) THEN
147: RAISE batch_step_upd_err;
148: END IF;

Line 207: x_return_status := FND_API.G_RET_STS_ERROR;

203:
204: EXCEPTION
205:
206: WHEN invalid_dep_step_status THEN
207: x_return_status := FND_API.G_RET_STS_ERROR;
208: GME_common_pvt.log_message ('GME_INV_DEP_STEP_STATUS');
209:
210: WHEN REVERT_LINE_FAIL THEN
211: x_return_status := l_return_status;

Line 215: x_return_status := FND_API.G_RET_STS_ERROR;

211: x_return_status := l_return_status;
212: WHEN batch_revert_error THEN
213: x_return_status := l_return_status;
214: WHEN invalid_batch_status THEN
215: x_return_status := FND_API.G_RET_STS_ERROR;
216: GME_common_pvt.log_message ('GME_API_INV_BATCH_UNCERT_STEP');
217:
218: WHEN BATCH_LINES_LOCKED THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;

Line 219: x_return_status := FND_API.G_RET_STS_ERROR;

215: x_return_status := FND_API.G_RET_STS_ERROR;
216: GME_common_pvt.log_message ('GME_API_INV_BATCH_UNCERT_STEP');
217:
218: WHEN BATCH_LINES_LOCKED THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: gme_common_pvt.log_message('GME_API_BATCH_LINES_LOCKED');
221: WHEN OTHERS THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:

Line 222: x_return_status := fnd_api.g_ret_sts_unexp_error;

218: WHEN BATCH_LINES_LOCKED THEN
219: x_return_status := FND_API.G_RET_STS_ERROR;
220: gme_common_pvt.log_message('GME_API_BATCH_LINES_LOCKED');
221: WHEN OTHERS THEN
222: x_return_status := fnd_api.g_ret_sts_unexp_error;
223:
224: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
225: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
226: END IF;