DBA Data[Home] [Help]

APPS.GME_TERMINATE_BATCH_PVT dependencies on GME_COMMON_PVT

Line 62: l_material_details_tab gme_common_pvt.material_details_tab;

58: ORDER BY batchstep_id;
59:
60: /* Variable Declarations */
61: l_material_details gme_material_details%ROWTYPE;
62: l_material_details_tab gme_common_pvt.material_details_tab;
63: l_batch_header_rec gme_batch_header%ROWTYPE;
64: l_in_batch_header_rec gme_batch_header%ROWTYPE;
65: l_batch_step_rec gme_batch_steps%ROWTYPE;
66: l_in_batch_step_rec gme_batch_steps%ROWTYPE;

Line 67: l_batch_step_ids gme_common_pvt.number_tab;

63: l_batch_header_rec gme_batch_header%ROWTYPE;
64: l_in_batch_header_rec gme_batch_header%ROWTYPE;
65: l_batch_step_rec gme_batch_steps%ROWTYPE;
66: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
67: l_batch_step_ids gme_common_pvt.number_tab;
68: l_rsrc_trans_count NUMBER;
69: l_batch_step_tab gme_common_pvt.steps_tab;
70: m_batch_step_tab gme_common_pvt.steps_tab;
71: l_message_count NUMBER; -- 4944024

Line 69: l_batch_step_tab gme_common_pvt.steps_tab;

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

Line 70: m_batch_step_tab gme_common_pvt.steps_tab;

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

Line 257: P_REQUESTER => gme_common_pvt.g_user_ident,

253: X_MSG_COUNT => l_message_count,
254: X_MSG_DATA => l_message_list,
255: P_ENTITY_NAME => 'OPERATION',
256: P_ENTITY_KEY => l_in_batch_step_rec.batchstep_id,
257: P_REQUESTER => gme_common_pvt.g_user_ident,
258: X_LOCK_STATUS => l_lock_status,
259: X_LOCKED_BY_STATUS => l_locked_by_status,
260: X_LOCK_ALLOWED => l_lock_allowed);
261:

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

272: || l_lock_status);
273: END IF;
274:
275: IF l_lock_status = 'Y' THEN
276: gme_common_pvt.log_message ('GME_STEP_LOCK_ERROR');
277: RAISE gmo_lock_error;
278: END IF;
279: END IF;
280:

Line 366: IF NOT gme_common_pvt.create_history

362: ,p_item_id => x_batch_header_rec.batch_id);
363:
364: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
365: /* Insert the event into the batch history table */
366: IF NOT gme_common_pvt.create_history
367: (x_batch_header_rec
368: ,p_batch_header_rec.batch_status) THEN
369: RAISE batch_hist_insert_err;
370: END IF;

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

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

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

425: || 'BATCH_HEADER_UPD_ERR.');
426: END IF;
427:
428: x_return_status := fnd_api.g_ret_sts_error;
429: gme_common_pvt.log_message ('GME_API_BATCH_HEADER_UPD_ERROR');
430: WHEN phantom_batch_terminate_error THEN
431: IF (g_debug <= gme_debug.g_log_procedure) THEN
432: gme_debug.put_line ( g_pkg_name
433: || '.'