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_MTLTEMPPROC_PRIV dependencies on WIP_CONSTANTS

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

32: --Initial Preprocessing
33: -------------------------------------------------------------
34:
35: savepoint wiptmpvb0;
36: if (l_logLevel <= wip_constants.trace_logging) then
37: l_params(1).paramName := 'p_initMsgList';
38: l_params(1).paramValue := p_initMsgList;
39: l_params(2).paramName := 'p_txnHdrID';
40: l_params(2).paramValue := p_txnHdrID;

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

58: l_retCode := inv_lpn_trx_pub.process_lpn_trx(p_trx_hdr_id => p_txnHdrID,
59: p_proc_mode => p_txnMode,
60: x_proc_msg => l_errMsg);
61:
62: if(l_logLevel <= wip_constants.full_logging) then
63: wip_logger.log('inv returned:' || l_retCode, l_retStatus);
64: wip_logger.log('inv errmsg:' || l_errMsg, l_retStatus);
65: end if;
66:

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

85: if(fnd_api.to_boolean(nvl(p_destroyQtyTrees, fnd_api.g_false))) then
86: inv_quantity_tree_pub.clear_quantity_cache;
87: end if;
88:
89: if (l_logLevel <= wip_constants.trace_logging) then
90: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
91: p_procReturnStatus => x_returnStatus,
92: p_msg => 'success',
93: x_returnStatus => l_retStatus);

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

100: rollback to wiptmpvb0;
101: wip_utilities.get_message_stack(p_msg => x_errorMsg,
102: p_delete_stack => fnd_api.g_false,
103: p_separator => ' ');
104: if (l_logLevel <= wip_constants.trace_logging) then
105: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
106: p_procReturnStatus => x_returnStatus,
107: p_msg => 'unhandled exception: ' || SQLERRM,
108: x_returnStatus => l_retStatus);

Line 132: and transaction_action_id in (wip_constants.isscomp_action,

128: error_explanation = substr(x_errorMsg,1,240)
129: where transaction_header_id = p_txnHdrID
130: and process_flag in ('Y', 'W')
131: and transaction_source_type_id = 5
132: and transaction_action_id in (wip_constants.isscomp_action,
133: wip_constants.retcomp_action,
134: wip_constants.issnegc_action,
135: wip_constants.retnegc_action);
136:

Line 133: wip_constants.retcomp_action,

129: where transaction_header_id = p_txnHdrID
130: and process_flag in ('Y', 'W')
131: and transaction_source_type_id = 5
132: and transaction_action_id in (wip_constants.isscomp_action,
133: wip_constants.retcomp_action,
134: wip_constants.issnegc_action,
135: wip_constants.retnegc_action);
136:
137: if (l_logLevel <= wip_constants.trace_logging) then

Line 134: wip_constants.issnegc_action,

130: and process_flag in ('Y', 'W')
131: and transaction_source_type_id = 5
132: and transaction_action_id in (wip_constants.isscomp_action,
133: wip_constants.retcomp_action,
134: wip_constants.issnegc_action,
135: wip_constants.retnegc_action);
136:
137: if (l_logLevel <= wip_constants.trace_logging) then
138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',

Line 135: wip_constants.retnegc_action);

131: and transaction_source_type_id = 5
132: and transaction_action_id in (wip_constants.isscomp_action,
133: wip_constants.retcomp_action,
134: wip_constants.issnegc_action,
135: wip_constants.retnegc_action);
136:
137: if (l_logLevel <= wip_constants.trace_logging) then
138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
139: p_procReturnStatus => x_returnStatus,

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

133: wip_constants.retcomp_action,
134: wip_constants.issnegc_action,
135: wip_constants.retnegc_action);
136:
137: if (l_logLevel <= wip_constants.trace_logging) then
138: wip_logger.exitPoint(p_procName => 'wip_mtlTempProc_priv.processTemp',
139: p_procReturnStatus => x_returnStatus,
140: p_msg => 'unhandled exception: ' || SQLERRM,
141: x_returnStatus => l_retStatus);

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

181: l_assy_processed number := 0; /*Added for bug 7009282 */
182: begin
183: savepoint wiptmpvb100;
184:
185: if (l_logLevel <= wip_constants.trace_logging) then
186: l_params(1).paramName := 'p_txnTmpID';
187: l_params(1).paramValue := p_txnTmpID;
188: l_params(2).paramName := 'p_processLpn';
189: l_params(2).paramValue := p_processLpn;

Line 204: 'Y', wip_constants.flow,

200: select transaction_action_id,
201: transaction_header_id, /*Added for bug 6417742(FP of 6342851)*/
202: transaction_type_id, /*Added for bug 6417742(FP of 6342851)*/
203: decode(flow_schedule, --treat wol cpls as flow
204: 'Y', wip_constants.flow,
205: wip_entity_type),
206: nvl(content_lpn_id, lpn_id),
207: transaction_source_id,
208: organization_id,

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

257: if (l_parent_inv_id < l_inv_id OR l_assy_processed = 1) then
258: delete mtl_material_transactions_temp
259: where transaction_temp_id = p_txnTmpID;
260:
261: if(l_logLevel <= wip_constants.trace_logging) then
262: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
263: p_procReturnStatus => x_returnStatus,
264: p_msg => 'success: phantom record deleted without any action',
265: x_returnStatus => l_retStatus);

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

279: where wip_entity_id = l_wipEntityID
280: and organization_id = l_orgID;
281: end if;
282:
283: if(l_logLevel <= wip_constants.full_logging) then
284: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);
285: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
286: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
287: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);

Line 294: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,

290: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);
291: end if;
292:
293: --component issues
294: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
295: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
296: --no action is necessary for flow txns
297: if(l_wipEntityType <> wip_constants.flow) then
298: if(l_logLevel <= wip_constants.full_logging) then

Line 295: wip_constants.issnegc_action, wip_constants.retnegc_action)) then

291: end if;
292:
293: --component issues
294: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
295: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
296: --no action is necessary for flow txns
297: if(l_wipEntityType <> wip_constants.flow) then
298: if(l_logLevel <= wip_constants.full_logging) then
299: wip_logger.log('calling component processor', l_retStatus);

Line 297: if(l_wipEntityType <> wip_constants.flow) then

293: --component issues
294: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
295: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
296: --no action is necessary for flow txns
297: if(l_wipEntityType <> wip_constants.flow) then
298: if(l_logLevel <= wip_constants.full_logging) then
299: wip_logger.log('calling component processor', l_retStatus);
300: end if;
301: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

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

294: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
295: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
296: --no action is necessary for flow txns
297: if(l_wipEntityType <> wip_constants.flow) then
298: if(l_logLevel <= wip_constants.full_logging) then
299: wip_logger.log('calling component processor', l_retStatus);
300: end if;
301: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
302: p_endDebug => fnd_api.g_false,

Line 307: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then

303: p_txnTmpID => p_txnTmpID,
304: x_returnStatus => x_returnStatus);
305: end if;
306:
307: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
308: --no action is necessary for lpn completions
309: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
310: if(l_wipEntityType = wip_constants.flow) then
311: if(l_logLevel <= wip_constants.full_logging) then

Line 310: if(l_wipEntityType = wip_constants.flow) then

306:
307: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
308: --no action is necessary for lpn completions
309: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
310: if(l_wipEntityType = wip_constants.flow) then
311: if(l_logLevel <= wip_constants.full_logging) then
312: wip_logger.log('calling flow/wol processor', l_retStatus);
313: end if;
314: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

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

307: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
308: --no action is necessary for lpn completions
309: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
310: if(l_wipEntityType = wip_constants.flow) then
311: if(l_logLevel <= wip_constants.full_logging) then
312: wip_logger.log('calling flow/wol processor', l_retStatus);
313: end if;
314: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
315: p_txnTempID => p_txnTmpID,

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

314: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
315: p_txnTempID => p_txnTmpID,
316: x_returnStatus => x_returnStatus);
317: else --non flow completion
318: if(l_logLevel <= wip_constants.full_logging) then
319: wip_logger.log('calling cpl processor', l_retStatus);
320: end if;
321: wip_cplProc_priv.processTemp(p_txnTmpID => p_txnTmpID,
322: p_initMsgList => fnd_api.g_false,

Line 327: elsif(l_txnActionID = wip_constants.scrassy_action) then

323: p_endDebug => fnd_api.g_false,
324: x_returnStatus => x_returnStatus);
325: end if;
326: end if;
327: elsif(l_txnActionID = wip_constants.scrassy_action) then
328: --for repetitive, must do allocation
329: if(l_wipEntityType = wip_constants.repetitive) then
330: if(l_logLevel <= wip_constants.full_logging) then
331: wip_logger.log('calling rep scrap processor', l_retStatus);

Line 329: if(l_wipEntityType = wip_constants.repetitive) then

325: end if;
326: end if;
327: elsif(l_txnActionID = wip_constants.scrassy_action) then
328: --for repetitive, must do allocation
329: if(l_wipEntityType = wip_constants.repetitive) then
330: if(l_logLevel <= wip_constants.full_logging) then
331: wip_logger.log('calling rep scrap processor', l_retStatus);
332: end if;
333: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,

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

326: end if;
327: elsif(l_txnActionID = wip_constants.scrassy_action) then
328: --for repetitive, must do allocation
329: if(l_wipEntityType = wip_constants.repetitive) then
330: if(l_logLevel <= wip_constants.full_logging) then
331: wip_logger.log('calling rep scrap processor', l_retStatus);
332: end if;
333: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
334: x_returnStatus => x_returnStatus);

Line 335: elsif (l_wipEntityType = wip_constants.flow) then

331: wip_logger.log('calling rep scrap processor', l_retStatus);
332: end if;
333: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
334: x_returnStatus => x_returnStatus);
335: elsif (l_wipEntityType = wip_constants.flow) then
336: if(l_logLevel <= wip_constants.full_logging) then
337: wip_logger.log('calling flow/wol processor', l_retStatus);
338: end if;
339: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

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

332: end if;
333: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
334: x_returnStatus => x_returnStatus);
335: elsif (l_wipEntityType = wip_constants.flow) then
336: if(l_logLevel <= wip_constants.full_logging) then
337: wip_logger.log('calling flow/wol processor', l_retStatus);
338: end if;
339: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
340: p_txnTempID => p_txnTmpID,

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

345: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
346: raise fnd_api.g_exc_unexpected_error;
347: end if;
348:
349: if(l_logLevel <= wip_constants.trace_logging) then
350: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
351: p_procReturnStatus => x_returnStatus,
352: p_msg => 'success',
353: x_returnStatus => l_retStatus);

Line 362: if ( l_txnActionID = WIP_CONSTANTS.CPLASSY_ACTION and

358:
359: /*Start - Bug 6417742(FP of 6342851): Added call label printing*/
360: /* Fix bug 8901142 (FP of 8585291) Added criteria to prevent printing label
361: twice for LPN completion/drop transaction */
362: if ( l_txnActionID = WIP_CONSTANTS.CPLASSY_ACTION and
363: l_flowSchedule = 'Y' and
364: l_transaction_type_id = WIP_CONSTANTS.CPLASSY_TYPE and
365: (l_lpnID is null or fnd_api.to_boolean(p_processLpn))) then
366: -- print label

Line 364: l_transaction_type_id = WIP_CONSTANTS.CPLASSY_TYPE and

360: /* Fix bug 8901142 (FP of 8585291) Added criteria to prevent printing label
361: twice for LPN completion/drop transaction */
362: if ( l_txnActionID = WIP_CONSTANTS.CPLASSY_ACTION and
363: l_flowSchedule = 'Y' and
364: l_transaction_type_id = WIP_CONSTANTS.CPLASSY_TYPE and
365: (l_lpnID is null or fnd_api.to_boolean(p_processLpn))) then
366: -- print label
367: wip_utilities.print_label(p_txn_id => l_transaction_header_id, -- should be transaction header id
368: p_table_type => 2, --MMTT

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

374:
375: -- do not error out if label printing, only put warning message in log
376: if(returnStatus <> fnd_api.g_ret_sts_success) then
377: WIP_UTILITIES.get_message_stack(p_msg => l_msg_stack);
378: if (l_logLevel <= wip_constants.full_logging) then
379: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
380: 'The following error has occurred during ' ||
381: 'printing: ' || l_msg_stack || '\n' ||
382: 'Please check the Inventory log file for more ' ||

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

383: 'information.',
384: x_returnStatus =>dummyErrCode);
385: end if;
386: end if;
387: if (l_logLevel <= wip_constants.full_logging) then
388: wip_logger.log(p_msg => 'Label printing returned with status ' || returnStatus,
389: x_returnStatus => dummyErrCode);
390: end if;
391: end if;

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

397: rollback to wiptmpvb100;
398: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
399: wip_utilities.get_message_stack(p_msg => x_errorMsg,
400: p_delete_stack => fnd_api.g_false);
401: if(l_logLevel <= wip_constants.trace_logging) then
402: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
403: p_procReturnStatus => x_returnStatus,
404: p_msg => 'error:' || x_errorMsg,
405: x_returnStatus => l_retStatus);

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

414: p_procedure_name => l_procName,
415: p_error_text => SQLERRM);
416: wip_utilities.get_message_stack(p_msg => x_errorMsg,
417: p_delete_stack => fnd_api.g_false);
418: if(l_logLevel <= wip_constants.trace_logging) then
419: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
420: p_procReturnStatus => x_returnStatus,
421: p_msg => 'unexp error:' || x_errorMsg,
422: x_returnStatus => l_retStatus);

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

451: begin
452: savepoint wiptmpvb200;
453: x_returnStatus := fnd_api.g_ret_sts_success;
454:
455: if (l_logLevel <= wip_constants.trace_logging) then
456: l_params(1).paramName := 'p_txnHdrID';
457: l_params(1).paramValue := p_txnHdrID;
458:
459: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,

Line 476: and process_flag = wip_constants.mti_inventory;

472: select count(*)
473: into l_numIntRows
474: from mtl_transactions_interface
475: where transaction_header_id = p_txnHdrID
476: and process_flag = wip_constants.mti_inventory;
477: end if;
478:
479: if(l_numIntRows = 0) then
480: if(l_logLevel <= wip_constants.trace_logging) then

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

476: and process_flag = wip_constants.mti_inventory;
477: end if;
478:
479: if(l_numIntRows = 0) then
480: if(l_logLevel <= wip_constants.trace_logging) then
481: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
482: p_procReturnStatus => x_returnStatus,
483: p_msg => 'no rows to backflush',
484: x_returnStatus => l_retStatus);

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

514: if(l_numErrRows = 0) then
515: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
516: fnd_msg_pub.initialize;
517: end if;
518: if(l_logLevel <= wip_constants.trace_logging) then
519: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
520: p_procReturnStatus => x_returnStatus,
521: p_msg => 'normal completion. ' || l_numTempRows || ' rows processed.',
522: x_returnStatus => l_retStatus);

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

550: for i in 1..l_itemNameTbl.count loop
551: fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');
552: fnd_message.set_token('ITEM_NAME', l_itemNameTbl(i));
553: fnd_message.set_token('ERR_MSG', l_errExplTbl(i));
554: if(l_logLevel <= wip_constants.trace_logging) then
555: wip_logger.log('item ' || l_itemNameTbl(i) || ': ' || l_errExplTbl(i), l_retStatus);
556: end if;
557: fnd_msg_pub.add;
558: end loop;

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

561: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
562: rollback to wiptmpvb200;
563: end if;
564:
565: if(l_logLevel <= wip_constants.trace_logging) then
566: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
567: p_procReturnStatus => x_returnStatus,
568: p_msg => to_char(l_numIntRows - l_numTempRows) || ' records errored',
569: x_returnStatus => l_retStatus);

Line 591: process_flag = wip_constants.mti_error,

587: program_application_id = fnd_global.prog_appl_id,
588: program_id = fnd_global.conc_program_id,
589: program_update_date = sysdate,
590: request_id = fnd_global.conc_request_id,
591: process_flag = wip_constants.mti_error,
592: error_code = substrb(g_pkgName || '.' || l_procName, 1, 240),
593: error_explanation = substrb(l_msgData, 1, 240)
594: where transaction_header_id = p_txnHdrID;
595: end if;

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

598: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
599: fnd_message.set_token('MESSAGE', l_msgData);
600: fnd_msg_pub.add;
601: end if;
602: if(l_logLevel <= wip_constants.trace_logging) then
603: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
604: p_procReturnStatus => x_returnStatus,
605: p_msg => 'error:' || l_msgData,
606: x_returnStatus => l_retStatus);

Line 630: process_flag = wip_constants.mti_error,

626: program_application_id = fnd_global.prog_appl_id,
627: program_id = fnd_global.conc_program_id,
628: program_update_date = sysdate,
629: request_id = fnd_global.conc_request_id,
630: process_flag = wip_constants.mti_error,
631: error_code = substrb(g_pkgName || '.' || l_procName, 1, 240),
632: error_explanation = substrb(l_msgData, 1, 240)
633: where transaction_header_id = p_txnHdrID;
634: end if;

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

632: error_explanation = substrb(l_msgData, 1, 240)
633: where transaction_header_id = p_txnHdrID;
634: end if;
635:
636: if(l_logLevel <= wip_constants.trace_logging) then
637: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
638: p_procReturnStatus => x_returnStatus,
639: p_msg => 'unexp error:' || l_msgData,
640: x_returnStatus => l_retStatus);