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 38: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;

34: FROM gme_batch_step_items i, gme_material_details d
35: WHERE d.batch_id = v_batch_id
36: AND d.material_detail_id = i.material_detail_id
37: AND i.batchstep_id = v_batchstep_id
38: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;
39:
40: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_step';
41: l_material_detail_tbl gme_common_pvt.material_details_tab;
42: l_material_detail_rec gme_material_details%ROWTYPE;

Line 41: l_material_detail_tbl gme_common_pvt.material_details_tab;

37: AND i.batchstep_id = v_batchstep_id
38: AND d.release_type = gme_common_pvt.g_mtl_autobystep_release;
39:
40: l_api_name CONSTANT VARCHAR2 (30) := 'unrelease_step';
41: l_material_detail_tbl gme_common_pvt.material_details_tab;
42: l_material_detail_rec gme_material_details%ROWTYPE;
43: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
44: l_msg_count NUMBER;
45: l_msg_stack VARCHAR2 (2000);

Line 82: P_REQUESTER => gme_common_pvt.g_user_ident,

78: X_MSG_COUNT => l_msg_count,
79: X_MSG_DATA => l_msg_stack,
80: P_ENTITY_NAME => 'OPERATION',
81: P_ENTITY_KEY => x_batch_step_rec.batchstep_id,
82: P_REQUESTER => gme_common_pvt.g_user_ident,
83: X_LOCK_STATUS => l_lock_status,
84: X_LOCKED_BY_STATUS => l_locked_by_status,
85: X_LOCK_ALLOWED => l_lock_allowed);
86: gme_debug.put_line ( g_pkg_name

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

100: || 'from gmo the lock_status='
101: || l_lock_status);
102: END IF;
103: IF l_lock_status = 'Y' THEN
104: gme_common_pvt.log_message ('GME_STEP_LOCK_ERROR');
105: RAISE gmo_lock_error;
106: END IF;
107:
108:

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

106: END IF;
107:
108:
109: -- set step status
110: x_batch_step_rec.step_status := gme_common_pvt.g_step_pending;
111: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
112: -- set actual start date to NULL...
113: x_batch_step_rec.actual_start_date := NULL;
114:

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

107:
108:
109: -- set step status
110: x_batch_step_rec.step_status := gme_common_pvt.g_step_pending;
111: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
112: -- set actual start date to NULL...
113: x_batch_step_rec.actual_start_date := NULL;
114:
115: -- reset quality status

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

122: RAISE error_update_row;
123: END IF;
124:
125: -- Update WHO columns for output structure
126: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
127: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
128: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
129:
130: -- Fetch all the material lines associated to the step if not from unrelease batch

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

123: END IF;
124:
125: -- Update WHO columns for output structure
126: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
127: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
128: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
129:
130: -- Fetch all the material lines associated to the step if not from unrelease batch
131: IF p_from_unrelease_batch = 0 THEN

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

124:
125: -- Update WHO columns for output structure
126: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
127: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
128: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
129:
130: -- Fetch all the material lines associated to the step if not from unrelease batch
131: IF p_from_unrelease_batch = 0 THEN
132: OPEN cur_get_step_materials (x_batch_step_rec.batch_id

Line 173: ,last_updated_by = gme_common_pvt.g_user_ident

169: -- Remove the actual start date of the activities... set defaults; set WHO columns
170: UPDATE gme_batch_step_activities
171: SET actual_start_date = NULL
172: ,plan_activity_factor = NVL (plan_activity_factor, 0)
173: ,last_updated_by = gme_common_pvt.g_user_ident
174: ,last_update_date = gme_common_pvt.g_timestamp
175: ,last_update_login = gme_common_pvt.g_login_id
176: WHERE batchstep_id = x_batch_step_rec.batchstep_id
177: AND batch_id = x_batch_step_rec.batch_id;

Line 174: ,last_update_date = gme_common_pvt.g_timestamp

170: UPDATE gme_batch_step_activities
171: SET actual_start_date = NULL
172: ,plan_activity_factor = NVL (plan_activity_factor, 0)
173: ,last_updated_by = gme_common_pvt.g_user_ident
174: ,last_update_date = gme_common_pvt.g_timestamp
175: ,last_update_login = gme_common_pvt.g_login_id
176: WHERE batchstep_id = x_batch_step_rec.batchstep_id
177: AND batch_id = x_batch_step_rec.batch_id;
178:

Line 175: ,last_update_login = gme_common_pvt.g_login_id

171: SET actual_start_date = NULL
172: ,plan_activity_factor = NVL (plan_activity_factor, 0)
173: ,last_updated_by = gme_common_pvt.g_user_ident
174: ,last_update_date = gme_common_pvt.g_timestamp
175: ,last_update_login = gme_common_pvt.g_login_id
176: WHERE batchstep_id = x_batch_step_rec.batchstep_id
177: AND batch_id = x_batch_step_rec.batch_id;
178:
179: -- Remove the actual start date of the resources... set defaults; set WHO columns

Line 185: ,last_updated_by = gme_common_pvt.g_user_ident

181: SET actual_start_date = NULL
182: ,plan_rsrc_count = NVL (plan_rsrc_count, 1)
183: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
184: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)
185: ,last_updated_by = gme_common_pvt.g_user_ident
186: ,last_update_date = gme_common_pvt.g_timestamp
187: ,last_update_login = gme_common_pvt.g_login_id
188: WHERE batchstep_id = x_batch_step_rec.batchstep_id
189: AND batch_id = x_batch_step_rec.batch_id;

Line 186: ,last_update_date = gme_common_pvt.g_timestamp

182: ,plan_rsrc_count = NVL (plan_rsrc_count, 1)
183: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
184: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)
185: ,last_updated_by = gme_common_pvt.g_user_ident
186: ,last_update_date = gme_common_pvt.g_timestamp
187: ,last_update_login = gme_common_pvt.g_login_id
188: WHERE batchstep_id = x_batch_step_rec.batchstep_id
189: AND batch_id = x_batch_step_rec.batch_id;
190:

Line 187: ,last_update_login = gme_common_pvt.g_login_id

183: ,plan_rsrc_qty = NVL (plan_rsrc_qty, 0)
184: ,plan_rsrc_usage = NVL (plan_rsrc_usage, 0)
185: ,last_updated_by = gme_common_pvt.g_user_ident
186: ,last_update_date = gme_common_pvt.g_timestamp
187: ,last_update_login = gme_common_pvt.g_login_id
188: WHERE batchstep_id = x_batch_step_rec.batchstep_id
189: AND batch_id = x_batch_step_rec.batch_id;
190:
191: -- Update plan start date and plan completion date on activity and resources

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

219: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
220: END IF;
221: EXCEPTION
222: WHEN error_update_row THEN
223: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'
224: ,SQLERRM);
225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: WHEN error_unrelease_matl OR update_step_qty_error THEN
227: NULL;

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

263: WHERE d.batchstep_id = s.batchstep_id AND
264: d.batch_id = s.batch_id AND
265: d.dep_step_id = v_batchstep_id AND
266: s.batch_id = v_batch_id AND
267: s.step_status <> gme_common_pvt.g_step_pending;
268:
269: l_is_dep_step_valid NUMBER;
270:
271: error_batch_type EXCEPTION;

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

279: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
280: || l_api_name);
281: END IF;
282:
283: IF p_batch_hdr_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN
284: RAISE error_batch_type;
285: END IF;
286:
287: IF p_batch_hdr_rec.batch_status <> gme_common_pvt.g_batch_wip THEN

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

283: IF p_batch_hdr_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN
284: RAISE error_batch_type;
285: END IF;
286:
287: IF p_batch_hdr_rec.batch_status <> gme_common_pvt.g_batch_wip THEN
288: RAISE error_batch_status;
289: END IF;
290:
291: IF p_batch_step_rec.step_status <> gme_common_pvt.g_step_wip THEN

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

287: IF p_batch_hdr_rec.batch_status <> gme_common_pvt.g_batch_wip THEN
288: RAISE error_batch_status;
289: END IF;
290:
291: IF p_batch_step_rec.step_status <> gme_common_pvt.g_step_wip THEN
292: RAISE error_step_status;
293: END IF;
294:
295: IF p_batch_hdr_rec.automatic_step_calculation = 1 OR

Line 296: p_batch_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release OR

292: RAISE error_step_status;
293: END IF;
294:
295: IF p_batch_hdr_rec.automatic_step_calculation = 1 OR
296: p_batch_step_rec.steprelease_type = gme_common_pvt.g_auto_step_release OR
297: p_batch_hdr_rec.enforce_step_dependency = 1 THEN
298: -- return error if any immediate succeeding step is not Pending
299: OPEN cur_dep_step(p_batch_step_rec.batchstep_id, p_batch_step_rec.batch_id);
300: FETCH cur_dep_step INTO l_is_dep_step_valid;

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

310: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
311: END IF;
312: EXCEPTION
313: WHEN error_step_status THEN
314: gme_common_pvt.log_message('GME_API_INV_STEP_STAT_UNRELE');
315: x_return_status := fnd_api.g_ret_sts_error;
316: WHEN error_batch_type OR error_batch_status THEN
317: gme_common_pvt.log_message('GME_API_INV_BATCH_UNRELE_STEP');
318: x_return_status := fnd_api.g_ret_sts_error;

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

313: WHEN error_step_status THEN
314: gme_common_pvt.log_message('GME_API_INV_STEP_STAT_UNRELE');
315: x_return_status := fnd_api.g_ret_sts_error;
316: WHEN error_batch_type OR error_batch_status THEN
317: gme_common_pvt.log_message('GME_API_INV_BATCH_UNRELE_STEP');
318: x_return_status := fnd_api.g_ret_sts_error;
319: WHEN error_dep_step_status THEN
320: gme_common_pvt.log_message ('GME_SUCC_DEP_PENDING');
321: x_return_status := FND_API.G_RET_STS_ERROR;

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

316: WHEN error_batch_type OR error_batch_status THEN
317: gme_common_pvt.log_message('GME_API_INV_BATCH_UNRELE_STEP');
318: x_return_status := fnd_api.g_ret_sts_error;
319: WHEN error_dep_step_status THEN
320: gme_common_pvt.log_message ('GME_SUCC_DEP_PENDING');
321: x_return_status := FND_API.G_RET_STS_ERROR;
322: WHEN OTHERS THEN
323: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
324: