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

Line 41: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;

37: FROM gme_batch_step_items i, gme_material_details d
38: WHERE d.batch_id = v_batch_id
39: AND d.material_detail_id = i.material_detail_id
40: AND i.batchstep_id = v_batchstep_id
41: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;
42:
43: -- Bug 9478698 - Get enhanced_pi_ind from batch header.
44: CURSOR cur_get_batch_info (
45: v_batch_id gme_batch_header.batch_id%TYPE)

Line 54: l_material_detail_tbl gme_common_pvt.material_details_tab;

50:
51: l_enhanced_pi_ind VARCHAR2(1);
52:
53: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_step';
54: l_material_detail_tbl gme_common_pvt.material_details_tab;
55: l_material_detail_rec gme_material_details%ROWTYPE;
56: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
57: l_msg_count NUMBER;
58: l_msg_stack VARCHAR2 (2000);

Line 103: P_REQUESTER => gme_common_pvt.g_user_ident,

99: X_MSG_COUNT => l_msg_count,
100: X_MSG_DATA => l_msg_stack,
101: P_ENTITY_NAME => 'OPERATION',
102: P_ENTITY_KEY => x_batch_step_rec.batchstep_id,
103: P_REQUESTER => gme_common_pvt.g_user_ident,
104: X_LOCK_STATUS => l_lock_status,
105: X_LOCKED_BY_STATUS => l_locked_by_status,
106: X_LOCK_ALLOWED => l_lock_allowed);
107:

Line 122: gme_common_pvt.log_message ('GME_STEP_LOCK_ERROR');

118: || l_lock_status);
119: END IF;
120:
121: IF l_lock_status = 'Y' THEN
122: gme_common_pvt.log_message ('GME_STEP_LOCK_ERROR');
123: RAISE gmo_lock_error;
124: END IF;
125: END IF;
126:

Line 128: x_batch_step_rec.step_status := gme_common_pvt.g_step_pending;

124: END IF;
125: END IF;
126:
127: -- set step status
128: x_batch_step_rec.step_status := gme_common_pvt.g_step_pending;
129: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
130: -- set actual start date to NULL...
131: x_batch_step_rec.actual_start_date := NULL;
132:

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

125: END IF;
126:
127: -- set step status
128: x_batch_step_rec.step_status := gme_common_pvt.g_step_pending;
129: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
130: -- set actual start date to NULL...
131: x_batch_step_rec.actual_start_date := NULL;
132:
133: -- reset quality status

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

140: RAISE error_update_row;
141: END IF;
142:
143: -- Update WHO columns for output structure
144: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
145: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
146: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
147:
148: -- Fetch all the material lines associated to the step if not from unrelease batch

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

141: END IF;
142:
143: -- Update WHO columns for output structure
144: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
145: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
146: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
147:
148: -- Fetch all the material lines associated to the step if not from unrelease batch
149: IF p_from_unrelease_batch = 0 THEN

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

142:
143: -- Update WHO columns for output structure
144: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
145: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
146: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
147:
148: -- Fetch all the material lines associated to the step if not from unrelease batch
149: IF p_from_unrelease_batch = 0 THEN
150: OPEN cur_get_step_materials (x_batch_step_rec.batch_id

Line 191: ,last_updated_by = gme_common_pvt.g_user_ident

187: -- Remove the actual start date of the activities... set defaults; set WHO columns
188: UPDATE gme_batch_step_activities
189: SET actual_start_date = NULL
190: ,plan_activity_factor = NVL (plan_activity_factor, 0)
191: ,last_updated_by = gme_common_pvt.g_user_ident
192: ,last_update_date = gme_common_pvt.g_timestamp
193: ,last_update_login = gme_common_pvt.g_login_id
194: WHERE batchstep_id = x_batch_step_rec.batchstep_id
195: AND batch_id = x_batch_step_rec.batch_id;

Line 192: ,last_update_date = gme_common_pvt.g_timestamp

188: UPDATE gme_batch_step_activities
189: SET actual_start_date = NULL
190: ,plan_activity_factor = NVL (plan_activity_factor, 0)
191: ,last_updated_by = gme_common_pvt.g_user_ident
192: ,last_update_date = gme_common_pvt.g_timestamp
193: ,last_update_login = gme_common_pvt.g_login_id
194: WHERE batchstep_id = x_batch_step_rec.batchstep_id
195: AND batch_id = x_batch_step_rec.batch_id;
196:

Line 193: ,last_update_login = gme_common_pvt.g_login_id

189: SET actual_start_date = NULL
190: ,plan_activity_factor = NVL (plan_activity_factor, 0)
191: ,last_updated_by = gme_common_pvt.g_user_ident
192: ,last_update_date = gme_common_pvt.g_timestamp
193: ,last_update_login = gme_common_pvt.g_login_id
194: WHERE batchstep_id = x_batch_step_rec.batchstep_id
195: AND batch_id = x_batch_step_rec.batch_id;
196:
197: -- Remove the actual start date of the resources... set defaults; set WHO columns

Line 203: ,last_updated_by = gme_common_pvt.g_user_ident

199: SET actual_start_date = NULL
200: ,plan_rsrc_count = NVL (plan_rsrc_count, 1)
201: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
202: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)
203: ,last_updated_by = gme_common_pvt.g_user_ident
204: ,last_update_date = gme_common_pvt.g_timestamp
205: ,last_update_login = gme_common_pvt.g_login_id
206: WHERE batchstep_id = x_batch_step_rec.batchstep_id
207: AND batch_id = x_batch_step_rec.batch_id;

Line 204: ,last_update_date = gme_common_pvt.g_timestamp

200: ,plan_rsrc_count = NVL (plan_rsrc_count, 1)
201: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
202: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)
203: ,last_updated_by = gme_common_pvt.g_user_ident
204: ,last_update_date = gme_common_pvt.g_timestamp
205: ,last_update_login = gme_common_pvt.g_login_id
206: WHERE batchstep_id = x_batch_step_rec.batchstep_id
207: AND batch_id = x_batch_step_rec.batch_id;
208:

Line 205: ,last_update_login = gme_common_pvt.g_login_id

201: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
202: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)
203: ,last_updated_by = gme_common_pvt.g_user_ident
204: ,last_update_date = gme_common_pvt.g_timestamp
205: ,last_update_login = gme_common_pvt.g_login_id
206: WHERE batchstep_id = x_batch_step_rec.batchstep_id
207: AND batch_id = x_batch_step_rec.batch_id;
208:
209: -- Update plan start date and plan completion date on activity and resources

Line 241: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

237: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
238: END IF;
239: EXCEPTION
240: WHEN error_update_row THEN
241: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
242: ,SQLERRM);
243: x_return_status := fnd_api.g_ret_sts_unexp_error;
244: WHEN error_unrelease_matl OR update_step_qty_error THEN
245: NULL;

Line 285: s.step_status <> gme_common_pvt.g_step_pending;

281: WHERE d.batchstep_id = s.batchstep_id AND
282: d.batch_id = s.batch_id AND
283: d.dep_step_id = v_batchstep_id AND
284: s.batch_id = v_batch_id AND
285: s.step_status <> gme_common_pvt.g_step_pending;
286:
287: l_is_dep_step_valid NUMBER;
288:
289: error_batch_type EXCEPTION;

Line 301: IF p_batch_hdr_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN

297: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
298: || l_api_name);
299: END IF;
300:
301: IF p_batch_hdr_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN
302: RAISE error_batch_type;
303: END IF;
304:
305: IF p_batch_hdr_rec.batch_status <> gme_common_pvt.g_batch_wip THEN

Line 305: IF p_batch_hdr_rec.batch_status <> gme_common_pvt.g_batch_wip THEN

301: IF p_batch_hdr_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN
302: RAISE error_batch_type;
303: END IF;
304:
305: IF p_batch_hdr_rec.batch_status <> gme_common_pvt.g_batch_wip THEN
306: RAISE error_batch_status;
307: END IF;
308:
309: IF p_batch_step_rec.step_status <> gme_common_pvt.g_step_wip THEN

Line 309: IF p_batch_step_rec.step_status <> gme_common_pvt.g_step_wip THEN

305: IF p_batch_hdr_rec.batch_status <> gme_common_pvt.g_batch_wip THEN
306: RAISE error_batch_status;
307: END IF;
308:
309: IF p_batch_step_rec.step_status <> gme_common_pvt.g_step_wip THEN
310: RAISE error_step_status;
311: END IF;
312:
313: IF p_batch_hdr_rec.automatic_step_calculation = 1 OR

Line 314: p_batch_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release OR

310: RAISE error_step_status;
311: END IF;
312:
313: IF p_batch_hdr_rec.automatic_step_calculation = 1 OR
314: p_batch_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release OR
315: p_batch_hdr_rec.enforce_step_dependency = 1 THEN
316: -- return error if any immediate succeeding step is not Pending
317: OPEN cur_dep_step(p_batch_step_rec.batchstep_id, p_batch_step_rec.batch_id);
318: FETCH cur_dep_step INTO l_is_dep_step_valid;

Line 332: gme_common_pvt.log_message('GME_API_INV_STEP_STAT_UNRELE');

328: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
329: END IF;
330: EXCEPTION
331: WHEN error_step_status THEN
332: gme_common_pvt.log_message('GME_API_INV_STEP_STAT_UNRELE');
333: x_return_status := fnd_api.g_ret_sts_error;
334: WHEN error_batch_type OR error_batch_status THEN
335: gme_common_pvt.log_message('GME_API_INV_BATCH_UNRELE_STEP');
336: x_return_status := fnd_api.g_ret_sts_error;

Line 335: gme_common_pvt.log_message('GME_API_INV_BATCH_UNRELE_STEP');

331: WHEN error_step_status THEN
332: gme_common_pvt.log_message('GME_API_INV_STEP_STAT_UNRELE');
333: x_return_status := fnd_api.g_ret_sts_error;
334: WHEN error_batch_type OR error_batch_status THEN
335: gme_common_pvt.log_message('GME_API_INV_BATCH_UNRELE_STEP');
336: x_return_status := fnd_api.g_ret_sts_error;
337: WHEN error_dep_step_status THEN
338: gme_common_pvt.log_message ('GME_SUCC_DEP_PENDING');
339: x_return_status := FND_API.G_RET_STS_ERROR;

Line 338: gme_common_pvt.log_message ('GME_SUCC_DEP_PENDING');

334: WHEN error_batch_type OR error_batch_status THEN
335: gme_common_pvt.log_message('GME_API_INV_BATCH_UNRELE_STEP');
336: x_return_status := fnd_api.g_ret_sts_error;
337: WHEN error_dep_step_status THEN
338: gme_common_pvt.log_message ('GME_SUCC_DEP_PENDING');
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: WHEN OTHERS THEN
341: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
342: