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_MTI_PUB dependencies on WIP_LOGGER

Line 112: l_params wip_logger.param_tbl_t;

108: l_tbls mti_recTbl_t;
109: l_errTbls mti_err_recTbl_t;
110: l_count NUMBER;
111: l_returnStatus VARCHAR2(1);
112: l_params wip_logger.param_tbl_t;
113: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
114: l_errExp VARCHAR2(240);
115: l_convPriQty NUMBER;
116: l_convOverCplPriQty NUMBER;

Line 122: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvWipProcessing',

118: begin
119: if (l_logLevel <= wip_constants.trace_logging) then
120: l_params(1).paramName := 'p_txnHeaderID';
121: l_params(1).paramValue := p_txnHeaderID;
122: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvWipProcessing',
123: p_params => l_params,
124: x_returnStatus => x_returnStatus);
125: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
126: raise fnd_api.g_exc_unexpected_error;

Line 206: wip_logger.log('uom conversion failed.', l_returnStatus);

202: /* End of fix for Bug 5411401 */
203:
204: if(l_convErrExists) then
205: if(l_logLevel <= wip_constants.full_logging) then
206: wip_logger.log('uom conversion failed.', l_returnStatus);
207: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
208: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
209: end if;
210: fnd_message.set_name('INV', 'INV_INT_UOMEXP');

Line 207: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);

203:
204: if(l_convErrExists) then
205: if(l_logLevel <= wip_constants.full_logging) then
206: wip_logger.log('uom conversion failed.', l_returnStatus);
207: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
208: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
209: end if;
210: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
211: l_errExp := fnd_message.get;

Line 208: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);

204: if(l_convErrExists) then
205: if(l_logLevel <= wip_constants.full_logging) then
206: wip_logger.log('uom conversion failed.', l_returnStatus);
207: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
208: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
209: end if;
210: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
211: l_errExp := fnd_message.get;
212: update mtl_transactions_interface

Line 244: wip_logger.log('pri qty:' || l_tbls.priQty(i), l_returnStatus);

240: primary_quantity = l_tbls.priQty(i),
241: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
242: where transaction_interface_id = l_tbls.txnIntID(i);
243: if(l_logLevel <= wip_constants.full_logging) then
244: wip_logger.log('pri qty:' || l_tbls.priQty(i), l_returnStatus);
245: wip_logger.log('ovcpl pri qty:' || l_tbls.overCplPriQty(i), l_returnStatus);
246: end if;
247: end if;
248:

Line 245: wip_logger.log('ovcpl pri qty:' || l_tbls.overCplPriQty(i), l_returnStatus);

241: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
242: where transaction_interface_id = l_tbls.txnIntID(i);
243: if(l_logLevel <= wip_constants.full_logging) then
244: wip_logger.log('pri qty:' || l_tbls.priQty(i), l_returnStatus);
245: wip_logger.log('ovcpl pri qty:' || l_tbls.overCplPriQty(i), l_returnStatus);
246: end if;
247: end if;
248:
249: if(l_tbls.wipEntityType(i) <> wip_constants.flow and not l_convErrExists) then

Line 251: wip_logger.log('calling work order row-by-row processor', l_returnStatus);

247: end if;
248:
249: if(l_tbls.wipEntityType(i) <> wip_constants.flow and not l_convErrExists) then
250: if(l_logLevel <= wip_constants.full_logging) then
251: wip_logger.log('calling work order row-by-row processor', l_returnStatus);
252: end if;
253: preInvProcessWorkOrder(p_txnHeaderID => p_txnHeaderID,
254: p_tbls => l_tbls,
255: p_index => i,

Line 263: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);

259: end loop;
260:
261: if ( l_errTbls.txnIntID is not null ) then
262: if(l_logLevel <= wip_constants.full_logging) then
263: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);
264: for i in 1..l_errTbls.txnIntID.count loop
265: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);
266: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);
267: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);

Line 265: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);

261: if ( l_errTbls.txnIntID is not null ) then
262: if(l_logLevel <= wip_constants.full_logging) then
263: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);
264: for i in 1..l_errTbls.txnIntID.count loop
265: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);
266: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);
267: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);
268: end loop;
269: end if;

Line 266: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);

262: if(l_logLevel <= wip_constants.full_logging) then
263: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);
264: for i in 1..l_errTbls.txnIntID.count loop
265: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);
266: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);
267: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);
268: end loop;
269: end if;
270:

Line 267: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);

263: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);
264: for i in 1..l_errTbls.txnIntID.count loop
265: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);
266: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);
267: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);
268: end loop;
269: end if;
270:
271: forall i in 1..l_errTbls.txnIntID.count

Line 288: wip_logger.log('calling flow group processor', l_returnStatus);

284: where transaction_interface_id = l_errTbls.txnIntID(i);
285: end if;
286:
287: if(l_logLevel <= wip_constants.full_logging) then
288: wip_logger.log('calling flow group processor', l_returnStatus);
289: end if;
290:
291: preInvProcessFlow(p_txnHeaderID => p_txnHeaderID,
292: x_returnStatus => l_returnStatus);

Line 296: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

292: x_returnStatus => l_returnStatus);
293:
294:
295: if (l_logLevel <= wip_constants.trace_logging) then
296: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
297: p_procReturnStatus => x_returnStatus,
298: p_msg => 'success',
299: x_returnStatus => l_returnStatus);
300: wip_logger.cleanup(l_returnStatus);

Line 300: wip_logger.cleanup(l_returnStatus);

296: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
297: p_procReturnStatus => x_returnStatus,
298: p_msg => 'success',
299: x_returnStatus => l_returnStatus);
300: wip_logger.cleanup(l_returnStatus);
301: end if;
302: exception
303: when others then
304: rollback to wipmtivb1;

Line 325: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

321: and transaction_source_type_id = 5
322: and process_flag = wip_constants.mti_inventory;
323:
324: if(l_logLevel <= wip_constants.trace_logging) then
325: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
326: p_procReturnStatus => x_returnStatus,
327: p_msg => 'unexpected error: ' || SQLERRM,
328: x_returnStatus => l_returnStatus); --discard logging return status
329: wip_logger.cleanup(l_returnStatus);

Line 329: wip_logger.cleanup(l_returnStatus);

325: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
326: p_procReturnStatus => x_returnStatus,
327: p_msg => 'unexpected error: ' || SQLERRM,
328: x_returnStatus => l_returnStatus); --discard logging return status
329: wip_logger.cleanup(l_returnStatus);
330: end if;
331: end preInvWIPProcessing;
332:
333: procedure preInvProcessWorkOrder(p_txnHeaderID in number,

Line 344: l_params wip_logger.param_tbl_t;

340: l_lsRequired NUMBER;
341: l_msg VARCHAR2(2000);
342: l_errCount NUMBER;
343: l_count NUMBER;
344: l_params wip_logger.param_tbl_t;
345: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
346: l_returnStatus VARCHAR2(1);
347: begin
348: savepoint wipmtivb10;

Line 356: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessWorkOrder',

352: l_params(1).paramValue := p_txnHeaderID;
353: l_params(2).paramName := 'p_index';
354: l_params(2).paramValue := p_index;
355:
356: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessWorkOrder',
357: p_params => l_params,
358: x_returnStatus => x_returnStatus);
359: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
360: raise fnd_api.g_exc_unexpected_error;

Line 372: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

368: elsif(p_tbls.txnActionID(p_index) = wip_constants.retassy_action) then
369: l_txnType := wip_constants.ret_txn;
370: else --scrap. don't do anything
371: if (l_logLevel <= wip_constants.trace_logging) then
372: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
373: p_procReturnStatus => x_returnStatus,
374: p_msg => 'success (scrap txn)',
375: x_returnStatus => l_returnStatus);
376: end if;

Line 383: wip_logger.log('doing repetitive processing', l_returnStatus);

379:
380: --if repetitive cpl, check allocation table to see if schedule has already been pre-processed
381: if(p_tbls.repLineID(p_index) is not null) then
382: if (l_logLevel <= wip_constants.full_logging) then
383: wip_logger.log('doing repetitive processing', l_returnStatus);
384: end if;
385: select count(*)
386: into l_count
387: from wip_mtl_allocations_temp

Line 392: wip_logger.log('found unallocated schedule', l_returnStatus);

388: where transaction_temp_id = p_tbls.txnIntID(p_index);
389:
390: if(l_count = 0) then
391: if (l_logLevel <= wip_constants.full_logging) then
392: wip_logger.log('found unallocated schedule', l_returnStatus);
393: end if;
394: wip_cplProc_priv.preAllocateSchedules(p_txnHdrID => p_txnHeaderID,
395: p_cplTxnID => p_tbls.cplTxnID(p_index),
396: p_txnActionID => p_tbls.txnActionID(p_index),

Line 418: wip_logger.log('backflushing cpl', l_returnStatus);

414: and transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
415: wip_constants.issnegc_action, wip_constants.retnegc_action);
416: if(l_count = 0) then
417: if (l_logLevel <= wip_constants.full_logging) then
418: wip_logger.log('backflushing cpl', l_returnStatus);
419: end if;
420: wip_bflProc_priv.backflush(p_wipEntityID => p_tbls.wipEntityID(p_index),
421: p_orgID => p_tbls.orgID(p_index),
422: p_primaryQty => abs(p_tbls.priQty(p_index)),

Line 443: wip_logger.log('bf required:' || l_bfRequired, l_returnStatus);

439: x_lotSerRequired => l_lsRequired,
440: x_returnStatus => x_returnStatus);
441:
442: if (l_logLevel <= wip_constants.full_logging) then
443: wip_logger.log('bf required:' || l_bfRequired, l_returnStatus);
444: wip_logger.log('ls required:' || l_lsRequired, l_returnStatus);
445: end if;
446: --if the procedure fails or some lot/serial info for backflush components can not
447: --be derived then error

Line 444: wip_logger.log('ls required:' || l_lsRequired, l_returnStatus);

440: x_returnStatus => x_returnStatus);
441:
442: if (l_logLevel <= wip_constants.full_logging) then
443: wip_logger.log('bf required:' || l_bfRequired, l_returnStatus);
444: wip_logger.log('ls required:' || l_lsRequired, l_returnStatus);
445: end if;
446: --if the procedure fails or some lot/serial info for backflush components can not
447: --be derived then error
448: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 459: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

455: end if;
456:
457: end if;
458: if (l_logLevel <= wip_constants.trace_logging) then
459: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
460: p_procReturnStatus => x_returnStatus,
461: p_msg => 'success',
462: x_returnStatus => l_returnStatus);
463: end if;

Line 473: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

469: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);
470: p_errTbls.errCode(l_errCount) := 'WIP_PREPROCESSING';
471: wip_utilities.get_message_stack(p_msg => l_msg);
472: if(l_logLevel <= wip_constants.trace_logging) then
473: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
474: p_procReturnStatus => x_returnStatus,
475: p_msg => 'error:' || l_msg,
476: x_returnStatus => l_returnStatus);
477: end if;

Line 481: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',

477: end if;
478: p_errTbls.errExpl(l_errCount) := substrb(l_msg, 1, 240);
479: when others then
480: if(l_logLevel <= wip_constants.trace_logging) then
481: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
482: p_procReturnStatus => x_returnStatus,
483: p_msg => 'unexp error:' || SQLERRM,
484: x_returnStatus => l_returnStatus);
485: end if;

Line 529: l_params wip_logger.param_tbl_t;

525: and transaction_action_id in (WIP_CONSTANTS.SCRASSY_ACTION,
526: WIP_CONSTANTS.CPLASSY_ACTION,
527: WIP_CONSTANTS.RETASSY_ACTION);
528: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
529: l_params wip_logger.param_tbl_t;
530: l_returnStatus varchar2(1);
531: l_msgCount number;
532: l_msgData varchar2(240);
533:

Line 564: l_params wip_logger.param_tbl_t;

560:
561: l_primaryUOM varchar2(3);
562: l_primaryQty number;
563:
564: l_params wip_logger.param_tbl_t;
565: l_returnStatus varchar2(1);
566: l_errCode varchar2(240);
567: l_errMsg varchar2(240);
568: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

Line 575: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',

571:
572: if (l_logLevel <= wip_constants.trace_logging) then
573: l_params(1).paramName := 'p_txnHeaderID';
574: l_params(1).paramValue := p_txnHeaderID;
575: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
576: p_params => l_params,
577: x_returnStatus => x_returnStatus);
578: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
579: raise fnd_api.g_exc_unexpected_error;

Line 587: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',

583: -- do derivation and validation only for flow records
584: wip_flowUtil_priv.processFlowInterfaceRecords(p_txnHeaderID);
585:
586: if (l_logLevel <= wip_constants.trace_logging) then
587: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
588: p_procReturnStatus => x_returnStatus,
589: p_msg => 'Finished pre inventory flow processing!',
590: x_returnStatus => l_returnStatus); --discard logging return status
591: end if;

Line 596: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',

592: exception
593: when others then
594: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
595: if (l_logLevel <= wip_constants.trace_logging) then
596: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
597: p_procReturnStatus => x_returnStatus,
598: p_msg => 'unexpected error: ' || SQLERRM,
599: x_returnStatus => l_returnStatus); --discard logging return status
600: end if;

Line 762: l_params wip_logger.param_tbl_t;

758: l_priQty number;
759: l_errNum number;
760: l_errCode varchar2(240);
761: l_poExpToAssetTnsf number;
762: l_params wip_logger.param_tbl_t;
763: l_returnStatus varchar2(1);
764: l_errMsg varchar2(240);
765: l_engItemFlag number := 2;
766: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

Line 775: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWIPValidation.',

771:
772: if (l_logLevel <= wip_constants.trace_logging) then
773: l_params(1).paramName := 'p_txnHeaderID';
774: l_params(1).paramValue := p_txnHeaderID;
775: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWIPValidation.',
776: p_params => l_params,
777: x_returnStatus => x_returnStatus);
778: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
779: raise fnd_api.g_exc_unexpected_error;

Line 1879: wip_logger.log('about to call EAM validations', l_returnStatus);

1875: and negative_req_flag is not null
1876: and negative_req_flag not in (1, -1);
1877:
1878: if(l_logLevel <= wip_constants.full_logging) then
1879: wip_logger.log('about to call EAM validations', l_returnStatus);
1880: end if;
1881:
1882: -- for discrete job, we do not support background transactions for
1883: -- serialized job

Line 1938: wip_logger.log('EAM validation routine returned:' || x_returnStatus, l_returnStatus);

1934: wip_eamMtlProc_priv.validateTxns(p_txnHdrID => p_txnHeaderID,
1935: x_returnStatus => x_returnStatus);
1936:
1937: if(l_logLevel <= wip_constants.full_logging) then
1938: wip_logger.log('EAM validation routine returned:' || x_returnStatus, l_returnStatus);
1939: end if;
1940:
1941: /* Fix for bug 5708242: Call to cstpacms.validate_move_snap_to_temp has been moved to
1942: wip_cplProc_priv.processTemp (wipcplpb.pls). Calling it here will commit records to

Line 1987: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',

1983: end if;
1984: end loop;
1985:
1986: if(l_logLevel <= wip_constants.trace_logging) then
1987: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',
1988: p_procReturnStatus => x_returnStatus,
1989: p_msg => 'Finished validating interface rows!',
1990: x_returnStatus => l_returnStatus); --discard logging return status
1991: end if;

Line 1996: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',

1992: exception
1993: when others then
1994: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1995: if (l_logLevel <= wip_constants.trace_logging) then
1996: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',
1997: p_procReturnStatus => x_returnStatus,
1998: p_msg => 'unexpected error: ' || SQLERRM,
1999: x_returnStatus => l_returnStatus); --discard logging return status
2000: end if;

Line 2046: l_params wip_logger.param_tbl_t;

2042: l_returnStatus VARCHAR2(1);
2043: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2044: l_errCode VARCHAR2(240);
2045: l_errMsg VARCHAR2(240);
2046: l_params wip_logger.param_tbl_t;
2047: l_orgIDTbl num_tbl_t;
2048: l_rowidTbl rowid_tbl_t;
2049: l_subCodeTbl big_char_tbl_t;
2050: l_itemIDTbl num_tbl_t;

Line 2102: wip_logger.entryPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',

2098: begin
2099: if (l_logLevel <= wip_constants.trace_logging) then
2100: l_params(1).paramName := 'p_txnHeaderID';
2101: l_params(1).paramValue := p_txnHeaderID;
2102: wip_logger.entryPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2103: p_params => l_params,
2104: x_returnStatus => l_returnStatus);
2105: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2106: raise fnd_api.g_exc_unexpected_error;

Line 2407: wip_logger.log('about to fetch records for name -> item derivation', l_returnStatus);

2403: and transaction_source_id is not null;
2404:
2405:
2406: if(l_logLevel <= wip_constants.full_logging) then
2407: wip_logger.log('about to fetch records for name -> item derivation', l_returnStatus);
2408: end if;
2409: --item id from name
2410: open c_itemTxns;
2411: fetch c_itemTxns

Line 2429: wip_logger.log('about to derive item id from name', l_returnStatus);

2425:
2426: for i in 1..l_orgIDTbl.count loop
2427: if(l_itemIDTbl(i) is null) then
2428: if(l_logLevel <= wip_constants.full_logging) then
2429: wip_logger.log('about to derive item id from name', l_returnStatus);
2430: end if;
2431: if(not inv_txn_manager_grp.getitemid(x_itemID => l_itemIDTbl(i),
2432: p_orgID => l_orgIDTbl(i),
2433: p_rowid => l_rowidTbl(i))) then

Line 2436: wip_logger.log('item id from name derivation failed', l_returnStatus);

2432: p_orgID => l_orgIDTbl(i),
2433: p_rowid => l_rowidTbl(i))) then
2434: l_itemIDTbl(i) := null;--let inventory error out later
2435: if(l_logLevel <= wip_constants.full_logging) then
2436: wip_logger.log('item id from name derivation failed', l_returnStatus);
2437: end if;
2438: elsif(l_logLevel <= wip_constants.full_logging) then
2439: wip_logger.log('item id' || l_itemIDTbl(i), l_returnStatus);
2440: end if;

Line 2439: wip_logger.log('item id' || l_itemIDTbl(i), l_returnStatus);

2435: if(l_logLevel <= wip_constants.full_logging) then
2436: wip_logger.log('item id from name derivation failed', l_returnStatus);
2437: end if;
2438: elsif(l_logLevel <= wip_constants.full_logging) then
2439: wip_logger.log('item id' || l_itemIDTbl(i), l_returnStatus);
2440: end if;
2441: end if;
2442:
2443: /* FP bug 5708701 (base bug 5046732) - Removed the code to derive locator id. We do not require locator_id.

Line 2462: wip_logger.log('about to derive locator id from name', l_returnStatus);

2458: and mp.organization_id = sub.organization_id
2459: and mp.organization_id = it.organization_id;
2460:
2461: if(l_logLevel <= wip_constants.full_logging) then
2462: wip_logger.log('about to derive locator id from name', l_returnStatus);
2463: end if;
2464: if(not inv_txn_manager_grp.getlocid(x_locID => l_locIDTbl(i),
2465: p_org_id => l_orgIDTbl(i),
2466: p_subinv => l_subCodeTbl(i),

Line 2471: wip_logger.log('locator id from name derivation failed', l_returnStatus);

2467: p_rowid => l_rowidTbl(i),
2468: p_locCtrl => l_locCtrl)) then
2469: l_locIDTbl(i) := null; --let inventory error out later
2470: if(l_logLevel <= wip_constants.full_logging) then
2471: wip_logger.log('locator id from name derivation failed', l_returnStatus);
2472: end if;
2473: end if;
2474: end if;
2475: */

Line 2657: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',

2653: and wfs.wip_entity_id = mti.transaction_source_id
2654: and wfs.status = 2);
2655:
2656: if (l_logLevel <= wip_constants.trace_logging) then
2657: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2658: p_procReturnStatus => x_returnStatus,
2659: p_msg => 'normal completion',
2660: x_returnStatus => l_returnStatus);
2661: end if;

Line 2683: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',

2679: and transaction_source_type_id = 5
2680: and process_flag = wip_constants.mti_inventory;
2681:
2682: if(l_logLevel <= wip_constants.trace_logging) then
2683: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2684: p_procReturnStatus => x_returnStatus,
2685: p_msg => 'unexpected error: ' || SQLERRM,
2686: x_returnStatus => l_returnStatus); --discard logging return status
2687: end if;

Line 2701: l_params wip_logger.param_tbl_t;

2697: l_itemIDTbl num_tbl_t;
2698: l_orgIDTbl num_tbl_t;
2699: l_itemNameTbl big_char_tbl_t;
2700: l_retStatus VARCHAR2(1);
2701: l_params wip_logger.param_tbl_t;
2702: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2703: begin
2704: x_returnStatus := fnd_api.g_ret_sts_success;
2705:

Line 2711: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWipProcessing',

2707: l_params(1).paramName := 'p_txnHeaderID';
2708: l_params(1).paramValue := p_txnHeaderID;
2709: l_params(2).paramName := 'p_txnBatchID';
2710: l_params(2).paramValue := p_txnBatchID;
2711: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWipProcessing',
2712: p_params => l_params,
2713: x_returnStatus => l_retStatus);
2714: end if;
2715: --delete any pre-allocations that occurred for errored records

Line 2724: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' pre-allocations', l_retStatus);

2720: and transaction_batch_id = p_txnBatchID
2721: and process_flag = wip_constants.mti_error);
2722:
2723: if(l_logLevel <= wip_constants.full_logging) then
2724: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' pre-allocations', l_retStatus);
2725: end if;
2726:
2727: --fetch all errored components
2728: select mti.completion_transaction_id,

Line 2766: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' backflush components', l_retStatus);

2762: or move_transaction_id is not null)
2763: and process_flag = wip_constants.mti_error;
2764:
2765: if(l_logLevel <= wip_constants.full_logging) then
2766: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' backflush components', l_retStatus);
2767: end if;
2768:
2769: --if any components failed update the parent with the error
2770: forall i in 1..l_errExplTbl.count

Line 2790: wip_logger.log('calling inventory api to release locks on MOQD', l_retStatus);

2786: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action);
2787:
2788: /*Bug 14802139: Calling below inventory API to release locks. this is an inventory request*/
2789: if(l_logLevel <= wip_constants.full_logging) then
2790: wip_logger.log('calling inventory api to release locks on MOQD', l_retStatus);
2791: end if;
2792: inv_table_lock_pvt.release_locks(p_header_id => p_txnHeaderID);
2793: if(l_logLevel <= wip_constants.full_logging) then
2794: wip_logger.log('done calling inventory api to release locks on MOQD', l_retStatus);

Line 2794: wip_logger.log('done calling inventory api to release locks on MOQD', l_retStatus);

2790: wip_logger.log('calling inventory api to release locks on MOQD', l_retStatus);
2791: end if;
2792: inv_table_lock_pvt.release_locks(p_header_id => p_txnHeaderID);
2793: if(l_logLevel <= wip_constants.full_logging) then
2794: wip_logger.log('done calling inventory api to release locks on MOQD', l_retStatus);
2795: end if;
2796:
2797: if (l_logLevel <= wip_constants.trace_logging) then
2798: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',

Line 2798: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',

2794: wip_logger.log('done calling inventory api to release locks on MOQD', l_retStatus);
2795: end if;
2796:
2797: if (l_logLevel <= wip_constants.trace_logging) then
2798: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2799: p_procReturnStatus => x_returnStatus,
2800: p_msg => 'success',
2801: x_returnStatus => l_retStatus); --discard logging return status
2802: wip_logger.cleanup(l_retStatus);

Line 2802: wip_logger.cleanup(l_retStatus);

2798: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2799: p_procReturnStatus => x_returnStatus,
2800: p_msg => 'success',
2801: x_returnStatus => l_retStatus); --discard logging return status
2802: wip_logger.cleanup(l_retStatus);
2803: end if;
2804:
2805: exception
2806: when others then

Line 2809: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',

2805: exception
2806: when others then
2807: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2808: if(l_logLevel <= wip_constants.trace_logging) then
2809: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2810: p_procReturnStatus => x_returnStatus,
2811: p_msg => 'unexpected error: ' || SQLERRM,
2812: x_returnStatus => l_retStatus); --discard logging return status
2813: wip_logger.cleanup(l_retStatus);

Line 2813: wip_logger.cleanup(l_retStatus);

2809: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2810: p_procReturnStatus => x_returnStatus,
2811: p_msg => 'unexpected error: ' || SQLERRM,
2812: x_returnStatus => l_retStatus); --discard logging return status
2813: wip_logger.cleanup(l_retStatus);
2814: end if;
2815: end postInvWIPProcessing;
2816: end wip_mti_pub;