DBA Data[Home] [Help]

APPS.GME_TERMINATE_BATCH_PVT dependencies on GME_COMMON_PVT

Line 58: l_material_details_tab gme_common_pvt.material_details_tab;

54: ORDER BY batchstep_id;
55:
56: /* Variable Declarations */
57: l_material_details gme_material_details%ROWTYPE;
58: l_material_details_tab gme_common_pvt.material_details_tab;
59: l_batch_header_rec gme_batch_header%ROWTYPE;
60: l_in_batch_header_rec gme_batch_header%ROWTYPE;
61: l_batch_step_rec gme_batch_steps%ROWTYPE;
62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

Line 63: l_batch_step_ids gme_common_pvt.number_tab;

59: l_batch_header_rec gme_batch_header%ROWTYPE;
60: l_in_batch_header_rec gme_batch_header%ROWTYPE;
61: l_batch_step_rec gme_batch_steps%ROWTYPE;
62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
63: l_batch_step_ids gme_common_pvt.number_tab;
64: l_rsrc_trans_count NUMBER;
65: l_batch_step_tab gme_common_pvt.steps_tab;
66: m_batch_step_tab gme_common_pvt.steps_tab;
67: l_message_count NUMBER; -- 4944024

Line 65: l_batch_step_tab gme_common_pvt.steps_tab;

61: l_batch_step_rec gme_batch_steps%ROWTYPE;
62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
63: l_batch_step_ids gme_common_pvt.number_tab;
64: l_rsrc_trans_count NUMBER;
65: l_batch_step_tab gme_common_pvt.steps_tab;
66: m_batch_step_tab gme_common_pvt.steps_tab;
67: l_message_count NUMBER; -- 4944024
68: l_message_list VARCHAR2 (2000); -- 4944024
69: l_api_name CONSTANT VARCHAR2 (30) := 'Terminate Batch';

Line 66: m_batch_step_tab gme_common_pvt.steps_tab;

62: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
63: l_batch_step_ids gme_common_pvt.number_tab;
64: l_rsrc_trans_count NUMBER;
65: l_batch_step_tab gme_common_pvt.steps_tab;
66: m_batch_step_tab gme_common_pvt.steps_tab;
67: l_message_count NUMBER; -- 4944024
68: l_message_list VARCHAR2 (2000); -- 4944024
69: l_api_name CONSTANT VARCHAR2 (30) := 'Terminate Batch';
70: l_lock_status VARCHAR2(1);

Line 249: P_REQUESTER => gme_common_pvt.g_user_ident,

245: X_MSG_COUNT => l_message_count,
246: X_MSG_DATA => l_message_list,
247: P_ENTITY_NAME => 'OPERATION',
248: P_ENTITY_KEY => l_in_batch_step_rec.batchstep_id,
249: P_REQUESTER => gme_common_pvt.g_user_ident,
250: X_LOCK_STATUS => l_lock_status,
251: X_LOCKED_BY_STATUS => l_locked_by_status,
252: X_LOCK_ALLOWED => l_lock_allowed);
253:

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

262: || 'from gmo the lock_status='
263: || l_lock_status);
264: END IF;
265: IF l_lock_status = 'Y' THEN
266: gme_common_pvt.log_message ('GME_STEP_LOCK_ERROR');
267: RAISE gmo_lock_error;
268: END IF;
269:
270: gme_terminate_step_pvt.terminate_step

Line 355: IF NOT gme_common_pvt.create_history

351: ,p_item_id => x_batch_header_rec.batch_id);
352:
353: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
354: /* Insert the event into the batch history table */
355: IF NOT gme_common_pvt.create_history
356: (x_batch_header_rec
357: ,p_batch_header_rec.batch_status) THEN
358: RAISE batch_hist_insert_err;
359: END IF;

Line 407: gme_common_pvt.log_message ('GME_INVALID_BSTAT_TERM');

403: || 'INVALID_BATCH_STATUS.');
404: END IF;
405:
406: x_return_status := fnd_api.g_ret_sts_error;
407: gme_common_pvt.log_message ('GME_INVALID_BSTAT_TERM');
408: WHEN batch_header_upd_err THEN
409: IF (g_debug <= gme_debug.g_log_procedure) THEN
410: gme_debug.put_line ( g_pkg_name
411: || '.'

Line 418: gme_common_pvt.log_message ('GME_API_BATCH_HEADER_UPD_ERROR');

414: || 'BATCH_HEADER_UPD_ERR.');
415: END IF;
416:
417: x_return_status := fnd_api.g_ret_sts_error;
418: gme_common_pvt.log_message ('GME_API_BATCH_HEADER_UPD_ERROR');
419: WHEN phantom_batch_terminate_error THEN
420: IF (g_debug <= gme_debug.g_log_procedure) THEN
421: gme_debug.put_line ( g_pkg_name
422: || '.'