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.14.12020000.2 2012/07/26 15:28:58 gmurator 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.14.12020000.2 2012/07/26 15:28:58 gmurator 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 52: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;

48: l_row_count NUMBER;
49: l_return_status VARCHAR2 (1);
50: l_ins_history gme_batch_history%ROWTYPE;
51: l_batch_step gme_batch_steps%ROWTYPE;
52: l_batch_steps_tab gme_close_batch_pvt.step_details_tab;
53: l_batch_header gme_batch_header%ROWTYPE;
54: l_in_batch_header gme_batch_header%ROWTYPE;
55: l_material_detail_ids gme_common_pvt.number_tab;
56: l_message_count NUMBER;

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

284: p_batch_header_rec.batch_close_date;
285: END IF;
286:
287: /* Check batch close date is not less than step close or transaction dates */
288: IF NOT (gme_close_batch_pvt.check_close_date (x_batch_header_rec) ) THEN
289: RAISE batch_close_date_err;
290: END IF;
291:
292: IF g_debug <= gme_debug.g_log_procedure THEN

Line 336: gme_close_batch_pvt.close_batch

332: IF l_in_batch_header.batch_status = 3 THEN
333: /* x_batch_header_rec has either sysdate or the user passed-in date */
334: l_in_batch_header.batch_close_date :=
335: x_batch_header_rec.batch_close_date;
336: gme_close_batch_pvt.close_batch
337: (p_batch_header_rec => l_in_batch_header
338: ,x_batch_header_rec => l_batch_header
339: ,x_return_status => l_return_status);
340:

Line 349: gme_close_batch_pvt.fetch_batch_steps (x_batch_header_rec.batch_id

345: END LOOP;
346:
347: IF x_batch_header_rec.poc_ind = 'Y' THEN
348: /* Now update the batch step status to close */
349: gme_close_batch_pvt.fetch_batch_steps (x_batch_header_rec.batch_id
350: ,NULL
351: ,l_batch_steps_tab
352: ,l_return_status);
353:

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

502: || 'purge_exception_err');
503: END IF;
504: WHEN OTHERS THEN
505: x_return_status := fnd_api.g_ret_sts_unexp_error;
506: fnd_msg_pub.add_exc_msg ('GME_CLOSE_BATCH_PVT', 'CLOSE_BATCH');
507: END close_batch;
508:
509: /*===============================================================================
510: Function

Line 914: END gme_close_batch_pvt;

910: fnd_message.set_name ('GMD', 'GMD_UNEXPECTED_ERROR');
911: fnd_message.set_token ('ERROR', SQLERRM);
912: fnd_msg_pub.ADD;
913: END fetch_batch_steps;
914: END gme_close_batch_pvt;