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.OE_SHIPPING_INTEGRATION_PVT dependencies on OE_GLOBALS

Line 157: ,p_control_rec IN OE_GLOBALS.Control_Rec_Type DEFAULT OE_GLOBALS.G_MISS_CONTROL_REC

153: PROCEDURE Call_Process_Order
154: ----------------------------------------------------------------*/
155: PROCEDURE Call_Process_Order
156: (p_line_tbl IN OE_Order_PUB.Line_Tbl_Type
157: ,p_control_rec IN OE_GLOBALS.Control_Rec_Type DEFAULT OE_GLOBALS.G_MISS_CONTROL_REC
158: ,p_process_requests IN BOOLEAN := FALSE
159: ,x_return_status OUT NOCOPY VARCHAR2
160:
161: )

Line 164: l_control_rec OE_GLOBALS.Control_Rec_Type;

160:
161: )
162: IS
163: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
164: l_control_rec OE_GLOBALS.Control_Rec_Type;
165: l_header_out_rec OE_ORDER_PUB.Header_Rec_Type;
166: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type;
167: l_line_adj_out_tbl OE_ORDER_PUB.Line_Adj_Tbl_Type;
168: l_header_adj_out_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

Line 363: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

359: BEGIN
360: IF l_debug_level > 0 THEN -- Added debug for bug 13435459
361: OE_DEBUG_PUB.add('Entering Update_Shipping_From_OE() at ',0.5);
362: END IF;
363: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
364: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
365: END IF;
366:
367: IF l_debug_level > 0 THEN

Line 364: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);

360: IF l_debug_level > 0 THEN -- Added debug for bug 13435459
361: OE_DEBUG_PUB.add('Entering Update_Shipping_From_OE() at ',0.5);
362: END IF;
363: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
364: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
365: END IF;
366:
367: IF l_debug_level > 0 THEN
368: oe_debug_pub.add('ENTERING oexvshpb UPDATE_SHIPPING_FROM_OE',1);

Line 403: = OE_GLOBALS.G_OPR_DELETE THEN

399:
400: -------------- handle delete operation -----------------
401:
402: IF p_update_lines_tbl(l_line_index).request_unique_key1
403: = OE_GLOBALS.G_OPR_DELETE THEN
404: -- fix for 3779333
405: -- select item type code from oe_orderlines_table. For config lines
406: -- pass action code as 'U' to shipping. for other item types, pass
407: -- action code as 'D'

Line 577: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

573: || L_LINE_REC.LINE_ID , 3 ) ;
574: END IF;
575:
576: OE_Delayed_Requests_Pvt.Log_Request
577: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
578: p_entity_id => l_line_rec.line_id,
579: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
580: p_requesting_entity_id => l_line_rec.line_id,
581: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 579: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

575:
576: OE_Delayed_Requests_Pvt.Log_Request
577: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
578: p_entity_id => l_line_rec.line_id,
579: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
580: p_requesting_entity_id => l_line_rec.line_id,
581: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
582: p_param1 => OE_GLOBALS.G_WFI_LIN,
583: p_param2 => l_line_rec.line_id,

Line 581: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

577: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
578: p_entity_id => l_line_rec.line_id,
579: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
580: p_requesting_entity_id => l_line_rec.line_id,
581: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
582: p_param1 => OE_GLOBALS.G_WFI_LIN,
583: p_param2 => l_line_rec.line_id,
584: p_param3 => 'SHIP_LINE',
585: p_param4 => l_result_code,

Line 582: p_param1 => OE_GLOBALS.G_WFI_LIN,

578: p_entity_id => l_line_rec.line_id,
579: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
580: p_requesting_entity_id => l_line_rec.line_id,
581: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
582: p_param1 => OE_GLOBALS.G_WFI_LIN,
583: p_param2 => l_line_rec.line_id,
584: p_param3 => 'SHIP_LINE',
585: p_param4 => l_result_code,
586: x_return_status => l_return_status);

Line 664: = OE_GLOBALS.G_OPR_CREATE THEN

660: IF g_debug_call > 0 THEN
661: G_DEBUG_MSG := G_DEBUG_MSG || '16,';
662: END IF;
663: IF p_update_lines_tbl(l_line_index).request_unique_key1
664: = OE_GLOBALS.G_OPR_CREATE THEN
665: l_changed_attributes(l_shp_index).action_flag := 'S';
666: ELSE
667: l_changed_attributes(l_shp_index).action_flag := 'U';
668: END IF;

Line 728: (p_item_type => OE_GLOBALS.G_WFI_LIN

724: (l_line_rec.ato_line_id = l_line_rec.line_id AND
725: l_line_rec.item_type_code IN ('STANDARD','OPTION','INCLUDED'))) THEN --9775352
726: --Get the activity result
727: OE_LINE_FULLFILL.Get_Activity_Result
728: (p_item_type => OE_GLOBALS.G_WFI_LIN
729: ,p_item_key => l_line_rec.line_id
730: ,p_activity_name => 'SHIP_LINE'
731: ,x_return_status => l_return_status
732: ,x_activity_result => l_activity_result

Line 744: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR

740: -- 4437814 end changes
741: IF l_debug_level > 0 THEN
742: oe_debug_pub.add('shipline notified flag:' || l_shipline_notified) ;
743: END IF;
744: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
745: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
746: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
747: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
748: IF l_shipline_notified = 'Y'THEN --4437814

Line 745: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR

741: IF l_debug_level > 0 THEN
742: oe_debug_pub.add('shipline notified flag:' || l_shipline_notified) ;
743: END IF;
744: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
745: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
746: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
747: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
748: IF l_shipline_notified = 'Y'THEN --4437814
749: IF l_debug_level > 0 THEN

Line 746: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR

742: oe_debug_pub.add('shipline notified flag:' || l_shipline_notified) ;
743: END IF;
744: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
745: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
746: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
747: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
748: IF l_shipline_notified = 'Y'THEN --4437814
749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add

Line 747: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN

743: END IF;
744: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
745: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
746: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
747: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
748: IF l_shipline_notified = 'Y'THEN --4437814
749: IF l_debug_level > 0 THEN
750: oe_debug_pub.add
751: ('line shipped within tolerance, complete ship_line',3);

Line 842: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN

838: END IF; -- if index is not null
839:
840: ELSE --pre-pack H
841:
842: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN
843:
844:
845: OE_Order_PVT.Process_Requests_And_Notify
846: ( p_process_requests => FALSE

Line 928: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

924: || L_LINE_REC.LINE_ID , 3 ) ;
925: END IF;
926:
927: OE_Delayed_Requests_Pvt.Log_Request
928: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
929: p_entity_id => l_line_rec.line_id,
930: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
931: p_requesting_entity_id => l_line_rec.line_id,
932: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 930: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

926:
927: OE_Delayed_Requests_Pvt.Log_Request
928: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
929: p_entity_id => l_line_rec.line_id,
930: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
931: p_requesting_entity_id => l_line_rec.line_id,
932: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
933: p_param1 => OE_GLOBALS.G_WFI_LIN,
934: p_param2 => l_line_rec.line_id,

Line 932: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

928: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
929: p_entity_id => l_line_rec.line_id,
930: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
931: p_requesting_entity_id => l_line_rec.line_id,
932: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
933: p_param1 => OE_GLOBALS.G_WFI_LIN,
934: p_param2 => l_line_rec.line_id,
935: p_param3 => 'SHIP_LINE',
936: p_param4 => l_result_code,

Line 933: p_param1 => OE_GLOBALS.G_WFI_LIN,

929: p_entity_id => l_line_rec.line_id,
930: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
931: p_requesting_entity_id => l_line_rec.line_id,
932: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
933: p_param1 => OE_GLOBALS.G_WFI_LIN,
934: p_param2 => l_line_rec.line_id,
935: p_param3 => 'SHIP_LINE',
936: p_param4 => l_result_code,
937: x_return_status => l_return_status);

Line 996: OE_GLOBALS.G_OPR_DELETE THEN

992: -- odaboval : Begin of OPM Changes
993: --{ bug3831490 contd
994: IF l_line_rec.item_type_code = 'CONFIG' AND
995: p_update_lines_tbl(l_line_index).request_unique_key1 =
996: OE_GLOBALS.G_OPR_DELETE THEN
997:
998: l_changed_attributes(l_shp_index).ordered_quantity := 0;
999: IF l_debug_level > 0 THEN
1000: OE_DEBUG_PUB.Add('This is Config cancel/delete case!',1);

Line 1280: OE_GLOBALS.G_FORCE_CLEAR_UI_BLOCK := 'Y';

1276: IF l_force_ui = 'Y' THEN
1277: IF l_debug_level > 0 THEN
1278: oe_debug_pub.add('Setting the global to force UI Block',2);
1279: END IF;
1280: OE_GLOBALS.G_FORCE_CLEAR_UI_BLOCK := 'Y';
1281: END IF;
1282: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1283: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1284: -- 3571148 changes

Line 1307: OE_GLOBALS.G_FORCE_CLEAR_UI_BLOCK := 'Y';

1303: IF l_force_ui = 'Y' THEN
1304: IF l_debug_level > 0 THEN
1305: oe_debug_pub.add('Setting the global to force UI Block',2);
1306: END IF;
1307: OE_GLOBALS.G_FORCE_CLEAR_UI_BLOCK := 'Y';
1308: END IF;
1309: -- Start: Changes for bug 6391881
1310: -- Check if we are coming from wsh_no_data_found error.
1311: IF ( l_wsh_no_data_found = TRUE) THEN

Line 1909: x_result_out :=OE_GLOBALS.G_FULLY_SHIPPED;

1905:
1906:
1907:
1908: IF l_ordered_quantity= l_shipped_quantity THEN
1909: x_result_out :=OE_GLOBALS.G_FULLY_SHIPPED;
1910:
1911: ELSIF l_ordered_quantity <= l_shipped_quantity + l_tolerance_quantity_below AND
1912: l_shipped_quantity < l_ordered_quantity THEN
1913: x_result_out :=OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW;

Line 1913: x_result_out :=OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW;

1909: x_result_out :=OE_GLOBALS.G_FULLY_SHIPPED;
1910:
1911: ELSIF l_ordered_quantity <= l_shipped_quantity + l_tolerance_quantity_below AND
1912: l_shipped_quantity < l_ordered_quantity THEN
1913: x_result_out :=OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW;
1914:
1915: ELSIF l_ordered_quantity > l_shipped_quantity + l_tolerance_quantity_below THEN
1916:
1917: IF l_line_rec.shipping_quantity_uom <> l_line_rec.order_quantity_uom THEN

Line 1969: x_result_out :=OE_GLOBALS.G_PARTIALLY_SHIPPED;

1965: END IF; -- done validate decimal
1966:
1967: IF l_ordered_quantity> l_temp_shipped_quantity + l_tolerance_quantity_below
1968: THEN
1969: x_result_out :=OE_GLOBALS.G_PARTIALLY_SHIPPED;
1970: ELSE
1971: x_result_out :=OE_GLOBALS.G_FULLY_SHIPPED;
1972: END IF;
1973:

Line 1971: x_result_out :=OE_GLOBALS.G_FULLY_SHIPPED;

1967: IF l_ordered_quantity> l_temp_shipped_quantity + l_tolerance_quantity_below
1968: THEN
1969: x_result_out :=OE_GLOBALS.G_PARTIALLY_SHIPPED;
1970: ELSE
1971: x_result_out :=OE_GLOBALS.G_FULLY_SHIPPED;
1972: END IF;
1973:
1974: IF l_debug_level > 0 THEN
1975: OE_DEBUG_PUB.Add('Check the Decimals for Standard Items..Different UOM');

Line 1994: x_result_out := OE_GLOBALS.G_FULLY_SHIPPED;

1990: IF l_wdd_count = 0 THEN
1991: IF l_debug_level > 0 THEN
1992: OE_DEBUG_PUB.Add('Delivery Detail Did not Split..');
1993: END IF;
1994: x_result_out := OE_GLOBALS.G_FULLY_SHIPPED;
1995: ELSE
1996: IF l_debug_level > 0 THEN
1997: OE_DEBUG_PUB.Add('Delivery Detail Has Split..');
1998: END IF;

Line 2003: x_result_out :=OE_GLOBALS.G_PARTIALLY_SHIPPED;

1999: END IF;
2000: END IF;
2001:
2002: ELSE
2003: x_result_out :=OE_GLOBALS.G_PARTIALLY_SHIPPED;
2004: END IF; -- different uom
2005:
2006: IF g_debug_call > 0 THEN
2007: G_DEBUG_MSG := G_DEBUG_MSG || '61,';

Line 2014: x_result_out :=OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE;

2010: -- Check for Shipment within ship tolerance above
2011:
2012: ELSIF l_shipped_quantity <= l_ordered_quantity + l_tolerance_quantity_above AND
2013: l_ordered_quantity < l_shipped_quantity THEN
2014: x_result_out :=OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE;
2015:
2016: -- Check for Shipment above ship tolerance above
2017:
2018: ELSIF l_shipped_quantity > l_ordered_quantity + l_tolerance_quantity_above THEN

Line 2019: x_result_out :=OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE;

2015:
2016: -- Check for Shipment above ship tolerance above
2017:
2018: ELSIF l_shipped_quantity > l_ordered_quantity + l_tolerance_quantity_above THEN
2019: x_result_out :=OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE;
2020: END IF;
2021:
2022: -- Bug 5332001
2023: IF l_debug_level > 0 THEN

Line 2048: x_result_out := OE_GLOBALS.G_FULLY_SHIPPED;

2044: OE_DEBUG_PUB.add('actual quantity '||actual_quantity||' poll received '||poll_received_quantity,1);
2045: END IF;
2046:
2047: IF poll_received_quantity = actual_quantity THEN
2048: x_result_out := OE_GLOBALS.G_FULLY_SHIPPED;
2049: END IF;
2050:
2051: EXCEPTION WHEN OTHERS THEN
2052: IF l_debug_level > 0 THEN

Line 2175: l_pto_index := mod(l_line_tbl(l_line_index).line_id,OE_GLOBALS.G_BINARY_LIMIT);

2171: END IF;
2172: l_final_index := l_final_index + 1;
2173: p_x_line_tbl(l_final_index) := l_line_tbl(l_line_index);
2174: -- l_pto_index := l_line_tbl(l_line_index).line_id; -- Bug 8795918
2175: l_pto_index := mod(l_line_tbl(l_line_index).line_id,OE_GLOBALS.G_BINARY_LIMIT);
2176:
2177: l_pto_shipment_tbl(l_pto_index).line_id := l_line_tbl(l_line_index).line_id;
2178: l_pto_shipment_tbl(l_pto_index).top_model_line_id := l_line_tbl(l_line_index).top_model_line_id;
2179: l_pto_shipment_tbl(l_pto_index).ordered_quantity := l_line_tbl(l_line_index).ordered_quantity;

Line 2237: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);

2233: LOOP
2234:
2235:
2236: -- l_top_index := l_pto_shipment_tbl(l_pto_index).top_model_line_id; -- Bug 8795918
2237: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);
2238:
2239: -- l_parent_index := nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id); -- Bug 8795918
2240: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);
2241: l_pto_shipment_tbl(l_pto_index).ratio_to_top_model := l_pto_shipment_tbl(l_pto_index).ordered_quantity/l_pto_shipment_tbl(l_top_index).ordered_quantity;

Line 2240: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);

2236: -- l_top_index := l_pto_shipment_tbl(l_pto_index).top_model_line_id; -- Bug 8795918
2237: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);
2238:
2239: -- l_parent_index := nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id); -- Bug 8795918
2240: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);
2241: l_pto_shipment_tbl(l_pto_index).ratio_to_top_model := l_pto_shipment_tbl(l_pto_index).ordered_quantity/l_pto_shipment_tbl(l_top_index).ordered_quantity;
2242:
2243: IF l_parent_index <> 0 THEN
2244:

Line 2277: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);

2273: END IF;
2274:
2275: -- l_parent_index := nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id); --Bug 8795918
2276: -- l_top_index := l_pto_shipment_tbl(l_pto_index).top_model_line_id; -- Bug 8795918
2277: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);
2278: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);
2279:
2280: l_parent_shipped_quantity := nvl(l_pto_shipment_tbl(l_pto_index).shipped_quantity,0)/l_pto_shipment_tbl(l_pto_index).ratio_to_parent;
2281: IF l_debug_level > 0 THEN

Line 2278: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);

2274:
2275: -- l_parent_index := nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id); --Bug 8795918
2276: -- l_top_index := l_pto_shipment_tbl(l_pto_index).top_model_line_id; -- Bug 8795918
2277: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);
2278: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);
2279:
2280: l_parent_shipped_quantity := nvl(l_pto_shipment_tbl(l_pto_index).shipped_quantity,0)/l_pto_shipment_tbl(l_pto_index).ratio_to_parent;
2281: IF l_debug_level > 0 THEN
2282: oe_debug_pub.add( 'SHIPPED QUANTITY FOR PARENT : '|| TO_CHAR ( L_PARENT_SHIPPED_QUANTITY ) , 3 ) ;

Line 2354: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);

2350: LOOP
2351:
2352: -- l_parent_index := nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id); -- Bug 8795918
2353: -- l_top_index := l_pto_shipment_tbl(l_pto_index).top_model_line_id; -- Bug 8795918
2354: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);
2355: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);
2356:
2357: IF nvl(l_pto_shipment_tbl(l_pto_index).shipped_quantity,0) = 0 THEN
2358:

Line 2355: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);

2351:
2352: -- l_parent_index := nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id); -- Bug 8795918
2353: -- l_top_index := l_pto_shipment_tbl(l_pto_index).top_model_line_id; -- Bug 8795918
2354: l_parent_index := mod(nvl(l_pto_shipment_tbl(l_pto_index).link_to_line_id,l_pto_shipment_tbl(l_pto_index).top_model_line_id),OE_GLOBALS.G_BINARY_LIMIT);
2355: l_top_index := mod(l_pto_shipment_tbl(l_pto_index).top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);
2356:
2357: IF nvl(l_pto_shipment_tbl(l_pto_index).shipped_quantity,0) = 0 THEN
2358:
2359: l_pto_shipment_tbl(l_pto_index).shipped_quantity := nvl(l_pto_shipment_tbl(l_top_index).shipped_quantity,0) * l_pto_shipment_tbl(l_pto_index).ratio_to_top_model;

Line 2387: l_pto_index := mod(l_line_tbl(l_line_index).line_id,OE_GLOBALS.G_BINARY_LIMIT);

2383: l_final_index := l_final_index + 1;
2384: p_x_line_tbl(l_final_index) := l_line_tbl(l_line_index);
2385:
2386: -- l_pto_index := l_line_tbl(l_line_index).line_id; -- Bug 8795918
2387: l_pto_index := mod(l_line_tbl(l_line_index).line_id,OE_GLOBALS.G_BINARY_LIMIT);
2388: IF l_debug_level > 0 THEN
2389: oe_debug_pub.add( 'INDEX/LINE_ID/FINAL_INDEX '|| TO_CHAR ( L_LINE_INDEX ) ||'/'||P_X_LINE_TBL ( L_FINAL_INDEX ) .LINE_ID||'/'||TO_CHAR ( L_FINAL_INDEX ) , 3 ) ;
2390: END IF;
2391:

Line 2544: l_control_rec OE_GLOBALS.Control_Rec_Type;

2540: -- Variables to call process order to update the shipped quantity for
2541: -- non shippable lines.
2542: l_upd_tbl_index NUMBER := 0;
2543: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
2544: l_control_rec OE_GLOBALS.Control_Rec_Type;
2545: l_top_model_index NUMBER;
2546: l_ato_line_index NUMBER := 0;
2547: l_set_recursion VARCHAR2(1) := 'N';
2548:

Line 2643: := OE_GLOBALS.G_OPR_UPDATE;

2639: END IF;
2640:
2641: l_update_line_tbl(l_upd_tbl_index) := l_line_tbl(l_pto_index);
2642: l_update_line_tbl(l_upd_tbl_index).operation
2643: := OE_GLOBALS.G_OPR_UPDATE;
2644:
2645: IF l_line_tbl(l_top_model_index).ship_tolerance_below <>
2646: nvl(l_line_tbl(l_pto_index).ship_tolerance_below,0) AND
2647: l_line_tbl(l_top_model_index).line_id =

Line 2678: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

2674: IF g_debug_call > 0 THEN
2675: G_DEBUG_MSG := G_DEBUG_MSG || 'Shp-8-6';
2676: END IF;
2677:
2678: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
2679: l_control_rec.validate_entity := FALSE;
2680: l_control_rec.check_security := FALSE;
2681:
2682: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN

Line 2682: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN

2678: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
2679: l_control_rec.validate_entity := FALSE;
2680: l_control_rec.check_security := FALSE;
2681:
2682: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
2683: l_set_recursion := 'N';
2684: ELSE
2685: l_set_recursion := 'Y';
2686: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

Line 2686: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

2682: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
2683: l_set_recursion := 'N';
2684: ELSE
2685: l_set_recursion := 'Y';
2686: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
2687: END IF;
2688:
2689: IF g_debug_call > 0 THEN
2690: G_DEBUG_MSG := G_DEBUG_MSG || '87,';

Line 2700: -- OE_GLOBALS.G_RECURSION_MODE := 'N';

2696: x_return_status => l_return_status );
2697:
2698: IF l_set_recursion = 'Y' THEN
2699: l_set_recursion := 'N';
2700: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2701: END IF;
2702:
2703: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2718: l_x_result_out := OE_GLOBALS.G_FULLY_SHIPPED;

2714:
2715: IF l_debug_level > 0 THEN
2716: oe_debug_pub.add( 'FULLY SHIPPED , SHIPMENT RATIO IS NOT BROKEN' , 3 ) ;
2717: END IF;
2718: l_x_result_out := OE_GLOBALS.G_FULLY_SHIPPED;
2719:
2720: ELSE
2721: IF l_debug_level > 0 THEN
2722: oe_debug_pub.add( 'NOT FULLY SHIPPED , SHIPMENT RATIO IS NOT BROKEN' , 3 ) ;

Line 2745: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND

2741:
2742:
2743: -- Call the split API if it is a partial shipment.
2744:
2745: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND
2746: l_line_tbl(l_top_model_index).ordered_quantity >
2747: l_line_tbl(l_top_model_index).shipped_quantity THEN
2748:
2749: IF l_debug_level > 0 THEN

Line 2759: l_split_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

2755:
2756: l_split_line_tbl(1) := l_line_tbl(l_top_model_index);
2757: l_split_line_tbl(1).ordered_quantity
2758: := l_line_tbl(l_top_model_index).shipped_quantity;
2759: l_split_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
2760: l_split_line_tbl(1).split_action_code := 'SPLIT';
2761: l_split_line_tbl(1).split_by := 'SYSTEM';
2762:
2763: IF g_debug_call > 0 THEN

Line 2775: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;

2771: := l_line_tbl(l_top_model_index).line_id;
2772: l_split_line_tbl(2).ordered_quantity
2773: := l_line_tbl(l_top_model_index).ordered_quantity -
2774: l_line_tbl(l_top_model_index).shipped_quantity;
2775: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
2776: l_split_line_tbl(2).split_by := 'SYSTEM';
2777:
2778: IF l_debug_level > 0 THEN
2779: oe_debug_pub.add( 'SPLIT FROM LINE ID : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( 2 ) .SPLIT_FROM_LINE_ID ) , 3 ) ;

Line 2795: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

2791: oe_debug_pub.add( 'ORDERED QUANTITY NEW LINE : '|| TO_CHAR ( L_SPLIT_LINE_TBL ( 2 ) .ORDERED_QUANTITY ) , 3 ) ;
2792: END IF;
2793:
2794:
2795: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
2796: l_control_rec.controlled_operation := TRUE;
2797: l_control_rec.check_security := FALSE;
2798: l_control_rec.change_attributes := TRUE;
2799: l_control_rec.default_attributes := TRUE;

Line 2802: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN

2798: l_control_rec.change_attributes := TRUE;
2799: l_control_rec.default_attributes := TRUE;
2800: l_control_rec.clear_dependents := TRUE;
2801:
2802: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
2803: l_set_recursion := 'N';
2804: ELSE
2805: l_set_recursion := 'Y';
2806: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

Line 2806: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

2802: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
2803: l_set_recursion := 'N';
2804: ELSE
2805: l_set_recursion := 'Y';
2806: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
2807: END IF;
2808:
2809: IF g_debug_call > 0 THEN
2810: G_DEBUG_MSG := G_DEBUG_MSG || '81,';

Line 2820: -- OE_GLOBALS.G_RECURSION_MODE := 'N';

2816: x_return_status => l_return_status);
2817:
2818: IF l_set_recursion = 'Y' THEN
2819: l_set_recursion := 'N';
2820: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
2821: END IF;
2822:
2823: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2941: := OE_GLOBALS.G_OPR_UPDATE;

2937: l_line_tbl(l_pto_index).shipped_quantity;
2938: l_split_line_tbl(l_split_index).shipped_quantity
2939: := l_line_tbl(l_pto_index).shipped_quantity;
2940: l_split_line_tbl(l_split_index).operation
2941: := OE_GLOBALS.G_OPR_UPDATE;
2942: l_split_line_tbl(l_split_index).split_by := 'SYSTEM';
2943: l_split_line_tbl(l_split_index).split_action_code := 'SPLIT';
2944:
2945: IF l_debug_level > 0 THEN

Line 3032: (p_item_type => OE_GLOBALS.G_WFI_LIN

3028: || L_ITEM_KEY||'/'||'SHIP_LINE' , 3 ) ;
3029: END IF;
3030:
3031: OE_LINE_FULLFILL.Get_Activity_Result
3032: (p_item_type => OE_GLOBALS.G_WFI_LIN
3033: ,p_item_key => l_item_key
3034: ,p_activity_name => 'SHIP_LINE'
3035: ,x_return_status => l_return_status
3036: ,x_activity_result => l_activity_result

Line 3072: (p_item_type => OE_GLOBALS.G_WFI_LIN

3068: oe_debug_pub.add( 'CALLING GET ACTIVITY RESULT FOR : '|| L_ITEM_KEY||'/'||'FULFILL_LINE' , 3 ) ;
3069: END IF;
3070:
3071: OE_LINE_FULLFILL.Get_Activity_Result
3072: (p_item_type => OE_GLOBALS.G_WFI_LIN
3073: ,p_item_key => l_item_key
3074: ,p_activity_name => 'FULFILL_LINE'
3075: ,x_return_status => l_return_status
3076: ,x_activity_result => l_activity_result

Line 3148: := OE_GLOBALS.G_OPR_UPDATE;

3144: :=l_split_line_tbl(l_split_index).blanket_version_number;
3145: --BSA changes for AFD
3146:
3147: l_fulfill_tbl(l_fulfill_index).operation
3148: := OE_GLOBALS.G_OPR_UPDATE;
3149:
3150: IF l_debug_level > 0 THEN
3151: oe_debug_pub.add( 'FULFILL INDEX : '||TO_CHAR ( L_FULFILL_INDEX ) , 3 ) ;
3152: END IF;

Line 3221: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3217: oe_debug_pub.add( 'COMPLETE ACT :LOGGING REQUEST '|| L_ITEM_KEY , 3 ) ;
3218: END IF;
3219:
3220: OE_Delayed_Requests_Pvt.Log_Request
3221: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3222: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3223: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3224: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3225: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 3223: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3219:
3220: OE_Delayed_Requests_Pvt.Log_Request
3221: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3222: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3223: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3224: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3225: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3226: p_param1 => OE_GLOBALS.G_WFI_LIN,
3227: p_param2 => l_item_key,

Line 3225: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

3221: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3222: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3223: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3224: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3225: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3226: p_param1 => OE_GLOBALS.G_WFI_LIN,
3227: p_param2 => l_item_key,
3228: p_param3 => 'FULFILL_LINE',
3229: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

Line 3226: p_param1 => OE_GLOBALS.G_WFI_LIN,

3222: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3223: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3224: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
3225: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3226: p_param1 => OE_GLOBALS.G_WFI_LIN,
3227: p_param2 => l_item_key,
3228: p_param3 => 'FULFILL_LINE',
3229: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3230: x_return_status => l_return_status);

Line 3229: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

3225: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3226: p_param1 => OE_GLOBALS.G_WFI_LIN,
3227: p_param2 => l_item_key,
3228: p_param3 => 'FULFILL_LINE',
3229: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3230: x_return_status => l_return_status);
3231:
3232: IF l_debug_level > 0 THEN
3233: oe_debug_pub.add( 'FULFILL ASSOCIATED SERVICE LINES '|| L_FULFILL_TBL ( L_FULFILL_INDEX ) .LINE_ID , 3 ) ;

Line 3325: l_control_rec OE_GLOBALS.Control_Rec_Type;

3321: l_msg_data VARCHAR2(2000);
3322: l_unreserve_quantity NUMBER;
3323: l_result_code VARCHAR2(30);
3324: l_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
3325: l_control_rec OE_GLOBALS.Control_Rec_Type;
3326: l_set_recursion VARCHAR2(1) := 'N';
3327:
3328: -- HW 2415731 variables for OPM
3329: l_temp_shipped_qty NUMBER;

Line 3441: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW THEN

3437:
3438:
3439:
3440:
3441: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW THEN
3442:
3443: -- Call API to releive allocation
3444: IF l_debug_level > 0 THEN
3445: oe_debug_pub.add( 'SHIPPED WITHIN TOLERANCE BELOW ' , 3 ) ;

Line 3459: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN

3455:
3456: END IF; -- if below tolerance
3457:
3458:
3459: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
3460: NULL;
3461: -- Send the notification ??
3462: END IF;
3463:

Line 3465: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND

3461: -- Send the notification ??
3462: END IF;
3463:
3464:
3465: IF l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND
3466: l_line_rec.ordered_quantity > l_line_rec.shipped_quantity AND
3467: (l_line_rec.top_model_line_id is null OR
3468: l_line_rec.top_model_line_id = FND_API.G_MISS_NUM OR
3469: nvl(l_line_rec.model_remnant_flag,'N') = 'Y') THEN

Line 3582: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

3578: -- IF ( l_line_tbl(1).shipping_quantity_uom <> l_line_tbl(1).order_quantity_uom )
3579: -- AND oe_line_util.Process_Characteristics
3580: -- HW end of changes for BUG#: 2415731
3581:
3582: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
3583: l_line_tbl(1).split_action_code := 'SPLIT';
3584: l_line_tbl(1).split_by := 'SYSTEM';
3585:
3586: -- Assign the second record of the table for process order for

Line 3645: l_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;

3641: -- AND oe_line_util.Process_Characteristics end of branching
3642: -- HW end of changes 2415731
3643:
3644:
3645: l_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
3646: l_line_tbl(2).split_by := 'SYSTEM';
3647:
3648: -- HW BUG#:2415731 added debugging messages for qty2 and others
3649: IF l_debug_level > 0 THEN

Line 3678: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN

3674:
3675: l_control_rec.validate_entity := FALSE;
3676: l_control_rec.check_security := FALSE;
3677:
3678: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
3679: l_set_recursion := 'N';
3680: ELSE
3681: l_set_recursion := 'Y';
3682: END IF;

Line 3726: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR

3722:
3723: -- Check for Shipment within ship tolerance below, within ship tolerance
3724: -- above and beyond tolerance.
3725:
3726: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
3727: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
3728: l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED OR
3729: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
3730: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE

Line 3727: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR

3723: -- Check for Shipment within ship tolerance below, within ship tolerance
3724: -- above and beyond tolerance.
3725:
3726: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
3727: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
3728: l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED OR
3729: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
3730: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE
3731: THEN

Line 3728: l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED OR

3724: -- above and beyond tolerance.
3725:
3726: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
3727: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
3728: l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED OR
3729: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
3730: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE
3731: THEN
3732:

Line 3729: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR

3725:
3726: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
3727: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
3728: l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED OR
3729: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
3730: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE
3731: THEN
3732:
3733: IF p_check_line_set = 'Y' AND

Line 3730: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE

3726: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW OR
3727: l_x_result_out = OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE OR
3728: l_x_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED OR
3729: l_x_result_out = OE_GLOBALS.G_FULLY_SHIPPED OR
3730: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE
3731: THEN
3732:
3733: IF p_check_line_set = 'Y' AND
3734: l_x_result_out <> OE_GLOBALS.G_PARTIALLY_SHIPPED AND

Line 3734: l_x_result_out <> OE_GLOBALS.G_PARTIALLY_SHIPPED AND

3730: l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE
3731: THEN
3732:
3733: IF p_check_line_set = 'Y' AND
3734: l_x_result_out <> OE_GLOBALS.G_PARTIALLY_SHIPPED AND
3735: l_line_rec.item_type_code IN ('STANDARD') THEN
3736:
3737: -- not now 'CONFIG'
3738: -- l_line_rec.ordered_quantity

Line 3781: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN

3777: G_DEBUG_MSG := G_DEBUG_MSG || '9-25';
3778: END IF;
3779: -- Call WF function to complete the shipment activity
3780:
3781: IF l_x_result_out = OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE THEN
3782: IF l_debug_level > 0 THEN
3783: oe_debug_pub.add( 'LINE SHIPPED BEYOND OVERSHIPMENT TOLERANCE ' , 3 ) ;
3784: END IF;
3785: l_result_code := 'OVER_SHIPPED';

Line 3796: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3792: oe_debug_pub.add( 'COMPLETEACTIVITY , LOG DELAYED REQ '||L_LINE_REC.LINE_ID , 3 ) ;
3793: END IF;
3794:
3795: OE_Delayed_Requests_Pvt.Log_Request
3796: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3797: p_entity_id => l_line_rec.line_id,
3798: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3799: p_requesting_entity_id => l_line_rec.line_id,
3800: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 3798: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3794:
3795: OE_Delayed_Requests_Pvt.Log_Request
3796: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3797: p_entity_id => l_line_rec.line_id,
3798: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3799: p_requesting_entity_id => l_line_rec.line_id,
3800: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3801: p_param1 => OE_GLOBALS.G_WFI_LIN,
3802: p_param2 => l_line_rec.line_id,

Line 3800: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

3796: (p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3797: p_entity_id => l_line_rec.line_id,
3798: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3799: p_requesting_entity_id => l_line_rec.line_id,
3800: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3801: p_param1 => OE_GLOBALS.G_WFI_LIN,
3802: p_param2 => l_line_rec.line_id,
3803: p_param3 => 'SHIP_LINE',
3804: p_param4 => l_result_code,

Line 3801: p_param1 => OE_GLOBALS.G_WFI_LIN,

3797: p_entity_id => l_line_rec.line_id,
3798: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3799: p_requesting_entity_id => l_line_rec.line_id,
3800: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3801: p_param1 => OE_GLOBALS.G_WFI_LIN,
3802: p_param2 => l_line_rec.line_id,
3803: p_param3 => 'SHIP_LINE',
3804: p_param4 => l_result_code,
3805: x_return_status => l_return_status);

Line 3909: ( p_item_type => OE_GLOBALS.G_WFI_LIN

3905: G_DEBUG_MSG := G_DEBUG_MSG || '10-1';
3906: END IF;
3907:
3908: OE_LINE_FULLFILL.Get_Activity_Result
3909: ( p_item_type => OE_GLOBALS.G_WFI_LIN
3910: , p_item_key => p_ato_line_id
3911: , p_activity_name => 'WAIT_FOR_CTO'
3912: , x_return_status => l_return_status
3913: , x_activity_result => l_activity_result

Line 3945: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

3941: G_DEBUG_MSG := G_DEBUG_MSG || '10-3';
3942: END IF;
3943:
3944: OE_Delayed_Requests_Pvt.Log_Request
3945: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3946: p_entity_id => p_ato_line_id,
3947: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3948: p_requesting_entity_id => p_ato_line_id,
3949: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 3947: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

3943:
3944: OE_Delayed_Requests_Pvt.Log_Request
3945: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3946: p_entity_id => p_ato_line_id,
3947: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3948: p_requesting_entity_id => p_ato_line_id,
3949: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3950: p_param1 => OE_GLOBALS.G_WFI_LIN,
3951: p_param2 => p_ato_line_id,

Line 3949: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

3945: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
3946: p_entity_id => p_ato_line_id,
3947: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3948: p_requesting_entity_id => p_ato_line_id,
3949: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3950: p_param1 => OE_GLOBALS.G_WFI_LIN,
3951: p_param2 => p_ato_line_id,
3952: p_param3 => 'WAIT_FOR_CTO',
3953: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

Line 3950: p_param1 => OE_GLOBALS.G_WFI_LIN,

3946: p_entity_id => p_ato_line_id,
3947: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
3948: p_requesting_entity_id => p_ato_line_id,
3949: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3950: p_param1 => OE_GLOBALS.G_WFI_LIN,
3951: p_param2 => p_ato_line_id,
3952: p_param3 => 'WAIT_FOR_CTO',
3953: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3954: x_return_status => l_return_status);

Line 3953: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

3949: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
3950: p_param1 => OE_GLOBALS.G_WFI_LIN,
3951: p_param2 => p_ato_line_id,
3952: p_param3 => 'WAIT_FOR_CTO',
3953: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
3954: x_return_status => l_return_status);
3955:
3956: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3957: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 4001: l_control_rec OE_GLOBALS.Control_Rec_Type;

3997: l_line_id NUMBER;
3998: l_return_status VARCHAR2(1);
3999: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
4000: l_update_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4001: l_control_rec OE_GLOBALS.Control_Rec_Type;
4002: l_set_recursion VARCHAR2(1) := 'N';
4003: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
4004: l_result_out VARCHAR2(30);
4005: --

Line 4030: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

4026: OE_Line_Util.Query_Rows
4027: (p_line_id => l_line_rec.top_model_line_id,
4028: x_line_tbl => l_update_line_tbl);
4029:
4030: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
4031: l_control_rec.validate_entity:= FALSE;
4032: l_control_rec.check_security := FALSE;
4033:
4034: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

Line 4034: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

4030: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
4031: l_control_rec.validate_entity:= FALSE;
4032: l_control_rec.check_security := FALSE;
4033:
4034: l_update_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4035: l_update_line_tbl(1).shipped_quantity := l_line_rec.shipped_quantity;
4036: l_update_line_tbl(1).actual_shipment_date := l_line_rec.actual_shipment_date;
4037:
4038: IF l_debug_level > 0 THEN

Line 4043: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN

4039: oe_debug_pub.add('ACTUAL SHIPMENT DATE :'
4040: ||TO_CHAR(L_UPDATE_LINE_TBL(1).ACTUAL_SHIPMENT_DATE,'DD-MM-YY'),3);
4041: END IF;
4042:
4043: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
4044: l_set_recursion := 'N';
4045: ELSE
4046: l_set_recursion := 'Y';
4047: END IF;

Line 4083: IF l_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND

4079: oe_debug_pub.add( 'SHIPMENT STATUS : '||L_RESULT_OUT , 3 ) ;
4080: END IF;
4081:
4082:
4083: IF l_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED AND
4084:
4085: l_line_rec.ordered_quantity > l_line_rec.shipped_quantity THEN
4086:
4087: l_split_line_tbl(1) := l_update_line_tbl(1);

Line 4089: l_split_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

4085: l_line_rec.ordered_quantity > l_line_rec.shipped_quantity THEN
4086:
4087: l_split_line_tbl(1) := l_update_line_tbl(1);
4088: l_split_line_tbl(1).ordered_quantity := l_line_rec.shipped_quantity;
4089: l_split_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
4090: l_split_line_tbl(1).split_action_code:= 'SPLIT';
4091: l_split_line_tbl(1).split_by := 'SYSTEM';
4092:
4093: -- Assign the second record of the table for process order for

Line 4100: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;

4096: l_split_line_tbl(2) := OE_ORDER_PUB.G_MISS_LINE_REC;
4097: l_split_line_tbl(2).split_from_line_id := l_update_line_tbl(1).line_id;
4098: l_split_line_tbl(2).ordered_quantity :=
4099: l_line_rec.ordered_quantity - l_line_rec.shipped_quantity;
4100: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
4101: l_split_line_tbl(2).split_by := 'SYSTEM';
4102:
4103: IF l_debug_level > 0 THEN
4104: oe_debug_pub.add( 'ITEM TYPE CODE : '||L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;

Line 4123: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

4119: oe_debug_pub.add( 'ORDERED QUANTITY NEW LINE : '
4120: ||TO_CHAR ( L_SPLIT_LINE_TBL ( 2 ) .ORDERED_QUANTITY ) , 3 ) ;
4121: END IF;
4122:
4123: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
4124: l_control_rec.controlled_operation := TRUE;
4125: l_control_rec.check_security := FALSE;
4126: l_control_rec.change_attributes := TRUE;
4127: l_control_rec.default_attributes := TRUE;

Line 4130: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN

4126: l_control_rec.change_attributes := TRUE;
4127: l_control_rec.default_attributes := TRUE;
4128: l_control_rec.clear_dependents := TRUE;
4129:
4130: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
4131: l_set_recursion := 'N';
4132: ELSE
4133: l_set_recursion := 'Y';
4134: END IF;

Line 4236: l_control_rec OE_GLOBALS.Control_Rec_Type;

4232: l_process_tbl OE_Order_Pub.Line_Tbl_Type;
4233: l_process_index NUMBER := 0;
4234: l_set_tbl OE_ORDER_PUB.Line_Tbl_Type;
4235: l_set_index NUMBER := 0;
4236: l_control_rec OE_GLOBALS.Control_Rec_Type;
4237: l_line_shipped VARCHAR2(1) := FND_API.G_FALSE;
4238: l_return_status VARCHAR2(1);
4239: l_set_recursion VARCHAR2(1) := 'N';
4240:

Line 4290: l_line_tbl(l_line_index).item_type_code = OE_Globals.G_ITEM_CONFIG) THEN

4286: oe_debug_pub.add( 'LINE_ID/TOP_MODEL_LINE_ID : '||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .LINE_ID ) ||'/'||TO_CHAR ( L_LINE_TBL ( L_LINE_INDEX ) .TOP_MODEL_LINE_ID ) , 3 ) ;
4287: END IF;
4288:
4289: IF (l_line_tbl(l_line_index).link_to_line_id = l_line_tbl(l_line_index).top_model_line_id AND
4290: l_line_tbl(l_line_index).item_type_code = OE_Globals.G_ITEM_CONFIG) THEN
4291: IF l_debug_level > 0 THEN
4292: oe_debug_pub.add( 'IT IS AN ATO ' , 3 ) ;
4293: END IF;
4294: l_process_index := l_process_index + 1;

Line 4309: ELSIF l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN

4305: END IF;
4306: l_process_index := l_process_index + 1;
4307: l_process_tbl(l_process_index) := l_line_tbl(l_line_index);
4308:
4309: ELSIF l_line_tbl(l_line_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN
4310:
4311: IF l_debug_level > 0 THEN
4312: oe_debug_pub.add( 'IT IS A STANDARD LINE' , 3 ) ;
4313: END IF;

Line 4379: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN

4375: l_process_tbl(l_process_index).shipped_quantity <> FND_API.G_MISS_NUM THEN
4376: IF l_debug_level > 0 THEN
4377: oe_debug_pub.add( 'INSIDE THE LOOP : LINE ID : '|| TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4378: END IF;
4379: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_STANDARD THEN
4380: Ship_Confirm_Standard_Line
4381: (
4382: p_line_rec => l_process_tbl(l_process_index),
4383: x_return_status => l_return_status

Line 4393: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

4389: RAISE FND_API.G_EXC_ERROR;
4390: END IF;
4391: END IF;
4392:
4393: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
4394: Ship_Confirm_ATO
4395: (
4396: p_line_id => l_process_tbl(l_process_index).line_id,
4397: x_return_status => l_return_status

Line 4417: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN

4413: oe_debug_pub.add( 'SHIP SET IS PARTIALLY SHIPPED REMOVING THE SETID '||TO_CHAR ( L_PROCESS_TBL ( L_PROCESS_INDEX ) .LINE_ID ) , 3 ) ;
4414: END IF;
4415: l_set_index := l_set_index + 1;
4416: l_set_tbl(l_set_index) := OE_Order_Pub.G_MISS_LINE_REC;
4417: IF l_process_tbl(l_process_index).item_type_code = OE_GLOBALS.G_ITEM_CONFIG THEN
4418: l_set_tbl(l_set_index).line_id := l_process_tbl(l_process_index).top_model_line_id;
4419: ELSE
4420: l_set_tbl(l_set_index).line_id := l_process_tbl(l_process_index).line_id;
4421: END IF;

Line 4426: l_set_tbl(l_set_index).operation := OE_GLOBALS.G_OPR_UPDATE;

4422: IF l_debug_level > 0 THEN
4423: oe_debug_pub.add( 'LINE ID : '||TO_CHAR ( L_SET_TBL ( L_SET_INDEX ) .LINE_ID ) , 3 ) ;
4424: END IF;
4425: l_set_tbl(l_set_index).ship_set_id := NULL;
4426: l_set_tbl(l_set_index).operation := OE_GLOBALS.G_OPR_UPDATE;
4427:
4428: END IF;
4429:
4430: l_line_shipped := FND_API.G_FALSE;

Line 4436: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

4432: END LOOP;
4433:
4434: IF l_set_index <> 0 THEN
4435:
4436: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
4437: l_control_rec.validate_entity := FALSE;
4438: l_control_rec.check_security := FALSE;
4439:
4440: IF l_debug_level > 0 THEN

Line 4447: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN

4443: IF l_debug_level > 0 THEN
4444: oe_debug_pub.add( 'NUMBER OF LINES '||TO_CHAR ( L_SET_INDEX ) , 3 ) ;
4445: END IF;
4446:
4447: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
4448:
4449: l_set_recursion := 'N';
4450:
4451: ELSE

Line 4454: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

4450:
4451: ELSE
4452:
4453: l_set_recursion := 'Y';
4454: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
4455:
4456: END IF;
4457: IF g_debug_call > 0 THEN
4458: G_DEBUG_MSG := G_DEBUG_MSG || '11-8';

Line 4471: -- OE_GLOBALS.G_RECURSION_MODE := 'N';

4467:
4468: IF l_set_recursion = 'Y' THEN
4469:
4470: l_set_recursion := 'N';
4471: -- OE_GLOBALS.G_RECURSION_MODE := 'N';
4472: END IF;
4473:
4474: IF l_debug_level > 0 THEN
4475: oe_debug_pub.add( 'RETURN STATUS FROM PROCESS ORDER : '||L_RETURN_STATUS , 3 ) ;

Line 4552: l_old_recursion_mode VARCHAR2(1) := OE_GLOBALS.G_RECURSION_MODE;

4548: l_msg_count NUMBER;
4549: l_msg_data VARCHAR2(2000);
4550: l_tolerance_quantity_below NUMBER;
4551: l_tolerance_quantity_above NUMBER;
4552: l_old_recursion_mode VARCHAR2(1) := OE_GLOBALS.G_RECURSION_MODE;
4553:
4554: --
4555: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
4556: --

Line 4564: -- Setting the Global variable OE_GLOBALS.G_RECURSION_MODE to Y so that the

4560: -- debug level changed to 0.5 for bug 13435459
4561: oe_debug_pub.add( 'ENTERING OE_SHIPPING_INTEGRATION_PVT.PROCESS_SHIP_CONFIRM '|| P_PROCESS_TYPE , 0.5 ) ;
4562: END IF;
4563:
4564: -- Setting the Global variable OE_GLOBALS.G_RECURSION_MODE to Y so that the
4565: -- Price request for "SHIP" event is not triggered before COST records are
4566: -- inserted into OE_PRICE_ADJUSTMENTS.
4567:
4568: IF g_debug_call > 0 THEN

Line 4572: IF OE_GLOBALS.G_RECURSION_MODE <> 'Y' THEN

4568: IF g_debug_call > 0 THEN
4569: G_DEBUG_MSG := G_DEBUG_MSG || '12-1';
4570: END IF;
4571:
4572: IF OE_GLOBALS.G_RECURSION_MODE <> 'Y' THEN
4573: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
4574: null;
4575: END IF;
4576:

Line 4573: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';

4569: G_DEBUG_MSG := G_DEBUG_MSG || '12-1';
4570: END IF;
4571:
4572: IF OE_GLOBALS.G_RECURSION_MODE <> 'Y' THEN
4573: -- OE_GLOBALS.G_RECURSION_MODE := 'Y';
4574: null;
4575: END IF;
4576:
4577:

Line 4652: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN

4648:
4649: END IF;
4650:
4651: x_return_status := FND_API.G_RET_STS_SUCCESS;
4652: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4653: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4654: null;
4655: END IF;
4656:

Line 4653: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;

4649: END IF;
4650:
4651: x_return_status := FND_API.G_RET_STS_SUCCESS;
4652: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4653: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4654: null;
4655: END IF;
4656:
4657: IF l_debug_level > 0 THEN

Line 4664: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN

4660: END IF;
4661:
4662: EXCEPTION
4663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4664: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4665: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4666: null;
4667: END IF;
4668:

Line 4665: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;

4661:
4662: EXCEPTION
4663: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4664: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4665: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4666: null;
4667: END IF;
4668:
4669: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 4683: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN

4679: G_DEBUG_MSG := G_DEBUG_MSG || 'E-30';
4680: END IF;
4681:
4682: WHEN FND_API.G_EXC_ERROR THEN
4683: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4684: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4685: null;
4686: END IF;
4687: x_return_status := FND_API.G_RET_STS_ERROR;

Line 4684: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;

4680: END IF;
4681:
4682: WHEN FND_API.G_EXC_ERROR THEN
4683: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4684: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4685: null;
4686: END IF;
4687: x_return_status := FND_API.G_RET_STS_ERROR;
4688: IF g_debug_call > 0 THEN

Line 4692: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN

4688: IF g_debug_call > 0 THEN
4689: G_DEBUG_MSG := G_DEBUG_MSG || 'E31';
4690: END IF;
4691: WHEN OTHERS THEN
4692: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4693: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4694: null;
4695: END IF;
4696: IF g_debug_call > 0 THEN

Line 4693: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;

4689: G_DEBUG_MSG := G_DEBUG_MSG || 'E31';
4690: END IF;
4691: WHEN OTHERS THEN
4692: IF l_old_recursion_mode <> OE_GLOBALS.G_RECURSION_MODE THEN
4693: -- OE_GLOBALS.G_RECURSION_MODE := l_old_recursion_mode;
4694: null;
4695: END IF;
4696: IF g_debug_call > 0 THEN
4697: G_DEBUG_MSG := G_DEBUG_MSG || 'E-32';

Line 5977: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN

5973: END LOOP;
5974:
5975: ELSE --pre-pack H
5976:
5977: IF OE_GLOBALS.G_ASO_INSTALLED = 'Y' THEN
5978:
5979: OE_Order_PVT.Process_Requests_And_Notify
5980: ( p_process_requests => FALSE
5981: , p_notify => TRUE