[Home] [Help]
23: l_plan_maint varchar2(1);
24: l_status VARCHAR2(1);
25: l_msg_data VARCHAR2(2000);
26: l_move_order_required VARCHAR2(1);
27: l_allocTbl wip_picking_pub.allocate_tbl_t;
28: l_task_id NUMBER;
29: l_project_id NUMBER;
30:
31: BEGIN
641: ) ;
642: end if ;
643:
644: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB) and
645: wip_picking_pub.is_job_pick_released(x_entity_id, x_rep_sched_id, x_org_id) and
646: x_old_start_quantity <> x_new_start_quantity) then
647: FND_MESSAGE.set_name('WIP','WIP_QTY_REQ_CHANGE_WARNING');
648: wip_jsi_utils.record_current_error(TRUE);
649:
646: x_old_start_quantity <> x_new_start_quantity) then
647: FND_MESSAGE.set_name('WIP','WIP_QTY_REQ_CHANGE_WARNING');
648: wip_jsi_utils.record_current_error(TRUE);
649:
650: wip_picking_pub.Update_Job_BackOrdQty (p_wip_entity_id => x_entity_id,
651: p_repetitive_schedule_id => x_rep_sched_id,
652: p_new_job_qty => x_new_start_quantity,
653: x_return_status => l_status,
654: x_msg_data => l_msg_data);
655:
656: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
657: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
658: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
659: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
660: wip_jsi_utils.record_current_error;
661: end if;
662: end if;
663:
670: x_msg_data => l_msg_data);
671: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
672: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
673: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
674: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
675: wip_jsi_utils.record_current_error;
676: end if;
677: end if;
678: