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_FLOWRESCHARGE dependencies on WIP_CONSTANTS

Line 80: or ( p_parentTxnActionID = WIP_CONSTANTS.SCRASSY_ACTION

76: and bos2.effectivity_date <= p_effDate
77: and nvl(bos2.disable_date, p_effDate+1) > p_effDate
78: and bos2.implementation_date is not null
79: and ( bos2.count_point_type in (1, 2)
80: or ( p_parentTxnActionID = WIP_CONSTANTS.SCRASSY_ACTION
81: and bos1.operation_seq_num = p_scrapLineOp));
82:
83: -- cursor to find out all the events that are not assigned to any lineop.
84: -- It is decided on the meeting(Richard, Barry, Adrian, Serena, Jung and Yong) that

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

116: begin
117: l_params(1).paramName := 'p_txnTempID';
118: l_params(1).paramValue := p_txnTempID;
119: x_returnStatus := fnd_api.g_ret_sts_success;
120: if (l_logLevel <= wip_constants.trace_logging) then
121: wip_logger.entryPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
122: p_params => l_params,
123: x_returnStatus => x_returnStatus);
124: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

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

160: where transaction_temp_id = p_txnTempID;
161:
162: chargePhantomResource(p_txnTempID, l_orgID, l_effDate, false, x_returnStatus);
163:
164: if (l_logLevel <= wip_constants.trace_logging) then
165: wip_logger.exitPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
166: p_procReturnStatus => x_returnStatus,
167: p_msg => 'No routing, tried to charge phantom',
168: x_returnStatus => l_returnStatus); --discard logging return status

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

216: -- now we got all the event/operation seq num that needs to be charged
217: -- iterate through that and find all the applicable resources attached to them
218: l_count := l_chargeTbl.first;
219: while ( l_count is not null ) loop
220: if (l_logLevel <= wip_constants.full_logging) then
221: wip_logger.log(p_msg => 'Inserting Resources for op seq/event: ' ||
222: l_chargeTbl(l_count).operation_seq_num,
223: x_returnStatus => l_returnStatus);
224: end if;

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

403: mmtt.completion_transaction_id,
404: mmtt.project_id,
405: mmtt.task_id;
406:
407: if (l_logLevel <= wip_constants.full_logging) then
408: wip_logger.log(p_msg => 'Inserting item overheads for op seq/event: ' ||
409: l_chargeTbl(l_count).operation_seq_num,
410: x_returnStatus => l_returnStatus);
411: end if;

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

498: and bd.department_id = bos.department_id
499: and wfs.organization_id = mmtt.organization_id
500: and wfs.wip_entity_id = mmtt.transaction_source_id;
501:
502: if (l_logLevel <= wip_constants.full_logging) then
503: wip_logger.log(p_msg => 'Inserting lot overheads for op seq/event: ' ||
504: l_chargeTbl(l_count).operation_seq_num,
505: x_returnStatus => l_returnStatus);
506: end if;

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

609:
610: -- now charge the phantom routing is applicable
611: chargePhantomResource(p_txnTempID, l_orgID, l_effDate, true, x_returnStatus);
612:
613: if (l_logLevel <= wip_constants.trace_logging) then
614: wip_logger.exitPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
615: p_procReturnStatus => x_returnStatus,
616: p_msg => 'Exit resource charge either successfully or failed in charging phantom!',
617: x_returnStatus => l_returnStatus); --discard logging return status

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

618: end if;
619: exception
620: when others then
621: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
622: if (l_logLevel <= wip_constants.trace_logging) then
623: wip_logger.exitPoint(p_procName => 'wip_flowResCharge.chargeResourceAndOverhead',
624: p_procReturnStatus => x_returnStatus,
625: p_msg => 'unexpected error: ' || SQLERRM,
626: x_returnStatus => l_returnStatus);

Line 658: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,

654: where mmtt.completion_transaction_id =
655: (select mmtt2.completion_transaction_id
656: from mtl_material_transactions_temp mmtt2
657: where mmtt2.transaction_temp_id = p_txnTempID)
658: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
659: WIP_CONSTANTS.RETCOMP_ACTION,
660: WIP_CONSTANTS.ISSNEGC_ACTION,
661: WIP_CONSTANTS.RETNEGC_ACTION)
662: and mmtt.operation_seq_num < 0

Line 659: WIP_CONSTANTS.RETCOMP_ACTION,

655: (select mmtt2.completion_transaction_id
656: from mtl_material_transactions_temp mmtt2
657: where mmtt2.transaction_temp_id = p_txnTempID)
658: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
659: WIP_CONSTANTS.RETCOMP_ACTION,
660: WIP_CONSTANTS.ISSNEGC_ACTION,
661: WIP_CONSTANTS.RETNEGC_ACTION)
662: and mmtt.operation_seq_num < 0
663: and mmtt.process_flag = 'Y'

Line 660: WIP_CONSTANTS.ISSNEGC_ACTION,

656: from mtl_material_transactions_temp mmtt2
657: where mmtt2.transaction_temp_id = p_txnTempID)
658: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
659: WIP_CONSTANTS.RETCOMP_ACTION,
660: WIP_CONSTANTS.ISSNEGC_ACTION,
661: WIP_CONSTANTS.RETNEGC_ACTION)
662: and mmtt.operation_seq_num < 0
663: and mmtt.process_flag = 'Y'
664: and mmtt.transaction_source_type_id = 5

Line 661: WIP_CONSTANTS.RETNEGC_ACTION)

657: where mmtt2.transaction_temp_id = p_txnTempID)
658: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
659: WIP_CONSTANTS.RETCOMP_ACTION,
660: WIP_CONSTANTS.ISSNEGC_ACTION,
661: WIP_CONSTANTS.RETNEGC_ACTION)
662: and mmtt.operation_seq_num < 0
663: and mmtt.process_flag = 'Y'
664: and mmtt.transaction_source_type_id = 5
665: and wfs.organization_id = mmtt.organization_id

Line 690: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,

686: where mmtt.completion_transaction_id =
687: (select mmtt2.completion_transaction_id
688: from mtl_material_transactions_temp mmtt2
689: where mmtt2.transaction_temp_id = p_txnTempID)
690: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
691: WIP_CONSTANTS.RETCOMP_ACTION,
692: WIP_CONSTANTS.ISSNEGC_ACTION,
693: WIP_CONSTANTS.RETNEGC_ACTION)
694: and mmtt.operation_seq_num = -1

Line 691: WIP_CONSTANTS.RETCOMP_ACTION,

687: (select mmtt2.completion_transaction_id
688: from mtl_material_transactions_temp mmtt2
689: where mmtt2.transaction_temp_id = p_txnTempID)
690: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
691: WIP_CONSTANTS.RETCOMP_ACTION,
692: WIP_CONSTANTS.ISSNEGC_ACTION,
693: WIP_CONSTANTS.RETNEGC_ACTION)
694: and mmtt.operation_seq_num = -1
695: and mmtt.transaction_source_type_id = 5

Line 692: WIP_CONSTANTS.ISSNEGC_ACTION,

688: from mtl_material_transactions_temp mmtt2
689: where mmtt2.transaction_temp_id = p_txnTempID)
690: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
691: WIP_CONSTANTS.RETCOMP_ACTION,
692: WIP_CONSTANTS.ISSNEGC_ACTION,
693: WIP_CONSTANTS.RETNEGC_ACTION)
694: and mmtt.operation_seq_num = -1
695: and mmtt.transaction_source_type_id = 5
696: and mmtt.process_flag = 'Y';

Line 693: WIP_CONSTANTS.RETNEGC_ACTION)

689: where mmtt2.transaction_temp_id = p_txnTempID)
690: and mmtt.transaction_action_id in (WIP_CONSTANTS.ISSCOMP_ACTION,
691: WIP_CONSTANTS.RETCOMP_ACTION,
692: WIP_CONSTANTS.ISSNEGC_ACTION,
693: WIP_CONSTANTS.RETNEGC_ACTION)
694: and mmtt.operation_seq_num = -1
695: and mmtt.transaction_source_type_id = 5
696: and mmtt.process_flag = 'Y';
697:

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

711: l_params(3).paramValue := 'True';
712: else
713: l_params(3).paramValue := 'False';
714: end if;
715: if (l_logLevel <= wip_constants.trace_logging) then
716: wip_logger.entryPoint(p_procName => 'wip_flowResCharge.chargePhantomResource',
717: p_params => l_params,
718: x_returnStatus => x_returnStatus);
719: if(x_returnStatus <> fnd_api.g_ret_sts_success) then

Line 725: if ( wip_globals.use_phantom_routings(p_orgID) = WIP_CONSTANTS.YES) then

721: end if;
722: end if;
723:
724: -- now charge the phantom routing is applicable
725: if ( wip_globals.use_phantom_routings(p_orgID) = WIP_CONSTANTS.YES) then
726: if ( p_hasRouting ) then
727: for phantoms_rec in phantoms_c1 loop
728: if (l_logLevel <= wip_constants.full_logging) then
729: wip_logger.log(p_msg => 'Charging phantom: ' ||

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

724: -- now charge the phantom routing is applicable
725: if ( wip_globals.use_phantom_routings(p_orgID) = WIP_CONSTANTS.YES) then
726: if ( p_hasRouting ) then
727: for phantoms_rec in phantoms_c1 loop
728: if (l_logLevel <= wip_constants.full_logging) then
729: wip_logger.log(p_msg => 'Charging phantom: ' ||
730: phantoms_rec.phantom_item_id || ' at op: ' ||
731: phantoms_rec.operation_seq_num || ' tmp id: ' ||
732: phantoms_rec.transaction_temp_id,

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

745: end if;
746: end loop;
747: else -- it doens't have a routing, use the second cursor
748: for phantoms_rec in phantoms_c2 loop
749: if (l_logLevel <= wip_constants.full_logging) then
750: wip_logger.log(p_msg => 'Charging phantom: ' ||
751: phantoms_rec.phantom_item_id || ' at op: ' ||
752: phantoms_rec.operation_seq_num || ' tmp id: ' ||
753: phantoms_rec.transaction_temp_id,

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

771:
772: exception
773: when others then
774: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
775: if (l_logLevel <= wip_constants.trace_logging) then
776: wip_logger.exitPoint(p_procName => 'wip_flowResCharge.chargePhantomResource',
777: p_procReturnStatus => x_returnStatus,
778: p_msg => 'unexpected error: ' || SQLERRM,
779: x_returnStatus => l_returnStatus);