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 FND_API

Line 129: x_return_status := FND_API.G_RET_STS_SUCCESS;

125:
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;

Line 154: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND

150: x_return_status => l_hold_return_status,
151: x_msg_count => l_hold_msg_count,
152: x_msg_data => l_hold_msg_data);
153:
154: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
155: l_hold_result_out = FND_API.G_TRUE ) THEN
156: /* we are reusing the OE_INVOICING_HOLD message here,
157: the message is generic, not invoicing specific */
158:

Line 155: l_hold_result_out = FND_API.G_TRUE ) THEN

151: x_msg_count => l_hold_msg_count,
152: x_msg_data => l_hold_msg_data);
153:
154: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
155: l_hold_result_out = FND_API.G_TRUE ) THEN
156: /* we are reusing the OE_INVOICING_HOLD message here,
157: the message is generic, not invoicing specific */
158:
159: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');

Line 161: x_return_status := FND_API.G_RET_STS_ERROR;

157: the message is generic, not invoicing specific */
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;

Line 167: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN

163: IF l_debug_level > 0 THEN
164: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
165: END IF;
166: RETURN;
167: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INV IFACE: CHECK HOLD API ERROR' , 5 ) ;
171: END IF;

Line 168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

164: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
165: END IF;
166: RETURN;
167: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INV IFACE: CHECK HOLD API ERROR' , 5 ) ;
171: END IF;
172: RETURN;

Line 181: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

177: OE_Line_Util.Lock_Row(p_line_id=>p_line_id
178: , p_x_line_rec => l_line_rec
179: , x_return_status => l_return_status
180: );
181: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 185: x_return_status := FND_API.G_RET_STS_ERROR;

181: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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 ) ;

Line 187: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR 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;
191: x_return_status := FND_API.G_RET_STS_ERROR;

Line 191: x_return_status := FND_API.G_RET_STS_ERROR;

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;
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(

Line 221: x_return_status := FND_API.G_RET_STS_SUCCESS;

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
224: oe_debug_pub.add( 'INV IFACE: INV IFACE NOT ELIGIBLE - EXTERNAL OR NON TRANSACTABLE' , 5 ) ;
225: END IF;

Line 235: x_return_status := FND_API.G_RET_STS_ERROR;

231: oe_debug_pub.add( 'INV IFACE: INV IFACE INCOMPLETE - NO WAREHOUSE' , 5 ) ;
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:

Line 287: x_msg_data => l_msg_data) <> FND_API.G_RET_STS_SUCCESS

283: x_concat_segs => l_concat_segs,
284: x_concat_ids => l_concat_ids,
285: x_concat_descrs => l_concat_descrs,
286: x_msg_count => l_msg_count,
287: x_msg_data => l_msg_data) <> FND_API.G_RET_STS_SUCCESS
288: THEN
289: -- if COGS workflow fails for some reason,
290: -- we will return INCOMPLETE
291:

Line 296: x_return_status := FND_API.G_RET_STS_ERROR;

292: l_trans_acc := NULL;
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:

Line 316: x_return_status := FND_API.G_RET_STS_ERROR;

312: WHEN OTHERS THEN
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:

Line 330: x_return_status := FND_API.G_RET_STS_ERROR;

326: /* ER 8419373
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

Line 339: x_return_status := FND_API.G_RET_STS_ERROR;

335: IF nvl(l_serial_code, 1) = 6 THEN
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:

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

441: l_line_rec.reserved_quantity > l_line_rec.ordered_quantity ) THEN
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;

Line 468: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

464: WHEN OTHERS THEN
465: IF l_debug_level > 0 THEN
466: OE_DEBUG_PUB.Add('Error in selecting Primary UOM code',1);
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

Line 507: , p_init_msg_lst => FND_API.G_TRUE

503: END IF;
504: /*ER 8419373
505: inv_reservation_pub.query_reservation
506: ( p_api_version_number => 1.0
507: , p_init_msg_lst => FND_API.G_TRUE
508: , x_return_status => l_return_status
509: , x_msg_count => l_msg_count
510: , x_msg_data => l_msg_data
511: , p_query_input => l_rsv_rec

Line 521: , p_init_msg_lst => FND_API.G_TRUE

517: );*/
518: --ER 8419373, call the overloaded INV API which provides serial number information
519: inv_reservation_pvt.query_reservation (
520: p_api_version_number => 1.0
521: , p_init_msg_lst => FND_API.G_TRUE
522: , x_return_status => l_return_status
523: , x_msg_count => l_msg_count
524: , x_msg_data => l_msg_data
525: , p_query_input => l_rsv_rec

Line 544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

540: oe_debug_pub.add( 'SERIAL TABLE COUNT: ' || l_serial_number_tbl.COUNT , 1 ) ;
541: oe_debug_pub.add( 'SERIAL COUNT: ' || l_serial_tbl_count , 1 ) ;
542: END IF;
543:
544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
545: l_return_status = FND_API.G_RET_STS_ERROR THEN
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
548: END IF;

Line 545: l_return_status = FND_API.G_RET_STS_ERROR THEN

541: oe_debug_pub.add( 'SERIAL COUNT: ' || l_serial_tbl_count , 1 ) ;
542: END IF;
543:
544: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
545: l_return_status = FND_API.G_RET_STS_ERROR THEN
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
548: END IF;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

545: l_return_status = FND_API.G_RET_STS_ERROR THEN
546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
548: END IF;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: RETURN;
552: END IF;
553:

Line 550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

546: IF l_debug_level > 0 THEN
547: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
548: END IF;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
551: RETURN;
552: END IF;
553:
554: -- LOOP to insert reservation record to interface table

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

559: IF l_rsv_tbl(I).revision is null THEN
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;

Line 579: x_return_status := FND_API.G_RET_STS_ERROR;

575: -- AND l_process_org = 0 ) THEN -- For discrete INVCONV
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

Line 592: x_return_status := FND_API.G_RET_STS_ERROR;

588: IF l_serial = 'Y' and l_serial_tbl_count = 0 THEN
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'

Line 608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

604: ,opm_msg_count
605: ,opm_msg_data);
606:
607: -- This error is reported if lot_id is not found
608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 612: x_return_status := FND_API.G_RET_STS_ERROR;

608: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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

Line 635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

631: ,l_return_status
632: ,opm_msg_count
633: ,opm_msg_data);
634:
635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 639: x_return_status := FND_API.G_RET_STS_ERROR;

635: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
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;

Line 656: x_return_status := FND_API.G_RET_STS_ERROR;

652: IF l_rsv_tbl(I).subinventory_code is null THEN
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

Line 673: x_return_status := FND_API.G_RET_STS_ERROR;

669: WHEN OTHERS THEN
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;

Line 691: x_return_status := FND_API.G_RET_STS_ERROR;

687: WHEN OTHERS THEN
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;

Line 708: x_return_status := FND_API.G_RET_STS_ERROR;

704: WHEN OTHERS THEN
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;

Line 734: x_return_status := FND_API.G_RET_STS_ERROR;

730: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOCATOR CONTROL' , 5 ) ;
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;

Line 858: x_return_status := FND_API.G_RET_STS_ERROR;

854: IF l_rsv_tbl(I).reservation_quantity <> l_rsv_serial_count THEN
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;

Line 1188: l_line_rec.subinventory = FND_API.G_MISS_CHAR ) THEN

1184:
1185: IF (l_process_org = 0 )THEN */
1186:
1187: IF ( l_line_rec.subinventory is null or
1188: l_line_rec.subinventory = FND_API.G_MISS_CHAR ) THEN
1189: IF l_debug_level > 0 THEN
1190: oe_debug_pub.add( 'INV IFACE: SUBINV IS NULL OR MISS_CHAR FOR INSERT - 2' , 5 ) ;
1191: END IF;
1192: -- Give a message here

Line 1197: x_return_status := FND_API.G_RET_STS_ERROR;

1193: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SUB');
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;

Line 1215: x_return_status := FND_API.G_RET_STS_ERROR;

1211: WHEN OTHERS THEN
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;

Line 1233: x_return_status := FND_API.G_RET_STS_ERROR;

1229: WHEN OTHERS THEN
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;

Line 1252: x_return_status := FND_API.G_RET_STS_ERROR;

1248: WHEN OTHERS THEN
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;

Line 1291: x_return_status := FND_API.G_RET_STS_ERROR;

1287: -- Give a message here
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:

Line 1303: x_return_status := FND_API.G_RET_STS_ERROR;

1299: IF ( l_process_org = 1 AND l_lot = 'N' ) THEN
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; */

Line 1616: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

1612: /* update flow_status_code */
1613: OE_ORDER_WF_UTIL.Update_Flow_Status_Code(p_line_id => p_line_id
1614: , p_flow_status_code => 'INVENTORY_INTERFACED'
1615: , x_return_status => l_return_status);
1616: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1617: IF l_debug_level > 0 THEN
1618: oe_debug_pub.add( 'INV IFACE: UPDATE FLOW STATUS CODE FAILED' , 5 ) ;
1619: END IF;
1620: END IF;

Line 1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1643: ,p_process_requests => TRUE);
1644: IF l_debug_level > 0 THEN
1645: oe_debug_pub.add( 'INV IFACE: AFTER CALLING EXPLOSION : '|| L_RETURN_STATUS , 3 ) ;
1646: END IF;
1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: IF l_debug_level > 0 THEN
1649: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1650: END IF;
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1647: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1648: IF l_debug_level > 0 THEN
1649: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1650: END IF;
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1653: IF l_debug_level > 0 THEN
1654: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1655: END IF;

Line 1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1648: IF l_debug_level > 0 THEN
1649: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1650: END IF;
1651: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1653: IF l_debug_level > 0 THEN
1654: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1655: END IF;
1656: RAISE FND_API.G_EXC_ERROR;

Line 1656: RAISE FND_API.G_EXC_ERROR;

1652: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1653: IF l_debug_level > 0 THEN
1654: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1655: END IF;
1656: RAISE FND_API.G_EXC_ERROR;
1657: END IF;
1658: END IF;
1659: END IF;
1660:

Line 1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1676:
1677: IF l_debug_level > 0 THEN
1678: oe_debug_pub.add( 'INV IFACE ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
1679: END IF;
1680: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1681: END Inventory_Interface;
1682:
1683: END OE_Inv_Iface_PVT;