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 116: x_return_status := FND_API.G_RET_STS_SUCCESS;

112:
113: IF l_debug_level > 0 THEN
114: oe_debug_pub.add( 'INV IFACE: ENTERING INVENTORY INTERFACE' , 1 ) ;
115: END IF;
116: x_return_status := FND_API.G_RET_STS_SUCCESS;
117: x_result_out := OE_GLOBALS.G_WFR_COMPLETE;
118:
119: profile_values.oe_source_code := FND_PROFILE.VALUE('ONT_SOURCE_CODE');
120: profile_values.user_id := FND_GLOBAL.USER_ID;

Line 141: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND

137: x_return_status => l_hold_return_status,
138: x_msg_count => l_hold_msg_count,
139: x_msg_data => l_hold_msg_data);
140:
141: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
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:

Line 142: l_hold_result_out = FND_API.G_TRUE ) THEN

138: x_msg_count => l_hold_msg_count,
139: x_msg_data => l_hold_msg_data);
140:
141: IF ( l_hold_return_status = FND_API.G_RET_STS_SUCCESS AND
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');

Line 148: x_return_status := FND_API.G_RET_STS_ERROR;

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
151: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
152: END IF;

Line 154: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN

150: IF l_debug_level > 0 THEN
151: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
152: END IF;
153: RETURN;
154: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: IF l_debug_level > 0 THEN
157: oe_debug_pub.add( 'INV IFACE: CHECK HOLD API ERROR' , 5 ) ;
158: END IF;

Line 155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

151: oe_debug_pub.add( 'INV IFACE: ACTIVITY ON HOLD , EXITING' , 5 ) ;
152: END IF;
153: RETURN;
154: ELSIF l_hold_return_status <> FND_API.G_RET_STS_SUCCESS THEN
155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
156: IF l_debug_level > 0 THEN
157: oe_debug_pub.add( 'INV IFACE: CHECK HOLD API ERROR' , 5 ) ;
158: END IF;
159: RETURN;

Line 168: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

164: OE_Line_Util.Lock_Row(p_line_id=>p_line_id
165: , p_x_line_rec => l_line_rec
166: , x_return_status => l_return_status
167: );
168: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
171: END IF;
172: x_return_status := FND_API.G_RET_STS_ERROR;

Line 172: x_return_status := FND_API.G_RET_STS_ERROR;

168: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
169: IF l_debug_level > 0 THEN
170: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
171: END IF;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;

Line 174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

170: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
171: END IF;
172: x_return_status := FND_API.G_RET_STS_ERROR;
173: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
177: END IF;
178: x_return_status := FND_API.G_RET_STS_ERROR;

Line 178: x_return_status := FND_API.G_RET_STS_ERROR;

174: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
175: IF l_debug_level > 0 THEN
176: oe_debug_pub.add( 'INV IFACE: LOCK_ROW FAILED' , 5 ) ;
177: END IF;
178: x_return_status := FND_API.G_RET_STS_ERROR;
179: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
180: END IF;
181:
182: OE_MSG_PUB.update_msg_context(

Line 208: x_return_status := FND_API.G_RET_STS_SUCCESS;

204: IF l_line_rec.shippable_flag = 'Y' THEN
205: IF nvl(l_line_rec.source_type_code, OE_GLOBALS.G_SOURCE_EXTERNAL)
206: = OE_GLOBALS.G_SOURCE_EXTERNAL OR
207: l_transactable_flag <> 'Y' THEN
208: x_return_status := FND_API.G_RET_STS_SUCCESS;
209: x_result_out := OE_GLOBALS.G_WFR_NOT_ELIGIBLE;
210: IF l_debug_level > 0 THEN
211: oe_debug_pub.add( 'INV IFACE: INV IFACE NOT ELIGIBLE - EXTERNAL OR NON TRANSACTABLE' , 5 ) ;
212: END IF;

Line 222: x_return_status := FND_API.G_RET_STS_ERROR;

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;
225: END IF;
226:

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

270: x_concat_segs => l_concat_segs,
271: x_concat_ids => l_concat_ids,
272: x_concat_descrs => l_concat_descrs,
273: x_msg_count => l_msg_count,
274: x_msg_data => l_msg_data) <> FND_API.G_RET_STS_SUCCESS
275: THEN
276: -- if COGS workflow fails for some reason,
277: -- we will return INCOMPLETE
278:

Line 283: x_return_status := FND_API.G_RET_STS_ERROR;

279: l_trans_acc := NULL;
280: IF l_debug_level > 0 THEN
281: oe_debug_pub.add( 'INV IFACE: COGS FAIL' , 5 ) ;
282: END IF;
283: x_return_status := FND_API.G_RET_STS_ERROR;
284: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
285: RETURN;
286: END IF;
287:

Line 303: x_return_status := FND_API.G_RET_STS_ERROR;

299: WHEN OTHERS THEN
300: IF l_debug_level > 0 THEN
301: oe_debug_pub.add( 'INV IFACE: REVISION/LOT SELECT FAILURE' , 5 ) ;
302: END IF;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
305: RETURN;
306: END;
307:

Line 316: x_return_status := FND_API.G_RET_STS_ERROR;

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;
319: END IF;
320:

Line 419: x_return_status := FND_API.G_RET_STS_ERROR;

415: l_line_rec.reserved_quantity > l_line_rec.ordered_quantity ) THEN
416: IF l_debug_level > 0 THEN
417: oe_debug_pub.add( 'INV IFACE FAILED: ORDERED_QTY IS < RESERVED_QTY FOR OPM' , 5 ) ;
418: END IF;
419: x_return_status := FND_API.G_RET_STS_ERROR;
420: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
421: ROLLBACK TO INVENTORY_INTERFACE;
422: RETURN;
423: END IF;

Line 446: , p_init_msg_lst => FND_API.G_TRUE

442: END IF;
443:
444: inv_reservation_pub.query_reservation
445: ( p_api_version_number => 1.0
446: , p_init_msg_lst => FND_API.G_TRUE
447: , x_return_status => l_return_status
448: , x_msg_count => l_msg_count
449: , x_msg_data => l_msg_data
450: , p_query_input => l_rsv_rec

Line 461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR

457: IF l_debug_level > 0 THEN
458: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS || ' COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
459: END IF;
460:
461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
462: l_return_status = FND_API.G_RET_STS_ERROR THEN
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
465: END IF;

Line 462: l_return_status = FND_API.G_RET_STS_ERROR THEN

458: oe_debug_pub.add( 'INV IFACE: AFTER CALLING INVS QUERY_RESERVATION: ' || L_RETURN_STATUS || ' COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;
459: END IF;
460:
461: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR OR
462: l_return_status = FND_API.G_RET_STS_ERROR THEN
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
465: END IF;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

462: l_return_status = FND_API.G_RET_STS_ERROR THEN
463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
465: END IF;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: RETURN;
469: END IF;
470:

Line 467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

463: IF l_debug_level > 0 THEN
464: oe_debug_pub.add( 'INV IFACE: QUERY_RESERVATION FAILED' , 5 ) ;
465: END IF;
466: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
467: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
468: RETURN;
469: END IF;
470:
471: -- LOOP to insert reservation record to interface table

Line 480: x_return_status := FND_API.G_RET_STS_ERROR;

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;
483: RETURN;
484: END IF;

Line 496: x_return_status := FND_API.G_RET_STS_ERROR;

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;
499: RETURN;
500: END IF; -- INVCONV

Line 515: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

511: ,opm_msg_count
512: ,opm_msg_data);
513:
514: -- This error is reported if lot_id is not found
515: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
516: IF l_debug_level > 0 THEN
517: 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 ) ;
518: END IF;
519: x_return_status := FND_API.G_RET_STS_ERROR;

Line 519: x_return_status := FND_API.G_RET_STS_ERROR;

515: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
516: IF l_debug_level > 0 THEN
517: 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 ) ;
518: END IF;
519: x_return_status := FND_API.G_RET_STS_ERROR;
520: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
521: ROLLBACK TO INVENTORY_INTERFACE;
522: RETURN;
523: END IF; -- of error checking

Line 542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

538: ,l_return_status
539: ,opm_msg_count
540: ,opm_msg_data);
541:
542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
543: IF l_debug_level > 0 THEN
544: oe_debug_pub.add( 'INV IFACE: FAILED TO UPDATE OPM TRXNS' , 5 ) ;
545: END IF;
546: x_return_status := FND_API.G_RET_STS_ERROR;

Line 546: x_return_status := FND_API.G_RET_STS_ERROR;

542: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
543: IF l_debug_level > 0 THEN
544: oe_debug_pub.add( 'INV IFACE: FAILED TO UPDATE OPM TRXNS' , 5 ) ;
545: END IF;
546: x_return_status := FND_API.G_RET_STS_ERROR;
547: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
548: ROLLBACK TO INVENTORY_INTERFACE;
549: RETURN;
550: END IF;

Line 563: x_return_status := FND_API.G_RET_STS_ERROR;

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;
566: RETURN;
567: ELSE

Line 580: x_return_status := FND_API.G_RET_STS_ERROR;

576: WHEN OTHERS THEN
577: IF l_debug_level > 0 THEN
578: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE FAILURE' , 5 ) ;
579: END IF;
580: x_return_status := FND_API.G_RET_STS_ERROR;
581: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
582: ROLLBACK TO INVENTORY_INTERFACE;
583: RETURN;
584: END;

Line 598: x_return_status := FND_API.G_RET_STS_ERROR;

594: WHEN OTHERS THEN
595: IF l_debug_level > 0 THEN
596: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE FAILURE' , 5 ) ;
597: END IF;
598: x_return_status := FND_API.G_RET_STS_ERROR;
599: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
600: ROLLBACK TO INVENTORY_INTERFACE;
601: RETURN;
602: END;

Line 615: x_return_status := FND_API.G_RET_STS_ERROR;

611: WHEN OTHERS THEN
612: IF l_debug_level > 0 THEN
613: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
614: END IF;
615: x_return_status := FND_API.G_RET_STS_ERROR;
616: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
617: ROLLBACK TO INVENTORY_INTERFACE;
618: RETURN;
619: END;

Line 641: x_return_status := FND_API.G_RET_STS_ERROR;

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;
644: RETURN;
645: END IF;

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

1010:
1011: IF (l_process_org = 0 )THEN */
1012:
1013: IF ( l_line_rec.subinventory is null or
1014: l_line_rec.subinventory = FND_API.G_MISS_CHAR ) THEN
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

Line 1023: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1024: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1025: ROLLBACK TO INVENTORY_INTERFACE;
1026: RETURN;
1027: END IF;

Line 1041: x_return_status := FND_API.G_RET_STS_ERROR;

1037: WHEN OTHERS THEN
1038: IF l_debug_level > 0 THEN
1039: oe_debug_pub.add( 'INV IFACE: LOCATOR CONTROL CODE SELECT FAILURE' , 5 ) ;
1040: END IF;
1041: x_return_status := FND_API.G_RET_STS_ERROR;
1042: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1043: ROLLBACK TO INVENTORY_INTERFACE;
1044: RETURN;
1045: END;

Line 1059: x_return_status := FND_API.G_RET_STS_ERROR;

1055: WHEN OTHERS THEN
1056: IF l_debug_level > 0 THEN
1057: oe_debug_pub.add( 'INV IFACE: LOCATOR TYPE SELECT FAILURE' , 5 ) ;
1058: END IF;
1059: x_return_status := FND_API.G_RET_STS_ERROR;
1060: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1061: ROLLBACK TO INVENTORY_INTERFACE;
1062: RETURN;
1063: END;

Line 1078: x_return_status := FND_API.G_RET_STS_ERROR;

1074: WHEN OTHERS THEN
1075: IF l_debug_level > 0 THEN
1076: oe_debug_pub.add( 'INV IFACE: LOCATION CONTROL CODE FAILURE' , 5 ) ;
1077: END IF;
1078: x_return_status := FND_API.G_RET_STS_ERROR;
1079: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1080: ROLLBACK TO INVENTORY_INTERFACE;
1081: RETURN;
1082: END;

Line 1116: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1118: ROLLBACK TO INVENTORY_INTERFACE;
1119: RETURN;
1120:

Line 1128: x_return_status := FND_API.G_RET_STS_ERROR;

1124: IF ( l_process_org = 1 AND l_lot = 'N' ) THEN
1125: IF l_debug_level > 0 THEN
1126: oe_debug_pub.add( 'INV IFACE: NO DEFAULT TRXN EXISTS FOR NON-LOT , NON-INV OPM ITEM' , 5 ) ;
1127: END IF;
1128: x_return_status := FND_API.G_RET_STS_ERROR;
1129: x_result_out := OE_GLOBALS.G_WFR_INCOMPLETE;
1130: ROLLBACK TO INVENTORY_INTERFACE;
1131: RETURN;
1132: END IF; */

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

1437: /* update flow_status_code */
1438: OE_ORDER_WF_UTIL.Update_Flow_Status_Code(p_line_id => p_line_id
1439: , p_flow_status_code => 'INVENTORY_INTERFACED'
1440: , x_return_status => l_return_status);
1441: IF (l_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
1442: IF l_debug_level > 0 THEN
1443: oe_debug_pub.add( 'INV IFACE: UPDATE FLOW STATUS CODE FAILED' , 5 ) ;
1444: END IF;
1445: END IF;

Line 1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1468: ,p_process_requests => TRUE);
1469: IF l_debug_level > 0 THEN
1470: oe_debug_pub.add( 'INV IFACE: AFTER CALLING EXPLOSION : '|| L_RETURN_STATUS , 3 ) ;
1471: END IF;
1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: IF l_debug_level > 0 THEN
1474: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1475: END IF;
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1472: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1473: IF l_debug_level > 0 THEN
1474: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1475: END IF;
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1480: END IF;

Line 1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1473: IF l_debug_level > 0 THEN
1474: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - UNEXP' , 1 ) ;
1475: END IF;
1476: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1480: END IF;
1481: RAISE FND_API.G_EXC_ERROR;

Line 1481: RAISE FND_API.G_EXC_ERROR;

1477: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1478: IF l_debug_level > 0 THEN
1479: oe_debug_pub.add( 'INV IFACE: FREEZE INCLUDED ITEM FAILED - EXP' , 1 ) ;
1480: END IF;
1481: RAISE FND_API.G_EXC_ERROR;
1482: END IF;
1483: END IF;
1484: END IF;
1485:

Line 1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1501:
1502: IF l_debug_level > 0 THEN
1503: oe_debug_pub.add( 'INV IFACE ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 100 ) , 1 ) ;
1504: END IF;
1505: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1506: END Inventory_Interface;
1507:
1508: END OE_Inv_Iface_PVT;