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.INV_MWB_CG_TRANSFER dependencies on FND_API

Line 139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

135: p_trx_cost => NULL
136: );
137:
138: IF L_RETURN_STATUS <> 0 THEN
139: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
140: END IF;
141:
142: IF P_IS_LOT_CONTROLLED = 'Y' AND P_IS_SERIAL_CONTROLLED <> 'Y' THEN
143:

Line 170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

166: IF L_RETURN_STATUS <> 0 THEN
167:
168: FND_MESSAGE.SET_NAME('INV','INV_LOT_COMMIT_FAILURE');
169: FND_MSG_PUB.ADD;
170: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
171:
172: END IF;
173:
174: END IF; -- for Only Lot Controlled Items

Line 193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

189: IF L_RETURN_STATUS <> 0 THEN
190:
191: FND_MESSAGE.SET_NAME('INV','INV_LOT_COMMIT_FAILURE');
192: FND_MSG_PUB.ADD;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194:
195: END IF;
196:
197: L_RETURN_STATUS := INV_TRX_UTIL_PUB.INSERT_SER_TRX(

Line 209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

205: IF L_RETURN_STATUS <> 0 THEN
206:
207: FND_MESSAGE.SET_NAME('INV','INV_SERIAL_COMMIT_FAILURE');
208: FND_MSG_PUB.ADD;
209: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
210:
211: END IF;
212:
213: END IF; -- for Lot and Serial Controlled Items

Line 229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

225: IF L_RETURN_STATUS <> 0 THEN
226:
227: FND_MESSAGE.SET_NAME('INV','INV_SERIAL_COMMIT_FAILURE');
228: FND_MSG_PUB.ADD;
229: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
230:
231: END IF;
232:
233: END IF; -- Only Serial Controlled Items

Line 239: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

235: IF X_TRANSACTION_HEADER_ID IS NULL THEN
236: X_TRANSACTION_HEADER_ID := L_TRANSACTION_TEMP_ID;
237: END IF;
238:
239: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
240:
241: EXCEPTION
242:
243: WHEN FND_API.G_EXC_ERROR THEN

Line 243: WHEN FND_API.G_EXC_ERROR THEN

239: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
240:
241: EXCEPTION
242:
243: WHEN FND_API.G_EXC_ERROR THEN
244:
245: ROLLBACK TO TRX_BEGIN;
246: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 246: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

242:
243: WHEN FND_API.G_EXC_ERROR THEN
244:
245: ROLLBACK TO TRX_BEGIN;
246: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: ROLLBACK TO TRX_BEGIN;
246: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
247: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: ROLLBACK TO TRX_BEGIN;
252: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
253: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 252: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: ROLLBACK TO TRX_BEGIN;
252: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
253: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
254:
255: WHEN OTHERS THEN
256:

Line 258: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

254:
255: WHEN OTHERS THEN
256:
257: ROLLBACK TO TRX_BEGIN;
258: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
259: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
260: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'TRANSFER');
261: END IF;
262: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 320: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

316:
317: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
318: BEGIN
319:
320: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
321:
322: IF P_IS_REVISION_CONTROLLED = 'Y' THEN
323: L_IS_REVISION_CONTROLLED := TRUE;
324: L_V_IS_REVISION_CONTROLLED := 'TRUE';

Line 343: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

339: THEN
340:
341: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_CGU_REQ');
342: FND_MSG_PUB.ADD;
343: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
344:
345: END IF;
346:
347: IF P_IS_REVISION_CONTROLLED = 'Y' AND P_REVISION IS NULL THEN

Line 352: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

348:
349: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_TRN_EXP');
350: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('WMS','WMS_REV'));
351: FND_MSG_PUB.ADD;
352: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
353:
354: END IF;
355:
356: IF P_IS_LOT_CONTROLLED = 'Y' AND P_LOT_NUMBER IS NULL THEN

Line 361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

357:
358: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_TRN_EXP');
359: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('WMS','WMS_LOT'));
360: FND_MSG_PUB.ADD;
361: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
362:
363: END IF;
364:
365: IF P_IS_SERIAL_CONTROLLED = 'Y' AND P_SERIAL_NUMBER IS NULL THEN

Line 370: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

366:
367: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_TRN_EXP');
368: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('WMS','WMS_SER'));
369: FND_MSG_PUB.ADD;
370: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
371:
372: END IF;
373:
374: IF P_IS_LPN_REQUIRED = 'Y' AND P_LPN_ID IS NULL THEN

Line 379: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

375:
376: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_TRN_EXP');
377: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('WMS','WMS_LPN'));
378: FND_MSG_PUB.ADD;
379: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
380:
381: END IF;
382:
383: /* Bug no 2925346 to disallow the cost group transfers

Line 395: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;

391: THEN
392:
393: FND_MESSAGE.SET_NAME('INV','INV_PRJ_CG_XFR_DISALLOWED');
394: fnd_msg_pub.add;
395: X_RETURN_STATUS:=FND_API.G_RET_STS_ERROR;
396: END IF;
397: END IF;
398:
399: IF P_ORG_ID IS NOT NULL AND P_INVENTORY_ITEM_ID IS NOT NULL AND

Line 421: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

417:
418: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_STATUS_NA');
419: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('INV','INV_SUBINV'));
420: FND_MSG_PUB.ADD;
421: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
422:
423: END IF;
424:
425: END IF; -- Subinventory Status Check

Line 449: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

445:
446: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_STATUS_NA');
447: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('WMS','WMS_LOC'));
448: FND_MSG_PUB.ADD;
449: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
450:
451: END IF;
452:
453: END IF; -- Locator Status Check.

Line 477: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

473:
474: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_STATUS_NA');
475: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('WMS','WMS_LOT'));
476: FND_MSG_PUB.ADD;
477: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
478:
479: END IF;
480:
481: END IF; -- Lot Number Status Check.

Line 505: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

501:
502: FND_MESSAGE.SET_NAME('WMS','WMS_ATT_STATUS_NA');
503: FND_MESSAGE.SET_TOKEN('TOKEN',FND_MESSAGE.GET_STRING('WMS','WMS_SER'));
504: FND_MSG_PUB.ADD;
505: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
506:
507: END IF;
508:
509: END IF; -- Serial Number Status Check.

Line 511: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN

507: END IF;
508:
509: END IF; -- Serial Number Status Check.
510:
511: IF X_RETURN_STATUS = FND_API.G_RET_STS_SUCCESS THEN
512:
513: IF X_AVAILABILITY IS NULL THEN
514: /*Changed from serial and not controlled to only check if serial controlled bug3405867*/
515: IF L_IS_SERIAL_CONTROLLED THEN --AND NOT L_IS_LOT_CONTROLLED THEN

Line 550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

546: L_ATT := 0;
547: L_QOH := X_ONHAND;
548: FND_MESSAGE.SET_NAME('INV','INV_ERROR_FIND_LPN_QTY');
549: FND_MSG_PUB.ADD;
550: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
551:
552: END IF;
553:
554: ELSE

Line 603: IF L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN

599: /* packed quantity should not be considered into onhand for loose items */
600: L_QOH:=NVL(L_QOH,0)-NVL(L_PQOH,0);
601: /* end of bug fix 2460413 */
602:
603: IF L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
604:
605: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
606:
607: END IF;

Line 605: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

601: /* end of bug fix 2460413 */
602:
603: IF L_RETURN_STATUS <> FND_API.G_RET_STS_SUCCESS THEN
604:
605: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
606:
607: END IF;
608:
609: END IF; -- Is Serial controlled / Is LPN Required

Line 615: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

611: IF NVL(L_ATT,0) <> L_QOH THEN
612:
613: FND_MESSAGE.SET_NAME('WMS','WMS_COMMINGLE_WARN');
614: FND_MSG_PUB.ADD;
615: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
616:
617: END IF;
618:
619: END IF; -- Availability is null

Line 626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN

622:
623: X_AVAILABILITY := NVL(L_ATT,0);
624: X_ONHAND := NVL(L_QOH,0);
625:
626: IF X_RETURN_STATUS = FND_API.G_RET_STS_ERROR THEN
627:
628: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
629:
630: END IF;

Line 634: WHEN FND_API.G_EXC_ERROR THEN

630: END IF;
631:
632: EXCEPTION
633:
634: WHEN FND_API.G_EXC_ERROR THEN
635:
636: X_AVAILABILITY := NVL(X_AVAILABILITY,0);
637: X_ONHAND := NVL(X_ONHAND,0);
638: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

Line 638: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

634: WHEN FND_API.G_EXC_ERROR THEN
635:
636: X_AVAILABILITY := NVL(X_AVAILABILITY,0);
637: X_ONHAND := NVL(X_ONHAND,0);
638: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
639: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642:

Line 641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

637: X_ONHAND := NVL(X_ONHAND,0);
638: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
639: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
640:
641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642:
643: X_AVAILABILITY := NVL(X_AVAILABILITY,0);
644: X_ONHAND := NVL(X_ONHAND,0);
645: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

Line 645: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

641: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
642:
643: X_AVAILABILITY := NVL(X_AVAILABILITY,0);
644: X_ONHAND := NVL(X_ONHAND,0);
645: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
646: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
647:
648: WHEN OTHERS THEN
649:

Line 652: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

648: WHEN OTHERS THEN
649:
650: X_AVAILABILITY := NVL(X_AVAILABILITY,0);
651: X_ONHAND := NVL(X_ONHAND,0);
652: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
653: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
654: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'VALIDATE');
655: END IF;
656: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );

Line 765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

761: X_MSG_COUNT => L_MSG_COUNT
762: );
763:
764: IF L_RETURN_STATUS <> 'S' THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
769:

Line 768: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;

764: IF L_RETURN_STATUS <> 'S' THEN
765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
766: END IF;
767:
768: X_RETURN_STATUS := FND_API.G_RET_STS_SUCCESS;
769:
770:
771: EXCEPTION
772:

Line 773: WHEN FND_API.G_EXC_ERROR THEN

769:
770:
771: EXCEPTION
772:
773: WHEN FND_API.G_EXC_ERROR THEN
774:
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
777:

Line 775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;

771: EXCEPTION
772:
773: WHEN FND_API.G_EXC_ERROR THEN
774:
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779:

Line 778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

774:
775: X_RETURN_STATUS := FND_API.G_RET_STS_ERROR;
776: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779:
780: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
781: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
782:

Line 780: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

776: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
777:
778: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
779:
780: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
781: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
782:
783: WHEN OTHERS THEN
784:

Line 785: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;

781: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );
782:
783: WHEN OTHERS THEN
784:
785: X_RETURN_STATUS := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
787: FND_MSG_PUB.ADD_EXC_MSG( g_pkg_name, 'TRANSFER');
788: END IF;
789: FND_MSG_PUB.COUNT_AND_GET( P_COUNT => X_MSG_COUNT, P_DATA => X_MSG_DATA );