[Home] [Help]
132: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);
133: /* triangulation country would be the country where the RMA was created/booked */
134: l_movement_transaction.triangulation_country_code := l_movement_transaction.dispatch_territory_code;
135:
136: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
137: (p_api_version_number => 1.0
138: ,p_init_msg_list => FND_API.G_FALSE
139: ,x_movement_transaction => l_movement_transaction
140: ,x_msg_count => x_msg_count
829: --the transaction is not inside of start period and end period
830: --so not create transaction
831: CLOSE ref_crsr;
832: ELSE
833: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
834: ( x_movement_transaction => l_movement_transaction);
835:
836: --Get subinventory location fix bug 2683302
837: l_subinv_terr_code :=
934: INV_MGD_MVT_UTILS_PKG.Get_Org_VAT_Number
935: ( p_entity_org_id => l_movement_transaction.entity_org_id
936: , p_date => l_movement_transaction.transaction_date);
937:
938: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
939: ( p_api_version_number => 1.0
940: , p_init_msg_list => FND_API.G_FALSE
941: , x_movement_transaction => l_movement_transaction
942: , x_msg_count => x_msg_count
1281: ||','||l_stat_typ_transaction.reference_period_rule
1282: ,'debug msg');
1283: END IF;
1284:
1285: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
1286: (x_movement_transaction => l_movement_transaction);
1287:
1288: --Get legal entity where this SO is created
1289: l_so_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity
1462: THEN
1463: l_movement_transaction.movement_id := null;
1464: END IF;
1465:
1466: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
1467: (p_api_version_number => 1.0
1468: ,p_init_msg_list => FND_API.G_FALSE
1469: ,x_movement_transaction => l_movement_transaction
1470: ,x_msg_count => x_msg_count
1736: IF (l_shipping_le_id IS NOT NULL
1737: AND l_shipping_le_id <> l_movement_transaction.entity_org_id)
1738: THEN
1739: --Initialize movement record
1740: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
1741: (x_movement_transaction => l_movement_transaction);
1742:
1743: --Find out territory code for legal entity
1744: l_le_territory_code :=
1972: ELSE
1973: l_movement_transaction.financial_document_flag := 'PROCESSED_INCLUDED';
1974: END IF;
1975:
1976: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
1977: (p_api_version_number => 1.0
1978: ,p_init_msg_list => FND_API.G_FALSE
1979: ,x_movement_transaction => l_movement_transaction
1980: ,x_msg_count => x_msg_count
2125: ELSE
2126: l_movement_transaction2.financial_document_flag := 'PROCESSED_INCLUDED';
2127: END IF;
2128:
2129: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
2130: (p_api_version_number => 1.0
2131: ,p_init_msg_list => FND_API.G_FALSE
2132: ,x_movement_transaction => l_movement_transaction2
2133: ,x_msg_count => x_msg_count
2355: , l_movement_transaction.picking_line_detail_id
2356: , l_shipping_org_id;
2357: CLOSE shipping_org;
2358:
2359: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
2360: (x_movement_transaction => l_movement_transaction);
2361:
2362: --Find out territory code
2363: l_subinv_terr_code :=
2497: l_movement_transaction.customer_vat_number :=
2498: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2499: (l_movement_transaction.bill_to_site_use_id);
2500:
2501: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
2502: (p_api_version_number => 1.0
2503: ,p_init_msg_list => FND_API.G_FALSE
2504: ,x_movement_transaction => l_movement_transaction
2505: ,x_msg_count => x_msg_count
2842: --Set movement_id,used to insert into parent_movement_id for new record
2843: x_mvt_rtv_transaction.movement_id := l_parent_mvt_id;
2844:
2845: --Insert rtv arrival adjustment record
2846: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
2847: ( p_api_version_number => 1.0
2848: , p_init_msg_list => FND_API.G_FALSE
2849: , x_movement_transaction => x_mvt_rtv_transaction
2850: , x_msg_count => x_msg_count
3067: l_parent_mvt_transaction.invoice_quantity;
3068: END IF;
3069:
3070: --Update parent PO
3071: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
3072: ( p_movement_statistics => l_parent_mvt_transaction
3073: , x_return_status => l_return_status
3074: , x_msg_count => x_msg_count
3075: , x_msg_data => x_msg_data
3363: ||','||l_stat_typ_transaction.reference_period_rule
3364: ,'debug msg');
3365: END IF;
3366:
3367: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
3368: (x_movement_transaction => l_movement_transaction);
3369:
3370: IF (p_transaction_type = 'RTV')
3371: AND (l_receipt_transaction.transaction_type = 'RECEIVE')
3604: ( x_mvt_rtv_transaction => l_movement_transaction
3605: , x_return_status => l_insert_status
3606: );
3607: ELSE
3608: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
3609: (p_api_version_number => 1.0
3610: ,p_init_msg_list => FND_API.G_FALSE
3611: ,x_movement_transaction => l_movement_transaction
3612: ,x_msg_count => x_msg_count
3723: l_movement_transaction.financial_document_flag
3724: := 'PROCESSED_INCLUDED';
3725: END IF;
3726:
3727: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
3728: (p_api_version_number => 1.0
3729: ,p_init_msg_list => FND_API.G_FALSE
3730: ,x_movement_transaction => l_movement_transaction
3731: ,x_msg_count => x_msg_count
3866: l_movement_transaction.financial_document_flag
3867: := 'PROCESSED_INCLUDED';
3868: END IF;
3869:
3870: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
3871: (p_api_version_number => 1.0
3872: ,p_init_msg_list => FND_API.G_FALSE
3873: ,x_movement_transaction => l_movement_transaction
3874: ,x_msg_count => x_msg_count
4238: --Set movement_id,used to insert into parent_movement_id for new record
4239: x_mvt_rma_transaction.movement_id := l_parent_mvt_id;
4240:
4241: --Insert rma arrival adjustment record
4242: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
4243: ( p_api_version_number => 1.0
4244: , p_init_msg_list => FND_API.G_FALSE
4245: , x_movement_transaction => x_mvt_rma_transaction
4246: , x_msg_count => x_msg_count
4463: l_parent_mvt_transaction.invoice_quantity;
4464: END IF;
4465:
4466: --Update parent SO
4467: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
4468: ( p_movement_statistics => l_parent_mvt_transaction
4469: , x_return_status => l_return_status
4470: , x_msg_count => x_msg_count
4471: , x_msg_data => x_msg_data
4743: --the transaction is not inside of start period and end period
4744: --so not create transaction
4745: CLOSE ref_crsr;
4746: ELSE
4747: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
4748: (x_movement_transaction => l_movement_transaction);
4749:
4750: -- The RMA details is fetched here because sometimes the ship_to_site
4751: -- is not present in the RCV table; hence we get the ship to site from
5063: ( x_mvt_rma_transaction => l_movement_transaction
5064: , x_return_status => l_insert_status
5065: );
5066: ELSE
5067: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics
5068: (p_api_version_number => 1.0
5069: ,p_init_msg_list => FND_API.G_FALSE
5070: ,x_movement_transaction => l_movement_transaction
5071: ,x_msg_count => x_msg_count
5212: l_movement_transaction := p_movement_transaction;
5213:
5214: -- Call the transaction proxy which processes all the transactions.
5215:
5216: INV_MGD_MVT_STATS_PVT.Get_Invoice_Transactions
5217: ( inv_crsr => inv_crsr
5218: , p_movement_transaction => l_movement_transaction
5219: , p_start_date => p_start_date
5220: , p_end_date => p_end_date
5451: l_movement_transaction.invoice_quantity := null;
5452: END IF;
5453:
5454:
5455: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
5456: (p_movement_statistics => l_movement_transaction
5457: , x_return_status => l_return_status
5458: , x_msg_count => x_msg_count
5459: , x_msg_data => x_msg_data
5576: x_return_status := FND_API.G_RET_STS_SUCCESS;
5577:
5578: -- Call the transaction proxy which processes all the PO and RTV transactions
5579: -- with corrections in the specified date range.
5580: INV_MGD_MVT_STATS_PVT.Get_PO_Trans_With_Correction
5581: ( inv_crsr => inv_crsr
5582: , p_legal_entity_id => p_legal_entity_id
5583: , p_start_date => p_start_date
5584: , p_end_date => p_end_date
5814: l_movement_transaction.unit_weight := null;
5815: END IF;
5816:
5817: --Update original movement records
5818: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
5819: ( p_movement_statistics => l_movement_transaction
5820: , x_return_status => l_return_status
5821: , x_msg_count => x_msg_count
5822: , x_msg_data => x_msg_data
5940: l_movement_transaction := p_movement_transaction;
5941:
5942: -- Call the transaction proxy which processes all the transactions.
5943:
5944: INV_MGD_MVT_STATS_PVT.Get_Pending_Txns
5945: ( p_movement_transaction => l_movement_transaction
5946: , val_crsr => mvt_crsr
5947: , p_document_source_type => p_transaction_type
5948: , x_return_status => l_return_status);
6209:
6210: l_movement_transaction.financial_document_flag := 'PROCESSED_INCLUDED';
6211: l_movement_transaction.movement_status := 'O';
6212:
6213: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
6214: (p_movement_statistics => l_movement_transaction
6215: , x_return_status => l_return_status
6216: , x_msg_count => x_msg_count
6217: , x_msg_data => x_msg_data
6222: ELSE
6223: IF ( sysdate > l_movement_transaction.transaction_date )
6224: THEN
6225: l_movement_transaction.movement_status :='O';
6226: INV_MGD_MVT_STATS_PVT.Update_Movement_Statistics
6227: (p_movement_statistics => l_movement_transaction
6228: , x_return_status => l_return_status
6229: , x_msg_count => x_msg_count
6230: , x_msg_data => x_msg_data