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 127: IF NOT gme_common_pvt.create_history (l_batch_header_rec, p_batch_header_rec.batch_status,

123: END LOOP;
124:
125: IF l_batch_header_rec.update_inventory_ind = 'Y'
126: THEN
127: IF NOT gme_common_pvt.create_history (l_batch_header_rec, p_batch_header_rec.batch_status,
128: gme_common_pvt.g_transaction_header_id)
129: THEN
130: RAISE batch_hist_insert_err;
131: END IF;

Line 128: gme_common_pvt.g_transaction_header_id)

124:
125: IF l_batch_header_rec.update_inventory_ind = 'Y'
126: THEN
127: IF NOT gme_common_pvt.create_history (l_batch_header_rec, p_batch_header_rec.batch_status,
128: gme_common_pvt.g_transaction_header_id)
129: THEN
130: RAISE batch_hist_insert_err;
131: END IF;
132: END IF;

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

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

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

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

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

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

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

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

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

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

Line 211: l_exception_material_tbl gme_common_pvt.exceptions_tab;

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

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

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