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.WIP_MOVPROC_GRP dependencies on WIP_CONSTANTS

Line 27: p_entityType => WIP_CONSTANTS.LOTBASED,

23: p_primaryQty => p_primaryQty,
24: p_txnDate => p_txnDate,
25: p_txnHdrID => p_txnHdrID,
26: p_txnType => p_txnType,
27: p_entityType => WIP_CONSTANTS.LOTBASED,
28: p_fmOp => p_fmOp,
29: p_fmStep => p_fmStep,
30: p_toOp => p_toOp,
31: p_toStep => p_toStep,

Line 69: p_entityType => WIP_CONSTANTS.LOTBASED,

65: p_txnHdrID => p_txnHdrID,
66: -- Fixed bug 5056289. Populate batch_id with move_id instead of header_id.
67: p_batchID => p_movTxnID,
68: p_txnType => p_txnType,
69: p_entityType => WIP_CONSTANTS.LOTBASED,
70: p_tblName => WIP_CONSTANTS.MMTT_TBL,
71: p_fmOp => p_fmOp,
72: p_fmStep => p_fmStep,
73: p_toOp => p_toOp,

Line 70: p_tblName => WIP_CONSTANTS.MMTT_TBL,

66: -- Fixed bug 5056289. Populate batch_id with move_id instead of header_id.
67: p_batchID => p_movTxnID,
68: p_txnType => p_txnType,
69: p_entityType => WIP_CONSTANTS.LOTBASED,
70: p_tblName => WIP_CONSTANTS.MMTT_TBL,
71: p_fmOp => p_fmOp,
72: p_fmStep => p_fmStep,
73: p_toOp => p_toOp,
74: p_toStep => p_toStep,

Line 114: p_entityType => WIP_CONSTANTS.LOTBASED,

110: p_txnHdrID => p_txnHdrID,
111: -- Fixed bug 5056289. Populate batch_id with move_id instead of header_id.
112: p_batchID => p_movTxnID,
113: p_txnType => p_txnType,
114: p_entityType => WIP_CONSTANTS.LOTBASED,
115: p_tblName => WIP_CONSTANTS.MTI_TBL,
116: p_fmOp => p_fmOp,
117: p_fmStep => p_fmStep,
118: p_toOp => p_toOp,

Line 115: p_tblName => WIP_CONSTANTS.MTI_TBL,

111: -- Fixed bug 5056289. Populate batch_id with move_id instead of header_id.
112: p_batchID => p_movTxnID,
113: p_txnType => p_txnType,
114: p_entityType => WIP_CONSTANTS.LOTBASED,
115: p_tblName => WIP_CONSTANTS.MTI_TBL,
116: p_fmOp => p_fmOp,
117: p_fmStep => p_fmStep,
118: p_toOp => p_toOp,
119: p_toStep => p_toStep,

Line 157: IF(l_logLevel <= WIP_CONSTANTS.TRACE_LOGGING) THEN

153: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
154: l_errors c_errors%ROWTYPE;
155: BEGIN
156:
157: IF(l_logLevel <= WIP_CONSTANTS.TRACE_LOGGING) THEN
158: l_params(1).paramName := 'p_movTxnID';
159: l_params(1).paramValue := p_movTxnID;
160: l_params(2).paramName := 'p_procPhase';
161: l_params(2).paramValue := p_procPhase;

Line 182: AND process_status = WIP_CONSTANTS.RUNNING

178: INTO l_groupID
179: FROM wip_move_txn_interface
180: WHERE transaction_id = p_movTxnID
181: AND process_phase = p_procPhase
182: AND process_status = WIP_CONSTANTS.RUNNING
183: AND group_id IS NOT NULL;
184:
185: IF(p_procPhase = WIP_CONSTANTS.MOVE_VAL) THEN
186: l_move_mode := WIP_CONSTANTS.BACKGROUND;

Line 185: IF(p_procPhase = WIP_CONSTANTS.MOVE_VAL) THEN

181: AND process_phase = p_procPhase
182: AND process_status = WIP_CONSTANTS.RUNNING
183: AND group_id IS NOT NULL;
184:
185: IF(p_procPhase = WIP_CONSTANTS.MOVE_VAL) THEN
186: l_move_mode := WIP_CONSTANTS.BACKGROUND;
187: ELSE
188: l_move_mode := WIP_CONSTANTS.ONLINE;
189: END IF;

Line 186: l_move_mode := WIP_CONSTANTS.BACKGROUND;

182: AND process_status = WIP_CONSTANTS.RUNNING
183: AND group_id IS NOT NULL;
184:
185: IF(p_procPhase = WIP_CONSTANTS.MOVE_VAL) THEN
186: l_move_mode := WIP_CONSTANTS.BACKGROUND;
187: ELSE
188: l_move_mode := WIP_CONSTANTS.ONLINE;
189: END IF;
190:

Line 188: l_move_mode := WIP_CONSTANTS.ONLINE;

184:
185: IF(p_procPhase = WIP_CONSTANTS.MOVE_VAL) THEN
186: l_move_mode := WIP_CONSTANTS.BACKGROUND;
187: ELSE
188: l_move_mode := WIP_CONSTANTS.ONLINE;
189: END IF;
190:
191: wip_movProc_priv.processIntf(p_group_id => l_groupID,
192: p_child_txn_id => -1,

Line 197: p_bf_mode => WIP_CONSTANTS.ONLINE,

193: p_mtl_header_id => p_txnHdrID,
194: p_proc_phase => p_procPhase,
195: p_time_out => 0,
196: p_move_mode => l_move_mode,
197: p_bf_mode => WIP_CONSTANTS.ONLINE,
198: p_mtl_mode => p_mtlMode,
199: p_endDebug => fnd_api.g_false,
200: p_initMsgList => fnd_api.g_true,
201: p_insertAssy => fnd_api.g_true,

Line 214: IF (l_logLevel <= wip_constants.trace_logging) THEN

210: IF(fnd_api.to_boolean(p_commit)) THEN
211: COMMIT;
212: END IF;
213:
214: IF (l_logLevel <= wip_constants.trace_logging) THEN
215: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
216: p_procReturnStatus => x_returnStatus,
217: p_msg => 'procedure complete',
218: x_returnStatus => l_returnStatus);

Line 225: IF(l_move_mode = WIP_CONSTANTS.BACKGROUND) THEN

221: EXCEPTION
222: WHEN fnd_api.g_exc_error THEN
223: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
224:
225: IF(l_move_mode = WIP_CONSTANTS.BACKGROUND) THEN
226: FOR l_errors IN c_errors(p_transaction_id => p_movTxnID) LOOP
227: x_errorMsg := x_errorMsg || l_errors.error_column ||':' ||
228: l_errors.error_message || '; ';
229: END LOOP;

Line 236: IF (l_logLevel <= wip_constants.trace_logging) THEN

232: -- get error message from message stack
233: inv_mobile_helper_functions.get_stacked_messages(x_errorMsg);
234: END IF;
235:
236: IF (l_logLevel <= wip_constants.trace_logging) THEN
237: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
238: p_procReturnStatus => x_returnStatus,
239: p_msg => 'wip_movProc_priv.processIntf failed',
240: x_returnStatus => l_returnStatus);

Line 250: IF (l_logLevel <= wip_constants.trace_logging) THEN

246: fnd_message.set_name('WIP', 'WIP_NOT_VALID');
247: fnd_message.set_token('ENTITY', 'TRANSACTION_ID');
248: x_errorMsg := substr(fnd_message.get, 1, 1000);
249:
250: IF (l_logLevel <= wip_constants.trace_logging) THEN
251: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
252: p_procReturnStatus => x_returnStatus,
253: p_msg => 'to many rows: ' || SQLERRM,
254: x_returnStatus => l_returnStatus);

Line 265: IF (l_logLevel <= wip_constants.trace_logging) THEN

261: fnd_message.set_token('ENTITY',
262: 'TRANSACTION_ID/GROUP_ID/PROCESS_PHASE/PROCESS_STATUS');
263: x_errorMsg := substr(fnd_message.get, 1, 1000);
264:
265: IF (l_logLevel <= wip_constants.trace_logging) THEN
266: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
267: p_procReturnStatus => x_returnStatus,
268: p_msg => 'no data found: ' || SQLERRM,
269: x_returnStatus => l_returnStatus);

Line 276: IF (l_logLevel <= wip_constants.trace_logging) THEN

272:
273: WHEN others THEN
274: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
275: x_errorMsg := 'unexpected error: ' || SQLERRM || 'SQLCODE = ' || SQLCODE;
276: IF (l_logLevel <= wip_constants.trace_logging) THEN
277: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
278: p_procReturnStatus => x_returnStatus,
279: p_msg => x_errorMsg,
280: x_returnStatus => l_returnStatus);

Line 299: IF(l_logLevel <= WIP_CONSTANTS.TRACE_LOGGING) THEN

295: l_groupID NUMBER;
296: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
297: BEGIN
298:
299: IF(l_logLevel <= WIP_CONSTANTS.TRACE_LOGGING) THEN
300: l_params(1).paramName := 'p_groupID';
301: l_params(1).paramValue := p_groupID;
302: l_params(2).paramName := 'p_commit';
303: l_params(2).paramValue := p_commit;

Line 313: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,

309:
310: wip_movProc_priv.processIntf(p_group_id => p_groupID,
311: p_child_txn_id => -1,
312: p_mtl_header_id => -1,
313: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
314: p_time_out => 0,
315: p_move_mode => WIP_CONSTANTS.BACKGROUND,
316: p_bf_mode => WIP_CONSTANTS.ONLINE,
317: p_mtl_mode => WIP_CONSTANTS.ONLINE,

Line 315: p_move_mode => WIP_CONSTANTS.BACKGROUND,

311: p_child_txn_id => -1,
312: p_mtl_header_id => -1,
313: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
314: p_time_out => 0,
315: p_move_mode => WIP_CONSTANTS.BACKGROUND,
316: p_bf_mode => WIP_CONSTANTS.ONLINE,
317: p_mtl_mode => WIP_CONSTANTS.ONLINE,
318: p_endDebug => fnd_api.g_false,
319: p_initMsgList => fnd_api.g_true,

Line 316: p_bf_mode => WIP_CONSTANTS.ONLINE,

312: p_mtl_header_id => -1,
313: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
314: p_time_out => 0,
315: p_move_mode => WIP_CONSTANTS.BACKGROUND,
316: p_bf_mode => WIP_CONSTANTS.ONLINE,
317: p_mtl_mode => WIP_CONSTANTS.ONLINE,
318: p_endDebug => fnd_api.g_false,
319: p_initMsgList => fnd_api.g_true,
320: p_insertAssy => fnd_api.g_true,

Line 317: p_mtl_mode => WIP_CONSTANTS.ONLINE,

313: p_proc_phase => WIP_CONSTANTS.MOVE_VAL,
314: p_time_out => 0,
315: p_move_mode => WIP_CONSTANTS.BACKGROUND,
316: p_bf_mode => WIP_CONSTANTS.ONLINE,
317: p_mtl_mode => WIP_CONSTANTS.ONLINE,
318: p_endDebug => fnd_api.g_false,
319: p_initMsgList => fnd_api.g_true,
320: p_insertAssy => fnd_api.g_true,
321: p_do_backflush => fnd_api.g_true,

Line 332: IF (l_logLevel <= wip_constants.trace_logging) THEN

328: IF(fnd_api.to_boolean(p_commit)) THEN
329: COMMIT;
330: END IF;
331:
332: IF (l_logLevel <= wip_constants.trace_logging) THEN
333: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
334: p_procReturnStatus => x_returnStatus,
335: p_msg => 'no record in this group error out',
336: x_returnStatus => l_returnStatus);

Line 344: IF (l_logLevel <= wip_constants.trace_logging) THEN

340:
341: WHEN fnd_api.g_exc_error THEN
342: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
343:
344: IF (l_logLevel <= wip_constants.trace_logging) THEN
345: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
346: p_procReturnStatus => x_returnStatus,
347: p_msg => 'some records in this group error out',
348: x_returnStatus => l_returnStatus);

Line 355: IF (l_logLevel <= wip_constants.trace_logging) THEN

351:
352: WHEN others THEN
353: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
354:
355: IF (l_logLevel <= wip_constants.trace_logging) THEN
356: wip_logger.exitPoint(p_procName => 'wip_movProc_grp.processInterface',
357: p_procReturnStatus => x_returnStatus,
358: p_msg => 'unexpected error: ' || SQLERRM,
359: x_returnStatus => l_returnStatus);