eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_UNRELEASE_BATCH_PVT dependencies on GME_DEBUG

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

57: l_message_list VARCHAR2(2000);
58: gmf_cost_failure EXCEPTION;
59:
60: BEGIN
61: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
62: gme_debug.g_log_procedure THEN
63: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
64: || l_api_name);
65: gme_debug.put_line ( g_pkg_name

Line 62: gme_debug.g_log_procedure THEN

58: gmf_cost_failure EXCEPTION;
59:
60: BEGIN
61: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
62: gme_debug.g_log_procedure THEN
63: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
64: || l_api_name);
65: gme_debug.put_line ( g_pkg_name
66: || '.'

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

59:
60: BEGIN
61: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
62: gme_debug.g_log_procedure THEN
63: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
64: || l_api_name);
65: gme_debug.put_line ( g_pkg_name
66: || '.'
67: || l_api_name

Line 65: gme_debug.put_line ( g_pkg_name

61: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
62: gme_debug.g_log_procedure THEN
63: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
64: || l_api_name);
65: gme_debug.put_line ( g_pkg_name
66: || '.'
67: || l_api_name
68: || ' unreleasing batch_id='
69: || p_batch_header_rec.batch_id);

Line 168: IF g_debug <= gme_debug.g_log_procedure THEN

164: IF NOT gme_common_pvt.create_history
165: (p_batch_header_rec => x_batch_header_rec
166: ,p_original_status => gme_common_pvt.g_batch_wip
167: ,p_event_id => gme_common_pvt.g_transaction_header_id) THEN
168: IF g_debug <= gme_debug.g_log_procedure THEN
169: gme_debug.put_line ( g_pkg_name
170: || '.'
171: || l_api_name
172: || ' create history returned error');

Line 169: gme_debug.put_line ( g_pkg_name

165: (p_batch_header_rec => x_batch_header_rec
166: ,p_original_status => gme_common_pvt.g_batch_wip
167: ,p_event_id => gme_common_pvt.g_transaction_header_id) THEN
168: IF g_debug <= gme_debug.g_log_procedure THEN
169: gme_debug.put_line ( g_pkg_name
170: || '.'
171: || l_api_name
172: || ' create history returned error');
173: END IF;

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

172: || ' create history returned error');
173: END IF;
174: END IF;
175:
176: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
177: gme_debug.g_log_procedure THEN
178: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
179: END IF;
180: EXCEPTION

Line 177: gme_debug.g_log_procedure THEN

173: END IF;
174: END IF;
175:
176: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
177: gme_debug.g_log_procedure THEN
178: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
179: END IF;
180: EXCEPTION
181: WHEN gmf_cost_failure THEN

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

174: END IF;
175:
176: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
177: gme_debug.g_log_procedure THEN
178: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
179: END IF;
180: EXCEPTION
181: WHEN gmf_cost_failure THEN
182: -- Bug 5043868

Line 197: IF g_debug <= gme_debug.g_log_procedure THEN

193: NULL;
194: WHEN OTHERS THEN
195: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
196:
197: IF g_debug <= gme_debug.g_log_procedure THEN
198: gme_debug.put_line ( 'Unexpected error: '
199: || g_pkg_name
200: || '.'
201: || l_api_name

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

194: WHEN OTHERS THEN
195: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
196:
197: IF g_debug <= gme_debug.g_log_procedure THEN
198: gme_debug.put_line ( 'Unexpected error: '
199: || g_pkg_name
200: || '.'
201: || l_api_name
202: || ': '

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

227: error_get_item EXCEPTION;
228: error_revert_material EXCEPTION;
229: error_update_row EXCEPTION;
230: BEGIN
231: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
232: gme_debug.g_log_procedure THEN
233: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
234: || l_api_name);
235: gme_debug.put_line ( g_pkg_name

Line 232: gme_debug.g_log_procedure THEN

228: error_revert_material EXCEPTION;
229: error_update_row EXCEPTION;
230: BEGIN
231: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
232: gme_debug.g_log_procedure THEN
233: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
234: || l_api_name);
235: gme_debug.put_line ( g_pkg_name
236: || '.'

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

229: error_update_row EXCEPTION;
230: BEGIN
231: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
232: gme_debug.g_log_procedure THEN
233: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
234: || l_api_name);
235: gme_debug.put_line ( g_pkg_name
236: || '.'
237: || l_api_name

Line 235: gme_debug.put_line ( g_pkg_name

231: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
232: gme_debug.g_log_procedure THEN
233: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
234: || l_api_name);
235: gme_debug.put_line ( g_pkg_name
236: || '.'
237: || l_api_name
238: || ' unrelease material material_detail_id='
239: || p_material_detail_rec.material_detail_id);

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

251: ,l_phantom_batch_rec) THEN
252: RAISE error_fetch_batch;
253: END IF;
254:
255: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
256: gme_debug.put_line
257: ( g_pkg_name
258: || '.'
259: || l_api_name

Line 256: gme_debug.put_line

252: RAISE error_fetch_batch;
253: END IF;
254:
255: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
256: gme_debug.put_line
257: ( g_pkg_name
258: || '.'
259: || l_api_name
260: || ' found phantom ingredient material_detail_id='

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

321: IF NOT gme_material_details_dbl.update_row (l_material_detail_rec) THEN
322: RAISE error_update_row;
323: END IF;
324:
325: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
326: gme_debug.g_log_procedure THEN
327: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
328: END IF;
329: EXCEPTION

Line 326: gme_debug.g_log_procedure THEN

322: RAISE error_update_row;
323: END IF;
324:
325: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
326: gme_debug.g_log_procedure THEN
327: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
328: END IF;
329: EXCEPTION
330: WHEN error_update_row OR error_fetch_batch THEN

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

323: END IF;
324:
325: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
326: gme_debug.g_log_procedure THEN
327: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
328: END IF;
329: EXCEPTION
330: WHEN error_update_row OR error_fetch_batch THEN
331: gme_common_pvt.log_message ('GME_UNEXPECTED_ERROR', 'ERROR'

Line 339: IF g_debug <= gme_debug.g_log_procedure THEN

335: NULL;
336: WHEN OTHERS THEN
337: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
338:
339: IF g_debug <= gme_debug.g_log_procedure THEN
340: gme_debug.put_line ( 'Unexpected error: '
341: || g_pkg_name
342: || '.'
343: || l_api_name

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

336: WHEN OTHERS THEN
337: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
338:
339: IF g_debug <= gme_debug.g_log_procedure THEN
340: gme_debug.put_line ( 'Unexpected error: '
341: || g_pkg_name
342: || '.'
343: || l_api_name
344: || ': '

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

377: WHERE i.organization_id = v_organization_id
378: AND i.inventory_item_id = v_inventory_item_id;
379: l_item_rec Cur_item_details%ROWTYPE;
380: BEGIN
381: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
382: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
383: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' material_detail_id='|| p_material_detail_rec.material_detail_id);
384: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_create_resv_pend_lots='|| p_create_resv_pend_lots);
385: IF p_ignore_transactable THEN

Line 382: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);

378: AND i.inventory_item_id = v_inventory_item_id;
379: l_item_rec Cur_item_details%ROWTYPE;
380: BEGIN
381: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
382: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
383: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' material_detail_id='|| p_material_detail_rec.material_detail_id);
384: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_create_resv_pend_lots='|| p_create_resv_pend_lots);
385: IF p_ignore_transactable THEN
386: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS TRUE');

Line 383: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' material_detail_id='|| p_material_detail_rec.material_detail_id);

379: l_item_rec Cur_item_details%ROWTYPE;
380: BEGIN
381: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
382: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
383: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' material_detail_id='|| p_material_detail_rec.material_detail_id);
384: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_create_resv_pend_lots='|| p_create_resv_pend_lots);
385: IF p_ignore_transactable THEN
386: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS TRUE');
387: ELSE

Line 384: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_create_resv_pend_lots='|| p_create_resv_pend_lots);

380: BEGIN
381: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
382: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
383: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' material_detail_id='|| p_material_detail_rec.material_detail_id);
384: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_create_resv_pend_lots='|| p_create_resv_pend_lots);
385: IF p_ignore_transactable THEN
386: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS TRUE');
387: ELSE
388: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS FALSE');

Line 386: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS TRUE');

382: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
383: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' material_detail_id='|| p_material_detail_rec.material_detail_id);
384: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_create_resv_pend_lots='|| p_create_resv_pend_lots);
385: IF p_ignore_transactable THEN
386: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS TRUE');
387: ELSE
388: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS FALSE');
389: END IF;
390: END IF;

Line 388: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS FALSE');

384: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_create_resv_pend_lots='|| p_create_resv_pend_lots);
385: IF p_ignore_transactable THEN
386: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS TRUE');
387: ELSE
388: gme_debug.put_line (g_pkg_name|| '.'|| l_api_name|| ' p_ignore_transactable IS FALSE');
389: END IF;
390: END IF;
391:
392: -- Set the return status to success initially

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

401: RAISE error_get_trans;
402: END IF;
403:
404: x_actual_qty := p_material_detail_rec.actual_qty;
405: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
406: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' actual_qty = '||x_actual_qty);
407: END IF;
408:
409: FOR i IN 1 .. l_mmt_tbl.COUNT LOOP

Line 406: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' actual_qty = '||x_actual_qty);

402: END IF;
403:
404: x_actual_qty := p_material_detail_rec.actual_qty;
405: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
406: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' actual_qty = '||x_actual_qty);
407: END IF;
408:
409: FOR i IN 1 .. l_mmt_tbl.COUNT LOOP
410: l_mmt_rec := l_mmt_tbl (i);

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

431: p_item_no => l_item_rec.concatenated_segments) THEN
432: RAISE fnd_api.g_exc_error;
433: END IF;
434: END IF;
435: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
436: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name||
437: ' calling gme_transactions_pvt.delete_material_txn with trxn_id= '||l_mmt_rec.transaction_id);
438: END IF;
439:

Line 436: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name||

432: RAISE fnd_api.g_exc_error;
433: END IF;
434: END IF;
435: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
436: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name||
437: ' calling gme_transactions_pvt.delete_material_txn with trxn_id= '||l_mmt_rec.transaction_id);
438: END IF;
439:
440: gme_transactions_pvt.delete_material_txn

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

444:
445: IF x_return_status <> fnd_api.g_ret_sts_success THEN
446: IF x_return_status = gme_common_pvt.g_not_transactable AND p_ignore_transactable THEN
447: -- don't do anything... move to the next...
448: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
449: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
450: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
451: || ' but p_ignore_transactable is set to TRUE; so moving to the next transaction');
452: END IF;

Line 449: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name

445: IF x_return_status <> fnd_api.g_ret_sts_success THEN
446: IF x_return_status = gme_common_pvt.g_not_transactable AND p_ignore_transactable THEN
447: -- don't do anything... move to the next...
448: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
449: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
450: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
451: || ' but p_ignore_transactable is set to TRUE; so moving to the next transaction');
452: END IF;
453: ELSE

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

450: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
451: || ' but p_ignore_transactable is set to TRUE; so moving to the next transaction');
452: END IF;
453: ELSE
454: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
455: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
456: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
457: || ' but p_ignore_transactable is set to FALSE; raising exception');
458: END IF;

Line 455: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name

451: || ' but p_ignore_transactable is set to TRUE; so moving to the next transaction');
452: END IF;
453: ELSE
454: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
455: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name
456: || ' gme_transactions_pvt.delete_material_txn returned '||l_return_status
457: || ' but p_ignore_transactable is set to FALSE; raising exception');
458: END IF;
459: RAISE error_del_trans;

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

459: RAISE error_del_trans;
460: END IF;
461: ELSE -- delete was successful; recreate resv / pplot if requested
462:
463: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
464: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; actual_qty = '||x_actual_qty);
465: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; trans qty fromm mmt = '||l_mmt_rec.transaction_quantity);
466: END IF;
467: -- Pawan Kumar bug 5483071 added following if condition

Line 464: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; actual_qty = '||x_actual_qty);

460: END IF;
461: ELSE -- delete was successful; recreate resv / pplot if requested
462:
463: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
464: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; actual_qty = '||x_actual_qty);
465: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; trans qty fromm mmt = '||l_mmt_rec.transaction_quantity);
466: END IF;
467: -- Pawan Kumar bug 5483071 added following if condition
468: IF (p_material_detail_rec.line_type = -1 ) THEN

Line 465: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; trans qty fromm mmt = '||l_mmt_rec.transaction_quantity);

461: ELSE -- delete was successful; recreate resv / pplot if requested
462:
463: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
464: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; actual_qty = '||x_actual_qty);
465: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || ' delete loop; trans qty fromm mmt = '||l_mmt_rec.transaction_quantity);
466: END IF;
467: -- Pawan Kumar bug 5483071 added following if condition
468: IF (p_material_detail_rec.line_type = -1 ) THEN
469: x_actual_qty := x_actual_qty + (l_mmt_rec.transaction_quantity);

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

470: ELSE
471: x_actual_qty := x_actual_qty - (l_mmt_rec.transaction_quantity) ;
472: END IF;
473:
474: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
475: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || 'after trxn delete loop; actual_qty = '||x_actual_qty);
476: END IF;
477:
478: IF p_create_resv_pend_lots = 1 THEN

Line 475: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || 'after trxn delete loop; actual_qty = '||x_actual_qty);

471: x_actual_qty := x_actual_qty - (l_mmt_rec.transaction_quantity) ;
472: END IF;
473:
474: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
475: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name || 'after trxn delete loop; actual_qty = '||x_actual_qty);
476: END IF;
477:
478: IF p_create_resv_pend_lots = 1 THEN
479: -- nsinghi bug#5176319. Do not already create reservation. Reservation will be created in gme_post_process after onhand is increased due to wip return.

Line 489: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

485: gme_common_pvt.g_mat_txn_hdr_tbl(l_txn_hdr_tbl_cnt).material_dtl_id := p_material_detail_rec.material_detail_id;
486:
487: -- gme_common_pvt.g_txn_hdr_tbl_cnt := gme_common_pvt.g_txn_hdr_tbl_cnt + 1;
488:
489: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
490: gme_debug.put_line ( g_pkg_name
491: || '.'
492: || l_api_name
493: || ':'

Line 490: gme_debug.put_line ( g_pkg_name

486:
487: -- gme_common_pvt.g_txn_hdr_tbl_cnt := gme_common_pvt.g_txn_hdr_tbl_cnt + 1;
488:
489: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
490: gme_debug.put_line ( g_pkg_name
491: || '.'
492: || l_api_name
493: || ':'
494: ||'gme_common_pvt.g_mat_txn_hdr_tbl('

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

520: ,x_exception_material_tbl => x_exception_material_tbl
521: ,x_return_status => x_return_status);
522: END IF;
523:
524: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
525: gme_debug.g_log_procedure THEN
526: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status = '||x_return_status||' and x_actual_qty='||x_actual_qty);
527: END IF;
528: EXCEPTION

Line 525: gme_debug.g_log_procedure THEN

521: ,x_return_status => x_return_status);
522: END IF;
523:
524: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
525: gme_debug.g_log_procedure THEN
526: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status = '||x_return_status||' and x_actual_qty='||x_actual_qty);
527: END IF;
528: EXCEPTION
529: WHEN fnd_api.g_exc_error THEN

Line 526: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status = '||x_return_status||' and x_actual_qty='||x_actual_qty);

522: END IF;
523:
524: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
525: gme_debug.g_log_procedure THEN
526: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status = '||x_return_status||' and x_actual_qty='||x_actual_qty);
527: END IF;
528: EXCEPTION
529: WHEN fnd_api.g_exc_error THEN
530: x_return_status := fnd_api.g_ret_sts_error;

Line 536: IF g_debug <= gme_debug.g_log_procedure THEN

532: NULL;
533: WHEN OTHERS THEN
534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
535:
536: IF g_debug <= gme_debug.g_log_procedure THEN
537: gme_debug.put_line ( 'Unexpected error: '
538: || g_pkg_name
539: || '.'
540: || l_api_name

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

533: WHEN OTHERS THEN
534: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
535:
536: IF g_debug <= gme_debug.g_log_procedure THEN
537: gme_debug.put_line ( 'Unexpected error: '
538: || g_pkg_name
539: || '.'
540: || l_api_name
541: || ': '

Line 572: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN

568: SELECT *
569: FROM mtl_material_transactions mmt
570: WHERE transaction_id = v_transaction_id;
571: BEGIN
572: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
573: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
574: END IF;
575:
576: x_return_status := fnd_api.g_ret_sts_success;

Line 573: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');

569: FROM mtl_material_transactions mmt
570: WHERE transaction_id = v_transaction_id;
571: BEGIN
572: IF (NVL (g_debug, 0) IN (gme_debug.g_log_statement, gme_debug.g_log_procedure) ) THEN
573: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':' || 'Entering');
574: END IF;
575:
576: x_return_status := fnd_api.g_ret_sts_success;
577:

Line 578: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

574: END IF;
575:
576: x_return_status := fnd_api.g_ret_sts_success;
577:
578: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
579: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'p_material_dtl_id = '
580: ||p_material_dtl_id);
581: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl.COUNT = '
582: ||gme_common_pvt.g_mat_txn_hdr_tbl.COUNT);

Line 579: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'p_material_dtl_id = '

575:
576: x_return_status := fnd_api.g_ret_sts_success;
577:
578: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
579: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'p_material_dtl_id = '
580: ||p_material_dtl_id);
581: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl.COUNT = '
582: ||gme_common_pvt.g_mat_txn_hdr_tbl.COUNT);
583: END IF;

Line 581: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl.COUNT = '

577:
578: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
579: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'p_material_dtl_id = '
580: ||p_material_dtl_id);
581: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl.COUNT = '
582: ||gme_common_pvt.g_mat_txn_hdr_tbl.COUNT);
583: END IF;
584:
585: IF gme_common_pvt.g_mat_txn_hdr_tbl.COUNT > 0 THEN

Line 591: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

587: LOOP
588:
589: IF gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id = p_material_dtl_id THEN
590:
591: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
592: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').txn_header_id = '
593: ||gme_common_pvt.g_mat_txn_hdr_tbl(cnt).txn_header_id);
594: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').material_dtl_id = '
595: ||gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id);

Line 592: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').txn_header_id = '

588:
589: IF gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id = p_material_dtl_id THEN
590:
591: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
592: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').txn_header_id = '
593: ||gme_common_pvt.g_mat_txn_hdr_tbl(cnt).txn_header_id);
594: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').material_dtl_id = '
595: ||gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id);
596: END IF;

Line 594: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').material_dtl_id = '

590:
591: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
592: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').txn_header_id = '
593: ||gme_common_pvt.g_mat_txn_hdr_tbl(cnt).txn_header_id);
594: gme_debug.put_line ( g_pkg_name|| '.'|| l_api_name|| ':'||'gme_common_pvt.g_mat_txn_hdr_tbl('||cnt||').material_dtl_id = '
595: ||gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id);
596: END IF;
597:
598: l_mat_dtl_rec.material_detail_id := gme_common_pvt.g_mat_txn_hdr_tbl(cnt).material_dtl_id;

Line 621: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN

617: OPEN cur_get_transaction (l_new_transaction_id);
618: FETCH cur_get_transaction INTO l_new_mmt_rec;
619: CLOSE cur_get_transaction;
620:
621: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
622: gme_debug.put_line('Ing issue transaction id is ' || l_mmt_rec.transaction_id);
623: gme_debug.put_line('Ing Return transaction id is ' || l_new_mmt_rec.transaction_id);
624: gme_debug.put_line('source line id is' || l_new_mmt_rec.source_line_id);
625: END IF;

Line 622: gme_debug.put_line('Ing issue transaction id is ' || l_mmt_rec.transaction_id);

618: FETCH cur_get_transaction INTO l_new_mmt_rec;
619: CLOSE cur_get_transaction;
620:
621: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
622: gme_debug.put_line('Ing issue transaction id is ' || l_mmt_rec.transaction_id);
623: gme_debug.put_line('Ing Return transaction id is ' || l_new_mmt_rec.transaction_id);
624: gme_debug.put_line('source line id is' || l_new_mmt_rec.source_line_id);
625: END IF;
626: -- Bug 6997483

Line 623: gme_debug.put_line('Ing Return transaction id is ' || l_new_mmt_rec.transaction_id);

619: CLOSE cur_get_transaction;
620:
621: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
622: gme_debug.put_line('Ing issue transaction id is ' || l_mmt_rec.transaction_id);
623: gme_debug.put_line('Ing Return transaction id is ' || l_new_mmt_rec.transaction_id);
624: gme_debug.put_line('source line id is' || l_new_mmt_rec.source_line_id);
625: END IF;
626: -- Bug 6997483
627: -- Call create_resv_pplot only of the source_line_id of the ing return/reversal transaction

Line 624: gme_debug.put_line('source line id is' || l_new_mmt_rec.source_line_id);

620:
621: IF (NVL (g_debug, 0) = gme_debug.g_log_statement) THEN
622: gme_debug.put_line('Ing issue transaction id is ' || l_mmt_rec.transaction_id);
623: gme_debug.put_line('Ing Return transaction id is ' || l_new_mmt_rec.transaction_id);
624: gme_debug.put_line('source line id is' || l_new_mmt_rec.source_line_id);
625: END IF;
626: -- Bug 6997483
627: -- Call create_resv_pplot only of the source_line_id of the ing return/reversal transaction
628: -- matches the transaction_id of the original ing issue transaction.

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

658: l_out_pplot_rec gme_pending_product_lots%ROWTYPE;
659: l_return_status VARCHAR2(1);
660:
661: BEGIN
662: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
663: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
664: END IF;
665:
666: -- Set the return status to success initially

Line 663: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);

659: l_return_status VARCHAR2(1);
660:
661: BEGIN
662: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
663: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
664: END IF;
665:
666: -- Set the return status to success initially
667: x_return_status := fnd_api.g_ret_sts_success;

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

725:
726: l_sequence := gme_pending_product_lots_pvt.get_last_sequence
727: (p_matl_dtl_id => l_pplot_rec.material_detail_id
728: ,x_return_status => l_return_status);
729: IF NVL (g_debug, -1) <= gme_debug.g_log_statement THEN
730: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from lot_qty '|| l_mmln_tbl (j).transaction_quantity);
731: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from get_sequence '||l_return_status);
732: END IF;
733: l_sequence := l_sequence + gme_pending_product_lots_pvt.g_sequence_increment;

Line 730: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from lot_qty '|| l_mmln_tbl (j).transaction_quantity);

726: l_sequence := gme_pending_product_lots_pvt.get_last_sequence
727: (p_matl_dtl_id => l_pplot_rec.material_detail_id
728: ,x_return_status => l_return_status);
729: IF NVL (g_debug, -1) <= gme_debug.g_log_statement THEN
730: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from lot_qty '|| l_mmln_tbl (j).transaction_quantity);
731: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from get_sequence '||l_return_status);
732: END IF;
733: l_sequence := l_sequence + gme_pending_product_lots_pvt.g_sequence_increment;
734: l_pplot_rec.sequence := l_sequence;

Line 731: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from get_sequence '||l_return_status);

727: (p_matl_dtl_id => l_pplot_rec.material_detail_id
728: ,x_return_status => l_return_status);
729: IF NVL (g_debug, -1) <= gme_debug.g_log_statement THEN
730: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from lot_qty '|| l_mmln_tbl (j).transaction_quantity);
731: gme_debug.put_line (g_pkg_name || '.' || l_api_name||' return_status from get_sequence '||l_return_status);
732: END IF;
733: l_sequence := l_sequence + gme_pending_product_lots_pvt.g_sequence_increment;
734: l_pplot_rec.sequence := l_sequence;
735:

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

743: END IF;
744: END LOOP;
745: END IF; -- IF l_material_detail_rec.line_type = gme_common_pvt.g_line_type_ing
746:
747: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
748: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status='||x_return_status);
749: END IF;
750:
751: EXCEPTION

Line 748: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status='||x_return_status);

744: END LOOP;
745: END IF; -- IF l_material_detail_rec.line_type = gme_common_pvt.g_line_type_ing
746:
747: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
748: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name|| ' with return_status='||x_return_status);
749: END IF;
750:
751: EXCEPTION
752: WHEN OTHERS THEN

Line 755: IF g_debug <= gme_debug.g_log_procedure THEN

751: EXCEPTION
752: WHEN OTHERS THEN
753: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
754:
755: IF g_debug <= gme_debug.g_log_procedure THEN
756: gme_debug.put_line ( 'Unexpected error: '
757: || g_pkg_name
758: || '.'
759: || l_api_name

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

752: WHEN OTHERS THEN
753: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
754:
755: IF g_debug <= gme_debug.g_log_procedure THEN
756: gme_debug.put_line ( 'Unexpected error: '
757: || g_pkg_name
758: || '.'
759: || l_api_name
760: || ': '

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

783: error_step_status EXCEPTION;
784: error_phantom EXCEPTION;
785:
786: BEGIN
787: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
788: gme_debug.g_log_procedure THEN
789: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
790: || l_api_name);
791: END IF;

Line 788: gme_debug.g_log_procedure THEN

784: error_phantom EXCEPTION;
785:
786: BEGIN
787: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
788: gme_debug.g_log_procedure THEN
789: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
790: || l_api_name);
791: END IF;
792:

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

785:
786: BEGIN
787: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
788: gme_debug.g_log_procedure THEN
789: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
790: || l_api_name);
791: END IF;
792:
793: IF p_batch_hdr_rec.batch_type = gme_common_pvt.g_doc_type_fpo THEN

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

809: IF l_is_step_status_valid > 0 THEN
810: RAISE error_step_status;
811: END IF;
812:
813: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
814: gme_debug.g_log_procedure THEN
815: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
816: END IF;
817: EXCEPTION

Line 814: gme_debug.g_log_procedure THEN

810: RAISE error_step_status;
811: END IF;
812:
813: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
814: gme_debug.g_log_procedure THEN
815: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
816: END IF;
817: EXCEPTION
818: WHEN error_phantom THEN

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

811: END IF;
812:
813: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
814: gme_debug.g_log_procedure THEN
815: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
816: END IF;
817: EXCEPTION
818: WHEN error_phantom THEN
819: gme_common_pvt.log_message ('PM_INVALID_PHANTOM_ACTION');

Line 830: IF g_debug <= gme_debug.g_log_procedure THEN

826: x_return_status := fnd_api.g_ret_sts_error;
827: WHEN OTHERS THEN
828: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
829:
830: IF g_debug <= gme_debug.g_log_procedure THEN
831: gme_debug.put_line ( 'Unexpected error: '
832: || g_pkg_name
833: || '.'
834: || l_api_name

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

827: WHEN OTHERS THEN
828: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
829:
830: IF g_debug <= gme_debug.g_log_procedure THEN
831: gme_debug.put_line ( 'Unexpected error: '
832: || g_pkg_name
833: || '.'
834: || l_api_name
835: || ': '

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

860: l_sqs NUMBER;
861: l_satt NUMBER;
862: l_satr NUMBER;
863: BEGIN
864: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
865: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
866: END IF;
867: IF (p_mmln_tbl.COUNT > 0) THEN
868: FOR i IN 1..p_mmln_tbl.COUNT LOOP

Line 865: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);

861: l_satt NUMBER;
862: l_satr NUMBER;
863: BEGIN
864: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
865: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'|| l_api_name);
866: END IF;
867: IF (p_mmln_tbl.COUNT > 0) THEN
868: FOR i IN 1..p_mmln_tbl.COUNT LOOP
869: gme_transactions_pvt.query_quantities(x_return_status => l_return_status,

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

888: x_sqr => l_sqr,
889: x_sqs => l_sqs,
890: x_satt => l_satt,
891: x_satr => l_satr);
892: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
893: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));
894: gme_debug.put_line('NVL(ABS(p_mmln_tbl(i).primary_quantity),0) = '||NVL(ABS(p_mmln_tbl(i).primary_quantity),0));
895: END IF;
896: IF (NVL(l_att,0) < NVL(ABS(p_mmln_tbl(i).primary_quantity),0)) THEN

Line 893: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));

889: x_sqs => l_sqs,
890: x_satt => l_satt,
891: x_satr => l_satr);
892: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
893: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));
894: gme_debug.put_line('NVL(ABS(p_mmln_tbl(i).primary_quantity),0) = '||NVL(ABS(p_mmln_tbl(i).primary_quantity),0));
895: END IF;
896: IF (NVL(l_att,0) < NVL(ABS(p_mmln_tbl(i).primary_quantity),0)) THEN
897: IF (p_org_neg_control = 2) THEN --org does not allow negative inventory

Line 894: gme_debug.put_line('NVL(ABS(p_mmln_tbl(i).primary_quantity),0) = '||NVL(ABS(p_mmln_tbl(i).primary_quantity),0));

890: x_satt => l_satt,
891: x_satr => l_satr);
892: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
893: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));
894: gme_debug.put_line('NVL(ABS(p_mmln_tbl(i).primary_quantity),0) = '||NVL(ABS(p_mmln_tbl(i).primary_quantity),0));
895: END IF;
896: IF (NVL(l_att,0) < NVL(ABS(p_mmln_tbl(i).primary_quantity),0)) THEN
897: IF (p_org_neg_control = 2) THEN --org does not allow negative inventory
898: gme_common_pvt.log_message

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

900: ,p_product_code => 'GME'
901: ,p_token1_name => 'ITEM_NO'
902: ,p_token1_value => p_item_no
903: );
904: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
905: gme_debug.put_line('error. onhand will be driven negative for lot '||p_mmln_tbl(i).lot_number||' which the org does not allow');
906: END IF;
907: RETURN TRUE;
908: ELSIF (p_org_neg_control = 1) --org allows negative inventory

Line 905: gme_debug.put_line('error. onhand will be driven negative for lot '||p_mmln_tbl(i).lot_number||' which the org does not allow');

901: ,p_token1_name => 'ITEM_NO'
902: ,p_token1_value => p_item_no
903: );
904: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
905: gme_debug.put_line('error. onhand will be driven negative for lot '||p_mmln_tbl(i).lot_number||' which the org does not allow');
906: END IF;
907: RETURN TRUE;
908: ELSIF (p_org_neg_control = 1) --org allows negative inventory
909: AND (l_qr > 0) THEN

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

912: ,p_product_code => 'GME'
913: ,p_token1_name => 'ITEM_NO'
914: ,p_token1_value => p_item_no
915: );
916: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
917: gme_debug.put_line('error. onhand will be driven negative for lot '||p_mmln_tbl(i).lot_number||' which org allows but there are reservations');
918: END IF;
919: RETURN TRUE;
920: END IF;

Line 917: gme_debug.put_line('error. onhand will be driven negative for lot '||p_mmln_tbl(i).lot_number||' which org allows but there are reservations');

913: ,p_token1_name => 'ITEM_NO'
914: ,p_token1_value => p_item_no
915: );
916: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
917: gme_debug.put_line('error. onhand will be driven negative for lot '||p_mmln_tbl(i).lot_number||' which org allows but there are reservations');
918: END IF;
919: RETURN TRUE;
920: END IF;
921: END IF;

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

943: x_sqr => l_sqr,
944: x_sqs => l_sqs,
945: x_satt => l_satt,
946: x_satr => l_satr);
947: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
948: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));
949: gme_debug.put_line('NVL(ABS(p_mmt_rec.primary_quantity),0) = '||NVL(ABS(p_mmt_rec.primary_quantity),0));
950: END IF;
951: IF (NVL(l_att,0) < NVL(ABS(p_mmt_rec.primary_quantity),0)) THEN

Line 948: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));

944: x_sqs => l_sqs,
945: x_satt => l_satt,
946: x_satr => l_satr);
947: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
948: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));
949: gme_debug.put_line('NVL(ABS(p_mmt_rec.primary_quantity),0) = '||NVL(ABS(p_mmt_rec.primary_quantity),0));
950: END IF;
951: IF (NVL(l_att,0) < NVL(ABS(p_mmt_rec.primary_quantity),0)) THEN
952: IF (p_org_neg_control = 2) THEN --org does not allow negative inventory

Line 949: gme_debug.put_line('NVL(ABS(p_mmt_rec.primary_quantity),0) = '||NVL(ABS(p_mmt_rec.primary_quantity),0));

945: x_satt => l_satt,
946: x_satr => l_satr);
947: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
948: gme_debug.put_line('NVL(l_att,0) = '||NVL(l_att,0));
949: gme_debug.put_line('NVL(ABS(p_mmt_rec.primary_quantity),0) = '||NVL(ABS(p_mmt_rec.primary_quantity),0));
950: END IF;
951: IF (NVL(l_att,0) < NVL(ABS(p_mmt_rec.primary_quantity),0)) THEN
952: IF (p_org_neg_control = 2) THEN --org does not allow negative inventory
953: gme_common_pvt.log_message

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

955: ,p_product_code => 'GME'
956: ,p_token1_name => 'ITEM_NO'
957: ,p_token1_value => p_item_no
958: );
959: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
960: gme_debug.put_line('error. onhand will be driven negative which the org does not allow');
961: END IF;
962: RETURN TRUE;
963: ELSIF (p_org_neg_control = 1) --org allows negative inventory

Line 960: gme_debug.put_line('error. onhand will be driven negative which the org does not allow');

956: ,p_token1_name => 'ITEM_NO'
957: ,p_token1_value => p_item_no
958: );
959: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
960: gme_debug.put_line('error. onhand will be driven negative which the org does not allow');
961: END IF;
962: RETURN TRUE;
963: ELSIF (p_org_neg_control = 1) --org allows negative inventory
964: AND (l_qr > 0) THEN

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

967: ,p_product_code => 'GME'
968: ,p_token1_name => 'ITEM_NO'
969: ,p_token1_value => p_item_no
970: );
971: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
972: gme_debug.put_line('error. onhand will be driven negative which org allows but there are reservations');
973: END IF;
974: RETURN TRUE;
975: END IF;

Line 972: gme_debug.put_line('error. onhand will be driven negative which org allows but there are reservations');

968: ,p_token1_name => 'ITEM_NO'
969: ,p_token1_value => p_item_no
970: );
971: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
972: gme_debug.put_line('error. onhand will be driven negative which org allows but there are reservations');
973: END IF;
974: RETURN TRUE;
975: END IF;
976: END IF;

Line 982: IF g_debug <= gme_debug.g_log_procedure THEN

978: RETURN FALSE;
979: EXCEPTION
980: WHEN OTHERS THEN
981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
982: IF g_debug <= gme_debug.g_log_procedure THEN
983: gme_debug.put_line('Unexpected error: '|| g_pkg_name|| '.'|| l_api_name|| ': '|| SQLERRM);
984: END IF;
985: RETURN FALSE;
986: END check_inv_negative;

Line 983: gme_debug.put_line('Unexpected error: '|| g_pkg_name|| '.'|| l_api_name|| ': '|| SQLERRM);

979: EXCEPTION
980: WHEN OTHERS THEN
981: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
982: IF g_debug <= gme_debug.g_log_procedure THEN
983: gme_debug.put_line('Unexpected error: '|| g_pkg_name|| '.'|| l_api_name|| ': '|| SQLERRM);
984: END IF;
985: RETURN FALSE;
986: END check_inv_negative;
987: