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 119: l_control_rec OE_GLOBALS.Control_Rec_Type;

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

Line 163: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN

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

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

160: oe_debug_pub.add( 'ENTERING OE_SHIP_CONFIRM.SHIP_CONFIRM' , 1 ) ;
161: END IF;
162:
163: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
164: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
165: END IF;
166:
167: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
168: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);

Line 167: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN

163: IF OE_GLOBALS.G_ASO_INSTALLED IS NULL THEN
164: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
165: END IF;
166:
167: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
168: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
169: END IF;
170:
171: IF l_debug_level > 0 THEN

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

164: OE_GLOBALS.G_ASO_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(697);
165: END IF;
166:
167: IF OE_GLOBALS.G_EC_INSTALLED IS NULL THEN
168: OE_GLOBALS.G_EC_INSTALLED := OE_GLOBALS.CHECK_PRODUCT_INSTALLED(175);
169: END IF;
170:
171: IF l_debug_level > 0 THEN
172: oe_debug_pub.add( 'NUMBER OF RECORDS LINE/ADJ/REQ : '||P_LINE_TBL.COUNT||'/'||P_LINE_ADJ_TBL.COUNT||'/'||P_REQ_QTY_TBL.COUNT , 3 ) ;

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

327: l_split_line_tbl(1).ordered_quantity := l_temp_requested_quantity;
328: -- HW added qty2 for OPM
329: -- l_split_line_tbl(1).ordered_quantity2 := nvl(p_req_qty_tbl(J).requested_quantity2,0); -- INVCONV
330: l_split_line_tbl(1).ordered_quantity2 := nvl(l_temp_requested_quantity2, 0); -- INVCONV
331: l_split_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
332: l_split_line_tbl(1).split_action_code := 'SPLIT';
333: l_split_line_tbl(1).split_by := 'SYSTEM';
334: l_split_line_tbl(1).change_reason := 'SYSTEM';
335:

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

355: l_split_line_tbl(2).ordered_quantity2 := nvl(l_ordered_quantity2,0)
356: -- nvl(p_req_qty_tbl(J).requested_quantity2,0); INVCONV
357: - nvl(l_temp_requested_quantity2, 0);
358:
359: l_split_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
360: l_split_line_tbl(2).split_by := 'SYSTEM';
361: l_split_line_tbl(2).change_reason := 'SYSTEM';
362:
363: IF l_debug_level > 0 THEN

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

390:
391: l_control_rec.validate_entity := FALSE;
392: l_control_rec.check_security := FALSE;
393:
394: IF OE_GLOBALS.G_RECURSION_MODE = 'Y' THEN
395:
396: l_set_recursion := 'N';
397:
398: ELSE

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

573: l_over_ship_reason_code_upd := p_line_tbl(J).over_ship_reason_code;
574:
575: END IF;
576:
577: IF NOT OE_GLOBALS.Equal(p_line_tbl(J).shipping_quantity,l_shipping_quantity) THEN
578: -- Convert the shipping quantity from shipping quantity UOM to
579: -- Ordered quantity UOM and update the field shipped quantity
580: -- Call API to convert the shipping quantity to shipped quantity
581: -- from shipping quantity UOM to ordered quantity UOM and assign

Line 912: l_item_type_code = Oe_Globals.G_ITEM_CONFIG AND

908: END IF;
909:
910: ELSIF (l_ato_line_id IS NOT NULL AND
911: l_ato_line_id <> FND_API.G_MISS_NUM) AND
912: l_item_type_code = Oe_Globals.G_ITEM_CONFIG AND
913: l_ato_line_id = l_top_model_line_id THEN
914:
915: IF l_debug_level > 0 THEN
916: oe_debug_pub.add( 'ATO SHIPPED : '||P_LINE_TBL ( J ) .LINE_ID , 3 ) ;

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

975: END IF;
976:
977: END IF;
978:
979: END IF; -- IF NOT OE_GLOBALS.Equal
980:
981:
982: /* jolin start */
983: /* Moved call to query record out NOCOPY of IF ordered=shipped below so that

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

1000: IF l_debug_level > 0 THEN
1001: oe_debug_pub.add( 'UPDATING LINE : '||P_LINE_TBL ( J ) .LINE_ID , 3 ) ;
1002: END IF;
1003:
1004: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1005: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1006: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
1007: THEN
1008: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */

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

1001: oe_debug_pub.add( 'UPDATING LINE : '||P_LINE_TBL ( J ) .LINE_ID , 3 ) ;
1002: END IF;
1003:
1004: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1005: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1006: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y') )
1007: THEN
1008: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */
1009: IF l_debug_level > 0 THEN

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

1035: WHERE line_id = p_line_tbl(J).line_id;
1036:
1037: ELSE /* ordered does not equal shipped qty */
1038:
1039: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1040: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1041: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y'))
1042: THEN
1043: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */

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

1036:
1037: ELSE /* ordered does not equal shipped qty */
1038:
1039: IF ((OE_GLOBALS.G_ASO_INSTALLED = 'Y') OR
1040: (OE_GLOBALS.G_EC_INSTALLED = 'Y') OR
1041: (NVL(FND_PROFILE.VALUE('ONT_DBI_INSTALLED'),'N') = 'Y'))
1042: THEN
1043: /* l_line_tbl(J) already holds the old info, so just overwrite what changed */
1044: IF l_debug_level > 0 THEN

Line 1065: IF l_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED THEN

1061: , p_shipped_quantity => l_Shipped_Quantity
1062: , x_result_out => l_result_out
1063: );
1064:
1065: IF l_result_out = OE_GLOBALS.G_PARTIALLY_SHIPPED THEN
1066: -- This line will split, set the calculate_price_flag to 'P' if 'Y'
1067: IF l_debug_level > 0 THEN
1068: oe_debug_pub.add( 'CALCULATE PRICE FLAG : '||L_CALCULATE_PRICE_FLAG , 3 ) ;
1069: END IF;

Line 1101: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1097: AND p_line_tbl(J).shipping_quantity2 <> 0 ) -- bug 3598987,3659454
1098: THEN
1099: oe_debug_pub.add( 'Before logging Delayed request for pricing',3);
1100: OE_delayed_requests_Pvt.log_request(
1101: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1102: p_entity_id => p_line_tbl(J).line_id,
1103: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1104: p_requesting_entity_id => p_line_tbl(J).line_id,
1105: p_request_unique_key1 => 'SHIP',

Line 1103: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,

1099: oe_debug_pub.add( 'Before logging Delayed request for pricing',3);
1100: OE_delayed_requests_Pvt.log_request(
1101: p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1102: p_entity_id => p_line_tbl(J).line_id,
1103: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL,
1104: p_requesting_entity_id => p_line_tbl(J).line_id,
1105: p_request_unique_key1 => 'SHIP',
1106: p_param1 => l_header_id,
1107: p_param2 => 'SHIP',

Line 1108: p_request_type => OE_GLOBALS.G_PRICE_LINE,

1104: p_requesting_entity_id => p_line_tbl(J).line_id,
1105: p_request_unique_key1 => 'SHIP',
1106: p_param1 => l_header_id,
1107: p_param2 => 'SHIP',
1108: p_request_type => OE_GLOBALS.G_PRICE_LINE,
1109: x_return_status => l_return_status);
1110:
1111: END IF;
1112:

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

1347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1348: --
1349: BEGIN
1350:
1351: IF (OE_GLOBALS.G_RECURSION_MODE = 'N'
1352: AND OE_DELAYED_REQUESTS_PVT.Requests_Count > 0 )
1353: THEN
1354:
1355: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity

Line 1356: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ

1352: AND OE_DELAYED_REQUESTS_PVT.Requests_Count > 0 )
1353: THEN
1354:
1355: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1356: (p_entity_code => OE_GLOBALS.G_ENTITY_HEADER_ADJ
1357: ,p_delete => FND_API.G_TRUE
1358: ,x_return_status => l_return_status
1359: );
1360: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1367: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att

1363: RAISE FND_API.G_EXC_ERROR;
1364: END IF;
1365:
1366: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1367: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Price_Att
1368: ,p_delete => FND_API.G_TRUE
1369: ,x_return_status => l_return_status
1370: );
1371: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1378: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att

1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1378: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Att
1379: ,p_delete => FND_API.G_TRUE
1380: ,x_return_status => l_return_status
1381: );
1382: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1389: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc

1385: RAISE FND_API.G_EXC_ERROR;
1386: END IF;
1387:
1388: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1389: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Adj_Assoc
1390: ,p_delete => FND_API.G_TRUE
1391: ,x_return_status => l_return_status
1392: );
1393: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1400: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit

1396: RAISE FND_API.G_EXC_ERROR;
1397: END IF;
1398:
1399: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
1400: (p_entity_code => OE_GLOBALS.G_ENTITY_Header_Scredit
1401: ,p_delete => FND_API.G_TRUE
1402: ,x_return_status => l_return_status
1403: );
1404: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

Line 1411: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE

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

Line 1422: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE_ADJ

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

Line 1433: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Scredit

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

Line 1444: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Price_Att

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

Line 1455: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Att

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

Line 1466: (p_entity_code => OE_GLOBALS.G_ENTITY_Line_Adj_Assoc

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

Line 1653: l_control_rec OE_GLOBALS.Control_Rec_Type;

1649: ( p_requested_line_rec IN OUT NOCOPY Ship_Line_Rec_Type)
1650: IS
1651: --J NUMBER := 0; bug 4422886
1652: l_split_line_rec OE_Order_Pub.Line_Rec_Type;
1653: l_control_rec OE_GLOBALS.Control_Rec_Type;
1654: l_return_status VARCHAR2(1);
1655: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1656: l_split_line_tbl OE_Order_Pub.Line_Tbl_Type;
1657: l_wdd_count NUMBER;

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

1740: -- := nvl(p_requested_line_rec.requested_quantity2(I),0); --?? INVCONV
1741: := p_requested_line_rec.shipped_quantity2(I); -- INVCONV
1742:
1743:
1744: l_split_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
1745: l_split_line_rec.split_action_code := 'SPLIT';
1746: l_split_line_rec.split_by := 'SYSTEM';
1747: l_split_line_rec.change_reason := 'SYSTEM';
1748:

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

1766: l_split_line_rec.split_from_line_id := l_split_line_tbl(1).line_id;
1767:
1768: l_split_line_rec.split_by := 'SYSTEM';
1769: l_split_line_rec.change_reason := 'SYSTEM';
1770: l_split_line_rec.operation := OE_GLOBALS.G_OPR_CREATE;
1771:
1772: -- J := J+1; bug 4422886
1773:
1774: l_split_line_tbl(2) := l_split_line_rec;

Line 1840: l_control_rec OE_GLOBALS.Control_Rec_Type;

1836: ,p_index IN NUMBER
1837: ,p_split_model IN VARCHAR2 := 'N')
1838: IS
1839: l_line_tbl OE_Order_Pub.Line_Tbl_Type;
1840: l_control_rec OE_GLOBALS.Control_Rec_Type;
1841: l_return_status VARCHAR2(1);
1842: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1843: l_return NUMBER; --Bug 7528326
1844: BEGIN

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

1852: IF l_debug_level > 0 THEN
1853: oe_debug_pub.add('pal local split line 1 ', 3);
1854: END IF;
1855:
1856: l_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;
1857: l_line_tbl(1).split_by := 'SYSTEM';
1858: l_line_tbl(1).change_reason := 'SYSTEM';
1859: l_line_tbl(1).split_action_code := 'SPLIT';
1860: l_line_tbl(1).ordered_quantity :=

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

1862:
1863: IF l_debug_level > 0 THEN
1864: oe_debug_pub.add('pal local split line 2 ', 3);
1865: END IF;
1866: l_line_tbl(2).operation := OE_GLOBALS.G_OPR_CREATE;
1867: l_line_tbl(2).split_by := 'SYSTEM';
1868: l_line_tbl(2).change_reason := 'SYSTEM';
1869: l_line_tbl(2).ordered_quantity :=
1870: p_ship_line_rec.ordered_quantity(p_index) -

Line 2149: (p_item_type => OE_GLOBALS.G_WFI_LIN

2145: oe_debug_pub.add('CALLING GET ACTIVITY RESULT FOR : '|| line_rec.line_id, 3);
2146: END IF;
2147:
2148: OE_LINE_FULLFILL.Get_Activity_Result
2149: (p_item_type => OE_GLOBALS.G_WFI_LIN
2150: ,p_item_key => to_char(line_rec.line_id)
2151: ,p_activity_name => 'FULFILL_LINE'
2152: ,x_return_status => l_return_status
2153: ,x_activity_result => l_activity_result

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

2211: l_fulfill_tbl(l_fulfill_index).blanket_version_number
2212: := line_rec.blanket_version_number;
2213: --BSA changes
2214:
2215: l_fulfill_tbl(l_fulfill_index).operation := OE_GLOBALS.G_OPR_UPDATE;
2216:
2217: IF l_debug_level > 0 THEN
2218: oe_debug_pub.add('FULFILLED QUANTITY : '
2219: || L_FULFILL_TBL(L_FULFILL_INDEX).FULFILLED_QUANTITY,3);

Line 2265: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2261: RAISE FND_API.G_EXC_ERROR;
2262: END IF;
2263:
2264: OE_Delayed_Requests_Pvt.Log_Request
2265: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2266: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2267: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2268: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2269: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 2267: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

2263:
2264: OE_Delayed_Requests_Pvt.Log_Request
2265: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2266: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2267: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2268: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2269: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2270: p_param1 => OE_GLOBALS.G_WFI_LIN,
2271: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??

Line 2269: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

2265: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2266: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2267: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2268: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2269: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2270: p_param1 => OE_GLOBALS.G_WFI_LIN,
2271: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??
2272: p_param3 => 'FULFILL_LINE',
2273: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

Line 2270: p_param1 => OE_GLOBALS.G_WFI_LIN,

2266: p_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2267: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2268: p_requesting_entity_id => l_fulfill_tbl(l_fulfill_index).line_id,
2269: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2270: p_param1 => OE_GLOBALS.G_WFI_LIN,
2271: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??
2272: p_param3 => 'FULFILL_LINE',
2273: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2274: x_return_status => l_return_status);

Line 2273: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

2269: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2270: p_param1 => OE_GLOBALS.G_WFI_LIN,
2271: p_param2 => to_char(l_fulfill_tbl(l_fulfill_index).line_id),--??
2272: p_param3 => 'FULFILL_LINE',
2273: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2274: x_return_status => l_return_status);
2275:
2276: OE_LINE_FULLFILL.Fulfill_Service_Lines
2277: (p_line_id => l_fulfill_tbl(l_fulfill_index).line_id,

Line 2364: ( p_item_type => OE_GLOBALS.G_WFI_LIN

2360: IF l_debug_level > 0 THEN
2361: oe_debug_pub.add( 'GET ACTIVITY RESULT : '|| p_ship_line_rec.ato_line_id(p_index) , 3 ) ;
2362: END IF;
2363: OE_LINE_FULLFILL.Get_Activity_Result
2364: ( p_item_type => OE_GLOBALS.G_WFI_LIN
2365: , p_item_key => p_ship_line_rec.ato_line_id(p_index)
2366: , p_activity_name => 'WAIT_FOR_CTO'
2367: , x_return_status => l_return_status
2368: , x_activity_result => l_activity_result

Line 2392: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2388:
2389: OE_DEBUG_PUB.Add('Log delayed request for Complete CTO-Bug-3471040');
2390:
2391: OE_Delayed_Requests_Pvt.Log_Request
2392: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2393: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2395: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2396: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

2390:
2391: OE_Delayed_Requests_Pvt.Log_Request
2392: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2393: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2395: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2396: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2397: p_param1 => OE_GLOBALS.G_WFI_LIN,
2398: p_param2 => p_ship_line_rec.ato_line_id(p_index),

Line 2396: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

2392: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2393: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2395: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2396: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2397: p_param1 => OE_GLOBALS.G_WFI_LIN,
2398: p_param2 => p_ship_line_rec.ato_line_id(p_index),
2399: p_param3 => 'WAIT_FOR_CTO',
2400: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

Line 2397: p_param1 => OE_GLOBALS.G_WFI_LIN,

2393: p_entity_id => p_ship_line_rec.ato_line_id(p_index),
2394: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2395: p_requesting_entity_id => p_ship_line_rec.ato_line_id(p_index),
2396: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2397: p_param1 => OE_GLOBALS.G_WFI_LIN,
2398: p_param2 => p_ship_line_rec.ato_line_id(p_index),
2399: p_param3 => 'WAIT_FOR_CTO',
2400: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2401: x_return_status => l_return_status);

Line 2400: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,

2396: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2397: p_param1 => OE_GLOBALS.G_WFI_LIN,
2398: p_param2 => p_ship_line_rec.ato_line_id(p_index),
2399: p_param3 => 'WAIT_FOR_CTO',
2400: p_param4 => OE_GLOBALS.G_WFR_COMPLETE,
2401: x_return_status => l_return_status);
2402:
2403: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2501: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,

2497: oe_debug_pub.add('loggin request to wf complete', 5);
2498: END IF;
2499:
2500: OE_Delayed_Requests_Pvt.Log_Request
2501: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2502: p_entity_id => p_ship_line_rec.line_id(p_index),
2503: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2504: p_requesting_entity_id => p_ship_line_rec.line_id(p_index),
2505: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

Line 2503: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,

2499:
2500: OE_Delayed_Requests_Pvt.Log_Request
2501: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2502: p_entity_id => p_ship_line_rec.line_id(p_index),
2503: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2504: p_requesting_entity_id => p_ship_line_rec.line_id(p_index),
2505: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2506: p_param1 => OE_GLOBALS.G_WFI_LIN,
2507: p_param2 => p_ship_line_rec.line_id(p_index),

Line 2505: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,

2501: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL,
2502: p_entity_id => p_ship_line_rec.line_id(p_index),
2503: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2504: p_requesting_entity_id => p_ship_line_rec.line_id(p_index),
2505: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2506: p_param1 => OE_GLOBALS.G_WFI_LIN,
2507: p_param2 => p_ship_line_rec.line_id(p_index),
2508: p_param3 => 'SHIP_LINE',
2509: p_param4 => 'SHIP_CONFIRM',

Line 2506: p_param1 => OE_GLOBALS.G_WFI_LIN,

2502: p_entity_id => p_ship_line_rec.line_id(p_index),
2503: p_requesting_entity_code => OE_GLOBALS.G_ENTITY_LINE,
2504: p_requesting_entity_id => p_ship_line_rec.line_id(p_index),
2505: p_request_type => OE_GLOBALS.G_COMPLETE_ACTIVITY,
2506: p_param1 => OE_GLOBALS.G_WFI_LIN,
2507: p_param2 => p_ship_line_rec.line_id(p_index),
2508: p_param3 => 'SHIP_LINE',
2509: p_param4 => 'SHIP_CONFIRM',
2510: x_return_status => l_return_status);

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

2926: IF l_debug_level > 0 THEN
2927: oe_debug_pub.add('zz2', 1);
2928: END IF;
2929:
2930: l_split_line_tbl(l_count).operation := OE_GLOBALS.G_OPR_UPDATE;
2931:
2932: l_split_line_tbl(l_count).split_by := 'SYSTEM';
2933: l_split_line_tbl(l_count).change_reason := 'SYSTEM';
2934: l_split_line_tbl(l_count).split_action_code := 'SPLIT';

Line 3408: l_control_rec OE_GLOBALS.Control_Rec_Type;

3404:
3405: I NUMBER;
3406: J NUMBER;
3407: l_set_tbl OE_Order_Pub.Line_Tbl_Type;
3408: l_control_rec OE_GLOBALS.Control_Rec_Type;
3409: l_return_status VARCHAR2(1);
3410: l_line_id NUMBER ;
3411: --
3412: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

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

3465: oe_debug_pub.add('unshipped LINE ID : '||L_SET_TBL(J).LINE_ID,3);
3466: END IF;
3467:
3468: l_set_tbl(J).ship_set_id := NULL;
3469: l_set_tbl(J).operation := OE_GLOBALS.G_OPR_UPDATE;
3470: END IF;
3471: END LOOP; -- all unshipped lines are in l_set_tbl
3472:
3473: IF J > 0 THEN

Line 3474: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;

3470: END IF;
3471: END LOOP; -- all unshipped lines are in l_set_tbl
3472:
3473: IF J > 0 THEN
3474: l_control_rec := OE_GLOBALS.G_MISS_CONTROL_REC;
3475: l_control_rec.validate_entity := FALSE;
3476: l_control_rec.check_security := FALSE;
3477:
3478: IF l_debug_level > 0 THEN

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

3970: LOOP
3971: Oe_Line_Adj_Util.Register_Changed_Lines
3972: ( p_line_id => l_change_line_tbl(K).line_id
3973: ,p_header_id => l_change_line_tbl(K).header_id
3974: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);
3975: K := l_change_line_tbl.NEXT(K);
3976: END LOOP;
3977: l_change_line_tbl.delete;
3978:

Line 3986: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL

3982: K := l_order_has_lines.FIRST;
3983: WHILE K is NOT NULL
3984: LOOP
3985: OE_delayed_requests_Pvt.log_request
3986: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3987: ,p_entity_id => l_order_has_lines(K)
3988: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL
3989: ,p_requesting_entity_id => l_order_has_lines(K)
3990: ,p_request_unique_key1 => 'SHIP'

Line 3988: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL

3984: LOOP
3985: OE_delayed_requests_Pvt.log_request
3986: ( p_entity_code => OE_GLOBALS.G_ENTITY_ALL
3987: ,p_entity_id => l_order_has_lines(K)
3988: ,p_requesting_entity_code => OE_GLOBALS.G_ENTITY_ALL
3989: ,p_requesting_entity_id => l_order_has_lines(K)
3990: ,p_request_unique_key1 => 'SHIP'
3991: ,p_param1 => l_order_has_lines(K)
3992: ,p_param2 => 'SHIP'

Line 3993: ,p_request_type => OE_GLOBALS.G_PRICE_ORDER

3989: ,p_requesting_entity_id => l_order_has_lines(K)
3990: ,p_request_unique_key1 => 'SHIP'
3991: ,p_param1 => l_order_has_lines(K)
3992: ,p_param2 => 'SHIP'
3993: ,p_request_type => OE_GLOBALS.G_PRICE_ORDER
3994: ,x_return_status => l_return_status);
3995:
3996: IF l_debug_level > 0 THEN
3997: Oe_Debug_pub.Add('Ret sts After Delayed Req'||l_return_status, 4);

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

4387: IF l_change_line_tbl(K).header_id = l_order_has_lines(J) THEN
4388: Oe_Line_Adj_Util.Register_Changed_Lines
4389: ( p_line_id => l_change_line_tbl(K).line_id
4390: ,p_header_id => l_change_line_tbl(K).header_id
4391: ,p_operation => OE_GLOBALS.G_OPR_UPDATE);
4392: l_change_line_tbl.delete(K);
4393: END IF;
4394: K := l_change_line_tbl.NEXT(K);
4395: END LOOP;

Line 4435: ( itemtype => OE_GLOBALS.G_WFI_LIN

4431: END IF;
4432:
4433: BEGIN
4434: WF_Engine.CompleteActivityInternalName
4435: ( itemtype => OE_GLOBALS.G_WFI_LIN
4436: ,itemkey => to_char(p_ship_line_rec.line_id(i))
4437: ,activity => 'SHIP_LINE'
4438: ,result => 'SHIP_CONFIRM');
4439:

Line 4541: (itemtype => OE_GLOBALS.G_WFI_LIN,

4537: || g_non_shippable_rec.ato_line_id(I), 1);
4538: END IF;
4539:
4540: WF_Engine.CompleteActivityInternalName
4541: (itemtype => OE_GLOBALS.G_WFI_LIN,
4542: itemkey => to_char(g_non_shippable_rec.ato_line_id(I)),
4543: activity => 'WAIT_FOR_CTO',
4544: result => OE_GLOBALS.G_WFR_COMPLETE);
4545:

Line 4544: result => OE_GLOBALS.G_WFR_COMPLETE);

4540: WF_Engine.CompleteActivityInternalName
4541: (itemtype => OE_GLOBALS.G_WFI_LIN,
4542: itemkey => to_char(g_non_shippable_rec.ato_line_id(I)),
4543: activity => 'WAIT_FOR_CTO',
4544: result => OE_GLOBALS.G_WFR_COMPLETE);
4545:
4546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

5175: p_line_rec => l_line_rec,
5176: x_result_out => l_tolerance_check
5177: );
5178:
5179: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5180: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5181: OE_GLOBALS.G_FULLY_SHIPPED,
5182: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5183: )

Line 5180: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,

5176: x_result_out => l_tolerance_check
5177: );
5178:
5179: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5180: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5181: OE_GLOBALS.G_FULLY_SHIPPED,
5182: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5183: )
5184: THEN

Line 5181: OE_GLOBALS.G_FULLY_SHIPPED,

5177: );
5178:
5179: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5180: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5181: OE_GLOBALS.G_FULLY_SHIPPED,
5182: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5183: )
5184: THEN
5185: x_result_out := 'T';

Line 5182: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)

5178:
5179: IF ( l_tolerance_check NOT IN ( OE_GLOBALS.G_SHIPPED_WITHIN_TOL_BELOW,
5180: OE_GLOBALS.G_SHIPPED_WITHIN_TOL_ABOVE,
5181: OE_GLOBALS.G_FULLY_SHIPPED,
5182: OE_GLOBALS.G_SHIPPED_BEYOND_TOLERANCE)
5183: )
5184: THEN
5185: x_result_out := 'T';
5186: RAISE FND_API.G_EXC_ERROR;

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

5202: l_update_lines_tbl(1).entity_id := p_line_id;
5203: l_update_lines_tbl(1).param1 := FND_API.G_FALSE;
5204: l_update_lines_tbl(1).param2 := FND_API.G_FALSE;
5205: l_update_lines_tbl(1).param5 := FND_API.G_TRUE;
5206: l_update_lines_tbl(1).request_type := OE_GLOBALS.G_OPR_UPDATE;
5207:
5208: --Step 4 : Call shipping integration
5209: OE_Shipping_Integration_PVT.Update_Shipping_From_OE
5210: (

Line 5223: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY

5219:
5220:
5221: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Reqtype
5222: (
5223: p_request_type =>OE_GLOBALS.G_COMPLETE_ACTIVITY
5224: ,p_delete => FND_API.G_TRUE
5225: ,x_return_status => l_return_status
5226: );
5227: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS)