[Home] [Help]
6276: fnd_user fu,
6277: mtl_system_items msi,
6278: mtl_parameters mp,
6279: hr_organization_information hoi,
6280: wip_entities we,
6281: wip_repetitive_schedules wrs,
6282: wip_operation_resources wor,
6283: wip_operations wo1,
6284: wip_operations wo2,
6720: mtl_parameters mp,
6721: hr_organization_information hoi,
6722: wip_operation_resources wor,
6723: wip_repetitive_schedules wrs,
6724: wip_entities we,
6725: wip_operations wo1,
6726: wip_operations wo2,
6727: wip_move_txn_allocations wma,
6728: wip_move_txn_interface wmti,
9931: /*Bug 13992087: This cursor returns jobs submitted for EZ_Completion (Move & Complete)*/
9932: /*Bug 16483751: Added the check so that EZ completions for repetetive schedules do not error out */
9933: CURSOR c_jobs IS
9934: select wmti.wip_entity_id, wmti.transaction_id txn_id, wmti.transaction_type txn_type
9935: from wip_move_txn_interface wmti,wip_entities we
9936: where wmti.group_id = p_group_id
9937: AND wmti.process_status = WIP_CONSTANTS.RUNNING
9938: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
9939: AND we.wip_entity_id=wmti.wip_entity_id
10116: AND process_status = WIP_CONSTANTS.RUNNING
10117: AND transaction_id = l_jobs.txn_id;
10118: wip_logger.log('Updated WMTI record to error', l_returnStatus);
10119:
10120: select WIP_ENTITY_NAME into l_job_name from wip_entities where WIP_ENTITY_ID = l_jobs.wip_entity_id;
10121: fnd_message.set_name('WIP', 'WIP_WORK_ORDER_LOCKED');
10122: fnd_message.set_token('JOBNAME', l_job_name);
10123: l_errMsg := fnd_message.get;
10124: wip_logger.log(l_errMsg, l_returnStatus);