642:
643: if (x_load_type in (WIP_CONSTANTS.RESCHED_JOB, WIP_CONSTANTS.RESCHED_LOT_JOB) and
644: wip_picking_pub.is_job_pick_released(x_entity_id, x_rep_sched_id, x_org_id) and
645: x_old_start_quantity <> x_new_start_quantity) then
646: FND_MESSAGE.set_name('WIP','WIP_QTY_REQ_CHANGE_WARNING');
647: wip_jsi_utils.record_current_error(TRUE);
648:
649: wip_picking_pub.Update_Job_BackOrdQty (p_wip_entity_id => x_entity_id,
650: p_repetitive_schedule_id => x_rep_sched_id,
652: x_return_status => l_status,
653: x_msg_data => l_msg_data);
654:
655: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
656: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
657: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
658: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
659: wip_jsi_utils.record_current_error;
660: end if;
653: x_msg_data => l_msg_data);
654:
655: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
656: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
657: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
658: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
659: wip_jsi_utils.record_current_error;
660: end if;
661: end if;
667: p_wip_entity_type => wip_constants.discrete,
668: x_return_status => l_status,
669: x_msg_data => l_msg_data);
670: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
671: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
672: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
673: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
674: wip_jsi_utils.record_current_error;
675: end if;
668: x_return_status => l_status,
669: x_msg_data => l_msg_data);
670: if(l_status <> FND_API.G_RET_STS_SUCCESS) then
671: fnd_message.set_name('WIP', 'WIP_UNEXPECTED_ERROR');
672: fnd_message.set_token('ERROR_TEXT', 'WIP_JSI_Processor.update_parent_table calling => ' ||
673: 'wip_picking_pub.Update_Job_BackOrdQty: ' || SQLERRM);
674: wip_jsi_utils.record_current_error;
675: end if;
676: end if;
926: P_Success_Flag := 1;
927: EXCEPTION
928: WHEN OTHERS THEN
929: P_Success_Flag := 0;
930: P_Error_Msg := SUBSTR(FND_MESSAGE.get,1,500);
931: END ML_Release;
932:
933: PROCEDURE ML_Status_Change(P_Wip_Entity_Id IN NUMBER,
934: P_Organization_Id IN NUMBER,
958:
959: EXCEPTION
960: WHEN OTHERS THEN
961: P_Success_Flag := 0;
962: P_Error_Msg := SUBSTR(FND_MESSAGE.get,1,500);
963: END;
964:
965:
966: END WIP_JSI_Processor ;