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 FND_API

Line 63: x_return_status := fnd_api.g_ret_sts_success;

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;
64: l_in_trohdr_rec.organization_id := p_organization_id;
65: l_in_trohdr_rec.move_order_type := p_move_order_type;
66: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
67: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;

Line 67: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;

63: x_return_status := fnd_api.g_ret_sts_success;
64: l_in_trohdr_rec.organization_id := p_organization_id;
65: l_in_trohdr_rec.move_order_type := p_move_order_type;
66: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
67: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
68: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
69: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
70: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
71: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;

Line 68: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;

64: l_in_trohdr_rec.organization_id := p_organization_id;
65: l_in_trohdr_rec.move_order_type := p_move_order_type;
66: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
67: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
68: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
69: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
70: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
71: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;
72: l_in_trohdr_rec.last_updated_by := gme_common_pvt.g_user_ident;

Line 84: ,p_init_msg_list => fnd_api.g_false

80: END IF;
81:
82: inv_move_order_pub.create_move_order_header
83: (p_api_version_number => 1.0
84: ,p_init_msg_list => fnd_api.g_false
85: ,p_return_values => fnd_api.g_false
86: ,p_commit => fnd_api.g_false
87: ,x_return_status => l_return_status
88: ,x_msg_count => l_msg_count

Line 85: ,p_return_values => fnd_api.g_false

81:
82: inv_move_order_pub.create_move_order_header
83: (p_api_version_number => 1.0
84: ,p_init_msg_list => fnd_api.g_false
85: ,p_return_values => fnd_api.g_false
86: ,p_commit => fnd_api.g_false
87: ,x_return_status => l_return_status
88: ,x_msg_count => l_msg_count
89: ,x_msg_data => l_msg_data

Line 86: ,p_commit => fnd_api.g_false

82: inv_move_order_pub.create_move_order_header
83: (p_api_version_number => 1.0
84: ,p_init_msg_list => fnd_api.g_false
85: ,p_return_values => fnd_api.g_false
86: ,p_commit => fnd_api.g_false
87: ,x_return_status => l_return_status
88: ,x_msg_count => l_msg_count
89: ,x_msg_data => l_msg_data
90: ,p_trohdr_rec => l_in_trohdr_rec

Line 96: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

92: ,x_trohdr_rec => l_out_trohdr_rec
93: ,x_trohdr_val_rec => l_out_trohdr_val_rec
94: ,p_validation_flag => inv_move_order_pub.g_validation_yes);
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);

Line 132: x_return_status := fnd_api.g_ret_sts_unexp_error;

128: || SQLERRM);
129: END IF;
130:
131: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
132: x_return_status := fnd_api.g_ret_sts_unexp_error;
133: END create_move_order_hdr;
134:
135: PROCEDURE create_move_order_lines (
136: p_move_order_header_id IN NUMBER

Line 180: x_return_status := fnd_api.g_ret_sts_success;

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;
181:
182: FOR i IN 1 .. p_material_details_tbl.COUNT LOOP
183: IF (p_material_details_tbl (i).line_type = -1) THEN
184: OPEN cur_item_mst (p_material_details_tbl (i).organization_id

Line 291: ,p_init_msg_list => fnd_api.g_false

287: /* Bug 4866700 added check to call only if records are there in table */
288: IF (l_in_trolin_tbl.COUNT > 0) THEN
289: inv_move_order_pub.create_move_order_lines
290: (p_api_version_number => 1.0
291: ,p_init_msg_list => fnd_api.g_false
292: ,p_return_values => fnd_api.g_false
293: ,p_commit => fnd_api.g_false
294: ,x_return_status => l_return_status
295: ,x_msg_count => l_msg_count

Line 292: ,p_return_values => fnd_api.g_false

288: IF (l_in_trolin_tbl.COUNT > 0) THEN
289: inv_move_order_pub.create_move_order_lines
290: (p_api_version_number => 1.0
291: ,p_init_msg_list => fnd_api.g_false
292: ,p_return_values => fnd_api.g_false
293: ,p_commit => fnd_api.g_false
294: ,x_return_status => l_return_status
295: ,x_msg_count => l_msg_count
296: ,x_msg_data => l_msg_data

Line 293: ,p_commit => fnd_api.g_false

289: inv_move_order_pub.create_move_order_lines
290: (p_api_version_number => 1.0
291: ,p_init_msg_list => fnd_api.g_false
292: ,p_return_values => fnd_api.g_false
293: ,p_commit => fnd_api.g_false
294: ,x_return_status => l_return_status
295: ,x_msg_count => l_msg_count
296: ,x_msg_data => l_msg_data
297: ,p_trolin_tbl => l_in_trolin_tbl

Line 303: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

299: ,x_trolin_tbl => x_trolin_tbl
300: ,x_trolin_val_tbl => l_out_trolin_val_tbl
301: ,p_validation_flag => inv_move_order_pub.g_validation_yes);
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 = '

Line 353: x_return_status := fnd_api.g_ret_sts_unexp_error;

349: || SQLERRM);
350: END IF;
351:
352: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
353: x_return_status := fnd_api.g_ret_sts_unexp_error;
354: END create_move_order_lines;
355:
356: PROCEDURE create_batch_move_order (
357: p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 410: x_return_status := fnd_api.g_ret_sts_success;

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;
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);

Line 470: IF (l_return_status = fnd_api.g_ret_sts_success) THEN

466: ,x_sqr => l_sqr
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

Line 538: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

534: ,p_move_order_type => gme_common_pvt.g_move_order_type
535: ,x_move_order_header_id => l_move_order_header_id
536: ,x_return_status => l_return_status);
537:
538: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
539: RAISE create_mo_err;
540: ELSE
541: gme_move_orders_pvt.create_move_order_lines
542: (p_move_order_header_id => l_move_order_header_id

Line 549: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

545: ,x_material_details_tbl => l_mtl_dtl_tbl_out
546: ,x_trolin_tbl => l_trolin_tbl
547: ,x_return_status => l_return_status);
548:
549: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
550: RAISE create_mo_err;
551: END IF;
552: END IF;
553: END IF;

Line 562: x_return_status := fnd_api.g_ret_sts_error;

558: EXCEPTION
559: WHEN create_mo_err OR unable_to_query_tree THEN
560: x_return_status := l_return_status;
561: WHEN uom_conversion_err THEN
562: x_return_status := fnd_api.g_ret_sts_error;
563: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
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);

Line 578: x_return_status := fnd_api.g_ret_sts_unexp_error;

574: || SQLERRM);
575: END IF;
576:
577: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
578: x_return_status := fnd_api.g_ret_sts_unexp_error;
579: END create_batch_move_order;
580:
581: PROCEDURE get_move_order_lines (
582: p_organization_id IN NUMBER

Line 611: x_return_status := fnd_api.g_ret_sts_success;

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;
612:
613: OPEN cur_move_order_lines;
614:
615: FETCH cur_move_order_lines

Line 635: x_return_status := fnd_api.g_ret_sts_unexp_error;

631: || SQLERRM);
632: END IF;
633:
634: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
635: x_return_status := fnd_api.g_ret_sts_unexp_error;
636: END get_move_order_lines;
637:
638: PROCEDURE delete_move_order_lines (
639: p_organization_id IN NUMBER

Line 676: x_return_status := fnd_api.g_ret_sts_success;

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;
677: gme_move_orders_pvt.get_move_order_lines
678: (p_organization_id => p_organization_id
679: ,p_batch_id => p_batch_id
680: ,p_material_detail_id => p_material_detail_id

Line 684: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

680: ,p_material_detail_id => p_material_detail_id
681: ,x_mo_line_tbl => l_line_tbl
682: ,x_return_status => l_return_status);
683:
684: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
685: RAISE get_mo_line_err;
686: END IF;
687:
688: FOR i IN 1 .. l_line_tbl.COUNT LOOP

Line 715: ,p_init_msg_list => fnd_api.g_false

711: END IF;
712:
713: inv_move_order_pub.process_move_order_line
714: (p_api_version_number => 1.0
715: ,p_init_msg_list => fnd_api.g_false
716: ,p_return_values => fnd_api.g_false
717: ,p_commit => fnd_api.g_false
718: ,x_return_status => l_return_status
719: ,x_msg_count => l_msg_count

Line 716: ,p_return_values => fnd_api.g_false

712:
713: inv_move_order_pub.process_move_order_line
714: (p_api_version_number => 1.0
715: ,p_init_msg_list => fnd_api.g_false
716: ,p_return_values => fnd_api.g_false
717: ,p_commit => fnd_api.g_false
718: ,x_return_status => l_return_status
719: ,x_msg_count => l_msg_count
720: ,x_msg_data => l_msg_data

Line 717: ,p_commit => fnd_api.g_false

713: inv_move_order_pub.process_move_order_line
714: (p_api_version_number => 1.0
715: ,p_init_msg_list => fnd_api.g_false
716: ,p_return_values => fnd_api.g_false
717: ,p_commit => fnd_api.g_false
718: ,x_return_status => l_return_status
719: ,x_msg_count => l_msg_count
720: ,x_msg_data => l_msg_data
721: ,p_trolin_tbl => l_trolin_tbl

Line 725: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

721: ,p_trolin_tbl => l_trolin_tbl
722: ,p_trolin_old_tbl => l_old_trolin_tbl
723: ,x_trolin_tbl => l_out_trolin_tbl);
724:
725: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
726: RAISE delete_mo_line_err;
727: END IF;
728:
729: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP

Line 753: ,p_init_msg_list => fnd_api.g_false

749: END IF;
750:
751: inv_move_order_pub.process_move_order
752: (p_api_version_number => 1.0
753: ,p_init_msg_list => fnd_api.g_false
754: ,p_return_values => fnd_api.g_false
755: ,p_commit => fnd_api.g_false
756: ,x_return_status => l_return_status
757: ,x_msg_count => l_msg_count

Line 754: ,p_return_values => fnd_api.g_false

750:
751: inv_move_order_pub.process_move_order
752: (p_api_version_number => 1.0
753: ,p_init_msg_list => fnd_api.g_false
754: ,p_return_values => fnd_api.g_false
755: ,p_commit => fnd_api.g_false
756: ,x_return_status => l_return_status
757: ,x_msg_count => l_msg_count
758: ,x_msg_data => l_msg_data

Line 755: ,p_commit => fnd_api.g_false

751: inv_move_order_pub.process_move_order
752: (p_api_version_number => 1.0
753: ,p_init_msg_list => fnd_api.g_false
754: ,p_return_values => fnd_api.g_false
755: ,p_commit => fnd_api.g_false
756: ,x_return_status => l_return_status
757: ,x_msg_count => l_msg_count
758: ,x_msg_data => l_msg_data
759: ,p_trohdr_rec => l_trohdr_rec

Line 765: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

761: ,x_trohdr_val_rec => l_out_trohdr_val_rec
762: ,x_trolin_tbl => l_out_trolin_tbl
763: ,x_trolin_val_tbl => l_trolin_val_tbl);
764:
765: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
766: RAISE delete_mo_hdr_err;
767: END IF;
768: END IF;
769: END IF;

Line 808: x_return_status := fnd_api.g_ret_sts_unexp_error;

804: || SQLERRM);
805: END IF;
806:
807: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
808: x_return_status := fnd_api.g_ret_sts_unexp_error;
809: END delete_move_order_lines;
810:
811:
812: PROCEDURE update_move_order_lines (

Line 877: x_return_status := fnd_api.g_ret_sts_success;

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;
878: -- Bug 9028327 - Fetch some additional columns.
879: OPEN get_line_uom;
880: FETCH get_line_uom INTO l_line_uom, l_inventory_item_id, l_organization_id;
881: CLOSE get_line_uom;

Line 1102: ,p_init_msg_list => fnd_api.g_false

1098: END IF;
1099:
1100: inv_move_order_pub.process_move_order_line
1101: (p_api_version_number => 1.0
1102: ,p_init_msg_list => fnd_api.g_false
1103: ,p_return_values => fnd_api.g_false
1104: ,p_commit => fnd_api.g_false
1105: ,x_return_status => l_return_status
1106: ,x_msg_count => l_msg_count

Line 1103: ,p_return_values => fnd_api.g_false

1099:
1100: inv_move_order_pub.process_move_order_line
1101: (p_api_version_number => 1.0
1102: ,p_init_msg_list => fnd_api.g_false
1103: ,p_return_values => fnd_api.g_false
1104: ,p_commit => fnd_api.g_false
1105: ,x_return_status => l_return_status
1106: ,x_msg_count => l_msg_count
1107: ,x_msg_data => l_msg_data

Line 1104: ,p_commit => fnd_api.g_false

1100: inv_move_order_pub.process_move_order_line
1101: (p_api_version_number => 1.0
1102: ,p_init_msg_list => fnd_api.g_false
1103: ,p_return_values => fnd_api.g_false
1104: ,p_commit => fnd_api.g_false
1105: ,x_return_status => l_return_status
1106: ,x_msg_count => l_msg_count
1107: ,x_msg_data => l_msg_data
1108: ,p_trolin_tbl => l_trolin_tbl

Line 1112: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1108: ,p_trolin_tbl => l_trolin_tbl
1109: ,p_trolin_old_tbl => l_old_trolin_tbl
1110: ,x_trolin_tbl => l_out_trolin_tbl);
1111:
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

Line 1140: x_return_status := fnd_api.g_ret_sts_unexp_error;

1136: || SQLERRM);
1137: END IF;
1138:
1139: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1140: x_return_status := fnd_api.g_ret_sts_unexp_error;
1141: END update_move_order_lines;
1142:
1143: FUNCTION pending_move_orders_exist (
1144: p_organization_id IN NUMBER

Line 1234: x_return_status := fnd_api.g_ret_sts_success;

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;
1235: gme_move_orders_pvt.get_move_order_lines
1236: (p_organization_id => p_mtl_dtl_rec.organization_id
1237: ,p_batch_id => p_mtl_dtl_rec.batch_id
1238: ,p_material_detail_id => p_mtl_dtl_rec.material_detail_id

Line 1242: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1238: ,p_material_detail_id => p_mtl_dtl_rec.material_detail_id
1239: ,x_mo_line_tbl => l_line_tbl
1240: ,x_return_status => l_return_status);
1241:
1242: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1243: RAISE get_mo_line_err;
1244: END IF;
1245:
1246: FOR i IN 1 .. l_line_tbl.COUNT LOOP

Line 1293: x_return_status := fnd_api.g_ret_sts_error;

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;
1294: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1295: fnd_message.set_token ('ITEM_NO', l_item_no);
1296: fnd_message.set_token ('FROM_UOM', l_from_uom);
1297: fnd_message.set_token ('TO_UOM', l_to_uom);

Line 1312: x_return_status := fnd_api.g_ret_sts_unexp_error;

1308: || SQLERRM);
1309: END IF;
1310:
1311: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1312: x_return_status := fnd_api.g_ret_sts_unexp_error;
1313: END get_pending_move_order_qty;
1314:
1315: PROCEDURE delete_batch_move_orders (
1316: p_organization_id IN NUMBER

Line 1347: x_return_status := fnd_api.g_ret_sts_success;

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;
1348:
1349: OPEN cur_batch_lines;
1350:
1351: FETCH cur_batch_lines

Line 1357: IF (p_delete_invis = fnd_api.g_true) THEN

1353:
1354: CLOSE cur_batch_lines;
1355:
1356: FOR i IN 1 .. l_lines_tbl.COUNT LOOP
1357: IF (p_delete_invis = fnd_api.g_true) THEN
1358: l_invis_line_id := l_lines_tbl (i).move_order_line_id;
1359: l_invis_header_id := l_lines_tbl (i).move_order_header_id;
1360: END IF;
1361:

Line 1370: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN

1366: ,p_invis_move_line_id => l_invis_line_id
1367: ,p_invis_move_header_id => l_invis_header_id
1368: ,x_return_status => l_return_status);
1369:
1370: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1371: RAISE del_mo_lines_err;
1372: END IF;
1373: END LOOP;
1374:

Line 1392: x_return_status := fnd_api.g_ret_sts_unexp_error;

1388: || SQLERRM);
1389: END IF;
1390:
1391: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1392: x_return_status := fnd_api.g_ret_sts_unexp_error;
1393: END delete_batch_move_orders;
1394: END gme_move_orders_pvt;