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_CONSTANTS

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

13: l_errMsg VARCHAR2(240);
14:
15:
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,

Line 50: and wip_entity_type <> wip_constants.eam

46: error_explanation = l_errMsg
47: where transaction_header_id = p_txnHdrID
48: and process_flag = 1
49: and transaction_source_type_id = 5
50: and wip_entity_type <> wip_constants.eam
51: and ( rebuild_item_id is not null
52: or rebuild_serial_number is not null
53: or rebuild_job_name is not null
54: or rebuild_activity_id is not null);

Line 184: and transaction_action_id <> wip_constants.isscomp_action

180: error_explanation = l_errMsg
181: where transaction_header_id = p_txnHdrID
182: and process_flag = 1
183: and transaction_source_type_id = 5
184: and transaction_action_id <> wip_constants.isscomp_action
185: and rebuild_item_id is not null;
186:
187:
188:

Line 304: and msi.serial_number_control_code in (wip_constants.full_sn,

300: from mtl_system_items msi, mtl_parameters mp
301: where mti.rebuild_item_id = msi.inventory_item_id
302: and mti.organization_id = mp.maint_organization_id
303: and mp.organization_id = msi.organization_id
304: and msi.serial_number_control_code in (wip_constants.full_sn,
305: wip_constants.dyn_rcv_sn));
306:
307:
308:

Line 305: wip_constants.dyn_rcv_sn));

301: where mti.rebuild_item_id = msi.inventory_item_id
302: and mti.organization_id = mp.maint_organization_id
303: and mp.organization_id = msi.organization_id
304: and msi.serial_number_control_code in (wip_constants.full_sn,
305: wip_constants.dyn_rcv_sn));
306:
307:
308:
309:

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

349: and msn.gen_object_id = mog.object_id --rebuild item's gen_object_id
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

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

362: fnd_msg_pub.add_exc_msg(p_pkg_name => 'wip_eamMtlProc_priv',
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

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

387: type char_tbl_t is table of varchar2(30);
388: l_serialNumTbl char_tbl_t := char_tbl_t(null);
389:
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,

Line 404: ((p_compRec.eamItemType <> wip_constants.rebuild_item_type) and

400: end if;
401: x_returnStatus := fnd_api.g_ret_sts_success;
402:
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,

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

402:
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

Line 416: if(p_compRec.serialControlCode in (wip_constants.full_sn, wip_constants.dyn_rcv_sn)) then

412: return;
413: end if;
414: --if the issued item is serial controlled, we need to insert a new row in the
415: --assets genealogy w/the serial number.
416: if(p_compRec.serialControlCode in (wip_constants.full_sn, wip_constants.dyn_rcv_sn)) then
417:
418: --rebuildable item transactions must always only involve a qty of 1.
419: --we have already checked the serial_control_code so a serial number must be in MSNT
420: if(p_compRec.lotControlCode = wip_constants.no_lot) then

Line 420: if(p_compRec.lotControlCode = wip_constants.no_lot) then

416: if(p_compRec.serialControlCode in (wip_constants.full_sn, wip_constants.dyn_rcv_sn)) then
417:
418: --rebuildable item transactions must always only involve a qty of 1.
419: --we have already checked the serial_control_code so a serial number must be in MSNT
420: if(p_compRec.lotControlCode = wip_constants.no_lot) then
421: select fm_serial_number
422: bulk collect into l_serialNumTbl
423: from mtl_serial_numbers_temp
424: where transaction_temp_id = p_compRec.txnTmpID;

Line 455: if(p_compRec.txnActionID = wip_constants.isscomp_action) then

451: --obj type=3 means maintenance_object_id is a instance_id in CII
452: --obj src=1 to make sure WO is not from ASO.
453: --this check should be moved to an EAM package.
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;

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

453: --this check should be moved to an EAM package.
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:

Line 462: 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
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);

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

475: x_return_status => x_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

Line 482: elsif(p_compRec.txnActionID = wip_constants.retcomp_action) then

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);
485: end if;
486: x_returnStatus := fnd_api.g_ret_sts_success;

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

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);
485: end if;
486: x_returnStatus := fnd_api.g_ret_sts_success;
487: for i in 1..l_serialNumTbl.count loop

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

495: x_return_status => x_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:

Line 517: p_compRec.txnActionID = wip_constants.isscomp_action) then

513: end if;
514: end if; --For bug 6892336, we do not deal with genealogy for non-serial item
515:
516: if(p_compRec.rebuildItemID > 0 and
517: p_compRec.txnActionID = wip_constants.isscomp_action) then
518: ----------------------------------------------------------------------------------
519: -- This call:
520: -- + inserts a record into wjsi
521: -- + submits the mass load concurrent request (will run when final commit occurs)

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

530: fnd_msg_pub.add; --add the returned error message to the stack.
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

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

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',
540: p_procReturnStatus => x_returnStatus,
541: p_msg => 'procedure success.',
542: x_returnStatus => l_returnStatus); --discard logging return status

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

543: end if;
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

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

554: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
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