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

Line 69: processInv => fnd_api.g_true,

65: cmpParams.taskID := parameters.taskID;
66: cmpParams.isFromSerializedPage := parameters.isFromSerializedPage;
67: -- call completion processor to process assy cpl
68: wma_completion.process(parameters => cmpParams,
69: processInv => fnd_api.g_true,
70: status => status,
71: errMessage => errMessage);
72: IF(status <> 0) THEN
73: if (l_logLevel <= wip_constants.trace_logging) then

Line 149: p_initMsgList => fnd_api.g_true,

145: --remain there even after the validateInterfaceTxns() call until the assy record is
146: --inserted and processed in the wma_completion.process() call further below
147: IF(parameters.txnType <> WIP_CONSTANTS.RET_TXN) THEN
148: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => parameters.mtl_header_id,
149: p_initMsgList => fnd_api.g_true,
150: x_returnStatus => l_returnStatus);
151: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
152: /* Bug 5727205 : Commented out commit. No need to commit if validation fails.
153: commit; */

Line 151: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN

147: IF(parameters.txnType <> WIP_CONSTANTS.RET_TXN) THEN
148: wip_mtlTempProc_priv.validateInterfaceTxns(p_txnHdrID => parameters.mtl_header_id,
149: p_initMsgList => fnd_api.g_true,
150: x_returnStatus => l_returnStatus);
151: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
152: /* Bug 5727205 : Commented out commit. No need to commit if validation fails.
153: commit; */
154: raise fnd_api.g_exc_unexpected_error;
155: END IF;

Line 154: raise fnd_api.g_exc_unexpected_error;

150: x_returnStatus => l_returnStatus);
151: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
152: /* Bug 5727205 : Commented out commit. No need to commit if validation fails.
153: commit; */
154: raise fnd_api.g_exc_unexpected_error;
155: END IF;
156: END IF;
157:
158: wip_movProc_priv.processIntf

Line 167: p_endDebug => FND_API.G_TRUE,

163: p_time_out => 0,
164: p_move_mode => WIP_CONSTANTS.ONLINE,
165: p_bf_mode => WIP_CONSTANTS.ONLINE,
166: p_mtl_mode => l_mtlMode,
167: p_endDebug => FND_API.G_TRUE,
168: p_initMsgList => FND_API.G_TRUE,
169: p_insertAssy => FND_API.G_FALSE,
170: p_do_backflush => FND_API.G_FALSE,
171: x_returnStatus => l_returnStatus);

Line 168: p_initMsgList => FND_API.G_TRUE,

164: p_move_mode => WIP_CONSTANTS.ONLINE,
165: p_bf_mode => WIP_CONSTANTS.ONLINE,
166: p_mtl_mode => l_mtlMode,
167: p_endDebug => FND_API.G_TRUE,
168: p_initMsgList => FND_API.G_TRUE,
169: p_insertAssy => FND_API.G_FALSE,
170: p_do_backflush => FND_API.G_FALSE,
171: x_returnStatus => l_returnStatus);
172:

Line 169: p_insertAssy => FND_API.G_FALSE,

165: p_bf_mode => WIP_CONSTANTS.ONLINE,
166: p_mtl_mode => l_mtlMode,
167: p_endDebug => FND_API.G_TRUE,
168: p_initMsgList => FND_API.G_TRUE,
169: p_insertAssy => FND_API.G_FALSE,
170: p_do_backflush => FND_API.G_FALSE,
171: x_returnStatus => l_returnStatus);
172:
173: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 170: p_do_backflush => FND_API.G_FALSE,

166: p_mtl_mode => l_mtlMode,
167: p_endDebug => FND_API.G_TRUE,
168: p_initMsgList => FND_API.G_TRUE,
169: p_insertAssy => FND_API.G_FALSE,
170: p_do_backflush => FND_API.G_FALSE,
171: x_returnStatus => l_returnStatus);
172:
173: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
174: raise fnd_api.g_exc_unexpected_error;

Line 173: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN

169: p_insertAssy => FND_API.G_FALSE,
170: p_do_backflush => FND_API.G_FALSE,
171: x_returnStatus => l_returnStatus);
172:
173: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
174: raise fnd_api.g_exc_unexpected_error;
175: END IF;
176: ELSE -- Background transaction
177: NULL;

Line 174: raise fnd_api.g_exc_unexpected_error;

170: p_do_backflush => FND_API.G_FALSE,
171: x_returnStatus => l_returnStatus);
172:
173: IF(l_returnStatus <> fnd_api.g_ret_sts_success) THEN
174: raise fnd_api.g_exc_unexpected_error;
175: END IF;
176: ELSE -- Background transaction
177: NULL;
178: END IF;

Line 208: processInv => fnd_api.g_true,

204: cmpParams.isFromSerializedPage := parameters.isFromSerializedPage;
205: -- call completion processor to derive and insert assembly record
206: -- into MMTT. And also call Inventory TM to process all records in MMTT.
207: wma_completion.process(parameters => cmpParams,
208: processInv => fnd_api.g_true,
209: status => status,
210: errMessage => errMessage);
211: IF(status <> 0) THEN
212: if (l_logLevel <= wip_constants.trace_logging) then

Line 230: WHEN fnd_api.g_exc_unexpected_error THEN

226: x_returnStatus => l_returnStatus);
227: end if;
228:
229: EXCEPTION
230: WHEN fnd_api.g_exc_unexpected_error THEN
231: status := -1;
232: wip_utilities.get_message_stack(p_msg => errMessage);
233: if (l_logLevel <= wip_constants.trace_logging) then
234: wip_logger.exitPoint(p_procName => 'wma_move.process',

Line 362: p_mergeMode => fnd_api.g_false,

358: p_lastOP => l_maxOpSeqNum,
359: p_firstMoveOp => null,
360: p_lastMoveOp => null,
361: p_srcCode => null,
362: p_mergeMode => fnd_api.g_false,
363: p_initMsgList => fnd_api.g_true,
364: p_endDebug => fnd_api.g_false,
365: p_mtlTxnMode => wip_constants.online,
366: x_compTbl => l_compTbl,

Line 363: p_initMsgList => fnd_api.g_true,

359: p_firstMoveOp => null,
360: p_lastMoveOp => null,
361: p_srcCode => null,
362: p_mergeMode => fnd_api.g_false,
363: p_initMsgList => fnd_api.g_true,
364: p_endDebug => fnd_api.g_false,
365: p_mtlTxnMode => wip_constants.online,
366: x_compTbl => l_compTbl,
367: x_returnStatus => x_returnStatus);

Line 364: p_endDebug => fnd_api.g_false,

360: p_lastMoveOp => null,
361: p_srcCode => null,
362: p_mergeMode => fnd_api.g_false,
363: p_initMsgList => fnd_api.g_true,
364: p_endDebug => fnd_api.g_false,
365: p_mtlTxnMode => wip_constants.online,
366: x_compTbl => l_compTbl,
367: x_returnStatus => x_returnStatus);
368:

Line 369: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

365: p_mtlTxnMode => wip_constants.online,
366: x_compTbl => l_compTbl,
367: x_returnStatus => x_returnStatus);
368:
369: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
370: raise fnd_api.g_exc_unexpected_error;
371: END IF;
372: END IF;-- Easy Complete/Return
373:

Line 370: raise fnd_api.g_exc_unexpected_error;

366: x_compTbl => l_compTbl,
367: x_returnStatus => x_returnStatus);
368:
369: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
370: raise fnd_api.g_exc_unexpected_error;
371: END IF;
372: END IF;-- Easy Complete/Return
373:
374: -- Call bf_require to derive first_bf_op, last_bf_op, and bf_qty before

Line 389: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

385: x_bf_qty => l_bf_qty,
386: x_returnStatus => x_returnStatus,
387: x_errMessage => x_errMessage);
388:
389: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
390: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
391: fnd_message.set_token('MESSAGE', x_errMessage);
392: fnd_msg_pub.add;
393: raise fnd_api.g_exc_unexpected_error;

Line 393: raise fnd_api.g_exc_unexpected_error;

389: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
390: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
391: fnd_message.set_token('MESSAGE', x_errMessage);
392: fnd_msg_pub.add;
393: raise fnd_api.g_exc_unexpected_error;
394: END IF;
395:
396: IF(l_first_bf_op <> -1) THEN
397:

Line 416: p_mergeMode => fnd_api.g_false,

412: p_lastOP => l_last_bf_op,
413: p_firstMoveOp => p_fm_op, -- use to check autocharge
414: p_lastMoveOp => p_to_op, -- use to check autocharge
415: p_srcCode => null,
416: p_mergeMode => fnd_api.g_false,
417: p_initMsgList => fnd_api.g_true,
418: p_endDebug => fnd_api.g_false,
419: p_mtlTxnMode => wip_constants.online,
420: x_compTbl => l_compTbl,

Line 417: p_initMsgList => fnd_api.g_true,

413: p_firstMoveOp => p_fm_op, -- use to check autocharge
414: p_lastMoveOp => p_to_op, -- use to check autocharge
415: p_srcCode => null,
416: p_mergeMode => fnd_api.g_false,
417: p_initMsgList => fnd_api.g_true,
418: p_endDebug => fnd_api.g_false,
419: p_mtlTxnMode => wip_constants.online,
420: x_compTbl => l_compTbl,
421: x_returnStatus => x_returnStatus);

Line 418: p_endDebug => fnd_api.g_false,

414: p_lastMoveOp => p_to_op, -- use to check autocharge
415: p_srcCode => null,
416: p_mergeMode => fnd_api.g_false,
417: p_initMsgList => fnd_api.g_true,
418: p_endDebug => fnd_api.g_false,
419: p_mtlTxnMode => wip_constants.online,
420: x_compTbl => l_compTbl,
421: x_returnStatus => x_returnStatus);
422:

Line 423: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

419: p_mtlTxnMode => wip_constants.online,
420: x_compTbl => l_compTbl,
421: x_returnStatus => x_returnStatus);
422:
423: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
424: raise fnd_api.g_exc_unexpected_error;
425: END IF;
426: END IF; -- l_first_bf_op <> -1
427:

Line 424: raise fnd_api.g_exc_unexpected_error;

420: x_compTbl => l_compTbl,
421: x_returnStatus => x_returnStatus);
422:
423: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
424: raise fnd_api.g_exc_unexpected_error;
425: END IF;
426: END IF; -- l_first_bf_op <> -1
427:
428: -- Call assy_pull_bf to derive first_bf_op, last_bf_op, and bf_qty before

Line 448: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

444: x_bf_qty => l_bf_qty,
445: x_returnStatus => x_returnStatus,
446: x_errMessage => x_errMessage);
447:
448: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
449: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
450: fnd_message.set_token('MESSAGE', x_errMessage);
451: fnd_msg_pub.add;
452: raise fnd_api.g_exc_unexpected_error;

Line 452: raise fnd_api.g_exc_unexpected_error;

448: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
449: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
450: fnd_message.set_token('MESSAGE', x_errMessage);
451: fnd_msg_pub.add;
452: raise fnd_api.g_exc_unexpected_error;
453: END IF;
454:
455: IF(l_first_bf_op <> -1) THEN
456:

Line 476: p_mergeMode => fnd_api.g_false,

472: p_lastOP => l_last_bf_op,
473: p_firstMoveOp => p_fm_op, -- use to check autocharge
474: p_lastMoveOp => p_to_op, -- use to check autocharge
475: p_srcCode => null,
476: p_mergeMode => fnd_api.g_false,
477: p_initMsgList => fnd_api.g_true,
478: p_endDebug => fnd_api.g_false,
479: p_mtlTxnMode => wip_constants.online,
480: x_compTbl => l_compTbl,

Line 477: p_initMsgList => fnd_api.g_true,

473: p_firstMoveOp => p_fm_op, -- use to check autocharge
474: p_lastMoveOp => p_to_op, -- use to check autocharge
475: p_srcCode => null,
476: p_mergeMode => fnd_api.g_false,
477: p_initMsgList => fnd_api.g_true,
478: p_endDebug => fnd_api.g_false,
479: p_mtlTxnMode => wip_constants.online,
480: x_compTbl => l_compTbl,
481: x_returnStatus => x_returnStatus);

Line 478: p_endDebug => fnd_api.g_false,

474: p_lastMoveOp => p_to_op, -- use to check autocharge
475: p_srcCode => null,
476: p_mergeMode => fnd_api.g_false,
477: p_initMsgList => fnd_api.g_true,
478: p_endDebug => fnd_api.g_false,
479: p_mtlTxnMode => wip_constants.online,
480: x_compTbl => l_compTbl,
481: x_returnStatus => x_returnStatus);
482:

Line 483: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

479: p_mtlTxnMode => wip_constants.online,
480: x_compTbl => l_compTbl,
481: x_returnStatus => x_returnStatus);
482:
483: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
484: raise fnd_api.g_exc_unexpected_error;
485: END IF;
486: END IF; -- l_first_bf_op <> -1
487:

Line 484: raise fnd_api.g_exc_unexpected_error;

480: x_compTbl => l_compTbl,
481: x_returnStatus => x_returnStatus);
482:
483: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
484: raise fnd_api.g_exc_unexpected_error;
485: END IF;
486: END IF; -- l_first_bf_op <> -1
487:
488: IF(p_childMoveID <> -1) THEN

Line 512: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

508: x_bf_qty => l_bf_qty,
509: x_returnStatus => x_returnStatus,
510: x_errMessage => x_errMessage);
511:
512: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
513: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
514: fnd_message.set_token('MESSAGE', x_errMessage);
515: fnd_msg_pub.add;
516: raise fnd_api.g_exc_unexpected_error;

Line 516: raise fnd_api.g_exc_unexpected_error;

512: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
513: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
514: fnd_message.set_token('MESSAGE', x_errMessage);
515: fnd_msg_pub.add;
516: raise fnd_api.g_exc_unexpected_error;
517: END IF;
518:
519: IF(l_first_bf_op <> -1) THEN
520:

Line 539: p_mergeMode => fnd_api.g_false,

535: p_lastOP => l_last_bf_op,
536: p_firstMoveOp => p_fm_op, -- use to check autocharge
537: p_lastMoveOp => p_to_op, -- use to check autocharge
538: p_srcCode => null,
539: p_mergeMode => fnd_api.g_false,
540: p_initMsgList => fnd_api.g_true,
541: p_endDebug => fnd_api.g_false,
542: p_mtlTxnMode => wip_constants.online,
543: x_compTbl => l_compTbl,

Line 540: p_initMsgList => fnd_api.g_true,

536: p_firstMoveOp => p_fm_op, -- use to check autocharge
537: p_lastMoveOp => p_to_op, -- use to check autocharge
538: p_srcCode => null,
539: p_mergeMode => fnd_api.g_false,
540: p_initMsgList => fnd_api.g_true,
541: p_endDebug => fnd_api.g_false,
542: p_mtlTxnMode => wip_constants.online,
543: x_compTbl => l_compTbl,
544: x_returnStatus => x_returnStatus);

Line 541: p_endDebug => fnd_api.g_false,

537: p_lastMoveOp => p_to_op, -- use to check autocharge
538: p_srcCode => null,
539: p_mergeMode => fnd_api.g_false,
540: p_initMsgList => fnd_api.g_true,
541: p_endDebug => fnd_api.g_false,
542: p_mtlTxnMode => wip_constants.online,
543: x_compTbl => l_compTbl,
544: x_returnStatus => x_returnStatus);
545:

Line 546: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

542: p_mtlTxnMode => wip_constants.online,
543: x_compTbl => l_compTbl,
544: x_returnStatus => x_returnStatus);
545:
546: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
547: raise fnd_api.g_exc_unexpected_error;
548: END IF;
549: END IF; -- end l_first_bf_op <> -1
550:

Line 547: raise fnd_api.g_exc_unexpected_error;

543: x_compTbl => l_compTbl,
544: x_returnStatus => x_returnStatus);
545:
546: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
547: raise fnd_api.g_exc_unexpected_error;
548: END IF;
549: END IF; -- end l_first_bf_op <> -1
550:
551: -- Call assy_pull_bf to derive first_bf_op, last_bf_op, and bf_qty before

Line 571: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

567: x_bf_qty => l_bf_qty,
568: x_returnStatus => x_returnStatus,
569: x_errMessage => x_errMessage);
570:
571: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
572: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
573: fnd_message.set_token('MESSAGE', x_errMessage);
574: fnd_msg_pub.add;
575: raise fnd_api.g_exc_unexpected_error;

Line 575: raise fnd_api.g_exc_unexpected_error;

571: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
572: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
573: fnd_message.set_token('MESSAGE', x_errMessage);
574: fnd_msg_pub.add;
575: raise fnd_api.g_exc_unexpected_error;
576: END IF;
577:
578: IF(l_first_bf_op <> -1) THEN
579:

Line 599: p_mergeMode => fnd_api.g_false,

595: p_lastOP => l_last_bf_op,
596: p_firstMoveOp => p_fm_op, -- use to check autocharge
597: p_lastMoveOp => p_to_op, -- use to check autocharge
598: p_srcCode => null,
599: p_mergeMode => fnd_api.g_false,
600: p_initMsgList => fnd_api.g_true,
601: p_endDebug => fnd_api.g_false,
602: p_mtlTxnMode => wip_constants.online,
603: x_compTbl => l_compTbl,

Line 600: p_initMsgList => fnd_api.g_true,

596: p_firstMoveOp => p_fm_op, -- use to check autocharge
597: p_lastMoveOp => p_to_op, -- use to check autocharge
598: p_srcCode => null,
599: p_mergeMode => fnd_api.g_false,
600: p_initMsgList => fnd_api.g_true,
601: p_endDebug => fnd_api.g_false,
602: p_mtlTxnMode => wip_constants.online,
603: x_compTbl => l_compTbl,
604: x_returnStatus => x_returnStatus);

Line 601: p_endDebug => fnd_api.g_false,

597: p_lastMoveOp => p_to_op, -- use to check autocharge
598: p_srcCode => null,
599: p_mergeMode => fnd_api.g_false,
600: p_initMsgList => fnd_api.g_true,
601: p_endDebug => fnd_api.g_false,
602: p_mtlTxnMode => wip_constants.online,
603: x_compTbl => l_compTbl,
604: x_returnStatus => x_returnStatus);
605:

Line 606: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

602: p_mtlTxnMode => wip_constants.online,
603: x_compTbl => l_compTbl,
604: x_returnStatus => x_returnStatus);
605:
606: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
607: raise fnd_api.g_exc_unexpected_error;
608: END IF;
609: END IF; -- l_first_bf_op <> -1
610:

Line 607: raise fnd_api.g_exc_unexpected_error;

603: x_compTbl => l_compTbl,
604: x_returnStatus => x_returnStatus);
605:
606: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN
607: raise fnd_api.g_exc_unexpected_error;
608: END IF;
609: END IF; -- l_first_bf_op <> -1
610:
611: END IF; -- end over move transaction

Line 635: p_initMsgList => fnd_api.g_true,

631: wip_autoLotProc_priv.deriveLots(
632: x_compLots => x_compInfo,
633: p_orgID => p_orgID,
634: p_wipEntityID => p_jobID,
635: p_initMsgList => fnd_api.g_true,
636: p_endDebug => fnd_api.g_false,
637: p_destroyTrees => fnd_api.g_true,
638: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
639: p_treeSrcName => null,

Line 636: p_endDebug => fnd_api.g_false,

632: x_compLots => x_compInfo,
633: p_orgID => p_orgID,
634: p_wipEntityID => p_jobID,
635: p_initMsgList => fnd_api.g_true,
636: p_endDebug => fnd_api.g_false,
637: p_destroyTrees => fnd_api.g_true,
638: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
639: p_treeSrcName => null,
640: x_returnStatus => x_returnStatus);

Line 637: p_destroyTrees => fnd_api.g_true,

633: p_orgID => p_orgID,
634: p_wipEntityID => p_jobID,
635: p_initMsgList => fnd_api.g_true,
636: p_endDebug => fnd_api.g_false,
637: p_destroyTrees => fnd_api.g_true,
638: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
639: p_treeSrcName => null,
640: x_returnStatus => x_returnStatus);
641:

Line 646: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN

642: if (l_logLevel <= wip_constants.full_logging) then
643: wip_logger.log(p_msg => 'after wip_autoLotProc_priv.deriveLots',
644: x_returnStatus => l_returnStatus);
645: end if;
646: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
647: raise fnd_api.g_exc_unexpected_error;
648: END IF;
649:
650: -- derive serial for serialized transaction. We can just check p_objectID.

Line 647: raise fnd_api.g_exc_unexpected_error;

643: wip_logger.log(p_msg => 'after wip_autoLotProc_priv.deriveLots',
644: x_returnStatus => l_returnStatus);
645: end if;
646: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
647: raise fnd_api.g_exc_unexpected_error;
648: END IF;
649:
650: -- derive serial for serialized transaction. We can just check p_objectID.
651: -- If p_objectID is -1, don't need to call deriveSerial. Otherwise call

Line 657: p_initMsgList => fnd_api.g_true,

653: IF(p_objectID <> -1) THEN
654: wip_autoSerialProc_priv.deriveSerial(x_compLots => x_compInfo,
655: p_orgID => p_orgID,
656: p_objectID => p_objectID,
657: p_initMsgList => fnd_api.g_true,
658: x_returnStatus => x_returnStatus);
659:
660: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
661: raise fnd_api.g_exc_unexpected_error;

Line 660: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN

656: p_objectID => p_objectID,
657: p_initMsgList => fnd_api.g_true,
658: x_returnStatus => x_returnStatus);
659:
660: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
661: raise fnd_api.g_exc_unexpected_error;
662: END IF;
663: END IF;
664: x_returnStatus := fnd_api.g_ret_sts_success;

Line 661: raise fnd_api.g_exc_unexpected_error;

657: p_initMsgList => fnd_api.g_true,
658: x_returnStatus => x_returnStatus);
659:
660: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
661: raise fnd_api.g_exc_unexpected_error;
662: END IF;
663: END IF;
664: x_returnStatus := fnd_api.g_ret_sts_success;
665: if (l_logLevel <= wip_constants.trace_logging) then

Line 664: x_returnStatus := fnd_api.g_ret_sts_success;

660: IF(x_returnStatus = fnd_api.g_ret_sts_unexp_error) THEN
661: raise fnd_api.g_exc_unexpected_error;
662: END IF;
663: END IF;
664: x_returnStatus := fnd_api.g_ret_sts_success;
665: if (l_logLevel <= wip_constants.trace_logging) then
666: wip_logger.exitPoint(p_procName => 'wma_move.backflush',
667: p_procReturnStatus => x_returnStatus,
668: p_msg => 'procedure complete',

Line 672: WHEN fnd_api.g_exc_unexpected_error THEN

668: p_msg => 'procedure complete',
669: x_returnStatus => l_returnStatus);
670: end if;
671: EXCEPTION
672: WHEN fnd_api.g_exc_unexpected_error THEN
673: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
674: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
675: if (l_logLevel <= wip_constants.trace_logging) then
676: wip_logger.exitPoint(p_procName => 'wma_move.backflush',

Line 673: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

669: x_returnStatus => l_returnStatus);
670: end if;
671: EXCEPTION
672: WHEN fnd_api.g_exc_unexpected_error THEN
673: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
674: x_errMessage := fnd_msg_pub.get(p_encoded => 'F');
675: if (l_logLevel <= wip_constants.trace_logging) then
676: wip_logger.exitPoint(p_procName => 'wma_move.backflush',
677: p_procReturnStatus => x_returnStatus,

Line 682: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

678: p_msg => x_errMessage,
679: x_returnStatus => l_returnStatus);
680: end if;
681: WHEN others THEN
682: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
683: x_errMessage := 'unexpected error: ' || SQLERRM;
684: if (l_logLevel <= wip_constants.trace_logging) then
685: wip_logger.exitPoint(p_procName => 'wma_move.backflush',
686: p_procReturnStatus => x_returnStatus,

Line 1005: x_returnStatus := fnd_api.g_ret_sts_success;

1001:
1002: -- if cannot find last_bf_op mean, no backflush required for this move txn
1003: -- we don't need to set anything
1004:
1005: x_returnStatus := fnd_api.g_ret_sts_success;
1006: if (l_logLevel <= wip_constants.trace_logging) then
1007: wip_logger.exitPoint(p_procName => 'wma_move.assy_pull_bf',
1008: p_procReturnStatus => x_returnStatus,
1009: p_msg => 'procedure complete',

Line 1029: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1025: IF(c_first_bf_op%ISOPEN) THEN
1026: CLOSE c_first_bf_op;
1027: END IF;
1028: x_errMessage := 'unexpected error: ' || SQLERRM;
1029: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1030: if (l_logLevel <= wip_constants.trace_logging) then
1031: wip_logger.exitPoint(p_procName => 'wma_move.assy_pull_bf',
1032: p_procReturnStatus => x_returnStatus,
1033: p_msg => x_errMessage,

Line 1217: x_returnStatus := fnd_api.g_ret_sts_success;

1213:
1214: -- if cannot find last_bf_op mean, no backflush required for this move txn
1215: -- we don't need to set anything
1216:
1217: x_returnStatus := fnd_api.g_ret_sts_success;
1218: if (l_logLevel <= wip_constants.trace_logging) then
1219: wip_logger.exitPoint(p_procName => 'wma_move.bf_require',
1220: p_procReturnStatus => x_returnStatus,
1221: p_msg => 'procedure complete',

Line 1247: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1243: IF(c_scrap_comp%ISOPEN) THEN
1244: CLOSE c_scrap_comp;
1245: END IF;
1246: x_errMessage := 'unexpected error: ' || SQLERRM;
1247: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1248: if (l_logLevel <= wip_constants.trace_logging) then
1249: wip_logger.exitPoint(p_procName => 'wma_move.bf_require',
1250: p_procReturnStatus => x_returnStatus,
1251: p_msg => x_errMessage,

Line 1303: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1299: IF (result = WIP_CONSTANTS.NO) THEN
1300: -- exceed tolerance, set error message
1301: fnd_message.set_name ('WIP', 'WIP_OC_TOLERANCE_FAIL');
1302: x_errMessage := fnd_message.get;
1303: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1304: if (l_logLevel <= wip_constants.trace_logging) then
1305: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1306: p_procReturnStatus => x_returnStatus,
1307: p_msg => x_errMessage,

Line 1332: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1328: IF(l_noMoveCount <> 0)THEN
1329: -- From step has no move shopfloor status
1330: fnd_message.set_name ('WIP', 'WIP_STATUS_NO_TXN1');
1331: x_errMessage := fnd_message.get;
1332: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1333: if (l_logLevel <= wip_constants.trace_logging) then
1334: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1335: p_procReturnStatus => x_returnStatus,
1336: p_msg => x_errMessage,

Line 1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1352: p_to_step => p_toStep) > 0) THEN
1353: -- There is no-move shop floor status in between
1354: fnd_message.set_name ('WIP', 'WIP_NO_MOVE_SF_STATUS_BETWEEN');
1355: x_errMessage := fnd_message.get;
1356: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1357: if (l_logLevel <= wip_constants.trace_logging) then
1358: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1359: p_procReturnStatus => x_returnStatus,
1360: p_msg => x_errMessage,

Line 1378: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1374: p_toStep => p_toStep,
1375: p_userID => p_userID,
1376: x_msg => message,
1377: x_error => x_errMessage) = false) THEN
1378: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1379: if (l_logLevel <= wip_constants.trace_logging) then
1380: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1381: p_procReturnStatus => x_returnStatus,
1382: p_msg => x_errMessage,

Line 1388: x_returnStatus := fnd_api.g_ret_sts_success;

1384: end if;
1385: return;
1386: END IF;
1387: END IF;
1388: x_returnStatus := fnd_api.g_ret_sts_success;
1389: if (l_logLevel <= wip_constants.trace_logging) then
1390: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1391: p_procReturnStatus => x_returnStatus,
1392: p_msg => 'success',

Line 1397: x_returnStatus := fnd_api.g_ret_sts_unexp_error;

1393: x_returnStatus => l_returnStatus);
1394: end if;
1395: EXCEPTION
1396: WHEN others THEN
1397: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1398: x_errMessage := 'unexpected error: ' || SQLERRM;
1399: if (l_logLevel <= wip_constants.trace_logging) then
1400: wip_logger.exitPoint(p_procName => 'wma_move.validate',
1401: p_procReturnStatus => x_returnStatus,