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 105: l_params wip_logger.param_tbl_t;

101: l_tbls mti_recTbl_t;
102: l_errTbls mti_err_recTbl_t;
103: l_count NUMBER;
104: l_returnStatus VARCHAR2(1);
105: l_params wip_logger.param_tbl_t;
106: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
107: l_errExp VARCHAR2(240);
108: l_convPriQty NUMBER;
109: l_convOverCplPriQty NUMBER;

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

111: begin
112: if (l_logLevel <= wip_constants.trace_logging) then
113: l_params(1).paramName := 'p_txnHeaderID';
114: l_params(1).paramValue := p_txnHeaderID;
115: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvWipProcessing',
116: p_params => l_params,
117: x_returnStatus => x_returnStatus);
118: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
119: raise fnd_api.g_exc_unexpected_error;

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

195: /* End of fix for Bug 5411401 */
196:
197: if(l_convErrExists) then
198: if(l_logLevel <= wip_constants.full_logging) then
199: wip_logger.log('uom conversion failed.', l_returnStatus);
200: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
201: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
202: end if;
203: fnd_message.set_name('INV', 'INV_INT_UOMEXP');

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

196:
197: if(l_convErrExists) then
198: if(l_logLevel <= wip_constants.full_logging) then
199: wip_logger.log('uom conversion failed.', l_returnStatus);
200: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
201: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
202: end if;
203: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
204: l_errExp := fnd_message.get;

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

197: if(l_convErrExists) then
198: if(l_logLevel <= wip_constants.full_logging) then
199: wip_logger.log('uom conversion failed.', l_returnStatus);
200: wip_logger.log('l_convPriQty' || l_convPriQty, l_returnStatus);
201: wip_logger.log('l_convOverCplPriQty' || l_convOverCplPriQty, l_returnStatus);
202: end if;
203: fnd_message.set_name('INV', 'INV_INT_UOMEXP');
204: l_errExp := fnd_message.get;
205: update mtl_transactions_interface

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

233: primary_quantity = l_tbls.priQty(i),
234: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
235: where transaction_interface_id = l_tbls.txnIntID(i);
236: if(l_logLevel <= wip_constants.full_logging) then
237: wip_logger.log('pri qty:' || l_tbls.priQty(i), l_returnStatus);
238: wip_logger.log('ovcpl pri qty:' || l_tbls.overCplPriQty(i), l_returnStatus);
239: end if;
240: end if;
241:

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

234: overcompletion_primary_qty = l_tbls.overCplPriQty(i)
235: where transaction_interface_id = l_tbls.txnIntID(i);
236: if(l_logLevel <= wip_constants.full_logging) then
237: wip_logger.log('pri qty:' || l_tbls.priQty(i), l_returnStatus);
238: wip_logger.log('ovcpl pri qty:' || l_tbls.overCplPriQty(i), l_returnStatus);
239: end if;
240: end if;
241:
242: if(l_tbls.wipEntityType(i) <> wip_constants.flow and not l_convErrExists) then

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

240: end if;
241:
242: if(l_tbls.wipEntityType(i) <> wip_constants.flow and not l_convErrExists) then
243: if(l_logLevel <= wip_constants.full_logging) then
244: wip_logger.log('calling work order row-by-row processor', l_returnStatus);
245: end if;
246: preInvProcessWorkOrder(p_txnHeaderID => p_txnHeaderID,
247: p_tbls => l_tbls,
248: p_index => i,

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

252: end loop;
253:
254: if ( l_errTbls.txnIntID is not null ) then
255: if(l_logLevel <= wip_constants.full_logging) then
256: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);
257: for i in 1..l_errTbls.txnIntID.count loop
258: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);
259: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);
260: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);

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

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

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

255: if(l_logLevel <= wip_constants.full_logging) then
256: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);
257: for i in 1..l_errTbls.txnIntID.count loop
258: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);
259: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);
260: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);
261: end loop;
262: end if;
263:

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

256: wip_logger.log(l_errTbls.txnIntID.count || ' records failed work order pre-processing', l_returnStatus);
257: for i in 1..l_errTbls.txnIntID.count loop
258: wip_logger.log('txnIntID: ' || l_errTbls.txnIntID(i), l_returnStatus);
259: wip_logger.log(' errCode: ' || l_errTbls.errCode(i), l_returnStatus);
260: wip_logger.log(' errExpl: ' || l_errTbls.errExpl(i), l_returnStatus);
261: end loop;
262: end if;
263:
264: forall i in 1..l_errTbls.txnIntID.count

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

277: where transaction_interface_id = l_errTbls.txnIntID(i);
278: end if;
279:
280: if(l_logLevel <= wip_constants.full_logging) then
281: wip_logger.log('calling flow group processor', l_returnStatus);
282: end if;
283:
284: preInvProcessFlow(p_txnHeaderID => p_txnHeaderID,
285: x_returnStatus => l_returnStatus);

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

285: x_returnStatus => l_returnStatus);
286:
287:
288: if (l_logLevel <= wip_constants.trace_logging) then
289: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
290: p_procReturnStatus => x_returnStatus,
291: p_msg => 'success',
292: x_returnStatus => l_returnStatus);
293: wip_logger.cleanup(l_returnStatus);

Line 293: wip_logger.cleanup(l_returnStatus);

289: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
290: p_procReturnStatus => x_returnStatus,
291: p_msg => 'success',
292: x_returnStatus => l_returnStatus);
293: wip_logger.cleanup(l_returnStatus);
294: end if;
295: exception
296: when others then
297: rollback to wipmtivb1;

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

314: and transaction_source_type_id = 5
315: and process_flag = wip_constants.mti_inventory;
316:
317: if(l_logLevel <= wip_constants.trace_logging) then
318: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
319: p_procReturnStatus => x_returnStatus,
320: p_msg => 'unexpected error: ' || SQLERRM,
321: x_returnStatus => l_returnStatus); --discard logging return status
322: wip_logger.cleanup(l_returnStatus);

Line 322: wip_logger.cleanup(l_returnStatus);

318: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
319: p_procReturnStatus => x_returnStatus,
320: p_msg => 'unexpected error: ' || SQLERRM,
321: x_returnStatus => l_returnStatus); --discard logging return status
322: wip_logger.cleanup(l_returnStatus);
323: end if;
324: end preInvWIPProcessing;
325:
326: procedure preInvProcessWorkOrder(p_txnHeaderID in number,

Line 337: l_params wip_logger.param_tbl_t;

333: l_lsRequired NUMBER;
334: l_msg VARCHAR2(2000);
335: l_errCount NUMBER;
336: l_count NUMBER;
337: l_params wip_logger.param_tbl_t;
338: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
339: l_returnStatus VARCHAR2(1);
340: begin
341: savepoint wipmtivb10;

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

345: l_params(1).paramValue := p_txnHeaderID;
346: l_params(2).paramName := 'p_index';
347: l_params(2).paramValue := p_index;
348:
349: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessWorkOrder',
350: p_params => l_params,
351: x_returnStatus => x_returnStatus);
352: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
353: raise fnd_api.g_exc_unexpected_error;

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

361: elsif(p_tbls.txnActionID(p_index) = wip_constants.retassy_action) then
362: l_txnType := wip_constants.ret_txn;
363: else --scrap. don't do anything
364: if (l_logLevel <= wip_constants.trace_logging) then
365: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
366: p_procReturnStatus => x_returnStatus,
367: p_msg => 'success (scrap txn)',
368: x_returnStatus => l_returnStatus);
369: end if;

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

372:
373: --if repetitive cpl, check allocation table to see if schedule has already been pre-processed
374: if(p_tbls.repLineID(p_index) is not null) then
375: if (l_logLevel <= wip_constants.full_logging) then
376: wip_logger.log('doing repetitive processing', l_returnStatus);
377: end if;
378: select count(*)
379: into l_count
380: from wip_mtl_allocations_temp

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

381: where transaction_temp_id = p_tbls.txnIntID(p_index);
382:
383: if(l_count = 0) then
384: if (l_logLevel <= wip_constants.full_logging) then
385: wip_logger.log('found unallocated schedule', l_returnStatus);
386: end if;
387: wip_cplProc_priv.preAllocateSchedules(p_txnHdrID => p_txnHeaderID,
388: p_cplTxnID => p_tbls.cplTxnID(p_index),
389: p_txnActionID => p_tbls.txnActionID(p_index),

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

407: and transaction_action_id in (wip_constants.isscomp_action, wip_constants.retcomp_action,
408: wip_constants.issnegc_action, wip_constants.retnegc_action);
409: if(l_count = 0) then
410: if (l_logLevel <= wip_constants.full_logging) then
411: wip_logger.log('backflushing cpl', l_returnStatus);
412: end if;
413: wip_bflProc_priv.backflush(p_wipEntityID => p_tbls.wipEntityID(p_index),
414: p_orgID => p_tbls.orgID(p_index),
415: p_primaryQty => abs(p_tbls.priQty(p_index)),

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

432: x_lotSerRequired => l_lsRequired,
433: x_returnStatus => x_returnStatus);
434:
435: if (l_logLevel <= wip_constants.full_logging) then
436: wip_logger.log('bf required:' || l_bfRequired, l_returnStatus);
437: wip_logger.log('ls required:' || l_lsRequired, l_returnStatus);
438: end if;
439: --if the procedure fails or some lot/serial info for backflush components can not
440: --be derived then error

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

433: x_returnStatus => x_returnStatus);
434:
435: if (l_logLevel <= wip_constants.full_logging) then
436: wip_logger.log('bf required:' || l_bfRequired, l_returnStatus);
437: wip_logger.log('ls required:' || l_lsRequired, l_returnStatus);
438: end if;
439: --if the procedure fails or some lot/serial info for backflush components can not
440: --be derived then error
441: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

448: end if;
449:
450: end if;
451: if (l_logLevel <= wip_constants.trace_logging) then
452: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
453: p_procReturnStatus => x_returnStatus,
454: p_msg => 'success',
455: x_returnStatus => l_returnStatus);
456: end if;

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

462: p_errTbls.txnIntID(l_errCount) := p_tbls.txnIntID(p_index);
463: p_errTbls.errCode(l_errCount) := 'WIP_PREPROCESSING';
464: wip_utilities.get_message_stack(p_msg => l_msg);
465: if(l_logLevel <= wip_constants.trace_logging) then
466: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
467: p_procReturnStatus => x_returnStatus,
468: p_msg => 'error:' || l_msg,
469: x_returnStatus => l_returnStatus);
470: end if;

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

470: end if;
471: p_errTbls.errExpl(l_errCount) := substrb(l_msg, 1, 240);
472: when others then
473: if(l_logLevel <= wip_constants.trace_logging) then
474: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvWIPProcessing',
475: p_procReturnStatus => x_returnStatus,
476: p_msg => 'unexp error:' || SQLERRM,
477: x_returnStatus => l_returnStatus);
478: end if;

Line 522: l_params wip_logger.param_tbl_t;

518: and transaction_action_id in (WIP_CONSTANTS.SCRASSY_ACTION,
519: WIP_CONSTANTS.CPLASSY_ACTION,
520: WIP_CONSTANTS.RETASSY_ACTION);
521: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);
522: l_params wip_logger.param_tbl_t;
523: l_returnStatus varchar2(1);
524: l_msgCount number;
525: l_msgData varchar2(240);
526:

Line 557: l_params wip_logger.param_tbl_t;

553:
554: l_primaryUOM varchar2(3);
555: l_primaryQty number;
556:
557: l_params wip_logger.param_tbl_t;
558: l_returnStatus varchar2(1);
559: l_errCode varchar2(240);
560: l_errMsg varchar2(240);
561: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

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

564:
565: if (l_logLevel <= wip_constants.trace_logging) then
566: l_params(1).paramName := 'p_txnHeaderID';
567: l_params(1).paramValue := p_txnHeaderID;
568: wip_logger.entryPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
569: p_params => l_params,
570: x_returnStatus => x_returnStatus);
571: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
572: raise fnd_api.g_exc_unexpected_error;

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

576: -- do derivation and validation only for flow records
577: wip_flowUtil_priv.processFlowInterfaceRecords(p_txnHeaderID);
578:
579: if (l_logLevel <= wip_constants.trace_logging) then
580: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
581: p_procReturnStatus => x_returnStatus,
582: p_msg => 'Finished pre inventory flow processing!',
583: x_returnStatus => l_returnStatus); --discard logging return status
584: end if;

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

585: exception
586: when others then
587: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
588: if (l_logLevel <= wip_constants.trace_logging) then
589: wip_logger.exitPoint(p_procName => 'wip_mti_pub.preInvProcessFlow',
590: p_procReturnStatus => x_returnStatus,
591: p_msg => 'unexpected error: ' || SQLERRM,
592: x_returnStatus => l_returnStatus); --discard logging return status
593: end if;

Line 742: l_params wip_logger.param_tbl_t;

738: l_priQty number;
739: l_errNum number;
740: l_errCode varchar2(240);*/
741: l_poExpToAssetTnsf number;
742: l_params wip_logger.param_tbl_t;
743: l_returnStatus varchar2(1);
744: l_errMsg varchar2(240);
745: l_engItemFlag number := 2;
746: l_logLevel NUMBER := to_number(fnd_log.g_current_runtime_level);

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

748:
749: if (l_logLevel <= wip_constants.trace_logging) then
750: l_params(1).paramName := 'p_txnHeaderID';
751: l_params(1).paramValue := p_txnHeaderID;
752: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWIPValidation.',
753: p_params => l_params,
754: x_returnStatus => x_returnStatus);
755: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
756: raise fnd_api.g_exc_unexpected_error;

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

1829: and negative_req_flag is not null
1830: and negative_req_flag not in (1, -1);
1831:
1832: if(l_logLevel <= wip_constants.full_logging) then
1833: wip_logger.log('about to call EAM validations', l_returnStatus);
1834: end if;
1835:
1836: -- for discrete job, we do not support background transactions for
1837: -- serialized job

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

1888: wip_eamMtlProc_priv.validateTxns(p_txnHdrID => p_txnHeaderID,
1889: x_returnStatus => x_returnStatus);
1890:
1891: if(l_logLevel <= wip_constants.full_logging) then
1892: wip_logger.log('EAM validation routine returned:' || x_returnStatus, l_returnStatus);
1893: end if;
1894:
1895: /* Fix for bug 5708242: Call to cstpacms.validate_move_snap_to_temp has been moved to
1896: wip_cplProc_priv.processTemp (wipcplpb.pls). Calling it here will commit records to

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

1934: end if;
1935: end loop;*/
1936:
1937: if(l_logLevel <= wip_constants.trace_logging) then
1938: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',
1939: p_procReturnStatus => x_returnStatus,
1940: p_msg => 'Finished validating interface rows!',
1941: x_returnStatus => l_returnStatus); --discard logging return status
1942: end if;

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

1943: exception
1944: when others then
1945: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
1946: if (l_logLevel <= wip_constants.trace_logging) then
1947: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPValidation',
1948: p_procReturnStatus => x_returnStatus,
1949: p_msg => 'unexpected error: ' || SQLERRM,
1950: x_returnStatus => l_returnStatus); --discard logging return status
1951: end if;

Line 1997: l_params wip_logger.param_tbl_t;

1993: l_returnStatus VARCHAR2(1);
1994: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
1995: l_errCode VARCHAR2(240);
1996: l_errMsg VARCHAR2(240);
1997: l_params wip_logger.param_tbl_t;
1998: l_orgIDTbl num_tbl_t;
1999: l_rowidTbl rowid_tbl_t;
2000: l_subCodeTbl big_char_tbl_t;
2001: l_itemIDTbl num_tbl_t;

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

2049: begin
2050: if (l_logLevel <= wip_constants.trace_logging) then
2051: l_params(1).paramName := 'p_txnHeaderID';
2052: l_params(1).paramValue := p_txnHeaderID;
2053: wip_logger.entryPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2054: p_params => l_params,
2055: x_returnStatus => l_returnStatus);
2056: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
2057: raise fnd_api.g_exc_unexpected_error;

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

2354: and transaction_source_id is not null;
2355:
2356:
2357: if(l_logLevel <= wip_constants.full_logging) then
2358: wip_logger.log('about to fetch records for name -> item derivation', l_returnStatus);
2359: end if;
2360: --item id from name
2361: open c_itemTxns;
2362: fetch c_itemTxns

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

2376:
2377: for i in 1..l_orgIDTbl.count loop
2378: if(l_itemIDTbl(i) is null) then
2379: if(l_logLevel <= wip_constants.full_logging) then
2380: wip_logger.log('about to derive item id from name', l_returnStatus);
2381: end if;
2382: if(not inv_txn_manager_grp.getitemid(x_itemID => l_itemIDTbl(i),
2383: p_orgID => l_orgIDTbl(i),
2384: p_rowid => l_rowidTbl(i))) then

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

2383: p_orgID => l_orgIDTbl(i),
2384: p_rowid => l_rowidTbl(i))) then
2385: l_itemIDTbl(i) := null;--let inventory error out later
2386: if(l_logLevel <= wip_constants.full_logging) then
2387: wip_logger.log('item id from name derivation failed', l_returnStatus);
2388: end if;
2389: elsif(l_logLevel <= wip_constants.full_logging) then
2390: wip_logger.log('item id' || l_itemIDTbl(i), l_returnStatus);
2391: end if;

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

2386: if(l_logLevel <= wip_constants.full_logging) then
2387: wip_logger.log('item id from name derivation failed', l_returnStatus);
2388: end if;
2389: elsif(l_logLevel <= wip_constants.full_logging) then
2390: wip_logger.log('item id' || l_itemIDTbl(i), l_returnStatus);
2391: end if;
2392: end if;
2393:
2394: /* FP bug 5708701 (base bug 5046732) - Removed the code to derive locator id. We do not require locator_id.

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

2409: and mp.organization_id = sub.organization_id
2410: and mp.organization_id = it.organization_id;
2411:
2412: if(l_logLevel <= wip_constants.full_logging) then
2413: wip_logger.log('about to derive locator id from name', l_returnStatus);
2414: end if;
2415: if(not inv_txn_manager_grp.getlocid(x_locID => l_locIDTbl(i),
2416: p_org_id => l_orgIDTbl(i),
2417: p_subinv => l_subCodeTbl(i),

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

2418: p_rowid => l_rowidTbl(i),
2419: p_locCtrl => l_locCtrl)) then
2420: l_locIDTbl(i) := null; --let inventory error out later
2421: if(l_logLevel <= wip_constants.full_logging) then
2422: wip_logger.log('locator id from name derivation failed', l_returnStatus);
2423: end if;
2424: end if;
2425: end if;
2426: */

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

2604: and wfs.wip_entity_id = mti.transaction_source_id
2605: and wfs.status = 2);
2606:
2607: if (l_logLevel <= wip_constants.trace_logging) then
2608: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2609: p_procReturnStatus => x_returnStatus,
2610: p_msg => 'normal completion',
2611: x_returnStatus => l_returnStatus);
2612: end if;

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

2630: and transaction_source_type_id = 5
2631: and process_flag = wip_constants.mti_inventory;
2632:
2633: if(l_logLevel <= wip_constants.trace_logging) then
2634: wip_logger.exitPoint(p_procName => 'wip_mti_pub.doPreProcessingValidations',
2635: p_procReturnStatus => x_returnStatus,
2636: p_msg => 'unexpected error: ' || SQLERRM,
2637: x_returnStatus => l_returnStatus); --discard logging return status
2638: end if;

Line 2652: l_params wip_logger.param_tbl_t;

2648: l_itemIDTbl num_tbl_t;
2649: l_orgIDTbl num_tbl_t;
2650: l_itemNameTbl big_char_tbl_t;
2651: l_retStatus VARCHAR2(1);
2652: l_params wip_logger.param_tbl_t;
2653: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
2654: begin
2655: x_returnStatus := fnd_api.g_ret_sts_success;
2656:

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

2658: l_params(1).paramName := 'p_txnHeaderID';
2659: l_params(1).paramValue := p_txnHeaderID;
2660: l_params(2).paramName := 'p_txnBatchID';
2661: l_params(2).paramValue := p_txnBatchID;
2662: wip_logger.entryPoint(p_procName => 'wip_mti_pub.postInvWipProcessing',
2663: p_params => l_params,
2664: x_returnStatus => l_retStatus);
2665: end if;
2666: --delete any pre-allocations that occurred for errored records

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

2671: and transaction_batch_id = p_txnBatchID
2672: and process_flag = wip_constants.mti_error);
2673:
2674: if(l_logLevel <= wip_constants.full_logging) then
2675: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' pre-allocations', l_retStatus);
2676: end if;
2677:
2678: --fetch all errored components
2679: select mti.completion_transaction_id,

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

2713: or move_transaction_id is not null)
2714: and process_flag = wip_constants.mti_error;
2715:
2716: if(l_logLevel <= wip_constants.full_logging) then
2717: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' backflush components', l_retStatus);
2718: end if;
2719:
2720: --if any components failed update the parent with the error
2721: forall i in 1..l_errExplTbl.count

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

2736: or move_transaction_id = l_movTxnIDTbl(i))
2737: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action);
2738:
2739: if (l_logLevel <= wip_constants.trace_logging) then
2740: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2741: p_procReturnStatus => x_returnStatus,
2742: p_msg => 'success',
2743: x_returnStatus => l_retStatus); --discard logging return status
2744: wip_logger.cleanup(l_retStatus);

Line 2744: wip_logger.cleanup(l_retStatus);

2740: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2741: p_procReturnStatus => x_returnStatus,
2742: p_msg => 'success',
2743: x_returnStatus => l_retStatus); --discard logging return status
2744: wip_logger.cleanup(l_retStatus);
2745: end if;
2746:
2747: exception
2748: when others then

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

2747: exception
2748: when others then
2749: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
2750: if(l_logLevel <= wip_constants.trace_logging) then
2751: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2752: p_procReturnStatus => x_returnStatus,
2753: p_msg => 'unexpected error: ' || SQLERRM,
2754: x_returnStatus => l_retStatus); --discard logging return status
2755: wip_logger.cleanup(l_retStatus);

Line 2755: wip_logger.cleanup(l_retStatus);

2751: wip_logger.exitPoint(p_procName => 'wip_mti_pub.postInvWIPProcessing',
2752: p_procReturnStatus => x_returnStatus,
2753: p_msg => 'unexpected error: ' || SQLERRM,
2754: x_returnStatus => l_retStatus); --discard logging return status
2755: wip_logger.cleanup(l_retStatus);
2756: end if;
2757: end postInvWIPProcessing;
2758: end wip_mti_pub;