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 40: x_return_status := fnd_api.g_ret_sts_success;

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;
41: l_in_trohdr_rec.organization_id := p_organization_id;
42: l_in_trohdr_rec.move_order_type := p_move_order_type;
43: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
44: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;

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

40: x_return_status := fnd_api.g_ret_sts_success;
41: l_in_trohdr_rec.organization_id := p_organization_id;
42: l_in_trohdr_rec.move_order_type := p_move_order_type;
43: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
44: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
45: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
46: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
47: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
48: l_in_trohdr_rec.last_update_date := gme_common_pvt.g_timestamp;

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

41: l_in_trohdr_rec.organization_id := p_organization_id;
42: l_in_trohdr_rec.move_order_type := p_move_order_type;
43: l_in_trohdr_rec.operation := inv_globals.g_opr_create;
44: l_in_trohdr_rec.request_number := fnd_api.g_miss_char;
45: l_in_trohdr_rec.header_id := fnd_api.g_miss_num;
46: l_in_trohdr_rec.creation_date := gme_common_pvt.g_timestamp;
47: l_in_trohdr_rec.created_by := gme_common_pvt.g_user_ident;
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;

Line 58: ,p_init_msg_list => fnd_api.g_false

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
61: ,x_return_status => l_return_status
62: ,x_msg_count => l_msg_count

Line 59: ,p_return_values => fnd_api.g_false

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
61: ,x_return_status => l_return_status
62: ,x_msg_count => l_msg_count
63: ,x_msg_data => l_msg_data

Line 60: ,p_commit => fnd_api.g_false

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
61: ,x_return_status => l_return_status
62: ,x_msg_count => l_msg_count
63: ,x_msg_data => l_msg_data
64: ,p_trohdr_rec => l_in_trohdr_rec

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

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
73: IF g_debug <= gme_debug.g_log_statement THEN
74: gme_debug.put_line ('Header_id is ' || l_out_trohdr_rec.header_id);

Line 106: x_return_status := fnd_api.g_ret_sts_unexp_error;

102: || SQLERRM);
103: END IF;
104:
105: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107: END create_move_order_hdr;
108:
109: PROCEDURE create_move_order_lines (
110: p_move_order_header_id IN NUMBER

Line 144: x_return_status := fnd_api.g_ret_sts_success;

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;
145:
146: FOR i IN 1 .. p_material_details_tbl.COUNT LOOP
147: IF (p_material_details_tbl (i).line_type = -1) THEN
148: OPEN cur_item_mst (p_material_details_tbl (i).organization_id

Line 241: ,p_init_msg_list => fnd_api.g_false

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
244: ,x_return_status => l_return_status
245: ,x_msg_count => l_msg_count

Line 242: ,p_return_values => fnd_api.g_false

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
244: ,x_return_status => l_return_status
245: ,x_msg_count => l_msg_count
246: ,x_msg_data => l_msg_data

Line 243: ,p_commit => fnd_api.g_false

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
244: ,x_return_status => l_return_status
245: ,x_msg_count => l_msg_count
246: ,x_msg_data => l_msg_data
247: ,p_trolin_tbl => l_in_trolin_tbl

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

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
256: IF g_debug <= gme_debug.g_log_statement THEN
257: gme_debug.put_line ( 'No. of move order lines created = '

Line 303: x_return_status := fnd_api.g_ret_sts_unexp_error;

299: || SQLERRM);
300: END IF;
301:
302: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
303: x_return_status := fnd_api.g_ret_sts_unexp_error;
304: END create_move_order_lines;
305:
306: PROCEDURE create_batch_move_order (
307: p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 360: x_return_status := fnd_api.g_ret_sts_success;

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;
361: FOR i IN 1 .. p_material_details_tbl.COUNT LOOP
362: IF ( p_material_details_tbl (i).line_type = -1
363: AND p_material_details_tbl (i).subinventory IS NOT NULL
364: AND p_material_details_tbl (i).material_requirement_date <

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

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

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

471: ,p_move_order_type => gme_common_pvt.g_move_order_type
472: ,x_move_order_header_id => l_move_order_header_id
473: ,x_return_status => l_return_status);
474:
475: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
476: RAISE create_mo_err;
477: ELSE
478: gme_move_orders_pvt.create_move_order_lines
479: (p_move_order_header_id => l_move_order_header_id

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

482: ,x_material_details_tbl => l_mtl_dtl_tbl_out
483: ,x_trolin_tbl => l_trolin_tbl
484: ,x_return_status => l_return_status);
485:
486: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
487: RAISE create_mo_err;
488: END IF;
489: END IF;
490: END IF;

Line 499: x_return_status := fnd_api.g_ret_sts_error;

495: EXCEPTION
496: WHEN create_mo_err OR unable_to_query_tree THEN
497: x_return_status := l_return_status;
498: WHEN uom_conversion_err THEN
499: x_return_status := fnd_api.g_ret_sts_error;
500: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
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);

Line 515: x_return_status := fnd_api.g_ret_sts_unexp_error;

511: || SQLERRM);
512: END IF;
513:
514: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
515: x_return_status := fnd_api.g_ret_sts_unexp_error;
516: END create_batch_move_order;
517:
518: PROCEDURE get_move_order_lines (
519: p_organization_id IN NUMBER

Line 548: x_return_status := fnd_api.g_ret_sts_success;

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;
549:
550: OPEN cur_move_order_lines;
551:
552: FETCH cur_move_order_lines

Line 572: x_return_status := fnd_api.g_ret_sts_unexp_error;

568: || SQLERRM);
569: END IF;
570:
571: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
572: x_return_status := fnd_api.g_ret_sts_unexp_error;
573: END get_move_order_lines;
574:
575: PROCEDURE delete_move_order_lines (
576: p_organization_id IN NUMBER

Line 613: x_return_status := fnd_api.g_ret_sts_success;

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;
614: gme_move_orders_pvt.get_move_order_lines
615: (p_organization_id => p_organization_id
616: ,p_batch_id => p_batch_id
617: ,p_material_detail_id => p_material_detail_id

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

617: ,p_material_detail_id => p_material_detail_id
618: ,x_mo_line_tbl => l_line_tbl
619: ,x_return_status => l_return_status);
620:
621: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
622: RAISE get_mo_line_err;
623: END IF;
624:
625: FOR i IN 1 .. l_line_tbl.COUNT LOOP

Line 652: ,p_init_msg_list => fnd_api.g_false

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
655: ,x_return_status => l_return_status
656: ,x_msg_count => l_msg_count

Line 653: ,p_return_values => fnd_api.g_false

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
655: ,x_return_status => l_return_status
656: ,x_msg_count => l_msg_count
657: ,x_msg_data => l_msg_data

Line 654: ,p_commit => fnd_api.g_false

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
655: ,x_return_status => l_return_status
656: ,x_msg_count => l_msg_count
657: ,x_msg_data => l_msg_data
658: ,p_trolin_tbl => l_trolin_tbl

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

658: ,p_trolin_tbl => l_trolin_tbl
659: ,p_trolin_old_tbl => l_old_trolin_tbl
660: ,x_trolin_tbl => l_out_trolin_tbl);
661:
662: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
663: RAISE delete_mo_line_err;
664: END IF;
665:
666: FOR i IN 1 .. l_trolin_tbl.COUNT LOOP

Line 690: ,p_init_msg_list => fnd_api.g_false

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
693: ,x_return_status => l_return_status
694: ,x_msg_count => l_msg_count

Line 691: ,p_return_values => fnd_api.g_false

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
693: ,x_return_status => l_return_status
694: ,x_msg_count => l_msg_count
695: ,x_msg_data => l_msg_data

Line 692: ,p_commit => fnd_api.g_false

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
693: ,x_return_status => l_return_status
694: ,x_msg_count => l_msg_count
695: ,x_msg_data => l_msg_data
696: ,p_trohdr_rec => l_trohdr_rec

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

698: ,x_trohdr_val_rec => l_out_trohdr_val_rec
699: ,x_trolin_tbl => l_out_trolin_tbl
700: ,x_trolin_val_tbl => l_trolin_val_tbl);
701:
702: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
703: RAISE delete_mo_hdr_err;
704: END IF;
705: END IF;
706: END IF;

Line 745: x_return_status := fnd_api.g_ret_sts_unexp_error;

741: || SQLERRM);
742: END IF;
743:
744: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
745: x_return_status := fnd_api.g_ret_sts_unexp_error;
746: END delete_move_order_lines;
747:
748: PROCEDURE update_move_order_lines (
749: p_batch_id IN NUMBER

Line 799: x_return_status := fnd_api.g_ret_sts_success;

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;
800:
801: IF (p_invis_move_line_id IS NOT NULL) THEN
802: l_trolin_tbl (1).operation := inv_globals.g_opr_update;
803: l_trolin_tbl (1).line_id := p_invis_move_line_id;

Line 905: ,p_init_msg_list => fnd_api.g_false

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
908: ,x_return_status => l_return_status
909: ,x_msg_count => l_msg_count

Line 906: ,p_return_values => fnd_api.g_false

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
908: ,x_return_status => l_return_status
909: ,x_msg_count => l_msg_count
910: ,x_msg_data => l_msg_data

Line 907: ,p_commit => fnd_api.g_false

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
908: ,x_return_status => l_return_status
909: ,x_msg_count => l_msg_count
910: ,x_msg_data => l_msg_data
911: ,p_trolin_tbl => l_trolin_tbl

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

911: ,p_trolin_tbl => l_trolin_tbl
912: ,p_trolin_old_tbl => l_old_trolin_tbl
913: ,x_trolin_tbl => l_out_trolin_tbl);
914:
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

Line 943: x_return_status := fnd_api.g_ret_sts_unexp_error;

939: || SQLERRM);
940: END IF;
941:
942: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
943: x_return_status := fnd_api.g_ret_sts_unexp_error;
944: END update_move_order_lines;
945:
946: FUNCTION pending_move_orders_exist (
947: p_organization_id IN NUMBER

Line 1037: x_return_status := fnd_api.g_ret_sts_success;

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;
1038: gme_move_orders_pvt.get_move_order_lines
1039: (p_organization_id => p_mtl_dtl_rec.organization_id
1040: ,p_batch_id => p_mtl_dtl_rec.batch_id
1041: ,p_material_detail_id => p_mtl_dtl_rec.material_detail_id

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

1041: ,p_material_detail_id => p_mtl_dtl_rec.material_detail_id
1042: ,x_mo_line_tbl => l_line_tbl
1043: ,x_return_status => l_return_status);
1044:
1045: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1046: RAISE get_mo_line_err;
1047: END IF;
1048:
1049: FOR i IN 1 .. l_line_tbl.COUNT LOOP

Line 1092: x_return_status := fnd_api.g_ret_sts_error;

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;
1093: fnd_message.set_name ('GMI', 'IC_API_UOM_CONVERSION_ERROR');
1094: fnd_message.set_token ('ITEM_NO', l_item_no);
1095: fnd_message.set_token ('FROM_UOM', l_from_uom);
1096: fnd_message.set_token ('TO_UOM', l_to_uom);

Line 1111: x_return_status := fnd_api.g_ret_sts_unexp_error;

1107: || SQLERRM);
1108: END IF;
1109:
1110: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1111: x_return_status := fnd_api.g_ret_sts_unexp_error;
1112: END get_pending_move_order_qty;
1113:
1114: PROCEDURE delete_batch_move_orders (
1115: p_organization_id IN NUMBER

Line 1146: x_return_status := fnd_api.g_ret_sts_success;

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;
1147:
1148: OPEN cur_batch_lines;
1149:
1150: FETCH cur_batch_lines

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

1152:
1153: CLOSE cur_batch_lines;
1154:
1155: FOR i IN 1 .. l_lines_tbl.COUNT LOOP
1156: IF (p_delete_invis = fnd_api.g_true) THEN
1157: l_invis_line_id := l_lines_tbl (i).move_order_line_id;
1158: l_invis_header_id := l_lines_tbl (i).move_order_header_id;
1159: END IF;
1160:

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

1165: ,p_invis_move_line_id => l_invis_line_id
1166: ,p_invis_move_header_id => l_invis_header_id
1167: ,x_return_status => l_return_status);
1168:
1169: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
1170: RAISE del_mo_lines_err;
1171: END IF;
1172: END LOOP;
1173:

Line 1191: x_return_status := fnd_api.g_ret_sts_unexp_error;

1187: || SQLERRM);
1188: END IF;
1189:
1190: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
1191: x_return_status := fnd_api.g_ret_sts_unexp_error;
1192: END delete_batch_move_orders;
1193: END gme_move_orders_pvt;