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

Line 44: l_material_details_tab gme_common_pvt.material_details_tab ;

40:
41: /* Buffers for database reads/writes */
42:
43: l_batch_header_rec gme_batch_header%ROWTYPE;
44: l_material_details_tab gme_common_pvt.material_details_tab ;
45:
46: /* Exception definitions */
47: BATCH_LINES_LOCKED EXCEPTION;
48: MATERIAL_DETAIL_FETCH_ERROR EXCEPTION;

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

81: CLOSE Cur_lock_batch_materials;
82:
83: /* Mark batch as 'WIP' */
84: l_batch_header_rec.batch_status := 2;
85: gme_common_pvt.g_batch_status_check := fnd_api.g_false;
86: /* Fetch all the material lines associated with the batch */
87: FOR i IN 1..l_material_details_tab.COUNT LOOP
88: IF (g_debug <= gme_debug.g_log_statement) THEN
89: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

Line 101: AND (gme_common_pvt.is_material_auto_release

97: AND l_material_details_tab(i).phantom_id IS NOT NULL)
98: OR
99: (l_material_details_tab(i).line_type <> -1
100: AND l_material_details_tab(i).phantom_line_id IS NULL
101: AND (gme_common_pvt.is_material_auto_release
102: (l_material_details_tab(i).material_detail_id) = 0 )
103: )) THEN
104: IF (g_debug <= gme_debug.g_log_statement) THEN
105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'

Line 128: IF NOT gme_common_pvt.create_history (l_batch_header_rec, p_batch_header_rec.batch_status)

124:
125: IF l_batch_header_rec.update_inventory_ind = 'Y'
126: THEN
127: -- Bug 11846735 - Do not pass in a value for event_id.
128: IF NOT gme_common_pvt.create_history (l_batch_header_rec, p_batch_header_rec.batch_status)
129: -- , gme_common_pvt.g_transaction_header_id)
130: THEN
131: RAISE batch_hist_insert_err;
132: END IF;

Line 129: -- , gme_common_pvt.g_transaction_header_id)

125: IF l_batch_header_rec.update_inventory_ind = 'Y'
126: THEN
127: -- Bug 11846735 - Do not pass in a value for event_id.
128: IF NOT gme_common_pvt.create_history (l_batch_header_rec, p_batch_header_rec.batch_status)
129: -- , gme_common_pvt.g_transaction_header_id)
130: THEN
131: RAISE batch_hist_insert_err;
132: END IF;
133: END IF;

Line 144: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;

140: RAISE BATCH_HDR_UPDATE_ERROR;
141: END IF;
142: x_batch_header_rec := l_batch_header_rec ;
143: /* Update the row who columns */
144: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
145: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
146: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
147:
148: EXCEPTION

Line 145: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;

141: END IF;
142: x_batch_header_rec := l_batch_header_rec ;
143: /* Update the row who columns */
144: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
145: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
146: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
147:
148: EXCEPTION
149:

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

142: x_batch_header_rec := l_batch_header_rec ;
143: /* Update the row who columns */
144: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
145: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
146: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
147:
148: EXCEPTION
149:
150:

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

149:
150:
151: WHEN BATCH_LINES_LOCKED THEN
152: x_return_status := FND_API.G_RET_STS_ERROR;
153: gme_common_pvt.log_message('GME_API_BATCH_LINES_LOCKED');
154:
155: WHEN REVERT_LINE_FAIL THEN
156: x_return_status := l_return_status;
157:

Line 164: gme_common_pvt.log_message('GME_RECORD_LOCKED','TABLE_NAME', g_table_name, 'KEY',to_char(p_batch_header_rec.batch_id));

160: WHEN BATCH_HDR_UPDATE_ERROR THEN
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: WHEN app_exception.record_lock_exception THEN
163: x_return_status := FND_API.G_RET_STS_ERROR;
164: gme_common_pvt.log_message('GME_RECORD_LOCKED','TABLE_NAME', g_table_name, 'KEY',to_char(p_batch_header_rec.batch_id));
165: WHEN OTHERS THEN
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167:
168: IF (NVL (g_debug, -1) = gme_debug.g_log_unexpected) THEN

Line 212: l_exception_material_tbl gme_common_pvt.exceptions_tab;

208: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
209: l_rsrc_trans_count NUMBER;
210: l_message_count NUMBER;
211: l_message_list VARCHAR2(2000);
212: l_exception_material_tbl gme_common_pvt.exceptions_tab;
213: l_actual_qty NUMBER;
214: CURSOR Cur_get_step (V_material_detail_id NUMBER) IS
215: SELECT batchstep_id
216: FROM gme_batch_step_items

Line 328: GME_common_pvt.log_message('GME_API_BATCH_FETCH_ERROR');

324: WHEN REVERT_MATL_ERROR THEN
325: NULL;
326: WHEN BATCH_HEADER_FETCH_ERROR THEN
327: x_return_status := FND_API.G_RET_STS_ERROR;
328: GME_common_pvt.log_message('GME_API_BATCH_FETCH_ERROR');
329: WHEN REVERT_PHANT_FAIL THEN
330: NULL;
331: WHEN ERROR_LOAD_TRANS OR UPDATE_STEP_QTY_ERROR THEN
332: x_return_status := l_return_status;