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

Line 38: l_material_details_tab gme_common_pvt.material_details_tab ;

34: l_batch_header_rec gme_batch_header%ROWTYPE;
35: l_in_batch_header_rec gme_batch_header%ROWTYPE;
36: x_in_batch_step_rec gme_batch_steps%ROWTYPE;
37: l_batch_step_rec gme_batch_steps%ROWTYPE;
38: l_material_details_tab gme_common_pvt.material_details_tab ;
39: /* Bug 2685645 added batch_id as parama and used in where clause */
40: CURSOR cur_dep_steps (v_batchstep_id NUMBER,
41: v_batch_id NUMBER) IS
42: SELECT batchstep_no, s.step_status,d.dep_type,d.standard_delay, s.steprelease_type

Line 117: IF GME_common_pvt.g_step_controls_batch_sts_ind = 1 THEN

113: /* is completed then we have to call the revert batch API and then go */
114: /* ahead in revert the step. If the step control profile is set to */
115: /* 'N' then the batch should be in WIP status to revert the step */
116:
117: IF GME_common_pvt.g_step_controls_batch_sts_ind = 1 THEN
118:
119: /* If the batch is certified and the batch is not a phantom */
120: IF (l_batch_header_rec.batch_status = 3) AND
121: (l_batch_header_rec.parentline_id IS NULL) THEN

Line 124: gme_debug.put_line ('revert batch'||GME_common_pvt.g_step_controls_batch_sts_ind);

120: IF (l_batch_header_rec.batch_status = 3) AND
121: (l_batch_header_rec.parentline_id IS NULL) THEN
122: /* Call the revert batch API */
123: IF ( g_debug <= gme_debug.g_log_procedure ) THEN
124: gme_debug.put_line ('revert batch'||GME_common_pvt.g_step_controls_batch_sts_ind);
125: END IF;
126: l_in_batch_header_rec := l_batch_header_rec;
127: gme_revert_batch_pvt.revert_batch
128: (p_batch_header_rec => l_in_batch_header_rec

Line 137: END IF; /* IFGME_common_pvt.STEP_CONTROL = 'Y' */

133:
134: RAISE batch_revert_error;
135: END IF;
136: END IF; /* IF (l_batch_header_rec.batch_status = 3) */
137: END IF; /* IFGME_common_pvt.STEP_CONTROL = 'Y' */
138:
139:
140: -- remove actual date from step record
141: l_batch_step_rec.actual_cmplt_date := NULL;

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 189: ,last_updated_by = gme_common_pvt.g_user_ident

185:
186:
187: UPDATE gme_batch_step_activities
188: SET actual_cmplt_date = NULL
189: ,last_updated_by = gme_common_pvt.g_user_ident
190: ,last_update_date = gme_common_pvt.g_timestamp
191: ,last_update_login = gme_common_pvt.g_login_id
192: WHERE batchstep_id = l_batch_step_rec.batchstep_id
193: AND batch_id = p_batch_header_rec.batch_id;

Line 190: ,last_update_date = gme_common_pvt.g_timestamp

186:
187: UPDATE gme_batch_step_activities
188: SET actual_cmplt_date = NULL
189: ,last_updated_by = gme_common_pvt.g_user_ident
190: ,last_update_date = gme_common_pvt.g_timestamp
191: ,last_update_login = gme_common_pvt.g_login_id
192: WHERE batchstep_id = l_batch_step_rec.batchstep_id
193: AND batch_id = p_batch_header_rec.batch_id;
194:

Line 191: ,last_update_login = gme_common_pvt.g_login_id

187: UPDATE gme_batch_step_activities
188: SET actual_cmplt_date = NULL
189: ,last_updated_by = gme_common_pvt.g_user_ident
190: ,last_update_date = gme_common_pvt.g_timestamp
191: ,last_update_login = gme_common_pvt.g_login_id
192: WHERE batchstep_id = l_batch_step_rec.batchstep_id
193: AND batch_id = p_batch_header_rec.batch_id;
194:
195:

Line 198: ,last_updated_by = gme_common_pvt.g_user_ident

194:
195:
196: UPDATE gme_batch_step_resources
197: SET actual_cmplt_date = NULL
198: ,last_updated_by = gme_common_pvt.g_user_ident
199: ,last_update_date = gme_common_pvt.g_timestamp
200: ,last_update_login = gme_common_pvt.g_login_id
201: WHERE batchstep_id = l_batch_step_rec.batchstep_id;
202:

Line 199: ,last_update_date = gme_common_pvt.g_timestamp

195:
196: UPDATE gme_batch_step_resources
197: SET actual_cmplt_date = NULL
198: ,last_updated_by = gme_common_pvt.g_user_ident
199: ,last_update_date = gme_common_pvt.g_timestamp
200: ,last_update_login = gme_common_pvt.g_login_id
201: WHERE batchstep_id = l_batch_step_rec.batchstep_id;
202:
203:

Line 200: ,last_update_login = gme_common_pvt.g_login_id

196: UPDATE gme_batch_step_resources
197: SET actual_cmplt_date = NULL
198: ,last_updated_by = gme_common_pvt.g_user_ident
199: ,last_update_date = gme_common_pvt.g_timestamp
200: ,last_update_login = gme_common_pvt.g_login_id
201: WHERE batchstep_id = l_batch_step_rec.batchstep_id;
202:
203:
204: EXCEPTION

Line 208: GME_common_pvt.log_message ('GME_INV_DEP_STEP_STATUS');

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;
212: WHEN batch_revert_error THEN

Line 216: GME_common_pvt.log_message ('GME_API_INV_BATCH_UNCERT_STEP');

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;
220: gme_common_pvt.log_message('GME_API_BATCH_LINES_LOCKED');

Line 220: gme_common_pvt.log_message('GME_API_BATCH_LINES_LOCKED');

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:
224: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN