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

Line 76: -- l_control_rec OE_GLOBALS.control_rec_type;

72: l_index NUMBER;
73: l_ordered_date DATE;
74: -- Process Order arguments
75:
76: -- l_control_rec OE_GLOBALS.control_rec_type;
77: l_line_tbl OE_ORDER_PUB.line_tbl_type;
78: l_old_line_tbl OE_ORDER_PUB.line_tbl_type;
79: /*
80: l_header_rec OE_Order_PUB.Header_Rec_Type;

Line 130: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;

126: IF l_debug_level > 0 THEN
127: oe_debug_pub.add( 'INV IFACE: ENTERING INVENTORY INTERFACE' , 1 ) ;
128: END IF;
129: x_return_status := FND_API.G_RET_STS_SUCCESS;
130: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
131:
132: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
133: profile_values.user_id := FND_GLOBAL.USER_ID;
134: profile_values.login_id := FND_GLOBAL.LOGIN_ID;

Line 147: p_wf_item => OE_GLOBALS.G_WFI_LIN,

143:
144: /* check for holds */
145: OE_HOLDS_PUB.CHECK_HOLDS(p_api_version => 1.0,
146: p_line_id => p_line_id,
147: p_wf_item => OE_GLOBALS.G_WFI_LIN,
148: p_wf_activity => 'INVENTORY_INTERFACE',
149: x_result_out => l_hold_result_out,
150: x_return_status => l_hold_return_status,
151: x_msg_count => l_hold_msg_count,

Line 162: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;

158:
159: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
160: OE_MSG_PUB.ADD;
161: x_return_status := FND_API.G_RET_STS_ERROR;
162: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
163: IF l_debug_level > 0 THEN
164: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
165: END IF;
166: RETURN;

Line 186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

182: IF l_debug_level > 0 THEN
183: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
184: END IF;
185: x_return_status := FND_API.G_RET_STS_ERROR;
186: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
190: END IF;

Line 192: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

188: IF l_debug_level > 0 THEN
189: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
190: END IF;
191: x_return_status := FND_API.G_RET_STS_ERROR;
192: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
193: END IF;
194:
195: OE_MSG_PUB.update_msg_context(
196: p_header_id => l_line_rec.header_id

Line 218: IF nvl(l_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL)

214: WHERE inventory_item_id = l_line_rec.inventory_item_id
215: AND organization_id = l_line_rec.ship_from_org_id;
216:
217: IF l_line_rec.shippable_flag = 'Y' THEN
218: IF nvl(l_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL)
219: = OE_GLOBALS.G_SOURCE_EXTERNAL OR
220: l_transactable_flag <> 'Y' THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

Line 219: = OE_GLOBALS.G_SOURCE_EXTERNAL OR

215: AND organization_id = l_line_rec.ship_from_org_id;
216:
217: IF l_line_rec.shippable_flag = 'Y' THEN
218: IF nvl(l_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL)
219: = OE_GLOBALS.G_SOURCE_EXTERNAL OR
220: l_transactable_flag <> 'Y' THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
223: IF l_debug_level > 0 THEN

Line 222: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;

218: IF nvl(l_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL)
219: = OE_GLOBALS.G_SOURCE_EXTERNAL OR
220: l_transactable_flag <> 'Y' THEN
221: x_return_status := FND_API.G_RET_STS_SUCCESS;
222: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
223: IF l_debug_level > 0 THEN
224: oe_debug_pub.add( 'INV IFACE: INV IFACE NOT ELIGIBLE - EXTERNAL OR NON TRANSACTABLE' , 5 ) ;
225: END IF;
226: RETURN;

Line 236: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

232: END IF;
233: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_NO_WAREHOUSE');
234: OE_MSG_PUB.ADD;
235: x_return_status := FND_API.G_RET_STS_ERROR;
236: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
237: RETURN;
238: END IF;
239:
240: /* get order info */

Line 297: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

293: IF l_debug_level > 0 THEN
294: oe_debug_pub.add( 'INV IFACE: COGS FAIL' , 5 ) ;
295: END IF;
296: x_return_status := FND_API.G_RET_STS_ERROR;
297: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
298: RETURN;
299: END IF;
300:
301: -- End Deferred Revenue Project

Line 317: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

313: IF l_debug_level > 0 THEN
314: oe_debug_pub.add( 'INV IFACE: REVISION/LOT SELECT FAILURE' , 5 ) ;
315: END IF;
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
318: RETURN;
319: END;
320:
321: -- After ER 8419373 we support serial numbers

Line 331: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

327: -- give a message here
328: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
329: OE_MSG_PUB.ADD;
330: x_return_status := FND_API.G_RET_STS_ERROR;
331: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
332: RETURN;
333: */
334: --Serial items with serial generation Sales Order Issue not supported
335: IF nvl(l_serial_code, 1) = 6 THEN

Line 340: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

336: -- give a message here
337: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SER_SO_ISSUE');
338: OE_MSG_PUB.ADD;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
341: RETURN;
342: END IF;
343:
344: l_serial := 'Y';

Line 446: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

442: IF l_debug_level > 0 THEN
443: oe_debug_pub.add( 'INV IFACE FAILED: ORDERED_QTY IS < RESERVED_QTY FOR OPM' , 5 ) ;
444: END IF;
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
447: ROLLBACK TO INVENTORY_INTERFACE;
448: RETURN;
449: END IF;
450: -- HW OPM BUG#:2536589 end of changes */

Line 471: IF NOT OE_GLOBALS.Equal(l_line_rec.order_quantity_uom,

467: END IF;
468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
469:
470: END;
471: IF NOT OE_GLOBALS.Equal(l_line_rec.order_quantity_uom,
472: l_primary_uom) THEN
473: l_qty_to_reserve := inv_convert.inv_um_convert(
474: item_id => l_line_rec.inventory_item_id
475: , PRECISION => 5

Line 564: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

560: -- give a message
561: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_REVISION');
562: OE_MSG_PUB.ADD;
563: x_return_status := FND_API.G_RET_STS_ERROR;
564: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
565: ROLLBACK TO INVENTORY_INTERFACE;
566: RETURN;
567: END IF;
568: END IF;

Line 580: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

576: -- give a message
577: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_LOT');
578: OE_MSG_PUB.ADD;
579: x_return_status := FND_API.G_RET_STS_ERROR;
580: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
581: ROLLBACK TO INVENTORY_INTERFACE;
582: RETURN;
583: END IF; -- INVCONV
584: END IF; -- of l_lot == 'Y'

Line 593: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

589: -- give a message
590: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SER');
591: OE_MSG_PUB.ADD;
592: x_return_status := FND_API.G_RET_STS_ERROR;
593: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
594: ROLLBACK TO INVENTORY_INTERFACE;
595: RETURN;
596: END IF; -- of l_serial = 'Y'
597:

Line 613: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

609: IF l_debug_level > 0 THEN
610: oe_debug_pub.add( 'INV IFACE: FAILED TO FETCH LOT_ID INFORMATION FOR OPM TRXN FOR TRANS_ID' || TO_CHAR ( L_RSV_TBL ( I ) .RESERVATION_ID ) , 5 ) ;
611: END IF;
612: x_return_status := FND_API.G_RET_STS_ERROR;
613: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
614: ROLLBACK TO INVENTORY_INTERFACE;
615: RETURN;
616: END IF; -- of error checking
617: END IF; -- of branching */ --INVCONV

Line 640: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add( 'INV IFACE: FAILED TO UPDATE OPM TRXNS' , 5 ) ;
638: END IF;
639: x_return_status := FND_API.G_RET_STS_ERROR;
640: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
641: ROLLBACK TO INVENTORY_INTERFACE;
642: RETURN;
643: END IF;
644:

Line 657: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

653: -- give a message
654: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_RSV_SUB');
655: OE_MSG_PUB.ADD;
656: x_return_status := FND_API.G_RET_STS_ERROR;
657: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
658: ROLLBACK TO INVENTORY_INTERFACE;
659: RETURN;
660: ELSE
661: BEGIN

Line 674: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

670: IF l_debug_level > 0 THEN
671: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE FAILURE' , 5 ) ;
672: END IF;
673: x_return_status := FND_API.G_RET_STS_ERROR;
674: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
675: ROLLBACK TO INVENTORY_INTERFACE;
676: RETURN;
677: END;
678:

Line 692: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

688: IF l_debug_level > 0 THEN
689: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE FAILURE' , 5 ) ;
690: END IF;
691: x_return_status := FND_API.G_RET_STS_ERROR;
692: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
693: ROLLBACK TO INVENTORY_INTERFACE;
694: RETURN;
695: END;
696:

Line 709: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

705: IF l_debug_level > 0 THEN
706: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
707: END IF;
708: x_return_status := FND_API.G_RET_STS_ERROR;
709: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
710: ROLLBACK TO INVENTORY_INTERFACE;
711: RETURN;
712: END;
713:

Line 735: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

731: END IF;
732: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_LOCATOR');
733: OE_MSG_PUB.ADD;
734: x_return_status := FND_API.G_RET_STS_ERROR;
735: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
736: ROLLBACK TO INVENTORY_INTERFACE;
737: RETURN;
738: END IF;
739: END IF;

Line 859: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

855: -- give a message
856: FND_MESSAGE.SET_NAME('ONT','OE_QUANTITY_MISMATCH');
857: OE_MSG_PUB.ADD;
858: x_return_status := FND_API.G_RET_STS_ERROR;
859: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
860: ROLLBACK TO INVENTORY_INTERFACE;
861: RETURN;
862: END IF;
863:

Line 1198: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

1194: -- message should say if item is under revision/lot/locator control, use the
1195: -- reservation form to reserve first
1196: OE_MSG_PUB.ADD;
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1199: ROLLBACK TO INVENTORY_INTERFACE;
1200: RETURN;
1201: END IF;
1202:

Line 1216: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

1212: IF l_debug_level > 0 THEN
1213: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE SELECT FAILURE' , 5 ) ;
1214: END IF;
1215: x_return_status := FND_API.G_RET_STS_ERROR;
1216: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1217: ROLLBACK TO INVENTORY_INTERFACE;
1218: RETURN;
1219: END;
1220:

Line 1234: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

1230: IF l_debug_level > 0 THEN
1231: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE SELECT FAILURE' , 5 ) ;
1232: END IF;
1233: x_return_status := FND_API.G_RET_STS_ERROR;
1234: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1235: ROLLBACK TO INVENTORY_INTERFACE;
1236: RETURN;
1237: END;
1238:

Line 1253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

1249: IF l_debug_level > 0 THEN
1250: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
1251: END IF;
1252: x_return_status := FND_API.G_RET_STS_ERROR;
1253: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1254: ROLLBACK TO INVENTORY_INTERFACE;
1255: RETURN;
1256: END;
1257:

Line 1292: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

1288: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_NO_RSV');
1289: OE_MSG_PUB.ADD;
1290: --END IF;
1291: x_return_status := FND_API.G_RET_STS_ERROR;
1292: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1293: ROLLBACK TO INVENTORY_INTERFACE;
1294: RETURN;
1295:
1296: END IF;

Line 1304: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;

1300: IF l_debug_level > 0 THEN
1301: oe_debug_pub.add( 'INV IFACE: NO DEFAULT TRXN EXISTS FOR NON-LOT , NON-INV OPM ITEM' , 5 ) ;
1302: END IF;
1303: x_return_status := FND_API.G_RET_STS_ERROR;
1304: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1305: ROLLBACK TO INVENTORY_INTERFACE;
1306: RETURN;
1307: END IF; */
1308:

Line 1633: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR

1629: l_line_rec.ato_line_id IS NULL) THEN
1630: IF l_debug_level > 0 THEN
1631: oe_debug_pub.add( 'INV IFACE: IT IS A PTO LINE WITHOUT EXPLOSION DATE' , 3 ) ;
1632: END IF;
1633: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1634: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1635: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add( 'INV IFACE: IT IS ITEM TYPE : '|| L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;

Line 1634: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR

1630: IF l_debug_level > 0 THEN
1631: oe_debug_pub.add( 'INV IFACE: IT IS A PTO LINE WITHOUT EXPLOSION DATE' , 3 ) ;
1632: END IF;
1633: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1634: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1635: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add( 'INV IFACE: IT IS ITEM TYPE : '|| L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;
1638: END IF;

Line 1635: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN

1631: oe_debug_pub.add( 'INV IFACE: IT IS A PTO LINE WITHOUT EXPLOSION DATE' , 3 ) ;
1632: END IF;
1633: IF l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_MODEL OR
1634: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_CLASS OR
1635: l_line_rec.item_type_code = OE_GLOBALS.G_ITEM_KIT THEN
1636: IF l_debug_level > 0 THEN
1637: oe_debug_pub.add( 'INV IFACE: IT IS ITEM TYPE : '|| L_LINE_REC.ITEM_TYPE_CODE , 3 ) ;
1638: END IF;
1639: -- Do the explosion