[Home] [Help]
142: l_hold_result_out = FND_API.G_TRUE ) THEN
143: /* we are reusing the OE_INVOICING_HOLD message here,
144: the message is generic, not invoicing specific */
145:
146: FND_MESSAGE.SET_NAME('ONT','OE_INVOICING_HOLD');
147: OE_MSG_PUB.ADD;
148: x_return_status := FND_API.G_RET_STS_ERROR;
149: x_result_out := OE_GLOBALS.G_WFR_ON_HOLD;
150: IF l_debug_level > 0 THEN
216: IF l_line_rec.ship_from_org_id is null THEN
217: IF l_debug_level > 0 THEN
218: oe_debug_pub.add( 'INV IFACE: INV IFACE INCOMPLETE - NO WAREHOUSE' , 5 ) ;
219: END IF;
220: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_NO_WAREHOUSE');
221: OE_MSG_PUB.ADD;
222: x_return_status := FND_API.G_RET_STS_ERROR;
223: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
224: RETURN;
310: IF l_debug_level > 0 THEN
311: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL , ERROR' , 5 ) ;
312: END IF;
313: -- give a message here
314: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
315: OE_MSG_PUB.ADD;
316: x_return_status := FND_API.G_RET_STS_ERROR;
317: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
318: RETURN;
474: -- validate the inventory control are being satisfied
475: IF l_revision = 'Y' THEN
476: IF l_rsv_tbl(I).revision is null THEN
477: -- give a message
478: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_REVISION');
479: OE_MSG_PUB.ADD;
480: x_return_status := FND_API.G_RET_STS_ERROR;
481: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
482: ROLLBACK TO INVENTORY_INTERFACE;
490: -- to branch and retrieve lot_id from OPM TRXN table
491: IF ( l_rsv_tbl(I).lot_number is null ) THEN -- INVCONV
492: -- AND l_process_org = 0 ) THEN -- For discrete INVCONV
493: -- give a message
494: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_LOT');
495: OE_MSG_PUB.ADD;
496: x_return_status := FND_API.G_RET_STS_ERROR;
497: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
498: ROLLBACK TO INVENTORY_INTERFACE;
557:
558:
559: IF l_rsv_tbl(I).subinventory_code is null THEN
560: -- give a message
561: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_RSV_SUB');
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;
635: -- give a message
636: IF l_debug_level > 0 THEN
637: oe_debug_pub.add( 'INV IFACE: ITEM UNDER LOCATOR CONTROL' , 5 ) ;
638: END IF;
639: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_LOCATOR');
640: OE_MSG_PUB.ADD;
641: x_return_status := FND_API.G_RET_STS_ERROR;
642: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
643: ROLLBACK TO INVENTORY_INTERFACE;
1015: IF l_debug_level > 0 THEN
1016: oe_debug_pub.add( 'INV IFACE: SUBINV IS NULL OR MISS_CHAR FOR INSERT - 2' , 5 ) ;
1017: END IF;
1018: -- Give a message here
1019: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SUB');
1020: -- message should say if item is under revision/lot/locator control, use the
1021: -- reservation form to reserve first
1022: OE_MSG_PUB.ADD;
1023: x_return_status := FND_API.G_RET_STS_ERROR;
1102: IF l_debug_level > 0 THEN
1103: oe_debug_pub.add( 'INV IFACE: ITEM UNDER SERIAL CONTORL , ERROR' , 5 ) ;
1104: END IF;
1105: -- give a message here
1106: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_SERIAL');
1107: OE_MSG_PUB.ADD;
1108: ELSE
1109: IF l_debug_level > 0 THEN
1110: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION/LOT/LOCATOR CONTROL AND NO RESERVATION EXISTS' , 5 ) ;
1109: IF l_debug_level > 0 THEN
1110: oe_debug_pub.add( 'INV IFACE: ITEM UNDER REVISION/LOT/LOCATOR CONTROL AND NO RESERVATION EXISTS' , 5 ) ;
1111: END IF;
1112: -- Give a message here
1113: FND_MESSAGE.SET_NAME('ONT', 'OE_INV_IFACE_NO_RSV');
1114: OE_MSG_PUB.ADD;
1115: END IF;
1116: x_return_status := FND_API.G_RET_STS_ERROR;
1117: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;