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

Line 5: x_params OUT NOCOPY wip_logger.param_tbl_t);

1: package body wip_eamMtlProc_priv as
2: /* $Header: wipemppb.pls 120.11 2011/01/03 09:48:39 vchidura ship $ */
3:
4: procedure fillIssueParamTbl(p_compRec IN wip_mtlTempProc_grp.comp_rec_t,
5: x_params OUT NOCOPY wip_logger.param_tbl_t);
6:
7:
8: procedure validateTxns(p_txnHdrID IN NUMBER,
9: x_returnStatus OUT NOCOPY VARCHAR2) is

Line 10: l_params wip_logger.param_tbl_t;

6:
7:
8: procedure validateTxns(p_txnHdrID IN NUMBER,
9: x_returnStatus OUT NOCOPY VARCHAR2) is
10: l_params wip_logger.param_tbl_t;
11: l_logLevel NUMBER := fnd_log.g_current_runtime_level;
12: l_returnStatus VARCHAR2(1);
13: l_errMsg VARCHAR2(240);
14:

Line 20: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.validateTxns',

16: begin
17: if (l_logLevel <= wip_constants.trace_logging) then
18: l_params(1).paramName := 'p_txnHdrID';
19: l_params(1).paramValue := p_txnHdrID;
20: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.validateTxns',
21: p_params => l_params,
22: x_returnStatus => x_returnStatus);
23: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
24: raise fnd_api.g_exc_unexpected_error;

Line 355: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_validateTxns',

351: and mog.start_date_active <= mti.transaction_date
352: and (mog.end_date_active is null or mog.end_date_active >= mti.transaction_date)))));
353:
354: if (l_logLevel <= wip_constants.trace_logging) then
355: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_validateTxns',
356: p_procReturnStatus => x_returnStatus,
357: p_msg => 'success',
358: x_returnStatus => l_returnStatus); --discard logging return status
359: end if;

Line 368: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_validateTxns',

364: p_procedure_name => 'validateTxns',
365: p_error_text => SQLERRM);
366:
367: if (l_logLevel <= wip_constants.trace_logging) then
368: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_validateTxns',
369: p_procReturnStatus => x_returnStatus,
370: p_msg => 'unexp error:' || SQLERRM,
371: x_returnStatus => l_returnStatus); --discard logging return status
372: end if;

Line 377: l_params wip_logger.param_tbl_t;

373: end validateTxns;
374:
375: procedure processCompTxn(p_compRec IN wip_mtlTempProc_grp.comp_rec_t,
376: x_returnStatus OUT NOCOPY VARCHAR2) is
377: l_params wip_logger.param_tbl_t;
378: l_msgData VARCHAR2(2000);
379: l_returnStatus VARCHAR2(1);
380: l_maintObjID NUMBER;
381: l_maintGenObjID NUMBER;

Line 402: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',

398: begin
399: if (l_logLevel <= wip_constants.trace_logging) then
400: fillIssueParamTbl(p_compRec => p_compRec,
401: x_params => l_params);
402: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
403: p_params => l_params,
404: x_returnStatus => x_returnStatus);
405: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
406: raise fnd_api.g_exc_unexpected_error;

Line 415: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',

411: if(p_compRec.eamItemType is null or
412: ((p_compRec.eamItemType <> wip_constants.rebuild_item_type) and
413: (p_compRec.eamItemType <> 1))) then
414: if (l_logLevel <= wip_constants.trace_logging) then
415: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
416: p_procReturnStatus => x_returnStatus,
417: p_msg => 'success(not an eam item)',
418: x_returnStatus => l_returnStatus); --discard logging return status
419: end if;

Line 480: wip_logger.log('calling create gen', l_returnStatus);

476: if(l_maintObjType = 3 and l_maintObjSrc = 1) then
477: if(p_compRec.txnActionID = wip_constants.isscomp_action) then
478: --insert the issued item into the asset's genealogy
479: if (l_logLevel <= wip_constants.full_logging) then
480: wip_logger.log('calling create gen', l_returnStatus);
481: end if;
482: x_returnStatus := fnd_api.g_ret_sts_success;
483:
484: if (l_logLevel <= wip_constants.full_logging) then

Line 485: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);

481: end if;
482: x_returnStatus := fnd_api.g_ret_sts_success;
483:
484: if (l_logLevel <= wip_constants.full_logging) then
485: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
486: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
487: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
488: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
489: end if;

Line 486: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);

482: x_returnStatus := fnd_api.g_ret_sts_success;
483:
484: if (l_logLevel <= wip_constants.full_logging) then
485: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
486: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
487: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
488: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
489: end if;
490:

Line 487: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);

483:
484: if (l_logLevel <= wip_constants.full_logging) then
485: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
486: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
487: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
488: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
489: end if;
490:
491: l_eam_itemType := p_compRec.eamItemType;

Line 488: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);

484: if (l_logLevel <= wip_constants.full_logging) then
485: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
486: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
487: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
488: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
489: end if;
490:
491: l_eam_itemType := p_compRec.eamItemType;
492:

Line 546: wip_logger.log('create gen returned: ' || x_returnStatus, l_returnStatus);

542: END IF; --end of check for the capital asset
543:
544:
545: if (l_logLevel <= wip_constants.full_logging) then
546: wip_logger.log('create gen returned: ' || x_returnStatus, l_returnStatus);
547: end if;
548: elsif(p_compRec.txnActionID = wip_constants.retcomp_action) then
549: if (l_logLevel <= wip_constants.full_logging) then
550: wip_logger.log('calling update gen', l_returnStatus);

Line 550: wip_logger.log('calling update gen', l_returnStatus);

546: wip_logger.log('create gen returned: ' || x_returnStatus, l_returnStatus);
547: end if;
548: elsif(p_compRec.txnActionID = wip_constants.retcomp_action) then
549: if (l_logLevel <= wip_constants.full_logging) then
550: wip_logger.log('calling update gen', l_returnStatus);
551: end if;
552: x_returnStatus := fnd_api.g_ret_sts_success;
553: for i in 1..l_serialNumTbl.count loop
554: wip_eam_genealogy_pvt.update_eam_genealogy(p_api_version => 1.0,

Line 566: wip_logger.log('upd gen returned: ' || x_returnStatus, l_returnStatus);

562: x_msg_count => l_msgCount,
563: x_msg_data => l_msgData);
564: end loop;
565: if (l_logLevel <= wip_constants.full_logging) then
566: wip_logger.log('upd gen returned: ' || x_returnStatus, l_returnStatus);
567: end if;
568: end if;
569:
570: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 601: wip_logger.log('rebuildable job creation succeeded', l_returnStatus);

597: l_errMsg := 'rebuild job creation failed';
598: raise fnd_api.g_exc_unexpected_error;
599: end if;
600: if (l_logLevel <= wip_constants.full_logging) then
601: wip_logger.log('rebuildable job creation succeeded', l_returnStatus);
602: end if;
603: end if;
604: if (l_logLevel <= wip_constants.trace_logging) then
605: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',

Line 605: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',

601: wip_logger.log('rebuildable job creation succeeded', l_returnStatus);
602: end if;
603: end if;
604: if (l_logLevel <= wip_constants.trace_logging) then
605: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
606: p_procReturnStatus => x_returnStatus,
607: p_msg => 'procedure success.',
608: x_returnStatus => l_returnStatus); --discard logging return status
609: end if;

Line 614: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',

610: exception
611: when fnd_api.g_exc_unexpected_error then
612: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
613: if (l_logLevel <= wip_constants.trace_logging) then
614: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
615: p_procReturnStatus => x_returnStatus,
616: p_msg => l_errMsg,
617: x_returnStatus => l_returnStatus); --discard logging return status
618: end if;

Line 625: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',

621: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_eamMtlProc_priv',
622: p_procedure_name => 'processCompTxn',
623: p_error_text => SQLERRM);
624: if (l_logLevel <= wip_constants.trace_logging) then
625: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
626: p_procReturnStatus => x_returnStatus,
627: p_msg => 'unexpected error: ' || SQLERRM,
628: x_returnStatus => l_returnStatus); --discard logging return status
629: end if;

Line 633: x_params OUT NOCOPY wip_logger.param_tbl_t)

629: end if;
630: end processCompTxn;
631:
632: procedure fillIssueParamTbl(p_compRec IN wip_mtlTempProc_grp.comp_rec_t,
633: x_params OUT NOCOPY wip_logger.param_tbl_t)
634: is begin
635: x_params(1).paramName := 'p_compRec.wipEntityId';
636: x_params(1).paramValue := p_compRec.wipEntityId;
637: x_params(2).paramName := 'p_compRec.repLineID';