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 35: IF g_debug <= gme_debug.g_log_procedure THEN

31: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
32: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
33: create_mo_hdr_err EXCEPTION;
34: BEGIN
35: IF g_debug <= gme_debug.g_log_procedure THEN
36: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
37: || l_api_name);
38: END IF;
39:

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

32: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
33: create_mo_hdr_err EXCEPTION;
34: BEGIN
35: IF g_debug <= gme_debug.g_log_procedure THEN
36: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
37: || l_api_name);
38: END IF;
39:
40: x_return_status := fnd_api.g_ret_sts_success;

Line 52: gme_debug.put_line

48: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
49: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;
50:
51: IF (g_debug IS NOT NULL) THEN
52: gme_debug.put_line
53: ('Calling inv_move_order_pub.create_move_order_header');
54: END IF;
55:
56: inv_move_order_pub.create_move_order_header

Line 73: IF g_debug <= gme_debug.g_log_statement THEN

69:
70: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
71: RAISE create_mo_hdr_err;
72: ELSE
73: IF g_debug <= gme_debug.g_log_statement THEN
74: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);
75: gme_debug.put_line ( 'request_number is '
76: || l_out_trohdr_rec.request_number);
77: END IF;

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

70: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
71: RAISE create_mo_hdr_err;
72: ELSE
73: IF g_debug <= gme_debug.g_log_statement THEN
74: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);
75: gme_debug.put_line ( 'request_number is '
76: || l_out_trohdr_rec.request_number);
77: END IF;
78:

Line 75: gme_debug.put_line ( 'request_number is '

71: RAISE create_mo_hdr_err;
72: ELSE
73: IF g_debug <= gme_debug.g_log_statement THEN
74: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);
75: gme_debug.put_line ( 'request_number is '
76: || l_out_trohdr_rec.request_number);
77: END IF;
78:
79: x_move_order_header_id := l_out_trohdr_rec.header_id;

Line 82: IF g_debug <= gme_debug.g_log_procedure THEN

78:
79: x_move_order_header_id := l_out_trohdr_rec.header_id;
80: END IF;
81:
82: IF g_debug <= gme_debug.g_log_procedure THEN
83: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
84: END IF;
85: EXCEPTION
86: WHEN create_mo_hdr_err THEN

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

79: x_move_order_header_id := l_out_trohdr_rec.header_id;
80: END IF;
81:
82: IF g_debug <= gme_debug.g_log_procedure THEN
83: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
84: END IF;
85: EXCEPTION
86: WHEN create_mo_hdr_err THEN
87: IF (g_debug <= gme_debug.g_log_error) THEN

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

83: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
84: END IF;
85: EXCEPTION
86: WHEN create_mo_hdr_err THEN
87: IF (g_debug <= gme_debug.g_log_error) THEN
88: gme_debug.put_line
89: ( 'inv_move_order_pub.create_move_order_header returns '
90: || l_return_status);
91: gme_debug.put_line ('error message is ' || l_msg_data);

Line 88: gme_debug.put_line

84: END IF;
85: EXCEPTION
86: WHEN create_mo_hdr_err THEN
87: IF (g_debug <= gme_debug.g_log_error) THEN
88: gme_debug.put_line
89: ( 'inv_move_order_pub.create_move_order_header returns '
90: || l_return_status);
91: gme_debug.put_line ('error message is ' || l_msg_data);
92: END IF;

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

87: IF (g_debug <= gme_debug.g_log_error) THEN
88: gme_debug.put_line
89: ( 'inv_move_order_pub.create_move_order_header returns '
90: || l_return_status);
91: gme_debug.put_line ('error message is ' || l_msg_data);
92: END IF;
93:
94: x_return_status := l_return_status;
95: WHEN OTHERS THEN

Line 96: IF g_debug <= gme_debug.g_log_unexpected THEN

92: END IF;
93:
94: x_return_status := l_return_status;
95: WHEN OTHERS THEN
96: IF g_debug <= gme_debug.g_log_unexpected THEN
97: gme_debug.put_line ( 'When others exception in '
98: || g_pkg_name
99: || '.'
100: || l_api_name

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

93:
94: x_return_status := l_return_status;
95: WHEN OTHERS THEN
96: IF g_debug <= gme_debug.g_log_unexpected THEN
97: gme_debug.put_line ( 'When others exception in '
98: || g_pkg_name
99: || '.'
100: || l_api_name
101: || ' Error is '

Line 139: IF g_debug <= gme_debug.g_log_procedure THEN

135: FROM mtl_system_items_b
136: WHERE organization_id = v_org_id
137: AND inventory_item_id = v_inventory_item_id;
138: BEGIN
139: IF g_debug <= gme_debug.g_log_procedure THEN
140: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
141: || l_api_name);
142: END IF;
143:

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

136: WHERE organization_id = v_org_id
137: AND inventory_item_id = v_inventory_item_id;
138: BEGIN
139: IF g_debug <= gme_debug.g_log_procedure THEN
140: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
141: || l_api_name);
142: END IF;
143:
144: x_return_status := fnd_api.g_ret_sts_success;

Line 232: IF g_debug <= gme_debug.g_log_statement THEN

228: p_material_details_tbl (i);
229: END IF;
230: END LOOP;
231:
232: IF g_debug <= gme_debug.g_log_statement THEN
233: gme_debug.put_line
234: ( 'Calling inv_move_order_pub.create_move_order_lines with no. of lines = '
235: || l_in_trolin_tbl.COUNT);
236: END IF;

Line 233: gme_debug.put_line

229: END IF;
230: END LOOP;
231:
232: IF g_debug <= gme_debug.g_log_statement THEN
233: gme_debug.put_line
234: ( 'Calling inv_move_order_pub.create_move_order_lines with no. of lines = '
235: || l_in_trolin_tbl.COUNT);
236: END IF;
237: /* Bug 4866700 added check to call only if records are there in table */

Line 256: IF g_debug <= gme_debug.g_log_statement THEN

252:
253: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
254: RAISE create_mo_line_err;
255: ELSE
256: IF g_debug <= gme_debug.g_log_statement THEN
257: gme_debug.put_line ( 'No. of move order lines created = '
258: || x_trolin_tbl.COUNT);
259: END IF;
260:

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

253: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
254: RAISE create_mo_line_err;
255: ELSE
256: IF g_debug <= gme_debug.g_log_statement THEN
257: gme_debug.put_line ( 'No. of move order lines created = '
258: || x_trolin_tbl.COUNT);
259: END IF;
260:
261: /* Populate out structure only for invisible move order */

Line 272: IF g_debug <= gme_debug.g_log_procedure THEN

268: END LOOP;
269: END IF;
270: END IF;
271: END IF;
272: IF g_debug <= gme_debug.g_log_procedure THEN
273: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
274: END IF;
275: EXCEPTION
276: WHEN create_mo_line_err THEN

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

269: END IF;
270: END IF;
271: END IF;
272: IF g_debug <= gme_debug.g_log_procedure THEN
273: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
274: END IF;
275: EXCEPTION
276: WHEN create_mo_line_err THEN
277: IF g_debug <= gme_debug.g_log_error THEN

Line 277: IF g_debug <= gme_debug.g_log_error THEN

273: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
274: END IF;
275: EXCEPTION
276: WHEN create_mo_line_err THEN
277: IF g_debug <= gme_debug.g_log_error THEN
278: gme_debug.put_line
279: ( 'inv_move_order_pub.create_move_order_lines returns '
280: || l_return_status);
281: gme_debug.put_line ('message count is ' || l_msg_count);

Line 278: gme_debug.put_line

274: END IF;
275: EXCEPTION
276: WHEN create_mo_line_err THEN
277: IF g_debug <= gme_debug.g_log_error THEN
278: gme_debug.put_line
279: ( 'inv_move_order_pub.create_move_order_lines returns '
280: || l_return_status);
281: gme_debug.put_line ('message count is ' || l_msg_count);
282:

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

277: IF g_debug <= gme_debug.g_log_error THEN
278: gme_debug.put_line
279: ( 'inv_move_order_pub.create_move_order_lines returns '
280: || l_return_status);
281: gme_debug.put_line ('message count is ' || l_msg_count);
282:
283: FOR i IN 1 .. l_msg_count LOOP
284: l_msg_data :=
285: fnd_msg_pub.get (p_msg_index => i

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

283: FOR i IN 1 .. l_msg_count LOOP
284: l_msg_data :=
285: fnd_msg_pub.get (p_msg_index => i
286: ,p_encoded => 'T');
287: gme_debug.put_line ('error message is ' || l_msg_data);
288: END LOOP;
289: END IF;
290:
291: x_return_status := l_return_status;

Line 293: IF g_debug <= gme_debug.g_log_unexpected THEN

289: END IF;
290:
291: x_return_status := l_return_status;
292: WHEN OTHERS THEN
293: IF g_debug <= gme_debug.g_log_unexpected THEN
294: gme_debug.put_line ( 'When others exception in '
295: || g_pkg_name
296: || '.'
297: || l_api_name

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

290:
291: x_return_status := l_return_status;
292: WHEN OTHERS THEN
293: IF g_debug <= gme_debug.g_log_unexpected THEN
294: gme_debug.put_line ( 'When others exception in '
295: || g_pkg_name
296: || '.'
297: || l_api_name
298: || ' Error is '

Line 355: IF g_debug <= gme_debug.g_log_procedure THEN

351: create_mo_err EXCEPTION;
352: uom_conversion_err EXCEPTION;
353: unable_to_query_tree EXCEPTION;
354: BEGIN
355: IF g_debug <= gme_debug.g_log_procedure THEN
356: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
357: || l_api_name);
358: END IF;
359:

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

352: uom_conversion_err EXCEPTION;
353: unable_to_query_tree EXCEPTION;
354: BEGIN
355: IF g_debug <= gme_debug.g_log_procedure THEN
356: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
357: || l_api_name);
358: END IF;
359:
360: x_return_status := fnd_api.g_ret_sts_success;

Line 408: IF g_debug <= gme_debug.g_log_statement THEN

404: ,x_sqs => l_sqs
405: ,x_satt => l_satt
406: ,x_satr => l_satr);
407: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
408: IF g_debug <= gme_debug.g_log_statement THEN
409: gme_debug.put_line ( 'item = '
410: || l_concatenated_segments);
411: gme_debug.put_line
412: ( 'subinventory = '

Line 409: gme_debug.put_line ( 'item = '

405: ,x_satt => l_satt
406: ,x_satr => l_satr);
407: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
408: IF g_debug <= gme_debug.g_log_statement THEN
409: gme_debug.put_line ( 'item = '
410: || l_concatenated_segments);
411: gme_debug.put_line
412: ( 'subinventory = '
413: || p_material_details_tbl (i).subinventory);

Line 411: gme_debug.put_line

407: IF (l_return_status = fnd_api.g_ret_sts_success) THEN
408: IF g_debug <= gme_debug.g_log_statement THEN
409: gme_debug.put_line ( 'item = '
410: || l_concatenated_segments);
411: gme_debug.put_line
412: ( 'subinventory = '
413: || p_material_details_tbl (i).subinventory);
414: gme_debug.put_line ('l_att = ' || l_att);
415: END IF;

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

410: || l_concatenated_segments);
411: gme_debug.put_line
412: ( 'subinventory = '
413: || p_material_details_tbl (i).subinventory);
414: gme_debug.put_line ('l_att = ' || l_att);
415: END IF;
416: IF (l_primary_uom_code <>
417: p_material_details_tbl (i).dtl_um) THEN
418: l_plan_qty_prim :=

Line 492: IF g_debug <= gme_debug.g_log_procedure THEN

488: END IF;
489: END IF;
490: END IF;
491:
492: IF g_debug <= gme_debug.g_log_procedure THEN
493: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
494: END IF;
495: EXCEPTION
496: WHEN create_mo_err OR unable_to_query_tree THEN

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

489: END IF;
490: END IF;
491:
492: IF g_debug <= gme_debug.g_log_procedure THEN
493: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
494: END IF;
495: EXCEPTION
496: WHEN create_mo_err OR unable_to_query_tree THEN
497: x_return_status := l_return_status;

Line 505: IF g_debug <= gme_debug.g_log_unexpected THEN

501: fnd_message.set_token ('ITEM_NO', l_item_no);
502: fnd_message.set_token ('FROM_UOM', l_from_uom);
503: fnd_message.set_token ('TO_UOM', l_to_uom);
504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
506: gme_debug.put_line ( 'When others exception in '
507: || g_pkg_name
508: || '.'
509: || l_api_name

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

502: fnd_message.set_token ('FROM_UOM', l_from_uom);
503: fnd_message.set_token ('TO_UOM', l_to_uom);
504: WHEN OTHERS THEN
505: IF g_debug <= gme_debug.g_log_unexpected THEN
506: gme_debug.put_line ( 'When others exception in '
507: || g_pkg_name
508: || '.'
509: || l_api_name
510: || ' Error is '

Line 543: IF g_debug <= gme_debug.g_log_procedure THEN

539: (gme_common_pvt.g_invis_move_order_type
540: ,inv_globals.g_move_order_put_away)
541: ORDER BY l.header_id, l.line_id;
542: BEGIN
543: IF g_debug <= gme_debug.g_log_procedure THEN
544: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
545: || l_api_name);
546: END IF;
547:

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

540: ,inv_globals.g_move_order_put_away)
541: ORDER BY l.header_id, l.line_id;
542: BEGIN
543: IF g_debug <= gme_debug.g_log_procedure THEN
544: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
545: || l_api_name);
546: END IF;
547:
548: x_return_status := fnd_api.g_ret_sts_success;

Line 557: IF g_debug <= gme_debug.g_log_procedure THEN

553: BULK COLLECT INTO x_mo_line_tbl;
554:
555: CLOSE cur_move_order_lines;
556:
557: IF g_debug <= gme_debug.g_log_procedure THEN
558: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name||' No of lines '||x_mo_line_tbl.count);
559: END IF;
560: EXCEPTION
561: WHEN OTHERS THEN

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

554:
555: CLOSE cur_move_order_lines;
556:
557: IF g_debug <= gme_debug.g_log_procedure THEN
558: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name||' No of lines '||x_mo_line_tbl.count);
559: END IF;
560: EXCEPTION
561: WHEN OTHERS THEN
562: IF g_debug <= gme_debug.g_log_unexpected THEN

Line 562: IF g_debug <= gme_debug.g_log_unexpected THEN

558: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name||' No of lines '||x_mo_line_tbl.count);
559: END IF;
560: EXCEPTION
561: WHEN OTHERS THEN
562: IF g_debug <= gme_debug.g_log_unexpected THEN
563: gme_debug.put_line ( 'When others exception in '
564: || g_pkg_name
565: || '.'
566: || l_api_name

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

559: END IF;
560: EXCEPTION
561: WHEN OTHERS THEN
562: IF g_debug <= gme_debug.g_log_unexpected THEN
563: gme_debug.put_line ( 'When others exception in '
564: || g_pkg_name
565: || '.'
566: || l_api_name
567: || ' Error is '

Line 608: IF g_debug <= gme_debug.g_log_procedure THEN

604: SELECT COUNT (1)
605: FROM mtl_txn_request_lines
606: WHERE header_id = v_header_id;
607: BEGIN
608: IF g_debug <= gme_debug.g_log_procedure THEN
609: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
610: || l_api_name);
611: END IF;
612:

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

605: FROM mtl_txn_request_lines
606: WHERE header_id = v_header_id;
607: BEGIN
608: IF g_debug <= gme_debug.g_log_procedure THEN
609: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
610: || l_api_name);
611: END IF;
612:
613: x_return_status := fnd_api.g_ret_sts_success;

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

635: l_trolin_tbl (l_row).header_id := p_invis_move_header_id;
636: END IF;
637:
638: IF (l_trolin_tbl.count = 0) THEN
639: IF (g_debug <= gme_debug.g_log_statement) THEN
640: gme_debug.put_line('No move order lines to delete');
641: END IF;
642: RETURN;
643: END IF;

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

636: END IF;
637:
638: IF (l_trolin_tbl.count = 0) THEN
639: IF (g_debug <= gme_debug.g_log_statement) THEN
640: gme_debug.put_line('No move order lines to delete');
641: END IF;
642: RETURN;
643: END IF;
644: IF (g_debug <= gme_debug.g_log_statement) THEN

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

640: gme_debug.put_line('No move order lines to delete');
641: END IF;
642: RETURN;
643: END IF;
644: IF (g_debug <= gme_debug.g_log_statement) THEN
645: gme_debug.put_line
646: ( 'Calling inv_move_order_pub.process_move_order_line in '
647: || l_api_name);
648: END IF;

Line 645: gme_debug.put_line

641: END IF;
642: RETURN;
643: END IF;
644: IF (g_debug <= gme_debug.g_log_statement) THEN
645: gme_debug.put_line
646: ( 'Calling inv_move_order_pub.process_move_order_line in '
647: || l_api_name);
648: END IF;
649:

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

678: IF (l_count = 0) THEN
679: l_trohdr_rec.header_id := l_trolin_tbl (i).header_id;
680: l_trohdr_rec.operation := inv_globals.g_opr_delete;
681:
682: IF (g_debug <= gme_debug.g_log_statement) THEN
683: gme_debug.put_line
684: ( 'Calling inv_move_order_pub.process_move_order in '
685: || l_api_name);
686: END IF;

Line 683: gme_debug.put_line

679: l_trohdr_rec.header_id := l_trolin_tbl (i).header_id;
680: l_trohdr_rec.operation := inv_globals.g_opr_delete;
681:
682: IF (g_debug <= gme_debug.g_log_statement) THEN
683: gme_debug.put_line
684: ( 'Calling inv_move_order_pub.process_move_order in '
685: || l_api_name);
686: END IF;
687:

Line 710: IF g_debug <= gme_debug.g_log_procedure THEN

706: END IF;
707: END IF;
708: END LOOP;
709:
710: IF g_debug <= gme_debug.g_log_procedure THEN
711: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
712: END IF;
713: EXCEPTION
714: WHEN get_mo_line_err THEN

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

707: END IF;
708: END LOOP;
709:
710: IF g_debug <= gme_debug.g_log_procedure THEN
711: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
712: END IF;
713: EXCEPTION
714: WHEN get_mo_line_err THEN
715: x_return_status := l_return_status;

Line 718: gme_debug.put_line

714: WHEN get_mo_line_err THEN
715: x_return_status := l_return_status;
716: WHEN delete_mo_line_err THEN
717: IF (g_debug IS NOT NULL) THEN
718: gme_debug.put_line
719: ( 'inv_move_order_pub.process_move_order_line returns '
720: || l_return_status);
721: gme_debug.put_line ('error message is ' || l_msg_data);
722: END IF;

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

717: IF (g_debug IS NOT NULL) THEN
718: gme_debug.put_line
719: ( 'inv_move_order_pub.process_move_order_line returns '
720: || l_return_status);
721: gme_debug.put_line ('error message is ' || l_msg_data);
722: END IF;
723:
724: x_return_status := l_return_status;
725: WHEN delete_mo_hdr_err THEN

Line 727: gme_debug.put_line

723:
724: x_return_status := l_return_status;
725: WHEN delete_mo_hdr_err THEN
726: IF (g_debug IS NOT NULL) THEN
727: gme_debug.put_line
728: ( 'inv_move_order_pub.process_move_order returns '
729: || l_return_status);
730: gme_debug.put_line ('error message is ' || l_msg_data);
731: END IF;

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

726: IF (g_debug IS NOT NULL) THEN
727: gme_debug.put_line
728: ( 'inv_move_order_pub.process_move_order returns '
729: || l_return_status);
730: gme_debug.put_line ('error message is ' || l_msg_data);
731: END IF;
732:
733: x_return_status := l_return_status;
734: WHEN OTHERS THEN

Line 735: IF g_debug <= gme_debug.g_log_unexpected THEN

731: END IF;
732:
733: x_return_status := l_return_status;
734: WHEN OTHERS THEN
735: IF g_debug <= gme_debug.g_log_unexpected THEN
736: gme_debug.put_line ( 'When others exception in '
737: || g_pkg_name
738: || '.'
739: || l_api_name

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

732:
733: x_return_status := l_return_status;
734: WHEN OTHERS THEN
735: IF g_debug <= gme_debug.g_log_unexpected THEN
736: gme_debug.put_line ( 'When others exception in '
737: || g_pkg_name
738: || '.'
739: || l_api_name
740: || ' Error is '

Line 794: IF g_debug <= gme_debug.g_log_procedure THEN

790: from gme_material_details
791: where material_detail_id = p_material_detail_id;
792: l_line_uom VARCHAR2(4);
793: BEGIN
794: IF g_debug <= gme_debug.g_log_procedure THEN
795: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
796: || l_api_name);
797: END IF;
798:

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

791: where material_detail_id = p_material_detail_id;
792: l_line_uom VARCHAR2(4);
793: BEGIN
794: IF g_debug <= gme_debug.g_log_procedure THEN
795: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
796: || l_api_name);
797: END IF;
798:
799: x_return_status := fnd_api.g_ret_sts_success;

Line 898: gme_debug.put_line

894: END IF;
895: END IF;
896:
897: IF (g_debug IS NOT NULL) THEN
898: gme_debug.put_line
899: ( 'Calling inv_move_order_pub.process_move_order_line in '
900: || l_api_name);
901: END IF;
902:

Line 919: IF g_debug <= gme_debug.g_log_procedure THEN

915: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
916: RAISE process_mo_line_err;
917: END IF;
918:
919: IF g_debug <= gme_debug.g_log_procedure THEN
920: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
921: END IF;
922: EXCEPTION
923: WHEN process_mo_line_err THEN

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

916: RAISE process_mo_line_err;
917: END IF;
918:
919: IF g_debug <= gme_debug.g_log_procedure THEN
920: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
921: END IF;
922: EXCEPTION
923: WHEN process_mo_line_err THEN
924: IF (g_debug IS NOT NULL) THEN

Line 925: gme_debug.put_line

921: END IF;
922: EXCEPTION
923: WHEN process_mo_line_err THEN
924: IF (g_debug IS NOT NULL) THEN
925: gme_debug.put_line
926: ( 'inv_move_order_pub.process_move_order_line returns '
927: || l_return_status);
928: gme_debug.put_line ('error message is ' || l_msg_data);
929: END IF;

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

924: IF (g_debug IS NOT NULL) THEN
925: gme_debug.put_line
926: ( 'inv_move_order_pub.process_move_order_line returns '
927: || l_return_status);
928: gme_debug.put_line ('error message is ' || l_msg_data);
929: END IF;
930:
931: x_return_status := l_return_status;
932: WHEN OTHERS THEN

Line 933: IF g_debug <= gme_debug.g_log_unexpected THEN

929: END IF;
930:
931: x_return_status := l_return_status;
932: WHEN OTHERS THEN
933: IF g_debug <= gme_debug.g_log_unexpected THEN
934: gme_debug.put_line ( 'When others exception in '
935: || g_pkg_name
936: || '.'
937: || l_api_name

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

930:
931: x_return_status := l_return_status;
932: WHEN OTHERS THEN
933: IF g_debug <= gme_debug.g_log_unexpected THEN
934: gme_debug.put_line ( 'When others exception in '
935: || g_pkg_name
936: || '.'
937: || l_api_name
938: || ' Error is '

Line 971: IF g_debug <= gme_debug.g_log_procedure THEN

967: AND h.header_id = l.header_id
968: AND h.move_order_type = gme_common_pvt.g_move_order_type
969: AND ROWNUM = 1;
970: BEGIN
971: IF g_debug <= gme_debug.g_log_procedure THEN
972: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
973: || l_api_name);
974: END IF;
975:

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

968: AND h.move_order_type = gme_common_pvt.g_move_order_type
969: AND ROWNUM = 1;
970: BEGIN
971: IF g_debug <= gme_debug.g_log_procedure THEN
972: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
973: || l_api_name);
974: END IF;
975:
976: OPEN cur_move_order_lines;

Line 987: IF g_debug <= gme_debug.g_log_procedure THEN

983: END IF;
984:
985: CLOSE cur_move_order_lines;
986:
987: IF g_debug <= gme_debug.g_log_procedure THEN
988: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
989: END IF;
990:
991: RETURN l_exists;

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

984:
985: CLOSE cur_move_order_lines;
986:
987: IF g_debug <= gme_debug.g_log_procedure THEN
988: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
989: END IF;
990:
991: RETURN l_exists;
992: EXCEPTION

Line 994: IF g_debug <= gme_debug.g_log_unexpected THEN

990:
991: RETURN l_exists;
992: EXCEPTION
993: WHEN OTHERS THEN
994: IF g_debug <= gme_debug.g_log_unexpected THEN
995: gme_debug.put_line ( 'When others exception in '
996: || g_pkg_name
997: || '.'
998: || l_api_name

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

991: RETURN l_exists;
992: EXCEPTION
993: WHEN OTHERS THEN
994: IF g_debug <= gme_debug.g_log_unexpected THEN
995: gme_debug.put_line ( 'When others exception in '
996: || g_pkg_name
997: || '.'
998: || l_api_name
999: || ' Error is '

Line 1032: IF g_debug <= gme_debug.g_log_procedure THEN

1028:
1029: get_mo_line_err EXCEPTION;
1030: uom_conv_error EXCEPTION;
1031: BEGIN
1032: IF g_debug <= gme_debug.g_log_procedure THEN
1033: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1034: || l_api_name);
1035: END IF;
1036:

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

1029: get_mo_line_err EXCEPTION;
1030: uom_conv_error EXCEPTION;
1031: BEGIN
1032: IF g_debug <= gme_debug.g_log_procedure THEN
1033: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1034: || l_api_name);
1035: END IF;
1036:
1037: x_return_status := fnd_api.g_ret_sts_success;

Line 1087: IF g_debug <= gme_debug.g_log_procedure THEN

1083:
1084: x_pending_qty := NVL (x_pending_qty, 0) + l_temp_qty;
1085: END LOOP;
1086:
1087: IF g_debug <= gme_debug.g_log_procedure THEN
1088: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1089: END IF;
1090: EXCEPTION
1091: WHEN uom_conv_error THEN

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

1084: x_pending_qty := NVL (x_pending_qty, 0) + l_temp_qty;
1085: END LOOP;
1086:
1087: IF g_debug <= gme_debug.g_log_procedure THEN
1088: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1089: END IF;
1090: EXCEPTION
1091: WHEN uom_conv_error THEN
1092: x_return_status := fnd_api.g_ret_sts_error;

Line 1101: IF g_debug <= gme_debug.g_log_unexpected THEN

1097: fnd_msg_pub.ADD;
1098: WHEN get_mo_line_err THEN
1099: x_return_status := l_return_status;
1100: WHEN OTHERS THEN
1101: IF g_debug <= gme_debug.g_log_unexpected THEN
1102: gme_debug.put_line ( 'When others exception in '
1103: || g_pkg_name
1104: || '.'
1105: || l_api_name

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

1098: WHEN get_mo_line_err THEN
1099: x_return_status := l_return_status;
1100: WHEN OTHERS THEN
1101: IF g_debug <= gme_debug.g_log_unexpected THEN
1102: gme_debug.put_line ( 'When others exception in '
1103: || g_pkg_name
1104: || '.'
1105: || l_api_name
1106: || ' Error is '

Line 1141: IF g_debug <= gme_debug.g_log_procedure THEN

1137: l_invis_header_id NUMBER;
1138: l_return_status VARCHAR2 (1);
1139: del_mo_lines_err EXCEPTION;
1140: BEGIN
1141: IF g_debug <= gme_debug.g_log_procedure THEN
1142: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1143: || l_api_name);
1144: END IF;
1145:

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

1138: l_return_status VARCHAR2 (1);
1139: del_mo_lines_err EXCEPTION;
1140: BEGIN
1141: IF g_debug <= gme_debug.g_log_procedure THEN
1142: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'
1143: || l_api_name);
1144: END IF;
1145:
1146: x_return_status := fnd_api.g_ret_sts_success;

Line 1174: IF g_debug <= gme_debug.g_log_procedure THEN

1170: RAISE del_mo_lines_err;
1171: END IF;
1172: END LOOP;
1173:
1174: IF g_debug <= gme_debug.g_log_procedure THEN
1175: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1176: END IF;
1177: EXCEPTION
1178: WHEN del_mo_lines_err THEN

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

1171: END IF;
1172: END LOOP;
1173:
1174: IF g_debug <= gme_debug.g_log_procedure THEN
1175: gme_debug.put_line ('Exiting api ' || g_pkg_name || '.' || l_api_name);
1176: END IF;
1177: EXCEPTION
1178: WHEN del_mo_lines_err THEN
1179: x_return_status := l_return_status;

Line 1181: IF g_debug <= gme_debug.g_log_unexpected THEN

1177: EXCEPTION
1178: WHEN del_mo_lines_err THEN
1179: x_return_status := l_return_status;
1180: WHEN OTHERS THEN
1181: IF g_debug <= gme_debug.g_log_unexpected THEN
1182: gme_debug.put_line ( 'When others exception in '
1183: || g_pkg_name
1184: || '.'
1185: || l_api_name

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

1178: WHEN del_mo_lines_err THEN
1179: x_return_status := l_return_status;
1180: WHEN OTHERS THEN
1181: IF g_debug <= gme_debug.g_log_unexpected THEN
1182: gme_debug.put_line ( 'When others exception in '
1183: || g_pkg_name
1184: || '.'
1185: || l_api_name
1186: || ' Error is '