DBA Data[Home] [Help]

APPS.GME_CLOSE_BATCH_PVT dependencies on GME_CLOSE_BATCH_PVT

Line 1: PACKAGE BODY gme_close_batch_pvt AS

1: PACKAGE BODY gme_close_batch_pvt AS
2: /* $Header: GMEVCLBB.pls 120.8.12010000.2 2008/11/06 03:08:35 srpuri ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_CLOSE_BATCH_PVT';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_CLOSE_BATCH_PVT';

1: PACKAGE BODY gme_close_batch_pvt AS
2: /* $Header: GMEVCLBB.pls 120.8.12010000.2 2008/11/06 03:08:35 srpuri ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_CLOSE_BATCH_PVT';
5:
6: /*================================================================================
7: Procedure
8: Close_Batch

Line 39: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;

35: l_row_count NUMBER;
36: l_return_status VARCHAR2 (1);
37: l_ins_history gme_batch_history%ROWTYPE;
38: l_batch_step gme_batch_steps%ROWTYPE;
39: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
40: l_batch_header gme_batch_header%ROWTYPE;
41: l_in_batch_header gme_batch_header%ROWTYPE;
42: l_material_detail_ids gme_common_pvt.number_tab;
43: l_message_count NUMBER;

Line 203: IF NOT (gme_close_batch_pvt.check_close_date (x_batch_header_rec) ) THEN

199: p_batch_header_rec.batch_close_date;
200: END IF;
201:
202: /* Check batch close date is not less than step close or transaction dates */
203: IF NOT (gme_close_batch_pvt.check_close_date (x_batch_header_rec) ) THEN
204: RAISE batch_close_date_err;
205: END IF;
206:
207: IF g_debug <= gme_debug.g_log_procedure THEN

Line 251: gme_close_batch_pvt.close_batch

247: IF l_in_batch_header.batch_status = 3 THEN
248: /* x_batch_header_rec has either sysdate or the user passed-in date */
249: l_in_batch_header.batch_close_date :=
250: x_batch_header_rec.batch_close_date;
251: gme_close_batch_pvt.close_batch
252: (p_batch_header_rec => l_in_batch_header
253: ,x_batch_header_rec => l_batch_header
254: ,x_return_status => l_return_status);
255:

Line 264: gme_close_batch_pvt.fetch_batch_steps (x_batch_header_rec.batch_id

260: END LOOP;
261:
262: IF x_batch_header_rec.poc_ind = 'Y' THEN
263: /* Now update the batch step status to close */
264: gme_close_batch_pvt.fetch_batch_steps (x_batch_header_rec.batch_id
265: ,NULL
266: ,l_batch_steps_tab
267: ,l_return_status);
268:

Line 402: fnd_msg_pub.add_exc_msg ('GME_CLOSE_BATCH_PVT', 'CLOSE_BATCH');

398: gme_debug.put_line ('Terminating due to error deleteing reservations against this batch supply.');
399: END IF; -- 4944024 END
400: WHEN OTHERS THEN
401: x_return_status := fnd_api.g_ret_sts_unexp_error;
402: fnd_msg_pub.add_exc_msg ('GME_CLOSE_BATCH_PVT', 'CLOSE_BATCH');
403: END close_batch;
404:
405: /*===============================================================================
406: Function

Line 806: END gme_close_batch_pvt;

802: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
803: fnd_message.set_token ('ERROR', SQLERRM);
804: fnd_msg_pub.ADD;
805: END fetch_batch_steps;
806: END gme_close_batch_pvt;