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

Line 66: gme_debug.log_initialize ('ConcPicking');

62: TYPE pick_ref IS REF CURSOR;
63: l_pick_cursor pick_ref;
64: BEGIN
65: IF g_debug IS NOT NULL THEN
66: gme_debug.log_initialize ('ConcPicking');
67: END IF;
68: IF g_debug <= gme_debug.g_log_procedure THEN
69: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
70: END IF;

Line 68: IF g_debug <= gme_debug.g_log_procedure THEN

64: BEGIN
65: IF g_debug IS NOT NULL THEN
66: gme_debug.log_initialize ('ConcPicking');
67: END IF;
68: IF g_debug <= gme_debug.g_log_procedure THEN
69: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
70: END IF;
71: l_where := 'NVL(open_qty,0) > 0';
72: l_where := l_where || ' AND organization_id = :organization_id';

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

65: IF g_debug IS NOT NULL THEN
66: gme_debug.log_initialize ('ConcPicking');
67: END IF;
68: IF g_debug <= gme_debug.g_log_procedure THEN
69: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
70: END IF;
71: l_where := 'NVL(open_qty,0) > 0';
72: l_where := l_where || ' AND organization_id = :organization_id';
73: IF (TO_NUMBER(p_all_batches) = 2) THEN

Line 104: IF g_debug <= gme_debug.g_log_statement THEN

100: || ' AND material_requirement_date <= SYSDATE + NVL(:days_forward, 100000)'
101: || ' AND material_requirement_date >= NVL(:from_req_date, material_requirement_date)'
102: || ' AND material_requirement_date <= NVL(:to_req_date, material_requirement_date)';
103: l_sql_stmt := 'SELECT * FROM gme_ingred_pick_vw WHERE ' || l_where;
104: IF g_debug <= gme_debug.g_log_statement THEN
105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| l_sql_stmt);
106: END IF;
107: OPEN l_pick_cursor FOR l_sql_stmt
108: USING p_organization_id, p_from_batch, p_to_batch, p_oprn_no, p_oprn_vers,

Line 105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| l_sql_stmt);

101: || ' AND material_requirement_date >= NVL(:from_req_date, material_requirement_date)'
102: || ' AND material_requirement_date <= NVL(:to_req_date, material_requirement_date)';
103: l_sql_stmt := 'SELECT * FROM gme_ingred_pick_vw WHERE ' || l_where;
104: IF g_debug <= gme_debug.g_log_statement THEN
105: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':'|| l_sql_stmt);
106: END IF;
107: OPEN l_pick_cursor FOR l_sql_stmt
108: USING p_organization_id, p_from_batch, p_to_batch, p_oprn_no, p_oprn_vers,
109: p_product_no, p_organization_id, p_organization_id, p_product_no,

Line 115: IF g_debug <= gme_debug.g_log_statement THEN

111: p_days_forward, fnd_date.canonical_to_date(p_from_req_date),
112: fnd_date.canonical_to_date(p_to_req_date);
113: FETCH l_pick_cursor BULK COLLECT INTO l_picking_tbl;
114: CLOSE l_pick_cursor;
115: IF g_debug <= gme_debug.g_log_statement THEN
116: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':No. of records found = '|| l_picking_tbl.COUNT);
117: END IF;
118:
119: FOR i IN 1 .. l_picking_tbl.COUNT LOOP

Line 116: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':No. of records found = '|| l_picking_tbl.COUNT);

112: fnd_date.canonical_to_date(p_to_req_date);
113: FETCH l_pick_cursor BULK COLLECT INTO l_picking_tbl;
114: CLOSE l_pick_cursor;
115: IF g_debug <= gme_debug.g_log_statement THEN
116: gme_debug.put_line(g_pkg_name|| '.'|| l_api_name|| ':No. of records found = '|| l_picking_tbl.COUNT);
117: END IF;
118:
119: FOR i IN 1 .. l_picking_tbl.COUNT LOOP
120: l_mat_req_tbl (i).organization_id :=

Line 145: IF g_debug <= gme_debug.g_log_statement THEN

141: ,p_plan_tasks => p_plan_tasks
142: ,x_return_status => l_return_status
143: ,x_conc_request_id => l_conc_request_id);
144:
145: IF g_debug <= gme_debug.g_log_statement THEN
146: gme_debug.put_line ( g_pkg_name
147: || '.'
148: || l_api_name
149: || ':Return from pick_material is '

Line 146: gme_debug.put_line ( g_pkg_name

142: ,x_return_status => l_return_status
143: ,x_conc_request_id => l_conc_request_id);
144:
145: IF g_debug <= gme_debug.g_log_statement THEN
146: gme_debug.put_line ( g_pkg_name
147: || '.'
148: || l_api_name
149: || ':Return from pick_material is '
150: || l_return_status);

Line 157: IF g_debug <= gme_debug.g_log_procedure THEN

153: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
154: RAISE pick_material_err;
155: END IF;
156:
157: IF g_debug <= gme_debug.g_log_procedure THEN
158: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
159: END IF;
160: EXCEPTION
161: WHEN build_where_err OR pick_material_err THEN

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

154: RAISE pick_material_err;
155: END IF;
156:
157: IF g_debug <= gme_debug.g_log_procedure THEN
158: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
159: END IF;
160: EXCEPTION
161: WHEN build_where_err OR pick_material_err THEN
162: gme_common_pvt.count_and_get (x_count => l_msg_count

Line 168: IF g_debug <= gme_debug.g_log_unexpected THEN

164: raise_application_error (-20000, l_msg_data, TRUE);
165: WHEN OTHERS THEN
166: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
167:
168: IF g_debug <= gme_debug.g_log_unexpected THEN
169: gme_debug.put_line ( 'When others exception in '
170: || g_pkg_name
171: || '.'
172: || l_api_name

Line 169: gme_debug.put_line ( 'When others exception in '

165: WHEN OTHERS THEN
166: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
167:
168: IF g_debug <= gme_debug.g_log_unexpected THEN
169: gme_debug.put_line ( 'When others exception in '
170: || g_pkg_name
171: || '.'
172: || l_api_name
173: || ' Error is '

Line 201: IF g_debug <= gme_debug.g_log_procedure THEN

197: l_open_qty NUMBER := 0;
198: l_return_status VARCHAR2 (1);
199: l_mtl_dtl_rec gme_material_details%ROWTYPE;
200: BEGIN
201: IF g_debug <= gme_debug.g_log_procedure THEN
202: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
203: || l_api_name);
204: END IF;
205:

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

198: l_return_status VARCHAR2 (1);
199: l_mtl_dtl_rec gme_material_details%ROWTYPE;
200: BEGIN
201: IF g_debug <= gme_debug.g_log_procedure THEN
202: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
203: || l_api_name);
204: END IF;
205:
206: l_mtl_dtl_rec.organization_id := p_organization_id;

Line 230: IF g_debug <= gme_debug.g_log_unexpected THEN

226: EXCEPTION
227: WHEN OTHERS THEN
228: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
229:
230: IF g_debug <= gme_debug.g_log_unexpected THEN
231: gme_debug.put_line ( 'When others exception in '
232: || g_pkg_name
233: || '.'
234: || l_api_name

Line 231: gme_debug.put_line ( 'When others exception in '

227: WHEN OTHERS THEN
228: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
229:
230: IF g_debug <= gme_debug.g_log_unexpected THEN
231: gme_debug.put_line ( 'When others exception in '
232: || g_pkg_name
233: || '.'
234: || l_api_name
235: || ' Error is '

Line 293: gme_debug.log_initialize ('PickMaterial');

289: process_line_err EXCEPTION;
290: print_pickslip_err EXCEPTION;
291: BEGIN
292: IF g_debug IS NOT NULL THEN
293: gme_debug.log_initialize ('PickMaterial');
294: END IF;
295:
296: IF g_debug <= gme_debug.g_log_procedure THEN
297: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 296: IF g_debug <= gme_debug.g_log_procedure THEN

292: IF g_debug IS NOT NULL THEN
293: gme_debug.log_initialize ('PickMaterial');
294: END IF;
295:
296: IF g_debug <= gme_debug.g_log_procedure THEN
297: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
298: || l_api_name);
299: END IF;
300:

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

293: gme_debug.log_initialize ('PickMaterial');
294: END IF;
295:
296: IF g_debug <= gme_debug.g_log_procedure THEN
297: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
298: || l_api_name);
299: END IF;
300:
301: x_return_status := fnd_api.g_ret_sts_success;

Line 304: IF g_debug <= gme_debug.g_log_statement THEN

300:
301: x_return_status := fnd_api.g_ret_sts_success;
302: l_count := p_mtl_req_tbl.COUNT;
303:
304: IF g_debug <= gme_debug.g_log_statement THEN
305: gme_debug.put_line ( g_pkg_name
306: || '.'
307: || l_api_name
308: || ':Material Requirement count is '

Line 305: gme_debug.put_line ( g_pkg_name

301: x_return_status := fnd_api.g_ret_sts_success;
302: l_count := p_mtl_req_tbl.COUNT;
303:
304: IF g_debug <= gme_debug.g_log_statement THEN
305: gme_debug.put_line ( g_pkg_name
306: || '.'
307: || l_api_name
308: || ':Material Requirement count is '
309: || l_count);

Line 326: IF g_debug <= gme_debug.g_log_statement THEN

322: RAISE setup_failure;
323: END IF;
324: END IF;
325:
326: IF g_debug <= gme_debug.g_log_statement THEN
327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':After setup');
328: END IF;
329:
330: gme_move_orders_pvt.create_move_order_hdr

Line 327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':After setup');

323: END IF;
324: END IF;
325:
326: IF g_debug <= gme_debug.g_log_statement THEN
327: gme_debug.put_line (g_pkg_name || '.' || l_api_name || ':After setup');
328: END IF;
329:
330: gme_move_orders_pvt.create_move_order_hdr
331: (p_organization_id => p_mtl_req_tbl (1).organization_id

Line 340: IF g_debug <= gme_debug.g_log_statement THEN

336: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
337: RAISE create_move_order_err;
338: END IF;
339:
340: IF g_debug <= gme_debug.g_log_statement THEN
341: gme_debug.put_line ( g_pkg_name
342: || '.'
343: || l_api_name
344: || ':Move order header created is '

Line 341: gme_debug.put_line ( g_pkg_name

337: RAISE create_move_order_err;
338: END IF;
339:
340: IF g_debug <= gme_debug.g_log_statement THEN
341: gme_debug.put_line ( g_pkg_name
342: || '.'
343: || l_api_name
344: || ':Move order header created is '
345: || l_move_order_header_id);

Line 379: IF g_debug <= gme_debug.g_log_statement THEN

375:
376: CLOSE cur_pending_move_orders;
377: END LOOP;
378:
379: IF g_debug <= gme_debug.g_log_statement THEN
380: gme_debug.put_line
381: ( g_pkg_name
382: || '.'
383: || l_api_name

Line 380: gme_debug.put_line

376: CLOSE cur_pending_move_orders;
377: END LOOP;
378:
379: IF g_debug <= gme_debug.g_log_statement THEN
380: gme_debug.put_line
381: ( g_pkg_name
382: || '.'
383: || l_api_name
384: || ':No. of lines to create move_order_lines is '

Line 402: IF g_debug <= gme_debug.g_log_statement THEN

398: END IF;
399:
400: l_count := l_trolin_tbl.COUNT;
401:
402: IF g_debug <= gme_debug.g_log_statement THEN
403: gme_debug.put_line ( g_pkg_name
404: || '.'
405: || l_api_name
406: || ':No. Move order lines created is '

Line 403: gme_debug.put_line ( g_pkg_name

399:
400: l_count := l_trolin_tbl.COUNT;
401:
402: IF g_debug <= gme_debug.g_log_statement THEN
403: gme_debug.put_line ( g_pkg_name
404: || '.'
405: || l_api_name
406: || ':No. Move order lines created is '
407: || l_count);

Line 408: gme_debug.put_line ( g_pkg_name

404: || '.'
405: || l_api_name
406: || ':No. Move order lines created is '
407: || l_count);
408: gme_debug.put_line ( g_pkg_name
409: || '.'
410: || l_api_name
411: || ':No. Pending Move order lines is '
412: || l_pend_lines_tbl.COUNT);

Line 435: IF g_debug <= gme_debug.g_log_statement THEN

431: END LOOP;
432:
433: IF ( p_print_pick_slip = 'Y'
434: AND (g_fully_allocated OR g_partially_allocated) ) THEN
435: IF g_debug <= gme_debug.g_log_statement THEN
436: gme_debug.put_line ( g_pkg_name
437: || '.'
438: || l_api_name
439: || ':Calling print picklsip');

Line 436: gme_debug.put_line ( g_pkg_name

432:
433: IF ( p_print_pick_slip = 'Y'
434: AND (g_fully_allocated OR g_partially_allocated) ) THEN
435: IF g_debug <= gme_debug.g_log_statement THEN
436: gme_debug.put_line ( g_pkg_name
437: || '.'
438: || l_api_name
439: || ':Calling print picklsip');
440: END IF;

Line 457: IF g_debug <= gme_debug.g_log_statement THEN

453: ,p_organization_id => p_mtl_req_tbl (1).organization_id
454: ,p_mo_request_number => l_move_order_header_id
455: ,p_plan_tasks => l_plan_tasks);
456:
457: IF g_debug <= gme_debug.g_log_statement THEN
458: gme_debug.put_line ( g_pkg_name
459: || '.'
460: || l_api_name
461: || ':Print picklsip returns '

Line 458: gme_debug.put_line ( g_pkg_name

454: ,p_mo_request_number => l_move_order_header_id
455: ,p_plan_tasks => l_plan_tasks);
456:
457: IF g_debug <= gme_debug.g_log_statement THEN
458: gme_debug.put_line ( g_pkg_name
459: || '.'
460: || l_api_name
461: || ':Print picklsip returns '
462: || l_return_status);

Line 463: gme_debug.put_line ( g_pkg_name

459: || '.'
460: || l_api_name
461: || ':Print picklsip returns '
462: || l_return_status);
463: gme_debug.put_line ( g_pkg_name
464: || '.'
465: || l_api_name
466: || ':Print picklsip message '
467: || l_msg_data);

Line 483: IF g_debug <= gme_debug.g_log_unexpected THEN

479: ,p_token1_name => 'MO_NUMBER'
480: ,p_token1_value => l_move_order_header_id
481: ,p_token2_name => 'CONC_REQUEST_ID'
482: ,p_token2_value => l_conc_req_id);
483: IF g_debug <= gme_debug.g_log_unexpected THEN
484: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
485: END IF;
486: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
487: gme_common_pvt.log_message

Line 484: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));

480: ,p_token1_value => l_move_order_header_id
481: ,p_token2_name => 'CONC_REQUEST_ID'
482: ,p_token2_value => l_conc_req_id);
483: IF g_debug <= gme_debug.g_log_unexpected THEN
484: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
485: END IF;
486: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
487: gme_common_pvt.log_message
488: (p_message_code => 'GME_PICKED_PARTIAL_PRINTED'

Line 493: IF g_debug <= gme_debug.g_log_unexpected THEN

489: ,p_token1_name => 'MO_NUMBER'
490: ,p_token1_value => l_move_order_header_id
491: ,p_token2_name => 'CONC_REQUEST_ID'
492: ,p_token2_value => l_conc_req_id);
493: IF g_debug <= gme_debug.g_log_unexpected THEN
494: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
495: END IF;
496: END IF;
497: ELSE

Line 494: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));

490: ,p_token1_value => l_move_order_header_id
491: ,p_token2_name => 'CONC_REQUEST_ID'
492: ,p_token2_value => l_conc_req_id);
493: IF g_debug <= gme_debug.g_log_unexpected THEN
494: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
495: END IF;
496: END IF;
497: ELSE
498: IF (NOT (g_partially_allocated) AND NOT (g_not_allocated) ) THEN

Line 503: IF g_debug <= gme_debug.g_log_unexpected THEN

499: gme_common_pvt.log_message
500: (p_message_code => 'GME_PICKED_ALL'
501: ,p_token1_name => 'MO_NUMBER'
502: ,p_token1_value => l_move_order_header_id);
503: IF g_debug <= gme_debug.g_log_unexpected THEN
504: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
505: END IF;
506: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
507: gme_common_pvt.log_message

Line 504: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));

500: (p_message_code => 'GME_PICKED_ALL'
501: ,p_token1_name => 'MO_NUMBER'
502: ,p_token1_value => l_move_order_header_id);
503: IF g_debug <= gme_debug.g_log_unexpected THEN
504: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
505: END IF;
506: ELSIF (g_partially_allocated OR g_fully_allocated) THEN
507: gme_common_pvt.log_message
508: (p_message_code => 'GME_PICKED_PARTIAL'

Line 511: IF g_debug <= gme_debug.g_log_unexpected THEN

507: gme_common_pvt.log_message
508: (p_message_code => 'GME_PICKED_PARTIAL'
509: ,p_token1_name => 'MO_NUMBER'
510: ,p_token1_value => l_move_order_header_id);
511: IF g_debug <= gme_debug.g_log_unexpected THEN
512: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
513: END IF;
514: ELSIF (NOT (g_partially_allocated) AND NOT (g_fully_allocated) ) THEN
515: gme_common_pvt.log_message

Line 512: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));

508: (p_message_code => 'GME_PICKED_PARTIAL'
509: ,p_token1_name => 'MO_NUMBER'
510: ,p_token1_value => l_move_order_header_id);
511: IF g_debug <= gme_debug.g_log_unexpected THEN
512: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
513: END IF;
514: ELSIF (NOT (g_partially_allocated) AND NOT (g_fully_allocated) ) THEN
515: gme_common_pvt.log_message
516: (p_message_code => 'GME_PICKED_NO_ALLOC'

Line 519: IF g_debug <= gme_debug.g_log_unexpected THEN

515: gme_common_pvt.log_message
516: (p_message_code => 'GME_PICKED_NO_ALLOC'
517: ,p_token1_name => 'MO_NUMBER'
518: ,p_token1_value => l_move_order_header_id);
519: IF g_debug <= gme_debug.g_log_unexpected THEN
520: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
521: END IF;
522: END IF;
523: END IF;

Line 520: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));

516: (p_message_code => 'GME_PICKED_NO_ALLOC'
517: ,p_token1_name => 'MO_NUMBER'
518: ,p_token1_value => l_move_order_header_id);
519: IF g_debug <= gme_debug.g_log_unexpected THEN
520: gme_debug.put_line(fnd_msg_pub.get(FND_MSG_PUB.G_LAST, 'F'));
521: END IF;
522: END IF;
523: END IF;
524:

Line 525: IF g_debug <= gme_debug.g_log_procedure THEN

521: END IF;
522: END IF;
523: END IF;
524:
525: IF g_debug <= gme_debug.g_log_procedure THEN
526: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
527: END IF;
528: EXCEPTION
529: WHEN no_materials_picked THEN

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

522: END IF;
523: END IF;
524:
525: IF g_debug <= gme_debug.g_log_procedure THEN
526: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
527: END IF;
528: EXCEPTION
529: WHEN no_materials_picked THEN
530: --Bug#5311713

Line 542: IF g_debug <= gme_debug.g_log_unexpected THEN

538: x_return_status := l_return_status;
539: WHEN OTHERS THEN
540: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
541:
542: IF g_debug <= gme_debug.g_log_unexpected THEN
543: gme_debug.put_line ( 'When others exception in '
544: || g_pkg_name
545: || '.'
546: || l_api_name

Line 543: gme_debug.put_line ( 'When others exception in '

539: WHEN OTHERS THEN
540: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
541:
542: IF g_debug <= gme_debug.g_log_unexpected THEN
543: gme_debug.put_line ( 'When others exception in '
544: || g_pkg_name
545: || '.'
546: || l_api_name
547: || ' Error is '

Line 591: IF g_debug <= gme_debug.g_log_procedure THEN

587: l_inv_resv_tbl inv_reservation_global.mtl_reservation_tbl_type;
588: create_suggestions_err EXCEPTION;
589: get_pick_slip_err EXCEPTION;
590: BEGIN
591: IF g_debug <= gme_debug.g_log_procedure THEN
592: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
593: || l_api_name);
594: END IF;
595:

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

588: create_suggestions_err EXCEPTION;
589: get_pick_slip_err EXCEPTION;
590: BEGIN
591: IF g_debug <= gme_debug.g_log_procedure THEN
592: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
593: || l_api_name);
594: END IF;
595:
596: x_return_status := fnd_api.g_ret_sts_success;

Line 604: IF g_debug <= gme_debug.g_log_statement THEN

600: ,p_material_detail_id => p_mo_line_rec.txn_source_line_id
601: ,x_return_status => l_return_status
602: ,x_reservations_tbl => l_resv_tbl);
603:
604: IF g_debug <= gme_debug.g_log_statement THEN
605: gme_debug.put_line ( g_pkg_name
606: || '.'
607: || l_api_name
608: || ':No. of reservations is '

Line 605: gme_debug.put_line ( g_pkg_name

601: ,x_return_status => l_return_status
602: ,x_reservations_tbl => l_resv_tbl);
603:
604: IF g_debug <= gme_debug.g_log_statement THEN
605: gme_debug.put_line ( g_pkg_name
606: || '.'
607: || l_api_name
608: || ':No. of reservations is '
609: || l_resv_tbl.COUNT);

Line 661: IF g_debug <= gme_debug.g_log_statement THEN

657: l_inv_resv_tbl (l_count).lpn_id := l_resv_tbl (i).lpn_id;
658: END IF;
659: END LOOP;
660:
661: IF g_debug <= gme_debug.g_log_statement THEN
662: gme_debug.put_line
663: ( g_pkg_name
664: || '.'
665: || l_api_name

Line 662: gme_debug.put_line

658: END IF;
659: END LOOP;
660:
661: IF g_debug <= gme_debug.g_log_statement THEN
662: gme_debug.put_line
663: ( g_pkg_name
664: || '.'
665: || l_api_name
666: || ':No. of reservations passed to create suggestions is '

Line 692: IF g_debug <= gme_debug.g_log_statement THEN

688: ,p_simulation_id => NULL
689: ,p_plan_tasks => l_plan_tasks
690: ,p_quick_pick_flag => 'N');
691:
692: IF g_debug <= gme_debug.g_log_statement THEN
693: gme_debug.put_line ( g_pkg_name
694: || '.'
695: || l_api_name
696: || 'create suggestions returns '

Line 693: gme_debug.put_line ( g_pkg_name

689: ,p_plan_tasks => l_plan_tasks
690: ,p_quick_pick_flag => 'N');
691:
692: IF g_debug <= gme_debug.g_log_statement THEN
693: gme_debug.put_line ( g_pkg_name
694: || '.'
695: || l_api_name
696: || 'create suggestions returns '
697: || l_return_status);

Line 698: gme_debug.put_line ( g_pkg_name

694: || '.'
695: || l_api_name
696: || 'create suggestions returns '
697: || l_return_status);
698: gme_debug.put_line ( g_pkg_name
699: || '.'
700: || l_api_name
701: || 'create suggestions mesg '
702: || l_msg_data);

Line 716: IF g_debug <= gme_debug.g_log_statement THEN

712: INTO l_qty_detailed, l_sec_qty_detailed;
713:
714: CLOSE cur_detailed_qty;
715:
716: IF g_debug <= gme_debug.g_log_statement THEN
717: gme_debug.put_line ( g_pkg_name
718: || '.'
719: || l_api_name
720: || ':Qty allocated '

Line 717: gme_debug.put_line ( g_pkg_name

713:
714: CLOSE cur_detailed_qty;
715:
716: IF g_debug <= gme_debug.g_log_statement THEN
717: gme_debug.put_line ( g_pkg_name
718: || '.'
719: || l_api_name
720: || ':Qty allocated '
721: || l_qty_detailed);

Line 722: gme_debug.put_line ( g_pkg_name

718: || '.'
719: || l_api_name
720: || ':Qty allocated '
721: || l_qty_detailed);
722: gme_debug.put_line ( g_pkg_name
723: || '.'
724: || l_api_name
725: || ':Sec Qty allocated '
726: || l_sec_qty_detailed);

Line 732: IF g_debug <= gme_debug.g_log_statement THEN

728:
729: l_mo_line_rec := p_mo_line_rec;
730:
731: IF (NVL (l_qty_detailed, 0) > 0) THEN
732: IF g_debug <= gme_debug.g_log_statement THEN
733: gme_debug.put_line ( g_pkg_name
734: || '.'
735: || l_api_name
736: || ':Get mmtt recs and create pick slips ');

Line 733: gme_debug.put_line ( g_pkg_name

729: l_mo_line_rec := p_mo_line_rec;
730:
731: IF (NVL (l_qty_detailed, 0) > 0) THEN
732: IF g_debug <= gme_debug.g_log_statement THEN
733: gme_debug.put_line ( g_pkg_name
734: || '.'
735: || l_api_name
736: || ':Get mmtt recs and create pick slips ');
737: END IF;

Line 750: IF g_debug <= gme_debug.g_log_statement THEN

746: set detailed_quantity = get_mmtt.primary_quantity
747: where reservation_id = get_mmtt.reservation_id;
748: END IF;
749:
750: IF g_debug <= gme_debug.g_log_statement THEN
751: gme_debug.put_line(g_pkg_name || '.' || l_api_name
752: || ' Calling ASSIGNTT with temp id ' || get_mmtt.transaction_temp_id);
753: END IF;
754:

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

747: where reservation_id = get_mmtt.reservation_id;
748: END IF;
749:
750: IF g_debug <= gme_debug.g_log_statement THEN
751: gme_debug.put_line(g_pkg_name || '.' || l_api_name
752: || ' Calling ASSIGNTT with temp id ' || get_mmtt.transaction_temp_id);
753: END IF;
754:
755: -- Bug 6778259 - Assign user task properly.

Line 764: IF g_debug <= gme_debug.g_log_statement THEN

760: x_msg_count => l_msg_count,
761: x_msg_data => l_msg_data
762: );
763:
764: IF g_debug <= gme_debug.g_log_statement THEN
765: gme_debug.put_line(g_pkg_name || '.' || l_api_name
766: || ':Return from ASSIGNTT IS ' || l_return_status);
767:
768: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

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

761: x_msg_data => l_msg_data
762: );
763:
764: IF g_debug <= gme_debug.g_log_statement THEN
765: gme_debug.put_line(g_pkg_name || '.' || l_api_name
766: || ':Return from ASSIGNTT IS ' || l_return_status);
767:
768: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
769: gme_debug.put_line ( g_pkg_name

Line 769: gme_debug.put_line ( g_pkg_name

765: gme_debug.put_line(g_pkg_name || '.' || l_api_name
766: || ':Return from ASSIGNTT IS ' || l_return_status);
767:
768: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
769: gme_debug.put_line ( g_pkg_name
770: || '.'
771: || l_api_name
772: || 'temp_id is '
773: || get_mmtt.transaction_temp_id);

Line 774: gme_debug.put_line ( g_pkg_name

770: || '.'
771: || l_api_name
772: || 'temp_id is '
773: || get_mmtt.transaction_temp_id);
774: gme_debug.put_line ( g_pkg_name
775: || '.'
776: || l_api_name
777: || ':Message is '
778: || l_msg_data);

Line 788: IF g_debug <= gme_debug.g_log_statement THEN

784: RAISE get_pick_slip_err;
785: END IF;
786:
787: IF get_mmtt.pick_slip_number IS NULL THEN
788: IF g_debug <= gme_debug.g_log_statement THEN
789: gme_debug.put_line
790: ( g_pkg_name
791: || '.'
792: || l_api_name

Line 789: gme_debug.put_line

785: END IF;
786:
787: IF get_mmtt.pick_slip_number IS NULL THEN
788: IF g_debug <= gme_debug.g_log_statement THEN
789: gme_debug.put_line
790: ( g_pkg_name
791: || '.'
792: || l_api_name
793: || ':Calling inv_pr_pick_slip_number.get_pick_slip_number');

Line 817: IF g_debug <= gme_debug.g_log_statement THEN

813: ,x_pick_slip_number => l_pick_slip_number
814: ,x_api_status => l_return_status
815: ,x_error_message => l_msg_data);
816:
817: IF g_debug <= gme_debug.g_log_statement THEN
818: gme_debug.put_line
819: ( g_pkg_name
820: || '.'
821: || l_api_name

Line 818: gme_debug.put_line

814: ,x_api_status => l_return_status
815: ,x_error_message => l_msg_data);
816:
817: IF g_debug <= gme_debug.g_log_statement THEN
818: gme_debug.put_line
819: ( g_pkg_name
820: || '.'
821: || l_api_name
822: || ':Return from inv_pr_pick_slip_number.get_pick_slip_number '

Line 824: gme_debug.put_line ( g_pkg_name

820: || '.'
821: || l_api_name
822: || ':Return from inv_pr_pick_slip_number.get_pick_slip_number '
823: || l_return_status);
824: gme_debug.put_line ( g_pkg_name
825: || '.'
826: || l_api_name
827: || ':l_pick_slip_number is '
828: || l_pick_slip_number);

Line 829: gme_debug.put_line ( g_pkg_name

825: || '.'
826: || l_api_name
827: || ':l_pick_slip_number is '
828: || l_pick_slip_number);
829: gme_debug.put_line ( g_pkg_name
830: || '.'
831: || l_api_name
832: || ':Message is '
833: || l_msg_data);

Line 860: IF g_debug <= gme_debug.g_log_statement THEN

856: ELSE
857: g_fully_allocated := TRUE;
858: END IF;
859: ELSE
860: IF g_debug <= gme_debug.g_log_statement THEN
861: gme_debug.put_line ( g_pkg_name
862: || '.'
863: || l_api_name
864: || ':Close mo lines since no allocations');

Line 861: gme_debug.put_line ( g_pkg_name

857: g_fully_allocated := TRUE;
858: END IF;
859: ELSE
860: IF g_debug <= gme_debug.g_log_statement THEN
861: gme_debug.put_line ( g_pkg_name
862: || '.'
863: || l_api_name
864: || ':Close mo lines since no allocations');
865: END IF;

Line 872: IF g_debug <= gme_debug.g_log_statement THEN

868: l_mo_line_rec.line_status := 5;
869: g_not_allocated := TRUE;
870: END IF;
871:
872: IF g_debug <= gme_debug.g_log_statement THEN
873: gme_debug.put_line ( g_pkg_name
874: || '.'
875: || l_api_name
876: || 'Updating MO line');

Line 873: gme_debug.put_line ( g_pkg_name

869: g_not_allocated := TRUE;
870: END IF;
871:
872: IF g_debug <= gme_debug.g_log_statement THEN
873: gme_debug.put_line ( g_pkg_name
874: || '.'
875: || l_api_name
876: || 'Updating MO line');
877: END IF;

Line 881: IF g_debug <= gme_debug.g_log_statement THEN

877: END IF;
878:
879: inv_trolin_util.update_row (l_mo_line_rec);
880:
881: IF g_debug <= gme_debug.g_log_statement THEN
882: gme_debug.put_line ( g_pkg_name
883: || '.'
884: || l_api_name
885: || 'After Updating MO line');

Line 882: gme_debug.put_line ( g_pkg_name

878:
879: inv_trolin_util.update_row (l_mo_line_rec);
880:
881: IF g_debug <= gme_debug.g_log_statement THEN
882: gme_debug.put_line ( g_pkg_name
883: || '.'
884: || l_api_name
885: || 'After Updating MO line');
886: END IF;

Line 888: IF g_debug <= gme_debug.g_log_statement THEN

884: || l_api_name
885: || 'After Updating MO line');
886: END IF;
887:
888: IF g_debug <= gme_debug.g_log_statement THEN
889: gme_debug.put_line ( g_pkg_name
890: || '.'
891: || l_api_name
892: || 'l_backordered_qty = '

Line 889: gme_debug.put_line ( g_pkg_name

885: || 'After Updating MO line');
886: END IF;
887:
888: IF g_debug <= gme_debug.g_log_statement THEN
889: gme_debug.put_line ( g_pkg_name
890: || '.'
891: || l_api_name
892: || 'l_backordered_qty = '
893: || l_backordered_qty);

Line 902: IF g_debug <= gme_debug.g_log_procedure THEN

898: SET backordered_qty = l_backordered_qty
899: WHERE material_detail_id = p_mo_line_rec.txn_source_line_id;
900: END IF;
901:
902: IF g_debug <= gme_debug.g_log_procedure THEN
903: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
904: END IF;
905: EXCEPTION
906: WHEN create_suggestions_err OR get_pick_slip_err THEN

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

899: WHERE material_detail_id = p_mo_line_rec.txn_source_line_id;
900: END IF;
901:
902: IF g_debug <= gme_debug.g_log_procedure THEN
903: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
904: END IF;
905: EXCEPTION
906: WHEN create_suggestions_err OR get_pick_slip_err THEN
907: x_return_status := l_return_status;

Line 911: IF g_debug <= gme_debug.g_log_unexpected THEN

907: x_return_status := l_return_status;
908: WHEN OTHERS THEN
909: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
910:
911: IF g_debug <= gme_debug.g_log_unexpected THEN
912: gme_debug.put_line ( 'When others exception in '
913: || g_pkg_name
914: || '.'
915: || l_api_name

Line 912: gme_debug.put_line ( 'When others exception in '

908: WHEN OTHERS THEN
909: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
910:
911: IF g_debug <= gme_debug.g_log_unexpected THEN
912: gme_debug.put_line ( 'When others exception in '
913: || g_pkg_name
914: || '.'
915: || l_api_name
916: || ' Error is '