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_RELEASE_BATCH_PVT dependencies on GME_DEBUG

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

55: l_message_list VARCHAR2(2000);
56: l_tmp VARCHAR2(2000);
57:
58: BEGIN
59: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
60: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
61: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_header_rec.batch_id);
62: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_phantom_product_id='||p_phantom_product_id);
63: IF p_yield IS NOT NULL AND p_yield THEN

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

56: l_tmp VARCHAR2(2000);
57:
58: BEGIN
59: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
60: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
61: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_header_rec.batch_id);
62: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_phantom_product_id='||p_phantom_product_id);
63: IF p_yield IS NOT NULL AND p_yield THEN
64: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=TRUE');

Line 61: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_header_rec.batch_id);

57:
58: BEGIN
59: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
60: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
61: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_header_rec.batch_id);
62: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_phantom_product_id='||p_phantom_product_id);
63: IF p_yield IS NOT NULL AND p_yield THEN
64: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=TRUE');
65: ELSIF p_yield IS NOT NULL THEN

Line 62: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_phantom_product_id='||p_phantom_product_id);

58: BEGIN
59: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
60: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
61: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_header_rec.batch_id);
62: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_phantom_product_id='||p_phantom_product_id);
63: IF p_yield IS NOT NULL AND p_yield THEN
64: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=TRUE');
65: ELSIF p_yield IS NOT NULL THEN
66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=FALSE');

Line 64: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=TRUE');

60: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
61: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_header_rec.batch_id);
62: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_phantom_product_id='||p_phantom_product_id);
63: IF p_yield IS NOT NULL AND p_yield THEN
64: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=TRUE');
65: ELSIF p_yield IS NOT NULL THEN
66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=FALSE');
67: ELSE
68: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield is NULL');

Line 66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=FALSE');

62: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_phantom_product_id='||p_phantom_product_id);
63: IF p_yield IS NOT NULL AND p_yield THEN
64: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=TRUE');
65: ELSIF p_yield IS NOT NULL THEN
66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=FALSE');
67: ELSE
68: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield is NULL');
69: END IF;
70: END IF;

Line 68: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield is NULL');

64: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=TRUE');
65: ELSIF p_yield IS NOT NULL THEN
66: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield=FALSE');
67: ELSE
68: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_yield is NULL');
69: END IF;
70: END IF;
71:
72: /* Set the return status to success initially */

Line 151: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

147:
148: -- Yield the phantom product for this batch... that will also take care of the phantom ingredient
149: IF p_phantom_product_id IS NOT NULL THEN
150: IF NVL(p_yield, TRUE) THEN
151: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' yielding phantom product');
153: END IF;
154: l_matl_dtl_rec.material_detail_id := p_phantom_product_id;
155: IF NOT gme_material_details_dbl.fetch_row(l_matl_dtl_rec, l_matl_dtl_rec) THEN

Line 152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' yielding phantom product');

148: -- Yield the phantom product for this batch... that will also take care of the phantom ingredient
149: IF p_phantom_product_id IS NOT NULL THEN
150: IF NVL(p_yield, TRUE) THEN
151: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' yielding phantom product');
153: END IF;
154: l_matl_dtl_rec.material_detail_id := p_phantom_product_id;
155: IF NOT gme_material_details_dbl.fetch_row(l_matl_dtl_rec, l_matl_dtl_rec) THEN
156: RAISE error_fetch_material;

Line 174: IF g_debug <= gme_debug.g_log_procedure THEN

170: END IF;
171:
172: IF p_batch_header_rec.update_inventory_ind = 'Y' AND
173: l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
174: IF g_debug <= gme_debug.g_log_procedure THEN
175: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' processing phantom product material_detail_id='||l_matl_dtl_rec.material_detail_id);
176: END IF;
177:
178: gme_complete_batch_pvt.yield_material

Line 175: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' processing phantom product material_detail_id='||l_matl_dtl_rec.material_detail_id);

171:
172: IF p_batch_header_rec.update_inventory_ind = 'Y' AND
173: l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
174: IF g_debug <= gme_debug.g_log_procedure THEN
175: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' processing phantom product material_detail_id='||l_matl_dtl_rec.material_detail_id);
176: END IF;
177:
178: gme_complete_batch_pvt.yield_material
179: (p_material_dtl_rec => l_matl_dtl_rec

Line 202: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

198: ELSE
199: l_matl_dtl_rec.actual_qty := l_matl_dtl_rec.plan_qty;
200: END IF;
201: ELSE
202: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
203: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' NOT yielding phantom product; set actual to 0');
204: END IF;
205: l_matl_dtl_rec.actual_qty := 0;
206: END IF;

Line 203: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' NOT yielding phantom product; set actual to 0');

199: l_matl_dtl_rec.actual_qty := l_matl_dtl_rec.plan_qty;
200: END IF;
201: ELSE
202: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
203: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' NOT yielding phantom product; set actual to 0');
204: END IF;
205: l_matl_dtl_rec.actual_qty := 0;
206: END IF;
207:

Line 240: IF g_debug <= gme_debug.g_log_procedure THEN

236: IF NOT gme_common_pvt.create_history
237: (p_batch_header_rec => x_batch_header_rec
238: ,p_original_status => gme_common_pvt.g_batch_pending
239: ,p_event_id => NVL(gme_common_pvt.g_transaction_header_id,-9999)) THEN
240: IF g_debug <= gme_debug.g_log_procedure THEN
241: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' create history returned error');
242: END IF;
243: END IF;
244:

Line 241: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' create history returned error');

237: (p_batch_header_rec => x_batch_header_rec
238: ,p_original_status => gme_common_pvt.g_batch_pending
239: ,p_event_id => NVL(gme_common_pvt.g_transaction_header_id,-9999)) THEN
240: IF g_debug <= gme_debug.g_log_procedure THEN
241: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' create history returned error');
242: END IF;
243: END IF;
244:
245:

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

260: RAISE gmf_cost_failure;
261: END IF;
262: -- End Bug 5903208
263:
264: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
265: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' for batch_id= '||x_batch_header_rec.batch_id||' and x_return_status= '||l_return_status);
266: END IF;
267:
268: EXCEPTION

Line 265: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' for batch_id= '||x_batch_header_rec.batch_id||' and x_return_status= '||l_return_status);

261: END IF;
262: -- End Bug 5903208
263:
264: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
265: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' for batch_id= '||x_batch_header_rec.batch_id||' and x_return_status= '||l_return_status);
266: END IF;
267:
268: EXCEPTION
269: WHEN gmf_cost_failure THEN

Line 284: IF g_debug <= gme_debug.g_log_procedure THEN

280: gme_common_pvt.log_message ('PM_UNEXPLODED_PHANTOMS');
281: x_return_status := FND_API.G_RET_STS_ERROR;
282: WHEN OTHERS THEN
283: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
284: IF g_debug <= gme_debug.g_log_procedure THEN
285: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
286: END IF;
287: x_return_status := FND_API.g_ret_sts_unexp_error;
288: END release_batch;

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

281: x_return_status := FND_API.G_RET_STS_ERROR;
282: WHEN OTHERS THEN
283: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
284: IF g_debug <= gme_debug.g_log_procedure THEN
285: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
286: END IF;
287: x_return_status := FND_API.g_ret_sts_unexp_error;
288: END release_batch;
289:

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

313: error_get_item EXCEPTION;
314: error_dispense_non_reserve EXCEPTION;
315: BEGIN
316:
317: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
318: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_detail_rec.material_detail_id);
320: END IF;
321:

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

314: error_dispense_non_reserve EXCEPTION;
315: BEGIN
316:
317: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
318: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_detail_rec.material_detail_id);
320: END IF;
321:
322: /* Set the return status to success initially */

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

315: BEGIN
316:
317: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
318: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_detail_rec.material_detail_id);
320: END IF;
321:
322: /* Set the return status to success initially */
323: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 344: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

340: IF NOT gme_batch_header_dbl.fetch_row(l_phantom_batch_rec, l_phantom_batch_rec) THEN
341: RAISE error_fetch_batch;
342: END IF;
343:
344: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
345: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' found phantom ingredient material_detail_id='||l_matl_dtl_rec.material_detail_id||' and phantom batch_id= '||l_phantom_batch_rec.batch_id);
346: END IF;
347: -- pass in the phantom line id so that release batch will know to yield that product
348: l_in_phantom_batch_rec := l_phantom_batch_rec;

Line 345: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' found phantom ingredient material_detail_id='||l_matl_dtl_rec.material_detail_id||' and phantom batch_id= '||l_phantom_batch_rec.batch_id);

341: RAISE error_fetch_batch;
342: END IF;
343:
344: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
345: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' found phantom ingredient material_detail_id='||l_matl_dtl_rec.material_detail_id||' and phantom batch_id= '||l_phantom_batch_rec.batch_id);
346: END IF;
347: -- pass in the phantom line id so that release batch will know to yield that product
348: l_in_phantom_batch_rec := l_phantom_batch_rec;
349: l_in_phantom_batch_rec.actual_start_date := p_trans_date;

Line 369: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

365: END IF;
366:
367: l_update_matl := FALSE;
368:
369: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
370: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after release_batch for phantom batch; it returned x_return_status='||x_return_status);
371: END IF;
372: ELSIF p_consume THEN
373: gme_material_detail_pvt.get_item_rec

Line 370: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after release_batch for phantom batch; it returned x_return_status='||x_return_status);

366:
367: l_update_matl := FALSE;
368:
369: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
370: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after release_batch for phantom batch; it returned x_return_status='||x_return_status);
371: END IF;
372: ELSIF p_consume THEN
373: gme_material_detail_pvt.get_item_rec
374: (p_org_id => l_matl_dtl_rec.organization_id

Line 388: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

384: IF p_update_inv_ind = 'Y' AND
385: l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
386: --Pawan Kumar bug 4742244 --
387: -- check for item which dispensable but non-reservable
388: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
389: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'disp ind'||l_matl_dtl_rec.dispense_ind);
390: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'reservable_type'||l_item_rec.reservable_type);
391: END IF;
392: IF nvl(l_matl_dtl_rec.dispense_ind, 'N' ) = 'Y' AND

Line 389: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'disp ind'||l_matl_dtl_rec.dispense_ind);

385: l_item_rec.mtl_transactions_enabled_flag = 'Y' THEN
386: --Pawan Kumar bug 4742244 --
387: -- check for item which dispensable but non-reservable
388: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
389: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'disp ind'||l_matl_dtl_rec.dispense_ind);
390: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'reservable_type'||l_item_rec.reservable_type);
391: END IF;
392: IF nvl(l_matl_dtl_rec.dispense_ind, 'N' ) = 'Y' AND
393: l_item_rec.reservable_type <> 1 THEN

Line 390: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'reservable_type'||l_item_rec.reservable_type);

386: --Pawan Kumar bug 4742244 --
387: -- check for item which dispensable but non-reservable
388: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
389: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'disp ind'||l_matl_dtl_rec.dispense_ind);
390: gme_debug.put_line(g_pkg_name||'.'||l_api_name||'reservable_type'||l_item_rec.reservable_type);
391: END IF;
392: IF nvl(l_matl_dtl_rec.dispense_ind, 'N' ) = 'Y' AND
393: l_item_rec.reservable_type <> 1 THEN
394: RAISE error_dispense_non_reserve;

Line 406: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

402: ,x_return_status => l_return_status);
403:
404: l_matl_dtl_rec.actual_qty := l_actual_qty;
405:
406: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
407: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after consume_material; it returned actual_qty='||l_actual_qty);
408: END IF;
409:
410: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN

Line 407: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after consume_material; it returned actual_qty='||l_actual_qty);

403:
404: l_matl_dtl_rec.actual_qty := l_actual_qty;
405:
406: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
407: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after consume_material; it returned actual_qty='||l_actual_qty);
408: END IF;
409:
410: IF l_return_status NOT IN (FND_API.G_RET_STS_SUCCESS, gme_common_pvt.g_exceptions_err) THEN
411: x_return_status := l_return_status;

Line 433: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

429: IF l_update_matl THEN
430: -- set WIP plan qty
431: l_matl_dtl_rec.wip_plan_qty := l_matl_dtl_rec.plan_qty;
432:
433: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
434: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; actual_qty='||l_matl_dtl_rec.actual_qty);
435: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; wip_plan_qty='||l_matl_dtl_rec.wip_plan_qty);
436: END IF;
437:

Line 434: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; actual_qty='||l_matl_dtl_rec.actual_qty);

430: -- set WIP plan qty
431: l_matl_dtl_rec.wip_plan_qty := l_matl_dtl_rec.plan_qty;
432:
433: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
434: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; actual_qty='||l_matl_dtl_rec.actual_qty);
435: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; wip_plan_qty='||l_matl_dtl_rec.wip_plan_qty);
436: END IF;
437:
438: IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN

Line 435: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; wip_plan_qty='||l_matl_dtl_rec.wip_plan_qty);

431: l_matl_dtl_rec.wip_plan_qty := l_matl_dtl_rec.plan_qty;
432:
433: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
434: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; actual_qty='||l_matl_dtl_rec.actual_qty);
435: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' before update_row; wip_plan_qty='||l_matl_dtl_rec.wip_plan_qty);
436: END IF;
437:
438: IF NOT gme_material_details_dbl.update_row (l_matl_dtl_rec) THEN
439: RAISE error_update_row;

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

439: RAISE error_update_row;
440: END IF;
441: END IF;
442:
443: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
444: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' with x_return_status= '||x_return_status);
445: END IF;
446:
447: EXCEPTION

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

440: END IF;
441: END IF;
442:
443: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
444: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' with x_return_status= '||x_return_status);
445: END IF;
446:
447: EXCEPTION
448: WHEN error_update_row OR error_fetch_batch THEN

Line 458: IF g_debug <= gme_debug.g_log_procedure THEN

454: gme_common_pvt.log_message ('GME_DISPENSE_NON_RESERVE');
455: x_return_status := fnd_api.g_ret_sts_error;
456: WHEN OTHERS THEN
457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
458: IF g_debug <= gme_debug.g_log_procedure THEN
459: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
460: END IF;
461: x_return_status := FND_API.g_ret_sts_unexp_error;
462: END process_ingredient;

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

455: x_return_status := fnd_api.g_ret_sts_error;
456: WHEN OTHERS THEN
457: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
458: IF g_debug <= gme_debug.g_log_procedure THEN
459: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
460: END IF;
461: x_return_status := FND_API.g_ret_sts_unexp_error;
462: END process_ingredient;
463:

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

527: no_consume_required EXCEPTION;
528:
529: BEGIN
530:
531: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
532: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);
535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);

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

528:
529: BEGIN
530:
531: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
532: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);
535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date

Line 533: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);

529: BEGIN
530:
531: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
532: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);
535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
537: ,'YYYY-MON-DD HH24:MI:SS'));

Line 534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);

530:
531: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
532: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);
535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
537: ,'YYYY-MON-DD HH24:MI:SS'));
538: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);

Line 535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);

531: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
532: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);
535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
537: ,'YYYY-MON-DD HH24:MI:SS'));
538: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
539: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);

Line 536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date

532: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
533: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);
535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
537: ,'YYYY-MON-DD HH24:MI:SS'));
538: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
539: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
540: END IF;

Line 538: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);

534: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispense_ind='||p_material_dtl_rec.dispense_ind);
535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
537: ,'YYYY-MON-DD HH24:MI:SS'));
538: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
539: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
540: END IF;
541: /* Set the return status to success initially */
542: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 539: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);

535: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
536: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
537: ,'YYYY-MON-DD HH24:MI:SS'));
538: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
539: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
540: END IF;
541: /* Set the return status to success initially */
542: x_return_status := FND_API.G_RET_STS_SUCCESS;
543:

Line 562: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

558:
559: IF gme_common_pvt.g_auto_consume_supply_sub_only = 1 THEN
560: IF p_material_dtl_rec.subinventory IS NULL THEN
561: l_pending_mo_ind := FALSE; -- can't have move order if sub is NULL
562: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
563: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' auto consume from supply sub is ON and subinv on material is NULL; cant consume anything; get exceptions');
564: END IF;
565:
566: RAISE error_get_exception;

Line 563: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' auto consume from supply sub is ON and subinv on material is NULL; cant consume anything; get exceptions');

559: IF gme_common_pvt.g_auto_consume_supply_sub_only = 1 THEN
560: IF p_material_dtl_rec.subinventory IS NULL THEN
561: l_pending_mo_ind := FALSE; -- can't have move order if sub is NULL
562: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
563: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' auto consume from supply sub is ON and subinv on material is NULL; cant consume anything; get exceptions');
564: END IF;
565:
566: RAISE error_get_exception;
567: END IF;

Line 573: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

569:
570: l_subinv := p_material_dtl_rec.subinventory;
571: l_locator_id := p_material_dtl_rec.locator_id;
572:
573: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
574: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_subinv='||l_subinv);
575: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_locator_id='||l_locator_id);
576: END IF;
577:

Line 574: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_subinv='||l_subinv);

570: l_subinv := p_material_dtl_rec.subinventory;
571: l_locator_id := p_material_dtl_rec.locator_id;
572:
573: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
574: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_subinv='||l_subinv);
575: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_locator_id='||l_locator_id);
576: END IF;
577:
578: -- channges for GMO

Line 575: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_locator_id='||l_locator_id);

571: l_locator_id := p_material_dtl_rec.locator_id;
572:
573: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
574: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_subinv='||l_subinv);
575: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_locator_id='||l_locator_id);
576: END IF;
577:
578: -- channges for GMO
579: gme_reservations_pvt.get_material_reservations

Line 595: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

591:
592: l_consume_qty := NVL(p_consume_qty, p_material_dtl_rec.plan_qty);
593: l_trans_date := NVL(p_trans_date, gme_common_pvt.g_timestamp);
594:
595: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
596: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
597: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_trans_date='||to_char(p_trans_date
598: ,'YYYY-MON-DD HH24:MI:SS'));
599: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);

Line 596: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);

592: l_consume_qty := NVL(p_consume_qty, p_material_dtl_rec.plan_qty);
593: l_trans_date := NVL(p_trans_date, gme_common_pvt.g_timestamp);
594:
595: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
596: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
597: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_trans_date='||to_char(p_trans_date
598: ,'YYYY-MON-DD HH24:MI:SS'));
599: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
600: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' number of reservations='||l_reservation_tab.COUNT);

Line 597: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_trans_date='||to_char(p_trans_date

593: l_trans_date := NVL(p_trans_date, gme_common_pvt.g_timestamp);
594:
595: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
596: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
597: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_trans_date='||to_char(p_trans_date
598: ,'YYYY-MON-DD HH24:MI:SS'));
599: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
600: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' number of reservations='||l_reservation_tab.COUNT);
601: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' auto consume from supply sub='||gme_common_pvt.g_auto_consume_supply_sub_only);

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

595: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
596: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
597: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_trans_date='||to_char(p_trans_date
598: ,'YYYY-MON-DD HH24:MI:SS'));
599: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
600: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' number of reservations='||l_reservation_tab.COUNT);
601: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' auto consume from supply sub='||gme_common_pvt.g_auto_consume_supply_sub_only);
602: END IF;
603:

Line 600: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' number of reservations='||l_reservation_tab.COUNT);

596: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
597: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_trans_date='||to_char(p_trans_date
598: ,'YYYY-MON-DD HH24:MI:SS'));
599: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
600: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' number of reservations='||l_reservation_tab.COUNT);
601: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' auto consume from supply sub='||gme_common_pvt.g_auto_consume_supply_sub_only);
602: END IF;
603:
604: i := 1;

Line 601: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' auto consume from supply sub='||gme_common_pvt.g_auto_consume_supply_sub_only);

597: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_trans_date='||to_char(p_trans_date
598: ,'YYYY-MON-DD HH24:MI:SS'));
599: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
600: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' number of reservations='||l_reservation_tab.COUNT);
601: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' auto consume from supply sub='||gme_common_pvt.g_auto_consume_supply_sub_only);
602: END IF;
603:
604: i := 1;
605: j := 1;

Line 610: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

606:
607: WHILE l_consume_qty > x_actual_qty AND i <= l_reservation_tab.COUNT LOOP
608: -- Consume all fully specified reservations and mark the Partial ones
609: l_reservation_rec := l_reservation_tab(i);
610: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
611: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation_id='||l_reservation_rec.reservation_id);
612: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation subinventory='||l_reservation_rec.subinventory_code);
613: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation external_source_line_id='||l_reservation_rec.external_source_line_id);
614: END IF;

Line 611: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation_id='||l_reservation_rec.reservation_id);

607: WHILE l_consume_qty > x_actual_qty AND i <= l_reservation_tab.COUNT LOOP
608: -- Consume all fully specified reservations and mark the Partial ones
609: l_reservation_rec := l_reservation_tab(i);
610: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
611: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation_id='||l_reservation_rec.reservation_id);
612: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation subinventory='||l_reservation_rec.subinventory_code);
613: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation external_source_line_id='||l_reservation_rec.external_source_line_id);
614: END IF;
615: /* Bug 5441643 Added NVL condition for location control code*/

Line 612: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation subinventory='||l_reservation_rec.subinventory_code);

608: -- Consume all fully specified reservations and mark the Partial ones
609: l_reservation_rec := l_reservation_tab(i);
610: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
611: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation_id='||l_reservation_rec.reservation_id);
612: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation subinventory='||l_reservation_rec.subinventory_code);
613: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation external_source_line_id='||l_reservation_rec.external_source_line_id);
614: END IF;
615: /* Bug 5441643 Added NVL condition for location control code*/
616: l_rsrv_type := gme_reservations_pvt.reservation_fully_specified

Line 613: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation external_source_line_id='||l_reservation_rec.external_source_line_id);

609: l_reservation_rec := l_reservation_tab(i);
610: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
611: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation_id='||l_reservation_rec.reservation_id);
612: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation subinventory='||l_reservation_rec.subinventory_code);
613: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' in reservation loop: reservation external_source_line_id='||l_reservation_rec.external_source_line_id);
614: END IF;
615: /* Bug 5441643 Added NVL condition for location control code*/
616: l_rsrv_type := gme_reservations_pvt.reservation_fully_specified
617: (p_reservation_rec => l_reservation_rec

Line 620: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

616: l_rsrv_type := gme_reservations_pvt.reservation_fully_specified
617: (p_reservation_rec => l_reservation_rec
618: ,p_item_location_control => NVL(p_item_rec.location_control_code,1)
619: ,p_item_restrict_locators => p_item_rec.restrict_locators_code);
620: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
621: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after call to gme_reservations_pvt.reservation_fully_specified: l_rsrv_type='||l_rsrv_type);
622: END IF;
623: IF l_rsrv_type = -1 THEN
624: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 621: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after call to gme_reservations_pvt.reservation_fully_specified: l_rsrv_type='||l_rsrv_type);

617: (p_reservation_rec => l_reservation_rec
618: ,p_item_location_control => NVL(p_item_rec.location_control_code,1)
619: ,p_item_restrict_locators => p_item_rec.restrict_locators_code);
620: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
621: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after call to gme_reservations_pvt.reservation_fully_specified: l_rsrv_type='||l_rsrv_type);
622: END IF;
623: IF l_rsrv_type = -1 THEN
624: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
625: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');

Line 624: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

620: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
621: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after call to gme_reservations_pvt.reservation_fully_specified: l_rsrv_type='||l_rsrv_type);
622: END IF;
623: IF l_rsrv_type = -1 THEN
624: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
625: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');
626: RAISE error_unexpected;
627: ENd IF;
628: END IF;

Line 625: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');

621: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' after call to gme_reservations_pvt.reservation_fully_specified: l_rsrv_type='||l_rsrv_type);
622: END IF;
623: IF l_rsrv_type = -1 THEN
624: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
625: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_rsrv_type passed back as -1 from gme_reservations_pvt.reservation_fully_specified');
626: RAISE error_unexpected;
627: ENd IF;
628: END IF;
629:

Line 665: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

661: i := i + 1; -- move on to the next reservation
662: END LOOP;
663:
664: IF x_actual_qty >= l_consume_qty THEN
665: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
666: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' consumption complete: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);
667: END IF;
668: -- done!
669: RAISE consume_done;

Line 666: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' consumption complete: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);

662: END LOOP;
663:
664: IF x_actual_qty >= l_consume_qty THEN
665: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
666: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' consumption complete: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);
667: END IF;
668: -- done!
669: RAISE consume_done;
670: END IF;

Line 673: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

669: RAISE consume_done;
670: END IF;
671:
672: IF (gme_common_pvt.g_auto_consume_supply_sub_only = 0 AND l_subinv IS NULL) THEN
673: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' exception; qty not met; consume from supply sub is FALSE and material subinv is NULL');
675: END IF;
676: RAISE error_get_exception;
677: END IF;

Line 674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' exception; qty not met; consume from supply sub is FALSE and material subinv is NULL');

670: END IF;
671:
672: IF (gme_common_pvt.g_auto_consume_supply_sub_only = 0 AND l_subinv IS NULL) THEN
673: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
674: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' exception; qty not met; consume from supply sub is FALSE and material subinv is NULL');
675: END IF;
676: RAISE error_get_exception;
677: END IF;
678:

Line 683: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

679: -- Changes for GMO
680: IF NVL(p_material_dtl_rec.dispense_ind, 'N') = 'Y' THEN
681: -- if you get to this point, raise exception; can't process PLR/HLR for dispensed records; nor
682: -- can you get available inventory; record must be dispensed to process it
683: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
684: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispensed item; get exceptions: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);
685: END IF;
686: RAISE error_get_exception;
687: END IF;

Line 684: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispensed item; get exceptions: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);

680: IF NVL(p_material_dtl_rec.dispense_ind, 'N') = 'Y' THEN
681: -- if you get to this point, raise exception; can't process PLR/HLR for dispensed records; nor
682: -- can you get available inventory; record must be dispensed to process it
683: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
684: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' dispensed item; get exceptions: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);
685: END IF;
686: RAISE error_get_exception;
687: END IF;
688:

Line 698: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

694: IF p_item_rec.lot_control_code = 2 THEN -- lot control
695: IF gme_common_pvt.g_auto_consume_supply_sub_only = 1 THEN -- auto consume -> Yes
696: IF l_pending_mo_ind THEN
697: l_try_PLR := FALSE;
698: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
699: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' consume from supply sub ON; pending MO TRUE: l_try_PLR := FALSE; get batch exception');
700: END IF;
701: ELSE
702: l_try_PLR := TRUE;

Line 699: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' consume from supply sub ON; pending MO TRUE: l_try_PLR := FALSE; get batch exception');

695: IF gme_common_pvt.g_auto_consume_supply_sub_only = 1 THEN -- auto consume -> Yes
696: IF l_pending_mo_ind THEN
697: l_try_PLR := FALSE;
698: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
699: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' consume from supply sub ON; pending MO TRUE: l_try_PLR := FALSE; get batch exception');
700: END IF;
701: ELSE
702: l_try_PLR := TRUE;
703: END IF;

Line 709: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

705: l_try_PLR := TRUE;
706: END IF;
707:
708: IF NOT l_try_PLR THEN
709: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
710: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot control item; get exceptions: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);
711: END IF;
712: RAISE error_get_exception;
713: END IF;

Line 710: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot control item; get exceptions: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);

706: END IF;
707:
708: IF NOT l_try_PLR THEN
709: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
710: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' lot control item; get exceptions: x_actual_qty='||x_actual_qty||' and l_consume_qty='||l_consume_qty);
711: END IF;
712: RAISE error_get_exception;
713: END IF;
714: END IF;

Line 729: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

725: ,p_item_rec => p_item_rec
726: ,x_reservation_rec => l_reservation_rec
727: ,x_return_status => l_return_status);
728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
729: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' could not convert partial to dlr for reservation id='||l_partial_rec.reservation_id||'; moving to next partial');
731: END IF;
732: ELSE
733: build_and_create_transaction

Line 730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' could not convert partial to dlr for reservation id='||l_partial_rec.reservation_id||'; moving to next partial');

726: ,x_reservation_rec => l_reservation_rec
727: ,x_return_status => l_return_status);
728: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
729: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
730: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' could not convert partial to dlr for reservation id='||l_partial_rec.reservation_id||'; moving to next partial');
731: END IF;
732: ELSE
733: build_and_create_transaction
734: (p_rsrv_rec => l_reservation_rec

Line 754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

750: END LOOP;
751:
752: -- If it's lot control and the qty is still not satisfied, get exceptions;
753: IF p_item_rec.lot_control_code = 2 THEN -- lot control
754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
755: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' lot control; DLR and PLR have been exhausted; get exception');
756: END IF;
757: RAISE error_get_exception;
758: END IF;

Line 755: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' lot control; DLR and PLR have been exhausted; get exception');

751:
752: -- If it's lot control and the qty is still not satisfied, get exceptions;
753: IF p_item_rec.lot_control_code = 2 THEN -- lot control
754: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
755: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' lot control; DLR and PLR have been exhausted; get exception');
756: END IF;
757: RAISE error_get_exception;
758: END IF;
759:

Line 774: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

770: CLOSE cur_get_item_revision;
771: END IF;
772: END IF; -- IF p_revision_qty_control_code = 2
773:
774: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_revision='||l_revision);
776: END IF;
777:
778: IF l_locator_id IS NULL THEN

Line 775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_revision='||l_revision);

771: END IF;
772: END IF; -- IF p_revision_qty_control_code = 2
773:
774: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
775: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_revision='||l_revision);
776: END IF;
777:
778: IF l_locator_id IS NULL THEN
779: -- check if it's locator control, we need a locator...

Line 789: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

785: ,p_subinventory => p_material_dtl_rec.subinventory
786: ,p_item_control => NVL(p_item_rec.location_control_code,1)
787: ,p_item_loc_restrict => p_item_rec.restrict_locators_code
788: ,p_action => gme_common_pvt.g_ing_issue_txn_action);
789: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
790: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_eff_locator_control='||l_eff_locator_control);
791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);
792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);

Line 790: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_eff_locator_control='||l_eff_locator_control);

786: ,p_item_control => NVL(p_item_rec.location_control_code,1)
787: ,p_item_loc_restrict => p_item_rec.restrict_locators_code
788: ,p_action => gme_common_pvt.g_ing_issue_txn_action);
789: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
790: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_eff_locator_control='||l_eff_locator_control);
791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);
792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);

Line 791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);

787: ,p_item_loc_restrict => p_item_rec.restrict_locators_code
788: ,p_action => gme_common_pvt.g_ing_issue_txn_action);
789: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
790: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_eff_locator_control='||l_eff_locator_control);
791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);
792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);
795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);

Line 792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);

788: ,p_action => gme_common_pvt.g_ing_issue_txn_action);
789: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
790: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_eff_locator_control='||l_eff_locator_control);
791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);
792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);
795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);
796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);

Line 793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);

789: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
790: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_eff_locator_control='||l_eff_locator_control);
791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);
792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);
795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);
796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);
797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);

Line 794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);

790: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' l_eff_locator_control='||l_eff_locator_control);
791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);
792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);
795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);
796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);
797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);
798: END IF;

Line 795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);

791: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' organization_id='||p_material_dtl_rec.organization_id);
792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);
795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);
796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);
797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);
798: END IF;
799: IF l_eff_locator_control <> 1 THEN

Line 796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);

792: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' g_org_locator_control='||gme_common_pvt.g_org_locator_control);
793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);
795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);
796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);
797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);
798: END IF;
799: IF l_eff_locator_control <> 1 THEN
800: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);

793: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' subinventory='||p_material_dtl_rec.subinventory);
794: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' inventory_item_id='||p_item_rec.inventory_item_id);
795: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' location_control_code='||p_item_rec.location_control_code);
796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);
797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);
798: END IF;
799: IF l_eff_locator_control <> 1 THEN
800: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
801: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' locator on material is NULL and material is eff locator control; cant get quantities from inventory; get exceptions');

Line 800: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

796: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' restrict_locators_code='||p_item_rec.restrict_locators_code);
797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);
798: END IF;
799: IF l_eff_locator_control <> 1 THEN
800: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
801: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' locator on material is NULL and material is eff locator control; cant get quantities from inventory; get exceptions');
802: END IF;
803: RAISE error_get_exception;
804: END IF;

Line 801: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' locator on material is NULL and material is eff locator control; cant get quantities from inventory; get exceptions');

797: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_action='||gme_common_pvt.g_ing_issue_txn_action);
798: END IF;
799: IF l_eff_locator_control <> 1 THEN
800: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
801: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' locator on material is NULL and material is eff locator control; cant get quantities from inventory; get exceptions');
802: END IF;
803: RAISE error_get_exception;
804: END IF;
805: END IF;

Line 847: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

843: ,p_lpn_id => NULL
844: ,p_transfer_locator_id => NULL
845: );
846:
847: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities return status='||l_return_status);
849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);
850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);

Line 848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities return status='||l_return_status);

844: ,p_transfer_locator_id => NULL
845: );
846:
847: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities return status='||l_return_status);
849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);
850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);
852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);

Line 849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);

845: );
846:
847: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities return status='||l_return_status);
849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);
850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);
852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);
853: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities loc='||l_locator_id);

Line 850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);

846:
847: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities return status='||l_return_status);
849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);
850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);
852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);
853: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities loc='||l_locator_id);
854: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities rev='||l_revision);

Line 851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);

847: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities return status='||l_return_status);
849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);
850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);
852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);
853: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities loc='||l_locator_id);
854: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities rev='||l_revision);
855: END IF;

Line 852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);

848: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities return status='||l_return_status);
849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);
850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);
852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);
853: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities loc='||l_locator_id);
854: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities rev='||l_revision);
855: END IF;
856:

Line 853: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities loc='||l_locator_id);

849: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities att='||l_att);
850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);
852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);
853: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities loc='||l_locator_id);
854: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities rev='||l_revision);
855: END IF;
856:
857: IF l_att > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

Line 854: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities rev='||l_revision);

850: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities qoh='||l_qoh);
851: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities item_id='||p_material_dtl_rec.inventory_item_id);
852: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities sub='||l_subinv);
853: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities loc='||l_locator_id);
854: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after query quantities rev='||l_revision);
855: END IF;
856:
857: IF l_att > 0 AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
858: build_and_create_transaction

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

879: IF x_actual_qty < l_consume_qty THEN
880: RAISE error_get_exception;
881: END IF;
882:
883: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
884: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
885: END IF;
886:
887: EXCEPTION

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

880: RAISE error_get_exception;
881: END IF;
882:
883: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
884: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
885: END IF;
886:
887: EXCEPTION
888: WHEN error_build_trxn OR error_get_item OR error_convert_partial OR consume_done OR

Line 892: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

888: WHEN error_build_trxn OR error_get_item OR error_convert_partial OR consume_done OR
889: error_get_reservations OR no_consume_required THEN
890: NULL;
891: WHEN error_get_exception THEN
892: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
893: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception block for get exceptions:');
894: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
895: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_start_actual_qty='||l_start_actual_qty);
896: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);

Line 893: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception block for get exceptions:');

889: error_get_reservations OR no_consume_required THEN
890: NULL;
891: WHEN error_get_exception THEN
892: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
893: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception block for get exceptions:');
894: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
895: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_start_actual_qty='||l_start_actual_qty);
896: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
897: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_exception_qty='||(l_consume_qty - x_actual_qty));

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

890: NULL;
891: WHEN error_get_exception THEN
892: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
893: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception block for get exceptions:');
894: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
895: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_start_actual_qty='||l_start_actual_qty);
896: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
897: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_exception_qty='||(l_consume_qty - x_actual_qty));
898: END IF;

Line 895: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_start_actual_qty='||l_start_actual_qty);

891: WHEN error_get_exception THEN
892: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
893: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception block for get exceptions:');
894: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
895: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_start_actual_qty='||l_start_actual_qty);
896: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
897: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_exception_qty='||(l_consume_qty - x_actual_qty));
898: END IF;
899:

Line 896: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);

892: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
893: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception block for get exceptions:');
894: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
895: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_start_actual_qty='||l_start_actual_qty);
896: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
897: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_exception_qty='||(l_consume_qty - x_actual_qty));
898: END IF;
899:
900: create_batch_exception

Line 897: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_exception_qty='||(l_consume_qty - x_actual_qty));

893: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception block for get exceptions:');
894: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
895: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_start_actual_qty='||l_start_actual_qty);
896: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_consume_qty='||l_consume_qty);
897: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_exception_qty='||(l_consume_qty - x_actual_qty));
898: END IF;
899:
900: create_batch_exception
901: (p_material_dtl_rec => p_material_dtl_rec

Line 913: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

909: WHEN error_unexpected THEN
910: x_return_status := FND_API.g_ret_sts_unexp_error;
911: WHEN OTHERS THEN
912: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
913: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
914: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
915: END IF;
916: x_return_status := FND_API.g_ret_sts_unexp_error;
917: END consume_material;

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

910: x_return_status := FND_API.g_ret_sts_unexp_error;
911: WHEN OTHERS THEN
912: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
913: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
914: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
915: END IF;
916: x_return_status := FND_API.g_ret_sts_unexp_error;
917: END consume_material;
918:

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

965: error_relieve_rsrv EXCEPTION;
966: um_convert_error EXCEPTION;
967: dispense_error EXCEPTION;
968: BEGIN
969: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
970: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);
972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);

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

966: um_convert_error EXCEPTION;
967: dispense_error EXCEPTION;
968: BEGIN
969: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
970: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);
972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);

Line 971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);

967: dispense_error EXCEPTION;
968: BEGIN
969: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
970: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);
972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);

Line 972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);

968: BEGIN
969: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
970: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);
972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);

Line 973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);

969: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
970: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);
972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);

Line 974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);

970: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);
972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);

Line 975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);

971: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.reservation_id='||p_rsrv_rec.reservation_id);
972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);
979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);

Line 976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);

972: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_rsrv_rec.lot_number='||p_rsrv_rec.lot_number);
973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);
979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);
980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);

Line 977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);

973: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_lot_divisible_flag='||p_lot_divisible_flag);
974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);
979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);
980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);
981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date

Line 978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);

974: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);
979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);
980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);
981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
982: ,'YYYY-MON-DD HH24:MI:SS'));

Line 979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);

975: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);
979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);
980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);
981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
982: ,'YYYY-MON-DD HH24:MI:SS'));
983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);

Line 980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);

976: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_att='||p_att);
977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);
979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);
980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);
981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
982: ,'YYYY-MON-DD HH24:MI:SS'));
983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
984: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);

Line 981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date

977: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_satt='||p_satt);
978: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_primary_uom_code='||p_primary_uom_code);
979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);
980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);
981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
982: ,'YYYY-MON-DD HH24:MI:SS'));
983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
984: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_secondary_uom_code='||p_secondary_uom_code);

Line 983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);

979: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.material_detail_id='||p_mtl_dtl_rec.material_detail_id);
980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);
981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
982: ,'YYYY-MON-DD HH24:MI:SS'));
983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
984: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_secondary_uom_code='||p_secondary_uom_code);
986: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
987: END IF;

Line 984: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);

980: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_mtl_dtl_rec.dtl_um='||p_mtl_dtl_rec.dtl_um);
981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
982: ,'YYYY-MON-DD HH24:MI:SS'));
983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
984: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_secondary_uom_code='||p_secondary_uom_code);
986: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
987: END IF;
988:

Line 985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_secondary_uom_code='||p_secondary_uom_code);

981: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_trans_date='||to_char(p_trans_date
982: ,'YYYY-MON-DD HH24:MI:SS'));
983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
984: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_secondary_uom_code='||p_secondary_uom_code);
986: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
987: END IF;
988:
989: /* Set the return status to success initially */

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

982: ,'YYYY-MON-DD HH24:MI:SS'));
983: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_consume_qty='||p_consume_qty);
984: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_revision='||p_revision);
985: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' p_secondary_uom_code='||p_secondary_uom_code);
986: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
987: END IF;
988:
989: /* Set the return status to success initially */
990: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1029: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1025: ,x_qty => l_dtl_qty
1026: ,x_return_status => x_return_status);
1027:
1028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1029: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1030: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_reservations_pvt.get_reservation_dtl_qty returned error');
1031: END IF;
1032:
1033: RAISE error_get_dtl_qty;

Line 1030: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_reservations_pvt.get_reservation_dtl_qty returned error');

1026: ,x_return_status => x_return_status);
1027:
1028: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1029: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1030: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_reservations_pvt.get_reservation_dtl_qty returned error');
1031: END IF;
1032:
1033: RAISE error_get_dtl_qty;
1034: END IF;

Line 1036: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1032:
1033: RAISE error_get_dtl_qty;
1034: END IF;
1035:
1036: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1037: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' get_reservation_dtl_qty returned l_dtl_qty='||l_dtl_qty);
1038: END IF;
1039: ELSE
1040: l_prim_qty := p_att;

Line 1037: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' get_reservation_dtl_qty returned l_dtl_qty='||l_dtl_qty);

1033: RAISE error_get_dtl_qty;
1034: END IF;
1035:
1036: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1037: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' get_reservation_dtl_qty returned l_dtl_qty='||l_dtl_qty);
1038: END IF;
1039: ELSE
1040: l_prim_qty := p_att;
1041: l_sec_qty := p_satt;

Line 1055: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1051: ,to_unit => l_to_um
1052: ,from_name => NULL
1053: ,to_name => NULL);
1054: IF l_dtl_qty = -99999 THEN
1055: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1056: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1057: END IF;
1058: RAISE um_convert_error;
1059: END IF;

Line 1056: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');

1052: ,from_name => NULL
1053: ,to_name => NULL);
1054: IF l_dtl_qty = -99999 THEN
1055: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1056: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1057: END IF;
1058: RAISE um_convert_error;
1059: END IF;
1060: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 1060: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1056: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1057: END IF;
1058: RAISE um_convert_error;
1059: END IF;
1060: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1061: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1062: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_dtl_qty= '||to_char(l_dtl_qty));
1063: END IF;
1064: END IF;

Line 1061: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');

1057: END IF;
1058: RAISE um_convert_error;
1059: END IF;
1060: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1061: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1062: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_dtl_qty= '||to_char(l_dtl_qty));
1063: END IF;
1064: END IF;
1065:

Line 1062: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_dtl_qty= '||to_char(l_dtl_qty));

1058: RAISE um_convert_error;
1059: END IF;
1060: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1061: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' after call to inv_convert.inv_um_convert');
1062: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_dtl_qty= '||to_char(l_dtl_qty));
1063: END IF;
1064: END IF;
1065:
1066: IF p_rsrv_rec.lot_number IS NOT NULL AND

Line 1069: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1065:
1066: IF p_rsrv_rec.lot_number IS NOT NULL AND
1067: NVL(p_lot_divisible_flag,'Y') = 'N' THEN
1068: l_whole_qty := TRUE;
1069: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1070: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = TRUE because lot indivisible item');
1071: END IF;
1072: ELSE
1073: l_whole_qty := FALSE;

Line 1070: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = TRUE because lot indivisible item');

1066: IF p_rsrv_rec.lot_number IS NOT NULL AND
1067: NVL(p_lot_divisible_flag,'Y') = 'N' THEN
1068: l_whole_qty := TRUE;
1069: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1070: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = TRUE because lot indivisible item');
1071: END IF;
1072: ELSE
1073: l_whole_qty := FALSE;
1074: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 1074: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1070: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = TRUE because lot indivisible item');
1071: END IF;
1072: ELSE
1073: l_whole_qty := FALSE;
1074: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1075: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = FALSE');
1076: END IF;
1077: END IF;
1078:

Line 1075: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = FALSE');

1071: END IF;
1072: ELSE
1073: l_whole_qty := FALSE;
1074: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1075: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = FALSE');
1076: END IF;
1077: END IF;
1078:
1079: -- test again for dispensed items

Line 1083: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1079: -- test again for dispensed items
1080: IF NOT l_whole_qty THEN
1081: IF NVL(p_dispense_ind,'N') = 'Y' THEN
1082: l_whole_qty := TRUE;
1083: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1084: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = TRUE because dispensed item');
1085: END IF;
1086: END IF;
1087: END IF;

Line 1084: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = TRUE because dispensed item');

1080: IF NOT l_whole_qty THEN
1081: IF NVL(p_dispense_ind,'N') = 'Y' THEN
1082: l_whole_qty := TRUE;
1083: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1084: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_whole_qty = TRUE because dispensed item');
1085: END IF;
1086: END IF;
1087: END IF;
1088:

Line 1090: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1086: END IF;
1087: END IF;
1088:
1089: IF l_dtl_qty <= p_consume_qty - x_actual_qty OR l_whole_qty THEN
1090: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1091: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trxn_qty := l_dtl_qty');
1092: END IF;
1093: l_trxn_qty := l_dtl_qty;
1094: ELSE

Line 1091: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trxn_qty := l_dtl_qty');

1087: END IF;
1088:
1089: IF l_dtl_qty <= p_consume_qty - x_actual_qty OR l_whole_qty THEN
1090: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1091: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trxn_qty := l_dtl_qty');
1092: END IF;
1093: l_trxn_qty := l_dtl_qty;
1094: ELSE
1095: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 1095: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1091: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trxn_qty := l_dtl_qty');
1092: END IF;
1093: l_trxn_qty := l_dtl_qty;
1094: ELSE
1095: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1096: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trxn_qty := p_consume_qty - x_actual_qty');
1097: END IF;
1098: l_trxn_qty := p_consume_qty - x_actual_qty;
1099: l_prim_qty := NULL;

Line 1096: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trxn_qty := p_consume_qty - x_actual_qty');

1092: END IF;
1093: l_trxn_qty := l_dtl_qty;
1094: ELSE
1095: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1096: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' l_trxn_qty := p_consume_qty - x_actual_qty');
1097: END IF;
1098: l_trxn_qty := p_consume_qty - x_actual_qty;
1099: l_prim_qty := NULL;
1100: l_sec_qty := NULL;

Line 1108: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1104: l_transaction_rec.transaction_date := p_trans_date;
1105: l_transaction_rec.transaction_quantity := l_trxn_qty;
1106: l_transaction_rec.secondary_uom_code := p_secondary_uom_code;
1107:
1108: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1109: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_date='||to_char(l_transaction_rec.transaction_date
1110: ,'YYYY-MON-DD HH24:MI:SS'));
1111: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_qty='||l_transaction_rec.transaction_quantity);
1112: END IF;

Line 1109: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_date='||to_char(l_transaction_rec.transaction_date

1105: l_transaction_rec.transaction_quantity := l_trxn_qty;
1106: l_transaction_rec.secondary_uom_code := p_secondary_uom_code;
1107:
1108: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1109: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_date='||to_char(l_transaction_rec.transaction_date
1110: ,'YYYY-MON-DD HH24:MI:SS'));
1111: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_qty='||l_transaction_rec.transaction_quantity);
1112: END IF;
1113:

Line 1111: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_qty='||l_transaction_rec.transaction_quantity);

1107:
1108: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1109: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_date='||to_char(l_transaction_rec.transaction_date
1110: ,'YYYY-MON-DD HH24:MI:SS'));
1111: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' transaction_qty='||l_transaction_rec.transaction_quantity);
1112: END IF;
1113:
1114: IF l_prim_qty IS NOT NULL THEN
1115: l_transaction_rec.primary_quantity := l_prim_qty;

Line 1116: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1112: END IF;
1113:
1114: IF l_prim_qty IS NOT NULL THEN
1115: l_transaction_rec.primary_quantity := l_prim_qty;
1116: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1117: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' primary_qty is known:'||l_transaction_rec.primary_quantity);
1118: END IF;
1119: END IF;
1120: IF l_sec_qty IS NOT NULL THEN

Line 1117: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' primary_qty is known:'||l_transaction_rec.primary_quantity);

1113:
1114: IF l_prim_qty IS NOT NULL THEN
1115: l_transaction_rec.primary_quantity := l_prim_qty;
1116: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1117: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' primary_qty is known:'||l_transaction_rec.primary_quantity);
1118: END IF;
1119: END IF;
1120: IF l_sec_qty IS NOT NULL THEN
1121: l_transaction_rec.secondary_transaction_quantity := l_sec_qty;

Line 1122: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1118: END IF;
1119: END IF;
1120: IF l_sec_qty IS NOT NULL THEN
1121: l_transaction_rec.secondary_transaction_quantity := l_sec_qty;
1122: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1123: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' secondary_transaction_quantity is known:'||l_transaction_rec.secondary_transaction_quantity);
1124: END IF;
1125: END IF;
1126:

Line 1123: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' secondary_transaction_quantity is known:'||l_transaction_rec.secondary_transaction_quantity);

1119: END IF;
1120: IF l_sec_qty IS NOT NULL THEN
1121: l_transaction_rec.secondary_transaction_quantity := l_sec_qty;
1122: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1123: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' secondary_transaction_quantity is known:'||l_transaction_rec.secondary_transaction_quantity);
1124: END IF;
1125: END IF;
1126:
1127: l_transaction_rec.transaction_uom := p_mtl_dtl_rec.dtl_um;

Line 1150: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1146: ,p_mmli_tbl => l_lot_rec
1147: ,x_return_status => x_return_status);
1148:
1149: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1150: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1151: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.create_transaction returned '||x_return_status);
1152: END IF;
1153: RAISE error_create_trxn;
1154: END IF;

Line 1151: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.create_transaction returned '||x_return_status);

1147: ,x_return_status => x_return_status);
1148:
1149: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1150: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1151: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' gme_transactions_pvt.create_transaction returned '||x_return_status);
1152: END IF;
1153: RAISE error_create_trxn;
1154: END IF;
1155:

Line 1158: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1154: END IF;
1155:
1156: x_actual_qty := x_actual_qty + l_trxn_qty;
1157:
1158: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1159: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
1160: END IF;
1161:
1162: IF l_rsrv_mode THEN

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

1155:
1156: x_actual_qty := x_actual_qty + l_trxn_qty;
1157:
1158: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1159: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' x_actual_qty='||x_actual_qty);
1160: END IF;
1161:
1162: IF l_rsrv_mode THEN
1163: IF l_prim_qty IS NULL THEN

Line 1176: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1172: ,to_unit => l_to_um
1173: ,from_name => NULL
1174: ,to_name => NULL);
1175: IF l_prim_qty = -99999 THEN
1176: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1177: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1178: END IF;
1179: RAISE um_convert_error;
1180: END IF;

Line 1177: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');

1173: ,from_name => NULL
1174: ,to_name => NULL);
1175: IF l_prim_qty = -99999 THEN
1176: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1177: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1178: END IF;
1179: RAISE um_convert_error;
1180: END IF;
1181: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

Line 1181: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1177: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' inv_convert.inv_um_convert returned error');
1178: END IF;
1179: RAISE um_convert_error;
1180: END IF;
1181: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1182: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calculated prim qty for call to gme_reservations_pvt.relieve_reservation: l_prim_qty= '||to_char(l_prim_qty));
1183: END IF;
1184: END IF;
1185: gme_reservations_pvt.relieve_reservation

Line 1182: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calculated prim qty for call to gme_reservations_pvt.relieve_reservation: l_prim_qty= '||to_char(l_prim_qty));

1178: END IF;
1179: RAISE um_convert_error;
1180: END IF;
1181: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1182: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' calculated prim qty for call to gme_reservations_pvt.relieve_reservation: l_prim_qty= '||to_char(l_prim_qty));
1183: END IF;
1184: END IF;
1185: gme_reservations_pvt.relieve_reservation
1186: (p_reservation_id => p_rsrv_rec.reservation_id

Line 1195: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1191: RAISE error_relieve_rsrv;
1192: END IF;
1193:
1194: -- Bug 4899399 - after relieving the reservation, informing the GMO about the transaction.
1195: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1196: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'dispense_ind'||p_mtl_dtl_rec.dispense_ind);
1197: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'trans type_id'||l_transaction_rec.transaction_type_id);
1198: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'ext sour line_id'||p_rsrv_rec.external_source_line_id);
1199:

Line 1196: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'dispense_ind'||p_mtl_dtl_rec.dispense_ind);

1192: END IF;
1193:
1194: -- Bug 4899399 - after relieving the reservation, informing the GMO about the transaction.
1195: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1196: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'dispense_ind'||p_mtl_dtl_rec.dispense_ind);
1197: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'trans type_id'||l_transaction_rec.transaction_type_id);
1198: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'ext sour line_id'||p_rsrv_rec.external_source_line_id);
1199:
1200: END IF;

Line 1197: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'trans type_id'||l_transaction_rec.transaction_type_id);

1193:
1194: -- Bug 4899399 - after relieving the reservation, informing the GMO about the transaction.
1195: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1196: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'dispense_ind'||p_mtl_dtl_rec.dispense_ind);
1197: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'trans type_id'||l_transaction_rec.transaction_type_id);
1198: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'ext sour line_id'||p_rsrv_rec.external_source_line_id);
1199:
1200: END IF;
1201: IF NVL(p_dispense_ind,'N') = 'Y' THEN

Line 1198: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'ext sour line_id'||p_rsrv_rec.external_source_line_id);

1194: -- Bug 4899399 - after relieving the reservation, informing the GMO about the transaction.
1195: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1196: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'dispense_ind'||p_mtl_dtl_rec.dispense_ind);
1197: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'trans type_id'||l_transaction_rec.transaction_type_id);
1198: gme_debug.put_line (g_pkg_name||'.'||l_api_name||'ext sour line_id'||p_rsrv_rec.external_source_line_id);
1199:
1200: END IF;
1201: IF NVL(p_dispense_ind,'N') = 'Y' THEN
1202: IF l_transaction_rec.transaction_type_id = gme_common_pvt.g_ing_issue THEN

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

1218: END IF;
1219: END IF;
1220: END IF;
1221:
1222: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1223: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1224: END IF;
1225:
1226:

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

1219: END IF;
1220: END IF;
1221:
1222: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1223: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1224: END IF;
1225:
1226:
1227: EXCEPTION

Line 1245: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN

1241: WHEN dispense_error THEN
1242: x_return_status := fnd_api.g_ret_sts_error;
1243: WHEN OTHERS THEN
1244: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1245: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1246: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1247: END IF;
1248: x_return_status := FND_API.g_ret_sts_unexp_error;
1249: END build_and_create_transaction;

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

1242: x_return_status := fnd_api.g_ret_sts_error;
1243: WHEN OTHERS THEN
1244: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1245: IF (NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT) THEN
1246: gme_debug.put_line ('Unexpected error: '||g_pkg_name||'.'||l_api_name||': '||SQLERRM);
1247: END IF;
1248: x_return_status := FND_API.g_ret_sts_unexp_error;
1249: END build_and_create_transaction;
1250:

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

1258:
1259: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTR_MMTI_FROM_RESERVATION';
1260: BEGIN
1261:
1262: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1263: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1264: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' reservation_id='||p_rsrv_rec.reservation_id);
1265: END IF;
1266:

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

1259: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTR_MMTI_FROM_RESERVATION';
1260: BEGIN
1261:
1262: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1263: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1264: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' reservation_id='||p_rsrv_rec.reservation_id);
1265: END IF;
1266:
1267: /* Initially let us assign the return status to success */

Line 1264: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' reservation_id='||p_rsrv_rec.reservation_id);

1260: BEGIN
1261:
1262: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1263: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1264: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' reservation_id='||p_rsrv_rec.reservation_id);
1265: END IF;
1266:
1267: /* Initially let us assign the return status to success */
1268: x_return_status := FND_API.g_ret_sts_success;

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

1284: IF p_rsrv_rec.lot_number IS NOT NULL THEN
1285: x_mmli_tbl(1).lot_number := p_rsrv_rec.lot_number;
1286: END IF;
1287:
1288: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1289: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1290: END IF;
1291:
1292:

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

1285: x_mmli_tbl(1).lot_number := p_rsrv_rec.lot_number;
1286: END IF;
1287:
1288: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1289: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1290: END IF;
1291:
1292:
1293: EXCEPTION

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

1312:
1313: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTR_MMTI_FROM_QTY_TREE';
1314: BEGIN
1315:
1316: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1317: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1318: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_mtl_dtl_rec.material_detail_id);
1319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
1320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);

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

1313: l_api_name CONSTANT VARCHAR2 (30) := 'CONSTR_MMTI_FROM_QTY_TREE';
1314: BEGIN
1315:
1316: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1317: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1318: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_mtl_dtl_rec.material_detail_id);
1319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
1320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
1321: END IF;

Line 1318: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_mtl_dtl_rec.material_detail_id);

1314: BEGIN
1315:
1316: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1317: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1318: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_mtl_dtl_rec.material_detail_id);
1319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
1320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
1321: END IF;
1322:

Line 1319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);

1315:
1316: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1317: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1318: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_mtl_dtl_rec.material_detail_id);
1319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
1320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
1321: END IF;
1322:
1323: /* Initially let us assign the return status to success */

Line 1320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);

1316: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1317: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1318: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_mtl_dtl_rec.material_detail_id);
1319: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_subinv='||p_subinv);
1320: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_locator_id='||p_locator_id);
1321: END IF;
1322:
1323: /* Initially let us assign the return status to success */
1324: x_return_status := FND_API.g_ret_sts_success;

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

1330: x_mmti_rec.organization_id := p_mtl_dtl_rec.organization_id;
1331: x_mmti_rec.subinventory_code := p_subinv;
1332: x_mmti_rec.locator_id := p_locator_id;
1333:
1334: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1335: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1336: END IF;
1337:
1338: EXCEPTION

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

1331: x_mmti_rec.subinventory_code := p_subinv;
1332: x_mmti_rec.locator_id := p_locator_id;
1333:
1334: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1335: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1336: END IF;
1337:
1338: EXCEPTION
1339: WHEN FND_API.G_EXC_ERROR THEN

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

1369:
1370: error_insert_exceptions EXCEPTION;
1371: error_no_exception EXCEPTION;
1372: BEGIN
1373: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1374: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
1376: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
1377: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);

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

1370: error_insert_exceptions EXCEPTION;
1371: error_no_exception EXCEPTION;
1372: BEGIN
1373: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1374: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
1376: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
1377: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
1378: IF p_material_dtl_rec.phantom_line_id IS NOT NULL THEN

Line 1375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);

1371: error_no_exception EXCEPTION;
1372: BEGIN
1373: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1374: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
1376: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
1377: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
1378: IF p_material_dtl_rec.phantom_line_id IS NOT NULL THEN
1379: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' this is a PHANTOM');

Line 1376: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);

1372: BEGIN
1373: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1374: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
1376: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
1377: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
1378: IF p_material_dtl_rec.phantom_line_id IS NOT NULL THEN
1379: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' this is a PHANTOM');
1380: END IF;

Line 1377: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);

1373: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1374: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
1376: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
1377: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
1378: IF p_material_dtl_rec.phantom_line_id IS NOT NULL THEN
1379: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' this is a PHANTOM');
1380: END IF;
1381:

Line 1379: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' this is a PHANTOM');

1375: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' material_detail_id='||p_material_dtl_rec.material_detail_id);
1376: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_no='||p_material_dtl_rec.line_no);
1377: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' line_type='||p_material_dtl_rec.line_type);
1378: IF p_material_dtl_rec.phantom_line_id IS NOT NULL THEN
1379: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' this is a PHANTOM');
1380: END IF;
1381:
1382: IF p_pending_move_order_ind IS NULL THEN
1383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind IS NULL');

Line 1383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind IS NULL');

1379: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' this is a PHANTOM');
1380: END IF;
1381:
1382: IF p_pending_move_order_ind IS NULL THEN
1383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind IS NULL');
1384: ELSIF p_pending_move_order_ind THEN
1385: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = TRUE');
1386: ELSE
1387: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = FALSE');

Line 1385: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = TRUE');

1381:
1382: IF p_pending_move_order_ind IS NULL THEN
1383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind IS NULL');
1384: ELSIF p_pending_move_order_ind THEN
1385: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = TRUE');
1386: ELSE
1387: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = FALSE');
1388: END IF;
1389:

Line 1387: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = FALSE');

1383: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind IS NULL');
1384: ELSIF p_pending_move_order_ind THEN
1385: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = TRUE');
1386: ELSE
1387: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = FALSE');
1388: END IF;
1389:
1390: IF p_pending_rsrv_ind IS NULL THEN
1391: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind IS NULL');

Line 1391: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind IS NULL');

1387: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_move_order_ind = FALSE');
1388: END IF;
1389:
1390: IF p_pending_rsrv_ind IS NULL THEN
1391: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind IS NULL');
1392: ELSIF p_pending_rsrv_ind THEN
1393: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = TRUE');
1394: ELSE
1395: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = FALSE');

Line 1393: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = TRUE');

1389:
1390: IF p_pending_rsrv_ind IS NULL THEN
1391: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind IS NULL');
1392: ELSIF p_pending_rsrv_ind THEN
1393: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = TRUE');
1394: ELSE
1395: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = FALSE');
1396: END IF;
1397:

Line 1395: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = FALSE');

1391: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind IS NULL');
1392: ELSIF p_pending_rsrv_ind THEN
1393: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = TRUE');
1394: ELSE
1395: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = FALSE');
1396: END IF;
1397:
1398: IF p_transacted_qty IS NULL THEN
1399: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty IS NULL');

Line 1399: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty IS NULL');

1395: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_pending_rsrv_ind = FALSE');
1396: END IF;
1397:
1398: IF p_transacted_qty IS NULL THEN
1399: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty IS NULL');
1400: ELSE
1401: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty = '||p_transacted_qty);
1402: END IF;
1403:

Line 1401: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty = '||p_transacted_qty);

1397:
1398: IF p_transacted_qty IS NULL THEN
1399: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty IS NULL');
1400: ELSE
1401: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty = '||p_transacted_qty);
1402: END IF;
1403:
1404: IF p_exception_qty IS NULL THEN
1405: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_exception_qty IS NULL');

Line 1405: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_exception_qty IS NULL');

1401: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_transacted_qty = '||p_transacted_qty);
1402: END IF;
1403:
1404: IF p_exception_qty IS NULL THEN
1405: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_exception_qty IS NULL');
1406: ELSE
1407: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_exception_qty = '||p_exception_qty);
1408: END IF;
1409:

Line 1407: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_exception_qty = '||p_exception_qty);

1403:
1404: IF p_exception_qty IS NULL THEN
1405: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_exception_qty IS NULL');
1406: ELSE
1407: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' p_exception_qty = '||p_exception_qty);
1408: END IF;
1409:
1410: END IF;
1411:

Line 1426: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1422: END IF;
1423:
1424: IF p_material_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND p_material_dtl_rec.phantom_line_id IS NOT NULL THEN
1425: -- don't report the phantom ingredients; just return; phantom products will be reported
1426: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1427: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' called for phantom ingredient... returning, only report for phantom product');
1428: END IF;
1429: RAISE error_no_exception;
1430: END IF;

Line 1427: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' called for phantom ingredient... returning, only report for phantom product');

1423:
1424: IF p_material_dtl_rec.line_type = gme_common_pvt.g_line_type_ing AND p_material_dtl_rec.phantom_line_id IS NOT NULL THEN
1425: -- don't report the phantom ingredients; just return; phantom products will be reported
1426: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1427: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' called for phantom ingredient... returning, only report for phantom product');
1428: END IF;
1429: RAISE error_no_exception;
1430: END IF;
1431:

Line 1489: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1485: END IF;
1486:
1487: x_return_status := gme_common_pvt.g_exceptions_err;
1488: ELSE
1489: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1490: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception not found');
1491: END IF;
1492: END IF;
1493:

Line 1490: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception not found');

1486:
1487: x_return_status := gme_common_pvt.g_exceptions_err;
1488: ELSE
1489: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1490: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception not found');
1491: END IF;
1492: END IF;
1493:
1494: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN

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

1490: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' exception not found');
1491: END IF;
1492: END IF;
1493:
1494: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1495: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' with return status= '||x_return_status);
1496: END IF;
1497: EXCEPTION
1498: WHEN error_insert_exceptions THEN

Line 1495: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' with return status= '||x_return_status);

1491: END IF;
1492: END IF;
1493:
1494: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1495: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name||' with return status= '||x_return_status);
1496: END IF;
1497: EXCEPTION
1498: WHEN error_insert_exceptions THEN
1499: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1503: IF nvl(g_debug, gme_debug.g_log_unexpected + 1) <= gme_debug.g_log_unexpected THEN

1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: WHEN error_no_exception THEN
1501: NULL;
1502: WHEN OTHERS THEN
1503: IF nvl(g_debug, gme_debug.g_log_unexpected + 1) <= gme_debug.g_log_unexpected THEN
1504: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1505: END IF;
1506: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1504: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1500: WHEN error_no_exception THEN
1501: NULL;
1502: WHEN OTHERS THEN
1503: IF nvl(g_debug, gme_debug.g_log_unexpected + 1) <= gme_debug.g_log_unexpected THEN
1504: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1505: END IF;
1506: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: END create_batch_exception;

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

1545: error_unexp_phantom EXCEPTION;
1546: error_unexp_downstream EXCEPTION;
1547:
1548: BEGIN
1549: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1550: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1551: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_id);
1552: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);
1553: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' mode='||p_auto_by_step);

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

1546: error_unexp_downstream EXCEPTION;
1547:
1548: BEGIN
1549: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1550: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1551: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_id);
1552: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);
1553: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' mode='||p_auto_by_step);
1554: END IF;

Line 1551: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_id);

1547:
1548: BEGIN
1549: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1550: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1551: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_id);
1552: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);
1553: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' mode='||p_auto_by_step);
1554: END IF;
1555:

Line 1552: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);

1548: BEGIN
1549: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1550: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1551: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_id);
1552: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);
1553: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' mode='||p_auto_by_step);
1554: END IF;
1555:
1556: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1553: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' mode='||p_auto_by_step);

1549: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1550: gme_debug.put_line('Entering api '||g_pkg_name||'.'||l_api_name);
1551: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batch_id='||p_batch_id);
1552: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' batchstep_id='||p_batchstep_id);
1553: gme_debug.put_line(g_pkg_name||'.'||l_api_name||' mode='||p_auto_by_step);
1554: END IF;
1555:
1556: x_return_status := FND_API.G_RET_STS_SUCCESS;
1557:

Line 1567: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1563: l_matl_dtl_id := l_matl_dtl_tab(i).material_detail_id;
1564: l_phantom_id := l_matl_dtl_tab(i).phantom_id;
1565: l_release_type := l_matl_dtl_tab(i).release_type;
1566:
1567: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1568: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' phantom ingredient found: material_detail_id='||l_matl_dtl_id);
1569: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' partner phantom batch id: batch_id='||l_phantom_id);
1570: END IF;
1571:

Line 1568: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' phantom ingredient found: material_detail_id='||l_matl_dtl_id);

1564: l_phantom_id := l_matl_dtl_tab(i).phantom_id;
1565: l_release_type := l_matl_dtl_tab(i).release_type;
1566:
1567: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1568: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' phantom ingredient found: material_detail_id='||l_matl_dtl_id);
1569: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' partner phantom batch id: batch_id='||l_phantom_id);
1570: END IF;
1571:
1572: IF p_auto_by_step IN (0,1) AND l_release_type = gme_common_pvt.g_mtl_autobystep_release THEN

Line 1569: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' partner phantom batch id: batch_id='||l_phantom_id);

1565: l_release_type := l_matl_dtl_tab(i).release_type;
1566:
1567: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1568: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' phantom ingredient found: material_detail_id='||l_matl_dtl_id);
1569: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' partner phantom batch id: batch_id='||l_phantom_id);
1570: END IF;
1571:
1572: IF p_auto_by_step IN (0,1) AND l_release_type = gme_common_pvt.g_mtl_autobystep_release THEN
1573: OPEN Cur_associated_step(l_matl_dtl_id);

Line 1587: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN

1583: l_step_id = p_batchstep_id AND
1584: l_release_type = gme_common_pvt.g_mtl_autobystep_release) OR
1585: (p_auto_by_step = 2)) THEN
1586: IF l_phantom_id IS NULL THEN
1587: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1588: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' phantom ingredient unexploded: material_detail_id='||l_matl_dtl_id);
1589: END IF;
1590: RAISE error_unexp_phantom;
1591: END IF;

Line 1588: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' phantom ingredient unexploded: material_detail_id='||l_matl_dtl_id);

1584: l_release_type = gme_common_pvt.g_mtl_autobystep_release) OR
1585: (p_auto_by_step = 2)) THEN
1586: IF l_phantom_id IS NULL THEN
1587: IF ( NVL(G_DEBUG,-1) = GME_DEBUG.G_LOG_STATEMENT ) THEN
1588: gme_debug.put_line (g_pkg_name||'.'||l_api_name||' phantom ingredient unexploded: material_detail_id='||l_matl_dtl_id);
1589: END IF;
1590: RAISE error_unexp_phantom;
1591: END IF;
1592:

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

1602: END IF;
1603: END IF;
1604: END LOOP;
1605:
1606: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1607: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1608: END IF;
1609:
1610: EXCEPTION

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

1603: END IF;
1604: END LOOP;
1605:
1606: IF nvl(g_debug, gme_debug.g_log_procedure + 1) <= gme_debug.g_log_procedure THEN
1607: gme_debug.put_line('Exiting api '||g_pkg_name||'.'||l_api_name);
1608: END IF;
1609:
1610: EXCEPTION
1611: WHEN error_unexp_phantom THEN

Line 1617: IF nvl(g_debug, gme_debug.g_log_unexpected + 1) <= gme_debug.g_log_unexpected THEN

1613: x_return_status := FND_API.G_RET_STS_ERROR;
1614: WHEN error_unexp_downstream THEN
1615: NULL;
1616: WHEN OTHERS THEN
1617: IF nvl(g_debug, gme_debug.g_log_unexpected + 1) <= gme_debug.g_log_unexpected THEN
1618: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1619: END IF;
1620: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1618: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);

1614: WHEN error_unexp_downstream THEN
1615: NULL;
1616: WHEN OTHERS THEN
1617: IF nvl(g_debug, gme_debug.g_log_unexpected + 1) <= gme_debug.g_log_unexpected THEN
1618: gme_debug.put_line('When others exception in '||g_pkg_name||'.'||l_api_name||' Error is ' || SQLERRM);
1619: END IF;
1620: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1621: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1622: END check_unexploded_phantom;

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

1653: error_vr_dates EXCEPTION;
1654: error_validation EXCEPTION;
1655:
1656: BEGIN
1657: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1658: gme_debug.g_log_procedure THEN
1659: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1660: || l_api_name);
1661: END IF;

Line 1658: gme_debug.g_log_procedure THEN

1654: error_validation EXCEPTION;
1655:
1656: BEGIN
1657: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1658: gme_debug.g_log_procedure THEN
1659: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1660: || l_api_name);
1661: END IF;
1662:

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

1655:
1656: BEGIN
1657: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1658: gme_debug.g_log_procedure THEN
1659: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1660: || l_api_name);
1661: END IF;
1662:
1663: x_return_status := FND_API.g_ret_sts_success;

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

1740: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1741: RAISE error_validation;
1742: END IF;
1743:
1744: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1745: gme_debug.g_log_procedure THEN
1746: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1747: END IF;
1748:

Line 1745: gme_debug.g_log_procedure THEN

1741: RAISE error_validation;
1742: END IF;
1743:
1744: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1745: gme_debug.g_log_procedure THEN
1746: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1747: END IF;
1748:
1749: EXCEPTION

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

1742: END IF;
1743:
1744: IF NVL (g_debug, gme_debug.g_log_procedure + 1) <=
1745: gme_debug.g_log_procedure THEN
1746: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1747: END IF;
1748:
1749: EXCEPTION
1750: WHEN error_validation THEN

Line 1773: IF g_debug <= gme_debug.g_log_procedure THEN

1769: x_return_status := fnd_api.g_ret_sts_error;
1770: WHEN OTHERS THEN
1771: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1772:
1773: IF g_debug <= gme_debug.g_log_procedure THEN
1774: gme_debug.put_line ( 'Unexpected error: '
1775: || g_pkg_name
1776: || '.'
1777: || l_api_name

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

1770: WHEN OTHERS THEN
1771: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1772:
1773: IF g_debug <= gme_debug.g_log_procedure THEN
1774: gme_debug.put_line ( 'Unexpected error: '
1775: || g_pkg_name
1776: || '.'
1777: || l_api_name
1778: || ': '