1: PACKAGE BODY gme_move_orders_pvt AS
2: /* $Header: GMEVMOVB.pls 120.19.12020000.2 2012/07/26 15:50:05 gmurator ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MOVE_ORDERS_PVT';
5:
1: PACKAGE BODY gme_move_orders_pvt AS
2: /* $Header: GMEVMOVB.pls 120.19.12020000.2 2012/07/26 15:50:05 gmurator ship $ */
3: g_debug VARCHAR2 (5) := fnd_profile.VALUE ('AFLOG_LEVEL');
4: g_pkg_name CONSTANT VARCHAR2 (30) := 'GME_MOVE_ORDERS_PVT';
5:
6: /*************************************************************************************************/
7: /* Oracle Process Manufacturing Process Execution APIs */
8: /* */
528: END IF;
529: END IF;
530: END LOOP;
531: IF (l_count > 0) THEN
532: gme_move_orders_pvt.create_move_order_hdr
533: (p_organization_id => p_batch_header_rec.organization_id
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
543: ,p_move_order_type => gme_common_pvt.g_move_order_type
544: ,p_material_details_tbl => l_mtl_dtl_tbl
545: ,x_material_details_tbl => l_mtl_dtl_tbl_out
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
681: ,x_mo_line_tbl => l_line_tbl
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
1239: ,x_mo_line_tbl => l_line_tbl
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;