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 INV_MOVE_ORDER_PUB

Line 29: l_in_trohdr_rec inv_move_order_pub.trohdr_rec_type;

25: l_api_name CONSTANT VARCHAR2 (30) := 'create_move_order_hdr';
26: l_return_status VARCHAR2 (1);
27: l_msg_count NUMBER;
28: l_msg_data VARCHAR2 (2000);
29: l_in_trohdr_rec inv_move_order_pub.trohdr_rec_type;
30: l_in_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
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;

Line 30: l_in_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

26: l_return_status VARCHAR2 (1);
27: l_msg_count NUMBER;
28: l_msg_data VARCHAR2 (2000);
29: l_in_trohdr_rec inv_move_order_pub.trohdr_rec_type;
30: l_in_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
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

Line 31: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;

27: l_msg_count NUMBER;
28: l_msg_data VARCHAR2 (2000);
29: l_in_trohdr_rec inv_move_order_pub.trohdr_rec_type;
30: l_in_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
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

Line 32: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

28: l_msg_data VARCHAR2 (2000);
29: l_in_trohdr_rec inv_move_order_pub.trohdr_rec_type;
30: l_in_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
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 || '.'

Line 53: ('Calling inv_move_order_pub.create_move_order_header');

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
57: (p_api_version_number => 1.0

Line 56: inv_move_order_pub.create_move_order_header

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
57: (p_api_version_number => 1.0
58: ,p_init_msg_list => fnd_api.g_false
59: ,p_return_values => fnd_api.g_false
60: ,p_commit => fnd_api.g_false

Line 68: ,p_validation_flag => inv_move_order_pub.g_validation_yes);

64: ,p_trohdr_rec => l_in_trohdr_rec
65: ,p_trohdr_val_rec => l_in_trohdr_val_rec
66: ,x_trohdr_rec => l_out_trohdr_rec
67: ,x_trohdr_val_rec => l_out_trohdr_val_rec
68: ,p_validation_flag => inv_move_order_pub.g_validation_yes);
69:
70: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
71: RAISE create_mo_hdr_err;
72: ELSE

Line 89: ( 'inv_move_order_pub.create_move_order_header returns '

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;
93:

Line 114: ,x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type

110: p_move_order_header_id IN NUMBER
111: ,p_move_order_type IN NUMBER
112: ,p_material_details_tbl IN gme_common_pvt.material_details_tab
113: ,x_material_details_tbl OUT NOCOPY gme_common_pvt.material_details_tab
114: ,x_trolin_tbl OUT NOCOPY inv_move_order_pub.trolin_tbl_type
115: ,x_return_status OUT NOCOPY VARCHAR2)
116: IS
117: l_api_name CONSTANT VARCHAR2 (30) := 'create_move_order_lines';
118: l_return_status VARCHAR2 (1);

Line 127: l_in_trolin_tbl inv_move_order_pub.trolin_tbl_type;

123: l_sec_uom_code VARCHAR2 (10);
124: l_msg_data VARCHAR2 (2000);
125: l_item_no VARCHAR2 (2000);
126: l_material_details_tbl gme_common_pvt.material_details_tab;
127: l_in_trolin_tbl inv_move_order_pub.trolin_tbl_type;
128: l_in_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
129: l_out_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
130: create_mo_line_err EXCEPTION;
131:

Line 128: l_in_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;

124: l_msg_data VARCHAR2 (2000);
125: l_item_no VARCHAR2 (2000);
126: l_material_details_tbl gme_common_pvt.material_details_tab;
127: l_in_trolin_tbl inv_move_order_pub.trolin_tbl_type;
128: l_in_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
129: l_out_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
130: create_mo_line_err EXCEPTION;
131:
132: CURSOR cur_item_mst (v_org_id NUMBER, v_inventory_item_id NUMBER)

Line 129: l_out_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;

125: l_item_no VARCHAR2 (2000);
126: l_material_details_tbl gme_common_pvt.material_details_tab;
127: l_in_trolin_tbl inv_move_order_pub.trolin_tbl_type;
128: l_in_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
129: l_out_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
130: create_mo_line_err EXCEPTION;
131:
132: CURSOR cur_item_mst (v_org_id NUMBER, v_inventory_item_id NUMBER)
133: IS

Line 234: ( 'Calling inv_move_order_pub.create_move_order_lines with no. of lines = '

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 */
238: IF (l_in_trolin_tbl.COUNT > 0) THEN

Line 239: inv_move_order_pub.create_move_order_lines

235: || l_in_trolin_tbl.COUNT);
236: END IF;
237: /* Bug 4866700 added check to call only if records are there in table */
238: IF (l_in_trolin_tbl.COUNT > 0) THEN
239: inv_move_order_pub.create_move_order_lines
240: (p_api_version_number => 1.0
241: ,p_init_msg_list => fnd_api.g_false
242: ,p_return_values => fnd_api.g_false
243: ,p_commit => fnd_api.g_false

Line 251: ,p_validation_flag => inv_move_order_pub.g_validation_yes);

247: ,p_trolin_tbl => l_in_trolin_tbl
248: ,p_trolin_val_tbl => l_in_trolin_val_tbl
249: ,x_trolin_tbl => x_trolin_tbl
250: ,x_trolin_val_tbl => l_out_trolin_val_tbl
251: ,p_validation_flag => inv_move_order_pub.g_validation_yes);
252:
253: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
254: RAISE create_mo_line_err;
255: ELSE

Line 279: ( 'inv_move_order_pub.create_move_order_lines returns '

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:
283: FOR i IN 1 .. l_msg_count LOOP

Line 323: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

319: l_primary_uom_code mtl_system_items_kfv.primary_uom_code%TYPE;
320:
321: l_mtl_dtl_tbl gme_common_pvt.material_details_tab;
322: l_mtl_dtl_tbl_out gme_common_pvt.material_details_tab;
323: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
324: l_is_revision_control BOOLEAN;
325: l_is_lot_control BOOLEAN;
326: l_is_serial_control BOOLEAN;
327: l_plan_qty_prim NUMBER;

Line 590: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;

586: l_count NUMBER;
587: l_curr_header_id NUMBER := 0;
588: l_msg_count NUMBER;
589: l_msg_data VARCHAR2 (2000);
590: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
591: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 591: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;

587: l_curr_header_id NUMBER := 0;
588: l_msg_count NUMBER;
589: l_msg_data VARCHAR2 (2000);
590: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
591: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;

588: l_msg_count NUMBER;
589: l_msg_data VARCHAR2 (2000);
590: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
591: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
596: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;

Line 593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;

589: l_msg_data VARCHAR2 (2000);
590: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
591: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
596: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
597: l_line_tbl gme_common_pvt.mo_lines_tab;

Line 594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

590: l_trohdr_rec inv_move_order_pub.trohdr_rec_type;
591: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
596: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
597: l_line_tbl gme_common_pvt.mo_lines_tab;
598: delete_mo_line_err EXCEPTION;

Line 595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

591: l_out_trohdr_rec inv_move_order_pub.trohdr_rec_type;
592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
596: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
597: l_line_tbl gme_common_pvt.mo_lines_tab;
598: delete_mo_line_err EXCEPTION;
599: delete_mo_hdr_err EXCEPTION;

Line 596: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;

592: l_out_trohdr_val_rec inv_move_order_pub.trohdr_val_rec_type;
593: l_trolin_val_tbl inv_move_order_pub.trolin_val_tbl_type;
594: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
595: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
596: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
597: l_line_tbl gme_common_pvt.mo_lines_tab;
598: delete_mo_line_err EXCEPTION;
599: delete_mo_hdr_err EXCEPTION;
600: get_mo_line_err EXCEPTION;

Line 646: ( 'Calling inv_move_order_pub.process_move_order_line in '

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:
650: inv_move_order_pub.process_move_order_line

Line 650: inv_move_order_pub.process_move_order_line

646: ( 'Calling inv_move_order_pub.process_move_order_line in '
647: || l_api_name);
648: END IF;
649:
650: inv_move_order_pub.process_move_order_line
651: (p_api_version_number => 1.0
652: ,p_init_msg_list => fnd_api.g_false
653: ,p_return_values => fnd_api.g_false
654: ,p_commit => fnd_api.g_false

Line 684: ( 'Calling inv_move_order_pub.process_move_order in '

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:
688: inv_move_order_pub.process_move_order

Line 688: inv_move_order_pub.process_move_order

684: ( 'Calling inv_move_order_pub.process_move_order in '
685: || l_api_name);
686: END IF;
687:
688: inv_move_order_pub.process_move_order
689: (p_api_version_number => 1.0
690: ,p_init_msg_list => fnd_api.g_false
691: ,p_return_values => fnd_api.g_false
692: ,p_commit => fnd_api.g_false

Line 719: ( 'inv_move_order_pub.process_move_order_line returns '

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;
723:

Line 728: ( 'inv_move_order_pub.process_move_order returns '

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;
732:

Line 763: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;

759: l_curr_qty NUMBER;
760: l_diff_qty NUMBER;
761: l_msg_count NUMBER;
762: l_msg_data VARCHAR2 (2000);
763: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
764: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
765: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
766:
767: CURSOR cur_move_order_lines

Line 764: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;

760: l_diff_qty NUMBER;
761: l_msg_count NUMBER;
762: l_msg_data VARCHAR2 (2000);
763: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
764: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
765: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
766:
767: CURSOR cur_move_order_lines
768: IS

Line 765: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;

761: l_msg_count NUMBER;
762: l_msg_data VARCHAR2 (2000);
763: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
764: l_old_trolin_tbl inv_move_order_pub.trolin_tbl_type;
765: l_out_trolin_tbl inv_move_order_pub.trolin_tbl_type;
766:
767: CURSOR cur_move_order_lines
768: IS
769: SELECT l.*

Line 899: ( 'Calling inv_move_order_pub.process_move_order_line in '

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:
903: inv_move_order_pub.process_move_order_line

Line 903: inv_move_order_pub.process_move_order_line

899: ( 'Calling inv_move_order_pub.process_move_order_line in '
900: || l_api_name);
901: END IF;
902:
903: inv_move_order_pub.process_move_order_line
904: (p_api_version_number => 1.0
905: ,p_init_msg_list => fnd_api.g_false
906: ,p_return_values => fnd_api.g_false
907: ,p_commit => fnd_api.g_false

Line 926: ( 'inv_move_order_pub.process_move_order_line returns '

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;
930: