DBA Data[Home] [Help]

APPS.GME_CANCEL_BATCH_PVT dependencies on GME_COMMON_PVT

Line 52: l_material_details_tab gme_common_pvt.material_details_tab;

48: /* Miscellaneous */
49: l_batch_step_rec gme_batch_steps%ROWTYPE;
50: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
51: l_material_details_rec gme_material_details%ROWTYPE;
52: l_material_details_tab gme_common_pvt.material_details_tab;
53: l_batch_step_tab gme_common_pvt.steps_tab;
54: l_batch_header_rec gme_batch_header%ROWTYPE;
55: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
56: l_rsrc_trans_count NUMBER;

Line 53: l_batch_step_tab gme_common_pvt.steps_tab;

49: l_batch_step_rec gme_batch_steps%ROWTYPE;
50: l_in_batch_step_rec gme_batch_steps%ROWTYPE;
51: l_material_details_rec gme_material_details%ROWTYPE;
52: l_material_details_tab gme_common_pvt.material_details_tab;
53: l_batch_step_tab gme_common_pvt.steps_tab;
54: l_batch_header_rec gme_batch_header%ROWTYPE;
55: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
56: l_rsrc_trans_count NUMBER;
57: l_message_count NUMBER; -- 4944024

Line 266: IF NOT gme_common_pvt.create_history (x_batch_header_rec, -1) THEN

262: END IF;
263:
264: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
265: -- Insert the event into the batch history table
266: IF NOT gme_common_pvt.create_history (x_batch_header_rec, -1) THEN
267: IF (g_debug <= gme_debug.g_log_procedure) THEN
268: gme_debug.put_line ( g_pkg_name
269: || '.'
270: || l_api_name

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

276: END IF;
277: END IF;
278:
279: /* Update the row who columns */
280: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
281: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
282: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
283:
284: IF (g_debug <= gme_debug.g_log_procedure) THEN

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

277: END IF;
278:
279: /* Update the row who columns */
280: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
281: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
282: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
283:
284: IF (g_debug <= gme_debug.g_log_procedure) THEN
285: gme_debug.put_line ( g_pkg_name

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

278:
279: /* Update the row who columns */
280: x_batch_header_rec.last_update_date := gme_common_pvt.g_timestamp;
281: x_batch_header_rec.last_updated_by := gme_common_pvt.g_user_ident;
282: x_batch_header_rec.last_update_login := gme_common_pvt.g_login_id;
283:
284: IF (g_debug <= gme_debug.g_log_procedure) THEN
285: gme_debug.put_line ( g_pkg_name
286: || '.'

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

339: || 'BATCH_HEADER_UPD_ERR');
340: END IF;
341:
342: x_return_status := fnd_api.g_ret_sts_error;
343: gme_common_pvt.log_message ('GME_API_BATCH_HEADER_UPD_ERROR');
344: WHEN batch_hist_insert_err THEN
345: IF (g_debug <= gme_debug.g_log_procedure) THEN
346: gme_debug.put_line ( g_pkg_name
347: || '.'

Line 409: l_material_details_tab gme_common_pvt.material_details_tab;

405: ,x_return_status OUT NOCOPY VARCHAR2)
406: IS
407:
408: l_material_details_rec gme_material_details%ROWTYPE;
409: l_material_details_tab gme_common_pvt.material_details_tab;
410: l_batch_header_rec gme_batch_header%ROWTYPE;
411: l_ph_batch_header_rec gme_batch_header%ROWTYPE;
412: l_api_name CONSTANT VARCHAR2 (30) := 'purge_batch_exceptions';
413: delete_reservations_err EXCEPTION;

Line 655: gme_common_pvt.log_message ('GME_INVALID_FIELD'

651: END IF;
652:
653: IF p_batch_id IS NULL AND p_material_detail_id IS NULL THEN
654: -- may use required message
655: gme_common_pvt.log_message ('GME_INVALID_FIELD'
656: ,'FIELD'
657: ,'p_batch_id');
658: RAISE fnd_api.g_exc_error;
659: END IF;