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

Line 37: l_phantom_ids gme_common_pvt.number_tab;

33: preceding_step_closed VARCHAR2 (1) := 'Y';
34: l_pend_exists BOOLEAN;
35: l_mat_row_count NUMBER;
36: l_rsc_row_count NUMBER;
37: l_phantom_ids gme_common_pvt.number_tab;
38: l_material_ids gme_common_pvt.number_tab;
39: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
40: l_default_row gme_inventory_txns_gtmp%ROWTYPE;
41: /* Exception definations */

Line 38: l_material_ids gme_common_pvt.number_tab;

34: l_pend_exists BOOLEAN;
35: l_mat_row_count NUMBER;
36: l_rsc_row_count NUMBER;
37: l_phantom_ids gme_common_pvt.number_tab;
38: l_material_ids gme_common_pvt.number_tab;
39: l_tran_row gme_inventory_txns_gtmp%ROWTYPE;
40: l_default_row gme_inventory_txns_gtmp%ROWTYPE;
41: /* Exception definations */
42: batch_step_fetch_error EXCEPTION;

Line 161: gme_common_pvt.log_message ('GME_INVALID_DATE_RANGE'

157: p_batch_step_rec.actual_cmplt_date THEN
158: x_batch_step_rec.step_close_date :=
159: p_batch_step_rec.step_close_date;
160: ELSE
161: gme_common_pvt.log_message ('GME_INVALID_DATE_RANGE'
162: ,'DATE1'
163: ,'Close Date'
164: ,'DATE2'
165: ,'Completion Date');

Line 170: x_batch_step_rec.step_close_date := gme_common_pvt.g_timestamp;

166: RAISE gme_invalid_date_range;
167: END IF; /* >= step completion date */
168: x_batch_step_rec.step_close_date := p_batch_step_rec.step_close_date;
169: ELSE
170: x_batch_step_rec.step_close_date := gme_common_pvt.g_timestamp;
171: END IF; /* step close date is not null */
172:
173: --Bug#5109119 check for close period
174: IF NOT gme_common_pvt.check_close_period(p_org_id => l_batch_header.organization_id

Line 174: IF NOT gme_common_pvt.check_close_period(p_org_id => l_batch_header.organization_id

170: x_batch_step_rec.step_close_date := gme_common_pvt.g_timestamp;
171: END IF; /* step close date is not null */
172:
173: --Bug#5109119 check for close period
174: IF NOT gme_common_pvt.check_close_period(p_org_id => l_batch_header.organization_id
175: ,p_trans_date => x_batch_step_rec.step_close_date) THEN
176: RAISE error_close_period;
177: END IF;
178:

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

181: IF NOT (gme_batch_steps_dbl.update_row (x_batch_step_rec) ) THEN
182: RAISE batch_step_upd_err;
183: END IF;
184:
185: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
186: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
187: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
188:
189: /* For any ingredient lines attached with the step we have to */

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

182: RAISE batch_step_upd_err;
183: END IF;
184:
185: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
186: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
187: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
188:
189: /* For any ingredient lines attached with the step we have to */
190: /* close any phantom batches associated with it */

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

183: END IF;
184:
185: x_batch_step_rec.last_update_date := gme_common_pvt.g_timestamp;
186: x_batch_step_rec.last_updated_by := gme_common_pvt.g_user_ident;
187: x_batch_step_rec.last_update_login := gme_common_pvt.g_login_id;
188:
189: /* For any ingredient lines attached with the step we have to */
190: /* close any phantom batches associated with it */
191: /* We need to do this only if close step is

Line 226: gme_common_pvt.log_message ('GME_API_INV_BATCH_CLOSE_STEP');

222: WHEN batch_step_fetch_error OR batch_header_fetch_error OR error_close_period THEN
223: x_return_status := fnd_api.g_ret_sts_error;
224: WHEN invalid_batch_status THEN
225: x_return_status := fnd_api.g_ret_sts_error;
226: gme_common_pvt.log_message ('GME_API_INV_BATCH_CLOSE_STEP');
227: WHEN invalid_batch_type THEN
228: x_return_status := fnd_api.g_ret_sts_error;
229: gme_common_pvt.log_message ('INVALID_BATCH_TYPE_CLS_STEP');
230: WHEN step_status_closed THEN

Line 229: gme_common_pvt.log_message ('INVALID_BATCH_TYPE_CLS_STEP');

225: x_return_status := fnd_api.g_ret_sts_error;
226: gme_common_pvt.log_message ('GME_API_INV_BATCH_CLOSE_STEP');
227: WHEN invalid_batch_type THEN
228: x_return_status := fnd_api.g_ret_sts_error;
229: gme_common_pvt.log_message ('INVALID_BATCH_TYPE_CLS_STEP');
230: WHEN step_status_closed THEN
231: x_return_status := fnd_api.g_ret_sts_error;
232: gme_common_pvt.log_message ('GME_API_CLOSE_STEP_STATUS');
233: WHEN invalid_step_status THEN

Line 232: gme_common_pvt.log_message ('GME_API_CLOSE_STEP_STATUS');

228: x_return_status := fnd_api.g_ret_sts_error;
229: gme_common_pvt.log_message ('INVALID_BATCH_TYPE_CLS_STEP');
230: WHEN step_status_closed THEN
231: x_return_status := fnd_api.g_ret_sts_error;
232: gme_common_pvt.log_message ('GME_API_CLOSE_STEP_STATUS');
233: WHEN invalid_step_status THEN
234: x_return_status := fnd_api.g_ret_sts_error;
235: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_CLS');
236: WHEN dep_step_closed_error THEN

Line 235: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_CLS');

231: x_return_status := fnd_api.g_ret_sts_error;
232: gme_common_pvt.log_message ('GME_API_CLOSE_STEP_STATUS');
233: WHEN invalid_step_status THEN
234: x_return_status := fnd_api.g_ret_sts_error;
235: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_CLS');
236: WHEN dep_step_closed_error THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238: gme_common_pvt.log_message ('GME_API_DEP_STEP_N_CLS');
239: WHEN batch_step_upd_err THEN

Line 238: gme_common_pvt.log_message ('GME_API_DEP_STEP_N_CLS');

234: x_return_status := fnd_api.g_ret_sts_error;
235: gme_common_pvt.log_message ('GME_API_INV_STAT_STEP_CLS');
236: WHEN dep_step_closed_error THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238: gme_common_pvt.log_message ('GME_API_DEP_STEP_N_CLS');
239: WHEN batch_step_upd_err THEN
240: gme_common_pvt.log_message ('GME_API_STEP_UPD_ERROR');
241: WHEN gme_invalid_date_range THEN
242: x_return_status := fnd_api.g_ret_sts_error;

Line 240: gme_common_pvt.log_message ('GME_API_STEP_UPD_ERROR');

236: WHEN dep_step_closed_error THEN
237: x_return_status := fnd_api.g_ret_sts_error;
238: gme_common_pvt.log_message ('GME_API_DEP_STEP_N_CLS');
239: WHEN batch_step_upd_err THEN
240: gme_common_pvt.log_message ('GME_API_STEP_UPD_ERROR');
241: WHEN gme_invalid_date_range THEN
242: x_return_status := fnd_api.g_ret_sts_error;
243: WHEN close_phant_error OR trans_update_err OR trans_delete_err OR fetch_trans_err THEN
244: x_return_status := l_return_status;

Line 247: gme_common_pvt.log_message ('GME_PENDING_TRANS_ERROR');

243: WHEN close_phant_error OR trans_update_err OR trans_delete_err OR fetch_trans_err THEN
244: x_return_status := l_return_status;
245: WHEN pend_trans_err THEN
246: x_return_status := fnd_api.g_ret_sts_error;
247: gme_common_pvt.log_message ('GME_PENDING_TRANS_ERROR');
248: WHEN OTHERS THEN
249: x_return_status := fnd_api.g_ret_sts_unexp_error;
250: fnd_msg_pub.add_exc_msg ('GME_API_CLOSE_STEP', 'CLOSE_STEP');
251: END close_step;