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.9 2008/05/07 20:24:45 fli 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 354: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_validateTxns',

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

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

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

Line 376: l_params wip_logger.param_tbl_t;

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

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

390: begin
391: if (l_logLevel <= wip_constants.trace_logging) then
392: fillIssueParamTbl(p_compRec => p_compRec,
393: x_params => l_params);
394: wip_logger.entryPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
395: p_params => l_params,
396: x_returnStatus => x_returnStatus);
397: if(x_returnStatus <> fnd_api.g_ret_sts_success) then
398: raise fnd_api.g_exc_unexpected_error;

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

403: if(p_compRec.eamItemType is null or
404: ((p_compRec.eamItemType <> wip_constants.rebuild_item_type) and
405: (p_compRec.eamItemType <> 1))) then
406: if (l_logLevel <= wip_constants.trace_logging) then
407: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
408: p_procReturnStatus => x_returnStatus,
409: p_msg => 'success(not an eam item)',
410: x_returnStatus => l_returnStatus); --discard logging return status
411: end if;

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

454: if(l_maintObjType = 3 and l_maintObjSrc = 1) then
455: if(p_compRec.txnActionID = wip_constants.isscomp_action) then
456: --insert the issued item into the asset's genealogy
457: if (l_logLevel <= wip_constants.full_logging) then
458: wip_logger.log('calling create gen', l_returnStatus);
459: end if;
460: x_returnStatus := fnd_api.g_ret_sts_success;
461:
462: if (l_logLevel <= wip_constants.full_logging) then

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

459: end if;
460: x_returnStatus := fnd_api.g_ret_sts_success;
461:
462: if (l_logLevel <= wip_constants.full_logging) then
463: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
464: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
465: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
466: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
467: end if;

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

460: x_returnStatus := fnd_api.g_ret_sts_success;
461:
462: if (l_logLevel <= wip_constants.full_logging) then
463: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
464: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
465: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
466: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
467: end if;
468:

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

461:
462: if (l_logLevel <= wip_constants.full_logging) then
463: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
464: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
465: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
466: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
467: end if;
468:
469: wip_eam_genealogy_pvt.create_eam_genealogy(p_api_version => 1.0,

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

462: if (l_logLevel <= wip_constants.full_logging) then
463: wip_logger.log('maintenance object id is: ' || l_maintObjID, l_returnStatus);
464: wip_logger.log('maintenance object type is: ' || l_maintObjType, l_returnStatus);
465: wip_logger.log('maintenance object source is: ' || l_maintObjSrc, l_returnStatus);
466: wip_logger.log('gen object id is: ' || l_maintGenObjID, l_returnStatus);
467: end if;
468:
469: wip_eam_genealogy_pvt.create_eam_genealogy(p_api_version => 1.0,
470: p_serial_number => l_serialNumTbl(1),

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

476: x_msg_count => l_msgCount,
477: x_msg_data => l_msgData);
478:
479: if (l_logLevel <= wip_constants.full_logging) then
480: wip_logger.log('create gen returned: ' || x_returnStatus, l_returnStatus);
481: end if;
482: elsif(p_compRec.txnActionID = wip_constants.retcomp_action) then
483: if (l_logLevel <= wip_constants.full_logging) then
484: wip_logger.log('calling update gen', l_returnStatus);

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

480: wip_logger.log('create gen returned: ' || x_returnStatus, l_returnStatus);
481: end if;
482: elsif(p_compRec.txnActionID = wip_constants.retcomp_action) then
483: if (l_logLevel <= wip_constants.full_logging) then
484: wip_logger.log('calling update gen', l_returnStatus);
485: end if;
486: x_returnStatus := fnd_api.g_ret_sts_success;
487: for i in 1..l_serialNumTbl.count loop
488: wip_eam_genealogy_pvt.update_eam_genealogy(p_api_version => 1.0,

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

496: x_msg_count => l_msgCount,
497: x_msg_data => l_msgData);
498: end loop;
499: if (l_logLevel <= wip_constants.full_logging) then
500: wip_logger.log('upd gen returned: ' || x_returnStatus, l_returnStatus);
501: end if;
502: end if;
503:
504: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

531: l_errMsg := 'rebuild job creation failed';
532: raise fnd_api.g_exc_unexpected_error;
533: end if;
534: if (l_logLevel <= wip_constants.full_logging) then
535: wip_logger.log('rebuildable job creation succeeded', l_returnStatus);
536: end if;
537: end if;
538: if (l_logLevel <= wip_constants.trace_logging) then
539: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',

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

535: wip_logger.log('rebuildable job creation succeeded', l_returnStatus);
536: end if;
537: end if;
538: if (l_logLevel <= wip_constants.trace_logging) then
539: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
540: p_procReturnStatus => x_returnStatus,
541: p_msg => 'procedure success.',
542: x_returnStatus => l_returnStatus); --discard logging return status
543: end if;

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

544: exception
545: when fnd_api.g_exc_unexpected_error then
546: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
547: if (l_logLevel <= wip_constants.trace_logging) then
548: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
549: p_procReturnStatus => x_returnStatus,
550: p_msg => l_errMsg,
551: x_returnStatus => l_returnStatus); --discard logging return status
552: end if;

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

555: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_eamMtlProc_priv',
556: p_procedure_name => 'processCompTxn',
557: p_error_text => SQLERRM);
558: if (l_logLevel <= wip_constants.trace_logging) then
559: wip_logger.exitPoint(p_procName => 'wip_eamMtlProc_priv.processCompTxn',
560: p_procReturnStatus => x_returnStatus,
561: p_msg => 'unexpected error: ' || SQLERRM,
562: x_returnStatus => l_returnStatus); --discard logging return status
563: end if;

Line 567: x_params OUT NOCOPY wip_logger.param_tbl_t)

563: end if;
564: end processCompTxn;
565:
566: procedure fillIssueParamTbl(p_compRec IN wip_mtlTempProc_grp.comp_rec_t,
567: x_params OUT NOCOPY wip_logger.param_tbl_t)
568: is begin
569: x_params(1).paramName := 'p_compRec.wipEntityId';
570: x_params(1).paramValue := p_compRec.wipEntityId;
571: x_params(2).paramName := 'p_compRec.repLineID';