DBA Data[Home] [Help]

APPS.GME_UNRELEASE_STEP_PVT dependencies on GME_DEBUG

Line 55: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

51: error_unrelease_matl EXCEPTION;
52: update_step_qty_error EXCEPTION;
53: gmo_lock_error EXCEPTION;
54: BEGIN
55: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
56: gme_debug.g_log_procedure THEN
57: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
58: || l_api_name);
59: gme_debug.put_line ( g_pkg_name

Line 56: gme_debug.g_log_procedure THEN

52: update_step_qty_error EXCEPTION;
53: gmo_lock_error EXCEPTION;
54: BEGIN
55: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
56: gme_debug.g_log_procedure THEN
57: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
58: || l_api_name);
59: gme_debug.put_line ( g_pkg_name
60: || '.'

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

53: gmo_lock_error EXCEPTION;
54: BEGIN
55: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
56: gme_debug.g_log_procedure THEN
57: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
58: || l_api_name);
59: gme_debug.put_line ( g_pkg_name
60: || '.'
61: || l_api_name

Line 59: gme_debug.put_line ( g_pkg_name

55: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
56: gme_debug.g_log_procedure THEN
57: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
58: || l_api_name);
59: gme_debug.put_line ( g_pkg_name
60: || '.'
61: || l_api_name
62: || ' unreleasing batchstep_id='
63: || p_batch_step_rec.batchstep_id);

Line 86: gme_debug.put_line ( g_pkg_name

82: P_REQUESTER => gme_common_pvt.g_user_ident,
83: X_LOCK_STATUS => l_lock_status,
84: X_LOCKED_BY_STATUS => l_locked_by_status,
85: X_LOCK_ALLOWED => l_lock_allowed);
86: gme_debug.put_line ( g_pkg_name
87: || '.'
88: || l_api_name
89: || ':'
90: || 'from gmo the lock_status='

Line 95: IF (g_debug <= gme_debug.g_log_procedure) THEN

91: || l_lock_status);
92: IF l_return_status <> fnd_api.g_ret_sts_success THEN
93: RAISE gmo_lock_error;
94: END IF;
95: IF (g_debug <= gme_debug.g_log_procedure) THEN
96: gme_debug.put_line ( g_pkg_name
97: || '.'
98: || l_api_name
99: || ':'

Line 96: gme_debug.put_line ( g_pkg_name

92: IF l_return_status <> fnd_api.g_ret_sts_success THEN
93: RAISE gmo_lock_error;
94: END IF;
95: IF (g_debug <= gme_debug.g_log_procedure) THEN
96: gme_debug.put_line ( g_pkg_name
97: || '.'
98: || l_api_name
99: || ':'
100: || 'from gmo the lock_status='

Line 217: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

213: WHERE batchstep_id = x_batch_step_rec.batchstep_id
214: AND batch_id = x_batch_step_rec.batch_id
215: AND plan_cmplt_date IS NULL;
216:
217: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
218: gme_debug.g_log_procedure THEN
219: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
220: END IF;
221: EXCEPTION

Line 218: gme_debug.g_log_procedure THEN

214: AND batch_id = x_batch_step_rec.batch_id
215: AND plan_cmplt_date IS NULL;
216:
217: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
218: gme_debug.g_log_procedure THEN
219: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
220: END IF;
221: EXCEPTION
222: WHEN error_update_row THEN

Line 219: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

215: AND plan_cmplt_date IS NULL;
216:
217: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
218: gme_debug.g_log_procedure THEN
219: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
220: END IF;
221: EXCEPTION
222: WHEN error_update_row THEN
223: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

Line 229: IF (g_debug <= gme_debug.g_log_procedure) THEN

225: x_return_status := fnd_api.g_ret_sts_unexp_error;
226: WHEN error_unrelease_matl OR update_step_qty_error THEN
227: NULL;
228: WHEN gmo_lock_error THEN
229: IF (g_debug <= gme_debug.g_log_procedure) THEN
230: gme_debug.put_line ( g_pkg_name
231: || '.'
232: || l_api_name
233: || ':'

Line 230: gme_debug.put_line ( g_pkg_name

226: WHEN error_unrelease_matl OR update_step_qty_error THEN
227: NULL;
228: WHEN gmo_lock_error THEN
229: IF (g_debug <= gme_debug.g_log_procedure) THEN
230: gme_debug.put_line ( g_pkg_name
231: || '.'
232: || l_api_name
233: || ':'
234: || 'GMO_LOCK_ERROR.');

Line 241: IF g_debug <= gme_debug.g_log_procedure THEN

237: x_return_status := fnd_api.g_ret_sts_error;
238: WHEN OTHERS THEN
239: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
240:
241: IF g_debug <= gme_debug.g_log_procedure THEN
242: gme_debug.put_line ( 'Unexpected error: '
243: || g_pkg_name
244: || '.'
245: || l_api_name

Line 242: gme_debug.put_line ( 'Unexpected error: '

238: WHEN OTHERS THEN
239: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
240:
241: IF g_debug <= gme_debug.g_log_procedure THEN
242: gme_debug.put_line ( 'Unexpected error: '
243: || g_pkg_name
244: || '.'
245: || l_api_name
246: || ': '

Line 277: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

273: error_step_status EXCEPTION;
274: error_dep_step_status EXCEPTION;
275:
276: BEGIN
277: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
278: gme_debug.g_log_procedure THEN
279: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
280: || l_api_name);
281: END IF;

Line 278: gme_debug.g_log_procedure THEN

274: error_dep_step_status EXCEPTION;
275:
276: BEGIN
277: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
278: gme_debug.g_log_procedure THEN
279: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
280: || l_api_name);
281: END IF;
282:

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

275:
276: BEGIN
277: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
278: gme_debug.g_log_procedure THEN
279: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
280: || l_api_name);
281: END IF;
282:
283: IF p_batch_hdr_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN

Line 308: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=

304: END IF;
305: CLOSE cur_dep_step;
306: END IF; -- IF p_batch_hdr_rec.automatic_step_calculation = 1 OR
307:
308: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
309: gme_debug.g_log_procedure THEN
310: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
311: END IF;
312: EXCEPTION

Line 309: gme_debug.g_log_procedure THEN

305: CLOSE cur_dep_step;
306: END IF; -- IF p_batch_hdr_rec.automatic_step_calculation = 1 OR
307:
308: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
309: gme_debug.g_log_procedure THEN
310: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
311: END IF;
312: EXCEPTION
313: WHEN error_step_status THEN

Line 310: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);

306: END IF; -- IF p_batch_hdr_rec.automatic_step_calculation = 1 OR
307:
308: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
309: gme_debug.g_log_procedure THEN
310: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
311: END IF;
312: EXCEPTION
313: WHEN error_step_status THEN
314: gme_common_pvt.log_message('GME_API_INV_STEP_STAT_UNRELE');

Line 325: IF g_debug <= gme_debug.g_log_procedure THEN

321: x_return_status := FND_API.G_RET_STS_ERROR;
322: WHEN OTHERS THEN
323: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
324:
325: IF g_debug <= gme_debug.g_log_procedure THEN
326: gme_debug.put_line ( 'Unexpected error: '
327: || g_pkg_name
328: || '.'
329: || l_api_name

Line 326: gme_debug.put_line ( 'Unexpected error: '

322: WHEN OTHERS THEN
323: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
324:
325: IF g_debug <= gme_debug.g_log_procedure THEN
326: gme_debug.put_line ( 'Unexpected error: '
327: || g_pkg_name
328: || '.'
329: || l_api_name
330: || ': '