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 207: and wip_entity_type = wip_constants.eam -- bug 9312526, this validation is only for eAM WOs not WIP

203: error_explanation = l_errMsg
204: where transaction_header_id = p_txnHdrID
205: and process_flag = 1
206: and transaction_source_type_id = 5
207: and wip_entity_type = wip_constants.eam -- bug 9312526, this validation is only for eAM WOs not WIP
208: and abs(primary_quantity) <> 1
209: and exists (select 1
210: from mtl_system_items msi
211: where msi.inventory_item_id = mti.inventory_item_id

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

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

Line 306: wip_constants.dyn_rcv_sn));

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

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

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

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

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

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

395: l_eam_itemType NUMBER;
396: --bug 10262178
397:
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,

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

408: end if;
409: x_returnStatus := fnd_api.g_ret_sts_success;
410:
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,

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

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

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

420: return;
421: end if;
422: --if the issued item is serial controlled, we need to insert a new row in the
423: --assets genealogy w/the serial number.
424: if(p_compRec.serialControlCode in (wip_constants.full_sn, wip_constants.dyn_rcv_sn)) then
425:
426: --rebuildable item transactions must always only involve a qty of 1.
427: --we have already checked the serial_control_code so a serial number must be in MSNT
428: if(p_compRec.lotControlCode = wip_constants.no_lot) then

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

424: if(p_compRec.serialControlCode in (wip_constants.full_sn, wip_constants.dyn_rcv_sn)) then
425:
426: --rebuildable item transactions must always only involve a qty of 1.
427: --we have already checked the serial_control_code so a serial number must be in MSNT
428: if(p_compRec.lotControlCode = wip_constants.no_lot) then
429: select fm_serial_number
430: bulk collect into l_serialNumTbl
431: from mtl_serial_numbers_temp
432: where transaction_temp_id = p_compRec.txnTmpID;

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

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

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

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

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

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

541: x_msg_data => l_msgData);
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

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

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

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

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

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

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

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

579: end if;
580: end if; --For bug 6892336, we do not deal with genealogy for non-serial item
581:
582: if(p_compRec.rebuildItemID > 0 and
583: p_compRec.txnActionID = wip_constants.isscomp_action) then
584: ----------------------------------------------------------------------------------
585: -- This call:
586: -- + inserts a record into wjsi
587: -- + submits the mass load concurrent request (will run when final commit occurs)

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

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

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

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

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

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

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

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