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

Line 58: IF g_debug <= gme_debug.g_log_procedure THEN

54: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
55: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
56: create_mo_hdr_err EXCEPTION;
57: BEGIN
58: IF g_debug <= gme_debug.g_log_procedure THEN
59: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
60: || l_api_name);
61: END IF;
62:

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

55: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
56: create_mo_hdr_err EXCEPTION;
57: BEGIN
58: IF g_debug <= gme_debug.g_log_procedure THEN
59: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
60: || l_api_name);
61: END IF;
62:
63: x_return_status := fnd_api.g_ret_sts_success;

Line 78: gme_debug.put_line

74: -- Bug 9941121 - Initialize grouping_rule_id properly.
75: l_in_trohdr_rec.grouping_rule_id := p_grouping_rule_id;
76:
77: IF (g_debug IS NOT NULL) THEN
78: gme_debug.put_line
79: ('Calling inv_move_order_pub.create_move_order_header');
80: END IF;
81:
82: inv_move_order_pub.create_move_order_header

Line 99: IF g_debug <= gme_debug.g_log_statement THEN

95:
96: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
97: RAISE create_mo_hdr_err;
98: ELSE
99: IF g_debug <= gme_debug.g_log_statement THEN
100: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);
101: gme_debug.put_line ( 'request_number is '
102: || l_out_trohdr_rec.request_number);
103: END IF;

Line 100: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);

96: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
97: RAISE create_mo_hdr_err;
98: ELSE
99: IF g_debug <= gme_debug.g_log_statement THEN
100: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);
101: gme_debug.put_line ( 'request_number is '
102: || l_out_trohdr_rec.request_number);
103: END IF;
104:

Line 101: gme_debug.put_line ( 'request_number is '

97: RAISE create_mo_hdr_err;
98: ELSE
99: IF g_debug <= gme_debug.g_log_statement THEN
100: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);
101: gme_debug.put_line ( 'request_number is '
102: || l_out_trohdr_rec.request_number);
103: END IF;
104:
105: x_move_order_header_id := l_out_trohdr_rec.header_id;

Line 108: IF g_debug <= gme_debug.g_log_procedure THEN

104:
105: x_move_order_header_id := l_out_trohdr_rec.header_id;
106: END IF;
107:
108: IF g_debug <= gme_debug.g_log_procedure THEN
109: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
110: END IF;
111: EXCEPTION
112: WHEN create_mo_hdr_err THEN

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

105: x_move_order_header_id := l_out_trohdr_rec.header_id;
106: END IF;
107:
108: IF g_debug <= gme_debug.g_log_procedure THEN
109: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
110: END IF;
111: EXCEPTION
112: WHEN create_mo_hdr_err THEN
113: IF (g_debug <= gme_debug.g_log_error) THEN

Line 113: IF (g_debug <= gme_debug.g_log_error) THEN

109: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
110: END IF;
111: EXCEPTION
112: WHEN create_mo_hdr_err THEN
113: IF (g_debug <= gme_debug.g_log_error) THEN
114: gme_debug.put_line
115: ( 'inv_move_order_pub.create_move_order_header returns '
116: || l_return_status);
117: gme_debug.put_line ('error message is ' || l_msg_data);

Line 114: gme_debug.put_line

110: END IF;
111: EXCEPTION
112: WHEN create_mo_hdr_err THEN
113: IF (g_debug <= gme_debug.g_log_error) THEN
114: gme_debug.put_line
115: ( 'inv_move_order_pub.create_move_order_header returns '
116: || l_return_status);
117: gme_debug.put_line ('error message is ' || l_msg_data);
118: END IF;

Line 117: gme_debug.put_line ('error message is ' || l_msg_data);

113: IF (g_debug <= gme_debug.g_log_error) THEN
114: gme_debug.put_line
115: ( 'inv_move_order_pub.create_move_order_header returns '
116: || l_return_status);
117: gme_debug.put_line ('error message is ' || l_msg_data);
118: END IF;
119:
120: x_return_status := l_return_status;
121: WHEN OTHERS THEN

Line 122: IF g_debug <= gme_debug.g_log_unexpected THEN

118: END IF;
119:
120: x_return_status := l_return_status;
121: WHEN OTHERS THEN
122: IF g_debug <= gme_debug.g_log_unexpected THEN
123: gme_debug.put_line ( 'When others exception in '
124: || g_pkg_name
125: || '.'
126: || l_api_name

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

119:
120: x_return_status := l_return_status;
121: WHEN OTHERS THEN
122: IF g_debug <= gme_debug.g_log_unexpected THEN
123: gme_debug.put_line ( 'When others exception in '
124: || g_pkg_name
125: || '.'
126: || l_api_name
127: || ' Error is '

Line 175: IF g_debug <= gme_debug.g_log_procedure THEN

171:
172: l_wms_enabled_flag VARCHAR2(1);
173:
174: BEGIN
175: IF g_debug <= gme_debug.g_log_procedure THEN
176: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
177: || l_api_name);
178: END IF;
179:

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

172: l_wms_enabled_flag VARCHAR2(1);
173:
174: BEGIN
175: IF g_debug <= gme_debug.g_log_procedure THEN
176: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
177: || l_api_name);
178: END IF;
179:
180: x_return_status := fnd_api.g_ret_sts_success;

Line 282: IF g_debug <= gme_debug.g_log_statement THEN

278: p_material_details_tbl (i);
279: END IF;
280: END LOOP;
281:
282: IF g_debug <= gme_debug.g_log_statement THEN
283: gme_debug.put_line
284: ( 'Calling inv_move_order_pub.create_move_order_lines with no. of lines = '
285: || l_in_trolin_tbl.COUNT);
286: END IF;

Line 283: gme_debug.put_line

279: END IF;
280: END LOOP;
281:
282: IF g_debug <= gme_debug.g_log_statement THEN
283: gme_debug.put_line
284: ( 'Calling inv_move_order_pub.create_move_order_lines with no. of lines = '
285: || l_in_trolin_tbl.COUNT);
286: END IF;
287: /* Bug 4866700 added check to call only if records are there in table */

Line 306: IF g_debug <= gme_debug.g_log_statement THEN

302:
303: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
304: RAISE create_mo_line_err;
305: ELSE
306: IF g_debug <= gme_debug.g_log_statement THEN
307: gme_debug.put_line ( 'No. of move order lines created = '
308: || x_trolin_tbl.COUNT);
309: END IF;
310:

Line 307: gme_debug.put_line ( 'No. of move order lines created = '

303: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
304: RAISE create_mo_line_err;
305: ELSE
306: IF g_debug <= gme_debug.g_log_statement THEN
307: gme_debug.put_line ( 'No. of move order lines created = '
308: || x_trolin_tbl.COUNT);
309: END IF;
310:
311: /* Populate out structure only for invisible move order */

Line 322: IF g_debug <= gme_debug.g_log_procedure THEN

318: END LOOP;
319: END IF;
320: END IF;
321: END IF;
322: IF g_debug <= gme_debug.g_log_procedure THEN
323: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
324: END IF;
325: EXCEPTION
326: WHEN create_mo_line_err THEN

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

319: END IF;
320: END IF;
321: END IF;
322: IF g_debug <= gme_debug.g_log_procedure THEN
323: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
324: END IF;
325: EXCEPTION
326: WHEN create_mo_line_err THEN
327: IF g_debug <= gme_debug.g_log_error THEN

Line 327: IF g_debug <= gme_debug.g_log_error THEN

323: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
324: END IF;
325: EXCEPTION
326: WHEN create_mo_line_err THEN
327: IF g_debug <= gme_debug.g_log_error THEN
328: gme_debug.put_line
329: ( 'inv_move_order_pub.create_move_order_lines returns '
330: || l_return_status);
331: gme_debug.put_line ('message count is ' || l_msg_count);

Line 328: gme_debug.put_line

324: END IF;
325: EXCEPTION
326: WHEN create_mo_line_err THEN
327: IF g_debug <= gme_debug.g_log_error THEN
328: gme_debug.put_line
329: ( 'inv_move_order_pub.create_move_order_lines returns '
330: || l_return_status);
331: gme_debug.put_line ('message count is ' || l_msg_count);
332:

Line 331: gme_debug.put_line ('message count is ' || l_msg_count);

327: IF g_debug <= gme_debug.g_log_error THEN
328: gme_debug.put_line
329: ( 'inv_move_order_pub.create_move_order_lines returns '
330: || l_return_status);
331: gme_debug.put_line ('message count is ' || l_msg_count);
332:
333: FOR i IN 1 .. l_msg_count LOOP
334: l_msg_data :=
335: fnd_msg_pub.get (p_msg_index => i

Line 337: gme_debug.put_line ('error message is ' || l_msg_data);

333: FOR i IN 1 .. l_msg_count LOOP
334: l_msg_data :=
335: fnd_msg_pub.get (p_msg_index => i
336: ,p_encoded => 'T');
337: gme_debug.put_line ('error message is ' || l_msg_data);
338: END LOOP;
339: END IF;
340:
341: x_return_status := l_return_status;

Line 343: IF g_debug <= gme_debug.g_log_unexpected THEN

339: END IF;
340:
341: x_return_status := l_return_status;
342: WHEN OTHERS THEN
343: IF g_debug <= gme_debug.g_log_unexpected THEN
344: gme_debug.put_line ( 'When others exception in '
345: || g_pkg_name
346: || '.'
347: || l_api_name

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

340:
341: x_return_status := l_return_status;
342: WHEN OTHERS THEN
343: IF g_debug <= gme_debug.g_log_unexpected THEN
344: gme_debug.put_line ( 'When others exception in '
345: || g_pkg_name
346: || '.'
347: || l_api_name
348: || ' Error is '

Line 405: IF g_debug <= gme_debug.g_log_procedure THEN

401: create_mo_err EXCEPTION;
402: uom_conversion_err EXCEPTION;
403: unable_to_query_tree EXCEPTION;
404: BEGIN
405: IF g_debug <= gme_debug.g_log_procedure THEN
406: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
407: || l_api_name);
408: END IF;
409:

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

402: uom_conversion_err EXCEPTION;
403: unable_to_query_tree EXCEPTION;
404: BEGIN
405: IF g_debug <= gme_debug.g_log_procedure THEN
406: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
407: || l_api_name);
408: END IF;
409:
410: x_return_status := fnd_api.g_ret_sts_success;

Line 413: IF g_debug <= gme_debug.g_log_procedure THEN

409:
410: x_return_status := fnd_api.g_ret_sts_success;
411: FOR i IN 1 .. p_material_details_tbl.COUNT LOOP
412:
413: IF g_debug <= gme_debug.g_log_procedure THEN
414: gme_debug.put_line ('Iteration of loop is '||i);
415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);
416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);
417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));

Line 414: gme_debug.put_line ('Iteration of loop is '||i);

410: x_return_status := fnd_api.g_ret_sts_success;
411: FOR i IN 1 .. p_material_details_tbl.COUNT LOOP
412:
413: IF g_debug <= gme_debug.g_log_procedure THEN
414: gme_debug.put_line ('Iteration of loop is '||i);
415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);
416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);
417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));
418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));

Line 415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);

411: FOR i IN 1 .. p_material_details_tbl.COUNT LOOP
412:
413: IF g_debug <= gme_debug.g_log_procedure THEN
414: gme_debug.put_line ('Iteration of loop is '||i);
415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);
416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);
417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));
418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));
419: END IF;

Line 416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);

412:
413: IF g_debug <= gme_debug.g_log_procedure THEN
414: gme_debug.put_line ('Iteration of loop is '||i);
415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);
416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);
417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));
418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));
419: END IF;
420:

Line 417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));

413: IF g_debug <= gme_debug.g_log_procedure THEN
414: gme_debug.put_line ('Iteration of loop is '||i);
415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);
416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);
417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));
418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));
419: END IF;
420:
421: IF ( p_material_details_tbl (i).line_type = -1

Line 418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));

414: gme_debug.put_line ('Iteration of loop is '||i);
415: gme_debug.put_line ('line_type is '||p_material_details_tbl (i).line_type);
416: gme_debug.put_line ('subinventory is '||p_material_details_tbl (i).subinventory);
417: gme_debug.put_line ('material_requirement_date is '||TO_CHAR(p_material_details_tbl (i).material_requirement_date,'DD-MON-YYYY HH24:MI:SS'));
418: gme_debug.put_line ('g_move_order_timefence is '||NVL(gme_common_pvt.g_move_order_timefence, 99999));
419: END IF;
420:
421: IF ( p_material_details_tbl (i).line_type = -1
422: AND p_material_details_tbl (i).subinventory IS NOT NULL

Line 425: IF g_debug <= gme_debug.g_log_procedure THEN

421: IF ( p_material_details_tbl (i).line_type = -1
422: AND p_material_details_tbl (i).subinventory IS NOT NULL
423: AND p_material_details_tbl (i).material_requirement_date <
424: (SYSDATE + NVL (gme_common_pvt.g_move_order_timefence, 0) ) ) THEN
425: IF g_debug <= gme_debug.g_log_procedure THEN
426: gme_debug.put_line ('point 1');
427: END IF;
428:
429: OPEN cur_get_item_info

Line 426: gme_debug.put_line ('point 1');

422: AND p_material_details_tbl (i).subinventory IS NOT NULL
423: AND p_material_details_tbl (i).material_requirement_date <
424: (SYSDATE + NVL (gme_common_pvt.g_move_order_timefence, 0) ) ) THEN
425: IF g_debug <= gme_debug.g_log_procedure THEN
426: gme_debug.put_line ('point 1');
427: END IF;
428:
429: OPEN cur_get_item_info
430: (p_material_details_tbl (i).organization_id

Line 471: IF g_debug <= gme_debug.g_log_statement THEN

467: ,x_sqs => l_sqs
468: ,x_satt => l_satt
469: ,x_satr => l_satr);
470: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
471: IF g_debug <= gme_debug.g_log_statement THEN
472: gme_debug.put_line ( 'item = '
473: || l_concatenated_segments);
474: gme_debug.put_line
475: ( 'subinventory = '

Line 472: gme_debug.put_line ( 'item = '

468: ,x_satt => l_satt
469: ,x_satr => l_satr);
470: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
471: IF g_debug <= gme_debug.g_log_statement THEN
472: gme_debug.put_line ( 'item = '
473: || l_concatenated_segments);
474: gme_debug.put_line
475: ( 'subinventory = '
476: || p_material_details_tbl (i).subinventory);

Line 474: gme_debug.put_line

470: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
471: IF g_debug <= gme_debug.g_log_statement THEN
472: gme_debug.put_line ( 'item = '
473: || l_concatenated_segments);
474: gme_debug.put_line
475: ( 'subinventory = '
476: || p_material_details_tbl (i).subinventory);
477: gme_debug.put_line ('l_att = ' || l_att);
478: END IF;

Line 477: gme_debug.put_line ('l_att = ' || l_att);

473: || l_concatenated_segments);
474: gme_debug.put_line
475: ( 'subinventory = '
476: || p_material_details_tbl (i).subinventory);
477: gme_debug.put_line ('l_att = ' || l_att);
478: END IF;
479: IF (l_primary_uom_code <>
480: p_material_details_tbl (i).dtl_um) THEN
481: l_plan_qty_prim :=

Line 555: IF g_debug <= gme_debug.g_log_procedure THEN

551: END IF;
552: END IF;
553: END IF;
554:
555: IF g_debug <= gme_debug.g_log_procedure THEN
556: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
557: END IF;
558: EXCEPTION
559: WHEN create_mo_err OR unable_to_query_tree THEN

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

552: END IF;
553: END IF;
554:
555: IF g_debug <= gme_debug.g_log_procedure THEN
556: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
557: END IF;
558: EXCEPTION
559: WHEN create_mo_err OR unable_to_query_tree THEN
560: x_return_status := l_return_status;

Line 568: IF g_debug <= gme_debug.g_log_unexpected THEN

564: fnd_message.set_token ('ITEM_NO', l_item_no);
565: fnd_message.set_token ('FROM_UOM', l_from_uom);
566: fnd_message.set_token ('TO_UOM', l_to_uom);
567: WHEN OTHERS THEN
568: IF g_debug <= gme_debug.g_log_unexpected THEN
569: gme_debug.put_line ( 'When others exception in '
570: || g_pkg_name
571: || '.'
572: || l_api_name

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

565: fnd_message.set_token ('FROM_UOM', l_from_uom);
566: fnd_message.set_token ('TO_UOM', l_to_uom);
567: WHEN OTHERS THEN
568: IF g_debug <= gme_debug.g_log_unexpected THEN
569: gme_debug.put_line ( 'When others exception in '
570: || g_pkg_name
571: || '.'
572: || l_api_name
573: || ' Error is '

Line 606: IF g_debug <= gme_debug.g_log_procedure THEN

602: (gme_common_pvt.g_invis_move_order_type
603: ,inv_globals.g_move_order_put_away)
604: ORDER BY l.header_id, l.line_id;
605: BEGIN
606: IF g_debug <= gme_debug.g_log_procedure THEN
607: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
608: || l_api_name);
609: END IF;
610:

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

603: ,inv_globals.g_move_order_put_away)
604: ORDER BY l.header_id, l.line_id;
605: BEGIN
606: IF g_debug <= gme_debug.g_log_procedure THEN
607: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
608: || l_api_name);
609: END IF;
610:
611: x_return_status := fnd_api.g_ret_sts_success;

Line 620: IF g_debug <= gme_debug.g_log_procedure THEN

616: BULK COLLECT INTO x_mo_line_tbl;
617:
618: CLOSE cur_move_order_lines;
619:
620: IF g_debug <= gme_debug.g_log_procedure THEN
621: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name||' No of lines '||x_mo_line_tbl.count);
622: END IF;
623: EXCEPTION
624: WHEN OTHERS THEN

Line 621: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name||' No of lines '||x_mo_line_tbl.count);

617:
618: CLOSE cur_move_order_lines;
619:
620: IF g_debug <= gme_debug.g_log_procedure THEN
621: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name||' No of lines '||x_mo_line_tbl.count);
622: END IF;
623: EXCEPTION
624: WHEN OTHERS THEN
625: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 625: IF g_debug <= gme_debug.g_log_unexpected THEN

621: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name||' No of lines '||x_mo_line_tbl.count);
622: END IF;
623: EXCEPTION
624: WHEN OTHERS THEN
625: IF g_debug <= gme_debug.g_log_unexpected THEN
626: gme_debug.put_line ( 'When others exception in '
627: || g_pkg_name
628: || '.'
629: || l_api_name

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

622: END IF;
623: EXCEPTION
624: WHEN OTHERS THEN
625: IF g_debug <= gme_debug.g_log_unexpected THEN
626: gme_debug.put_line ( 'When others exception in '
627: || g_pkg_name
628: || '.'
629: || l_api_name
630: || ' Error is '

Line 671: IF g_debug <= gme_debug.g_log_procedure THEN

667: SELECT COUNT (1)
668: FROM mtl_txn_request_lines
669: WHERE header_id = v_header_id;
670: BEGIN
671: IF g_debug <= gme_debug.g_log_procedure THEN
672: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
673: || l_api_name);
674: END IF;
675:

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

668: FROM mtl_txn_request_lines
669: WHERE header_id = v_header_id;
670: BEGIN
671: IF g_debug <= gme_debug.g_log_procedure THEN
672: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
673: || l_api_name);
674: END IF;
675:
676: x_return_status := fnd_api.g_ret_sts_success;

Line 702: IF (g_debug <= gme_debug.g_log_statement) THEN

698: l_trolin_tbl (l_row).header_id := p_invis_move_header_id;
699: END IF;
700:
701: IF (l_trolin_tbl.count = 0) THEN
702: IF (g_debug <= gme_debug.g_log_statement) THEN
703: gme_debug.put_line('No move order lines to delete');
704: END IF;
705: RETURN;
706: END IF;

Line 703: gme_debug.put_line('No move order lines to delete');

699: END IF;
700:
701: IF (l_trolin_tbl.count = 0) THEN
702: IF (g_debug <= gme_debug.g_log_statement) THEN
703: gme_debug.put_line('No move order lines to delete');
704: END IF;
705: RETURN;
706: END IF;
707: IF (g_debug <= gme_debug.g_log_statement) THEN

Line 707: IF (g_debug <= gme_debug.g_log_statement) THEN

703: gme_debug.put_line('No move order lines to delete');
704: END IF;
705: RETURN;
706: END IF;
707: IF (g_debug <= gme_debug.g_log_statement) THEN
708: gme_debug.put_line
709: ( 'Calling inv_move_order_pub.process_move_order_line in '
710: || l_api_name);
711: END IF;

Line 708: gme_debug.put_line

704: END IF;
705: RETURN;
706: END IF;
707: IF (g_debug <= gme_debug.g_log_statement) THEN
708: gme_debug.put_line
709: ( 'Calling inv_move_order_pub.process_move_order_line in '
710: || l_api_name);
711: END IF;
712:

Line 745: IF (g_debug <= gme_debug.g_log_statement) THEN

741: IF (l_count = 0) THEN
742: l_trohdr_rec.header_id := l_trolin_tbl (i).header_id;
743: l_trohdr_rec.operation := inv_globals.g_opr_delete;
744:
745: IF (g_debug <= gme_debug.g_log_statement) THEN
746: gme_debug.put_line
747: ( 'Calling inv_move_order_pub.process_move_order in '
748: || l_api_name);
749: END IF;

Line 746: gme_debug.put_line

742: l_trohdr_rec.header_id := l_trolin_tbl (i).header_id;
743: l_trohdr_rec.operation := inv_globals.g_opr_delete;
744:
745: IF (g_debug <= gme_debug.g_log_statement) THEN
746: gme_debug.put_line
747: ( 'Calling inv_move_order_pub.process_move_order in '
748: || l_api_name);
749: END IF;
750:

Line 773: IF g_debug <= gme_debug.g_log_procedure THEN

769: END IF;
770: END IF;
771: END LOOP;
772:
773: IF g_debug <= gme_debug.g_log_procedure THEN
774: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
775: END IF;
776: EXCEPTION
777: WHEN get_mo_line_err THEN

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

770: END IF;
771: END LOOP;
772:
773: IF g_debug <= gme_debug.g_log_procedure THEN
774: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
775: END IF;
776: EXCEPTION
777: WHEN get_mo_line_err THEN
778: x_return_status := l_return_status;

Line 781: gme_debug.put_line

777: WHEN get_mo_line_err THEN
778: x_return_status := l_return_status;
779: WHEN delete_mo_line_err THEN
780: IF (g_debug IS NOT NULL) THEN
781: gme_debug.put_line
782: ( 'inv_move_order_pub.process_move_order_line returns '
783: || l_return_status);
784: gme_debug.put_line ('error message is ' || l_msg_data);
785: END IF;

Line 784: gme_debug.put_line ('error message is ' || l_msg_data);

780: IF (g_debug IS NOT NULL) THEN
781: gme_debug.put_line
782: ( 'inv_move_order_pub.process_move_order_line returns '
783: || l_return_status);
784: gme_debug.put_line ('error message is ' || l_msg_data);
785: END IF;
786:
787: x_return_status := l_return_status;
788: WHEN delete_mo_hdr_err THEN

Line 790: gme_debug.put_line

786:
787: x_return_status := l_return_status;
788: WHEN delete_mo_hdr_err THEN
789: IF (g_debug IS NOT NULL) THEN
790: gme_debug.put_line
791: ( 'inv_move_order_pub.process_move_order returns '
792: || l_return_status);
793: gme_debug.put_line ('error message is ' || l_msg_data);
794: END IF;

Line 793: gme_debug.put_line ('error message is ' || l_msg_data);

789: IF (g_debug IS NOT NULL) THEN
790: gme_debug.put_line
791: ( 'inv_move_order_pub.process_move_order returns '
792: || l_return_status);
793: gme_debug.put_line ('error message is ' || l_msg_data);
794: END IF;
795:
796: x_return_status := l_return_status;
797: WHEN OTHERS THEN

Line 798: IF g_debug <= gme_debug.g_log_unexpected THEN

794: END IF;
795:
796: x_return_status := l_return_status;
797: WHEN OTHERS THEN
798: IF g_debug <= gme_debug.g_log_unexpected THEN
799: gme_debug.put_line ( 'When others exception in '
800: || g_pkg_name
801: || '.'
802: || l_api_name

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

795:
796: x_return_status := l_return_status;
797: WHEN OTHERS THEN
798: IF g_debug <= gme_debug.g_log_unexpected THEN
799: gme_debug.put_line ( 'When others exception in '
800: || g_pkg_name
801: || '.'
802: || l_api_name
803: || ' Error is '

Line 872: IF g_debug <= gme_debug.g_log_procedure THEN

868: from gme_material_details
869: where material_detail_id = p_material_detail_id;
870: l_line_uom VARCHAR2(4);
871: BEGIN
872: IF g_debug <= gme_debug.g_log_procedure THEN
873: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
874: || l_api_name);
875: END IF;
876:

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

869: where material_detail_id = p_material_detail_id;
870: l_line_uom VARCHAR2(4);
871: BEGIN
872: IF g_debug <= gme_debug.g_log_procedure THEN
873: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
874: || l_api_name);
875: END IF;
876:
877: x_return_status := fnd_api.g_ret_sts_success;

Line 1095: gme_debug.put_line

1091: END IF;
1092: END IF;
1093:
1094: IF (g_debug IS NOT NULL) THEN
1095: gme_debug.put_line
1096: ( 'Calling inv_move_order_pub.process_move_order_line in '
1097: || l_api_name);
1098: END IF;
1099:

Line 1116: IF g_debug <= gme_debug.g_log_procedure THEN

1112: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1113: RAISE process_mo_line_err;
1114: END IF;
1115:
1116: IF g_debug <= gme_debug.g_log_procedure THEN
1117: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1118: END IF;
1119: EXCEPTION
1120: WHEN process_mo_line_err THEN

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

1113: RAISE process_mo_line_err;
1114: END IF;
1115:
1116: IF g_debug <= gme_debug.g_log_procedure THEN
1117: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1118: END IF;
1119: EXCEPTION
1120: WHEN process_mo_line_err THEN
1121: IF (g_debug IS NOT NULL) THEN

Line 1122: gme_debug.put_line

1118: END IF;
1119: EXCEPTION
1120: WHEN process_mo_line_err THEN
1121: IF (g_debug IS NOT NULL) THEN
1122: gme_debug.put_line
1123: ( 'inv_move_order_pub.process_move_order_line returns '
1124: || l_return_status);
1125: gme_debug.put_line ('error message is ' || l_msg_data);
1126: END IF;

Line 1125: gme_debug.put_line ('error message is ' || l_msg_data);

1121: IF (g_debug IS NOT NULL) THEN
1122: gme_debug.put_line
1123: ( 'inv_move_order_pub.process_move_order_line returns '
1124: || l_return_status);
1125: gme_debug.put_line ('error message is ' || l_msg_data);
1126: END IF;
1127:
1128: x_return_status := l_return_status;
1129: WHEN OTHERS THEN

Line 1130: IF g_debug <= gme_debug.g_log_unexpected THEN

1126: END IF;
1127:
1128: x_return_status := l_return_status;
1129: WHEN OTHERS THEN
1130: IF g_debug <= gme_debug.g_log_unexpected THEN
1131: gme_debug.put_line ( 'When others exception in '
1132: || g_pkg_name
1133: || '.'
1134: || l_api_name

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

1127:
1128: x_return_status := l_return_status;
1129: WHEN OTHERS THEN
1130: IF g_debug <= gme_debug.g_log_unexpected THEN
1131: gme_debug.put_line ( 'When others exception in '
1132: || g_pkg_name
1133: || '.'
1134: || l_api_name
1135: || ' Error is '

Line 1168: IF g_debug <= gme_debug.g_log_procedure THEN

1164: AND h.header_id = l.header_id
1165: AND h.move_order_type = gme_common_pvt.g_move_order_type
1166: AND ROWNUM = 1;
1167: BEGIN
1168: IF g_debug <= gme_debug.g_log_procedure THEN
1169: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1170: || l_api_name);
1171: END IF;
1172:

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

1165: AND h.move_order_type = gme_common_pvt.g_move_order_type
1166: AND ROWNUM = 1;
1167: BEGIN
1168: IF g_debug <= gme_debug.g_log_procedure THEN
1169: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1170: || l_api_name);
1171: END IF;
1172:
1173: OPEN cur_move_order_lines;

Line 1184: IF g_debug <= gme_debug.g_log_procedure THEN

1180: END IF;
1181:
1182: CLOSE cur_move_order_lines;
1183:
1184: IF g_debug <= gme_debug.g_log_procedure THEN
1185: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1186: END IF;
1187:
1188: RETURN l_exists;

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

1181:
1182: CLOSE cur_move_order_lines;
1183:
1184: IF g_debug <= gme_debug.g_log_procedure THEN
1185: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1186: END IF;
1187:
1188: RETURN l_exists;
1189: EXCEPTION

Line 1191: IF g_debug <= gme_debug.g_log_unexpected THEN

1187:
1188: RETURN l_exists;
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF g_debug <= gme_debug.g_log_unexpected THEN
1192: gme_debug.put_line ( 'When others exception in '
1193: || g_pkg_name
1194: || '.'
1195: || l_api_name

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

1188: RETURN l_exists;
1189: EXCEPTION
1190: WHEN OTHERS THEN
1191: IF g_debug <= gme_debug.g_log_unexpected THEN
1192: gme_debug.put_line ( 'When others exception in '
1193: || g_pkg_name
1194: || '.'
1195: || l_api_name
1196: || ' Error is '

Line 1229: IF g_debug <= gme_debug.g_log_procedure THEN

1225:
1226: get_mo_line_err EXCEPTION;
1227: uom_conv_error EXCEPTION;
1228: BEGIN
1229: IF g_debug <= gme_debug.g_log_procedure THEN
1230: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1231: || l_api_name);
1232: END IF;
1233:

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

1226: get_mo_line_err EXCEPTION;
1227: uom_conv_error EXCEPTION;
1228: BEGIN
1229: IF g_debug <= gme_debug.g_log_procedure THEN
1230: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1231: || l_api_name);
1232: END IF;
1233:
1234: x_return_status := fnd_api.g_ret_sts_success;

Line 1288: IF g_debug <= gme_debug.g_log_procedure THEN

1284:
1285: x_pending_qty := NVL (x_pending_qty, 0) + l_temp_qty;
1286: END LOOP;
1287:
1288: IF g_debug <= gme_debug.g_log_procedure THEN
1289: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1290: END IF;
1291: EXCEPTION
1292: WHEN uom_conv_error THEN

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

1285: x_pending_qty := NVL (x_pending_qty, 0) + l_temp_qty;
1286: END LOOP;
1287:
1288: IF g_debug <= gme_debug.g_log_procedure THEN
1289: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1290: END IF;
1291: EXCEPTION
1292: WHEN uom_conv_error THEN
1293: x_return_status := fnd_api.g_ret_sts_error;

Line 1302: IF g_debug <= gme_debug.g_log_unexpected THEN

1298: fnd_msg_pub.ADD;
1299: WHEN get_mo_line_err THEN
1300: x_return_status := l_return_status;
1301: WHEN OTHERS THEN
1302: IF g_debug <= gme_debug.g_log_unexpected THEN
1303: gme_debug.put_line ( 'When others exception in '
1304: || g_pkg_name
1305: || '.'
1306: || l_api_name

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

1299: WHEN get_mo_line_err THEN
1300: x_return_status := l_return_status;
1301: WHEN OTHERS THEN
1302: IF g_debug <= gme_debug.g_log_unexpected THEN
1303: gme_debug.put_line ( 'When others exception in '
1304: || g_pkg_name
1305: || '.'
1306: || l_api_name
1307: || ' Error is '

Line 1342: IF g_debug <= gme_debug.g_log_procedure THEN

1338: l_invis_header_id NUMBER;
1339: l_return_status VARCHAR2 (1);
1340: del_mo_lines_err EXCEPTION;
1341: BEGIN
1342: IF g_debug <= gme_debug.g_log_procedure THEN
1343: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1344: || l_api_name);
1345: END IF;
1346:

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

1339: l_return_status VARCHAR2 (1);
1340: del_mo_lines_err EXCEPTION;
1341: BEGIN
1342: IF g_debug <= gme_debug.g_log_procedure THEN
1343: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1344: || l_api_name);
1345: END IF;
1346:
1347: x_return_status := fnd_api.g_ret_sts_success;

Line 1375: IF g_debug <= gme_debug.g_log_procedure THEN

1371: RAISE del_mo_lines_err;
1372: END IF;
1373: END LOOP;
1374:
1375: IF g_debug <= gme_debug.g_log_procedure THEN
1376: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1377: END IF;
1378: EXCEPTION
1379: WHEN del_mo_lines_err THEN

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

1372: END IF;
1373: END LOOP;
1374:
1375: IF g_debug <= gme_debug.g_log_procedure THEN
1376: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1377: END IF;
1378: EXCEPTION
1379: WHEN del_mo_lines_err THEN
1380: x_return_status := l_return_status;

Line 1382: IF g_debug <= gme_debug.g_log_unexpected THEN

1378: EXCEPTION
1379: WHEN del_mo_lines_err THEN
1380: x_return_status := l_return_status;
1381: WHEN OTHERS THEN
1382: IF g_debug <= gme_debug.g_log_unexpected THEN
1383: gme_debug.put_line ( 'When others exception in '
1384: || g_pkg_name
1385: || '.'
1386: || l_api_name

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

1379: WHEN del_mo_lines_err THEN
1380: x_return_status := l_return_status;
1381: WHEN OTHERS THEN
1382: IF g_debug <= gme_debug.g_log_unexpected THEN
1383: gme_debug.put_line ( 'When others exception in '
1384: || g_pkg_name
1385: || '.'
1386: || l_api_name
1387: || ' Error is '