eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_MGD_MVT_STATS_PROC dependencies on INV_MGD_MVT_UTILS_PKG

Line 96: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

92: x_return_status := FND_API.G_RET_STS_SUCCESS;
93: l_movement_transaction := p_movement_transaction;
94: l_stat_typ_transaction := p_stat_typ_transaction;
95:
96: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
97: ( p_stat_typ_transaction => l_stat_typ_transaction
98: , x_movement_transaction => l_movement_transaction
99: , x_return_status => l_return_status
100: );

Line 115: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

111: END IF;
112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
113: ELSE
114: l_movement_transaction.customer_vat_number :=
115: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
116: (l_movement_transaction.bill_to_site_use_id);
117:
118: IF l_movement_transaction.invoice_id IS NULL
119: THEN

Line 130: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);

126:
127: /* Set the parameters for the RMA Dispatch transaction */
128: l_movement_transaction.movement_type := 'D';
129: l_movement_transaction.dispatch_territory_code :=
130: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
131: l_movement_transaction.destination_territory_code :=
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;

Line 132: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);

128: l_movement_transaction.movement_type := 'D';
129: l_movement_transaction.dispatch_territory_code :=
130: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
131: l_movement_transaction.destination_territory_code :=
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

Line 838: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

834: ( x_movement_transaction => l_movement_transaction);
835:
836: --Get subinventory location fix bug 2683302
837: l_subinv_terr_code :=
838: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
839: ( p_warehouse_id => l_movement_transaction.organization_id
840: , p_subinv_code => l_subinv_code);
841:
842: l_transfer_subinv_terr_code :=

Line 843: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

839: ( p_warehouse_id => l_movement_transaction.organization_id
840: , p_subinv_code => l_subinv_code);
841:
842: l_transfer_subinv_terr_code :=
843: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
844: ( p_warehouse_id => l_movement_transaction.transfer_organization_id
845: , p_subinv_code => l_transfer_subinv);
846:
847: --Get organization location

Line 849: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

845: , p_subinv_code => l_transfer_subinv);
846:
847: --Get organization location
848: l_org_terr_code :=
849: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
850: (p_warehouse_id => l_movement_transaction.organization_id);
851:
852: l_transfer_org_terr_code :=
853: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 853: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

849: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
850: (p_warehouse_id => l_movement_transaction.organization_id);
851:
852: l_transfer_org_terr_code :=
853: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
854: (p_warehouse_id => l_movement_transaction.transfer_organization_id);
855:
856: --Get legal entity location
857: -- Bug: 5920143. Calculate LE Territory code only when

Line 862: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

858: -- user has selected Include Establishments as No
859: IF(l_stat_typ_transaction.include_establishments = 'N')
860: THEN
861: l_le_terr_code :=
862: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
863: (p_le_id => l_movement_transaction.entity_org_id);
864: END IF;
865: -- For every record fetched get the dispatch and destination territory
866: -- codes.

Line 913: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

909: );
910:
911: IF l_return_status = 'Y'
912: THEN
913: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
914: ( p_stat_typ_transaction => l_stat_typ_transaction
915: , x_movement_transaction => l_movement_transaction
916: , x_return_status => l_return_status
917: );

Line 934: INV_MGD_MVT_UTILS_PKG.Get_Org_VAT_Number

930: ELSE
931:
932: --Get legal entity vat number stored in customer_vat_number
933: l_movement_transaction.customer_vat_number :=
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

Line 1289: l_so_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity

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
1290: (p_order_line_id => l_movement_transaction.order_line_id);
1291:
1292: --Find out the territory code
1293: l_so_le_terri_code :=

Line 1294: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1290: (p_order_line_id => l_movement_transaction.order_line_id);
1291:
1292: --Find out the territory code
1293: l_so_le_terri_code :=
1294: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1295: (p_le_id => l_so_le_id);
1296:
1297: l_shipping_le_terri_code :=
1298: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

Line 1298: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1294: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1295: (p_le_id => l_so_le_id);
1296:
1297: l_shipping_le_terri_code :=
1298: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1299: (p_le_id => l_movement_transaction.entity_org_id);
1300:
1301: l_shipping_org_terri_code :=
1302: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 1302: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

1298: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1299: (p_le_id => l_movement_transaction.entity_org_id);
1300:
1301: l_shipping_org_terri_code :=
1302: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
1303: (p_warehouse_id => l_movement_transaction.organization_id);
1304:
1305: l_customer_terri_code :=
1306: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

Line 1306: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

1302: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
1303: (p_warehouse_id => l_movement_transaction.organization_id);
1304:
1305: l_customer_terri_code :=
1306: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
1307: (p_site_use_id =>l_movement_transaction.ship_to_site_use_id);
1308:
1309: -- If cross legal entity transaction,the destination
1310: -- territory code is depend on if it's invoiced based

Line 1415: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

1411: );
1412: END IF;
1413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1414: ELSE
1415: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
1416: (p_stat_typ_transaction => l_stat_typ_transaction
1417: ,x_movement_transaction => l_movement_transaction
1418: ,x_return_status => l_return_status
1419: );

Line 1434: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

1430: END IF;
1431: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1432: ELSE
1433: l_movement_transaction.customer_vat_number :=
1434: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
1435: (l_movement_transaction.bill_to_site_use_id);
1436:
1437: IF l_movement_transaction.document_source_type <> 'IO'
1438: THEN

Line 1732: l_shipping_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity

1728: --Bug:5741580, Actual transaction date stored in temperory variable
1729: l_trans_date := l_movement_transaction.transaction_date;
1730:
1731: --Find out the legal entity of the shipping warehouse
1732: l_shipping_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity
1733: (p_warehouse_id => l_movement_transaction.organization_id);
1734:
1735: --Only process those SO which cross legal entities
1736: IF (l_shipping_le_id IS NOT NULL

Line 1745: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1741: (x_movement_transaction => l_movement_transaction);
1742:
1743: --Find out territory code for legal entity
1744: l_le_territory_code :=
1745: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1746: (p_le_id => l_movement_transaction.entity_org_id);
1747:
1748: --Find out territory code for customer
1749: l_customer_terri_code :=

Line 1750: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

1746: (p_le_id => l_movement_transaction.entity_org_id);
1747:
1748: --Find out territory code for customer
1749: l_customer_terri_code :=
1750: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
1751: (p_site_use_id => l_movement_transaction.ship_to_site_use_id);
1752:
1753: --For creating Arrival SO record
1754: --Find out dispatch territory code and destination territory code

Line 1756: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1752:
1753: --For creating Arrival SO record
1754: --Find out dispatch territory code and destination territory code
1755: l_movement_transaction.dispatch_territory_code :=
1756: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1757: (p_le_id => l_shipping_le_id);
1758:
1759: l_movement_transaction.destination_territory_code := l_le_territory_code;
1760:

Line 1938: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

1934: l_movement_transaction.movement_type := 'A';
1935:
1936: IF l_return_status = 'Y'
1937: THEN
1938: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
1939: (p_stat_typ_transaction => l_stat_typ_transaction
1940: ,x_movement_transaction => l_movement_transaction
1941: ,x_return_status => l_return_status
1942: );

Line 1965: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

1961: l_movement_transaction.bill_to_site_use_id;
1962: CLOSE bill_to_site;
1963:
1964: l_movement_transaction.customer_vat_number :=
1965: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
1966: (l_movement_transaction.bill_to_site_use_id);
1967:
1968: IF l_movement_transaction.invoice_id IS NULL
1969: THEN

Line 2098: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

2094: l_movement_transaction2.transaction_date :=
2095: l_movement_transaction2.reference_date;
2096: END IF;
2097:
2098: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
2099: (p_stat_typ_transaction => l_stat_typ_transaction2
2100: ,x_movement_transaction => l_movement_transaction2
2101: ,x_return_status => l_return_status
2102: );

Line 2118: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

2114: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2115: ELSE
2116:
2117: /*l_movement_transaction2.customer_vat_number :=
2118: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2119: (l_movement_transaction2.bill_to_site_use_id);*/
2120:
2121: IF l_movement_transaction2.invoice_id IS NULL
2122: THEN

Line 2364: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

2360: (x_movement_transaction => l_movement_transaction);
2361:
2362: --Find out territory code
2363: l_subinv_terr_code :=
2364: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
2365: ( p_warehouse_id => l_movement_transaction.organization_id
2366: , p_subinv_code => l_subinv_code);
2367:
2368: l_recv_org_terr_code :=

Line 2369: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

2365: ( p_warehouse_id => l_movement_transaction.organization_id
2366: , p_subinv_code => l_subinv_code);
2367:
2368: l_recv_org_terr_code :=
2369: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
2370: (p_warehouse_id => l_movement_transaction.organization_id);
2371:
2372: l_le_terr_code :=
2373: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

Line 2373: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

2369: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
2370: (p_warehouse_id => l_movement_transaction.organization_id);
2371:
2372: l_le_terr_code :=
2373: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
2374: (p_le_id => l_movement_transaction.entity_org_id);
2375:
2376: l_shipping_org_terri_code :=
2377: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 2377: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

2373: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
2374: (p_le_id => l_movement_transaction.entity_org_id);
2375:
2376: l_shipping_org_terri_code :=
2377: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
2378: (p_warehouse_id => l_shipping_org_id);
2379:
2380: l_movement_transaction.dispatch_territory_code := l_shipping_org_terri_code;
2381: l_movement_transaction.destination_territory_code :=

Line 2488: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

2484: );
2485:
2486: IF l_return_status = 'Y'
2487: THEN
2488: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
2489: (p_stat_typ_transaction => l_stat_typ_transaction
2490: ,x_movement_transaction => l_movement_transaction
2491: ,x_return_status => l_return_status
2492: );

Line 2498: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

2494: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2495: THEN
2496:
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

Line 3447: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

3443: END IF;
3444:
3445: --Get subinventory location fix bug 2683302
3446: l_subinv_terr_code :=
3447: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
3448: ( p_warehouse_id => l_movement_transaction.organization_id
3449: , p_subinv_code => l_subinv_code);
3450:
3451: l_org_terr_code :=

Line 3452: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

3448: ( p_warehouse_id => l_movement_transaction.organization_id
3449: , p_subinv_code => l_subinv_code);
3450:
3451: l_org_terr_code :=
3452: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
3453: (p_warehouse_id => l_movement_transaction.organization_id);
3454:
3455: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location
3456: (p_le_id => l_movement_transaction.entity_org_id);

Line 3455: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location

3451: l_org_terr_code :=
3452: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
3453: (p_warehouse_id => l_movement_transaction.organization_id);
3454:
3455: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location
3456: (p_le_id => l_movement_transaction.entity_org_id);
3457:
3458: l_movement_transaction.dispatch_territory_code :=
3459: INV_MGD_MVT_UTILS_PKG.Get_Vendor_Location

Line 3459: INV_MGD_MVT_UTILS_PKG.Get_Vendor_Location

3455: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location
3456: (p_le_id => l_movement_transaction.entity_org_id);
3457:
3458: l_movement_transaction.dispatch_territory_code :=
3459: INV_MGD_MVT_UTILS_PKG.Get_Vendor_Location
3460: (p_vendor_site_id =>l_movement_transaction.vendor_site_id);
3461:
3462: --If dropship,do not consider subinventory location,because dropship
3463: --receipt is logical receipt,not real receipt.

Line 3557: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

3553: );
3554:
3555: IF l_return_status = 'Y'
3556: THEN
3557: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
3558: (p_stat_typ_transaction => l_stat_typ_transaction
3559: ,x_movement_transaction => l_movement_transaction
3560: ,x_return_status => l_return_status
3561: );

Line 3669: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

3665: --l_movement_transaction.triangulation_country_code :=
3666: -- l_movement_transaction.destination_territory_code;
3667:
3668: l_movement_transaction.destination_territory_code :=
3669: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
3670: (l_movement_transaction.ship_to_site_use_id);
3671:
3672: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3673: THEN

Line 3704: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

3700:
3701: --Continue if the insert flag is Yes
3702: IF l_insert_flag = 'Y'
3703: THEN
3704: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
3705: (p_stat_typ_transaction => l_stat_typ_transaction
3706: ,x_movement_transaction => l_movement_transaction
3707: ,x_return_status => l_return_status
3708: );

Line 3811: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

3807: l_movement_transaction.triangulation_country_code :=
3808: l_movement_transaction.destination_territory_code;
3809:
3810: l_movement_transaction.destination_territory_code :=
3811: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
3812: (l_movement_transaction.ship_to_site_use_id);
3813:
3814: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
3815: THEN

Line 3849: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

3845:
3846: --Continue if the insert flag is Yes
3847: IF l_insert_flag = 'Y'
3848: THEN
3849: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
3850: (p_stat_typ_transaction => l_stat_typ_transaction
3851: ,x_movement_transaction => l_movement_transaction
3852: ,x_return_status => l_return_status
3853: );

Line 4764: l_rma_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity

4760: --Fix bug3057775. Consider to create mvt RMA at the LE where this
4761: --RMA is created when the triangulation mode is invoice based.
4762: --Find out the legal entity where this RMA is created(use existing
4763: --procedure for SO)
4764: l_rma_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity
4765: (p_order_line_id => l_movement_transaction.order_line_id);
4766:
4767: --Find out the legal entity where this RMA is received
4768: l_receiving_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity

Line 4768: l_receiving_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity

4764: l_rma_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity
4765: (p_order_line_id => l_movement_transaction.order_line_id);
4766:
4767: --Find out the legal entity where this RMA is received
4768: l_receiving_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity
4769: (p_warehouse_id => l_movement_transaction.organization_id);
4770:
4771: --Get subinventory location fix bug 2683302
4772: l_subinv_terr_code :=

Line 4773: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

4769: (p_warehouse_id => l_movement_transaction.organization_id);
4770:
4771: --Get subinventory location fix bug 2683302
4772: l_subinv_terr_code :=
4773: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
4774: ( p_warehouse_id => l_movement_transaction.organization_id
4775: , p_subinv_code => l_subinv_code);
4776:
4777: l_org_terr_code :=

Line 4778: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

4774: ( p_warehouse_id => l_movement_transaction.organization_id
4775: , p_subinv_code => l_subinv_code);
4776:
4777: l_org_terr_code :=
4778: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
4779: (p_warehouse_id => l_movement_transaction.organization_id);
4780:
4781: --Get the country where the processor is run
4782: l_le_terr_code :=

Line 4783: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

4779: (p_warehouse_id => l_movement_transaction.organization_id);
4780:
4781: --Get the country where the processor is run
4782: l_le_terr_code :=
4783: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
4784: (p_le_id => l_movement_transaction.entity_org_id);
4785:
4786: l_movement_transaction.dispatch_territory_code :=
4787: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

Line 4787: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

4783: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
4784: (p_le_id => l_movement_transaction.entity_org_id);
4785:
4786: l_movement_transaction.dispatch_territory_code :=
4787: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
4788: (p_site_use_id => l_movement_transaction.ship_to_site_use_id);
4789: /*7165989*/
4790: l_sold_from_org_code :=
4791: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 4791: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

4787: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
4788: (p_site_use_id => l_movement_transaction.ship_to_site_use_id);
4789: /*7165989*/
4790: l_sold_from_org_code :=
4791: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
4792: (p_warehouse_id => l_movement_transaction.sold_from_org_id);
4793: FND_FILE.put_line (FND_FILE.log , '< l_sold_from_org_code - '|| l_sold_from_org_code );
4794: /*7165989*/
4795: --Initialize insert flag

Line 4852: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);

4848: FND_FILE.put_line (FND_FILE.log ,'Case 1 : RMA Invoice Based Triangulation run at booking LE' );
4849:
4850: ELSIF (l_insert_flag = 'N') THEN
4851: l_dispatch :=
4852: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
4853: l_destination :=
4854: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);
4855:
4856: if (l_dispatch <> l_destination ) THEN

Line 4854: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);

4850: ELSIF (l_insert_flag = 'N') THEN
4851: l_dispatch :=
4852: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
4853: l_destination :=
4854: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);
4855:
4856: if (l_dispatch <> l_destination ) THEN
4857:
4858: l_ship_from_loc :=

Line 4859: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code

4855:
4856: if (l_dispatch <> l_destination ) THEN
4857:
4858: l_ship_from_loc :=
4859: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code
4860: ( p_territory_code => l_dispatch
4861: , p_zone_code => l_movement_transaction.zone_code
4862: , p_trans_date => l_movement_Transaction.transaction_date
4863: );

Line 4866: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code

4862: , p_trans_date => l_movement_Transaction.transaction_date
4863: );
4864:
4865: l_ship_to_loc :=
4866: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code
4867: ( p_territory_code => l_destination
4868: , p_zone_code => l_movement_transaction.zone_code
4869: , p_trans_date => l_movement_Transaction.transaction_date
4870: );

Line 5026: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

5022: AND l_return_status = 'Y')
5023: THEN
5024: l_process_flag := 'Y';
5025:
5026: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
5027: ( p_stat_typ_transaction => l_stat_typ_transaction
5028: , x_movement_transaction => l_movement_transaction
5029: , x_return_status => l_return_status
5030: );

Line 5045: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

5041: END IF;
5042: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5043: ELSE
5044: l_movement_transaction.customer_vat_number :=
5045: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
5046: (l_movement_transaction.bill_to_site_use_id);
5047:
5048: IF l_movement_transaction.invoice_id IS NULL
5049: THEN

Line 5419: INV_MGD_MVT_UTILS_PKG.Get_Order_Number

5415: , l_stat_typ_transaction.returns_processing;
5416:
5417: EXIT WHEN setup_crsr%NOTFOUND;
5418:
5419: INV_MGD_MVT_UTILS_PKG.Get_Order_Number
5420: ( x_movement_transaction => l_movement_transaction
5421: );
5422:
5423: INV_MGD_MVT_PO_MDTR.Get_Blanket_Info

Line 5780: INV_MGD_MVT_UTILS_PKG.Get_Weight_Precision

5776: INV_MGD_MVT_FIN_MDTR.Calc_Statistics_Value
5777: (p_movement_transaction => l_movement_transaction);
5778:
5779: --Fix bug 4866967 and 5203245
5780: INV_MGD_MVT_UTILS_PKG.Get_Weight_Precision
5781: (p_legal_entity_id => l_movement_transaction.entity_org_id
5782: , p_zone_code => l_movement_transaction.zone_code
5783: , p_usage_type => l_movement_transaction.usage_type
5784: , p_stat_type => l_movement_transaction.stat_type

Line 5795: l_movement_transaction.total_weight := INV_MGD_MVT_UTILS_PKG.Round_Number

5791: THEN
5792: l_total_weight := l_movement_transaction.unit_weight *
5793: l_movement_transaction.transaction_quantity;
5794:
5795: l_movement_transaction.total_weight := INV_MGD_MVT_UTILS_PKG.Round_Number
5796: ( p_number => l_total_weight
5797: , p_precision => l_weight_precision
5798: , p_rounding_method => l_rounding_method
5799: );

Line 5805: INV_MGD_MVT_UTILS_PKG.Convert_alternate_Quantity

5801:
5802: IF (l_movement_transaction.alternate_uom_code IS NOT NULL)
5803: THEN
5804: l_movement_transaction.alternate_quantity :=
5805: INV_MGD_MVT_UTILS_PKG.Convert_alternate_Quantity
5806: ( p_transaction_quantity => l_movement_transaction.transaction_quantity
5807: , p_alternate_uom_code => l_movement_transaction.alternate_uom_code
5808: , p_transaction_uom_code => l_movement_transaction.transaction_uom_code
5809: , p_inventory_item_id => l_movement_transaction.inventory_item_id

Line 6148: INV_MGD_MVT_UTILS_PKG.Get_Order_Number

6144: , l_stat_typ_transaction.returns_processing;
6145:
6146: EXIT WHEN setup_crsr%NOTFOUND;
6147:
6148: INV_MGD_MVT_UTILS_PKG.Get_Order_Number
6149: ( x_movement_transaction => l_movement_transaction
6150: );
6151:
6152: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info