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 WIP_CONSTANTS

Line 24: if (l_logLevel <= wip_constants.trace_logging) then

20: cmpParams wma_completion.CmpParams;
21: l_params wip_logger.param_tbl_t;
22: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
23: BEGIN
24: if (l_logLevel <= wip_constants.trace_logging) then
25: l_params(1).paramName := 'not printing params';
26: l_params(1).paramValue := ' ';
27: wip_logger.entryPoint(p_procName => 'wma_move.process',
28: p_params => l_params,

Line 33: IF(parameters.txnType = WIP_CONSTANTS.COMP_TXN) THEN

29: x_returnStatus => l_returnStatus);
30: end if;
31:
32: status := 0;
33: IF(parameters.txnType = WIP_CONSTANTS.COMP_TXN) THEN
34: -- tell move processor not to process backflush components.
35: -- The last processor should be the one who call Inventory TM.
36: -- In this case it is Completion Processor.
37: l_mtlMode := WIP_CONSTANTS.BACKGROUND;

Line 37: l_mtlMode := WIP_CONSTANTS.BACKGROUND;

33: IF(parameters.txnType = WIP_CONSTANTS.COMP_TXN) THEN
34: -- tell move processor not to process backflush components.
35: -- The last processor should be the one who call Inventory TM.
36: -- In this case it is Completion Processor.
37: l_mtlMode := WIP_CONSTANTS.BACKGROUND;
38: ELSE
39: -- If Move or EZ Return, move processor should be the one who call
40: -- inventory TM because it is the last processor.
41: l_mtlMode := WIP_CONSTANTS.ONLINE;

Line 41: l_mtlMode := WIP_CONSTANTS.ONLINE;

37: l_mtlMode := WIP_CONSTANTS.BACKGROUND;
38: ELSE
39: -- If Move or EZ Return, move processor should be the one who call
40: -- inventory TM because it is the last processor.
41: l_mtlMode := WIP_CONSTANTS.ONLINE;
42: END IF;
43:
44: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE AND
45: parameters.txnType = WIP_CONSTANTS.RET_TXN) THEN

Line 44: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE AND

40: -- inventory TM because it is the last processor.
41: l_mtlMode := WIP_CONSTANTS.ONLINE;
42: END IF;
43:
44: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE AND
45: parameters.txnType = WIP_CONSTANTS.RET_TXN) THEN
46: -- create completionParams structure from moveParams
47: cmpParams.environment := parameters.environment;
48: cmpParams.transactionType := parameters.mtlTxnTypeID;

Line 45: parameters.txnType = WIP_CONSTANTS.RET_TXN) THEN

41: l_mtlMode := WIP_CONSTANTS.ONLINE;
42: END IF;
43:
44: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE AND
45: parameters.txnType = WIP_CONSTANTS.RET_TXN) THEN
46: -- create completionParams structure from moveParams
47: cmpParams.environment := parameters.environment;
48: cmpParams.transactionType := parameters.mtlTxnTypeID;
49: cmpParams.transactionHeaderID := parameters.mtl_header_id;

Line 73: if (l_logLevel <= wip_constants.trace_logging) then

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
74: wip_logger.exitPoint(p_procName => 'wma_move.process',
75: p_procReturnStatus => status,
76: p_msg => errMessage,
77: x_returnStatus => l_returnStatus);

Line 91: if (l_logLevel <= wip_constants.trace_logging) then

87: errMessage => error) = FALSE) THEN
88: -- process error
89: status := -1;
90: errMessage := error;
91: if (l_logLevel <= wip_constants.trace_logging) then
92: wip_logger.exitPoint(p_procName => 'wma_move.process',
93: p_procReturnStatus => status,
94: p_msg => errMessage,
95: x_returnStatus => l_returnStatus);

Line 106: if (l_logLevel <= wip_constants.trace_logging) then

102: errMessage => error) = FALSE ) THEN
103: -- process error
104: status := -1;
105: errMessage := error;
106: if (l_logLevel <= wip_constants.trace_logging) then
107: wip_logger.exitPoint(p_procName => 'wma_move.process',
108: p_procReturnStatus => status,
109: p_msg => errMessage,
110: x_returnStatus => l_returnStatus);

Line 116: IF(parameters.isFromSerializedPage = WIP_CONSTANTS.YES) THEN

112: return;
113: END IF;
114:
115: -- Only call the API's below for serial txns
116: IF(parameters.isFromSerializedPage = WIP_CONSTANTS.YES) THEN
117: -- serial txns, so need to insert record into WIP_SERIAL_MOVE_INTERFACE too
118: IF(insertSerial(groupID => moveRecord.row.group_id,
119: transactionID => moveRecord.row.transaction_id,
120: serialNumber => parameters.serial,

Line 125: if (l_logLevel <= wip_constants.trace_logging) then

121: errMessage => error) = FALSE) THEN
122: -- process error
123: status := -1;
124: errMessage := error;
125: if (l_logLevel <= wip_constants.trace_logging) then
126: wip_logger.exitPoint(p_procName => 'wma_move.process',
127: p_procReturnStatus => status,
128: p_msg => errMessage,
129: x_returnStatus => l_returnStatus);

Line 138: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE) THEN

134:
135: -- If mobile transaction mode is online, call PL/SQL move_processor to
136: -- process record in WMTI. Otherwise stop here, and let the move manager
137: -- to pick the record
138: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE) THEN
139:
140:
141: --move op pull txns to mmtt. This is already be done (and they would already be
142: --processed) if the txn is an easy return.

Line 147: IF(parameters.txnType <> WIP_CONSTANTS.RET_TXN) THEN

143: --note that for an easy cpl record, the assy l/s info is already written, but the
144: --assy record in MTI does not exist. Thus the 'orphaned' l/s info in MSNI/MTLI will
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

Line 162: p_proc_phase => WIP_CONSTANTS.MOVE_PROC,

158: wip_movProc_priv.processIntf
159: (p_group_id => parameters.txnID,
160: p_child_txn_id => parameters.childTxnID,
161: p_mtl_header_id => parameters.mtl_header_id,
162: p_proc_phase => WIP_CONSTANTS.MOVE_PROC,
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,

Line 164: p_move_mode => WIP_CONSTANTS.ONLINE,

160: p_child_txn_id => parameters.childTxnID,
161: p_mtl_header_id => parameters.mtl_header_id,
162: p_proc_phase => WIP_CONSTANTS.MOVE_PROC,
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,

Line 165: p_bf_mode => WIP_CONSTANTS.ONLINE,

161: p_mtl_header_id => parameters.mtl_header_id,
162: p_proc_phase => WIP_CONSTANTS.MOVE_PROC,
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,

Line 182: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE AND

178: END IF;
179:
180: /********************* End doing move ************************/
181:
182: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE AND
183: parameters.txnType = WIP_CONSTANTS.COMP_TXN) THEN
184: -- create completionParams structure from moveParams
185: cmpParams.environment := parameters.environment;
186: cmpParams.transactionType := parameters.mtlTxnTypeID;

Line 183: parameters.txnType = WIP_CONSTANTS.COMP_TXN) THEN

179:
180: /********************* End doing move ************************/
181:
182: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE AND
183: parameters.txnType = WIP_CONSTANTS.COMP_TXN) THEN
184: -- create completionParams structure from moveParams
185: cmpParams.environment := parameters.environment;
186: cmpParams.transactionType := parameters.mtlTxnTypeID;
187: cmpParams.transactionHeaderID := parameters.mtl_header_id;

Line 212: if (l_logLevel <= wip_constants.trace_logging) then

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
213: wip_logger.exitPoint(p_procName => 'wma_move.process',
214: p_procReturnStatus => status,
215: p_msg => errMessage,
216: x_returnStatus => l_returnStatus);

Line 222: if (l_logLevel <= wip_constants.trace_logging) then

218: return;
219: END IF;
220: END IF; -- Easy Complete
221:
222: if (l_logLevel <= wip_constants.trace_logging) then
223: wip_logger.exitPoint(p_procName => 'wma_move.process',
224: p_procReturnStatus => status,
225: p_msg => 'success',
226: x_returnStatus => l_returnStatus);

Line 233: if (l_logLevel <= wip_constants.trace_logging) then

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',
235: p_procReturnStatus => status,
236: p_msg => errMessage,
237: x_returnStatus => l_returnStatus);

Line 245: if (l_logLevel <= wip_constants.trace_logging) then

241: fnd_message.set_name ('WIP', 'GENERIC_ERROR');
242: fnd_message.set_token ('FUNCTION', 'wma_move.process');
243: fnd_message.set_token ('ERROR', SQLCODE || ' ' || SQLERRM);
244: errMessage := fnd_message.get;
245: if (l_logLevel <= wip_constants.trace_logging) then
246: wip_logger.exitPoint(p_procName => 'wma_move.process',
247: p_procReturnStatus => status,
248: p_msg => errMessage,
249: x_returnStatus => l_returnStatus);

Line 291: if (l_logLevel <= wip_constants.trace_logging) then

287: l_params wip_logger.param_tbl_t;
288: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
289:
290: BEGIN
291: if (l_logLevel <= wip_constants.trace_logging) then
292: l_params(1).paramName := 'p_jobID';
293: l_params(1).paramValue := p_jobID;
294: l_params(2).paramName := 'p_orgID';
295: l_params(2).paramValue := p_orgID;

Line 331: IF(p_txnType = WIP_CONSTANTS.COMP_TXN OR

327: WHERE organization_id = p_orgID;
328:
329: l_compTbl := system.wip_component_tbl_t();
330:
331: IF(p_txnType = WIP_CONSTANTS.COMP_TXN OR
332: p_txnType = WIP_CONSTANTS.RET_TXN) THEN -- Easy Complete/Return
333: -- get the last operation to pass to backflush processor
334: SELECT NVL(MAX(operation_seq_num), 1)
335: INTO l_maxOpSeqNum

Line 332: p_txnType = WIP_CONSTANTS.RET_TXN) THEN -- Easy Complete/Return

328:
329: l_compTbl := system.wip_component_tbl_t();
330:
331: IF(p_txnType = WIP_CONSTANTS.COMP_TXN OR
332: p_txnType = WIP_CONSTANTS.RET_TXN) THEN -- Easy Complete/Return
333: -- get the last operation to pass to backflush processor
334: SELECT NVL(MAX(operation_seq_num), 1)
335: INTO l_maxOpSeqNum
336: FROM wip_operations

Line 339: IF(p_txnType = WIP_CONSTANTS.COMP_TXN) THEN

335: INTO l_maxOpSeqNum
336: FROM wip_operations
337: WHERE wip_entity_id = p_jobID;
338:
339: IF(p_txnType = WIP_CONSTANTS.COMP_TXN) THEN
340: l_bf_qty := p_moveQty;
341: ELSIF(p_txnType = WIP_CONSTANTS.RET_TXN) THEN
342: l_bf_qty := -1 * p_moveQty;
343: END IF;

Line 341: ELSIF(p_txnType = WIP_CONSTANTS.RET_TXN) THEN

337: WHERE wip_entity_id = p_jobID;
338:
339: IF(p_txnType = WIP_CONSTANTS.COMP_TXN) THEN
340: l_bf_qty := p_moveQty;
341: ELSIF(p_txnType = WIP_CONSTANTS.RET_TXN) THEN
342: l_bf_qty := -1 * p_moveQty;
343: END IF;
344: -- call backflush processor to insert Assembly Pull components
345: wip_bflProc_priv.processRequirements

Line 347: p_wipEntityType => WIP_CONSTANTS.DISCRETE,

343: END IF;
344: -- call backflush processor to insert Assembly Pull components
345: wip_bflProc_priv.processRequirements
346: (p_wipEntityID => p_jobID,
347: p_wipEntityType => WIP_CONSTANTS.DISCRETE,
348: p_repSchedID => null,
349: p_repLineID => null,
350: p_cplTxnID => p_cmpTxnID,
351: p_movTxnID => null,

Line 355: p_wipSupplyType => WIP_CONSTANTS.ASSY_PULL,

351: p_movTxnID => null,
352: p_orgID => p_orgID,
353: p_assyQty => l_bf_qty,
354: p_txnDate => p_txnDate,
355: p_wipSupplyType => WIP_CONSTANTS.ASSY_PULL,
356: p_txnHdrID => p_txnHdrID,
357: p_firstOp => -1, -- for regular completion
358: p_lastOP => l_maxOpSeqNum,
359: p_firstMoveOp => null,

Line 365: p_mtlTxnMode => wip_constants.online,

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:
369: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 401: p_wipEntityType => WIP_CONSTANTS.DISCRETE,

397:
398: -- Call backflush processor to get operation pull components into l_compTbl
399: wip_bflProc_priv.processRequirements
400: (p_wipEntityID => p_jobID,
401: p_wipEntityType => WIP_CONSTANTS.DISCRETE,
402: p_repSchedID => null,
403: p_repLineID => null,
404: p_cplTxnID => null,
405: p_movTxnID => p_moveID,

Line 409: p_wipSupplyType => WIP_CONSTANTS.OP_PULL,

405: p_movTxnID => p_moveID,
406: p_orgID => p_orgID,
407: p_assyQty => l_bf_qty,
408: p_txnDate => p_txnDate,
409: p_wipSupplyType => WIP_CONSTANTS.OP_PULL,
410: p_txnHdrID => p_txnHdrID,
411: p_firstOp => l_first_bf_op,
412: p_lastOP => l_last_bf_op,
413: p_firstMoveOp => p_fm_op, -- use to check autocharge

Line 419: p_mtlTxnMode => wip_constants.online,

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:
423: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 461: p_wipEntityType => WIP_CONSTANTS.DISCRETE,

457: -- Call backflush processor to get assembly pull components into l_compTbl
458: -- for scrap transactions
459: wip_bflProc_priv.processRequirements
460: (p_wipEntityID => p_jobID,
461: p_wipEntityType => WIP_CONSTANTS.DISCRETE,
462: p_repSchedID => null,
463: p_repLineID => null,
464: p_cplTxnID => null,
465: p_movTxnID => p_moveID,

Line 469: p_wipSupplyType => WIP_CONSTANTS.ASSY_PULL,

465: p_movTxnID => p_moveID,
466: p_orgID => p_orgID,
467: p_assyQty => l_bf_qty,
468: p_txnDate => p_txnDate,
469: p_wipSupplyType => WIP_CONSTANTS.ASSY_PULL,
470: p_txnHdrID => p_txnHdrID,
471: p_firstOp => l_first_bf_op,
472: p_lastOP => l_last_bf_op,
473: p_firstMoveOp => p_fm_op, -- use to check autocharge

Line 479: p_mtlTxnMode => wip_constants.online,

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:
483: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 502: p_fm_step => WIP_CONSTANTS.QUEUE,

498: WHERE wip_entity_id = p_jobID;
499:
500: bf_require(p_jobID => p_jobID,
501: p_fm_op => l_first_op,
502: p_fm_step => WIP_CONSTANTS.QUEUE,
503: p_to_op => p_fm_op,
504: p_to_step => p_fm_step,
505: p_moveQty => p_ocQty,
506: x_first_bf_op => l_first_bf_op,

Line 524: p_wipEntityType => WIP_CONSTANTS.DISCRETE,

520:
521: /* Call backflush processor to get component into l_compTbl*/
522: wip_bflProc_priv.processRequirements
523: (p_wipEntityID => p_jobID,
524: p_wipEntityType => WIP_CONSTANTS.DISCRETE,
525: p_repSchedID => null,
526: p_repLineID => null,
527: p_cplTxnID => null,
528: p_movTxnID => p_childMoveID,

Line 532: p_wipSupplyType => WIP_CONSTANTS.OP_PULL,

528: p_movTxnID => p_childMoveID,
529: p_orgID => p_orgID,
530: p_assyQty => l_bf_qty,
531: p_txnDate => p_txnDate,
532: p_wipSupplyType => WIP_CONSTANTS.OP_PULL,
533: p_txnHdrID => p_txnHdrID,
534: p_firstOp => l_first_bf_op,
535: p_lastOP => l_last_bf_op,
536: p_firstMoveOp => p_fm_op, -- use to check autocharge

Line 542: p_mtlTxnMode => wip_constants.online,

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:
546: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 561: p_fm_step => WIP_CONSTANTS.QUEUE,

557: l_last_bf_op := -1;
558:
559: assy_pull_bf(p_jobID => p_jobID,
560: p_fm_op => l_first_op,
561: p_fm_step => WIP_CONSTANTS.QUEUE,
562: p_to_op => p_fm_op,
563: p_to_step => p_fm_step,
564: p_moveQty => p_ocQty,
565: x_first_bf_op => l_first_bf_op,

Line 584: p_wipEntityType => WIP_CONSTANTS.DISCRETE,

580: -- Call backflush processor to get assembly pull components into
581: -- l_compTbl for scrap transactions
582: wip_bflProc_priv.processRequirements
583: (p_wipEntityID => p_jobID,
584: p_wipEntityType => WIP_CONSTANTS.DISCRETE,
585: p_repSchedID => null,
586: p_repLineID => null,
587: p_cplTxnID => null,
588: p_movTxnID => p_childMoveID,

Line 592: p_wipSupplyType => WIP_CONSTANTS.ASSY_PULL,

588: p_movTxnID => p_childMoveID,
589: p_orgID => p_orgID,
590: p_assyQty => l_bf_qty,
591: p_txnDate => p_txnDate,
592: p_wipSupplyType => WIP_CONSTANTS.ASSY_PULL,
593: p_txnHdrID => p_txnHdrID,
594: p_firstOp => l_first_bf_op,
595: p_lastOP => l_last_bf_op,
596: p_firstMoveOp => p_fm_op, -- use to check autocharge

Line 602: p_mtlTxnMode => wip_constants.online,

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:
606: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 612: if (l_logLevel <= wip_constants.full_logging) then

608: END IF;
609: END IF; -- l_first_bf_op <> -1
610:
611: END IF; -- end over move transaction
612: if (l_logLevel <= wip_constants.full_logging) then
613: wip_logger.log(p_msg => 'before system.wip_lot_serial_obj_t',
614: x_returnStatus => l_returnStatus);
615: end if;
616: x_compInfo := system.wip_lot_serial_obj_t(null, null, null, l_compTbl,

Line 618: if (l_logLevel <= wip_constants.full_logging) then

614: x_returnStatus => l_returnStatus);
615: end if;
616: x_compInfo := system.wip_lot_serial_obj_t(null, null, null, l_compTbl,
617: null, null);
618: if (l_logLevel <= wip_constants.full_logging) then
619: wip_logger.log(p_msg => 'after system.wip_lot_serial_obj_t',
620: x_returnStatus => l_returnStatus);
621: end if;
622: x_compInfo.initialize;

Line 623: if (l_logLevel <= wip_constants.full_logging) then

619: wip_logger.log(p_msg => 'after system.wip_lot_serial_obj_t',
620: x_returnStatus => l_returnStatus);
621: end if;
622: x_compInfo.initialize;
623: if (l_logLevel <= wip_constants.full_logging) then
624: wip_logger.log(p_msg => 'after x_compInfo.initialize',
625: x_returnStatus => l_returnStatus);
626: end if;
627: -- derive lot if the component under lot control, if return status

Line 642: if (l_logLevel <= wip_constants.full_logging) then

638: p_treeMode => inv_quantity_tree_pvt.g_reservation_mode,
639: p_treeSrcName => null,
640: x_returnStatus => x_returnStatus);
641:
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

Line 665: if (l_logLevel <= wip_constants.trace_logging) 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',
669: x_returnStatus => l_returnStatus);

Line 675: if (l_logLevel <= wip_constants.trace_logging) then

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,
678: p_msg => x_errMessage,
679: x_returnStatus => l_returnStatus);

Line 684: if (l_logLevel <= wip_constants.trace_logging) then

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,
687: p_msg => x_errMessage,
688: x_returnStatus => l_returnStatus);

Line 741: if(parameters.txnMode = WIP_CONSTANTS.BACKGROUND AND

737: errMessage := fnd_message.get;
738: return false;
739: end if;
740:
741: if(parameters.txnMode = WIP_CONSTANTS.BACKGROUND AND
742: (parameters.txnType = WIP_CONSTANTS.RET_TXN OR
743: parameters.txnType = WIP_CONSTANTS.COMP_TXN)) then
744: -- Only check revision for background transaction because we skip
745: -- validation code if mobile insert record into WMTI. For online txns

Line 742: (parameters.txnType = WIP_CONSTANTS.RET_TXN OR

738: return false;
739: end if;
740:
741: if(parameters.txnMode = WIP_CONSTANTS.BACKGROUND AND
742: (parameters.txnType = WIP_CONSTANTS.RET_TXN OR
743: parameters.txnType = WIP_CONSTANTS.COMP_TXN)) then
744: -- Only check revision for background transaction because we skip
745: -- validation code if mobile insert record into WMTI. For online txns
746: -- wma_completion.derive will validate the revision before insert into MMTT

Line 743: parameters.txnType = WIP_CONSTANTS.COMP_TXN)) then

739: end if;
740:
741: if(parameters.txnMode = WIP_CONSTANTS.BACKGROUND AND
742: (parameters.txnType = WIP_CONSTANTS.RET_TXN OR
743: parameters.txnType = WIP_CONSTANTS.COMP_TXN)) then
744: -- Only check revision for background transaction because we skip
745: -- validation code if mobile insert record into WMTI. For online txns
746: -- wma_completion.derive will validate the revision before insert into MMTT
747:

Line 759: if (item.revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED) then

755: return false;
756: end if;
757:
758: -- get the item revision
759: if (item.revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED) then
760: if(NOT wma_completion.getRevision(
761: wipEntityID => parameters.wipEntityID,
762: orgID => parameters.environment.orgID,
763: itemID => parameters.itemID,

Line 768: end if; -- revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED

764: revision => l_revision)) then
765: errMessage := substr(fnd_message.get,1,241);
766: return false;
767: end if; -- getRevision
768: end if; -- revQtyControlCode = WIP_CONSTANTS.REVISION_CONTROLLED
769: end if; -- Background transaction
770:
771: -- derive the accounting period stuff by calling inv routine
772: invttmtx.tdatechk(

Line 814: IF (l_logLevel <= wip_constants.full_logging) THEN

810: p_operation_exists => toOpExists);
811:
812: -- now derive the rest of the mandatory fields in the MoveTxnRec
813: IF(parameters.txnID = NULL) THEN
814: IF (l_logLevel <= wip_constants.full_logging) THEN
815: wip_logger.log(p_msg => 'before wma_derive.getNextVal',
816: x_returnStatus => l_returnStatus);
817: END IF;
818: moveRecord.row.transaction_id := wma_derive.getNextVal

Line 820: IF (l_logLevel <= wip_constants.full_logging) THEN

816: x_returnStatus => l_returnStatus);
817: END IF;
818: moveRecord.row.transaction_id := wma_derive.getNextVal
819: ('wip_transactions_s');
820: IF (l_logLevel <= wip_constants.full_logging) THEN
821: wip_logger.log(p_msg => 'after wma_derive.getNextVal',
822: x_returnStatus => l_returnStatus);
823: END IF;
824: ELSE

Line 828: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE) THEN

824: ELSE
825: moveRecord.row.transaction_id := parameters.txnID;
826: END IF;
827:
828: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE) THEN
829: moveRecord.row.process_status := WIP_CONSTANTS.RUNNING;
830: moveRecord.row.group_id := moveRecord.row.transaction_id;
831: ELSE -- background
832: moveRecord.row.process_status := WIP_CONSTANTS.PENDING;

Line 829: moveRecord.row.process_status := WIP_CONSTANTS.RUNNING;

825: moveRecord.row.transaction_id := parameters.txnID;
826: END IF;
827:
828: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE) THEN
829: moveRecord.row.process_status := WIP_CONSTANTS.RUNNING;
830: moveRecord.row.group_id := moveRecord.row.transaction_id;
831: ELSE -- background
832: moveRecord.row.process_status := WIP_CONSTANTS.PENDING;
833: moveRecord.row.group_id := NULL;

Line 832: moveRecord.row.process_status := WIP_CONSTANTS.PENDING;

828: IF(parameters.txnMode = WIP_CONSTANTS.ONLINE) THEN
829: moveRecord.row.process_status := WIP_CONSTANTS.RUNNING;
830: moveRecord.row.group_id := moveRecord.row.transaction_id;
831: ELSE -- background
832: moveRecord.row.process_status := WIP_CONSTANTS.PENDING;
833: moveRecord.row.group_id := NULL;
834: END IF;
835: moveRecord.row.last_update_date := sysdate;
836: moveRecord.row.last_updated_by := parameters.environment.userID;

Line 841: moveRecord.row.process_phase := WIP_CONSTANTS.MOVE_PROC;

837: moveRecord.row.last_updated_by_name := parameters.environment.userName;
838: moveRecord.row.creation_date := sysdate;
839: moveRecord.row.created_by := parameters.environment.userID;
840: moveRecord.row.created_by_name := parameters.environment.userName;
841: moveRecord.row.process_phase := WIP_CONSTANTS.MOVE_PROC;
842:
843: moveRecord.row.transaction_type := parameters.txnType;
844: moveRecord.row.organization_id := parameters.environment.orgID;
845: moveRecord.row.organization_code := parameters.environment.orgCode;

Line 848: moveRecord.row.entity_type := WIP_CONSTANTS.DISCRETE; --only support discrete now

844: moveRecord.row.organization_id := parameters.environment.orgID;
845: moveRecord.row.organization_code := parameters.environment.orgCode;
846: moveRecord.row.wip_entity_id := parameters.wipEntityID;
847: moveRecord.row.wip_entity_name := parameters.wipEntityName;
848: moveRecord.row.entity_type := WIP_CONSTANTS.DISCRETE; --only support discrete now
849: moveRecord.row.primary_item_id := parameters.itemID;
850: moveRecord.row.line_id := job.lineID;
851: moveRecord.row.line_code := job.lineCode;
852: moveRecord.row.transaction_date := sysdate;

Line 874: IF(parameters.isFromSerializedPage = WIP_CONSTANTS.YES) THEN

870: moveRecord.row.qa_collection_id := parameters.qualityID;
871: moveRecord.row.overcompletion_transaction_qty := parameters.overcompleteQty;
872: moveRecord.row.overcompletion_primary_qty := parameters.overcompleteQty;
873: -- insert different source_code for serialized transactions
874: IF(parameters.isFromSerializedPage = WIP_CONSTANTS.YES) THEN
875: moveRecord.row.source_code := WMA_COMMON.SERIALIZATION_SOURCE_CODE;
876: ELSE
877: moveRecord.row.source_code := WMA_COMMON.SOURCE_CODE;
878: END IF;

Line 925: SIGN(p_to_step - WIP_CONSTANTS.SCRAP),

921: CURSOR c_last_bf_op IS
922:
923: SELECT p_moveQty *
924: DECODE(
925: SIGN(p_to_step - WIP_CONSTANTS.SCRAP),
926: 0, DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),
927: 0, DECODE(SIGN(p_to_op - p_fm_op),
928: 1,1,
929: -1,-1),

Line 926: 0, DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),

922:
923: SELECT p_moveQty *
924: DECODE(
925: SIGN(p_to_step - WIP_CONSTANTS.SCRAP),
926: 0, DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),
927: 0, DECODE(SIGN(p_to_op - p_fm_op),
928: 1,1,
929: -1,-1),
930: -1, 1),

Line 931: -1, DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),

927: 0, DECODE(SIGN(p_to_op - p_fm_op),
928: 1,1,
929: -1,-1),
930: -1, 1),
931: -1, DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),
932: 0, -1)) txn_qty,
933: MAX(wop.operation_seq_num) last_op
934: FROM wip_operations wop
935: WHERE wop.wip_entity_id = p_jobID

Line 937: p_fm_step = WIP_CONSTANTS.SCRAP)

933: MAX(wop.operation_seq_num) last_op
934: FROM wip_operations wop
935: WHERE wop.wip_entity_id = p_jobID
936: AND ((wop.operation_seq_num = p_fm_op AND
937: p_fm_step = WIP_CONSTANTS.SCRAP)
938: OR
939: (wop.operation_seq_num = p_to_op AND
940: p_to_step = WIP_CONSTANTS.SCRAP)
941: );

Line 940: p_to_step = WIP_CONSTANTS.SCRAP)

936: AND ((wop.operation_seq_num = p_fm_op AND
937: p_fm_step = WIP_CONSTANTS.SCRAP)
938: OR
939: (wop.operation_seq_num = p_to_op AND
940: p_to_step = WIP_CONSTANTS.SCRAP)
941: );
942:
943: CURSOR c_first_bf_op IS
944:

Line 949: DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),

945: SELECT MIN(wop.operation_seq_num) first_op
946: FROM wip_operations wop
947: WHERE wop.wip_entity_id = p_jobID
948: AND wop.operation_seq_num >
949: DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),
950: 0, DECODE(SIGN(p_to_step - WIP_CONSTANTS.SCRAP),
951: 0, DECODE(SIGN(p_to_op - p_fm_op),
952: 1, p_fm_op,
953: p_to_op),

Line 950: 0, DECODE(SIGN(p_to_step - WIP_CONSTANTS.SCRAP),

946: FROM wip_operations wop
947: WHERE wop.wip_entity_id = p_jobID
948: AND wop.operation_seq_num >
949: DECODE(SIGN(p_fm_step - WIP_CONSTANTS.SCRAP),
950: 0, DECODE(SIGN(p_to_step - WIP_CONSTANTS.SCRAP),
951: 0, DECODE(SIGN(p_to_op - p_fm_op),
952: 1, p_fm_op,
953: p_to_op),
954: 0),

Line 964: if (l_logLevel <= wip_constants.trace_logging) then

960: l_first_op NUMBER;
961: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
962:
963: BEGIN
964: if (l_logLevel <= wip_constants.trace_logging) then
965: l_params(1).paramName := 'p_jobID';
966: l_params(1).paramValue := p_jobID;
967: l_params(2).paramName := 'p_fm_op';
968: l_params(2).paramValue := p_fm_op;

Line 1006: if (l_logLevel <= wip_constants.trace_logging) then

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',
1010: x_returnStatus => l_returnStatus);

Line 1030: if (l_logLevel <= wip_constants.trace_logging) 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,
1034: x_returnStatus => l_returnStatus);

Line 1088: - WIP_CONSTANTS.RUN),

1084: 1, p_to_step,
1085: 0, DECODE(SIGN(p_to_step - p_fm_step),
1086: 1, p_to_step,
1087: p_fm_step))
1088: - WIP_CONSTANTS.RUN),
1089: 1, DECODE(SIGN(p_to_op - p_fm_op), -1, p_fm_op, p_to_op)
1090: + 0.0000001,
1091: DECODE(SIGN(p_to_op - p_fm_op), -1, p_fm_op, p_to_op))
1092: > wop.operation_seq_num

Line 1096: AND (wop.backflush_flag = WIP_CONSTANTS.YES

1092: > wop.operation_seq_num
1093: AND wop.operation_seq_num >= DECODE(SIGN(p_to_op - p_fm_op),
1094: -1, p_to_op,
1095: p_fm_op)
1096: AND (wop.backflush_flag = WIP_CONSTANTS.YES
1097: OR
1098: (wop.operation_seq_num = p_fm_op AND
1099: p_fm_step = WIP_CONSTANTS.SCRAP)
1100: OR

Line 1099: p_fm_step = WIP_CONSTANTS.SCRAP)

1095: p_fm_op)
1096: AND (wop.backflush_flag = WIP_CONSTANTS.YES
1097: OR
1098: (wop.operation_seq_num = p_fm_op AND
1099: p_fm_step = WIP_CONSTANTS.SCRAP)
1100: OR
1101: (wop.operation_seq_num = p_to_op AND
1102: p_to_step = WIP_CONSTANTS.SCRAP));
1103:

Line 1102: p_to_step = WIP_CONSTANTS.SCRAP));

1098: (wop.operation_seq_num = p_fm_op AND
1099: p_fm_step = WIP_CONSTANTS.SCRAP)
1100: OR
1101: (wop.operation_seq_num = p_to_op AND
1102: p_to_step = WIP_CONSTANTS.SCRAP));
1103:
1104: CURSOR c_first_bf_op IS
1105:
1106: SELECT MIN(wop.operation_seq_num) first_op

Line 1119: - WIP_CONSTANTS.RUN),

1115: 1, p_fm_step,
1116: 0, DECODE(SIGN(p_to_step - p_fm_step),
1117: 1, p_fm_step,
1118: p_to_step))
1119: - WIP_CONSTANTS.RUN),
1120: 1, DECODE(SIGN(p_to_op - p_fm_op), -1,p_to_op, p_fm_op)
1121: + 0.0000001,
1122: DECODE(SIGN(p_to_op - p_fm_op), -1, p_to_op,p_fm_op))
1123: > wop1.operation_seq_num

Line 1124: AND (wop1.backflush_flag = WIP_CONSTANTS.YES

1120: 1, DECODE(SIGN(p_to_op - p_fm_op), -1,p_to_op, p_fm_op)
1121: + 0.0000001,
1122: DECODE(SIGN(p_to_op - p_fm_op), -1, p_to_op,p_fm_op))
1123: > wop1.operation_seq_num
1124: AND (wop1.backflush_flag = WIP_CONSTANTS.YES
1125: OR
1126: (p_to_op > p_fm_op AND
1127: wop1.operation_seq_num = p_fm_op AND
1128: p_fm_step = WIP_CONSTANTS.SCRAP)

Line 1128: p_fm_step = WIP_CONSTANTS.SCRAP)

1124: AND (wop1.backflush_flag = WIP_CONSTANTS.YES
1125: OR
1126: (p_to_op > p_fm_op AND
1127: wop1.operation_seq_num = p_fm_op AND
1128: p_fm_step = WIP_CONSTANTS.SCRAP)
1129: OR
1130: (p_to_op < p_fm_op AND
1131: wop1.operation_seq_num = p_to_op AND
1132: p_to_step = WIP_CONSTANTS.SCRAP)));

Line 1132: p_to_step = WIP_CONSTANTS.SCRAP)));

1128: p_fm_step = WIP_CONSTANTS.SCRAP)
1129: OR
1130: (p_to_op < p_fm_op AND
1131: wop1.operation_seq_num = p_to_op AND
1132: p_to_step = WIP_CONSTANTS.SCRAP)));
1133:
1134: CURSOR c_scrap_comp IS
1135:
1136: SELECT MIN(wop.operation_seq_num) first_op,

Line 1146: AND p_to_step = WIP_CONSTANTS.SCRAP

1142: (SELECT NVL(MAX(wop1.operation_seq_num),0)
1143: FROM wip_operations wop1
1144: WHERE wop1.wip_entity_id = p_jobID
1145: AND p_fm_op > p_to_op
1146: AND p_to_step = WIP_CONSTANTS.SCRAP
1147: AND p_to_op >= wop1.operation_seq_num
1148: AND (wop1.backflush_flag = WIP_CONSTANTS.YES));
1149:
1150: l_last_bf_op c_last_bf_op%ROWTYPE;

Line 1148: AND (wop1.backflush_flag = WIP_CONSTANTS.YES));

1144: WHERE wop1.wip_entity_id = p_jobID
1145: AND p_fm_op > p_to_op
1146: AND p_to_step = WIP_CONSTANTS.SCRAP
1147: AND p_to_op >= wop1.operation_seq_num
1148: AND (wop1.backflush_flag = WIP_CONSTANTS.YES));
1149:
1150: l_last_bf_op c_last_bf_op%ROWTYPE;
1151: l_scrap_comp c_scrap_comp%ROWTYPE;
1152: l_params wip_logger.param_tbl_t;

Line 1172: if (l_logLevel <= wip_constants.trace_logging) then

1168: l_params(6).paramName := 'p_moveQty';
1169: l_params(6).paramValue := p_moveQty;
1170:
1171: -- write parameter value to log file
1172: if (l_logLevel <= wip_constants.trace_logging) then
1173: wip_logger.entryPoint(p_procName =>'wma_move.bf_require',
1174: p_params => l_params,
1175: x_returnStatus => l_returnStatus);
1176: end if;

Line 1198: IF(p_to_op <> p_fm_op AND p_to_step = WIP_CONSTANTS.SCRAP) THEN

1194: x_bf_qty := l_last_bf_op.txn_qty;
1195: ELSE
1196: -- only do this for backward move to scrap transactions. We need to issue
1197: -- all operation pull component upto scrap operations.
1198: IF(p_to_op <> p_fm_op AND p_to_step = WIP_CONSTANTS.SCRAP) THEN
1199: OPEN c_scrap_comp;
1200: LOOP
1201: FETCH c_scrap_comp INTO l_scrap_comp;
1202: EXIT WHEN c_scrap_comp%NOTFOUND;

Line 1218: if (l_logLevel <= wip_constants.trace_logging) then

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',
1222: x_returnStatus => l_returnStatus);

Line 1248: if (l_logLevel <= wip_constants.trace_logging) 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,
1252: x_returnStatus => l_returnStatus);

Line 1283: if (l_logLevel <= wip_constants.trace_logging) then

1279: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
1280: -- Fixed bug 5252677
1281: l_noMoveCount NUMBER;
1282: BEGIN
1283: if (l_logLevel <= wip_constants.trace_logging) then
1284: l_params(1).paramName := 'not printing params';
1285: l_params(1).paramValue := ' ';
1286: wip_logger.entryPoint(p_procName => 'wma_move.validate',
1287: p_params => l_params,

Line 1299: IF (result = WIP_CONSTANTS.NO) THEN

1295: p_wip_entity_id => p_jobID,
1296: p_primary_quantity => p_overcomplQty,
1297: p_result => result);
1298:
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;

Line 1304: if (l_logLevel <= wip_constants.trace_logging) 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,
1308: x_returnStatus => l_returnStatus);

Line 1325: AND wsc.status_move_flag = WIP_CONSTANTS.NO

1321: AND ws.wip_entity_id = p_jobID
1322: AND ws.operation_seq_num = p_fmOp
1323: AND ws.intraoperation_step_type = p_fmStep
1324: AND ws.shop_floor_status_code = wsc.shop_floor_status_code
1325: AND wsc.status_move_flag = WIP_CONSTANTS.NO
1326: AND NVL(wsc.disable_date, SYSDATE + 1) > SYSDATE;
1327:
1328: IF(l_noMoveCount <> 0)THEN
1329: -- From step has no move shopfloor status

Line 1333: if (l_logLevel <= wip_constants.trace_logging) 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,
1337: x_returnStatus => l_returnStatus);

Line 1357: if (l_logLevel <= wip_constants.trace_logging) 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,
1361: x_returnStatus => l_returnStatus);

Line 1367: p_toStep = WIP_CONSTANTS.QUEUE) THEN

1363: return;
1364: END IF;-- Check no move shopfloor statuses between the from and to
1365:
1366: IF(p_fmOp < p_toOp AND
1367: p_toStep = WIP_CONSTANTS.QUEUE) THEN
1368: -- check osp related validation
1369: IF (wip_osp.checkOSP(p_orgID => p_orgID,
1370: p_wipEntityID => p_jobID,
1371: p_entityType => 1, -- Discrete

Line 1379: if (l_logLevel <= wip_constants.trace_logging) then

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,
1383: x_returnStatus => l_returnStatus);

Line 1389: if (l_logLevel <= wip_constants.trace_logging) then

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',
1393: x_returnStatus => l_returnStatus);

Line 1399: if (l_logLevel <= wip_constants.trace_logging) then

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,
1402: p_msg => x_errMessage,
1403: x_returnStatus => l_returnStatus);