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_REOPEN_STEP_PVT dependencies on GME_COMMON_PVT

Line 41: l_phantom_ids gme_common_pvt.number_tab;

37: /* Local variables */
38: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
39: l_batch_header gme_batch_header%ROWTYPE;
40: l_in_batch_header gme_batch_header%ROWTYPE;
41: l_phantom_ids gme_common_pvt.number_tab;
42: l_return_status VARCHAR2 (1);
43: batch_step_fetch_err EXCEPTION;
44: batch_step_reopen_err EXCEPTION;
45: batch_step_upd_err EXCEPTION;

Line 111: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');

107: WHEN batch_step_upd_err THEN
108: x_return_status := fnd_api.g_ret_sts_error;
109: WHEN batch_step_reopen_err THEN
110: x_return_status := fnd_api.g_ret_sts_error;
111: gme_common_pvt.log_message ('GME_API_BATCH_STEP_REOPEN_ERR');
112: WHEN reopen_phant_error THEN
113: x_return_status := l_return_status;
114: WHEN OTHERS THEN
115: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 171: l_phantom_ids gme_common_pvt.number_tab;

167: AND gbsd.dep_type = 0
168: AND gbs.step_status = 4;
169:
170: l_return_status VARCHAR2 (1);
171: l_phantom_ids gme_common_pvt.number_tab;
172: BEGIN
173: -- Set the return status to success initially
174: x_return_status := fnd_api.g_ret_sts_success;
175:

Line 223: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;

219: IF NOT (gme_batch_steps_dbl.update_row (p_batch_step => x_batch_step_rec) ) THEN
220: RAISE batch_step_upd_err;
221: END IF;
222:
223: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
224: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
225: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
226: /* For any ingredient lines attached with the step we have to */
227: /* reopen any phantom batches associated with it */

Line 224: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;

220: RAISE batch_step_upd_err;
221: END IF;
222:
223: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
224: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
225: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
226: /* For any ingredient lines attached with the step we have to */
227: /* reopen any phantom batches associated with it */
228: gme_phantom_pvt.fetch_step_phantoms

Line 225: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;

221: END IF;
222:
223: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
224: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
225: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
226: /* For any ingredient lines attached with the step we have to */
227: /* reopen any phantom batches associated with it */
228: gme_phantom_pvt.fetch_step_phantoms
229: (p_batch_id => x_batch_step_rec.batch_id

Line 257: gme_common_pvt.log_message ('GME_API_INV_BATCH_STATUS_REOP');

253: WHEN batch_step_fetch_err THEN
254: x_return_status := fnd_api.g_ret_sts_error;
255: WHEN invalid_batch_status THEN
256: x_return_status := fnd_api.g_ret_sts_error;
257: gme_common_pvt.log_message ('GME_API_INV_BATCH_STATUS_REOP');
258: WHEN invalid_step_status THEN
259: x_return_status := fnd_api.g_ret_sts_error;
260: gme_common_pvt.log_message ('GME_API_INV_STEP_STATUS_REOP');
261: WHEN batch_depend_step THEN

Line 260: gme_common_pvt.log_message ('GME_API_INV_STEP_STATUS_REOP');

256: x_return_status := fnd_api.g_ret_sts_error;
257: gme_common_pvt.log_message ('GME_API_INV_BATCH_STATUS_REOP');
258: WHEN invalid_step_status THEN
259: x_return_status := fnd_api.g_ret_sts_error;
260: gme_common_pvt.log_message ('GME_API_INV_STEP_STATUS_REOP');
261: WHEN batch_depend_step THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263: gme_common_pvt.log_message ('GME_API_DEP_STEP_REOPEN');
264: WHEN batch_step_upd_err THEN

Line 263: gme_common_pvt.log_message ('GME_API_DEP_STEP_REOPEN');

259: x_return_status := fnd_api.g_ret_sts_error;
260: gme_common_pvt.log_message ('GME_API_INV_STEP_STATUS_REOP');
261: WHEN batch_depend_step THEN
262: x_return_status := fnd_api.g_ret_sts_error;
263: gme_common_pvt.log_message ('GME_API_DEP_STEP_REOPEN');
264: WHEN batch_step_upd_err THEN
265: x_return_status := fnd_api.g_ret_sts_error;
266: WHEN reopen_phant_error THEN
267: x_return_status := l_return_status;