DBA Data[Home] [Help]

APPS.GME_MATERIAL_DETAIL_PVT dependencies on GME_MOVE_ORDERS_PVT

Line 174: gme_move_orders_pvt.create_move_order_lines

170: p_batch_header_rec.update_inventory_ind = 'Y' THEN
171: l_material_detail_tbl (1) := x_material_detail_rec;
172:
173: -- add material line into invisible move order
174: gme_move_orders_pvt.create_move_order_lines
175: (p_move_order_header_id => p_batch_header_rec.move_order_header_id
176: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
177: ,p_material_details_tbl => l_material_detail_tbl
178: ,x_material_details_tbl => l_out_material_detail_tbl

Line 183: l_proc := 'gme_move_orders_pvt.create_move_order_lines';

179: ,x_trolin_tbl => l_trolin_tbl
180: ,x_return_status => x_return_status);
181:
182: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
183: l_proc := 'gme_move_orders_pvt.create_move_order_lines';
184: RAISE error_processing;
185: END IF;
186:
187: x_material_detail_rec := l_out_material_detail_tbl(1);

Line 3665: gme_move_orders_pvt.update_move_order_lines

3661:
3662: -- Bug 13076579 - Restructured following condition.
3663: /*
3664: IF l_factor <> 1 THEN -- will only be for pending and WIP
3665: gme_move_orders_pvt.update_move_order_lines
3666: (p_batch_id => l_mtl_dtl_rec.batch_id
3667: ,p_material_detail_id => l_mtl_dtl_rec.material_detail_id
3668: ,p_new_qty => l_qty
3669: ,p_new_date => l_mtl_dtl_rec.material_requirement_date

Line 3674: l_proc := 'gme_move_orders_pvt.update_move_order_lines';

3670: ,p_invis_move_line_id => NULL
3671: ,x_return_status => x_return_status);
3672:
3673: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3674: l_proc := 'gme_move_orders_pvt.update_move_order_lines';
3675: RAISE error_processing;
3676: END IF;
3677: END IF;
3678: */

Line 3692: gme_move_orders_pvt.update_move_order_lines

3688: -- Increase differences will be accounted for when user does picking.
3689: IF (l_qty < l_compare_qty) THEN
3690: -- Bug 14612460 - if the new qty is zero then we just need to delete the move orders.
3691: IF (l_qty > 0) THEN
3692: gme_move_orders_pvt.update_move_order_lines
3693: (p_batch_id => l_mtl_dtl_rec.batch_id
3694: ,p_material_detail_id => l_mtl_dtl_rec.material_detail_id
3695: ,p_new_qty => l_qty
3696: ,p_new_date => l_mtl_dtl_rec.material_requirement_date

Line 3701: l_proc := 'gme_move_orders_pvt.update_move_order_lines';

3697: ,p_invis_move_line_id => NULL
3698: ,x_return_status => x_return_status);
3699:
3700: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3701: l_proc := 'gme_move_orders_pvt.update_move_order_lines';
3702: RAISE error_processing;
3703: END IF;
3704: ELSE
3705: gme_move_orders_pvt.delete_move_order_lines

Line 3705: gme_move_orders_pvt.delete_move_order_lines

3701: l_proc := 'gme_move_orders_pvt.update_move_order_lines';
3702: RAISE error_processing;
3703: END IF;
3704: ELSE
3705: gme_move_orders_pvt.delete_move_order_lines
3706: (p_organization_id => l_mtl_dtl_rec.organization_id
3707: ,p_batch_id => l_mtl_dtl_rec.batch_id
3708: ,p_material_detail_id => l_mtl_dtl_rec.material_detail_id
3709: ,p_invis_move_line_id => NULL

Line 3713: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';

3709: ,p_invis_move_line_id => NULL
3710: ,x_return_status => x_return_status);
3711:
3712: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3713: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';
3714: RAISE error_processing;
3715: END IF;
3716: END IF;
3717: END IF;

Line 3724: gme_move_orders_pvt.delete_move_order_lines

3720:
3721:
3722: IF l_mtl_dtl_rec.phantom_type <> l_db_mtl_dtl_rec.phantom_type THEN
3723: IF l_mtl_dtl_rec.phantom_type IN (1,2) THEN -- phantom ing should not have invisible mo line
3724: gme_move_orders_pvt.delete_move_order_lines
3725: (p_organization_id => p_batch_header_rec.organization_id
3726: ,p_batch_id => p_batch_header_rec.batch_id
3727: ,p_material_detail_id => l_mtl_dtl_rec.material_detail_id
3728: ,p_invis_move_line_id => l_mtl_dtl_rec.move_order_line_id

Line 3732: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';

3728: ,p_invis_move_line_id => l_mtl_dtl_rec.move_order_line_id
3729: ,x_return_status => x_return_status);
3730:
3731: IF x_return_status <> fnd_api.g_ret_sts_success THEN
3732: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';
3733: RAISE error_processing;
3734: END IF;
3735:
3736: l_mtl_dtl_rec.move_order_line_id := NULL;

Line 3742: gme_move_orders_pvt.create_move_order_lines

3738: ELSE -- phantom type is changed to 0 -> not a phantom, so the invisible mo line must be created
3739: l_material_detail_tbl (1) := l_mtl_dtl_rec;
3740:
3741: -- add material line into invisible move order
3742: gme_move_orders_pvt.create_move_order_lines
3743: (p_move_order_header_id => p_batch_header_rec.move_order_header_id
3744: ,p_move_order_type => gme_common_pvt.g_invis_move_order_type
3745: ,p_material_details_tbl => l_material_detail_tbl
3746: ,x_material_details_tbl => l_out_material_detail_tbl

Line 3751: l_proc := 'gme_move_orders_pvt.create_move_order_lines';

3747: ,x_trolin_tbl => l_trolin_tbl
3748: ,x_return_status => x_return_status);
3749:
3750: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3751: l_proc := 'gme_move_orders_pvt.create_move_order_lines';
3752: RAISE error_processing;
3753: END IF;
3754:
3755: l_mtl_dtl_rec := l_out_material_detail_tbl(1);

Line 4573: IF gme_move_orders_pvt.pending_move_orders_exist

4569: gme_common_pvt.log_message ('GME_PENDING_RSRV_EXIST');
4570: RAISE val_error;
4571: END IF;
4572:
4573: IF gme_move_orders_pvt.pending_move_orders_exist
4574: (p_organization_id => p_material_detail_rec.organization_id
4575: ,p_batch_id => p_material_detail_rec.batch_id
4576: ,p_material_detail_id => p_material_detail_rec.material_detail_id) THEN
4577: gme_common_pvt.log_message ('GME_PENDING_MO_EXIST');

Line 4643: gme_move_orders_pvt.delete_move_order_lines

4639: l_proc := 'gme_pending_product_lots.delete_pending_product_lot';
4640: RAISE error_processing;
4641: END IF;
4642:
4643: gme_move_orders_pvt.delete_move_order_lines
4644: (p_organization_id => p_batch_header_rec.organization_id
4645: ,p_batch_id => p_batch_header_rec.batch_id
4646: ,p_material_detail_id => p_material_detail_rec.material_detail_id
4647: ,p_invis_move_line_id => p_material_detail_rec.move_order_line_id

Line 4651: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';

4647: ,p_invis_move_line_id => p_material_detail_rec.move_order_line_id
4648: ,x_return_status => x_return_status);
4649:
4650: IF x_return_status <> fnd_api.g_ret_sts_success THEN
4651: l_proc := 'gme_move_orders_pvt.delete_move_order_lines';
4652: RAISE error_processing;
4653: END IF;
4654:
4655: gme_reservations_pvt.delete_material_reservations (