eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_REVERT_BATCH_PVT dependencies on FND_API

Line 65: x_return_status := FND_API.G_RET_STS_SUCCESS;

61:
62: l_api_name CONSTANT VARCHAR2 (30) := 'revert_batch';
63: BEGIN
64: /* Set the return status to success initially */
65: x_return_status := FND_API.G_RET_STS_SUCCESS;
66:
67: IF (g_debug <= gme_debug.g_log_statement) THEN
68: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
69: || 'Entering');

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

81: CLOSE Cur_lock_batch_materials;
82:
83: /* Mark batch as 'WIP' */
84: l_batch_header_rec.batch_status := 2;
85: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
86: /* Fetch all the material lines associated with the batch */
87: FOR i IN 1..l_material_details_tab.COUNT LOOP
88: IF (g_debug <= gme_debug.g_log_statement) THEN
89: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

Line 151: x_return_status := FND_API.G_RET_STS_ERROR;

147: EXCEPTION
148:
149:
150: WHEN BATCH_LINES_LOCKED THEN
151: x_return_status := FND_API.G_RET_STS_ERROR;
152: gme_common_pvt.log_message('GME_API_BATCH_LINES_LOCKED');
153:
154: WHEN REVERT_LINE_FAIL THEN
155: x_return_status := l_return_status;

Line 158: x_return_status := FND_API.G_RET_STS_ERROR;

154: WHEN REVERT_LINE_FAIL THEN
155: x_return_status := l_return_status;
156:
157: WHEN BATCH_HIST_INSERT_ERR THEN
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: WHEN BATCH_HDR_UPDATE_ERROR THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: WHEN app_exception.record_lock_exception THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;

Line 160: x_return_status := FND_API.G_RET_STS_ERROR;

156:
157: WHEN BATCH_HIST_INSERT_ERR THEN
158: x_return_status := FND_API.G_RET_STS_ERROR;
159: WHEN BATCH_HDR_UPDATE_ERROR THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: WHEN app_exception.record_lock_exception THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: gme_common_pvt.log_message('GME_RECORD_LOCKED','TABLE_NAME', g_table_name, 'KEY',to_char(p_batch_header_rec.batch_id));
164: WHEN OTHERS THEN

Line 162: x_return_status := FND_API.G_RET_STS_ERROR;

158: x_return_status := FND_API.G_RET_STS_ERROR;
159: WHEN BATCH_HDR_UPDATE_ERROR THEN
160: x_return_status := FND_API.G_RET_STS_ERROR;
161: WHEN app_exception.record_lock_exception THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: gme_common_pvt.log_message('GME_RECORD_LOCKED','TABLE_NAME', g_table_name, 'KEY',to_char(p_batch_header_rec.batch_id));
164: WHEN OTHERS THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166:

Line 165: x_return_status := fnd_api.g_ret_sts_unexp_error;

161: WHEN app_exception.record_lock_exception THEN
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: gme_common_pvt.log_message('GME_RECORD_LOCKED','TABLE_NAME', g_table_name, 'KEY',to_char(p_batch_header_rec.batch_id));
164: WHEN OTHERS THEN
165: x_return_status := fnd_api.g_ret_sts_unexp_error;
166:
167: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
168: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
169: END IF;

Line 235: x_return_status := FND_API.G_RET_STS_SUCCESS;

231: l_txn_enabled_flag VARCHAR2(1);
232: BEGIN
233:
234: /* Inititialize the return status to success */
235: x_return_status := FND_API.G_RET_STS_SUCCESS;
236: IF (g_debug <= gme_debug.g_log_statement) THEN
237: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'
238: || 'Entering');
239: END IF;

Line 256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

252: revert_batch
253: ( p_batch_header_rec => l_ph_batch_header_rec
254: , x_batch_header_rec => l_batch_header_rec
255: , x_return_status => x_return_status);
256: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
257: RAISE REVERT_PHANT_FAIL;
258: END IF;
259: ELSE
260: l_batch_header_rec := p_batch_header_rec ;

Line 278: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

274: ,p_create_resv_pend_lots => 1
275: ,x_actual_qty => l_actual_qty
276: ,x_exception_material_tbl => l_exception_material_tbl
277: ,x_return_status => x_return_status );
278: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
279: RAISE REVERT_MATL_ERROR;
280: END IF;
281: END IF;
282: /* Default the actual qty to zero */

Line 326: x_return_status := FND_API.G_RET_STS_ERROR;

322:
323: WHEN REVERT_MATL_ERROR THEN
324: NULL;
325: WHEN BATCH_HEADER_FETCH_ERROR THEN
326: x_return_status := FND_API.G_RET_STS_ERROR;
327: GME_common_pvt.log_message('GME_API_BATCH_FETCH_ERROR');
328: WHEN REVERT_PHANT_FAIL THEN
329: NULL;
330: WHEN ERROR_LOAD_TRANS OR UPDATE_STEP_QTY_ERROR THEN

Line 333: x_return_status := fnd_api.g_ret_sts_unexp_error;

329: NULL;
330: WHEN ERROR_LOAD_TRANS OR UPDATE_STEP_QTY_ERROR THEN
331: x_return_status := l_return_status;
332: WHEN OTHERS THEN
333: x_return_status := fnd_api.g_ret_sts_unexp_error;
334:
335: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN
336: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'WHEN OTHERS:' || SQLERRM);
337: END IF;