3930:
3931: l_print_mode VARCHAR2(1); --used for print pick slip which is not required
3932: l_grouping_rule_id NUMBER; -- get its value from shipping parameter however it is used for print pick slip which is not required
3933: l_detail_rec_count NUMBER;
3934: l_mo_line_tbl inv_move_order_pub.Trolin_Tbl_Type;
3935: l_mo_line INV_Move_Order_PUB.TROLIN_REC_TYPE;
3936:
3937: l_return_status VARCHAR2(3);
3938: l_msg_count number;
3931: l_print_mode VARCHAR2(1); --used for print pick slip which is not required
3932: l_grouping_rule_id NUMBER; -- get its value from shipping parameter however it is used for print pick slip which is not required
3933: l_detail_rec_count NUMBER;
3934: l_mo_line_tbl inv_move_order_pub.Trolin_Tbl_Type;
3935: l_mo_line INV_Move_Order_PUB.TROLIN_REC_TYPE;
3936:
3937: l_return_status VARCHAR2(3);
3938: l_msg_count number;
3939: l_msg_data varchar2(1000);
9699: l_group_info wsh_delivery_autocreate.grp_attr_tab_type;
9700: l_matched_entities wsh_util_core.id_tab_type;
9701: l_out_rec wsh_delivery_autocreate.out_rec_type;
9702: p_line_rows wsh_util_core.id_tab_type;
9703: p_carton_grouping_tbl inv_move_order_pub.num_tbl_type;
9704: p_move_order_line_tbl inv_move_order_pub.num_tbl_type;
9705: l_match_found boolean;
9706: x_return_status varchar2(1);
9707:
9700: l_matched_entities wsh_util_core.id_tab_type;
9701: l_out_rec wsh_delivery_autocreate.out_rec_type;
9702: p_line_rows wsh_util_core.id_tab_type;
9703: p_carton_grouping_tbl inv_move_order_pub.num_tbl_type;
9704: p_move_order_line_tbl inv_move_order_pub.num_tbl_type;
9705: l_match_found boolean;
9706: x_return_status varchar2(1);
9707:
9708: -- For Creating Move Order Header
9706: x_return_status varchar2(1);
9707:
9708: -- For Creating Move Order Header
9709:
9710: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9711: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9712: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9713: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9714: l_commit VARCHAR2(1) := FND_API.G_TRUE;
9707:
9708: -- For Creating Move Order Header
9709:
9710: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9711: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9712: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9713: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9714: l_commit VARCHAR2(1) := FND_API.G_TRUE;
9715:
9708: -- For Creating Move Order Header
9709:
9710: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9711: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9712: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9713: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9714: l_commit VARCHAR2(1) := FND_API.G_TRUE;
9715:
9716: TYPE group_match_seq_rec_type IS RECORD(
9709:
9710: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9711: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9712: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
9713: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
9714: l_commit VARCHAR2(1) := FND_API.G_TRUE;
9715:
9716: TYPE group_match_seq_rec_type IS RECORD(
9717: delivery_detail_id NUMBER,
10649: .delivery_group_id;
10650:
10651: end loop;
10652:
10653: print_debug('Calling the inv_move_order_pub.stamp_cart_id : ',
10654: l_debug);
10655:
10656: inv_move_order_pub.stamp_cart_id(p_validation_level => 1,
10657: p_carton_grouping_tbl => p_carton_grouping_tbl,
10652:
10653: print_debug('Calling the inv_move_order_pub.stamp_cart_id : ',
10654: l_debug);
10655:
10656: inv_move_order_pub.stamp_cart_id(p_validation_level => 1,
10657: p_carton_grouping_tbl => p_carton_grouping_tbl,
10658: p_move_order_line_tbl => p_move_order_line_tbl);
10659:
10660: print_debug(' After calling inv_move_order_pub.stamp_cart_id -- > Now we Release the Tasks ',
10656: inv_move_order_pub.stamp_cart_id(p_validation_level => 1,
10657: p_carton_grouping_tbl => p_carton_grouping_tbl,
10658: p_move_order_line_tbl => p_move_order_line_tbl);
10659:
10660: print_debug(' After calling inv_move_order_pub.stamp_cart_id -- > Now we Release the Tasks ',
10661: l_debug);
10662:
10663: print_debug('Pre cartonization code ends here ----> ', l_debug);
10664:
10790: l_trohdr_rec.transaction_type_id := INV_GLOBALS.G_TYPE_TRANSFER_ORDER_STGXFR;
10791: l_trohdr_rec.operation := INV_GLOBALS.G_OPR_CREATE;
10792: l_trohdr_rec.db_flag := FND_API.G_TRUE;
10793:
10794: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Header',
10795: l_debug);
10796:
10797: INV_Move_Order_PUB.Create_Move_Order_Header(p_api_version_number => 1.0,
10798: p_init_msg_list => FND_API.G_FALSE,
10793:
10794: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Header',
10795: l_debug);
10796:
10797: INV_Move_Order_PUB.Create_Move_Order_Header(p_api_version_number => 1.0,
10798: p_init_msg_list => FND_API.G_FALSE,
10799: p_return_values => FND_API.G_TRUE,
10800: p_commit => l_commit,
10801: x_return_status => x_return_status,
10804: p_trohdr_rec => l_trohdr_rec,
10805: p_trohdr_val_rec => l_trohdr_val_rec,
10806: x_trohdr_rec => l_x_trohdr_rec,
10807: x_trohdr_val_rec => l_x_trohdr_val_rec,
10808: p_validation_flag => inv_move_order_pub.g_validation_yes);
10809:
10810: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
10811:
10812: print_debug('Creating MO Header failed with unexpected error returning message: ' ||
17813: x_result := 'E';
17814:
17815: END cancel_mmtt;
17816:
17817: PROCEDURE update_wave_lines_tbl (p_mo_line_table IN INV_Move_Order_PUB.TROLIN_TBL_TYPE
17818: ,x_return_status OUT NOCOPY VARCHAR2) IS
17819:
17820: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
17821: TYPE num_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;