DBA Data[Home] [Help]

APPS.WMS_REPLENISHMENT_PVT dependencies on INV_MOVE_ORDER_PUB

Line 3239: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

3235: -- In case of Push Replenishement, once all replenishment tasks are
3236: -- completed, user will perform pick release manually.
3237: -- Just to keep in mind, we do not distinguish dynamic and push in the Allocate_repl_move_order Conc Request
3238:
3239: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3240: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3241: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3242: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3243: l_commit VARCHAR2(1) := FND_API.G_TRUE;

Line 3240: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

3236: -- completed, user will perform pick release manually.
3237: -- Just to keep in mind, we do not distinguish dynamic and push in the Allocate_repl_move_order Conc Request
3238:
3239: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3240: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3241: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3242: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3243: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3244:

Line 3241: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;

3237: -- Just to keep in mind, we do not distinguish dynamic and push in the Allocate_repl_move_order Conc Request
3238:
3239: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3240: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3241: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3242: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3243: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3244:
3245: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

Line 3242: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;

3238:
3239: l_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3240: l_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3241: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3242: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3243: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3244:
3245: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3246: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

Line 3245: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3241: l_x_trohdr_rec INV_Move_Order_PUB.Trohdr_Rec_Type;
3242: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3243: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3244:
3245: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3246: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3247: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3248: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3249:

Line 3246: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3242: l_x_trohdr_val_rec INV_Move_Order_PUB.Trohdr_Val_Rec_Type;
3243: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3244:
3245: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3246: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3247: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3248: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3249:
3250: l_return_status VARCHAR2(1);

Line 3247: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;

3243: l_commit VARCHAR2(1) := FND_API.G_TRUE;
3244:
3245: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3246: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3247: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3248: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3249:
3250: l_return_status VARCHAR2(1);
3251: l_msg_count NUMBER;

Line 3248: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;

3244:
3245: l_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3246: l_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3247: l_x_trolin_tbl INV_Move_Order_PUB.Trolin_Tbl_Type;
3248: l_x_trolin_val_tbl INV_Move_Order_PUB.Trolin_Val_Tbl_Type;
3249:
3250: l_return_status VARCHAR2(1);
3251: l_msg_count NUMBER;
3252: l_msg_data VARCHAR2(1000);

Line 3451: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Header');

3447: l_trohdr_rec.organization_id := p_consol_item_repl_tbl(i).organization_id;
3448:
3449: -- Create MO Header
3450: IF l_debug = 1 THEN
3451: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Header');
3452: END IF;
3453:
3454: INV_Move_Order_PUB.Create_Move_Order_Header(p_api_version_number => 1.0,
3455: p_init_msg_list => FND_API.G_FALSE,

Line 3454: INV_Move_Order_PUB.Create_Move_Order_Header(p_api_version_number => 1.0,

3450: IF l_debug = 1 THEN
3451: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Header');
3452: END IF;
3453:
3454: INV_Move_Order_PUB.Create_Move_Order_Header(p_api_version_number => 1.0,
3455: p_init_msg_list => FND_API.G_FALSE,
3456: p_return_values => FND_API.G_TRUE,
3457: p_commit => l_commit,
3458: x_return_status => l_return_status,

Line 3465: p_validation_flag => inv_move_order_pub.g_validation_yes

3461: p_trohdr_rec => l_trohdr_rec,
3462: p_trohdr_val_rec => l_trohdr_val_rec,
3463: x_trohdr_rec => l_x_trohdr_rec,
3464: x_trohdr_val_rec => l_x_trohdr_val_rec,
3465: p_validation_flag => inv_move_order_pub.g_validation_yes
3466: );
3467:
3468:
3469: IF l_debug = 1 THEN

Line 3708: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Lines');

3704: l_order_count:= 1;
3705:
3706: -- Create MO Lines
3707: IF l_debug = 1 THEN
3708: print_debug('CALLING INV_Move_Order_PUB.Create_Move_Order_Lines');
3709: END IF;
3710: l_line_num := l_line_num + 1;
3711: l_trolin_tbl(l_order_count).header_id := l_x_trohdr_rec.header_id;
3712: l_trolin_tbl(l_order_count).created_by := fnd_global.user_id;

Line 3758: INV_Move_Order_PUB.Create_Move_Order_Lines(

3754: -- mo header IN THE l_trolin_tbl TABLE AND THEN CALL ONLY ONCE FOR
3755: -- PERFORMACE REASON. THEN FOR EACH MO LINE FROM THE SAME TABLE,
3756: -- CREATE RESERVATION FOR CORRESPONDING DEMAND LINES, IF NEEDED
3757: l_return_status := fnd_api.g_ret_sts_success;
3758: INV_Move_Order_PUB.Create_Move_Order_Lines(
3759: p_api_version_number => 1.0,
3760: p_init_msg_list => FND_API.G_FALSE,
3761: p_commit => FND_API.G_FALSE, --BUG14504260
3762: x_return_status => l_return_status,

Line 3773: print_debug('After call to INV_Move_Order_PUB.Create_Move_Order_Lines');

3769: p_validation_flag => 'Y' );
3770:
3771:
3772: IF L_DEBUG = 1 THEN
3773: print_debug('After call to INV_Move_Order_PUB.Create_Move_Order_Lines');
3774: END IF;
3775:
3776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3777:

Line 3779: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with expected error returning message: ' || l_msg_data || l_msg_count);

3775:
3776: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
3777:
3778: IF L_DEBUG = 1 THEN
3779: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with expected error returning message: ' || l_msg_data || l_msg_count);
3780: END IF;
3781: IF l_msg_count > 0 THEN
3782: FOR i in 1 .. l_msg_count LOOP
3783: l_msg := fnd_msg_pub.get(i, 'F');

Line 3793: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data);

3789: l_trolin_tbl.DELETE(l_order_count);
3790: GOTO next_consol_rec;
3791: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3792: IF L_DEBUG= 1 THEN
3793: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines failed with unexpected error returning message: ' || l_msg_data);
3794: END IF;
3795:
3796: IF l_msg_count > 0 THEN
3797: FOR i in 1 .. l_msg_count LOOP

Line 3808: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines returned success');

3804: l_trolin_tbl.DELETE(l_order_count);
3805: GOTO next_consol_rec;
3806: ELSE
3807: IF L_DEBUG = 1 THEN
3808: print_debug('INV_Move_Order_PUB.Create_Move_Order_Lines returned success');
3809: END IF;
3810: END IF;
3811:
3812: