DBA Data[Home] [Help]

APPS.GME_CLOSE_BATCH_PVT dependencies on GME_DEBUG

Line 113: IF g_debug <= gme_debug.g_log_procedure THEN

109: FROM gme_material_details
110: WHERE batch_id = v_batch_id
111: AND line_type = 1;
112: BEGIN
113: IF g_debug <= gme_debug.g_log_procedure THEN
114: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
115: || l_api_name);
116: END IF;
117:

Line 114: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

110: WHERE batch_id = v_batch_id
111: AND line_type = 1;
112: BEGIN
113: IF g_debug <= gme_debug.g_log_procedure THEN
114: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
115: || l_api_name);
116: END IF;
117:
118: /* Set the success staus to success inititally*/

Line 127: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN

123: ,x_batch_header_rec) ) THEN
124: RAISE batch_header_fetch_error;
125: END IF;
126:
127: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
128: gme_debug.put_line ( 'Closing batch '
129: || x_batch_header_rec.batch_no
130: || ' at '
131: || TO_CHAR (p_batch_header_rec.batch_close_date

Line 128: gme_debug.put_line ( 'Closing batch '

124: RAISE batch_header_fetch_error;
125: END IF;
126:
127: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
128: gme_debug.put_line ( 'Closing batch '
129: || x_batch_header_rec.batch_no
130: || ' at '
131: || TO_CHAR (p_batch_header_rec.batch_close_date
132: ,'DD-MON-YYYY HH24:MI:SS') );

Line 147: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

143: END IF;
144:
145: -- 4944024 BEGIN
146: -- Delete any reservations against this batch as a supply source
147: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
148: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoking delete_prod_supply_resv for batch header' );
149: END IF;
150:
151: l_batch_header_rec := x_batch_header_rec;

Line 148: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoking delete_prod_supply_resv for batch header' );

144:
145: -- 4944024 BEGIN
146: -- Delete any reservations against this batch as a supply source
147: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
148: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' Invoking delete_prod_supply_resv for batch header' );
149: END IF;
150:
151: l_batch_header_rec := x_batch_header_rec;
152: gme_supply_res_pvt.delete_batch_prod_supply_resv (

Line 207: IF g_debug <= gme_debug.g_log_procedure THEN

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
208: gme_debug.put_line ('Calling Batch Header DBL.Update Row ');
209: END IF;
210:
211: /* Set up the fields in output structure. */

Line 208: gme_debug.put_line ('Calling Batch Header DBL.Update Row ');

204: RAISE batch_close_date_err;
205: END IF;
206:
207: IF g_debug <= gme_debug.g_log_procedure THEN
208: gme_debug.put_line ('Calling Batch Header DBL.Update Row ');
209: END IF;
210:
211: /* Set up the fields in output structure. */
212: x_batch_header_rec.batch_status := 4;

Line 221: IF g_debug <= gme_debug.g_log_procedure THEN

217: END IF;
218:
219: /* Insert the event into the batch history table */
220: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
221: IF g_debug <= gme_debug.g_log_procedure THEN
222: gme_debug.put_line ('Calling Create History.');
223: END IF;
224:
225: IF NOT gme_common_pvt.create_history

Line 222: gme_debug.put_line ('Calling Create History.');

218:
219: /* Insert the event into the batch history table */
220: IF x_batch_header_rec.update_inventory_ind = 'Y' THEN
221: IF g_debug <= gme_debug.g_log_procedure THEN
222: gme_debug.put_line ('Calling Create History.');
223: END IF;
224:
225: IF NOT gme_common_pvt.create_history
226: (p_batch_header_rec => x_batch_header_rec

Line 397: IF g_debug <= gme_debug.g_log_procedure THEN

393: x_return_status := l_return_status;
394: WHEN close_phant_fail THEN
395: x_return_status := l_return_status;
396: WHEN error_processing THEN -- 4944024 BEGIN
397: IF g_debug <= gme_debug.g_log_procedure THEN
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;

Line 398: gme_debug.put_line ('Terminating due to error deleteing reservations against this batch supply.');

394: WHEN close_phant_fail THEN
395: x_return_status := l_return_status;
396: WHEN error_processing THEN -- 4944024 BEGIN
397: IF g_debug <= gme_debug.g_log_procedure THEN
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');