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 179: if (l_logLevel <= wip_constants.trace_logging) then

175: dummyErrCode VARCHAR2(1);
176: begin
177: savepoint wiptmpvb100;
178:
179: if (l_logLevel <= wip_constants.trace_logging) then
180: l_params(1).paramName := 'p_txnTmpID';
181: l_params(1).paramValue := p_txnTmpID;
182: l_params(2).paramName := 'p_processLpn';
183: l_params(2).paramValue := p_processLpn;

Line 198: 'Y', wip_constants.flow,

194: select transaction_action_id,
195: transaction_header_id, /*Added for bug 6417742(FP of 6342851)*/
196: transaction_type_id, /*Added for bug 6417742(FP of 6342851)*/
197: decode(flow_schedule, --treat wol cpls as flow
198: 'Y', wip_constants.flow,
199: wip_entity_type),
200: nvl(content_lpn_id, lpn_id),
201: transaction_source_id,
202: organization_id,

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

224:
225: delete mtl_material_transactions_temp
226: where transaction_temp_id = p_txnTmpID;
227:
228: if(l_logLevel <= wip_constants.trace_logging) then
229: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
230: p_procReturnStatus => x_returnStatus,
231: p_msg => 'success: phantom record deleted without any action',
232: x_returnStatus => l_retStatus);

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

245: where wip_entity_id = l_wipEntityID
246: and organization_id = l_orgID;
247: end if;
248:
249: if(l_logLevel <= wip_constants.full_logging) then
250: wip_logger.log('txnActID: ' || l_txnActionID, l_retStatus);
251: wip_logger.log('wipEntityType: ' || l_wipEntityType, l_retStatus);
252: wip_logger.log('lpnID: ' || l_lpnID, l_retStatus);
253: wip_logger.log('wipEntityID: ' || l_wipEntityID, l_retStatus);

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

256: wip_logger.log('FlowSchedule: ' || l_flowSchedule, l_retStatus);
257: end if;
258:
259: --component issues
260: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
261: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
262: --no action is necessary for flow txns
263: if(l_wipEntityType <> wip_constants.flow) then
264: if(l_logLevel <= wip_constants.full_logging) then

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

257: end if;
258:
259: --component issues
260: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
261: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
262: --no action is necessary for flow txns
263: if(l_wipEntityType <> wip_constants.flow) then
264: if(l_logLevel <= wip_constants.full_logging) then
265: wip_logger.log('calling component processor', l_retStatus);

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

259: --component issues
260: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
261: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
262: --no action is necessary for flow txns
263: if(l_wipEntityType <> wip_constants.flow) then
264: if(l_logLevel <= wip_constants.full_logging) then
265: wip_logger.log('calling component processor', l_retStatus);
266: end if;
267: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

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

260: if(l_txnActionID in (wip_constants.isscomp_action, wip_constants.retcomp_action,
261: wip_constants.issnegc_action, wip_constants.retnegc_action)) then
262: --no action is necessary for flow txns
263: if(l_wipEntityType <> wip_constants.flow) then
264: if(l_logLevel <= wip_constants.full_logging) then
265: wip_logger.log('calling component processor', l_retStatus);
266: end if;
267: wip_mtlProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
268: p_endDebug => fnd_api.g_false,

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

269: p_txnTmpID => p_txnTmpID,
270: x_returnStatus => x_returnStatus);
271: end if;
272:
273: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
274: --no action is necessary for lpn completions
275: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
276: if(l_wipEntityType = wip_constants.flow) then
277: if(l_logLevel <= wip_constants.full_logging) then

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

272:
273: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
274: --no action is necessary for lpn completions
275: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
276: if(l_wipEntityType = wip_constants.flow) then
277: if(l_logLevel <= wip_constants.full_logging) then
278: wip_logger.log('calling flow/wol processor', l_retStatus);
279: end if;
280: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

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

273: elsif(l_txnActionID in (wip_constants.cplassy_action, wip_constants.retassy_action)) then
274: --no action is necessary for lpn completions
275: if(l_lpnID is null or fnd_api.to_boolean(p_processLpn)) then
276: if(l_wipEntityType = wip_constants.flow) then
277: if(l_logLevel <= wip_constants.full_logging) then
278: wip_logger.log('calling flow/wol processor', l_retStatus);
279: end if;
280: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
281: p_txnTempID => p_txnTmpID,

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

280: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
281: p_txnTempID => p_txnTmpID,
282: x_returnStatus => x_returnStatus);
283: else --non flow completion
284: if(l_logLevel <= wip_constants.full_logging) then
285: wip_logger.log('calling cpl processor', l_retStatus);
286: end if;
287: wip_cplProc_priv.processTemp(p_txnTmpID => p_txnTmpID,
288: p_initMsgList => fnd_api.g_false,

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

289: p_endDebug => fnd_api.g_false,
290: x_returnStatus => x_returnStatus);
291: end if;
292: end if;
293: elsif(l_txnActionID = wip_constants.scrassy_action) then
294: --for repetitive, must do allocation
295: if(l_wipEntityType = wip_constants.repetitive) then
296: if(l_logLevel <= wip_constants.full_logging) then
297: wip_logger.log('calling rep scrap processor', l_retStatus);

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

291: end if;
292: end if;
293: elsif(l_txnActionID = wip_constants.scrassy_action) then
294: --for repetitive, must do allocation
295: if(l_wipEntityType = wip_constants.repetitive) then
296: if(l_logLevel <= wip_constants.full_logging) then
297: wip_logger.log('calling rep scrap processor', l_retStatus);
298: end if;
299: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,

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

292: end if;
293: elsif(l_txnActionID = wip_constants.scrassy_action) then
294: --for repetitive, must do allocation
295: if(l_wipEntityType = wip_constants.repetitive) then
296: if(l_logLevel <= wip_constants.full_logging) then
297: wip_logger.log('calling rep scrap processor', l_retStatus);
298: end if;
299: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
300: x_returnStatus => x_returnStatus);

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

297: wip_logger.log('calling rep scrap processor', l_retStatus);
298: end if;
299: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
300: x_returnStatus => x_returnStatus);
301: elsif (l_wipEntityType = wip_constants.flow) then
302: if(l_logLevel <= wip_constants.full_logging) then
303: wip_logger.log('calling flow/wol processor', l_retStatus);
304: end if;
305: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,

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

298: end if;
299: wip_movProc_priv.repetitive_scrap(p_tmp_id => p_txnTmpID,
300: x_returnStatus => x_returnStatus);
301: elsif (l_wipEntityType = wip_constants.flow) then
302: if(l_logLevel <= wip_constants.full_logging) then
303: wip_logger.log('calling flow/wol processor', l_retStatus);
304: end if;
305: wip_cfmProc_priv.processTemp(p_initMsgList => fnd_api.g_false,
306: p_txnTempID => p_txnTmpID,

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

311: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
312: raise fnd_api.g_exc_unexpected_error;
313: end if;
314:
315: if(l_logLevel <= wip_constants.trace_logging) then
316: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
317: p_procReturnStatus => x_returnStatus,
318: p_msg => 'success',
319: x_returnStatus => l_retStatus);

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

335:
336: -- do not error out if label printing, only put warning message in log
337: if(returnStatus <> fnd_api.g_ret_sts_success) then
338: WIP_UTILITIES.get_message_stack(p_msg => l_msg_stack);
339: if (l_logLevel <= wip_constants.full_logging) then
340: wip_logger.log(p_msg => 'An error has occurred with label printing.\n' ||
341: 'The following error has occurred during ' ||
342: 'printing: ' || l_msg_stack || '\n' ||
343: 'Please check the Inventory log file for more ' ||

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

344: 'information.',
345: x_returnStatus =>dummyErrCode);
346: end if;
347: end if;
348: if (l_logLevel <= wip_constants.full_logging) then
349: wip_logger.log(p_msg => 'Label printing returned with status ' ||
350: returnStatus,
351: x_returnStatus => dummyErrCode);
352: end if;

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

358: rollback to wiptmpvb100;
359: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
360: wip_utilities.get_message_stack(p_msg => x_errorMsg,
361: p_delete_stack => fnd_api.g_false);
362: if(l_logLevel <= wip_constants.trace_logging) then
363: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
364: p_procReturnStatus => x_returnStatus,
365: p_msg => 'error:' || x_errorMsg,
366: x_returnStatus => l_retStatus);

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

375: p_procedure_name => l_procName,
376: p_error_text => SQLERRM);
377: wip_utilities.get_message_stack(p_msg => x_errorMsg,
378: p_delete_stack => fnd_api.g_false);
379: if(l_logLevel <= wip_constants.trace_logging) then
380: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
381: p_procReturnStatus => x_returnStatus,
382: p_msg => 'unexp error:' || x_errorMsg,
383: x_returnStatus => l_retStatus);

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

412: begin
413: savepoint wiptmpvb200;
414: x_returnStatus := fnd_api.g_ret_sts_success;
415:
416: if (l_logLevel <= wip_constants.trace_logging) then
417: l_params(1).paramName := 'p_txnHdrID';
418: l_params(1).paramValue := p_txnHdrID;
419:
420: wip_logger.entryPoint(p_procName => g_pkgName || '.' || l_procName,

Line 437: and process_flag = wip_constants.mti_inventory;

433: select count(*)
434: into l_numIntRows
435: from mtl_transactions_interface
436: where transaction_header_id = p_txnHdrID
437: and process_flag = wip_constants.mti_inventory;
438: end if;
439:
440: if(l_numIntRows = 0) then
441: if(l_logLevel <= wip_constants.trace_logging) then

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

437: and process_flag = wip_constants.mti_inventory;
438: end if;
439:
440: if(l_numIntRows = 0) then
441: if(l_logLevel <= wip_constants.trace_logging) then
442: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
443: p_procReturnStatus => x_returnStatus,
444: p_msg => 'no rows to backflush',
445: x_returnStatus => l_retStatus);

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

475: if(l_numErrRows = 0) then
476: if(fnd_api.to_boolean(nvl(p_initMsgList, fnd_api.g_false))) then
477: fnd_msg_pub.initialize;
478: end if;
479: if(l_logLevel <= wip_constants.trace_logging) then
480: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
481: p_procReturnStatus => x_returnStatus,
482: p_msg => 'normal completion. ' || l_numTempRows || ' rows processed.',
483: x_returnStatus => l_retStatus);

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

511: for i in 1..l_itemNameTbl.count loop
512: fnd_message.set_name('WIP', 'WIP_TMPINSERT_ERR');
513: fnd_message.set_token('ITEM_NAME', l_itemNameTbl(i));
514: fnd_message.set_token('ERR_MSG', l_errExplTbl(i));
515: if(l_logLevel <= wip_constants.trace_logging) then
516: wip_logger.log('item ' || l_itemNameTbl(i) || ': ' || l_errExplTbl(i), l_retStatus);
517: end if;
518: fnd_msg_pub.add;
519: end loop;

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

522: if(fnd_api.to_boolean(nvl(p_rollBackOnErr, fnd_api.g_true))) then
523: rollback to wiptmpvb200;
524: end if;
525:
526: if(l_logLevel <= wip_constants.trace_logging) then
527: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
528: p_procReturnStatus => x_returnStatus,
529: p_msg => to_char(l_numIntRows - l_numTempRows) || ' records errored',
530: x_returnStatus => l_retStatus);

Line 552: process_flag = wip_constants.mti_error,

548: program_application_id = fnd_global.prog_appl_id,
549: program_id = fnd_global.conc_program_id,
550: program_update_date = sysdate,
551: request_id = fnd_global.conc_request_id,
552: process_flag = wip_constants.mti_error,
553: error_code = substrb(g_pkgName || '.' || l_procName, 1, 240),
554: error_explanation = substrb(l_msgData, 1, 240)
555: where transaction_header_id = p_txnHdrID;
556: end if;

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

559: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
560: fnd_message.set_token('MESSAGE', l_msgData);
561: fnd_msg_pub.add;
562: end if;
563: if(l_logLevel <= wip_constants.trace_logging) then
564: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
565: p_procReturnStatus => x_returnStatus,
566: p_msg => 'error:' || l_msgData,
567: 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 597: if(l_logLevel <= wip_constants.trace_logging) then

593: error_explanation = substrb(l_msgData, 1, 240)
594: where transaction_header_id = p_txnHdrID;
595: end if;
596:
597: if(l_logLevel <= wip_constants.trace_logging) then
598: wip_logger.exitPoint(p_procName => g_pkgName || '.' || l_procName,
599: p_procReturnStatus => x_returnStatus,
600: p_msg => 'unexp error:' || l_msgData,
601: x_returnStatus => l_retStatus);