838: end if;
839:
840: for l_inv_row in c_invalid_rows loop
841: l_error_exists := true;
842: fnd_message.set_name('WIP', l_err_msg);
843: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
844: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
845: p_text => substr(fnd_message.get,1,500),
846: p_error_type => wip_jdi_utils.msg_error);
839:
840: for l_inv_row in c_invalid_rows loop
841: l_error_exists := true;
842: fnd_message.set_name('WIP', l_err_msg);
843: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
844: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
845: p_text => substr(fnd_message.get,1,500),
846: p_error_type => wip_jdi_utils.msg_error);
847: end loop;
841: l_error_exists := true;
842: fnd_message.set_name('WIP', l_err_msg);
843: fnd_message.set_token('INTERFACE', to_char(l_inv_row.interface_id));
844: wip_interface_err_Utils.add_error(p_interface_id => l_inv_row.interface_id,
845: p_text => substr(fnd_message.get,1,500),
846: p_error_type => wip_jdi_utils.msg_error);
847: end loop;
848: if(l_error_exists) then
849: update wip_job_dtls_interface wjdi
878: END IF;
879:
880: exception
881: when no_data_found then --could not find the ML row
882: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
883: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
884: x_err_code := SQLCODE;
885: x_err_msg := substr(fnd_message.get, 1, 500);
886: x_return_status := FND_API.G_RET_STS_ERROR;
879:
880: exception
881: when no_data_found then --could not find the ML row
882: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
883: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
884: x_err_code := SQLCODE;
885: x_err_msg := substr(fnd_message.get, 1, 500);
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: when others then
881: when no_data_found then --could not find the ML row
882: fnd_message.set_name('WIP', 'WIP_JOB_DOES_NOT_EXIST');
883: fnd_message.set_token('INTERFACE', to_char(wip_jsi_utils.current_interface_id));
884: x_err_code := SQLCODE;
885: x_err_msg := substr(fnd_message.get, 1, 500);
886: x_return_status := FND_API.G_RET_STS_ERROR;
887: when others then
888: x_err_code := SQLCODE;
889: x_err_msg := 'WIPJDLDB default wip_entity_id '||SQLERRM;