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: --Debug

Line 886: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

882: ( x_movement_transaction => l_movement_transaction);
883:
884: --Get subinventory location fix bug 2683302
885: l_subinv_terr_code :=
886: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
887: ( p_warehouse_id => l_movement_transaction.organization_id
888: , p_subinv_code => l_subinv_code);
889:
890: l_transfer_subinv_terr_code :=

Line 891: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

887: ( p_warehouse_id => l_movement_transaction.organization_id
888: , p_subinv_code => l_subinv_code);
889:
890: l_transfer_subinv_terr_code :=
891: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
892: ( p_warehouse_id => l_movement_transaction.transfer_organization_id
893: , p_subinv_code => l_transfer_subinv);
894:
895: --Get organization location

Line 897: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

893: , p_subinv_code => l_transfer_subinv);
894:
895: --Get organization location
896: l_org_terr_code :=
897: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
898: (p_warehouse_id => l_movement_transaction.organization_id);
899:
900: l_transfer_org_terr_code :=
901: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 901: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

897: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
898: (p_warehouse_id => l_movement_transaction.organization_id);
899:
900: l_transfer_org_terr_code :=
901: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
902: (p_warehouse_id => l_movement_transaction.transfer_organization_id);
903:
904: --Get legal entity location
905: -- Bug: 5920143. Calculate LE Territory code only when

Line 910: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

906: -- user has selected Include Establishments as No
907: IF(l_stat_typ_transaction.include_establishments = 'N')
908: THEN
909: l_le_terr_code :=
910: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
911: (p_le_id => l_movement_transaction.entity_org_id);
912: END IF;
913: -- For every record fetched get the dispatch and destination territory
914: -- codes.

Line 961: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

957: );
958:
959: IF l_return_status = 'Y'
960: THEN
961: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
962: ( p_stat_typ_transaction => l_stat_typ_transaction
963: , x_movement_transaction => l_movement_transaction
964: , x_return_status => l_return_status
965: );

Line 982: INV_MGD_MVT_UTILS_PKG.Get_Org_VAT_Number

978: ELSE
979:
980: --Get legal entity vat number stored in customer_vat_number
981: l_movement_transaction.customer_vat_number :=
982: INV_MGD_MVT_UTILS_PKG.Get_Org_VAT_Number
983: ( p_entity_org_id => l_movement_transaction.entity_org_id
984: , p_date => l_movement_transaction.transaction_date);
985:
986: INV_MGD_MVT_STATS_PVT.Create_Movement_Statistics

Line 1346: l_so_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity

1342: INV_MGD_MVT_STATS_PVT.Init_Movement_Record
1343: (x_movement_transaction => l_movement_transaction);
1344:
1345: --Get legal entity where this SO is created
1346: l_so_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity
1347: (p_order_line_id => l_movement_transaction.order_line_id);
1348:
1349: --Find out the territory code
1350: l_so_le_terri_code :=

Line 1351: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1347: (p_order_line_id => l_movement_transaction.order_line_id);
1348:
1349: --Find out the territory code
1350: l_so_le_terri_code :=
1351: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1352: (p_le_id => l_so_le_id);
1353:
1354: l_shipping_le_terri_code :=
1355: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

Line 1355: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1351: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1352: (p_le_id => l_so_le_id);
1353:
1354: l_shipping_le_terri_code :=
1355: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1356: (p_le_id => l_movement_transaction.entity_org_id);
1357:
1358: l_shipping_org_terri_code :=
1359: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 1359: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

1355: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1356: (p_le_id => l_movement_transaction.entity_org_id);
1357:
1358: l_shipping_org_terri_code :=
1359: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
1360: (p_warehouse_id => l_movement_transaction.organization_id);
1361:
1362: l_customer_terri_code :=
1363: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

Line 1363: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

1359: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
1360: (p_warehouse_id => l_movement_transaction.organization_id);
1361:
1362: l_customer_terri_code :=
1363: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
1364: (p_site_use_id =>l_movement_transaction.ship_to_site_use_id);
1365:
1366: -- If cross legal entity transaction,the destination
1367: -- territory code is depend on if it's invoiced based

Line 1472: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

1468: );
1469: END IF;
1470: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1471: ELSE
1472: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
1473: (p_stat_typ_transaction => l_stat_typ_transaction
1474: ,x_movement_transaction => l_movement_transaction
1475: ,x_return_status => l_return_status
1476: );

Line 1491: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

1487: END IF;
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: ELSE
1490: l_movement_transaction.customer_vat_number :=
1491: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
1492: (l_movement_transaction.bill_to_site_use_id);
1493:
1494: /*Start Bugfix 13400081: IO records were not getting updated because of
1495: this if condition.

Line 1827: l_shipping_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity

1823: --Bug:5741580, Actual transaction date stored in temperory variable
1824: l_trans_date := l_movement_transaction.transaction_date;
1825:
1826: --Find out the legal entity of the shipping warehouse
1827: l_shipping_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity
1828: (p_warehouse_id => l_movement_transaction.organization_id);
1829:
1830: --Debug
1831: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 1851: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1847: (x_movement_transaction => l_movement_transaction);
1848:
1849: --Find out territory code for legal entity
1850: l_le_territory_code :=
1851: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1852: (p_le_id => l_movement_transaction.entity_org_id);
1853:
1854: --Find out territory code for customer
1855: l_customer_terri_code :=

Line 1856: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

1852: (p_le_id => l_movement_transaction.entity_org_id);
1853:
1854: --Find out territory code for customer
1855: l_customer_terri_code :=
1856: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
1857: (p_site_use_id => l_movement_transaction.ship_to_site_use_id);
1858:
1859: --For creating Arrival SO record
1860: --Find out dispatch territory code and destination territory code

Line 1862: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

1858:
1859: --For creating Arrival SO record
1860: --Find out dispatch territory code and destination territory code
1861: l_movement_transaction.dispatch_territory_code :=
1862: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
1863: (p_le_id => l_shipping_le_id);
1864:
1865: l_movement_transaction.destination_territory_code := l_le_territory_code;
1866:

Line 2094: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

2090: l_movement_transaction.movement_type := 'A';
2091:
2092: IF l_return_status = 'Y'
2093: THEN
2094: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
2095: (p_stat_typ_transaction => l_stat_typ_transaction
2096: ,x_movement_transaction => l_movement_transaction
2097: ,x_return_status => l_return_status
2098: );

Line 2121: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

2117: l_movement_transaction.bill_to_site_use_id;
2118: CLOSE bill_to_site;
2119:
2120: l_movement_transaction.customer_vat_number :=
2121: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2122: (l_movement_transaction.bill_to_site_use_id);
2123:
2124: IF l_movement_transaction.invoice_id IS NULL
2125: THEN

Line 2287: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

2283: l_movement_transaction2.transaction_date :=
2284: l_movement_transaction2.reference_date;
2285: END IF;
2286:
2287: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
2288: (p_stat_typ_transaction => l_stat_typ_transaction2
2289: ,x_movement_transaction => l_movement_transaction2
2290: ,x_return_status => l_return_status
2291: );

Line 2307: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

2303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2304: ELSE
2305:
2306: /*l_movement_transaction2.customer_vat_number :=
2307: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2308: (l_movement_transaction2.bill_to_site_use_id);*/
2309:
2310: IF l_movement_transaction2.invoice_id IS NULL
2311: THEN

Line 2644: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

2640: (x_movement_transaction => l_movement_transaction);
2641:
2642: --Find out territory code
2643: l_subinv_terr_code :=
2644: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
2645: ( p_warehouse_id => l_movement_transaction.organization_id
2646: , p_subinv_code => l_subinv_code);
2647:
2648: l_recv_org_terr_code :=

Line 2649: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

2645: ( p_warehouse_id => l_movement_transaction.organization_id
2646: , p_subinv_code => l_subinv_code);
2647:
2648: l_recv_org_terr_code :=
2649: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
2650: (p_warehouse_id => l_movement_transaction.organization_id);
2651:
2652: l_le_terr_code :=
2653: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

Line 2653: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

2649: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
2650: (p_warehouse_id => l_movement_transaction.organization_id);
2651:
2652: l_le_terr_code :=
2653: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
2654: (p_le_id => l_movement_transaction.entity_org_id);
2655:
2656: l_shipping_org_terri_code :=
2657: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 2657: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

2653: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
2654: (p_le_id => l_movement_transaction.entity_org_id);
2655:
2656: l_shipping_org_terri_code :=
2657: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
2658: (p_warehouse_id => l_shipping_org_id);
2659:
2660: l_movement_transaction.dispatch_territory_code := l_shipping_org_terri_code;
2661: l_movement_transaction.destination_territory_code :=

Line 2768: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

2764: );
2765:
2766: IF l_return_status = 'Y'
2767: THEN
2768: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
2769: (p_stat_typ_transaction => l_stat_typ_transaction
2770: ,x_movement_transaction => l_movement_transaction
2771: ,x_return_status => l_return_status
2772: );

Line 2778: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

2774: IF l_return_status = FND_API.G_RET_STS_SUCCESS
2775: THEN
2776:
2777: l_movement_transaction.customer_vat_number :=
2778: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
2779: (l_movement_transaction.bill_to_site_use_id);
2780:
2781: --Start Bugfix 13400081
2782: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

Line 3790: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

3786: END IF;
3787:
3788: --Get subinventory location fix bug 2683302
3789: l_subinv_terr_code :=
3790: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
3791: ( p_warehouse_id => l_movement_transaction.organization_id
3792: , p_subinv_code => l_subinv_code);
3793:
3794: l_org_terr_code :=

Line 3795: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

3791: ( p_warehouse_id => l_movement_transaction.organization_id
3792: , p_subinv_code => l_subinv_code);
3793:
3794: l_org_terr_code :=
3795: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
3796: (p_warehouse_id => l_movement_transaction.organization_id);
3797:
3798: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location
3799: (p_le_id => l_movement_transaction.entity_org_id);

Line 3798: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location

3794: l_org_terr_code :=
3795: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
3796: (p_warehouse_id => l_movement_transaction.organization_id);
3797:
3798: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location
3799: (p_le_id => l_movement_transaction.entity_org_id);
3800:
3801: l_movement_transaction.dispatch_territory_code :=
3802: INV_MGD_MVT_UTILS_PKG.Get_Vendor_Location

Line 3802: INV_MGD_MVT_UTILS_PKG.Get_Vendor_Location

3798: l_le_terr_code := INV_MGD_MVT_UTILS_PKG.Get_LE_Location
3799: (p_le_id => l_movement_transaction.entity_org_id);
3800:
3801: l_movement_transaction.dispatch_territory_code :=
3802: INV_MGD_MVT_UTILS_PKG.Get_Vendor_Location
3803: (p_vendor_site_id =>l_movement_transaction.vendor_site_id);
3804:
3805: --If dropship,do not consider subinventory location,because dropship
3806: --receipt is logical receipt,not real receipt.

Line 3900: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

3896: );
3897:
3898: IF l_return_status = 'Y'
3899: THEN
3900: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
3901: (p_stat_typ_transaction => l_stat_typ_transaction
3902: ,x_movement_transaction => l_movement_transaction
3903: ,x_return_status => l_return_status
3904: );

Line 4012: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

4008: --l_movement_transaction.triangulation_country_code :=
4009: -- l_movement_transaction.destination_territory_code;
4010:
4011: l_movement_transaction.destination_territory_code :=
4012: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
4013: (l_movement_transaction.ship_to_site_use_id);
4014:
4015: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4016: THEN

Line 4047: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

4043:
4044: --Continue if the insert flag is Yes
4045: IF l_insert_flag = 'Y'
4046: THEN
4047: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
4048: (p_stat_typ_transaction => l_stat_typ_transaction
4049: ,x_movement_transaction => l_movement_transaction
4050: ,x_return_status => l_return_status
4051: );

Line 4154: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

4150: l_movement_transaction.triangulation_country_code :=
4151: l_movement_transaction.destination_territory_code;
4152:
4153: l_movement_transaction.destination_territory_code :=
4154: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
4155: (l_movement_transaction.ship_to_site_use_id);
4156:
4157: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
4158: THEN

Line 4192: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

4188:
4189: --Continue if the insert flag is Yes
4190: IF l_insert_flag = 'Y'
4191: THEN
4192: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
4193: (p_stat_typ_transaction => l_stat_typ_transaction
4194: ,x_movement_transaction => l_movement_transaction
4195: ,x_return_status => l_return_status
4196: );

Line 5171: l_rma_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity

5167: --Fix bug3057775. Consider to create mvt RMA at the LE where this
5168: --RMA is created when the triangulation mode is invoice based.
5169: --Find out the legal entity where this RMA is created(use existing
5170: --procedure for SO)
5171: l_rma_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity
5172: (p_order_line_id => l_movement_transaction.order_line_id);
5173:
5174: --Find out the legal entity where this RMA is received
5175: l_receiving_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity

Line 5175: l_receiving_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity

5171: l_rma_le_id := INV_MGD_MVT_UTILS_PKG.Get_SO_Legal_Entity
5172: (p_order_line_id => l_movement_transaction.order_line_id);
5173:
5174: --Find out the legal entity where this RMA is received
5175: l_receiving_le_id := INV_MGD_MVT_UTILS_PKG.Get_Shipping_Legal_Entity
5176: (p_warehouse_id => l_movement_transaction.organization_id);
5177:
5178: --Get subinventory location fix bug 2683302
5179: l_subinv_terr_code :=

Line 5180: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location

5176: (p_warehouse_id => l_movement_transaction.organization_id);
5177:
5178: --Get subinventory location fix bug 2683302
5179: l_subinv_terr_code :=
5180: INV_MGD_MVT_UTILS_PKG.Get_Subinv_Location
5181: ( p_warehouse_id => l_movement_transaction.organization_id
5182: , p_subinv_code => l_subinv_code);
5183:
5184: l_org_terr_code :=

Line 5185: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

5181: ( p_warehouse_id => l_movement_transaction.organization_id
5182: , p_subinv_code => l_subinv_code);
5183:
5184: l_org_terr_code :=
5185: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
5186: (p_warehouse_id => l_movement_transaction.organization_id);
5187:
5188: --Get the country where the processor is run
5189: l_le_terr_code :=

Line 5190: INV_MGD_MVT_UTILS_PKG.Get_LE_Location

5186: (p_warehouse_id => l_movement_transaction.organization_id);
5187:
5188: --Get the country where the processor is run
5189: l_le_terr_code :=
5190: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
5191: (p_le_id => l_movement_transaction.entity_org_id);
5192:
5193: l_movement_transaction.dispatch_territory_code :=
5194: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

Line 5194: INV_MGD_MVT_UTILS_PKG.Get_Site_Location

5190: INV_MGD_MVT_UTILS_PKG.Get_LE_Location
5191: (p_le_id => l_movement_transaction.entity_org_id);
5192:
5193: l_movement_transaction.dispatch_territory_code :=
5194: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
5195: (p_site_use_id => l_movement_transaction.ship_to_site_use_id);
5196: /*7165989*/
5197: l_sold_from_org_code :=
5198: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

Line 5198: INV_MGD_MVT_UTILS_PKG.Get_Org_Location

5194: INV_MGD_MVT_UTILS_PKG.Get_Site_Location
5195: (p_site_use_id => l_movement_transaction.ship_to_site_use_id);
5196: /*7165989*/
5197: l_sold_from_org_code :=
5198: INV_MGD_MVT_UTILS_PKG.Get_Org_Location
5199: (p_warehouse_id => l_movement_transaction.sold_from_org_id);
5200: FND_FILE.put_line (FND_FILE.log , '< l_sold_from_org_code - '|| l_sold_from_org_code );
5201: /*7165989*/
5202:

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

5296: END IF;
5297:
5298: ELSIF (l_insert_flag = 'N') THEN
5299: l_dispatch :=
5300: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
5301: l_destination :=
5302: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);
5303:
5304: --Debug

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

5298: ELSIF (l_insert_flag = 'N') THEN
5299: l_dispatch :=
5300: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.sold_from_org_id);
5301: l_destination :=
5302: INV_MGD_MVT_UTILS_PKG.Get_Org_Location(p_warehouse_id => l_movement_transaction.organization_id);
5303:
5304: --Debug
5305: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
5306: THEN

Line 5316: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code

5312: END IF;
5313:
5314: if (l_dispatch <> l_destination ) THEN
5315: l_ship_from_loc :=
5316: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code
5317: ( p_territory_code => l_dispatch
5318: , p_zone_code => l_movement_transaction.zone_code
5319: , p_trans_date => l_movement_Transaction.transaction_date
5320: );

Line 5323: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code

5319: , p_trans_date => l_movement_Transaction.transaction_date
5320: );
5321:
5322: l_ship_to_loc :=
5323: INV_MGD_MVT_UTILS_PKG.Get_Zone_Code
5324: ( p_territory_code => l_destination
5325: , p_zone_code => l_movement_transaction.zone_code
5326: , p_trans_date => l_movement_Transaction.transaction_date
5327: );

Line 5597: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info

5593: IF (l_insert_flag = 'Y' AND l_return_status = 'Y')
5594: THEN
5595: l_process_flag := 'Y';
5596:
5597: INV_MGD_MVT_UTILS_PKG.Mvt_Stats_Util_Info
5598: ( p_stat_typ_transaction => l_stat_typ_transaction
5599: , x_movement_transaction => l_movement_transaction
5600: , x_return_status => l_return_status
5601: );

Line 5616: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number

5612: END IF;
5613: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5614: ELSE
5615: l_movement_transaction.customer_vat_number :=
5616: INV_MGD_MVT_UTILS_PKG.Get_Cust_VAT_Number
5617: (l_movement_transaction.bill_to_site_use_id);
5618:
5619: IF l_movement_transaction.invoice_id IS NULL
5620: THEN

Line 6012: INV_MGD_MVT_UTILS_PKG.Get_Order_Number

6008: , l_stat_typ_transaction.returns_processing;
6009:
6010: EXIT WHEN setup_crsr%NOTFOUND;
6011:
6012: INV_MGD_MVT_UTILS_PKG.Get_Order_Number
6013: ( x_movement_transaction => l_movement_transaction
6014: );
6015:
6016: INV_MGD_MVT_PO_MDTR.Get_Blanket_Info

Line 6373: INV_MGD_MVT_UTILS_PKG.Get_Weight_Precision

6369: INV_MGD_MVT_FIN_MDTR.Calc_Statistics_Value
6370: (p_movement_transaction => l_movement_transaction);
6371:
6372: --Fix bug 4866967 and 5203245
6373: INV_MGD_MVT_UTILS_PKG.Get_Weight_Precision
6374: (p_legal_entity_id => l_movement_transaction.entity_org_id
6375: , p_zone_code => l_movement_transaction.zone_code
6376: , p_usage_type => l_movement_transaction.usage_type
6377: , p_stat_type => l_movement_transaction.stat_type

Line 6388: l_movement_transaction.total_weight := INV_MGD_MVT_UTILS_PKG.Round_Number

6384: THEN
6385: l_total_weight := l_movement_transaction.unit_weight *
6386: l_movement_transaction.transaction_quantity;
6387:
6388: l_movement_transaction.total_weight := INV_MGD_MVT_UTILS_PKG.Round_Number
6389: ( p_number => l_total_weight
6390: , p_precision => l_weight_precision
6391: , p_rounding_method => l_rounding_method
6392: );

Line 6398: INV_MGD_MVT_UTILS_PKG.Convert_alternate_Quantity

6394:
6395: IF (l_movement_transaction.alternate_uom_code IS NOT NULL)
6396: THEN
6397: l_movement_transaction.alternate_quantity :=
6398: INV_MGD_MVT_UTILS_PKG.Convert_alternate_Quantity
6399: ( p_transaction_quantity => l_movement_transaction.transaction_quantity
6400: , p_alternate_uom_code => l_movement_transaction.alternate_uom_code
6401: , p_transaction_uom_code => l_movement_transaction.transaction_uom_code
6402: , p_inventory_item_id => l_movement_transaction.inventory_item_id

Line 6741: INV_MGD_MVT_UTILS_PKG.Get_Order_Number

6737: , l_stat_typ_transaction.returns_processing;
6738:
6739: EXIT WHEN setup_crsr%NOTFOUND;
6740:
6741: INV_MGD_MVT_UTILS_PKG.Get_Order_Number
6742: ( x_movement_transaction => l_movement_transaction
6743: );
6744:
6745: INV_MGD_MVT_FIN_MDTR.Calc_Invoice_Info