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_SHIP_CONFIRMATION_PUB dependencies on OE_GLOBALS

Line 8: G_SKIP_SHIP VARCHAR2(30) := OE_GLOBALS.G_COMPLETE_ACTIVITY; -- Bug 10032407

4:
5: -- Global constant holding the package name
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Ship_Confirmation_Pub';
8: G_SKIP_SHIP VARCHAR2(30) := OE_GLOBALS.G_COMPLETE_ACTIVITY; -- Bug 10032407
9:
10: Type ship_confirm_models is table of NUMBER
11: index by binary_integer;
12:

Line 121: l_control_rec OE_GLOBALS.Control_Rec_Type;

117: -- l_OPM_requested_quantity NUMBER; INVCONV
118: l_ordered_quantity2 NUMBER;
119: l_split_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
120: l_line_set_id NUMBER;
121: l_control_rec OE_GLOBALS.Control_Rec_Type;
122: l_set_recursion VARCHAR2(1) := 'N';
123:
124: l_calculate_price_flag VARCHAR2(1);
125: -- Variables for update global picture jolin

Line 167: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

163: IF l_debug_level > 0 THEN
164: oe_debug_pub.add( 'ENTERING OE_SHIP_CONFIRM.SHIP_CONFIRM' , 1 ) ;
165: END IF;
166:
167: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
168: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
169: END IF;
170:
171: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

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

164: oe_debug_pub.add( 'ENTERING OE_SHIP_CONFIRM.SHIP_CONFIRM' , 1 ) ;
165: END IF;
166:
167: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
168: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
169: END IF;
170:
171: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
172: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);

Line 171: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

167: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
168: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
169: END IF;
170:
171: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
172: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
173: END IF;
174:
175: IF l_debug_level > 0 THEN

Line 172: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);

168: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
169: END IF;
170:
171: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
172: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
173: END IF;
174:
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'NUMBER OF RECORDS LINE/ADJ/REQ :

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

335: l_split_line_tbl(1).ordered_quantity := l_temp_requested_quantity;
336: -- HW added qty2 for OPM
337: -- l_split_line_tbl(1).ordered_quantity2 := nvl(p_req_qty_tbl(J).requested_quantity2,0); -- INVCONV
338: l_split_line_tbl(1).ordered_quantity2 := nvl(l_temp_requested_quantity2, 0); -- INVCONV
339: l_split_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
340: l_split_line_tbl(1).split_action_code := 'SPLIT';
341: l_split_line_tbl(1).split_by := 'SYSTEM';
342: l_split_line_tbl(1).change_reason := 'SYSTEM';
343: l_split_line_tbl(1).ship_from_org_id := l_ship_from_org_id; --9733938

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

364: l_split_line_tbl(2).ordered_quantity2 := nvl(l_ordered_quantity2,0)
365: -- nvl(p_req_qty_tbl(J).requested_quantity2,0); INVCONV
366: - nvl(l_temp_requested_quantity2, 0);
367:
368: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
369: l_split_line_tbl(2).split_by := 'SYSTEM';
370: l_split_line_tbl(2).change_reason := 'SYSTEM';
371:
372: IF l_debug_level > 0 THEN

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

399:
400: l_control_rec.validate_entity := FALSE;
401: l_control_rec.check_security := FALSE;
402:
403: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
404:
405: l_set_recursion := 'N';
406:
407: ELSE

Line 486: l_line_id_mod := mod(p_line_tbl(J).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918

482: FROM oe_order_lines
483: WHERE line_id = p_line_tbl(J).line_id;
484:
485:
486: l_line_id_mod := mod(p_line_tbl(J).line_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918
487: --bug3549422
488: --added the NOWAIT to the select statements and
489: BEGIN
490:

Line 549: l_ship_set_id_mod := mod(l_ship_set_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918

545: FROM OE_ORDER_LINES
546: WHERE line_id = p_line_tbl(J).line_id
547: FOR UPDATE NOWAIT;
548:
549: l_ship_set_id_mod := mod(l_ship_set_id,OE_GLOBALS.G_BINARY_LIMIT); -- Bug 8795918
550:
551: EXCEPTION
552:
553: WHEN APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION THEN

Line 590: IF NOT OE_GLOBALS.Equal(p_line_tbl(J).shipping_quantity,l_shipping_quantity) THEN

586: l_over_ship_reason_code_upd := p_line_tbl(J).over_ship_reason_code;
587:
588: END IF;
589:
590: IF NOT OE_GLOBALS.Equal(p_line_tbl(J).shipping_quantity,l_shipping_quantity) THEN
591: -- Convert the shipping quantity from shipping quantity UOM to
592: -- Ordered quantity UOM and update the field shipped quantity
593: -- Call API to convert the shipping quantity to shipped quantity
594: -- from shipping quantity UOM to ordered quantity UOM and assign

Line 930: l_item_type_code = Oe_Globals.G_ITEM_CONFIG AND

926: END IF;
927:
928: ELSIF (l_ato_line_id IS NOT NULL AND
929: l_ato_line_id <> FND_API.G_MISS_NUM) AND
930: l_item_type_code = Oe_Globals.G_ITEM_CONFIG AND
931: l_ato_line_id = l_top_model_line_id THEN
932:
933: IF l_debug_level > 0 THEN
934: oe_debug_pub.add( 'ATO SHIPPED : '||P_LINE_TBL ( J ) .LINE_ID , 3 ) ;

Line 958: l_top_model_line_id_mod := mod(l_top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);-- Bug 8795918

954: ELSIF (l_top_model_line_id IS NOT NULL AND
955: l_top_model_line_id <> FND_API.G_MISS_NUM) AND
956: nvl(l_model_remnant_flag,'N') = 'N' THEN
957:
958: l_top_model_line_id_mod := mod(l_top_model_line_id,OE_GLOBALS.G_BINARY_LIMIT);-- Bug 8795918
959:
960: IF l_debug_level > 0 THEN
961: oe_debug_pub.add( 'PTO/KIT SHIPPED : '||L_TOP_MODEL_LINE_ID , 3 ) ;
962: END IF;

Line 1007: END IF; -- IF NOT OE_GLOBALS.Equal

1003: END IF;
1004:
1005: END IF;
1006:
1007: END IF; -- IF NOT OE_GLOBALS.Equal
1008:
1009:
1010: /* jolin start */
1011: /* Moved call to query record out NOCOPY of IF ordered=shipped below so that

Line 1032: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

1028: IF l_debug_level > 0 THEN
1029: oe_debug_pub.add( 'UPDATING LINE : '||P_LINE_TBL ( J ) .LINE_ID , 3 ) ;
1030: END IF;
1031:
1032: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1033: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1034: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
1035: THEN
1036: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */

Line 1033: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR

1029: oe_debug_pub.add( 'UPDATING LINE : '||P_LINE_TBL ( J ) .LINE_ID , 3 ) ;
1030: END IF;
1031:
1032: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1033: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1034: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
1035: THEN
1036: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */
1037: IF l_debug_level > 0 THEN

Line 1067: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR

1063: WHERE line_id = p_line_tbl(J).line_id;
1064:
1065: ELSE /* ordered does not equal shipped qty */
1066:
1067: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1068: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1069: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y'))
1070: THEN
1071: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */

Line 1068: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR

1064:
1065: ELSE /* ordered does not equal shipped qty */
1066:
1067: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1068: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1069: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y'))
1070: THEN
1071: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */
1072: IF l_debug_level > 0 THEN

Line 1094: IF l_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED THEN

1090: , p_shipped_quantity => l_Shipped_Quantity
1091: , x_result_out => l_result_out
1092: );
1093:
1094: IF l_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED THEN
1095: -- This line will split, set the calculate_price_flag to 'P' if 'Y'
1096: IF l_debug_level > 0 THEN
1097: oe_debug_pub.add( 'CALCULATE PRICE FLAG : '||L_CALCULATE_PRICE_FLAG , 3 ) ;
1098: END IF;

Line 1130: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1126: AND p_line_tbl(J).shipping_quantity2 <> 0 ) -- bug 3598987,3659454
1127: THEN
1128: oe_debug_pub.add( 'Before logging Delayed request for pricing',3);
1129: OE_delayed_requests_Pvt.log_request(
1130: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1131: p_entity_id => p_line_tbl(J).line_id,
1132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1133: p_requesting_entity_id => p_line_tbl(J).line_id,
1134: p_request_unique_key1 => 'SHIP',

Line 1132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1128: oe_debug_pub.add( 'Before logging Delayed request for pricing',3);
1129: OE_delayed_requests_Pvt.log_request(
1130: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1131: p_entity_id => p_line_tbl(J).line_id,
1132: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1133: p_requesting_entity_id => p_line_tbl(J).line_id,
1134: p_request_unique_key1 => 'SHIP',
1135: p_param1 => l_header_id,
1136: p_param2 => 'SHIP',

Line 1137: p_request_type => OE_GLOBALS.G_PRICE_LINE,

1133: p_requesting_entity_id => p_line_tbl(J).line_id,
1134: p_request_unique_key1 => 'SHIP',
1135: p_param1 => l_header_id,
1136: p_param2 => 'SHIP',
1137: p_request_type => OE_GLOBALS.G_PRICE_LINE,
1138: x_return_status => l_return_status);
1139:
1140: END IF;
1141:

Line 1396: IF (OE_GLOBALS.G_RECURSION_MODE = 'N'

1392: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1393: --
1394: BEGIN
1395:
1396: IF (OE_GLOBALS.G_RECURSION_MODE = 'N'
1397: AND OE_DELAYED_REQUESTS_PVT.Requests_Count > 0 )
1398: THEN
1399:
1400: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1401: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ

1397: AND OE_DELAYED_REQUESTS_PVT.Requests_Count > 0 )
1398: THEN
1399:
1400: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1401: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ
1402: ,p_delete => FND_API.G_TRUE
1403: ,x_return_status => l_return_status
1404: );
1405: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1412: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att

1408: RAISE FND_API.G_EXC_ERROR;
1409: END IF;
1410:
1411: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1412: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att
1413: ,p_delete => FND_API.G_TRUE
1414: ,x_return_status => l_return_status
1415: );
1416: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1423: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att

1419: RAISE FND_API.G_EXC_ERROR;
1420: END IF;
1421:
1422: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1423: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att
1424: ,p_delete => FND_API.G_TRUE
1425: ,x_return_status => l_return_status
1426: );
1427: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1434: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc

1430: RAISE FND_API.G_EXC_ERROR;
1431: END IF;
1432:
1433: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1434: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc
1435: ,p_delete => FND_API.G_TRUE
1436: ,x_return_status => l_return_status
1437: );
1438: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1445: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit

1441: RAISE FND_API.G_EXC_ERROR;
1442: END IF;
1443:
1444: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1445: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit
1446: ,p_delete => FND_API.G_TRUE
1447: ,x_return_status => l_return_status
1448: );
1449: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1456: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

1452: RAISE FND_API.G_EXC_ERROR;
1453: END IF;
1454:
1455: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1456: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
1457: ,p_delete => FND_API.G_TRUE
1458: ,x_return_status => l_return_status
1459: );
1460: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1467: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ

1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:
1466: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1467: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ
1468: ,p_delete => FND_API.G_TRUE
1469: ,x_return_status => l_return_status
1470: );
1471: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1478: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Scredit

1474: RAISE FND_API.G_EXC_ERROR;
1475: END IF;
1476:
1477: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1478: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Scredit
1479: ,p_delete => FND_API.G_TRUE
1480: ,x_return_status => l_return_status
1481: );
1482: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1489: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att

1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:
1488: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1489: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att
1490: ,p_delete => FND_API.G_TRUE
1491: ,x_return_status => l_return_status
1492: );
1493: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1500: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Att

1496: RAISE FND_API.G_EXC_ERROR;
1497: END IF;
1498:
1499: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1500: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Att
1501: ,p_delete => FND_API.G_TRUE
1502: ,x_return_status => l_return_status
1503: );
1504: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1511: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Assoc

1507: RAISE FND_API.G_EXC_ERROR;
1508: END IF;
1509:
1510: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1511: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Assoc
1512: ,p_delete => FND_API.G_TRUE
1513: ,x_return_status => l_return_status
1514: );
1515: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1739: l_control_rec OE_GLOBALS.Control_Rec_Type;

1735: ( p_requested_line_rec IN OUT NOCOPY Ship_Line_Rec_Type)
1736: IS
1737: --J NUMBER := 0; bug 4422886
1738: l_split_line_rec OE_Order_Pub.Line_Rec_Type;
1739: l_control_rec OE_GLOBALS.Control_Rec_Type;
1740: l_return_status VARCHAR2(1);
1741: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1742: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;
1743: l_wdd_count NUMBER;

Line 1831: l_split_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

1827: := p_requested_line_rec.shipped_quantity2(I); -- INVCONV
1828: l_split_line_rec.ship_from_org_id := p_requested_line_rec.ship_from_org_id(I); --9733938
1829:
1830:
1831: l_split_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1832: l_split_line_rec.split_action_code := 'SPLIT';
1833: l_split_line_rec.split_by := 'SYSTEM';
1834: l_split_line_rec.change_reason := 'SYSTEM';
1835:

Line 1860: l_split_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;

1856: l_split_line_rec.split_from_line_id := l_split_line_tbl(1).line_id;
1857:
1858: l_split_line_rec.split_by := 'SYSTEM';
1859: l_split_line_rec.change_reason := 'SYSTEM';
1860: l_split_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1861:
1862: -- J := J+1; bug 4422886
1863:
1864: l_split_line_tbl(2) := l_split_line_rec;

Line 1930: l_control_rec OE_GLOBALS.Control_Rec_Type;

1926: ,p_index IN NUMBER
1927: ,p_split_model IN VARCHAR2 := 'N')
1928: IS
1929: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1930: l_control_rec OE_GLOBALS.Control_Rec_Type;
1931: l_return_status VARCHAR2(1);
1932: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1933: l_return NUMBER; --Bug 7528326
1934: BEGIN

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

1942: IF l_debug_level > 0 THEN
1943: oe_debug_pub.add('local split line 1 ', 3);
1944: END IF;
1945:
1946: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1947: l_line_tbl(1).split_by := 'SYSTEM';
1948: l_line_tbl(1).change_reason := 'SYSTEM';
1949: l_line_tbl(1).split_action_code := 'SPLIT';
1950: l_line_tbl(1).ordered_quantity :=

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

1954:
1955: IF l_debug_level > 0 THEN
1956: oe_debug_pub.add('local split line 2 ', 3);
1957: END IF;
1958: l_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
1959: l_line_tbl(2).split_by := 'SYSTEM';
1960: l_line_tbl(2).change_reason := 'SYSTEM';
1961: l_line_tbl(2).ordered_quantity :=
1962: p_ship_line_rec.ordered_quantity(p_index) -

Line 2292: (p_item_type => OE_GLOBALS.G_WFI_LIN

2288: oe_debug_pub.add('CALLING GET ACTIVITY RESULT FOR : '|| line_rec.line_id, 3);
2289: END IF;
2290:
2291: OE_LINE_FULLFILL.Get_Activity_Result
2292: (p_item_type => OE_GLOBALS.G_WFI_LIN
2293: ,p_item_key => to_char(line_rec.line_id)
2294: ,p_activity_name => 'FULFILL_LINE'
2295: ,x_return_status => l_return_status
2296: ,x_activity_result => l_activity_result

Line 2360: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;

2356: l_fulfill_tbl(l_fulfill_index).blanket_version_number
2357: := line_rec.blanket_version_number;
2358: --BSA changes
2359:
2360: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
2361:
2362: IF l_debug_level > 0 THEN
2363: oe_debug_pub.add('FULFILLED QUANTITY : '
2364: || L_FULFILL_TBL(L_FULFILL_INDEX).FULFILLED_QUANTITY,3);

Line 2413: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2409: RAISE FND_API.G_EXC_ERROR;
2410: END IF;
2411:
2412: OE_Delayed_Requests_Pvt.Log_Request
2413: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2414: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2415: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2416: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2417: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 2415: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

2411:
2412: OE_Delayed_Requests_Pvt.Log_Request
2413: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2414: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2415: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2416: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2417: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2418: p_param1 => OE_GLOBALS.G_WFI_LIN,
2419: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??

Line 2417: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

2413: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2414: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2415: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2416: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2417: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2418: p_param1 => OE_GLOBALS.G_WFI_LIN,
2419: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??
2420: p_param3 => 'FULFILL_LINE',
2421: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

Line 2418: p_param1 => OE_GLOBALS.G_WFI_LIN,

2414: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2415: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2416: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2417: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2418: p_param1 => OE_GLOBALS.G_WFI_LIN,
2419: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??
2420: p_param3 => 'FULFILL_LINE',
2421: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2422: x_return_status => l_return_status);

Line 2421: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

2417: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2418: p_param1 => OE_GLOBALS.G_WFI_LIN,
2419: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??
2420: p_param3 => 'FULFILL_LINE',
2421: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2422: x_return_status => l_return_status);
2423:
2424: OE_LINE_FULLFILL.Fulfill_Service_Lines
2425: (p_line_id => l_fulfill_tbl(l_fulfill_index).line_id,

Line 2512: ( p_item_type => OE_GLOBALS.G_WFI_LIN

2508: IF l_debug_level > 0 THEN
2509: oe_debug_pub.add( 'GET ACTIVITY RESULT : '|| p_ship_line_rec.ato_line_id(p_index) , 3 ) ;
2510: END IF;
2511: OE_LINE_FULLFILL.Get_Activity_Result
2512: ( p_item_type => OE_GLOBALS.G_WFI_LIN
2513: , p_item_key => p_ship_line_rec.ato_line_id(p_index)
2514: , p_activity_name => 'WAIT_FOR_CTO'
2515: , x_return_status => l_return_status
2516: , x_activity_result => l_activity_result

Line 2540: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2536:
2537: OE_DEBUG_PUB.Add('Log delayed request for Complete CTO-Bug-3471040');
2538:
2539: OE_Delayed_Requests_Pvt.Log_Request
2540: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2541: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2542: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2543: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2544: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 2542: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

2538:
2539: OE_Delayed_Requests_Pvt.Log_Request
2540: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2541: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2542: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2543: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2544: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2545: p_param1 => OE_GLOBALS.G_WFI_LIN,
2546: p_param2 => p_ship_line_rec.ato_line_id(p_index),

Line 2544: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

2540: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2541: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2542: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2543: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2544: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2545: p_param1 => OE_GLOBALS.G_WFI_LIN,
2546: p_param2 => p_ship_line_rec.ato_line_id(p_index),
2547: p_param3 => 'WAIT_FOR_CTO',
2548: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

Line 2545: p_param1 => OE_GLOBALS.G_WFI_LIN,

2541: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2542: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2543: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2544: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2545: p_param1 => OE_GLOBALS.G_WFI_LIN,
2546: p_param2 => p_ship_line_rec.ato_line_id(p_index),
2547: p_param3 => 'WAIT_FOR_CTO',
2548: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2549: x_return_status => l_return_status);

Line 2548: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

2544: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2545: p_param1 => OE_GLOBALS.G_WFI_LIN,
2546: p_param2 => p_ship_line_rec.ato_line_id(p_index),
2547: p_param3 => 'WAIT_FOR_CTO',
2548: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2549: x_return_status => l_return_status);
2550:
2551: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2552: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2650: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2646: oe_debug_pub.add('Activity to be performed' || G_SKIP_SHIP, 5); -- Bug 10032407
2647: END IF;
2648:
2649: OE_Delayed_Requests_Pvt.Log_Request
2650: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2651: p_entity_id => p_ship_line_rec.line_id(p_index),
2652: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2653: p_requesting_entity_id => p_ship_line_rec.line_id(p_index),
2654: p_request_type => G_SKIP_SHIP, -- Bug 10032407

Line 2652: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

2648:
2649: OE_Delayed_Requests_Pvt.Log_Request
2650: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2651: p_entity_id => p_ship_line_rec.line_id(p_index),
2652: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2653: p_requesting_entity_id => p_ship_line_rec.line_id(p_index),
2654: p_request_type => G_SKIP_SHIP, -- Bug 10032407
2655: p_param1 => OE_GLOBALS.G_WFI_LIN,
2656: p_param2 => p_ship_line_rec.line_id(p_index),

Line 2655: p_param1 => OE_GLOBALS.G_WFI_LIN,

2651: p_entity_id => p_ship_line_rec.line_id(p_index),
2652: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2653: p_requesting_entity_id => p_ship_line_rec.line_id(p_index),
2654: p_request_type => G_SKIP_SHIP, -- Bug 10032407
2655: p_param1 => OE_GLOBALS.G_WFI_LIN,
2656: p_param2 => p_ship_line_rec.line_id(p_index),
2657: p_param3 => 'SHIP_LINE',
2658: p_param4 => 'SHIP_CONFIRM',
2659: x_return_status => l_return_status);

Line 3108: l_split_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;

3104: IF l_debug_level > 0 THEN
3105: oe_debug_pub.add('zz2', 1);
3106: END IF;
3107:
3108: l_split_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;
3109:
3110: l_split_line_tbl(l_count).split_by := 'SYSTEM';
3111: l_split_line_tbl(l_count).change_reason := 'SYSTEM';
3112: l_split_line_tbl(l_count).split_action_code := 'SPLIT';

Line 3453: G_SKIP_SHIP := OE_GLOBALS.G_SKIP_ACTIVITY; -- Bug 10032407

3449: actual_shipment_date = l_line_set_rec.actual_shipment_date(I),
3450: lock_control = lock_control + 1
3451: WHERE line_id = l_line_set_rec.line_id(I);
3452:
3453: G_SKIP_SHIP := OE_GLOBALS.G_SKIP_ACTIVITY; -- Bug 10032407
3454:
3455: IF l_debug_level > 0 THEN
3456: oe_debug_pub.add('line set id '|| line_rec.line_set_id , 3 ) ;
3457: END IF;

Line 3464: G_SKIP_SHIP:= OE_GLOBALS.G_COMPLETE_ACTIVITY; -- Bug 10032407

3460: (p_ship_line_rec => l_line_set_rec
3461: ,p_check_line_set => 'N'
3462: ,p_index => I);
3463:
3464: G_SKIP_SHIP:= OE_GLOBALS.G_COMPLETE_ACTIVITY; -- Bug 10032407
3465:
3466: IF l_debug_level > 0 THEN
3467: oe_debug_pub.add('ret sts for me '||l_return_status , 3 ) ;
3468: END IF;

Line 3486: G_SKIP_SHIP:= OE_GLOBALS.G_COMPLETE_ACTIVITY; -- Bug 10032407

3482: END IF;
3483:
3484: EXCEPTION
3485: WHEN OTHERS THEN
3486: G_SKIP_SHIP:= OE_GLOBALS.G_COMPLETE_ACTIVITY; -- Bug 10032407
3487: IF l_debug_level > 0 THEN
3488: oe_debug_pub.add('error in Ship_Confirm_Split_Lines '|| sqlerrm,3);
3489: END IF;
3490: RAISE;

Line 3589: l_control_rec OE_GLOBALS.Control_Rec_Type;

3585:
3586: I NUMBER;
3587: J NUMBER;
3588: l_set_tbl OE_Order_Pub.Line_Tbl_Type;
3589: l_control_rec OE_GLOBALS.Control_Rec_Type;
3590: l_return_status VARCHAR2(1);
3591: l_line_id NUMBER ;
3592: --
3593: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 3651: l_set_tbl(J).operation := OE_GLOBALS.G_OPR_UPDATE;

3647: oe_debug_pub.add('unshipped LINE ID : '||L_SET_TBL(J).LINE_ID,3);
3648: END IF;
3649:
3650: l_set_tbl(J).ship_set_id := NULL;
3651: l_set_tbl(J).operation := OE_GLOBALS.G_OPR_UPDATE;
3652: END IF;
3653: END LOOP; -- all unshipped lines are in l_set_tbl
3654:
3655: IF J > 0 THEN

Line 3656: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

3652: END IF;
3653: END LOOP; -- all unshipped lines are in l_set_tbl
3654:
3655: IF J > 0 THEN
3656: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
3657: l_control_rec.validate_entity := FALSE;
3658: l_control_rec.check_security := FALSE;
3659:
3660: IF l_debug_level > 0 THEN

Line 3758: oe_globals.g_call_process_req := FALSE;

3754: IF l_debug_level > 0 THEN
3755: Oe_Debug_pub.Add('----------entering handle_nonbulk_mode', 3);
3756: END IF;
3757: --9354229
3758: oe_globals.g_call_process_req := FALSE;
3759:
3760: x_return_status := FND_API.G_RET_STS_SUCCESS;
3761: IF l_debug_level > 0 THEN
3762: oe_debug_pub.ADD('request_line_rec line_id count: ' || p_requested_line_rec.line_id.COUNT, 3);

Line 4065: IF p_ship_line_rec.line_id(I) > OE_GLOBALS.G_BINARY_LIMIT THEN

4061: AND p_ship_line_rec.shipping_quantity2(I) <> 0 ) -- bug 3598987,3659454
4062: THEN
4063: --bug 3654553, 8795918
4064:
4065: IF p_ship_line_rec.line_id(I) > OE_GLOBALS.G_BINARY_LIMIT THEN
4066: l_ind := mod(p_ship_line_rec.line_id(I),OE_GLOBALS.G_BINARY_LIMIT);
4067: ELSE
4068: l_ind := p_ship_line_rec.line_id(I);
4069: END IF;

Line 4066: l_ind := mod(p_ship_line_rec.line_id(I),OE_GLOBALS.G_BINARY_LIMIT);

4062: THEN
4063: --bug 3654553, 8795918
4064:
4065: IF p_ship_line_rec.line_id(I) > OE_GLOBALS.G_BINARY_LIMIT THEN
4066: l_ind := mod(p_ship_line_rec.line_id(I),OE_GLOBALS.G_BINARY_LIMIT);
4067: ELSE
4068: l_ind := p_ship_line_rec.line_id(I);
4069: END IF;
4070: IF p_ship_line_rec.header_id(I) > OE_GLOBALS.G_BINARY_LIMIT THEN

Line 4070: IF p_ship_line_rec.header_id(I) > OE_GLOBALS.G_BINARY_LIMIT THEN

4066: l_ind := mod(p_ship_line_rec.line_id(I),OE_GLOBALS.G_BINARY_LIMIT);
4067: ELSE
4068: l_ind := p_ship_line_rec.line_id(I);
4069: END IF;
4070: IF p_ship_line_rec.header_id(I) > OE_GLOBALS.G_BINARY_LIMIT THEN
4071: l_ind_hdr := mod(p_ship_line_rec.header_id(I),OE_GLOBALS.G_BINARY_LIMIT);
4072: ELSE
4073: l_ind_hdr := p_ship_line_rec.header_id(I);
4074: END IF;

Line 4071: l_ind_hdr := mod(p_ship_line_rec.header_id(I),OE_GLOBALS.G_BINARY_LIMIT);

4067: ELSE
4068: l_ind := p_ship_line_rec.line_id(I);
4069: END IF;
4070: IF p_ship_line_rec.header_id(I) > OE_GLOBALS.G_BINARY_LIMIT THEN
4071: l_ind_hdr := mod(p_ship_line_rec.header_id(I),OE_GLOBALS.G_BINARY_LIMIT);
4072: ELSE
4073: l_ind_hdr := p_ship_line_rec.header_id(I);
4074: END IF;
4075: /* Caching lines which needs to be priced */

Line 4089: l_ship_set_id_mod := mod(p_ship_line_rec.ship_set_id(I),OE_GLOBALS.G_BINARY_LIMIT); --Bug 8795918

4085: END IF;
4086:
4087:
4088: IF p_ship_line_rec.ship_set_id(I) is NOT NULL THEN
4089: l_ship_set_id_mod := mod(p_ship_line_rec.ship_set_id(I),OE_GLOBALS.G_BINARY_LIMIT); --Bug 8795918
4090: -- IF l_set_tbl.EXISTS(p_ship_line_rec.ship_set_id(I)) -- Bug 8795918
4091: IF l_set_tbl.EXISTS(l_ship_set_id_mod)
4092: THEN
4093:

Line 4122: l_top_model_line_id_mod := mod(p_ship_line_rec.top_model_line_id(I),OE_GLOBALS.G_BINARY_LIMIT);-- Bug 8795918

4118: IF p_ship_line_rec.top_model_line_id(I) is not null AND
4119: p_ship_line_rec.top_model_line_id(I) <>
4120: nvl(p_ship_line_rec.ato_line_id(I), -1) AND
4121: p_ship_line_rec.model_remnant_flag(I) = 'N' THEN
4122: l_top_model_line_id_mod := mod(p_ship_line_rec.top_model_line_id(I),OE_GLOBALS.G_BINARY_LIMIT);-- Bug 8795918
4123: IF l_debug_level > 0 THEN
4124: Oe_Debug_pub.Add('this line is part of a pto model', 3);
4125: END IF;
4126: -- IF l_model_tbl.EXISTS(p_ship_line_rec.top_model_line_id(I)) -- Bug 8795918

Line 4211: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);

4207: LOOP
4208: Oe_Line_Adj_Util.Register_Changed_Lines
4209: ( p_line_id => l_change_line_tbl(K).line_id
4210: ,p_header_id => l_change_line_tbl(K).header_id
4211: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);
4212: K := l_change_line_tbl.NEXT(K);
4213: END LOOP;
4214: l_change_line_tbl.delete;
4215:

Line 4223: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL

4219: K := l_order_has_lines.FIRST;
4220: WHILE K is NOT NULL
4221: LOOP
4222: OE_delayed_requests_Pvt.log_request
4223: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL
4224: ,p_entity_id => l_order_has_lines(K)
4225: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL
4226: ,p_requesting_entity_id => l_order_has_lines(K)
4227: ,p_request_unique_key1 => 'SHIP'

Line 4225: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL

4221: LOOP
4222: OE_delayed_requests_Pvt.log_request
4223: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL
4224: ,p_entity_id => l_order_has_lines(K)
4225: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL
4226: ,p_requesting_entity_id => l_order_has_lines(K)
4227: ,p_request_unique_key1 => 'SHIP'
4228: ,p_param1 => l_order_has_lines(K)
4229: ,p_param2 => 'SHIP'

Line 4230: ,p_request_type => OE_GLOBALS.G_PRICE_ORDER

4226: ,p_requesting_entity_id => l_order_has_lines(K)
4227: ,p_request_unique_key1 => 'SHIP'
4228: ,p_param1 => l_order_has_lines(K)
4229: ,p_param2 => 'SHIP'
4230: ,p_request_type => OE_GLOBALS.G_PRICE_ORDER
4231: ,x_return_status => l_return_status);
4232:
4233: IF l_debug_level > 0 THEN
4234: Oe_Debug_pub.Add('Ret sts After Delayed Req'||l_return_status, 4);

Line 4271: oe_globals.g_call_process_req := TRUE;

4267: (p_set_tbl => l_set_tbl);
4268: END IF;
4269:
4270: --9354229
4271: oe_globals.g_call_process_req := TRUE;
4272:
4273: IF l_debug_level > 0 THEN
4274: oe_debug_pub.add('calling Process_Requests_And_Notify......', 1);
4275: END IF;

Line 4335: oe_globals.g_call_process_req := TRUE;

4331: IF l_debug_level > 0 THEN
4332: OE_DEBUG_PUB.Add('Unable to lock the line',3);
4333: END IF;
4334: --9354229
4335: oe_globals.g_call_process_req := TRUE;
4336: OE_Msg_Pub.Add_Text('Could not obtain Lock on Order Line/s');
4337: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4338: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4339: RAISE FND_API.G_EXC_ERROR;

Line 4347: oe_globals.g_call_process_req := TRUE;

4343: IF l_debug_level > 0 THEN
4344: Oe_Debug_pub.Add('error in handle_nonbulk_mode '|| sqlerrm, 3);
4345: END IF;
4346: --9354229
4347: oe_globals.g_call_process_req := TRUE;
4348: OE_MSG_PUB.Save_API_Messages(); --bug 4516453
4349: OE_MSG_PUB.Reset_Msg_Context (p_entity_code => 'HEADER'); -- bug 4516453
4350: RAISE;
4351: END Handle_NonBulk_Mode;

Line 4689: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);

4685: IF l_change_line_tbl(K).header_id = l_order_has_lines(J) THEN
4686: Oe_Line_Adj_Util.Register_Changed_Lines
4687: ( p_line_id => l_change_line_tbl(K).line_id
4688: ,p_header_id => l_change_line_tbl(K).header_id
4689: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);
4690: l_change_line_tbl.delete(K);
4691: END IF;
4692: K := l_change_line_tbl.NEXT(K);
4693: END LOOP;

Line 4771: ( itemtype => OE_GLOBALS.G_WFI_LIN

4767: END IF;
4768:
4769: BEGIN
4770: WF_Engine.CompleteActivityInternalName
4771: ( itemtype => OE_GLOBALS.G_WFI_LIN
4772: ,itemkey => to_char(p_ship_line_rec.line_id(i))
4773: ,activity => 'SHIP_LINE'
4774: ,result => 'SHIP_CONFIRM'
4775: ,raise_engine_exception => TRUE ); --15870313

Line 4879: (itemtype => OE_GLOBALS.G_WFI_LIN,

4875: END IF;
4876:
4877: BEGIN
4878: WF_Engine.CompleteActivityInternalName
4879: (itemtype => OE_GLOBALS.G_WFI_LIN,
4880: itemkey => to_char(g_non_shippable_rec.ato_line_id(I)),
4881: activity => 'WAIT_FOR_CTO',
4882: result => OE_GLOBALS.G_WFR_COMPLETE,
4883: raise_engine_exception => TRUE ); --15870313

Line 4882: result => OE_GLOBALS.G_WFR_COMPLETE,

4878: WF_Engine.CompleteActivityInternalName
4879: (itemtype => OE_GLOBALS.G_WFI_LIN,
4880: itemkey => to_char(g_non_shippable_rec.ato_line_id(I)),
4881: activity => 'WAIT_FOR_CTO',
4882: result => OE_GLOBALS.G_WFR_COMPLETE,
4883: raise_engine_exception => TRUE ); --15870313
4884:
4885: EXCEPTION
4886: WHEN OTHERS THEN

Line 5010: (p_request_type => OE_GLOBALS.G_TAX_LINE

5006: IF l_debug_level > 0 THEN
5007: oe_debug_pub.add('OEXPSHCB:calling Tax Delayed Request');
5008: END IF;
5009: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
5010: (p_request_type => OE_GLOBALS.G_TAX_LINE
5011: ,p_delete => FND_API.G_TRUE
5012: ,x_return_status => l_return_status
5013: );
5014: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 5456: := OE_GLOBALS.G_OPR_UPDATE; -- Bug 8442372

5452: := l_line_rec.actual_shipment_date;
5453: OE_ORDER_UTIL.g_line_tbl(J).flow_status_code
5454: := l_line_rec.flow_status_code;
5455: OE_ORDER_UTIL.g_line_tbl(J).operation
5456: := OE_GLOBALS.G_OPR_UPDATE; -- Bug 8442372
5457:
5458: IF l_debug_level > 0 THEN
5459: oe_debug_pub.add
5460: ('AFTER UPDATE GLOBAL FLOW_STATUS_CODE IS: '

Line 5559: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,

5555: p_line_rec => l_line_rec,
5556: x_result_out => l_tolerance_check
5557: );
5558:
5559: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5560: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5561: OE_GLOBALS.G_FULLY_SHIPPED,
5562: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5563: )

Line 5560: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,

5556: x_result_out => l_tolerance_check
5557: );
5558:
5559: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5560: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5561: OE_GLOBALS.G_FULLY_SHIPPED,
5562: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5563: )
5564: THEN

Line 5561: OE_GLOBALS.G_FULLY_SHIPPED,

5557: );
5558:
5559: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5560: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5561: OE_GLOBALS.G_FULLY_SHIPPED,
5562: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5563: )
5564: THEN
5565: x_result_out := 'T';

Line 5562: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)

5558:
5559: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5560: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5561: OE_GLOBALS.G_FULLY_SHIPPED,
5562: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5563: )
5564: THEN
5565: x_result_out := 'T';
5566: RAISE FND_API.G_EXC_ERROR;

Line 5586: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;

5582: l_update_lines_tbl(1).entity_id := p_line_id;
5583: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5584: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5585: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5586: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5587:
5588: --Step 4 : Call shipping integration
5589: OE_Shipping_Integration_PVT.Update_Shipping_From_OE
5590: (

Line 5603: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY

5599:
5600:
5601: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
5602: (
5603: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
5604: ,p_delete => FND_API.G_TRUE
5605: ,x_return_status => l_return_status
5606: );
5607: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)