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 152: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 159: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 163: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 166: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

Line 236: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 257: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 279: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 327: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 334: x_return_status := fnd_api.g_ret_sts_unexp_error;

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